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

"SAMPLE to SMPL_SET_TEMP" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"SAMPLE to SMPL_SET_TEMP" Foreign Keys 
Parent Key  Child Key 
SMPL_ID  SMPL_ID 

"SAMPLE to SMPL_SET_TEMP" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"SAMPLE to SMPL_SET_TEMP" Bound Attachments 
Name  Current Value 


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

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

"SAMPLE to SAMPLE" Foreign Keys 
Parent Key  Child Key 
SMPL_ID  FAM_SMPL_ID 

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

"SAMPLE to SAMPLE" Bound Attachments 
Name  Current Value 


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

"CTRL_AREA to CTRL_AREA_CUST" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"CTRL_AREA to CTRL_AREA_CUST" Foreign Keys 
Parent Key  Child Key 
CTRL_AREA_ID  CTRL_AREA_ID 

"CTRL_AREA to CTRL_AREA_CUST" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"CTRL_AREA to CTRL_AREA_CUST" Bound Attachments 
Name  Current Value 


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

"EMPLOYEE to CTRL_AREA_CUST" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"EMPLOYEE to CTRL_AREA_CUST" Foreign Keys 
Parent Key  Child Key 
BN  BN 

"EMPLOYEE to CTRL_AREA_CUST" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"EMPLOYEE to CTRL_AREA_CUST" Bound Attachments 
Name  Current Value 


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

"CTRL_AREA to CTRL_AREA_INVT" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"CTRL_AREA to CTRL_AREA_INVT" Foreign Keys 
Parent Key  Child Key 
CTRL_AREA_ID  CTRL_AREA_ID 

"CTRL_AREA to CTRL_AREA_INVT" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"CTRL_AREA to CTRL_AREA_INVT" Bound Attachments 
Name  Current Value 


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

"EMPLOYEE to CTRL_AREA_INVT" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"EMPLOYEE to CTRL_AREA_INVT" Foreign Keys 
Parent Key  Child Key 
BN  BN 

"EMPLOYEE to CTRL_AREA_INVT" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"EMPLOYEE to CTRL_AREA_INVT" Bound Attachments 
Name  Current Value 


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

"CTRL_AREA_SUBAREA to CTRL_AREA_SUBAREA1" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"CTRL_AREA_SUBAREA to CTRL_AREA_SUBAREA1" Foreign Keys 
Parent Key  Child Key 
CTRL_AREA_ID, SUBAREA_ID  CTRL_AREA_ID, SUBAREA_ID 

"CTRL_AREA_SUBAREA to CTRL_AREA_SUBAREA1" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"CTRL_AREA_SUBAREA to CTRL_AREA_SUBAREA1" Bound Attachments 
Name  Current Value 


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

"CTRL_AREA_SUBAREA1 to CTRL_AREA_SUBAREA2" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"CTRL_AREA_SUBAREA1 to CTRL_AREA_SUBAREA2" Foreign Keys 
Parent Key  Child Key 
CTRL_AREA_ID, SUBAREA_ID, SUBAREA1_ID  CTRL_AREA_ID, SUBAREA_ID, SUBAREA1_ID 

"CTRL_AREA_SUBAREA1 to CTRL_AREA_SUBAREA2" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"CTRL_AREA_SUBAREA1 to CTRL_AREA_SUBAREA2" Bound Attachments 
Name  Current Value 


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

"CTRL_AREA to CTRL_AREA_SUBAREA" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"CTRL_AREA to CTRL_AREA_SUBAREA" Foreign Keys 
Parent Key  Child Key 
CTRL_AREA_ID  CTRL_AREA_ID 

"CTRL_AREA to CTRL_AREA_SUBAREA" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"CTRL_AREA to CTRL_AREA_SUBAREA" Bound Attachments 
Name  Current Value 


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

"CTRL_AREA_TYPE to CTRL_AREA" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"CTRL_AREA_TYPE to CTRL_AREA" Foreign Keys 
Parent Key  Child Key 
TYPE_ID  TYPE_ID 

"CTRL_AREA_TYPE to CTRL_AREA" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"CTRL_AREA_TYPE to CTRL_AREA" Bound Attachments 
Name  Current Value 


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

