|
id
|
bigint(20)
|
|
|
|
|
user_id
|
int(11)
|
|
|
|
|
visitor_key
|
varchar(96)
|
|
|
|
|
session_id
|
varchar(128)
|
|
|
|
|
customer_name
|
varchar(160)
|
|
|
|
|
customer_email
|
varchar(190)
|
|
|
|
|
customer_phone
|
varchar(60)
|
|
|
|
|
cart_json
|
longtext
|
|
|
|
|
items_count
|
int(11)
|
|
|
0
|
|
total_amount
|
decimal(10,2)
|
|
|
0.00
|
|
status
|
varchar(30)
|
|
|
active
|
|
sales_order_id
|
int(11)
|
|
|
|
|
notified_admin
|
tinyint(1)
|
|
|
0
|
|
created_at
|
timestamp
|
|
|
current_timestamp()
|
|
updated_at
|
timestamp
|
|
|
|
|
last_activity_at
|
timestamp
|
|
|
current_timestamp()
|