"OPER.Shift to Shift Summary" 
RelationshipType  Identifying 
Do Not Generate  False 
Relationship Name   
Relationship Business Name   
Logical Only  No 
Parent Entity  OPER.Shift 
Child Entity  Shift Summary 
Cardinality  One To Zero or More 
Existence  Mandatory 
Propagated Key  Primary Key 

"OPER.Shift to Shift Summary" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"OPER.Shift to Shift Summary" Foreign Keys 
Parent Key  Child Key 
Shift Identifier  Shift Identifier 

"OPER.Shift to Shift Summary" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"OPER.Shift to Shift Summary" Bound Attachments 
Name  Current Value 


"Operation Procedure Manual to Operation Procedure Manual Revision" 
RelationshipType  Identifying 
Do Not Generate  False 
Relationship Name   
Relationship Business Name   
Logical Only  No 
Parent Entity  Operation Procedure Manual 
Child Entity  Operation Procedure Manual Revision 
Cardinality  One To Zero or More 
Existence  Mandatory 
Propagated Key  Primary Key 

"Operation Procedure Manual to Operation Procedure Manual Revision" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"Operation Procedure Manual to Operation Procedure Manual Revision" Foreign Keys 
Parent Key  Child Key 
Operation Procedure Manual Identifier  Operation Procedure Manual Identifier 

"Operation Procedure Manual to Operation Procedure Manual Revision" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"Operation Procedure Manual to Operation Procedure Manual Revision" Bound Attachments 
Name  Current Value 


"Operation Subgroup1 to Beam Downtime Accounting" 
RelationshipType  Identifying 
Do Not Generate  False 
Relationship Name   
Relationship Business Name   
Logical Only  No 
Parent Entity  Operation Subgroup1 
Child Entity  Beam Downtime Accounting 
Cardinality  One To Zero or More 
Existence  Mandatory 
Propagated Key  Primary Key 

"Operation Subgroup1 to Beam Downtime Accounting" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"Operation Subgroup1 to Beam Downtime Accounting" Foreign Keys 
Parent Key  Child Key 
Operation Group Identifier, Operation Subgroup1 Identifier  Operation Group Identifier, Operation Subgroup1 Identifier 

"Operation Subgroup1 to Beam Downtime Accounting" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"Operation Subgroup1 to Beam Downtime Accounting" Bound Attachments 
Name  Current Value 


"Beam Accounting Delivery Type to Beam Accounting Actual Delivery" 
RelationshipType  Identifying 
Do Not Generate  False 
Relationship Name  BEAM_ACCT_RPT_ACT_DELIV_FK2 
Relationship Business Name   
Logical Only  No 
Parent Entity  Beam Accounting Delivery Type 
Child Entity  Beam Accounting Actual Delivery 
Cardinality  One To Zero or More 
Existence  Mandatory 
Propagated Key  Primary Key 

"Beam Accounting Delivery Type to Beam Accounting Actual Delivery" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"Beam Accounting Delivery Type to Beam Accounting Actual Delivery" Foreign Keys 
Parent Key  Child Key 
Delivery Type  Delivery Type 

"Beam Accounting Delivery Type to Beam Accounting Actual Delivery" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"Beam Accounting Delivery Type to Beam Accounting Actual Delivery" Bound Attachments 
Name  Current Value 


"Beam Accounting Requested Type to Beam Accounting Activity Request" 
RelationshipType  Identifying 
Do Not Generate  False 
Relationship Name  BEAM_ACCT_RPT_ACT_REQ_FK2 
Relationship Business Name   
Logical Only  No 
Parent Entity  Beam Accounting Requested Type 
Child Entity  Beam Accounting Activity Request 
Cardinality  One To Zero or More 
Existence  Mandatory 
Propagated Key  Primary Key 

"Beam Accounting Requested Type to Beam Accounting Activity Request" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"Beam Accounting Requested Type to Beam Accounting Activity Request" Foreign Keys 
Parent Key  Child Key 
Request Type  Request Type 

"Beam Accounting Requested Type to Beam Accounting Activity Request" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"Beam Accounting Requested Type to Beam Accounting Activity Request" Bound Attachments 
Name  Current Value 


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

"Checklist to Checklist Step" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"Checklist to Checklist Step" Foreign Keys 
Parent Key  Child Key 
Chklst Id, Chklst Rev  Chklst Id, Chklst Rev 

"Checklist to Checklist Step" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"Checklist to Checklist Step" Bound Attachments 
Name  Current Value 


"Fiscal Year to Accelerator Run Schedule" 
RelationshipType  Non-Identifying 
Do Not Generate  False 
Relationship Name  fk_accel_run_sched_to_fy 
Relationship Business Name   
Logical Only  No 
Parent Entity  Fiscal Year 
Child Entity  Accelerator Run Schedule 
Cardinality  One To Zero or More 
Existence  Mandatory 
Propagated Key  Primary Key 

"Fiscal Year to Accelerator Run Schedule" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"Fiscal Year to Accelerator Run Schedule" Foreign Keys 
Parent Key  Child Key 
Fiscal Year Identifier  Fiscal Year Identifier 

"Fiscal Year to Accelerator Run Schedule" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"Fiscal Year to Accelerator Run Schedule" Bound Attachments 
Name  Current Value 


"Accelerator Run Schedule Activity to Accelerator Production Schedule" 
RelationshipType  Identifying 
Do Not Generate  False 
Relationship Name  fk_aps_to_accel_run_sched_act 
Relationship Business Name   
Logical Only  No 
Parent Entity  Accelerator Run Schedule Activity 
Child Entity  Accelerator Production Schedule 
Cardinality  One To Zero or More 
Existence  Mandatory 
Propagated Key  Primary Key 

