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

"Assay_Context to Rslt_Context_Item" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"Assay_Context to Rslt_Context_Item" Foreign Keys 
Parent Key  Child Key 
Assay_Context_ID  Assay_Context_ID 

"Assay_Context to Rslt_Context_Item" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 


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

"RESULT to Rslt_Context_Item" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"RESULT to Rslt_Context_Item" Foreign Keys 
Parent Key  Child Key 
RESULT_ID  Result_RESULT_ID 

"RESULT to Rslt_Context_Item" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 


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

"Assay_Context to Assay_Context_Item" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"Assay_Context to Assay_Context_Item" Foreign Keys 
Parent Key  Child Key 
Assay_Context_ID  Assay_Context_ID 

"Assay_Context to Assay_Context_Item" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 


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

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

"ELEMENT to Assay_Context_Item" Foreign Keys 
Parent Key  Child Key 
ELEMENT_ID  ATTRIBUTE_ID 

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


"ELEMENT to Assay_Context_Item" 
RelationshipType  Non-Identifying 
Do Not Generate  False 
Relationship Name  FK_A_CONTEXT_ITEM_VALUE 
Relationship Business Name  VALUE 
Physical Only  No 
Parent Table  ELEMENT 
Child Table  Assay_Context_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 Assay_Context_Item" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"ELEMENT to Assay_Context_Item" Foreign Keys 
Parent Key  Child Key 
ELEMENT_ID  VALUE_ID 

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


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

"Assay_Context to ASSAY_CONTEXT_MEASURE" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"Assay_Context to ASSAY_CONTEXT_MEASURE" Foreign Keys 
Parent Key  Child Key 
Assay_Context_ID  Assay_Context_ID 

"Assay_Context to ASSAY_CONTEXT_MEASURE" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  Cascade 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 


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

"MEASURE to ASSAY_CONTEXT_MEASURE" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"MEASURE to ASSAY_CONTEXT_MEASURE" Foreign Keys 
Parent Key  Child Key 
MEASURE_ID  MEASURE_ID 

"MEASURE to ASSAY_CONTEXT_MEASURE" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  Cascade 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 


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

"ASSAY to Assay_Context" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"ASSAY to Assay_Context" Foreign Keys 
Parent Key  Child Key 
ASSAY_ID  ASSAY_ID 

"ASSAY to Assay_Context" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 


"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 


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

"ASSAY to ASSAY_DOCUMENT" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"ASSAY to ASSAY_DOCUMENT" Foreign Keys 
Parent Key  Child Key 
ASSAY_ID  ASSAY_ID 

"ASSAY to ASSAY_DOCUMENT" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 


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

"ROLE to ASSAY" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"ROLE to ASSAY" Foreign Keys 
Parent Key  Child Key 
ROLE_ID  OWNER_ROLE_ID 

"ROLE to ASSAY" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 


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

"AUDIT_ROW_LOG to AUDIT_COLUMN_LOG" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"AUDIT_ROW_LOG to AUDIT_COLUMN_LOG" Foreign Keys 
Parent Key  Child Key 
AUDIT_ID  AUDIT_ID 

"AUDIT_ROW_LOG to AUDIT_COLUMN_LOG" 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 


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

"EXPERIMENT to CONFIDENCE_LEVEL_SCORE" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"EXPERIMENT to CONFIDENCE_LEVEL_SCORE" Foreign Keys 
Parent Key  Child Key 
EXPERIMENT_ID  EXPERIMENT_ID 

"EXPERIMENT to CONFIDENCE_LEVEL_SCORE" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  Cascade 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 


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

"CONFIDENCE_LEVEL_FACTOR to CONFIDENCE_LEVEL_SCORE" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"CONFIDENCE_LEVEL_FACTOR to CONFIDENCE_LEVEL_SCORE" Foreign Keys 
Parent Key  Child Key 
CONFIDENCE_LEVEL_FACTOR_ID  CONFIDENCE_LEVEL_FACTOR_ID 