"INSTR to CTRL_AREA" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"INSTR to CTRL_AREA" Foreign Keys 
Parent Key  Child Key 
INSTR_ID  INSTR_ID 

"INSTR to CTRL_AREA" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"INSTR to CTRL_AREA" Bound Attachments 
Name  Current Value 


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

"LAB to CTRL_AREA" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"LAB to CTRL_AREA" Foreign Keys 
Parent Key  Child Key 
LAB_ID  LAB_ID 

"LAB to CTRL_AREA" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"LAB to CTRL_AREA" Bound Attachments 
Name  Current Value 


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

"SMPL_HAND to CTRL_AREA" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"SMPL_HAND to CTRL_AREA" Foreign Keys 
Parent Key  Child Key 
HAND_ID  HAND_ID 

"SMPL_HAND to CTRL_AREA" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"SMPL_HAND to CTRL_AREA" Bound Attachments 
Name  Current Value 


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

"SMPL_STOR to CTRL_AREA" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"SMPL_STOR to CTRL_AREA" Foreign Keys 
Parent Key  Child Key 
STOR_ID  STOR_ID 

"SMPL_STOR to CTRL_AREA" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"SMPL_STOR to CTRL_AREA" Bound Attachments 
Name  Current Value 


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

"DOT_PKG_GRP to DOT_HAZ_MAT_TAB" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"DOT_PKG_GRP to DOT_HAZ_MAT_TAB" Foreign Keys 
Parent Key  Child Key 
PKG_GRP_ID  PKG_GRP_ID 

"DOT_PKG_GRP to DOT_HAZ_MAT_TAB" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"DOT_PKG_GRP to DOT_HAZ_MAT_TAB" Bound Attachments 
Name  Current Value 


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

"EMPLOYEE to INSTR" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"EMPLOYEE to INSTR" Foreign Keys 
Parent Key  Child Key 
BN  GRP_LEAD_BN 

"EMPLOYEE to INSTR" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"EMPLOYEE to INSTR" Bound Attachments 
Name  Current Value 


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

"SMPL_ACT to ITEMS_LOG" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"SMPL_ACT to ITEMS_LOG" Foreign Keys 
Parent Key  Child Key 
ACT_ID  ACT_ID 

"SMPL_ACT to ITEMS_LOG" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"SMPL_ACT to ITEMS_LOG" Bound Attachments 
Name  Current Value 


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

"EMPLOYEE to SMPL_SHIP" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"EMPLOYEE to SMPL_SHIP" Foreign Keys 
Parent Key  Child Key 
BN  SHIP_ORD_ORIG_BY_BN 

"EMPLOYEE to SMPL_SHIP" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"EMPLOYEE to SMPL_SHIP" Bound Attachments 
Name  Current Value 


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

"CTRL_AREA to SAMPLE" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"CTRL_AREA to SAMPLE" Foreign Keys 
Parent Key  Child Key 
CTRL_AREA_ID  CTRL_AREA_ID 

"CTRL_AREA to SAMPLE" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"CTRL_AREA to SAMPLE" Bound Attachments 
Name  Current Value 


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

"CTRL_AREA_SUBAREA to SAMPLE" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"CTRL_AREA_SUBAREA to SAMPLE" Foreign Keys 
Parent Key  Child Key 
CTRL_AREA_ID, SUBAREA_ID  CTRL_AREA_ID, SUBAREA_ID 

"CTRL_AREA_SUBAREA to SAMPLE" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"CTRL_AREA_SUBAREA to SAMPLE" Bound Attachments 
Name  Current Value 


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

"MATL_ST to SAMPLE" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"MATL_ST to SAMPLE" Foreign Keys 
Parent Key  Child Key 
ST_ID  ST_ID 

"MATL_ST to SAMPLE" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"MATL_ST to SAMPLE" Bound Attachments 
Name  Current Value 


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

"SMPL_CONT to SAMPLE" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"SMPL_CONT to SAMPLE" Foreign Keys 
Parent Key  Child Key 
CONT_ID  CONT_ID 

"SMPL_CONT to SAMPLE" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"SMPL_CONT to SAMPLE" Bound Attachments 
Name  Current Value 


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