"Accelerator Run Schedule Activity to Accelerator Production Schedule" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"Accelerator Run Schedule Activity to Accelerator Production Schedule" Foreign Keys 
Parent Key  Child Key 
Run Schedule Activity Identifier  Run Schedule Activity Identifier 

"Accelerator Run Schedule Activity to Accelerator Production Schedule" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"Accelerator Run Schedule Activity to Accelerator Production Schedule" Bound Attachments 
Name  Current Value 


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

"Run Schedule Status to Accelerator Run Schedule" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"Run Schedule Status to Accelerator Run Schedule" Foreign Keys 
Parent Key  Child Key 
Satus Identifier  Satus Identifier 

"Run Schedule Status to Accelerator Run Schedule" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"Run Schedule Status to Accelerator Run Schedule" Bound Attachments 
Name  Current Value 


"Beam Downtime Accounting to Downtime Timer Accounting Association" 
RelationshipType  Identifying 
Do Not Generate  False 
Relationship Name  fk_beam_dt_acct_to_dtaa 
Relationship Business Name   
Logical Only  No 
Parent Entity  Beam Downtime Accounting 
Child Entity  Downtime Timer Accounting Association 
Cardinality  One To Zero or More 
Existence  Mandatory 
Propagated Key  Primary Key 

"Beam Downtime Accounting to Downtime Timer Accounting Association" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"Beam Downtime Accounting to Downtime Timer Accounting Association" Foreign Keys 
Parent Key  Child Key 
Operation Group Identifier, Operation Subgroup1 Identifier, Downtime Dte  Operation Group Identifier, Operation Subgroup1 Identifier, Downtime Dte 

"Beam Downtime Accounting to Downtime Timer Accounting Association" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"Beam Downtime Accounting to Downtime Timer Accounting Association" Bound Attachments 
Name  Current Value 


"Delegation of Authority to Delegation Period" 
RelationshipType  Identifying 
Do Not Generate  False 
Relationship Name  fk_deleg_per_to_deleg_of_auth 
Relationship Business Name   
Logical Only  No 
Parent Entity  Delegation of Authority 
Child Entity  Delegation Period 
Cardinality  One To Zero or More 
Existence  Mandatory 
Propagated Key  Primary Key 

"Delegation of Authority to Delegation Period" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"Delegation of Authority to Delegation Period" Foreign Keys 
Parent Key  Child Key 
Badge Number  Badge Number 

"Delegation of Authority to Delegation Period" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"Delegation of Authority to Delegation Period" Bound Attachments 
Name  Current Value 


"Delegation of Authority to Delegation Proxy" 
RelationshipType  Identifying 
Do Not Generate  False 
Relationship Name  fk_deleg_proxy_to_doa 
Relationship Business Name   
Logical Only  No 
Parent Entity  Delegation of Authority 
Child Entity  Delegation Proxy 
Cardinality  One To Zero or More 
Existence  Mandatory 
Propagated Key  Primary Key 

"Delegation of Authority to Delegation Proxy" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"Delegation of Authority to Delegation Proxy" Foreign Keys 
Parent Key  Child Key 
Badge Number  Badge Number 

"Delegation of Authority to Delegation Proxy" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"Delegation of Authority to Delegation Proxy" Bound Attachments 
Name  Current Value 


"OPER.Employee to Delegation Proxy" 
RelationshipType  Identifying 
Do Not Generate  False 
Relationship Name  fk_deleg_proxy_to_employee 
Relationship Business Name   
Logical Only  No 
Parent Entity  OPER.Employee 
Child Entity  Delegation Proxy 
Cardinality  One To Zero or More 
Existence  Mandatory 
Propagated Key  Primary Key 

"OPER.Employee to Delegation Proxy" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"OPER.Employee to Delegation Proxy" Foreign Keys 
Parent Key  Child Key 
Badge Number  Proxy Badge Number 

"OPER.Employee to Delegation Proxy" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"OPER.Employee to Delegation Proxy" Bound Attachments 
Name  Current Value 


"Delegation Period to Delegate" 
RelationshipType  Identifying 
Do Not Generate  False 
Relationship Name  fk_deleg_to_deleg_per 
Relationship Business Name   
Logical Only  No 
Parent Entity  Delegation Period 
Child Entity  Delegate 
Cardinality  One To Zero or More 
Existence  Mandatory 
Propagated Key  Primary Key 

"Delegation Period to Delegate" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"Delegation Period to Delegate" Foreign Keys 
Parent Key  Child Key 
Badge Number, Start Date  Badge Number, Start Date 

"Delegation Period to Delegate" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"Delegation Period to Delegate" Bound Attachments 
Name  Current Value 


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

"OPER.Employee to Delegate" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"OPER.Employee to Delegate" Foreign Keys 
Parent Key  Child Key 
Badge Number  Delegate Badge Number 

"OPER.Employee to Delegate" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"OPER.Employee to Delegate" Bound Attachments 
Name  Current Value 


"OPER.Employee to Delegation of Authority" 
RelationshipType  Identifying 
Do Not Generate  False 
Relationship Name  fk_doa_to_employee 
Relationship Business Name   
Logical Only  No 
Parent Entity  OPER.Employee 
Child Entity  Delegation of Authority 
Cardinality  One To Zero or More 
Existence  Mandatory 
Propagated Key  Primary Key 

"OPER.Employee to Delegation of Authority" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"OPER.Employee to Delegation of Authority" Foreign Keys 
Parent Key  Child Key 
Badge Number  Badge Number 

"OPER.Employee to Delegation of Authority" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"OPER.Employee to Delegation of Authority" Bound Attachments 
Name  Current Value 


"Delegation of Authority to Delegation of Authority Notification" 
RelationshipType  Identifying 
Do Not Generate  False 
Relationship Name  fk_doan_to_deleg_of_auth 
Relationship Business Name   
Logical Only  No 
Parent Entity  Delegation of Authority 
Child Entity  Delegation of Authority Notification 
Cardinality  One To Zero or More 
Existence  Mandatory 
Propagated Key  Primary Key 