"CONFIDENCE_LEVEL_FACTOR to CONFIDENCE_LEVEL_SCORE" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 


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

"PCASSAY to PCASSAY_COLUMN" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"PCASSAY to PCASSAY_COLUMN" Foreign Keys 
Parent Key  Child Key 
ASSAY_ID  ASSAY_ASSAY_ID 

"PCASSAY to PCASSAY_COLUMN" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 


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

"PCASSAY_PANEL to PCASSAY_COLUMN" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"PCASSAY_PANEL to PCASSAY_COLUMN" Foreign Keys 
Parent Key  Child Key 
PANEL_ID  PANEL_PANEL_ID 

"PCASSAY_PANEL to PCASSAY_COLUMN" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 


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

"PCASSAY to PCASSAY_COMMENTS" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"PCASSAY to PCASSAY_COMMENTS" Foreign Keys 
Parent Key  Child Key 
ASSAY_ID  ASSAY_ASSAY_ID 

"PCASSAY to PCASSAY_COMMENTS" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 


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

"PCCOMPOUND to PCCOMPOUND_SYNONYMS" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"PCCOMPOUND to PCCOMPOUND_SYNONYMS" Foreign Keys 
Parent Key  Child Key 
CD_ID  CID 

"PCCOMPOUND to PCCOMPOUND_SYNONYMS" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 


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

"PCASSAY_RESULT to CURVES" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"PCASSAY_RESULT to CURVES" Foreign Keys 
Parent Key  Child Key 
RESULT_ID  ASSAYRESULT_RESULT_ID 

"PCASSAY_RESULT to CURVES" 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 


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

"EXPERIMENT to EXPRMT_CONTEXT" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"EXPERIMENT to EXPRMT_CONTEXT" Foreign Keys 
Parent Key  Child Key 
EXPERIMENT_ID  EXPERIMENT_ID 

"EXPERIMENT to EXPRMT_CONTEXT" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 


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

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

"ELEMENT to EXPRMT_CONTEXT_ITEM" Foreign Keys 
Parent Key  Child Key 
ELEMENT_ID  ATTRIBUTE_ID 

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


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

"EXPRMT_CONTEXT to EXPRMT_CONTEXT_ITEM" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"EXPRMT_CONTEXT to EXPRMT_CONTEXT_ITEM" Foreign Keys 
Parent Key  Child Key 
EXPRMT_CONTEXT_ID  EXPRMT_CONTEXT_ID 

"EXPRMT_CONTEXT to EXPRMT_CONTEXT_ITEM" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 


"ELEMENT to EXPRMT_CONTEXT_ITEM" 
RelationshipType  Non-Identifying 
Do Not Generate  False 
Relationship Name  FK_E_CNTXT_ITM_VALUE 
Relationship Business Name  value 
Physical Only  No 
Parent Table  ELEMENT 
Child Table  EXPRMT_CONTEXT_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 EXPRMT_CONTEXT_ITEM" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"ELEMENT to EXPRMT_CONTEXT_ITEM" Foreign Keys 
Parent Key  Child Key 
ELEMENT_ID  VALUE_ID 

"ELEMENT to EXPRMT_CONTEXT_ITEM" 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 


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

"Assay_Context to ASSAY_CTXT_EXP_MEASURE" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"Assay_Context to ASSAY_CTXT_EXP_MEASURE" Foreign Keys 
Parent Key  Child Key 
Assay_Context_ID  Assay_Context_ID 

"Assay_Context to ASSAY_CTXT_EXP_MEASURE" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  Cascade 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 


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

"EXPRMT_MEASURE to ASSAY_CTXT_EXP_MEASURE" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"EXPRMT_MEASURE to ASSAY_CTXT_EXP_MEASURE" Foreign Keys 
Parent Key  Child Key 
EXPRMT_MEASURE_ID  EXPERIMENT_MEASURE_ID 

"EXPRMT_MEASURE to ASSAY_CTXT_EXP_MEASURE" 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 


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