"SMPL_STAT to SAMPLE" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"SMPL_STAT to SAMPLE" Foreign Keys 
Parent Key  Child Key 
STAT_ID  STAT_ID 

"SMPL_STAT to SAMPLE" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"SMPL_STAT to SAMPLE" Bound Attachments 
Name  Current Value 


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

"CTRL_AREA_SUBAREA to SMPL_DELIV_REQ" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"CTRL_AREA_SUBAREA to SMPL_DELIV_REQ" Foreign Keys 
Parent Key  Child Key 
CTRL_AREA_ID, SUBAREA_ID  CTRL_AREA_ID, SUBAREA_ID 

"CTRL_AREA_SUBAREA to SMPL_DELIV_REQ" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"CTRL_AREA_SUBAREA to SMPL_DELIV_REQ" Bound Attachments 
Name  Current Value 


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

"SMPL_HAZ_CLASS to SMPL_HAZ_CLASS_ITEM" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"SMPL_HAZ_CLASS to SMPL_HAZ_CLASS_ITEM" Foreign Keys 
Parent Key  Child Key 
SMPL_HAZ_ID  SMPL_HAZ_ID 

"SMPL_HAZ_CLASS to SMPL_HAZ_CLASS_ITEM" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"SMPL_HAZ_CLASS to SMPL_HAZ_CLASS_ITEM" Bound Attachments 
Name  Current Value 


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

"CNTRY to SHIP_FACIL" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"CNTRY to SHIP_FACIL" Foreign Keys 
Parent Key  Child Key 
CNTRY_ID  CNTRY_ID 

"CNTRY to SHIP_FACIL" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"CNTRY to SHIP_FACIL" Bound Attachments 
Name  Current Value 


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

"ATTACH_TYPE to SMPL_ATTACH" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"ATTACH_TYPE to SMPL_ATTACH" Foreign Keys 
Parent Key  Child Key 
ATTACH_TYPE_ID  ATTACH_TYPE_ID 

"ATTACH_TYPE to SMPL_ATTACH" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"ATTACH_TYPE to SMPL_ATTACH" Bound Attachments 
Name  Current Value 


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

"SMPL_ATTACH to SAMPLE_SMPL_ATTACH_ASSC" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"SMPL_ATTACH to SAMPLE_SMPL_ATTACH_ASSC" Foreign Keys 
Parent Key  Child Key 
ATTACH_ID  ATTACH_ID 

"SMPL_ATTACH to SAMPLE_SMPL_ATTACH_ASSC" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"SMPL_ATTACH to SAMPLE_SMPL_ATTACH_ASSC" Bound Attachments 
Name  Current Value 


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

"SMPL_CONT to SMPL_CAN" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"SMPL_CONT to SMPL_CAN" Foreign Keys 
Parent Key  Child Key 
CONT_ID  CONT_ID 

"SMPL_CONT to SMPL_CAN" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"SMPL_CONT to SMPL_CAN" Bound Attachments 
Name  Current Value 


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

"HMMIS_CHEM to SMPL_CLASS" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"HMMIS_CHEM to SMPL_CLASS" Foreign Keys 
Parent Key  Child Key 
CHEM_RECID  CHEM_RECID 

"HMMIS_CHEM to SMPL_CLASS" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"HMMIS_CHEM to SMPL_CLASS" Bound Attachments 
Name  Current Value 


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

"SAMPLE to SMPL_CLASS" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"SAMPLE to SMPL_CLASS" Foreign Keys 
Parent Key  Child Key 
SMPL_ID  SMPL_ID 

"SAMPLE to SMPL_CLASS" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"SAMPLE to SMPL_CLASS" Bound Attachments 
Name  Current Value 


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

"SMPL_HAZ to SMPL_CLASS" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"SMPL_HAZ to SMPL_CLASS" Foreign Keys 
Parent Key  Child Key 
SMPL_HAZ_ID  SMPL_HAZ_ID 

"SMPL_HAZ to SMPL_CLASS" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"SMPL_HAZ to SMPL_CLASS" Bound Attachments 
Name  Current Value 


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

