"Assay_Descriptor_Tree to Assay_Descriptor_Tree" 
RelationshipType  Non-Identifying 
Do Not Generate  False 
Relationship Name  FK_ASSAY_DESCRIPTOR_PARENT_SLF 
Relationship Business Name   
Physical Only  No 
Parent Table  Assay_Descriptor_Tree 
Child Table  Assay_Descriptor_Tree 
Cardinality  Zero or One to Zero or More 
Existence  Optional 
Propagated Key  Primary Key 
Deferrable  NO 
Initially Deferred  NO 
Disabled  NO 
NoValidate  NO 

"Assay_Descriptor_Tree to Assay_Descriptor_Tree" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"Assay_Descriptor_Tree to Assay_Descriptor_Tree" Foreign Keys 
Parent Key  Child Key 
NODE_ID  PARENT_NODE_ID 

"Assay_Descriptor_Tree to Assay_Descriptor_Tree" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 


"BARD_TREE to BARD_TREE" 
RelationshipType  Non-Identifying 
Do Not Generate  False 
Relationship Name  FK_BARD_TREE_PARENT 
Relationship Business Name   
Physical Only  No 
Parent Table  BARD_TREE 
Child Table  BARD_TREE 
Cardinality  Zero or One to Zero or More 
Existence  Optional 
Propagated Key  Primary Key 
Deferrable  NO 
Initially Deferred  NO 
Disabled  NO 
NoValidate  NO 

"BARD_TREE to BARD_TREE" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"BARD_TREE to BARD_TREE" Foreign Keys 
Parent Key  Child Key 
NODE_ID  PARENT_NODE_ID 

"BARD_TREE to BARD_TREE" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 


"Biology_Descriptor_tree to Biology_Descriptor_tree" 
RelationshipType  Non-Identifying 
Do Not Generate  False 
Relationship Name  FK_BIOLOGY_DESCRIPTOR_PRNT_SLF 
Relationship Business Name   
Physical Only  No 
Parent Table  Biology_Descriptor_tree 
Child Table  Biology_Descriptor_tree 
Cardinality  Zero or One to Zero or More 
Existence  Optional 
Propagated Key  Primary Key 
Deferrable  NO 
Initially Deferred  NO 
Disabled  NO 
NoValidate  NO 

"Biology_Descriptor_tree to Biology_Descriptor_tree" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"Biology_Descriptor_tree to Biology_Descriptor_tree" Foreign Keys 
Parent Key  Child Key 
NODE_ID  PARENT_NODE_ID 

"Biology_Descriptor_tree to Biology_Descriptor_tree" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 


"DICTIONARY_TREE to DICTIONARY_TREE" 
RelationshipType  Non-Identifying 
Do Not Generate  False 
Relationship Name  FK_DICTIONARY_TREE_PARENT 
Relationship Business Name   
Physical Only  No 
Parent Table  DICTIONARY_TREE 
Child Table  DICTIONARY_TREE 
Cardinality  Zero or One to Zero or More 
Existence  Optional 
Propagated Key  Primary Key 
Deferrable  NO 
Initially Deferred  NO 
Disabled  NO 
NoValidate  NO 

"DICTIONARY_TREE to DICTIONARY_TREE" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"DICTIONARY_TREE to DICTIONARY_TREE" Foreign Keys 
Parent Key  Child Key 
NODE_ID  PARENT_NODE_ID 

"DICTIONARY_TREE to DICTIONARY_TREE" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 


"ELEMENT to ELEMENT_HIERARCHY" 
RelationshipType  Non-Identifying 
Do Not Generate  False 
Relationship Name  FK_E_HIERARCHY_CHILD_ELEM_ID 
Relationship Business Name   
Physical Only  No 
Parent Table  ELEMENT 
Child Table  ELEMENT_HIERARCHY 
Cardinality  One To Zero or More 
Existence  Mandatory 
Propagated Key  Primary Key 
Deferrable  NO 
Initially Deferred  NO 
Disabled  NO 
NoValidate  NO 