"MIGRATION_ACTION to MIGRATION_EVENT" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"MIGRATION_ACTION to MIGRATION_EVENT" Foreign Keys 
Parent Key  Child Key 
ACTION_REF  ACTION_REF 

"MIGRATION_ACTION to MIGRATION_EVENT" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 


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

"MIGRATION_DAY to MIGRATION_EVENT" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"MIGRATION_DAY to MIGRATION_EVENT" Foreign Keys 
Parent Key  Child Key 
DAY_REF  DAY_REF 

"MIGRATION_DAY to MIGRATION_EVENT" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 


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

"MIGRATION_PERSON to MIGRATION_EVENT" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"MIGRATION_PERSON to MIGRATION_EVENT" Foreign Keys 
Parent Key  Child Key 
PERSON_REF  PERSON_REF 

"MIGRATION_PERSON to MIGRATION_EVENT" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 


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

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

"ELEMENT to EXPRMT_MEASURE" Foreign Keys 
Parent Key  Child Key 
ELEMENT_ID  RESULT_TYPE_ID 

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


"ELEMENT to EXPRMT_MEASURE" 
RelationshipType  Non-Identifying 
Do Not Generate  False 
Relationship Name  FK_EXP_MEASURE_STATS_MOD 
Relationship Business Name  STATS MODIFIER 
Physical Only  No 
Parent Table  ELEMENT 
Child Table  EXPRMT_MEASURE 
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 EXPRMT_MEASURE" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"ELEMENT to EXPRMT_MEASURE" Foreign Keys 
Parent Key  Child Key 
ELEMENT_ID  STATS_MODIFIER_ID 

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


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

"ROLE to EXPERIMENT" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"ROLE to EXPERIMENT" Foreign Keys 
Parent Key  Child Key 
ROLE_ID  OWNER_ROLE_ID 

"ROLE to EXPERIMENT" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 


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

"ASSAY to EXPERIMENT" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"ASSAY to EXPERIMENT" Foreign Keys 
Parent Key  Child Key 
ASSAY_ID  ASSAY_ID 

"ASSAY to EXPERIMENT" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 


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

"EXPERIMENT to EXPERIMENT_FILE" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"EXPERIMENT to EXPERIMENT_FILE" Foreign Keys 
Parent Key  Child Key 
EXPERIMENT_ID  EXPERIMENT_ID 

"EXPERIMENT to EXPERIMENT_FILE" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 


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

"EXPERIMENT to EXPERIMENT_DOCUMENT" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"EXPERIMENT to EXPERIMENT_DOCUMENT" Foreign Keys 
Parent Key  Child Key 
EXPERIMENT_ID  EXPERIMENT_ID 

"EXPERIMENT to EXPERIMENT_DOCUMENT" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 


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

"PANEL_EXPERIMENT to EXPERIMENT" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"PANEL_EXPERIMENT to EXPERIMENT" Foreign Keys 
Parent Key  Child Key 
PANEL_EXPRMT_ID  PANEL_EXPRMT_ID 

"PANEL_EXPERIMENT to EXPERIMENT" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 


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

"EXPERIMENT to EXPRMT_MEASURE" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"EXPERIMENT to EXPRMT_MEASURE" Foreign Keys 
Parent Key  Child Key 
EXPERIMENT_ID  EXPERIMENT_ID 

"EXPERIMENT to EXPRMT_MEASURE" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 


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

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

"EXPRMT_MEASURE to EXPRMT_MEASURE" Foreign Keys 
Parent Key  Child Key 
EXPRMT_MEASURE_ID  PARENT_EXPRMT_MEASURE_ID 

"EXPRMT_MEASURE to EXPRMT_MEASURE" 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 


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

"EXPERIMENT to EXTERNAL_REFERENCE" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"EXPERIMENT to EXTERNAL_REFERENCE" Foreign Keys 
Parent Key  Child Key 
EXPERIMENT_ID  EXPERIMENT_ID 

