"Assay_Context to Rslt_Context_Item" 
RelationshipType  Non-Identifying 
Do Not Generate  False 
Relationship Name   
Relationship Business Name   
Logical Only  No 
Parent Entity  Assay_Context 
Child Entity  Rslt_Context_Item 
Cardinality  One To Zero or More 
Existence  Mandatory 
Propagated Key  Primary Key 

"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 


"Assay_Context to Assay_Context_Item" 
RelationshipType  Non-Identifying 
Do Not Generate  False 
Relationship Name  FK_A_CONTEXT_ITEM_A_CONTEXT 
Relationship Business Name   
Logical Only  No 
Parent Entity  Assay_Context 
Child Entity  Assay_Context_Item 
Cardinality  One To Zero or More 
Existence  Mandatory 
Propagated Key  Primary Key 

"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 
Logical Only  No 
Parent Entity  Element 
Child Entity  Assay_Context_Item 
Cardinality  One To Zero or More 
Existence  Mandatory 
Propagated Key  Primary Key 

"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 
Logical Only  No 
Parent Entity  Element 
Child Entity  Assay_Context_Item 
Cardinality  Zero or One to Zero or More 
Existence  Optional 
Propagated Key  Primary Key 

"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   
Logical Only  No 
Parent Entity  Assay_Context 
Child Entity  Assay_Context_Measure 
Cardinality  One To Zero or More 
Existence  Mandatory 
Propagated Key  Primary Key 

"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   
Logical Only  No 
Parent Entity  Measure 
Child Entity  Assay_Context_Measure 
Cardinality  One To Zero or More 
Existence  Mandatory 
Propagated Key  Primary Key 

"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   
Logical Only  No 
Parent Entity  Assay 
Child Entity  Assay_Context 
Cardinality  One To Zero or More 
Existence  Mandatory 
Propagated Key  Primary Key 

"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 to Assay_document" 
RelationshipType  Non-Identifying 
Do Not Generate  False 
Relationship Name  FK_ASSAY_DOCUMENT_ASSAY 
Relationship Business Name   
Logical Only  No 
Parent Entity  Assay 
Child Entity  Assay_document 
Cardinality  One To Zero or More 
Existence  Mandatory 
Propagated Key  Primary Key 

"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   
Logical Only  No 
Parent Entity  Role 
Child Entity  Assay 
Cardinality  Zero or One to Zero or More 
Existence  Optional 
Propagated Key  Primary Key 

"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 


"Experiment to Exprmt_Context" 
RelationshipType  Non-Identifying 
Do Not Generate  False 
Relationship Name  FK_E_CNTXT_EXPERIMENT 
Relationship Business Name   
Logical Only  No 
Parent Entity  Experiment 
Child Entity  Exprmt_Context 
Cardinality  One To Zero or More 
Existence  Mandatory 
Propagated Key  Primary Key 

"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 
Logical Only  No 
Parent Entity  Element 
Child Entity  Exprmt_Context_Item 
Cardinality  One To Zero or More 
Existence  Mandatory 
Propagated Key  Primary Key 

"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   
Logical Only  No 
Parent Entity  Exprmt_Context 
Child Entity  Exprmt_Context_Item 
Cardinality  One To Zero or More 
Existence  Mandatory 
Propagated Key  Primary Key 

"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 
Logical Only  No 
Parent Entity  Element 
Child Entity  Exprmt_Context_Item 
Cardinality  Zero or One to Zero or More 
Existence  Optional 
Propagated Key  Primary Key 

"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   
Logical Only  No 
Parent Entity  Element 
Child Entity  Element_Hierarchy 
Cardinality  One To Zero or More 
Existence  Mandatory 
Propagated Key  Primary Key 

"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   
Logical Only  No 
Parent Entity  Element 
Child Entity  Element_Hierarchy 
Cardinality  One To Zero or More 
Existence  Mandatory 
Propagated Key  Primary Key 

"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   
Logical Only  No 
Parent Entity  Assay_Context 
Child Entity  ASSAY_CTXT_EXP_MEASURE 
Cardinality  One To Zero or More 
Existence  Mandatory 
Propagated Key  Primary Key 

