Skip to main content
summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
Diffstat (limited to 'openk-platform/openk-cachedb-service/src/test/sql/cachedb-insert-data.sql')
-rw-r--r--openk-platform/openk-cachedb-service/src/test/sql/cachedb-insert-data.sql348
1 files changed, 235 insertions, 113 deletions
diff --git a/openk-platform/openk-cachedb-service/src/test/sql/cachedb-insert-data.sql b/openk-platform/openk-cachedb-service/src/test/sql/cachedb-insert-data.sql
index bcd00ed0..af20b99d 100644
--- a/openk-platform/openk-cachedb-service/src/test/sql/cachedb-insert-data.sql
+++ b/openk-platform/openk-cachedb-service/src/test/sql/cachedb-insert-data.sql
@@ -6,23 +6,14 @@ INSERT INTO EQUIPMENT_CONTAINER VALUES (1000, '7788', 'Substation01 - Ortsnetzst
INSERT INTO EQUIPMENT_CONTAINER VALUES (1001, '23222666', 'Substation02 - Ortsnetzstation Störzelbach',null,null,null, 'SubstationType', null, 1000);
INSERT INTO EQUIPMENT_CONTAINER VALUES (1002, '2366456', 'Substation03 - Ortsnetzstation Alesheim04',null,null,null, 'SubstationType', null, 1000);
INSERT INTO EQUIPMENT_CONTAINER VALUES (1003, '236453466', 'Substation04 - Ortsnetzstation A02',null,null,null, 'SubstationType', null, 1000);
-INSERT INTO EQUIPMENT_CONTAINER VALUES (1005, '34423666', 'Substation05 - Ortsnetzstation A06',null,null,null, 'SubstationType', null, 1000);
-INSERT INTO EQUIPMENT_CONTAINER VALUES (1006, '2367766', 'Substation06 - Ortsnetzstation Alesheim06',null,null,null, 'SubstationType', null, 1000);
-INSERT INTO EQUIPMENT_CONTAINER VALUES (1007, '2368866', 'Substation07 - Ortsnetzstation A03',null,null,null, 'SubstationType', null, 1000);
-INSERT INTO EQUIPMENT_CONTAINER VALUES (1008, '23633366', 'Substation08 - Ortsnetzstation W02',null,null,null, 'SubstationType', null, 1000);
-INSERT INTO EQUIPMENT_CONTAINER VALUES (1009, '23633366', 'Substation09 - Umspannwerk WAHF',null,null,null, 'SubstationType', null, 1000);
-INSERT INTO EQUIPMENT_CONTAINER VALUES (1010, '236634336', 'VoltageLevel01 - 110kV', 110, 'KILO', 'V', 'VoltageLevelType', 1009, null);
-INSERT INTO EQUIPMENT_CONTAINER VALUES (1011, '8974455', 'VoltageLevel02', 20,'KILO','V','VoltageLevelType', 1009, null);
-INSERT INTO EQUIPMENT_CONTAINER VALUES (1012, '23633366', 'Substation10 - Ortsnetzstation Alesheim05A',null,null,null, 'SubstationType', null, 1000);
-
-INSERT INTO AC_LINE_SEGMENT VALUES (1000, '45889', 'Cable01', 1000);
-INSERT INTO AC_LINE_SEGMENT VALUES (1001, '1034534501', 'Cable02', 1001);
-INSERT INTO AC_LINE_SEGMENT VALUES (1002, '1034534501', 'Cable03', 1003);
-INSERT INTO AC_LINE_SEGMENT VALUES (1003, '1034534501', 'Cable04', 1005);
-INSERT INTO AC_LINE_SEGMENT VALUES (1004, '10454301', 'Cable05', 1006);
-INSERT INTO AC_LINE_SEGMENT VALUES (1005, '1042534234301', 'Cable06', 1007);
-INSERT INTO AC_LINE_SEGMENT VALUES (1006, '104234301', 'Cable07', 1008);
-INSERT INTO AC_LINE_SEGMENT VALUES (1007, '188804234301', 'Cable08', 1010);
+INSERT INTO EQUIPMENT_CONTAINER VALUES (1004, '34423666', 'Substation05 - Ortsnetzstation A06',null,null,null, 'SubstationType', null, 1000);
+INSERT INTO EQUIPMENT_CONTAINER VALUES (1005, '2367766', 'Substation06 - Ortsnetzstation Alesheim 01',null,null,null, 'SubstationType', null, 1000);
+INSERT INTO EQUIPMENT_CONTAINER VALUES (1006, '2368866', 'Substation07 - Ortsnetzstation A03',null,null,null, 'SubstationType', null, 1000);
+INSERT INTO EQUIPMENT_CONTAINER VALUES (1007, '2365633366', 'Substation08 - Ortsnetzstation W02',null,null,null, 'SubstationType', null, 1000);
+INSERT INTO EQUIPMENT_CONTAINER VALUES (1008, '23634883366', 'Substation09 - Umspannwerk WAHF',null,null,null, 'SubstationType', null, 1000);
+INSERT INTO EQUIPMENT_CONTAINER VALUES (1009, '236634589336', 'VoltageLevel01 - 110kV', 110, 'KILO', 'V', 'VoltageLevelType', 1009, null);
+INSERT INTO EQUIPMENT_CONTAINER VALUES (1010, '8974455', 'VoltageLevel02', 20,'KILO','V','VoltageLevelType', 1009, null);
+INSERT INTO EQUIPMENT_CONTAINER VALUES (1011, '23633366', 'Substation10 - Ortsnetzstation Alesheim05A',null,null,null, 'SubstationType', null, 1000);
INSERT INTO generating_unit(
id, high_control_limit_value, high_control_limit_unit_multiplier,
@@ -41,6 +32,7 @@ INSERT INTO generating_unit(
VALUES (1002,33, 'KILO', 'W',222,'KILO','W','IS_CONTROLLABLE','WIND');
--###########################################################################
-- weitere Beispiele fuer Abschaltvorgang
+/*
INSERT INTO generating_unit(
id, high_control_limit_value, high_control_limit_unit_multiplier,
high_control_limit_unit_symbol, max_operating_power_limit_value,
@@ -61,6 +53,7 @@ INSERT INTO generating_unit(
high_control_limit_unit_symbol, max_operating_power_limit_value,
max_operating_power_unit_multiplier, max_operating_power_unit_symbol, control_source, unit_type)
VALUES (9003,33, 'KILO', 'W',222,'KILO','W','IS_CONTROLLABLE','WIND');
+*/
--###########################################################################
INSERT INTO location(id, name, email,street_name, street_number, postal_code,city,country)
@@ -75,32 +68,41 @@ INSERT INTO location(id, name, email,street_name, street_number, postal_code,cit
INSERT INTO position_point VALUES(1000,null,'56.002554','20.00122',null, 1000);
INSERT INTO synchronous_machine(id, mrid, name, synchronous_machine_kind, communication_type,
- normally_in_service, generating_unit_id, location_id, equipment_container_id, feed_in_ranking,
- communication_group, control_enabled, synchronous_machine_id)
+ normally_in_service, generating_unit_id, location_id, equipment_container_id, feed_in_ranking, FEED_IN_PRIORITY,
+ max_voltage_limit_value, MAX_VOLTAGE_LIMIT_UNIT_MULTIPLIER, MAX_VOLTAGE_LIMIT_UNIT_SYMBOL,
+ communication_group, control_enabled, CURRENT_REDUCTION_SETTING_PER_CENT, status_current_reduction_setting, synchronous_machine_id)
VALUES (1000,'458899', 'SynchronousMachine01', 'GENERATOR' , 'EFT',
- 'TRUE', 1000, 1000, 1000, 14,
- 1, 'TRUE', null);
-INSERT INTO synchronous_machine(id, mrid, name, synchronous_machine_kind, communication_type,
- normally_in_service, generating_unit_id,location_id, equipment_container_id, feed_in_ranking,
- communication_group, control_enabled, synchronous_machine_id)
+ 'TRUE', 1000, 1000, 1000, 14,1,
+ 30, 'KILO', 'W',
+ 1, 'TRUE', '60', true, null);
+INSERT INTO synchronous_machine(id, mrid, name, synchronous_machine_kind, communication_type,
+ normally_in_service, generating_unit_id, location_id, equipment_container_id, feed_in_ranking, FEED_IN_PRIORITY,
+ max_voltage_limit_value, MAX_VOLTAGE_LIMIT_UNIT_MULTIPLIER, MAX_VOLTAGE_LIMIT_UNIT_SYMBOL,
+ communication_group, control_enabled, CURRENT_REDUCTION_SETTING_PER_CENT, status_current_reduction_setting, synchronous_machine_id)
VALUES (1001, '2000', 'SynchronousMachine02', 'GENERATOR', 'EFT',
- 'TRUE', 1001, 1001, 1000, 15,
- 1, 'TRUE', 1000);
-INSERT INTO synchronous_machine(id, mrid, name, synchronous_machine_kind, communication_type,
- normally_in_service, generating_unit_id,location_id, equipment_container_id, feed_in_ranking,
- communication_group, control_enabled, synchronous_machine_id)
+ 'TRUE', 1001, 1001, 1000, 15, 1,
+ 30, 'KILO', 'W',
+ 1, 'TRUE', '90', true, 1000);
+INSERT INTO synchronous_machine(id, mrid, name, synchronous_machine_kind, communication_type,
+ normally_in_service, generating_unit_id, location_id, equipment_container_id, feed_in_ranking,FEED_IN_PRIORITY,
+ max_voltage_limit_value, MAX_VOLTAGE_LIMIT_UNIT_MULTIPLIER, MAX_VOLTAGE_LIMIT_UNIT_SYMBOL,
+ communication_group, control_enabled, CURRENT_REDUCTION_SETTING_PER_CENT, status_current_reduction_setting, synchronous_machine_id)
VALUES (1002, '1002', 'SynchronousMachine03', 'GENERATOR', 'EFT',
- 'TRUE', 1002, 1002, 1002, 15,
- 1, 'TRUE', 1000);
+ 'TRUE', 1002, 1002, 1002, 15, 1,
+ 30, 'KILO', 'W',
+ 1, 'TRUE', '80', true, 1000);
-- Beispiel: SynchronousMachine an VoltageLevel
+/*
INSERT INTO synchronous_machine(id, mrid, name, synchronous_machine_kind, communication_type,
normally_in_service, generating_unit_id,location_id, equipment_container_id, feed_in_ranking,
communication_group, control_enabled, synchronous_machine_id)
VALUES (1003, '1002', 'SynchronousMachine99', 'GENERATOR', 'EFT',
'TRUE', 1002, 1002, 1011, 15,
1, 'TRUE', 1000);
+*/
--###########################################################################
-- weitere Beispiele fuer Abschaltvorgang
+/*
INSERT INTO synchronous_machine(id, mrid, name, synchronous_machine_kind, communication_type,
normally_in_service, generating_unit_id,location_id, equipment_container_id, feed_in_ranking,
communication_group, control_enabled, synchronous_machine_id)
@@ -125,10 +127,17 @@ INSERT INTO synchronous_machine(id, mrid, name, synchronous_machine_kind, commun
VALUES (9003, '9003', 'SynchronousMachine9003', 'GENERATOR', 'EFT',
'TRUE', 9003, 1001, 1000, 1,
1, 'TRUE', 1000);
-
-
+*/
--###########################################################################
+INSERT INTO OPERATING_PARTICIPANT VALUES (1000, '1000', 'MDN-0479',100, null, null, null,1000, null);
+INSERT INTO OPERATING_PARTICIPANT VALUES (1001, '1000', 'MDN-0479',100, null, null, null,1001, null);
+INSERT INTO OPERATING_PARTICIPANT VALUES (1002, '1000', 'MDN-0479',100, null, null, null,1002, null);
+--INSERT INTO OPERATING_PARTICIPANT VALUES ('1000', 'MDN-0479');
+
+--INSERT INTO OPERATING_SHARE VALUES (1000, 100, '1000', null, null, null, 1000, null);
+--INSERT INTO OPERATING_SHARE VALUES (1001, 100, '1000', null, null, null, 1001, null);
+--INSERT INTO OPERATING_SHARE VALUES (1002, 100, '1000', null, null, null, 1002, null);
INSERT INTO REDUCTION_SETTING VALUES (1000, 10, 1000);
INSERT INTO REDUCTION_SETTING VALUES (1001, 20, 1000);
@@ -143,88 +152,201 @@ INSERT INTO measurement_analog VALUES (1000, '11', 'GeneratorVoltage','KILO','W'
INSERT INTO measurement_analog VALUES (1001, '22', 'GeneratorVoltage','KILO','W',22,222, 2000,1001);
INSERT INTO measurement_analog VALUES (1002, '2233', 'GeneratorVoltage','KILO','W',33,233, 3000,1002);
-INSERT INTO measurement_analog_value VALUES (1000, '10.04.2015 12:12:35', 11.11, 1000);
-INSERT INTO measurement_analog_value VALUES (1001, '10.04.2015 12:12:35', 12.12, 1000);
-INSERT INTO measurement_analog_value VALUES (1002, '10.04.2015 12:12:35', 13.13, 1000);
-INSERT INTO measurement_analog_value VALUES (1003, '10.04.2015 12:12:35', 14.14, 1000);
-INSERT INTO measurement_analog_value VALUES (1004, '10.04.2015 12:12:35', 11.11, 1001);
-INSERT INTO measurement_analog_value VALUES (1005, '10.04.2015 12:12:35', 12.12, 1002);
-INSERT INTO measurement_analog_value VALUES (1006, '10.04.2015 12:12:35', 13.13, 1002);
-INSERT INTO measurement_analog_value VALUES (1007, '10.04.2015 12:12:35', 14.14, 1002);
-
-INSERT INTO POWER_TRANSFORMER VALUES (1000, '1000100', 'PowerTransformer01', 1009);
-
-INSERT INTO BUSBAR_SECTION VALUES (1000, '5488855', 'BusbarSection01', 1011);
-INSERT INTO BUSBAR_SECTION VALUES (1001, '53423488855', 'BusbarSection02', 1011);
-
-INSERT INTO SWITCH VALUES (1000, '1000', 'Switch01','FALSE', 1001);
-INSERT INTO SWITCH VALUES (1001, '2000', 'Switch02','FALSE', 1002);
-INSERT INTO SWITCH VALUES (1002, '3000', 'Switch03','TRUE',1002);
-INSERT INTO SWITCH VALUES (1003, '1003', 'Switch04','TRUE',1002);
-INSERT INTO SWITCH VALUES (1004, '1004', 'Switch05','TRUE',1011);
-INSERT INTO SWITCH VALUES (1005, '1005', 'Switch06','TRUE',1011);
-INSERT INTO SWITCH VALUES (1006, '1006', 'Switch07','TRUE',1011);
-INSERT INTO SWITCH VALUES (1007, '1007', 'Switch08','TRUE',1011);
+INSERT INTO measurement_analog_value VALUES (1000, '10.04.2015 12:12:35', 11.11, false, 1000);
+INSERT INTO measurement_analog_value VALUES (1001, '10.04.2015 12:12:35', 12.12, false, 1000);
+INSERT INTO measurement_analog_value VALUES (1002, '10.04.2015 12:12:35', 13.13, false, 1000);
+INSERT INTO measurement_analog_value VALUES (1003, '10.04.2015 12:12:35', 14.14, false, 1000);
+INSERT INTO measurement_analog_value VALUES (1004, '10.04.2015 12:12:35', 11.11, false, 1001);
+INSERT INTO measurement_analog_value VALUES (1005, '10.04.2015 12:12:35', 12.12, false, 1002);
+INSERT INTO measurement_analog_value VALUES (1006, '10.04.2015 12:12:35', 13.13, false, 1002);
+INSERT INTO measurement_analog_value VALUES (1007, '10.04.2015 12:12:35', 14.14, false, 1002);
+
+INSERT INTO AC_LINE_SEGMENT VALUES (1000, '45889', 'Cable01', 1000);
+INSERT INTO AC_LINE_SEGMENT VALUES (1001, '1034534501', 'Cable02', 1002);
+INSERT INTO AC_LINE_SEGMENT VALUES (1002, '103234501', 'Cable03', 1002);
+INSERT INTO AC_LINE_SEGMENT VALUES (1003, '103/4534501', 'Cable04', 1003);
+INSERT INTO AC_LINE_SEGMENT VALUES (1004, '104557884301', 'Cable05', 1004);
+INSERT INTO AC_LINE_SEGMENT VALUES (1005, '17780301', 'Cable06', 1005);
+INSERT INTO AC_LINE_SEGMENT VALUES (1006, '14/301', 'Cable07', 1006);
+INSERT INTO AC_LINE_SEGMENT VALUES (1007, '14555/01', 'Cable08', 1009);
+
+INSERT INTO POWER_TRANSFORMER VALUES (1000, '1000100', 'PowerTransformer01', 1001);
+INSERT INTO POWER_TRANSFORMER VALUES (1001, '1001', 'PowerTransformer02', 1002);
+INSERT INTO POWER_TRANSFORMER VALUES (1002, '1002', 'PowerTransformer03', 1003);
+INSERT INTO POWER_TRANSFORMER VALUES (1003, '1003', 'PowerTransformer04', 1004);
+INSERT INTO POWER_TRANSFORMER VALUES (1004, '1004', 'PowerTransformer05', 1005);
+INSERT INTO POWER_TRANSFORMER VALUES (1005, '1005', 'PowerTransformer06', 1006);
+INSERT INTO POWER_TRANSFORMER VALUES (1006, '1006', 'PowerTransformer07', 1007);
+INSERT INTO POWER_TRANSFORMER VALUES (1007, '1007', 'PowerTransformer08', 1008);
+
+INSERT INTO BUSBAR_SECTION VALUES (1000, '5488855', 'BusbarSection01', 1010);
+INSERT INTO BUSBAR_SECTION VALUES (1001, '53423488855', 'BusbarSection02', 1010);
+
+INSERT INTO SWITCH VALUES (1000, '1000', 'Switch01','FALSE', 1000);
+INSERT INTO SWITCH VALUES (1001, '2000', 'Switch02','FALSE', 1000);
+INSERT INTO SWITCH VALUES (1002, '3000', 'Switch03','FALSE',1000);
+INSERT INTO SWITCH VALUES (1003, '1003', 'Switch04','FALSE',1001);
+INSERT INTO SWITCH VALUES (1004, '1004', 'Switch05','FALSE',1001);
+INSERT INTO SWITCH VALUES (1005, '1005', 'Switch06','FALSE',1002);
+INSERT INTO SWITCH VALUES (1006, '1006', 'Switch07','FALSE',1002);
+INSERT INTO SWITCH VALUES (1007, '1007', 'Switch08','FALSE',1002);
+INSERT INTO SWITCH VALUES (1008, '1008', 'Switch09','FALSE',1002);
+INSERT INTO SWITCH VALUES (1009, '1009', 'Switch10','FALSE',1002);
+INSERT INTO SWITCH VALUES (1010, '1010', 'Switch11','FALSE',1003);
+INSERT INTO SWITCH VALUES (1011, '1011', 'Switch12','FALSE',1003);
+INSERT INTO SWITCH VALUES (1012, '1012', 'Switch13','FALSE',1003);
+INSERT INTO SWITCH VALUES (1013, '1013', 'Switch14','FALSE',1004);
+INSERT INTO SWITCH VALUES (1014, '1014', 'Switch15','FALSE',1004);
+INSERT INTO SWITCH VALUES (1015, '1015', 'Switch16','FALSE',1004);
+INSERT INTO SWITCH VALUES (1016, '1016', 'Switch17','FALSE',1005);
+INSERT INTO SWITCH VALUES (1017, '1017', 'Switch18','FALSE',1005);
+INSERT INTO SWITCH VALUES (1018, '1018', 'Switch19','FALSE',1005);
+INSERT INTO SWITCH VALUES (1019, '1019', 'Switch20','FALSE',1006);
+INSERT INTO SWITCH VALUES (1020, '1020', 'Switch21','FALSE',1006);
+INSERT INTO SWITCH VALUES (1021, '1021', 'Switch22','FALSE',1006);
+INSERT INTO SWITCH VALUES (1022, '1022', 'Switch23','FALSE',1007);
+INSERT INTO SWITCH VALUES (1023, '1023', 'Switch24','FALSE',1007);
+INSERT INTO SWITCH VALUES (1024, '1024', 'Switch25','FALSE',1007);
+INSERT INTO SWITCH VALUES (1025, '1025', 'Switch26','FALSE',1010);
+INSERT INTO SWITCH VALUES (1026, '1026', 'Switch27','FALSE',1010);
+INSERT INTO SWITCH VALUES (1027, '1027', 'Switch28','FALSE',1010);
+INSERT INTO SWITCH VALUES (1028, '1028', 'Switch29','FALSE',1010);
+INSERT INTO SWITCH VALUES (1029, '1029', 'Switch30','FALSE',1009);
INSERT INTO CONNECTIVITY_NODE VALUES (1000, '12359', 'CN01', 1000);
INSERT INTO CONNECTIVITY_NODE VALUES (1001, '235699898', 'CN02', 1000);
INSERT INTO CONNECTIVITY_NODE VALUES (1002, '2343589', 'CN03', 1000);
-INSERT INTO CONNECTIVITY_NODE VALUES (1003, '222333589', 'CN04', 1001);
-INSERT INTO CONNECTIVITY_NODE VALUES (1004, '25789989', 'CN05', 1002);
-INSERT INTO CONNECTIVITY_NODE VALUES (1005, '25341189', 'CN06', 1002);
-INSERT INTO CONNECTIVITY_NODE VALUES (1006, '25546489', 'CN07', 1003);
-INSERT INTO CONNECTIVITY_NODE VALUES (1007, '1045507', 'CN08', 1005);
-INSERT INTO CONNECTIVITY_NODE VALUES (1008, '2577789', 'CN09', 1006);
-INSERT INTO CONNECTIVITY_NODE VALUES (1009, '29000589', 'CN10', 1007);
-INSERT INTO CONNECTIVITY_NODE VALUES (1010, '258345349', 'CN11', 1007);
-INSERT INTO CONNECTIVITY_NODE VALUES (1011, '253453489', 'CN12', 1008);
-INSERT INTO CONNECTIVITY_NODE VALUES (1012, '2533434453489', 'CN13', 1011);
-INSERT INTO CONNECTIVITY_NODE VALUES (1013, '2534534', 'CN14', 1011);
-INSERT INTO CONNECTIVITY_NODE VALUES (1014, '2534587834', 'CN15', 1011);
-INSERT INTO CONNECTIVITY_NODE VALUES (1015, '25345434', 'CN16', 1011);
-INSERT INTO CONNECTIVITY_NODE VALUES (1016, '2534343834', 'CN17', 1011);
-INSERT INTO CONNECTIVITY_NODE VALUES (1017, '8888884', 'CN18', 1010);
-INSERT INTO CONNECTIVITY_NODE VALUES (1018, '1018', 'CN19', 1012);
-
-INSERT INTO TERMINAL VALUES (1000, '1000', 'T01', 1000, null, null, null, 1000, null);
-INSERT INTO TERMINAL VALUES (1001, '1002', 'T02', 1000, null, null, null, null, 1000);
-INSERT INTO TERMINAL VALUES (1002, '1003', 'T03', 1001, null, null, null, 1001, null);
-INSERT INTO TERMINAL VALUES (1003, '1004', 'T04', 1001, null, null, null, null, 1000);
-INSERT INTO TERMINAL VALUES (1004, '1005', 'T05', 1002, null, null, null, null, 1000);
-INSERT INTO TERMINAL VALUES (1005, '1006', 'T06', 1002, null, null, 1000, null, null);
-INSERT INTO TERMINAL VALUES (1006, '1007', 'T07', 1003, null, null, 1000, null, null);
-INSERT INTO TERMINAL VALUES (1007, '1008', 'T08', 1003, null, null, null, null, 1001);
-INSERT INTO TERMINAL VALUES (1008, '1009', 'T09', 1004, null, null, null, null, 1001);
-INSERT INTO TERMINAL VALUES (1009, '1010', 'T10', 1004, null, null, 1001, null, null);
-INSERT INTO TERMINAL VALUES (1010, '1011', 'T11', 1005, null, null, 1001, null, null);
-INSERT INTO TERMINAL VALUES (1011, '1012', 'T12', 1005, null, null, 1002, null, null);
-INSERT INTO TERMINAL VALUES (1012, '1013', 'T13', 1005, null, null, 1003, null, null);
-INSERT INTO TERMINAL VALUES (1013, '1014', 'T14', 1005, null, null, null, 1002, null);
-INSERT INTO TERMINAL VALUES (1014, '1015', 'T15', 1018, null, null, 1003, null, null);
-INSERT INTO TERMINAL VALUES (1015, '1016', 'T16', 1006, null, null, 1002, null, null);
-INSERT INTO TERMINAL VALUES (1016, '1017', 'T17', 1006, null, null, null, null, 1002);
-INSERT INTO TERMINAL VALUES (1017, '1018', 'T18', 1007, null, null, null, null, 1002);
-INSERT INTO TERMINAL VALUES (1018, '1019', 'T19', 1007, null, null, null, null, 1003);
-INSERT INTO TERMINAL VALUES (1019, '1020', 'T20', 1008, null, null, null, null, 1003);
-INSERT INTO TERMINAL VALUES (1020, '1021', 'T21', 1008, null, null, null, null, 1004);
-INSERT INTO TERMINAL VALUES (1021, '1022', 'T22', 1009, null, null, null, null, 1004);
-INSERT INTO TERMINAL VALUES (1022, '1023', 'T23', 1009, null, null, null, null, 1005);
-INSERT INTO TERMINAL VALUES (1023, '1024', 'T24', 1010, null, null, null, null, 1005);
-INSERT INTO TERMINAL VALUES (1024, '1024', 'T25', 1010, null, null, null, null, 1006);
-INSERT INTO TERMINAL VALUES (1025, '1025', 'T26', 1011, null, null, null, null, 1006);
-INSERT INTO TERMINAL VALUES (1026, '1026', 'T27', 1011, null, null, 1004, null, null);
-INSERT INTO TERMINAL VALUES (1027, '1027', 'T28', 1011, null, null, 1005, null, null);
-INSERT INTO TERMINAL VALUES (1028, '1028', 'T29', 1012, null, null, 1005, null, null);
-INSERT INTO TERMINAL VALUES (1029, '1029', 'T30', 1012, null, 1001, null, null, null);
-INSERT INTO TERMINAL VALUES (1030, '1030', 'T31', 1013, null, null, 1004, null, null);
-INSERT INTO TERMINAL VALUES (1031, '1031', 'T32', 1013, null, 1000, null, null, null);
-INSERT INTO TERMINAL VALUES (1032, '1032', 'T33', 1014, null, 1001, null, null, null);
-INSERT INTO TERMINAL VALUES (1033, '1033', 'T34', 1014, null, null, 1007, null, null);
-INSERT INTO TERMINAL VALUES (1034, '1034', 'T35', 1015, null, 1000, null, null, null);
-INSERT INTO TERMINAL VALUES (1035, '1035', 'T36', 1015, null, null, 1006, null, null);
-INSERT INTO TERMINAL VALUES (1036, '1036', 'T37', 1016, null, null, 1007, null, null);
-INSERT INTO TERMINAL VALUES (1037, '1037', 'T38', 1016, null, null, 1006, null, null);
-INSERT INTO TERMINAL VALUES (1038, '1038', 'T39', 1016, 1000, null, null, null, null);
-INSERT INTO TERMINAL VALUES (1039, '1039', 'T40', 1017, 1000, null, null, null, null);
-INSERT INTO TERMINAL VALUES (1040, '1040', 'T41', 1017, null, null, null, null, 1007);
+INSERT INTO CONNECTIVITY_NODE VALUES (1003, '222333589', 'CN04', 1000);
+INSERT INTO CONNECTIVITY_NODE VALUES (1004, '25789989', 'CN05', 1000);
+INSERT INTO CONNECTIVITY_NODE VALUES (1005, '25341189', 'CN06', 1001);
+INSERT INTO CONNECTIVITY_NODE VALUES (1006, '25546489', 'CN07', 1001);
+INSERT INTO CONNECTIVITY_NODE VALUES (1007, '1045507', 'CN08', 1001);
+INSERT INTO CONNECTIVITY_NODE VALUES (1008, '2577789', 'CN09', 1002);
+INSERT INTO CONNECTIVITY_NODE VALUES (1009, '29000589', 'CN10', 1002);
+INSERT INTO CONNECTIVITY_NODE VALUES (1010, '258345349', 'CN11', 1002);
+INSERT INTO CONNECTIVITY_NODE VALUES (1011, '253453489', 'CN12', 1002);
+INSERT INTO CONNECTIVITY_NODE VALUES (1012, '2533434453489', 'CN13', 1002);
+INSERT INTO CONNECTIVITY_NODE VALUES (1013, '2534534', 'CN14', 1002);
+INSERT INTO CONNECTIVITY_NODE VALUES (1014, '2534587834', 'CN15', 1003);
+INSERT INTO CONNECTIVITY_NODE VALUES (1015, '25345434', 'CN16', 1003);
+INSERT INTO CONNECTIVITY_NODE VALUES (1016, '2534343834', 'CN17', 1003);
+INSERT INTO CONNECTIVITY_NODE VALUES (1017, '8888884', 'CN18', 1003);
+INSERT INTO CONNECTIVITY_NODE VALUES (1018, '1018', 'CN19', 1004);
+INSERT INTO CONNECTIVITY_NODE VALUES (1019, '1019', 'CN20', 1004);
+INSERT INTO CONNECTIVITY_NODE VALUES (1020, '1020', 'CN21', 1004);
+INSERT INTO CONNECTIVITY_NODE VALUES (1021, '1021', 'CN22', 1004);
+INSERT INTO CONNECTIVITY_NODE VALUES (1022, '1022', 'CN23', 1005);
+INSERT INTO CONNECTIVITY_NODE VALUES (1023, '1023', 'CN24', 1005);
+INSERT INTO CONNECTIVITY_NODE VALUES (1024, '1024', 'CN25', 1005);
+INSERT INTO CONNECTIVITY_NODE VALUES (1025, '1025', 'CN26', 1005);
+INSERT INTO CONNECTIVITY_NODE VALUES (1026, '1026', 'CN27', 1005);
+INSERT INTO CONNECTIVITY_NODE VALUES (1027, '1027', 'CN28', 1006);
+INSERT INTO CONNECTIVITY_NODE VALUES (1028, '1028', 'CN29', 1006);
+INSERT INTO CONNECTIVITY_NODE VALUES (1029, '1029', 'CN30', 1006);
+INSERT INTO CONNECTIVITY_NODE VALUES (1030, '1030', 'CN31', 1006);
+INSERT INTO CONNECTIVITY_NODE VALUES (1031, '1031', 'CN32', 1006);
+INSERT INTO CONNECTIVITY_NODE VALUES (1032, '1032', 'CN33', 1006);
+INSERT INTO CONNECTIVITY_NODE VALUES (1033, '1033', 'CN34', 1006);
+INSERT INTO CONNECTIVITY_NODE VALUES (1034, '1034', 'CN35', 1006);
+INSERT INTO CONNECTIVITY_NODE VALUES (1035, '1035', 'CN36', 1008);
+INSERT INTO CONNECTIVITY_NODE VALUES (1036, '1036', 'CN37', 1010);
+INSERT INTO CONNECTIVITY_NODE VALUES (1037, '1037', 'CN38', 1010);
+INSERT INTO CONNECTIVITY_NODE VALUES (1038, '1038', 'CN39', 1010);
+INSERT INTO CONNECTIVITY_NODE VALUES (1039, '1039', 'CN40', 1010);
+INSERT INTO CONNECTIVITY_NODE VALUES (1040, '1040', 'CN41', 1009);
+INSERT INTO CONNECTIVITY_NODE VALUES (1041, '1041', 'CN42', 1009);
+
+INSERT INTO TERMINAL VALUES (1000, '1000', 'T01', 'TRUE', 1000, null, null, null, 1000, null);
+INSERT INTO TERMINAL VALUES (1001, '1002', 'T02', 'TRUE', 1000, null, null, 1000, null, null);
+INSERT INTO TERMINAL VALUES (1002, '1003', 'T03', 'TRUE', 1001, null, null, null, 1001, null);
+INSERT INTO TERMINAL VALUES (1003, '1004', 'T04', 'TRUE', 1001, null, null, 1001, null, null);
+INSERT INTO TERMINAL VALUES (1004, '1005', 'T05', 'TRUE', 1002, null, null, 1000, null, null);
+INSERT INTO TERMINAL VALUES (1005, '1006', 'T06', 'TRUE', 1002, null, null, null, null, 1000);
+INSERT INTO TERMINAL VALUES (1006, '1007', 'T07', 'TRUE', 1003, null, null, 1001, null, null);
+INSERT INTO TERMINAL VALUES (1007, '1008', 'T08', 'TRUE', 1003, null, null, null, null, 1000);
+INSERT INTO TERMINAL VALUES (1008, '1009', 'T09', 'TRUE', 1004, null, null, null, null, 1000);
+INSERT INTO TERMINAL VALUES (1009, '1010', 'T10', 'TRUE', 1004, null, null, 1002, null, null);
+INSERT INTO TERMINAL VALUES (1010, '1011', 'T11', 'TRUE', 1005, null, null, 1002, null, null);
+INSERT INTO TERMINAL VALUES (1011, '1012', 'T12', 'TRUE', 1005, null, null, 1004, null, null);
+INSERT INTO TERMINAL VALUES (1012, '1013', 'T13', 'TRUE', 1005, null, null, 1003, null, null);
+INSERT INTO TERMINAL VALUES (1013, '1014', 'T14', 'TRUE', 1006, null, null, 1003, null, null);
+INSERT INTO TERMINAL VALUES (1014, '1015', 'T15', 'TRUE', 1006, 1000, null, null, null, null);
+INSERT INTO TERMINAL VALUES (1015, '1016', 'T16', 'TRUE', 1007, null, null, 1004, null, null);
+INSERT INTO TERMINAL VALUES (1016, '1017', 'T17', 'TRUE', 1007, null, null, null, null, 1001);
+INSERT INTO TERMINAL VALUES (1017, '1018', 'T18', 'TRUE', 1008, null, null, null, null, 1001);
+INSERT INTO TERMINAL VALUES (1018, '1019', 'T19', 'TRUE', 1008, null, null, 1005, null, null);
+INSERT INTO TERMINAL VALUES (1019, '1020', 'T20', 'TRUE', 1011, null, null, 1008, null, null);
+INSERT INTO TERMINAL VALUES (1020, '1021', 'T21', 'TRUE', 1009, null, null, 1008, null, null);
+INSERT INTO TERMINAL VALUES (1021, '1022', 'T22', 'TRUE', 1009, 1001, null, null, null, null);
+INSERT INTO TERMINAL VALUES (1022, '1023', 'T23', 'TRUE', 1011, null, null, 1009, null, null);
+INSERT INTO TERMINAL VALUES (1023, '1024', 'T24', 'TRUE', 1010, null, null, 1009, null, null);
+INSERT INTO TERMINAL VALUES (1024, '1024', 'T25', 'TRUE', 1010, null, null, null, 1002, null);
+INSERT INTO TERMINAL VALUES (1025, '1025', 'T26', 'TRUE', 1011, null, null, 1007, null, null);
+INSERT INTO TERMINAL VALUES (1026, '1026', 'T27', 'TRUE', 1011, null, null, 1005, null, null);
+INSERT INTO TERMINAL VALUES (1027, '1027', 'T28', 'TRUE', 1011, null, null, 1006, null, null);
+INSERT INTO TERMINAL VALUES (1028, '1028', 'T29', 'TRUE', 1012, null, null, 1007, null, null);
+INSERT INTO TERMINAL VALUES (1029, '1029', 'T30', 'TRUE', 1013, null, null, 1006, null, null);
+INSERT INTO TERMINAL VALUES (1030, '1030', 'T31', 'TRUE', 1013, null, null, null, null, 1002);
+INSERT INTO TERMINAL VALUES (1031, '1031', 'T32', 'TRUE', 1014, null, null, null, null, 1002);
+INSERT INTO TERMINAL VALUES (1032, '1032', 'T33', 'TRUE', 1014, null, null, 1010, null, null);
+INSERT INTO TERMINAL VALUES (1033, '1033', 'T34', 'TRUE', 1015, null, null, 1010, null, null);
+INSERT INTO TERMINAL VALUES (1034, '1034', 'T35', 'TRUE', 1015, null, null, 1011, null, null);
+INSERT INTO TERMINAL VALUES (1035, '1035', 'T36', 'TRUE', 1016, null, null, 1011, null, null);
+INSERT INTO TERMINAL VALUES (1036, '1036', 'T37', 'TRUE', 1016, 1002, null, null, null, null);
+INSERT INTO TERMINAL VALUES (1037, '1037', 'T38', 'TRUE', 1015, null, null, 1012, null, null);
+INSERT INTO TERMINAL VALUES (1038, '1038', 'T39', 'TRUE', 1017, null, null, 1012, null, null);
+INSERT INTO TERMINAL VALUES (1039, '1039', 'T40', 'TRUE', 1017, null, null, null, null, 1003);
+INSERT INTO TERMINAL VALUES (1040, '1040', 'T41', 'TRUE', 1018, null, null, null, null, 1003);
+INSERT INTO TERMINAL VALUES (1041, '1041', 'T42', 'TRUE', 1018, null, null, 1013, null, null);
+INSERT INTO TERMINAL VALUES (1042, '1042', 'T43', 'TRUE', 1019, null, null, 1013, null, null);
+INSERT INTO TERMINAL VALUES (1043, '1043', 'T44', 'TRUE', 1019, null, null, 1014, null, null);
+INSERT INTO TERMINAL VALUES (1044, '1044', 'T45', 'TRUE', 1020, null, null, 1014, null, null);
+INSERT INTO TERMINAL VALUES (1045, '1045', 'T46', 'TRUE', 1020, 1003, null, null, null, null);
+INSERT INTO TERMINAL VALUES (1046, '1046', 'T47', 'TRUE', 1019, null, null, 1015, null, null);
+INSERT INTO TERMINAL VALUES (1047, '1047', 'T48', 'TRUE', 1021, null, null, 1015, null, null);
+INSERT INTO TERMINAL VALUES (1048, '1048', 'T49', 'TRUE', 1021, null, null, null, null, 1004);
+INSERT INTO TERMINAL VALUES (1049, '1049', 'T50', 'TRUE', 1022, null, null, null, null, 1004);
+INSERT INTO TERMINAL VALUES (1050, '1050', 'T51', 'TRUE', 1022, null, null, 1016, null, null);
+INSERT INTO TERMINAL VALUES (1051, '1051', 'T52', 'TRUE', 1023, null, null, 1016, null, null);
+INSERT INTO TERMINAL VALUES (1052, '1052', 'T53', 'TRUE', 1023, null, null, 1017, null, null);
+INSERT INTO TERMINAL VALUES (1053, '1053', 'T54', 'TRUE', 1024, null, null, 1017, null, null);
+INSERT INTO TERMINAL VALUES (1054, '1054', 'T55', 'TRUE', 1024, 1004, null, null, null, null);
+INSERT INTO TERMINAL VALUES (1055, '1055', 'T56', 'TRUE', 1025, null, null, 1018, null, null);
+INSERT INTO TERMINAL VALUES (1056, '1056', 'T57', 'TRUE', 1025, null, null, null, null, 1005);
+INSERT INTO TERMINAL VALUES (1057, '1057', 'T58', 'TRUE', 1026, null, null, null, null, 1005);
+INSERT INTO TERMINAL VALUES (1058, '1058', 'T59', 'TRUE', 1026, null, null, 1019, null, null);
+INSERT INTO TERMINAL VALUES (1059, '1059', 'T60', 'TRUE', 1027, null, null, 1019, null, null);
+INSERT INTO TERMINAL VALUES (1060, '1060', 'T61', 'TRUE', 1027, null, null, 1020, null, null);
+INSERT INTO TERMINAL VALUES (1061, '1061', 'T62', 'TRUE', 1028, null, null, 1020, null, null);
+INSERT INTO TERMINAL VALUES (1062, '1062', 'T63', 'TRUE', 1028, 1005, null, null, null, null);
+INSERT INTO TERMINAL VALUES (1063, '1063', 'T64', 'TRUE', 1027, null, null, 1021, null, null);
+INSERT INTO TERMINAL VALUES (1064, '1064', 'T65', 'TRUE', 1029, null, null, 1021, null, null);
+INSERT INTO TERMINAL VALUES (1065, '1065', 'T66', 'TRUE', 1029, null, null, null, null, 1006);
+INSERT INTO TERMINAL VALUES (1066, '1066', 'T67', 'TRUE', 1030, null, null, null, null, 1006);
+INSERT INTO TERMINAL VALUES (1067, '1067', 'T68', 'TRUE', 1030, null, null, 1022, null, null);
+INSERT INTO TERMINAL VALUES (1068, '1068', 'T69', 'TRUE', 1031, null, null, 1022, null, null);
+INSERT INTO TERMINAL VALUES (1069, '1069', 'T70', 'TRUE', 1031, null, null, 1023, null, null);
+INSERT INTO TERMINAL VALUES (1070, '1070', 'T71', 'TRUE', 1032, null, null, 1023, null, null);
+INSERT INTO TERMINAL VALUES (1071, '1071', 'T72', 'TRUE', 1032, 1006, null, null, null, null);
+INSERT INTO TERMINAL VALUES (1072, '1072', 'T73', 'TRUE', 1031, null, null, 1024, null, null);
+INSERT INTO TERMINAL VALUES (1073, '1073', 'T74', 'TRUE', 1033, null, null, 1024, null, null);
+INSERT INTO TERMINAL VALUES (1074, '1074', 'T75', 'TRUE', 1033, null, null, null, null, 1007);
+INSERT INTO TERMINAL VALUES (1075, '1075', 'T76', 'TRUE', 1034, null, null, null, null, 1007);
+INSERT INTO TERMINAL VALUES (1076, '1076', 'T77', 'TRUE', 1034, null, null, 1025, null, null);
+INSERT INTO TERMINAL VALUES (1077, '1077', 'T78', 'TRUE', 1034, null, null, 1026, null, null);
+INSERT INTO TERMINAL VALUES (1078, '1078', 'T79', 'TRUE', 1035, null, null, 1025, null, null);
+INSERT INTO TERMINAL VALUES (1079, '1079', 'T80', 'TRUE', 1035, null, 1001, null, null, null);
+INSERT INTO TERMINAL VALUES (1080, '1080', 'T81', 'TRUE', 1036, null, null, 1026, null, null);
+INSERT INTO TERMINAL VALUES (1081, '1081', 'T82', 'TRUE', 1036, null, 1000, null, null, null);
+INSERT INTO TERMINAL VALUES (1082, '1082', 'T83', 'TRUE', 1037, null, 1001, null, null, null);
+INSERT INTO TERMINAL VALUES (1083, '1083', 'T84', 'TRUE', 1037, null, null, 1027, null, null);
+INSERT INTO TERMINAL VALUES (1084, '1084', 'T85', 'TRUE', 1038, null, 1000, null, null, null);
+INSERT INTO TERMINAL VALUES (1085, '1085', 'T86', 'TRUE', 1038, null, null, 1028, null, null);
+INSERT INTO TERMINAL VALUES (1086, '1086', 'T87', 'TRUE', 1039, null, null, 1028, null, null);
+INSERT INTO TERMINAL VALUES (1087, '1087', 'T88', 'TRUE', 1039, null, null, 1027, null, null);
+INSERT INTO TERMINAL VALUES (1088, '1088', 'T89', 'TRUE', 1039, 1007, null, null, null, null);
+INSERT INTO TERMINAL VALUES (1089, '1089', 'T90', 'TRUE', 1040, 1007, null, null, null, null);
+INSERT INTO TERMINAL VALUES (1090, '1090', 'T91', 'TRUE', 1040, null, null, 1029, null, null);
+INSERT INTO TERMINAL VALUES (1091, '1091', 'T92', 'TRUE', 1041, null, null, 1029, null, null);
+INSERT INTO TERMINAL VALUES (1092, '1092', 'T93', 'TRUE', 1041, null, null, null, null, 1007);

Back to the top