-- ---------------------------- -- 系统通知表 -- ---------------------------- CREATE TABLE `smart_assess`.`sys_notice` ( `id` bigint NOT NULL AUTO_INCREMENT, `title` varchar(50) NOT NULL COMMENT '通知标题', `content` mediumtext NULL COMMENT '通知内容', `status` tinyint(2) NULL DEFAULT 0 COMMENT '通知状态(0正常,1关闭 默认0)', `version` int NULL DEFAULT 0 COMMENT '乐观锁', `create_by` varchar(20) NULL COMMENT '创建人', `create_time` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `update_by` varchar(20) NULL COMMENT '更新人', `update_time` datetime NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', `remark` varchar(100) NULL COMMENT '备注', PRIMARY KEY (`id`) )ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '通知表' ROW_FORMAT = Dynamic;