conversation_sessions
表 · 10 字段
暂无表描述
字段信息
| 字段名 | 类型 | 必填 | 说明 | 关联关系 |
|---|---|---|---|---|
| id主键 | int(11) | 否 | - | - |
| user_id唯一 | varchar(100) | 否 | - | - |
| last_user_message_time索引 | datetime | 是 | - | - |
| last_bot_message_time | datetime | 是 | - | - |
| follow_up_count索引 | int(11) | 是 | - | - |
| last_follow_up_time | datetime | 是 | - | - |
| conversation_stage | varchar(50) | 是 | - | - |
| context_summary | text | 是 | - | - |
| created_at | datetime | 是 | - | - |
| updated_at | datetime | 是 | - | - |
索引信息
idx_follow_up
普通索引: follow_up_count, last_user_message_time
idx_last_user_message_time
普通索引: last_user_message_time
idx_user_id
普通索引: user_id
idx_user_id_unique
唯一索引: user_id
PRIMARY
唯一索引: id
相关表
v_current_performance_config
v_employee_with_dept
v_按天业绩统计_净实收计算
v_钉钉员工表
v_销售业绩
v_销售业绩_快照版
crm_member_orders
customer_pool_proxy
department_mapping
dingtalk_employee_raw
employee_roster
n8n_html_reports
notification
order_salesperson_snapshot
performance_verification
sales_amount_manual_input
star_subject
weike_phone_mapping
wm_order_discounts
wm_order_items
wm_order_rights
wm_orders