10wm_quiz_item.sql 1.1 KB

1234567891011121314151617181920212223242526272829
  1. USE `cnbg`;
  2. SET NAMES utf8mb4;
  3. SET FOREIGN_KEY_CHECKS = 0;
  4. -- ----------------------------
  5. -- Table structure for wm_quiz_item
  6. -- ----------------------------
  7. DROP TABLE IF EXISTS `wm_quiz_item`;
  8. CREATE TABLE `wm_quiz_item`
  9. (
  10. `item_id` INT AUTO_INCREMENT COMMENT 'Id',
  11. `quiz_sn` VARCHAR(64) NOT NULL COMMENT '试卷序号',
  12. `label` VARCHAR(64) NOT NULL COMMENT '标题',
  13. `quiz_options` JSON COMMENT '选项',
  14. `answer` VARCHAR(255) NULL COMMENT '答案',
  15. `widget` BIGINT NOT NULL COMMENT '排序权重',
  16. `mark` INT NOT NULL DEFAULT 0 COMMENT '分数',
  17. `create_by` VARCHAR(64) NOT NULL COMMENT '创建人',
  18. `update_by` VARCHAR(64) NOT NULL COMMENT '修改人',
  19. `create_time` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  20. `update_time` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  21. PRIMARY KEY `pk_id` (`item_id`) USING BTREE,
  22. INDEX `idx_quiz_sn` (`quiz_sn`) USING BTREE
  23. ) ENGINE = InnoDB
  24. COMMENT ='试卷项表';
  25. SET FOREIGN_KEY_CHECKS = 1;