| 12345678910111213141516171819202122 |
- -- 龙虾用户画像表（长期记忆核心载体）
- CREATE TABLE IF NOT EXISTS lobster_user_profile (
- id BIGINT AUTO_INCREMENT PRIMARY KEY,
- company_id BIGINT NOT NULL,
- external_user_id VARCHAR(128) NOT NULL,
- nickname VARCHAR(64) DEFAULT NULL COMMENT '客户昵称',
- persona VARCHAR(256) DEFAULT NULL COMMENT 'AI生成的人物画像描述',
- current_state VARCHAR(64) DEFAULT NULL COMMENT '当前阶段(需求确认/方案推荐/犹豫跟进/已成交)',
- internal_tags VARCHAR(512) DEFAULT NULL COMMENT '内部标签(JSON数组)',
- total_purchase DECIMAL(12,2) DEFAULT 0 COMMENT '累计消费金额',
- last_active_time DATETIME DEFAULT NULL COMMENT '最后活跃时间',
- interaction_count INT DEFAULT 0 COMMENT '交互次数',
- variable_snapshot TEXT DEFAULT NULL COMMENT '关键变量快照(JSON)',
- lifecycle_stage VARCHAR(32) DEFAULT 'NEW' COMMENT '客户生命周期(NEW/ACTIVE/SLEEP/DORMANT/CHURN)',
- value_score INT DEFAULT 0 COMMENT '客户价值分(0-100)',
- deleted TINYINT DEFAULT 0,
- create_time DATETIME DEFAULT CURRENT_TIMESTAMP,
- update_time DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
- UNIQUE KEY uk_user (company_id, external_user_id),
- KEY idx_state (current_state),
- KEY idx_lifecycle (lifecycle_stage)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='龙虾用户画像表(长期记忆)';
|