"SAMPLE to SMPL_DEL_REQ" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"SAMPLE to SMPL_DEL_REQ" Foreign Keys 
Parent Key  Child Key 
SMPL_ID  SMPL_ID 

"SAMPLE to SMPL_DEL_REQ" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"SAMPLE to SMPL_DEL_REQ" Bound Attachments 
Name  Current Value 


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

"CTRL_AREA to SMPL_DELIV_REQ" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"CTRL_AREA to SMPL_DELIV_REQ" Foreign Keys 
Parent Key  Child Key 
CTRL_AREA_ID  CTRL_AREA_ID 

"CTRL_AREA to SMPL_DELIV_REQ" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"CTRL_AREA to SMPL_DELIV_REQ" Bound Attachments 
Name  Current Value 


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

"EMPLOYEE to SMPL_DELIV_REQ" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"EMPLOYEE to SMPL_DELIV_REQ" Foreign Keys 
Parent Key  Child Key 
BN  BN 

"EMPLOYEE to SMPL_DELIV_REQ" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"EMPLOYEE to SMPL_DELIV_REQ" Bound Attachments 
Name  Current Value 


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

"SAMPLE to SMPL_DELIV_REQ" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"SAMPLE to SMPL_DELIV_REQ" Foreign Keys 
Parent Key  Child Key 
SMPL_ID  SMPL_ID 

"SAMPLE to SMPL_DELIV_REQ" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"SAMPLE to SMPL_DELIV_REQ" Bound Attachments 
Name  Current Value 


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

"SMPL_GRP to SAMPLE" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"SMPL_GRP to SAMPLE" Foreign Keys 
Parent Key  Child Key 
GRP_ID  GRP_ID 

"SMPL_GRP to SAMPLE" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"SMPL_GRP to SAMPLE" Bound Attachments 
Name  Current Value 


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

"DOT_HAZ_MAT_CLASS to SAMPLE" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"DOT_HAZ_MAT_CLASS to SAMPLE" Foreign Keys 
Parent Key  Child Key 
DOT_CLASS_NBR, DOT_DIV_NBR  DOT_CLASS_NBR, DOT_DIV_NBR 

"DOT_HAZ_MAT_CLASS to SAMPLE" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"DOT_HAZ_MAT_CLASS to SAMPLE" Bound Attachments 
Name  Current Value 


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

"BEAM_ENGY_UOM to SMPL_IRRAD" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"BEAM_ENGY_UOM to SMPL_IRRAD" Foreign Keys 
Parent Key  Child Key 
BEAM_ENGY_UOM_ID  BEAM_ENGY_UOM_ID 

"BEAM_ENGY_UOM to SMPL_IRRAD" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"BEAM_ENGY_UOM to SMPL_IRRAD" Bound Attachments 
Name  Current Value 


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

"INSTR to SMPL_IRRAD" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"INSTR to SMPL_IRRAD" Foreign Keys 
Parent Key  Child Key 
INSTR_ID  INSTR_ID 

"INSTR to SMPL_IRRAD" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"INSTR to SMPL_IRRAD" Bound Attachments 
Name  Current Value 


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

"SAMPLE to SMPL_IRRAD" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"SAMPLE to SMPL_IRRAD" Foreign Keys 
Parent Key  Child Key 
SMPL_ID  SMPL_ID 

"SAMPLE to SMPL_IRRAD" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"SAMPLE to SMPL_IRRAD" Bound Attachments 
Name  Current Value 


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

"TIME_UOM to SMPL_IRRAD" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"TIME_UOM to SMPL_IRRAD" Foreign Keys 
Parent Key  Child Key 
TIME_UNIT_ID  TIME_UNIT_ID 

"TIME_UOM to SMPL_IRRAD" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"TIME_UOM to SMPL_IRRAD" Bound Attachments 
Name  Current Value 


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

"SAMPLE to SMPL_LOG" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"SAMPLE to SMPL_LOG" Foreign Keys 
Parent Key  Child Key 
SMPL_ID  SMPL_ID 

"SAMPLE to SMPL_LOG" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"SAMPLE to SMPL_LOG" Bound Attachments 
Name  Current Value 


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

