|
id
|
int(11)
|
|
|
|
|
reference_code
|
varchar(30)
|
|
|
|
|
full_name
|
varchar(150)
|
|
|
|
|
phone
|
varchar(20)
|
|
|
|
|
email
|
varchar(150)
|
|
|
|
|
person_type
|
enum
|
-- |
|
other
|
|
person_id
|
varchar(50)
|
|
|
|
|
category
|
enum
|
-- |
|
شكوى
|
|
subject
|
varchar(200)
|
|
|
|
|
message
|
text
|
|
|
|
|
status
|
enum
|
-- |
|
جديد
|
|
admin_response
|
text
|
|
|
|
|
responded_by
|
int(11)
|
|
|
|
|
responded_at
|
datetime
|
|
|
|
|
created_at
|
datetime
|
|
|
current_timestamp()
|
|
ip_address
|
varchar(45)
|
|
|
|