题解 | 删除记录（三）

DROP TABLE IF EXISTS nowcoder_exam_record;
CREATE TABLE IF NOT EXISTS nowcoder_exam_record(
      id int(11) PRIMARY KEY AUTO_INCREMENT COMMENT"自增ID",
      uid int(11) NOT NULL COMMENT"用户ID",
      exam_id int(11) NOT NULL COMMENT"试卷ID",
      start_time datetime NOT NULL COMMENT"开始时间",
      submit_time datetime COMMENT"提交时间",
      score tinyint(4) COMMENT"得分"
)character set utf8 collate utf8_general_ci