| 123456789101112 |
- CREATE TABLE `lecture` (
- `id` VARCHAR(36) NOT NULL,
- `uid` VARCHAR(36) NOT NULL COMMENT '开展讲座人ID',
- `lecture_time` TIMESTAMP NOT NULL COMMENT '讲座开展时间',
- `create_time` TIMESTAMP NULL COMMENT '记录创建时间',
- `last_update_time` TIMESTAMP NULL COMMENT '记录最后更新时间',
- `name` VARCHAR(45) NOT NULL COMMENT '名称',
- `summary` VARCHAR(128) NULL COMMENT '简介',
- `deleted_sign` INT(1) NOT NULL DEFAULT 0 COMMENT '删除标记',
- PRIMARY KEY (`id`))
- ENGINE = InnoDB DEFAULT CHARSET=utf8mb4
- COMMENT = '科技讲堂';
|