"ELEMENT to ELEMENT_HIERARCHY" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"ELEMENT to ELEMENT_HIERARCHY" Foreign Keys 
Parent Key  Child Key 
ELEMENT_ID  CHILD_ELEMENT_ID 

"ELEMENT to ELEMENT_HIERARCHY" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  Cascade 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 


"ELEMENT to ELEMENT_HIERARCHY" 
RelationshipType  Non-Identifying 
Do Not Generate  False 
Relationship Name  FK_E_HIERARCHY_PARENT_ELEM_ID 
Relationship Business Name   
Physical Only  No 
Parent Table  ELEMENT 
Child Table  ELEMENT_HIERARCHY 
Cardinality  One To Zero or More 
Existence  Mandatory 
Propagated Key  Primary Key 
Deferrable  NO 
Initially Deferred  NO 
Disabled  NO 
NoValidate  NO 

"ELEMENT to ELEMENT_HIERARCHY" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"ELEMENT to ELEMENT_HIERARCHY" Foreign Keys 
Parent Key  Child Key 
ELEMENT_ID  PARENT_ELEMENT_ID 

"ELEMENT to ELEMENT_HIERARCHY" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  Cascade 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 


"ELEMENT to ELEMENT" 
RelationshipType  Non-Identifying 
Do Not Generate  False 
Relationship Name  FK_Element_Unit 
Relationship Business Name  measured in 
Physical Only  No 
Parent Table  ELEMENT 
Child Table  ELEMENT 
Cardinality  Zero or One to Zero or More 
Existence  Optional 
Propagated Key  Primary Key 
Deferrable  YES 
Initially Deferred  YES 
Disabled  NO 
NoValidate  NO 

"ELEMENT to ELEMENT" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"ELEMENT to ELEMENT" Foreign Keys 
Parent Key  Child Key 
ELEMENT_ID  UNIT_ID 

"ELEMENT to ELEMENT" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 


"EXT_ONTOLOGY_TREE to EXT_ONTOLOGY_TREE" 
RelationshipType  Non-Identifying 
Do Not Generate  False 
Relationship Name  FK_EXT_ONTOLOGY_TREE_PARENT 
Relationship Business Name   
Physical Only  No 
Parent Table  EXT_ONTOLOGY_TREE 
Child Table  EXT_ONTOLOGY_TREE 
Cardinality  Zero or One to Zero or More 
Existence  Optional 
Propagated Key  Primary Key 
Deferrable  NO 
Initially Deferred  NO 
Disabled  NO 
NoValidate  NO 

"EXT_ONTOLOGY_TREE to EXT_ONTOLOGY_TREE" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"EXT_ONTOLOGY_TREE to EXT_ONTOLOGY_TREE" Foreign Keys 
Parent Key  Child Key 
NODE_ID  PARENT_NODE_ID 

"EXT_ONTOLOGY_TREE to EXT_ONTOLOGY_TREE" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 


"Instance_Descriptor_tree to Instance_Descriptor_tree" 
RelationshipType  Non-Identifying 
Do Not Generate  False 
Relationship Name  FK_INSTANCE_DESCRIPTR_PRNT_SLF 
Relationship Business Name   
Physical Only  No 
Parent Table  Instance_Descriptor_tree 
Child Table  Instance_Descriptor_tree 
Cardinality  Zero or One to Zero or More 
Existence  Optional 
Propagated Key  Primary Key 
Deferrable  NO 
Initially Deferred  NO 
Disabled  NO 
NoValidate  NO 

"Instance_Descriptor_tree to Instance_Descriptor_tree" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"Instance_Descriptor_tree to Instance_Descriptor_tree" Foreign Keys 
Parent Key  Child Key 
NODE_ID  PARENT_NODE_ID 

"Instance_Descriptor_tree to Instance_Descriptor_tree" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 


