update20200323.sql 4.4 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788
  1. -- ----------------------------
  2. -- 权限 新增合同支付修改权限
  3. -- ----------------------------
  4. INSERT INTO `calculation`.`zh_permission` (`id`, `name`, `controller`, `action`, `pid`, `icon_class`, `create_time`, `isshow`) VALUES ('66', '合同支付', 'project', 'dealpay', '38', '', NULL, '1');
  5. SET FOREIGN_KEY_CHECKS=0;
  6. -- ----------------------------
  7. -- Table structure for zh_stage_jgcl
  8. -- ----------------------------
  9. CREATE TABLE `zh_stage_jgcl` (
  10. `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  11. `uuid` varchar(50) CHARACTER SET ascii NOT NULL COMMENT '材料id(uuid)',
  12. `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  13. `unit` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '单位',
  14. `unit_price` decimal(24,8) DEFAULT NULL COMMENT '单价',
  15. `arrive_qty` decimal(24,8) DEFAULT NULL COMMENT '本期 - 到场 - 数量',
  16. `arrive_tp` decimal(24,8) DEFAULT NULL COMMENT '本期 - 到场 - 金额',
  17. `deduct_qty` decimal(24,8) DEFAULT NULL COMMENT '本期 - 扣回 - 数量',
  18. `deduct_tp` decimal(24,8) DEFAULT NULL COMMENT '本期 - 扣回 - 金额',
  19. `source` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '材料来源',
  20. `bills_code` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '单据号',
  21. `check_code` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '检验单编号',
  22. `memo` text CHARACTER SET utf8 COMMENT '备注',
  23. `add_uid` int(11) NOT NULL COMMENT '新增人id',
  24. `add_sid` int(11) NOT NULL COMMENT '新增期id',
  25. `sid` int(11) NOT NULL COMMENT '所属期id',
  26. `shistory` text COLLATE utf8_unicode_ci COMMENT '所属期-第几轮',
  27. `order` int(11) NOT NULL COMMENT '排序字段',
  28. `pre_used` tinyint(1) DEFAULT NULL COMMENT '是否计量过',
  29. PRIMARY KEY (`id`)
  30. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  31. -- ----------------------------
  32. -- Table structure for zh_stage_bonus
  33. -- ----------------------------
  34. CREATE TABLE `zh_stage_bonus` (
  35. `id` varchar(50) CHARACTER SET ascii COLLATE ascii_bin NOT NULL COMMENT '主键id(uuid)',
  36. `tid` int(11) NOT NULL COMMENT '标段id',
  37. `sid` int(11) NOT NULL COMMENT '期id',
  38. `sorder` tinyint(4) NOT NULL COMMENT '第几期',
  39. `uid` int(11) NOT NULL COMMENT '新增人',
  40. `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '名称',
  41. `tp` decimal(24,8) DEFAULT NULL COMMENT '金额',
  42. `code` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  43. `proof` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '依据材料证明',
  44. `create_time` datetime(4) DEFAULT NULL COMMENT '创建时间',
  45. `real_time` datetime(4) DEFAULT NULL COMMENT '实际时间-用户可修改',
  46. `memo` text CHARACTER SET utf8 COMMENT '备注',
  47. `shistory` text CHARACTER SET utf8 COMMENT '历史记录',
  48. `order` int(4) DEFAULT NULL COMMENT '排序字段',
  49. PRIMARY KEY (`id`)
  50. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  51. -- ----------------------------
  52. -- Table structure for zh_stage_other
  53. -- ----------------------------
  54. CREATE TABLE `zh_stage_other` (
  55. `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
  56. `uuid` varchar(50) CHARACTER SET ascii NOT NULL COMMENT 'uuid',
  57. `tid` int(11) NOT NULL COMMENT '标段id',
  58. `sid` int(11) NOT NULL COMMENT '所属期id',
  59. `sorder` tinyint(4) NOT NULL COMMENT '所属第几期',
  60. `add_sid` int(11) NOT NULL COMMENT '新增期',
  61. `add_uid` int(11) NOT NULL COMMENT '新增人',
  62. `add_time` datetime(4) NOT NULL COMMENT '新建时间',
  63. `name` varchar(255) CHARACTER SET utf8 NOT NULL COMMENT '名称',
  64. `total_price` decimal(24,8) DEFAULT NULL COMMENT '金额',
  65. `tp` decimal(24,8) DEFAULT NULL COMMENT '本期 - 金额',
  66. `real_time` datetime(4) DEFAULT NULL COMMENT '时间',
  67. `memo` text CHARACTER SET utf8 COMMENT '备注',
  68. `order` int(11) DEFAULT NULL COMMENT '排序',
  69. `shistory` text COLLATE utf8_unicode_ci COMMENT '本期记录',
  70. `pre_used` tinyint(1) DEFAULT NULL COMMENT '是否往期已用',
  71. PRIMARY KEY (`id`)
  72. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  73. -- ----------------------------
  74. -- Table structure for zh_rpt_custom_define
  75. -- ----------------------------
  76. CREATE TABLE `zh_rpt_custom_define` (
  77. `id` int(11) NOT NULL AUTO_INCREMENT,
  78. `tid` int(11) NOT NULL COMMENT '标段id',
  79. `sid` int(11) NOT NULL COMMENT '期id',
  80. `rid` int(11) NOT NULL COMMENT '报表id',
  81. `audit_select` text COLLATE utf8_unicode_ci COMMENT '用户定制信息',
  82. PRIMARY KEY (`id`)
  83. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;