"EXPERIMENT to EXTERNAL_REFERENCE" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 


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

"EXTERNAL_SYSTEM to EXTERNAL_REFERENCE" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"EXTERNAL_SYSTEM to EXTERNAL_REFERENCE" Foreign Keys 
Parent Key  Child Key 
EXTERNAL_SYSTEM_ID  EXTERNAL_SYSTEM_ID 

"EXTERNAL_SYSTEM to EXTERNAL_REFERENCE" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 


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

"PROJECT to EXTERNAL_REFERENCE" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"PROJECT to EXTERNAL_REFERENCE" Foreign Keys 
Parent Key  Child Key 
PROJECT_ID  PROJECT_ID 

"PROJECT to EXTERNAL_REFERENCE" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 


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

"PERSON to FAVORITE" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"PERSON to FAVORITE" Foreign Keys 
Parent Key  Child Key 
PERSON_ID  PERSON_ID 

"PERSON to FAVORITE" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 


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

"CONFIDENCE_LEVEL_FACTOR to FACTOR_COMPONENT" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"CONFIDENCE_LEVEL_FACTOR to FACTOR_COMPONENT" Foreign Keys 
Parent Key  Child Key 
CONFIDENCE_LEVEL_FACTOR_ID  CONFIDENCE_LEVEL_FACTOR_ID 

"CONFIDENCE_LEVEL_FACTOR to FACTOR_COMPONENT" 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 


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

"ASSAY to MEASURE" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"ASSAY to MEASURE" Foreign Keys 
Parent Key  Child Key 
ASSAY_ID  ASSAY_ID 

"ASSAY to MEASURE" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 


"ELEMENT to MEASURE" 
RelationshipType  Non-Identifying 
Do Not Generate  False 
Relationship Name  FK_Measure_Element_Unit 
Relationship Business Name  UNIT 
Physical Only  No 
Parent Table  ELEMENT 
Child Table  MEASURE 
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 MEASURE" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"ELEMENT to MEASURE" Foreign Keys 
Parent Key  Child Key 
ELEMENT_ID  ENTRY_UNIT_ID 

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


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

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

"MEASURE to MEASURE" Foreign Keys 
Parent Key  Child Key 
MEASURE_ID  PARENT_MEASURE_ID 

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


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

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

"ELEMENT to MEASURE" Foreign Keys 
Parent Key  Child Key 
ELEMENT_ID  RESULT_TYPE_ID 

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


"ELEMENT to MEASURE" 
RelationshipType  Non-Identifying 
Do Not Generate  False 
Relationship Name  FK_MEASURE_STATS_MODIFIER 
Relationship Business Name  stats 
Physical Only  No 
Parent Table  ELEMENT 
Child Table  MEASURE 
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 MEASURE" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"ELEMENT to MEASURE" Foreign Keys 
Parent Key  Child Key 
ELEMENT_ID  Stats_Modifier_ID 

"ELEMENT to MEASURE" 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 


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

"ASSAY to PANEL_ASSAY" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"ASSAY to PANEL_ASSAY" Foreign Keys 
Parent Key  Child Key 
ASSAY_ID  ASSAY_ID 

"ASSAY to PANEL_ASSAY" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  Cascade 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 


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

"PANEL to PANEL_ASSAY" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"PANEL to PANEL_ASSAY" Foreign Keys 
Parent Key  Child Key 
PANEL_ID  PANEL_ID 

"PANEL to PANEL_ASSAY" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  Cascade 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 


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

"PANEL to PANEL_EXPERIMENT" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"PANEL to PANEL_EXPERIMENT" Foreign Keys 
Parent Key  Child Key 
PANEL_ID  PANEL_ID 

"PANEL to PANEL_EXPERIMENT" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 


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

"ROLE to PANEL" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"ROLE to PANEL" Foreign Keys 
Parent Key  Child Key 
ROLE_ID  OWNER_ROLE_ID 