"SMPL_ACT to SMPL_LOG" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"SMPL_ACT to SMPL_LOG" Foreign Keys 
Parent Key  Child Key 
ACT_ID  ACT_ID 

"SMPL_ACT to SMPL_LOG" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"SMPL_ACT to SMPL_LOG" Bound Attachments 
Name  Current Value 


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

"PROPOSAL to SMPL_PRPSL_ASSC" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"PROPOSAL to SMPL_PRPSL_ASSC" Foreign Keys 
Parent Key  Child Key 
PRPSL_ID  PRPSL_ID 

"PROPOSAL to SMPL_PRPSL_ASSC" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"PROPOSAL to SMPL_PRPSL_ASSC" Bound Attachments 
Name  Current Value 


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

"SAMPLE to SMPL_PRPSL_ASSC" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"SAMPLE to SMPL_PRPSL_ASSC" Foreign Keys 
Parent Key  Child Key 
SMPL_ID  SMPL_ID 

"SAMPLE to SMPL_PRPSL_ASSC" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"SAMPLE to SMPL_PRPSL_ASSC" Bound Attachments 
Name  Current Value 


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

"RADIONUC to SMPL_RADIONUC_ASSC" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"RADIONUC to SMPL_RADIONUC_ASSC" Foreign Keys 
Parent Key  Child Key 
SYM_ID  SYM_ID 

"RADIONUC to SMPL_RADIONUC_ASSC" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"RADIONUC to SMPL_RADIONUC_ASSC" Bound Attachments 
Name  Current Value 


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

"SAMPLE to SMPL_RADIONUC_ASSC" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"SAMPLE to SMPL_RADIONUC_ASSC" Foreign Keys 
Parent Key  Child Key 
SMPL_ID  SMPL_ID 

"SAMPLE to SMPL_RADIONUC_ASSC" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"SAMPLE to SMPL_RADIONUC_ASSC" Bound Attachments 
Name  Current Value 


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

"EMPLOYEE to SMPL_ROLE_EMP_ASSC" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"EMPLOYEE to SMPL_ROLE_EMP_ASSC" Foreign Keys 
Parent Key  Child Key 
BN  BN 

"EMPLOYEE to SMPL_ROLE_EMP_ASSC" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"EMPLOYEE to SMPL_ROLE_EMP_ASSC" Bound Attachments 
Name  Current Value 


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

"SMPL_ROLE to SMPL_ROLE_TMPL" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"SMPL_ROLE to SMPL_ROLE_TMPL" Foreign Keys 
Parent Key  Child Key 
ROLE_ID  ROLE_ID 

"SMPL_ROLE to SMPL_ROLE_TMPL" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"SMPL_ROLE to SMPL_ROLE_TMPL" Bound Attachments 
Name  Current Value 


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

"SMPL_ROLE_GRP to SMPL_ROLE_TMPL" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"SMPL_ROLE_GRP to SMPL_ROLE_TMPL" Foreign Keys 
Parent Key  Child Key 
SMPL_ROLE_GRP_ID  SMPL_ROLE_GRP_ID 

"SMPL_ROLE_GRP to SMPL_ROLE_TMPL" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"SMPL_ROLE_GRP to SMPL_ROLE_TMPL" Bound Attachments 
Name  Current Value 


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

"SAMPLE to SMPL_SMPL_SHIP_ASSC" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"SAMPLE to SMPL_SMPL_SHIP_ASSC" Foreign Keys 
Parent Key  Child Key 
SMPL_ID  SMPL_ID 

"SAMPLE to SMPL_SMPL_SHIP_ASSC" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"SAMPLE to SMPL_SMPL_SHIP_ASSC" Bound Attachments 
Name  Current Value 


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

"SMPL_SHIP to SMPL_SMPL_SHIP_ASSC" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"SMPL_SHIP to SMPL_SMPL_SHIP_ASSC" Foreign Keys 
Parent Key  Child Key 
SMPL_SHIP_ID  SMPL_SHIP_ID 

"SMPL_SHIP to SMPL_SMPL_SHIP_ASSC" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"SMPL_SHIP to SMPL_SMPL_SHIP_ASSC" Bound Attachments 
Name  Current Value 


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