"Delegation of Authority to Delegation of Authority Notification" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"Delegation of Authority to Delegation of Authority Notification" Foreign Keys 
Parent Key  Child Key 
Badge Number  Badge Number 

"Delegation of Authority to Delegation of Authority Notification" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"Delegation of Authority to Delegation of Authority Notification" Bound Attachments 
Name  Current Value 


"OPER.Employee to Delegation of Authority Notification" 
RelationshipType  Identifying 
Do Not Generate  False 
Relationship Name  fk_doan_to_employee 
Relationship Business Name   
Logical Only  No 
Parent Entity  OPER.Employee 
Child Entity  Delegation of Authority Notification 
Cardinality  One To Zero or More 
Existence  Mandatory 
Propagated Key  Primary Key 

"OPER.Employee to Delegation of Authority Notification" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"OPER.Employee to Delegation of Authority Notification" Foreign Keys 
Parent Key  Child Key 
Badge Number  Notification Badge Number 

"OPER.Employee to Delegation of Authority Notification" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"OPER.Employee to Delegation of Authority Notification" Bound Attachments 
Name  Current Value 


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

"Downtime Event to Downtime Timer" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"Downtime Event to Downtime Timer" Foreign Keys 
Parent Key  Child Key 
Downtime Event Identifier  Downtime Event Identifier 

"Downtime Event to Downtime Timer" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"Downtime Event to Downtime Timer" Bound Attachments 
Name  Current Value 


"Downtime Timer to Downtime Timer Accounting Association" 
RelationshipType  Identifying 
Do Not Generate  False 
Relationship Name  fk_dtaa_to_downtime_timer 
Relationship Business Name   
Logical Only  No 
Parent Entity  Downtime Timer 
Child Entity  Downtime Timer Accounting Association 
Cardinality  One To Zero or More 
Existence  Mandatory 
Propagated Key  Primary Key 

"Downtime Timer to Downtime Timer Accounting Association" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"Downtime Timer to Downtime Timer Accounting Association" Foreign Keys 
Parent Key  Child Key 
Sequence Identifer  Sequence Identifer 

"Downtime Timer to Downtime Timer Accounting Association" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"Downtime Timer to Downtime Timer Accounting Association" Bound Attachments 
Name  Current Value 


"Downtime Timer to Downtime Timer Event Assocation" 
RelationshipType  Identifying 
Do Not Generate  False 
Relationship Name  fk_dtea_to_downtime_timer 
Relationship Business Name   
Logical Only  No 
Parent Entity  Downtime Timer 
Child Entity  Downtime Timer Event Assocation 
Cardinality  One To Zero or More 
Existence  Mandatory 
Propagated Key  Primary Key 

"Downtime Timer to Downtime Timer Event Assocation" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"Downtime Timer to Downtime Timer Event Assocation" Foreign Keys 
Parent Key  Child Key 
Sequence Identifer  Sequence Identifer 

"Downtime Timer to Downtime Timer Event Assocation" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"Downtime Timer to Downtime Timer Event Assocation" Bound Attachments 
Name  Current Value 


"Downtime Timer Event to Downtime Timer Event Assocation" 
RelationshipType  Identifying 
Do Not Generate  False 
Relationship Name  fk_dtea_to_dt_timer_evt 
Relationship Business Name   
Logical Only  No 
Parent Entity  Downtime Timer Event 
Child Entity  Downtime Timer Event Assocation 
Cardinality  One To Zero or More 
Existence  Mandatory 
Propagated Key  Primary Key 

"Downtime Timer Event to Downtime Timer Event Assocation" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"Downtime Timer Event to Downtime Timer Event Assocation" Foreign Keys 
Parent Key  Child Key 
Downtime Timer Event Identifier  Downtime Timer Event Identifier 

"Downtime Timer Event to Downtime Timer Event Assocation" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"Downtime Timer Event to Downtime Timer Event Assocation" Bound Attachments 
Name  Current Value 


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

"Holiday to Holiday Schedule" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"Holiday to Holiday Schedule" Foreign Keys 
Parent Key  Child Key 
Name  Name 

"Holiday to Holiday Schedule" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"Holiday to Holiday Schedule" Bound Attachments 
Name  Current Value 


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

"Message Channel Access to Message Channel" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"Message Channel Access to Message Channel" Foreign Keys 
Parent Key  Child Key 
ACCESS_ID  ACCESS_ID 

"Message Channel Access to Message Channel" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"Message Channel Access to Message Channel" Bound Attachments 
Name  Current Value 


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

"Message Channel to Message Channel Message" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"Message Channel to Message Channel Message" Foreign Keys 
Parent Key  Child Key 
MSG_CHAN_ID  MSG_CHAN_ID 

"Message Channel to Message Channel Message" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"Message Channel to Message Channel Message" Bound Attachments 
Name  Current Value 


"OPER.Operation Group to Operation Subgroup1" 
RelationshipType  Identifying 
Do Not Generate  False 
Relationship Name  fk_oper_subgrp1_oper_grp 
Relationship Business Name   
Logical Only  No 
Parent Entity  OPER.Operation Group 
Child Entity  Operation Subgroup1 
Cardinality  One To Zero or More 
Existence  Mandatory 
Propagated Key  Primary Key 

"OPER.Operation Group to Operation Subgroup1" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"OPER.Operation Group to Operation Subgroup1" Foreign Keys 
Parent Key  Child Key 
Operation Group Identifier  Operation Group Identifier 

"OPER.Operation Group to Operation Subgroup1" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"OPER.Operation Group to Operation Subgroup1" Bound Attachments 
Name  Current Value 


