10 lines
474 B
SQL
10 lines
474 B
SQL
CREATE TABLE `health`.`ufutx_s2_conversation` (
|
|
`id` BIGINT NOT NULL AUTO_INCREMENT,
|
|
`customer_id` BIGINT NOT NULL COMMENT '客户id',
|
|
`session_id` VARCHAR(20) NOT NULL COMMENT 'session_id',
|
|
`role` ENUM("user", "assistant") NOT NULL COMMENT "角色",
|
|
`message` TEXT NOT NULL COMMENT "内容",
|
|
`created_at` TIMESTAMP NULL DEFAULT NULL,
|
|
`updated_at` TIMESTAMP NULL DEFAULT NULL,
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE = InnoDB COMMENT = 'crm聊天记录'; |