migrate/1787110702_create_unify_feedback_log.up.sql
2026-08-19 13:30:05 +08:00

11 lines
524 B
SQL

CREATE TABLE `health`.`ufutx_unify_feedback_log` (
`id` INT NOT NULL AUTO_INCREMENT,
`feedback_id` INT NOT NULL COMMENT "反馈id",
`user_id` INT NOT NULL COMMENT "用户id",
`user_type` TINYINT NOT NULL COMMENT "用户类型,1:用户,2:后台",
`content` text DEFAULT NULL COMMENT '文本',
`image` JSON DEFAULT NULL COMMENT "图片",
`created_at` TIMESTAMP NULL DEFAULT NULL,
`updated_at` TIMESTAMP NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE = InnoDB COMMENT = '统一反馈记录';