"Operation Subgroup1 to Operation Subgroup2" 
RelationshipType  Identifying 
Do Not Generate  False 
Relationship Name  fk_oper_subgrp2_oper_subgrp1 
Relationship Business Name   
Logical Only  No 
Parent Entity  Operation Subgroup1 
Child Entity  Operation Subgroup2 
Cardinality  One To Zero or More 
Existence  Mandatory 
Propagated Key  Primary Key 

"Operation Subgroup1 to Operation Subgroup2" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"Operation Subgroup1 to Operation Subgroup2" Foreign Keys 
Parent Key  Child Key 
Operation Group Identifier, Operation Subgroup1 Identifier  Operation Group Identifier, Operation Subgroup1 Identifier 

"Operation Subgroup1 to Operation Subgroup2" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"Operation Subgroup1 to Operation Subgroup2" Bound Attachments 
Name  Current Value 


"Operation Subgroup2 to Operation Subgroup3" 
RelationshipType  Identifying 
Do Not Generate  False 
Relationship Name  fk_oper_subgrp3_oper_subgrp2 
Relationship Business Name   
Logical Only  No 
Parent Entity  Operation Subgroup2 
Child Entity  Operation Subgroup3 
Cardinality  One To Zero or More 
Existence  Mandatory 
Propagated Key  Primary Key 

"Operation Subgroup2 to Operation Subgroup3" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"Operation Subgroup2 to Operation Subgroup3" Foreign Keys 
Parent Key  Child Key 
Operation Group Identifier, Operation Subgroup1 Identifier, Operation Subgroup2 Identifier  Operation Group Identifier, Operation Subgroup1 Identifier, Operation Subgroup2 Identifier 

"Operation Subgroup2 to Operation Subgroup3" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"Operation Subgroup2 to Operation Subgroup3" Bound Attachments 
Name  Current Value 


"Operation Subgroup3 to Operation Subgroup4" 
RelationshipType  Identifying 
Do Not Generate  False 
Relationship Name  fk_oper_subgrp3_oper_subgrp4 
Relationship Business Name   
Logical Only  No 
Parent Entity  Operation Subgroup3 
Child Entity  Operation Subgroup4 
Cardinality  One To Zero or More 
Existence  Mandatory 
Propagated Key  Primary Key 

"Operation Subgroup3 to Operation Subgroup4" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"Operation Subgroup3 to Operation Subgroup4" Foreign Keys 
Parent Key  Child Key 
Operation Group Identifier, Operation Subgroup1 Identifier, Operation Subgroup2 Identifier, Operation Subgroup3 Identifier  Operation Group Identifier, Operation Subgroup1 Identifier, Operation Subgroup2 Identifier, Operation Subgroup3 Identifier 

"Operation Subgroup3 to Operation Subgroup4" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"Operation Subgroup3 to Operation Subgroup4" Bound Attachments 
Name  Current Value 


"Operation Subgroup4 to Operation Subgroup5" 
RelationshipType  Identifying 
Do Not Generate  False 
Relationship Name  fk_oper_subgrp4_oper_subgrp5 
Relationship Business Name   
Logical Only  No 
Parent Entity  Operation Subgroup4 
Child Entity  Operation Subgroup5 
Cardinality  One To Zero or More 
Existence  Mandatory 
Propagated Key  Primary Key 

"Operation Subgroup4 to Operation Subgroup5" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"Operation Subgroup4 to Operation Subgroup5" Foreign Keys 
Parent Key  Child Key 
Operation Group Identifier, Operation Subgroup1 Identifier, Operation Subgroup2 Identifier, Operation Subgroup3 Identifier, Operation Subgroup4 Identifier  Operation Group Identifier, Operation Subgroup1 Identifier, Operation Subgroup2 Identifier, Operation Subgroup3 Identifier, Operation Subgroup4 Identifier 

"Operation Subgroup4 to Operation Subgroup5" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"Operation Subgroup4 to Operation Subgroup5" Bound Attachments 
Name  Current Value 


"OPER.Employee to OPM Author Association" 
RelationshipType  Identifying 
Do Not Generate  False 
Relationship Name  fk_opm_auth_assc_to_emp 
Relationship Business Name   
Logical Only  No 
Parent Entity  OPER.Employee 
Child Entity  OPM Author Association 
Cardinality  One To Zero or More 
Existence  Mandatory 
Propagated Key  Primary Key 

"OPER.Employee to OPM Author Association" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"OPER.Employee to OPM Author Association" Foreign Keys 
Parent Key  Child Key 
Badge Number  Badge Number 

"OPER.Employee to OPM Author Association" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"OPER.Employee to OPM Author Association" Bound Attachments 
Name  Current Value 


"Operation Procedure Manual Revision to OPM Author Association" 
RelationshipType  Identifying 
Do Not Generate  False 
Relationship Name  fk_opm_auth_assc_to_opm_rev 
Relationship Business Name   
Logical Only  No 
Parent Entity  Operation Procedure Manual Revision 
Child Entity  OPM Author Association 
Cardinality  One To Zero or More 
Existence  Mandatory 
Propagated Key  Primary Key 

"Operation Procedure Manual Revision to OPM Author Association" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"Operation Procedure Manual Revision to OPM Author Association" Foreign Keys 
Parent Key  Child Key 
Operation Procedure Manual Identifier, Revision Number  Operation Procedure Manual Identifier, Revision Number 

"Operation Procedure Manual Revision to OPM Author Association" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"Operation Procedure Manual Revision to OPM Author Association" Bound Attachments 
Name  Current Value 


"Operation Procedure Manual Revision to OPM Chapter" 
RelationshipType  Identifying 
Do Not Generate  False 
Relationship Name  fk_opm_chap_to_opm_rev 
Relationship Business Name   
Logical Only  No 
Parent Entity  Operation Procedure Manual Revision 
Child Entity  OPM Chapter 
Cardinality  One To Zero or More 
Existence  Mandatory 
Propagated Key  Primary Key 