"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   
Logical Only  No 
Parent Entity  Exprmt_Measure 
Child Entity  ASSAY_CTXT_EXP_MEASURE 
Cardinality  One To Zero or More 
Existence  Mandatory 
Propagated Key  Primary Key 

"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 
Logical Only  No 
Parent Entity  Element 
Child Entity  Element 
Cardinality  Zero or One to Zero or More 
Existence  Optional 
Propagated Key  Primary Key 

"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 


"Element to Exprmt_Measure" 
RelationshipType  Non-Identifying 
Do Not Generate  False 
Relationship Name  FK_EXP_MEASURE_RESULT_TYPE 
Relationship Business Name  RESULT TYPE 
Logical Only  No 
Parent Entity  Element 
Child Entity  Exprmt_Measure 
Cardinality  One To Zero or More 
Existence  Mandatory 
Propagated Key  Primary Key 

"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 
Logical Only  No 
Parent Entity  Element 
Child Entity  Exprmt_Measure 
Cardinality  Zero or One to Zero or More 
Existence  Optional 
Propagated Key  Primary Key 

"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   
Logical Only  No 
Parent Entity  Role 
Child Entity  Experiment 
Cardinality  Zero or One to Zero or More 
Existence  Optional 
Propagated Key  Primary Key 

"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   
Logical Only  No 
Parent Entity  Assay 
Child Entity  Experiment 
Cardinality  One To Zero or More 
Existence  Mandatory 
Propagated Key  Primary Key 

"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   
Logical Only  No 
Parent Entity  Experiment 
Child Entity  EXPERIMENT_FILE 
Cardinality  One To Zero or More 
Existence  Mandatory 
Propagated Key  Primary Key 

"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 


"PANEL_LOAD to Experiment" 
RelationshipType  Non-Identifying 
Do Not Generate  False 
Relationship Name  FK_EXPRMT_EXPRMT_PANEL 
Relationship Business Name   
Logical Only  No 
Parent Entity  PANEL_LOAD 
Child Entity  Experiment 
Cardinality  Zero or One to Zero or More 
Existence  Optional 
Propagated Key  Primary Key 

"PANEL_LOAD to Experiment" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"PANEL_LOAD to Experiment" Foreign Keys 
Parent Key  Child Key 
PANEL_LOAD_ID  PANEL_LOAD_ID 

"PANEL_LOAD 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   
Logical Only  No 
Parent Entity  Experiment 
Child Entity  Exprmt_Measure 
Cardinality  One To Zero or More 
Existence  Mandatory 
Propagated Key  Primary Key 

"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   
Logical Only  No 
Parent Entity  Exprmt_Measure 
Child Entity  Exprmt_Measure 
Cardinality  Zero or One to Zero or More 
Existence  Optional 
Propagated Key  Primary Key 

"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 


"Experiment to External_Reference" 
RelationshipType  Non-Identifying 
Do Not Generate  False 
Relationship Name  FK_EXT_REFERENCE_EXPERIMENT 
Relationship Business Name   
Logical Only  No 
Parent Entity  Experiment 
Child Entity  External_Reference 
Cardinality  Zero or One to Zero or More 
Existence  Optional 
Propagated Key  Primary Key 

"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   
Logical Only  No 
Parent Entity  External_System 
Child Entity  External_Reference 
Cardinality  One To Zero or More 
Existence  Mandatory 
Propagated Key  Primary Key 

"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   
Logical Only  No 
Parent Entity  Project 
Child Entity  External_Reference 
Cardinality  Zero or One to Zero or More 
Existence  Optional 
Propagated Key  Primary Key 

"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   
Logical Only  No 
Parent Entity  Person 
Child Entity  Favorite 
Cardinality  One To Zero or More 
Existence  Mandatory 
Propagated Key  Primary Key 

"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 


"Assay to Measure" 
RelationshipType  Non-Identifying 
Do Not Generate  False 
Relationship Name  FK_MEASURE_ASSAY 
Relationship Business Name   
Logical Only  No 
Parent Entity  Assay 
Child Entity  Measure 
Cardinality  One To Zero or More 
Existence  Mandatory 
Propagated Key  Primary Key 

"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 
Logical Only  No 
Parent Entity  Element 
Child Entity  Measure 
Cardinality  Zero or One to Zero or More 
Existence  Optional 
Propagated Key  Primary Key 