"Laboratory_tree to Laboratory_tree" 
RelationshipType  Non-Identifying 
Do Not Generate  False 
Relationship Name  FK_LABORATORY_PARENT_NODE_ID 
Relationship Business Name   
Physical Only  No 
Parent Table  Laboratory_tree 
Child Table  Laboratory_tree 
Cardinality  Zero or One to Zero or More 
Existence  Optional 
Propagated Key  Primary Key 
Deferrable  NO 
Initially Deferred  NO 
Disabled  NO 
NoValidate  NO 

"Laboratory_tree to Laboratory_tree" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"Laboratory_tree to Laboratory_tree" Foreign Keys 
Parent Key  Child Key 
NODE_ID  PARENT_NODE_ID 

"Laboratory_tree to Laboratory_tree" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 


"ELEMENT to ONTOLOGY_ITEM" 
RelationshipType  Non-Identifying 
Do Not Generate  False 
Relationship Name  FK_ONTOLOGY_ITEM_ELEMENT 
Relationship Business Name   
Physical Only  No 
Parent Table  ELEMENT 
Child Table  ONTOLOGY_ITEM 
Cardinality  Zero or One to Zero or More 
Existence  Optional 
Propagated Key  Primary Key 
Deferrable  NO 
Initially Deferred  NO 
Disabled  NO 
NoValidate  NO 

"ELEMENT to ONTOLOGY_ITEM" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"ELEMENT to ONTOLOGY_ITEM" Foreign Keys 
Parent Key  Child Key 
ELEMENT_ID  ELEMENT_ID 

"ELEMENT to ONTOLOGY_ITEM" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  Cascade 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 


"ONTOLOGY to ONTOLOGY_ITEM" 
RelationshipType  Non-Identifying 
Do Not Generate  False 
Relationship Name  FK_ONTOLOGY_ITEM_ONTOLOGY 
Relationship Business Name   
Physical Only  No 
Parent Table  ONTOLOGY 
Child Table  ONTOLOGY_ITEM 
Cardinality  One To Zero or More 
Existence  Mandatory 
Propagated Key  Primary Key 
Deferrable  NO 
Initially Deferred  NO 
Disabled  NO 
NoValidate  NO 

"ONTOLOGY to ONTOLOGY_ITEM" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"ONTOLOGY to ONTOLOGY_ITEM" Foreign Keys 
Parent Key  Child Key 
ONTOLOGY_ID  ONTOLOGY_ID 

"ONTOLOGY to ONTOLOGY_ITEM" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 


"Result_type_tree to Result_type_tree" 
RelationshipType  Non-Identifying 
Do Not Generate  False 
Relationship Name  FK_Result_Type_Parent_Self 
Relationship Business Name   
Physical Only  No 
Parent Table  Result_type_tree 
Child Table  Result_type_tree 
Cardinality  Zero or One to Zero or More 
Existence  Optional 
Propagated Key  Primary Key 
Deferrable  NO 
Initially Deferred  NO 
Disabled  NO 
NoValidate  NO 

"Result_type_tree to Result_type_tree" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"Result_type_tree to Result_type_tree" Foreign Keys 
Parent Key  Child Key 
NODE_ID  Parent_node_id 

"Result_type_tree to Result_type_tree" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 


"Stage_tree to Stage_tree" 
RelationshipType  Non-Identifying 
Do Not Generate  False 
Relationship Name  FK_STAGE_PARENT_NODE_ID 
Relationship Business Name   
Physical Only  No 
Parent Table  Stage_tree 
Child Table  Stage_tree 
Cardinality  Zero or One to Zero or More 
Existence  Optional 
Propagated Key  Primary Key 
Deferrable  NO 
Initially Deferred  NO 
Disabled  NO 
NoValidate  NO 

"Stage_tree to Stage_tree" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"Stage_tree to Stage_tree" Foreign Keys 
Parent Key  Child Key 
NODE_ID  PARENT_NODE_ID 

"Stage_tree to Stage_tree" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 


