--- Table: users ---
Array
(
    [Field] => id
    [Type] => int(11)
    [Null] => NO
    [Key] => PRI
    [Default] => 
    [Extra] => auto_increment
)
Array
(
    [Field] => role_id
    [Type] => int(11)
    [Null] => NO
    [Key] => MUL
    [Default] => 
    [Extra] => 
)
Array
(
    [Field] => full_name
    [Type] => varchar(150)
    [Null] => NO
    [Key] => 
    [Default] => 
    [Extra] => 
)
Array
(
    [Field] => email
    [Type] => varchar(150)
    [Null] => NO
    [Key] => UNI
    [Default] => 
    [Extra] => 
)
Array
(
    [Field] => phone
    [Type] => varchar(50)
    [Null] => YES
    [Key] => 
    [Default] => 
    [Extra] => 
)
Array
(
    [Field] => country
    [Type] => varchar(100)
    [Null] => YES
    [Key] => 
    [Default] => 
    [Extra] => 
)
Array
(
    [Field] => password
    [Type] => varchar(255)
    [Null] => NO
    [Key] => 
    [Default] => 
    [Extra] => 
)
Array
(
    [Field] => profile_picture
    [Type] => varchar(255)
    [Null] => YES
    [Key] => 
    [Default] => 
    [Extra] => 
)
Array
(
    [Field] => status
    [Type] => enum('active','inactive','blocked')
    [Null] => YES
    [Key] => 
    [Default] => inactive
    [Extra] => 
)
Array
(
    [Field] => otp
    [Type] => varchar(10)
    [Null] => YES
    [Key] => 
    [Default] => 
    [Extra] => 
)
Array
(
    [Field] => otp_expires_at
    [Type] => datetime
    [Null] => YES
    [Key] => 
    [Default] => 
    [Extra] => 
)
Array
(
    [Field] => agent_id
    [Type] => int(11)
    [Null] => YES
    [Key] => MUL
    [Default] => 
    [Extra] => 
)
Array
(
    [Field] => created_at
    [Type] => timestamp
    [Null] => YES
    [Key] => 
    [Default] => current_timestamp()
    [Extra] => 
)
Array
(
    [Field] => updated_at
    [Type] => timestamp
    [Null] => YES
    [Key] => 
    [Default] => current_timestamp()
    [Extra] => on update current_timestamp()
)

--- Roles ---
Array
(
    [id] => 1
    [role_name] => super_admin
    [created_at] => 2025-10-17 16:01:19
    [updated_at] => 2025-10-17 16:01:19
)
Array
(
    [id] => 2
    [role_name] => user
    [created_at] => 2025-10-17 16:01:27
    [updated_at] => 2025-10-17 16:01:27
)
Array
(
    [id] => 3
    [role_name] => agent
    [created_at] => 2025-10-17 16:01:33
    [updated_at] => 2025-10-17 16:01:33
)