"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   
Logical Only  No 
Parent Entity  Measure 
Child Entity  Measure 
Cardinality  Zero or One to Zero or More 
Existence  Optional 
Propagated Key  Primary Key 

"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   
Logical Only  No 
Parent Entity  Element 
Child Entity  Measure 
Cardinality  One To Zero or More 
Existence  Mandatory 
Propagated Key  Primary Key 

"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 
Logical Only  No 
Parent Entity  Element 
Child Entity  Measure 
Cardinality  Zero or One to Zero or More 
Existence  Optional 
Propagated Key  Primary Key 

"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   
Logical Only  No 
Parent Entity  Element 
Child Entity  Ontology_Item 
Cardinality  Zero or One to Zero or More 
Existence  Optional 
Propagated Key  Primary Key 

"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   
Logical Only  No 
Parent Entity  Ontology 
Child Entity  Ontology_Item 
Cardinality  One To Zero or More 
Existence  Mandatory 
Propagated Key  Primary Key 

"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   
Logical Only  No 
Parent Entity  Assay 
Child Entity  PANEL_ASSAY 
Cardinality  One To Zero or More 
Existence  Mandatory 
Propagated Key  Primary Key 

"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   
Logical Only  No 
Parent Entity  PANEL 
Child Entity  PANEL_ASSAY 
Cardinality  One To Zero or More 
Existence  Mandatory 
Propagated Key  Primary Key 

"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_LOAD" 
RelationshipType  Non-Identifying 
Do Not Generate  False 
Relationship Name  FK_PANEL_EXPRMT_PANEL 
Relationship Business Name   
Logical Only  No 
Parent Entity  PANEL 
Child Entity  PANEL_LOAD 
Cardinality  One To Zero or More 
Existence  Mandatory 
Propagated Key  Primary Key 

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

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

"PANEL to PANEL_LOAD" 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   
Logical Only  No 
Parent Entity  Role 
Child Entity  PANEL 
Cardinality  Zero or One to Zero or More 
Existence  Optional 
Propagated Key  Primary Key 

"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 


"Person to Person_Role" 
RelationshipType  Non-Identifying 
Do Not Generate  False 
Relationship Name  FK_PERSON_ROLE_PERSON 
Relationship Business Name   
Logical Only  No 
Parent Entity  Person 
Child Entity  Person_Role 
Cardinality  One To Zero or More 
Existence  Mandatory 
Propagated Key  Primary Key 

"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   
Logical Only  No 
Parent Entity  Role 
Child Entity  Person_Role 
Cardinality  One To Zero or More 
Existence  Mandatory 
Propagated Key  Primary Key 

"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 


"Element to Project_Context_Item" 
RelationshipType  Non-Identifying 
Do Not Generate  False 
Relationship Name  FK_PRJCT_CNTXT_ITEM_ATTRIBUTE 
Relationship Business Name  attribute 
Logical Only  No 
Parent Entity  Element 
Child Entity  Project_Context_Item 
Cardinality  One To Zero or More 
Existence  Mandatory 
Propagated Key  Primary Key 

"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 
Logical Only  No 
Parent Entity  Element 
Child Entity  Project_Context_Item 
Cardinality  Zero or One to Zero or More 
Existence  Optional 
Propagated Key  Primary Key 

"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   
Logical Only  No 
Parent Entity  Project_Context 
Child Entity  Project_Context_Item 
Cardinality  One To Zero or More 
Existence  Mandatory 
Propagated Key  Primary Key 

"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   
Logical Only  No 
Parent Entity  Project 
Child Entity  Project_Context 
Cardinality  One To Zero or More 
Existence  Mandatory 
Propagated Key  Primary Key 

"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   
Logical Only  No 
Parent Entity  Experiment 
Child Entity  Project_Experiment 
Cardinality  Zero or One to Zero or More 
Existence  Optional 
Propagated Key  Primary Key 

"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   
Logical Only  No 
Parent Entity  Project 
Child Entity  Project_Experiment 
Cardinality  One To Zero or More 
Existence  Mandatory 
Propagated Key  Primary Key 

"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   
Logical Only  No 
Parent Entity  Element 
Child Entity  Project_Experiment 
Cardinality  Zero or One to Zero or More 
Existence  Optional 
Propagated Key  Primary Key 