"SMPL_SHIP to SMPL_SHIP_ATTACH" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"SMPL_SHIP to SMPL_SHIP_ATTACH" Foreign Keys 
Parent Key  Child Key 
SMPL_SHIP_ID  SMPL_SHIP_ID 

"SMPL_SHIP to SMPL_SHIP_ATTACH" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"SMPL_SHIP to SMPL_SHIP_ATTACH" Bound Attachments 
Name  Current Value 


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

"EMPLOYEE to SMPL_SHIP" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"EMPLOYEE to SMPL_SHIP" Foreign Keys 
Parent Key  Child Key 
BN  MOD_BY_BN 

"EMPLOYEE to SMPL_SHIP" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"EMPLOYEE to SMPL_SHIP" Bound Attachments 
Name  Current Value 


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

"SHIP_FACIL to SMPL_SHIP" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"SHIP_FACIL to SMPL_SHIP" Foreign Keys 
Parent Key  Child Key 
SHIP_FACIL_ID  SHIP_FACIL_ID 

"SHIP_FACIL to SMPL_SHIP" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"SHIP_FACIL to SMPL_SHIP" Bound Attachments 
Name  Current Value 


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

"SMPL_SHIP_STAT to SMPL_SHIP" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"SMPL_SHIP_STAT to SMPL_SHIP" Foreign Keys 
Parent Key  Child Key 
STAT_ID  STAT_ID 

"SMPL_SHIP_STAT to SMPL_SHIP" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"SMPL_SHIP_STAT to SMPL_SHIP" Bound Attachments 
Name  Current Value 


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

"DOT_HAZ_MAT_CLASS to SAMPLE" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"DOT_HAZ_MAT_CLASS to SAMPLE" Foreign Keys 
Parent Key  Child Key 
DOT_CLASS_NBR, DOT_DIV_NBR  DOT_SUB_CLASS_NBR, DOT_SUB_HAZ_DIV_NBR 

"DOT_HAZ_MAT_CLASS to SAMPLE" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"DOT_HAZ_MAT_CLASS to SAMPLE" Bound Attachments 
Name  Current Value 


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

"CTRL_AREA_SUBAREA1 to SAMPLE" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"CTRL_AREA_SUBAREA1 to SAMPLE" Foreign Keys 
Parent Key  Child Key 
CTRL_AREA_ID, SUBAREA_ID, SUBAREA1_ID  CTRL_AREA_ID, SUBAREA_ID, SUBAREA1_ID 

"CTRL_AREA_SUBAREA1 to SAMPLE" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"CTRL_AREA_SUBAREA1 to SAMPLE" Bound Attachments 
Name  Current Value 


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

"CTRL_AREA_SUBAREA2 to SAMPLE" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"CTRL_AREA_SUBAREA2 to SAMPLE" Foreign Keys 
Parent Key  Child Key 
CTRL_AREA_ID, SUBAREA_ID, SUBAREA1_ID, SUBAREA2_ID  CTRL_AREA_ID, SUBAREA_ID, SUBAREA1_ID, SUBAREA2_ID 

"CTRL_AREA_SUBAREA2 to SAMPLE" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"CTRL_AREA_SUBAREA2 to SAMPLE" Bound Attachments 
Name  Current Value 


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

"DOT_PKG_GRP to SAMPLE" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"DOT_PKG_GRP to SAMPLE" Foreign Keys 
Parent Key  Child Key 
PKG_GRP_ID  PKG_GRP_ID 

"DOT_PKG_GRP to SAMPLE" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"DOT_PKG_GRP to SAMPLE" Bound Attachments 
Name  Current Value 


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

"SMPL_CAN to SAMPLE" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"SMPL_CAN to SAMPLE" Foreign Keys 
Parent Key  Child Key 
CAN_ID, CONT_ID  CAN_ID, CONT_ID 

"SMPL_CAN to SAMPLE" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"SMPL_CAN to SAMPLE" Bound Attachments 
Name  Current Value 


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

"SMPL_SPEC_REQ to SAMPLE" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"SMPL_SPEC_REQ to SAMPLE" Foreign Keys 
Parent Key  Child Key 
REQ_ID  REQ_ID 

