scd_tools_go/service/db/db_init.sql

/*
 Navicat Premium Data Transfer

 Source Server         : 127.0.0.1
 Source Server Type    : MySQL
 Source Server Version : 80021
 Source Host           : localhost:3306
 Source Schema         : jujutong_scd

 Target Server Type    : MySQL
 Target Server Version : 80021
 File Encoding         : 65001

 Date: 26/05/2023 11:28:34
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for global_alarm
-- ----------------------------
DROP TABLE IF EXISTS `global_alarm`;
CREATE TABLE `global_alarm` (
  `id` int NOT NULL AUTO_INCREMENT,
  `eventtype` varchar(1) DEFAULT NULL COMMENT '告警事件类型',
  `alarm_text` varchar(255) DEFAULT NULL COMMENT '告警内容',
  `alarm_type` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '告警类型',
  `alarm_time` datetime DEFAULT NULL COMMENT '告警时间',
  `is_reset` int DEFAULT '0' COMMENT '告警已恢复',
  `is_send` int DEFAULT NULL COMMENT '是否已发送',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Table structure for global_backup
-- ----------------------------
DROP TABLE IF EXISTS `global_backup`;
CREATE TABLE `global_backup`  (
  `id` int(0) NOT NULL AUTO_INCREMENT,
  `backtype` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备份数据类型。log|db等',
  `backdate` datetime(0) NULL DEFAULT NULL COMMENT '备份操作时间',
  `backstaff` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备份人',
  `backfilepath` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备份文件存储路径',
  `datastartdate` datetime(0) NULL DEFAULT NULL COMMENT '备份数据开始时间',
  `dataenddate` datetime(0) NULL DEFAULT NULL COMMENT '备份数据结束时间',
  `backfilesize` bigint(0) NULL DEFAULT NULL COMMENT '备份文件大小',
  `state` int(0) NULL DEFAULT 0 COMMENT '操作状态.1 进行中  2 完成',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `ind1`(`backdate`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for global_const_code
-- ----------------------------
DROP TABLE IF EXISTS `global_const_code`;
CREATE TABLE `global_const_code`  (
  `id` int(0) NOT NULL AUTO_INCREMENT,
  `code` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `parentcode` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `name` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `ind2`(`code`, `parentcode`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 109537 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of global_const_code
-- ----------------------------
INSERT IGNORE INTO `global_const_code` VALUES (1, 'pl_sys_config', 'sysmenu', '平台配置');
INSERT IGNORE INTO `global_const_code` VALUES (2, 'pl_sysparam_save', 'pl_config', '保存');
INSERT IGNORE INTO `global_const_code` VALUES (3, 'pl_sysmenu_edit', 'pl_config', '菜单编辑');
INSERT IGNORE INTO `global_const_code` VALUES (4, 'pl_sysmenu_delete', 'pl_config', '菜单删除');
INSERT IGNORE INTO `global_const_code` VALUES (8, 'pl_sys_user', 'sysmenu', '系统用户管理');
INSERT IGNORE INTO `global_const_code` VALUES (9, 'sysmenu', 'systemconstcode', '功能菜单');
INSERT IGNORE INTO `global_const_code` VALUES (10, 'pl_sys', 'sysmenu', '系统管理');
INSERT IGNORE INTO `global_const_code` VALUES (30, 'pstype', 'systemconstcode', '地市');
INSERT IGNORE INTO `global_const_code` VALUES (31, 'pstype01', 'pstype', '变电站');
INSERT IGNORE INTO `global_const_code` VALUES (32, 'pstype0102', 'pstype01', '部门');
INSERT IGNORE INTO `global_const_code` VALUES (38, 'duty', 'systemconstcode', '职务');
INSERT IGNORE INTO `global_const_code` VALUES (39, '1', 'duty', '财务');
INSERT IGNORE INTO `global_const_code` VALUES (40, '2', 'duty', '计算机');
INSERT IGNORE INTO `global_const_code` VALUES (44, '3', 'duty', '软件开发');
INSERT IGNORE INTO `global_const_code` VALUES (45, '4', 'duty', '产品营运');
INSERT IGNORE INTO `global_const_code` VALUES (46, 'pl_sys_config_menu', 'pl_sys_config', '菜单管理');
INSERT IGNORE INTO `global_const_code` VALUES (47, 'pl_sys_config_role', 'pl_sys_config', '角色管理');
INSERT IGNORE INTO `global_const_code` VALUES (49, 'pl_role_code', 'systemconstcode', '角色代码');
INSERT IGNORE INTO `global_const_code` VALUES (50, 'role_superadmin', 'pl_role_code', '超级管理员');
INSERT IGNORE INTO `global_const_code` VALUES (51, 'role_sysadmin', 'pl_role_code', '系统管理员');
INSERT IGNORE INTO `global_const_code` VALUES (52, 'role_b_users', 'pl_role_code', '一般用户');
INSERT IGNORE INTO `global_const_code` VALUES (53, 'role_audit', 'pl_role_code', '审计用户');
INSERT IGNORE INTO `global_const_code` VALUES (54, 'role_third_user', 'pl_role_code', '外部接入用户');
INSERT IGNORE INTO `global_const_code` VALUES (56, 'pl_menu_basic_data', 'sysmenu', '基础数据维护');
INSERT IGNORE INTO `global_const_code` VALUES (57, 'pl_sys_config_dict', 'pl_sys_config', '系统字典代码');
INSERT IGNORE INTO `global_const_code` VALUES (58, 'pl_func_menu_add', 'pl_sys_config_menu', '添加菜单');
INSERT IGNORE INTO `global_const_code` VALUES (69, 'p_func_user_add', 'pl_sys_user', '新增');
INSERT IGNORE INTO `global_const_code` VALUES (70, 'pl_func_user_remove', 'pl_sys_user', '删除');
INSERT IGNORE INTO `global_const_code` VALUES (71, 'pl_func_user_edit', 'pl_sys_user', '编辑');
INSERT IGNORE INTO `global_const_code` VALUES (72, 'pl_func_user_resetpwd', 'pl_sys_user', '重置密码');
INSERT IGNORE INTO `global_const_code` VALUES (78, 'pl_func_person_add', 'pl_func_basicdata_person', '新增');
INSERT IGNORE INTO `global_const_code` VALUES (84, 'pl_sys_dict_add', 'pl_sys_config_dict', '新增');
INSERT IGNORE INTO `global_const_code` VALUES (85, 'pl_menu_screen', 'sysmenu', 'SCD可视化');
INSERT IGNORE INTO `global_const_code` VALUES (102, 'role_fenxi', 'pl_role_code', '综合分析人员');
INSERT IGNORE INTO `global_const_code` VALUES (117, 'pl_func_basicdata_area', 'pl_menu_basic_data', '变电站管理');
INSERT IGNORE INTO `global_const_code` VALUES (119, 'pl_sys_config_sysparam', 'pl_sys_config', '系统参数');
INSERT IGNORE INTO `global_const_code` VALUES (125, 'pl_sys_log', 'pl_sys', '系统日志');
INSERT IGNORE INTO `global_const_code` VALUES (146, 'pl_menu_outin', 'sysmenu', '签入签出');
INSERT IGNORE INTO `global_const_code` VALUES (147, 'pl_menu_scdtools', 'sysmenu', 'SCD工具');
INSERT IGNORE INTO `global_const_code` VALUES (148, 'pl_menu_stat', 'sysmenu', '统计分析');
INSERT IGNORE INTO `global_const_code` VALUES (149, 'voltage_level', 'systemconstcode', '电压等级');
INSERT IGNORE INTO `global_const_code` VALUES (150, 'station_type', 'systemconstcode', '变电站类型');
INSERT IGNORE INTO `global_const_code` VALUES (151, 'v_level_200', 'voltage_level', '500KV');
INSERT IGNORE INTO `global_const_code` VALUES (152, 'v_level_300', 'voltage_level', '220KV');
INSERT IGNORE INTO `global_const_code` VALUES (153, 'v_level_400', 'voltage_level', '110KV');
INSERT IGNORE INTO `global_const_code` VALUES (154, 'station_smart', 'station_type', '智能站');
INSERT IGNORE INTO `global_const_code` VALUES (156, 'station_concentrate', 'station_type', '集控站');
INSERT IGNORE INTO `global_const_code` VALUES (157, 'pl_checkrule_cnf', 'sysmenu', '校验规则配置');
INSERT IGNORE INTO `global_const_code` VALUES (158, 'pl_checkflow_cnf', 'sysmenu', '文件审核配置');
INSERT IGNORE INTO `global_const_code` VALUES (159, 'pl_checkflow_in_cnf', 'pl_checkflow_cnf', '签入审核配置');
INSERT IGNORE INTO `global_const_code` VALUES (160, 'pl_checkflow_out_cnf', 'pl_checkflow_cnf', '签出审核配置');
INSERT IGNORE INTO `global_const_code` VALUES (161, 'pl_menu_admin', 'sysmenu', '后台管理');
INSERT IGNORE INTO `global_const_code` VALUES (162, 'pl_menu_in', 'pl_menu_outin', '签入');
INSERT IGNORE INTO `global_const_code` VALUES (163, 'pl_menu_out', 'pl_menu_outin', '签出');
INSERT IGNORE INTO `global_const_code` VALUES (164, 'pl_menu_in_01', 'pl_menu_in', '编制');
INSERT IGNORE INTO `global_const_code` VALUES (165, 'pl_meun_in_02', 'pl_menu_in', '校核');
INSERT IGNORE INTO `global_const_code` VALUES (166, 'pl_menu_in_03', 'pl_menu_in', '审核');
INSERT IGNORE INTO `global_const_code` VALUES (167, 'pl_menu_in_04', 'pl_menu_in', '发布');
INSERT IGNORE INTO `global_const_code` VALUES (168, 'pl_menu_out_01', 'pl_menu_out', '申请');
INSERT IGNORE INTO `global_const_code` VALUES (169, 'pl_menu_out_02', 'pl_menu_out', '校核');
INSERT IGNORE INTO `global_const_code` VALUES (170, 'pl_menu_out_03', 'pl_menu_out', '审核');
INSERT IGNORE INTO `global_const_code` VALUES (172, 'scd_check_type', 'systemconstcode', '签入签出类型');
INSERT IGNORE INTO `global_const_code` VALUES (173, 'scd_check_type02_cld', 'systemconstcode', '改扩建子类型');
INSERT IGNORE INTO `global_const_code` VALUES (174, 'scd_check_type01', 'scd_check_type', '新建');
INSERT IGNORE INTO `global_const_code` VALUES (175, 'scd_check_type02', 'scd_check_type', '改扩建');
INSERT IGNORE INTO `global_const_code` VALUES (176, 'scd_check_type03', 'scd_check_type', '运检维护');
INSERT IGNORE INTO `global_const_code` VALUES (177, 'scd_check_c_type01', 'scd_check_type03_cld', '装置升级');
INSERT IGNORE INTO `global_const_code` VALUES (178, 'scd_check_c_type02', 'scd_check_type03_cld', '设备消缺');
INSERT IGNORE INTO `global_const_code` VALUES (179, 'scd_check_c_type03', 'scd_check_type03_cld', '反措执行');
INSERT IGNORE INTO `global_const_code` VALUES (180, 'scd_check_c_type04', 'scd_check_type03_cld', '配置变更');
INSERT IGNORE INTO `global_const_code` VALUES (181, 'scd_check_c_type09', 'scd_check_type03_cld', '其他');
INSERT IGNORE INTO `global_const_code` VALUES (182, 'alert_level', 'systemconstcode', '校验结果等级');
INSERT IGNORE INTO `global_const_code` VALUES (183, 'hint', 'alert_level', '提示');
INSERT IGNORE INTO `global_const_code` VALUES (184, 'waring', 'alert_level', '警告');
INSERT IGNORE INTO `global_const_code` VALUES (185, 'error', 'alert_level', '错误');
INSERT IGNORE INTO `global_const_code` VALUES (186, 'v_level_500', 'voltage_level', '35KV');
INSERT IGNORE INTO `global_const_code` VALUES (187, 'v_level_999', 'voltage_level', '其它');
INSERT IGNORE INTO `global_const_code` VALUES (188, 'device_type', 'systemconstcode', '装置类型');
INSERT IGNORE INTO `global_const_code` VALUES (189, 'C', 'device_type', '测控装置');
INSERT IGNORE INTO `global_const_code` VALUES (190, 'I', 'device_type', '智能终端');
INSERT IGNORE INTO `global_const_code` VALUES (191, 'M', 'device_type', '合并单元');
INSERT IGNORE INTO `global_const_code` VALUES (192, 'P', 'device_type', '保护装置');
INSERT IGNORE INTO `global_const_code` VALUES (193, 'S', 'device_type', '稳控');
INSERT IGNORE INTO `global_const_code` VALUES (194, 'MI', 'device_type', '合并单元和智能终端合一');
INSERT IGNORE INTO `global_const_code` VALUES (195, 'file_types', 'systemconstcode', '文件类型');
INSERT IGNORE INTO `global_const_code` VALUES (196, 'file_a_scd', 'file_types', 'SCD文件');
INSERT IGNORE INTO `global_const_code` VALUES (197, 'file_icd02', 'file_types', '施工竣工图纸');
INSERT IGNORE INTO `global_const_code` VALUES (198, 'file_ccd', 'file_types', 'CCD装置文件');
INSERT IGNORE INTO `global_const_code` VALUES (199, 'scd_check_type03_cld', 'systemconstcode', '运检维护子类型');
INSERT IGNORE INTO `global_const_code` VALUES (200, 'scd_check_c_type20', 'scd_check_type02_cld', '新增间隔或设备');
INSERT IGNORE INTO `global_const_code` VALUES (201, 'scd_check_c_type21', 'scd_check_type02_cld', '技术改造');
INSERT IGNORE INTO `global_const_code` VALUES (202, 'scd_check_c_type22', 'scd_check_type02_cld', '设计变更');
INSERT IGNORE INTO `global_const_code` VALUES (203, 'file_icd', 'file_types', 'ICD');
INSERT IGNORE INTO `global_const_code` VALUES (204, 'file_cid', 'file_types', 'CID');
INSERT IGNORE INTO `global_const_code` VALUES (205, 'file_spcd', 'disable_file_types', 'SPCD');
INSERT IGNORE INTO `global_const_code` VALUES (206, 'v_level_100', 'voltage_level', '750kV');
INSERT IGNORE INTO `global_const_code` VALUES (207, 'v_level_600', 'voltage_level', '10kV');
INSERT IGNORE INTO `global_const_code` VALUES (208, 'file_all', 'file_types', '全部文件');
INSERT IGNORE INTO `global_const_code` VALUES (2035, 'func_attachment_upload', 'pl_menu_scdtools', '上传');
INSERT IGNORE INTO `global_const_code` VALUES (2036, 'func_attachment_delete', 'pl_menu_scdtools', '删除');
INSERT IGNORE INTO `global_const_code` VALUES (2037, 'func_attachment_download', 'pl_menu_scdtools', '下载');
INSERT IGNORE INTO `global_const_code` VALUES (2038, 'pl_sys_cleardata', 'pl_sys', '数据清理');
INSERT IGNORE INTO `global_const_code` VALUES (2042, 'pl_menu_out_unlock', 'pl_menu_out', '终止流程');
INSERT IGNORE INTO `global_const_code` VALUES (2043, 'checkrule_apply_stan', 'systemconstcode', '校验规则标准');
INSERT IGNORE INTO `global_const_code` VALUES (2044, 'checkrule_type', 'systemconstcode', '校验规则类型');
INSERT IGNORE INTO `global_const_code` VALUES (2045, 'rule_standard_001', 'checkrule_apply_stan', 'DL/T860');
INSERT IGNORE INTO `global_const_code` VALUES (2046, 'rule_standard_002', 'checkrule_apply_stan', 'IEC61850_v2');
INSERT IGNORE INTO `global_const_code` VALUES (2047, 'rule_standard_003', 'checkrule_apply_stan', 'Q/GDW616');
INSERT IGNORE INTO `global_const_code` VALUES (2048, 'rule_type_001', 'checkrule_type', '基础建模校验');
INSERT IGNORE INTO `global_const_code` VALUES (2049, 'rule_type_002', 'checkrule_type', '数据类型模板一致性');
INSERT IGNORE INTO `global_const_code` VALUES (2050, 'rule_type_003', 'checkrule_type', '数据类型模板重复定义');
INSERT IGNORE INTO `global_const_code` VALUES (2051, 'rule_type_004', 'checkrule_type', '数据类型模板引用检查');
INSERT IGNORE INTO `global_const_code` VALUES (2052, 'rule_type_005', 'checkrule_type', '数据集控制块一致性');
INSERT IGNORE INTO `global_const_code` VALUES (2053, 'rule_type_006', 'checkrule_type', '模型数据实体化配置');
INSERT IGNORE INTO `global_const_code` VALUES (2054, 'rule_type_007', 'checkrule_type', '通信数据一致性');
INSERT IGNORE INTO `global_const_code` VALUES (2055, 'rule_type_008', 'checkrule_type', '虚端子配置');
INSERT IGNORE INTO `global_const_code` VALUES (2056, 'rule_type_009', 'checkrule_type', '工程配置规范检查');
INSERT IGNORE INTO `global_const_code` VALUES (2059, 'pl_audi_admin', 'sysmenu', '审计管理');
INSERT IGNORE INTO `global_const_code` VALUES (2060, 'pl_audi_auditype', 'pl_audi_admin', '日志审计分类');
INSERT IGNORE INTO `global_const_code` VALUES (2061, 'pl_audi_opttype', 'pl_audi_admin', '日志方法分类');
INSERT IGNORE INTO `global_const_code` VALUES (2062, 'pl_audi_logconfig', 'pl_audi_admin', '日志参数配置');
INSERT IGNORE INTO `global_const_code` VALUES (2063, '/static/police_o_admin.html', 'pl_menu_admin', 'url');
INSERT IGNORE INTO `global_const_code` VALUES (2064, '/static/scd_o.html', 'pl_menu_screen', 'url');
INSERT IGNORE INTO `global_const_code` VALUES (2065, 'pl_menu_network', 'sysmenu', '网络结构图');
INSERT IGNORE INTO `global_const_code` VALUES (2066, '/static/scd_network.html', 'pl_menu_network', 'url');
INSERT IGNORE INTO `global_const_code` VALUES (2067, '/static/scd_files.html', 'pl_menu_scdtools', 'url');
INSERT IGNORE INTO `global_const_code` VALUES (2068, '/static/scd_inout.html', 'pl_menu_outin', 'url');
INSERT IGNORE INTO `global_const_code` VALUES (2069, '/static/scd_stat.html', 'pl_menu_stat', 'url');
INSERT IGNORE INTO `global_const_code` VALUES (2070, 'pl_audi_query', 'sysmenu', '审计查询');
INSERT IGNORE INTO `global_const_code` VALUES (2071, 'pl_audi_backuprecovery', 'pl_audi_admin', '备份还原');
INSERT IGNORE INTO `global_const_code` VALUES (2072, 'pl_audi_logopt', 'pl_audi_query', '日志操作');
INSERT IGNORE INTO `global_const_code` VALUES (2073, 'pl_audi_stat', 'pl_audi_query', '日志报表');
INSERT IGNORE INTO `global_const_code` VALUES (2074, 'pl_audi_alertrecord', 'pl_audi_query', '告警记录');
INSERT IGNORE INTO `global_const_code` VALUES (2075, 'pl_audi_runrecord', 'pl_audi_query', '运行日志');
INSERT IGNORE INTO `global_const_code` VALUES (2096, 'log_optresult', 'systemconstcode', '日志结果类型');
INSERT IGNORE INTO `global_const_code` VALUES (2097, 'log_opttype', 'systemconstcode', '日志操作分类');
INSERT IGNORE INTO `global_const_code` VALUES (2099, 'log_eventtype', 'systemconstcode', '日志事件类型');
INSERT IGNORE INTO `global_const_code` VALUES (2100, 'log_eventlevel', 'systemconstcode', '日志事件等级');
INSERT IGNORE INTO `global_const_code` VALUES (2101, 'log_audittype', 'systemconstcode', '日志审计分类');
INSERT IGNORE INTO `global_const_code` VALUES (2102, '0', 'log_opttype', '查询');
INSERT IGNORE INTO `global_const_code` VALUES (2103, '0', 'log_audittype', '系统登录');
INSERT IGNORE INTO `global_const_code` VALUES (2104, '0', 'log_eventlevel', '高');
INSERT IGNORE INTO `global_const_code` VALUES (2106, '1', 'log_opttype', '新增');
INSERT IGNORE INTO `global_const_code` VALUES (2108, '1', 'log_audittype', '网络结构图');
INSERT IGNORE INTO `global_const_code` VALUES (2109, '2', 'log_opttype', '编辑');
INSERT IGNORE INTO `global_const_code` VALUES (2114, '3', 'log_opttype', '删除');
INSERT IGNORE INTO `global_const_code` VALUES (2118, '2', 'log_audittype', 'SCD可视化');
INSERT IGNORE INTO `global_const_code` VALUES (2119, '3', 'log_audittype', 'SCD文件解析');
INSERT IGNORE INTO `global_const_code` VALUES (2121, '4', 'log_audittype', 'SCD文件重新解析');
INSERT IGNORE INTO `global_const_code` VALUES (2123, '5', 'log_audittype', 'SCD签入签出');
INSERT IGNORE INTO `global_const_code` VALUES (2125, '6', 'log_audittype', 'SCD差异对比');
INSERT IGNORE INTO `global_const_code` VALUES (2127, '7', 'log_audittype', 'SCD一致性校验');
INSERT IGNORE INTO `global_const_code` VALUES (2129, '8', 'log_audittype', 'ICD|CID一致性校验');
INSERT IGNORE INTO `global_const_code` VALUES (2131, '9', 'log_audittype', 'ICD|CID与IED一致性校验');
INSERT IGNORE INTO `global_const_code` VALUES (2133, '10', 'log_audittype', 'CCD一致性校验');
INSERT IGNORE INTO `global_const_code` VALUES (2134, '1', 'log_eventlevel', '中');
INSERT IGNORE INTO `global_const_code` VALUES (2136, '2', 'log_eventlevel', '低');
INSERT IGNORE INTO `global_const_code` VALUES (2137, '11', 'log_audittype', 'SCL校验');
INSERT IGNORE INTO `global_const_code` VALUES (2138, '3', 'log_eventlevel', '未知类型');
INSERT IGNORE INTO `global_const_code` VALUES (2140, '12', 'log_audittype', 'CCD与scd一致性校验');
INSERT IGNORE INTO `global_const_code` VALUES (2142, '13', 'log_audittype', '配置文件');
INSERT IGNORE INTO `global_const_code` VALUES (2144, '14', 'log_audittype', '统计分析');
INSERT IGNORE INTO `global_const_code` VALUES (2146, '15', 'log_audittype', '管理后台/基础数据维护/变电站');
INSERT IGNORE INTO `global_const_code` VALUES (2148, '16', 'log_audittype', '管理后台/SCD文件审核配置');
INSERT IGNORE INTO `global_const_code` VALUES (2150, '17', 'log_audittype', '管理后台/SCD校验规则配置');
INSERT IGNORE INTO `global_const_code` VALUES (2152, '18', 'log_audittype', '管理后台/系统管理/数据清理');
INSERT IGNORE INTO `global_const_code` VALUES (2154, '19', 'log_audittype', '管理后台/系统管理/系统日志');
INSERT IGNORE INTO `global_const_code` VALUES (2156, '4', 'log_opttype', '登录');
INSERT IGNORE INTO `global_const_code` VALUES (2157, '20', 'log_audittype', '管理后台/系统管理/过期系统日志清理');
INSERT IGNORE INTO `global_const_code` VALUES (2159, '5', 'log_opttype', '登出');
INSERT IGNORE INTO `global_const_code` VALUES (2160, '21', 'log_audittype', '管理后台/系统管理/附件管理');
INSERT IGNORE INTO `global_const_code` VALUES (2162, '6', 'log_opttype', '执行');
INSERT IGNORE INTO `global_const_code` VALUES (2164, '22', 'log_audittype', '管理后台/系统管理/用户管理');
INSERT IGNORE INTO `global_const_code` VALUES (2166, '7', 'log_opttype', '数据统计');
INSERT IGNORE INTO `global_const_code` VALUES (2167, '23', 'log_audittype', '管理后台/系统管理/菜单管理');
INSERT IGNORE INTO `global_const_code` VALUES (2169, '8', 'log_opttype', '图表分析');
INSERT IGNORE INTO `global_const_code` VALUES (2170, '24', 'log_audittype', '管理后台/系统管理/角色管理');
INSERT IGNORE INTO `global_const_code` VALUES (2172, '9', 'log_opttype', '修改密码');
INSERT IGNORE INTO `global_const_code` VALUES (2173, '25', 'log_audittype', '管理后台/系统管理/用户角色分配');
INSERT IGNORE INTO `global_const_code` VALUES (2175, '10', 'log_opttype', '重置密码');
INSERT IGNORE INTO `global_const_code` VALUES (2176, '26', 'log_audittype', '管理后台/系统管理/字典代码');
INSERT IGNORE INTO `global_const_code` VALUES (2178, '11', 'log_opttype', '审核');
INSERT IGNORE INTO `global_const_code` VALUES (2179, '27', 'log_audittype', '管理后台/系统管理/系统参数');
INSERT IGNORE INTO `global_const_code` VALUES (2181, '12', 'log_opttype', '签入');
INSERT IGNORE INTO `global_const_code` VALUES (2182, '28', 'log_audittype', '管理后台/审计管理/审计分类管理');
INSERT IGNORE INTO `global_const_code` VALUES (2184, '13', 'log_opttype', '签出');
INSERT IGNORE INTO `global_const_code` VALUES (2186, '29', 'log_audittype', '管理后台/审计管理/操作分类管理');
INSERT IGNORE INTO `global_const_code` VALUES (2187, '14', 'log_opttype', '导入');
INSERT IGNORE INTO `global_const_code` VALUES (2188, '15', 'log_opttype', '导出');
INSERT IGNORE INTO `global_const_code` VALUES (2190, '16', 'log_opttype', '下载');
INSERT IGNORE INTO `global_const_code` VALUES (2192, '30', 'log_audittype', '管理后台/审计管理/日志参数配置');
INSERT IGNORE INTO `global_const_code` VALUES (2193, '31', 'log_audittype', '管理后台/审计管理/日志备份还原');
INSERT IGNORE INTO `global_const_code` VALUES (2194, '32', 'log_audittype', '管理后台/审计查询/日志操作');
INSERT IGNORE INTO `global_const_code` VALUES (2195, '17', 'log_opttype', '上传');
INSERT IGNORE INTO `global_const_code` VALUES (2198, '18', 'log_opttype', '启动');
INSERT IGNORE INTO `global_const_code` VALUES (2199, '33', 'log_audittype', '管理后台/审计查询/日志报表');
INSERT IGNORE INTO `global_const_code` VALUES (2200, '34', 'log_audittype', '管理后台/审计查询/告警记录');
INSERT IGNORE INTO `global_const_code` VALUES (2202, '19', 'log_opttype', '提交');
INSERT IGNORE INTO `global_const_code` VALUES (2203, '35', 'log_audittype', '管理后台/审计查询/运行日志');
INSERT IGNORE INTO `global_const_code` VALUES (2205, '36', 'log_audittype', '客户端节点');
INSERT IGNORE INTO `global_const_code` VALUES (2207, '20', 'log_opttype', '终止');
INSERT IGNORE INTO `global_const_code` VALUES (2208, '37', 'log_audittype', '通知公告');
INSERT IGNORE INTO `global_const_code` VALUES (2210, '38', 'log_audittype', '未知类型');
INSERT IGNORE INTO `global_const_code` VALUES (2212, '21', 'log_opttype', '结束');
INSERT IGNORE INTO `global_const_code` VALUES (2214, '22', 'log_opttype', '驳回');
INSERT IGNORE INTO `global_const_code` VALUES (2216, '23', 'log_opttype', '撤回');
INSERT IGNORE INTO `global_const_code` VALUES (2218, '24', 'log_opttype', '绑定关系');
INSERT IGNORE INTO `global_const_code` VALUES (2221, '25', 'log_opttype', '解除绑定');
INSERT IGNORE INTO `global_const_code` VALUES (2222, '26', 'log_opttype', '禁用');
INSERT IGNORE INTO `global_const_code` VALUES (2225, '27', 'log_opttype', '启用');
INSERT IGNORE INTO `global_const_code` VALUES (2227, '28', 'log_opttype', '锁定');
INSERT IGNORE INTO `global_const_code` VALUES (2229, '29', 'log_opttype', '解锁');
INSERT IGNORE INTO `global_const_code` VALUES (2231, '30', 'log_opttype', '未知类型');
INSERT IGNORE INTO `global_const_code` VALUES (43736, '0', 'log_eventtype', '系统事件');
INSERT IGNORE INTO `global_const_code` VALUES (43742, '1', 'log_eventtype', '业务事件');
INSERT IGNORE INTO `global_const_code` VALUES (43745, '2', 'log_eventtype', '未知类型');
INSERT IGNORE INTO `global_const_code` VALUES (43817, '0', 'log_optresult', '失败');
INSERT IGNORE INTO `global_const_code` VALUES (43822, '1', 'log_optresult', '成功');
INSERT IGNORE INTO `global_const_code` VALUES (43826, '2', 'log_optresult', '');
INSERT IGNORE INTO `global_const_code` VALUES (93197, 'rule_standard_004', 'checkrule_apply_stan', 'DL/T1873');
INSERT IGNORE INTO `global_const_code` VALUES (93198, 'rule_standard_005', 'checkrule_apply_stan', 'Q/CSG1203065-2020');
INSERT IGNORE INTO `global_const_code` VALUES (93199, 'rule_standard_006', 'checkrule_apply_stan', 'GB/T 32890');
INSERT IGNORE INTO `global_const_code` VALUES (93200, 'rule_standard_007', 'checkrule_apply_stan', 'GB/T 1874');
INSERT IGNORE INTO `global_const_code` VALUES (93201, 'rule_standard_008', 'checkrule_apply_stan', 'Q∕GDW 11156-2014');
INSERT IGNORE INTO `global_const_code` VALUES (93202, 'rule_standard_009', 'checkrule_apply_stan', 'QGDW11662-2017');
INSERT IGNORE INTO `global_const_code` VALUES (93203, 'rule_standard_010', 'checkrule_apply_stan', 'Q_CSG1204059-2020');
INSERT IGNORE INTO `global_const_code` VALUES (93204, 'rule_standard_011', 'checkrule_apply_stan', '智能站工程配置补充要求-20200824');
INSERT IGNORE INTO `global_const_code` VALUES (98390, 'rule_type_010', 'checkrule_type', '站控层通信参数校验');
INSERT IGNORE INTO `global_const_code` VALUES (98391, 'rule_type_011', 'checkrule_type', '过程层通信参数校验');
INSERT IGNORE INTO `global_const_code` VALUES (98392, 'rule_type_012', 'checkrule_type', '物理端口配置');
INSERT IGNORE INTO `global_const_code` VALUES (98393, 'rule_type_013', 'checkrule_type', '数据集校验');
INSERT IGNORE INTO `global_const_code` VALUES (98394, 'rule_type_014', 'checkrule_type', '虚回路校验');
INSERT IGNORE INTO `global_const_code` VALUES (98395, 'rule_type_015', 'checkrule_type', 'GOOSE控制块校验');
INSERT IGNORE INTO `global_const_code` VALUES (98396, 'rule_type_016', 'checkrule_type', 'SV控制块');
INSERT IGNORE INTO `global_const_code` VALUES (98397, 'rule_type_017', 'checkrule_type', '日志控制块校验');
INSERT IGNORE INTO `global_const_code` VALUES (98398, 'rule_type_018', 'checkrule_type', '定值控制块校验');
INSERT IGNORE INTO `global_const_code` VALUES (98399, 'rule_type_019', 'checkrule_type', '报告控制块校验');
INSERT IGNORE INTO `global_const_code` VALUES (98400, 'rule_standard_012', 'checkrule_apply_stan', 'GB/T 34121');
INSERT IGNORE INTO `global_const_code` VALUES (98401, 'rule_standard_013', 'checkrule_apply_stan', 'IEC61850-6');
INSERT IGNORE INTO `global_const_code` VALUES (102227, 'A', 'device_type', '辅助装置');
INSERT IGNORE INTO `global_const_code` VALUES (102228, 'AP', 'device_type', '交直流一体化电源');
INSERT IGNORE INTO `global_const_code` VALUES (102229, 'CM', 'device_type', '在线状态监测');
INSERT IGNORE INTO `global_const_code` VALUES (102230, 'D', 'device_type', '行波测距');
INSERT IGNORE INTO `global_const_code` VALUES (102231, 'E', 'device_type', '电能表');
INSERT IGNORE INTO `global_const_code` VALUES (102232, 'F', 'device_type', '保信子站');
INSERT IGNORE INTO `global_const_code` VALUES (102233, 'IN', 'device_type', '非电量和智能终端合一');
INSERT IGNORE INTO `global_const_code` VALUES (102234, 'L', 'device_type', '过负荷联切');
INSERT IGNORE INTO `global_const_code` VALUES (102235, 'PS', 'device_type', '短引线保护');
INSERT IGNORE INTO `global_const_code` VALUES (102236, 'PC', 'device_type', '保护和测控合一');
INSERT IGNORE INTO `global_const_code` VALUES (102237, 'PP', 'device_type', '同步相量测量装置');
INSERT IGNORE INTO `global_const_code` VALUES (102238, 'RF', 'device_type', '故障录波器');
INSERT IGNORE INTO `global_const_code` VALUES (102239, 'RN', 'device_type', '网络记录分析仪');
INSERT IGNORE INTO `global_const_code` VALUES (102240, 'RM', 'device_type', '故录和网分合一');
INSERT IGNORE INTO `global_const_code` VALUES (102242, 'SP', 'device_type', '备用电源自动投入装置');
INSERT IGNORE INTO `global_const_code` VALUES (102243, 'SF', 'device_type', '低周减载');
INSERT IGNORE INTO `global_const_code` VALUES (102244, 'SW', 'device_type', '交换机');
INSERT IGNORE INTO `global_const_code` VALUES (102245, 'SC', 'device_type', '同步时钟装置');
INSERT IGNORE INTO `global_const_code` VALUES (102246, 'T', 'device_type', '远动机');
INSERT IGNORE INTO `global_const_code` VALUES (102247, 'xy', 'device_type', '其他');

-- ----------------------------
-- Table structure for global_sys_param
-- ----------------------------
DROP TABLE IF EXISTS `global_sys_param`;
CREATE TABLE `global_sys_param`  (
  `param_name` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `param_value` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
  `param_memo` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`param_name`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of global_sys_param
-- ----------------------------
INSERT INTO `global_sys_param` VALUES ('allow_access_ips', '*', '允许访问系统的IP或者IP段');
INSERT INTO `global_sys_param` VALUES ('attachmentClearHour', '00', '过期附件清理时点(每天)');
INSERT INTO `global_sys_param` VALUES ('autoclearday', '60', '有效数据保留天数');
INSERT INTO `global_sys_param` VALUES ('client_version_scd1.0', '20230525-23', 'scd1.0_客户端版本');
INSERT INTO `global_sys_param` VALUES ('db_script_version', '3', '数据库更新版本');
INSERT INTO `global_sys_param` VALUES ('login_fail_locktime', '180', '登录失败次数超限时锁定时长(秒)');
INSERT INTO `global_sys_param` VALUES ('login_fail_maxcount', '5', '最大登录失败次数');
INSERT INTO `global_sys_param` VALUES ('log_alarm_email', '1979027121@qq.com', '日志告警接收邮箱');
INSERT INTO `global_sys_param` VALUES ('log_fliterrule_date_range', '2023-05-24,2023-05-25', '日志日期过滤规则设置');
INSERT INTO `global_sys_param` VALUES ('log_fliterrule_date_state', '1', '日志时间过滤规则开关');
INSERT INTO `global_sys_param` VALUES ('log_fliterrule_eventtype_id', '0', '日志事件类型过滤规则列表');
INSERT INTO `global_sys_param` VALUES ('log_fliterrule_eventtype_state', '1', '日志事件类型过滤规则开关');
INSERT INTO `global_sys_param` VALUES ('log_fliterrule_staff_list', '李玉', '日志用户过滤规则列表');
INSERT INTO `global_sys_param` VALUES ('log_fliterrule_staff_state', '1', '日志用户过滤规则开关');
INSERT INTO `global_sys_param` VALUES ('log_size_alarm1', '20', '日志预警阀值');
INSERT INTO `global_sys_param` VALUES ('log_size_alarm2', '90', '日志告警阀值');
INSERT INTO `global_sys_param` VALUES ('log_size_max', '100', '日志容量最大值');
INSERT INTO `global_sys_param` VALUES ('Mqtt_JS_URL', '8.142.173.95:8083', 'mqtt的js库连接地址');
INSERT INTO `global_sys_param` VALUES ('orgname', '某某公司', '当前单位名称');
INSERT INTO `global_sys_param` VALUES ('scdparse_max_count', '5', '允许同时解析的scd文件数量');
INSERT INTO `global_sys_param` VALUES ('session_timeout', '1800', 'Session超时时长');
INSERT INTO `global_sys_param` VALUES ('tempScdMonitorHour', '01', '临时(非管控)SCD释放时点(每天)');
INSERT INTO `global_sys_param` VALUES ('user_login_client_limt', 'none', '同一帐号是否允许多点登录(o2o、none)');
INSERT INTO `global_sys_param` VALUES ('user_pwd_edit_mod', 'admin', '帐号密码修改模式(admin、none)');
INSERT INTO `global_sys_param` VALUES ('user_pwd_expire_day', '60', '默认帐号密码过期天数');
INSERT INTO `global_sys_param` VALUES ('user_pwd_rule', 'simple', '帐号密码复杂度规则(simple、strong)');
INSERT INTO `global_sys_param` VALUES ('xrootcode', 'pstype', '启用区域类型根节点编号');

-- ----------------------------
-- Table structure for global_syslog
-- ----------------------------
DROP TABLE IF EXISTS `global_syslog`;
CREATE TABLE `global_syslog`  (
  `id` bigint(0) NOT NULL AUTO_INCREMENT,
  `insdate` datetime(0) NULL DEFAULT NULL COMMENT '操作时间',
  `ip` varchar(24) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '操作IP',
  `description` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '日志内容',
  `staff` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '操作人员',
  `logtype` int(0) NULL DEFAULT NULL COMMENT '操作类型',
  `audittype` int(0) NULL DEFAULT NULL COMMENT '审计类型',
  `eventtype` int(0) NULL DEFAULT NULL COMMENT '事件类型',
  `eventlevel` int(0) NULL DEFAULT NULL COMMENT '事件等级',
  `success` int(0) NOT NULL DEFAULT 1 COMMENT '操作结果',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `ind1`(`insdate`) USING BTREE,
  INDEX `ind2`(`logtype`) USING BTREE,
  INDEX `ind3`(`success`) USING BTREE,
  INDEX `ind4`(`audittype`) USING BTREE,
  INDEX `ind5`(`eventtype`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for t_area_ied_relation
-- ----------------------------
DROP TABLE IF EXISTS `t_area_ied_relation`;
CREATE TABLE `t_area_ied_relation`  (
  `id` int(0) NOT NULL AUTO_INCREMENT,
  `scd_id` bigint(0) NOT NULL DEFAULT 0 COMMENT 'SCD编号',
  `area_id` int(0) NOT NULL COMMENT '间隔ID',
  `ied_id` bigint(0) NOT NULL COMMENT 'ied设备ID',
  `ied_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT 'ied设备名称',
  `ied_type` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '设备类型',
  PRIMARY KEY (`id`, `area_id`, `ied_id`) USING BTREE,
  INDEX `ind1`(`scd_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '间隔下属IED设备关系表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for t_base_checkin_book
-- ----------------------------
DROP TABLE IF EXISTS `t_base_checkin_book`;
CREATE TABLE `t_base_checkin_book`  (
  `id` bigint(0) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `CREATED_BY` int(0) NULL DEFAULT NULL COMMENT '创建人',
  `CREATED_TIME` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `UPDATED_BY` int(0) NULL DEFAULT NULL COMMENT '更新人',
  `UPDATED_TIME` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
  `remark` varchar(900) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
  `station_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '所属变电站',
  `manufactor` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '集成厂家',
  `optor` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '集成人姓名',
  `linkphone` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '集成人联系方式',
  `design_unit` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '设计单位',
  `manage_unit` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '项目管理单位',
  `finish_date` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '项目完成时间',
  `checkin_type` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '签入类型',
  `checkin_subtype` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '签入子类型',
  `job_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '工作内容',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '签入台账' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for t_base_checkout
-- ----------------------------
DROP TABLE IF EXISTS `t_base_checkout`;
CREATE TABLE `t_base_checkout`  (
  `id` bigint(0) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `CREATED_BY` int(0) NULL DEFAULT NULL COMMENT '创建人',
  `CREATED_TIME` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `UPDATED_BY` int(0) NULL DEFAULT NULL COMMENT '更新人',
  `UPDATED_TIME` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
  `remark` varchar(900) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
  `checkout_type` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '签出类型',
  `checkout_subtype` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '签出子类型',
  `job_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '工作内容',
  `run_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '运行文件',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '签出台账' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for t_base_job_content
-- ----------------------------
DROP TABLE IF EXISTS `t_base_job_content`;
CREATE TABLE `t_base_job_content`  (
  `id` bigint(0) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `CREATED_BY` int(0) NULL DEFAULT NULL COMMENT '创建人',
  `CREATED_TIME` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `UPDATED_BY` int(0) NULL DEFAULT NULL COMMENT '更新人',
  `UPDATED_TIME` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
  `remark` varchar(900) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
  `job_type` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '工作类型',
  `job_content` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '工作内容',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '签出、签入工作内容' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for t_base_notice
-- ----------------------------
DROP TABLE IF EXISTS `t_base_notice`;
CREATE TABLE `t_base_notice`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `station_id` int(0) NOT NULL COMMENT '所属站',
  `caption` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '标题',
  `notice_type` int(0) NOT NULL DEFAULT 0 COMMENT '通知分类',
  `sender_name` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '发送者名称',
  `sender_time` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '发送时间',
  `content` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '正文内容',
  `rev_id` int(0) NOT NULL COMMENT '通知对象ID',
  `read_flag` int(0) NOT NULL COMMENT '已读标记',
  `read_time` datetime(0) NULL DEFAULT NULL COMMENT '读取时间',
  `cr` int(0) NULL DEFAULT NULL,
  `ct` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `ind1`(`station_id`) USING BTREE,
  INDEX `ind2`(`rev_id`) USING BTREE,
  INDEX `ind3`(`sender_time`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '站内通知提醒表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for t_base_station
-- ----------------------------
DROP TABLE IF EXISTS `t_base_station`;
CREATE TABLE `t_base_station`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `station_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '变电站名称',
  `voltage_class` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '电压等级',
  `parent_org` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '所属地市公司',
  `station_type` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '变电站类型',
  `station_status` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '变电站状态',
  `addr` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '地址',
  `remark` varchar(900) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
  `CREATED_BY` int(0) NULL DEFAULT NULL COMMENT '创建人',
  `CREATED_TIME` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `UPDATED_BY` int(0) NULL DEFAULT NULL COMMENT '更新人',
  `UPDATED_TIME` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '变电站基础信息表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for t_data_area
-- ----------------------------
DROP TABLE IF EXISTS `t_data_area`;
CREATE TABLE `t_data_area`  (
  `ID` bigint(0) UNSIGNED NOT NULL AUTO_INCREMENT,
  `PID` bigint(0) NOT NULL COMMENT '上级ID',
  `AREA_NAME` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '区域名称',
  `AREA_CODE` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '区域代码\r\n编码规则:上级代码+自身代码',
  `AREA_TYPE` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '区域类别\\r\\n取代码表中的:小区、楼栋、楼层、房间等代码',
  `AREA_KIND` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '业态：自住、出租等',
  `AREA_ADDR` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '地址',
  `JD` decimal(16, 13) NULL DEFAULT NULL COMMENT '经度',
  `WD` decimal(16, 13) NULL DEFAULT NULL COMMENT '纬度',
  `LIVE_NUM` int(0) NULL DEFAULT NULL COMMENT '居住人口',
  `AREA_LEVEL` int(0) NULL DEFAULT NULL COMMENT '区域层级',
  `IS_LEAF` int(0) NULL DEFAULT NULL COMMENT '是否子叶节点',
  `AREA_SORT` int(0) NULL DEFAULT NULL COMMENT '排序字段',
  `APMAC` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'ap设备的mac地址',
  `Cr` int(0) NULL DEFAULT NULL,
  `ct` datetime(0) NULL DEFAULT NULL,
  `AREA_UNICODE` varchar(225) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '区域场所唯一标识',
  `P_AREA_UNICODE` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '父级唯一标识',
  `FULLPATH` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '节点全路径描述',
  PRIMARY KEY (`ID`) USING BTREE,
  UNIQUE INDEX `ind7`(`AREA_NAME`, `PID`) USING BTREE,
  INDEX `t_area_PID`(`PID`) USING BTREE,
  INDEX `t_area_AREA_CODE`(`AREA_CODE`) USING BTREE,
  INDEX `t_area_IS_LEAF`(`IS_LEAF`) USING BTREE,
  INDEX `t_area_AREA_SORT`(`AREA_SORT`) USING BTREE,
  INDEX `t_area_AREA_TYPE`(`AREA_TYPE`) USING BTREE,
  INDEX `t_area_AREA_KIND`(`AREA_KIND`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 861 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '区域表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for t_data_attachment
-- ----------------------------
DROP TABLE IF EXISTS `t_data_attachment`;
CREATE TABLE `t_data_attachment`  (
  `id` int(0) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `skeepday` int(0) NOT NULL DEFAULT 30,
  `tablename` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `colname` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `filterwhere` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `memo` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `cr` int(0) NOT NULL,
  `ct` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for t_data_role_func
-- ----------------------------
DROP TABLE IF EXISTS `t_data_role_func`;
CREATE TABLE `t_data_role_func`  (
  `id` int(0) NOT NULL AUTO_INCREMENT,
  `roleid` int(0) NOT NULL,
  `funccodeid` int(0) NOT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `ind1`(`roleid`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for t_data_user
-- ----------------------------
DROP TABLE IF EXISTS `t_data_user`;
CREATE TABLE `t_data_user`  (
  `id` int(0) NOT NULL AUTO_INCREMENT,
  `name` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `account` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `pwd` varchar(1024) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `pwd_expire` datetime(0) NULL DEFAULT '1970-01-01 00:00:00' COMMENT '密码过期时间',
  `mobilephone` varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '移动电话号码',
  `memo` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `createtime` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP,
  `createuser` int(0) NULL DEFAULT NULL,
  `role` tinyint(1) NULL DEFAULT 0 COMMENT '是否为管理员帐号',
  `bind_ips` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '绑定允许登录的IP或IP段,多过IP用,分隔',
  `datelimit_start` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '授权访问开始日期',
  `datelimit_end` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '授权访问结束日期',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for t_data_usersession
-- ----------------------------
DROP TABLE IF EXISTS `t_data_usersession`;
CREATE TABLE `t_data_usersession`  (
  `sessionid` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'sessionID',
  `userid` int(0) NOT NULL COMMENT '用户ID',
  `lastdt` bigint(0) NOT NULL COMMENT '最后访问系统的时间戳',
  PRIMARY KEY (`sessionid`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for t_ied_ctrl_relation
-- ----------------------------
DROP TABLE IF EXISTS `t_ied_ctrl_relation`;
CREATE TABLE `t_ied_ctrl_relation`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `scd_id` bigint(0) NOT NULL COMMENT 'SCD文件ID',
  `master_ied_id` bigint(0) NOT NULL COMMENT '主IED ID',
  `master_ied_name` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '主IED名称',
  `ref_type` int(0) NOT NULL COMMENT '关系类型;1:输入 0:输出',
  `source_ied_id` bigint(0) NOT NULL COMMENT '源IED ID',
  `source_ied_name` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '源IED名称',
  `target_ied_id` bigint(0) NOT NULL COMMENT '目标IED ID',
  `target_ied_name` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '目标IED名称',
  `out_ld_id` bigint(0) NULL DEFAULT NULL COMMENT '输入逻辑设备节点ID',
  `out_ld_inst` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '输入逻辑设备节点实例',
  `out_ld_desc` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '输入逻辑设备节点描述',
  `ld_id` bigint(0) NOT NULL COMMENT '逻辑设备节点ID',
  `ld_inst` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '逻辑设备实例名称',
  `ld_desc` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '逻辑设备描述',
  `ctrl_id` bigint(0) NOT NULL COMMENT '控制块ID',
  `ctrl_type` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '控制块类型;SMV/GSEControl',
  `ctrl_name` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '控制块名称',
  `datset_id` bigint(0) NOT NULL COMMENT '数据集ID',
  `datset_name` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '数据集名称',
  `datset_desc` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '数据集描述',
  `cnt` int(0) NOT NULL DEFAULT 0 COMMENT '输入输出数量',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `ind1`(`scd_id`) USING BTREE,
  INDEX `ind2`(`master_ied_id`) USING BTREE,
  INDEX `ind3`(`master_ied_name`) USING BTREE,
  INDEX `ind4`(`source_ied_name`) USING BTREE,
  INDEX `ind5`(`target_ied_name`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 2625 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'IED控制块输入输出关系信息' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for t_ied_relation
-- ----------------------------
DROP TABLE IF EXISTS `t_ied_relation`;
CREATE TABLE `t_ied_relation`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `scd_id` bigint(0) NOT NULL COMMENT 'SCD文件ID',
  `ied_id` bigint(0) NOT NULL COMMENT 'IED编号',
  `ied_name` varchar(90) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'IED名称',
  `ref_type` int(0) NOT NULL COMMENT '输入输出类型;1表示输入 0表示输出',
  `ref_ied_name` varchar(90) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '关联IED名称',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `scdid`(`scd_id`) USING BTREE,
  INDEX `iedname`(`ied_name`) USING BTREE,
  INDEX `iedid`(`ied_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'IED输入输出关系表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for t_relation_user_area
-- ----------------------------
DROP TABLE IF EXISTS `t_relation_user_area`;
CREATE TABLE `t_relation_user_area`  (
  `id` bigint(0) NOT NULL AUTO_INCREMENT,
  `userid` int(0) NOT NULL COMMENT '用户ID',
  `areaid` int(0) NULL DEFAULT NULL COMMENT '区域ID',
  `ct` datetime(0) NULL DEFAULT NULL COMMENT '关系创建时间',
  `cr` int(0) NULL DEFAULT NULL COMMENT '创建人',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `ind1`(`userid`) USING BTREE,
  INDEX `ind2`(`areaid`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for t_scd_accesspoint_attrs
-- ----------------------------
DROP TABLE IF EXISTS `t_scd_accesspoint_attrs`;
CREATE TABLE `t_scd_accesspoint_attrs`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `scd_id` bigint(0) NOT NULL,
  `node_id` bigint(0) NOT NULL COMMENT '所属节点ID',
  `attr_name` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_desc` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_router` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_clock` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `CREATED_BY` int(0) NULL DEFAULT 0 COMMENT '创建人',
  `CREATED_TIME` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `q1`(`scd_id`) USING BTREE,
  INDEX `q2`(`node_id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 17207 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'AccessPoint节点属性' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for t_scd_association_attrs
-- ----------------------------
DROP TABLE IF EXISTS `t_scd_association_attrs`;
CREATE TABLE `t_scd_association_attrs`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `scd_id` bigint(0) NOT NULL,
  `node_id` bigint(0) NOT NULL COMMENT '所属节点ID',
  `attr_ld_inst` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_prefix` varchar(12) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_ln_class` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_ln_inst` varchar(14) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_kind` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_association_id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_ied_name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_desc` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `CREATED_BY` int(0) NULL DEFAULT 0 COMMENT '创建人',
  `CREATED_TIME` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `q1`(`scd_id`) USING BTREE,
  INDEX `q2`(`node_id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'Association节点属性' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for t_scd_authentication_attrs
-- ----------------------------
DROP TABLE IF EXISTS `t_scd_authentication_attrs`;
CREATE TABLE `t_scd_authentication_attrs`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `scd_id` bigint(0) NOT NULL,
  `node_id` bigint(0) NOT NULL COMMENT '所属节点ID',
  `attr_none` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_password` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_weak` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_strong` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_certificate` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `CREATED_BY` int(0) NULL DEFAULT 0 COMMENT '创建人',
  `CREATED_TIME` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `q1`(`scd_id`) USING BTREE,
  INDEX `q2`(`node_id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 9927 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'Authentication节点属性' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for t_scd_bay_attrs
-- ----------------------------
DROP TABLE IF EXISTS `t_scd_bay_attrs`;
CREATE TABLE `t_scd_bay_attrs`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `scd_id` bigint(0) NOT NULL,
  `node_id` bigint(0) NOT NULL COMMENT '所属节点ID',
  `attr_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `CREATED_BY` int(0) NULL DEFAULT 0 COMMENT '创建人',
  `CREATED_TIME` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `q1`(`scd_id`) USING BTREE,
  INDEX `q2`(`node_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 352 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'Private-voltage-Bay节点属性' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for t_scd_bda_attrs
-- ----------------------------
DROP TABLE IF EXISTS `t_scd_bda_attrs`;
CREATE TABLE `t_scd_bda_attrs`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `scd_id` bigint(0) NOT NULL,
  `node_id` bigint(0) NOT NULL COMMENT '所属节点ID',
  `attr_desc` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_type` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `attr_saddr` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_btype` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `attr_val_kind` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_count` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `CREATED_BY` int(0) NULL DEFAULT 0 COMMENT '创建人',
  `CREATED_TIME` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `q1`(`scd_id`) USING BTREE,
  INDEX `q2`(`node_id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 11689 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'BDA节点属性' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for t_scd_bitrate_attrs
-- ----------------------------
DROP TABLE IF EXISTS `t_scd_bitrate_attrs`;
CREATE TABLE `t_scd_bitrate_attrs`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `scd_id` bigint(0) NOT NULL,
  `node_id` bigint(0) NOT NULL COMMENT '所属节点ID',
  `attr_unit` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_multiplier` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `CREATED_BY` int(0) NULL DEFAULT 0 COMMENT '创建人',
  `CREATED_TIME` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `w1`(`scd_id`) USING BTREE,
  INDEX `w2`(`node_id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 43 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'BitRate节点属性' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for t_scd_clientln_attrs
-- ----------------------------
DROP TABLE IF EXISTS `t_scd_clientln_attrs`;
CREATE TABLE `t_scd_clientln_attrs`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `scd_id` bigint(0) NOT NULL,
  `node_id` bigint(0) NOT NULL COMMENT '所属节点ID',
  `attr_ied_name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `attr_desc` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_ld_inst` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_prefix` varchar(12) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_ln_class` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_ln_inst` varchar(14) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `CREATED_BY` int(0) NULL DEFAULT 0 COMMENT '创建人',
  `CREATED_TIME` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `q1`(`scd_id`) USING BTREE,
  INDEX `q2`(`node_id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'ClientLN节点属性' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for t_scd_clientservices_attrs
-- ----------------------------
DROP TABLE IF EXISTS `t_scd_clientservices_attrs`;
CREATE TABLE `t_scd_clientservices_attrs`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `scd_id` bigint(0) NOT NULL,
  `node_id` bigint(0) NOT NULL COMMENT '所属节点ID',
  `attr_goose` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_gsse` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_buf_report` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_unbuf_report` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_read_log` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_sv` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_fccb` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `CREATED_BY` int(0) NULL DEFAULT 0 COMMENT '创建人',
  `CREATED_TIME` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `q1`(`scd_id`) USING BTREE,
  INDEX `q2`(`node_id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 253 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'ClientServices节点属性' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for t_scd_communication_attrs
-- ----------------------------
DROP TABLE IF EXISTS `t_scd_communication_attrs`;
CREATE TABLE `t_scd_communication_attrs`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `scd_id` bigint(0) NOT NULL,
  `node_id` bigint(0) NOT NULL COMMENT '所属节点ID',
  `attr_desc` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `CREATED_BY` int(0) NULL DEFAULT 0 COMMENT '创建人',
  `CREATED_TIME` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `ind1`(`scd_id`) USING BTREE,
  INDEX `w2`(`node_id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 16 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'Communication节点属性' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for t_scd_confdataset_attrs
-- ----------------------------
DROP TABLE IF EXISTS `t_scd_confdataset_attrs`;
CREATE TABLE `t_scd_confdataset_attrs`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `scd_id` bigint(0) NOT NULL,
  `node_id` bigint(0) NOT NULL COMMENT '所属节点ID',
  `attr_max` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_max_attributes` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_modify` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_fccb` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `CREATED_BY` int(0) NULL DEFAULT 0 COMMENT '创建人',
  `CREATED_TIME` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `q1`(`scd_id`) USING BTREE,
  INDEX `q2`(`node_id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 8258 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'ConfDataSet节点属性' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for t_scd_conflns_attrs
-- ----------------------------
DROP TABLE IF EXISTS `t_scd_conflns_attrs`;
CREATE TABLE `t_scd_conflns_attrs`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `scd_id` bigint(0) NOT NULL,
  `node_id` bigint(0) NOT NULL COMMENT '所属节点ID',
  `attr_fix_prefix` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_fix_ln_inst` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `CREATED_BY` int(0) NULL DEFAULT 0 COMMENT '创建人',
  `CREATED_TIME` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `q1`(`scd_id`) USING BTREE,
  INDEX `q2`(`node_id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 4871 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'ConfLNs节点属性' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for t_scd_conflogcontrol_attrs
-- ----------------------------
DROP TABLE IF EXISTS `t_scd_conflogcontrol_attrs`;
CREATE TABLE `t_scd_conflogcontrol_attrs`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `scd_id` bigint(0) NOT NULL,
  `node_id` bigint(0) NOT NULL COMMENT '所属节点ID',
  `attr_max` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `CREATED_BY` int(0) NULL DEFAULT 0 COMMENT '创建人',
  `CREATED_TIME` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `q1`(`scd_id`) USING BTREE,
  INDEX `q2`(`node_id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 2034 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'ConfLogControl节点属性' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for t_scd_confreportcontrol_attrs
-- ----------------------------
DROP TABLE IF EXISTS `t_scd_confreportcontrol_attrs`;
CREATE TABLE `t_scd_confreportcontrol_attrs`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `scd_id` bigint(0) NOT NULL,
  `node_id` bigint(0) NOT NULL COMMENT '所属节点ID',
  `attr_max` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_buf_mode` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_buf_conf` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `CREATED_BY` int(0) NULL DEFAULT 0 COMMENT '创建人',
  `CREATED_TIME` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `q2`(`scd_id`) USING BTREE,
  INDEX `q1`(`node_id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 3352 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'ConfReportControl节点属性' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for t_scd_connectedap_attrs
-- ----------------------------
DROP TABLE IF EXISTS `t_scd_connectedap_attrs`;
CREATE TABLE `t_scd_connectedap_attrs`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `scd_id` bigint(0) NOT NULL,
  `node_id` bigint(0) NOT NULL COMMENT '所属节点ID',
  `attr_ied_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `attr_ap_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `attr_desc` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `CREATED_BY` int(0) NULL DEFAULT 0 COMMENT '创建人',
  `CREATED_TIME` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `w1`(`scd_id`) USING BTREE,
  INDEX `w2`(`node_id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 11257 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'ConnectedAP节点属性' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for t_scd_connectedap_smv_attrs
-- ----------------------------
DROP TABLE IF EXISTS `t_scd_connectedap_smv_attrs`;
CREATE TABLE `t_scd_connectedap_smv_attrs`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `scd_id` bigint(0) NOT NULL,
  `node_id` bigint(0) NOT NULL COMMENT '所属节点ID',
  `attr_ld_inst` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_cb_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_desc` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `CREATED_BY` int(0) NULL DEFAULT 0 COMMENT '创建人',
  `CREATED_TIME` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `w1`(`scd_id`) USING BTREE,
  INDEX `w2`(`node_id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1000 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'ConnectedAP节点SMV节点属性' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for t_scd_da_attrs
-- ----------------------------
DROP TABLE IF EXISTS `t_scd_da_attrs`;
CREATE TABLE `t_scd_da_attrs`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `scd_id` bigint(0) NOT NULL,
  `node_id` bigint(0) NOT NULL COMMENT '所属节点ID',
  `attr_desc` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_type` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `attr_saddr` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_btype` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `attr_val_kind` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_count` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_dchg` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_qchg` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_dupd` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_fc` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `CREATED_BY` int(0) NULL DEFAULT 0 COMMENT '创建人',
  `CREATED_TIME` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `q1`(`scd_id`) USING BTREE,
  INDEX `q2`(`node_id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 152737 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'DA节点属性' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for t_scd_dai_attrs
-- ----------------------------
DROP TABLE IF EXISTS `t_scd_dai_attrs`;
CREATE TABLE `t_scd_dai_attrs`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `scd_id` bigint(0) NOT NULL,
  `node_id` bigint(0) NOT NULL COMMENT '所属节点ID',
  `attr_name` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `attr_desc` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_ix` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_saddr` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_val_kind` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `CREATED_BY` int(0) NULL DEFAULT 0 COMMENT '创建人',
  `CREATED_TIME` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `q1`(`scd_id`) USING BTREE,
  INDEX `q2`(`node_id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 16790370 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'DAI节点属性' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for t_scd_dataset_attrs
-- ----------------------------
DROP TABLE IF EXISTS `t_scd_dataset_attrs`;
CREATE TABLE `t_scd_dataset_attrs`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `scd_id` bigint(0) NOT NULL,
  `node_id` bigint(0) NOT NULL COMMENT '所属节点ID',
  `attr_name` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_desc` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `CREATED_BY` int(0) NULL DEFAULT 0 COMMENT '创建人',
  `CREATED_TIME` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `q1`(`scd_id`) USING BTREE,
  INDEX `q2`(`node_id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 60526 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'DataSet节点属性' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for t_scd_datype_attrs
-- ----------------------------
DROP TABLE IF EXISTS `t_scd_datype_attrs`;
CREATE TABLE `t_scd_datype_attrs`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `scd_id` bigint(0) NOT NULL,
  `node_id` bigint(0) NOT NULL COMMENT '所属节点ID',
  `attr_desc` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_ied_type` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `CREATED_BY` int(0) NULL DEFAULT 0 COMMENT '创建人',
  `CREATED_TIME` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `q1`(`scd_id`) USING BTREE,
  INDEX `q2`(`node_id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 3807 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'DAType节点属性' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for t_scd_diff_compare
-- ----------------------------
DROP TABLE IF EXISTS `t_scd_diff_compare`;
CREATE TABLE `t_scd_diff_compare`  (
  `id` bigint(0) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '本次对比名称',
  `file_type` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '对比的文件类型;scdicd',
  `source_id` bigint(0) NOT NULL DEFAULT 0 COMMENT '对比源文件ID',
  `source_file` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `target_id` bigint(0) NOT NULL DEFAULT 0 COMMENT '对比目标文件ID',
  `target_file` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `node_state` int(0) NULL DEFAULT 0 COMMENT '节点对比完成状态',
  `attr_state` int(0) NULL DEFAULT 0 COMMENT '节点属性对比完成状态',
  `station_id` int(0) NULL DEFAULT 0 COMMENT '变电站ID',
  `CREATED_BY` int(0) NOT NULL DEFAULT 0 COMMENT '创建人',
  `CREATED_TIME` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'SCD文件差异对比表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for t_scd_diff_compare_detail
-- ----------------------------
DROP TABLE IF EXISTS `t_scd_diff_compare_detail`;
CREATE TABLE `t_scd_diff_compare_detail`  (
  `id` bigint(0) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `compare_id` bigint(0) NOT NULL COMMENT '对比记录ID',
  `diff_object_type` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '发生差异的对象类型',
  `diff_object_node_id` bigint(0) NULL DEFAULT 0 COMMENT '发生差异的节点对象ID',
  `diff_source_node_id` bigint(0) NULL DEFAULT 0 COMMENT '比对源SCD文件节点ID',
  `ied_name` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT 'IED',
  `ied_desc` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT 'IED描述',
  `diff_object_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '发生差异的节点名称',
  `source_line_no` bigint(0) NULL DEFAULT 0,
  `object_line_no` bigint(0) NULL DEFAULT 0,
  `diff_opt` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '发生差异的操作;iud',
  `diff_desc` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '差异描述',
  `CREATED_BY` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '0' COMMENT '创建人',
  `CREATED_TIME` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `ind1`(`compare_id`) USING BTREE,
  INDEX `ind4`(`diff_object_type`) USING BTREE,
  INDEX `ind5`(`ied_name`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '差异对比结果详情' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for t_scd_diff_compare_stat
-- ----------------------------
DROP TABLE IF EXISTS `t_scd_diff_compare_stat`;
CREATE TABLE `t_scd_diff_compare_stat`  (
  `id` bigint(0) NOT NULL AUTO_INCREMENT COMMENT '主銉',
  `compare_id` int(0) NOT NULL COMMENT '比对记录ID',
  `scd_id` bigint(0) NOT NULL COMMENT '比对SCDID',
  `node_id` bigint(0) NOT NULL COMMENT '分类节点ID',
  `diff_opt` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '差异操作类型',
  `area_id` int(0) NULL DEFAULT 0 COMMENT '间隔ID;仅对IED分类',
  `voltage_level` int(0) NULL DEFAULT 0 COMMENT '电压等级ID;仅对IED分类',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `ind1`(`compare_id`) USING BTREE,
  INDEX `ind2`(`scd_id`) USING BTREE,
  INDEX `ind3`(`node_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 182 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'scd一致性比对结果分类汇总统计' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for t_scd_do_attrs
-- ----------------------------
DROP TABLE IF EXISTS `t_scd_do_attrs`;
CREATE TABLE `t_scd_do_attrs`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `scd_id` bigint(0) NOT NULL,
  `node_id` bigint(0) NOT NULL COMMENT '所属节点ID',
  `attr_name` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `attr_desc` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_type` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_access_control` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_transient` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `CREATED_BY` int(0) NULL DEFAULT 0 COMMENT '创建人',
  `CREATED_TIME` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `q1`(`scd_id`) USING BTREE,
  INDEX `q2`(`node_id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 659326 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'DO节点属性' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for t_scd_doi_attrs
-- ----------------------------
DROP TABLE IF EXISTS `t_scd_doi_attrs`;
CREATE TABLE `t_scd_doi_attrs`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `scd_id` bigint(0) NOT NULL,
  `node_id` bigint(0) NOT NULL COMMENT '所属节点ID',
  `attr_name` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `attr_desc` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_ix` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_access_control` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `CREATED_BY` int(0) NULL DEFAULT 0 COMMENT '创建人',
  `CREATED_TIME` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `q1`(`scd_id`) USING BTREE,
  INDEX `q2`(`node_id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 5777710 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'DOI节点属性' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for t_scd_dotype_attrs
-- ----------------------------
DROP TABLE IF EXISTS `t_scd_dotype_attrs`;
CREATE TABLE `t_scd_dotype_attrs`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `scd_id` bigint(0) NOT NULL,
  `node_id` bigint(0) NOT NULL COMMENT '所属节点ID',
  `attr_id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `attr_desc` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_ied_type` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_cdc` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `CREATED_BY` int(0) NULL DEFAULT 0 COMMENT '创建人',
  `CREATED_TIME` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `q1`(`scd_id`) USING BTREE,
  INDEX `q2`(`node_id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 18822 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'DOType节点属性' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for t_scd_dynassociation_attrs
-- ----------------------------
DROP TABLE IF EXISTS `t_scd_dynassociation_attrs`;
CREATE TABLE `t_scd_dynassociation_attrs`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `scd_id` bigint(0) NOT NULL,
  `node_id` bigint(0) NOT NULL COMMENT '所属节点ID',
  `attr_max` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `CREATED_BY` int(0) NULL DEFAULT 0 COMMENT '创建人',
  `CREATED_TIME` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `q1`(`scd_id`) USING BTREE,
  INDEX `q2`(`scd_id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'DynAssociation节点属性' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for t_scd_dyndataset_attrs
-- ----------------------------
DROP TABLE IF EXISTS `t_scd_dyndataset_attrs`;
CREATE TABLE `t_scd_dyndataset_attrs`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `scd_id` bigint(0) NOT NULL,
  `node_id` bigint(0) NOT NULL COMMENT '所属节点ID',
  `attr_max` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_max_attributes` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `CREATED_BY` int(0) NULL DEFAULT 0 COMMENT '创建人',
  `CREATED_TIME` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `q1`(`scd_id`) USING BTREE,
  INDEX `q2`(`node_id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 381 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'DynDataSet节点属性' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for t_scd_enumtype_attrs
-- ----------------------------
DROP TABLE IF EXISTS `t_scd_enumtype_attrs`;
CREATE TABLE `t_scd_enumtype_attrs`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `scd_id` bigint(0) NOT NULL,
  `node_id` bigint(0) NOT NULL COMMENT '所属节点ID',
  `attr_id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `attr_desc` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `CREATED_BY` int(0) NULL DEFAULT 0 COMMENT '创建人',
  `CREATED_TIME` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `q1`(`scd_id`) USING BTREE,
  INDEX `q2`(`node_id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 3229 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'EnumType节点属性' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for t_scd_enumval_attrs
-- ----------------------------
DROP TABLE IF EXISTS `t_scd_enumval_attrs`;
CREATE TABLE `t_scd_enumval_attrs`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `scd_id` bigint(0) NOT NULL,
  `node_id` bigint(0) NOT NULL COMMENT '所属节点ID',
  `attr_ord` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `attr_desc` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `CREATED_BY` int(0) NULL DEFAULT 0 COMMENT '创建人',
  `CREATED_TIME` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `q1`(`scd_id`) USING BTREE,
  INDEX `q2`(`node_id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 62567 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'EnumVal节点属性' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for t_scd_extref_attrs
-- ----------------------------
DROP TABLE IF EXISTS `t_scd_extref_attrs`;
CREATE TABLE `t_scd_extref_attrs`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `scd_id` bigint(0) NOT NULL,
  `node_id` bigint(0) NOT NULL COMMENT '所属节点ID',
  `attr_ld_inst` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_prefix` varchar(12) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_ln_class` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_ln_inst` varchar(14) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_do_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_da_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_ied_name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_desc` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_int_addr` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `CREATED_BY` int(0) NULL DEFAULT 0 COMMENT '创建人',
  `CREATED_TIME` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `q1`(`scd_id`) USING BTREE,
  INDEX `q2`(`node_id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 162932 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'ExtRef节点属性' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for t_scd_fccb_attrs
-- ----------------------------
DROP TABLE IF EXISTS `t_scd_fccb_attrs`;
CREATE TABLE `t_scd_fccb_attrs`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `scd_id` bigint(0) NOT NULL,
  `node_id` bigint(0) NOT NULL COMMENT '所属节点ID',
  `attr_ld_inst` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_prefix` varchar(12) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_ln_class` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_ln_inst` varchar(14) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_cb_name` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_da_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_fc` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_must_understand` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `CREATED_BY` int(0) NULL DEFAULT 0 COMMENT '创建人',
  `CREATED_TIME` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `q1`(`scd_id`) USING BTREE,
  INDEX `q2`(`node_id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'FCCB节点属性' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for t_scd_fcda_attrs
-- ----------------------------
DROP TABLE IF EXISTS `t_scd_fcda_attrs`;
CREATE TABLE `t_scd_fcda_attrs`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `scd_id` bigint(0) NOT NULL,
  `node_id` bigint(0) NOT NULL COMMENT '所属节点ID',
  `attr_ld_inst` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_prefix` varchar(12) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_ln_class` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_ln_inst` varchar(14) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_do_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_da_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_fc` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_ix` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `CREATED_BY` int(0) NULL DEFAULT 0 COMMENT '创建人',
  `CREATED_TIME` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `q1`(`scd_id`) USING BTREE,
  INDEX `q2`(`node_id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 2478075 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'FCDA节点属性' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for t_scd_goose_attrs
-- ----------------------------
DROP TABLE IF EXISTS `t_scd_goose_attrs`;
CREATE TABLE `t_scd_goose_attrs`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `scd_id` bigint(0) NOT NULL,
  `node_id` bigint(0) NOT NULL COMMENT '所属节点ID',
  `attr_max` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `CREATED_BY` int(0) NULL DEFAULT 0 COMMENT '创建人',
  `CREATED_TIME` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `q1`(`scd_id`) USING BTREE,
  INDEX `q2`(`node_id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 4600 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'GOOSE节点属性' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for t_scd_goosesecurity_attrs
-- ----------------------------
DROP TABLE IF EXISTS `t_scd_goosesecurity_attrs`;
CREATE TABLE `t_scd_goosesecurity_attrs`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `scd_id` bigint(0) NOT NULL,
  `node_id` bigint(0) NOT NULL COMMENT '所属节点ID',
  `attr_name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `attr_desc` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_xfer_number` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_serial_number` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `CREATED_BY` int(0) NULL DEFAULT 0 COMMENT '创建人',
  `CREATED_TIME` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `q1`(`scd_id`) USING BTREE,
  INDEX `q2`(`node_id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'GOOSESecurity节点属性' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for t_scd_gse_attrs
-- ----------------------------
DROP TABLE IF EXISTS `t_scd_gse_attrs`;
CREATE TABLE `t_scd_gse_attrs`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `scd_id` bigint(0) NOT NULL,
  `node_id` bigint(0) NOT NULL COMMENT '所属节点ID',
  `attr_ld_inst` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_cb_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_desc` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `CREATED_BY` int(0) NULL DEFAULT 0 COMMENT '创建人',
  `CREATED_TIME` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `w1`(`scd_id`) USING BTREE,
  INDEX `w11`(`node_id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 14247 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'GSE节点属性' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for t_scd_gsecontrol_attrs
-- ----------------------------
DROP TABLE IF EXISTS `t_scd_gsecontrol_attrs`;
CREATE TABLE `t_scd_gsecontrol_attrs`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `scd_id` bigint(0) NOT NULL,
  `node_id` bigint(0) NOT NULL COMMENT '所属节点ID',
  `attr_name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `attr_desc` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_dat_set` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_conf_rev` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `attr_type` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_appid` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `CREATED_BY` int(0) NULL DEFAULT 0 COMMENT '创建人',
  `CREATED_TIME` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `q1`(`scd_id`) USING BTREE,
  INDEX `q2`(`node_id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 14431 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'GSEControl节点属性' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for t_scd_gsesettings_attrs
-- ----------------------------
DROP TABLE IF EXISTS `t_scd_gsesettings_attrs`;
CREATE TABLE `t_scd_gsesettings_attrs`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `scd_id` bigint(0) NOT NULL,
  `node_id` bigint(0) NOT NULL COMMENT '所属节点ID',
  `attr_cb_name` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_dat_set` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_app_id` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_data_label` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `CREATED_BY` int(0) NULL DEFAULT 0 COMMENT '创建人',
  `CREATED_TIME` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `q1`(`scd_id`) USING BTREE,
  INDEX `q2`(`node_id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1143 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'GSESettings节点属性' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for t_scd_gsse_attrs
-- ----------------------------
DROP TABLE IF EXISTS `t_scd_gsse_attrs`;
CREATE TABLE `t_scd_gsse_attrs`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `scd_id` bigint(0) NOT NULL,
  `node_id` bigint(0) NOT NULL COMMENT '所属节点ID',
  `attr_max` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `CREATED_BY` int(0) NULL DEFAULT 0 COMMENT '创建人',
  `CREATED_TIME` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `q1`(`scd_id`) USING BTREE,
  INDEX `q2`(`node_id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'GSSE节点属性' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for t_scd_header_attrs
-- ----------------------------
DROP TABLE IF EXISTS `t_scd_header_attrs`;
CREATE TABLE `t_scd_header_attrs`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `scd_id` bigint(0) NOT NULL,
  `node_id` bigint(0) NOT NULL COMMENT '所属节点ID',
  `attr_id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_version` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_reversion` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_toolid` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_namestructure` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `CREATED_BY` int(0) NULL DEFAULT 0 COMMENT '创建人',
  `CREATED_TIME` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `ind1`(`node_id`) USING BTREE,
  INDEX `ind2`(`scd_id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 55 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'Header节点属性' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for t_scd_hitem_attrs
-- ----------------------------
DROP TABLE IF EXISTS `t_scd_hitem_attrs`;
CREATE TABLE `t_scd_hitem_attrs`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `scd_id` bigint(0) NOT NULL,
  `node_id` int(0) NOT NULL COMMENT '所属节点ID',
  `attr_version` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_revision` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_when` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_who` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_what` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_why` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `CREATED_BY` int(0) NULL DEFAULT 0 COMMENT '创建人',
  `CREATED_TIME` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `ind1`(`scd_id`) USING BTREE,
  INDEX `ind2`(`node_id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 301 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'Hitem节点属性' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for t_scd_ied_attrs
-- ----------------------------
DROP TABLE IF EXISTS `t_scd_ied_attrs`;
CREATE TABLE `t_scd_ied_attrs`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `scd_id` bigint(0) NOT NULL,
  `node_id` bigint(0) NOT NULL COMMENT '所属节点ID',
  `attr_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_desc` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_manufacturer` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_config_version` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_original_scl_version` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_original_scl_revision` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_type` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_eng_right` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_owner` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `CREATED_BY` int(0) NULL DEFAULT 0 COMMENT '创建人',
  `CREATED_TIME` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `w1`(`scd_id`) USING BTREE,
  INDEX `w2`(`node_id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 6010 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'IED节点属性' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for t_scd_ied_ctrl_inputs_ref
-- ----------------------------
DROP TABLE IF EXISTS `t_scd_ied_ctrl_inputs_ref`;
CREATE TABLE `t_scd_ied_ctrl_inputs_ref`  (
  `id` bigint(0) NOT NULL AUTO_INCREMENT COMMENT '主建',
  `scd_id` bigint(0) NOT NULL COMMENT 'SCD文件编号',
  `m_ied_name` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '源IED名称',
  `s_ied_name` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '目标IED名称',
  `m_ctrlid` bigint(0) NOT NULL DEFAULT 0 COMMENT '源控制块ID',
  `s_ctrlid` bigint(0) NOT NULL DEFAULT 0 COMMENT '目标控制块ID',
  `fcda_id` bigint(0) NOT NULL DEFAULT 0 COMMENT '虚端子ID',
  `fcda_node_id` bigint(0) NOT NULL DEFAULT 0 COMMENT '虚端子节点ID',
  `from_doi_desc` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '',
  `from_ied` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '',
  `from_ln_desc` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '',
  `to_doi_desc` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '',
  `to_ied` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '',
  `to_ln_desc` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '',
  `attr_ld_inst` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '',
  `attr_ln_class` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '',
  `attr_ln_inst` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '',
  `attr_prefix` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '',
  `attr_ix` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '',
  `attr_int_addr` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '',
  `attr_fc` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '',
  `attr_do_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '',
  `attr_da_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `ind1`(`scd_id`) USING BTREE,
  INDEX `ind2`(`m_ied_name`) USING BTREE,
  INDEX `ind3`(`s_ied_name`) USING BTREE,
  INDEX `ind4`(`m_ctrlid`) USING BTREE,
  INDEX `ind5`(`s_ctrlid`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 225 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'IED控制块虚端子输入输出关系' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for t_scd_ied_network_info
-- ----------------------------
DROP TABLE IF EXISTS `t_scd_ied_network_info`;
CREATE TABLE `t_scd_ied_network_info`  (
  `id` bigint(0) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `scd_id` bigint(0) NOT NULL,
  `ied_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `subnetwork_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `subnetwork_desc` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `subnetwork_type` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `ap_name` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `ap_node_id` bigint(0) NULL DEFAULT NULL,
  `net_type` varchar(3) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `net_node_id` bigint(0) NULL DEFAULT NULL,
  `cb_name` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `address_json` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `ld_inst` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `ind1`(`scd_id`) USING BTREE,
  INDEX `ind2`(`ied_name`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 153 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'IED网络信息表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for t_scd_ied_node_parents_info
-- ----------------------------
DROP TABLE IF EXISTS `t_scd_ied_node_parents_info`;
CREATE TABLE `t_scd_ied_node_parents_info`  (
  `node_id` bigint(0) NOT NULL COMMENT '节点ID',
  `node_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '节点名称',
  `scd_id` bigint(0) NOT NULL DEFAULT 0 COMMENT '所属scd ID',
  `path_ids` varchar(900) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '父节点路径',
  `path_names` varchar(900) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '父节点全名称',
  `path_attr_values` varchar(900) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '在IED下的唯一属性值',
  `CREATED_BY` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0' COMMENT '创建人',
  `CREATED_TIME` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`node_id`, `scd_id`) USING BTREE,
  INDEX `ind1`(`scd_id`) USING BTREE,
  INDEX `ind2`(`node_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'ied下级节点的父节点信息' ROW_FORMAT = Dynamic PARTITION BY KEY (`scd_id`)
PARTITIONS 100
(PARTITION `p0` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p1` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p10` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p100` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p101` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p102` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p103` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p104` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p105` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p106` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p107` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p108` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p109` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p11` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p110` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p111` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p112` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p113` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p114` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p115` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p116` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p117` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p118` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p119` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p12` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p120` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p121` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p122` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p123` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p124` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p125` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p126` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p127` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p128` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p129` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p13` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p130` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p131` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p132` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p133` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p134` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p135` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p136` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p137` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p138` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p139` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p14` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p140` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p141` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p142` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p143` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p144` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p145` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p146` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p147` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p148` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p149` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p15` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p150` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p151` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p152` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p153` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p154` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p155` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p156` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p157` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p158` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p159` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p16` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p160` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p161` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p162` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p163` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p164` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p165` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p166` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p167` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p168` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p169` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p17` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p170` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p171` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p172` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p173` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p174` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p175` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p176` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p177` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p178` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p179` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p18` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p180` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p181` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p182` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p183` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p184` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p185` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p186` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p187` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p188` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 )
;

-- ----------------------------
-- Table structure for t_scd_inputs_attrs
-- ----------------------------
DROP TABLE IF EXISTS `t_scd_inputs_attrs`;
CREATE TABLE `t_scd_inputs_attrs`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `scd_id` bigint(0) NOT NULL,
  `node_id` bigint(0) NOT NULL COMMENT '所属节点ID',
  `attr_desc` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `CREATED_BY` int(0) NULL DEFAULT 0 COMMENT '创建人',
  `CREATED_TIME` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `q1`(`scd_id`) USING BTREE,
  INDEX `q2`(`node_id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 643 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'Inputs节点属性' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for t_scd_issuername_attrs
-- ----------------------------
DROP TABLE IF EXISTS `t_scd_issuername_attrs`;
CREATE TABLE `t_scd_issuername_attrs`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `scd_id` bigint(0) NOT NULL,
  `node_id` bigint(0) NOT NULL COMMENT '所属节点ID',
  `attr_common_name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `attr_id_hierarchy` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `CREATED_BY` int(0) NULL DEFAULT 0 COMMENT '创建人',
  `CREATED_TIME` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `q1`(`scd_id`) USING BTREE,
  INDEX `q2`(`node_id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'IssuerName节点属性' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for t_scd_ldevice_attrs
-- ----------------------------
DROP TABLE IF EXISTS `t_scd_ldevice_attrs`;
CREATE TABLE `t_scd_ldevice_attrs`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `scd_id` bigint(0) NOT NULL,
  `node_id` bigint(0) NOT NULL COMMENT '所属节点ID',
  `attr_inst` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_desc` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_ld_name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `CREATED_BY` int(0) NULL DEFAULT 0 COMMENT '创建人',
  `CREATED_TIME` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `q1`(`scd_id`) USING BTREE,
  INDEX `q2`(`node_id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 17001 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'LDevice节点属性' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for t_scd_ln0_attrs
-- ----------------------------
DROP TABLE IF EXISTS `t_scd_ln0_attrs`;
CREATE TABLE `t_scd_ln0_attrs`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `scd_id` bigint(0) NOT NULL,
  `node_id` bigint(0) NOT NULL COMMENT '所属节点ID',
  `attr_inst` varchar(63) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_ln_type` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_desc` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_ln_class` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `CREATED_BY` int(0) NULL DEFAULT 0 COMMENT '创建人',
  `CREATED_TIME` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `q1`(`scd_id`) USING BTREE,
  INDEX `q2`(`node_id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 17001 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'LN0节点属性' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for t_scd_ln_attrs
-- ----------------------------
DROP TABLE IF EXISTS `t_scd_ln_attrs`;
CREATE TABLE `t_scd_ln_attrs`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `scd_id` bigint(0) NOT NULL,
  `node_id` bigint(0) NOT NULL COMMENT '所属节点ID',
  `attr_desc` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_ln_type` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `attr_ln_class` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `attr_inst` varchar(14) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `attr_prefix` varchar(12) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `join_str` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `CREATED_BY` int(0) NULL DEFAULT 0 COMMENT '创建人',
  `CREATED_TIME` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `q1`(`scd_id`) USING BTREE,
  INDEX `q2`(`node_id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 569343 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'LN节点属性' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for t_scd_lnodetype_attrs
-- ----------------------------
DROP TABLE IF EXISTS `t_scd_lnodetype_attrs`;
CREATE TABLE `t_scd_lnodetype_attrs`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `scd_id` bigint(0) NOT NULL,
  `node_id` bigint(0) NOT NULL COMMENT '所属节点ID',
  `attr_id` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `attr_desc` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_ied_type` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_ln_class` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `CREATED_BY` int(0) NULL DEFAULT 0 COMMENT '创建人',
  `CREATED_TIME` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `q1`(`scd_id`) USING BTREE,
  INDEX `q2`(`node_id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 38509 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'LNodeType节点属性' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for t_scd_log_attrs
-- ----------------------------
DROP TABLE IF EXISTS `t_scd_log_attrs`;
CREATE TABLE `t_scd_log_attrs`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `scd_id` bigint(0) NOT NULL,
  `node_id` bigint(0) NOT NULL COMMENT '所属节点ID',
  `attr_name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `CREATED_BY` int(0) NULL DEFAULT 0 COMMENT '创建人',
  `CREATED_TIME` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `q1`(`scd_id`) USING BTREE,
  INDEX `q2`(`node_id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'Log节点属性' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for t_scd_logcontrol_attrs
-- ----------------------------
DROP TABLE IF EXISTS `t_scd_logcontrol_attrs`;
CREATE TABLE `t_scd_logcontrol_attrs`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `scd_id` bigint(0) NOT NULL,
  `node_id` bigint(0) NOT NULL COMMENT '所属节点ID',
  `attr_name` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `attr_desc` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_ld_inst` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_prefix` varchar(12) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_ln_class` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_ln_inst` varchar(14) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_dat_set` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_intg_pd` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_log_name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_log_ena` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_reason_code` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `CREATED_BY` int(0) NULL DEFAULT 0 COMMENT '创建人',
  `CREATED_TIME` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `q1`(`scd_id`) USING BTREE,
  INDEX `q2`(`node_id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 2783 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'LogControl节点属性' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for t_scd_logsettings_attrs
-- ----------------------------
DROP TABLE IF EXISTS `t_scd_logsettings_attrs`;
CREATE TABLE `t_scd_logsettings_attrs`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `scd_id` bigint(0) NOT NULL,
  `node_id` bigint(0) NOT NULL COMMENT '所属节点ID',
  `attr_cb_name` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_dat_set` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_log_ena` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_trg_ops` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_intg_pd` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `CREATED_BY` int(0) NULL DEFAULT 0 COMMENT '创建人',
  `CREATED_TIME` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `q1`(`scd_id`) USING BTREE,
  INDEX `q2`(`node_id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1811 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'LogSettings节点属性' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for t_scd_maxtime_attrs
-- ----------------------------
DROP TABLE IF EXISTS `t_scd_maxtime_attrs`;
CREATE TABLE `t_scd_maxtime_attrs`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `scd_id` bigint(0) NOT NULL,
  `node_id` bigint(0) NOT NULL COMMENT '所属节点ID',
  `attr_unit` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_multiplier` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `CREATED_BY` int(0) NULL DEFAULT 0 COMMENT '创建人',
  `CREATED_TIME` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `w1`(`scd_id`) USING BTREE,
  INDEX `w2`(`node_id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 21868 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'MaxTime节点属性' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for t_scd_mintime_attrs
-- ----------------------------
DROP TABLE IF EXISTS `t_scd_mintime_attrs`;
CREATE TABLE `t_scd_mintime_attrs`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `scd_id` bigint(0) NOT NULL,
  `node_id` bigint(0) NOT NULL COMMENT '所属节点ID',
  `attr_unit` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_multiplier` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `CREATED_BY` int(0) NULL DEFAULT 0 COMMENT '创建人',
  `CREATED_TIME` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `w1`(`scd_id`) USING BTREE,
  INDEX `w2`(`node_id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 21868 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'MinTime节点属性' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for t_scd_node_check
-- ----------------------------
DROP TABLE IF EXISTS `t_scd_node_check`;
CREATE TABLE `t_scd_node_check`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `check_desc` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '验证描述',
  `check_object` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '被检查对象;node.attr表示是属性；node表示是节点',
  `check_area` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '检查范围;默认为全局。可指定节点/下级节点',
  `is_exists` int(0) NULL DEFAULT NULL COMMENT '引用对象是否存在;检查指定的引用对象是否存在',
  `is_ref` int(0) NULL DEFAULT NULL COMMENT '对象是否被引用;检查对象是否被引用',
  `is_unique` int(0) NULL DEFAULT NULL COMMENT '节点内容是否重复',
  `hint_text` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `enable` int(0) NULL DEFAULT 1 COMMENT '启动状态',
  `alert_level` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `CREATED_BY` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建人',
  `CREATED_TIME` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `ind1`(`check_object`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 33 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '节点有效性验证定义' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of t_scd_node_check
-- ----------------------------
INSERT INTO `t_scd_node_check` VALUES (1, '', 'LNodeType:LNodeType.attr_id', 'LN0.attr_ln_type,LN.attr_ln_type', 0, 1, 0, '警告 C0701: 未引用的LNodeType id=%s', 1, 'waring', NULL, NULL);
INSERT INTO `t_scd_node_check` VALUES (2, '', 'DOType:DOType.attr_id', 'DO.attr_type,SDO.attr_type', 0, 1, 0, '警告 C0702: 未引用的DOType id=%s', 1, 'waring', NULL, NULL);
INSERT INTO `t_scd_node_check` VALUES (3, '', 'DAType:DAType.attr_id', 'DA.attr_type,BDA.attr_type', 0, 1, 0, '警告 C0703: 未引用的DAType id=%s', 1, 'waring', NULL, NULL);
INSERT INTO `t_scd_node_check` VALUES (4, '', 'EnumType:EnumType.attr_id', 'DA.attr_type,BDA.attr_type', 0, 1, 0, '警告 C0704: 未引用的EnumType id=%s', 1, 'waring', NULL, NULL);
INSERT INTO `t_scd_node_check` VALUES (5, '', 'LNodeType:LNodeType', '', 0, 0, 1, '警告 C0705', 1, 'waring', NULL, NULL);
INSERT INTO `t_scd_node_check` VALUES (6, '', 'DOType:DOType', '', 0, 0, 1, '警告 C0706', 1, 'waring', NULL, NULL);
INSERT INTO `t_scd_node_check` VALUES (7, '', 'DAType:DAType', '', 0, 0, 1, '警告 C0707', 1, 'waring', NULL, NULL);
INSERT INTO `t_scd_node_check` VALUES (32, '校验SubNetwork节点下ConnectedAP是否重复', 'ConnectedAP:ConnectedAP', '', 0, 0, 1, '错误：ConnectedAP %s 存在多个相同定义', 1, 'error', '0', '2022-10-05 10:15:38');
INSERT INTO `t_scd_node_check` VALUES (9, '', 'LN0:LN0.attr_ln_type', 'LNodeType.attr_id', 1, 0, 0, '警告 C0709：LN0 InType %s 在LNodeType中未定义', 1, 'error', NULL, NULL);
INSERT INTO `t_scd_node_check` VALUES (10, '', 'LN:LN.attr_ln_type', 'LNodeType.attr_id', 1, 0, 0, '警告 C0709：LN InType %s 在LNodeType中未定义', 1, 'error', NULL, NULL);
INSERT INTO `t_scd_node_check` VALUES (11, '', 'DO:DO.attr_type', 'DOType.attr_id', 1, 0, 0, '警告 C070A：DO Type %s 在DOType中未定义', 1, 'error', NULL, NULL);
INSERT INTO `t_scd_node_check` VALUES (12, '', 'SDO:SDO.attr_type', 'DOType.attr_id', 1, 0, 0, '警告 C070A：SDO Type %s 在DOType中未定义', 1, 'error', NULL, NULL);
INSERT INTO `t_scd_node_check` VALUES (13, '', 'DA:DA.attr_type|DA.attr_btype=\'Struct\'', 'DAType.attr_id', 1, 0, 0, '警告 C070B：DA Type %s 在DAType中未定义', 1, 'error', NULL, NULL);
INSERT INTO `t_scd_node_check` VALUES (14, '', 'DA:DA.attr_type|DA.attr_btype=\'Enum\'', 'EnumType.attr_id', 1, 0, 0, '警告 C070B：DA Type %s 在DAType中未定义', 1, 'error', NULL, NULL);
INSERT INTO `t_scd_node_check` VALUES (16, '', 'BDA:BDA.attr_type|BDA.attr_btype=\'Enum\'', 'EnumType.attr_id', 1, 0, 0, '警告 C070B：BDA Type %s 在DAType中未定义', 1, 'error', NULL, NULL);
INSERT INTO `t_scd_node_check` VALUES (15, '', 'BDA:BDA.attr_type|BDA.attr_btype=\'Struct\'', 'DAType.attr_id', 1, 0, 0, '警告 C070B：BDA Type %s 在DAType中未定义', 1, 'error', NULL, NULL);
INSERT INTO `t_scd_node_check` VALUES (17, '', 'DA:DA.attr_btype=\'Struct\'|DA.attr_type=\'\'', '', 0, 0, 0, '警告 C070E：DA  %s type属性不能为空', 1, 'error', NULL, NULL);
INSERT INTO `t_scd_node_check` VALUES (18, '', 'DA:DA.attr_btype=\'Enum\'|DA.attr_type=\'\'', '', 0, 0, 0, '警告 C070E：DA  %s type属性不能为空', 1, 'error', NULL, NULL);
INSERT INTO `t_scd_node_check` VALUES (19, '', 'BDA:BDA.attr_btype=\'Enum\'|BDA.attr_type=\'\'', '', 0, 0, 0, '警告 C070E：BDA  %s type属性不能为空', 1, 'error', NULL, NULL);
INSERT INTO `t_scd_node_check` VALUES (20, '', 'BDA:BDA.attr_btype=\'Struct\'|BDA.attr_type=\'\'', '', 0, 0, 0, '警告 C070E：BDA  %s type属性不能为空', 1, 'error', NULL, NULL);
INSERT INTO `t_scd_node_check` VALUES (21, '', 'FCDA:FCDA.InClass', '', 0, 0, 0, '警告 C0710：FCDA= %s is not correct', 0, 'error', '0', '2022-10-05 10:07:23');
INSERT INTO `t_scd_node_check` VALUES (22, '', 'DA:DOType.attr_cdc=\'BSC\'>DA.attr_name=\'ctlVal\'|DA.attr_btype=\'Tcmd\'', '', 0, 0, 0, '警告 C0711：DOType %s的btype值错误，正确值应该为Tcmd', 1, 'error', NULL, NULL);
INSERT INTO `t_scd_node_check` VALUES (23, '', 'all:*=EntryTime', '', 0, 0, 0, '警告 C0713：EntryTime已废弃，请用Timestamp替换', 1, 'hint', NULL, NULL);
INSERT INTO `t_scd_node_check` VALUES (24, '', 'ReportControl:ReportControl.attr_name=ReportControl.attr_dat_set', '', 0, 0, 0, '警告 C0715：ReportContro %s中的属性name和datSet同名', 1, 'error', NULL, NULL);
INSERT INTO `t_scd_node_check` VALUES (26, '', 'ConnectedAP:ConnectedAP.attr_ied_name', 'IED.attr_name', 0, 1, 0, '警告 ：ConnectedAP iedName %s 在IED中未被定义', 1, 'waring', NULL, NULL);
INSERT INTO `t_scd_node_check` VALUES (27, '', 'ConnectedAP:ConnectedAP.attr_ap_name', 'AccessPoint.attr_name', 0, 1, 0, '警告 ：ConnectedAP apName %s 在AccessPoint中未被引用', 1, 'waring', NULL, NULL);
INSERT INTO `t_scd_node_check` VALUES (31, '这是一个测试规则', 'test:test', 'sdfsfs', 1, 0, 0, '这是一个测试规则', 0, 'hint', '0', '2022-10-05 10:06:34');

-- ----------------------------
-- Table structure for t_scd_node_rule_parse
-- ----------------------------
DROP TABLE IF EXISTS `t_scd_node_rule_parse`;
CREATE TABLE `t_scd_node_rule_parse`  (
  `id` bigint(0) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `scd_id` bigint(0) NOT NULL COMMENT 'SCD文件编号',
  `node_id` bigint(0) NULL DEFAULT NULL COMMENT 'scd节点编号',
  `line_no` bigint(0) NULL DEFAULT 0 COMMENT '行号',
  `ied_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '装置名称。装置校验结果才有值',
  `ied_desc` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '',
  `rule_target` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '规则对象;node:节点规则 attr:节点属性',
  `rule_id` int(0) NOT NULL COMMENT '规则编号',
  `parse_result` varchar(1024) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '解析结果描述;一般失败才记录结果',
  `line_xml` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '校验行源文',
  `CREATED_BY` int(0) NULL DEFAULT 0 COMMENT '创建人',
  `CREATED_TIME` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `ind1`(`scd_id`) USING BTREE,
  INDEX `ind2`(`node_id`) USING BTREE,
  INDEX `ind3`(`rule_id`) USING BTREE,
  INDEX `ind4`(`ied_name`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '节点规则解析结果表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for t_scd_node_scl
-- ----------------------------
DROP TABLE IF EXISTS `t_scd_node_scl`;
CREATE TABLE `t_scd_node_scl`  (
  `id` bigint(0) NOT NULL COMMENT '主键',
  `scd_id` bigint(0) NOT NULL,
  `parent_node_id` int(0) NULL DEFAULT NULL,
  `node_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `node_value` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `ied_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'IED名称;仅IED下属节点才需要该属性',
  `ied_type` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'IED TYPE;仅IED下属节点才需要该属性',
  `node_path` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '节点全路径ID',
  `line_no` bigint(0) NULL DEFAULT 0 COMMENT '行号',
  `CREATED_BY` int(0) NULL DEFAULT NULL COMMENT '创建人',
  `CREATED_TIME` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`, `scd_id`) USING BTREE,
  INDEX `ind1`(`parent_node_id`) USING BTREE,
  INDEX `ind2`(`node_name`) USING BTREE,
  INDEX `ind3`(`scd_id`) USING BTREE,
  INDEX `ind4`(`line_no`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'scd节点表' ROW_FORMAT = Dynamic PARTITION BY KEY (`scd_id`)
PARTITIONS 100
(PARTITION `p0` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p1` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p10` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p100` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p101` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p102` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p103` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p104` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p105` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p106` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p107` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p108` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p109` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p11` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p110` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p111` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p112` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p113` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p114` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p115` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p116` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p117` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p118` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p119` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p12` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p120` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p121` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p122` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p123` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p124` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p125` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p126` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p127` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p128` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p129` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p13` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p130` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p131` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p132` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p133` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p134` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p135` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p136` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p137` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p138` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p139` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p14` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p140` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p141` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p142` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p143` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p144` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p145` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p146` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p147` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p148` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p149` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p15` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p150` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p151` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p152` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p153` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p154` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p155` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p156` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p157` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p158` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p159` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p16` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p160` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p161` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p162` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p163` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p164` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p165` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p166` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p167` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p168` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p169` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p17` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p170` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p171` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p172` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p173` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p174` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p175` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p176` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p177` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p178` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p179` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p18` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p180` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p181` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p182` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p183` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p184` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p185` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p186` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p187` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 ,
PARTITION `p188` ENGINE = InnoDB MAX_ROWS = 0 MIN_ROWS = 0 )
;

-- ----------------------------
-- Table structure for t_scd_optfields_attrs
-- ----------------------------
DROP TABLE IF EXISTS `t_scd_optfields_attrs`;
CREATE TABLE `t_scd_optfields_attrs`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `scd_id` bigint(0) NOT NULL,
  `node_id` bigint(0) NOT NULL COMMENT '所属节点ID',
  `attr_seq_num` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_time_stamp` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_data_set` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_reason_code` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_data_ref` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_entry_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_config_ref` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_buf_ovfl` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `CREATED_BY` int(0) NULL DEFAULT 0 COMMENT '创建人',
  `CREATED_TIME` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `q1`(`scd_id`) USING BTREE,
  INDEX `q2`(`node_id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 34879 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'OptFields节点属性' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for t_scd_p_attrs
-- ----------------------------
DROP TABLE IF EXISTS `t_scd_p_attrs`;
CREATE TABLE `t_scd_p_attrs`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `scd_id` bigint(0) NOT NULL,
  `node_id` bigint(0) NOT NULL COMMENT '所属节点ID',
  `attr_type` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `CREATED_BY` int(0) NULL DEFAULT 0 COMMENT '创建人',
  `CREATED_TIME` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `w1`(`scd_id`) USING BTREE,
  INDEX `w2`(`node_id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 103725 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'P节点属性' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for t_scd_physconn_attrs
-- ----------------------------
DROP TABLE IF EXISTS `t_scd_physconn_attrs`;
CREATE TABLE `t_scd_physconn_attrs`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `scd_id` bigint(0) NOT NULL,
  `node_id` bigint(0) NOT NULL COMMENT '所属节点ID',
  `attr_type` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `CREATED_BY` int(0) NULL DEFAULT 0 COMMENT '创建人',
  `CREATED_TIME` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `w1`(`scd_id`) USING BTREE,
  INDEX `w2`(`node_id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 6371 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'PhysConn节点属性' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for t_scd_private_attrs
-- ----------------------------
DROP TABLE IF EXISTS `t_scd_private_attrs`;
CREATE TABLE `t_scd_private_attrs`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `scd_id` bigint(0) NOT NULL,
  `node_id` bigint(0) NOT NULL COMMENT '所属节点ID',
  `attr_type` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `CREATED_BY` int(0) NULL DEFAULT 0 COMMENT '创建人',
  `CREATED_TIME` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `q1`(`scd_id`) USING BTREE,
  INDEX `q2`(`node_id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 32038 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'Private节点属性' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for t_scd_reportcontrol_attrs
-- ----------------------------
DROP TABLE IF EXISTS `t_scd_reportcontrol_attrs`;
CREATE TABLE `t_scd_reportcontrol_attrs`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `scd_id` bigint(0) NOT NULL,
  `node_id` bigint(0) NOT NULL COMMENT '所属节点ID',
  `attr_name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `attr_desc` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_dat_set` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_intg_pd` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_rpt_id` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_conf_rev` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `attr_buffered` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_buf_time` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_indexed` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `CREATED_BY` int(0) NULL DEFAULT 0 COMMENT '创建人',
  `CREATED_TIME` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `q1`(`scd_id`) USING BTREE,
  INDEX `q2`(`node_id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 34879 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'ReportControl节点属性' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for t_scd_reportsettings_attrs
-- ----------------------------
DROP TABLE IF EXISTS `t_scd_reportsettings_attrs`;
CREATE TABLE `t_scd_reportsettings_attrs`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `scd_id` bigint(0) NOT NULL,
  `node_id` bigint(0) NOT NULL COMMENT '所属节点ID',
  `attr_cb_name` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_dat_set` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_rpt_id` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_opt_fields` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_buf_time` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_trg_ops` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_intg_pd` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `CREATED_BY` int(0) NULL DEFAULT 0 COMMENT '创建人',
  `CREATED_TIME` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `q1`(`scd_id`) USING BTREE,
  INDEX `q2`(`node_id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 3260 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'ReportSettings节点属性' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for t_scd_rptenabled_attrs
-- ----------------------------
DROP TABLE IF EXISTS `t_scd_rptenabled_attrs`;
CREATE TABLE `t_scd_rptenabled_attrs`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `scd_id` bigint(0) NOT NULL,
  `node_id` bigint(0) NOT NULL COMMENT '所属节点ID',
  `attr_max` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_desc` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `CREATED_BY` int(0) NULL DEFAULT 0 COMMENT '创建人',
  `CREATED_TIME` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `q1`(`scd_id`) USING BTREE,
  INDEX `q2`(`node_id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 34819 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'RptEnabled节点属性' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for t_scd_sampledvaluecontrol_attrs
-- ----------------------------
DROP TABLE IF EXISTS `t_scd_sampledvaluecontrol_attrs`;
CREATE TABLE `t_scd_sampledvaluecontrol_attrs`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `scd_id` bigint(0) NOT NULL,
  `node_id` bigint(0) NOT NULL COMMENT '所属节点ID',
  `attr_name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `attr_desc` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_dat_set` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_conf_rev` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_smv_id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `attr_multicast` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_smp_rate` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_nof_asdu` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `CREATED_BY` int(0) NULL DEFAULT 0 COMMENT '创建人',
  `CREATED_TIME` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `q1`(`scd_id`) USING BTREE,
  INDEX `q2`(`node_id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1036 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'SampledValueControl节点属性' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for t_scd_scl
-- ----------------------------
DROP TABLE IF EXISTS `t_scd_scl`;
CREATE TABLE `t_scd_scl`  (
  `id` bigint(0) NOT NULL COMMENT '主键',
  `scd_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'scd名称',
  `path` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '存储路径',
  `version` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '版本号',
  `station_id` int(0) NULL DEFAULT 0 COMMENT '所属变电站ID',
  `enable` int(0) NULL DEFAULT 0 COMMENT '启用状态',
  `checkout_lock` int(0) NULL DEFAULT 0 COMMENT '签出锁定',
  `node_cnt` bigint(0) NULL DEFAULT 0 COMMENT '节点数量',
  `is_parse` int(0) NULL DEFAULT 0 COMMENT '是否已解析完成',
  `in_rt_crc` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '签入时取得的系统内部crc校验码',
  `out_rt_crc` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '签出时生成的系统内部crc校验码',
  `is_checkin_scd` int(0) NULL DEFAULT NULL COMMENT '是否签入的管控文件',
  `CREATED_BY` int(0) NULL DEFAULT NULL COMMENT '创建人',
  `CREATED_TIME` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'scd主表数据' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for t_scd_scl_attrs
-- ----------------------------
DROP TABLE IF EXISTS `t_scd_scl_attrs`;
CREATE TABLE `t_scd_scl_attrs`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `scd_id` bigint(0) NOT NULL,
  `node_id` bigint(0) NOT NULL,
  `attr_xmlns` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_xmlns_xsi` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_xsi_schema_location` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_xmlns_ext` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `CREATED_BY` int(0) NULL DEFAULT 0 COMMENT '创建人',
  `CREATED_TIME` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `ind1`(`scd_id`) USING BTREE,
  INDEX `ind2`(`node_id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 95 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '根节点属性' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for t_scd_scl_check
-- ----------------------------
DROP TABLE IF EXISTS `t_scd_scl_check`;
CREATE TABLE `t_scd_scl_check`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `check_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '规则名称',
  `check_desc` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '规则说明',
  `hint_text` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '提示内容模板',
  `check_type` int(0) NULL DEFAULT NULL COMMENT '规则分类',
  `apply_standard` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '来源标准',
  `apply_standard_no` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '标准条款',
  `object_type` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '检验对象类型;nodeattr',
  `object_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '校验对象名称;支持表达式:拼结 &&',
  `alert_level` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `func_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '自定义检测程序方法名称',
  `node_path` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '父节点路径',
  `order_no` int(0) NULL DEFAULT NULL COMMENT '节点顺序号;只针对节点有效',
  `is_ref` int(0) NULL DEFAULT NULL COMMENT '是否引用',
  `is_exists` int(0) NULL DEFAULT NULL COMMENT '是否存在',
  `check_area` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '检验目标范围',
  `is_notnull` int(0) NULL DEFAULT NULL COMMENT '是否必填',
  `data_type` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '数据类型;int、float、string、16(进制)。默认为string',
  `min_len` int(0) NULL DEFAULT NULL COMMENT '最小长度;为0表示不限制',
  `max_len` int(0) NULL DEFAULT NULL COMMENT '最大长度;为0表示不限制',
  `min_value` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '最小值',
  `max_value` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '最大值',
  `isunique_by_parent` int(0) NULL DEFAULT 0 COMMENT '唯一;在父节点下唯一',
  `isunique_by_global` int(0) NULL DEFAULT 0 COMMENT 'SCD内唯一',
  `const_value` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '常量固定值',
  `emun_value` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '枚举值',
  `regexp_value` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '正则值校验',
  `enable` int(0) NULL DEFAULT 1 COMMENT '启用状态',
  `CREATED_BY` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建人',
  `CREATED_TIME` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `ind1`(`object_name`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 111 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'SCL节点或属性约束校验规则' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of t_scd_scl_check
-- ----------------------------
INSERT INTO `t_scd_scl_check` VALUES (1, 'toolID属性检查', 'SCD和CID文件的Header元素必须填写toolID。SCD和CID文件toolID属性值应按“厂商编码_配置工具名称_工具软件版本”的格式填写', '', 2056, 'Q/CSG1203065-2020', '6.6.3', 'node', 'Header', 'waring', '', '', NULL, 0, 1, '', 0, '', 0, 0, '', '', 0, 0, '', '', '', 1, '1', '2023-05-08 21:57:16');
INSERT INTO `t_scd_scl_check` VALUES (2, '全站过程层CRC正确性校验', 'IED 过程层虚端子 CRC32 校验码和全站过程层虚端子 CRC32 校验码应正确', '', 2056, 'DL/T1873', '10.2', 'node', 'IED', 'error', '', '', NULL, 0, 1, '', 0, '', 0, 0, '', '', 0, 0, '', '', '', 1, '1', '2023-04-22 11:25:54');
INSERT INTO `t_scd_scl_check` VALUES (3, 'Header版本一致性', 'Header中的version、revision与History中的最后一个Item不一致', '', 2056, '', '', 'node', 'Header', 'hint', '', '', NULL, 0, 1, '', 0, '', 0, 0, '', '', 0, 0, '', '', '', 1, '1', '2023-04-22 11:26:51');
INSERT INTO `t_scd_scl_check` VALUES (4, 'Header元素完备性校验', 'SCD和CID文件的Header元素必须填写id、version、revision属性', '', 2056, 'Q/CSG1203065-2020、GB/T32890', '6.6.2、5.3', 'node', 'Header', 'waring', '', '', NULL, 0, 1, '', 0, '', 0, 0, '', '', 0, 0, '', '', '', 1, '1', '2023-05-08 21:58:12');
INSERT INTO `t_scd_scl_check` VALUES (5, 'Hitem元素完备性校验', 'ICD、SCD和CID文件的Hitem元素必须填写version、revision、when属性', '', 2056, 'Q/CSG1203065-2020、GB/T32890', '6.6.4、5.3', 'node', 'Header', 'waring', '', '', NULL, 0, 1, '', 0, '', 0, 0, '', '', 0, 0, '', '', '', 1, '1', '2023-05-08 21:58:50');
INSERT INTO `t_scd_scl_check` VALUES (6, 'History版本连续性', 'SCD文件version属性从1.0开始，当文件增加了新的IED或某个IED模型实例升级时，以步长0.1向上累加；SCD文件revision属性从1.0开始，当文件做了通信配置、参数、描述修改时，以步长0.1向上累加，文件版本增加时，文件修订版本置1.0', '', 2056, 'Q/CSG1203065-2020、GB/T32890', '6.6.4、5.3', 'node', 'Header', 'hint', '', '', NULL, 0, 1, '', 0, '', 0, 0, '', '', 0, 0, '', '', '', 1, '1', '2023-05-08 21:59:24');
INSERT INTO `t_scd_scl_check` VALUES (7, 'Substation完备性校验', 'Substation元素缺失', '', 2056, '', '', 'node', 'Substation', 'waring', '', '', NULL, 0, 1, '', 0, '', 0, 0, '', '', 0, 0, '', '', '', 1, '1', '2023-04-22 11:33:18');
INSERT INTO `t_scd_scl_check` VALUES (8, '变电站名称一致性', 'Substation的name与Header中的id不一致', '', 2056, 'Q/CSG1203065-2020、GB/T32890', '6.6.2', 'node', 'Substation', 'error', '', '', NULL, 0, 1, '', 0, '', 0, 0, '', '', 0, 0, '', '', '', 1, '1', '2023-04-22 11:34:47');
INSERT INTO `t_scd_scl_check` VALUES (9, 'VoltageLevel命名错误', 'VoltageLevel对象的命名name应按“额定电压kV”形式命名', '', 2056, 'GB/T1874', '7.2', 'node', 'Substation', 'error', '', '', NULL, 0, 1, '', 0, '', 0, 0, '', '', 0, 0, '', '', '', 1, '1', '2023-04-22 11:36:16');
INSERT INTO `t_scd_scl_check` VALUES (10, 'VoltageLevel下Voltage缺失', 'VoltageLevel下必须包含Voltage对象', '', 2056, 'GB/T1874', '7.2', 'node', 'Substation', 'error', '', '', NULL, 0, 1, '', 0, '', 0, 0, '', '', 0, 0, '', '', '', 1, '1', '2023-04-22 11:37:01');
INSERT INTO `t_scd_scl_check` VALUES (11, 'Voltage对象的取值/属性错误', 'Voltage对象的取值应以kV为单位。如220kV电压等级对象下的Voltage的电压值为220,multiplier属性值“k”、 unit属性值“V”', '', 2056, 'GB/T1874', '7.2', 'node', 'Substation', 'error', '', '', NULL, 0, 1, '', 0, '', 0, 0, '', '', 0, 0, '', '', '', 1, '1', '2023-04-22 11:38:52');
INSERT INTO `t_scd_scl_check` VALUES (12, '子网命名校验', '子网（SubNetwork）按物理网络划分，全站子网宜划分成站控层网络和过程层网络两种类型，过程层网络按照电压等级划分', '', 2048, 'Q/CSG1203065-2020', '6.4.1', 'node', 'Communication', 'waring', '', '', NULL, 0, 1, '', 0, '', 0, 0, '', '', 0, 0, '', '', '', 1, '1', '2023-04-22 11:42:07');
INSERT INTO `t_scd_scl_check` VALUES (13, '访问点命名一致性校验', '〈Communication)下<ConnectedAP>的apName届性值是否指向已存在的TED访问点', '', 2048, 'Q∕GDW 11156-2014', '7.1.7', 'node', 'Communication', 'error', '', '', NULL, 0, 1, '', 0, '', 0, 0, '', '', 0, 0, '', '', '', 1, '1', '2023-04-22 11:43:20');
INSERT INTO `t_scd_scl_check` VALUES (14, 'IED命名一致性校验', '〈Communication)下(ConnectedAP>的iedName属性值是否指向己存在的IED', '', 2048, 'Q∕GDW 11156-2014', '7.1.7', 'node', 'Communication', 'error', '', '', NULL, 0, 1, '', 0, '', 0, 0, '', '', 0, 0, '', '', '', 1, '1', '2023-04-22 11:44:24');
INSERT INTO `t_scd_scl_check` VALUES (15, 'GSE命名一致性校验', '〈Communication)下<GSE>的cbName、Idlnst属性值是否指向已存在的GOOSE控制块', '', 2048, 'Q∕GDW 11156-2014', '7.1.7', 'node', 'Communication', 'error', '', '', NULL, 0, 1, '', 0, '', 0, 0, '', '', 0, 0, '', '', '', 1, '1', '2023-04-22 11:45:30');
INSERT INTO `t_scd_scl_check` VALUES (16, 'SMV命名一致性校验', '<Communication)下<SMV>的cbName、Idlnst属性值是合指向已存在的IED控制块', '', 2048, 'Q∕GDW 11156-2014', '7.1.7', 'node', 'Communication', 'error', '', '', NULL, 0, 1, '', 0, '', 0, 0, '', '', 0, 0, '', '', '', 1, '1', '2023-04-22 11:46:12');
INSERT INTO `t_scd_scl_check` VALUES (17, 'ConnectedAP唯一性校验', 'ConnectedAP不应重复配置', '', 2048, 'Q∕GDW 11156-2014', '7.1.7', 'node', 'Communication', 'error', '', '', NULL, 0, 1, '', 0, '', 0, 0, '', '', 0, 0, '', '', '', 1, '1', '2023-04-22 11:46:44');
INSERT INTO `t_scd_scl_check` VALUES (18, 'IP地址唯一性', 'IP应全站唯一', '', 98390, 'QGDW11662-2017、Q/CSG1203065-2020', '8.2.4', 'node', 'Communication', 'error', '', '', NULL, 0, 1, '', 0, '', 0, 0, '', '', 0, 0, '', '', '', 1, '1', '2023-04-22 11:49:41');
INSERT INTO `t_scd_scl_check` VALUES (19, 'IP地址未配置', 'MMS通信参数应配置:IP、IP-SUBNET等', '', 98390, 'QGDW11662-2017、Q/CSG1203065-2020', '8.2.4', 'node', 'Communication', 'error', '', '', NULL, 0, 1, '', 0, '', 0, 0, '', '', 0, 0, '', '', '', 1, '1', '2023-04-22 11:50:25');
INSERT INTO `t_scd_scl_check` VALUES (20, 'IP-SUBNET地址未配置', 'MMS通信参数应配置：IP、IP-SUBNET等', '', 98390, 'QGDW11662-2017、Q/CSG1203065-2020', '8.2.4', 'node', 'Communication', 'error', '', '', NULL, 0, 1, '', 0, '', 0, 0, '', '', 0, 0, '', '', '', 1, '1', '2023-04-22 11:51:18');
INSERT INTO `t_scd_scl_check` VALUES (21, 'IP地址越界', 'IP及子网掩码地址范围：0.0.0.0～255.255.255.255', '', 98390, 'QGDW11662-2017、Q/CSG1203065-2020', '8.2.4', 'node', 'Communication', 'error', '', '', NULL, 0, 1, '', 0, '', 0, 0, '', '', 0, 0, '', '', '', 1, '1', '2023-04-22 11:52:00');
INSERT INTO `t_scd_scl_check` VALUES (22, 'IP地址配置不规范', 'IP地址配置不规范', '', 98390, 'QGDW11662-2017、Q/CSG1203065-2020', '8.2.4', 'node', 'Communication', 'error', '', '', NULL, 0, 1, '', 0, '', 0, 0, '', '', 0, 0, '', '', '', 1, '1', '2023-04-22 11:52:42');
INSERT INTO `t_scd_scl_check` VALUES (23, 'IP-SUBNET地址越界', 'IP及子网掩码地址范围：0.0.0.0～255.255.255.255', '', 98390, 'QGDW11662-2017、Q/CSG1203065-2020', '8.2.4', 'node', 'Communication', 'error', '', '', NULL, 0, 1, '', 0, '', 0, 0, '', '', 0, 0, '', '', '', 1, '1', '2023-04-22 11:53:31');
INSERT INTO `t_scd_scl_check` VALUES (24, 'GOOSE通信参数唯一性', 'MAC-Address、appID/GOID、APPID等GOOSE通信参数应全站唯一', '', 98391, 'QGDW11662-2017、Q/CSG1203065-2020', '8.2.4', 'node', 'Communication', 'error', '', '', NULL, 0, 1, '', 0, '', 0, 0, '', '', 0, 0, '', '', '', 1, '1', '2023-04-22 11:54:33');
INSERT INTO `t_scd_scl_check` VALUES (25, 'GOOSE通信参数Mac地址越界', 'MAC-Address为12 位16进制值，其范围：0x01-0C-CD-01-00-00～0x01-0C-CD-01-01-FF', '', 98391, 'QGDW11662-2017、Q/CSG1203065-2020', '8.2.4', 'node', 'Communication', 'error', '', '', NULL, 0, 1, '', 0, '', 0, 0, '', '', 0, 0, '', '', '', 1, '1', '2023-04-22 11:55:27');
INSERT INTO `t_scd_scl_check` VALUES (26, 'GOOSE通信参数APPID越界', 'APPID为4位16进制值,其范围：0x1000～0x1FFF', '', 98391, 'QGDW11662-2017、Q/CSG1203065-2020', '8.2.4', 'node', 'Communication', 'error', '', '', NULL, 0, 1, '', 0, '', 0, 0, '', '', 0, 0, '', '', '', 1, '1', '2023-04-22 11:56:11');
INSERT INTO `t_scd_scl_check` VALUES (27, 'GOOSE通信参数APPID与Mac地址不匹配', 'APPID第1字节由MAC-Address的倒数第3、第2字节的后一个字符组合而成，APPID第2字节取MAC-Address的最后1个字节，例如MAC-Address地址为0x01-0C-CD-01-01-11则 APPID为0x1111', '', 98391, 'QGDW11662-2017', '8.2.3', 'node', 'Communication', 'waring', '', '', NULL, 0, 1, '', 0, '', 0, 0, '', '', 0, 0, '', '', '', 1, '1', '2023-04-22 12:00:55');
INSERT INTO `t_scd_scl_check` VALUES (28, 'GOOSE通信参数VLAN-ID越界', 'VLAN-ID为3位16进制值，范围：0x000～0xFFFH。初始赋值000，此时由交换机标记VLAN-ID', '', 98391, 'QGDW11662-2017、Q/CSG1203065-2020', '8.2.4', 'node', 'Communication', 'error', '', '', NULL, 0, 1, '', 0, '', 0, 0, '', '', 0, 0, '', '', '', 1, '1', '2023-04-22 11:59:12');
INSERT INTO `t_scd_scl_check` VALUES (29, 'GOOSE通信参数VLAN-Priority越界', 'VLAN-Priority为1位16进制值， 范围： 0～7', '', 98391, 'QGDW11662-2017、Q/CSG1203065-2020', '8.2.4', 'node', 'Communication', 'error', '', '', NULL, 0, 1, '', 0, '', 0, 0, '', '', 0, 0, '', '', '', 1, '1', '2023-04-22 11:59:49');
INSERT INTO `t_scd_scl_check` VALUES (30, 'GOOSE通信参数MinTime和MaxTime不为推荐值', 'MinTime和MaxTime的宜分别配置为2ms和5000ms', '', 98391, 'QGDW11662-2017、Q/CSG1203065-2020', '8.2.4', 'node', 'Communication', 'error', '', '', NULL, 0, 1, '', 0, '', 0, 0, '', '', 0, 0, '', '', '', 1, '1', '2023-04-22 12:00:33');
INSERT INTO `t_scd_scl_check` VALUES (31, 'GOOSE通信参数缺失', 'GOOSE 通信参数应配置：目的 MAC-Address、 appID/GOID、 APPID、 confRev、 VLAN-ID、 VLAN-Priority、 MinTime、 MaxTime 等', '', 98391, 'QGDW11662-2017、Q/CSG1203065-2020', '8.2.4', 'node', 'Communication', 'error', '', '', NULL, 0, 1, '', 0, '', 0, 0, '', '', 0, 0, '', '', '', 1, '1', '2023-04-22 12:01:43');
INSERT INTO `t_scd_scl_check` VALUES (32, 'SV通信参数唯一性', 'MAC-Address、 smvID、 APPID 等 SV 通信参数应全站唯一', '', 98391, 'QGDW11662-2017、Q/CSG1203065-2020', '8.2.4', 'node', 'Communication', 'error', '', '', NULL, 0, 1, '', 0, '', 0, 0, '', '', 0, 0, '', '', '', 1, '1', '2023-04-22 12:02:17');
INSERT INTO `t_scd_scl_check` VALUES (33, 'SV通信参数Mac地址越界', 'MAC-Address 为 12 位 16 进制值， 其范围： 0x01-0C-CD-04-00-00～0x01-0C-CD-04-01-FF', '', 98391, 'QGDW11662-2017、Q/CSG1203065-2020', '8.2.4', 'node', 'Communication', 'error', '', '', NULL, 0, 1, '', 0, '', 0, 0, '', '', 0, 0, '', '', '', 1, '1', '2023-04-22 12:10:30');
INSERT INTO `t_scd_scl_check` VALUES (34, 'SV通信参数APPID越界', 'APPID 为 4 位 16 进制值，其范围： 0x4000～0x4FFF', '', 98391, 'QGDW11662-2017、Q/CSG1203065-2020', '8.2.4', 'node', 'Communication', 'error', '', '', NULL, 0, 1, '', 0, '', 0, 0, '', '', 0, 0, '', '', '', 1, '1', '2023-04-22 12:10:58');
INSERT INTO `t_scd_scl_check` VALUES (35, 'SV通信参数APPID与Mac地址不匹配', 'APPID 第 1 字节由 MAC-Address 的倒数第 3、第 2 字节的后一个字符组合而成， APPID 第 2 字 节取 MAC-Address 的最后 1 个字节，例如： MAC-Address 为 0x01-0C-CD-04-01-11，则 APPID 为 0x4111', '', 98391, 'QGDW11662-2017、Q/CSG1203065-2020', '8.2.4', 'node', 'Communication', 'waring', '', '', NULL, 0, 1, '', 0, '', 0, 0, '', '', 0, 0, '', '', '', 1, '1', '2023-04-22 12:11:41');
INSERT INTO `t_scd_scl_check` VALUES (36, 'SV通信参数VLAN-ID越界', 'VLAN-ID 为 3 位 16 进制值， 范围： 0x000～0xFFFH。初始赋值 000，此时由交换机标记 VLAN-ID', '', 98391, 'QGDW11662-2017、Q/CSG1203065-2020', '8.2.4', 'node', 'Communication', 'error', '', '', NULL, 0, 1, '', 0, '', 0, 0, '', '', 0, 0, '', '', '', 1, '1', '2023-04-22 12:12:31');
INSERT INTO `t_scd_scl_check` VALUES (37, 'SV通信参数VLAN-Priority越界', 'VLAN-Priority 为 1 位 16 进制值， 范围： 0～7', '', 98391, 'QGDW11662-2017、Q/CSG1203065-2020', '8.2.4', 'node', 'Communication', 'error', '', '', NULL, 0, 1, '', 0, '', 0, 0, '', '', 0, 0, '', '', '', 1, '1', '2023-04-22 12:13:15');
INSERT INTO `t_scd_scl_check` VALUES (38, 'SV通信参数缺失', 'SV通信参数应配置:目的MAC-Address、smvID、APPID、ConfRev、VLAN-ID、VLAN-Priority等', '', 98391, 'QGDW11662-2017、Q/CSG1203065-2020', '8.2.4', 'node', 'Communication', 'error', '', '', NULL, 0, 1, '', 0, '', 0, 0, '', '', 0, 0, '', '', '', 1, '1', '2023-04-22 12:14:04');
INSERT INTO `t_scd_scl_check` VALUES (39, 'ICD文件校验码存在性', '应在SCD文件的每个IED元素中分别记录相应ICD文件的CRC校验码', '', 2048, 'QGDW11662-2017、Q/CSG1203065-2020', '8.2.4', 'node', 'IED', 'waring', '', '', NULL, 0, 1, '', 0, '', 0, 0, '', '', 0, 0, '', '', '', 1, '1', '2023-04-22 12:15:05');
INSERT INTO `t_scd_scl_check` VALUES (40, '逻辑设备建模正确性', '一个物理设备，应建模为一个IED对象。该对象是一个容器，包含Server对象。Server对象中至少包含一个LD对象，每个LD对象中至少包含3个LN对象：LLN0、LPHD、其他应用逻辑节点', '', 2048, 'GB/T 32890', '6.1.1', 'node', 'IED', 'error', '', '', NULL, 0, 1, '', 0, '', 0, 0, '', '', 0, 0, '', '', '', 1, '1', '2023-04-22 12:17:09');
INSERT INTO `t_scd_scl_check` VALUES (41, 'CCD校验码校验', 'CCD校验码一致性校验', '', 2048, 'GB/T 32890', '5.3', 'node', 'IED', 'error', '', '', NULL, 0, 1, '', 0, '', 0, 0, '', '', 0, 0, '', '', '', 1, '1', '2023-04-22 12:19:31');
INSERT INTO `t_scd_scl_check` VALUES (42, '访问点（AccessPoint）名称校验', '服务器描述了一个设备外部可见（可访问）的行为，每个服务器至少应有一个访问点（AccessPoint）。应采用三个不同访问点S1、G1、M1分别与站控层MMS、过程层GOOSE、过程层SV进行通信。所有访问点，应在同一个ICD文件中体现。', '', 2048, 'Q_CSG1203065-2020', '7.1.3.1', 'node', 'IED', 'waring', '', '', NULL, 0, 1, '', 0, '', 0, 0, '', '', 0, 0, '', '', '', 1, '1', '2023-04-22 12:21:07');
INSERT INTO `t_scd_scl_check` VALUES (43, 'IEDName合法性校验', 'IED 的 name 由 5 部分共 8 位合法可视字符组成，分别代表： IED 类型、归属设备类型、电压等 级、归属设备编号、 IED 编号', '', 2048, '智能变电站系统配置（SCD）文件技术规范\r\n附件2：智能站工程配置补充要求-20200824', 'DL/T 1873 8.2.2、\r\n补充要求 3.2.1', 'node', 'IED', 'waring', '', '', NULL, 0, 1, '', 0, '', 0, 0, '', '', 0, 0, '', '', '', 1, '1', '2023-04-22 12:23:41');
INSERT INTO `t_scd_scl_check` VALUES (44, '信号关联关系格式检查', '站控层和过程层存在相关性的信号宜采用统一扩展的原则，由制造厂商在 IED 装置 ICD 文件中预先 定义。信号关联关系通过在“IED”元素下扩充“Private”元素来进行定义', '', 2048, 'DL/T1873、Q/CSG1203065-2020', '8.3、7.2.3.2/7.2.3.3', 'node', 'IED', 'error', '', '', NULL, 0, 1, '', 0, '', 0, 0, '', '', 0, 0, '', '', '', 1, '1', '2023-05-08 22:30:00');
INSERT INTO `t_scd_scl_check` VALUES (45, '数据集成员有效性校验', '数据集成员模型中应为已存在的数据对象和数据属性', '', 98393, 'DL/T1873', '10.2', 'node', 'IED', 'error', '', '', NULL, 0, 1, '', 0, '', 0, 0, '', '', 0, 0, '', '', '', 1, '1', '2023-04-22 12:28:40');
INSERT INTO `t_scd_scl_check` VALUES (46, '校验数据集成员构成', 'dsGOOSE 数据集的所有成员都应采用FCDA构成方式，其它数据集成员都应采用FCD构成方式。dsGOOSE 数据集成员总数不应超过256个', '', 98393, 'DL/T1873', '10.2', 'node', 'IED', 'error', '', '', NULL, 0, 1, '', 0, '', 0, 0, '', '', 0, 0, '', '', '', 1, '1', '2023-04-22 17:15:17');
INSERT INTO `t_scd_scl_check` VALUES (47, '数据集成员数目校验', '数据集成员实际个数应小于或等于 ConfDataSet 的 maxAttributes 属性值', '', 98393, 'DL/T1873', '10.2', 'node', 'IED', 'error', '', '', NULL, 0, 1, '', 0, '', 0, 0, '', '', 0, 0, '', '', '', 1, '1', '2023-04-22 12:29:56');
INSERT INTO `t_scd_scl_check` VALUES (48, '数据集数目校验', '数据集〈Dataset〉实际个数是否小于或等于〈ConfDataset>的max属性值', '', 98393, 'Q∕GDW 11156-2014', '7.1.7', 'node', 'IED', 'error', '', '', NULL, 0, 1, '', 0, '', 0, 0, '', '', 0, 0, '', '', '', 1, '1', '2023-04-22 12:31:00');
INSERT INTO `t_scd_scl_check` VALUES (49, '数据集成员跨LD校验', '数据集包含的数据对象不应跨 LD', '', 98393, 'DL/T1873', '10.2', 'node', 'IED', 'error', '', '', NULL, 0, 1, '', 0, '', 0, 0, '', '', 0, 0, '', '', '', 1, '1', '2023-04-22 12:31:35');
INSERT INTO `t_scd_scl_check` VALUES (50, '连线外部虚端子合法性', '虚端子关联部分外部端子为有效的模型', '', 98394, 'DL/T1873', '10.2', 'node', 'IED', 'error', '', '', NULL, 0, 1, '', 0, '', 0, 0, '', '', 0, 0, '', '', '', 1, '1', '2023-04-22 15:14:14');
INSERT INTO `t_scd_scl_check` VALUES (51, '连线内部参引对应数据不存在', '虚端子关联部分内部端子为有效的模型', '', 98394, 'DL/T1873', '10.2', 'node', 'IED', 'error', '', '', NULL, 0, 1, '', 0, '', 0, 0, '', '', 0, 0, '', '', '', 1, '1', '2023-04-22 15:14:45');
INSERT INTO `t_scd_scl_check` VALUES (52, '连线两端数据不匹配', '测试 TUT 在配置虚端子关联时, 发送端与接收端的数据类型不一致', '', 98394, 'GB/T34121', '', 'node', 'IED', 'error', '', '', NULL, 0, 1, '', 0, '', 0, 0, '', '', 0, 0, '', '', '', 1, '1', '2023-04-22 15:17:31');
INSERT INTO `t_scd_scl_check` VALUES (53, '连线外部参引对应的控制块的属性配置错误', '外部信号相关控制块配置参数（APPID、appID、confRev、smvID等）缺失、值为空、值不正确', '', 98394, 'Q_CSG1204059-2020', '6.3.7', 'node', 'IED', 'error', '', '', NULL, 0, 1, '', 0, '', 0, 0, '', '', 0, 0, '', '', '', 1, '1', '2023-04-22 15:18:34');
INSERT INTO `t_scd_scl_check` VALUES (54, 'GOOSE控制块引用的数据集不存在', 'GOOSE控制块引用的数据集不存在', '', 98395, 'DL/T1873', '10.2', 'node', 'IED', 'error', '', '', NULL, 0, 1, '', 0, '', 0, 0, '', '', 0, 0, '', '', '', 1, '1', '2023-04-22 15:19:46');
INSERT INTO `t_scd_scl_check` VALUES (55, 'GOOSE控制块的个数超出声明的最大值', 'ICD文件中相关的IEDGOOSE控制块配置的必要参数缺失、错误(GOOSE控制块的个数超出声明的最大值)', '', 98395, 'Q_CSG1204059-2020', 'A.2.2 ExpN6', 'node', 'IED', 'waring', '', '', NULL, 0, 1, '', 0, '', 0, 0, '', '', 0, 0, '', '', '', 1, '1', '2023-04-22 15:20:53');
INSERT INTO `t_scd_scl_check` VALUES (56, 'GOOSE控制块的name属性值在LN内重复配置', 'ICD文件中相关的IEDGOOSE控制块配置的必要参数缺失、错误(GOOSE控制块的name属性值在LN内重复配置)', '', 98395, 'Q_CSG1204059-2020', 'A.2.2 ExpN6', 'node', 'IED', 'error', '', '', NULL, 0, 1, '', 0, '', 0, 0, '', '', 0, 0, '', '', '', 1, '1', '2023-04-22 15:21:30');
INSERT INTO `t_scd_scl_check` VALUES (57, 'GOOSE控制块的appID属性配置错误(缺失、值为空)', 'SCD文件中相关的IEDGOOSE控制块配置的必要参数缺失、错误(GOOSE控制块的appID属性配置错误(缺失、值为空))', '', 98395, 'Q_CSG1204059-2020', 'A.2.2 ExpN6', 'node', 'IED', 'error', '', '', NULL, 0, 1, '', 0, '', 0, 0, '', '', 0, 0, '', '', '', 1, '1', '2023-04-22 15:22:12');
INSERT INTO `t_scd_scl_check` VALUES (58, 'GOOSE控制块的appID唯一性', 'SCD文件中相关的IEDGOOSE控制块配置的必要参数缺失、错误（GOOSE控制块的appID是否唯一）', '', 98395, 'Q_CSG1204059-2020', 'A.1.3 Ied6', 'node', 'IED', 'error', '', '', NULL, 0, 1, '', 0, '', 0, 0, '', '', 0, 0, '', '', '', 1, '1', '2023-04-22 15:22:43');
INSERT INTO `t_scd_scl_check` VALUES (59, 'GOOSE控制块appID格式校验', 'GOOSE 标识（appID）宜由“引用路径”（“IEDName” +“LDevice” +“/” +“LLN0” +“.”） +“GOOSE控制块名称”组合而成', '', 98395, 'DL/T1873', '10.2', 'node', 'IED', 'waring', '', '', NULL, 0, 1, '', 0, '', 0, 0, '', '', 0, 0, '', '', '', 1, '1', '2023-04-22 15:23:49');
INSERT INTO `t_scd_scl_check` VALUES (60, 'GOOSE控制块的confRev属性配置错误(缺失、值为空)', 'SCD文件中相关的IEDGOOSE控制块配置的必要参数缺失、错误(GOOSE控制块的confRev属性配置错误(缺失、值为空))', '', 98395, 'Q_CSG1204059-2020', '', 'node', 'IED', 'error', '', '', NULL, 0, 1, '', 0, '', 0, 0, '', '', 0, 0, '', '', '', 1, '1', '2023-04-22 15:40:10');
INSERT INTO `t_scd_scl_check` VALUES (61, 'GOOSE控制块未配置网络参数', 'SCD文件中相关的IEDGOOSE控制块配置的必要参数缺失、错误(GOOSE控制块未配置网络参数)', '', 98395, 'Q_CSG1204059-2020', '', 'node', 'IED', 'error', '', '', NULL, 0, 1, '', 0, '', 0, 0, '', '', 0, 0, '', '', '', 1, '1', '2023-04-22 15:25:06');
INSERT INTO `t_scd_scl_check` VALUES (62, 'SV控制块引用的数据集不存在', 'SV控制块引用的数据集不存在', '', 98396, 'DL/T1873', '10.2', 'node', 'IED', 'error', '', '', NULL, 0, 1, '', 0, '', 0, 0, '', '', 0, 0, '', '', '', 1, '1', '2023-04-22 15:26:01');
INSERT INTO `t_scd_scl_check` VALUES (63, 'SV控制块的name属性值在LN内重复配置', 'SV控制块的name属性值在LN内重复配置', '', 98396, 'Q_CSG1204059-2020', '', 'node', 'IED', 'error', '', '', NULL, 0, 1, '', 0, '', 0, 0, '', '', 0, 0, '', '', '', 1, '1', '2023-04-22 15:26:38');
INSERT INTO `t_scd_scl_check` VALUES (64, 'SV控制块appID格式校验', 'SV 标识（smvID）宜由“引用路径”（“IEDName” +“LDevice” +“/“+“LLN0” +“.”） + “SV 控制块名称”组合而成', '', 98396, 'DL/T1873', '10.2', 'node', 'IED', 'waring', '', '', NULL, 0, 1, '', 0, '', 0, 0, '', '', 0, 0, '', '', '', 1, '1', '2023-04-22 15:27:07');
INSERT INTO `t_scd_scl_check` VALUES (65, 'SV控制块的smvID属性配置错误(缺失、值为空、合法性)', 'SCD文件中相关的IED SV控制块配置的必要参数缺失、错误(SV控制块的smvID属性配置错误(缺失、值为空、合法性))', '', 98396, 'Q_CSG1204059-2020', '', 'node', 'IED', 'error', '', '', NULL, 0, 1, '', 0, '', 0, 0, '', '', 0, 0, '', '', '', 1, '1', '2023-04-22 15:27:39');
INSERT INTO `t_scd_scl_check` VALUES (66, 'SV控制块的smvID唯一性', 'SV控制块的smvID唯一性', '', 98396, 'Q_CSG1204059-2020', '', 'node', 'IED', 'error', '', '', NULL, 0, 1, '', 0, '', 0, 0, '', '', 0, 0, '', '', '', 1, '1', '2023-04-22 15:28:03');
INSERT INTO `t_scd_scl_check` VALUES (67, 'SV控制块的smpRate属性错误(缺失、值为空、值不正确)', 'SV控制块的smpRate属性错误(缺失、值为空、值不正确)', '', 98396, 'Q_CSG1204059-2020', '', 'node', 'IED', 'waring', '', '', NULL, 0, 1, '', 0, '', 0, 0, '', '', 0, 0, '', '', '', 1, '1', '2023-04-22 15:29:56');
INSERT INTO `t_scd_scl_check` VALUES (68, 'SV控制块的nofASDU属性错误(缺失、值为空)', 'SV控制块的nofASDU属性错误(缺失、值为空)', '', 98396, 'Q_CSG1204059-2020', '', 'node', 'IED', 'waring', '', '', NULL, 0, 1, '', 0, '', 0, 0, '', '', 0, 0, '', '', '', 1, '1', '2023-04-22 15:30:42');
INSERT INTO `t_scd_scl_check` VALUES (69, 'SV控制块的confRev属性配置错误(缺失、值为空)', 'SV控制块的confRev属性配置错误(缺失、值为空)', '', 98396, 'Q_CSG1204059-2020', '', 'node', 'IED', 'waring', '', '', NULL, 0, 1, '', 0, '', 0, 0, '', '', 0, 0, '', '', '', 1, '1', '2023-04-22 15:30:07');
INSERT INTO `t_scd_scl_check` VALUES (70, 'SV控制块未配置网络参数', 'SV控制块未配置网络参数', '', 98396, 'Q_CSG1204059-2020', '', 'node', 'IED', 'error', '', '', NULL, 0, 1, '', 0, '', 0, 0, '', '', 0, 0, '', '', '', 1, '1', '2023-04-22 15:29:30');
INSERT INTO `t_scd_scl_check` VALUES (71, '日志控制块引用的数据集不存在', '日志控制块引用的数据集不存在', '', 98397, 'DL/T1873', '10.2', 'node', 'IED', 'error', '', '', NULL, 0, 1, '', 0, '', 0, 0, '', '', 0, 0, '', '', '', 1, '1', '2023-04-22 15:31:23');
INSERT INTO `t_scd_scl_check` VALUES (72, '日志控制块对应的日志名不存在', 'SCD文件中相关的IED日志控制块配置的必要参数缺失、错误（日志控制块对应的日志名不存在）', '', 98397, 'IEC61850-6 ', '9.3.9', 'node', 'IED', 'waring', '', '', NULL, 0, 1, '', 0, '', 0, 0, '', '', 0, 0, '', '', '', 1, '1', '2023-04-22 15:32:57');
INSERT INTO `t_scd_scl_check` VALUES (73, '日志控制块的name属性在LN下配置重复', 'ICD文件中相关的IED日志控制块配置的必要参数缺失、错误（日志控制块的name属性在LN下配置重复）', '', 98397, 'Q_CSG1204059-2020', '', 'node', 'IED', 'error', '', '', NULL, 0, 1, '', 0, '', 0, 0, '', '', 0, 0, '', '', '', 1, '1', '2023-04-22 15:33:31');
INSERT INTO `t_scd_scl_check` VALUES (74, '日志控制块的datSet属性配置错误(缺失、值为空)', 'ICD文件中相关的IED日志控制块配置的必要参数缺失、错误（日志控制块的datSet属性配置错误(缺失、值为空)）', '', 98397, 'Q_CSG1204059-2020', '', 'node', 'IED', 'waring', '', '', NULL, 0, 1, '', 0, '', 0, 0, '', '', 0, 0, '', '', '', 1, '1', '2023-04-22 15:34:05');
INSERT INTO `t_scd_scl_check` VALUES (75, '日志控制块的intgPd属性配置错误(缺失、值为空)', 'ICD文件中相关的IED日志控制块配置的必要参数缺失、错误（日志控制块的intgPd属性配置错误）', '', 98397, 'Q_CSG1204059-2020', '', 'node', 'IED', 'error', '', '', NULL, 0, 1, '', 0, '', 0, 0, '', '', 0, 0, '', '', '', 1, '1', '2023-04-22 15:34:38');
INSERT INTO `t_scd_scl_check` VALUES (76, '定值控制块的actSG属性配置错误(值不正确)', '定值控制块的actSG属性配置错误(值不正确)', '', 98398, 'IEC61850-6 ', '9.3.12', 'node', 'IED', 'error', '', '', NULL, 0, 1, '', 0, '', 0, 0, '', '', 0, 0, '', '', '', 1, '1', '2023-04-22 15:35:00');
INSERT INTO `t_scd_scl_check` VALUES (77, '定值控制块的numOfSGs属性配置错误(值不正确)', '定值控制块的numOfSGs属性配置错误(值不正确)', '', 98398, 'IEC61850-6 ', '9.3.12', 'node', 'IED', 'error', '', '', NULL, 0, 1, '', 0, '', 0, 0, '', '', 0, 0, '', '', '', 1, '1', '2023-04-22 15:35:18');
INSERT INTO `t_scd_scl_check` VALUES (78, '定值数据集的逻辑设备中定值控制块存在性校验', '定值数据集的逻辑设备中定值控制块存在性校验', '', 98398, 'Q_CSG1204059-2020', '8.7', 'node', 'IED', 'error', '', '', NULL, 0, 1, '', 0, '', 0, 0, '', '', 0, 0, '', '', '', 1, '1', '2023-04-22 15:35:57');
INSERT INTO `t_scd_scl_check` VALUES (79, '报告控制块引用的数据集不存在', '报告控制块引用的数据集不存在', '', 98399, 'DL/T1873', '10.2', 'node', 'IED', 'error', '', '', NULL, 0, 1, '', 0, '', 0, 0, '', '', 0, 0, '', '', '', 1, '1', '2023-04-22 15:36:15');
INSERT INTO `t_scd_scl_check` VALUES (80, '报告控制块的rptID重复', '报告控制块的rptID重复', '', 98399, 'Q_CSG1204059-2020', '', 'node', 'IED', 'error', '', '', NULL, 0, 1, '', 0, '', 0, 0, '', '', 0, 0, '', '', '', 1, '1', '2023-04-22 15:36:37');
INSERT INTO `t_scd_scl_check` VALUES (81, '报告控制块的confRev属性配置错误(缺失、值为空)', '报告控制块的confRev属性配置错误(缺失、值为空)', '', 98399, 'Q_CSG1204059-2020', '', 'node', 'IED', 'error', '', '', NULL, 0, 1, '', 0, '', 0, 0, '', '', 0, 0, '', '', '', 1, '1', '2023-04-22 15:36:55');
INSERT INTO `t_scd_scl_check` VALUES (82, '报告控制块的rptID属性配置错误(缺失)', '报告控制块的rptID属性配置错误(缺失)', '', 98399, 'Q_CSG1204059-2020', '', 'node', 'IED', 'error', '', '', NULL, 0, 1, '', 0, '', 0, 0, '', '', 0, 0, '', '', '', 1, '1', '2023-04-22 15:37:14');
INSERT INTO `t_scd_scl_check` VALUES (83, '报告控制块的name在LN下重复配置', '报告控制块的name在LN下重复配置', '', 98399, 'Q_CSG1204059-2020', '', 'node', 'IED', 'error', '', '', NULL, 0, 1, '', 0, '', 0, 0, '', '', 0, 0, '', '', '', 1, '1', '2023-04-22 15:37:32');
INSERT INTO `t_scd_scl_check` VALUES (84, '报告控制块属性正确性及规范性检查', '遥测类报告控制块使用无缓冲报告控制块类型，报告控制块名称以 urcb 开头；遥信、告警类报告控制块为有缓冲报告控制块类型，报告控制块名称以 brcb 开头', '', 98399, 'DL/T1873', '10.2', 'node', 'IED', 'error', '', '', NULL, 0, 1, '', 0, '', 0, 0, '', '', 0, 0, '', '', '', 1, '1', '2023-04-22 15:38:08');
INSERT INTO `t_scd_scl_check` VALUES (85, 'LN引用LNodeType不存在', 'LN引用LNodeType不存在', '', 2053, 'DL/T1873', '10.2', 'node', 'DataTypeTemplates', 'error', '', '', NULL, 0, 1, '', 0, '', 0, 0, '', '', 0, 0, '', '', '', 1, '1', '2023-04-22 15:42:54');
INSERT INTO `t_scd_scl_check` VALUES (86, 'DOI/SDI引用模板不一致', 'DOI/SDI引用模板不一致', '', 2053, 'DL/T1873', '10.2', 'node', 'DataTypeTemplates', 'error', '', '', NULL, 0, 1, '', 0, '', 0, 0, '', '', 0, 0, '', '', '', 1, '1', '2023-04-22 15:43:03');
INSERT INTO `t_scd_scl_check` VALUES (87, 'DAI引用模板不一致', 'DAI引用模板不一致', '', 2053, 'DL/T1873', '10.2', 'node', 'DataTypeTemplates', 'error', '', '', NULL, 0, 1, '', 0, '', 0, 0, '', '', 0, 0, '', '', '', 1, '1', '2023-04-22 15:43:13');
INSERT INTO `t_scd_scl_check` VALUES (88, 'DoType模板引用合法性校验', 'DoType模板引用合法性校验', '', 2051, '', '', 'node', 'DataTypeTemplates', 'error', '', '', NULL, 0, 1, '', 0, '', 0, 0, '', '', 0, 0, '', '', '', 1, '1', '2023-04-22 15:43:48');
INSERT INTO `t_scd_scl_check` VALUES (89, 'DaType模板引用合法性校验', 'DaType模板引用合法性校验', '', 2051, '', '', 'node', 'DataTypeTemplates', 'error', '', '', NULL, 0, 1, '', 0, '', 0, 0, '', '', 0, 0, '', '', '', 1, '1', '2023-04-22 15:44:13');
INSERT INTO `t_scd_scl_check` VALUES (90, 'EnumType模板引用合法性校验', 'EnumType模板引用合法性校验', '', 2051, '', '', 'node', 'DataTypeTemplates', 'error', '', '', NULL, 0, 1, '', 0, '', 0, 0, '', '', 0, 0, '', '', '', 1, '1', '2023-04-22 15:44:32');
INSERT INTO `t_scd_scl_check` VALUES (91, '模板重复定义校验', '模板重复定义校验', '', 2050, 'DL/T1873', '10.2', 'node', 'DataTypeTemplates', 'error', '', '', NULL, 0, 1, '', 0, '', 0, 0, '', '', 0, 0, '', '', '', 1, '1', '2023-04-22 15:45:02');
INSERT INTO `t_scd_scl_check` VALUES (92, '冗余模板校验', '是否存在未被引用的模板', '', 2051, 'DL/T1873', '10.2', 'node', 'DataTypeTemplates', 'error', '', '', NULL, 0, 1, '', 0, '', 0, 0, '', '', 0, 0, '', '', '', 1, '1', '2023-04-22 15:45:51');
INSERT INTO `t_scd_scl_check` VALUES (93, '语法校验', 'SCD的XML语法是否符合规范', '', 2056, '', '', 'node', 'SCLSyntax', 'waring', '', '', NULL, 0, 1, '', 0, '', 0, 0, '', '', 0, 0, '', '', '', 1, '1', '2023-04-23 00:06:56');
INSERT INTO `t_scd_scl_check` VALUES (94, 'SSD关联关系错误', 'Substation中存在层级关系错误', '', 2048, '', 'GB/T1874、6.1.2', 'node', 'Substation', 'error', '', '', NULL, 0, 1, '', 0, '', 0, 0, '', '', 0, 0, '', '', '', 1, '1', '2023-05-10 00:38:08');
INSERT INTO `t_scd_scl_check` VALUES (95, 'Substation对象缺失CIME-dtype元素', 'Substation对象缺失CIME-dtype元素', '', 2048, 'GB/T1874', '7.1', 'node', 'Substation', 'error', '', '', NULL, 0, 1, '', 0, '', 0, 0, '', '', 0, 0, '', '', '', 1, '1', '2023-05-10 00:41:41');
INSERT INTO `t_scd_scl_check` VALUES (96, 'Substation对象对应CIME-dtype中desc属性值错误', 'Substation对象对应CIME-dtype中desc属性值错误', '', 2048, 'GB/T1874', '7.1', 'node', 'Substation', 'error', '', '', NULL, 0, 1, '', 0, '', 0, 0, '', '', 0, 0, '', '', '', 1, '1', '2023-05-10 00:42:26');
INSERT INTO `t_scd_scl_check` VALUES (97, 'Substation对象缺失CIME-area元素', 'Substation对象缺失CIME-area元素', '', 2048, 'GB/T1874', '7.1', 'node', 'Substation', 'error', '', '', NULL, 0, 1, '', 0, '', 0, 0, '', '', 0, 0, '', '', '', 1, '1', '2023-05-10 00:43:10');
INSERT INTO `t_scd_scl_check` VALUES (98, 'Substation对象对应CIME-area中属性缺失', 'Substation对象对应CIME-area中属性缺失', '', 2048, 'GB/T1874', '7.1', 'node', 'Substation', 'error', '', '', NULL, 0, 1, '', 0, '', 0, 0, '', '', 0, 0, '', '', '', 1, '1', '2023-05-10 00:44:04');
INSERT INTO `t_scd_scl_check` VALUES (99, 'Bay对象缺失CIME-dtype元素', 'Bay对象缺失CIME-dtype元素', '', 2048, 'GB/T1874', '7.3.3.2', 'node', 'Substation', 'error', '', '', NULL, 0, 1, '', 0, '', 0, 0, '', '', 0, 0, '', '', '', 1, '1', '2023-05-10 00:45:16');
INSERT INTO `t_scd_scl_check` VALUES (100, 'Bay对象对应CIME-dtype中desc属性值错误', 'Bay对象对应CIME-dtype中desc属性值错误', '', 2048, 'GB/T1874', '7.3.3.2', 'node', 'Substation', 'error', '', '', NULL, 0, 1, '', 0, '', 0, 0, '', '', 0, 0, '', '', '', 1, '1', '2023-05-10 00:46:09');
INSERT INTO `t_scd_scl_check` VALUES (101, 'Bay对象对应CIME-dtype中desc属性值错误', 'Bay对象对应CIME-dtype中desc属性值错误', '', 2048, 'GB/T1874', '7.3.3.2', 'node', 'Substation', 'error', '', '', NULL, 0, 1, '', 0, '', 0, 0, '', '', 0, 0, '', '', '', 1, '1', '2023-05-10 00:46:56');
INSERT INTO `t_scd_scl_check` VALUES (102, 'PowerTransformer对象命名错误', 'PowerTransformer对象命名错误', '', 2048, 'GB/T1874', '7.4.1.1', 'node', 'Substation', 'error', '', '', NULL, 0, 1, '', 0, '', 0, 0, '', '', 0, 0, '', '', '', 1, '1', '2023-05-10 00:47:43');
INSERT INTO `t_scd_scl_check` VALUES (103, 'PowerTransformer对象type错误', 'PowerTransformer对象type错误', '', 2048, 'GB/T1874', '附录D', 'node', 'Substation', 'error', '', '', NULL, 0, 1, '', 0, '', 0, 0, '', '', 0, 0, '', '', '', 1, '1', '2023-05-10 00:48:38');
INSERT INTO `t_scd_scl_check` VALUES (104, 'TransformerWinding对象缺失CIME-voltageLevel', 'TransformerWinding对象缺失CIME-voltageLevel', '', 2048, 'GB/T1874', '7.4.1.3', 'node', 'Substation', 'error', '', '', NULL, 0, 1, '', 0, '', 0, 0, '', '', 0, 0, '', '', '', 1, '1', '2023-05-10 00:50:03');
INSERT INTO `t_scd_scl_check` VALUES (105, 'TransformerWinding对象中CIME-voltageLevel属性错误或缺失', 'TransformerWinding 对象中包含一个用来描述绕组所属电压等级的 Private 元素，该元素的类型type为“CIME-voltageLevel”，含有name（电压等级名称）和 desc（电压等级描述）两个属 性，其中name取值应为某VoltageLevel对象的name属性值', '', 2048, 'GB/T1874', '7.4.1.3', 'node', 'Substation', 'error', '', '', NULL, 0, 1, '', 0, '', 0, 0, '', '', 0, 0, '', '', '', 1, '1', '2023-05-10 00:51:52');
INSERT INTO `t_scd_scl_check` VALUES (106, 'ConductingEquipment命名错误', '在同一Bay内，不应有两个同名的ConductingEquipment元素', '', 2048, 'GB/T1874', '7.4.2.1', 'node', 'Substation', 'error', '', '', NULL, 0, 1, '', 0, '', 0, 0, '', '', 0, 0, '', '', '', 1, '1', '2023-05-10 00:52:51');
INSERT INTO `t_scd_scl_check` VALUES (107, 'ConductingEquipment对象缺失CIME-dtype元素', 'ConductingEquipment对象缺失CIME-dtype元素', '', 2048, 'GB/T1874', '7.4.2.4', 'node', 'Substation', 'error', '', '', NULL, 0, 1, '', 0, '', 0, 0, '', '', 0, 0, '', '', '', 1, '1', '2023-05-10 00:53:50');
INSERT INTO `t_scd_scl_check` VALUES (108, 'ConductingEquipment对象对应CIME-dtype中desc属性值错误', '设备对象中包含一个用来描述设备详细类型的 Private 元素，该元素的类型type为“ CIMEdtype”，含有desc（详细类型描述）属性', '', 2048, 'GB/T1874', '7.4.2.4', 'node', 'Substation', 'error', '', '', NULL, 0, 1, '', 0, '', 0, 0, '', '', 0, 0, '', '', '', 1, '1', '2023-05-10 00:57:02');
INSERT INTO `t_scd_scl_check` VALUES (109, 'ConnectivityNode对象命名错误', 'ConnectivityNode 的 name 属性强制要求列明，作为标识间隔内 ConnectivityNode 实例，按照 Cn 进行命名（ n 为间隔内 ConnectivityNode 实例的序号）', '', 2048, 'GB/T 1874', '7.4.5.1', 'node', 'Substation', 'error', '', '', NULL, 0, 1, '', 0, '', 0, 0, '', '', 0, 0, '', '', '', 1, '1', '2023-05-10 00:57:53');
INSERT INTO `t_scd_scl_check` VALUES (110, '间隔关联逻辑节点不存在', '应把间隔相关的逻辑节点全部关联到间隔', '', 2048, 'GB/T 1874', '7.3.3.6', 'node', 'Substation', 'error', '', '', NULL, 0, 1, '', 0, '', 0, 0, '', '', 0, 0, '', '', '', 1, '1', '2023-05-10 00:59:00');

-- ----------------------------
-- Table structure for t_scd_sclcontrol_attrs
-- ----------------------------
DROP TABLE IF EXISTS `t_scd_sclcontrol_attrs`;
CREATE TABLE `t_scd_sclcontrol_attrs`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `scd_id` bigint(0) NOT NULL,
  `node_id` bigint(0) NOT NULL COMMENT '所属节点ID',
  `attr_desc` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `CREATED_BY` int(0) NULL DEFAULT 0 COMMENT '创建人',
  `CREATED_TIME` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `q1`(`scd_id`) USING BTREE,
  INDEX `q2`(`node_id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 392 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'SCLControl节点属性' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for t_scd_sdi_attrs
-- ----------------------------
DROP TABLE IF EXISTS `t_scd_sdi_attrs`;
CREATE TABLE `t_scd_sdi_attrs`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `scd_id` bigint(0) NOT NULL,
  `node_id` bigint(0) NOT NULL COMMENT '所属节点ID',
  `attr_name` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `attr_desc` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_Ix` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `CREATED_BY` int(0) NULL DEFAULT 0 COMMENT '创建人',
  `CREATED_TIME` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `q1`(`scd_id`) USING BTREE,
  INDEX `q2`(`node_id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 2962493 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'SDI节点属性' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for t_scd_sdo_attrs
-- ----------------------------
DROP TABLE IF EXISTS `t_scd_sdo_attrs`;
CREATE TABLE `t_scd_sdo_attrs`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `scd_id` bigint(0) NOT NULL,
  `node_id` bigint(0) NOT NULL COMMENT '所属节点ID',
  `attr_desc` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_type` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `attr_name` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `CREATED_BY` int(0) NULL DEFAULT 0 COMMENT '创建人',
  `CREATED_TIME` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `q1`(`scd_id`) USING BTREE,
  INDEX `q2`(`node_id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 6032 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'SDO节点属性' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for t_scd_server_attrs
-- ----------------------------
DROP TABLE IF EXISTS `t_scd_server_attrs`;
CREATE TABLE `t_scd_server_attrs`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `scd_id` bigint(0) NOT NULL,
  `node_id` bigint(0) NOT NULL COMMENT '所属节点ID',
  `attr_name` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_timeout` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `CREATED_BY` int(0) NULL DEFAULT 0 COMMENT '创建人',
  `CREATED_TIME` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `q1`(`scd_id`) USING BTREE,
  INDEX `q2`(`node_id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 4148 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'Server节点属性' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for t_scd_serverat_attrs
-- ----------------------------
DROP TABLE IF EXISTS `t_scd_serverat_attrs`;
CREATE TABLE `t_scd_serverat_attrs`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `scd_id` bigint(0) NOT NULL,
  `node_id` bigint(0) NOT NULL COMMENT '所属节点ID',
  `attr_ap_name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `attr_desc` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `CREATED_BY` int(0) NULL DEFAULT 0 COMMENT '创建人',
  `CREATED_TIME` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `q1`(`scd_id`) USING BTREE,
  INDEX `q2`(`node_id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'ServerAt节点属性' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for t_scd_settingcontrol_attrs
-- ----------------------------
DROP TABLE IF EXISTS `t_scd_settingcontrol_attrs`;
CREATE TABLE `t_scd_settingcontrol_attrs`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `scd_id` bigint(0) NOT NULL,
  `node_id` bigint(0) NOT NULL COMMENT '所属节点ID',
  `attr_desc` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_num_of_sgs` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_act_sg` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `CREATED_BY` int(0) NULL DEFAULT 0 COMMENT '创建人',
  `CREATED_TIME` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `q1`(`scd_id`) USING BTREE,
  INDEX `q2`(`node_id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 5220 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'SettingControl节点属性' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for t_scd_smv_attrs
-- ----------------------------
DROP TABLE IF EXISTS `t_scd_smv_attrs`;
CREATE TABLE `t_scd_smv_attrs`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `scd_id` bigint(0) NOT NULL,
  `node_id` bigint(0) NOT NULL COMMENT '所属节点ID',
  `attr_max` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `CREATED_BY` int(0) NULL DEFAULT 0 COMMENT '创建人',
  `CREATED_TIME` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `q1`(`scd_id`) USING BTREE,
  INDEX `q2`(`node_id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'SMV节点属性' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for t_scd_smvopts_attrs
-- ----------------------------
DROP TABLE IF EXISTS `t_scd_smvopts_attrs`;
CREATE TABLE `t_scd_smvopts_attrs`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `scd_id` bigint(0) NOT NULL,
  `node_id` bigint(0) NOT NULL COMMENT '所属节点ID',
  `attr_refresh_time` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_sample_synchronized` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_sample_rate` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_data_ref` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_security` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `CREATED_BY` int(0) NULL DEFAULT 0 COMMENT '创建人',
  `CREATED_TIME` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `q1`(`scd_id`) USING BTREE,
  INDEX `q2`(`node_id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1036 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'SmvOpts节点属性' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for t_scd_smvsecurity_attrs
-- ----------------------------
DROP TABLE IF EXISTS `t_scd_smvsecurity_attrs`;
CREATE TABLE `t_scd_smvsecurity_attrs`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `scd_id` bigint(0) NOT NULL,
  `node_id` bigint(0) NOT NULL COMMENT '所属节点ID',
  `attr_name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `attr_desc` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_xfer_number` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_serial_number` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `CREATED_BY` int(0) NULL DEFAULT 0 COMMENT '创建人',
  `CREATED_TIME` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `q1`(`scd_id`) USING BTREE,
  INDEX `q2`(`node_id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'SMVSecurity节点属性' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for t_scd_smvsettings_attrs
-- ----------------------------
DROP TABLE IF EXISTS `t_scd_smvsettings_attrs`;
CREATE TABLE `t_scd_smvsettings_attrs`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `scd_id` bigint(0) NOT NULL,
  `node_id` bigint(0) NOT NULL COMMENT '所属节点ID',
  `attr_cb_name` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_dat_set` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_sv_id` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_opt_fields` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_smp_rate` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `CREATED_BY` int(0) NULL DEFAULT 0 COMMENT '创建人',
  `CREATED_TIME` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `q1`(`scd_id`) USING BTREE,
  INDEX `q2`(`node_id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 351 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'SMVSettings节点属性' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for t_scd_subnetwork_attrs
-- ----------------------------
DROP TABLE IF EXISTS `t_scd_subnetwork_attrs`;
CREATE TABLE `t_scd_subnetwork_attrs`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `scd_id` bigint(0) NOT NULL,
  `node_id` bigint(0) NOT NULL COMMENT '所属节点ID',
  `attr_desc` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `attr_type` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `CREATED_BY` int(0) NULL DEFAULT 0 COMMENT '创建人',
  `CREATED_TIME` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `w1`(`scd_id`) USING BTREE,
  INDEX `w2`(`node_id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 226 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'SubNetwork节点属性' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for t_scd_substation_attrs
-- ----------------------------
DROP TABLE IF EXISTS `t_scd_substation_attrs`;
CREATE TABLE `t_scd_substation_attrs`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `scd_id` bigint(0) NOT NULL,
  `node_id` bigint(0) NOT NULL COMMENT '所属节点ID',
  `attr_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_desc` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `CREATED_BY` int(0) NULL DEFAULT 0 COMMENT '创建人',
  `CREATED_TIME` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `q1`(`scd_id`) USING BTREE,
  INDEX `q2`(`node_id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 26 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'Substation节点属性' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for t_scd_sunject_attrs
-- ----------------------------
DROP TABLE IF EXISTS `t_scd_sunject_attrs`;
CREATE TABLE `t_scd_sunject_attrs`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `scd_id` bigint(0) NOT NULL,
  `node_id` bigint(0) NOT NULL COMMENT '所属节点ID',
  `attr_common_name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `attr_id_hierarchy` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `CREATED_BY` int(0) NULL DEFAULT 0 COMMENT '创建人',
  `CREATED_TIME` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `q1`(`scd_id`) USING BTREE,
  INDEX `q2`(`node_id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'Sunject节点属性' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for t_scd_trgops_attrs
-- ----------------------------
DROP TABLE IF EXISTS `t_scd_trgops_attrs`;
CREATE TABLE `t_scd_trgops_attrs`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `scd_id` bigint(0) NOT NULL,
  `node_id` bigint(0) NOT NULL COMMENT '所属节点ID',
  `attr_dchg` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_qchg` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_dupd` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_period` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_gi` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `attr_include_all` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `CREATED_BY` int(0) NULL DEFAULT 0 COMMENT '创建人',
  `CREATED_TIME` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `q1`(`scd_id`) USING BTREE,
  INDEX `q2`(`node_id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 37661 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'TrgOps节点属性' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for t_scd_val_attrs
-- ----------------------------
DROP TABLE IF EXISTS `t_scd_val_attrs`;
CREATE TABLE `t_scd_val_attrs`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `scd_id` bigint(0) NOT NULL,
  `node_id` bigint(0) NOT NULL COMMENT '所属节点ID',
  `attr_sgroup` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `CREATED_BY` int(0) NULL DEFAULT 0 COMMENT '创建人',
  `CREATED_TIME` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `q1`(`scd_id`) USING BTREE,
  INDEX `q2`(`node_id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1055 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'Val节点属性' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for t_scd_voltage_attrs
-- ----------------------------
DROP TABLE IF EXISTS `t_scd_voltage_attrs`;
CREATE TABLE `t_scd_voltage_attrs`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `scd_id` bigint(0) NOT NULL,
  `node_id` bigint(0) NOT NULL COMMENT '所属节点ID',
  `attr_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `CREATED_BY` int(0) NULL DEFAULT 0 COMMENT '创建人',
  `CREATED_TIME` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `q1`(`scd_id`) USING BTREE,
  INDEX `q2`(`node_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 53 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'Private-voltage节点属性' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for t_substation_area
-- ----------------------------
DROP TABLE IF EXISTS `t_substation_area`;
CREATE TABLE `t_substation_area`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `substation_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '所属变电站ID',
  `scd_id` bigint(0) NOT NULL COMMENT 'SCD编号',
  `voltage_level` int(0) NULL DEFAULT NULL COMMENT '电压等级',
  `name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '间隔名称',
  `name_no` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `dispatch_no` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '调度编号',
  `location` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '位置;一般存储相对坐标x、y',
  `CREATED_BY` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建人',
  `CREATED_TIME` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `ind1`(`scd_id`) USING BTREE,
  INDEX `ind2`(`voltage_level`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '站内间隔信息表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for t_sys_attachment
-- ----------------------------
DROP TABLE IF EXISTS `t_sys_attachment`;
CREATE TABLE `t_sys_attachment`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `created_by` int(0) NULL DEFAULT 0 COMMENT '创建人',
  `created_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
  `station_id` int(0) NOT NULL COMMENT '所属站',
  `scd_id` bigint(0) NULL DEFAULT 0 COMMENT '关联scd',
  `ied_name` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `ied_desc` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '装置描述',
  `file_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '文件名称',
  `file_size` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '文件大小',
  `save_path` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '保存路径',
  `file_type` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '文件类型',
  `file_suffix` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '文件后缀',
  `crc_sign` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '认证标记',
  `check_flag` int(0) NULL DEFAULT 0 COMMENT '0 闈炵?鎺?1 绠℃帶',
  `remark` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `ind1`(`station_id`) USING BTREE,
  INDEX `ind2`(`file_name`) USING BTREE,
  INDEX `ind3`(`created_time`) USING BTREE,
  INDEX `ind4`(`scd_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '附件信息' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for t_sys_attachment_download
-- ----------------------------
DROP TABLE IF EXISTS `t_sys_attachment_download`;
CREATE TABLE `t_sys_attachment_download`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `attachment_id` int(0) NOT NULL COMMENT '附件ID',
  `download_user` int(0) NOT NULL COMMENT '下载人员',
  `download_date` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '下载日期',
  `download_desc` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '下载说明',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `ind1`(`attachment_id`) USING BTREE,
  INDEX `ind2`(`download_user`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '附件下载记录表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for t_sys_flow
-- ----------------------------
DROP TABLE IF EXISTS `t_sys_flow`;
CREATE TABLE `t_sys_flow`  (
  `id` bigint(0) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `flow_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '流程名称',
  `flow_type` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '流程类别',
  `act` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '流程动作;流程走完后需要执行的操作',
  `isUsed` int(0) NOT NULL DEFAULT 0 COMMENT '是否启用',
  `CREATED_BY` int(0) NULL DEFAULT NULL COMMENT '创建人',
  `CREATED_TIME` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `UPDATED_BY` int(0) NULL DEFAULT NULL COMMENT '更新人',
  `UPDATED_TIME` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '系统流程表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of t_sys_flow
-- ----------------------------
INSERT INTO `t_sys_flow` VALUES (3, 'SCD签入', 'scdin', NULL, 1, NULL, '2022-09-21 17:09:45', NULL, '2022-09-21 17:10:01');
INSERT INTO `t_sys_flow` VALUES (4, 'SCD签出', 'scdout', NULL, 1, NULL, '2022-09-21 17:10:00', NULL, '2022-09-21 17:10:03');

-- ----------------------------
-- Table structure for t_sys_flow_node
-- ----------------------------
DROP TABLE IF EXISTS `t_sys_flow_node`;
CREATE TABLE `t_sys_flow_node`  (
  `id` bigint(0) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `flow_id` int(0) NULL DEFAULT NULL COMMENT '流程id',
  `node_code` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `node_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '节点名称',
  `node_type` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '节点类别',
  `node_position` int(0) NULL DEFAULT NULL,
  `act` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '流程动作;流程走完后需要执行的操作',
  `CREATED_BY` int(0) NULL DEFAULT NULL COMMENT '创建人',
  `CREATED_TIME` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `UPDATED_BY` int(0) NULL DEFAULT NULL COMMENT '更新人',
  `UPDATED_TIME` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 8 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '系统流程节点' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of t_sys_flow_node
-- ----------------------------
INSERT INTO `t_sys_flow_node` VALUES (1, 3, 'checkinstart', '编制', 'start', 0, 'next', NULL, '2022-09-16 10:31:37', NULL, '2022-09-21 17:11:17');
INSERT INTO `t_sys_flow_node` VALUES (2, 3, 'checkincheck', '校验', 'normal', 1, 'next', NULL, '2022-09-16 10:32:20', NULL, '2022-09-21 17:11:19');
INSERT INTO `t_sys_flow_node` VALUES (3, 3, 'checkinaudit', '审核', 'normal', 2, 'next', NULL, '2022-09-16 10:32:37', NULL, '2022-09-21 17:11:20');
INSERT INTO `t_sys_flow_node` VALUES (4, 3, 'checkinend', '发布', 'end', 3, NULL, NULL, '2022-09-16 10:32:47', NULL, '2022-09-21 17:11:22');
INSERT INTO `t_sys_flow_node` VALUES (5, 4, 'checkoutstart', '签出', 'start', 0, 'next', NULL, '2022-09-16 10:54:55', NULL, '2022-09-21 17:11:23');
INSERT INTO `t_sys_flow_node` VALUES (6, 4, 'checkoutcheck', '校核', 'normal', 1, 'next', NULL, '2022-09-16 10:55:15', NULL, '2022-09-21 17:11:25');
INSERT INTO `t_sys_flow_node` VALUES (7, 4, 'checkoutend', '审核', 'end', 2, NULL, NULL, '2022-09-16 10:55:32', NULL, '2022-09-21 17:11:26');

-- ----------------------------
-- Table structure for t_sys_flow_node_staff_ref
-- ----------------------------
DROP TABLE IF EXISTS `t_sys_flow_node_staff_ref`;
CREATE TABLE `t_sys_flow_node_staff_ref`  (
  `id` bigint(0) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `station_id` bigint(0) NOT NULL COMMENT '变电站ID',
  `flow_id` bigint(0) NOT NULL COMMENT '流程ID',
  `node_id` bigint(0) NOT NULL COMMENT '节点ID',
  `staff_id` bigint(0) NOT NULL COMMENT '处理人员ID',
  `CREATED_BY` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建人',
  `CREATED_TIME` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 54 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '流程节点与处理人员关系表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for t_sys_flow_run
-- ----------------------------
DROP TABLE IF EXISTS `t_sys_flow_run`;
CREATE TABLE `t_sys_flow_run`  (
  `id` bigint(0) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `station_id` bigint(0) NOT NULL COMMENT '变电站ID',
  `flow_id` bigint(0) NOT NULL COMMENT '流程ID',
  `scd_path` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'SCD文件路径',
  `scd_name` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'SCD文件名称',
  `deal_state` int(0) NOT NULL DEFAULT 0 COMMENT '处理状态;0处理中  1结束 2驳回',
  `start_date` datetime(0) NOT NULL COMMENT '开始处理时间',
  `finish_date` datetime(0) NULL DEFAULT NULL COMMENT '处理完成时间',
  `is_dispose` int(0) NULL DEFAULT 0 COMMENT '是否强制终止',
  `dispose_staff` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '终止人',
  `dispose_reason` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '终止原因',
  `dispose_dt` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '终止时间',
  `CREATED_BY` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '0' COMMENT '创建人',
  `CREATED_TIME` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 52 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '流程执行记录表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for t_sys_flow_run_detail
-- ----------------------------
DROP TABLE IF EXISTS `t_sys_flow_run_detail`;
CREATE TABLE `t_sys_flow_run_detail`  (
  `id` bigint(0) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `flow_run_id` bigint(0) NOT NULL,
  `node_id` bigint(0) NOT NULL COMMENT '节点ID',
  `work_book_id` bigint(0) NULL DEFAULT NULL COMMENT '工作内容台账ID',
  `deal_state` int(0) NOT NULL DEFAULT 0 COMMENT '当前节点处理状态;0处理中  1处理完成',
  `deal_result` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '0' COMMENT '处理结果;0未通过 1 通过',
  `deal_staff_id` bigint(0) NULL DEFAULT NULL COMMENT '处理人员ID',
  `deal_comment` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '处理意见',
  `start_date` datetime(0) NOT NULL COMMENT '开始处理时间',
  `finish_date` datetime(0) NULL DEFAULT NULL COMMENT '处理完成时间',
  `CREATED_BY` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '0' COMMENT '创建人',
  `CREATED_TIME` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `ind2`(`node_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 121 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '流程执行记录表' ROW_FORMAT = Dynamic;

DROP TABLE IF EXISTS t_data_task;
CREATE TABLE t_data_task(
    id INT NOT NULL AUTO_INCREMENT  COMMENT '主键' ,
    name VARCHAR(50) NOT NULL   COMMENT '任务名称' ,
    code VARCHAR(64) NOT NULL   COMMENT '任务编号' ,
    station_id INT NOT NULL  DEFAULT 0 COMMENT '所属变电站' ,
    scd_id bigint NOT NULL  DEFAULT 0 COMMENT 'SCD文件编号' ,
    report_id INT NOT NULL  DEFAULT 0 COMMENT '报告模板ID' ,
    memo VARCHAR(255)    COMMENT '任务说明' ,
    state INT NOT NULL  DEFAULT 0 COMMENT '检测状态;0 未检查 1 检测中 2检测结束 3 异常中断' ,
    start_time DATETIME    COMMENT '开始检测时间' ,
    end_time DATETIME    COMMENT '检测结束时间' ,
    cr INT   DEFAULT 0 COMMENT '创建人' ,
    ct DATETIME   DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间' ,
    ur INT   DEFAULT 0 COMMENT '更新人' ,
    ut DATETIME   DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间' ,
    PRIMARY KEY (id)
)  COMMENT = '检测任务';

DROP TABLE IF EXISTS t_data_task_model;
CREATE TABLE t_data_task_model(
    id INT NOT NULL AUTO_INCREMENT  COMMENT '主键' ,
    task_id INT NOT NULL   COMMENT '任务ID' ,
    model_id INT NOT NULL   COMMENT '模型ID' ,
    cr INT   DEFAULT 0 COMMENT '创建人' ,
    ct DATETIME   DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间' ,
    ur INT   DEFAULT 0 COMMENT '更新人' ,
    ut DATETIME   DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间' ,
    PRIMARY KEY (id)
)  COMMENT = '检测任务采用模型';

DROP TABLE IF EXISTS t_data_task_check_step;
CREATE TABLE t_data_task_check_step(
    id INT NOT NULL AUTO_INCREMENT  COMMENT '主键' ,
    task_id INT NOT NULL   COMMENT '任务ID' ,
    task_step_id INT NOT NULL  DEFAULT 0 COMMENT '检测步骤ID;关联代码：CHECK_STEP' ,
    state INT NOT NULL   COMMENT '检测状态;0 未开始 1 检测中 2 已完成' ,
    cr INT   DEFAULT 0 COMMENT '创建人' ,
    ct DATETIME   DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间' ,
    ur INT   DEFAULT 0 COMMENT '更新人' ,
    ut DATETIME   DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间' ,
    PRIMARY KEY (id)
)  COMMENT = '检测任务检测过程步骤';

DROP TABLE IF EXISTS t_data_model_defualt;
CREATE TABLE t_data_model_defualt(
    id INT NOT NULL AUTO_INCREMENT  COMMENT '主键' ,
    model_name VARCHAR(64) NOT NULL   COMMENT '模型名称' ,
    area_id INT NOT NULL   COMMENT '所属间隔ID' ,
    vol_id INT NOT NULL   COMMENT '所属电压等级ID' ,
    line_link_style VARCHAR(32)    COMMENT '接线方式;关联代码：LINE_LINK_STYLE' ,
    relation_json text    COMMENT '关系定义内容' ,
    cr INT   DEFAULT 0 COMMENT '创建人' ,
    ct DATETIME   DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间' ,
    ur INT   DEFAULT 0 COMMENT '更新人' ,
    ut DATETIME   DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间' ,
    PRIMARY KEY (id)
)  COMMENT = '内置模型';

DROP TABLE IF EXISTS t_data_model_relation_def;
CREATE TABLE t_data_model_relation_def(
    id INT NOT NULL AUTO_INCREMENT  COMMENT '主键' ,
    model_id INT NOT NULL  DEFAULT 0 COMMENT '模型ID' ,
    custem_model_id INT NOT NULL  DEFAULT 0 COMMENT '自定义模型ID' ,
    from_ied_code VARCHAR(10) NOT NULL   COMMENT '装置类型1;关联代码：device_type' ,
    from_ied_name VARCHAR(90) NOT NULL   COMMENT '装置名称1' ,
    to_ied_name VARCHAR(90) NOT NULL   COMMENT '装置名称2' ,
    to_ied_code VARCHAR(10) NOT NULL   COMMENT '装置类型2;关联代码：device_type' ,
    in_type VARCHAR(10)   DEFAULT 'GOOSE' COMMENT '输入端子类型;SV,GOOSE' ,
    cr INT   DEFAULT 0 COMMENT '创建人' ,
    ct DATETIME   DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间' ,
    ur INT   DEFAULT 0 COMMENT '更新人' ,
    ut DATETIME   DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间' ,
    PRIMARY KEY (id)
)  COMMENT = '模型关联关系定义';

DROP TABLE IF EXISTS t_data_model_func_def;
CREATE TABLE t_data_model_func_def(
    id INT NOT NULL AUTO_INCREMENT  COMMENT '主键' ,
    relation_id INT NOT NULL  DEFAULT 0 COMMENT '模型关系ID' ,
    from_ied_func text NOT NULL   COMMENT '装置功能点' ,
    to_ied_func text NOT NULL   COMMENT '装置功能点' ,
    link_func text NOT NULL   COMMENT '关联功能' ,
    cr INT   DEFAULT 0 COMMENT '创建人' ,
    ct DATETIME   DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间' ,
    ur INT   DEFAULT 0 COMMENT '更新人' ,
    ut DATETIME   DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间' ,
    PRIMARY KEY (id)
)  COMMENT = '模型功能定义';

DROP TABLE IF EXISTS t_data_model_custem;
CREATE TABLE t_data_model_custem(
    id INT NOT NULL AUTO_INCREMENT  COMMENT '主键' ,
    model_name VARCHAR(64) NOT NULL   COMMENT '模型名称' ,
    ref_id INT NOT NULL   COMMENT '引用的内置模型ID' ,
    relation_json text    COMMENT '关系定义内容' ,
    cr INT   DEFAULT 0 COMMENT '创建人' ,
    ct DATETIME   DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间' ,
    ur INT   DEFAULT 0 COMMENT '更新人' ,
    ut DATETIME   DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间' ,
    PRIMARY KEY (id)
)  COMMENT = '自定义模型';

DROP TABLE IF EXISTS t_data_task_report;
CREATE TABLE t_data_task_report(
    id INT NOT NULL AUTO_INCREMENT  COMMENT '主键' ,
    name VARCHAR(50) NOT NULL   COMMENT '报告名称' ,
    code VARCHAR(64) NOT NULL   COMMENT '报告编号' ,
    task_id INT NOT NULL  DEFAULT 0 COMMENT '所属检测任务' ,
    state INT NOT NULL  DEFAULT 0 COMMENT '生成状态;1 生成中 2生成结束' ,
    doc VARCHAR(255)    COMMENT '下载路径' ,
    cr INT   DEFAULT 0 COMMENT '创建人' ,
    ct DATETIME   DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间' ,
    ur INT   DEFAULT 0 COMMENT '更新人' ,
    ut DATETIME   DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间' ,
    PRIMARY KEY (id)
)  COMMENT = '检测任务报告';

DROP TABLE IF EXISTS t_data_model_func_group;
CREATE TABLE t_data_model_func_group(
    id INT NOT NULL AUTO_INCREMENT  COMMENT '主键' ,
    relation_id INT NOT NULL  DEFAULT 0 COMMENT '模型关系ID' ,
    group_name VARCHAR(90) NOT NULL   COMMENT '分组名称' ,
    func_name VARCHAR(90) NOT NULL   COMMENT '功能名称' ,
    cr INT   DEFAULT 0 COMMENT '创建人' ,
    ct DATETIME   DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间' ,
    ur INT   DEFAULT 0 COMMENT '更新人' ,
    ut DATETIME   DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间' ,
    PRIMARY KEY (id)
)  COMMENT = '模型功能分组';


SET FOREIGN_KEY_CHECKS = 1;