"Operation Procedure Manual Revision to OPM Chapter" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"Operation Procedure Manual Revision to OPM Chapter" Foreign Keys 
Parent Key  Child Key 
Operation Procedure Manual Identifier, Revision Number  Operation Procedure Manual Identifier, Revision Number 

"Operation Procedure Manual Revision to OPM Chapter" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"Operation Procedure Manual Revision to OPM Chapter" Bound Attachments 
Name  Current Value 


"OPER.Operation Group to OPM Group" 
RelationshipType  Non-Identifying 
Do Not Generate  False 
Relationship Name  fk_opm_grp_to_oper_grp 
Relationship Business Name   
Logical Only  No 
Parent Entity  OPER.Operation Group 
Child Entity  OPM Group 
Cardinality  Zero or One to Zero or More 
Existence  Optional 
Propagated Key  Primary Key 

"OPER.Operation Group to OPM Group" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"OPER.Operation Group to OPM Group" Foreign Keys 
Parent Key  Child Key 
Operation Group Identifier  Operation Group Identifier 

"OPER.Operation Group to OPM Group" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"OPER.Operation Group to OPM Group" Bound Attachments 
Name  Current Value 


"Operation Subgroup1 to OPM Group" 
RelationshipType  Non-Identifying 
Do Not Generate  False 
Relationship Name  fk_opm_grp_to_oper_subgrp1 
Relationship Business Name   
Logical Only  No 
Parent Entity  Operation Subgroup1 
Child Entity  OPM Group 
Cardinality  Zero or One to Zero or More 
Existence  Optional 
Propagated Key  Primary Key 

"Operation Subgroup1 to OPM Group" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"Operation Subgroup1 to OPM Group" Foreign Keys 
Parent Key  Child Key 
Operation Group Identifier, Operation Subgroup1 Identifier  Operation Group Identifier, Operation Subgroup1 Identifier 

"Operation Subgroup1 to OPM Group" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"Operation Subgroup1 to OPM Group" Bound Attachments 
Name  Current Value 


"OPM Group to Operation Procedure Manual" 
RelationshipType  Non-Identifying 
Do Not Generate  False 
Relationship Name  fk_opm_grp_to_opm 
Relationship Business Name   
Logical Only  No 
Parent Entity  OPM Group 
Child Entity  Operation Procedure Manual 
Cardinality  One To Zero or More 
Existence  Mandatory 
Propagated Key  Primary Key 

"OPM Group to Operation Procedure Manual" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"OPM Group to Operation Procedure Manual" Foreign Keys 
Parent Key  Child Key 
Group Identifier  Group Identifier 

"OPM Group to Operation Procedure Manual" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"OPM Group to Operation Procedure Manual" Bound Attachments 
Name  Current Value 


"OPER.Employee to OPM Reviewer Association" 
RelationshipType  Identifying 
Do Not Generate  False 
Relationship Name  fk_opm_rev_assc_to_emp 
Relationship Business Name   
Logical Only  No 
Parent Entity  OPER.Employee 
Child Entity  OPM Reviewer Association 
Cardinality  One To Zero or More 
Existence  Mandatory 
Propagated Key  Primary Key 

"OPER.Employee to OPM Reviewer Association" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"OPER.Employee to OPM Reviewer Association" Foreign Keys 
Parent Key  Child Key 
Badge Number  Badge Number 

"OPER.Employee to OPM Reviewer Association" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"OPER.Employee to OPM Reviewer Association" Bound Attachments 
Name  Current Value 


"Operation Procedure Manual Revision to OPM Reviewer Association" 
RelationshipType  Identifying 
Do Not Generate  False 
Relationship Name  fk_opm_rev_assc_to_opm_rev 
Relationship Business Name   
Logical Only  No 
Parent Entity  Operation Procedure Manual Revision 
Child Entity  OPM Reviewer Association 
Cardinality  One To Zero or More 
Existence  Mandatory 
Propagated Key  Primary Key 

"Operation Procedure Manual Revision to OPM Reviewer Association" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"Operation Procedure Manual Revision to OPM Reviewer Association" Foreign Keys 
Parent Key  Child Key 
Operation Procedure Manual Identifier, Revision Number  Operation Procedure Manual Identifier, Revision Number 

"Operation Procedure Manual Revision to OPM Reviewer Association" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"Operation Procedure Manual Revision to OPM Reviewer Association" Bound Attachments 
Name  Current Value 


"OPM Review Status to Operation Procedure Manual Revision" 
RelationshipType  Non-Identifying 
Do Not Generate  False 
Relationship Name  fk_opm_to_opm_rev_stat 
Relationship Business Name   
Logical Only  No 
Parent Entity  OPM Review Status 
Child Entity  Operation Procedure Manual Revision 
Cardinality  One To Zero or More 
Existence  Mandatory 
Propagated Key  Primary Key 

"OPM Review Status to Operation Procedure Manual Revision" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"OPM Review Status to Operation Procedure Manual Revision" Foreign Keys 
Parent Key  Child Key 
Review Status Identifier  Review Status Identifier 

"OPM Review Status to Operation Procedure Manual Revision" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"OPM Review Status to Operation Procedure Manual Revision" Bound Attachments 
Name  Current Value 


"OPER.Employee to Organization Matrix" 
RelationshipType  Identifying 
Do Not Generate  False 
Relationship Name  fk_org_matrix_to_emp 
Relationship Business Name   
Logical Only  No 
Parent Entity  OPER.Employee 
Child Entity  Organization Matrix 
Cardinality  One To Zero or More 
Existence  Mandatory 
Propagated Key  Primary Key 