"SMPL_SPEC_REQ to SAMPLE" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"SMPL_SPEC_REQ to SAMPLE" Bound Attachments 
Name  Current Value 


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

"UNIT_LEN to SAMPLE" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"UNIT_LEN to SAMPLE" Foreign Keys 
Parent Key  Child Key 
LEN_UNIT_ID  LEN_UNIT_ID 

"UNIT_LEN to SAMPLE" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"UNIT_LEN to SAMPLE" Bound Attachments 
Name  Current Value 


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

"CTRL_AREA_SUBAREA to SMPL_TRANS" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"CTRL_AREA_SUBAREA to SMPL_TRANS" Foreign Keys 
Parent Key  Child Key 
CTRL_AREA_ID, SUBAREA_ID  CTRL_AREA_ID, SUBAREA_ID 

"CTRL_AREA_SUBAREA to SMPL_TRANS" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"CTRL_AREA_SUBAREA to SMPL_TRANS" Bound Attachments 
Name  Current Value 


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

"CTRL_AREA to SMPL_TRANS" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"CTRL_AREA to SMPL_TRANS" Foreign Keys 
Parent Key  Child Key 
CTRL_AREA_ID  CTRL_AREA_ID 

"CTRL_AREA to SMPL_TRANS" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"CTRL_AREA to SMPL_TRANS" Bound Attachments 
Name  Current Value 


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

"SAMPLE to SMPL_TRANS" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"SAMPLE to SMPL_TRANS" Foreign Keys 
Parent Key  Child Key 
SMPL_ID  SMPL_ID 

"SAMPLE to SMPL_TRANS" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"SAMPLE to SMPL_TRANS" Bound Attachments 
Name  Current Value 


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

"CTRL_AREA to SMPL_TRANS" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"CTRL_AREA to SMPL_TRANS" Foreign Keys 
Parent Key  Child Key 
CTRL_AREA_ID  TO_CTRL_AREA_ID 

"CTRL_AREA to SMPL_TRANS" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"CTRL_AREA to SMPL_TRANS" Bound Attachments 
Name  Current Value 


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

"SMPL_ROLE to SMPL_ROLE_EMP_ASSC" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"SMPL_ROLE to SMPL_ROLE_EMP_ASSC" Foreign Keys 
Parent Key  Child Key 
ROLE_ID  ROLE_ID 

"SMPL_ROLE to SMPL_ROLE_EMP_ASSC" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"SMPL_ROLE to SMPL_ROLE_EMP_ASSC" Bound Attachments 
Name  Current Value 


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

"CTRL_AREA to SMPL_ROLE_EMP_CTRL_AREA_ASSC" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"CTRL_AREA to SMPL_ROLE_EMP_CTRL_AREA_ASSC" Foreign Keys 
Parent Key  Child Key 
CTRL_AREA_ID  CTRL_AREA_ID 

"CTRL_AREA to SMPL_ROLE_EMP_CTRL_AREA_ASSC" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"CTRL_AREA to SMPL_ROLE_EMP_CTRL_AREA_ASSC" Bound Attachments 
Name  Current Value 


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

"SMPL_ROLE_EMP_ASSC to SMPL_ROLE_EMP_CTRL_AREA_ASSC" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"SMPL_ROLE_EMP_ASSC to SMPL_ROLE_EMP_CTRL_AREA_ASSC" Foreign Keys 
Parent Key  Child Key 
ROLE_ID, BN  ROLE_ID, BN 

"SMPL_ROLE_EMP_ASSC to SMPL_ROLE_EMP_CTRL_AREA_ASSC" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"SMPL_ROLE_EMP_ASSC to SMPL_ROLE_EMP_CTRL_AREA_ASSC" Bound Attachments 
Name  Current Value 


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

"SAMPLE to SAMPLE_SMPL_ATTACH_ASSC" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"SAMPLE to SAMPLE_SMPL_ATTACH_ASSC" Foreign Keys 
Parent Key  Child Key 
SMPL_ID  SMPL_ID 

