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