"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 
Logical Only  No 
Parent Entity  Project_Experiment 
Child Entity  Project_Step 
Cardinality  One To Zero or More 
Existence  Mandatory 
Propagated Key  Primary Key 

"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 
Logical Only  No 
Parent Entity  Project_Experiment 
Child Entity  Project_Step 
Cardinality  One To Zero or More 
Existence  Mandatory 
Propagated Key  Primary Key 

"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   
Logical Only  No 
Parent Entity  Project 
Child Entity  Project_Document 
Cardinality  One To Zero or More 
Existence  Mandatory 
Propagated Key  Primary Key 

"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   
Logical Only  No 
Parent Entity  Role 
Child Entity  Project 
Cardinality  Zero or One to Zero or More 
Existence  Optional 
Propagated Key  Primary Key 

"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 
Logical Only  No 
Parent Entity  Element 
Child Entity  Rslt_Context_Item 
Cardinality  One To Zero or More 
Existence  Mandatory 
Propagated Key  Primary Key 

"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 
Logical Only  No 
Parent Entity  Element 
Child Entity  Rslt_Context_Item 
Cardinality  Zero or One to Zero or More 
Existence  Optional 
Propagated Key  Primary Key 

"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 
Logical Only  No 
Parent Entity  Element 
Child Entity  Result 
Cardinality  Zero or One to Zero or More 
Existence  Optional 
Propagated Key  Primary Key 

"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   
Logical Only  No 
Parent Entity  Experiment 
Child Entity  Result 
Cardinality  One To Zero or More 
Existence  Mandatory 
Propagated Key  Primary Key 

"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   
Logical Only  No 
Parent Entity  Result 
Child Entity  Result 
Cardinality  Zero or One to Zero or More 
Existence  Optional 
Propagated Key  Primary Key 

"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 
Logical Only  No 
Parent Entity  Element 
Child Entity  Result 
Cardinality  One To Zero or More 
Existence  Mandatory 
Propagated Key  Primary Key 

"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 
Logical Only  No 
Parent Entity  Element 
Child Entity  Result 
Cardinality  Zero or One to Zero or More 
Existence  Optional 
Propagated Key  Primary Key 

"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 


"Element to Step_Context_Item" 
RelationshipType  Non-Identifying 
Do Not Generate  False 
Relationship Name  FK_STEP_CNTXT_ITEM_ATTR 
Relationship Business Name  value 
Logical Only  No 
Parent Entity  Element 
Child Entity  Step_Context_Item 
Cardinality  Zero or One to Zero or More 
Existence  Optional 
Propagated Key  Primary Key 

"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 
Logical Only  No 
Parent Entity  Element 
Child Entity  Step_Context_Item 
Cardinality  One To Zero or More 
Existence  Mandatory 
Propagated Key  Primary Key 

"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   
Logical Only  No 
Parent Entity  Step_Context 
Child Entity  Step_Context_Item 
Cardinality  One To Zero or More 
Existence  Mandatory 
Propagated Key  Primary Key 

"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   
Logical Only  No 
Parent Entity  Project_Step 
Child Entity  Step_Context 
Cardinality  One To Zero or More 
Existence  Mandatory 
Propagated Key  Primary Key 

"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   
Logical Only  No 
Parent Entity  Person_Role 
Child Entity  Team_Member 
Cardinality  One To Zero or More 
Existence  Mandatory 
Propagated Key  Primary Key 

"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   
Logical Only  No 
Parent Entity  Team 
Child Entity  Team_Member 
Cardinality  One To Zero or More 
Existence  Mandatory 
Propagated Key  Primary Key 

"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   
Logical Only  No 
Parent Entity  Element 
Child Entity  Tree_Root 
Cardinality  One To Zero or More 
Existence  Mandatory 
Propagated Key  Primary Key 

"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   
Logical Only  No 
Parent Entity  Element 
Child Entity  Unit_Conversion 
Cardinality  One To Zero or More 
Existence  Mandatory 
Propagated Key  Primary Key 

"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   
Logical Only  No 
Parent Entity  Element 
Child Entity  Unit_Conversion 
Cardinality  One To Zero or More 
Existence  Mandatory 
Propagated Key  Primary Key 

"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