"SAMPLE to SAMPLE_SMPL_ATTACH_ASSC" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"SAMPLE to SAMPLE_SMPL_ATTACH_ASSC" Bound Attachments 
Name  Current Value 


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

"SAMPLE to SMPL_SMPL_FORM_ASSC" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"SAMPLE to SMPL_SMPL_FORM_ASSC" Foreign Keys 
Parent Key  Child Key 
SMPL_ID  SMPL_ID 

"SAMPLE to SMPL_SMPL_FORM_ASSC" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"SAMPLE to SMPL_SMPL_FORM_ASSC" Bound Attachments 
Name  Current Value 


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

"SMPL_FORM to SMPL_SMPL_FORM_ASSC" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"SMPL_FORM to SMPL_SMPL_FORM_ASSC" Foreign Keys 
Parent Key  Child Key 
SMPL_FORM_ID  SMPL_FORM_ID 

"SMPL_FORM to SMPL_SMPL_FORM_ASSC" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"SMPL_FORM to SMPL_SMPL_FORM_ASSC" Bound Attachments 
Name  Current Value 


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

"SAMPLE to SMPL_SPEC_REQ_ASSC" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"SAMPLE to SMPL_SPEC_REQ_ASSC" Foreign Keys 
Parent Key  Child Key 
SMPL_ID  SMPL_ID 

"SAMPLE to SMPL_SPEC_REQ_ASSC" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"SAMPLE to SMPL_SPEC_REQ_ASSC" Bound Attachments 
Name  Current Value 


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

"SMPL_SPEC_REQ to SMPL_SPEC_REQ_ASSC" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"SMPL_SPEC_REQ to SMPL_SPEC_REQ_ASSC" Foreign Keys 
Parent Key  Child Key 
REQ_ID  REQ_ID 

"SMPL_SPEC_REQ to SMPL_SPEC_REQ_ASSC" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"SMPL_SPEC_REQ to SMPL_SPEC_REQ_ASSC" Bound Attachments 
Name  Current Value 


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

"SMPL_ATTACH to SMPL_SHIP_SMPL_ATTCH_ASSC" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"SMPL_ATTACH to SMPL_SHIP_SMPL_ATTCH_ASSC" Foreign Keys 
Parent Key  Child Key 
ATTACH_ID  ATTACH_ID 

"SMPL_ATTACH to SMPL_SHIP_SMPL_ATTCH_ASSC" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"SMPL_ATTACH to SMPL_SHIP_SMPL_ATTCH_ASSC" Bound Attachments 
Name  Current Value 


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

"SMPL_SHIP to SMPL_SHIP_SMPL_ATTCH_ASSC" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"SMPL_SHIP to SMPL_SHIP_SMPL_ATTCH_ASSC" Foreign Keys 
Parent Key  Child Key 
SMPL_SHIP_ID  SMPL_SHIP_ID 

"SMPL_SHIP to SMPL_SHIP_SMPL_ATTCH_ASSC" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"SMPL_SHIP to SMPL_SHIP_SMPL_ATTCH_ASSC" Bound Attachments 
Name  Current Value 


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

"CTRL_AREA_SUBAREA to SMPL_TRANS" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"CTRL_AREA_SUBAREA to SMPL_TRANS" Foreign Keys 
Parent Key  Child Key 
CTRL_AREA_ID, SUBAREA_ID  CTRL_AREA_ID, TO_SUBAREA_ID 

"CTRL_AREA_SUBAREA to SMPL_TRANS" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"CTRL_AREA_SUBAREA to SMPL_TRANS" Bound Attachments 
Name  Current Value 


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

"EMPLOYEE to USER_PROFILE" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"EMPLOYEE to USER_PROFILE" Foreign Keys 
Parent Key  Child Key 
BN  BN 

"EMPLOYEE to USER_PROFILE" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"EMPLOYEE to USER_PROFILE" Bound Attachments 
Name  Current Value 


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

"EMPLOYEE to USER_PROFILE" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"EMPLOYEE to USER_PROFILE" Foreign Keys 
Parent Key  Child Key 
BN  BN 

"EMPLOYEE to USER_PROFILE" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"EMPLOYEE to USER_PROFILE" Bound Attachments 
Name  Current Value