"ROLE to PANEL" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 


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

"PCASSAY to PCASSAY_PANEL" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"PCASSAY to PCASSAY_PANEL" Foreign Keys 
Parent Key  Child Key 
ASSAY_ID  ASSAY_ASSAY_ID 

"PCASSAY to PCASSAY_PANEL" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 


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

"PCASSAY to PCASSAY_PANEL" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"PCASSAY to PCASSAY_PANEL" Foreign Keys 
Parent Key  Child Key 
ASSAY_ID  PANEL_ASSAY_ID 

"PCASSAY to PCASSAY_PANEL" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 


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

"CURVES to PCASSAY_RESULT" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"CURVES to PCASSAY_RESULT" Foreign Keys 
Parent Key  Child Key 
ID  CURVE_ID 

"CURVES to PCASSAY_RESULT" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 


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

"PCASSAY to PCASSAY_RESULT" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"PCASSAY to PCASSAY_RESULT" Foreign Keys 
Parent Key  Child Key 
ASSAY_ID  ASSAY_ASSAY_ID 

"PCASSAY to PCASSAY_RESULT" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 


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

"PCASSAY_COLUMN to PCASSAY_RESULT" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"PCASSAY_COLUMN to PCASSAY_RESULT" Foreign Keys 
Parent Key  Child Key 
COLUMN_ID  PRIMARYCOLUMN_COLUMN_ID 

"PCASSAY_COLUMN to PCASSAY_RESULT" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 


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

"PERSON to PERSON_ROLE" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"PERSON to PERSON_ROLE" Foreign Keys 
Parent Key  Child Key 
PERSON_ID  PERSON_ID 

"PERSON to PERSON_ROLE" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 


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

"ROLE to PERSON_ROLE" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"ROLE to PERSON_ROLE" Foreign Keys 
Parent Key  Child Key 
ROLE_ID  ROLE_ID 

"ROLE to PERSON_ROLE" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 


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

"PCASSAY to PCASSAY_PLOTLABEL" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"PCASSAY to PCASSAY_PLOTLABEL" Foreign Keys 
Parent Key  Child Key 
ASSAY_ID  ASSAY_ASSAY_ID 

"PCASSAY to PCASSAY_PLOTLABEL" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 


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

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

"ELEMENT to PRJCT_EXPRMT_CNTXT_ITEM" Foreign Keys 
Parent Key  Child Key 
ELEMENT_ID  ATTRIBUTE_ID 

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


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

"PRJCT_EXPRMT_CONTEXT to PRJCT_EXPRMT_CNTXT_ITEM" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"PRJCT_EXPRMT_CONTEXT to PRJCT_EXPRMT_CNTXT_ITEM" Foreign Keys 
Parent Key  Child Key 
PRJCT_EXPRMT_CONTEXT_ID  PRJCT_EXPRMT_CONTEXT_ID 

"PRJCT_EXPRMT_CONTEXT to PRJCT_EXPRMT_CNTXT_ITEM" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 


"ELEMENT to PRJCT_EXPRMT_CNTXT_ITEM" 
RelationshipType  Non-Identifying 
Do Not Generate  False 
Relationship Name  FK_PRJ_EXPT_CNTXT_ITM_VAL 
Relationship Business Name  value 
Physical Only  No 
Parent Table  ELEMENT 
Child Table  PRJCT_EXPRMT_CNTXT_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 PRJCT_EXPRMT_CNTXT_ITEM" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"ELEMENT to PRJCT_EXPRMT_CNTXT_ITEM" Foreign Keys 
Parent Key  Child Key 
ELEMENT_ID  VALUE_ID 

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


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

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

"ELEMENT to Project_Context_Item" Foreign Keys 
Parent Key  Child Key 
ELEMENT_ID  ATTRIBUTE_ID 

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


