update20220402.sql 6.8 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105
  1. ALTER TABLE `zh_change_apply`
  2. ADD `total_price` DECIMAL(30,8) NULL DEFAULT NULL COMMENT '金额' AFTER `content`,
  3. ADD `decimal` VARCHAR(1000) NULL DEFAULT NULL COMMENT '小数位数设置JSON' AFTER `total_price`;
  4. CREATE TABLE `zh_change_plan` (
  5. `id` int(11) NOT NULL AUTO_INCREMENT,
  6. `tid` int(11) NOT NULL COMMENT '标段id',
  7. `selected` tinyint(4) UNSIGNED NOT NULL DEFAULT 0 COMMENT '报表用,是否选择',
  8. `uid` int(11) NOT NULL COMMENT '发起人',
  9. `code` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT '变更方案编号',
  10. `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT '变更工程名称',
  11. `in_time` datetime NOT NULL COMMENT '发起时间',
  12. `status` tinyint(2) NOT NULL COMMENT '方案状态',
  13. `times` tinyint(2) NOT NULL COMMENT '审批次数',
  14. `apply_code` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '变更申请编号',
  15. `org_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '原设计图名称',
  16. `peg` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '桩号',
  17. `new_code` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '图号',
  18. `c_new_code` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '变更图号',
  19. `design_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '变更设计名称',
  20. `class` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '工程变更类别',
  21. `quality` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '工程变更性质',
  22. `reason` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT '变更原因',
  23. `content` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT '变更内容',
  24. `memo` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT '方案描述',
  25. `total_price` decimal(30, 8) NULL DEFAULT NULL COMMENT '金额',
  26. `decimal` varchar(1000) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '小数位数设置JSON',
  27. PRIMARY KEY (`id`) USING BTREE
  28. ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_unicode_ci COMMENT = '变更方案表' ROW_FORMAT = Dynamic;
  29. -- ----------------------------
  30. -- Table structure for zh_change_plan_attachment
  31. -- ----------------------------
  32. CREATE TABLE `zh_change_plan_attachment` (
  33. `id` int(11) NOT NULL AUTO_INCREMENT,
  34. `tid` int(11) NOT NULL COMMENT '标段id',
  35. `cpid` int(11) NOT NULL COMMENT '方案id',
  36. `uid` int(11) NOT NULL COMMENT '上传者id',
  37. `filename` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT '文件名称',
  38. `fileext` varchar(5) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT '文件后缀',
  39. `filesize` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT '文件大小',
  40. `filepath` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT '文件存储路径',
  41. `upload_time` datetime NOT NULL COMMENT '上传时间',
  42. `extra_upload` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否为审核通过后再次上传的文件,0为否',
  43. PRIMARY KEY (`id`) USING BTREE,
  44. INDEX `idx_cid`(`cpid`) USING BTREE
  45. ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_unicode_ci COMMENT = '变更立项附件表' ROW_FORMAT = Dynamic;
  46. -- ----------------------------
  47. -- Table structure for zh_change_plan_audit
  48. -- ----------------------------
  49. CREATE TABLE `zh_change_plan_audit` (
  50. `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  51. `tid` int(11) NOT NULL COMMENT '标段id',
  52. `cpid` int(11) NOT NULL COMMENT '方案id',
  53. `aid` int(11) NOT NULL COMMENT '审批人id',
  54. `order` int(11) NOT NULL COMMENT '审批顺序',
  55. `times` int(11) NOT NULL COMMENT '审批次数',
  56. `status` tinyint(1) NOT NULL COMMENT '审批状态',
  57. `begin_time` datetime NULL DEFAULT NULL COMMENT '开始审批时间',
  58. `end_time` datetime NULL DEFAULT NULL COMMENT '结束审批时间',
  59. `opinion` varchar(1000) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '审批意见',
  60. PRIMARY KEY (`id`) USING BTREE
  61. ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_unicode_ci COMMENT = '变更立项审批表' ROW_FORMAT = Dynamic;
  62. -- ----------------------------
  63. -- Table structure for zh_change_plan_list
  64. -- ----------------------------
  65. CREATE TABLE `zh_change_plan_list` (
  66. `id` int(11) NOT NULL AUTO_INCREMENT,
  67. `tid` int(11) NOT NULL COMMENT '标段id',
  68. `cpid` int(11) NOT NULL COMMENT '方案id',
  69. `code` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '清单编号',
  70. `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '清单名称',
  71. `unit` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '单位',
  72. `unit_price` decimal(30, 8) NULL DEFAULT NULL COMMENT '单价',
  73. `oamount` decimal(30, 8) NULL DEFAULT NULL COMMENT '原数量',
  74. `camount` decimal(30, 8) NULL DEFAULT NULL COMMENT '变更数量',
  75. `samount` decimal(30, 8) NULL DEFAULT NULL COMMENT '审批完成后变更数量',
  76. `audit_amount` varchar(1000) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '用户填的数目,json',
  77. `spamount` decimal(30, 8) NULL DEFAULT NULL COMMENT '审批流程中读取数量',
  78. PRIMARY KEY (`id`) USING BTREE
  79. ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_unicode_ci COMMENT = '变更方案清单表' ROW_FORMAT = Dynamic;
  80. ALTER TABLE `zh_material` ADD `period` VARCHAR(255) NULL DEFAULT NULL COMMENT '调差周期' AFTER `s_order`;
  81. ALTER TABLE `zh_tender`
  82. ADD `c_apply_list_rule` VARCHAR(255) NULL DEFAULT NULL COMMENT '变更申请统一原设计数量读取规则' AFTER `pos_file`,
  83. ADD `c_plan_list_rule` VARCHAR(255) NULL DEFAULT NULL COMMENT '变更方案统一原设计数量读取规则' AFTER `c_apply_list_rule`;
  84. ALTER TABLE `zh_change` ADD `plan_code` VARCHAR(255) NULL DEFAULT NULL COMMENT '变更方案编号' AFTER `name`;
  85. CREATE TABLE `zh_change_apply_list` (
  86. `id` int(11) NOT NULL AUTO_INCREMENT,
  87. `tid` int(11) NOT NULL COMMENT '标段id',
  88. `caid` int(11) NOT NULL COMMENT '申请id',
  89. `code` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '清单编号',
  90. `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '清单名称',
  91. `unit` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '单位',
  92. `unit_price` decimal(30, 8) NULL DEFAULT NULL COMMENT '单价',
  93. `oamount` decimal(30, 8) NULL DEFAULT NULL COMMENT '原数量',
  94. `camount` decimal(30, 8) NULL DEFAULT NULL COMMENT '变更数量',
  95. PRIMARY KEY (`id`) USING BTREE
  96. ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_unicode_ci COMMENT = '变更申请清单表' ROW_FORMAT = Dynamic;