 insert into CATISSUE_RELATED_TABLES_MAP values ( 35 , 33 , 'IDENTIFIER','SPECIMEN_COLLECTION_GROUP_ID');
 insert into CATISSUE_RELATED_TABLES_MAP values ( 34 , 33 , 'IDENTIFIER','SPECIMEN_CHARACTERISTICS_ID');
 insert into CATISSUE_RELATED_TABLES_MAP values ( 33 , 33 , 'IDENTIFIER','PARENT_SPECIMEN_ID');
-
+insert into CATISSUE_RELATED_TABLES_MAP values ( 38 , 37 , 'IDENTIFIER','DISTRIBUTION_ID');
+

insert into CATISSUE_QUERY_INTERFACE_COLUMN_DATA ( TABLE_ID, COLUMN_NAME , DISPLAY_NAME , ATTRIBUTE_TYPE ) values ( 36, 'QUANTITY_IN_GRAM', 'Quantity In Gram', 'double');
insert into CATISSUE_QUERY_INTERFACE_COLUMN_DATA ( TABLE_ID, COLUMN_NAME , DISPLAY_NAME , ATTRIBUTE_TYPE ) values ( 36, 'AVAILABLE_QUANTITY_IN_GRAM', 'Available Quantity In Gram', 'double');
insert into CATISSUE_QUERY_INTERFACE_TABLE_DATA  ( TABLE_ID, TABLE_NAME, DISPLAY_NAME, ALIAS_NAME) values ( 37, 'CATISSUE_DISTRIBUTED_ITEM', 'Distributed Item', 'DistributedItem');
insert into CATISSUE_QUERY_INTERFACE_COLUMN_DATA ( TABLE_ID, COLUMN_NAME , DISPLAY_NAME , ATTRIBUTE_TYPE ) values ( 37, 'IDENTIFIER', 'Identifier', 'bigint');
insert into CATISSUE_QUERY_INTERFACE_COLUMN_DATA ( TABLE_ID, COLUMN_NAME , DISPLAY_NAME , ATTRIBUTE_TYPE ) values ( 37, 'QUANTITY', 'Quantity', 'double');
insert into CATISSUE_QUERY_INTERFACE_COLUMN_DATA ( TABLE_ID, COLUMN_NAME , DISPLAY_NAME , ATTRIBUTE_TYPE ) values ( 37, 'SPECIMEN_ID', 'Specimen Id', 'bigint');
insert into CATISSUE_QUERY_INTERFACE_COLUMN_DATA ( TABLE_ID, COLUMN_NAME , DISPLAY_NAME , ATTRIBUTE_TYPE ) values ( 37, 'DISTRIBUTION_ID', 'Distribution Id', 'bigint');
insert into CATISSUE_QUERY_INTERFACE_TABLE_DATA  ( TABLE_ID, TABLE_NAME, DISPLAY_NAME, ALIAS_NAME) values ( 38, 'CATISSUE_DISTRIBUTION', 'Distribution', 'Distribution');
insert into CATISSUE_QUERY_INTERFACE_COLUMN_DATA ( TABLE_ID, COLUMN_NAME , DISPLAY_NAME , ATTRIBUTE_TYPE ) values ( 38, 'IDENTIFIER', 'Identifier', 'bigint');
insert into CATISSUE_QUERY_INTERFACE_COLUMN_DATA ( TABLE_ID, COLUMN_NAME , DISPLAY_NAME , ATTRIBUTE_TYPE ) values ( 38, 'TO_SITE_ID', 'To Site Id', 'bigint');
insert into CATISSUE_QUERY_INTERFACE_COLUMN_DATA ( TABLE_ID, COLUMN_NAME , DISPLAY_NAME , ATTRIBUTE_TYPE ) values ( 38, 'FROM_SITE_ID', 'From Site Id', 'bigint');
insert into CATISSUE_QUERY_INTERFACE_COLUMN_DATA ( TABLE_ID, COLUMN_NAME , DISPLAY_NAME , ATTRIBUTE_TYPE ) values ( 38, 'DISTRIBUTION_PROTOCOL_ID', 'Distribution Protocol Id', 'bigint');




insert into CATISSUE_TABLE_RELATION (PARENT_TABLE_ID,CHILD_TABLE_ID) values (35 , 27);
insert into CATISSUE_TABLE_RELATION (PARENT_TABLE_ID,CHILD_TABLE_ID) values (33 , 33);
insert into CATISSUE_TABLE_RELATION (PARENT_TABLE_ID,CHILD_TABLE_ID) values (33 , 34);
insert into CATISSUE_TABLE_RELATION (PARENT_TABLE_ID,CHILD_TABLE_ID) values (38 , 38);
insert into CATISSUE_TABLE_RELATION (PARENT_TABLE_ID,CHILD_TABLE_ID) values (38 , 37);