"OPER.Employee to Organization Matrix" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"OPER.Employee to Organization Matrix" Foreign Keys 
Parent Key  Child Key 
Badge Number  Badge Number 

"OPER.Employee to Organization Matrix" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"OPER.Employee to Organization Matrix" Bound Attachments 
Name  Current Value 


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

"Operation Activity to Operation State" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"Operation Activity to Operation State" Foreign Keys 
Parent Key  Child Key 
Activity Identifier  Activity Identifier 

"Operation Activity to Operation State" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"Operation Activity to Operation State" Bound Attachments 
Name  Current Value 


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

"Operation Status to Operation State" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"Operation Status to Operation State" Foreign Keys 
Parent Key  Child Key 
Operation Status Identifer  Operation Status Identifer 

"Operation Status to Operation State" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"Operation Status to Operation State" Bound Attachments 
Name  Current Value 


"Delegation of Authority to Person Location" 
RelationshipType  Identifying 
Do Not Generate  False 
Relationship Name  fk_pers_loc_to_del_auth 
Relationship Business Name   
Logical Only  No 
Parent Entity  Delegation of Authority 
Child Entity  Person Location 
Cardinality  One To Zero or More 
Existence  Mandatory 
Propagated Key  Primary Key 

"Delegation of Authority to Person Location" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"Delegation of Authority to Person Location" Foreign Keys 
Parent Key  Child Key 
Badge Number  Badge Number 

"Delegation of Authority to Person Location" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"Delegation of Authority to Person Location" Bound Attachments 
Name  Current Value 


"Job Title to Personnel Role" 
RelationshipType  Non-Identifying 
Do Not Generate  False 
Relationship Name  fk_pers_role_to_job_title 
Relationship Business Name   
Logical Only  No 
Parent Entity  Job Title 
Child Entity  Personnel Role 
Cardinality  Zero or One to Zero or More 
Existence  Optional 
Propagated Key  Primary Key 

"Job Title to Personnel Role" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"Job Title to Personnel Role" Foreign Keys 
Parent Key  Child Key 
Job Title Identifier  Job Title Identifier 

"Job Title to Personnel Role" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"Job Title to Personnel Role" Bound Attachments 
Name  Current Value 


"Research Acclerator Division Area to Research Acclerator Division Area Role Assignment" 
RelationshipType  Identifying 
Do Not Generate  False 
Relationship Name  fk_rad_asgn_area 
Relationship Business Name   
Logical Only  No 
Parent Entity  Research Acclerator Division Area 
Child Entity  Research Acclerator Division Area Role Assignment 
Cardinality  One To Zero or More 
Existence  Mandatory 
Propagated Key  Primary Key 

"Research Acclerator Division Area to Research Acclerator Division Area Role Assignment" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"Research Acclerator Division Area to Research Acclerator Division Area Role Assignment" Foreign Keys 
Parent Key  Child Key 
Area Identifier  Area Identifier 

"Research Acclerator Division Area to Research Acclerator Division Area Role Assignment" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"Research Acclerator Division Area to Research Acclerator Division Area Role Assignment" Bound Attachments 
Name  Current Value 


"OPER.Employee to Research Acclerator Division Area Role Assignment" 
RelationshipType  Identifying 
Do Not Generate  False 
Relationship Name  fk_rad_asgn_emp 
Relationship Business Name   
Logical Only  No 
Parent Entity  OPER.Employee 
Child Entity  Research Acclerator Division Area Role Assignment 
Cardinality  One To Zero or More 
Existence  Mandatory 
Propagated Key  Primary Key 

"OPER.Employee to Research Acclerator Division Area Role Assignment" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"OPER.Employee to Research Acclerator Division Area Role Assignment" Foreign Keys 
Parent Key  Child Key 
Badge Number  Badge Number 

"OPER.Employee to Research Acclerator Division Area Role Assignment" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"OPER.Employee to Research Acclerator Division Area Role Assignment" Bound Attachments 
Name  Current Value 


"Research Acclerator Division Area Role to Research Acclerator Division Area Role Assignment" 
RelationshipType  Identifying 
Do Not Generate  False 
Relationship Name  fk_rad_asgn_role 
Relationship Business Name   
Logical Only  No 
Parent Entity  Research Acclerator Division Area Role 
Child Entity  Research Acclerator Division Area Role Assignment 
Cardinality  One To Zero or More 
Existence  Mandatory 
Propagated Key  Primary Key 

"Research Acclerator Division Area Role to Research Acclerator Division Area Role Assignment" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"Research Acclerator Division Area Role to Research Acclerator Division Area Role Assignment" Foreign Keys 
Parent Key  Child Key 
Role Identifier  Role Identifier 

"Research Acclerator Division Area Role to Research Acclerator Division Area Role Assignment" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"Research Acclerator Division Area Role to Research Acclerator Division Area Role Assignment" Bound Attachments 
Name  Current Value 


"Run Schedule Status to Reactor Fuel Cycle" 
RelationshipType  Non-Identifying 
Do Not Generate  False 
Relationship Name  fk_rfc_to_run_sched_stat 
Relationship Business Name   
Logical Only  No 
Parent Entity  Run Schedule Status 
Child Entity  Reactor Fuel Cycle 
Cardinality  One To Zero or More 
Existence  Mandatory 
Propagated Key  Primary Key 

"Run Schedule Status to Reactor Fuel Cycle" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"Run Schedule Status to Reactor Fuel Cycle" Foreign Keys 
Parent Key  Child Key 
Satus Identifier  Satus Identifier 

"Run Schedule Status to Reactor Fuel Cycle" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"Run Schedule Status to Reactor Fuel Cycle" Bound Attachments 
Name  Current Value 


