 insert into CATISSUE_RELATED_TABLES_MAP values ( 12 , 20 , 'IDENTIFIER','SPECIMEN_REQUIREMENT_ID');
 insert into CATISSUE_RELATED_TABLES_MAP values ( 19 , 20 , 'IDENTIFIER','DISTRIBUTION_PROTOCOL_ID');
 
-#Kpail: removed as all the sub-specimen requirement table are mearged in single table
+#Kpail: removed as all the sub-specimen requirement table are mearged in single table.
 #insert into CATISSUE_RELATED_TABLES_MAP values ( 13 , 12 , 'IDENTIFIER','IDENTIFIER');
 #insert into CATISSUE_RELATED_TABLES_MAP values ( 14 , 12 , 'IDENTIFIER','IDENTIFIER');
 #insert into CATISSUE_RELATED_TABLES_MAP values ( 15 , 12 , 'IDENTIFIER','IDENTIFIER');

      FIRST_TABLE_JOIN_COLUMN varchar(50),
      SECOND_TABLE_JOIN_COLUMN varchar(50)
);
 
insert into CATISSUE_QUERY_INTERFACE_TABLE_DATA  ( TABLE_ID, TABLE_NAME, DISPLAY_NAME, ALIAS_NAME, PRIVILEGE_ID) values ( 4, 'CATISSUE_ADDRESS', 'Address', 'Address', 2);
insert into CATISSUE_QUERY_INTERFACE_COLUMN_DATA ( IDENTIFIER, TABLE_ID, COLUMN_NAME , ATTRIBUTE_TYPE ) values ( 1, 4, 'IDENTIFIER', 'bigint');
insert into CATISSUE_QUERY_INTERFACE_COLUMN_DATA ( IDENTIFIER, TABLE_ID, COLUMN_NAME , ATTRIBUTE_TYPE ) values ( 2, 4, 'STREET', 'varchar');

# ************************* RELATIONSHIP QUERIES FOR ADVANCE QUERY SEARCH ******************************
INSERT INTO CATISSUE_TABLE_RELATION (RELATIONSHIP_ID, PARENT_TABLE_ID, CHILD_TABLE_ID, TABLES_IN_PATH) values (103,31,10,'27');
INSERT INTO CATISSUE_TABLE_RELATION (RELATIONSHIP_ID, PARENT_TABLE_ID, CHILD_TABLE_ID, TABLES_IN_PATH) values (104,10,35,'27');

# ************************* RELATIONSHIP QUERIES FOR SPECIMEN BIOHAZARD RELATIONSHIP *****************************************
INSERT INTO CATISSUE_TABLE_RELATION (RELATIONSHIP_ID, PARENT_TABLE_ID, CHILD_TABLE_ID) values (105,62,8);

INSERT INTO CATISSUE_SEARCH_DISPLAY_DATA (RELATIONSHIP_ID, COL_ID, DISPLAY_NAME) VALUES (105, 24, 'Identifier');
INSERT INTO CATISSUE_SEARCH_DISPLAY_DATA (RELATIONSHIP_ID, COL_ID, DISPLAY_NAME) VALUES (105, 25, 'Name');
INSERT INTO CATISSUE_SEARCH_DISPLAY_DATA (RELATIONSHIP_ID, COL_ID, DISPLAY_NAME) VALUES (105, 26, 'Comments');
INSERT INTO CATISSUE_SEARCH_DISPLAY_DATA (RELATIONSHIP_ID, COL_ID, DISPLAY_NAME) VALUES (105, 27, 'Type');
