Database Debug

Total Jobs in DB: 25

Array
(
    [0] => Array
        (
            [id] => 1
            [title] => Senior Product Designer
            [department_id] => 20
            [description] => Leading design initiatives across our mobile and desktop applications.
            [requirements] => - 5+ years of experience\n- Proficiency in Figma
            [employment_type] => Full-time
            [location] => New York, NY (Remote)
            [salary_range] => $140k - $180k
            [application_deadline] => 
            [status] => published
            [created_by] => 
            [created_at] => 2025-12-21 18:17:17
            [updated_at] => 2026-01-01 13:17:17
            [experience_level] => Senior Level
            [min_salary] => 140000.00
            [max_salary] => 180000.00
        )

    [1] => Array
        (
            [id] => 2
            [title] => Backend Engineer
            [department_id] => 16
            [description] => Building high-scale distributed systems.
            [requirements] => - Strong Go or Java experience
            [employment_type] => Full-time
            [location] => San Francisco, CA
            [salary_range] => $160k - $220k
            [application_deadline] => 
            [status] => published
            [created_by] => 
            [created_at] => 2025-12-12 18:17:17
            [updated_at] => 2026-01-01 13:17:17
            [experience_level] => Senior Level
            [min_salary] => 160000.00
            [max_salary] => 220000.00
        )

    [2] => Array
        (
            [id] => 3
            [title] => HR Manager
            [department_id] => 18
            [description] => Manage employee relations and talent acquisition.
            [requirements] => - 3+ years in HR
            [employment_type] => Contract
            [location] => London, UK
            [salary_range] => £60k - £80k
            [application_deadline] => 
            [status] => published
            [created_by] => 
            [created_at] => 2025-12-20 18:17:17
            [updated_at] => 2026-01-01 13:17:17
            [experience_level] => Mid Level
            [min_salary] => 60000.00
            [max_salary] => 80000.00
        )

)

Schema Columns

Array
(
    [0] => Array
        (
            [Field] => id
            [Type] => int(11)
            [Null] => NO
            [Key] => PRI
            [Default] => 
            [Extra] => auto_increment
        )

    [1] => Array
        (
            [Field] => title
            [Type] => varchar(150)
            [Null] => NO
            [Key] => 
            [Default] => 
            [Extra] => 
        )

    [2] => Array
        (
            [Field] => department_id
            [Type] => int(11)
            [Null] => YES
            [Key] => MUL
            [Default] => 
            [Extra] => 
        )

    [3] => Array
        (
            [Field] => description
            [Type] => text
            [Null] => NO
            [Key] => 
            [Default] => 
            [Extra] => 
        )

    [4] => Array
        (
            [Field] => requirements
            [Type] => text
            [Null] => YES
            [Key] => 
            [Default] => 
            [Extra] => 
        )

    [5] => Array
        (
            [Field] => employment_type
            [Type] => enum('Full-time','Part-time','Contract','Internship')
            [Null] => YES
            [Key] => 
            [Default] => Full-time
            [Extra] => 
        )

    [6] => Array
        (
            [Field] => location
            [Type] => varchar(100)
            [Null] => YES
            [Key] => 
            [Default] => OOUTH, Sagamu
            [Extra] => 
        )

    [7] => Array
        (
            [Field] => salary_range
            [Type] => varchar(100)
            [Null] => YES
            [Key] => 
            [Default] => 
            [Extra] => 
        )

    [8] => Array
        (
            [Field] => application_deadline
            [Type] => date
            [Null] => YES
            [Key] => 
            [Default] => 
            [Extra] => 
        )

    [9] => Array
        (
            [Field] => status
            [Type] => enum('draft','published','closed')
            [Null] => YES
            [Key] => 
            [Default] => draft
            [Extra] => 
        )

    [10] => Array
        (
            [Field] => created_by
            [Type] => int(11)
            [Null] => YES
            [Key] => MUL
            [Default] => 
            [Extra] => 
        )

    [11] => Array
        (
            [Field] => created_at
            [Type] => timestamp
            [Null] => YES
            [Key] => 
            [Default] => current_timestamp()
            [Extra] => 
        )

    [12] => Array
        (
            [Field] => updated_at
            [Type] => timestamp
            [Null] => YES
            [Key] => 
            [Default] => current_timestamp()
            [Extra] => on update current_timestamp()
        )

    [13] => Array
        (
            [Field] => experience_level
            [Type] => enum('Entry Level','Mid Level','Senior Level','Director')
            [Null] => YES
            [Key] => 
            [Default] => Mid Level
            [Extra] => 
        )

    [14] => Array
        (
            [Field] => min_salary
            [Type] => decimal(10,2)
            [Null] => YES
            [Key] => 
            [Default] => 
            [Extra] => 
        )

    [15] => Array
        (
            [Field] => max_salary
            [Type] => decimal(10,2)
            [Null] => YES
            [Key] => 
            [Default] => 
            [Extra] => 
        )

)