"Reactor Fuel Cycle to Reactor Run Schedule" 
RelationshipType  Identifying 
Do Not Generate  False 
Relationship Name  fk_rrs_to_reac_fuel_cyc 
Relationship Business Name   
Logical Only  No 
Parent Entity  Reactor Fuel Cycle 
Child Entity  Reactor Run Schedule 
Cardinality  One To Zero or More 
Existence  Mandatory 
Propagated Key  Primary Key 

"Reactor Fuel Cycle to Reactor Run Schedule" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"Reactor Fuel Cycle to Reactor Run Schedule" Foreign Keys 
Parent Key  Child Key 
Fuel Cycle Identifier  Fuel Cycle Identifier 

"Reactor Fuel Cycle to Reactor Run Schedule" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"Reactor Fuel Cycle to Reactor Run Schedule" Bound Attachments 
Name  Current Value 


"Reactor Operation Activity to Reactor Run Schedule" 
RelationshipType  Identifying 
Do Not Generate  False 
Relationship Name  fk_rrs_to_reac_oper_act 
Relationship Business Name   
Logical Only  No 
Parent Entity  Reactor Operation Activity 
Child Entity  Reactor Run Schedule 
Cardinality  One To Zero or More 
Existence  Mandatory 
Propagated Key  Primary Key 

"Reactor Operation Activity to Reactor Run Schedule" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"Reactor Operation Activity to Reactor Run Schedule" Foreign Keys 
Parent Key  Child Key 
Activity Type Identifier  Activity Type Identifier 

"Reactor Operation Activity to Reactor Run Schedule" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"Reactor Operation Activity to Reactor Run Schedule" Bound Attachments 
Name  Current Value 


"OPER.Shift to Shift Holiday Schedule" 
RelationshipType  Identifying 
Do Not Generate  False 
Relationship Name  fk_shift_holi_sched_to_shift 
Relationship Business Name   
Logical Only  No 
Parent Entity  OPER.Shift 
Child Entity  Shift Holiday Schedule 
Cardinality  One To Zero or More 
Existence  Mandatory 
Propagated Key  Primary Key 

"OPER.Shift to Shift Holiday Schedule" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"OPER.Shift to Shift Holiday Schedule" Foreign Keys 
Parent Key  Child Key 
Shift Identifier  Shift Identifier 

"OPER.Shift to Shift Holiday Schedule" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"OPER.Shift to Shift Holiday Schedule" Bound Attachments 
Name  Current Value 


"OPER.Shift to Shift Scheduled Work Assignment" 
RelationshipType  Identifying 
Do Not Generate  False 
Relationship Name  fk_shift_pers_asgn_to_shift 
Relationship Business Name   
Logical Only  No 
Parent Entity  OPER.Shift 
Child Entity  Shift Scheduled Work Assignment 
Cardinality  One To Zero or More 
Existence  Mandatory 
Propagated Key  Primary Key 

"OPER.Shift to Shift Scheduled Work Assignment" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"OPER.Shift to Shift Scheduled Work Assignment" Foreign Keys 
Parent Key  Child Key 
Shift Identifier  Shift Identifier 

"OPER.Shift to Shift Scheduled Work Assignment" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"OPER.Shift to Shift Scheduled Work Assignment" Bound Attachments 
Name  Current Value 


"OPER.Shift to Shift Work Schedule" 
RelationshipType  Identifying 
Do Not Generate  False 
Relationship Name  fk_shift_work_sched_to_shift 
Relationship Business Name   
Logical Only  No 
Parent Entity  OPER.Shift 
Child Entity  Shift Work Schedule 
Cardinality  One To Zero or More 
Existence  Mandatory 
Propagated Key  Primary Key 

"OPER.Shift to Shift Work Schedule" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"OPER.Shift to Shift Work Schedule" Foreign Keys 
Parent Key  Child Key 
Shift Identifier  Shift Identifier 

"OPER.Shift to Shift Work Schedule" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"OPER.Shift to Shift Work Schedule" Bound Attachments 
Name  Current Value 


"OPER.Personnel Role to Shift Scheduled Work Assignment" 
RelationshipType  Identifying 
Do Not Generate  False 
Relationship Name  fk_spa_to_pers_role 
Relationship Business Name   
Logical Only  No 
Parent Entity  OPER.Personnel Role 
Child Entity  Shift Scheduled Work Assignment 
Cardinality  One To Zero or More 
Existence  Mandatory 
Propagated Key  Primary Key 

"OPER.Personnel Role to Shift Scheduled Work Assignment" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"OPER.Personnel Role to Shift Scheduled Work Assignment" Foreign Keys 
Parent Key  Child Key 
BN  BN 

"OPER.Personnel Role to Shift Scheduled Work Assignment" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"OPER.Personnel Role to Shift Scheduled Work Assignment" Bound Attachments 
Name  Current Value 


"Shift Work Schedule to Shift Scheduled Work Assignment" 
RelationshipType  Identifying 
Do Not Generate  False 
Relationship Name  fk_spa_to_shift_work_sched 
Relationship Business Name   
Logical Only  No 
Parent Entity  Shift Work Schedule 
Child Entity  Shift Scheduled Work Assignment 
Cardinality  One To Zero or More 
Existence  Mandatory 
Propagated Key  Primary Key 

"Shift Work Schedule to Shift Scheduled Work Assignment" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"Shift Work Schedule to Shift Scheduled Work Assignment" Foreign Keys 
Parent Key  Child Key 
Shift Identifier, Calendar Date  Shift Identifier, Calendar Date 

"Shift Work Schedule to Shift Scheduled Work Assignment" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"Shift Work Schedule to Shift Scheduled Work Assignment" Bound Attachments 
Name  Current Value 


