dye-schema.sql 6.5 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131
  1. /*
  2. Navicat Premium Data Transfer
  3. Source Server : 192.168.100.94
  4. Source Server Type : MySQL
  5. Source Server Version : 50723
  6. Source Host : 192.168.100.94:9934
  7. Source Schema : calendar-center
  8. Target Server Type : MySQL
  9. Target Server Version : 50723
  10. File Encoding : 65001
  11. Date: 27/10/2021 11:47:10
  12. */
  13. SET NAMES utf8mb4;
  14. SET FOREIGN_KEY_CHECKS = 0;
  15. -- ----------------------------
  16. -- Table structure for dye_rule_custom
  17. -- ----------------------------
  18. DROP TABLE IF EXISTS `dye_rule_custom`;
  19. CREATE TABLE `dye_rule_custom` (
  20. `id` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  21. `basic_id` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '基础表ID',
  22. `upper_limit` int(50) NOT NULL COMMENT '上限',
  23. `upper_symbol` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '上限符号',
  24. `lower_limit` int(50) NOT NULL COMMENT '下限',
  25. `lower_symbol` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '下限符号',
  26. `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '名称',
  27. `color_value` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '色值',
  28. `create_time` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建时间',
  29. `update_time` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '修改时间',
  30. `update_user_id` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '最后修改人ID',
  31. `is_delete` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '0' COMMENT '是否删除(0:否 1:是)',
  32. `order_num` int(10) NULL DEFAULT NULL COMMENT '排序',
  33. `num_symbol` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '数值单位符号',
  34. PRIMARY KEY (`id`) USING BTREE,
  35. UNIQUE INDEX `id`(`id`) USING BTREE COMMENT '主键索引',
  36. INDEX `basic_id`(`basic_id`) USING BTREE COMMENT '外键索引',
  37. CONSTRAINT `fk_custom` FOREIGN KEY (`basic_id`) REFERENCES `dye_basic` (`id`) ON DELETE RESTRICT ON UPDATE NO ACTION
  38. ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '染色规则自定义表' ROW_FORMAT = Dynamic;
  39. SET FOREIGN_KEY_CHECKS = 1;
  40. /*
  41. Navicat Premium Data Transfer
  42. Source Server : 192.168.100.94
  43. Source Server Type : MySQL
  44. Source Server Version : 50723
  45. Source Host : 192.168.100.94:9934
  46. Source Schema : calendar-center
  47. Target Server Type : MySQL
  48. Target Server Version : 50723
  49. File Encoding : 65001
  50. Date: 27/10/2021 11:47:17
  51. */
  52. SET NAMES utf8mb4;
  53. SET FOREIGN_KEY_CHECKS = 0;
  54. -- ----------------------------
  55. -- Table structure for dye_rule_default
  56. -- ----------------------------
  57. DROP TABLE IF EXISTS `dye_rule_default`;
  58. CREATE TABLE `dye_rule_default` (
  59. `id` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '主键',
  60. `basic_id` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '染色基础表ID',
  61. `upper_limit` int(50) NOT NULL COMMENT '上限',
  62. `upper_symbol` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '上限符号',
  63. `lower_limit` int(50) NOT NULL COMMENT '下限',
  64. `lower_symbol` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '下限符号',
  65. `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '名称',
  66. `color_value` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '色值',
  67. `create_time` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建时间',
  68. `update_time` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '更新时间',
  69. `update_user_id` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '最后更新人ID',
  70. `is_delete` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '0' COMMENT '是否删除(0:否 1:是)',
  71. `order_num` int(10) NULL DEFAULT NULL COMMENT '排序',
  72. `num_symbol` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '数值单位符号',
  73. PRIMARY KEY (`id`) USING BTREE,
  74. UNIQUE INDEX `id`(`id`) USING BTREE COMMENT '主键索引',
  75. INDEX `basic_id`(`basic_id`) USING BTREE COMMENT '外键索引',
  76. CONSTRAINT `fk_default` FOREIGN KEY (`basic_id`) REFERENCES `dye_basic` (`id`) ON DELETE RESTRICT ON UPDATE NO ACTION
  77. ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '默认染色规则' ROW_FORMAT = Dynamic;
  78. SET FOREIGN_KEY_CHECKS = 1;
  79. /*
  80. Navicat Premium Data Transfer
  81. Source Server : 192.168.100.94
  82. Source Server Type : MySQL
  83. Source Server Version : 50723
  84. Source Host : 192.168.100.94:9934
  85. Source Schema : calendar-center
  86. Target Server Type : MySQL
  87. Target Server Version : 50723
  88. File Encoding : 65001
  89. Date: 27/10/2021 11:47:02
  90. */
  91. SET NAMES utf8mb4;
  92. SET FOREIGN_KEY_CHECKS = 0;
  93. -- ----------------------------
  94. -- Table structure for dye_basic
  95. -- ----------------------------
  96. DROP TABLE IF EXISTS `dye_basic`;
  97. CREATE TABLE `dye_basic` (
  98. `id` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  99. `group_code` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '集团编码',
  100. `project_id` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '项目ID',
  101. `type_code` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '染色类型编码,对应rwd_def_funcid的type字段',
  102. `type_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '染色类型名称',
  103. `season_code` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '季节编码',
  104. `season_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '季节名称',
  105. `create_time` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建时间',
  106. `update_time` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '更新时间',
  107. `update_user_id` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '最后创建人ID',
  108. `is_delete` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '0' COMMENT '是否删除(0:否 1:是)',
  109. PRIMARY KEY (`id`) USING BTREE
  110. ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '染色基础表' ROW_FORMAT = Dynamic;
  111. SET FOREIGN_KEY_CHECKS = 1;