| id |
bigint(20)
|
|
|
|
| integration_id |
bigint(20)
|
|
|
|
| external_key |
varchar(191)
|
utf8mb4_unicode_ci
|
|
|
| external_id |
varchar(191)
|
utf8mb4_unicode_ci
|
|
|
| source |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| ad_id |
varchar(191)
|
utf8mb4_unicode_ci
|
|
|
| list_id |
varchar(191)
|
utf8mb4_unicode_ci
|
|
|
| link_ad |
text
|
utf8mb4_unicode_ci
|
|
|
| customer_name |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| customer_email |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| customer_phone |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| message_text |
longtext
|
utf8mb4_unicode_ci
|
|
|
| created_at_source |
datetime
|
|
|
|
| buyer_history |
longtext
|
utf8mb4_bin
|
|
|
| ads_info |
longtext
|
utf8mb4_bin
|
|
|
| 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)
|
|
|
|