"Shift Summary to Shift Summary File Attachment" 
RelationshipType  Identifying 
Do Not Generate  False 
Relationship Name  fk_ssfa_to_shift_summ 
Relationship Business Name   
Logical Only  No 
Parent Entity  Shift Summary 
Child Entity  Shift Summary File Attachment 
Cardinality  One To Zero or More 
Existence  Mandatory 
Propagated Key  Primary Key 

"Shift Summary to Shift Summary File Attachment" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"Shift Summary to Shift Summary File Attachment" Foreign Keys 
Parent Key  Child Key 
Shift Identifier, Calendar Date  Shift Identifier, Calendar Date 

"Shift Summary to Shift Summary File Attachment" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"Shift Summary to Shift Summary File Attachment" Bound Attachments 
Name  Current Value 


"Shift Summary to Shift Summary Process Variable Association" 
RelationshipType  Identifying 
Do Not Generate  False 
Relationship Name  fk_sspva_to_shift_summ 
Relationship Business Name   
Logical Only  No 
Parent Entity  Shift Summary 
Child Entity  Shift Summary Process Variable Association 
Cardinality  One To Zero or More 
Existence  Mandatory 
Propagated Key  Primary Key 

"Shift Summary to Shift Summary Process Variable Association" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"Shift Summary to Shift Summary Process Variable Association" Foreign Keys 
Parent Key  Child Key 
Shift Identifier, Calendar Date  Shift Identifier, Calendar Date 

"Shift Summary to Shift Summary Process Variable Association" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"Shift Summary to Shift Summary Process Variable Association" Bound Attachments 
Name  Current Value 


"Shift Summary Process Variable to Shift Summary Process Variable Association" 
RelationshipType  Identifying 
Do Not Generate  False 
Relationship Name  fk_sspva_to_shpv 
Relationship Business Name   
Logical Only  No 
Parent Entity  Shift Summary Process Variable 
Child Entity  Shift Summary Process Variable Association 
Cardinality  One To Zero or More 
Existence  Mandatory 
Propagated Key  Primary Key 

"Shift Summary Process Variable to Shift Summary Process Variable Association" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"Shift Summary Process Variable to Shift Summary Process Variable Association" Foreign Keys 
Parent Key  Child Key 
Sgnl Id  Sgnl Id 

"Shift Summary Process Variable to Shift Summary Process Variable Association" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"Shift Summary Process Variable to Shift Summary Process Variable Association" Bound Attachments 
Name  Current Value 


"Shift Activity to Shift Scheduled Work Assignment" 
RelationshipType  Non-Identifying 
Do Not Generate  False 
Relationship Name  fk_sswa_to_shift_act 
Relationship Business Name   
Logical Only  No 
Parent Entity  Shift Activity 
Child Entity  Shift Scheduled Work Assignment 
Cardinality  Zero or One to Zero or More 
Existence  Optional 
Propagated Key  Primary Key 

"Shift Activity to Shift Scheduled Work Assignment" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"Shift Activity to Shift Scheduled Work Assignment" Foreign Keys 
Parent Key  Child Key 
Shift Activity Identifier  Shift Activity Identifier 

"Shift Activity to Shift Scheduled Work Assignment" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"Shift Activity to Shift Scheduled Work Assignment" Bound Attachments 
Name  Current Value 


"OPER.Employee to Target Beam Parameters" 
RelationshipType  Non-Identifying 
Do Not Generate  False 
Relationship Name  fk_tgt_beam_parm_emp 
Relationship Business Name   
Logical Only  No 
Parent Entity  OPER.Employee 
Child Entity  Target Beam Parameters 
Cardinality  One To Zero or More 
Existence  Mandatory 
Propagated Key  Primary Key 

"OPER.Employee to Target Beam Parameters" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"OPER.Employee to Target Beam Parameters" Foreign Keys 
Parent Key  Child Key 
Badge Number  Badge Number 

"OPER.Employee to Target Beam Parameters" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"OPER.Employee to Target Beam Parameters" Bound Attachments 
Name  Current Value 


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

"Checklist to Operations Checklist" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"Checklist to Operations Checklist" Foreign Keys 
Parent Key  Child Key 
Chklst Id, Chklst Rev  Chklst Id, Chklst Rev 

"Checklist to Operations Checklist" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"Checklist to Operations Checklist" Bound Attachments 
Name  Current Value 


"Checklist Step to Operations Checklist Item" 
RelationshipType  Identifying 
Do Not Generate  False 
Relationship Name  opr_chklst_item_chklst_step_rf 
Relationship Business Name   
Logical Only  No 
Parent Entity  Checklist Step 
Child Entity  Operations Checklist Item 
Cardinality  One To Zero or More 
Existence  Mandatory 
Propagated Key  Primary Key 

"Checklist Step to Operations Checklist Item" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"Checklist Step to Operations Checklist Item" Foreign Keys 
Parent Key  Child Key 
Chklst Id, Chklst Rev, Step Nbr  Chklst Id, Chklst Rev, Step Nbr 

"Checklist Step to Operations Checklist Item" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"Checklist Step to Operations Checklist Item" Bound Attachments 
Name  Current Value 


"Operations Checklist to Operations Checklist Item" 
RelationshipType  Identifying 
Do Not Generate  False 
Relationship Name  opr_chklst_item_opr_chklst_rf 
Relationship Business Name   
Logical Only  No 
Parent Entity  Operations Checklist 
Child Entity  Operations Checklist Item 
Cardinality  One To Zero or More 
Existence  Mandatory 
Propagated Key  Primary Key 

"Operations Checklist to Operations Checklist Item" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"Operations Checklist to Operations Checklist Item" Foreign Keys 
Parent Key  Child Key 
Chklst Id, Chklst Rev, Chklst Dte  Chklst Id, Chklst Rev, Chklst Dte 

"Operations Checklist to Operations Checklist Item" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"Operations Checklist to Operations Checklist Item" Bound Attachments 
Name  Current Value