"ELEMENT to Project_Context_Item" 
RelationshipType  Non-Identifying 
Do Not Generate  False 
Relationship Name  FK_PRJCT_CNTXT_ITEM_VALUE 
Relationship Business Name  value 
Physical Only  No 
Parent Table  ELEMENT 
Child Table  Project_Context_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 Project_Context_Item" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"ELEMENT to Project_Context_Item" Foreign Keys 
Parent Key  Child Key 
ELEMENT_ID  VALUE_ID 

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


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

"PROJECT_CONTEXT to Project_Context_Item" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"PROJECT_CONTEXT to Project_Context_Item" Foreign Keys 
Parent Key  Child Key 
PROJECT_CONTEXT_ID  PROJECT_CONTEXT_ID 

"PROJECT_CONTEXT to Project_Context_Item" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 


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

"PROJECT to PROJECT_CONTEXT" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"PROJECT to PROJECT_CONTEXT" Foreign Keys 
Parent Key  Child Key 
PROJECT_ID  PROJECT_ID 

"PROJECT to PROJECT_CONTEXT" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 


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

"EXPERIMENT to PROJECT_EXPERIMENT" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"EXPERIMENT to PROJECT_EXPERIMENT" Foreign Keys 
Parent Key  Child Key 
EXPERIMENT_ID  EXPERIMENT_ID 

"EXPERIMENT to PROJECT_EXPERIMENT" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 


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

"PROJECT to PROJECT_EXPERIMENT" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"PROJECT to PROJECT_EXPERIMENT" Foreign Keys 
Parent Key  Child Key 
PROJECT_ID  PROJECT_ID 

"PROJECT to PROJECT_EXPERIMENT" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 


"ELEMENT to PROJECT_EXPERIMENT" 
RelationshipType  Non-Identifying 
Do Not Generate  False 
Relationship Name  FK_PRJCT_EXPRMT_STAGE 
Relationship Business Name   
Physical Only  No 
Parent Table  ELEMENT 
Child Table  PROJECT_EXPERIMENT 
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 PROJECT_EXPERIMENT" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"ELEMENT to PROJECT_EXPERIMENT" Foreign Keys 
Parent Key  Child Key 
ELEMENT_ID  STAGE_ID 

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


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

"PROJECT_EXPERIMENT to Project_Step" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"PROJECT_EXPERIMENT to Project_Step" Foreign Keys 
Parent Key  Child Key 
PROJECT_EXPERIMENT_ID  NEXT_PROJECT_EXPERIMENT_ID 

"PROJECT_EXPERIMENT to Project_Step" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 


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

"PROJECT_EXPERIMENT to Project_Step" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"PROJECT_EXPERIMENT to Project_Step" Foreign Keys 
Parent Key  Child Key 
PROJECT_EXPERIMENT_ID  PREV_PROJECT_EXPERIMENT_ID 

"PROJECT_EXPERIMENT to Project_Step" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 


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

"PROJECT to PROJECT_DOCUMENT" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"PROJECT to PROJECT_DOCUMENT" Foreign Keys 
Parent Key  Child Key 
PROJECT_ID  PROJECT_ID 

"PROJECT to PROJECT_DOCUMENT" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 


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

"ROLE to PROJECT" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"ROLE to PROJECT" Foreign Keys 
Parent Key  Child Key 
ROLE_ID  OWNER_ROLE_ID 

"ROLE to PROJECT" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 


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

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

"ELEMENT to Rslt_Context_Item" Foreign Keys 
Parent Key  Child Key 
ELEMENT_ID  ATTRIBUTE_ID 

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


"ELEMENT to Rslt_Context_Item" 
RelationshipType  Non-Identifying 
Do Not Generate  False 
Relationship Name  FK_R_CONTEXT_ITEM_VALUE 
Relationship Business Name  value 
Physical Only  No 
Parent Table  ELEMENT 
Child Table  Rslt_Context_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 Rslt_Context_Item" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"ELEMENT to Rslt_Context_Item" Foreign Keys 
Parent Key  Child Key 
ELEMENT_ID  VALUE_ID 

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


