/*
 Navicat Premium Data Transfer

 Source Server         : 192.168.7.248
 Source Server Type    : MySQL
 Source Server Version : 80030 (8.0.30)
 Source Host           : 192.168.7.248:3306
 Source Schema         : urule

 Target Server Type    : MySQL
 Target Server Version : 80030 (8.0.30)
 File Encoding         : 65001

 Date: 28/11/2023 13:51:28
*/


-- ----------------------------
-- Table structure for urule_authority
-- ----------------------------
CREATE TABLE `urule_authority`  (
  `ID_` int NOT NULL,
  `ROLE_ID_` int NOT NULL,
  `ROLE_TYPE_` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `RESOURCE_CODE_` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `RESOURCE_TYPE_` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `AUTH_` tinyint NOT NULL DEFAULT 1,
  PRIMARY KEY (`ID_`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '角色授权表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of urule_authority
-- ----------------------------
INSERT INTO `urule_authority` VALUES (1, 2, 'group', 'projects_view', 'view', 1);
INSERT INTO `urule_authority` VALUES (2, 2, 'group', 'projects_add', 'fun', 1);
INSERT INTO `urule_authority` VALUES (3, 2, 'group', 'projects_update', 'fun', 1);
INSERT INTO `urule_authority` VALUES (4, 2, 'group', 'projects_remove', 'fun', 1);
INSERT INTO `urule_authority` VALUES (5, 2, 'group', 'projects_import', 'fun', 1);
INSERT INTO `urule_authority` VALUES (6, 2, 'group', 'projects_export', 'fun', 1);
INSERT INTO `urule_authority` VALUES (7, 2, 'group', 'members_view', 'view', 1);
INSERT INTO `urule_authority` VALUES (8, 2, 'group', 'members_join', 'fun', 1);
INSERT INTO `urule_authority` VALUES (9, 2, 'group', 'members_add', 'fun', 1);
INSERT INTO `urule_authority` VALUES (10, 2, 'group', 'members_remove', 'fun', 1);
INSERT INTO `urule_authority` VALUES (11, 2, 'group', 'members_userrole', 'fun', 1);
INSERT INTO `urule_authority` VALUES (12, 2, 'group', 'permissions_view', 'view', 1);
INSERT INTO `urule_authority` VALUES (13, 2, 'group', 'permissions_manager', 'fun', 1);
INSERT INTO `urule_authority` VALUES (14, 2, 'group', 'setting_view', 'view', 1);
INSERT INTO `urule_authority` VALUES (15, 2, 'group', 'setting_update', 'fun', 1);
INSERT INTO `urule_authority` VALUES (16, 2, 'group', 'logs_view', 'view', 1);
INSERT INTO `urule_authority` VALUES (17, 2, 'group', 'logs_export', 'fun', 1);
INSERT INTO `urule_authority` VALUES (18, 2, 'group', 'clusterUrls_view', 'view', 1);
INSERT INTO `urule_authority` VALUES (19, 2, 'group', 'clusterUrls_manager', 'fun', 1);
INSERT INTO `urule_authority` VALUES (20, 2, 'group', 'clientUrls_view', 'view', 1);
INSERT INTO `urule_authority` VALUES (21, 2, 'group', 'clientUrls_manager', 'fun', 1);
INSERT INTO `urule_authority` VALUES (22, 2, 'group', 'dynamicJar_view', 'view', 1);
INSERT INTO `urule_authority` VALUES (23, 2, 'group', 'dynamicJar_manager', 'fun', 1);
INSERT INTO `urule_authority` VALUES (24, 2, 'group', 'datasource_view', 'view', 1);
INSERT INTO `urule_authority` VALUES (25, 2, 'group', 'datasource_manager', 'fun', 1);
INSERT INTO `urule_authority` VALUES (26, 3, 'group', 'projects_view', 'view', 1);
INSERT INTO `urule_authority` VALUES (27, 3, 'group', 'logs_view', 'view', 1);
INSERT INTO `urule_authority` VALUES (28, 1, 'project', 'project_remove', 'fun', 1);
INSERT INTO `urule_authority` VALUES (29, 1, 'project', 'project_export', 'fun', 1);
INSERT INTO `urule_authority` VALUES (30, 1, 'project', 'members_view', 'view', 1);
INSERT INTO `urule_authority` VALUES (31, 1, 'project', 'members_add', 'fun', 1);
INSERT INTO `urule_authority` VALUES (32, 1, 'project', 'members_remove', 'fun', 1);
INSERT INTO `urule_authority` VALUES (33, 1, 'project', 'members_userrole', 'fun', 1);
INSERT INTO `urule_authority` VALUES (34, 1, 'project', 'permissions_view', 'view', 1);
INSERT INTO `urule_authority` VALUES (35, 1, 'project', 'permissions_manager', 'fun', 1);
INSERT INTO `urule_authority` VALUES (36, 1, 'project', 'setting_view', 'view', 1);
INSERT INTO `urule_authority` VALUES (37, 1, 'project', 'setting_update', 'fun', 1);
INSERT INTO `urule_authority` VALUES (38, 1, 'project', 'setting_remove', 'fun', 1);
INSERT INTO `urule_authority` VALUES (39, 1, 'project', 'setting_approveUser', 'fun', 1);
INSERT INTO `urule_authority` VALUES (40, 1, 'project', 'rule_knowledge_view', 'view', 1);
INSERT INTO `urule_authority` VALUES (41, 1, 'project', 'rule_knowledge_manager', 'fun', 1);
INSERT INTO `urule_authority` VALUES (42, 1, 'project', 'Batch_view', 'view', 1);
INSERT INTO `urule_authority` VALUES (43, 1, 'project', 'Batch_manager', 'fun', 1);
INSERT INTO `urule_authority` VALUES (44, 1, 'project', 'rule_library_view', 'view', 1);
INSERT INTO `urule_authority` VALUES (45, 1, 'project', 'rule_library_add', 'fun', 1);
INSERT INTO `urule_authority` VALUES (46, 1, 'project', 'rule_library_update', 'fun', 1);
INSERT INTO `urule_authority` VALUES (47, 1, 'project', 'rule_library_remove', 'fun', 1);
INSERT INTO `urule_authority` VALUES (48, 1, 'project', 'rule_ruleset_view', 'view', 1);
INSERT INTO `urule_authority` VALUES (49, 1, 'project', 'rule_ruleset_add', 'fun', 1);
INSERT INTO `urule_authority` VALUES (50, 1, 'project', 'rule_ruleset_update', 'fun', 1);
INSERT INTO `urule_authority` VALUES (51, 1, 'project', 'rule_ruleset_remove', 'fun', 1);
INSERT INTO `urule_authority` VALUES (52, 1, 'project', 'rule_decisiontable_view', 'view', 1);
INSERT INTO `urule_authority` VALUES (53, 1, 'project', 'rule_decisiontable_add', 'fun', 1);
INSERT INTO `urule_authority` VALUES (54, 1, 'project', 'rule_decisiontable_update', 'fun', 1);
INSERT INTO `urule_authority` VALUES (55, 1, 'project', 'rule_decisiontable_remove', 'fun', 1);
INSERT INTO `urule_authority` VALUES (56, 1, 'project', 'rule_decisiontree_view', 'view', 1);
INSERT INTO `urule_authority` VALUES (57, 1, 'project', 'rule_decisiontree_add', 'fun', 1);
INSERT INTO `urule_authority` VALUES (58, 1, 'project', 'rule_decisiontree_update', 'fun', 1);
INSERT INTO `urule_authority` VALUES (59, 1, 'project', 'rule_decisiontree_remove', 'fun', 1);
INSERT INTO `urule_authority` VALUES (60, 1, 'project', 'rule_scorecard_view', 'view', 1);
INSERT INTO `urule_authority` VALUES (61, 1, 'project', 'rule_scorecard_add', 'fun', 1);
INSERT INTO `urule_authority` VALUES (62, 1, 'project', 'rule_scorecard_update', 'fun', 1);
INSERT INTO `urule_authority` VALUES (63, 1, 'project', 'rule_scorecard_remove', 'fun', 1);
INSERT INTO `urule_authority` VALUES (64, 1, 'project', 'rule_flow_view', 'view', 1);
INSERT INTO `urule_authority` VALUES (65, 1, 'project', 'rule_flow_add', 'fun', 1);
INSERT INTO `urule_authority` VALUES (66, 1, 'project', 'rule_flow_update', 'fun', 1);
INSERT INTO `urule_authority` VALUES (67, 1, 'project', 'rule_flow_remove', 'fun', 1);
INSERT INTO `urule_authority` VALUES (68, 1, 'project', 'rule_conditiontemplate_view', 'view', 1);
INSERT INTO `urule_authority` VALUES (69, 1, 'project', 'rule_conditiontemplate_add', 'fun', 1);
INSERT INTO `urule_authority` VALUES (70, 1, 'project', 'rule_conditiontemplate_update', 'fun', 1);
INSERT INTO `urule_authority` VALUES (71, 1, 'project', 'rule_conditiontemplate_remove', 'fun', 1);
INSERT INTO `urule_authority` VALUES (72, 1, 'project', 'rule_actiontemplate_view', 'view', 1);
INSERT INTO `urule_authority` VALUES (73, 1, 'project', 'rule_actiontemplate_add', 'fun', 1);
INSERT INTO `urule_authority` VALUES (74, 1, 'project', 'rule_actiontemplate_update', 'fun', 1);
INSERT INTO `urule_authority` VALUES (75, 1, 'project', 'rule_actiontemplate_remove', 'fun', 1);
INSERT INTO `urule_authority` VALUES (76, 3, 'project', 'rule_knowledge_view', 'view', 1);
INSERT INTO `urule_authority` VALUES (77, 3, 'project', 'Batch_view', 'view', 1);
INSERT INTO `urule_authority` VALUES (78, 3, 'project', 'rule_library_view', 'view', 1);
INSERT INTO `urule_authority` VALUES (79, 3, 'project', 'rule_ruleset_view', 'view', 1);
INSERT INTO `urule_authority` VALUES (80, 3, 'project', 'rule_decisiontable_view', 'view', 1);
INSERT INTO `urule_authority` VALUES (81, 3, 'project', 'rule_decisiontree_view', 'view', 1);
INSERT INTO `urule_authority` VALUES (82, 3, 'project', 'rule_scorecard_view', 'view', 1);
INSERT INTO `urule_authority` VALUES (83, 3, 'project', 'rule_flow_view', 'view', 1);
INSERT INTO `urule_authority` VALUES (84, 3, 'project', 'rule_conditiontemplate_view', 'view', 1);
INSERT INTO `urule_authority` VALUES (85, 3, 'project', 'rule_actiontemplate_view', 'view', 1);
INSERT INTO `urule_authority` VALUES (86, 4, 'project', 'rule_knowledge_view', 'view', 1);
INSERT INTO `urule_authority` VALUES (87, 4, 'project', 'rule_knowledge_manager', 'fun', 1);
INSERT INTO `urule_authority` VALUES (88, 5, 'project', 'Batch_view', 'view', 1);
INSERT INTO `urule_authority` VALUES (89, 5, 'project', 'Batch_manager', 'fun', 1);
INSERT INTO `urule_authority` VALUES (90, 6, 'project', 'rule_library_view', 'view', 1);
INSERT INTO `urule_authority` VALUES (91, 6, 'project', 'rule_library_add', 'fun', 1);
INSERT INTO `urule_authority` VALUES (92, 6, 'project', 'rule_library_update', 'fun', 1);
INSERT INTO `urule_authority` VALUES (93, 6, 'project', 'rule_library_remove', 'fun', 1);
INSERT INTO `urule_authority` VALUES (94, 7, 'project', 'rule_ruleset_view', 'view', 1);
INSERT INTO `urule_authority` VALUES (95, 7, 'project', 'rule_ruleset_add', 'fun', 1);
INSERT INTO `urule_authority` VALUES (96, 7, 'project', 'rule_ruleset_update', 'fun', 1);
INSERT INTO `urule_authority` VALUES (97, 7, 'project', 'rule_ruleset_remove', 'fun', 1);
INSERT INTO `urule_authority` VALUES (98, 8, 'project', 'rule_decisiontable_view', 'view', 1);
INSERT INTO `urule_authority` VALUES (99, 8, 'project', 'rule_decisiontable_add', 'fun', 1);
INSERT INTO `urule_authority` VALUES (100, 8, 'project', 'rule_decisiontable_update', 'fun', 1);
INSERT INTO `urule_authority` VALUES (101, 8, 'project', 'rule_decisiontable_remove', 'fun', 1);
INSERT INTO `urule_authority` VALUES (102, 9, 'project', 'rule_decisiontree_view', 'view', 1);
INSERT INTO `urule_authority` VALUES (103, 9, 'project', 'rule_decisiontree_add', 'fun', 1);
INSERT INTO `urule_authority` VALUES (104, 9, 'project', 'rule_decisiontree_update', 'fun', 1);
INSERT INTO `urule_authority` VALUES (105, 9, 'project', 'rule_decisiontree_remove', 'fun', 1);
INSERT INTO `urule_authority` VALUES (106, 10, 'project', 'rule_scorecard_view', 'view', 1);
INSERT INTO `urule_authority` VALUES (107, 10, 'project', 'rule_scorecard_add', 'fun', 1);
INSERT INTO `urule_authority` VALUES (108, 10, 'project', 'rule_scorecard_update', 'fun', 1);
INSERT INTO `urule_authority` VALUES (109, 10, 'project', 'rule_scorecard_remove', 'fun', 1);
INSERT INTO `urule_authority` VALUES (110, 11, 'project', 'rule_flow_view', 'view', 1);
INSERT INTO `urule_authority` VALUES (111, 11, 'project', 'rule_flow_add', 'fun', 1);
INSERT INTO `urule_authority` VALUES (112, 11, 'project', 'rule_flow_update', 'fun', 1);
INSERT INTO `urule_authority` VALUES (113, 11, 'project', 'rule_flow_remove', 'fun', 1);
INSERT INTO `urule_authority` VALUES (114, 12, 'project', 'rule_conditiontemplate_view', 'view', 1);
INSERT INTO `urule_authority` VALUES (115, 12, 'project', 'rule_conditiontemplate_add', 'fun', 1);
INSERT INTO `urule_authority` VALUES (116, 12, 'project', 'rule_conditiontemplate_update', 'fun', 1);
INSERT INTO `urule_authority` VALUES (117, 12, 'project', 'rule_conditiontemplate_remove', 'fun', 1);
INSERT INTO `urule_authority` VALUES (118, 13, 'project', 'rule_actiontemplate_view', 'view', 1);
INSERT INTO `urule_authority` VALUES (119, 13, 'project', 'rule_actiontemplate_add', 'fun', 1);
INSERT INTO `urule_authority` VALUES (120, 13, 'project', 'rule_actiontemplate_update', 'fun', 1);
INSERT INTO `urule_authority` VALUES (121, 13, 'project', 'rule_actiontemplate_remove', 'fun', 1);

-- ----------------------------
-- Table structure for urule_batch
-- ----------------------------
CREATE TABLE `urule_batch`  (
  `ID_` int NOT NULL,
  `PROJECT_ID_` int NOT NULL,
  `NAME_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `ENABLE_` tinyint NOT NULL DEFAULT 0,
  `SKIP_LIMIT_` int NULL DEFAULT NULL,
  `ASYNC_` tinyint NOT NULL DEFAULT 1,
  `CALLBACK_URL_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `STATUS_` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `LISTENER_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `THREAD_MULTI_` tinyint NOT NULL DEFAULT 1,
  `THREAD_SIZE_` int NULL DEFAULT NULL,
  `THREAD_DATA_SIZE_` int NULL DEFAULT NULL,
  `PROVIDER_ID_` int NULL DEFAULT NULL,
  `RESOLVER_ID_` int NULL DEFAULT NULL,
  `PACKET_ID_` int NULL DEFAULT NULL,
  `PACKET_INPUT_DATA_` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL,
  `REST_ENABLE_` tinyint NOT NULL DEFAULT 0,
  `REST_SECURITY_ENABLE_` tinyint NOT NULL DEFAULT 0,
  `REST_SECURITY_USER_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `REST_SECURITY_PASSWORD_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `INPUT_DATA_` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL,
  `DESC_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `CREATE_USER_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `UPDATE_USER_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `CREATE_DATE_` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `UPDATE_DATE_` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`ID_`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '批处理方案' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of urule_batch
-- ----------------------------

-- ----------------------------
-- Table structure for urule_batch_data_provider
-- ----------------------------
CREATE TABLE `urule_batch_data_provider`  (
  `ID_` int NOT NULL,
  `BATCH_ID_` int NOT NULL,
  `PROJECT_ID_` int NOT NULL,
  `NAME_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `DATASOURCE_ID_` int NULL DEFAULT NULL,
  `LISTENER_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `INPUT_DATA_` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL,
  `PACKET_VAR_NAME_` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `SUPPORT_PAGING_` tinyint NOT NULL DEFAULT 0,
  `PAGE_SIZE_` int NOT NULL DEFAULT 100,
  `PAGE_SQL_` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL,
  `ORDER_FIELD_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `ORDER_FIELD_PARAM_NAME_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `PAGE_LIMIT_TYPE_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `COUNT_SQL_` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL,
  `VALIDATOR_DATA_` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL,
  `DESC_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `CREATE_USER_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `UPDATE_USER_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `CREATE_DATE_` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `UPDATE_DATE_` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`ID_`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '批处理查询方案' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of urule_batch_data_provider
-- ----------------------------

-- ----------------------------
-- Table structure for urule_batch_data_resolver
-- ----------------------------
CREATE TABLE `urule_batch_data_resolver`  (
  `ID_` int NOT NULL,
  `BATCH_ID_` int NOT NULL,
  `PROJECT_ID_` int NOT NULL,
  `DATASOURCE_ID_` int NULL DEFAULT NULL,
  `NAME_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `LISTENER_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `TRAN_SCOPE_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `VALIDATOR_DATA_` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL,
  `DESC_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `CREATE_USER_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `UPDATE_USER_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `CREATE_DATE_` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `UPDATE_DATE_` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`ID_`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '批处理保存方案' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of urule_batch_data_resolver
-- ----------------------------

-- ----------------------------
-- Table structure for urule_batch_provider_field
-- ----------------------------
CREATE TABLE `urule_batch_provider_field`  (
  `ID_` int NOT NULL,
  `PROJECT_ID_` int NOT NULL,
  `BATCH_ID_` int NOT NULL,
  `PROVIDER_ID_` int NOT NULL,
  `SRC_PROPERTY_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `DATA_TYPE_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `DEST_PROPERTY_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `CLAZZ_PATH_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `DATA_PROVIDER_ID_` int NULL DEFAULT NULL,
  `CREATE_USER_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `UPDATE_USER_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `CREATE_DATE_` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `UPDATE_DATE_` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`ID_`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '批处理查询方案数据映射' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of urule_batch_provider_field
-- ----------------------------

-- ----------------------------
-- Table structure for urule_batch_resolver_field
-- ----------------------------
CREATE TABLE `urule_batch_resolver_field`  (
  `ID_` int NOT NULL,
  `PROJECT_ID_` int NOT NULL,
  `BATCH_ID_` int NOT NULL,
  `RESOLVER_ID_` int NOT NULL,
  `ITEM_ID_` int NOT NULL,
  `SRC_PROPERTY_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `DATA_TYPE_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `KEY_` tinyint NOT NULL DEFAULT 0,
  `DEST_PROPERTY_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `CREATE_USER_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `UPDATE_USER_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `CREATE_DATE_` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `UPDATE_DATE_` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`ID_`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '批处理保存方案数据映射' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of urule_batch_resolver_field
-- ----------------------------

-- ----------------------------
-- Table structure for urule_batch_resolver_item
-- ----------------------------
CREATE TABLE `urule_batch_resolver_item`  (
  `ID_` int NOT NULL,
  `BATCH_ID_` int NOT NULL,
  `PROJECT_ID_` int NOT NULL,
  `RESOLVER_ID_` int NOT NULL,
  `NAME_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `UPDATE_MODE_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `TABLE_NAME_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `VALIDATOR_DATA_` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL,
  `PARTITION_NAME_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `PARTITION_VALUE_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `COMMIT_LIMIT_` int NULL DEFAULT NULL,
  `DESC_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `CREATE_USER_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `UPDATE_USER_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `CREATE_DATE_` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `UPDATE_DATE_` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`ID_`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '批处理保存方案明细项' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of urule_batch_resolver_item
-- ----------------------------

-- ----------------------------
-- Table structure for urule_datasource
-- ----------------------------
CREATE TABLE `urule_datasource`  (
  `ID_` int NOT NULL,
  `GROUP_ID_` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `NAME_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `TYPE_` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `DATASOURCE_BEAN_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `DB_JNDI_NAME_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `DB_DRIVER_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `DB_URL_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `DB_USER_` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `DB_PWD_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `DB_VALIDATION_QUERY_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `DB_INITIAL_SIZE_` int NULL DEFAULT NULL,
  `DB_MAX_TOTAL_` int NULL DEFAULT NULL,
  `DB_MAX_IDLE_` int NULL DEFAULT NULL,
  `DB_MIN_IDLE_` int NULL DEFAULT NULL,
  `DESC_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `CREATE_USER_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `UPDATE_USER_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `CREATE_DATE_` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `UPDATE_DATE_` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`ID_`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '数据仓库' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of urule_datasource
-- ----------------------------

-- ----------------------------
-- Table structure for urule_deployed_packet
-- ----------------------------
CREATE TABLE `urule_deployed_packet`  (
  `ID_` int NOT NULL,
  `PACKET_ID_` int NOT NULL DEFAULT 0,
  `PROJECT_ID_` int NOT NULL,
  `DESC_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `APPLY_ID_` int NOT NULL DEFAULT 0,
  `CONTENT_` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `DIGEST_` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `VERSION_` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `STATUS_` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `ENABLE_` tinyint NOT NULL DEFAULT 0,
  `CREATE_USER_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `CREATE_DATE_` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`ID_`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '已发布知识包主表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of urule_deployed_packet
-- ----------------------------
INSERT INTO `urule_deployed_packet` VALUES (101, 1, 1, '1.0', 101, '{\"knowledgePackage\":{\"monitor\":false,\"rete\":{\"objectTypeNodes\":[{\"id\":28,\"lines\":[{\"fromNodeId\":28,\"toNodeId\":27}],\"objectTypeClass\":\"__*__\",\"nodeType\":\"objectType\"}]},\"aloneRetes\":[],\"flowMap\":{},\"parameters\":{},\"timestamp\":1701053032586,\"id\":\"e1ad786b-ce50-4c89-8286-a70164c87caf\",\"variableCategories\":[{\"uuid\":\"55170ba8-6b28-42b0-ac00-fb773018ea2a\",\"name\":\"SupplierEvaluationIndex\",\"type\":\"Custom\",\"clazz\":\"com.ruoyi.supplier.domain.SupplierEvaluationIndex\",\"file\":\"VariableLibrary:hdgk/SupplierEvaluationIndex\",\"act\":\"InOut\",\"variables\":[{\"uuid\":\"15d0d5b5-4d02-49e7-a922-13b038ebbd19\",\"name\":\"cooperationDuration\",\"label\":\"合作时长\",\"type\":\"Integer\",\"dataType\":\"Integer\",\"act\":\"InOut\"},{\"uuid\":\"92c348ce-fd13-486e-be08-a7c2f8870993\",\"name\":\"orderNum\",\"label\":\"订单总数\",\"type\":\"Integer\",\"dataType\":\"Integer\",\"act\":\"InOut\"},{\"uuid\":\"2c18ff3c-93e6-40de-b93a-c1232a6a8988\",\"name\":\"paymentCycle\",\"label\":\"交款周期\",\"type\":\"Integer\",\"dataType\":\"Integer\",\"act\":\"InOut\"},{\"uuid\":\"4d12ac01-bb0c-4bab-9aaa-84e61205e0da\",\"name\":\"score\",\"label\":\"综合得分\",\"type\":\"Integer\",\"dataType\":\"Integer\",\"act\":\"InOut\"}]}],\"variableCateogoryMap\":{\"SupplierEvaluationIndex\":\"com.ruoyi.supplier.domain.SupplierEvaluationIndex\"}},\"allNodes\":[{\"id\":27,\"rule\":{\"name\":\"supplier\",\"file\":\"Scorecard:hdgk/supplier,102\",\"loopRule\":false,\"withElse\":false,\"scoringType\":\"weightsum\",\"assignTargetType\":\"variable\",\"variableCategory\":\"SupplierEvaluationIndex\",\"variableName\":\"score\",\"variableLabel\":\"综合得分\",\"datatype\":\"Integer\",\"knowledgePackageWrapper\":{\"knowledgePackage\":{\"monitor\":false,\"rete\":{\"objectTypeNodes\":[{\"id\":3,\"lines\":[{\"fromNodeId\":3,\"toNodeId\":4},{\"fromNodeId\":3,\"toNodeId\":6},{\"fromNodeId\":3,\"toNodeId\":9},{\"fromNodeId\":3,\"toNodeId\":12},{\"fromNodeId\":3,\"toNodeId\":14},{\"fromNodeId\":3,\"toNodeId\":16},{\"fromNodeId\":3,\"toNodeId\":19},{\"fromNodeId\":3,\"toNodeId\":21},{\"fromNodeId\":3,\"toNodeId\":23},{\"fromNodeId\":3,\"toNodeId\":26}],\"objectTypeClass\":\"com.ruoyi.supplier.domain.SupplierEvaluationIndex\",\"nodeType\":\"objectType\"}]},\"parameters\":{},\"timestamp\":1701053032581,\"id\":\"7d796169-8460-4233-8597-3c3fd6d90782\",\"variableCategories\":[{\"uuid\":\"55170ba8-6b28-42b0-ac00-fb773018ea2a\",\"name\":\"SupplierEvaluationIndex\",\"type\":\"Custom\",\"clazz\":\"com.ruoyi.supplier.domain.SupplierEvaluationIndex\",\"file\":\"VariableLibrary:hdgk/SupplierEvaluationIndex\",\"act\":\"InOut\",\"variables\":[{\"uuid\":\"15d0d5b5-4d02-49e7-a922-13b038ebbd19\",\"name\":\"cooperationDuration\",\"label\":\"合作时长\",\"type\":\"Integer\",\"dataType\":\"Integer\",\"act\":\"InOut\"},{\"uuid\":\"92c348ce-fd13-486e-be08-a7c2f8870993\",\"name\":\"orderNum\",\"label\":\"订单总数\",\"type\":\"Integer\",\"dataType\":\"Integer\",\"act\":\"InOut\"},{\"uuid\":\"2c18ff3c-93e6-40de-b93a-c1232a6a8988\",\"name\":\"paymentCycle\",\"label\":\"交款周期\",\"type\":\"Integer\",\"dataType\":\"Integer\",\"act\":\"InOut\"},{\"uuid\":\"4d12ac01-bb0c-4bab-9aaa-84e61205e0da\",\"name\":\"score\",\"label\":\"综合得分\",\"type\":\"Integer\",\"dataType\":\"Integer\",\"act\":\"InOut\"}]}],\"variableCateogoryMap\":{\"SupplierEvaluationIndex\":\"com.ruoyi.supplier.domain.SupplierEvaluationIndex\"}},\"allNodes\":[{\"id\":4,\"lines\":[{\"fromNodeId\":4,\"toNodeId\":2}],\"debug\":false,\"criteria\":{\"op\":\"LessThenEquals\",\"left\":{\"leftPart\":{\"uuid\":\"15d0d5b5-4d02-49e7-a922-13b038ebbd19\",\"categoryUuid\":\"55170ba8-6b28-42b0-ac00-fb773018ea2a\",\"variableName\":\"cooperationDuration\",\"variableLabel\":\"合作时长\",\"variableCategory\":\"SupplierEvaluationIndex\",\"datatype\":\"Integer\"},\"type\":\"variable\"},\"value\":{\"content\":\"365\",\"valueType\":\"Input\"},\"file\":\"Scorecard:hdgk/supplier,102\",\"necessaryClassList\":[\"com.ruoyi.supplier.domain.SupplierEvaluationIndex\"]},\"nodeType\":\"criteria\"},{\"id\":2,\"rule\":{\"name\":\"sc-r2\",\"file\":\"Scorecard:hdgk/supplier,102\",\"rhs\":{\"actions\":[{\"name\":\"scoring_value\",\"value\":{\"content\":\"20\",\"valueType\":\"Input\"},\"weight\":\"0.2\",\"rowNumber\":2,\"actionType\":\"Scoring\",\"priority\":0}]},\"loopRule\":false,\"withElse\":false},\"nodeType\":\"terminal\"},{\"id\":6,\"lines\":[{\"fromNodeId\":6,\"toNodeId\":7}],\"debug\":false,\"criteria\":{\"op\":\"GreaterThen\",\"left\":{\"leftPart\":{\"uuid\":\"15d0d5b5-4d02-49e7-a922-13b038ebbd19\",\"categoryUuid\":\"55170ba8-6b28-42b0-ac00-fb773018ea2a\",\"variableName\":\"cooperationDuration\",\"variableLabel\":\"合作时长\",\"variableCategory\":\"SupplierEvaluationIndex\",\"datatype\":\"Integer\"},\"type\":\"variable\"},\"value\":{\"content\":\"365\",\"valueType\":\"Input\"},\"file\":\"Scorecard:hdgk/supplier,102\",\"necessaryClassList\":[\"com.ruoyi.supplier.domain.SupplierEvaluationIndex\"]},\"nodeType\":\"criteria\"},{\"id\":7,\"lines\":[{\"fromNodeId\":7,\"toNodeId\":5}],\"debug\":false,\"criteria\":{\"op\":\"LessThenEquals\",\"left\":{\"leftPart\":{\"uuid\":\"15d0d5b5-4d02-49e7-a922-13b038ebbd19\",\"categoryUuid\":\"55170ba8-6b28-42b0-ac00-fb773018ea2a\",\"variableName\":\"cooperationDuration\",\"variableLabel\":\"合作时长\",\"variableCategory\":\"SupplierEvaluationIndex\",\"datatype\":\"Integer\"},\"type\":\"variable\"},\"value\":{\"content\":\"730\",\"valueType\":\"Input\"},\"file\":\"Scorecard:hdgk/supplier,102\",\"necessaryClassList\":[\"com.ruoyi.supplier.domain.SupplierEvaluationIndex\"]},\"nodeType\":\"criteria\"},{\"id\":5,\"rule\":{\"name\":\"sc-r3\",\"file\":\"Scorecard:hdgk/supplier,102\",\"rhs\":{\"actions\":[{\"name\":\"scoring_value\",\"value\":{\"content\":\"40\",\"valueType\":\"Input\"},\"weight\":\"0.2\",\"rowNumber\":3,\"actionType\":\"Scoring\",\"priority\":0}]},\"loopRule\":false,\"withElse\":false},\"nodeType\":\"terminal\"},{\"id\":9,\"lines\":[{\"fromNodeId\":9,\"toNodeId\":10}],\"debug\":false,\"criteria\":{\"op\":\"GreaterThen\",\"left\":{\"leftPart\":{\"uuid\":\"15d0d5b5-4d02-49e7-a922-13b038ebbd19\",\"categoryUuid\":\"55170ba8-6b28-42b0-ac00-fb773018ea2a\",\"variableName\":\"cooperationDuration\",\"variableLabel\":\"合作时长\",\"variableCategory\":\"SupplierEvaluationIndex\",\"datatype\":\"Integer\"},\"type\":\"variable\"},\"value\":{\"content\":\"730\",\"valueType\":\"Input\"},\"file\":\"Scorecard:hdgk/supplier,102\",\"necessaryClassList\":[\"com.ruoyi.supplier.domain.SupplierEvaluationIndex\"]},\"nodeType\":\"criteria\"},{\"id\":10,\"lines\":[{\"fromNodeId\":10,\"toNodeId\":8}],\"debug\":false,\"criteria\":{\"op\":\"LessThenEquals\",\"left\":{\"leftPart\":{\"uuid\":\"15d0d5b5-4d02-49e7-a922-13b038ebbd19\",\"categoryUuid\":\"55170ba8-6b28-42b0-ac00-fb773018ea2a\",\"variableName\":\"cooperationDuration\",\"variableLabel\":\"合作时长\",\"variableCategory\":\"SupplierEvaluationIndex\",\"datatype\":\"Integer\"},\"type\":\"variable\"},\"value\":{\"content\":\"1825\",\"valueType\":\"Input\"},\"file\":\"Scorecard:hdgk/supplier,102\",\"necessaryClassList\":[\"com.ruoyi.supplier.domain.SupplierEvaluationIndex\"]},\"nodeType\":\"criteria\"},{\"id\":8,\"rule\":{\"name\":\"sc-r4\",\"file\":\"Scorecard:hdgk/supplier,102\",\"rhs\":{\"actions\":[{\"name\":\"scoring_value\",\"value\":{\"content\":\"60\",\"valueType\":\"Input\"},\"weight\":\"0.2\",\"rowNumber\":4,\"actionType\":\"Scoring\",\"priority\":0}]},\"loopRule\":false,\"withElse\":false},\"nodeType\":\"terminal\"},{\"id\":12,\"lines\":[{\"fromNodeId\":12,\"toNodeId\":11}],\"debug\":false,\"criteria\":{\"op\":\"GreaterThen\",\"left\":{\"leftPart\":{\"uuid\":\"15d0d5b5-4d02-49e7-a922-13b038ebbd19\",\"categoryUuid\":\"55170ba8-6b28-42b0-ac00-fb773018ea2a\",\"variableName\":\"cooperationDuration\",\"variableLabel\":\"合作时长\",\"variableCategory\":\"SupplierEvaluationIndex\",\"datatype\":\"Integer\"},\"type\":\"variable\"},\"value\":{\"content\":\"1825\",\"valueType\":\"Input\"},\"file\":\"Scorecard:hdgk/supplier,102\",\"necessaryClassList\":[\"com.ruoyi.supplier.domain.SupplierEvaluationIndex\"]},\"nodeType\":\"criteria\"},{\"id\":11,\"rule\":{\"name\":\"sc-r5\",\"file\":\"Scorecard:hdgk/supplier,102\",\"rhs\":{\"actions\":[{\"name\":\"scoring_value\",\"value\":{\"content\":\"100\",\"valueType\":\"Input\"},\"weight\":\"0.2\",\"rowNumber\":5,\"actionType\":\"Scoring\",\"priority\":0}]},\"loopRule\":false,\"withElse\":false},\"nodeType\":\"terminal\"},{\"id\":14,\"lines\":[{\"fromNodeId\":14,\"toNodeId\":13}],\"debug\":false,\"criteria\":{\"op\":\"LessThenEquals\",\"left\":{\"leftPart\":{\"uuid\":\"92c348ce-fd13-486e-be08-a7c2f8870993\",\"categoryUuid\":\"55170ba8-6b28-42b0-ac00-fb773018ea2a\",\"variableName\":\"orderNum\",\"variableLabel\":\"订单总数\",\"variableCategory\":\"SupplierEvaluationIndex\",\"datatype\":\"Integer\"},\"type\":\"variable\"},\"value\":{\"content\":\"50\",\"valueType\":\"Input\"},\"file\":\"Scorecard:hdgk/supplier,102\",\"necessaryClassList\":[\"com.ruoyi.supplier.domain.SupplierEvaluationIndex\"]},\"nodeType\":\"criteria\"},{\"id\":13,\"rule\":{\"name\":\"sc-r6\",\"file\":\"Scorecard:hdgk/supplier,102\",\"rhs\":{\"actions\":[{\"name\":\"scoring_value\",\"value\":{\"content\":\"20\",\"valueType\":\"Input\"},\"weight\":\"0.2\",\"rowNumber\":6,\"actionType\":\"Scoring\",\"priority\":0}]},\"loopRule\":false,\"withElse\":false},\"nodeType\":\"terminal\"},{\"id\":16,\"lines\":[{\"fromNodeId\":16,\"toNodeId\":17}],\"debug\":false,\"criteria\":{\"op\":\"GreaterThen\",\"left\":{\"leftPart\":{\"uuid\":\"92c348ce-fd13-486e-be08-a7c2f8870993\",\"categoryUuid\":\"55170ba8-6b28-42b0-ac00-fb773018ea2a\",\"variableName\":\"orderNum\",\"variableLabel\":\"订单总数\",\"variableCategory\":\"SupplierEvaluationIndex\",\"datatype\":\"Integer\"},\"type\":\"variable\"},\"value\":{\"content\":\"50\",\"valueType\":\"Input\"},\"file\":\"Scorecard:hdgk/supplier,102\",\"necessaryClassList\":[\"com.ruoyi.supplier.domain.SupplierEvaluationIndex\"]},\"nodeType\":\"criteria\"},{\"id\":17,\"lines\":[{\"fromNodeId\":17,\"toNodeId\":15}],\"debug\":false,\"criteria\":{\"op\":\"LessThenEquals\",\"left\":{\"leftPart\":{\"uuid\":\"92c348ce-fd13-486e-be08-a7c2f8870993\",\"categoryUuid\":\"55170ba8-6b28-42b0-ac00-fb773018ea2a\",\"variableName\":\"orderNum\",\"variableLabel\":\"订单总数\",\"variableCategory\":\"SupplierEvaluationIndex\",\"datatype\":\"Integer\"},\"type\":\"variable\"},\"value\":{\"content\":\"100\",\"valueType\":\"Input\"},\"file\":\"Scorecard:hdgk/supplier,102\",\"necessaryClassList\":[\"com.ruoyi.supplier.domain.SupplierEvaluationIndex\"]},\"nodeType\":\"criteria\"},{\"id\":15,\"rule\":{\"name\":\"sc-r7\",\"file\":\"Scorecard:hdgk/supplier,102\",\"rhs\":{\"actions\":[{\"name\":\"scoring_value\",\"value\":{\"content\":\"60\",\"valueType\":\"Input\"},\"weight\":\"0.2\",\"rowNumber\":7,\"actionType\":\"Scoring\",\"priority\":0}]},\"loopRule\":false,\"withElse\":false},\"nodeType\":\"terminal\"},{\"id\":19,\"lines\":[{\"fromNodeId\":19,\"toNodeId\":18}],\"debug\":false,\"criteria\":{\"op\":\"GreaterThen\",\"left\":{\"leftPart\":{\"uuid\":\"92c348ce-fd13-486e-be08-a7c2f8870993\",\"categoryUuid\":\"55170ba8-6b28-42b0-ac00-fb773018ea2a\",\"variableName\":\"orderNum\",\"variableLabel\":\"订单总数\",\"variableCategory\":\"SupplierEvaluationIndex\",\"datatype\":\"Integer\"},\"type\":\"variable\"},\"value\":{\"content\":\"100\",\"valueType\":\"Input\"},\"file\":\"Scorecard:hdgk/supplier,102\",\"necessaryClassList\":[\"com.ruoyi.supplier.domain.SupplierEvaluationIndex\"]},\"nodeType\":\"criteria\"},{\"id\":18,\"rule\":{\"name\":\"sc-r8\",\"file\":\"Scorecard:hdgk/supplier,102\",\"rhs\":{\"actions\":[{\"name\":\"scoring_value\",\"value\":{\"content\":\"100\",\"valueType\":\"Input\"},\"weight\":\"0.2\",\"rowNumber\":8,\"actionType\":\"Scoring\",\"priority\":0}]},\"loopRule\":false,\"withElse\":false},\"nodeType\":\"terminal\"},{\"id\":21,\"lines\":[{\"fromNodeId\":21,\"toNodeId\":20}],\"debug\":false,\"criteria\":{\"op\":\"LessThenEquals\",\"left\":{\"leftPart\":{\"uuid\":\"2c18ff3c-93e6-40de-b93a-c1232a6a8988\",\"categoryUuid\":\"55170ba8-6b28-42b0-ac00-fb773018ea2a\",\"variableName\":\"paymentCycle\",\"variableLabel\":\"交款周期\",\"variableCategory\":\"SupplierEvaluationIndex\",\"datatype\":\"Integer\"},\"type\":\"variable\"},\"value\":{\"content\":\"7\",\"valueType\":\"Input\"},\"file\":\"Scorecard:hdgk/supplier,102\",\"necessaryClassList\":[\"com.ruoyi.supplier.domain.SupplierEvaluationIndex\"]},\"nodeType\":\"criteria\"},{\"id\":20,\"rule\":{\"name\":\"sc-r9\",\"file\":\"Scorecard:hdgk/supplier,102\",\"rhs\":{\"actions\":[{\"name\":\"scoring_value\",\"value\":{\"content\":\"100\",\"valueType\":\"Input\"},\"weight\":\"0.6\",\"rowNumber\":9,\"actionType\":\"Scoring\",\"priority\":0}]},\"loopRule\":false,\"withElse\":false},\"nodeType\":\"terminal\"},{\"id\":23,\"lines\":[{\"fromNodeId\":23,\"toNodeId\":24}],\"debug\":false,\"criteria\":{\"op\":\"GreaterThen\",\"left\":{\"leftPart\":{\"uuid\":\"2c18ff3c-93e6-40de-b93a-c1232a6a8988\",\"categoryUuid\":\"55170ba8-6b28-42b0-ac00-fb773018ea2a\",\"variableName\":\"paymentCycle\",\"variableLabel\":\"交款周期\",\"variableCategory\":\"SupplierEvaluationIndex\",\"datatype\":\"Integer\"},\"type\":\"variable\"},\"value\":{\"content\":\"7\",\"valueType\":\"Input\"},\"file\":\"Scorecard:hdgk/supplier,102\",\"necessaryClassList\":[\"com.ruoyi.supplier.domain.SupplierEvaluationIndex\"]},\"nodeType\":\"criteria\"},{\"id\":24,\"lines\":[{\"fromNodeId\":24,\"toNodeId\":22}],\"debug\":false,\"criteria\":{\"op\":\"LessThenEquals\",\"left\":{\"leftPart\":{\"uuid\":\"2c18ff3c-93e6-40de-b93a-c1232a6a8988\",\"categoryUuid\":\"55170ba8-6b28-42b0-ac00-fb773018ea2a\",\"variableName\":\"paymentCycle\",\"variableLabel\":\"交款周期\",\"variableCategory\":\"SupplierEvaluationIndex\",\"datatype\":\"Integer\"},\"type\":\"variable\"},\"value\":{\"content\":\"14\",\"valueType\":\"Input\"},\"file\":\"Scorecard:hdgk/supplier,102\",\"necessaryClassList\":[\"com.ruoyi.supplier.domain.SupplierEvaluationIndex\"]},\"nodeType\":\"criteria\"},{\"id\":22,\"rule\":{\"name\":\"sc-r10\",\"file\":\"Scorecard:hdgk/supplier,102\",\"rhs\":{\"actions\":[{\"name\":\"scoring_value\",\"value\":{\"content\":\"60\",\"valueType\":\"Input\"},\"weight\":\"0.6\",\"rowNumber\":10,\"actionType\":\"Scoring\",\"priority\":0}]},\"loopRule\":false,\"withElse\":false},\"nodeType\":\"terminal\"},{\"id\":26,\"lines\":[{\"fromNodeId\":26,\"toNodeId\":25}],\"debug\":false,\"criteria\":{\"op\":\"GreaterThen\",\"left\":{\"leftPart\":{\"uuid\":\"2c18ff3c-93e6-40de-b93a-c1232a6a8988\",\"categoryUuid\":\"55170ba8-6b28-42b0-ac00-fb773018ea2a\",\"variableName\":\"paymentCycle\",\"variableLabel\":\"交款周期\",\"variableCategory\":\"SupplierEvaluationIndex\",\"datatype\":\"Integer\"},\"type\":\"variable\"},\"value\":{\"content\":\"14\",\"valueType\":\"Input\"},\"file\":\"Scorecard:hdgk/supplier,102\",\"necessaryClassList\":[\"com.ruoyi.supplier.domain.SupplierEvaluationIndex\"]},\"nodeType\":\"criteria\"},{\"id\":25,\"rule\":{\"name\":\"sc-r11\",\"file\":\"Scorecard:hdgk/supplier,102\",\"rhs\":{\"actions\":[{\"name\":\"scoring_value\",\"value\":{\"content\":\"40\",\"valueType\":\"Input\"},\"weight\":\"0.6\",\"rowNumber\":11,\"actionType\":\"Scoring\",\"priority\":0}]},\"loopRule\":false,\"withElse\":false},\"nodeType\":\"terminal\"}],\"id\":\"72105785-8222-44fd-a787-8acd30d20abb\"}},\"nodeType\":\"terminal\"}],\"id\":\"e1fcd493-26eb-4e36-a667-57506ada587e\"}', 'ea45745c46457148c1d455db4eaf0259', '1.0.0', 'pass', 1, 'admin', '2023-11-27 10:43:53');
INSERT INTO `urule_deployed_packet` VALUES (302, 102, 1, '2', 302, '{\"knowledgePackage\":{\"monitor\":false,\"rete\":{\"objectTypeNodes\":[{\"id\":18,\"lines\":[{\"fromNodeId\":18,\"toNodeId\":17}],\"objectTypeClass\":\"__*__\",\"nodeType\":\"objectType\"}]},\"aloneRetes\":[],\"flowMap\":{},\"parameters\":{},\"timestamp\":1701141388917,\"id\":\"27749cd0-c029-4c88-b843-f26e098aca2f\",\"variableCategories\":[{\"uuid\":\"55170ba8-6b28-42b0-ac00-fb773018ea2a\",\"name\":\"SupplierEvaluationIndex\",\"type\":\"Custom\",\"clazz\":\"com.ruoyi.supplier.domain.SupplierEvaluationIndex\",\"file\":\"VariableLibrary:hdgk/SupplierEvaluationIndex\",\"act\":\"InOut\",\"variables\":[{\"uuid\":\"15d0d5b5-4d02-49e7-a922-13b038ebbd19\",\"name\":\"cooperationDuration\",\"label\":\"合作时长\",\"type\":\"Integer\",\"dataType\":\"Integer\",\"act\":\"InOut\"},{\"uuid\":\"92c348ce-fd13-486e-be08-a7c2f8870993\",\"name\":\"orderNum\",\"label\":\"订单总数\",\"type\":\"Integer\",\"dataType\":\"Integer\",\"act\":\"InOut\"},{\"uuid\":\"2c18ff3c-93e6-40de-b93a-c1232a6a8988\",\"name\":\"paymentCycle\",\"label\":\"交款周期\",\"type\":\"Integer\",\"dataType\":\"Integer\",\"act\":\"InOut\"},{\"uuid\":\"4d12ac01-bb0c-4bab-9aaa-84e61205e0da\",\"name\":\"score\",\"label\":\"综合得分\",\"type\":\"Integer\",\"dataType\":\"Integer\",\"act\":\"InOut\"}]}],\"variableCateogoryMap\":{\"SupplierEvaluationIndex\":\"com.ruoyi.supplier.domain.SupplierEvaluationIndex\"}},\"allNodes\":[{\"id\":17,\"rule\":{\"name\":\"cc\",\"file\":\"ComplexScorecard:hdgk/fz,103\",\"loopRule\":false,\"withElse\":false,\"scoringType\":\"sum\",\"assignTargetType\":\"variable\",\"variableCategory\":\"SupplierEvaluationIndex\",\"variableName\":\"score\",\"variableLabel\":\"综合得分\",\"datatype\":\"Integer\",\"knowledgePackageWrapper\":{\"knowledgePackage\":{\"monitor\":false,\"rete\":{\"objectTypeNodes\":[{\"id\":3,\"lines\":[{\"fromNodeId\":3,\"toNodeId\":4},{\"fromNodeId\":3,\"toNodeId\":7},{\"fromNodeId\":3,\"toNodeId\":14},{\"fromNodeId\":3,\"toNodeId\":16}],\"objectTypeClass\":\"com.ruoyi.supplier.domain.SupplierEvaluationIndex\",\"nodeType\":\"objectType\"}]},\"parameters\":{},\"timestamp\":1701141388911,\"id\":\"344cb795-22c0-4605-a7a6-4d691e108796\",\"variableCategories\":[{\"uuid\":\"55170ba8-6b28-42b0-ac00-fb773018ea2a\",\"name\":\"SupplierEvaluationIndex\",\"type\":\"Custom\",\"clazz\":\"com.ruoyi.supplier.domain.SupplierEvaluationIndex\",\"file\":\"VariableLibrary:hdgk/SupplierEvaluationIndex\",\"act\":\"InOut\",\"variables\":[{\"uuid\":\"15d0d5b5-4d02-49e7-a922-13b038ebbd19\",\"name\":\"cooperationDuration\",\"label\":\"合作时长\",\"type\":\"Integer\",\"dataType\":\"Integer\",\"act\":\"InOut\"},{\"uuid\":\"92c348ce-fd13-486e-be08-a7c2f8870993\",\"name\":\"orderNum\",\"label\":\"订单总数\",\"type\":\"Integer\",\"dataType\":\"Integer\",\"act\":\"InOut\"},{\"uuid\":\"2c18ff3c-93e6-40de-b93a-c1232a6a8988\",\"name\":\"paymentCycle\",\"label\":\"交款周期\",\"type\":\"Integer\",\"dataType\":\"Integer\",\"act\":\"InOut\"},{\"uuid\":\"4d12ac01-bb0c-4bab-9aaa-84e61205e0da\",\"name\":\"score\",\"label\":\"综合得分\",\"type\":\"Integer\",\"dataType\":\"Integer\",\"act\":\"InOut\"}]}],\"variableCateogoryMap\":{\"SupplierEvaluationIndex\":\"com.ruoyi.supplier.domain.SupplierEvaluationIndex\"}},\"allNodes\":[{\"id\":4,\"lines\":[{\"fromNodeId\":4,\"toNodeId\":5},{\"fromNodeId\":4,\"toNodeId\":10}],\"debug\":false,\"criteria\":{\"op\":\"LessThenEquals\",\"left\":{\"leftPart\":{\"uuid\":\"15d0d5b5-4d02-49e7-a922-13b038ebbd19\",\"categoryUuid\":\"55170ba8-6b28-42b0-ac00-fb773018ea2a\",\"variableName\":\"cooperationDuration\",\"variableLabel\":\"合作时长\",\"variableCategory\":\"SupplierEvaluationIndex\",\"datatype\":\"Integer\"},\"type\":\"variable\"},\"value\":{\"content\":\"300\",\"valueType\":\"Input\"},\"file\":\"ComplexScorecard:hdgk/fz,103\",\"necessaryClassList\":[\"com.ruoyi.supplier.domain.SupplierEvaluationIndex\"]},\"nodeType\":\"criteria\"},{\"id\":5,\"lines\":[{\"fromNodeId\":5,\"toNodeId\":2}],\"debug\":false,\"criteria\":{\"op\":\"LessThenEquals\",\"left\":{\"leftPart\":{\"uuid\":\"92c348ce-fd13-486e-be08-a7c2f8870993\",\"categoryUuid\":\"55170ba8-6b28-42b0-ac00-fb773018ea2a\",\"variableName\":\"orderNum\",\"variableLabel\":\"订单总数\",\"variableCategory\":\"SupplierEvaluationIndex\",\"datatype\":\"Integer\"},\"type\":\"variable\"},\"value\":{\"content\":\"50\",\"valueType\":\"Input\"},\"file\":\"ComplexScorecard:hdgk/fz,103\",\"necessaryClassList\":[\"com.ruoyi.supplier.domain.SupplierEvaluationIndex\"]},\"nodeType\":\"criteria\"},{\"id\":2,\"rule\":{\"name\":\"cc-r0\",\"file\":\"ComplexScorecard:hdgk/fz,103\",\"rhs\":{\"actions\":[{\"name\":\"scoring_value\",\"value\":{\"content\":\"20\",\"valueType\":\"Input\"},\"actionType\":\"Scoring\",\"rowNumber\":0,\"priority\":0}]},\"loopRule\":false,\"withElse\":false},\"nodeType\":\"terminal\"},{\"id\":10,\"lines\":[{\"fromNodeId\":10,\"toNodeId\":9}],\"debug\":false,\"criteria\":{\"op\":\"GreaterThen\",\"left\":{\"leftPart\":{\"uuid\":\"92c348ce-fd13-486e-be08-a7c2f8870993\",\"categoryUuid\":\"55170ba8-6b28-42b0-ac00-fb773018ea2a\",\"variableName\":\"orderNum\",\"variableLabel\":\"订单总数\",\"variableCategory\":\"SupplierEvaluationIndex\",\"datatype\":\"Integer\"},\"type\":\"variable\"},\"value\":{\"content\":\"50\",\"valueType\":\"Input\"},\"file\":\"ComplexScorecard:hdgk/fz,103\",\"necessaryClassList\":[\"com.ruoyi.supplier.domain.SupplierEvaluationIndex\"]},\"nodeType\":\"criteria\"},{\"id\":9,\"rule\":{\"name\":\"cc-r2\",\"file\":\"ComplexScorecard:hdgk/fz,103\",\"rhs\":{\"actions\":[{\"name\":\"scoring_value\",\"value\":{\"content\":\"40\",\"valueType\":\"Input\"},\"actionType\":\"Scoring\",\"rowNumber\":2,\"priority\":0}]},\"loopRule\":false,\"withElse\":false},\"nodeType\":\"terminal\"},{\"id\":7,\"lines\":[{\"fromNodeId\":7,\"toNodeId\":8},{\"fromNodeId\":7,\"toNodeId\":12}],\"debug\":false,\"criteria\":{\"op\":\"GreaterThen\",\"left\":{\"leftPart\":{\"uuid\":\"15d0d5b5-4d02-49e7-a922-13b038ebbd19\",\"categoryUuid\":\"55170ba8-6b28-42b0-ac00-fb773018ea2a\",\"variableName\":\"cooperationDuration\",\"variableLabel\":\"合作时长\",\"variableCategory\":\"SupplierEvaluationIndex\",\"datatype\":\"Integer\"},\"type\":\"variable\"},\"value\":{\"content\":\"300\",\"valueType\":\"Input\"},\"file\":\"ComplexScorecard:hdgk/fz,103\",\"necessaryClassList\":[\"com.ruoyi.supplier.domain.SupplierEvaluationIndex\"]},\"nodeType\":\"criteria\"},{\"id\":8,\"lines\":[{\"fromNodeId\":8,\"toNodeId\":6}],\"debug\":false,\"criteria\":{\"op\":\"LessThenEquals\",\"left\":{\"leftPart\":{\"uuid\":\"92c348ce-fd13-486e-be08-a7c2f8870993\",\"categoryUuid\":\"55170ba8-6b28-42b0-ac00-fb773018ea2a\",\"variableName\":\"orderNum\",\"variableLabel\":\"订单总数\",\"variableCategory\":\"SupplierEvaluationIndex\",\"datatype\":\"Integer\"},\"type\":\"variable\"},\"value\":{\"content\":\"50\",\"valueType\":\"Input\"},\"file\":\"ComplexScorecard:hdgk/fz,103\",\"necessaryClassList\":[\"com.ruoyi.supplier.domain.SupplierEvaluationIndex\"]},\"nodeType\":\"criteria\"},{\"id\":6,\"rule\":{\"name\":\"cc-r1\",\"file\":\"ComplexScorecard:hdgk/fz,103\",\"rhs\":{\"actions\":[{\"name\":\"scoring_value\",\"value\":{\"content\":\"30\",\"valueType\":\"Input\"},\"actionType\":\"Scoring\",\"rowNumber\":1,\"priority\":0}]},\"loopRule\":false,\"withElse\":false},\"nodeType\":\"terminal\"},{\"id\":12,\"lines\":[{\"fromNodeId\":12,\"toNodeId\":11}],\"debug\":false,\"criteria\":{\"op\":\"GreaterThen\",\"left\":{\"leftPart\":{\"uuid\":\"92c348ce-fd13-486e-be08-a7c2f8870993\",\"categoryUuid\":\"55170ba8-6b28-42b0-ac00-fb773018ea2a\",\"variableName\":\"orderNum\",\"variableLabel\":\"订单总数\",\"variableCategory\":\"SupplierEvaluationIndex\",\"datatype\":\"Integer\"},\"type\":\"variable\"},\"value\":{\"content\":\"50\",\"valueType\":\"Input\"},\"file\":\"ComplexScorecard:hdgk/fz,103\",\"necessaryClassList\":[\"com.ruoyi.supplier.domain.SupplierEvaluationIndex\"]},\"nodeType\":\"criteria\"},{\"id\":11,\"rule\":{\"name\":\"cc-r3\",\"file\":\"ComplexScorecard:hdgk/fz,103\",\"rhs\":{\"actions\":[{\"name\":\"scoring_value\",\"value\":{\"content\":\"50\",\"valueType\":\"Input\"},\"actionType\":\"Scoring\",\"rowNumber\":3,\"priority\":0}]},\"loopRule\":false,\"withElse\":false},\"nodeType\":\"terminal\"},{\"id\":14,\"lines\":[{\"fromNodeId\":14,\"toNodeId\":13}],\"debug\":false,\"criteria\":{\"op\":\"LessThenEquals\",\"left\":{\"leftPart\":{\"uuid\":\"2c18ff3c-93e6-40de-b93a-c1232a6a8988\",\"categoryUuid\":\"55170ba8-6b28-42b0-ac00-fb773018ea2a\",\"variableName\":\"paymentCycle\",\"variableLabel\":\"交款周期\",\"variableCategory\":\"SupplierEvaluationIndex\",\"datatype\":\"Integer\"},\"type\":\"variable\"},\"value\":{\"content\":\"7\",\"valueType\":\"Input\"},\"file\":\"ComplexScorecard:hdgk/fz,103\",\"necessaryClassList\":[\"com.ruoyi.supplier.domain.SupplierEvaluationIndex\"]},\"nodeType\":\"criteria\"},{\"id\":13,\"rule\":{\"name\":\"cc-r4\",\"file\":\"ComplexScorecard:hdgk/fz,103\",\"rhs\":{\"actions\":[{\"name\":\"scoring_value\",\"value\":{\"content\":\"50\",\"valueType\":\"Input\"},\"actionType\":\"Scoring\",\"rowNumber\":4,\"priority\":0}]},\"loopRule\":false,\"withElse\":false},\"nodeType\":\"terminal\"},{\"id\":16,\"lines\":[{\"fromNodeId\":16,\"toNodeId\":15}],\"debug\":false,\"criteria\":{\"op\":\"GreaterThen\",\"left\":{\"leftPart\":{\"uuid\":\"2c18ff3c-93e6-40de-b93a-c1232a6a8988\",\"categoryUuid\":\"55170ba8-6b28-42b0-ac00-fb773018ea2a\",\"variableName\":\"paymentCycle\",\"variableLabel\":\"交款周期\",\"variableCategory\":\"SupplierEvaluationIndex\",\"datatype\":\"Integer\"},\"type\":\"variable\"},\"value\":{\"content\":\"7\",\"valueType\":\"Input\"},\"file\":\"ComplexScorecard:hdgk/fz,103\",\"necessaryClassList\":[\"com.ruoyi.supplier.domain.SupplierEvaluationIndex\"]},\"nodeType\":\"criteria\"},{\"id\":15,\"rule\":{\"name\":\"cc-r5\",\"file\":\"ComplexScorecard:hdgk/fz,103\",\"rhs\":{\"actions\":[{\"name\":\"scoring_value\",\"value\":{\"content\":\"20\",\"valueType\":\"Input\"},\"actionType\":\"Scoring\",\"rowNumber\":5,\"priority\":0}]},\"loopRule\":false,\"withElse\":false},\"nodeType\":\"terminal\"}],\"id\":\"7dc30cc7-d8f4-463d-a947-0767e9c4aa33\"}},\"nodeType\":\"terminal\"}],\"id\":\"6650de66-f704-444d-9a49-009b3483887a\"}', '3aa8aff32dc512b871ba53878391b6da', '1.0.0', 'pass', 1, 'admin', '2023-11-28 11:16:29');

-- ----------------------------
-- Table structure for urule_deployed_packet_file
-- ----------------------------
CREATE TABLE `urule_deployed_packet_file`  (
  `ID_` int NOT NULL,
  `DEPLOYED_PACKET_ID_` int NOT NULL DEFAULT 0,
  `PROJECT_ID_` int NOT NULL,
  `FILE_ID_` int NOT NULL DEFAULT 0,
  `DIGEST_` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `PATH_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `VERSION_` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `CONTENT_` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `CREATE_USER_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `CREATE_DATE_` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`ID_`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '已发布知识包从表，记录包含的文件快照' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of urule_deployed_packet_file
-- ----------------------------
INSERT INTO `urule_deployed_packet_file` VALUES (1, 101, 1, 102, '4cba38cb3e654265fae355bd49c9a62c', 'Scorecard:hdgk/supplier', NULL, '<?xml version=\"1.0\" encoding=\"UTF-8\"?><scorecard weight-support=\"true\"  name=\"supplier\" attr-col-width=\"200\" attr-col-name=\"属性\" attr-col-category=\"SupplierEvaluationIndex\"  attr-col-category-uuid=\"55170ba8-6b28-42b0-ac00-fb773018ea2a\" condition-col-width=\"220\" condition-col-name=\"条件\" score-col-width=\"180\" score-col-name=\"分值\" scoring-type=\"weightsum\" assign-target-type=\"variable\"  category-uuid=\"55170ba8-6b28-42b0-ac00-fb773018ea2a\" var-category=\"SupplierEvaluationIndex\" var=\"score\" var-label=\"综合得分\" datatype=\"Integer\" uuid=\"4d12ac01-bb0c-4bab-9aaa-84e61205e0da\"><remark><![CDATA[]]></remark><quick-test-data><![CDATA[{\"input\":[{\"categoryUuid\":\"55170ba8-6b28-42b0-ac00-fb773018ea2a\",\"categoryName\":\"SupplierEvaluationIndex\",\"categoryClass\":\"com.ruoyi.supplier.domain.SupplierEvaluationIndex\",\"fields\":[{\"uuid\":\"15d0d5b5-4d02-49e7-a922-13b038ebbd19\",\"name\":\"cooperationDuration\",\"label\":\"合作时长\",\"type\":\"Integer\",\"value\":\"500\"},{\"uuid\":\"92c348ce-fd13-486e-be08-a7c2f8870993\",\"name\":\"orderNum\",\"label\":\"订单总数\",\"type\":\"Integer\",\"value\":\"60\"},{\"uuid\":\"2c18ff3c-93e6-40de-b93a-c1232a6a8988\",\"name\":\"paymentCycle\",\"label\":\"交款周期\",\"type\":\"Integer\",\"value\":\"5\"}]}],\"output\":[{\"categoryUuid\":\"55170ba8-6b28-42b0-ac00-fb773018ea2a\",\"categoryName\":\"SupplierEvaluationIndex\",\"categoryClass\":\"com.ruoyi.supplier.domain.SupplierEvaluationIndex\",\"fields\":[{\"uuid\":\"4d12ac01-bb0c-4bab-9aaa-84e61205e0da\",\"name\":\"score\",\"label\":\"综合得分\",\"type\":\"Integer\"}]}]}]]></quick-test-data><import-variable-library id=\"101\" path=\"VariableLibrary:/供应商评价/SupplierEvaluationIndex\"/><card-cell type=\"attribute\" row=\"2\" col=\"1\" weight=\"0.2\" var=\"cooperationDuration\" var-label=\"合作时长\" uuid=\"15d0d5b5-4d02-49e7-a922-13b038ebbd19\" datatype=\"Integer\"></card-cell><card-cell type=\"condition\" row=\"2\" col=\"2\"><joint type=\"and\"><condition op=\"LessThenEquals\"><value  content=\"365\" type=\"Input\" ></value></condition></joint></card-cell><card-cell type=\"score\" row=\"2\" col=\"3\"><value  content=\"20\" type=\"Input\" ></value></card-cell><card-cell type=\"condition\" row=\"3\" col=\"2\"><joint type=\"and\"><condition op=\"GreaterThen\"><value  content=\"365\" type=\"Input\" ></value></condition><condition op=\"LessThenEquals\"><value  content=\"730\" type=\"Input\" ></value></condition></joint></card-cell><card-cell type=\"score\" row=\"3\" col=\"3\"><value  content=\"40\" type=\"Input\" ></value></card-cell><card-cell type=\"condition\" row=\"4\" col=\"2\"><joint type=\"and\"><condition op=\"GreaterThen\"><value  content=\"730\" type=\"Input\" ></value></condition><condition op=\"LessThenEquals\"><value  content=\"1825\" type=\"Input\" ></value></condition></joint></card-cell><card-cell type=\"score\" row=\"4\" col=\"3\"><value  content=\"60\" type=\"Input\" ></value></card-cell><card-cell type=\"condition\" row=\"5\" col=\"2\"><joint type=\"and\"><condition op=\"GreaterThen\"><value  content=\"1825\" type=\"Input\" ></value></condition></joint></card-cell><card-cell type=\"score\" row=\"5\" col=\"3\"><value  content=\"100\" type=\"Input\" ></value></card-cell><card-cell type=\"attribute\" row=\"6\" col=\"1\" weight=\"0.2\" var=\"orderNum\" var-label=\"订单总数\" uuid=\"92c348ce-fd13-486e-be08-a7c2f8870993\" datatype=\"Integer\"></card-cell><card-cell type=\"condition\" row=\"6\" col=\"2\"><joint type=\"and\"><condition op=\"LessThenEquals\"><value  content=\"50\" type=\"Input\" ></value></condition></joint></card-cell><card-cell type=\"score\" row=\"6\" col=\"3\"><value  content=\"20\" type=\"Input\" ></value></card-cell><card-cell type=\"condition\" row=\"7\" col=\"2\"><joint type=\"and\"><condition op=\"GreaterThen\"><value  content=\"50\" type=\"Input\" ></value></condition><condition op=\"LessThenEquals\"><value  content=\"100\" type=\"Input\" ></value></condition></joint></card-cell><card-cell type=\"score\" row=\"7\" col=\"3\"><value  content=\"60\" type=\"Input\" ></value></card-cell><card-cell type=\"condition\" row=\"8\" col=\"2\"><joint type=\"and\"><condition op=\"GreaterThen\"><value  content=\"100\" type=\"Input\" ></value></condition></joint></card-cell><card-cell type=\"score\" row=\"8\" col=\"3\"><value  content=\"100\" type=\"Input\" ></value></card-cell><card-cell type=\"attribute\" row=\"9\" col=\"1\" weight=\"0.6\" var=\"paymentCycle\" var-label=\"交款周期\" uuid=\"2c18ff3c-93e6-40de-b93a-c1232a6a8988\" datatype=\"Integer\"></card-cell><card-cell type=\"condition\" row=\"9\" col=\"2\"><joint type=\"and\"><condition op=\"LessThenEquals\"><value  content=\"7\" type=\"Input\" ></value></condition></joint></card-cell><card-cell type=\"score\" row=\"9\" col=\"3\"><value  content=\"100\" type=\"Input\" ></value></card-cell><card-cell type=\"condition\" row=\"10\" col=\"2\"><joint type=\"and\"><condition op=\"GreaterThen\"><value  content=\"7\" type=\"Input\" ></value></condition><condition op=\"LessThenEquals\"><value  content=\"14\" type=\"Input\" ></value></condition></joint></card-cell><card-cell type=\"score\" row=\"10\" col=\"3\"><value  content=\"60\" type=\"Input\" ></value></card-cell><card-cell type=\"condition\" row=\"11\" col=\"2\"><joint type=\"and\"><condition op=\"GreaterThen\"><value  content=\"14\" type=\"Input\" ></value></condition></joint></card-cell><card-cell type=\"score\" row=\"11\" col=\"3\"><value  content=\"40\" type=\"Input\" ></value></card-cell><attribute-row row-number=\"2\"><condition-row row-number=\"3\"></condition-row><condition-row row-number=\"4\"></condition-row><condition-row row-number=\"5\"></condition-row></attribute-row><attribute-row row-number=\"6\"><condition-row row-number=\"7\"></condition-row><condition-row row-number=\"8\"></condition-row></attribute-row><attribute-row row-number=\"9\"><condition-row row-number=\"10\"></condition-row><condition-row row-number=\"11\"></condition-row></attribute-row></scorecard>', 'admin', '2023-11-27 10:43:53');
INSERT INTO `urule_deployed_packet_file` VALUES (101, 302, 1, 103, 'd3a70885b5c4518749e9bf8584044c2d', 'ComplexScorecard:hdgk/fz', NULL, '<?xml version=\"1.0\" encoding=\"UTF-8\"?><complex-scorecard  scoring-type=\"sum\" assign-target-type=\"variable\"  category-uuid=\"55170ba8-6b28-42b0-ac00-fb773018ea2a\" var-category=\"SupplierEvaluationIndex\" var=\"score\" var-label=\"综合得分\" datatype=\"Integer\" uuid=\"4d12ac01-bb0c-4bab-9aaa-84e61205e0da\"><remark><![CDATA[]]></remark><quick-test-data><![CDATA[{\"input\":[{\"categoryUuid\":\"55170ba8-6b28-42b0-ac00-fb773018ea2a\",\"categoryName\":\"SupplierEvaluationIndex\",\"categoryClass\":\"com.ruoyi.supplier.domain.SupplierEvaluationIndex\",\"fields\":[{\"uuid\":\"15d0d5b5-4d02-49e7-a922-13b038ebbd19\",\"name\":\"cooperationDuration\",\"label\":\"合作时长\",\"type\":\"Integer\",\"value\":\"301\"},{\"uuid\":\"92c348ce-fd13-486e-be08-a7c2f8870993\",\"name\":\"orderNum\",\"label\":\"订单总数\",\"type\":\"Integer\",\"value\":\"30\"},{\"uuid\":\"2c18ff3c-93e6-40de-b93a-c1232a6a8988\",\"name\":\"paymentCycle\",\"label\":\"交款周期\",\"type\":\"Integer\",\"value\":\"7\"}]}],\"output\":[{\"categoryUuid\":\"55170ba8-6b28-42b0-ac00-fb773018ea2a\",\"categoryName\":\"SupplierEvaluationIndex\",\"categoryClass\":\"com.ruoyi.supplier.domain.SupplierEvaluationIndex\",\"fields\":[{\"uuid\":\"4d12ac01-bb0c-4bab-9aaa-84e61205e0da\",\"name\":\"score\",\"label\":\"综合得分\",\"type\":\"Integer\"}]}]}]]></quick-test-data><import-variable-library id=\"101\" path=\"VariableLibrary:/供应商评价/SupplierEvaluationIndex\"/><row num=\"0\" height=\"30\"/><row num=\"1\" height=\"30\"/><row num=\"2\" height=\"30\"/><row num=\"3\" height=\"30\"/><row num=\"4\" height=\"30\"/><row num=\"5\" height=\"30\"/><col num=\"0\" width=\"207.469\" type=\"Criteria\" uuid=\"55170ba8-6b28-42b0-ac00-fb773018ea2a\" var-category=\"SupplierEvaluationIndex\"/><col num=\"1\" width=\"245.469\" type=\"Criteria\" uuid=\"55170ba8-6b28-42b0-ac00-fb773018ea2a\" var-category=\"SupplierEvaluationIndex\"/><col num=\"2\" width=\"120\" type=\"Score\"/><cell row=\"0\" col=\"0\" rowspan=\"1\" var-label=\"合作时长\" var=\"cooperationDuration\" datatype=\"Integer\" uuid=\"15d0d5b5-4d02-49e7-a922-13b038ebbd19\"><joint type=\"and\"><condition op=\"LessThenEquals\"><value  content=\"300\" type=\"Input\" ></value></condition></joint></cell><cell row=\"0\" col=\"1\" rowspan=\"1\" var-label=\"订单总数\" var=\"orderNum\" datatype=\"Integer\" uuid=\"92c348ce-fd13-486e-be08-a7c2f8870993\"><joint type=\"and\"><condition op=\"LessThenEquals\"><value  content=\"50\" type=\"Input\" ></value></condition></joint></cell><cell row=\"0\" col=\"2\" rowspan=\"1\"><value  content=\"20\" type=\"Input\" ></value></cell><cell row=\"1\" col=\"0\" rowspan=\"1\" var-label=\"合作时长\" var=\"cooperationDuration\" datatype=\"Integer\" uuid=\"15d0d5b5-4d02-49e7-a922-13b038ebbd19\"><joint type=\"and\"><condition op=\"GreaterThen\"><value  content=\"300\" type=\"Input\" ></value></condition></joint></cell><cell row=\"1\" col=\"1\" rowspan=\"1\" var-label=\"订单总数\" var=\"orderNum\" datatype=\"Integer\" uuid=\"92c348ce-fd13-486e-be08-a7c2f8870993\"><joint type=\"and\"><condition op=\"LessThenEquals\"><value  content=\"50\" type=\"Input\" ></value></condition></joint></cell><cell row=\"1\" col=\"2\" rowspan=\"1\"><value  content=\"30\" type=\"Input\" ></value></cell><cell row=\"2\" col=\"0\" rowspan=\"1\" var-label=\"合作时长\" var=\"cooperationDuration\" datatype=\"Integer\" uuid=\"15d0d5b5-4d02-49e7-a922-13b038ebbd19\"><joint type=\"and\"><condition op=\"LessThenEquals\"><value  content=\"300\" type=\"Input\" ></value></condition></joint></cell><cell row=\"2\" col=\"1\" rowspan=\"1\" var-label=\"订单总数\" var=\"orderNum\" datatype=\"Integer\" uuid=\"92c348ce-fd13-486e-be08-a7c2f8870993\"><joint type=\"and\"><condition op=\"GreaterThen\"><value  content=\"50\" type=\"Input\" ></value></condition></joint></cell><cell row=\"2\" col=\"2\" rowspan=\"1\"><value  content=\"40\" type=\"Input\" ></value></cell><cell row=\"3\" col=\"0\" rowspan=\"1\" var-label=\"合作时长\" var=\"cooperationDuration\" datatype=\"Integer\" uuid=\"15d0d5b5-4d02-49e7-a922-13b038ebbd19\"><joint type=\"and\"><condition op=\"GreaterThen\"><value  content=\"300\" type=\"Input\" ></value></condition></joint></cell><cell row=\"3\" col=\"1\" rowspan=\"1\" var-label=\"订单总数\" var=\"orderNum\" datatype=\"Integer\" uuid=\"92c348ce-fd13-486e-be08-a7c2f8870993\"><joint type=\"and\"><condition op=\"GreaterThen\"><value  content=\"50\" type=\"Input\" ></value></condition></joint></cell><cell row=\"3\" col=\"2\" rowspan=\"1\"><value  content=\"50\" type=\"Input\" ></value></cell><cell row=\"4\" col=\"0\" rowspan=\"1\" var-label=\"交款周期\" var=\"paymentCycle\" datatype=\"Integer\" uuid=\"2c18ff3c-93e6-40de-b93a-c1232a6a8988\"><joint type=\"and\"><condition op=\"LessThenEquals\"><value  content=\"7\" type=\"Input\" ></value></condition></joint></cell><cell row=\"4\" col=\"1\" rowspan=\"1\" var-label=\"交款周期\" var=\"paymentCycle\" datatype=\"Integer\" uuid=\"2c18ff3c-93e6-40de-b93a-c1232a6a8988\"></cell><cell row=\"4\" col=\"2\" rowspan=\"1\"><value  content=\"50\" type=\"Input\" ></value></cell><cell row=\"5\" col=\"0\" rowspan=\"1\" var-label=\"交款周期\" var=\"paymentCycle\" datatype=\"Integer\" uuid=\"2c18ff3c-93e6-40de-b93a-c1232a6a8988\"><joint type=\"and\"><condition op=\"GreaterThen\"><value  content=\"7\" type=\"Input\" ></value></condition></joint></cell><cell row=\"5\" col=\"1\" rowspan=\"1\" var-label=\"交款周期\" var=\"paymentCycle\" datatype=\"Integer\" uuid=\"2c18ff3c-93e6-40de-b93a-c1232a6a8988\"></cell><cell row=\"5\" col=\"2\" rowspan=\"1\"><value  content=\"20\" type=\"Input\" ></value></cell></complex-scorecard>', 'admin', '2023-11-28 11:16:29');

-- ----------------------------
-- Table structure for urule_dynamic_jar
-- ----------------------------
CREATE TABLE `urule_dynamic_jar`  (
  `ID_` int NOT NULL,
  `DESC_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `NAME_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `GROUP_ID_` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `JAR_` mediumblob NULL,
  `CREATE_USER_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `UPDATE_USER_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `CREATE_DATE_` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `UPDATE_DATE_` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`ID_`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '动态JAR文件存储表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of urule_dynamic_jar
-- ----------------------------

-- ----------------------------
-- Table structure for urule_file
-- ----------------------------
CREATE TABLE `urule_file`  (
  `ID_` int NOT NULL,
  `NAME_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `TYPE_` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `LATEST_VERSION_` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `PACKAGE_ID_` int NOT NULL DEFAULT 0,
  `PROJECT_ID_` int NOT NULL DEFAULT 0,
  `CONTENT_` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `DIGEST_` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `LOCKED_USER_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `CREATE_USER_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `UPDATE_USER_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `CREATE_DATE_` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `UPDATE_DATE_` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `DELETED_` tinyint NOT NULL DEFAULT 0,
  PRIMARY KEY (`ID_`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '文件' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of urule_file
-- ----------------------------
INSERT INTO `urule_file` VALUES (1, '供应商评价指标', 'VariableLibrary', NULL, 0, 1, '<?xml version=\"1.0\" encoding=\"UTF-8\"?>\r\n<variable-library>\r\n</variable-library>', NULL, NULL, 'admin', 'admin', '2023-11-24 13:40:56', '2023-11-24 00:00:00', 1);
INSERT INTO `urule_file` VALUES (101, 'SupplierEvaluationIndex', 'VariableLibrary', NULL, 0, 1, '<?xml version=\"1.0\" encoding=\"utf-8\"?><variable-library><category uuid=\"55170ba8-6b28-42b0-ac00-fb773018ea2a\" name=\"SupplierEvaluationIndex\" type=\"Custom\" act=\"InOut\" clazz=\"com.ruoyi.supplier.domain.SupplierEvaluationIndex\"><var uuid=\"15d0d5b5-4d02-49e7-a922-13b038ebbd19\" name=\"cooperationDuration\" label=\"合作时长\" \n            type=\"Integer\" act=\"InOut\" default-value=\"\"/><var uuid=\"92c348ce-fd13-486e-be08-a7c2f8870993\" name=\"orderNum\" label=\"订单总数\" \n            type=\"Integer\" act=\"InOut\" default-value=\"\"/><var uuid=\"2c18ff3c-93e6-40de-b93a-c1232a6a8988\" name=\"paymentCycle\" label=\"交款周期\" \n            type=\"Integer\" act=\"InOut\" default-value=\"\"/><var uuid=\"4d12ac01-bb0c-4bab-9aaa-84e61205e0da\" name=\"score\" label=\"综合得分\" \n            type=\"Integer\" act=\"InOut\" default-value=\"\"/></category></variable-library>', 'f9e059dd8e04a1daeb67835def535740', 'admin', 'admin', 'admin', '2023-11-24 14:33:36', '2023-11-24 14:34:44', 0);
INSERT INTO `urule_file` VALUES (102, 'supplier', 'Scorecard', NULL, 0, 1, '<?xml version=\"1.0\" encoding=\"UTF-8\"?><scorecard weight-support=\"true\"  name=\"supplier\" attr-col-width=\"200\" attr-col-name=\"属性\" attr-col-category=\"SupplierEvaluationIndex\"  attr-col-category-uuid=\"55170ba8-6b28-42b0-ac00-fb773018ea2a\" condition-col-width=\"220\" condition-col-name=\"条件\" score-col-width=\"180\" score-col-name=\"分值\" scoring-type=\"weightsum\" assign-target-type=\"variable\"  category-uuid=\"55170ba8-6b28-42b0-ac00-fb773018ea2a\" var-category=\"SupplierEvaluationIndex\" var=\"score\" var-label=\"综合得分\" datatype=\"Integer\" uuid=\"4d12ac01-bb0c-4bab-9aaa-84e61205e0da\"><remark><![CDATA[]]></remark><quick-test-data><![CDATA[{\"input\":[{\"categoryUuid\":\"55170ba8-6b28-42b0-ac00-fb773018ea2a\",\"categoryName\":\"SupplierEvaluationIndex\",\"categoryClass\":\"com.ruoyi.supplier.domain.SupplierEvaluationIndex\",\"fields\":[{\"uuid\":\"15d0d5b5-4d02-49e7-a922-13b038ebbd19\",\"name\":\"cooperationDuration\",\"label\":\"合作时长\",\"type\":\"Integer\",\"value\":\"500\"},{\"uuid\":\"92c348ce-fd13-486e-be08-a7c2f8870993\",\"name\":\"orderNum\",\"label\":\"订单总数\",\"type\":\"Integer\",\"value\":\"60\"},{\"uuid\":\"2c18ff3c-93e6-40de-b93a-c1232a6a8988\",\"name\":\"paymentCycle\",\"label\":\"交款周期\",\"type\":\"Integer\",\"value\":\"5\"}]}],\"output\":[{\"categoryUuid\":\"55170ba8-6b28-42b0-ac00-fb773018ea2a\",\"categoryName\":\"SupplierEvaluationIndex\",\"categoryClass\":\"com.ruoyi.supplier.domain.SupplierEvaluationIndex\",\"fields\":[{\"uuid\":\"4d12ac01-bb0c-4bab-9aaa-84e61205e0da\",\"name\":\"score\",\"label\":\"综合得分\",\"type\":\"Integer\"}]}]}]]></quick-test-data><import-variable-library id=\"101\" path=\"VariableLibrary:/供应商评价/SupplierEvaluationIndex\"/><card-cell type=\"attribute\" row=\"2\" col=\"1\" weight=\"0.2\" var=\"cooperationDuration\" var-label=\"合作时长\" uuid=\"15d0d5b5-4d02-49e7-a922-13b038ebbd19\" datatype=\"Integer\"></card-cell><card-cell type=\"condition\" row=\"2\" col=\"2\"><joint type=\"and\"><condition op=\"LessThenEquals\"><value  content=\"365\" type=\"Input\" ></value></condition></joint></card-cell><card-cell type=\"score\" row=\"2\" col=\"3\"><value  content=\"20\" type=\"Input\" ></value></card-cell><card-cell type=\"condition\" row=\"3\" col=\"2\"><joint type=\"and\"><condition op=\"GreaterThen\"><value  content=\"365\" type=\"Input\" ></value></condition><condition op=\"LessThenEquals\"><value  content=\"730\" type=\"Input\" ></value></condition></joint></card-cell><card-cell type=\"score\" row=\"3\" col=\"3\"><value  content=\"40\" type=\"Input\" ></value></card-cell><card-cell type=\"condition\" row=\"4\" col=\"2\"><joint type=\"and\"><condition op=\"GreaterThen\"><value  content=\"730\" type=\"Input\" ></value></condition><condition op=\"LessThenEquals\"><value  content=\"1825\" type=\"Input\" ></value></condition></joint></card-cell><card-cell type=\"score\" row=\"4\" col=\"3\"><value  content=\"60\" type=\"Input\" ></value></card-cell><card-cell type=\"condition\" row=\"5\" col=\"2\"><joint type=\"and\"><condition op=\"GreaterThen\"><value  content=\"1825\" type=\"Input\" ></value></condition></joint></card-cell><card-cell type=\"score\" row=\"5\" col=\"3\"><value  content=\"100\" type=\"Input\" ></value></card-cell><card-cell type=\"attribute\" row=\"6\" col=\"1\" weight=\"0.2\" var=\"orderNum\" var-label=\"订单总数\" uuid=\"92c348ce-fd13-486e-be08-a7c2f8870993\" datatype=\"Integer\"></card-cell><card-cell type=\"condition\" row=\"6\" col=\"2\"><joint type=\"and\"><condition op=\"LessThenEquals\"><value  content=\"50\" type=\"Input\" ></value></condition></joint></card-cell><card-cell type=\"score\" row=\"6\" col=\"3\"><value  content=\"20\" type=\"Input\" ></value></card-cell><card-cell type=\"condition\" row=\"7\" col=\"2\"><joint type=\"and\"><condition op=\"GreaterThen\"><value  content=\"50\" type=\"Input\" ></value></condition><condition op=\"LessThenEquals\"><value  content=\"100\" type=\"Input\" ></value></condition></joint></card-cell><card-cell type=\"score\" row=\"7\" col=\"3\"><value  content=\"60\" type=\"Input\" ></value></card-cell><card-cell type=\"condition\" row=\"8\" col=\"2\"><joint type=\"and\"><condition op=\"GreaterThen\"><value  content=\"100\" type=\"Input\" ></value></condition></joint></card-cell><card-cell type=\"score\" row=\"8\" col=\"3\"><value  content=\"100\" type=\"Input\" ></value></card-cell><card-cell type=\"attribute\" row=\"9\" col=\"1\" weight=\"0.6\" var=\"paymentCycle\" var-label=\"交款周期\" uuid=\"2c18ff3c-93e6-40de-b93a-c1232a6a8988\" datatype=\"Integer\"></card-cell><card-cell type=\"condition\" row=\"9\" col=\"2\"><joint type=\"and\"><condition op=\"LessThenEquals\"><value  content=\"7\" type=\"Input\" ></value></condition></joint></card-cell><card-cell type=\"score\" row=\"9\" col=\"3\"><value  content=\"100\" type=\"Input\" ></value></card-cell><card-cell type=\"condition\" row=\"10\" col=\"2\"><joint type=\"and\"><condition op=\"GreaterThen\"><value  content=\"7\" type=\"Input\" ></value></condition><condition op=\"LessThenEquals\"><value  content=\"14\" type=\"Input\" ></value></condition></joint></card-cell><card-cell type=\"score\" row=\"10\" col=\"3\"><value  content=\"60\" type=\"Input\" ></value></card-cell><card-cell type=\"condition\" row=\"11\" col=\"2\"><joint type=\"and\"><condition op=\"GreaterThen\"><value  content=\"14\" type=\"Input\" ></value></condition></joint></card-cell><card-cell type=\"score\" row=\"11\" col=\"3\"><value  content=\"40\" type=\"Input\" ></value></card-cell><attribute-row row-number=\"2\"><condition-row row-number=\"3\"></condition-row><condition-row row-number=\"4\"></condition-row><condition-row row-number=\"5\"></condition-row></attribute-row><attribute-row row-number=\"6\"><condition-row row-number=\"7\"></condition-row><condition-row row-number=\"8\"></condition-row></attribute-row><attribute-row row-number=\"9\"><condition-row row-number=\"10\"></condition-row><condition-row row-number=\"11\"></condition-row></attribute-row></scorecard>', '4cba38cb3e654265fae355bd49c9a62c', 'admin', 'admin', 'admin', '2023-11-24 14:36:31', '2023-11-24 14:59:35', 0);
INSERT INTO `urule_file` VALUES (103, 'fz', 'ComplexScorecard', NULL, 0, 1, '<?xml version=\"1.0\" encoding=\"UTF-8\"?><complex-scorecard  scoring-type=\"sum\" assign-target-type=\"variable\"  category-uuid=\"55170ba8-6b28-42b0-ac00-fb773018ea2a\" var-category=\"SupplierEvaluationIndex\" var=\"score\" var-label=\"综合得分\" datatype=\"Integer\" uuid=\"4d12ac01-bb0c-4bab-9aaa-84e61205e0da\"><remark><![CDATA[]]></remark><quick-test-data><![CDATA[{\"input\":[{\"categoryUuid\":\"55170ba8-6b28-42b0-ac00-fb773018ea2a\",\"categoryName\":\"SupplierEvaluationIndex\",\"categoryClass\":\"com.ruoyi.supplier.domain.SupplierEvaluationIndex\",\"fields\":[{\"uuid\":\"15d0d5b5-4d02-49e7-a922-13b038ebbd19\",\"name\":\"cooperationDuration\",\"label\":\"合作时长\",\"type\":\"Integer\",\"value\":\"301\"},{\"uuid\":\"92c348ce-fd13-486e-be08-a7c2f8870993\",\"name\":\"orderNum\",\"label\":\"订单总数\",\"type\":\"Integer\",\"value\":\"30\"},{\"uuid\":\"2c18ff3c-93e6-40de-b93a-c1232a6a8988\",\"name\":\"paymentCycle\",\"label\":\"交款周期\",\"type\":\"Integer\",\"value\":\"7\"}]}],\"output\":[{\"categoryUuid\":\"55170ba8-6b28-42b0-ac00-fb773018ea2a\",\"categoryName\":\"SupplierEvaluationIndex\",\"categoryClass\":\"com.ruoyi.supplier.domain.SupplierEvaluationIndex\",\"fields\":[{\"uuid\":\"4d12ac01-bb0c-4bab-9aaa-84e61205e0da\",\"name\":\"score\",\"label\":\"综合得分\",\"type\":\"Integer\"}]}]}]]></quick-test-data><import-variable-library id=\"101\" path=\"VariableLibrary:/供应商评价/SupplierEvaluationIndex\"/><row num=\"0\" height=\"30\"/><row num=\"1\" height=\"30\"/><row num=\"2\" height=\"30\"/><row num=\"3\" height=\"30\"/><row num=\"4\" height=\"30\"/><row num=\"5\" height=\"30\"/><col num=\"0\" width=\"207.469\" type=\"Criteria\" uuid=\"55170ba8-6b28-42b0-ac00-fb773018ea2a\" var-category=\"SupplierEvaluationIndex\"/><col num=\"1\" width=\"245.469\" type=\"Criteria\" uuid=\"55170ba8-6b28-42b0-ac00-fb773018ea2a\" var-category=\"SupplierEvaluationIndex\"/><col num=\"2\" width=\"120\" type=\"Score\"/><cell row=\"0\" col=\"0\" rowspan=\"1\" var-label=\"合作时长\" var=\"cooperationDuration\" datatype=\"Integer\" uuid=\"15d0d5b5-4d02-49e7-a922-13b038ebbd19\"><joint type=\"and\"><condition op=\"LessThenEquals\"><value  content=\"300\" type=\"Input\" ></value></condition></joint></cell><cell row=\"0\" col=\"1\" rowspan=\"1\" var-label=\"订单总数\" var=\"orderNum\" datatype=\"Integer\" uuid=\"92c348ce-fd13-486e-be08-a7c2f8870993\"><joint type=\"and\"><condition op=\"LessThenEquals\"><value  content=\"50\" type=\"Input\" ></value></condition></joint></cell><cell row=\"0\" col=\"2\" rowspan=\"1\"><value  content=\"20\" type=\"Input\" ></value></cell><cell row=\"1\" col=\"0\" rowspan=\"1\" var-label=\"合作时长\" var=\"cooperationDuration\" datatype=\"Integer\" uuid=\"15d0d5b5-4d02-49e7-a922-13b038ebbd19\"><joint type=\"and\"><condition op=\"GreaterThen\"><value  content=\"300\" type=\"Input\" ></value></condition></joint></cell><cell row=\"1\" col=\"1\" rowspan=\"1\" var-label=\"订单总数\" var=\"orderNum\" datatype=\"Integer\" uuid=\"92c348ce-fd13-486e-be08-a7c2f8870993\"><joint type=\"and\"><condition op=\"LessThenEquals\"><value  content=\"50\" type=\"Input\" ></value></condition></joint></cell><cell row=\"1\" col=\"2\" rowspan=\"1\"><value  content=\"30\" type=\"Input\" ></value></cell><cell row=\"2\" col=\"0\" rowspan=\"1\" var-label=\"合作时长\" var=\"cooperationDuration\" datatype=\"Integer\" uuid=\"15d0d5b5-4d02-49e7-a922-13b038ebbd19\"><joint type=\"and\"><condition op=\"LessThenEquals\"><value  content=\"300\" type=\"Input\" ></value></condition></joint></cell><cell row=\"2\" col=\"1\" rowspan=\"1\" var-label=\"订单总数\" var=\"orderNum\" datatype=\"Integer\" uuid=\"92c348ce-fd13-486e-be08-a7c2f8870993\"><joint type=\"and\"><condition op=\"GreaterThen\"><value  content=\"50\" type=\"Input\" ></value></condition></joint></cell><cell row=\"2\" col=\"2\" rowspan=\"1\"><value  content=\"40\" type=\"Input\" ></value></cell><cell row=\"3\" col=\"0\" rowspan=\"1\" var-label=\"合作时长\" var=\"cooperationDuration\" datatype=\"Integer\" uuid=\"15d0d5b5-4d02-49e7-a922-13b038ebbd19\"><joint type=\"and\"><condition op=\"GreaterThen\"><value  content=\"300\" type=\"Input\" ></value></condition></joint></cell><cell row=\"3\" col=\"1\" rowspan=\"1\" var-label=\"订单总数\" var=\"orderNum\" datatype=\"Integer\" uuid=\"92c348ce-fd13-486e-be08-a7c2f8870993\"><joint type=\"and\"><condition op=\"GreaterThen\"><value  content=\"50\" type=\"Input\" ></value></condition></joint></cell><cell row=\"3\" col=\"2\" rowspan=\"1\"><value  content=\"50\" type=\"Input\" ></value></cell><cell row=\"4\" col=\"0\" rowspan=\"1\" var-label=\"交款周期\" var=\"paymentCycle\" datatype=\"Integer\" uuid=\"2c18ff3c-93e6-40de-b93a-c1232a6a8988\"><joint type=\"and\"><condition op=\"LessThenEquals\"><value  content=\"7\" type=\"Input\" ></value></condition></joint></cell><cell row=\"4\" col=\"1\" rowspan=\"1\" var-label=\"交款周期\" var=\"paymentCycle\" datatype=\"Integer\" uuid=\"2c18ff3c-93e6-40de-b93a-c1232a6a8988\"></cell><cell row=\"4\" col=\"2\" rowspan=\"1\"><value  content=\"50\" type=\"Input\" ></value></cell><cell row=\"5\" col=\"0\" rowspan=\"1\" var-label=\"交款周期\" var=\"paymentCycle\" datatype=\"Integer\" uuid=\"2c18ff3c-93e6-40de-b93a-c1232a6a8988\"><joint type=\"and\"><condition op=\"GreaterThen\"><value  content=\"7\" type=\"Input\" ></value></condition></joint></cell><cell row=\"5\" col=\"1\" rowspan=\"1\" var-label=\"交款周期\" var=\"paymentCycle\" datatype=\"Integer\" uuid=\"2c18ff3c-93e6-40de-b93a-c1232a6a8988\"></cell><cell row=\"5\" col=\"2\" rowspan=\"1\"><value  content=\"20\" type=\"Input\" ></value></cell></complex-scorecard>', 'd3a70885b5c4518749e9bf8584044c2d', 'admin', 'admin', 'admin', '2023-11-24 16:07:06', '2023-11-24 16:21:05', 0);

-- ----------------------------
-- Table structure for urule_group
-- ----------------------------
CREATE TABLE `urule_group`  (
  `ID_` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `NAME_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `DESC_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `CREATE_USER_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `UPDATE_USER_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `CREATE_DATE_` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `UPDATE_DATE_` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`ID_`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '团队' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of urule_group
-- ----------------------------
INSERT INTO `urule_group` VALUES ('hdgk_1124', '华东工控', '测试', 'admin', NULL, '2023-11-24 13:37:56', '2023-11-24 05:37:56');

-- ----------------------------
-- Table structure for urule_group_role
-- ----------------------------
CREATE TABLE `urule_group_role`  (
  `ID_` int NOT NULL,
  `NAME_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `TYPE_` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `GROUP_ID_` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `CREATE_USER_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `UPDATE_USER_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `CREATE_DATE_` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `UPDATE_DATE_` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`ID_`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '团队角色' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of urule_group_role
-- ----------------------------
INSERT INTO `urule_group_role` VALUES (1, 'Owner', 'system', 'hdgk_1124', 'admin', NULL, '2023-11-24 13:37:56', '2023-11-24 13:37:56');
INSERT INTO `urule_group_role` VALUES (2, 'Manager', 'system', 'hdgk_1124', 'admin', NULL, '2023-11-24 13:37:56', '2023-11-24 13:37:56');
INSERT INTO `urule_group_role` VALUES (3, 'User', 'system', 'hdgk_1124', 'admin', NULL, '2023-11-24 13:37:57', '2023-11-24 13:37:57');

-- ----------------------------
-- Table structure for urule_group_user
-- ----------------------------
CREATE TABLE `urule_group_user`  (
  `ID_` int NOT NULL,
  `USER_ID_` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `USER_NAME_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `GROUP_ID_` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `CREATE_DATE_` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`ID_`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '团队用户' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of urule_group_user
-- ----------------------------
INSERT INTO `urule_group_user` VALUES (1, 'admin', 'admin', 'hdgk_1124', '2023-11-24 05:37:56');

-- ----------------------------
-- Table structure for urule_group_user_role
-- ----------------------------
CREATE TABLE `urule_group_user_role`  (
  `ID_` int NOT NULL,
  `GROUP_ID_` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `USER_ID_` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `ROLE_ID_` int NOT NULL,
  PRIMARY KEY (`ID_`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '用户团队角色关系表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of urule_group_user_role
-- ----------------------------
INSERT INTO `urule_group_user_role` VALUES (1, 'hdgk_1124', 'admin', 1);

-- ----------------------------
-- Table structure for urule_invite
-- ----------------------------
CREATE TABLE `urule_invite`  (
  `ID_` int NOT NULL,
  `GROUP_ID_` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `TYPE_` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `SECRET_KEY_` varchar(6) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `EXPIR_DATE_` datetime NULL DEFAULT CURRENT_TIMESTAMP,
  `CREATE_USER_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `CREATE_DATE_` datetime NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`ID_`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '邀请表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of urule_invite
-- ----------------------------

-- ----------------------------
-- Table structure for urule_log_batch
-- ----------------------------
CREATE TABLE `urule_log_batch`  (
  `ID_` int NOT NULL,
  `USER_` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `IP_` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `USER_AGENT_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `BATCH_ID_` int NOT NULL,
  `BATCH_NAME_` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `STATUS_` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `READ_COUNT_` int NULL DEFAULT NULL,
  `FILTER_COUNT_` int NULL DEFAULT NULL,
  `ITEM_DATA_` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL,
  `IN_PARAMS_` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL,
  `PACKET_ID_` int NULL DEFAULT NULL,
  `PACKET_PARAMS_` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL,
  `START_TIME_` datetime NULL DEFAULT CURRENT_TIMESTAMP,
  `END_TIME_` datetime NULL DEFAULT CURRENT_TIMESTAMP,
  `TIME_` int NULL DEFAULT NULL,
  `MSG_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `DETAIL_` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL,
  `GROUP_ID_` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `GROUP_NAME_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `PROJECT_ID_` int NOT NULL,
  `PROJECT_NAME_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `CREATE_DATE_` datetime NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`ID_`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '批处理执行日志表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of urule_log_batch
-- ----------------------------

-- ----------------------------
-- Table structure for urule_log_batch_skip
-- ----------------------------
CREATE TABLE `urule_log_batch_skip`  (
  `ID_` int NOT NULL,
  `BATCH_ID_` int NOT NULL,
  `LOG_ID_` int NOT NULL,
  `TYPE_` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `MSG_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `DETAIL_` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL,
  `DATA_` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL,
  `GROUP_ID_` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `PROJECT_ID_` int NOT NULL,
  `CREATE_DATE_` datetime NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`ID_`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '批处理执行异常日志表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of urule_log_batch_skip
-- ----------------------------

-- ----------------------------
-- Table structure for urule_log_knowledge
-- ----------------------------
CREATE TABLE `urule_log_knowledge`  (
  `ID_` int NOT NULL,
  `USER_` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `IP_` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `USER_AGENT_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `KNOWLEDGE_ID_` int NULL DEFAULT NULL,
  `KNOWLEDGE_NAME_` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `VERSION_` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `IN_PARAMS_` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL,
  `OUT_PARAMS_` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL,
  `LOGS_` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL,
  `START_TIME_` datetime NULL DEFAULT CURRENT_TIMESTAMP,
  `END_TIME_` datetime NULL DEFAULT CURRENT_TIMESTAMP,
  `TIME_` int NULL DEFAULT NULL,
  `GROUP_ID_` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `GROUP_NAME_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `PROJECT_ID_` int NOT NULL,
  `PROJECT_NAME_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `CREATE_DATE_` datetime NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`ID_`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '规则执行日志表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of urule_log_knowledge
-- ----------------------------

-- ----------------------------
-- Table structure for urule_log_operation
-- ----------------------------
CREATE TABLE `urule_log_operation`  (
  `ID_` int NOT NULL,
  `USER_ID_` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `USER_NAME_` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `GROUP_ID_` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `GROUP_NAME_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `PROJECT_ID_` int NULL DEFAULT NULL,
  `PROJECT_NAME_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `ITEM_ID_` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `CATEGORY_` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `ACTION_` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `CONTENT_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `CREATE_DATE_` datetime NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`ID_`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '操作日志表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of urule_log_operation
-- ----------------------------
INSERT INTO `urule_log_operation` VALUES (1, 'admin', 'admin', 'hdgk_1124', '华东工控', NULL, NULL, '1', 'projects', 'add', '创建了项目[供应商评价]', '2023-11-24 13:39:50');
INSERT INTO `urule_log_operation` VALUES (2, 'admin', 'admin', 'hdgk_1124', '华东工控', 1, '供应商评价', '1', 'VariableLibrary', 'add', '添加变量库文件[供应商评价指标]', '2023-11-24 13:40:56');
INSERT INTO `urule_log_operation` VALUES (101, 'admin', 'admin', 'hdgk_1124', '华东工控', 1, '供应商评价', '101', 'VariableLibrary', 'add', '添加变量库文件[SupplierEvaluationIndex]', '2023-11-24 14:33:36');
INSERT INTO `urule_log_operation` VALUES (102, 'admin', 'admin', 'hdgk_1124', '华东工控', 1, '供应商评价', '1', 'VariableLibrary', 'remove', '删除变量库文件[供应商评价指标]', '2023-11-24 14:33:51');
INSERT INTO `urule_log_operation` VALUES (103, 'admin', 'admin', 'hdgk_1124', '华东工控', 1, '供应商评价', '101', 'VariableLibrary', 'update', '保存变量库文件[SupplierEvaluationIndex]', '2023-11-24 14:34:44');
INSERT INTO `urule_log_operation` VALUES (104, 'admin', 'admin', 'hdgk_1124', '华东工控', 1, '供应商评价', '102', 'Scorecard', 'add', '添加评分卡文件[supplier]', '2023-11-24 14:36:32');
INSERT INTO `urule_log_operation` VALUES (105, 'admin', 'admin', 'hdgk_1124', '华东工控', 1, '供应商评价', '102', 'Scorecard', 'update', '保存评分卡文件[supplier]', '2023-11-24 14:56:03');
INSERT INTO `urule_log_operation` VALUES (106, 'admin', 'admin', 'hdgk_1124', '华东工控', 1, '供应商评价', '102', 'Scorecard', 'update', '保存评分卡文件[supplier]', '2023-11-24 14:58:27');
INSERT INTO `urule_log_operation` VALUES (107, 'admin', 'admin', 'hdgk_1124', '华东工控', 1, '供应商评价', '102', 'Scorecard', 'update', '保存评分卡文件[supplier]', '2023-11-24 14:58:53');
INSERT INTO `urule_log_operation` VALUES (108, 'admin', 'admin', 'hdgk_1124', '华东工控', 1, '供应商评价', '102', 'Scorecard', 'update', '保存评分卡文件[supplier]', '2023-11-24 14:59:35');
INSERT INTO `urule_log_operation` VALUES (109, 'admin', 'admin', 'hdgk_1124', '华东工控', 1, '供应商评价', '103', 'ComplexScorecard', 'add', '添加复杂评分卡文件[fz]', '2023-11-24 16:07:06');
INSERT INTO `urule_log_operation` VALUES (110, 'admin', 'admin', 'hdgk_1124', '华东工控', 1, '供应商评价', '103', 'ComplexScorecard', 'update', '保存复杂评分卡文件[fz]', '2023-11-24 16:19:33');
INSERT INTO `urule_log_operation` VALUES (111, 'admin', 'admin', 'hdgk_1124', '华东工控', 1, '供应商评价', '103', 'ComplexScorecard', 'update', '保存复杂评分卡文件[fz]', '2023-11-24 16:21:05');
INSERT INTO `urule_log_operation` VALUES (112, 'admin', 'admin', 'hdgk_1124', '华东工控', 1, '供应商评价', '1', 'Knowledge', 'add', '添加知识包[test123456]', '2023-11-25 10:25:52');
INSERT INTO `urule_log_operation` VALUES (113, 'admin', 'admin', 'hdgk_1124', '华东工控', 1, '供应商评价', '1', 'Knowledge', 'update', '添加规则文件到知识包[test123456]', '2023-11-25 10:26:36');
INSERT INTO `urule_log_operation` VALUES (114, 'admin', 'admin', 'hdgk_1124', '华东工控', 1, '供应商评价', '1', 'Knowledge', 'enable', '申请启用知识包[test123456]', '2023-11-25 10:26:59');
INSERT INTO `urule_log_operation` VALUES (115, 'admin', 'admin', 'hdgk_1124', '华东工控', 1, '供应商评价', '1', 'Knowledge', 'enable', '启用知识包[test123456]审批通过', '2023-11-25 10:29:44');
INSERT INTO `urule_log_operation` VALUES (201, 'admin', 'admin', 'hdgk_1124', '华东工控', NULL, NULL, '1', 'projects', 'update', '修改项目[hdgk]', '2023-11-27 09:50:05');
INSERT INTO `urule_log_operation` VALUES (202, 'admin', 'admin', 'hdgk_1124', '华东工控', NULL, NULL, '1', 'projects', 'update', '修改项目[hdgk]', '2023-11-27 09:50:07');
INSERT INTO `urule_log_operation` VALUES (301, 'admin', 'admin', 'hdgk_1124', '华东工控', 1, 'hdgk', '1', 'Knowledge', 'update', '更新知识包[test123456]', '2023-11-27 10:42:28');
INSERT INTO `urule_log_operation` VALUES (302, 'admin', 'admin', 'hdgk_1124', '华东工控', 1, 'hdgk', '1', 'Knowledge', 'update', '更新知识包[test123456]', '2023-11-27 10:43:01');
INSERT INTO `urule_log_operation` VALUES (303, 'admin', 'admin', 'hdgk_1124', '华东工控', 1, 'hdgk', '1', 'Knowledge', 'update', '更新知识包[test123456]', '2023-11-27 10:43:06');
INSERT INTO `urule_log_operation` VALUES (304, 'admin', 'admin', 'hdgk_1124', '华东工控', 1, 'hdgk', '1', 'Knowledge', 'update', '更新知识包[test123456]', '2023-11-27 10:43:19');
INSERT INTO `urule_log_operation` VALUES (305, 'admin', 'admin', 'hdgk_1124', '华东工控', 1, 'hdgk', '1', 'Knowledge', 'update', '更新知识包[test123456]', '2023-11-27 10:43:24');
INSERT INTO `urule_log_operation` VALUES (306, 'admin', 'admin', 'hdgk_1124', '华东工控', 1, 'hdgk', '1', 'Knowledge', 'deploy', '申请发布知识包[test123456]', '2023-11-27 10:43:53');
INSERT INTO `urule_log_operation` VALUES (307, 'admin', 'admin', 'hdgk_1124', '华东工控', 1, 'hdgk', '1', 'Knowledge', 'deploy', '发布知识包[test123456]审批通过', '2023-11-27 10:45:17');
INSERT INTO `urule_log_operation` VALUES (308, 'admin', 'admin', 'hdgk_1124', '华东工控', 1, 'hdgk', '1', 'Knowledge', 'update', '更新知识包[test123456]', '2023-11-27 10:46:19');
INSERT INTO `urule_log_operation` VALUES (401, 'admin', 'admin', 'hdgk_1124', '华东工控', 1, 'hdgk', '101', 'Knowledge', 'add', '添加知识包[fz]', '2023-11-27 17:18:14');
INSERT INTO `urule_log_operation` VALUES (402, 'admin', 'admin', 'hdgk_1124', '华东工控', 1, 'hdgk', '101', 'Knowledge', 'update', '更新知识包[fz]', '2023-11-27 17:19:06');
INSERT INTO `urule_log_operation` VALUES (403, 'admin', 'admin', 'hdgk_1124', '华东工控', 1, 'hdgk', '101', 'Knowledge', 'update', '更新知识包[fz]', '2023-11-27 17:19:51');
INSERT INTO `urule_log_operation` VALUES (404, 'admin', 'admin', 'hdgk_1124', '华东工控', 1, 'hdgk', '101', 'Knowledge', 'delete', '删除知识包[fz]', '2023-11-27 17:22:32');
INSERT INTO `urule_log_operation` VALUES (405, 'admin', 'admin', 'hdgk_1124', '华东工控', 1, 'hdgk', '102', 'Knowledge', 'add', '添加知识包[fz1234]', '2023-11-27 17:23:01');
INSERT INTO `urule_log_operation` VALUES (406, 'admin', 'admin', 'hdgk_1124', '华东工控', 1, 'hdgk', '102', 'Knowledge', 'update', '更新知识包[fz1234]', '2023-11-27 17:28:51');
INSERT INTO `urule_log_operation` VALUES (407, 'admin', 'admin', 'hdgk_1124', '华东工控', 1, 'hdgk', '102', 'Knowledge', 'disable', '申请禁用知识包[fz1234]', '2023-11-27 17:29:22');
INSERT INTO `urule_log_operation` VALUES (408, 'admin', 'admin', 'hdgk_1124', '华东工控', 1, 'hdgk', '102', 'Knowledge', 'disable', '禁用知识包[fz1234]审批通过', '2023-11-27 17:29:51');
INSERT INTO `urule_log_operation` VALUES (501, 'admin', 'admin', 'hdgk_1124', '华东工控', 1, 'hdgk', '102', 'Knowledge', 'update', '更新知识包[fz1234]', '2023-12-28 09:20:11');
INSERT INTO `urule_log_operation` VALUES (502, 'admin', 'admin', 'hdgk_1124', '华东工控', 1, 'hdgk', '201', 'Knowledge', 'add', '添加知识包[test2]', '2023-11-28 11:12:46');
INSERT INTO `urule_log_operation` VALUES (503, 'admin', 'admin', 'hdgk_1124', '华东工控', 1, 'hdgk', '201', 'Knowledge', 'update', '更新知识包[test2]', '2023-11-28 11:13:16');
INSERT INTO `urule_log_operation` VALUES (504, 'admin', 'admin', 'hdgk_1124', '华东工控', 1, 'hdgk', '102', 'Knowledge', 'update', '添加规则文件到知识包[fz1234]', '2023-11-28 11:15:15');
INSERT INTO `urule_log_operation` VALUES (505, 'admin', 'admin', 'hdgk_1124', '华东工控', 1, 'hdgk', '201', 'Knowledge', 'delete', '删除知识包[test2]', '2023-11-28 11:15:22');
INSERT INTO `urule_log_operation` VALUES (506, 'admin', 'admin', 'hdgk_1124', '华东工控', 1, 'hdgk', '102', 'Knowledge', 'enable', '申请启用知识包[fz1234]', '2023-11-28 11:15:51');
INSERT INTO `urule_log_operation` VALUES (507, 'admin', 'admin', 'hdgk_1124', '华东工控', 1, 'hdgk', '102', 'Knowledge', 'enable', '启用知识包[fz1234]审批通过', '2023-11-28 11:16:09');
INSERT INTO `urule_log_operation` VALUES (508, 'admin', 'admin', 'hdgk_1124', '华东工控', 1, 'hdgk', '102', 'Knowledge', 'deploy', '申请发布知识包[fz1234]', '2023-11-28 11:16:29');
INSERT INTO `urule_log_operation` VALUES (509, 'admin', 'admin', 'hdgk_1124', '华东工控', 1, 'hdgk', '102', 'Knowledge', 'deploy', '发布知识包[fz1234]审批通过', '2023-11-28 11:16:41');

-- ----------------------------
-- Table structure for urule_log_userlogin
-- ----------------------------
CREATE TABLE `urule_log_userlogin`  (
  `ID_` int NOT NULL,
  `USER_ID_` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `USER_NAME_` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `GROUP_ID_` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `IP_` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `USER_AGENT_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `CREATE_DATE_` datetime NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`ID_`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '登录日志表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of urule_log_userlogin
-- ----------------------------
INSERT INTO `urule_log_userlogin` VALUES (1, 'admin', 'admin', NULL, '0:0:0:0:0:0:0:1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36 Edg/119.0.0.0', '2023-11-24 13:37:09');
INSERT INTO `urule_log_userlogin` VALUES (101, 'admin', 'admin', NULL, '0:0:0:0:0:0:0:1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36 Edg/119.0.0.0', '2023-11-24 14:13:17');
INSERT INTO `urule_log_userlogin` VALUES (201, 'admin', 'admin', NULL, '0:0:0:0:0:0:0:1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36 Edg/119.0.0.0', '2023-11-24 14:32:24');
INSERT INTO `urule_log_userlogin` VALUES (202, 'admin', 'admin', NULL, '0:0:0:0:0:0:0:1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36 Edg/119.0.0.0', '2023-11-24 16:06:45');
INSERT INTO `urule_log_userlogin` VALUES (203, 'admin', 'admin', NULL, '0:0:0:0:0:0:0:1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36 Edg/119.0.0.0', '2023-11-25 10:24:58');
INSERT INTO `urule_log_userlogin` VALUES (301, 'admin', 'admin', NULL, '0:0:0:0:0:0:0:1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36 Edg/119.0.0.0', '2023-11-25 10:48:11');
INSERT INTO `urule_log_userlogin` VALUES (401, 'admin', 'admin', NULL, '0:0:0:0:0:0:0:1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36 Edg/119.0.0.0', '2023-11-25 11:11:25');
INSERT INTO `urule_log_userlogin` VALUES (501, 'admin', 'admin', NULL, '0:0:0:0:0:0:0:1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36 Edg/119.0.0.0', '2023-11-27 09:45:58');
INSERT INTO `urule_log_userlogin` VALUES (601, 'admin', 'admin', NULL, '0:0:0:0:0:0:0:1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36 Edg/119.0.0.0', '2023-11-27 10:41:19');
INSERT INTO `urule_log_userlogin` VALUES (701, 'admin', 'admin', NULL, '0:0:0:0:0:0:0:1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36 Edg/119.0.0.0', '2023-11-27 15:57:16');
INSERT INTO `urule_log_userlogin` VALUES (801, 'admin', 'admin', NULL, '0:0:0:0:0:0:0:1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36 Edg/119.0.0.0', '2023-11-27 17:17:31');
INSERT INTO `urule_log_userlogin` VALUES (802, 'admin', 'admin', NULL, '0:0:0:0:0:0:0:1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36', '2023-11-27 17:26:10');
INSERT INTO `urule_log_userlogin` VALUES (803, 'admin', 'admin', NULL, '0:0:0:0:0:0:0:1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36 Edg/119.0.0.0', '2023-11-28 08:54:48');
INSERT INTO `urule_log_userlogin` VALUES (901, 'admin', 'admin', NULL, '0:0:0:0:0:0:0:1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36 Edg/119.0.0.0', '2023-11-28 09:16:30');
INSERT INTO `urule_log_userlogin` VALUES (1001, 'admin', 'admin', NULL, '0:0:0:0:0:0:0:1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36 Edg/119.0.0.0', '2023-11-28 09:19:45');
INSERT INTO `urule_log_userlogin` VALUES (1002, 'admin', 'admin', NULL, '0:0:0:0:0:0:0:1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36 Edg/119.0.0.0', '2023-11-28 11:07:28');

-- ----------------------------
-- Table structure for urule_package
-- ----------------------------
CREATE TABLE `urule_package`  (
  `ID_` int NOT NULL,
  `NAME_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `TYPE_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `PARENT_ID_` int NOT NULL DEFAULT 0,
  `PROJECT_ID_` int NOT NULL DEFAULT 0,
  `CREATE_USER_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `UPDATE_USER_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `CREATE_DATE_` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `UPDATE_DATE_` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `DELETED_` tinyint NOT NULL DEFAULT 0,
  PRIMARY KEY (`ID_`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '目录' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of urule_package
-- ----------------------------

-- ----------------------------
-- Table structure for urule_packet
-- ----------------------------
CREATE TABLE `urule_packet`  (
  `ID_` int NOT NULL,
  `PROJECT_ID_` int NOT NULL DEFAULT 0,
  `NAME_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `CODE_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `TYPE_` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `DESC_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `INPUT_DATA_` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL,
  `OUTPUT_DATA_` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL,
  `AUDIT_ENABLE_` tinyint NOT NULL DEFAULT 0,
  `AUDIT_INPUT_` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL,
  `AUDIT_OUTPUT_` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL,
  `REST_ENABLE_` tinyint NOT NULL DEFAULT 0,
  `REST_SECURITY_ENABLE_` tinyint NOT NULL DEFAULT 0,
  `REST_SECURITY_USER_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `REST_SECURITY_PASSWORD_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `REST_INPUT_` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL,
  `REST_OUTPUT_` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL,
  `CREATE_USER_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `UPDATE_USER_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `CREATE_DATE_` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `UPDATE_DATE_` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `ENABLE_` tinyint NOT NULL DEFAULT 0,
  PRIMARY KEY (`ID_`) USING BTREE,
  UNIQUE INDEX `URULE_PACKET_CODE_INDEX`(`CODE_` ASC) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '知识包定义主表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of urule_packet
-- ----------------------------
INSERT INTO `urule_packet` VALUES (1, 1, 'test123456', '123456', 'file', 'ces', '[{\"categoryUuid\":\"55170ba8-6b28-42b0-ac00-fb773018ea2a\",\"categoryName\":\"SupplierEvaluationIndex\",\"categoryClass\":\"com.ruoyi.supplier.domain.SupplierEvaluationIndex\",\"fields\":[{\"uuid\":\"15d0d5b5-4d02-49e7-a922-13b038ebbd19\",\"name\":\"cooperationDuration\",\"label\":\"合作时长\",\"type\":\"Integer\",\"value\":\"500\"},{\"uuid\":\"92c348ce-fd13-486e-be08-a7c2f8870993\",\"name\":\"orderNum\",\"label\":\"订单总数\",\"type\":\"Integer\",\"value\":\"50\"},{\"uuid\":\"2c18ff3c-93e6-40de-b93a-c1232a6a8988\",\"name\":\"paymentCycle\",\"label\":\"交款周期\",\"type\":\"Integer\",\"value\":\"7\"}]}]', '[{\"categoryUuid\":\"55170ba8-6b28-42b0-ac00-fb773018ea2a\",\"categoryName\":\"SupplierEvaluationIndex\",\"categoryClass\":\"com.ruoyi.supplier.domain.SupplierEvaluationIndex\",\"fields\":[{\"uuid\":\"4d12ac01-bb0c-4bab-9aaa-84e61205e0da\",\"name\":\"score\",\"label\":\"综合得分\",\"type\":\"Integer\"}]}]', 0, NULL, NULL, 1, 0, NULL, '12345678', '[{\"name\":\"SupplierEvaluationIndex\",\"clazz\":\"com.ruoyi.supplier.domain.SupplierEvaluationIndex\",\"uuid\":\"55170ba8-6b28-42b0-ac00-fb773018ea2a\",\"fields\":[{\"uuid\":\"15d0d5b5-4d02-49e7-a922-13b038ebbd19\",\"name\":\"cooperationDuration\",\"label\":\"合作时长\",\"type\":\"Integer\"},{\"uuid\":\"92c348ce-fd13-486e-be08-a7c2f8870993\",\"name\":\"orderNum\",\"label\":\"订单总数\",\"type\":\"Integer\"},{\"uuid\":\"2c18ff3c-93e6-40de-b93a-c1232a6a8988\",\"name\":\"paymentCycle\",\"label\":\"交款周期\",\"type\":\"Integer\"}]}]', '[{\"name\":\"SupplierEvaluationIndex\",\"clazz\":\"com.ruoyi.supplier.domain.SupplierEvaluationIndex\",\"uuid\":\"55170ba8-6b28-42b0-ac00-fb773018ea2a\",\"fields\":[{\"uuid\":\"4d12ac01-bb0c-4bab-9aaa-84e61205e0da\",\"name\":\"score\",\"label\":\"综合得分\",\"type\":\"Integer\"}]}]', 'admin', 'admin', '2023-11-25 10:25:52', '2023-11-27 10:46:19', 1);
INSERT INTO `urule_packet` VALUES (102, 1, 'fz1234', '2', 'file', '11111', NULL, NULL, 0, NULL, NULL, 0, 0, NULL, NULL, NULL, NULL, 'admin', 'admin', '2023-11-27 17:23:01', '2023-11-28 11:16:09', 1);

-- ----------------------------
-- Table structure for urule_packet_apply
-- ----------------------------
CREATE TABLE `urule_packet_apply`  (
  `ID_` int NOT NULL,
  `PACKET_ID_` int NOT NULL DEFAULT 0,
  `DEPLOYED_PACKET_ID_` int NOT NULL DEFAULT 0,
  `PROJECT_ID_` int NOT NULL,
  `TYPE_` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `TITLE_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `DESC_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `APPROVER_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `STATUS_` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `CREATE_USER_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `CREATE_DATE_` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `UPDATE_DATE_` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`ID_`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '发布知识包审核主表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of urule_packet_apply
-- ----------------------------
INSERT INTO `urule_packet_apply` VALUES (1, 1, 1, 1, 'enable', '123456', '123456', 'admin', 'pass', 'admin', '2023-11-25 10:26:59', '2023-11-25 10:29:44');
INSERT INTO `urule_packet_apply` VALUES (101, 1, 101, 1, 'deploy', '调用测试', '1', 'admin', 'pass', 'admin', '2023-11-27 10:43:52', '2023-11-27 10:45:17');
INSERT INTO `urule_packet_apply` VALUES (201, 102, 201, 1, 'disable', '1', '1', 'admin', 'pass', 'admin', '2023-11-27 17:29:22', '2023-11-27 17:29:51');
INSERT INTO `urule_packet_apply` VALUES (301, 102, 301, 1, 'enable', '123', '134', 'admin', 'pass', 'admin', '2023-11-28 11:15:51', '2023-11-28 11:16:09');
INSERT INTO `urule_packet_apply` VALUES (302, 102, 302, 1, 'deploy', '1', '2', 'admin', 'pass', 'admin', '2023-11-28 11:16:29', '2023-11-28 11:16:41');

-- ----------------------------
-- Table structure for urule_packet_apply_detail
-- ----------------------------
CREATE TABLE `urule_packet_apply_detail`  (
  `ID_` int NOT NULL,
  `APPLY_ID_` int NOT NULL DEFAULT 0,
  `PROJECT_ID_` int NOT NULL,
  `DESC_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `CREATE_USER_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `CREATE_DATE_` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`ID_`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '发布知识包审核从表，记录审核过程' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of urule_packet_apply_detail
-- ----------------------------
INSERT INTO `urule_packet_apply_detail` VALUES (1, 1, 1, '1', 'admin', '2023-11-25 10:29:44');
INSERT INTO `urule_packet_apply_detail` VALUES (101, 101, 1, '1', 'admin', '2023-11-27 10:45:17');
INSERT INTO `urule_packet_apply_detail` VALUES (201, 201, 1, '1', 'admin', '2023-11-27 17:29:51');
INSERT INTO `urule_packet_apply_detail` VALUES (301, 301, 1, '1', 'admin', '2023-11-28 11:16:09');
INSERT INTO `urule_packet_apply_detail` VALUES (302, 302, 1, '1', 'admin', '2023-11-28 11:16:41');

-- ----------------------------
-- Table structure for urule_packet_file
-- ----------------------------
CREATE TABLE `urule_packet_file`  (
  `ID_` int NOT NULL,
  `PACKET_ID_` int NOT NULL DEFAULT 0,
  `PROJECT_ID_` int NOT NULL,
  `FILE_ID_` int NOT NULL DEFAULT 0,
  `PATH_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `VERSION_` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `DESC_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `CREATE_USER_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `UPDATE_USER_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `CREATE_DATE_` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `UPDATE_DATE_` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`ID_`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '知识包定义从表，文件表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of urule_packet_file
-- ----------------------------
INSERT INTO `urule_packet_file` VALUES (1, 1, 1, 102, 'Scorecard:/供应商评价/supplier', NULL, NULL, 'admin', 'admin', '2023-11-25 10:26:36', '2023-11-25 10:26:36');
INSERT INTO `urule_packet_file` VALUES (101, 102, 1, 103, 'ComplexScorecard:/hdgk/fz', NULL, NULL, 'admin', 'admin', '2023-11-28 11:15:15', '2023-11-28 11:15:15');

-- ----------------------------
-- Table structure for urule_packet_package
-- ----------------------------
CREATE TABLE `urule_packet_package`  (
  `ID_` int NOT NULL,
  `PACKET_ID_` int NOT NULL DEFAULT 0,
  `PROJECT_ID_` int NOT NULL,
  `CONTENT_` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `DESC_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `CREATE_USER_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `UPDATE_USER_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `CREATE_DATE_` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `UPDATE_DATE_` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`ID_`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '知识包定义从表，存储导出后知识包' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of urule_packet_package
-- ----------------------------

-- ----------------------------
-- Table structure for urule_packet_scenario
-- ----------------------------
CREATE TABLE `urule_packet_scenario`  (
  `ID_` int NOT NULL,
  `PACKET_ID_` int NOT NULL,
  `PROJECT_ID_` int NOT NULL,
  `NAME_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `DESC_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `EXCEL_FILE_` mediumblob NULL,
  `EXCEL_FILE_NAME_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `INPUT_DATA_` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL,
  `OUTPUT_DATA_` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL,
  `CREATE_USER_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `UPDATE_USER_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `CREATE_DATE_` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `UPDATE_DATE_` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`ID_`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '场景批量测试' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of urule_packet_scenario
-- ----------------------------

-- ----------------------------
-- Table structure for urule_project
-- ----------------------------
CREATE TABLE `urule_project`  (
  `ID_` int NOT NULL,
  `NAME_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `DESC_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `TYPE_` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `GROUP_ID_` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `APPROVE_USER_ENABLE_` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `APPROVE_USER_DISABLE_` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `APPROVE_USER_DEPLOY_` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `CREATE_USER_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `UPDATE_USER_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `CREATE_DATE_` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `UPDATE_DATE_` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`ID_`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '项目表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of urule_project
-- ----------------------------
INSERT INTO `urule_project` VALUES (1, 'hdgk', '', 'custom', 'hdgk_1124', 'admin', 'admin', 'admin', 'admin', 'admin', '2023-11-24 13:39:49', '2023-11-27 09:50:07');

-- ----------------------------
-- Table structure for urule_project_role
-- ----------------------------
CREATE TABLE `urule_project_role`  (
  `ID_` int NOT NULL,
  `NAME_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `DESC_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `PROJECT_ID_` int NOT NULL,
  `TYPE_` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `CREATE_USER_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `UPDATE_USER_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `CREATE_DATE_` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `UPDATE_DATE_` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`ID_`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '项目角色' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of urule_project_role
-- ----------------------------
INSERT INTO `urule_project_role` VALUES (1, 'Manager', NULL, 1, 'system', 'admin', NULL, '2023-11-24 13:39:49', '2023-11-24 13:39:49');
INSERT INTO `urule_project_role` VALUES (3, 'User', NULL, 1, 'system', 'admin', NULL, '2023-11-24 13:39:49', '2023-11-24 13:39:49');
INSERT INTO `urule_project_role` VALUES (4, 'Knowledge', NULL, 1, 'system', 'admin', NULL, '2023-11-24 13:39:50', '2023-11-24 13:39:50');
INSERT INTO `urule_project_role` VALUES (5, 'Batch', NULL, 1, 'system', 'admin', NULL, '2023-11-24 13:39:50', '2023-11-24 13:39:50');
INSERT INTO `urule_project_role` VALUES (6, 'Library', NULL, 1, 'system', 'admin', NULL, '2023-11-24 13:39:50', '2023-11-24 13:39:50');
INSERT INTO `urule_project_role` VALUES (7, 'RuleSet', NULL, 1, 'system', 'admin', NULL, '2023-11-24 13:39:50', '2023-11-24 13:39:50');
INSERT INTO `urule_project_role` VALUES (8, 'DecisionTable', NULL, 1, 'system', 'admin', NULL, '2023-11-24 13:39:50', '2023-11-24 13:39:50');
INSERT INTO `urule_project_role` VALUES (9, 'DecisionTree', NULL, 1, 'system', 'admin', NULL, '2023-11-24 13:39:50', '2023-11-24 13:39:50');
INSERT INTO `urule_project_role` VALUES (10, 'Scorecard', NULL, 1, 'system', 'admin', NULL, '2023-11-24 13:39:50', '2023-11-24 13:39:50');
INSERT INTO `urule_project_role` VALUES (11, 'Flow', NULL, 1, 'system', 'admin', NULL, '2023-11-24 13:39:50', '2023-11-24 13:39:50');
INSERT INTO `urule_project_role` VALUES (12, 'ConditionTemplate', NULL, 1, 'system', 'admin', NULL, '2023-11-24 13:39:50', '2023-11-24 13:39:50');
INSERT INTO `urule_project_role` VALUES (13, 'ActionTemplate', NULL, 1, 'system', 'admin', NULL, '2023-11-24 13:39:50', '2023-11-24 13:39:50');

-- ----------------------------
-- Table structure for urule_project_user
-- ----------------------------
CREATE TABLE `urule_project_user`  (
  `ID_` int NOT NULL,
  `USER_ID_` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `USER_NAME_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `PROJECT_ID_` int NOT NULL,
  `CREATE_DATE_` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`ID_`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '项目用户' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of urule_project_user
-- ----------------------------
INSERT INTO `urule_project_user` VALUES (1, 'admin', 'admin', 1, '2023-11-24 13:39:49');

-- ----------------------------
-- Table structure for urule_project_user_role
-- ----------------------------
CREATE TABLE `urule_project_user_role`  (
  `ID_` int NOT NULL,
  `PROJECT_ID_` int NOT NULL,
  `USER_ID_` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `ROLE_ID_` int NOT NULL,
  PRIMARY KEY (`ID_`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '用户项目角色关系表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of urule_project_user_role
-- ----------------------------
INSERT INTO `urule_project_user_role` VALUES (2, 1, 'admin', 1);

-- ----------------------------
-- Table structure for urule_property
-- ----------------------------
CREATE TABLE `urule_property`  (
  `ID_` int NOT NULL,
  `KEY_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `VALUE_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `LABEL_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `TYPE_` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `CREATE_USER_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `UPDATE_USER_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `CREATE_DATE_` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `UPDATE_DATE_` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`ID_`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = 'URULE属性表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of urule_property
-- ----------------------------
INSERT INTO `urule_property` VALUES (1, 'DEFAULT.dbid', '0', '默认ID', 'system', NULL, NULL, '2023-11-24 05:35:58', '2023-11-24 05:35:58');
INSERT INTO `urule_property` VALUES (2, 'URULE_PROPERTY.dbid', '1000', '属性ID', 'system', NULL, NULL, '2023-11-24 05:35:58', '2023-11-24 05:35:58');
INSERT INTO `urule_property` VALUES (3, 'URULE_GROUP_ROLE.dbid', '100', '团队角色ID', 'system', NULL, NULL, '2023-11-24 05:35:58', '2023-11-24 05:35:58');
INSERT INTO `urule_property` VALUES (4, 'URULE_GROUP_USER.dbid', '100', '团队用户ID', 'system', NULL, NULL, '2023-11-24 05:35:58', '2023-11-24 05:35:58');
INSERT INTO `urule_property` VALUES (5, 'URULE_GROUP_USER_ROLE.dbid', '100', '团队角色用户ID', 'system', NULL, NULL, '2023-11-24 05:35:58', '2023-11-24 05:35:58');
INSERT INTO `urule_property` VALUES (6, 'URULE_PROJECT.dbid', '100', '项目ID', 'system', NULL, NULL, '2023-11-24 05:35:58', '2023-11-24 05:35:58');
INSERT INTO `urule_property` VALUES (7, 'URULE_PROJECT_ROLE.dbid', '100', '项目角色ID', 'system', NULL, NULL, '2023-11-24 05:35:58', '2023-11-24 05:35:58');
INSERT INTO `urule_property` VALUES (8, 'URULE_PROJECT_USER.dbid', '100', '项目用户ID', 'system', NULL, NULL, '2023-11-24 05:35:58', '2023-11-24 05:35:58');
INSERT INTO `urule_property` VALUES (9, 'URULE_PROJECT_USER_ROLE.dbid', '0', '项目角色用户ID', 'system', NULL, NULL, '2023-11-24 05:35:58', '2023-11-24 05:35:58');
INSERT INTO `urule_property` VALUES (10, 'URULE_INVITE.dbid', '0', '团队邀请ID', 'system', NULL, NULL, '2023-11-24 05:35:58', '2023-11-24 05:35:58');
INSERT INTO `urule_property` VALUES (11, 'URULE_AUTHORITY.dbid', '200', '权限ID', 'system', NULL, NULL, '2023-11-24 05:35:58', '2023-11-24 05:35:58');
INSERT INTO `urule_property` VALUES (12, 'URULE_LOG_USERLOGIN.dbid', '1100', '登录日志ID', 'system', NULL, NULL, '2023-11-24 05:35:58', '2023-11-24 05:35:58');
INSERT INTO `urule_property` VALUES (13, 'URULE_LOG_OPERATION.dbid', '600', '操作日志ID', 'system', NULL, NULL, '2023-11-24 05:35:58', '2023-11-24 05:35:58');
INSERT INTO `urule_property` VALUES (14, 'URULE_LOG_KNOWLEDGE.dbid', '0', '知识包执行日志ID', 'system', NULL, NULL, '2023-11-24 05:35:58', '2023-11-24 05:35:58');
INSERT INTO `urule_property` VALUES (15, 'URULE_LOG_BATCH.dbid', '0', '批处理执行日志异常ID', 'system', NULL, NULL, '2023-11-24 05:35:58', '2023-11-24 05:35:58');
INSERT INTO `urule_property` VALUES (16, 'URULE_LOG_BATCH_SKIP.dbid', '0', '批处理执行异常日志ID', 'system', NULL, NULL, '2023-11-24 05:35:58', '2023-11-24 05:35:58');
INSERT INTO `urule_property` VALUES (41, 'URULE_DATASOURCE.dbid', '0', '数据源', 'system', NULL, NULL, '2023-11-24 05:35:58', '2023-11-24 05:35:58');
INSERT INTO `urule_property` VALUES (42, 'URULE_BATCH.dbid', '0', '执行方案', 'system', NULL, NULL, '2023-11-24 05:35:58', '2023-11-24 05:35:58');
INSERT INTO `urule_property` VALUES (43, 'URULE_BATCH_DATA_PROVIDER.dbid', '0', '加载数据方案', 'system', NULL, NULL, '2023-11-24 05:35:58', '2023-11-24 05:35:58');
INSERT INTO `urule_property` VALUES (44, 'URULE_BATCH_PROVIDER_FIELD.dbid', '0', '加载数据方案字段表', 'system', NULL, NULL, '2023-11-24 05:35:58', '2023-11-24 05:35:58');
INSERT INTO `urule_property` VALUES (45, 'URULE_BATCH_DATA_RESOLVER.dbid', '0', '存储数据方案', 'system', NULL, NULL, '2023-11-24 05:35:58', '2023-11-24 05:35:58');
INSERT INTO `urule_property` VALUES (46, 'URULE_BATCH_RESOLVER_ITEM.dbid', '0', '存储数据方案存储项表', 'system', NULL, NULL, '2023-11-24 05:35:58', '2023-11-24 05:35:58');
INSERT INTO `urule_property` VALUES (47, 'URULE_BATCH_RESOLVER_FIELD.dbid', '0', '存储数据方案字段表', 'system', NULL, NULL, '2023-11-24 05:35:58', '2023-11-24 05:35:58');
INSERT INTO `urule_property` VALUES (51, 'URULE_FILE.dbid', '200', '规则文件ID', 'system', NULL, NULL, '2023-11-24 05:35:58', '2023-11-24 05:35:58');
INSERT INTO `urule_property` VALUES (52, 'URULE_PACKET_PACKAGE.dbid', '0', '导出后上传的知识包ID', 'system', NULL, NULL, '2023-11-24 05:35:58', '2023-11-24 05:35:58');
INSERT INTO `urule_property` VALUES (53, 'URULE_PACKET.dbid', '300', '知识包ID', 'system', NULL, NULL, '2023-11-24 05:35:58', '2023-11-24 05:35:58');
INSERT INTO `urule_property` VALUES (54, 'URULE_PACKET_FILE.dbid', '200', '知识包文件ID', 'system', NULL, NULL, '2023-11-24 05:35:58', '2023-11-24 05:35:58');
INSERT INTO `urule_property` VALUES (55, 'URULE_DEPLOYED_PACKET.dbid', '400', '已发布知识包ID', 'system', NULL, NULL, '2023-11-24 05:35:58', '2023-11-24 05:35:58');
INSERT INTO `urule_property` VALUES (56, 'URULE_DEPLOYED_PACKET_FILE.dbid', '200', '已发布知识包文件ID', 'system', NULL, NULL, '2023-11-24 05:35:58', '2023-11-24 05:35:58');
INSERT INTO `urule_property` VALUES (57, 'URULE_PACKET_APPLY.dbid', '400', '审批ID', 'system', NULL, NULL, '2023-11-24 05:35:58', '2023-11-24 05:35:58');
INSERT INTO `urule_property` VALUES (58, 'URULE_PACKET_APPLY_DETAIL.dbid', '400', '审批明细ID', 'system', NULL, NULL, '2023-11-24 05:35:58', '2023-11-24 05:35:58');
INSERT INTO `urule_property` VALUES (59, 'URULE_PACKET_SCENARIO.dbid', '0', '知识包测试ID', 'system', NULL, NULL, '2023-11-24 05:35:58', '2023-11-24 05:35:58');
INSERT INTO `urule_property` VALUES (60, 'URULE_URL_CONFIG.dbid', '0', 'URL配置', 'system', NULL, NULL, '2023-11-24 05:35:58', '2023-11-24 05:35:58');
INSERT INTO `urule_property` VALUES (61, 'URULE_DYNAMIC_JAR.dbid', '0', '动态JAR文件', 'system', NULL, NULL, '2023-11-24 05:35:58', '2023-11-24 05:35:58');
INSERT INTO `urule_property` VALUES (101, 'urule.application.title', 'URule Console Pro 4', 'Application Title', 'system', NULL, NULL, '2023-11-24 05:35:58', '2023-11-24 05:35:58');
INSERT INTO `urule_property` VALUES (201, 'urule.security.useConservativeStrategy', 'true', '是否启用权限验证的保守策略', 'system', NULL, NULL, '2023-11-24 05:35:58', '2023-11-24 05:35:58');
INSERT INTO `urule_property` VALUES (301, 'urule.mail.smtp.host', 'smtp.163.com', 'SMTP服务器', 'system', NULL, NULL, '2023-11-24 05:35:58', '2023-11-24 05:35:58');
INSERT INTO `urule_property` VALUES (302, 'urule.mail.smtp.port', '25', 'SMTP端口', 'system', NULL, NULL, '2023-11-24 05:35:58', '2023-11-24 05:35:58');
INSERT INTO `urule_property` VALUES (303, 'urule.mail.smtp.auth', 'true', '需要验证用户名密码', 'system', NULL, NULL, '2023-11-24 05:35:58', '2023-11-24 05:35:58');
INSERT INTO `urule_property` VALUES (304, 'urule.mail.smtp.user', 'urule@163.com', '发件人', 'system', NULL, NULL, '2023-11-24 05:35:58', '2023-11-24 05:35:58');
INSERT INTO `urule_property` VALUES (305, 'urule.mail.smtp.pass', 'urule', '授权码', 'system', NULL, NULL, '2023-11-24 05:35:58', '2023-11-24 05:35:58');

-- ----------------------------
-- Table structure for urule_url_config
-- ----------------------------
CREATE TABLE `urule_url_config`  (
  `ID_` int NOT NULL,
  `NAME_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `URL_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `TYPE_` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `GROUP_ID_` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `CREATE_USER_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `UPDATE_USER_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `CREATE_DATE_` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `UPDATE_DATE_` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`ID_`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '集群服务器及客户端URL配置表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of urule_url_config
-- ----------------------------

-- ----------------------------
-- Table structure for urule_user
-- ----------------------------
CREATE TABLE `urule_user`  (
  `ID_` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `NAME_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `PASSWORD_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `EMAIL_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `SECRET_KEY_` varchar(6) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `DESC_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `CREATE_USER_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `UPDATE_USER_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `EXPIR_DATE_` datetime NULL DEFAULT CURRENT_TIMESTAMP,
  `CREATE_DATE_` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `UPDATE_DATE_` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`ID_`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '用户' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of urule_user
-- ----------------------------
INSERT INTO `urule_user` VALUES ('admin', 'admin', '12345678', NULL, NULL, NULL, 'admin', NULL, '2023-11-24 05:36:48', '2023-11-24 13:36:48', '2023-11-24 05:36:48');

-- ----------------------------
-- Table structure for urule_version_file
-- ----------------------------
CREATE TABLE `urule_version_file`  (
  `ID_` int NOT NULL,
  `NAME_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `FILE_ID_` int NOT NULL,
  `PROJECT_ID_` int NOT NULL,
  `VERSION_` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `CONTENT_` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `DIGEST_` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `NOTE_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `CREATE_USER_` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `CREATE_DATE_` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`ID_`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '版本文件' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of urule_version_file
-- ----------------------------

