24 lines
865 B
SQL
24 lines
865 B
SQL
CREATE TABLE `ufutx_unify_feedback` (
|
|
`id` INT NOT NULL AUTO_INCREMENT,
|
|
`user_id` INT NOT NULL COMMENT "提交人id",
|
|
`source` ENUM(
|
|
"app_complaint",
|
|
"app_suggest",
|
|
"business_suggest",
|
|
"business_behavior",
|
|
"business_system",
|
|
"ai_groupchat",
|
|
"ai_scale",
|
|
"ai_band",
|
|
"admin_manual"
|
|
) NOT NULL COMMENT "来源",
|
|
`related_user_id` JSON COMMENT "关联用户id",
|
|
`im_chat_id` VARCHAR(20) COMMENT "关联云信群聊id",
|
|
`type` VARCHAR(100) COMMENT "类型",
|
|
`content` TEXT COMMENT "内容",
|
|
`img` JSON COMMENT "图片",
|
|
`status` TINYINT DEFAULT 0 COMMENT "状态:0-未处理,1-处理中,2-已处理",
|
|
`created_at` TIMESTAMP NULL DEFAULT NULL,
|
|
`updated_at` TIMESTAMP NULL DEFAULT NULL,
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE = InnoDB COMMENT = '统一反馈'; |