"ELEMENT to RESULT" 
RelationshipType  Non-Identifying 
Do Not Generate  False 
Relationship Name  FK_RESULT_ELEMENT_VALUE 
Relationship Business Name  value 
Physical Only  No 
Parent Table  ELEMENT 
Child Table  RESULT 
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 RESULT" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"ELEMENT to RESULT" Foreign Keys 
Parent Key  Child Key 
ELEMENT_ID  Value_ID 

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


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

"EXPERIMENT to RESULT" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"EXPERIMENT to RESULT" Foreign Keys 
Parent Key  Child Key 
EXPERIMENT_ID  EXPERIMENT_ID 

"EXPERIMENT to RESULT" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 


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

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

"RESULT to RESULT" Foreign Keys 
Parent Key  Child Key 
RESULT_ID  PARENT_RESULT_ID 

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


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

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

"ELEMENT to RESULT" Foreign Keys 
Parent Key  Child Key 
ELEMENT_ID  RESULT_TYPE_ID 

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


"ELEMENT to RESULT" 
RelationshipType  Non-Identifying 
Do Not Generate  False 
Relationship Name  FK_RESULT_STATS_MODIFIER 
Relationship Business Name  stats 
Physical Only  No 
Parent Table  ELEMENT 
Child Table  RESULT 
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 RESULT" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"ELEMENT to RESULT" Foreign Keys 
Parent Key  Child Key 
ELEMENT_ID  STATS_MODIFIER_ID 

"ELEMENT to RESULT" 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 STEP_CONTEXT_ITEM" 
RelationshipType  Non-Identifying 
Do Not Generate  False 
Relationship Name  FK_STEP_CNTXT_ITEM_ATTR 
Relationship Business Name  value 
Physical Only  No 
Parent Table  ELEMENT 
Child Table  STEP_CONTEXT_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 STEP_CONTEXT_ITEM" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"ELEMENT to STEP_CONTEXT_ITEM" Foreign Keys 
Parent Key  Child Key 
ELEMENT_ID  VALUE_ID 

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


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

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

"ELEMENT to STEP_CONTEXT_ITEM" Foreign Keys 
Parent Key  Child Key 
ELEMENT_ID  ATTRIBUTE_ID 

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


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

"STEP_CONTEXT to STEP_CONTEXT_ITEM" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"STEP_CONTEXT to STEP_CONTEXT_ITEM" Foreign Keys 
Parent Key  Child Key 
STEP_CONTEXT_ID  STEP_CONTEXT_ID 

"STEP_CONTEXT to STEP_CONTEXT_ITEM" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 


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

"Project_Step to STEP_CONTEXT" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"Project_Step to STEP_CONTEXT" Foreign Keys 
Parent Key  Child Key 
Project_Step_ID  Project_Step_ID 

"Project_Step to STEP_CONTEXT" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 


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

"PERSON_ROLE to TEAM_MEMBER" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"PERSON_ROLE to TEAM_MEMBER" Foreign Keys 
Parent Key  Child Key 
PERSON_ROLE_ID  PERSON_ROLE_ID 

"PERSON_ROLE to TEAM_MEMBER" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 


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

"TEAM to TEAM_MEMBER" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"TEAM to TEAM_MEMBER" Foreign Keys 
Parent Key  Child Key 
TEAM_ID  TEAM_ID 

"TEAM to TEAM_MEMBER" 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 


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

"PCASSAY to PCASSAY_XREF" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"PCASSAY to PCASSAY_XREF" Foreign Keys 
Parent Key  Child Key 
ASSAY_ID  ASSAY_ASSAY_ID 

"PCASSAY to PCASSAY_XREF" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 


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

"PCASSAY_PANEL to PCASSAY_XREF" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"PCASSAY_PANEL to PCASSAY_XREF" Foreign Keys 
Parent Key  Child Key 
PANEL_ID  PANEL_PANEL_ID 

"PCASSAY_PANEL to PCASSAY_XREF" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None