11wm_question.sql 1.1 KB

1234567891011121314151617181920212223242526272829
  1. USE `cnbg`;
  2. SET NAMES utf8mb4;
  3. SET FOREIGN_KEY_CHECKS = 0;
  4. -- ----------------------------
  5. -- Table structure for wm_question
  6. -- ----------------------------
  7. DROP TABLE IF EXISTS `wm_question`;
  8. CREATE TABLE `wm_question`
  9. (
  10. `qst_id` INT AUTO_INCREMENT COMMENT 'Id',
  11. `serial_num` VARCHAR(64) NOT NULL COMMENT '序列号',
  12. `label` VARCHAR(64) NOT NULL COMMENT '标题',
  13. `options` JSON COMMENT '选项',
  14. `answer` VARCHAR(255) NULL COMMENT '答案',
  15. `ent_id` INT UNSIGNED NOT NULL COMMENT '企业信息',
  16. `create_by` VARCHAR(64) NOT NULL COMMENT '创建人',
  17. `update_by` VARCHAR(64) NOT NULL COMMENT '修改人',
  18. `create_time` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  19. `update_time` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  20. PRIMARY KEY `pk_id` (`qst_id`) USING BTREE,
  21. UNIQUE KEY `uk_sn` (`serial_num`) USING BTREE,
  22. INDEX `idx_eid` (`ent_id`) USING BTREE
  23. ) ENGINE = InnoDB
  24. COMMENT ='试题表';
  25. SET FOREIGN_KEY_CHECKS = 1;