-- afc_application
DELETE FROM afc_application WHERE ID like 'dqms%';
INSERT INTO afc_application (ID, NAME, CODE, TYPES, SECRET, URL, DESCRIPTION, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED, EXTRA, IS_SHARE, ACCESS_TOKEN, REFRESH_TOKEN, OPEN_TYPE, MICRO_URL, MICRO_MARK, IS_LOWCODE, BPS_TENANT_ID, DIMENSION_CODE) VALUES ('dqms-66', '数据质量', 'QUALITY', null, '215acf6db2844663a0c1c0bdac287441', null, null, 'sys_tenant', to_date('2022-07-18 21:44:33','yyyy-mm-dd hh24:mi:ss'), to_date('2022-07-19 02:22:44','yyyy-mm-dd hh24:mi:ss'), '64', '64', null, null, '0', 5, 30, 'microApp', '[{"id":1663312107142,"microMark":"quality","microUrl":"/"}]', 'quality_ui', null, null, null);

-- afc_res_group
DELETE FROM afc_res_group WHERE ID like 'dqms%';
INSERT INTO afc_res_group (ID, NAME, CODE, TYPES, RES_TYPE, DESCRIPTION, APP_ID, BUSINESS_OBJ_ID, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, SORT_NO, IS_FIXED) VALUES ('dqms-446', '默认分组', 'dqms-66_public_group', 'public_group', null, null, 'dqms-66', null, 'sys_tenant', to_date('2022-07-18 21:44:33','yyyy-mm-dd hh24:mi:ss'), null, '64', null, 0, null);
INSERT INTO afc_res_group (ID, NAME, CODE, TYPES, RES_TYPE, DESCRIPTION, APP_ID, BUSINESS_OBJ_ID, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, SORT_NO, IS_FIXED) VALUES ('dqms-449', '质量定义', 'define', null, null, null, 'dqms-66', null, 'sys_tenant', to_date('2022-07-19 03:52:15','yyyy-mm-dd hh24:mi:ss'), null, '64', null, 1, null);
INSERT INTO afc_res_group (ID, NAME, CODE, TYPES, RES_TYPE, DESCRIPTION, APP_ID, BUSINESS_OBJ_ID, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, SORT_NO, IS_FIXED) VALUES ('dqms-450', '质量调度', 'dispatch', null, null, null, 'dqms-66', null, 'sys_tenant', to_date('2022-07-19 03:52:32','yyyy-mm-dd hh24:mi:ss'), null, '64', null, 2, null);
INSERT INTO afc_res_group (ID, NAME, CODE, TYPES, RES_TYPE, DESCRIPTION, APP_ID, BUSINESS_OBJ_ID, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, SORT_NO, IS_FIXED) VALUES ('dqms-451', '质量监控', 'monitor', null, null, null, 'dqms-66', null, 'sys_tenant', to_date('2022-07-19 03:52:48','yyyy-mm-dd hh24:mi:ss'), null, '64', null, 3, null);
INSERT INTO afc_res_group (ID, NAME, CODE, TYPES, RES_TYPE, DESCRIPTION, APP_ID, BUSINESS_OBJ_ID, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, SORT_NO, IS_FIXED) VALUES ('dqms-452', '质量结果', 'result', null, null, null, 'dqms-66', null, 'sys_tenant', to_date('2022-07-19 03:53:04','yyyy-mm-dd hh24:mi:ss'), null, '64', null, 4, null);
INSERT INTO afc_res_group (ID, NAME, CODE, TYPES, RES_TYPE, DESCRIPTION, APP_ID, BUSINESS_OBJ_ID, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, SORT_NO, IS_FIXED) VALUES ('dqms-453', '质量警告', 'alarm', null, null, null, 'dqms-66', null, 'sys_tenant', to_date('2022-07-19 03:53:20','yyyy-mm-dd hh24:mi:ss'), null, '64', null, 5, null);
INSERT INTO afc_res_group (ID, NAME, CODE, TYPES, RES_TYPE, DESCRIPTION, APP_ID, BUSINESS_OBJ_ID, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, SORT_NO, IS_FIXED) VALUES ('dqms-454', '问题管理', 'problem', null, null, null, 'dqms-66', null, 'sys_tenant', to_date('2022-07-19 03:53:40','yyyy-mm-dd hh24:mi:ss'), null, '64', null, 6, null);
INSERT INTO afc_res_group (ID, NAME, CODE, TYPES, RES_TYPE, DESCRIPTION, APP_ID, BUSINESS_OBJ_ID, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, SORT_NO, IS_FIXED) VALUES ('dqms-455', '质量分析', 'dqAnalysis', null, null, null, 'dqms-66', null, 'sys_tenant', to_date('2022-07-19 03:53:59','yyyy-mm-dd hh24:mi:ss'), null, '64', null, 7, null);
INSERT INTO afc_res_group (ID, NAME, CODE, TYPES, RES_TYPE, DESCRIPTION, APP_ID, BUSINESS_OBJ_ID, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, SORT_NO, IS_FIXED) VALUES ('dqms-456', '数据源管理', 'dataOperation', null, null, null, 'dqms-66', null, 'sys_tenant', to_date('2022-07-19 03:54:17','yyyy-mm-dd hh24:mi:ss'), null, '64', null, 8, null);
INSERT INTO afc_res_group (ID, NAME, CODE, TYPES, RES_TYPE, DESCRIPTION, APP_ID, BUSINESS_OBJ_ID, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, SORT_NO, IS_FIXED) VALUES ('dqms-457', '安全审计', 'securityAudit', null, null, null, 'dqms-66', null, 'sys_tenant', to_date('2022-12-20 14:05:49','yyyy-mm-dd hh24:mi:ss'), null, 'admin', null, 9, null);
INSERT INTO AFC_RES_GROUP (ID, NAME, CODE, TYPES, RES_TYPE, DESCRIPTION, APP_ID, BUSINESS_OBJ_ID, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, SORT_NO, IS_FIXED) VALUES ('dqms-458', '产品信息', 'productsInfo', null, null, null, 'dqms-66', null, 'sys_tenant', to_date('2022-12-20 14:05:58','yyyy-mm-dd hh24:mi:ss'), null, 'admin', null, 10, null);

DELETE FROM afc_res_group WHERE ID LIKE 'quality%';

INSERT INTO afc_res_group (ID, NAME, CODE, TYPES, RES_TYPE, DESCRIPTION, APP_ID, BUSINESS_OBJ_ID, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, SORT_NO, IS_FIXED)VALUES ('quality-11', '主数据平台变量', 'mdm_platform_vars', 'platform', 'systemVariable', null, null, null, 'sys_tenant', to_date('2022-12-30 12:00:00','yyyy-mm-dd hh24:mi:ss'), null, null, null, 1, null);
INSERT INTO afc_res_group (ID, NAME, CODE, TYPES, RES_TYPE, DESCRIPTION, APP_ID, BUSINESS_OBJ_ID, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, SORT_NO, IS_FIXED)VALUES ('quality-12', 'AFC变量', 'afc_platform_vars', 'platform', 'systemVariable', null, null, null, 'sys_tenant', to_date('2022-12-30 12:00:00','yyyy-mm-dd hh24:mi:ss'), null, null, null, 1, null);

-- afc_menu
DELETE FROM afc_menu WHERE ID like 'dqms%';
INSERT INTO afc_menu (ID, NAME, CODE, RES_ID, DESCRIPTION, SORT_NO, IS_LEAF, TREE_LEVEL, SEQ, PARENT_ID, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED, OPEN_TYPE, MENU_ICON, MENU_TYPE, BUSINESS_OBJ_ID, IS_NEW_WINDOW_OPEN) VALUES ('dqms-442', '数据质量', 'quality', 'dqms-1885', null, 9, '0', null, null, 'root', 'sys_tenant', to_date('2022-07-18 21:43:27','yyyy-mm-dd hh24:mi:ss'), to_date('2022-07-19 01:51:08','yyyy-mm-dd hh24:mi:ss'), '64', '64', null, null, 'Newuserzone', null, null, null);
INSERT INTO afc_menu (ID, NAME, CODE, RES_ID, DESCRIPTION, SORT_NO, IS_LEAF, TREE_LEVEL, SEQ, PARENT_ID, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED, OPEN_TYPE, MENU_ICON, MENU_TYPE, BUSINESS_OBJ_ID, IS_NEW_WINDOW_OPEN) VALUES ('dqms-364', '质量调度', 'dispatch', null, null, 2, '0', null, null, 'dqms-442', 'sys_tenant', to_date('2022-07-19 17:28:07','yyyy-mm-dd hh24:mi:ss'), to_date('2022-07-28 11:26:06','yyyy-mm-dd hh24:mi:ss'), '64', '64', null, null, 'dingdan', null, null, null);
INSERT INTO afc_menu (ID, NAME, CODE, RES_ID, DESCRIPTION, SORT_NO, IS_LEAF, TREE_LEVEL, SEQ, PARENT_ID, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED, OPEN_TYPE, MENU_ICON, MENU_TYPE, BUSINESS_OBJ_ID, IS_NEW_WINDOW_OPEN) VALUES ('dqms-365', '质量监控', 'monitor', null, null, 3, '0', null, null, 'dqms-442', 'sys_tenant', to_date('2022-07-19 17:28:41','yyyy-mm-dd hh24:mi:ss'), to_date('2022-07-28 11:26:19','yyyy-mm-dd hh24:mi:ss'), '64', '64', null, null, 'fenlei', null, null, null);
INSERT INTO afc_menu (ID, NAME, CODE, RES_ID, DESCRIPTION, SORT_NO, IS_LEAF, TREE_LEVEL, SEQ, PARENT_ID, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED, OPEN_TYPE, MENU_ICON, MENU_TYPE, BUSINESS_OBJ_ID, IS_NEW_WINDOW_OPEN) VALUES ('dqms-366', '质量结果', 'result', null, null, 4, '0', null, null, 'dqms-442', 'sys_tenant', to_date('2022-07-19 17:29:03','yyyy-mm-dd hh24:mi:ss'), to_date('2022-07-28 11:26:24','yyyy-mm-dd hh24:mi:ss'), '64', '64', null, null, 'dingdan', null, null, null);
INSERT INTO afc_menu (ID, NAME, CODE, RES_ID, DESCRIPTION, SORT_NO, IS_LEAF, TREE_LEVEL, SEQ, PARENT_ID, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED, OPEN_TYPE, MENU_ICON, MENU_TYPE, BUSINESS_OBJ_ID, IS_NEW_WINDOW_OPEN) VALUES ('dqms-367', '质量告警', 'alarm', null, null, 5, '0', null, null, 'dqms-442', 'sys_tenant', to_date('2022-07-19 17:29:21','yyyy-mm-dd hh24:mi:ss'), to_date('2022-07-28 13:56:10','yyyy-mm-dd hh24:mi:ss'), '64', '64', null, null, 'remind-fill', null, null, null);
INSERT INTO afc_menu (ID, NAME, CODE, RES_ID, DESCRIPTION, SORT_NO, IS_LEAF, TREE_LEVEL, SEQ, PARENT_ID, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED, OPEN_TYPE, MENU_ICON, MENU_TYPE, BUSINESS_OBJ_ID, IS_NEW_WINDOW_OPEN) VALUES ('dqms-368', '问题管理', 'problemManage', null, null, 6, '0', null, null, 'dqms-442', 'sys_tenant', to_date('2022-07-19 17:29:50','yyyy-mm-dd hh24:mi:ss'), to_date('2022-07-28 13:55:54','yyyy-mm-dd hh24:mi:ss'), '64', '64', null, null, 'rightalignment', null, null, null);
INSERT INTO afc_menu (ID, NAME, CODE, RES_ID, DESCRIPTION, SORT_NO, IS_LEAF, TREE_LEVEL, SEQ, PARENT_ID, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED, OPEN_TYPE, MENU_ICON, MENU_TYPE, BUSINESS_OBJ_ID, IS_NEW_WINDOW_OPEN) VALUES ('dqms-369', '质量分析', 'dqAnalysis', null, null, 7, '0', null, null, 'dqms-442', 'sys_tenant', to_date('2022-07-19 17:30:07','yyyy-mm-dd hh24:mi:ss'), to_date('2022-07-28 13:57:33','yyyy-mm-dd hh24:mi:ss'), '64', '64', null, null, 'dingdan', null, null, null);
INSERT INTO afc_menu (ID, NAME, CODE, RES_ID, DESCRIPTION, SORT_NO, IS_LEAF, TREE_LEVEL, SEQ, PARENT_ID, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED, OPEN_TYPE, MENU_ICON, MENU_TYPE, BUSINESS_OBJ_ID, IS_NEW_WINDOW_OPEN) VALUES ('dqms-370', '数据源管理', 'dataOperation', null, null, 8, '0', null, null, 'dqms-442', 'sys_tenant', to_date('2022-07-19 17:30:25','yyyy-mm-dd hh24:mi:ss'), to_date('2022-07-28 13:58:11','yyyy-mm-dd hh24:mi:ss'), '64', '64', null, null, 'jifen_2', null, null, null);
INSERT INTO afc_menu (ID, NAME, CODE, RES_ID, DESCRIPTION, SORT_NO, IS_LEAF, TREE_LEVEL, SEQ, PARENT_ID, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED, OPEN_TYPE, MENU_ICON, MENU_TYPE, BUSINESS_OBJ_ID, IS_NEW_WINDOW_OPEN) VALUES ('dqms-443', '质量定义', 'define', null, null, 1, '0', null, null, 'dqms-442', 'sys_tenant', to_date('2022-07-19 01:44:21','yyyy-mm-dd hh24:mi:ss'), to_date('2022-07-28 11:24:41','yyyy-mm-dd hh24:mi:ss'), '64', '64', null, null, 'fenlei_2', null, null, null);
INSERT INTO afc_menu (ID, NAME, CODE, RES_ID, DESCRIPTION, SORT_NO, IS_LEAF, TREE_LEVEL, SEQ, PARENT_ID, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED, OPEN_TYPE, MENU_ICON, MENU_TYPE, BUSINESS_OBJ_ID, IS_NEW_WINDOW_OPEN) VALUES ('dqms-372', '检核规则分组', 'group', 'dqms-1887', null, 2, '1', null, null, 'dqms-443', 'sys_tenant', to_date('2022-07-19 17:31:38','yyyy-mm-dd hh24:mi:ss'), null, '64', null, null, null, null, null, null, null);
INSERT INTO afc_menu (ID, NAME, CODE, RES_ID, DESCRIPTION, SORT_NO, IS_LEAF, TREE_LEVEL, SEQ, PARENT_ID, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED, OPEN_TYPE, MENU_ICON, MENU_TYPE, BUSINESS_OBJ_ID, IS_NEW_WINDOW_OPEN) VALUES ('dqms-373', '检核规则管理', 'checkRuleManage', 'dqms-1888', null, 3, '1', null, null, 'dqms-443', 'sys_tenant', to_date('2022-07-19 17:32:08','yyyy-mm-dd hh24:mi:ss'), null, '64', null, null, null, null, null, null, null);
INSERT INTO afc_menu (ID, NAME, CODE, RES_ID, DESCRIPTION, SORT_NO, IS_LEAF, TREE_LEVEL, SEQ, PARENT_ID, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED, OPEN_TYPE, MENU_ICON, MENU_TYPE, BUSINESS_OBJ_ID, IS_NEW_WINDOW_OPEN) VALUES ('dqms-374', '指标信息维护', 'indexinfo', 'dqms-1889', null, 4, '1', null, null, 'dqms-443', 'sys_tenant', to_date('2022-07-19 17:32:33','yyyy-mm-dd hh24:mi:ss'), null, '64', null, null, null, null, null, null, null);
INSERT INTO afc_menu (ID, NAME, CODE, RES_ID, DESCRIPTION, SORT_NO, IS_LEAF, TREE_LEVEL, SEQ, PARENT_ID, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED, OPEN_TYPE, MENU_ICON, MENU_TYPE, BUSINESS_OBJ_ID, IS_NEW_WINDOW_OPEN) VALUES ('dqms-375', 'HBase规则维护', 'ruleinfo', 'dqms-1890', null, 5, '1', null, null, 'dqms-443', 'sys_tenant', to_date('2022-07-19 17:33:03','yyyy-mm-dd hh24:mi:ss'), null, '64', null, null, null, null, null, null, null);
INSERT INTO afc_menu (ID, NAME, CODE, RES_ID, DESCRIPTION, SORT_NO, IS_LEAF, TREE_LEVEL, SEQ, PARENT_ID, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED, OPEN_TYPE, MENU_ICON, MENU_TYPE, BUSINESS_OBJ_ID, IS_NEW_WINDOW_OPEN) VALUES ('dqms-376', '通用检核配置', 'commoncheckconf', 'dqms-1891', null, 6, '1', null, null, 'dqms-443', 'sys_tenant', to_date('2022-07-19 17:33:27','yyyy-mm-dd hh24:mi:ss'), null, '64', null, null, null, null, null, null, null);
INSERT INTO afc_menu (ID, NAME, CODE, RES_ID, DESCRIPTION, SORT_NO, IS_LEAF, TREE_LEVEL, SEQ, PARENT_ID, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED, OPEN_TYPE, MENU_ICON, MENU_TYPE, BUSINESS_OBJ_ID, IS_NEW_WINDOW_OPEN) VALUES ('dqms-377', '频度管理', 'frequency', 'dqms-1892', null, 1, '1', null, null, 'dqms-364', 'sys_tenant', to_date('2022-07-19 17:39:59','yyyy-mm-dd hh24:mi:ss'), null, '64', null, null, null, null, null, null, null);
INSERT INTO afc_menu (ID, NAME, CODE, RES_ID, DESCRIPTION, SORT_NO, IS_LEAF, TREE_LEVEL, SEQ, PARENT_ID, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED, OPEN_TYPE, MENU_ICON, MENU_TYPE, BUSINESS_OBJ_ID, IS_NEW_WINDOW_OPEN) VALUES ('dqms-378', '日历管理', 'calendar', 'dqms-1893', null, 2, '1', null, null, 'dqms-364', 'sys_tenant', to_date('2022-07-19 17:40:28','yyyy-mm-dd hh24:mi:ss'), null, '64', null, null, null, null, null, null, null);
INSERT INTO afc_menu (ID, NAME, CODE, RES_ID, DESCRIPTION, SORT_NO, IS_LEAF, TREE_LEVEL, SEQ, PARENT_ID, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED, OPEN_TYPE, MENU_ICON, MENU_TYPE, BUSINESS_OBJ_ID, IS_NEW_WINDOW_OPEN) VALUES ('dqms-379', '检核任务管理', 'scheduleInfo', 'dqms-1894', null, 3, '1', null, null, 'dqms-364', 'sys_tenant', to_date('2022-07-19 17:41:01','yyyy-mm-dd hh24:mi:ss'), null, '64', null, null, null, null, null, null, null);
INSERT INTO afc_menu (ID, NAME, CODE, RES_ID, DESCRIPTION, SORT_NO, IS_LEAF, TREE_LEVEL, SEQ, PARENT_ID, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED, OPEN_TYPE, MENU_ICON, MENU_TYPE, BUSINESS_OBJ_ID, IS_NEW_WINDOW_OPEN) VALUES ('dqms-380', '检核规则监控', 'checkRuleMonitor', 'dqms-1895', null, 1, '1', null, null, 'dqms-365', 'sys_tenant', to_date('2022-07-19 17:42:57','yyyy-mm-dd hh24:mi:ss'), null, '64', null, null, null, null, null, null, null);
INSERT INTO afc_menu (ID, NAME, CODE, RES_ID, DESCRIPTION, SORT_NO, IS_LEAF, TREE_LEVEL, SEQ, PARENT_ID, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED, OPEN_TYPE, MENU_ICON, MENU_TYPE, BUSINESS_OBJ_ID, IS_NEW_WINDOW_OPEN) VALUES ('dqms-461', '检核任务监控', 'scheduleMonitor', 'dqms-1896', null, 2, '1', null, null, 'dqms-365', 'sys_tenant', to_date('2022-07-19 17:43:19','yyyy-mm-dd hh24:mi:ss'), null, '64', null, null, null, null, null, null, null);
INSERT INTO afc_menu (ID, NAME, CODE, RES_ID, DESCRIPTION, SORT_NO, IS_LEAF, TREE_LEVEL, SEQ, PARENT_ID, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED, OPEN_TYPE, MENU_ICON, MENU_TYPE, BUSINESS_OBJ_ID, IS_NEW_WINDOW_OPEN) VALUES ('dqms-462', '检核规则日志', 'checkRuleLogs', 'dqms-1897', null, 3, '1', null, null, 'dqms-365', 'sys_tenant', to_date('2022-07-19 17:43:53','yyyy-mm-dd hh24:mi:ss'), null, '64', null, null, null, null, null, null, null);
INSERT INTO afc_menu (ID, NAME, CODE, RES_ID, DESCRIPTION, SORT_NO, IS_LEAF, TREE_LEVEL, SEQ, PARENT_ID, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED, OPEN_TYPE, MENU_ICON, MENU_TYPE, BUSINESS_OBJ_ID, IS_NEW_WINDOW_OPEN) VALUES ('dqms-463', '检核结果', 'checkRuleResult', 'dqms-1898', null, 1, '1', null, null, 'dqms-366', 'sys_tenant', to_date('2022-07-19 17:44:29','yyyy-mm-dd hh24:mi:ss'), null, '64', null, null, null, null, null, null, null);
INSERT INTO afc_menu (ID, NAME, CODE, RES_ID, DESCRIPTION, SORT_NO, IS_LEAF, TREE_LEVEL, SEQ, PARENT_ID, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED, OPEN_TYPE, MENU_ICON, MENU_TYPE, BUSINESS_OBJ_ID, IS_NEW_WINDOW_OPEN) VALUES ('dqms-464', '通用检核详情', 'commoncheckDetail', 'dqms-1899', null, 2, '1', null, null, 'dqms-366', 'sys_tenant', to_date('2022-07-19 17:44:54','yyyy-mm-dd hh24:mi:ss'), null, '64', null, null, null, null, null, null, null);
INSERT INTO afc_menu (ID, NAME, CODE, RES_ID, DESCRIPTION, SORT_NO, IS_LEAF, TREE_LEVEL, SEQ, PARENT_ID, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED, OPEN_TYPE, MENU_ICON, MENU_TYPE, BUSINESS_OBJ_ID, IS_NEW_WINDOW_OPEN) VALUES ('dqms-465', '告警配置', 'alarmConfigInfo', 'dqms-1900', null, 1, '1', null, null, 'dqms-367', 'sys_tenant', to_date('2022-07-19 17:45:34','yyyy-mm-dd hh24:mi:ss'), null, '64', null, null, null, '', null, null, null);
INSERT INTO afc_menu (ID, NAME, CODE, RES_ID, DESCRIPTION, SORT_NO, IS_LEAF, TREE_LEVEL, SEQ, PARENT_ID, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED, OPEN_TYPE, MENU_ICON, MENU_TYPE, BUSINESS_OBJ_ID, IS_NEW_WINDOW_OPEN) VALUES ('dqms-466', '告警结果', 'alarmRecord', 'dqms-1901', null, 2, '1', null, null, 'dqms-367', 'sys_tenant', to_date('2022-07-19 17:45:55','yyyy-mm-dd hh24:mi:ss'), null, '64', null, null, null, null, null, null, null);
INSERT INTO afc_menu (ID, NAME, CODE, RES_ID, DESCRIPTION, SORT_NO, IS_LEAF, TREE_LEVEL, SEQ, PARENT_ID, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED, OPEN_TYPE, MENU_ICON, MENU_TYPE, BUSINESS_OBJ_ID, IS_NEW_WINDOW_OPEN) VALUES ('dqms-468', '问题处理', 'problem', 'dqms-1903', null, 1, '1', null, null, 'dqms-368', 'sys_tenant', to_date('2022-07-19 17:46:45','yyyy-mm-dd hh24:mi:ss'), null, '64', null, null, null, null, null, null, null);
INSERT INTO afc_menu (ID, NAME, CODE, RES_ID, DESCRIPTION, SORT_NO, IS_LEAF, TREE_LEVEL, SEQ, PARENT_ID, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED, OPEN_TYPE, MENU_ICON, MENU_TYPE, BUSINESS_OBJ_ID, IS_NEW_WINDOW_OPEN) VALUES ('dqms-469', '知识库', 'knowledgeinfo', 'dqms-1904', null, 2, '1', null, null, 'dqms-368', 'sys_tenant', to_date('2022-07-19 17:47:10','yyyy-mm-dd hh24:mi:ss'), null, '64', null, null, null, null, null, null, null);
INSERT INTO afc_menu (ID, NAME, CODE, RES_ID, DESCRIPTION, SORT_NO, IS_LEAF, TREE_LEVEL, SEQ, PARENT_ID, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED, OPEN_TYPE, MENU_ICON, MENU_TYPE, BUSINESS_OBJ_ID, IS_NEW_WINDOW_OPEN) VALUES ('dqms-470', '检核指标分析', 'checkIndexAnalysis', 'dqms-1905', null, 1, '1', null, null, 'dqms-369', 'sys_tenant', to_date('2022-07-19 17:48:04','yyyy-mm-dd hh24:mi:ss'), null, '64', null, null, null, null, null, null, null);
INSERT INTO afc_menu (ID, NAME, CODE, RES_ID, DESCRIPTION, SORT_NO, IS_LEAF, TREE_LEVEL, SEQ, PARENT_ID, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED, OPEN_TYPE, MENU_ICON, MENU_TYPE, BUSINESS_OBJ_ID, IS_NEW_WINDOW_OPEN) VALUES ('dqms-471', '检核规则分析', 'checkRuleAnalysis', 'dqms-1906', null, 2, '1', null, null, 'dqms-369', 'sys_tenant', to_date('2022-07-19 17:48:51','yyyy-mm-dd hh24:mi:ss'), null, '64', null, null, null, null, null, null, null);
INSERT INTO afc_menu (ID, NAME, CODE, RES_ID, DESCRIPTION, SORT_NO, IS_LEAF, TREE_LEVEL, SEQ, PARENT_ID, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED, OPEN_TYPE, MENU_ICON, MENU_TYPE, BUSINESS_OBJ_ID, IS_NEW_WINDOW_OPEN) VALUES ('dqms-472', '质量分析报告', 'checkDataAnalysis', 'dqms-1907', null, 3, '1', null, null, 'dqms-369', 'sys_tenant', to_date('2022-07-19 17:49:16','yyyy-mm-dd hh24:mi:ss'), to_date('2022-07-19 17:49:28','yyyy-mm-dd hh24:mi:ss'), '64', '64', null, null, null, null, null, null);
INSERT INTO afc_menu (ID, NAME, CODE, RES_ID, DESCRIPTION, SORT_NO, IS_LEAF, TREE_LEVEL, SEQ, PARENT_ID, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED, OPEN_TYPE, MENU_ICON, MENU_TYPE, BUSINESS_OBJ_ID, IS_NEW_WINDOW_OPEN) VALUES ('dqms-473', '数据源维护', 'dataSourceInfo', 'dqms-1908', null, 1, '1', null, null, 'dqms-370', 'sys_tenant', to_date('2022-07-19 17:50:04','yyyy-mm-dd hh24:mi:ss'), null, '64', null, null, null, null, null, null, null);
INSERT INTO afc_menu (ID, NAME, CODE, RES_ID, DESCRIPTION, SORT_NO, IS_LEAF, TREE_LEVEL, SEQ, PARENT_ID, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED, OPEN_TYPE, MENU_ICON, MENU_TYPE, BUSINESS_OBJ_ID, IS_NEW_WINDOW_OPEN) VALUES ('dqms-474', '数据源配置管理', 'config', 'dqms-1909', null, 2, '1', null, null, 'dqms-370', 'sys_tenant', to_date('2022-07-19 17:50:24','yyyy-mm-dd hh24:mi:ss'), null, '64', null, null, null, null, null, null, null);
INSERT INTO afc_menu (ID, NAME, CODE, RES_ID, DESCRIPTION, SORT_NO, IS_LEAF, TREE_LEVEL, SEQ, PARENT_ID, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED, OPEN_TYPE, MENU_ICON, MENU_TYPE, BUSINESS_OBJ_ID, IS_NEW_WINDOW_OPEN) VALUES ('dqms-475', 'HBase表映射管理', 'Hbaseconfig', 'dqms-1910', null, 3, '1', null, null, 'dqms-370', 'sys_tenant', to_date('2022-07-19 17:50:45','yyyy-mm-dd hh24:mi:ss'), null, '64', null, null, null, null, null, null, null);
INSERT INTO afc_menu (ID, NAME, CODE, RES_ID, DESCRIPTION, SORT_NO, IS_LEAF, TREE_LEVEL, SEQ, PARENT_ID, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED, OPEN_TYPE, MENU_ICON, MENU_TYPE, BUSINESS_OBJ_ID, IS_NEW_WINDOW_OPEN) VALUES ('dqms-43', '操作日志', 'logger', 'dqms-221', null, 3, '1', null, null, 'dqms-81', 'sys_tenant', to_date('2022-12-20 14:18:06','yyyy-mm-dd hh24:mi:ss'), null, 'admin', null, null, null, 'jiandu', null, null, null);
INSERT INTO afc_menu (ID, NAME, CODE, RES_ID, DESCRIPTION, SORT_NO, IS_LEAF, TREE_LEVEL, SEQ, PARENT_ID, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED, OPEN_TYPE, MENU_ICON, MENU_TYPE, BUSINESS_OBJ_ID, IS_NEW_WINDOW_OPEN) VALUES ('dqms-44', '质量评分', 'checkDataScore', 'dqms-222', null, 4, '1', null, null, 'dqms-369', 'sys_tenant', to_date('2022-12-28 15:47:43','yyyy-mm-dd hh24:mi:ss'), null, 'admin', null, null, null, null, null, null, null);
INSERT INTO AFC_MENU (ID, NAME, CODE, RES_ID, DESCRIPTION, SORT_NO, IS_LEAF, TREE_LEVEL, SEQ, PARENT_ID, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED, OPEN_TYPE, MENU_ICON, MENU_TYPE, BUSINESS_OBJ_ID, IS_NEW_WINDOW_OPEN) VALUES ('dqms-81', '安全审计', 'securityAudit', null, null, 10, '0', null, null, 'dqms-442', 'sys_tenant', to_date('2023-01-12 17:27:26','yyyy-mm-dd hh24:mi:ss'), null, 'admin', null, null, null, 'jiandu', null, null, null);
INSERT INTO AFC_MENU (ID, NAME, CODE, RES_ID, DESCRIPTION, SORT_NO, IS_LEAF, TREE_LEVEL, SEQ, PARENT_ID, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED, OPEN_TYPE, MENU_ICON, MENU_TYPE, BUSINESS_OBJ_ID, IS_NEW_WINDOW_OPEN) VALUES ('dqms-82', '产品信息', 'productsInfo', 'dqms-223', null, 10, '1', 0, null, 'dqms-442', 'sys_tenant', to_date('2023-01-12 17:27:26','yyyy-mm-dd hh24:mi:ss'), null, 'admin', null, null, null, 'jiandu', null, null, null);

