| id |
bigint(20)
|
|
|
|
| integration_id |
bigint(20)
|
|
|
|
| external_message_id |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| email_uid |
bigint(20)
|
|
|
|
| email_date |
datetime
|
|
|
|
| source_name |
varchar(191)
|
utf8mb4_unicode_ci
|
|
|
| customer_name |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| customer_email |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| customer_phone |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| vehicle_title |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| vehicle_color |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| vehicle_year |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| vehicle_plate |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| vehicle_price |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| listing_url |
text
|
utf8mb4_unicode_ci
|
|
|
| message_text |
text
|
utf8mb4_unicode_ci
|
|
|
| raw_subject |
text
|
utf8mb4_unicode_ci
|
|
|
| raw_from_email |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| raw_text |
longtext
|
utf8mb4_unicode_ci
|
|
|
| raw_html |
longtext
|
utf8mb4_unicode_ci
|
|
|
| parsed_payload_json |
longtext
|
utf8mb4_bin
|
|
|
| crm_contact_id |
bigint(20)
|
|
|
|
| crm_chat_id |
bigint(20)
|
|
|
|
| import_status |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| created_at |
timestamp
|
|
|
|
| updated_at |
timestamp
|
|
|
|
| company_id |
int(11)
|
|
|
|
| user_id |
int(11)
|
|
|
|
