CREATE TABLE `notice` ( `id` VARCHAR(36) NOT NULL, `aid` VARCHAR(36) NULL, `notice_type` VARCHAR(16) NULL COMMENT '通知类型', `content` VARCHAR(36) NULL COMMENT '通知内容', `create_time` DATETIME NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `readed` INT(1) NULL, PRIMARY KEY (`id`)) ENGINE = InnoDB COMMENT = '流转状态通知表';