11 lines
601 B
SQL
11 lines
601 B
SQL
CREATE TABLE `course_work` (
|
|
`id` BIGINT PRIMARY KEY AUTO_INCREMENT COMMENT '提交记录ID',
|
|
`course_id` INT NOT NULL COMMENT '课程ID',
|
|
`video_id` INT NOT NULL COMMENT '视频ID',
|
|
`user_id` INT NOT NULL COMMENT '用户ID',
|
|
`content` TEXT NOT NULL COMMENT '内容',
|
|
`image` JSON COMMENT "图片 数组形式",
|
|
`created_at` TIMESTAMP NUll DEFAULT NULL COMMENT '创建时间',
|
|
`updated_at` TIMESTAMP NUll DEFAULT NULL COMMENT '更新时间',
|
|
UNIQUE KEY `uk_video_user` (`video_id`, `user_id`)
|
|
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COMMENT = '作业提交表'; |