9wm_quiz.sql 1.3 KB

123456789101112131415161718192021222324252627282930313233
  1. USE `cnbg`;
  2. SET NAMES utf8mb4;
  3. SET FOREIGN_KEY_CHECKS = 0;
  4. -- ----------------------------
  5. -- Table structure for wm_quiz
  6. -- ----------------------------
  7. DROP TABLE IF EXISTS `wm_quiz`;
  8. CREATE TABLE `wm_quiz`
  9. (
  10. `quiz_id` INT AUTO_INCREMENT COMMENT 'Id',
  11. `serial_num` VARCHAR(64) NOT NULL COMMENT '序列号',
  12. `quiz_title` VARCHAR(64) NOT NULL COMMENT '标题',
  13. `introduction` VARCHAR(255) NULL COMMENT '简介',
  14. `source_type` VARCHAR(8) NOT NULL COMMENT '问卷来源类型',
  15. `quiz_state` VARCHAR(8) NOT NULL COMMENT '问卷状态',
  16. `ent_id` INT UNSIGNED NOT NULL COMMENT '企业信息',
  17. `quiz_expand` JSON COMMENT '试卷统计',
  18. `create_by` VARCHAR(64) NOT NULL COMMENT '创建人',
  19. `update_by` VARCHAR(64) NOT NULL COMMENT '修改人',
  20. `create_time` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  21. `update_time` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  22. PRIMARY KEY `pk_id` (`quiz_id`) USING BTREE,
  23. UNIQUE KEY `uk_sn` (`serial_num`) USING BTREE,
  24. INDEX `idx_st` (`source_type`) USING BTREE,
  25. INDEX `idx_state` (`quiz_state`) USING BTREE,
  26. INDEX `idx_eid` (`ent_id`) USING BTREE
  27. ) ENGINE = InnoDB
  28. COMMENT ='试卷表';
  29. SET FOREIGN_KEY_CHECKS = 1;