-- afc_role
DELETE FROM afc_role WHERE ID like 'dqms%';
INSERT INTO afc_role (ID, NAME, CODE, DESCRIPTION, ROLE_TPL_ID, TYPES, BUSINESS_OBJ_ID, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-92', '数据质量管理员', 'dqms-admin', '', null, 'platform', null, 'sys_tenant', to_date('2022-07-19 03:37:45','yyyy-mm-dd hh24:mi:ss'), null, '64', null, '0');

INSERT INTO afc_r_party_role (ID, PARTY_TYPE, PARTY_ID, ROLE_TYPE, ROLE_ID, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, IS_FIXED) VALUES ('dqms-128', 'user', '1', 'platform', 'dqms-92', null, null, null);

-- afc_system_variable
DELETE FROM afc_system_variable WHERE RES_GROUP_ID LIKE 'quality%';

INSERT INTO afc_system_variable (ID, CODE, NAME, VALUE, RES_GROUP_ID, IS_ENCRYPT, DESCRIPTION, SOURCE, CREATE_USER, UPDATE_USER, TENANT_ID, CREATE_TIME, UPDATE_TIME, TYPES, APP_ID)VALUES ('quality-11', 'mdm.server.url', 'mdm_server_url', 'http://10.15.15.130:29898', 'quality-11', '0', null, null, null, null, 'sys_tenant', to_date('2022-12-30 12:00:00','yyyy-mm-dd hh24:mi:ss'), null, 'platform', null);
INSERT INTO afc_system_variable (ID, CODE, NAME, VALUE, RES_GROUP_ID, IS_ENCRYPT, DESCRIPTION, SOURCE, CREATE_USER, UPDATE_USER, TENANT_ID, CREATE_TIME, UPDATE_TIME, TYPES, APP_ID)VALUES('quality-12', 'mdm.server.token', 'mdm_server_token', '501143620fac471bb1ec2840e09f091d', 'quality-11', '0', null, null, null, null, 'sys_tenant', to_date('2022-12-30 12:00:00','yyyy-mm-dd hh24:mi:ss'), null, 'platform', null);
INSERT INTO afc_system_variable (ID, CODE, NAME, VALUE, RES_GROUP_ID, IS_ENCRYPT, DESCRIPTION, SOURCE, CREATE_USER, UPDATE_USER, TENANT_ID, CREATE_TIME, UPDATE_TIME, TYPES, APP_ID)VALUES('quality-13', 'mdm.frequency.name', 'mdm_frequency_name', 'mdm_frequency', 'quality-11', '0', null, null, null, null, 'sys_tenant', to_date('2022-12-30 12:00:00','yyyy-mm-dd hh24:mi:ss'), null, 'platform', null);
INSERT INTO afc_system_variable (ID, CODE, NAME, VALUE, RES_GROUP_ID, IS_ENCRYPT, DESCRIPTION, SOURCE, CREATE_USER, UPDATE_USER, TENANT_ID, CREATE_TIME, UPDATE_TIME, TYPES, APP_ID)VALUES('quality-14', 'mdm.index.id', 'mdm_index_id', '775617973328220160', 'quality-11', '0', null, null, null, null, 'sys_tenant', to_date('2022-12-30 12:00:00','yyyy-mm-dd hh24:mi:ss'), null, 'platform', null);
INSERT INTO afc_system_variable (ID, CODE, NAME, VALUE, RES_GROUP_ID, IS_ENCRYPT, DESCRIPTION, SOURCE, CREATE_USER, UPDATE_USER, TENANT_ID, CREATE_TIME, UPDATE_TIME, TYPES, APP_ID)VALUES('quality-15', 'mdm.datasource.id', 'mdm_datasource_id', '775620198016421888', 'quality-11', '0', null, null, null, null, 'sys_tenant', to_date('2022-12-30 12:00:00','yyyy-mm-dd hh24:mi:ss'), null, 'platform', null);
INSERT INTO afc_system_variable (ID, CODE, NAME, VALUE, RES_GROUP_ID, IS_ENCRYPT, DESCRIPTION, SOURCE, CREATE_USER, UPDATE_USER, TENANT_ID, CREATE_TIME, UPDATE_TIME, TYPES, APP_ID)VALUES('quality-16', 'mdm.output.datasource.id', 'mdm_output_datasource_id', '775874119687409664', 'quality-11', '0', null, null, null, null, 'sys_tenant', to_date('2022-12-30 12:00:00','yyyy-mm-dd hh24:mi:ss'), null, 'platform', null);
INSERT INTO afc_system_variable (ID, CODE, NAME, VALUE, RES_GROUP_ID, IS_ENCRYPT, DESCRIPTION, SOURCE, CREATE_USER, UPDATE_USER, TENANT_ID, CREATE_TIME, UPDATE_TIME, TYPES, APP_ID)VALUES('quality-17', 'mdm.output.datasource.databaseName', 'mdm_output_datasource_databaseName', 'dqms_result_store', 'quality-11', '0', null, null, null, null, 'sys_tenant', to_date('2022-12-30 12:00:00','yyyy-mm-dd hh24:mi:ss'), null, 'platform', null);
INSERT INTO afc_system_variable (ID, CODE, NAME, VALUE, RES_GROUP_ID, IS_ENCRYPT, DESCRIPTION, SOURCE, CREATE_USER, UPDATE_USER, TENANT_ID, CREATE_TIME, UPDATE_TIME, TYPES, APP_ID)VALUES('quality-18', 'afc.server.url', 'afc_server_url', 'http://10.15.15.136:28085', 'quality-12', '0', null, null, null, null, 'sys_tenant', to_date('2022-12-30 12:00:00','yyyy-mm-dd hh24:mi:ss'), null, 'platform', null);
INSERT INTO afc_system_variable (ID, CODE, NAME, VALUE, RES_GROUP_ID, IS_ENCRYPT, DESCRIPTION, SOURCE, CREATE_USER, UPDATE_USER, TENANT_ID, CREATE_TIME, UPDATE_TIME, TYPES, APP_ID)VALUES('quality-19', 'afc.server.token', 'afc_server_token', 'fe98f2cbf76444169ef209d2f59a9967', 'quality-12', '0', null, null, null, null, 'sys_tenant', to_date('2022-12-30 12:00:00','yyyy-mm-dd hh24:mi:ss'), null, 'platform', null);

DELETE FROM afc_api_token WHERE TOKEN = 'c0101b6109e8478784ceb8897159fe2b';
INSERT INTO afc_api_token (ID, TOKEN, USER_ID, CREATE_TIME, EXPIRE_TIME, REMARK) VALUES ('1', 'c0101b6109e8478784ceb8897159fe2b', '1', to_date('2024-01-25 20:19:02','yyyy-mm-dd hh24:mi:ss'),to_date('2030-12-31 23:59:59','yyyy-mm-dd hh24:mi:ss') , null);

DELETE FROM xxl_job_group WHERE ID IN (9);
INSERT INTO xxl_job_group ( ID ,  APP_NAME ,  TITLE ,  ADDRESS_TYPE ,  ADDRESS_LIST ) VALUES (9, 'quality-executor', 'quality执行器', 0, '');

-- afc_resource
DELETE FROM afc_resource WHERE ID like 'dqms%';
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-1885', '首页', 'quality_ui_index', 'url', 'dqms-66', 'dqms-446', null, null, null, '{"openType":"microApp","mark":"index","url":null,"params":null,"afcenterPath":"http://localhost:9000/","appMark":"quality","microMark":"quality","appCode":"quality"}', 'sys_tenant', to_date('2022-07-19 01:25:05','yyyy-mm-dd hh24:mi:ss'), to_date('2022-09-16 15:39:41','yyyy-mm-dd hh24:mi:ss'), '64', 'fran', null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-1887', '检核规则分组', 'group', 'url', 'dqms-66', 'dqms-449', null, null, null, '{"openType":"microApp","mark":"define/group","url":null,"params":null,"afcenterPath":"/","appMark":"quality","microMark":"quality","appCode":"quality"}', 'sys_tenant', to_date('2022-07-19 03:56:56','yyyy-mm-dd hh24:mi:ss'), to_date('2022-09-16 15:12:34','yyyy-mm-dd hh24:mi:ss'), '64', 'wangyue', null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-1888', '检核规则管理', 'checkRuleManage', 'url', 'dqms-66', 'dqms-449', null, null, null, '{"openType":"microApp","mark":"define/checkRuleManage","url":null,"params":null,"afcenterPath":"/","appMark":"quality","microMark":"quality","appCode":"quality"}', 'sys_tenant', to_date('2022-07-19 03:57:14','yyyy-mm-dd hh24:mi:ss'), to_date('2022-09-16 15:12:50','yyyy-mm-dd hh24:mi:ss'), '64', 'wangyue', null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-1889', '指标信息维护', 'indexinfo', 'url', 'dqms-66', 'dqms-449', null, null, null, '{"openType":"microApp","mark":"define/indexinfo","url":null,"params":null,"afcenterPath":"/","appMark":"quality","microMark":"quality","appCode":"quality"}', 'sys_tenant', to_date('2022-07-19 03:57:33','yyyy-mm-dd hh24:mi:ss'), to_date('2022-09-16 15:12:54','yyyy-mm-dd hh24:mi:ss'), '64', 'wangyue', null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-1890', 'HBase规则维护', 'ruleinfo', 'url', 'dqms-66', 'dqms-449', null, null, null, '{"openType":"microApp","mark":"define/ruleinfo","url":null,"params":null,"afcenterPath":"/","appMark":"quality","microMark":"quality","appCode":"quality"}', 'sys_tenant', to_date('2022-07-19 03:58:01','yyyy-mm-dd hh24:mi:ss'), to_date('2022-09-16 15:12:57','yyyy-mm-dd hh24:mi:ss'), '64', 'wangyue', null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-1891', '通用检核配置', 'commoncheckconf', 'url', 'dqms-66', 'dqms-449', null, null, null, '{"openType":"microApp","mark":"define/commoncheckconf","url":null,"params":null,"afcenterPath":"/","appMark":"quality","microMark":"quality","appCode":"quality"}', 'sys_tenant', to_date('2022-07-19 03:58:20','yyyy-mm-dd hh24:mi:ss'), to_date('2022-09-16 15:15:01','yyyy-mm-dd hh24:mi:ss'), '64', 'wangyue', null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-1892', '频度管理', 'frequency', 'url', 'dqms-66', 'dqms-450', null, null, null, '{"openType":"microApp","mark":"dispatch/frequency","url":null,"params":null,"afcenterPath":"/","appMark":"quality","microMark":"quality","appCode":"quality"}', 'sys_tenant', to_date('2022-07-19 03:58:42','yyyy-mm-dd hh24:mi:ss'), to_date('2022-09-16 15:13:13','yyyy-mm-dd hh24:mi:ss'), '64', 'wangyue', null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-1893', '日历管理', 'calendar', 'url', 'dqms-66', 'dqms-450', null, null, null, '{"openType":"microApp","mark":"dispatch/calendar","url":null,"params":null,"afcenterPath":"/","appMark":"quality","microMark":"quality","appCode":"quality"}', 'sys_tenant', to_date('2022-07-19 03:58:57','yyyy-mm-dd hh24:mi:ss'), to_date('2022-09-16 15:13:17','yyyy-mm-dd hh24:mi:ss'), '64', 'wangyue', null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-1894', '检核任务管理', 'scheduleInfo', 'url', 'dqms-66', 'dqms-450', null, null, null, '{"openType":"microApp","mark":"dispatch/scheduleInfo","url":null,"params":null,"afcenterPath":"/","appMark":"quality","microMark":"quality","appCode":"quality"}', 'sys_tenant', to_date('2022-07-19 03:59:14','yyyy-mm-dd hh24:mi:ss'), to_date('2022-09-16 15:13:20','yyyy-mm-dd hh24:mi:ss'), '64', 'wangyue', null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-1895', '检核规则监控', 'checkRuleMonitor', 'url', 'dqms-66', 'dqms-451', null, null, null, '{"openType":"microApp","mark":"monitor/checkRuleMonitor","url":null,"params":null,"afcenterPath":"/","appMark":"quality","microMark":"quality","appCode":"quality"}', 'sys_tenant', to_date('2022-07-19 03:59:34','yyyy-mm-dd hh24:mi:ss'), to_date('2022-09-16 15:13:25','yyyy-mm-dd hh24:mi:ss'), '64', 'wangyue', null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-1896', '检核任务监控', 'scheduleMonitor', 'url', 'dqms-66', 'dqms-451', null, null, null, '{"openType":"microApp","mark":"monitor/scheduleMonitor","url":null,"params":null,"afcenterPath":"/","appMark":"quality","microMark":"quality","appCode":"quality"}', 'sys_tenant', to_date('2022-07-19 03:59:51','yyyy-mm-dd hh24:mi:ss'), to_date('2022-09-16 15:13:28','yyyy-mm-dd hh24:mi:ss'), '64', 'wangyue', null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-1897', '检核规则日志', 'checkRuleLogs', 'url', 'dqms-66', 'dqms-451', null, null, null, '{"openType":"microApp","mark":"monitor/checkRuleLogs","url":null,"params":null,"afcenterPath":"/","appMark":"quality","microMark":"quality","appCode":"quality"}', 'sys_tenant', to_date('2022-07-19 04:00:07','yyyy-mm-dd hh24:mi:ss'), to_date('2022-09-16 15:13:31','yyyy-mm-dd hh24:mi:ss'), '64', 'wangyue', null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-1898', '检核结果', 'checkRuleResult', 'url', 'dqms-66', 'dqms-452', null, null, null, '{"openType":"microApp","mark":"result/checkRuleResult","url":null,"params":null,"afcenterPath":"/","appMark":"quality","microMark":"quality","appCode":"quality"}', 'sys_tenant', to_date('2022-07-19 04:00:24','yyyy-mm-dd hh24:mi:ss'), to_date('2022-09-16 15:13:36','yyyy-mm-dd hh24:mi:ss'), '64', 'wangyue', null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-1899', '通用检核详情', 'commoncheckDetail', 'url', 'dqms-66', 'dqms-452', null, null, null, '{"openType":"microApp","mark":"result/commoncheckDetail","url":null,"params":null,"afcenterPath":"/","appMark":"quality","microMark":"quality","appCode":"quality"}', 'sys_tenant', to_date('2022-07-19 04:00:40','yyyy-mm-dd hh24:mi:ss'), to_date('2022-09-16 15:13:39','yyyy-mm-dd hh24:mi:ss'), '64', 'wangyue', null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-1900', '告警配置', 'alarmConfigInfo', 'url', 'dqms-66', 'dqms-453', null, null, null, '{"openType":"microApp","mark":"alarm/alarmConfigInfo","url":null,"params":null,"afcenterPath":"/","appMark":"quality","microMark":"quality","appCode":"quality"}', 'sys_tenant', to_date('2022-07-19 04:00:58','yyyy-mm-dd hh24:mi:ss'), to_date('2022-09-16 15:13:43','yyyy-mm-dd hh24:mi:ss'), '64', 'wangyue', null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-1901', '告警结果', 'alarmRecord', 'url', 'dqms-66', 'dqms-453', null, null, null, '{"openType":"microApp","mark":"alarm/alarmRecord","url":null,"params":null,"afcenterPath":"/","appMark":"quality","microMark":"quality","appCode":"quality"}', 'sys_tenant', to_date('2022-07-19 04:01:12','yyyy-mm-dd hh24:mi:ss'), to_date('2022-09-16 15:13:47','yyyy-mm-dd hh24:mi:ss'), '64', 'wangyue', null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-1903', '问题处理', 'problem', 'url', 'dqms-66', 'dqms-454', null, null, null, '{"openType":"microApp","mark":"problem/problem","url":null,"params":null,"afcenterPath":"/","appMark":"quality","microMark":"quality","appCode":"quality"}', 'sys_tenant', to_date('2022-07-19 04:01:45','yyyy-mm-dd hh24:mi:ss'), to_date('2022-09-16 15:13:53','yyyy-mm-dd hh24:mi:ss'), '64', 'wangyue', null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-1904', '知识库', 'knowledgeinfo', 'url', 'dqms-66', 'dqms-454', null, null, null, '{"openType":"microApp","mark":"problem/knowledgeinfo","url":null,"params":null,"afcenterPath":"/","appMark":"quality","microMark":"quality","appCode":"quality"}', 'sys_tenant', to_date('2022-07-19 04:02:00','yyyy-mm-dd hh24:mi:ss'), to_date('2022-09-16 15:13:57','yyyy-mm-dd hh24:mi:ss'), '64', 'wangyue', null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-1905', '检核指标分析', 'checkIndexAnalysis', 'url', 'dqms-66', 'dqms-455', null, null, null, '{"openType":"microApp","mark":"dqAnalysis/checkIndexAnalysis","url":null,"params":null,"afcenterPath":"/","appMark":"quality","microMark":"quality","appCode":"quality"}', 'sys_tenant', to_date('2022-07-19 04:02:19','yyyy-mm-dd hh24:mi:ss'), to_date('2022-09-16 15:14:05','yyyy-mm-dd hh24:mi:ss'), '64', 'wangyue', null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-1906', '检核规则分析', 'checkRuleAnalysis', 'url', 'dqms-66', 'dqms-455', null, null, null, '{"openType":"microApp","mark":"dqAnalysis/checkRuleAnalysis","url":null,"params":null,"afcenterPath":"/","appMark":"quality","microMark":"quality","appCode":"quality"}', 'sys_tenant', to_date('2022-07-19 04:02:37','yyyy-mm-dd hh24:mi:ss'), to_date('2022-09-16 15:14:08','yyyy-mm-dd hh24:mi:ss'), '64', 'wangyue', null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-1907', '质量分析报告', 'checkDataAnalysis', 'url', 'dqms-66', 'dqms-455', null, null, null, '{"openType":"microApp","mark":"dqAnalysis/checkDataAnalysis","url":null,"params":null,"afcenterPath":"/","appMark":"quality","microMark":"quality","appCode":"quality"}', 'sys_tenant', to_date('2022-07-19 04:02:52','yyyy-mm-dd hh24:mi:ss'), to_date('2022-09-16 15:14:11','yyyy-mm-dd hh24:mi:ss'), '64', 'wangyue', null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-1908', '数据源维护', 'dataSourceInfo', 'url', 'dqms-66', 'dqms-456', null, null, null, '{"openType":"microApp","mark":"dataOperation/dataSourceInfo","url":null,"params":null,"afcenterPath":"/","appMark":"quality","microMark":"quality","appCode":"quality"}', 'sys_tenant', to_date('2022-07-19 04:03:15','yyyy-mm-dd hh24:mi:ss'), to_date('2022-09-16 15:14:14','yyyy-mm-dd hh24:mi:ss'), '64', 'wangyue', null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-1909', '数据源配置管理', 'config', 'url', 'dqms-66', 'dqms-456', null, null, null, '{"openType":"microApp","mark":"dataOperation/config","url":null,"params":null,"afcenterPath":"/","appMark":"quality","microMark":"quality","appCode":"quality"}', 'sys_tenant', to_date('2022-07-19 04:05:13','yyyy-mm-dd hh24:mi:ss'), to_date('2022-09-16 15:14:17','yyyy-mm-dd hh24:mi:ss'), '64', 'wangyue', null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-1910', 'HBase表映射管理', 'Hbaseconfig', 'url', 'dqms-66', 'dqms-456', null, null, null, '{"openType":"microApp","mark":"dataOperation/Hbaseconfig","url":null,"params":null,"afcenterPath":"/","appMark":"quality","microMark":"quality","appCode":"quality"}', 'sys_tenant', to_date('2022-07-19 04:05:28','yyyy-mm-dd hh24:mi:ss'), to_date('2022-09-16 15:14:20','yyyy-mm-dd hh24:mi:ss'), '64', 'wangyue', null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-601', '数据源新增', 'dqms-dataSource-add', 'function', 'dqms-66', 'dqms-456', null, null, null, null, 'sys_tenant', to_date('2022-09-28 11:18:05','yyyy-mm-dd hh24:mi:ss'), to_date('2022-09-29 09:59:23','yyyy-mm-dd hh24:mi:ss'), 'wangyue', 'fran', null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-602', '数据源修改', 'dqms-dataSource-mod', 'function', 'dqms-66', 'dqms-456', null, null, null, null, 'sys_tenant', to_date('2022-09-28 11:18:57','yyyy-mm-dd hh24:mi:ss'), null, 'wangyue', null, null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-605', '数据源配置新增', 'dqms-dataSource-config-add', 'function', 'dqms-66', 'dqms-456', null, null, null, null, 'sys_tenant', to_date('2022-09-28 14:10:38','yyyy-mm-dd hh24:mi:ss'), null, 'wangyue', null, null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-606', '数据源配置修改', 'dqms-dataSource-config-mod', 'function', 'dqms-66', 'dqms-456', null, null, null, null, 'sys_tenant', to_date('2022-09-28 14:10:55','yyyy-mm-dd hh24:mi:ss'), null, 'wangyue', null, null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-221', '操作日志', 'logger', 'url', 'dqms-66', 'dqms-457', null, null, null, '{"openType":"microApp","mark":"securityAudit/logger","url":null,"params":null,"microUrl":null,"microMark":"quality","isLowOrHigh":"high","resourceCode":null,"formStatus":null,"resourceType":null,"viewType":null,"appCode":"quality","query":null,"processDefName":null,"biId":null,"biType":null,"bicode":null}', 'sys_tenant', to_date('2022-12-20 14:09:21','yyyy-mm-dd hh24:mi:ss'),to_date('2022-12-20 14:15:46','yyyy-mm-dd hh24:mi:ss'), 'admin','admin', null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-222', '质量评分', 'checkDataScore', 'url', 'dqms-66', 'dqms-455', null, null, null, '{"openType":"microApp","mark":"dqAnalysis/checkDataScore","url":null,"params":null,"microUrl":null,"microMark":"quality","isLowOrHigh":"high","resourceCode":null,"formStatus":null,"resourceType":null,"viewType":null,"appCode":"quality","query":null,"processDefName":null,"biId":null,"biType":null,"bicode":null}', 'sys_tenant', to_date('2022-12-28 15:40:38','yyyy-mm-dd hh24:mi:ss'), to_date('2022-12-28 16:54:59','yyyy-mm-dd hh24:mi:ss'), 'admin', 'admin', null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-241', '告警配置 - 新增', 'dqms-f-alarm-config-add', 'function', 'dqms-66', 'dqms-453', null, null, null, null, 'sys_tenant', to_date('2023-04-10 23:42:32','yyyy-mm-dd hh24:mi:ss'),to_date('2023-04-17 22:08:44','yyyy-mm-dd hh24:mi:ss'), 'admin', 'admin', null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-242', '告警配置 - 删除', 'dqms-f-alarm-config-delete-by-id', 'function', 'dqms-66', 'dqms-453', null, null, null, null, 'sys_tenant', to_date('2023-04-10 23:43:38','yyyy-mm-dd hh24:mi:ss'), to_date('2023-04-17 22:08:51','yyyy-mm-dd hh24:mi:ss'), 'admin', 'admin', null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-243', '告警配置 - 批量删除', 'dqms-f-alarm-config-delete-by-ids', 'function', 'dqms-66', 'dqms-453', null, null, null, null, 'sys_tenant', to_date('2023-04-10 23:43:56','yyyy-mm-dd hh24:mi:ss'), to_date('2023-04-17 22:08:38','yyyy-mm-dd hh24:mi:ss'), 'admin', 'admin', null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-244', '告警配置 - 修改', 'dqms-f-alarm-config-update', 'function', 'dqms-66', 'dqms-453', null, null, null, null, 'sys_tenant', to_date('2023-04-10 23:44:23','yyyy-mm-dd hh24:mi:ss'), to_date('2023-04-17 22:08:31','yyyy-mm-dd hh24:mi:ss'), 'admin', 'admin', null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-245', '告警配置 - 状态修改', 'dqms-f-alarm-config-update-state', 'function', 'dqms-66', 'dqms-453', null, null, null, null, 'sys_tenant', to_date('2023-04-10 23:45:02','yyyy-mm-dd hh24:mi:ss'), to_date('2023-04-17 22:08:24','yyyy-mm-dd hh24:mi:ss'), 'admin', 'admin', null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-246', '告警记录 - 关闭', 'dqms-f-alarm-record-close-remind', 'function', 'dqms-66', 'dqms-453', null, null, null, null, 'sys_tenant', to_date('2023-04-10 23:58:00','yyyy-mm-dd hh24:mi:ss'), to_date('2023-04-17 22:08:10','yyyy-mm-dd hh24:mi:ss'), 'admin', 'admin', null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-247', '告警记录 - 批量关闭', 'dqms-f-alarm-record-batch-modify-state', 'function', 'dqms-66', 'dqms-453', null, null, null, null, 'sys_tenant', to_date('2023-04-10 23:58:52','yyyy-mm-dd hh24:mi:ss'), to_date('2023-04-17 22:08:17','yyyy-mm-dd hh24:mi:ss'), 'admin', 'admin', null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-248', '数据源配置新增', 'dqms-f-ds-data-config-save', 'function', 'dqms-66', 'dqms-456', null, null, null, null, 'sys_tenant', to_date('2023-04-11 00:00:53','yyyy-mm-dd hh24:mi:ss'), null, 'admin', null, null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-250', '数据源配置修改', 'dqms-f-ds-data-config-update', 'function', 'dqms-66', 'dqms-456', null, null, null, null, 'sys_tenant', to_date('2023-04-11 00:02:32','yyyy-mm-dd hh24:mi:ss'), to_date('2023-04-11 00:02:47','yyyy-mm-dd hh24:mi:ss'), 'admin', 'admin', null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-251', '数据源配置删除', 'dqms-f-ds-data-config-delete', 'function', 'dqms-66', 'dqms-456', null, null, null, null, 'sys_tenant', to_date('2023-04-11 00:03:21','yyyy-mm-dd hh24:mi:ss'), null, 'admin', null, null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-252', '数据源新增', 'dqms-f-ds-data-source-add', 'function', 'dqms-66', 'dqms-456', null, null, null, null, 'sys_tenant', to_date('2023-04-11 00:12:04','yyyy-mm-dd hh24:mi:ss'), null, 'admin', null, null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-253', '数据源删除', 'dqms-f-ds-data-source-delete', 'function', 'dqms-66', 'dqms-456', null, null, null, null, 'sys_tenant', to_date('2023-04-11 00:12:20','yyyy-mm-dd hh24:mi:ss'), null, 'admin', null, null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-254', '数据源修改', 'dqms-f-ds-data-source-update', 'function', 'dqms-66', 'dqms-456', null, null, null, null, 'sys_tenant', to_date('2023-04-11 00:12:37','yyyy-mm-dd hh24:mi:ss'), null, 'admin', null, null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-255', '数据源 - 测试连接', 'dqms-f-ds-data-source-test-connect', 'function', 'dqms-66', 'dqms-456', null, null, null, null, 'sys_tenant', to_date('2023-04-11 00:13:02','yyyy-mm-dd hh24:mi:ss'), null, 'admin', null, null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-256', 'hbase表映射配置删除', 'dqms-f-hbase-table-mapping-del', 'function', 'dqms-66', 'dqms-456', null, null, null, null, 'sys_tenant', to_date('2023-04-11 00:14:15','yyyy-mm-dd hh24:mi:ss'), null, 'admin', null, null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-257', 'hbase表映射配置新增', 'dqms-f-hbase-table-mapping-save', 'function', 'dqms-66', 'dqms-456', null, null, null, null, 'sys_tenant', to_date('2023-04-11 00:14:34','yyyy-mm-dd hh24:mi:ss'), null, 'admin', null, null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-258', 'hbase映射表创建', 'dqms-f-hbase-table-mapping-create-table', 'function', 'dqms-66', 'dqms-456', null, null, null, null, 'sys_tenant', to_date('2023-04-11 00:15:01','yyyy-mm-dd hh24:mi:ss'), null, 'admin', null, null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-259', '日历 - 新增', 'dqms-f-calendar-add', 'function', 'dqms-66', 'dqms-450', null, null, null, null, 'sys_tenant', to_date('2023-04-11 00:15:41','yyyy-mm-dd hh24:mi:ss'), to_date('2023-04-14 00:13:43','yyyy-mm-dd hh24:mi:ss'), 'admin', 'admin', null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-260', '日历 - 修改', 'dqms-f-calendar-update', 'function', 'dqms-66', 'dqms-450', null, null, null, null, 'sys_tenant', to_date('2023-04-11 00:15:57','yyyy-mm-dd hh24:mi:ss'), to_date('2023-04-14 00:13:54','yyyy-mm-dd hh24:mi:ss'), 'admin', 'admin', null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-261', '日历 - 删除', 'dqms-f-calendar-delete-by-name', 'function', 'dqms-66', 'dqms-450', null, null, null, null, 'sys_tenant', to_date('2023-04-11 00:19:54','yyyy-mm-dd hh24:mi:ss'), to_date('2023-04-14 00:14:01','yyyy-mm-dd hh24:mi:ss'), 'admin', 'admin', null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-263', '检核结果转问题', 'dqms-f-res-check-save-problem', 'function', 'dqms-66', 'dqms-452', null, null, null, null, 'sys_tenant', to_date('2023-04-11 00:52:37','yyyy-mm-dd hh24:mi:ss'), null, 'admin', null, null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-264', '检核结果 - 问题关闭', 'dqms-f-res-check-save-close-problem', 'function', 'dqms-66', 'dqms-454', null, null, null, null, 'sys_tenant', to_date('2023-04-11 00:53:12','yyyy-mm-dd hh24:mi:ss'), to_date('2023-04-14 23:13:14','yyyy-mm-dd hh24:mi:ss'), 'admin', 'admin', null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-350', '检核结果列表导出', 'dqms-f-res-check-excel-export', 'function', 'dqms-66', 'dqms-452', null, null, null, '将检核结果列表导出为xlsx', 'sys_tenant', to_date('2023-06-07 00:42:44','yyyy-mm-dd hh24:mi:ss'), null, 'admin', null, null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-265', '检核规则管理 - 删除', 'dqms-f-res-check-del-by-config-sid', 'function', 'dqms-66', 'dqms-449', null, null, null, null, 'sys_tenant', to_date('2023-04-11 17:41:36','yyyy-mm-dd hh24:mi:ss'), to_date('2023-04-11 22:52:47','yyyy-mm-dd hh24:mi:ss'), 'admin', 'admin', null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-266', '检核规则立即执行', 'dqms-f-res-check-immediate-exe', 'function', 'dqms-66', 'dqms-451', null, null, null, null, 'sys_tenant', to_date('2023-04-11 17:42:58','yyyy-mm-dd hh24:mi:ss'), null, 'admin', null, null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-267', '检核结果下载', 'dqms-f-res-check-download-ftp', 'function', 'dqms-66', 'dqms-452', null, null, null, null, 'sys_tenant', to_date('2023-04-11 17:44:52','yyyy-mm-dd hh24:mi:ss'), null, 'admin', null, null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-268', '检核规则监控状态重置', 'dqms-f-res-check-re-set-method-monitor', 'function', 'dqms-66', 'dqms-451', null, null, null, null, 'sys_tenant', to_date('2023-04-11 17:45:49','yyyy-mm-dd hh24:mi:ss'), null, 'admin', null, null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-282', '检核规则管理 - 新增', 'dqms-f-method-config-add-tradition-method', 'function', 'dqms-66', 'dqms-449', null, null, null, null, 'sys_tenant', to_date('2023-04-11 22:52:32','yyyy-mm-dd hh24:mi:ss'), null, 'admin', null, null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-290', '检核规则管理 - 状态 -> 停用', 'dqms-f-method-config-stop-config', 'function', 'dqms-66', 'dqms-449', null, null, null, null, 'sys_tenant', to_date('2023-04-12 23:40:00','yyyy-mm-dd hh24:mi:ss'), to_date('2023-04-12 23:41:00','yyyy-mm-dd hh24:mi:ss'), 'admin', 'admin', null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-291', '检核规则管理 - 状态 -> 启用', 'dqms-f-method-config-start-config', 'function', 'dqms-66', 'dqms-449', null, null, null, null, 'sys_tenant', to_date('2023-04-12 23:40:33','yyyy-mm-dd hh24:mi:ss'), null, 'admin', null, null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-297', '检核规则管理 - hbase导入模板下载', 'dqms-f-method-config-down-for-ct', 'function', 'dqms-66', 'dqms-449', null, null, null, null, 'sys_tenant', to_date('2023-04-13 01:00:19','yyyy-mm-dd hh24:mi:ss'), null, 'admin', null, null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-298', '检核规则管理 - hbase导入', 'dqms-f-method-config-import-data-for-ct', 'function', 'dqms-66', 'dqms-449', null, null, null, null, 'sys_tenant', to_date('2023-04-13 01:03:25','yyyy-mm-dd hh24:mi:ss'), null, 'admin', null, null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-299', '检核规则管理 - jdbc导入模板下载', 'dqms-f-x-check-config-sql-template', 'function', 'dqms-66', 'dqms-449', null, null, null, null, 'sys_tenant', to_date('2023-04-13 02:26:00','yyyy-mm-dd hh24:mi:ss'), null, 'admin', null, null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-300', 'jdbc导入', 'dqms-f-x-check-config-import-data', 'function', 'dqms-66', 'dqms-449', null, null, null, null, 'sys_tenant', to_date('2023-04-13 02:26:18','yyyy-mm-dd hh24:mi:ss'), null, 'admin', null, null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-301', '频度 - 新增', 'dqms-f-frequency-add', 'function', 'dqms-66', 'dqms-450', null, null, null, null, 'sys_tenant', to_date('2023-04-14 00:14:20','yyyy-mm-dd hh24:mi:ss'), to_date('2023-04-14 00:14:32','yyyy-mm-dd hh24:mi:ss'), 'admin', 'admin', null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-302', '频度 - 修改', 'dqms-f-frequency-update', 'function', 'dqms-66', 'dqms-450', null, null, null, null, 'sys_tenant', to_date('2023-04-14 00:14:50','yyyy-mm-dd hh24:mi:ss'), null, 'admin', null, null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-303', '频度 - 删除', 'dqms-f-frequency-delete-batch', 'function', 'dqms-66', 'dqms-450', null, null, null, null, 'sys_tenant', to_date('2023-04-14 00:15:11','yyyy-mm-dd hh24:mi:ss'), null, 'admin', null, null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-304', '通用检核 - 新增', 'dqms-f-general-config-add-general-config', 'function', 'dqms-66', 'dqms-449', null, null, null, null, 'sys_tenant', to_date('2023-04-14 01:14:31','yyyy-mm-dd hh24:mi:ss'), null, 'admin', null, null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-305', '通用检核 - 数据对照新增', 'dqms-f-general-config-add-general-config-for-data-compare', 'function', 'dqms-66', 'dqms-449', null, null, null, null, 'sys_tenant', to_date('2023-04-14 01:15:02','yyyy-mm-dd hh24:mi:ss'), null, 'admin', null, null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-306', '通用检核 - 删除', 'dqms-f-general-config-delete-by-ids', 'function', 'dqms-66', 'dqms-449', null, null, null, null, 'sys_tenant', to_date('2023-04-14 01:15:26','yyyy-mm-dd hh24:mi:ss'), null, 'admin', null, null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-307', '通用检核 - 修改', 'dqms-f-general-config-update-general-config', 'function', 'dqms-66', 'dqms-449', null, null, null, null, 'sys_tenant', to_date('2023-04-14 01:15:44','yyyy-mm-dd hh24:mi:ss'), null, 'admin', null, null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-308', '通用检核 - 状态修改', 'dqms-f-general-config-update-general-config-state', 'function', 'dqms-66', 'dqms-449', null, null, null, null, 'sys_tenant', to_date('2023-04-14 01:16:05','yyyy-mm-dd hh24:mi:ss'), null, 'admin', null, null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-309', '通用检核 - 新增（页面）', 'dqms-f-general-config-add', 'function', 'dqms-66', 'dqms-449', null, null, null, null, 'sys_tenant', to_date('2023-04-14 01:16:26','yyyy-mm-dd hh24:mi:ss'), to_date('2023-04-14 02:21:34','yyyy-mm-dd hh24:mi:ss'), 'admin', 'admin', null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-310', '检核规则管理 - 导入（页面）', 'dqms-f-method-config-import', 'function', 'dqms-66', 'dqms-449', null, null, null, null, 'sys_tenant', to_date('2023-04-14 01:44:49','yyyy-mm-dd hh24:mi:ss'), to_date('2023-04-14 02:21:44','yyyy-mm-dd hh24:mi:ss'), 'admin', 'admin', null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-311', '分组 - 新增', 'dqms-f-group-add', 'function', 'dqms-66', 'dqms-449', null, null, null, null, 'sys_tenant', to_date('2023-04-14 02:22:06','yyyy-mm-dd hh24:mi:ss'), null, 'admin', null, null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-312', '分组 - 批量删除分组信息', 'dqms-f-group-delete-batch', 'function', 'dqms-66', 'dqms-449', null, null, null, null, 'sys_tenant', to_date('2023-04-14 02:22:24','yyyy-mm-dd hh24:mi:ss'), to_date('2023-04-14 02:23:32','yyyy-mm-dd hh24:mi:ss'), 'admin', 'admin', null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-314', '分组 - 修改', 'dqms-f-group-update-relation', 'function', 'dqms-66', 'dqms-449', null, null, null, null, 'sys_tenant', to_date('2023-04-14 02:24:04','yyyy-mm-dd hh24:mi:ss'), null, 'admin', null, null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-315', '分组 - 规则/指标指定分组', 'dqms-f-group-add-relation-batch', 'function', 'dqms-66', 'dqms-449', null, null, null, null, 'sys_tenant', to_date('2023-04-14 02:26:06','yyyy-mm-dd hh24:mi:ss'), null, 'admin', null, null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-317', '指标 - 新增', 'dqms-f-index-info-add', 'function', 'dqms-66', 'dqms-449', null, null, null, null, 'sys_tenant', to_date('2023-04-14 02:27:04','yyyy-mm-dd hh24:mi:ss'), null, 'admin', null, null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-318', '指标 - 删除', 'dqms-f-index-info-delete', 'function', 'dqms-66', 'dqms-449', null, null, null, null, 'sys_tenant', to_date('2023-04-14 02:27:21','yyyy-mm-dd hh24:mi:ss'), null, 'admin', null, null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-319', '指标 - 更新', 'dqms-f-index-info-update', 'function', 'dqms-66', 'dqms-449', null, null, null, null, 'sys_tenant', to_date('2023-04-14 02:27:37','yyyy-mm-dd hh24:mi:ss'), null, 'admin', null, null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-320', '知识库 - 保存（页面）', 'dqms-f-knowledge-info-save', 'function', 'dqms-66', 'dqms-454', null, null, null, null, 'sys_tenant', to_date('2023-04-14 22:03:25','yyyy-mm-dd hh24:mi:ss'), null, 'admin', null, null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-321', '知识库 - 新增', 'dqms-f-knowledge-info-add', 'function', 'dqms-66', 'dqms-454', null, null, null, null, 'sys_tenant', to_date('2023-04-14 22:03:48','yyyy-mm-dd hh24:mi:ss'), null, 'admin', null, null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-322', '知识库 - 修改', 'dqms-f-knowledge-info-update', 'function', 'dqms-66', 'dqms-454', null, null, null, null, 'sys_tenant', to_date('2023-04-14 22:04:06','yyyy-mm-dd hh24:mi:ss'), null, 'admin', null, null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-324', '问题处理 - 添加反馈', 'dqms-f-option-save-feedback', 'function', 'dqms-66', 'dqms-454', null, null, null, null, 'sys_tenant', to_date('2023-04-14 23:04:04','yyyy-mm-dd hh24:mi:ss'), null, 'admin', null, null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-325', '问题处理 - 新增', 'dqms-f-option-save-option', 'function', 'dqms-66', 'dqms-454', null, null, null, null, 'sys_tenant', to_date('2023-04-14 23:04:30','yyyy-mm-dd hh24:mi:ss'), null, 'admin', null, null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-326', '问题处理 - 关闭', 'dqms-f-option-update-state', 'function', 'dqms-66', 'dqms-454', null, null, null, null, 'sys_tenant', to_date('2023-04-14 23:04:57','yyyy-mm-dd hh24:mi:ss'), null, 'admin', null, null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-327', 'hbase规则维护 - 新增', 'dqms-f-rule-info-add', 'function', 'dqms-66', 'dqms-449', null, null, null, null, 'sys_tenant', to_date('2023-04-14 23:28:44','yyyy-mm-dd hh24:mi:ss'), null, 'admin', null, null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-328', 'hbase规则维护 - 删除', 'dqms-f-rule-info-delete', 'function', 'dqms-66', 'dqms-449', null, null, null, null, 'sys_tenant', to_date('2023-04-14 23:29:05','yyyy-mm-dd hh24:mi:ss'), null, 'admin', null, null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-329', 'hbase规则维护 - 删除', 'dqms-f-rule-info-update', 'function', 'dqms-66', 'dqms-449', null, null, null, null, 'sys_tenant', to_date('2023-04-14 23:29:31','yyyy-mm-dd hh24:mi:ss'), null, 'admin', null, null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-330', '检核任务管理 - 新增', 'dqms-f-schedule-config-add', 'function', 'dqms-66', 'dqms-450', null, null, null, null, 'sys_tenant', to_date('2023-04-15 00:04:17','yyyy-mm-dd hh24:mi:ss'), null, 'admin', null, null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-331', '检核任务管理 - 删除', 'dqms-f-schedule-config-delete', 'function', 'dqms-66', 'dqms-450', null, '检核工作台使用', null, null, 'sys_tenant', to_date('2023-04-15 00:05:19','yyyy-mm-dd hh24:mi:ss'), null, 'admin', null, null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-332', '检核任务管理 - 修改', 'dqms-f-schedule-config-update', 'function', 'dqms-66', 'dqms-450', null, null, null, null, 'sys_tenant', to_date('2023-04-15 00:06:04','yyyy-mm-dd hh24:mi:ss'), null, 'admin', null, null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-333', '检核任务管理 - 启用', 'dqms-f-schedule-config-start-schedule', 'function', 'dqms-66', 'dqms-450', null, null, null, null, 'sys_tenant', to_date('2023-04-15 00:06:25','yyyy-mm-dd hh24:mi:ss'), null, 'admin', null, null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-334', '检核任务管理 - 停用', 'dqms-f-schedule-config-stop-schedule', 'function', 'dqms-66', 'dqms-450', null, null, null, null, 'sys_tenant', to_date('2023-04-15 00:06:55','yyyy-mm-dd hh24:mi:ss'), null, 'admin', null, null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-335', '检核工作台 - 批量删除', 'dqms-f-schedule-config-delete-batch', 'function', 'dqms-66', 'dqms-450', null, null, null, null, 'sys_tenant', to_date('2023-04-15 00:07:23','yyyy-mm-dd hh24:mi:ss'), null, 'admin', null, null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-336', '检核任务管理 - 批量启用', 'dqms-f-schedule-config-start-schedule-batch', 'function', 'dqms-66', 'dqms-450', null, null, null, null, 'sys_tenant', to_date('2023-04-15 00:08:08','yyyy-mm-dd hh24:mi:ss'), null, 'admin', null, null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-337', '检核任务管理 - 批量停用', 'dqms-f-schedule-config-stop-schedule-batch', 'function', 'dqms-66', 'dqms-450', null, null, null, null, 'sys_tenant', to_date('2023-04-15 00:08:27','yyyy-mm-dd hh24:mi:ss'), null, 'admin', null, null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-338', '检核任务管理 - 立即执行', 'dqms-f-schedule-config-start-schedule-now', 'function', 'dqms-66', 'dqms-450', null, null, null, null, 'sys_tenant', to_date('2023-04-15 00:09:17','yyyy-mm-dd hh24:mi:ss'), null, 'admin', null, null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-341', '检核任务管理 - 状态切换（页面）', 'dqms-f-schedule-config-update-state', 'function', 'dqms-66', 'dqms-450', null, '启用\\停用', null, null, 'sys_tenant', to_date('2023-04-15 00:14:46','yyyy-mm-dd hh24:mi:ss'), null, 'admin', null, null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-342', '分组 - 删除（页面）', 'dqms-f-group-delete', 'function', 'dqms-66', 'dqms-449', null, null, null, null, 'sys_tenant', to_date('2023-04-17 23:46:19','yyyy-mm-dd hh24:mi:ss'), null, 'admin', null, null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-343', '检核规则管理 - 修改', 'dqms-f-method-config-edit-tradition-method', 'function', 'dqms-66', 'dqms-449', null, null, null, null, 'sys_tenant', to_date('2023-04-18 01:20:28','yyyy-mm-dd hh24:mi:ss'), null, 'admin', null, null);
INSERT INTO AFC_RESOURCE (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-373', '质量分析报告 - 下载pdf', null, 'function', 'dqms-66', 'dqms-455', null, null, null, null, 'sys_tenant', to_date('2023-04-15 00:14:46','yyyy-mm-dd hh24:mi:ss'), null, 'admin', null, null);
INSERT INTO AFC_RESOURCE (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-374', '质量分析报告 - 下载word', null, 'function', 'dqms-66', 'dqms-455', null, null, null, null, 'sys_tenant', to_date('2023-04-15 00:14:46','yyyy-mm-dd hh24:mi:ss'), null, 'admin', null, null);
INSERT INTO AFC_RESOURCE (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-375', '质量分析报告 - 导出excel', null, 'function', 'dqms-66', 'dqms-455', null, null, null, null, 'sys_tenant', to_date('2023-04-15 00:14:46','yyyy-mm-dd hh24:mi:ss'), null, 'admin', null, null);
INSERT INTO AFC_RESOURCE (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-223', '产品信息', 'productsInfo', 'url', 'dqms-66', 'dqms-458', null, null, null, '{"openType":"microApp","mark":"products-info/info","url":null,"params":null,"microUrl":null,"microMark":"quality","isLowOrHigh":"high","resourceCode":null,"formStatus":null,"resourceType":null,"viewType":null,"appCode":"quality","query":null,"processDefName":null,"biId":null,"biType":null,"bicode":null}', 'sys_tenant',to_date('2022-12-20 14:09:21','yyyy-mm-dd hh24:mi:ss') ,to_date('2022-12-20 14:15:46','yyyy-mm-dd hh24:mi:ss'), 'admin','admin', null);
INSERT INTO AFC_RESOURCE (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-365', '检核工作台 - 检核任务新增（页面）', 'dqms-f-method-config-add-task', 'function', 'dqms-66', 'dqms-449', null, '页面tree', null, null, 'sys_tenant', to_date('2023-04-19 17:50:03','yyyy-mm-dd hh24:mi:ss'), null, 'admin', null, null);
INSERT INTO AFC_RESOURCE (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-366', '检核工作台 - 检核任务修改（页面）', 'dqms-f-method-config-edit-task', 'function', 'dqms-66', 'dqms-449', null, '页面tree', null, null, 'sys_tenant', to_date('2023-04-19 17:50:33','yyyy-mm-dd hh24:mi:ss'), null, 'admin', null, null);
INSERT INTO AFC_RESOURCE (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-367', '检核工作台 - 检核任务删除（页面）', 'dqms-f-method-config-del-task', 'function', 'dqms-66', 'dqms-449', null, '页面tree', null, null, 'sys_tenant', to_date('2023-04-19 17:50:56','yyyy-mm-dd hh24:mi:ss'), null, 'admin', null, null);
INSERT INTO AFC_RESOURCE (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-368', '检核工作台 - 检核任务启用（页面）', 'dqms-f-method-config-start-task', 'function', 'dqms-66', 'dqms-449', null, '页面tree', null, null, 'sys_tenant', to_date('2023-04-19 17:51:38','yyyy-mm-dd hh24:mi:ss'), null, 'admin', null, null);
INSERT INTO AFC_RESOURCE (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-369', '检核工作台 - 检核任务停用（页面）', 'dqms-f-method-config-stop-task', 'function', 'dqms-66', 'dqms-449', null, '页面tree', null, null, 'sys_tenant', to_date('2023-04-19 17:52:09','yyyy-mm-dd hh24:mi:ss'), null, 'admin', null, null);

-- afc_r_res_role
DELETE FROM AFC_R_RES_ROLE WHERE ID like 'dqms%';
INSERT INTO AFC_R_RES_ROLE (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-425', 'dqms-223', 'url', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO AFC_R_RES_ROLE (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1202', 'dqms-300', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-3353', 'dqms-1885', 'url', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-3355', 'dqms-1887', 'url', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-3356', 'dqms-1888', 'url', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-3357', 'dqms-1889', 'url', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-3358', 'dqms-1890', 'url', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-3359', 'dqms-1891', 'url', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-3360', 'dqms-1892', 'url', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-3921', 'dqms-1893', 'url', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-3922', 'dqms-1894', 'url', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-3923', 'dqms-1895', 'url', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-3924', 'dqms-1896', 'url', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-3925', 'dqms-1897', 'url', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-3926', 'dqms-1898', 'url', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-3927', 'dqms-1899', 'url', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-3928', 'dqms-1900', 'url', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-3929', 'dqms-1901', 'url', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-3931', 'dqms-1903', 'url', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-3932', 'dqms-1904', 'url', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-3933', 'dqms-1905', 'url', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-3934', 'dqms-1906', 'url', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-3935', 'dqms-1907', 'url', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-3936', 'dqms-1908', 'url', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-3937', 'dqms-1909', 'url', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-3938', 'dqms-1910', 'url', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-2265', 'dqms-601', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-2266', 'dqms-602', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-2267', 'dqms-605', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-2268', 'dqms-606', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-424', 'dqms-221', 'url', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-423', 'dqms-222', 'url', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-822', 'dqms-350', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1116', 'dqms-265', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1118', 'dqms-282', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1125', 'dqms-290', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1126', 'dqms-291', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1132', 'dqms-297', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1133', 'dqms-298', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1134', 'dqms-299', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1135', 'dqms-304', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1136', 'dqms-305', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1137', 'dqms-306', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1138', 'dqms-307', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1139', 'dqms-308', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1140', 'dqms-309', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1141', 'dqms-310', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1142', 'dqms-311', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1143', 'dqms-312', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1144', 'dqms-313', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1145', 'dqms-314', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1146', 'dqms-315', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1147', 'dqms-317', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1148', 'dqms-318', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1149', 'dqms-319', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1150', 'dqms-327', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1151', 'dqms-328', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1152', 'dqms-329', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1153', 'dqms-342', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1154', 'dqms-343', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1155', 'dqms-259', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1156', 'dqms-260', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1157', 'dqms-261', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1158', 'dqms-301', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1159', 'dqms-302', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1160', 'dqms-303', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1161', 'dqms-330', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1162', 'dqms-331', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1163', 'dqms-332', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1164', 'dqms-333', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1165', 'dqms-334', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1166', 'dqms-335', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1167', 'dqms-336', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1168', 'dqms-337', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1169', 'dqms-338', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1170', 'dqms-341', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1171', 'dqms-266', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1172', 'dqms-268', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1173', 'dqms-263', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1174', 'dqms-267', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1175', 'dqms-241', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1176', 'dqms-242', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1177', 'dqms-243', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1178', 'dqms-244', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1179', 'dqms-245', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1180', 'dqms-246', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1181', 'dqms-247', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1182', 'dqms-264', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1183', 'dqms-320', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1184', 'dqms-321', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1185', 'dqms-322', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1186', 'dqms-324', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1187', 'dqms-325', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1188', 'dqms-326', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1189', 'dqms-248', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1190', 'dqms-250', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1191', 'dqms-251', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1192', 'dqms-252', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1193', 'dqms-253', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1194', 'dqms-254', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1195', 'dqms-255', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1196', 'dqms-256', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1197', 'dqms-257', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1198', 'dqms-258', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-449', 'dqms-316', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO AFC_R_RES_ROLE (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1199', 'dqms-373', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO AFC_R_RES_ROLE (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1200', 'dqms-374', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO AFC_R_RES_ROLE (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1201', 'dqms-375', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO AFC_R_RES_ROLE (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1207', 'dqms-365', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO AFC_R_RES_ROLE (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1203', 'dqms-366', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO AFC_R_RES_ROLE (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1204', 'dqms-367', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO AFC_R_RES_ROLE (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1205', 'dqms-368', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO AFC_R_RES_ROLE (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1206', 'dqms-369', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
DELETE FROM XXL_JOB_INFO WHERE ID IN (1);
INSERT INTO XXL_JOB_INFO (ID, JOB_GROUP, JOB_DESC, ADD_TIME, UPDATE_TIME, AUTHOR, ALARM_EMAIL, SCHEDULE_TYPE, SCHEDULE_CONF, MISFIRE_STRATEGY, EXECUTOR_ROUTE_STRATEGY, EXECUTOR_HANDLER, EXECUTOR_PARAM, EXECUTOR_BLOCK_STRATEGY, EXECUTOR_TIMEOUT, EXECUTOR_FAIL_RETRY_COUNT, GLUE_TYPE, GLUE_SOURCE, GLUE_REMARK, GLUE_UPDATETIME, CHILD_JOBID, TRIGGER_STATUS, TRIGGER_LAST_TIME, TRIGGER_NEXT_TIME) VALUES (1, 9, '告警结果生成任务', to_date('2024-02-27 01:45:14','yyyy-mm-dd hh24:mi:ss'), to_date('2024-02-27 01:45:14','yyyy-mm-dd hh24:mi:ss'), 'admin', null, 'CRON', '0 0/30 * * * ?', 'DO_NOTHING', 'FIRST', 'alarmRecordJobHandler', null, 'SERIAL_EXECUTION', 0, 0, 'BEAN', null, null, to_date('2024-02-27 01:45:14','yyyy-mm-dd hh24:mi:ss'), null, 0, 0, 0);


CREATE TABLE COF_DICT_ENTRY (
  ID VARCHAR2(64) NOT NULL ,
  CODE VARCHAR2(64) ,
  DICT_TYPE_ID VARCHAR2(64) ,
  NAME VARCHAR2(512) ,
  DESCRIPTION VARCHAR2(256) ,
  CREATE_TIME DATE ,
  UPDATE_TIME DATE ,
  TENANT_ID VARCHAR2(64) ,
  PARENT_ID VARCHAR2(64) ,
  LOCALE VARCHAR2(64) ,
  STATUS VARCHAR2(64) ,
  SORT_NO NUMBER(11) ,
  IS_LEAF NUMBER(1) ,
  TREE_LEVEL NUMBER(11) ,
  SEQ VARCHAR2(256) ,
  IS_FIXED NUMBER(1)
);

CREATE TABLE COF_DICT_TYPE (
  ID VARCHAR2(64) NOT NULL ,
  CODE VARCHAR2(64) ,
  NAME VARCHAR2(150) ,
  DESCRIPTION VARCHAR2(256) ,
  CREATE_TIME DATE ,
  UPDATE_TIME DATE ,
  TENANT_ID VARCHAR2(64) ,
  PARENT_ID VARCHAR2(64) ,
  LOCALE VARCHAR2(64) ,
  SORT_NO NUMBER(11) ,
  IS_LEAF NUMBER(1) ,
  TREE_LEVEL NUMBER(11) ,
  SEQ VARCHAR2(256) ,
  IS_FIXED NUMBER(1)
);

-- ----------------------------
-- Table structure for CL_DATA_CLASSIF
-- ----------------------------

CREATE TABLE "CL_DATA_CLASSIF"
(
    "RESOURCE_ID"   NUMBER(24, 0) NOT NULL,
    "CLASSIF_SID"   NUMBER(24, 0) NOT NULL,
    "RESOURCE_TYPE" CHAR(1 CHAR),
    "CREATE_BY"     VARCHAR2(255 CHAR),
    "CREATE_TIME"   DATE,
    "UPDATE_BY"     VARCHAR2(255 CHAR),
    "UPDATE_TIME"   DATE
);
COMMENT ON COLUMN "CL_DATA_CLASSIF"."RESOURCE_ID" IS '资源注册后，关联数据资源';
COMMENT ON COLUMN "CL_DATA_CLASSIF"."RESOURCE_TYPE" IS '目录级、数据级、数据项级';

-- ----------------------------
-- Table structure for CL_DATA_LEVEL
-- ----------------------------

CREATE TABLE "CL_DATA_LEVEL"
(
    "RESOURCE_SID"  NUMBER(24, 0) NOT NULL,
    "LEVEL_SID"     NUMBER(24, 0) NOT NULL,
    "RESOURCE_TYPE" CHAR(1 CHAR),
    "CREATE_BY"     VARCHAR2(255 CHAR),
    "CREATE_TIME"   DATE,
    "UPDATE_BY"     VARCHAR2(255 CHAR),
    "UPDATE_TIME"   DATE
);
COMMENT ON COLUMN "CL_DATA_LEVEL"."RESOURCE_SID" IS '资源注册后，关联数据资源';
COMMENT ON COLUMN "CL_DATA_LEVEL"."RESOURCE_TYPE" IS '0目录级、1数据级、2数据项级';

-- ----------------------------
-- Table structure for CL_LEVEL_INFO
-- ----------------------------

CREATE TABLE "CL_LEVEL_INFO"
(
    "SID"         NUMBER(24, 0) NOT NULL,
    "LEVEL_CODE"  NUMBER(24, 0),
    "LEVEL_NAME"  VARCHAR2(64 CHAR),
    "LEVEL_DESC"  VARCHAR2(128 CHAR),
    "UPPER_LEVEL" NUMBER(24, 0),
    "LEVEL_NUM"   NUMBER(24, 0),
    "CREATE_BY"   VARCHAR2(255 CHAR),
    "CREATE_TIME" DATE,
    "UPDATE_BY"   VARCHAR2(255 CHAR),
    "UPDATE_TIME" DATE
);
COMMENT ON COLUMN "CL_LEVEL_INFO"."UPPER_LEVEL" IS '第一级时为空';
COMMENT ON COLUMN "CL_LEVEL_INFO"."LEVEL_NUM" IS '1/2';

-- ----------------------------
-- Table structure for CL_RESOUCE_COUNT
-- ----------------------------

CREATE TABLE "CL_RESOUCE_COUNT"
(
    "SID"          NUMBER(24, 0) NOT NULL,
    "TOTAL_NUM"    NUMBER(10, 0),
    "BATCH_NUMBER" NUMBER(24, 0)
);

-- ----------------------------
-- Table structure for CL_RESOUCE_COUNT_TEMP
-- ----------------------------

CREATE TABLE "CL_RESOUCE_COUNT_TEMP"
(
    "SID"          NUMBER(24, 0) NOT NULL,
    "TOTAL_NUM"    NUMBER(10, 0),
    "BATCH_NUMBER" NUMBER(24, 0)
);
COMMENT ON COLUMN "CL_RESOUCE_COUNT_TEMP"."BATCH_NUMBER" IS '批次号';

-- ----------------------------
-- Table structure for CL_ROLE_CLASSIF
-- ----------------------------

CREATE TABLE "CL_ROLE_CLASSIF"
(
    "ROLE_SID"    VARCHAR2(65 CHAR) NOT NULL,
    "CLASSIF_SID" NUMBER(24, 0)     NOT NULL,
    "CREATE_BY"   VARCHAR2(255 CHAR),
    "CREATE_TIME" DATE,
    "UPDATE_BY"   VARCHAR2(255 CHAR),
    "UPDATE_TIME" DATE
);

-- ----------------------------
-- Table structure for CL_ROLE_LEVEL
-- ----------------------------

CREATE TABLE "CL_ROLE_LEVEL"
(
    "ROLE_SID"    VARCHAR2(65 CHAR) NOT NULL,
    "LEVEL_SID"   NUMBER(24, 0)     NOT NULL,
    "CREATE_BY"   VARCHAR2(255 CHAR),
    "CREATE_TIME" DATE,
    "UPDATE_BY"   VARCHAR2(255 CHAR),
    "UPDATE_TIME" DATE
);

-- ----------------------------
-- Table structure for DS_DATA_CONFIG_MGR
-- ----------------------------

CREATE TABLE "DS_DATA_CONFIG_MGR"
(
    "SID"                NUMBER(24, 0)     NOT NULL,
    "CONFIGCODE"         VARCHAR2(50 CHAR) NOT NULL,
    "CONFIGNAME"         VARCHAR2(50 CHAR) NOT NULL,
    "CONFIGTYPE"         VARCHAR2(25 CHAR) NOT NULL,
    "USERKEYTABFILE"     VARCHAR2(255 CHAR),
    "KRB5FILE"           VARCHAR2(255 CHAR),
    "HIVECLIENTPROPFILE" VARCHAR2(255 CHAR),
    "HDFSSITEFILE"       VARCHAR2(255 CHAR),
    "CORESITEFILE"       VARCHAR2(255 CHAR),
    "HBASESITEFILE"      VARCHAR2(255 CHAR),
    "DESCRIPTION"        VARCHAR2(500 CHAR),
    "CREATE_BY"          VARCHAR2(255 CHAR),
    "CREATE_TIME"        DATE,
    "UPDATE_BY"          VARCHAR2(255 CHAR),
    "UPDATE_TIME"        DATE,
    "PATH_TYPE"          VARCHAR2(255 CHAR) DEFAULT ' LOCAL ',
    "SFTP_PATH"          VARCHAR2(255 CHAR)
);
COMMENT ON COLUMN "DS_DATA_CONFIG_MGR"."PATH_TYPE" IS ' LOCAL/SFTP';
COMMENT ON COLUMN "DS_DATA_CONFIG_MGR"."SFTP_PATH" IS 'SFTP的路径';

-- ----------------------------
-- Table structure for DS_DATA_SOURCE
-- ----------------------------

CREATE TABLE "DS_DATA_SOURCE"
(
    "SID"                  NUMBER(24, 0) NOT NULL,
    "DATA_SOURCE_NAME"     VARCHAR2(300 CHAR),
    "URL"                  VARCHAR2(1000 CHAR),
    "DRIVER"               VARCHAR2(100 CHAR),
    "USER_NAME"            VARCHAR2(60 CHAR),
    "PWD"                  VARCHAR2(255 CHAR),
    "SOURCE"               VARCHAR2(10 CHAR),
    "CREATE_BY"            VARCHAR2(255 CHAR),
    "CREATE_TIME"          DATE,
    "UPDATE_BY"            VARCHAR2(255 CHAR),
    "UPDATE_TIME"          DATE,
    "DATA_SOURCE_CODE"     VARCHAR2(255 CHAR),
    "METACUBE_DEFINE_NAME" VARCHAR2(255 CHAR),
    "DATASOURCE_TYPE"      VARCHAR2(50 CHAR),
    "CONFIGMGR_SID"        VARCHAR2(65 CHAR)
);
COMMENT ON COLUMN "DS_DATA_SOURCE"."DATA_SOURCE_NAME" IS '数据源名称';
COMMENT ON COLUMN "DS_DATA_SOURCE"."SOURCE" IS '数据源来源：1：元数据:2：自建:3：同步';

-- ----------------------------
-- Table structure for DS_HBASE_MAPPPING
-- ----------------------------

CREATE TABLE "DS_HBASE_MAPPPING"
(
    "SID"              NUMBER(24, 0)      NOT NULL,
    "HIVE_DS_ID"       VARCHAR2(100 CHAR),
    "HIVE_DS_NAME"     VARCHAR2(100 CHAR),
    "HIVE_DB_NAME"     VARCHAR2(100 CHAR),
    "HIVE_TABLE"       VARCHAR2(100 CHAR),
    "HBASE_DS_ID"      VARCHAR2(100 CHAR),
    "HBASE_DS_NAME"    VARCHAR2(100 CHAR),
    "HBASE_NAMESPACE"  VARCHAR2(100 CHAR),
    "HBASE_TABLE"      VARCHAR2(100 CHAR) NOT NULL,
    "STORAGE_TYPE"     VARCHAR2(20 CHAR) DEFAULT ' string ',
    "COLUMN_MAPPINGS"  CLOB,
    "SERDE_PROPERTIES" CLOB,
    "TBL_PROPERTIES"   VARCHAR2(1024 CHAR),
    "CREATE_TIME"      DATE,
    "CREATE_BY"        VARCHAR2(255 CHAR),
    "UPDATE_TIME"      DATE,
    "UPDATE_BY"        VARCHAR2(255 CHAR)
);

-- ----------------------------
-- Table structure for PO_FEEDBACK
-- ----------------------------

CREATE TABLE "PO_FEEDBACK"
(
    "SID"         NUMBER(24, 0)     NOT NULL,
    "OPTIONID"    NUMBER(24, 0)     NOT NULL,
    "USERNAME"    VARCHAR2(32 CHAR) NOT NULL,
    "FEEDBACK"    CLOB              NOT NULL,
    "CREATE_BY"   VARCHAR2(255 CHAR),
    "UPDATE_BY"   VARCHAR2(255 CHAR),
    "CREATE_TIME" DATE,
    "UPDATE_TIME" DATE
);
COMMENT ON COLUMN "PO_FEEDBACK"."CREATE_BY" IS '创建时的userid';
COMMENT ON COLUMN "PO_FEEDBACK"."UPDATE_BY" IS '最后一次修改者的userid';
COMMENT ON COLUMN "PO_FEEDBACK"."UPDATE_TIME" IS '最后一次修改该记录的时间';

-- ----------------------------
-- Table structure for PO_FILES
-- ----------------------------

CREATE TABLE "PO_FILES"
(
    "SID"            NUMBER(24, 0)     NOT NULL,
    "RELID"          NUMBER(24, 0),
    "FILENAME"       VARCHAR2(64 CHAR) NOT NULL,
    "ACTUALFILENAME" VARCHAR2(64 CHAR) NOT NULL,
    "FILEPATH"       VARCHAR2(255 CHAR),
    "CREATE_BY"      VARCHAR2(255 CHAR),
    "UPDATE_BY"      VARCHAR2(255 CHAR),
    "CREATE_TIME"    DATE,
    "UPDATE_TIME"    DATE
);
COMMENT ON COLUMN "PO_FILES"."RELID" IS '附件所关联的对象ID';
COMMENT ON COLUMN "PO_FILES"."FILEPATH" IS '可以使用 http://ip:port/files/文件名称 访问上传路径下的文件';
COMMENT ON COLUMN "PO_FILES"."CREATE_BY" IS '创建时的userid';
COMMENT ON COLUMN "PO_FILES"."UPDATE_BY" IS '最后一次修改者的userid';
COMMENT ON COLUMN "PO_FILES"."UPDATE_TIME" IS '最后一次修改该记录的时间';

-- ----------------------------
-- Table structure for PO_OPTIONS
-- ----------------------------

CREATE TABLE "PO_OPTIONS"
(
    "SID"          NUMBER(24, 0)     NOT NULL,
    "TITLE"        VARCHAR2(32 CHAR) NOT NULL,
    "SOURCE"       VARCHAR2(32 CHAR) NOT NULL,
    "DATARESOURCE" VARCHAR2(32 CHAR),
    "FIELD"        VARCHAR2(32 CHAR),
    "DESCRIPTION"  CLOB              NOT NULL,
    "STATUS"       CHAR(1 CHAR)      NOT NULL,
    "USERNAME"     VARCHAR2(32 CHAR) NOT NULL,
    "CREATE_BY"    VARCHAR2(255 CHAR),
    "UPDATE_BY"    VARCHAR2(255 CHAR),
    "CREATE_TIME"  DATE,
    "UPDATE_TIME"  DATE,
    "CONTACTINFO"  VARCHAR2(255 CHAR)
);
COMMENT ON COLUMN "PO_OPTIONS"."SOURCE" IS '来源于静态参数 存静态参数的ID 有   质量检核  隐患  用户反馈 其他途径';
COMMENT ON COLUMN "PO_OPTIONS"."STATUS" IS '0  未反馈 1  已反馈 9  已关闭';
COMMENT ON COLUMN "PO_OPTIONS"."CREATE_BY" IS '创建时的userid';
COMMENT ON COLUMN "PO_OPTIONS"."UPDATE_BY" IS '最后一次修改者的userid';
COMMENT ON COLUMN "PO_OPTIONS"."UPDATE_TIME" IS '最后一次修改该记录的时间';

    -- ----------------------------
-- Table structure for DS_RESOURCE_INFO
-- ----------------------------
CREATE TABLE "DS_RESOURCE_INFO" (
    "TABLE_TAG" VARCHAR2(255 CHAR),
    "SID" NUMBER(38,0) NOT NULL,
    "RESOURCE_CODE" VARCHAR2(64 CHAR),
    "RESOURCE_NAME" CLOB,
    "DIRECTORY_CODE" VARCHAR2(64 CHAR),
    "DIRECTORY_NAME" CLOB,
    "AUTHORITY_UNIT" VARCHAR2(128 CHAR),
    "SOURCE_TYPE" NUMBER(38,0),
    "OBTAIN_WAY" NUMBER(38,0),
    "APP_SYSTEM" VARCHAR2(128 CHAR),
    "MANAGE_UNIT" VARCHAR2(128 CHAR),
    "DATA_LOCATION" VARCHAR2(32 CHAR),
    "STORAGE_CENTER" VARCHAR2(32 CHAR),
    "STATUS" CHAR(1 CHAR),
    "DESCRIPTION" CLOB,
    "STORAGE_SCALE" VARCHAR2(128 CHAR),
    "STORAGE_CYCLE" VARCHAR2(128 CHAR),
    "UPDATE_CYCLE" VARCHAR2(128 CHAR),
    "UPDATE_SCALE" VARCHAR2(128 CHAR),
    "DATA_UPDATE_TIME" TIMESTAMP(6),
    "REGISTER_TIME" TIMESTAMP(6),
    "META_DIR_CODE" VARCHAR2(128 CHAR),
    "SCHEMA_CODE" VARCHAR2(128 CHAR),
    "TABLE_CODE" VARCHAR2(128 CHAR),
    "CREATE_BY" VARCHAR2(255 CHAR),
    "CREATE_TIME" TIMESTAMP(6),
    "UPDATE_BY" VARCHAR2(255 CHAR),
    "UPDATE_TIME" TIMESTAMP(6),
    "DATA_SOURCE_NAME" VARCHAR2(300 CHAR),
    "RESOURCE_TYPE" VARCHAR2(20 CHAR),
    "INIT_SOLR" CHAR(1 CHAR),
    "DATA_ORGANIZATION" NUMBER(38,0),
    "LABEL_1" NUMBER(38,0),
    "LABEL_2" NUMBER(38,0),
    "LABEL_3" NUMBER(38,0),
    "LABEL_4" NUMBER(38,0),
    "LABEL_5" NUMBER(38,0),
    "INSTANCE_ID" VARCHAR2(128 CHAR),
    "ISPEAT" VARCHAR2(64 CHAR),
    "TABLEDESC" CLOB,
    "DATAMODE" VARCHAR2(255 CHAR),
    "WHYREPEAT" VARCHAR2(500 CHAR),
    "DIFFERSERV" VARCHAR2(255 CHAR),
    "TABLE_RECORD" VARCHAR2(255 CHAR),
    "MAPPING_NUMBER" VARCHAR2(200 CHAR),
    "MAPPING_FIELD" VARCHAR2(200 CHAR),
    "DATA_TABLE_NUM" VARCHAR2(255 CHAR),
    "DEPLOY_TYPE" VARCHAR2(300 CHAR),
    "LAST_UPDATE_TIME" VARCHAR2(100 CHAR),
    "FUNCTION_TEMPLATE" VARCHAR2(255 CHAR),
    "SUB_FUNCTION_TEMPLATE" VARCHAR2(255 CHAR),
    "IS_ACCESS" VARCHAR2(255 CHAR),
    "MAINDATAID" VARCHAR2(100 CHAR),
    "WHY_NEGATIVELIST" VARCHAR2(255 CHAR),
    "IS_NEGATIVELIST" VARCHAR2(255 CHAR),
    "ID" VARCHAR2(100 CHAR),
    "MAINTABLEID" VARCHAR2(100 CHAR),
    "BUSI_TYPE_NUM" VARCHAR2(100 CHAR),
    "TOPIC_NUM" VARCHAR2(100 CHAR),
    "TABLE_NAMESPACE" VARCHAR2(255 CHAR),
    "TABLE_NAME" VARCHAR2(512 CHAR),
"PRINCIPAL" VARCHAR2(255 CHAR)
);

-- ----------------------------
-- Table structure for DS_RESOURCE_ITEM
-- ----------------------------

CREATE TABLE "DS_RESOURCE_ITEM" (
        "SID" NUMBER(38,0) NOT NULL,
        "RESOURCE_SID" NUMBER(38,0),
        "ITEM_CODE" VARCHAR2(200 CHAR),
        "ITEM_NAME" CLOB,
        "IS_QUERY" CHAR(1 CHAR),
        "QUERY_MATCH_TYPE" VARCHAR2(128 CHAR),
        "IS_SUBSCRIBE" CHAR(1 CHAR),
        "SUBSCRIBE_MATCH_TYPE" VARCHAR2(128 CHAR),
        "CREATE_BY" VARCHAR2(255 CHAR),
        "CREATE_TIME" TIMESTAMP(6),
        "UPDATE_BY" VARCHAR2(255 CHAR),
        "UPDATE_TIME" TIMESTAMP(6),
        "INSTANCE_ID" VARCHAR2(255 CHAR),
        "SYNCDATE" TIMESTAMP(6),
        "SEQ" NUMBER(38,0),
        "ITEM_TYPE" VARCHAR2(500 CHAR),
        "INSTANCE_CODE" VARCHAR2(255 CHAR),
        "INSTANCE_NAME" CLOB,
        "COMMENTS" CLOB,
        "IS_PK" VARCHAR2(255 CHAR),
        "IS_UNIQUE" VARCHAR2(255 CHAR),
        "IS_FK" VARCHAR2(255 CHAR),
        "IS_NULLABLE" VARCHAR2(255 CHAR),
        "COLLENGTHS" VARCHAR2(255 CHAR),
        "SCALES" VARCHAR2(255 CHAR),
        "INITIAL_VALUE" VARCHAR2(255 CHAR),
        "IS_SHARE" VARCHAR2(255 CHAR),
        "IS_MASKING" VARCHAR2(255 CHAR),
        "DATA_TYPE" VARCHAR2(500 CHAR),
        "WHY_SHARE" CLOB,
        "DESEN_RULE" VARCHAR2(500 CHAR),
        "STD_CODE" VARCHAR2(255 CHAR),
        "STORAGE_FORMAT" VARCHAR2(255 CHAR),
        "IS_BASE" VARCHAR2(255 CHAR),
        "SOURCE_SYSTEM" VARCHAR2(255 CHAR),
        "OWN_USER" VARCHAR2(255 CHAR),
        "SOURCE_TB_EN" VARCHAR2(255 CHAR),
        "SOURCE_TB_CN" VARCHAR2(255 CHAR),
        "SOURCE_TB_DESC" CLOB,
        "SOURCE_COL_EN" VARCHAR2(255 CHAR),
        "SOURCE_COL_CN" VARCHAR2(255 CHAR),
        "SOURCE_COL_DESC" CLOB,
        "REB_DEPT" VARCHAR2(255 CHAR),
        "BUS_DEPT_IS_CFM" VARCHAR2(255 CHAR),
        "DATA_IS_CFM" VARCHAR2(255 CHAR),
        "LATEST_VER_NO" VARCHAR2(255 CHAR),
        "LATEST_REVISION_NO" VARCHAR2(255 CHAR),
        "CONSTRAINTS_KEY" VARCHAR2(255 CHAR),
        "STATUS" VARCHAR2(10 CHAR),
        "ID" VARCHAR2(100 CHAR),
        "MAINTABLEID" VARCHAR2(100 CHAR),
        "MAINDATAID" VARCHAR2(100 CHAR),
        "SOURCE_COL_TYPE" VARCHAR2(100 CHAR),
        "PRINCIPAL" VARCHAR2(255 CHAR)
);


--------------------------------------------------------
--  DDL for Table CK_ALARM_CONFIG
--------------------------------------------------------

CREATE TABLE "CK_ALARM_CONFIG"
(	"SID" NUMBER(38,0),
     "ALARM_NAME" VARCHAR2(255 CHAR),
     "THRESHOLD_TYPE" CHAR(1 CHAR),
	"THRESHOLD_RELATION" VARCHAR2(64 CHAR),
	"THRESHOLD_VALUE" VARCHAR2(10 CHAR),
	"ALARM_LEVEL" CHAR(1 CHAR),
	"STATE" CHAR(1 CHAR),
	"DELETED" CHAR(1 CHAR),
	"CREATE_BY" VARCHAR2(255 CHAR),
	"CREATE_TIME" TIMESTAMP (6),
	"UPDATE_BY" VARCHAR2(255 CHAR),
	"UPDATE_TIME" TIMESTAMP (6),
	"REMARK" VARCHAR2(255 CHAR),
	"MESSAGETYPE" NUMBER(10,0),
	"STANDBY" VARCHAR2(255 CHAR)
   );

--------------------------------------------------------
--  DDL for Table CK_ALARM_RECORD
--------------------------------------------------------

CREATE TABLE "CK_ALARM_RECORD"
(	"SID" NUMBER(38,0),
     "RELATION_ID" NUMBER(38,0),
     "RELATION_TABLE" VARCHAR2(10 CHAR),
     "ALARM_SID" NUMBER(38,0),
     "CHECK_LOG_SID" NUMBER(38,0),
     "CONTENT" VARCHAR2(1000 CHAR),
     "MESSAGE_SEND_RESULT" VARCHAR2(255 CHAR),
     "RECEIVED_BY" VARCHAR2(255 CHAR),
     "RECEIPT_TIME" TIMESTAMP (6),
     "STATE" CHAR(1 CHAR),
	"DELETED" CHAR(1 CHAR),
	"CREATE_BY" VARCHAR2(255 CHAR),
	"CREATE_TIME" TIMESTAMP (6),
	"UPDATE_BY" VARCHAR2(255 CHAR),
	"UPDATE_TIME" TIMESTAMP (6)
);

--------------------------------------------------------
--  DDL for Table CK_CALENDAR
--------------------------------------------------------

CREATE TABLE "CK_CALENDAR"
(	"CK_ID" VARCHAR2(255 CHAR),
     "CK_NAME" VARCHAR2(255 CHAR),
     "CK_DESC" VARCHAR2(255 CHAR),
     "CK_YEAR" NUMBER(10,0),
     "CK_DATELIST" CLOB,
     "CREATE_BY" VARCHAR2(255 CHAR),
     "CREATE_TIME" TIMESTAMP (6),
     "UPDATE_BY" VARCHAR2(255 CHAR),
     "UPDATE_TIME" TIMESTAMP (6)
);

--------------------------------------------------------
--  DDL for Table CK_CHECK_LOG
--------------------------------------------------------
CREATE TABLE "CK_CHECK_LOG"
(	"SID" NUMBER(38,0),
     "METHOD_CONFIG_ID" NUMBER(38,0),
     "CHECK_TIME" TIMESTAMP (6),
     "CHECK_END_TIME" TIMESTAMP (6),
     "CHECK_DURATION" VARCHAR2(10 CHAR),
     "JOB_ID" NUMBER(38,0),
     "JOB_LOG_ID" NUMBER(38,0),
     "CHECK_STATUS" VARCHAR2(10 CHAR),
     "RESULT_ID" VARCHAR2(64 CHAR),
     "ERROR_REMARK" CLOB
);
--------------------------------------------------------
--  DDL for Table CK_CHECK_LOG_LATEST
--------------------------------------------------------

CREATE TABLE "CK_CHECK_LOG_LATEST"
(
    "METHOD_CONFIG_ID" NUMBER(38,0),
     "LOG_SID" NUMBER(38,0)
);

--------------------------------------------------------
--  DDL for Table CK_CHECK_RESULT
--------------------------------------------------------
CREATE TABLE "CK_CHECK_RESULT"
(
        "SID" NUMBER(38,0),
        "INDEX_SID" NUMBER(38,0),
        "CHECK_FREQUENCY" VARCHAR2(5 CHAR),
        "CHECK_TIME" DATE,
        "CHECK_END_TIME" DATE,
        "CHECK_DURATION" VARCHAR2(10 CHAR),
        "ERROR_NUM" NUMBER(38,0),
        "SUM_NUM" NUMBER(38,0),
        "RESOURCE_SID" NUMBER(38,0),
        "ITEM_SID" NUMBER(38,0),
        "ERROR_KEYWORD" CLOB,
        "ERROR_VALUE" CLOB,
        "ERROR_REMARK" CLOB,
        "SOURCE_DATE" TIMESTAMP (6),
        "ERROR_SOURCE1" VARCHAR2(200 CHAR),
        "ERROR_SOURCE2" VARCHAR2(100 CHAR),
        "ERROR_SOURCE3" VARCHAR2(50 CHAR),
        "METHOD_CONFIG_ID" NUMBER(38,0),
        "JOB_ID" NUMBER(38,0),
        "JOB_LOG_ID" NUMBER(38,0),
        "CHECK_RESULT_URL" VARCHAR2(200 CHAR),
        "CHECK_STATUS" VARCHAR2(10 CHAR),
        "CHECK_RESULT_PATH" VARCHAR2(200 CHAR),
        "CHECK_RESULT" CLOB
);

--------------------------------------------------------
--  DDL for Table CK_CHECK_RESULT_LATEST
--------------------------------------------------------

CREATE TABLE "CK_CHECK_RESULT_LATEST"
(
    "METHOD_CONFIG_ID" NUMBER(38,0),
    "JOB_ID" NUMBER(38,0),
    "MAX_JOB_LOG_ID" NUMBER(38,0),
    "MAX_CHECK_TIME" TIMESTAMP (6)
);

--------------------------------------------------------
--  DDL for Table CK_FREQUENCY
--------------------------------------------------------

CREATE TABLE "CK_FREQUENCY"
(
    "NAME" VARCHAR2(128 CHAR),
    "TYPE" CHAR(1 CHAR),
	"INTERVALNUM" NUMBER(10,0),
	"CREATE_BY" VARCHAR2(255 CHAR),
	"CREATE_TIME" TIMESTAMP (6),
	"UPDATE_BY" VARCHAR2(255 CHAR),
	"UPDATE_TIME" TIMESTAMP (6),
	"EXPRESSION" VARCHAR2(255 CHAR),
	"DESCRIPTION" VARCHAR2(255 CHAR)
);

--------------------------------------------------------
--  DDL for Table CK_GENERAL_CONFIG
--------------------------------------------------------
CREATE TABLE "CK_GENERAL_CONFIG"
(
    "SID" NUMBER(38,0),
    "CONFIG_TYPE" CHAR(1 CHAR),
	"CONFIG_NAME" VARCHAR2(255 CHAR),
	"STATE" CHAR(1 CHAR),
	"DELETED" CHAR(1 CHAR),
	"CREATE_BY" VARCHAR2(255 CHAR),
	"CREATE_TIME" TIMESTAMP (6),
	"UPDATE_BY" VARCHAR2(255 CHAR),
	"UPDATE_TIME" TIMESTAMP (6),
	"REMARK" VARCHAR2(255 CHAR),
	"STANDBY" VARCHAR2(500 CHAR),
	"SCHEDULE_ID" NUMBER(38,0),
	"SCHEDULE_NAME" VARCHAR2(128 CHAR),
	"PRINCIPAL" VARCHAR2(255 CHAR),
	"ALARM_ID"      NUMBER(38,0),
    "CHECK_CONFIG"  VARCHAR2(255 CHAR)
);

--------------------------------------------------------
--  DDL for Table CK_GENERAL_CONFIG_DETAIL
--------------------------------------------------------
CREATE TABLE "CK_GENERAL_CONFIG_DETAIL"
(
        "SID" NUMBER(38,0),
        "CONFIG_ID" NUMBER(38,0),
        "RESOURCE_NAME" CLOB,
        "RESOURCE_ID" NUMBER(38,0),
        "DATA_SOURCE_NAME" VARCHAR2(64 CHAR),
        "INSTANCE_CODE" VARCHAR2(255 CHAR),
        "ITEM_CODE" VARCHAR2(200 CHAR),
        "ITEM_NAME" CLOB,
        "TABLE_CODE" VARCHAR2(128 CHAR),
        "EXT_CONDITION" VARCHAR2(500 CHAR),
        "UP_THRESHOLD" VARCHAR2(20 CHAR),
        "DOWN_THRESHOLD" VARCHAR2(20 CHAR),
        "PERIOD" NUMBER(10,0),
        "PERIOD_TYPE" CHAR(1 CHAR),
        "ITEM_ID" NUMBER(38,0),
        "DATA_SOURCE_SID" NUMBER(38,0),
        "SCHEMA_CODE" VARCHAR2(255 CHAR)
);

--------------------------------------------------------
--  DDL for Table CK_GENERAL_RESULT
--------------------------------------------------------
CREATE TABLE "CK_GENERAL_RESULT"
(
    "SID" NUMBER(38,0),
    "CONFIG_ID" NUMBER(38,0),
    "AVERAGE_VALUE" VARCHAR2(20 CHAR),
    "UP_THRESHOLD" VARCHAR2(20 CHAR),
    "DOWN_THRESHOLD" VARCHAR2(20 CHAR),
    "CREATE_TIME" TIMESTAMP (6),
    "JOB_ID" NUMBER(38,0),
    "JOB_LOG_ID" NUMBER(38,0),
    "COUNT_OUT_OF_RANGE" NUMBER(20,0),
    "LOG_MESSAGE" CLOB
);

--------------------------------------------------------
--  DDL for Table CK_GENERAL_RESULT_DETAIL
--------------------------------------------------------
CREATE TABLE "CK_GENERAL_RESULT_DETAIL"
(
    "SID" NUMBER(38,0),
    "RESULT_SID" NUMBER(38,0),
    "DATA_SOURCE_NAME" VARCHAR2(64 CHAR),
    "TABLE_CODE" VARCHAR2(128 CHAR),
    "RESOURCE_ID" NUMBER(38,0),
    "RESOURCE_NAME" CLOB,
    "ITEM_CODE" VARCHAR2(200 CHAR),
    "ITEM_NAME" CLOB,
    "ACTUAL_VALUE" VARCHAR2(20 CHAR),
    "LINE_NUM" VARCHAR2(20 CHAR),
    "INSTANCE_CODE" VARCHAR2(255 CHAR),
    "EXT_CONDITION" VARCHAR2(500 CHAR),
    "ITEM_ID" NUMBER(38,0),
    "DATA_SOURCE_SID" NUMBER(38,0),
    "SCHEMA_CODE" VARCHAR2(255 CHAR)
);

--------------------------------------------------------
--  DDL for Table CK_GROUP
--------------------------------------------------------
CREATE TABLE "CK_GROUP"
(
    "SID" NUMBER(38,0),
    "GROUP_NAME" VARCHAR2(128 CHAR),
    "UPPER_GROUP" NUMBER(38,0),
    "DESCRIPTION" CLOB,
    "CREATE_BY" VARCHAR2(255 CHAR),
    "CREATE_TIME" TIMESTAMP (6),
    "UPDATE_BY" VARCHAR2(255 CHAR),
    "UPDATE_TIME" TIMESTAMP (6),
    "UPPER_NAME" VARCHAR2(128 CHAR)
);

--------------------------------------------------------
--  DDL for Table CK_GROUP_RELATION
--------------------------------------------------------
CREATE TABLE "CK_GROUP_RELATION"
(
    "CONFIGSID" NUMBER(38,0),
    "CONFIGTYPE" NUMBER(10,0),
    "GROUPSID" NUMBER(38,0),
    "CREATE_BY" VARCHAR2(255 CHAR),
    "CREATE_TIME" TIMESTAMP (6),
    "UPDATE_BY" VARCHAR2(255 CHAR),
    "UPDATE_TIME" TIMESTAMP (6)
);


--------------------------------------------------------
--  DDL for Table CK_INDEX_INFO
--------------------------------------------------------
CREATE TABLE "CK_INDEX_INFO"
(
    "SID" NUMBER(38,0),
    "INDEX_CODE" VARCHAR2(128 CHAR),
    "INDEX_NAME" VARCHAR2(128 CHAR),
    "CHECK_TYPE" CHAR(1 CHAR),
    "INDEX_LEVEL" VARCHAR2(2 CHAR),
    "PARENT_SID" VARCHAR2(40 CHAR),
    "INDEX_WEIGHT" NUMBER(38,0),
    "REMARK" CLOB,
    "DELETED" CHAR(1 CHAR),
    "CREATE_BY" VARCHAR2(255 CHAR),
    "CREATE_TIME" TIMESTAMP (6),
    "UPDATE_BY" VARCHAR2(255 CHAR),
    "UPDATE_TIME" TIMESTAMP (6),
    "ALARM_ID" NUMBER(38,0),
    "ALARM_NAME" VARCHAR2(128 CHAR)
);

--------------------------------------------------------
--  DDL for Table CK_INDEX_WEIGHT_INFO
--------------------------------------------------------
CREATE TABLE "CK_INDEX_WEIGHT_INFO"
(
    "SID" NUMBER(38,0),
    "INDEX_SID" NUMBER(38,0),
    "INDEX_NAME" VARCHAR2(128 CHAR),
    "START_VALUE" NUMBER(38,0),
    "END_VALUE" NUMBER(38,0),
    "SCORE" NUMBER(38,0),
    "CREATE_BY" VARCHAR2(255 CHAR),
    "CREATE_TIME" TIMESTAMP (6),
    "UPDATE_BY" VARCHAR2(255 CHAR),
    "UPDATE_TIME" TIMESTAMP (6)
);

--------------------------------------------------------
--  DDL for Table CK_KNOWLEDGE_INFO
--------------------------------------------------------
CREATE TABLE "CK_KNOWLEDGE_INFO"
(
    "SID" NUMBER(38,0),
    "TITLE" VARCHAR2(255 CHAR),
    "CONTENT" CLOB,
    "TARGET" VARCHAR2(255 CHAR),
    "DELETED" CHAR(1 CHAR),
    "CREATE_BY" VARCHAR2(255 CHAR),
    "CREATE_TIME" TIMESTAMP (6),
    "UPDATE_BY" VARCHAR2(255 CHAR),
    "UPDATE_TIME" TIMESTAMP (6),
    "PREVIEW" CLOB,
"READNUM" NUMBER(38,0)
);

--------------------------------------------------------
--  DDL for Table CK_KNOWLEDGE_LOG
--------------------------------------------------------
CREATE TABLE "CK_KNOWLEDGE_LOG"
(
    "SID" NUMBER(38,0),
    "KNOWLEDGE_SID" NUMBER(38,0),
    "DELETED" CHAR(1 CHAR),
    "CREATE_BY" VARCHAR2(255 CHAR),
    "CREATE_TIME" TIMESTAMP (6),
    "UPDATE_BY" VARCHAR2(255 CHAR),
    "UPDATE_TIME" TIMESTAMP (6)
);

--------------------------------------------------------
--  DDL for Table CK_METHOD_CONFIG
--------------------------------------------------------
CREATE TABLE "CK_METHOD_CONFIG"
(
    "SID" NUMBER(38,0),
    "NAME" VARCHAR2(500 CHAR),
    "CODE" VARCHAR2(255 CHAR),
    "CHECK_METHOD" CHAR(1 CHAR),
    "RESOURCE_ID" NUMBER(38,0),
    "RESOURCE_NAME" CLOB,
    "ITEM_ID" NUMBER(38,0),
    "ITEM_CODE" VARCHAR2(200 char),
    "ITEM_NAME" CLOB,
    "TABLE_CODE" VARCHAR2(128 CHAR),
    "INSTANCE_CODE" VARCHAR2(200 char),
    "FULLSQL" CLOB,
    "WHERESQL" CLOB,
    "NUMSQL" CLOB,
    "CHECK_TYPE" CHAR(1 CHAR),
    "INDEX_ID" NUMBER(38,0),
    "INDEX_CODE" VARCHAR2(128 CHAR),
    "INDEX_NAME" VARCHAR2(128 CHAR),
    "SCHEDULE_ID" NUMBER(38,0),
    "SCHEDULE_NAME" VARCHAR2(128 CHAR),
    "CONFIG_TYPE" CHAR(1 CHAR),
    "CHECK_TPL" NUMBER(38,0),
    "CHECK_CONFIG" CLOB,
    "IS_ALARM" CHAR(1 CHAR) DEFAULT 0,
    "ALARM_ID" NUMBER(38,0),
    "ALARM_NAME" VARCHAR2(128 CHAR),
    "ALARM_CONFIG" CLOB,
    "ALARM_TIME" TIMESTAMP,
    "STATE" CHAR(1 CHAR),
    "DELETED" CHAR(1 CHAR),
    "CREATE_BY" VARCHAR2(255 CHAR),
    "CREATE_TIME" TIMESTAMP (6),
    "UPDATE_BY" VARCHAR2(255 CHAR),
    "UPDATE_TIME" TIMESTAMP (6),
    "REMARK" VARCHAR2(255 CHAR),
    "STANDBY" VARCHAR2(500 CHAR),
    "SHOW_FIELD" CLOB,
    "DATA_SOURCE_NAME" VARCHAR2(255 CHAR),
    "DATA_SOURCE_SID" NUMBER(38,0),
    "RESOURCE_TYPE" VARCHAR2(255 CHAR),
    "SCHEMA_CODE" VARCHAR2(255 CHAR),
    "PRINCIPAL" VARCHAR2(255 CHAR),
    "SINK_MODE" VARCHAR2(64 CHAR),
    "DATA_FROM" VARCHAR2(64 CHAR)
);
COMMENT ON COLUMN CK_METHOD_CONFIG.SINK_MODE IS '结果输出方式';
COMMENT ON COLUMN CK_METHOD_CONFIG.DATA_FROM IS '检核规则创建来源, 默认为NULL';

--------------------------------------------------------
--  DDL for Table CK_METHOD_CONFIG_COURSE
--------------------------------------------------------
CREATE TABLE "CK_METHOD_CONFIG_COURSE"
(
    "SID" NUMBER(38,0),
    "METHOD_CONFIG_ID" NUMBER(38,0),
    "OPT" CHAR(2 CHAR),
    "TABLE_CODE" VARCHAR2(128 CHAR),
    "ITEM_CODE" VARCHAR2(128 CHAR),
    "INSTANCE_CODE" VARCHAR2(255 CHAR),
    "WILDCARD" CHAR(1 CHAR),
    "ACTUAL_VALUE" VARCHAR2(128 CHAR),
    "STARTTIME" VARCHAR2(20 CHAR),
    "ENDTIME" VARCHAR2(20 CHAR),
    "DICT_ID" VARCHAR2(20 CHAR),
    "ITEM_ID" NUMBER(38,0),
    "ITEM_NAME" VARCHAR2(128 CHAR)
);

--------------------------------------------------------
--  DDL for Table CK_METHOD_ITEM
--------------------------------------------------------
CREATE TABLE "CK_METHOD_ITEM"
(
    "SID" NUMBER(38,0),
    "CONFIG_SID" NUMBER(38,0),
    "INDEX_SID" NUMBER(38,0),
    "PARENT_SID" NUMBER(38,0),
    "OPT" VARCHAR2(10 CHAR),
    "RULE_SID" NUMBER(38,0),
    "EXPRESSION" VARCHAR2(200 CHAR),
    "IDENTIFIER" VARCHAR2(200 CHAR),
    "CHECK_MODE" CHAR(1 CHAR),
    "DELETED" CHAR(1 CHAR),
    "CREATE_BY" VARCHAR2(255 CHAR),
    "CREATE_TIME" TIMESTAMP (6),
    "UPDATE_BY" VARCHAR2(255 CHAR),
    "UPDATE_TIME" TIMESTAMP (6),
    "REMARK" VARCHAR2(255 CHAR),
    "STANDBY" VARCHAR2(500 CHAR)
);

--------------------------------------------------------
--  DDL for Table CK_RESULT_DETAIL
--------------------------------------------------------
CREATE TABLE "CK_RESULT_DETAIL"
(
    "SID" NUMBER(38,0),
    "RESULTID" NUMBER(38,0),
    "CHECK_COLUMN" VARCHAR2(1000 CHAR),
    "COLUMN1" VARCHAR2(500 CHAR),
    "COLUMN2" VARCHAR2(500 CHAR),
    "COLUMN3" VARCHAR2(500 CHAR),
    "COLUMN4" VARCHAR2(500 CHAR),
    "COLUMN5" VARCHAR2(500 CHAR),
    "COLUMN6" VARCHAR2(500 CHAR),
    "COLUMN7" VARCHAR2(500 CHAR),
    "COLUMN8" VARCHAR2(500 CHAR),
    "COLUMN9" VARCHAR2(500 CHAR),
    "COLUMN10" VARCHAR2(500 CHAR),
    "COLUMN11" VARCHAR2(500 CHAR),
    "COLUMN12" VARCHAR2(500 CHAR),
    "COLUMN13" VARCHAR2(500 CHAR),
    "COLUMN14" VARCHAR2(500 CHAR),
    "COLUMN15" VARCHAR2(500 CHAR),
    "COLUMN16" VARCHAR2(500 CHAR),
    "COLUMN17" VARCHAR2(500 CHAR),
    "COLUMN18" VARCHAR2(500 CHAR),
    "COLUMN19" VARCHAR2(500 CHAR),
    "COLUMN20" VARCHAR2(500 CHAR),
    "COLUMN21" VARCHAR2(500 CHAR),
    "COLUMN22" VARCHAR2(500 CHAR),
    "COLUMN23" VARCHAR2(500 CHAR),
    "COLUMN24" VARCHAR2(500 CHAR),
    "COLUMN25" VARCHAR2(500 CHAR),
    "COLUMN26" VARCHAR2(500 CHAR),
    "COLUMN27" VARCHAR2(500 CHAR),
    "COLUMN28" VARCHAR2(500 CHAR),
    "COLUMN29" VARCHAR2(500 CHAR),
    "COLUMN30" VARCHAR2(500 CHAR),
    "COLUMN31" VARCHAR2(500 CHAR),
    "COLUMN32" VARCHAR2(500 CHAR),
    "COLUMN33" VARCHAR2(500 CHAR),
    "COLUMN34" VARCHAR2(500 CHAR),
    "CREATE_BY" VARCHAR2(255 CHAR),
    "CREATE_TIME" TIMESTAMP (6),
    "UPDATE_BY" VARCHAR2(255 CHAR),
    "UPDATE_TIME" TIMESTAMP (6),
    "TYPE" CHAR(1 CHAR)
);

--------------------------------------------------------
--  DDL for Table CK_RESULT_OPTIONS
--------------------------------------------------------
CREATE TABLE "CK_RESULT_OPTIONS"
(
    "SID" NUMBER(38,0),
    "CHECK_METHOD" CHAR(1 CHAR),
    "RESULT_SID" NUMBER(38,0),
    "OPTION_SID" NUMBER(38,0),
    "DELETED" CHAR(1 CHAR),
    "CREATE_BY" VARCHAR2(255 CHAR),
    "CREATE_TIME" TIMESTAMP (6),
    "UPDATE_BY" VARCHAR2(255 CHAR),
    "UPDATE_TIME" TIMESTAMP (6),
    "REMARK" VARCHAR2(255 CHAR),
    "STANDBY" VARCHAR2(500 CHAR)
);

--------------------------------------------------------
--  DDL for Table CK_RULE_INFO
--------------------------------------------------------
CREATE TABLE "CK_RULE_INFO"
(
    "SID" NUMBER(38,0),
    "RULE_CODE" VARCHAR2(30 CHAR),
    "RULE_NAME" VARCHAR2(50 CHAR),
    "RULE_OPTION" VARCHAR2(20 CHAR),
    "RULE_VALUE" CLOB,
    "RULE_VALUE_TYPE" CHAR(1 CHAR),
    "EXPRESSION" CLOB,
    "REMARK" CLOB,
    "DELETED" CHAR(1 CHAR),
    "CREATE_BY" VARCHAR2(255 CHAR),
    "CREATE_TIME" TIMESTAMP (6),
    "UPDATE_BY" VARCHAR2(255 CHAR),
    "UPDATE_TIME" TIMESTAMP (6)
);

--------------------------------------------------------
--  DDL for Table CK_SCHEDULE_CONFIG
--------------------------------------------------------
CREATE TABLE "CK_SCHEDULE_CONFIG"
(
    "SID" NUMBER(38,0),
    "NAME" VARCHAR2(128 CHAR),
    "JOB_ID" NUMBER(10,0),
    "JOB_GROUP" NUMBER(10,0),
    "TYPE" CHAR(1 CHAR),
    "INTERVALNUM" NUMBER(10,0),
    "STARTTIME" VARCHAR2(20 CHAR),
    "JOB_HANDLER" VARCHAR2(255 CHAR),
    "STATE" CHAR(1 CHAR),
    "DELETED" CHAR(1 CHAR),
    "CREATE_BY" VARCHAR2(255 CHAR),
    "CREATE_TIME" TIMESTAMP (6),
    "UPDATE_BY" VARCHAR2(255 CHAR),
    "UPDATE_TIME" TIMESTAMP (6),
    "REMARK" VARCHAR2(255 CHAR),
    "STANDBY" VARCHAR2(500 CHAR),
    "CALENDAR" VARCHAR2(255 CHAR),
    "FREQUENCY_NAME" VARCHAR2(255 CHAR),
    "EXPRESSION" VARCHAR2(255 CHAR)
);

--------------------------------------------------------
--  DDL for Table CL_CLASSIF_INFO
--------------------------------------------------------
CREATE TABLE "CL_CLASSIF_INFO"
(
    "SID" NUMBER(24,0),
    "CLASSIF_NAME" VARCHAR2(128 CHAR),
    "UPPER_CLASSIF" NUMBER(24,0),
    "SEQ" VARCHAR2(1024 CHAR),
    "IS_LEAF" CHAR(1 CHAR),
    "DISPLAY_ORDER" NUMBER(24,0),
    "DESCRIPTION" CLOB,
    "LEVEL_NUM" NUMBER(24,0),
    "CLASSIF_FULL_NAME" VARCHAR2(500 CHAR),
    "CLASSIF_TYPE" VARCHAR2(5 CHAR),
    "RESOURCE_MAPPING" VARCHAR2(128 CHAR),
    "IS_AUTH" CHAR(1 CHAR),
    "CREATE_BY" VARCHAR2(255 CHAR),
    "CREATE_TIME" DATE,
    "UPDATE_BY" VARCHAR2(255 CHAR),
    "UPDATE_TIME" DATE,
    "CLASSIFTEMPLATE" VARCHAR2(255 CHAR),
    "SHOW_SCHEMA" VARCHAR2(10 CHAR),
    "ABBR_NAME" VARCHAR2(128 CHAR)
);
COMMENT ON COLUMN "CL_CLASSIF_INFO"."UPPER_CLASSIF" IS '父节点id，一级节点为空';
COMMENT ON COLUMN "CL_CLASSIF_INFO"."SEQ" IS '.11.22.33.';
COMMENT ON COLUMN "CL_CLASSIF_INFO"."IS_LEAF" IS 'Y/N';
COMMENT ON COLUMN "CL_CLASSIF_INFO"."DISPLAY_ORDER" IS '1、2、3...99';
COMMENT ON COLUMN "CL_CLASSIF_INFO"."LEVEL_NUM" IS '1、2、3';
COMMENT ON COLUMN "CL_CLASSIF_INFO"."CLASSIF_FULL_NAME" IS '一级名称-二级名称-叶子名称';
COMMENT ON COLUMN "CL_CLASSIF_INFO"."RESOURCE_MAPPING" IS '自动映射数据资源';
COMMENT ON COLUMN "CL_CLASSIF_INFO"."IS_AUTH" IS '确定该分类是否需要做鉴权 0:不需要 1:需要';
COMMENT ON COLUMN "CL_CLASSIF_INFO"."SHOW_SCHEMA" IS '是否展示SCHEMA节点 0:否,1:是';
COMMENT ON COLUMN "CL_CLASSIF_INFO"."ABBR_NAME" IS '简称';

--------------------------------------------------------
--  DDL for Index SYS_C0097980
--------------------------------------------------------

CREATE UNIQUE INDEX "SYS_C0097980" ON "CK_ALARM_CONFIG" ("SID")
    PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOCOMPRESS LOGGING
   ;
--------------------------------------------------------
--  DDL for Index SYS_C0097982
--------------------------------------------------------

CREATE UNIQUE INDEX "SYS_C0097982" ON "CK_ALARM_RECORD" ("SID")
    PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOCOMPRESS LOGGING
   ;
--------------------------------------------------------
--  DDL for Index SYS_C0097987
--------------------------------------------------------

CREATE UNIQUE INDEX "SYS_C0097987" ON "CK_CALENDAR" ("CK_ID")
    PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOCOMPRESS LOGGING
   ;
--------------------------------------------------------
--  DDL for Index SYS_C0097989
--------------------------------------------------------

CREATE UNIQUE INDEX "SYS_C0097989" ON "CK_CHECK_LOG" ("SID")
    PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOCOMPRESS LOGGING
   ;
--------------------------------------------------------
--  DDL for Index SYS_C0097991
--------------------------------------------------------

CREATE UNIQUE INDEX "SYS_C0097991" ON "CK_CHECK_LOG_LATEST" ("METHOD_CONFIG_ID")
    PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOCOMPRESS LOGGING
   ;
--------------------------------------------------------
--  DDL for Index SYS_C0097994
--------------------------------------------------------

CREATE UNIQUE INDEX "SYS_C0097994" ON "CK_CHECK_RESULT" ("SID")
    PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOCOMPRESS LOGGING
   ;
--------------------------------------------------------
--  DDL for Index SYS_C0097996
--------------------------------------------------------

CREATE UNIQUE INDEX "SYS_C0097996" ON "CK_CHECK_RESULT_LATEST" ("METHOD_CONFIG_ID")
    PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOCOMPRESS LOGGING
   ;
--------------------------------------------------------
--  DDL for Index SYS_C0098002
--------------------------------------------------------

CREATE UNIQUE INDEX "SYS_C0098002" ON "CK_FREQUENCY" ("NAME")
    PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOCOMPRESS LOGGING
   ;
--------------------------------------------------------
--  DDL for Index SYS_C0098008
--------------------------------------------------------

CREATE UNIQUE INDEX "SYS_C0098008" ON "CK_GENERAL_CONFIG" ("SID")
    PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOCOMPRESS LOGGING
   ;
--------------------------------------------------------
--  DDL for Index SYS_C0098011
--------------------------------------------------------

CREATE UNIQUE INDEX "SYS_C0098011" ON "CK_GENERAL_CONFIG_DETAIL" ("SID")
    PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOCOMPRESS LOGGING
   ;
--------------------------------------------------------
--  DDL for Index SYS_C0098014
--------------------------------------------------------

CREATE UNIQUE INDEX "SYS_C0098014" ON "CK_GENERAL_RESULT" ("SID")
    PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOCOMPRESS LOGGING
   ;
--------------------------------------------------------
--  DDL for Index SYS_C0098017
--------------------------------------------------------

CREATE UNIQUE INDEX "SYS_C0098017" ON "CK_GENERAL_RESULT_DETAIL" ("SID")
    PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOCOMPRESS LOGGING
   ;
--------------------------------------------------------
--  DDL for Index SYS_C0098019
--------------------------------------------------------

CREATE UNIQUE INDEX "SYS_C0098019" ON "CK_GROUP" ("SID")
    PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOCOMPRESS LOGGING
   ;
--------------------------------------------------------
--  DDL for Index SYS_C0098023
--------------------------------------------------------

CREATE UNIQUE INDEX "SYS_C0098023" ON "CK_INDEX_INFO" ("SID")
    PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOCOMPRESS LOGGING
   ;
--------------------------------------------------------
--  DDL for Index SYS_C0098025
--------------------------------------------------------

CREATE UNIQUE INDEX "SYS_C0098025" ON "CK_INDEX_WEIGHT_INFO" ("SID")
    PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOCOMPRESS LOGGING
   ;
--------------------------------------------------------
--  DDL for Index SYS_C0098027
--------------------------------------------------------

CREATE UNIQUE INDEX "SYS_C0098027" ON "CK_KNOWLEDGE_INFO" ("SID")
    PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOCOMPRESS LOGGING
   ;
--------------------------------------------------------
--  DDL for Index SYS_C0098038
--------------------------------------------------------

CREATE UNIQUE INDEX "SYS_C0098038" ON "CK_METHOD_CONFIG" ("SID")
    PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOCOMPRESS LOGGING
   ;
--------------------------------------------------------
--  DDL for Index SYS_C0098040
--------------------------------------------------------

CREATE UNIQUE INDEX "SYS_C0098040" ON "CK_METHOD_CONFIG_COURSE" ("SID")
    PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOCOMPRESS LOGGING
   ;
--------------------------------------------------------
--  DDL for Index SYS_C0098047
--------------------------------------------------------

CREATE UNIQUE INDEX "SYS_C0098047" ON "CK_METHOD_ITEM" ("SID")
    PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOCOMPRESS LOGGING
   ;
--------------------------------------------------------
--  DDL for Index SYS_C0098058
--------------------------------------------------------

CREATE UNIQUE INDEX "SYS_C0098058" ON "CK_RESULT_DETAIL" ("SID")
    PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOCOMPRESS LOGGING
   ;
--------------------------------------------------------
--  DDL for Index SYS_C0098045
--------------------------------------------------------

CREATE UNIQUE INDEX "SYS_C0098045" ON "CK_RESULT_OPTIONS" ("SID")
    PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOCOMPRESS LOGGING
   ;
--------------------------------------------------------
--  DDL for Index SYS_C0098050
--------------------------------------------------------

CREATE UNIQUE INDEX "SYS_C0098050" ON "CK_RULE_INFO" ("SID")
    PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOCOMPRESS LOGGING
   ;
--------------------------------------------------------
--  DDL for Index SYS_C0098056
--------------------------------------------------------

CREATE UNIQUE INDEX "SYS_C0098056" ON "CK_SCHEDULE_CONFIG" ("SID")
    PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOCOMPRESS LOGGING
   ;
--------------------------------------------------------
--  Constraints for Table CK_ALARM_CONFIG
--------------------------------------------------------

ALTER TABLE "CK_ALARM_CONFIG" MODIFY ("SID" NOT NULL ENABLE);

ALTER TABLE "CK_ALARM_CONFIG" MODIFY ("DELETED" DEFAULT 0 NOT NULL ENABLE);

ALTER TABLE "CK_ALARM_CONFIG" MODIFY ("CREATE_BY" NOT NULL ENABLE);

ALTER TABLE "CK_ALARM_CONFIG" MODIFY ("CREATE_TIME" NOT NULL ENABLE);

ALTER TABLE "CK_ALARM_CONFIG" ADD PRIMARY KEY ("SID")
    USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOCOMPRESS LOGGING
    ENABLE;
--------------------------------------------------------
--  Constraints for Table CK_ALARM_RECORD
--------------------------------------------------------

ALTER TABLE "CK_ALARM_RECORD" MODIFY ("SID" NOT NULL ENABLE);

ALTER TABLE "CK_ALARM_RECORD" ADD PRIMARY KEY ("SID")
    USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOCOMPRESS LOGGING
    ENABLE;
--------------------------------------------------------
--  Constraints for Table CK_CALENDAR
--------------------------------------------------------

ALTER TABLE "CK_CALENDAR" MODIFY ("CK_ID" NOT NULL ENABLE);

ALTER TABLE "CK_CALENDAR" MODIFY ("CK_NAME" NOT NULL ENABLE);

ALTER TABLE "CK_CALENDAR" MODIFY ("CK_YEAR" NOT NULL ENABLE);

ALTER TABLE "CK_CALENDAR" MODIFY ("CK_DATELIST" NOT NULL ENABLE);

ALTER TABLE "CK_CALENDAR" ADD PRIMARY KEY ("CK_ID")
    USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOCOMPRESS LOGGING
    ENABLE;
--------------------------------------------------------
--  Constraints for Table CK_CHECK_LOG
--------------------------------------------------------

ALTER TABLE "CK_CHECK_LOG" MODIFY ("SID" NOT NULL ENABLE);

ALTER TABLE "CK_CHECK_LOG" ADD PRIMARY KEY ("SID")
    USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOCOMPRESS LOGGING
    ENABLE;
--------------------------------------------------------
--  Constraints for Table CK_CHECK_LOG_LATEST
--------------------------------------------------------

ALTER TABLE "CK_CHECK_LOG_LATEST" MODIFY ("METHOD_CONFIG_ID" NOT NULL ENABLE);

ALTER TABLE "CK_CHECK_LOG_LATEST" ADD PRIMARY KEY ("METHOD_CONFIG_ID")
    USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOCOMPRESS LOGGING
    ENABLE;
--------------------------------------------------------
--  Constraints for Table CK_CHECK_RESULT
--------------------------------------------------------

ALTER TABLE "CK_CHECK_RESULT" MODIFY ("SID" NOT NULL ENABLE);

ALTER TABLE "CK_CHECK_RESULT" MODIFY ("METHOD_CONFIG_ID" NOT NULL ENABLE);

ALTER TABLE "CK_CHECK_RESULT" ADD PRIMARY KEY ("SID")
    USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOCOMPRESS LOGGING
    ENABLE;
--------------------------------------------------------
--  Constraints for Table CK_CHECK_RESULT_LATEST
--------------------------------------------------------

ALTER TABLE "CK_CHECK_RESULT_LATEST" MODIFY ("METHOD_CONFIG_ID" NOT NULL ENABLE);

ALTER TABLE "CK_CHECK_RESULT_LATEST" ADD PRIMARY KEY ("METHOD_CONFIG_ID")
    USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOCOMPRESS LOGGING
    ENABLE;
--------------------------------------------------------
--  Constraints for Table CK_FREQUENCY
--------------------------------------------------------

ALTER TABLE "CK_FREQUENCY" MODIFY ("NAME" NOT NULL ENABLE);

ALTER TABLE "CK_FREQUENCY" ADD PRIMARY KEY ("NAME")
    USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOCOMPRESS LOGGING
    ENABLE;
--------------------------------------------------------
--  Constraints for Table CK_GENERAL_CONFIG
--------------------------------------------------------

ALTER TABLE "CK_GENERAL_CONFIG" MODIFY ("SID" NOT NULL ENABLE);

ALTER TABLE "CK_GENERAL_CONFIG" MODIFY ("STATE" NOT NULL ENABLE);

ALTER TABLE "CK_GENERAL_CONFIG" MODIFY ("DELETED" NOT NULL ENABLE);

ALTER TABLE "CK_GENERAL_CONFIG" MODIFY ("CREATE_BY" NOT NULL ENABLE);

ALTER TABLE "CK_GENERAL_CONFIG" MODIFY ("CREATE_TIME" NOT NULL ENABLE);

ALTER TABLE "CK_GENERAL_CONFIG" ADD PRIMARY KEY ("SID")
    USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOCOMPRESS LOGGING
    ENABLE;
--------------------------------------------------------
--  Constraints for Table CK_GENERAL_CONFIG_DETAIL
--------------------------------------------------------

ALTER TABLE "CK_GENERAL_CONFIG_DETAIL" MODIFY ("SID" NOT NULL ENABLE);

ALTER TABLE "CK_GENERAL_CONFIG_DETAIL" MODIFY ("CONFIG_ID" NOT NULL ENABLE);

ALTER TABLE "CK_GENERAL_CONFIG_DETAIL" ADD PRIMARY KEY ("SID")
    USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOCOMPRESS LOGGING
    ENABLE;
--------------------------------------------------------
--  Constraints for Table CK_GENERAL_RESULT
--------------------------------------------------------

ALTER TABLE "CK_GENERAL_RESULT" MODIFY ("SID" NOT NULL ENABLE);

ALTER TABLE "CK_GENERAL_RESULT" MODIFY ("CONFIG_ID" NOT NULL ENABLE);

ALTER TABLE "CK_GENERAL_RESULT" ADD PRIMARY KEY ("SID")
    USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOCOMPRESS LOGGING
    ENABLE;
--------------------------------------------------------
--  Constraints for Table CK_GENERAL_RESULT_DETAIL
--------------------------------------------------------

ALTER TABLE "CK_GENERAL_RESULT_DETAIL" MODIFY ("SID" NOT NULL ENABLE);

ALTER TABLE "CK_GENERAL_RESULT_DETAIL" MODIFY ("RESULT_SID" NOT NULL ENABLE);

ALTER TABLE "CK_GENERAL_RESULT_DETAIL" ADD PRIMARY KEY ("SID")
    USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOCOMPRESS LOGGING
    ENABLE;
--------------------------------------------------------
--  Constraints for Table CK_GROUP
--------------------------------------------------------

ALTER TABLE "CK_GROUP" MODIFY ("SID" NOT NULL ENABLE);

ALTER TABLE "CK_GROUP" ADD PRIMARY KEY ("SID")
    USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOCOMPRESS LOGGING
    ENABLE;
--------------------------------------------------------
--  Constraints for Table CK_GROUP_RELATION
--------------------------------------------------------

ALTER TABLE "CK_GROUP_RELATION" MODIFY ("CONFIGSID" NOT NULL ENABLE);

ALTER TABLE "CK_GROUP_RELATION" MODIFY ("CONFIGTYPE" NOT NULL ENABLE);
--------------------------------------------------------
--  Constraints for Table CK_INDEX_INFO
--------------------------------------------------------

ALTER TABLE "CK_INDEX_INFO" MODIFY ("SID" NOT NULL ENABLE);

ALTER TABLE "CK_INDEX_INFO" ADD PRIMARY KEY ("SID")
    USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOCOMPRESS LOGGING
    ENABLE;
--------------------------------------------------------
--  Constraints for Table CK_INDEX_WEIGHT_INFO
--------------------------------------------------------

ALTER TABLE "CK_INDEX_WEIGHT_INFO" MODIFY ("SID" NOT NULL ENABLE);

ALTER TABLE "CK_INDEX_WEIGHT_INFO" ADD PRIMARY KEY ("SID")
    USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOCOMPRESS LOGGING
    ENABLE;
--------------------------------------------------------
--  Constraints for Table CK_KNOWLEDGE_INFO
--------------------------------------------------------

ALTER TABLE "CK_KNOWLEDGE_INFO" MODIFY ("SID" NOT NULL ENABLE);

ALTER TABLE "CK_KNOWLEDGE_INFO" ADD PRIMARY KEY ("SID")
    USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOCOMPRESS LOGGING
    ENABLE;
--------------------------------------------------------
--  Constraints for Table CK_KNOWLEDGE_LOG
--------------------------------------------------------

ALTER TABLE "CK_KNOWLEDGE_LOG" MODIFY ("SID" NOT NULL ENABLE);
--------------------------------------------------------
--  Constraints for Table CK_METHOD_CONFIG
--------------------------------------------------------
ALTER TABLE "CK_METHOD_CONFIG" MODIFY ("SID" NOT NULL ENABLE);

ALTER TABLE "CK_METHOD_CONFIG" MODIFY ("NAME" NOT NULL ENABLE);

ALTER TABLE "CK_METHOD_CONFIG" MODIFY ("TABLE_CODE" NOT NULL ENABLE);

ALTER TABLE "CK_METHOD_CONFIG" MODIFY ("INSTANCE_CODE" NOT NULL ENABLE);

ALTER TABLE "CK_METHOD_CONFIG" MODIFY ("STATE" NOT NULL ENABLE);

ALTER TABLE "CK_METHOD_CONFIG" MODIFY ("DELETED" DEFAULT 0 NOT NULL ENABLE);

ALTER TABLE "CK_METHOD_CONFIG" MODIFY ("CREATE_BY" NOT NULL ENABLE);

ALTER TABLE "CK_METHOD_CONFIG" MODIFY ("CREATE_TIME" NOT NULL ENABLE);

ALTER TABLE "CK_METHOD_CONFIG" ADD PRIMARY KEY ("SID")
    USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOCOMPRESS LOGGING
    ENABLE;
--------------------------------------------------------
--  Constraints for Table CK_METHOD_CONFIG_COURSE
--------------------------------------------------------

ALTER TABLE "CK_METHOD_CONFIG_COURSE" MODIFY ("SID" NOT NULL ENABLE);

ALTER TABLE "CK_METHOD_CONFIG_COURSE" ADD PRIMARY KEY ("SID")
    USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOCOMPRESS LOGGING
    ENABLE;
--------------------------------------------------------
--  Constraints for Table CK_METHOD_ITEM
--------------------------------------------------------

ALTER TABLE "CK_METHOD_ITEM" MODIFY ("SID" NOT NULL ENABLE);

ALTER TABLE "CK_METHOD_ITEM" ADD PRIMARY KEY ("SID")
    USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOCOMPRESS LOGGING
    ENABLE;
--------------------------------------------------------
--  Constraints for Table CK_RESULT_DETAIL
--------------------------------------------------------

ALTER TABLE "CK_RESULT_DETAIL" MODIFY ("SID" NOT NULL ENABLE);

ALTER TABLE "CK_RESULT_DETAIL" ADD PRIMARY KEY ("SID")
    USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOCOMPRESS LOGGING
    ENABLE;
--------------------------------------------------------
--  Constraints for Table CK_RESULT_OPTIONS
--------------------------------------------------------

ALTER TABLE "CK_RESULT_OPTIONS" MODIFY ("SID" NOT NULL ENABLE);

ALTER TABLE "CK_RESULT_OPTIONS" MODIFY ("CHECK_METHOD" NOT NULL ENABLE);

ALTER TABLE "CK_RESULT_OPTIONS" MODIFY ("RESULT_SID" NOT NULL ENABLE);

ALTER TABLE "CK_RESULT_OPTIONS" MODIFY ("OPTION_SID" NOT NULL ENABLE);

ALTER TABLE "CK_RESULT_OPTIONS" ADD PRIMARY KEY ("SID")
    USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOCOMPRESS LOGGING
    ENABLE;
--------------------------------------------------------
--  Constraints for Table CK_RULE_INFO
--------------------------------------------------------

ALTER TABLE "CK_RULE_INFO" MODIFY ("SID" NOT NULL ENABLE);

ALTER TABLE "CK_RULE_INFO" MODIFY ("RULE_CODE" NOT NULL ENABLE);

ALTER TABLE "CK_RULE_INFO" ADD PRIMARY KEY ("SID")
    USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOCOMPRESS LOGGING
    ENABLE;
--------------------------------------------------------
--  Constraints for Table CK_SCHEDULE_CONFIG
--------------------------------------------------------

ALTER TABLE "CK_SCHEDULE_CONFIG" MODIFY ("SID" NOT NULL ENABLE);

ALTER TABLE "CK_SCHEDULE_CONFIG" MODIFY ("STATE" NOT NULL ENABLE);

ALTER TABLE "CK_SCHEDULE_CONFIG" MODIFY ("DELETED" NOT NULL ENABLE);

ALTER TABLE "CK_SCHEDULE_CONFIG" MODIFY ("CREATE_BY" NOT NULL ENABLE);

ALTER TABLE "CK_SCHEDULE_CONFIG" MODIFY ("CREATE_TIME" NOT NULL ENABLE);

ALTER TABLE "CK_SCHEDULE_CONFIG" ADD PRIMARY KEY ("SID")
    USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOCOMPRESS LOGGING
    ENABLE;

-- ----------------------------
-- Primary Key structure for table CL_CLASSIF_INFO
-- ----------------------------
ALTER TABLE "CL_CLASSIF_INFO"
    ADD CONSTRAINT "PRIMARY_111" PRIMARY KEY ("SID");

-- ----------------------------
-- Uniques structure for table CL_CLASSIF_INFO
-- ----------------------------
ALTER TABLE "CL_CLASSIF_INFO"
    ADD CONSTRAINT "IDEX_CLS_SEQ" UNIQUE ("SEQ") NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Checks structure for table CL_CLASSIF_INFO
-- ----------------------------
ALTER TABLE "CL_CLASSIF_INFO"
    ADD CONSTRAINT "SYS_C0097234" CHECK ("SID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Indexes structure for table CL_CLASSIF_INFO
-- ----------------------------
CREATE INDEX "IDEX_CLS_UPPERCLASSIF"
    ON "CL_CLASSIF_INFO" ("UPPER_CLASSIF" ASC);


-- ----------------------------
-- Primary Key structure for table CL_DATA_CLASSIF
-- ----------------------------
ALTER TABLE "CL_DATA_CLASSIF"
    ADD CONSTRAINT "PRIMARY_112" PRIMARY KEY ("RESOURCE_ID", "CLASSIF_SID");

-- ----------------------------
-- Checks structure for table CL_DATA_CLASSIF
-- ----------------------------
ALTER TABLE "CL_DATA_CLASSIF"
    ADD CONSTRAINT "SYS_C0097237" CHECK ("RESOURCE_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "CL_DATA_CLASSIF"
    ADD CONSTRAINT "SYS_C0097238" CHECK ("CLASSIF_SID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Indexes structure for table CL_DATA_CLASSIF
-- ----------------------------
CREATE INDEX "IDX_CDC_CLASSIF_SID"
    ON "CL_DATA_CLASSIF" ("CLASSIF_SID" ASC);

CREATE INDEX "IDX_CDC_RESOURCE_ID"
    ON "CL_DATA_CLASSIF" ("RESOURCE_ID" ASC);

-- ----------------------------
-- Primary Key structure for table CL_DATA_LEVEL
-- ----------------------------
ALTER TABLE "CL_DATA_LEVEL"
    ADD CONSTRAINT "PRIMARY_113" PRIMARY KEY ("RESOURCE_SID", "LEVEL_SID");

-- ----------------------------
-- Checks structure for table CL_DATA_LEVEL
-- ----------------------------
ALTER TABLE "CL_DATA_LEVEL"
    ADD CONSTRAINT "SYS_C0097240" CHECK ("RESOURCE_SID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "CL_DATA_LEVEL"
    ADD CONSTRAINT "SYS_C0097241" CHECK ("LEVEL_SID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Primary Key structure for table CL_LEVEL_INFO
-- ----------------------------
ALTER TABLE "CL_LEVEL_INFO"
    ADD CONSTRAINT "PRIMARY_114" PRIMARY KEY ("SID");

-- ----------------------------
-- Checks structure for table CL_LEVEL_INFO
-- ----------------------------
ALTER TABLE "CL_LEVEL_INFO"
    ADD CONSTRAINT "SYS_C0097243" CHECK ("SID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Primary Key structure for table CL_RESOUCE_COUNT
-- ----------------------------
ALTER TABLE "CL_RESOUCE_COUNT"
    ADD CONSTRAINT "PRIMARY_115" PRIMARY KEY ("SID");

-- ----------------------------
-- Checks structure for table CL_RESOUCE_COUNT
-- ----------------------------
ALTER TABLE "CL_RESOUCE_COUNT"
    ADD CONSTRAINT "SYS_C0097245" CHECK ("SID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Primary Key structure for table CL_RESOUCE_COUNT_TEMP
-- ----------------------------
ALTER TABLE "CL_RESOUCE_COUNT_TEMP"
    ADD CONSTRAINT "PRIMARY_116" PRIMARY KEY ("SID");

-- ----------------------------
-- Checks structure for table CL_RESOUCE_COUNT_TEMP
-- ----------------------------
ALTER TABLE "CL_RESOUCE_COUNT_TEMP"
    ADD CONSTRAINT "SYS_C0097247" CHECK ("SID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Primary Key structure for table CL_ROLE_CLASSIF
-- ----------------------------
ALTER TABLE "CL_ROLE_CLASSIF"
    ADD CONSTRAINT "PRIMARY_117" PRIMARY KEY ("ROLE_SID", "CLASSIF_SID");

-- ----------------------------
-- Checks structure for table CL_ROLE_CLASSIF
-- ----------------------------
ALTER TABLE "CL_ROLE_CLASSIF"
    ADD CONSTRAINT "SYS_C0097249" CHECK ("ROLE_SID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "CL_ROLE_CLASSIF"
    ADD CONSTRAINT "SYS_C0097250" CHECK ("CLASSIF_SID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Primary Key structure for table CL_ROLE_LEVEL
-- ----------------------------
ALTER TABLE "CL_ROLE_LEVEL"
    ADD CONSTRAINT "PRIMARY_118" PRIMARY KEY ("ROLE_SID", "LEVEL_SID");

-- ----------------------------
-- Checks structure for table CL_ROLE_LEVEL
-- ----------------------------
ALTER TABLE "CL_ROLE_LEVEL"
    ADD CONSTRAINT "SYS_C0097252" CHECK ("ROLE_SID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "CL_ROLE_LEVEL"
    ADD CONSTRAINT "SYS_C0097253" CHECK ("LEVEL_SID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Primary Key structure for table DS_DATA_CONFIG_MGR
-- ----------------------------
ALTER TABLE "DS_DATA_CONFIG_MGR"
    ADD CONSTRAINT "PRIMARY_26" PRIMARY KEY ("SID");

-- ----------------------------
-- Checks structure for table DS_DATA_CONFIG_MGR
-- ----------------------------
ALTER TABLE "DS_DATA_CONFIG_MGR"
    ADD CONSTRAINT "SYS_C0097329" CHECK ("SID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "DS_DATA_CONFIG_MGR"
    ADD CONSTRAINT "SYS_C0097330" CHECK ("CONFIGCODE" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "DS_DATA_CONFIG_MGR"
    ADD CONSTRAINT "SYS_C0097331" CHECK ("CONFIGNAME" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "DS_DATA_CONFIG_MGR"
    ADD CONSTRAINT "SYS_C0097332" CHECK ("CONFIGTYPE" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Primary Key structure for table DS_DATA_SOURCE
-- ----------------------------
ALTER TABLE "DS_DATA_SOURCE"
    ADD CONSTRAINT "PRIMARY_27" PRIMARY KEY ("SID");

-- ----------------------------
-- Checks structure for table DS_DATA_SOURCE
-- ----------------------------
ALTER TABLE "DS_DATA_SOURCE"
    ADD CONSTRAINT "SYS_C0097334" CHECK ("SID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Primary Key structure for table DS_HBASE_MAPPPING
-- ----------------------------
ALTER TABLE "DS_HBASE_MAPPPING"
    ADD CONSTRAINT "PRIMARY_30" PRIMARY KEY ("SID");

-- ----------------------------
-- Checks structure for table DS_HBASE_MAPPPING
-- ----------------------------
ALTER TABLE "DS_HBASE_MAPPPING"
    ADD CONSTRAINT "SYS_C0097343" CHECK ("SID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

ALTER TABLE "DS_HBASE_MAPPPING"
    ADD CONSTRAINT "SYS_C0097344" CHECK ("HBASE_TABLE" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Primary Key structure for table PO_FEEDBACK
-- ----------------------------
ALTER TABLE "PO_FEEDBACK"
    ADD CONSTRAINT "PRIMARY_87" PRIMARY KEY ("SID");

-- ----------------------------
-- Checks structure for table PO_FEEDBACK
-- ----------------------------
ALTER TABLE "PO_FEEDBACK"
    ADD CONSTRAINT "SYS_C0097497" CHECK ("SID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "PO_FEEDBACK"
    ADD CONSTRAINT "SYS_C0097498" CHECK ("OPTIONID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "PO_FEEDBACK"
    ADD CONSTRAINT "SYS_C0097499" CHECK ("USERNAME" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "PO_FEEDBACK"
    ADD CONSTRAINT "SYS_C0097500" CHECK ("FEEDBACK" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Primary Key structure for table PO_FILES
-- ----------------------------
ALTER TABLE "PO_FILES"
    ADD CONSTRAINT "PRIMARY_88" PRIMARY KEY ("SID");

-- ----------------------------
-- Checks structure for table PO_FILES
-- ----------------------------
ALTER TABLE "PO_FILES"
    ADD CONSTRAINT "SYS_C0097502" CHECK ("SID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "PO_FILES"
    ADD CONSTRAINT "SYS_C0097503" CHECK ("FILENAME" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "PO_FILES"
    ADD CONSTRAINT "SYS_C0097504" CHECK ("ACTUALFILENAME" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Primary Key structure for table PO_OPTIONS
-- ----------------------------
ALTER TABLE "PO_OPTIONS"
    ADD CONSTRAINT "PRIMARY_89" PRIMARY KEY ("SID");

-- ----------------------------
-- Checks structure for table PO_OPTIONS
-- ----------------------------
ALTER TABLE "PO_OPTIONS"
    ADD CONSTRAINT "SYS_C0097506" CHECK ("SID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "PO_OPTIONS"
    ADD CONSTRAINT "SYS_C0097507" CHECK ("TITLE" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "PO_OPTIONS"
    ADD CONSTRAINT "SYS_C0097508" CHECK ("SOURCE" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "PO_OPTIONS"
    ADD CONSTRAINT "SYS_C0097509" CHECK ("DESCRIPTION" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "PO_OPTIONS"
    ADD CONSTRAINT "SYS_C0097510" CHECK ("STATUS" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "PO_OPTIONS"
    ADD CONSTRAINT "SYS_C0097511" CHECK ("USERNAME" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Primary Key structure for table DS_RESOURCE_INFO
-- ----------------------------
ALTER TABLE "DS_RESOURCE_INFO" ADD CONSTRAINT "SYS_C0097969" PRIMARY KEY ("SID");

-- ----------------------------
-- Checks structure for table DS_RESOURCE_INFO
-- ----------------------------
ALTER TABLE "DS_RESOURCE_INFO" ADD CONSTRAINT "SYS_C0097968" CHECK ("SID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Primary Key structure for table DS_RESOURCE_ITEM
-- ----------------------------
ALTER TABLE "DS_RESOURCE_ITEM" ADD CONSTRAINT "SYS_C0097973" PRIMARY KEY ("SID");

-- ----------------------------
-- Checks structure for table DS_RESOURCE_ITEM
-- ----------------------------
ALTER TABLE "DS_RESOURCE_ITEM" ADD CONSTRAINT "SYS_C0097972" CHECK ("SID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;


create table DQMS_OPERATION_LOG
(
    ID                   varchar(64) not null ,
    OPERATOR_ID          varchar(64) ,
    OPERATOR_NAME        varchar(64),
    OPERATE_TYPE         int,
    OPERATE_DATE         date,
    TARGET_TYPE          varchar(64),
    TARGET_MODEL_ID      varchar(64),
    TARGET_MODEL_NAME    varchar(64),
    MESSAGE              CLOB,
    TENANT_ID            varchar(64),
    primary key (ID)
);
COMMENT ON TABLE dqms_operation_log IS '操作日志';
COMMENT ON COLUMN dqms_operation_log.id IS '操作日志ID';
COMMENT ON COLUMN dqms_operation_log.operator_id IS '操作者ID';
COMMENT ON COLUMN dqms_operation_log.operator_name IS '操作者名称';
COMMENT ON COLUMN dqms_operation_log.operate_type IS '操作类型';
COMMENT ON COLUMN dqms_operation_log.operate_date IS '时间';
COMMENT ON COLUMN dqms_operation_log.target_type IS '目标类型';
COMMENT ON COLUMN dqms_operation_log.target_model_id IS '目标ID';
COMMENT ON COLUMN dqms_operation_log.target_model_name IS '目标名称';
COMMENT ON COLUMN dqms_operation_log.message IS '信息';
COMMENT ON COLUMN dqms_operation_log.tenant_id IS '租户ID';

COMMENT ON TABLE DQMS_OPERATION_LOG IS '操作日志';
CREATE INDEX LOG_INDEX_OPERATOR ON DQMS_OPERATION_LOG(OPERATOR_NAME);
CREATE INDEX LOG_INDEX_OPERATE_TYPE ON DQMS_OPERATION_LOG(OPERATE_TYPE);
CREATE INDEX LOG_INDEX_TARGET ON DQMS_OPERATION_LOG(TARGET_TYPE, TARGET_MODEL_ID, TARGET_MODEL_NAME);


CREATE TABLE DQMS_OPERATION_LOG_DETAIL
(
    ID                   varchar(64) not null,
    OLD_DATA_JSON        CLOB,
    NEW_DATA_JSON        CLOB,
    primary key (ID)
);

COMMENT ON COLUMN DQMS_OPERATION_LOG_DETAIL.ID IS '日志详情ID';
COMMENT ON COLUMN DQMS_OPERATION_LOG_DETAIL.OLD_DATA_JSON IS '旧值';
COMMENT ON COLUMN DQMS_OPERATION_LOG_DETAIL.NEW_DATA_JSON IS '新值';
COMMENT ON TABLE DQMS_OPERATION_LOG_DETAIL IS '操作日志详情';

-----------------------------
-- 组织机构评分
-----------------------------
CREATE TABLE DQMS_RATING_RESULT(
    ID  NUMBER(20,0) PRIMARY KEY,
    ORG_ID VARCHAR(64),
    ORG_NAME VARCHAR(50),
    ORG_LEVEL VARCHAR(2),
    PARENT_ORG_ID VARCHAR(64),
    SCORE NUMBER(20,0),
    START_DATE TIMESTAMP,
    END_DATE TIMESTAMP,
    RATING_CYCLE VARCHAR(50),
    RATING_POINT VARCHAR(50),
    CREATE_TIME TIMESTAMP,
    CREATE_USER VARCHAR(25),
    LAST_MODIFIER_TIME TIMESTAMP,
    LAST_MODIFIER_USER VARCHAR(25)
);
COMMENT ON COLUMN DQMS_RATING_RESULT.ORG_ID IS '组织ID';
COMMENT ON COLUMN DQMS_RATING_RESULT.ORG_NAME IS '组织名';
COMMENT ON COLUMN DQMS_RATING_RESULT.ORG_LEVEL IS '组织等级';
COMMENT ON COLUMN DQMS_RATING_RESULT.PARENT_ORG_ID IS '父组织ID';
COMMENT ON COLUMN DQMS_RATING_RESULT.SCORE IS '得分';
COMMENT ON COLUMN DQMS_RATING_RESULT.START_DATE IS '评估开始日期';
COMMENT ON COLUMN DQMS_RATING_RESULT.END_DATE IS '评估截至日期';
COMMENT ON COLUMN DQMS_RATING_RESULT.RATING_CYCLE IS '评分周期 年（year）、季度（quarter）、月（month）、周（week），默认月';
COMMENT ON COLUMN DQMS_RATING_RESULT.RATING_POINT IS '评分点 例如：2023-01';

--------------------------------------------------------
--  DDL for Index SYS_C0098278
--------------------------------------------------------

DELETE FROM cof_dict_type;
INSERT INTO cof_dict_type (ID, CODE, NAME, DESCRIPTION, CREATE_TIME, UPDATE_TIME, TENANT_ID, PARENT_ID, LOCALE, SORT_NO, IS_LEAF, TREE_LEVEL, SEQ, IS_FIXED)
VALUES ('314575736782065664', 'CK_CHECK_TYPE', '检核类型', null, null, null, 'default', null, 'zh', null, 1, 1, '.82.', 0);
INSERT INTO cof_dict_type (ID, CODE, NAME, DESCRIPTION, CREATE_TIME, UPDATE_TIME, TENANT_ID, PARENT_ID, LOCALE, SORT_NO, IS_LEAF, TREE_LEVEL, SEQ, IS_FIXED) VALUES ('42497a16-8bb6-4c06-8142-880efb4ee397', 'CHECK_RESOURCE_TYPE', '检核规则类型', null, null, null, 'default', null, 'zh', 0, 1, 1, '.87.', 0);
INSERT INTO cof_dict_type (ID, CODE, NAME, DESCRIPTION, CREATE_TIME, UPDATE_TIME, TENANT_ID, PARENT_ID, LOCALE, SORT_NO, IS_LEAF, TREE_LEVEL, SEQ, IS_FIXED) VALUES ('429501651677614080', 'CK_GENERAL_CHECK_STATE', '通用检核配置状态', null, null, null, 'default', null, 'zh', null, 1, 1, '.46.', 0);
INSERT INTO cof_dict_type (ID, CODE, NAME, DESCRIPTION, CREATE_TIME, UPDATE_TIME, TENANT_ID, PARENT_ID, LOCALE, SORT_NO, IS_LEAF, TREE_LEVEL, SEQ, IS_FIXED) VALUES ('306247813742333952', 'CK_RULE_VALUE_TYPE', '规则值类型', null, null, null, 'default', null, 'zh', null, 1, 1, '.82.', 0);
INSERT INTO cof_dict_type (ID, CODE, NAME, DESCRIPTION, CREATE_TIME, UPDATE_TIME, TENANT_ID, PARENT_ID, LOCALE, SORT_NO, IS_LEAF, TREE_LEVEL, SEQ, IS_FIXED) VALUES ('306242162043523072', 'CK_RULE_OPTION', '规则操作符', null, null, null, 'default', null, 'zh', null, 1, 1, '.82.', 0);
INSERT INTO cof_dict_type (ID, CODE, NAME, DESCRIPTION, CREATE_TIME, UPDATE_TIME, TENANT_ID, PARENT_ID, LOCALE, SORT_NO, IS_LEAF, TREE_LEVEL, SEQ, IS_FIXED) VALUES ('423644463499317248', 'CK_COMMONCHECK_TYPE', '通用检核配置类型', null, null, null, 'default', null, 'zh', null, 1, 1, '.49.', 0);
INSERT INTO cof_dict_type (ID, CODE, NAME, DESCRIPTION, CREATE_TIME, UPDATE_TIME, TENANT_ID, PARENT_ID, LOCALE, SORT_NO, IS_LEAF, TREE_LEVEL, SEQ, IS_FIXED) VALUES ('25fcceeb-12bf-4b11-ad5f-6af625fb2028', 'CK_CHECK_GENERAL', '通用检核', null, null, null, 'default', null, 'zh', 0, 1, 1, '.90.', 0);
INSERT INTO cof_dict_type (ID, CODE, NAME, DESCRIPTION, CREATE_TIME, UPDATE_TIME, TENANT_ID, PARENT_ID, LOCALE, SORT_NO, IS_LEAF, TREE_LEVEL, SEQ, IS_FIXED) VALUES ('430613552059285504', 'CK_SCHEDULE_TYPE', '调度类型', null, null, null, 'default', null, 'zh', 45, 1, 1, '.45.', 0);
INSERT INTO cof_dict_type (ID, CODE, NAME, DESCRIPTION, CREATE_TIME, UPDATE_TIME, TENANT_ID, PARENT_ID, LOCALE, SORT_NO, IS_LEAF, TREE_LEVEL, SEQ, IS_FIXED) VALUES ('435019220119879680', 'CK_JOB_HANDLER', '任务类别', null, null, null, 'default', null, 'zh', 42, 1, 1, '.42.', 0);
INSERT INTO cof_dict_type (ID, CODE, NAME, DESCRIPTION, CREATE_TIME, UPDATE_TIME, TENANT_ID, PARENT_ID, LOCALE, SORT_NO, IS_LEAF, TREE_LEVEL, SEQ, IS_FIXED) VALUES ('464219649722449921', 'CK_SCHEDULER_MONITOR_STATUS', '调度任务监控状态', null, null, null, 'default', null, 'zh', 23, 1, 1, '.23.', 0);
INSERT INTO cof_dict_type (ID, CODE, NAME, DESCRIPTION, CREATE_TIME, UPDATE_TIME, TENANT_ID, PARENT_ID, LOCALE, SORT_NO, IS_LEAF, TREE_LEVEL, SEQ, IS_FIXED) VALUES ('437418455066902528', 'CK_ALARM_TYPE', '告警阈值类型', null, null, null, 'default', null, 'zh', 40, 1, 1, '.40.', 0);
INSERT INTO cof_dict_type (ID, CODE, NAME, DESCRIPTION, CREATE_TIME, UPDATE_TIME, TENANT_ID, PARENT_ID, LOCALE, SORT_NO, IS_LEAF, TREE_LEVEL, SEQ, IS_FIXED) VALUES ('437418825000321024', 'CK_ALARM_RELATION', '告警阈值关系', null, null, null, 'default', null, 'zh', 39, 1, 1, '.39.', 0);
INSERT INTO cof_dict_type (ID, CODE, NAME, DESCRIPTION, CREATE_TIME, UPDATE_TIME, TENANT_ID, PARENT_ID, LOCALE, SORT_NO, IS_LEAF, TREE_LEVEL, SEQ, IS_FIXED) VALUES ('437419085214941184', 'CK_ALARM_LEVEL', '告警级别', null, null, null, 'default', null, 'zh', 38, 1, 1, '.38.', 0);
INSERT INTO cof_dict_type (ID, CODE, NAME, DESCRIPTION, CREATE_TIME, UPDATE_TIME, TENANT_ID, PARENT_ID, LOCALE, SORT_NO, IS_LEAF, TREE_LEVEL, SEQ, IS_FIXED) VALUES ('438970573996953600', 'CK_ALARM_STATE', '告警配置状态', null, null, null, 'default', null, 'zh', 37, 1, 1, '.37.', 0);
INSERT INTO cof_dict_type (ID, CODE, NAME, DESCRIPTION, CREATE_TIME, UPDATE_TIME, TENANT_ID, PARENT_ID, LOCALE, SORT_NO, IS_LEAF, TREE_LEVEL, SEQ, IS_FIXED) VALUES ('449125026590896128', 'CK_ALARM_RECORD_STATE', '告警记录状态', NULL, to_date('2020-07-31 18:29:20','yyyy-mm-dd hh24:mi:ss'), NULL, 'default', NULL, 'zh', 31, 1, 1, '.31.', 0);
INSERT INTO cof_dict_type (ID, CODE, NAME, DESCRIPTION, CREATE_TIME, UPDATE_TIME, TENANT_ID, PARENT_ID, LOCALE, SORT_NO, IS_LEAF, TREE_LEVEL, SEQ, IS_FIXED) VALUES ('306738524021460992', 'PO_OPTIONS_SOURCE', '问题来源', null, null, null, 'default', null, 'zh', null, 1, 1, '.82.', 0);
INSERT INTO cof_dict_type (ID, CODE, NAME, DESCRIPTION, CREATE_TIME, UPDATE_TIME, TENANT_ID, PARENT_ID, LOCALE, SORT_NO, IS_LEAF, TREE_LEVEL, SEQ, IS_FIXED) VALUES ('478779397398495232', 'DATA_SOURCE_TYPE', '数据源类型', null, null, null, 'default', null, 'zh', 20, 1, 1, '.20.', 0);
INSERT INTO cof_dict_type (ID, CODE, NAME, DESCRIPTION, CREATE_TIME, UPDATE_TIME, TENANT_ID, PARENT_ID, LOCALE, SORT_NO, IS_LEAF, TREE_LEVEL, SEQ, IS_FIXED) VALUES ('341743150732808192', 'DS_SOURCE', '数据源来源', null, null, null, 'default', null, 'zh', null, 1, 1, '.66.', 0);
INSERT INTO cof_dict_type (ID, CODE, NAME, DESCRIPTION, CREATE_TIME, UPDATE_TIME, TENANT_ID, PARENT_ID, LOCALE, SORT_NO, IS_LEAF, TREE_LEVEL, SEQ, IS_FIXED) VALUES ('328430455870853120', 'ITEM_TYPE', '数据项值类型', null, null, null, 'default', null, 'zh', null, 1, 1, '.74.', 0);
INSERT INTO cof_dict_type (ID, CODE, NAME, DESCRIPTION, CREATE_TIME, UPDATE_TIME, TENANT_ID, PARENT_ID, LOCALE, SORT_NO, IS_LEAF, TREE_LEVEL, SEQ, IS_FIXED) VALUES ('341474990574145536', 'DS_DIRVER', '数据源驱动', null, null, null, 'default', null, 'zh', null, 1, 1, '.67.', 0);
INSERT INTO cof_dict_type (ID, CODE, NAME, DESCRIPTION, CREATE_TIME, UPDATE_TIME, TENANT_ID, PARENT_ID, LOCALE, SORT_NO, IS_LEAF, TREE_LEVEL, SEQ, IS_FIXED) VALUES ('486772360502214656', 'CK_EXECUTOR_CONFIG', '检核执行相关配置', null, null, null, 'default', null, 'zh', 19, 1, 1, '.19.', 0);
INSERT INTO cof_dict_type (ID, CODE, NAME, DESCRIPTION, CREATE_TIME, UPDATE_TIME, TENANT_ID, PARENT_ID, LOCALE, SORT_NO, IS_LEAF, TREE_LEVEL, SEQ, IS_FIXED) VALUES ('449121282373464064', 'CK_ALARM_STAT_START_TIME', '告警信息记录起始时间', NULL, to_date('2020-07-31 18:14:28','yyyy-mm-dd hh24:mi:ss'), NULL, 'default', NULL, 'zh', 32, 1, 1, '.32.', 0);
INSERT INTO cof_dict_type (ID, CODE, NAME, DESCRIPTION, CREATE_TIME, UPDATE_TIME, TENANT_ID, PARENT_ID, LOCALE, SORT_NO, IS_LEAF, TREE_LEVEL, SEQ, IS_FIXED) VALUES ('44e4253a-2105-4a4e-a091-45952c7c5dc8', 'CK_CHECK_MONITOR_STATUS', '检核规则监控状态', NULL,  to_date('2021-04-22 15:18:34','yyyy-mm-dd hh24:mi:ss'), to_date('2021-04-22 15:18:34','yyyy-mm-dd hh24:mi:ss'), 'default', NULL, 'zh', 0, 1, 1, '.88.', 0);
INSERT INTO cof_dict_type (ID, CODE, NAME, DESCRIPTION, CREATE_TIME, UPDATE_TIME, TENANT_ID, PARENT_ID, LOCALE, SORT_NO, IS_LEAF, TREE_LEVEL, SEQ, IS_FIXED) VALUES ('308046373039247360', 'CK_INDEX_LEVEL', '指标级别', NULL,  to_date('2019-09-02 16:11:05','yyyy-mm-dd hh24:mi:ss'), NULL, 'default', NULL, 'zh', NULL, 1, 1, '.82.', 0);
INSERT INTO COF_DICT_TYPE (ID, CODE, NAME, DESCRIPTION, CREATE_TIME, UPDATE_TIME, TENANT_ID, PARENT_ID, LOCALE, SORT_NO, IS_LEAF, TREE_LEVEL, SEQ, IS_FIXED) VALUES ('307009384934412288', 'PO_OPTIONS_STATUS', '问题状态', NULL, to_date('2019-09-02 16:11:05','yyyy-mm-dd hh24:mi:ss'), NULL, 'default', NULL, 'zh', NULL, 1, 1, '.82.', 0);


DELETE FROM cof_dict_entry;
INSERT INTO cof_dict_entry (ID, CODE, DICT_TYPE_ID, NAME, DESCRIPTION, CREATE_TIME, UPDATE_TIME, TENANT_ID, PARENT_ID, LOCALE, STATUS, SORT_NO, IS_LEAF, TREE_LEVEL, SEQ, IS_FIXED) VALUES ('449121473755361280', 'starttime', '449121282373464064', '2021-06-02 17:10:55', NULL, NULL, NULL, 'default', NULL, 'zh', 'ENABLED', 1, 1, NULL, '.60.', 0);
INSERT INTO cof_dict_entry (ID, CODE, DICT_TYPE_ID, NAME, DESCRIPTION, CREATE_TIME, UPDATE_TIME, TENANT_ID, PARENT_ID, LOCALE, STATUS, SORT_NO, IS_LEAF, TREE_LEVEL, SEQ, IS_FIXED) VALUES ('314575915853680640', '1', '314575736782065664', '完整性', null, null, null, 'default', null, 'zh', 'ENABLED', 1, 1, null, '.60.', 0);
INSERT INTO cof_dict_entry (ID, CODE, DICT_TYPE_ID, NAME, DESCRIPTION, CREATE_TIME, UPDATE_TIME, TENANT_ID, PARENT_ID, LOCALE, STATUS, SORT_NO, IS_LEAF, TREE_LEVEL, SEQ, IS_FIXED) VALUES ('314575941719953408', '2', '314575736782065664', '有效性', null, null, null, 'default', null, 'zh', 'ENABLED', 2, 1, null, '.60.', 0);
INSERT INTO cof_dict_entry (ID, CODE, DICT_TYPE_ID, NAME, DESCRIPTION, CREATE_TIME, UPDATE_TIME, TENANT_ID, PARENT_ID, LOCALE, STATUS, SORT_NO, IS_LEAF, TREE_LEVEL, SEQ, IS_FIXED) VALUES ('314575967619780608', '3', '314575736782065664', '正确性', null, null, null, 'default', null, 'zh', 'ENABLED', 3, 1, null, '.60.', 0);
INSERT INTO cof_dict_entry (ID, CODE, DICT_TYPE_ID, NAME, DESCRIPTION, CREATE_TIME, UPDATE_TIME, TENANT_ID, PARENT_ID, LOCALE, STATUS, SORT_NO, IS_LEAF, TREE_LEVEL, SEQ, IS_FIXED) VALUES ('314576003359444992', '4', '314575736782065664', '唯一性', null, null, null, 'default', null, 'zh', 'ENABLED', 4, 1, null, '.60.', 0);
INSERT INTO cof_dict_entry (ID, CODE, DICT_TYPE_ID, NAME, DESCRIPTION, CREATE_TIME, UPDATE_TIME, TENANT_ID, PARENT_ID, LOCALE, STATUS, SORT_NO, IS_LEAF, TREE_LEVEL, SEQ, IS_FIXED) VALUES ('314576033013174272', '5', '314575736782065664', '及时性', null, null, null, 'default', null, 'zh', 'ENABLED', 5, 1, null, '.60.', 0);
INSERT INTO cof_dict_entry (ID, CODE, DICT_TYPE_ID, NAME, DESCRIPTION, CREATE_TIME, UPDATE_TIME, TENANT_ID, PARENT_ID, LOCALE, STATUS, SORT_NO, IS_LEAF, TREE_LEVEL, SEQ, IS_FIXED) VALUES ('314576061412806656', '6', '314575736782065664', '合理性', null, null, null, 'default', null, 'zh', 'ENABLED', 6, 1, null, '.60.', 0);
INSERT INTO cof_dict_entry (ID, CODE, DICT_TYPE_ID, NAME, DESCRIPTION, CREATE_TIME, UPDATE_TIME, TENANT_ID, PARENT_ID, LOCALE, STATUS, SORT_NO, IS_LEAF, TREE_LEVEL, SEQ, IS_FIXED) VALUES ('354570112157437952', '7', '314575736782065664', '空值率', null, null, null, 'default', null, 'zh', 'ENABLED', 7, 1, null, '.60.', 0);
INSERT INTO cof_dict_entry (ID, CODE, DICT_TYPE_ID, NAME, DESCRIPTION, CREATE_TIME, UPDATE_TIME, TENANT_ID, PARENT_ID, LOCALE, STATUS, SORT_NO, IS_LEAF, TREE_LEVEL, SEQ, IS_FIXED) VALUES ('48abe20e-cf21-4038-8fb4-fe0fc3c8d1d3', 'HiveTable', '42497a16-8bb6-4c06-8142-880efb4ee397', 'Hive检核规则', null, null, null, 'default', null, 'zh', 'ENABLED', 1, 1, 1, '.100.', 0);
INSERT INTO cof_dict_entry (ID, CODE, DICT_TYPE_ID, NAME, DESCRIPTION, CREATE_TIME, UPDATE_TIME, TENANT_ID, PARENT_ID, LOCALE, STATUS, SORT_NO, IS_LEAF, TREE_LEVEL, SEQ, IS_FIXED) VALUES ('8ba203f7-749d-4e98-95c9-c0d577db83c6', 'table', '42497a16-8bb6-4c06-8142-880efb4ee397', '表检核规则', null, null, null, 'default', null, 'zh', 'ENABLED', 0, 1, 1, '.99.', 0);
INSERT INTO cof_dict_entry (ID, CODE, DICT_TYPE_ID, NAME, DESCRIPTION, CREATE_TIME, UPDATE_TIME, TENANT_ID, PARENT_ID, LOCALE, STATUS, SORT_NO, IS_LEAF, TREE_LEVEL, SEQ, IS_FIXED) VALUES ('9edfcb14-5c33-4b3b-9b52-a71551dbf22a', 'HBaseTable', '42497a16-8bb6-4c06-8142-880efb4ee397', 'HBase检核规则', null, null, null, 'default', null, 'zh', 'ENABLED', 2, 1, 1, '.101.', 0);
INSERT INTO cof_dict_entry (ID, CODE, DICT_TYPE_ID, NAME, DESCRIPTION, CREATE_TIME, UPDATE_TIME, TENANT_ID, PARENT_ID, LOCALE, STATUS, SORT_NO, IS_LEAF, TREE_LEVEL, SEQ, IS_FIXED) VALUES ('429501736977174528', '1', '429501651677614080', '新建', null, null, null, 'default', null, 'zh', 'ENABLED', 1, 1, null, '.60.', 0);
INSERT INTO cof_dict_entry (ID, CODE, DICT_TYPE_ID, NAME, DESCRIPTION, CREATE_TIME, UPDATE_TIME, TENANT_ID, PARENT_ID, LOCALE, STATUS, SORT_NO, IS_LEAF, TREE_LEVEL, SEQ, IS_FIXED) VALUES ('429501802991325184', '2', '429501651677614080', '启用', null, null, null, 'default', null, 'zh', 'ENABLED', 2, 1, null, '.60.', 0);
INSERT INTO cof_dict_entry (ID, CODE, DICT_TYPE_ID, NAME, DESCRIPTION, CREATE_TIME, UPDATE_TIME, TENANT_ID, PARENT_ID, LOCALE, STATUS, SORT_NO, IS_LEAF, TREE_LEVEL, SEQ, IS_FIXED) VALUES ('429501838730989568', '3', '429501651677614080', '停用', null, null, null, 'default', null, 'zh', 'ENABLED', 3, 1, null, '.60.', 0);
INSERT INTO cof_dict_entry (ID, CODE, DICT_TYPE_ID, NAME, DESCRIPTION, CREATE_TIME, UPDATE_TIME, TENANT_ID, PARENT_ID, LOCALE, STATUS, SORT_NO, IS_LEAF, TREE_LEVEL, SEQ, IS_FIXED) VALUES ('306300301090623488', '1', '306247813742333952', '普通值', null, null, null, 'default', null, 'zh', 'ENABLED', 1, 1, null, '.60.', 0);
INSERT INTO cof_dict_entry (ID, CODE, DICT_TYPE_ID, NAME, DESCRIPTION, CREATE_TIME, UPDATE_TIME, TENANT_ID, PARENT_ID, LOCALE, STATUS, SORT_NO, IS_LEAF, TREE_LEVEL, SEQ, IS_FIXED) VALUES ('306300389359751168', '2', '306247813742333952', '特殊值', null, null, null, 'default', null, 'zh', 'ENABLED', 2, 1, null, '.60.', 0);
INSERT INTO cof_dict_entry (ID, CODE, DICT_TYPE_ID, NAME, DESCRIPTION, CREATE_TIME, UPDATE_TIME, TENANT_ID, PARENT_ID, LOCALE, STATUS, SORT_NO, IS_LEAF, TREE_LEVEL, SEQ, IS_FIXED) VALUES ('306300420691202048', '3', '306247813742333952', '码表值', null, null, null, 'default', null, 'zh', 'ENABLED', 3, 1, null, '.60.', 0);
INSERT INTO cof_dict_entry (ID, CODE, DICT_TYPE_ID, NAME, DESCRIPTION, CREATE_TIME, UPDATE_TIME, TENANT_ID, PARENT_ID, LOCALE, STATUS, SORT_NO, IS_LEAF, TREE_LEVEL, SEQ, IS_FIXED) VALUES ('306242501815701504', '==', '306242162043523072', '等于', null, null, null, 'default', null, 'zh', 'ENABLED', 1, 1, null, '.60.', 0);
INSERT INTO cof_dict_entry (ID, CODE, DICT_TYPE_ID, NAME, DESCRIPTION, CREATE_TIME, UPDATE_TIME, TENANT_ID, PARENT_ID, LOCALE, STATUS, SORT_NO, IS_LEAF, TREE_LEVEL, SEQ, IS_FIXED) VALUES ('306242567506890752', '!=', '306242162043523072', '不等于', null, null, null, 'default', null, 'zh', 'ENABLED', 2, 1, null, '.60.', 0);
INSERT INTO cof_dict_entry (ID, CODE, DICT_TYPE_ID, NAME, DESCRIPTION, CREATE_TIME, UPDATE_TIME, TENANT_ID, PARENT_ID, LOCALE, STATUS, SORT_NO, IS_LEAF, TREE_LEVEL, SEQ, IS_FIXED) VALUES ('306242604093804544', '<=', '306242162043523072', '小于等于', null, null, null, 'default', null, 'zh', 'ENABLED', 3, 1, null, '.60.', 0);
INSERT INTO cof_dict_entry (ID, CODE, DICT_TYPE_ID, NAME, DESCRIPTION, CREATE_TIME, UPDATE_TIME, TENANT_ID, PARENT_ID, LOCALE, STATUS, SORT_NO, IS_LEAF, TREE_LEVEL, SEQ, IS_FIXED) VALUES ('306242638248022016', '<', '306242162043523072', '小于', null, null, null, 'default', null, 'zh', 'ENABLED', 4, 1, null, '.60.', 0);
INSERT INTO cof_dict_entry (ID, CODE, DICT_TYPE_ID, NAME, DESCRIPTION, CREATE_TIME, UPDATE_TIME, TENANT_ID, PARENT_ID, LOCALE, STATUS, SORT_NO, IS_LEAF, TREE_LEVEL, SEQ, IS_FIXED) VALUES ('306242684507000832', '>=', '306242162043523072', '大于等于', null, null, null, 'default', null, 'zh', 'ENABLED', 5, 1, null, '.60.', 0);
INSERT INTO cof_dict_entry (ID, CODE, DICT_TYPE_ID, NAME, DESCRIPTION, CREATE_TIME, UPDATE_TIME, TENANT_ID, PARENT_ID, LOCALE, STATUS, SORT_NO, IS_LEAF, TREE_LEVEL, SEQ, IS_FIXED) VALUES ('306242718308896768', '>', '306242162043523072', '大于', null, null, null, 'default', null, 'zh', 'ENABLED', 6, 1, null, '.60.', 0);
INSERT INTO cof_dict_entry (ID, CODE, DICT_TYPE_ID, NAME, DESCRIPTION, CREATE_TIME, UPDATE_TIME, TENANT_ID, PARENT_ID, LOCALE, STATUS, SORT_NO, IS_LEAF, TREE_LEVEL, SEQ, IS_FIXED) VALUES ('306301168330084352', 'matches', '306242162043523072', '匹配正则', null, null, null, 'default', null, 'zh', 'ENABLED', 7, 1, null, '.60.', 0);
INSERT INTO cof_dict_entry (ID, CODE, DICT_TYPE_ID, NAME, DESCRIPTION, CREATE_TIME, UPDATE_TIME, TENANT_ID, PARENT_ID, LOCALE, STATUS, SORT_NO, IS_LEAF, TREE_LEVEL, SEQ, IS_FIXED) VALUES ('306301814399700992', 'contains', '306242162043523072', '包含码表', null, null, null, 'default', null, 'zh', 'ENABLED', 8, 1, null, '.60.', 0);
INSERT INTO cof_dict_entry (ID, CODE, DICT_TYPE_ID, NAME, DESCRIPTION, CREATE_TIME, UPDATE_TIME, TENANT_ID, PARENT_ID, LOCALE, STATUS, SORT_NO, IS_LEAF, TREE_LEVEL, SEQ, IS_FIXED) VALUES ('423664174639353856', '1', '423644463499317248', '数据抖动', null, null, null, 'default', null, 'zh', 'ENABLED', 1, 1, null, '.60.', 0);
INSERT INTO cof_dict_entry (ID, CODE, DICT_TYPE_ID, NAME, DESCRIPTION, CREATE_TIME, UPDATE_TIME, TENANT_ID, PARENT_ID, LOCALE, STATUS, SORT_NO, IS_LEAF, TREE_LEVEL, SEQ, IS_FIXED) VALUES ('423664223591075840', '2', '423644463499317248', '数据偏移', null, null, null, 'default', null, 'zh', 'ENABLED', 2, 1, null, '.60.', 0);
INSERT INTO cof_dict_entry (ID, CODE, DICT_TYPE_ID, NAME, DESCRIPTION, CREATE_TIME, UPDATE_TIME, TENANT_ID, PARENT_ID, LOCALE, STATUS, SORT_NO, IS_LEAF, TREE_LEVEL, SEQ, IS_FIXED) VALUES ('423664297431797760', '3', '423644463499317248', '数据堆积', null, null, null, 'default', null, 'zh', 'ENABLED', 3, 1, null, '.60.', 0);
INSERT INTO cof_dict_entry (ID, CODE, DICT_TYPE_ID, NAME, DESCRIPTION, CREATE_TIME, UPDATE_TIME, TENANT_ID, PARENT_ID, LOCALE, STATUS, SORT_NO, IS_LEAF, TREE_LEVEL, SEQ, IS_FIXED) VALUES ('423664380911030272', '4', '423644463499317248', '数据对照', null, null, null, 'default', null, 'zh', 'ENABLED', 4, 1, null, '.60.', 0);
INSERT INTO cof_dict_entry (ID, CODE, DICT_TYPE_ID, NAME, DESCRIPTION, CREATE_TIME, UPDATE_TIME, TENANT_ID, PARENT_ID, LOCALE, STATUS, SORT_NO, IS_LEAF, TREE_LEVEL, SEQ, IS_FIXED) VALUES ('3611f8bc-3d6e-4961-98f3-12ea35119f8c', 'YES_OR_NO', '25fcceeb-12bf-4b11-ad5f-6af625fb2028', 'NO', null, null, null, 'default', null, 'zh', 'ENABLED', 0, 1, 1, '.118.', 0);
INSERT INTO cof_dict_entry (ID, CODE, DICT_TYPE_ID, NAME, DESCRIPTION, CREATE_TIME, UPDATE_TIME, TENANT_ID, PARENT_ID, LOCALE, STATUS, SORT_NO, IS_LEAF, TREE_LEVEL, SEQ, IS_FIXED) VALUES ('08860cc4-003d-4b73-877b-236b5aa60f2b', '7', '430613552059285504', '每月', '', null, null, 'default', null, 'zh', 'ENABLED', 6, 1, 1, '.97.', 0);
INSERT INTO cof_dict_entry (ID, CODE, DICT_TYPE_ID, NAME, DESCRIPTION, CREATE_TIME, UPDATE_TIME, TENANT_ID, PARENT_ID, LOCALE, STATUS, SORT_NO, IS_LEAF, TREE_LEVEL, SEQ, IS_FIXED) VALUES ('3c915bf7-8965-439f-a902-982fbb7d2e19', '8', '430613552059285504', '每季', '', null, null, 'default', null, 'zh', 'ENABLED', 7, 1, 1, '.98.', 0);
INSERT INTO cof_dict_entry (ID, CODE, DICT_TYPE_ID, NAME, DESCRIPTION, CREATE_TIME, UPDATE_TIME, TENANT_ID, PARENT_ID, LOCALE, STATUS, SORT_NO, IS_LEAF, TREE_LEVEL, SEQ, IS_FIXED) VALUES ('44f2b6ef-866d-4d8c-a8d7-d097804f99a7', '1', '430613552059285504', '一次', null, null, null, 'default', null, 'zh', 'ENABLED', 0, 1, 1, '.91.', 0);
INSERT INTO cof_dict_entry (ID, CODE, DICT_TYPE_ID, NAME, DESCRIPTION, CREATE_TIME, UPDATE_TIME, TENANT_ID, PARENT_ID, LOCALE, STATUS, SORT_NO, IS_LEAF, TREE_LEVEL, SEQ, IS_FIXED) VALUES ('7af83165-d7ec-46c4-8eaa-2c4d9a88da3e', '6', '430613552059285504', '每旬', '', null, null, 'default', null, 'zh', 'ENABLED', 5, 1, 1, '.96.', 0);
INSERT INTO cof_dict_entry (ID, CODE, DICT_TYPE_ID, NAME, DESCRIPTION, CREATE_TIME, UPDATE_TIME, TENANT_ID, PARENT_ID, LOCALE, STATUS, SORT_NO, IS_LEAF, TREE_LEVEL, SEQ, IS_FIXED) VALUES ('97d5ffb6-c19e-4192-ad38-3c1844c4ea77', '3', '430613552059285504', '每小时', '', null, null, 'default', null, 'zh', 'ENABLED', 2, 1, 1, '.93.', 0);
INSERT INTO cof_dict_entry (ID, CODE, DICT_TYPE_ID, NAME, DESCRIPTION, CREATE_TIME, UPDATE_TIME, TENANT_ID, PARENT_ID, LOCALE, STATUS, SORT_NO, IS_LEAF, TREE_LEVEL, SEQ, IS_FIXED) VALUES ('a26a270d-fb01-448e-a42e-347ebf265236', '2', '430613552059285504', '每分', '', null, null, 'default', null, 'zh', 'ENABLED', 1, 1, 1, '.92.', 0);
INSERT INTO cof_dict_entry (ID, CODE, DICT_TYPE_ID, NAME, DESCRIPTION, CREATE_TIME, UPDATE_TIME, TENANT_ID, PARENT_ID, LOCALE, STATUS, SORT_NO, IS_LEAF, TREE_LEVEL, SEQ, IS_FIXED) VALUES ('adf34d8a-6a3d-4758-8cc4-b833abbd9f5b', '5', '430613552059285504', '每周', '', null, null, 'default', null, 'zh', 'ENABLED', 4, 1, 1, '.95.', 0);
INSERT INTO cof_dict_entry (ID, CODE, DICT_TYPE_ID, NAME, DESCRIPTION, CREATE_TIME, UPDATE_TIME, TENANT_ID, PARENT_ID, LOCALE, STATUS, SORT_NO, IS_LEAF, TREE_LEVEL, SEQ, IS_FIXED) VALUES ('f540e60f-7708-4460-8581-44c4abe41cb2', '4', '430613552059285504', '每天', '', null, null, 'default', null, 'zh', 'ENABLED', 3, 1, 1, '.94.', 0);
INSERT INTO cof_dict_entry (ID, CODE, DICT_TYPE_ID, NAME, DESCRIPTION, CREATE_TIME, UPDATE_TIME, TENANT_ID, PARENT_ID, LOCALE, STATUS, SORT_NO, IS_LEAF, TREE_LEVEL, SEQ, IS_FIXED) VALUES ('435019761520640000', 'GeneralCheckHandler', '435019220119879680', '通用检核任务', null, null, null, 'default', null, 'zh', 'ENABLED', 1, 1, null, '.60.', 0);
INSERT INTO cof_dict_entry (ID, CODE, DICT_TYPE_ID, NAME, DESCRIPTION, CREATE_TIME, UPDATE_TIME, TENANT_ID, PARENT_ID, LOCALE, STATUS, SORT_NO, IS_LEAF, TREE_LEVEL, SEQ, IS_FIXED) VALUES ('435020625639538688', 'tableCheckJobHandler', '435019220119879680', '表检核任务', null, null, null, 'default', null, 'zh', 'ENABLED', 2, 1, null, '.60.', 0);
INSERT INTO cof_dict_entry (ID, CODE, DICT_TYPE_ID, NAME, DESCRIPTION, CREATE_TIME, UPDATE_TIME, TENANT_ID, PARENT_ID, LOCALE, STATUS, SORT_NO, IS_LEAF, TREE_LEVEL, SEQ, IS_FIXED) VALUES ('435020729301762048', 'CheckHbaseTableJobHandler', '435019220119879680', 'hbase检核任务', null, null, null, 'default', null, 'zh', 'ENABLED', 3, 1, null, '.60.', 0);
INSERT INTO cof_dict_entry (ID, CODE, DICT_TYPE_ID, NAME, DESCRIPTION, CREATE_TIME, UPDATE_TIME, TENANT_ID, PARENT_ID, LOCALE, STATUS, SORT_NO, IS_LEAF, TREE_LEVEL, SEQ, IS_FIXED) VALUES ('438567657444638720', 'CheckHiveTableJobHandler', '435019220119879680', 'Hive检核任务', null, null, null, 'default', null, 'zh', 'ENABLED', 4, 1, null, '.60.', 0);
INSERT INTO cof_dict_entry (ID, CODE, DICT_TYPE_ID, NAME, DESCRIPTION, CREATE_TIME, UPDATE_TIME, TENANT_ID, PARENT_ID, LOCALE, STATUS, SORT_NO, IS_LEAF, TREE_LEVEL, SEQ, IS_FIXED) VALUES ('04adfe0b-c224-4f20-ac40-6f7a729757b3', '200', '464219649722449921', '完成', '', null, null, 'default', null, 'zh', 'ENABLED', 2, 1, 1, '.112.', 0);
INSERT INTO cof_dict_entry (ID, CODE, DICT_TYPE_ID, NAME, DESCRIPTION, CREATE_TIME, UPDATE_TIME, TENANT_ID, PARENT_ID, LOCALE, STATUS, SORT_NO, IS_LEAF, TREE_LEVEL, SEQ, IS_FIXED) VALUES ('13053f36-ab55-4c18-baeb-06843283f610', '-100', '464219649722449921', '运行', null, null, null, 'default', null, 'zh', 'ENABLED', 1, 1, 1, '.111.', 0);
INSERT INTO cof_dict_entry (ID, CODE, DICT_TYPE_ID, NAME, DESCRIPTION, CREATE_TIME, UPDATE_TIME, TENANT_ID, PARENT_ID, LOCALE, STATUS, SORT_NO, IS_LEAF, TREE_LEVEL, SEQ, IS_FIXED) VALUES ('d3e2bbab-acc5-43bd-943e-b4b069119c3b', '500', '464219649722449921', '失败', '', null, null, 'default', null, 'zh', 'ENABLED', 3, 1, 1, '.113.', 0);
INSERT INTO cof_dict_entry (ID, CODE, DICT_TYPE_ID, NAME, DESCRIPTION, CREATE_TIME, UPDATE_TIME, TENANT_ID, PARENT_ID, LOCALE, STATUS, SORT_NO, IS_LEAF, TREE_LEVEL, SEQ, IS_FIXED) VALUES ('437418566052380672', '1', '437418455066902528', '数值', null, null, null, 'default', null, 'zh', 'ENABLED', 1, 1, null, '.60.', 0);
INSERT INTO cof_dict_entry (ID, CODE, DICT_TYPE_ID, NAME, DESCRIPTION, CREATE_TIME, UPDATE_TIME, TENANT_ID, PARENT_ID, LOCALE, STATUS, SORT_NO, IS_LEAF, TREE_LEVEL, SEQ, IS_FIXED) VALUES ('437418643554729984', '2', '437418455066902528', '百分比', null, null, null, 'default', null, 'zh', 'ENABLED', 2, 1, null, '.60.', 0);
INSERT INTO cof_dict_entry (ID, CODE, DICT_TYPE_ID, NAME, DESCRIPTION, CREATE_TIME, UPDATE_TIME, TENANT_ID, PARENT_ID, LOCALE, STATUS, SORT_NO, IS_LEAF, TREE_LEVEL, SEQ, IS_FIXED) VALUES ('437418915186245632', 'lt', '437418825000321024', '<', null, null, null, 'default', null, 'zh', 'ENABLED', 1, 1, null, '.60.', 0);
INSERT INTO cof_dict_entry (ID, CODE, DICT_TYPE_ID, NAME, DESCRIPTION, CREATE_TIME, UPDATE_TIME, TENANT_ID, PARENT_ID, LOCALE, STATUS, SORT_NO, IS_LEAF, TREE_LEVEL, SEQ, IS_FIXED) VALUES ('437418950540034048', 'eq', '437418825000321024', '=', null, null, null, 'default', null, 'zh', 'ENABLED', 2, 1, null, '.60.', 0);
INSERT INTO cof_dict_entry (ID, CODE, DICT_TYPE_ID, NAME, DESCRIPTION, CREATE_TIME, UPDATE_TIME, TENANT_ID, PARENT_ID, LOCALE, STATUS, SORT_NO, IS_LEAF, TREE_LEVEL, SEQ, IS_FIXED) VALUES ('437418984052523008', 'gt', '437418825000321024', '>', null, null, null, 'default', null, 'zh', 'ENABLED', 3, 1, null, '.60.', 0);
INSERT INTO cof_dict_entry (ID, CODE, DICT_TYPE_ID, NAME, DESCRIPTION, CREATE_TIME, UPDATE_TIME, TENANT_ID, PARENT_ID, LOCALE, STATUS, SORT_NO, IS_LEAF, TREE_LEVEL, SEQ, IS_FIXED) VALUES ('437419157604433920', '1', '437419085214941184', '一般', null, null, null, 'default', null, 'zh', 'ENABLED', 1, 1, null, '.60.', 0);
INSERT INTO cof_dict_entry (ID, CODE, DICT_TYPE_ID, NAME, DESCRIPTION, CREATE_TIME, UPDATE_TIME, TENANT_ID, PARENT_ID, LOCALE, STATUS, SORT_NO, IS_LEAF, TREE_LEVEL, SEQ, IS_FIXED) VALUES ('437419190605217792', '2', '437419085214941184', '中等', null, null, null, 'default', null, 'zh', 'ENABLED', 2, 1, null, '.60.', 0);
INSERT INTO cof_dict_entry (ID, CODE, DICT_TYPE_ID, NAME, DESCRIPTION, CREATE_TIME, UPDATE_TIME, TENANT_ID, PARENT_ID, LOCALE, STATUS, SORT_NO, IS_LEAF, TREE_LEVEL, SEQ, IS_FIXED) VALUES ('437419238596444160', '3', '437419085214941184', '严重', null, null, null, 'default', null, 'zh', 'ENABLED', 3, 1, null, '.60.', 0);
INSERT INTO cof_dict_entry (ID, CODE, DICT_TYPE_ID, NAME, DESCRIPTION, CREATE_TIME, UPDATE_TIME, TENANT_ID, PARENT_ID, LOCALE, STATUS, SORT_NO, IS_LEAF, TREE_LEVEL, SEQ, IS_FIXED) VALUES ('438970836551995392', '1', '438970573996953600', '新增', null, null, null, 'default', null, 'zh', 'ENABLED', 1, 1, null, '.60.', 0);
INSERT INTO cof_dict_entry (ID, CODE, DICT_TYPE_ID, NAME, DESCRIPTION, CREATE_TIME, UPDATE_TIME, TENANT_ID, PARENT_ID, LOCALE, STATUS, SORT_NO, IS_LEAF, TREE_LEVEL, SEQ, IS_FIXED) VALUES ('438970880189534208', '2', '438970573996953600', '生效', null, null, null, 'default', null, 'zh', 'ENABLED', 2, 1, null, '.60.', 0);
INSERT INTO cof_dict_entry (ID, CODE, DICT_TYPE_ID, NAME, DESCRIPTION, CREATE_TIME, UPDATE_TIME, TENANT_ID, PARENT_ID, LOCALE, STATUS, SORT_NO, IS_LEAF, TREE_LEVEL, SEQ, IS_FIXED) VALUES ('438970914096287744', '3', '438970573996953600', '挂起', null, null, null, 'default', null, 'zh', 'ENABLED', 3, 1, null, '.60.', 0);
INSERT INTO cof_dict_entry (ID, CODE, DICT_TYPE_ID, NAME, DESCRIPTION, CREATE_TIME, UPDATE_TIME, TENANT_ID, PARENT_ID, LOCALE, STATUS, SORT_NO, IS_LEAF, TREE_LEVEL, SEQ, IS_FIXED) VALUES ('306738663343656960', '0', '306738524021460992', '质量检核 ', null, null, null, 'default', null, 'zh', 'ENABLED', 1, 1, null, '.60.', 0);
INSERT INTO cof_dict_entry (ID, CODE, DICT_TYPE_ID, NAME, DESCRIPTION, CREATE_TIME, UPDATE_TIME, TENANT_ID, PARENT_ID, LOCALE, STATUS, SORT_NO, IS_LEAF, TREE_LEVEL, SEQ, IS_FIXED) VALUES ('306738779987251200', '1', '306738524021460992', '隐患', null, null, null, 'default', null, 'zh', 'ENABLED', 2, 1, null, '.60.', 0);
INSERT INTO cof_dict_entry (ID, CODE, DICT_TYPE_ID, NAME, DESCRIPTION, CREATE_TIME, UPDATE_TIME, TENANT_ID, PARENT_ID, LOCALE, STATUS, SORT_NO, IS_LEAF, TREE_LEVEL, SEQ, IS_FIXED) VALUES ('306738841576411136', '3', '306738524021460992', '用户反馈', null, null, null, 'default', null, 'zh', 'ENABLED', 3, 1, null, '.60.', 0);
INSERT INTO cof_dict_entry (ID, CODE, DICT_TYPE_ID, NAME, DESCRIPTION, CREATE_TIME, UPDATE_TIME, TENANT_ID, PARENT_ID, LOCALE, STATUS, SORT_NO, IS_LEAF, TREE_LEVEL, SEQ, IS_FIXED) VALUES ('306738880365334528', '4', '306738524021460992', '其他途径', null, null, null, 'default', null, 'zh', 'ENABLED', 4, 1, null, '.60.', 0);
INSERT INTO cof_dict_entry (ID, CODE, DICT_TYPE_ID, NAME, DESCRIPTION, CREATE_TIME, UPDATE_TIME, TENANT_ID, PARENT_ID, LOCALE, STATUS, SORT_NO, IS_LEAF, TREE_LEVEL, SEQ, IS_FIXED) VALUES ('478779614147543040', 'table', '478779397398495232', '关系型', null, null, null, 'default', null, 'zh', 'ENABLED', 2, 1, null, '.60.', 0);
INSERT INTO cof_dict_entry (ID, CODE, DICT_TYPE_ID, NAME, DESCRIPTION, CREATE_TIME, UPDATE_TIME, TENANT_ID, PARENT_ID, LOCALE, STATUS, SORT_NO, IS_LEAF, TREE_LEVEL, SEQ, IS_FIXED) VALUES ('478779893454635008', 'MrsHiveTable', '478779397398495232', 'MRS Hive', null, null, null, 'default', null, 'zh', 'ENABLED', 8, 1, null, '.60.', 0);
INSERT INTO cof_dict_entry (ID, CODE, DICT_TYPE_ID, NAME, DESCRIPTION, CREATE_TIME, UPDATE_TIME, TENANT_ID, PARENT_ID, LOCALE, STATUS, SORT_NO, IS_LEAF, TREE_LEVEL, SEQ, IS_FIXED) VALUES ('478779946848124928', 'MrsHBaseTable', '478779397398495232', 'MRS HBase', null, null, null, 'default', null, 'zh', 'ENABLED', 9, 1, null, '.60.', 0);
INSERT INTO cof_dict_entry (ID, CODE, DICT_TYPE_ID, NAME, DESCRIPTION, CREATE_TIME, UPDATE_TIME, TENANT_ID, PARENT_ID, LOCALE, STATUS, SORT_NO, IS_LEAF, TREE_LEVEL, SEQ, IS_FIXED) VALUES ('478780012283461632', 'sftp', '478779397398495232', '文件系统', null, null, null, 'default', null, 'zh', 'ENABLED', 3, 1, null, '.60.', 0);
INSERT INTO cof_dict_entry (ID, CODE, DICT_TYPE_ID, NAME, DESCRIPTION, CREATE_TIME, UPDATE_TIME, TENANT_ID, PARENT_ID, LOCALE, STATUS, SORT_NO, IS_LEAF, TREE_LEVEL, SEQ, IS_FIXED) VALUES ('478781045504114688', 'other', '478779397398495232', '其他', null, null, null, 'default', null, 'zh', 'ENABLED', 1, 1, null, '.60.', 0);
INSERT INTO cof_dict_entry (ID, CODE, DICT_TYPE_ID, NAME, DESCRIPTION, CREATE_TIME, UPDATE_TIME, TENANT_ID, PARENT_ID, LOCALE, STATUS, SORT_NO, IS_LEAF, TREE_LEVEL, SEQ, IS_FIXED) VALUES ('516505563761606656', 'HIVE', '478779397398495232', 'Hive', null, null, null, 'default', null, 'zh', 'ENABLED', 4, 1, null, '.60.', 0);
INSERT INTO cof_dict_entry (ID, CODE, DICT_TYPE_ID, NAME, DESCRIPTION, CREATE_TIME, UPDATE_TIME, TENANT_ID, PARENT_ID, LOCALE, STATUS, SORT_NO, IS_LEAF, TREE_LEVEL, SEQ, IS_FIXED) VALUES ('516505627292729344', 'HBASE', '478779397398495232', 'HBase', null, null, null, 'default', null, 'zh', 'ENABLED', 5, 1, null, '.60.', 0);
INSERT INTO cof_dict_entry (ID, CODE, DICT_TYPE_ID, NAME, DESCRIPTION, CREATE_TIME, UPDATE_TIME, TENANT_ID, PARENT_ID, LOCALE, STATUS, SORT_NO, IS_LEAF, TREE_LEVEL, SEQ, IS_FIXED) VALUES ('516505740207587328', 'KERBEROS_HIVE', '478779397398495232', 'Kerberos Hive', null, null, null, 'default', null, 'zh', 'ENABLED', 6, 1, null, '.60.', 0);
INSERT INTO cof_dict_entry (ID, CODE, DICT_TYPE_ID, NAME, DESCRIPTION, CREATE_TIME, UPDATE_TIME, TENANT_ID, PARENT_ID, LOCALE, STATUS, SORT_NO, IS_LEAF, TREE_LEVEL, SEQ, IS_FIXED) VALUES ('516505838819868672', 'KERBEROS_HBASE', '478779397398495232', 'Kerberos HBase', null, null, null, 'default', null, 'zh', 'ENABLED', 7, 1, null, '.60.', 0);
INSERT INTO cof_dict_entry (ID, CODE, DICT_TYPE_ID, NAME, DESCRIPTION, CREATE_TIME, UPDATE_TIME, TENANT_ID, PARENT_ID, LOCALE, STATUS, SORT_NO, IS_LEAF, TREE_LEVEL, SEQ, IS_FIXED) VALUES ('341743210044461056', '1', '341743150732808192', '自建', null, null, null, 'default', null, 'zh', 'ENABLED', 5, 1, null, '.60.', 0);
INSERT INTO cof_dict_entry (ID, CODE, DICT_TYPE_ID, NAME, DESCRIPTION, CREATE_TIME, UPDATE_TIME, TENANT_ID, PARENT_ID, LOCALE, STATUS, SORT_NO, IS_LEAF, TREE_LEVEL, SEQ, IS_FIXED) VALUES ('341743210044461057', '3', '341743150732808192', '同步', null, null, null, 'default', null, 'zh', 'ENABLED', 5, 1, null, '.60.', 0);
INSERT INTO cof_dict_entry (ID, CODE, DICT_TYPE_ID, NAME, DESCRIPTION, CREATE_TIME, UPDATE_TIME, TENANT_ID, PARENT_ID, LOCALE, STATUS, SORT_NO, IS_LEAF, TREE_LEVEL, SEQ, IS_FIXED) VALUES ('341743258182488064', '2', '341743150732808192', '元数据导入', null, null, null, 'default', null, 'zh', 'ENABLED', 5, 1, null, '.60.', 0);
INSERT INTO cof_dict_entry (ID, CODE, DICT_TYPE_ID, NAME, DESCRIPTION, CREATE_TIME, UPDATE_TIME, TENANT_ID, PARENT_ID, LOCALE, STATUS, SORT_NO, IS_LEAF, TREE_LEVEL, SEQ, IS_FIXED) VALUES ('328433537769934848', '1', '328430455870853120', '字符串', null, null, null, 'default', null, 'zh', 'ENABLED', 5, 1, null, '.60.', 0);
INSERT INTO cof_dict_entry (ID, CODE, DICT_TYPE_ID, NAME, DESCRIPTION, CREATE_TIME, UPDATE_TIME, TENANT_ID, PARENT_ID, LOCALE, STATUS, SORT_NO, IS_LEAF, TREE_LEVEL, SEQ, IS_FIXED) VALUES ('328433835393552384', '2', '328430455870853120', '整数', null, null, null, 'default', null, 'zh', 'ENABLED', 5, 1, null, '.60.', 0);
INSERT INTO cof_dict_entry (ID, CODE, DICT_TYPE_ID, NAME, DESCRIPTION, CREATE_TIME, UPDATE_TIME, TENANT_ID, PARENT_ID, LOCALE, STATUS, SORT_NO, IS_LEAF, TREE_LEVEL, SEQ, IS_FIXED) VALUES ('341475184619425792', 'com.mysql.cj.jdbc.Driver', '341474990574145536', 'com.mysql.cj.jdbc.Driver', null, null, null, 'default', null, 'zh', 'ENABLED', 1, 1, null, '.60.', 0);
INSERT INTO cof_dict_entry (ID, CODE, DICT_TYPE_ID, NAME, DESCRIPTION, CREATE_TIME, UPDATE_TIME, TENANT_ID, PARENT_ID, LOCALE, STATUS, SORT_NO, IS_LEAF, TREE_LEVEL, SEQ, IS_FIXED) VALUES ('341475101521874944', 'oracle.jdbc.OracleDriver', '341474990574145536', 'oracle.jdbc.OracleDriver', null, null, null, 'default', null, 'zh', 'ENABLED', 2, 1, null, '.60.', 0);
INSERT INTO cof_dict_entry (ID, CODE, DICT_TYPE_ID, NAME, DESCRIPTION, CREATE_TIME, UPDATE_TIME, TENANT_ID, PARENT_ID, LOCALE, STATUS, SORT_NO, IS_LEAF, TREE_LEVEL, SEQ, IS_FIXED) VALUES ('341475184619425793', 'dm.jdbc.driver.DmDriver', '341474990574145536', 'dm.jdbc.driver.DmDriver', null, null, null, 'default', null, 'zh', 'ENABLED', 3, 1, null, '.60.', 0);
INSERT INTO cof_dict_entry (ID, CODE, DICT_TYPE_ID, NAME, DESCRIPTION, CREATE_TIME, UPDATE_TIME, TENANT_ID, PARENT_ID, LOCALE, STATUS, SORT_NO, IS_LEAF, TREE_LEVEL, SEQ, IS_FIXED) VALUES ('341475184619425794', 'org.opengauss.Driver', '341474990574145536', 'org.opengauss.Driver', null, null, null, 'default', null, 'zh', 'ENABLED', 4, 1, null, '.60.', 0);
INSERT INTO cof_dict_entry (ID, CODE, DICT_TYPE_ID, NAME, DESCRIPTION, CREATE_TIME, UPDATE_TIME, TENANT_ID, PARENT_ID, LOCALE, STATUS, SORT_NO, IS_LEAF, TREE_LEVEL, SEQ, IS_FIXED) VALUES ('341475184619425795', 'org.postgresql.Driver', '341474990574145536', 'org.postgresql.Driver', null, null, null, 'default', null, 'zh', 'ENABLED', 5, 1, null, '.60.', 0);
INSERT INTO cof_dict_entry (ID, CODE, DICT_TYPE_ID, NAME, DESCRIPTION, CREATE_TIME, UPDATE_TIME, TENANT_ID, PARENT_ID, LOCALE, STATUS, SORT_NO, IS_LEAF, TREE_LEVEL, SEQ, IS_FIXED) VALUES ('428093768050778112', 'org.apache.hive.jdbc.HiveDriver', '341474990574145536', 'org.apache.hive.jdbc.HiveDriver', null, null, null, 'default', null, 'zh', 'ENABLED', 6, 1, null, '.60.', 0);
INSERT INTO cof_dict_entry (ID, CODE, DICT_TYPE_ID, NAME, DESCRIPTION, CREATE_TIME, UPDATE_TIME, TENANT_ID, PARENT_ID, LOCALE, STATUS, SORT_NO, IS_LEAF, TREE_LEVEL, SEQ, IS_FIXED) VALUES ('341475184619425796', 'com.kingbase8.Driver', '341474990574145536', 'com.kingbase8.Driver', null, null, null, 'default', null, 'zh', 'ENABLED', 7, 1, null, '.60.', 0);
INSERT INTO cof_dict_entry (ID, CODE, DICT_TYPE_ID, NAME, DESCRIPTION, CREATE_TIME, UPDATE_TIME, TENANT_ID, PARENT_ID, LOCALE, STATUS, SORT_NO, IS_LEAF, TREE_LEVEL, SEQ, IS_FIXED) VALUES ('341475184619425797', 'com.highgo.jdbc.Driver', '341474990574145536', 'com.highgo.jdbc.Driver', null, null, null, 'default', null, 'zh', 'ENABLED', 8, 1, null, '.60.', 0);
INSERT INTO cof_dict_entry (ID, CODE, DICT_TYPE_ID, NAME, DESCRIPTION, CREATE_TIME, UPDATE_TIME, TENANT_ID, PARENT_ID, LOCALE, STATUS, SORT_NO, IS_LEAF, TREE_LEVEL, SEQ, IS_FIXED) VALUES ('341475184619425798', 'com.microsoft.sqlserver.jdbc.SQLServerDriver', '341474990574145536', 'com.microsoft.sqlserver.jdbc.SQLServerDriver', null, null, null, 'default', null, 'zh', 'ENABLED', 8, 1, null, '.60.', 0);
INSERT INTO cof_dict_entry (ID, CODE, DICT_TYPE_ID, NAME, DESCRIPTION, CREATE_TIME, UPDATE_TIME, TENANT_ID, PARENT_ID, LOCALE, STATUS, SORT_NO, IS_LEAF, TREE_LEVEL, SEQ, IS_FIXED) VALUES ('486777881183551488', 'FILE_STORE_JOBID', '486772360502214656', null, null, null, null, 'default', null, 'zh', 'ENABLED', 1, 1, null, '.60.', 0);
INSERT INTO cof_dict_entry (ID, CODE, DICT_TYPE_ID, NAME, DESCRIPTION, CREATE_TIME, UPDATE_TIME, TENANT_ID, PARENT_ID, LOCALE, STATUS, SORT_NO, IS_LEAF, TREE_LEVEL, SEQ, IS_FIXED) VALUES ('486780201149562880', 'FILE_PROCESS_JOBID', '486772360502214656', null, null, null, null, 'default', null, 'zh', 'ENABLED', 2, 1, null, '.60.', 0);
INSERT INTO cof_dict_entry (ID, CODE, DICT_TYPE_ID, NAME, DESCRIPTION, CREATE_TIME, UPDATE_TIME, TENANT_ID, PARENT_ID, LOCALE, STATUS, SORT_NO, IS_LEAF, TREE_LEVEL, SEQ, IS_FIXED) VALUES ('491099272561197056', 'APACHE_HTTP_URL', '486772360502214656', 'http://<ip>:<port>/', null, null, null, 'default', null, 'zh', 'ENABLED', 3, 1, null, '.60.', 0);
INSERT INTO cof_dict_entry (ID, CODE, DICT_TYPE_ID, NAME, DESCRIPTION, CREATE_TIME, UPDATE_TIME, TENANT_ID, PARENT_ID, LOCALE, STATUS, SORT_NO, IS_LEAF, TREE_LEVEL, SEQ, IS_FIXED) VALUES ('491099441839112192', 'CDH_HTTP_URL', '486772360502214656', 'http://<ip>:<port>/', null, null, null, 'default', null, 'zh', 'ENABLED', 4, 1, null, '.60.', 0);
INSERT INTO cof_dict_entry (ID, CODE, DICT_TYPE_ID, NAME, DESCRIPTION, CREATE_TIME, UPDATE_TIME, TENANT_ID, PARENT_ID, LOCALE, STATUS, SORT_NO, IS_LEAF, TREE_LEVEL, SEQ, IS_FIXED) VALUES ('491850335119638528', 'MRS_HTTP_URL', '486772360502214656', 'http://<ip>:<port>/', null, null, null, 'default', null, 'zh', 'ENABLED', 5, 1, null, '.60.', 0);
INSERT INTO COF_DICT_ENTRY (ID, CODE, DICT_TYPE_ID, NAME, DESCRIPTION, CREATE_TIME, UPDATE_TIME, TENANT_ID, PARENT_ID, LOCALE, STATUS, SORT_NO, IS_LEAF, TREE_LEVEL, SEQ, IS_FIXED) VALUES ('307009508569911296', '0', '307009384934412288', '未反馈', NULL, NULL, NULL, 'default', NULL, 'zh', 'ENABLED', 1, 1, NULL, '.60.', 0);
INSERT INTO COF_DICT_ENTRY (ID, CODE, DICT_TYPE_ID, NAME, DESCRIPTION, CREATE_TIME, UPDATE_TIME, TENANT_ID, PARENT_ID, LOCALE, STATUS, SORT_NO, IS_LEAF, TREE_LEVEL, SEQ, IS_FIXED) VALUES ('307009548298358784', '1', '307009384934412288', '已反馈', NULL, NULL, NULL, 'default', NULL, 'zh', 'ENABLED', 2, 1, NULL, '.60.', 0);
INSERT INTO COF_DICT_ENTRY (ID, CODE, DICT_TYPE_ID, NAME, DESCRIPTION, CREATE_TIME, UPDATE_TIME, TENANT_ID, PARENT_ID, LOCALE, STATUS, SORT_NO, IS_LEAF, TREE_LEVEL, SEQ, IS_FIXED) VALUES ('307009600056070144', '9', '307009384934412288', '已关闭', NULL, NULL, NULL, 'default', NULL, 'zh', 'ENABLED', 3, 1, NULL, '.60.', 0);


INSERT INTO ck_frequency (NAME, TYPE, INTERVALNUM, CREATE_BY, CREATE_TIME, UPDATE_BY, UPDATE_TIME, EXPRESSION, DESCRIPTION) VALUES ('ONCE', '1', null, 'admin', to_timestamp('2024-01-01 00:00:00','yyyy-mm-dd hh24:mi:ss'), null, null, '', null);
INSERT INTO ck_frequency (NAME, TYPE, INTERVALNUM, CREATE_BY, CREATE_TIME, UPDATE_BY, UPDATE_TIME, EXPRESSION, DESCRIPTION) VALUES ('EVERY_MINUTE', '2', null, 'admin', to_timestamp('2024-01-01 00:00:00','yyyy-mm-dd hh24:mi:ss'), null, null, '0 00/1 * * * ? ', null);
INSERT INTO ck_frequency (NAME, TYPE, INTERVALNUM, CREATE_BY, CREATE_TIME, UPDATE_BY, UPDATE_TIME, EXPRESSION, DESCRIPTION) VALUES ('EVERY_HOUR', '3', null, 'admin', to_timestamp('2024-01-01 00:00:00','yyyy-mm-dd hh24:mi:ss'), null, null, '0 00 00/1 * * ? *', null);
INSERT INTO ck_frequency (NAME, TYPE, INTERVALNUM, CREATE_BY, CREATE_TIME, UPDATE_BY, UPDATE_TIME, EXPRESSION, DESCRIPTION) VALUES ('EVERY_DAY', '4', null, 'admin', to_timestamp('2024-01-01 00:00:00','yyyy-mm-dd hh24:mi:ss'), null, null, '0 00 00 /1 * ? *', null);
INSERT INTO ck_frequency (NAME, TYPE, INTERVALNUM, CREATE_BY, CREATE_TIME, UPDATE_BY, UPDATE_TIME, EXPRESSION, DESCRIPTION) VALUES ('EVERY_WEEK', '5', null, 'admin', to_timestamp('2024-01-01 00:00:00', 'yyyy-mm-dd hh24:mi:ss'),null, null, '0 00 00 ? * MON,TUE,WED,THU,FRI *', null);
INSERT INTO ck_frequency (NAME, TYPE, INTERVALNUM, CREATE_BY, CREATE_TIME, UPDATE_BY, UPDATE_TIME, EXPRESSION, DESCRIPTION) VALUES ('EVERY_TEN_DAYS', '6', null, 'admin', to_timestamp('2024-01-01 00:00:00','yyyy-mm-dd hh24:mi:ss'), null, null, '0 00 00 1,11,21 * ? *', null);
INSERT INTO ck_frequency (NAME, TYPE, INTERVALNUM, CREATE_BY, CREATE_TIME, UPDATE_BY, UPDATE_TIME, EXPRESSION, DESCRIPTION) VALUES ('EVERY_MONTH', '7', null, 'admin', to_timestamp('2024-01-01 00:00:00','yyyy-mm-dd hh24:mi:ss'), null, null, '0 00 00 1 1,2,3,4,5,6,7,8,9,10,11,12 ? *', null);
INSERT INTO ck_frequency (NAME, TYPE, INTERVALNUM, CREATE_BY, CREATE_TIME, UPDATE_BY, UPDATE_TIME, EXPRESSION, DESCRIPTION) VALUES ('EACH_QUARTER', '8', null, 'admin', to_timestamp('2024-01-01 00:00:00', 'yyyy-mm-dd hh24:mi:ss'),null, null, '0 00 00 1 1,4,7,10 ? *', null);