"STATS_MODIFIER_TREE to STATS_MODIFIER_TREE" 
RelationshipType  Non-Identifying 
Do Not Generate  False 
Relationship Name  FK_STATS_MODIFIER_PARENT 
Relationship Business Name   
Physical Only  No 
Parent Table  STATS_MODIFIER_TREE 
Child Table  STATS_MODIFIER_TREE 
Cardinality  Zero or One to Zero or More 
Existence  Optional 
Propagated Key  Primary Key 
Deferrable  NO 
Initially Deferred  NO 
Disabled  NO 
NoValidate  NO 

"STATS_MODIFIER_TREE to STATS_MODIFIER_TREE" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"STATS_MODIFIER_TREE to STATS_MODIFIER_TREE" Foreign Keys 
Parent Key  Child Key 
NODE_ID  PARENT_NODE_ID 

"STATS_MODIFIER_TREE to STATS_MODIFIER_TREE" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 


"ELEMENT to TREE_ROOT" 
RelationshipType  Non-Identifying 
Do Not Generate  False 
Relationship Name  FK_TREE_ROOT_ELEMENT 
Relationship Business Name   
Physical Only  No 
Parent Table  ELEMENT 
Child Table  TREE_ROOT 
Cardinality  One To Zero or More 
Existence  Mandatory 
Propagated Key  Primary Key 
Deferrable  NO 
Initially Deferred  NO 
Disabled  NO 
NoValidate  NO 

"ELEMENT to TREE_ROOT" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"ELEMENT to TREE_ROOT" Foreign Keys 
Parent Key  Child Key 
ELEMENT_ID  ELEMENT_ID 

"ELEMENT to TREE_ROOT" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 


"ELEMENT to UNIT_CONVERSION" 
RelationshipType  Non-Identifying 
Do Not Generate  False 
Relationship Name  FK_UNIT_CONVERSN_FRM_UNT_ELMNT 
Relationship Business Name   
Physical Only  No 
Parent Table  ELEMENT 
Child Table  UNIT_CONVERSION 
Cardinality  One To Zero or More 
Existence  Mandatory 
Propagated Key  Primary Key 
Deferrable  NO 
Initially Deferred  NO 
Disabled  NO 
NoValidate  NO 

"ELEMENT to UNIT_CONVERSION" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"ELEMENT to UNIT_CONVERSION" Foreign Keys 
Parent Key  Child Key 
ELEMENT_ID  FROM_UNIT_ID 

"ELEMENT to UNIT_CONVERSION" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  Cascade 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 


"ELEMENT to UNIT_CONVERSION" 
RelationshipType  Non-Identifying 
Do Not Generate  False 
Relationship Name  FK_UNIT_CONVERSN_TO_UNT_ELMNT 
Relationship Business Name   
Physical Only  No 
Parent Table  ELEMENT 
Child Table  UNIT_CONVERSION 
Cardinality  One To Zero or More 
Existence  Mandatory 
Propagated Key  Primary Key 
Deferrable  NO 
Initially Deferred  NO 
Disabled  NO 
NoValidate  NO 

"ELEMENT to UNIT_CONVERSION" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"ELEMENT to UNIT_CONVERSION" Foreign Keys 
Parent Key  Child Key 
ELEMENT_ID  TO_UNIT_ID 

"ELEMENT to UNIT_CONVERSION" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  Cascade 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 


"Unit_tree to Unit_tree" 
RelationshipType  Non-Identifying 
Do Not Generate  False 
Relationship Name  FK_UNIT_PARENT_SELF 
Relationship Business Name   
Physical Only  No 
Parent Table  Unit_tree 
Child Table  Unit_tree 
Cardinality  Zero or One to Zero or More 
Existence  Optional 
Propagated Key  Primary Key 
Deferrable  NO 
Initially Deferred  NO 
Disabled  NO 
NoValidate  NO 

"Unit_tree to Unit_tree" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"Unit_tree to Unit_tree" Foreign Keys 
Parent Key  Child Key 
NODE_ID  PARENT_NODE_ID 

"Unit_tree to Unit_tree" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None