| id |
int(11)
|
|
|
|
| name |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| email |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| phone |
varchar(20)
|
utf8mb4_unicode_ci
|
|
|
| subject |
varchar(500)
|
utf8mb4_unicode_ci
|
|
|
| message |
text
|
utf8mb4_unicode_ci
|
|
|
| company |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| project_type |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| budget_range |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| status |
enum('new', 'in_progress', 'replied', 'closed')
|
utf8mb4_unicode_ci
|
|
|
| priority |
enum('low', 'medium', 'high', 'urgent')
|
utf8mb4_unicode_ci
|
|
|
| ip_address |
varchar(45)
|
utf8mb4_unicode_ci
|
|
|
| user_agent |
text
|
utf8mb4_unicode_ci
|
|
|
| source_page |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| admin_notes |
text
|
utf8mb4_unicode_ci
|
|
|
| replied_by |
int(11)
|
|
|
|
| replied_at |
datetime
|
|
|
|
| created_at |
timestamp
|
|
|
|
| updated_at |
timestamp
|
|
|
|