|
id
|
bigint(20)
|
|
|
|
|
integration_id
|
bigint(20)
|
|
|
|
|
chat_id
|
varchar(191)
|
|
|
|
|
message_id
|
varchar(191)
|
|
|
|
|
list_id
|
varchar(191)
|
|
|
|
|
sender_type
|
varchar(50)
|
|
|
|
|
origin
|
varchar(50)
|
|
|
|
|
customer_name
|
varchar(255)
|
|
|
|
|
customer_email
|
varchar(255)
|
|
|
|
|
customer_phone
|
varchar(50)
|
|
|
|
|
message_text
|
longtext
|
|
|
|
|
message_timestamp_source
|
datetime
|
|
|
|
|
payload_json
|
longtext
|
|
|
|
|
direction
|
varchar(20)
|
|
|
inbound
|
|
created_at
|
timestamp
|
|
|
current_timestamp()
|
|
updated_at
|
timestamp
|
|
|
current_timestamp()
|