update.sql 3.4 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263
  1. -- 请按如下分类提交sql!!!
  2. -- Version V3.5.50.xxxx
  3. -- uat 2025-xx-xx
  4. -- prod 2025-xx-xx
  5. ------------------------------------
  6. -- 表结构
  7. ------------------------------------
  8. CREATE TABLE `zh_quality_inspection` (
  9. `id` int NOT NULL AUTO_INCREMENT,
  10. `tid` int(11) NOT NULL COMMENT '标段id',
  11. `code` varchar(255) NOT NULL COMMENT '编号',
  12. `status` tinyint(2) NOT NULL COMMENT '审批状态',
  13. `times` tinyint(2) NOT NULL DEFAULT 1 COMMENT '审批次数',
  14. `uid` int(11) NOT NULL COMMENT '创建人id',
  15. `check_item` varchar(1000) NULL DEFAULT '' COMMENT '检查项',
  16. `check_situation` varchar(1000) NULL DEFAULT '' COMMENT '检查情况',
  17. `action` varchar(1000) NULL DEFAULT '' COMMENT '处理要求及措施',
  18. `check_date` datetime NULL DEFAULT NULL COMMENT '检查日期',
  19. `inspector` varchar(255) NULL COMMENT '检查人',
  20. `rectification_item` varchar(1000) NULL DEFAULT '' COMMENT '整改内容',
  21. `rectification_date` datetime NULL DEFAULT NULL COMMENT '整改日期',
  22. `rectification_uid` int(11) NULL DEFAULT NULL COMMENT '整改人id',
  23. `create_time` datetime NOT NULL COMMENT '创建时间',
  24. PRIMARY KEY (`id`)
  25. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT = '质量巡检单表';
  26. CREATE TABLE `zh_quality_inspection_audit` (
  27. `id` int(11) NOT NULL AUTO_INCREMENT,
  28. `tid` int(11) NOT NULL COMMENT '标段id',
  29. `qiid` int(11) NOT NULL COMMENT '质量巡检id',
  30. `aid` int(11) NOT NULL COMMENT '审批人id',
  31. `order` int(11) NOT NULL COMMENT '审批顺序',
  32. `times` tinyint(2) NOT NULL COMMENT '审批次数',
  33. `status` tinyint(2) NOT NULL COMMENT '审批状态',
  34. `begin_time` datetime NULL DEFAULT NULL COMMENT '开始审批时间',
  35. `end_time` datetime NULL DEFAULT NULL COMMENT '结束审批时间',
  36. `opinion` varchar(1000) NULL COMMENT '审批意见',
  37. `is_rectification` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否是整改人',
  38. `is_old` TINYINT(1) NOT NULL DEFAULT '0' COMMENT '是否为旧流程(用于管理员修改流程时旧数据保留但不影响新流程)',
  39. `audit_type` tinyint(4) UNSIGNED NOT NULL DEFAULT 1 COMMENT '审批类型(1个人,2会签,3或签)',
  40. `audit_order` tinyint(4) UNSIGNED NOT NULL DEFAULT 0 COMMENT '审批顺序',
  41. PRIMARY KEY (`id`)
  42. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT = '质量巡检审批表';
  43. CREATE TABLE `zh_quality_inspection_attachment` (
  44. `id` int(11) NOT NULL AUTO_INCREMENT,
  45. `tid` int(11) NOT NULL COMMENT '标段id',
  46. `qiid` int(11) NOT NULL COMMENT '巡检id',
  47. `uid` int(11) NOT NULL COMMENT '上传者id',
  48. `filename` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT '文件名称',
  49. `fileext` varchar(5) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT '文件后缀',
  50. `filesize` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT '文件大小',
  51. `filepath` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT '文件存储路径',
  52. `upload_time` datetime NOT NULL COMMENT '上传时间',
  53. `extra_upload` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否为审核通过后再次上传的文件,0为否',
  54. PRIMARY KEY (`id`) USING BTREE,
  55. INDEX `idx_cid`(`qiid`) USING BTREE
  56. ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_unicode_ci COMMENT = '质量巡检附件表' ROW_FORMAT = Dynamic;
  57. ------------------------------------
  58. -- 表数据
  59. ------------------------------------