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

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

"NS_OPER.Shift to Instrument Shift Summary" Foreign Keys 
Parent Key  Child Key 
Shift Identifier  Shift Identifier 

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

"NS_OPER.Shift to Instrument Shift Summary" Bound Attachments 
Name  Current Value 


"XF_ADMIN.Instrument to Instrument Logbook Category Association" 
RelationshipType  Identifying 
Do Not Generate  False 
Relationship Name   
Relationship Business Name   
Logical Only  No 
Parent Entity  XF_ADMIN.Instrument 
Child Entity  Instrument Logbook Category Association 
Cardinality  One To Zero or More 
Existence  Mandatory 
Propagated Key  Primary Key 

"XF_ADMIN.Instrument to Instrument Logbook Category Association" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"XF_ADMIN.Instrument to Instrument Logbook Category Association" Foreign Keys 
Parent Key  Child Key 
Instrument Identifier  Instrument Identifier 

"XF_ADMIN.Instrument to Instrument Logbook Category Association" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"XF_ADMIN.Instrument to Instrument Logbook Category Association" Bound Attachments 
Name  Current Value 


"Log Category to Instrument Logbook Category Association" 
RelationshipType  Identifying 
Do Not Generate  False 
Relationship Name   
Relationship Business Name   
Logical Only  No 
Parent Entity  Log Category 
Child Entity  Instrument Logbook Category Association 
Cardinality  One To Zero or More 
Existence  Mandatory 
Propagated Key  Primary Key 

"Log Category to Instrument Logbook Category Association" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"Log Category to Instrument Logbook Category Association" Foreign Keys 
Parent Key  Child Key 
Cat Id  Cat Id 

"Log Category to Instrument Logbook Category Association" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"Log Category to Instrument Logbook Category Association" Bound Attachments 
Name  Current Value 


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

"NS_OPER.Personnel Role to Personnel Role Operation Group Assignment" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"NS_OPER.Personnel Role to Personnel Role Operation Group Assignment" Foreign Keys 
Parent Key  Child Key 
Badge Number  Badge Number 

"NS_OPER.Personnel Role to Personnel Role Operation Group Assignment" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"NS_OPER.Personnel Role to Personnel Role Operation Group Assignment" Bound Attachments 
Name  Current Value 


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

"NS_OPER.Operation Group to Personnel Role Operation Group Assignment" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"NS_OPER.Operation Group to Personnel Role Operation Group Assignment" Foreign Keys 
Parent Key  Child Key 
Operation Group Identifier  Operation Group Identifier 

"NS_OPER.Operation Group to Personnel Role Operation Group Assignment" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"NS_OPER.Operation Group to Personnel Role Operation Group Assignment" Bound Attachments 
Name  Current Value 


"Personnel Role Operation Group Assignment to Personnel Role Operation SubGroup Assignment" 
RelationshipType  Identifying 
Do Not Generate  False 
Relationship Name   
Relationship Business Name   
Logical Only  No 
Parent Entity  Personnel Role Operation Group Assignment 
Child Entity  Personnel Role Operation SubGroup Assignment 
Cardinality  One To Zero or More 
Existence  Mandatory 
Propagated Key  Primary Key 

"Personnel Role Operation Group Assignment to Personnel Role Operation SubGroup Assignment" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"Personnel Role Operation Group Assignment to Personnel Role Operation SubGroup Assignment" Foreign Keys 
Parent Key  Child Key 
Badge Number, Operation Group Identifier  Badge Number, Operation Group Identifier 

"Personnel Role Operation Group Assignment to Personnel Role Operation SubGroup Assignment" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"Personnel Role Operation Group Assignment to Personnel Role Operation SubGroup Assignment" Bound Attachments 
Name  Current Value 


"Operation Subgroup to Personnel Role Operation SubGroup Assignment" 
RelationshipType  Identifying 
Do Not Generate  False 
Relationship Name   
Relationship Business Name   
Logical Only  No 
Parent Entity  Operation Subgroup 
Child Entity  Personnel Role Operation SubGroup Assignment 
Cardinality  One To Zero or More 
Existence  Mandatory 
Propagated Key  Primary Key 

"Operation Subgroup to Personnel Role Operation SubGroup Assignment" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"Operation Subgroup to Personnel Role Operation SubGroup Assignment" Foreign Keys 
Parent Key  Child Key 
Operation Group Identifier, Operation Subgroup1 Identifier  Operation Group Identifier, Operation Subgroup1 Identifier 

"Operation Subgroup to Personnel Role Operation SubGroup Assignment" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"Operation Subgroup to Personnel Role Operation SubGroup Assignment" Bound Attachments 
Name  Current Value 


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

"XF_ADMIN.Instrument to Instrument Downtime Accounting" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"XF_ADMIN.Instrument to Instrument Downtime Accounting" Foreign Keys 
Parent Key  Child Key 
Instrument Identifier  Instrument Identifier 

"XF_ADMIN.Instrument to Instrument Downtime Accounting" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"XF_ADMIN.Instrument to Instrument Downtime Accounting" Bound Attachments 
Name  Current Value 


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

"Instrument Shift Summary to Instrument Downtime Accounting" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"Instrument Shift Summary to Instrument Downtime Accounting" Foreign Keys 
Parent Key  Child Key 
Shift Identifier, Facility Identifier, Calendar Date  Shift Identifier, Facility Identifier, Calendar Date 

"Instrument Shift Summary to Instrument Downtime Accounting" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"Instrument Shift Summary to Instrument Downtime Accounting" Bound Attachments 
Name  Current Value 


"XF_ADMIN.Instrument to Instrument Support Activity" 
RelationshipType  Non-Identifying 
Do Not Generate  False 
Relationship Name  fk_instr_sup_act_to_instr 
Relationship Business Name   
Logical Only  No 
Parent Entity  XF_ADMIN.Instrument 
Child Entity  Instrument Support Activity 
Cardinality  Zero or One to Zero or More 
Existence  Optional 
Propagated Key  Primary Key 

"XF_ADMIN.Instrument to Instrument Support Activity" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"XF_ADMIN.Instrument to Instrument Support Activity" Foreign Keys 
Parent Key  Child Key 
Instrument Identifier  Instrument Identifier 

"XF_ADMIN.Instrument to Instrument Support Activity" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"XF_ADMIN.Instrument to Instrument Support Activity" Bound Attachments 
Name  Current Value 


"Personnel Role Operation SubGroup Assignment to Instrument Support Activity" 
RelationshipType  Non-Identifying 
Do Not Generate  False 
Relationship Name  fk_instr_sup_act_to_prosa 
Relationship Business Name   
Logical Only  No 
Parent Entity  Personnel Role Operation SubGroup Assignment 
Child Entity  Instrument Support Activity 
Cardinality  Zero or One to Zero or More 
Existence  Optional 
Propagated Key  Primary Key 

"Personnel Role Operation SubGroup Assignment to Instrument Support Activity" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"Personnel Role Operation SubGroup Assignment to Instrument Support Activity" Foreign Keys 
Parent Key  Child Key 
Badge Number, Operation Group Identifier, Operation Subgroup1 Identifier  Badge Number, Operation Group Identifier, Operation Subgroup1 Identifier 

"Personnel Role Operation SubGroup Assignment to Instrument Support Activity" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"Personnel Role Operation SubGroup Assignment to Instrument Support Activity" Bound Attachments 
Name  Current Value 


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

"Instrument Support Activity Status to Instrument Support Activity" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"Instrument Support Activity Status to Instrument Support Activity" Foreign Keys 
Parent Key  Child Key 
Status Identifier  Status Identifier 

"Instrument Support Activity Status to Instrument Support Activity" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"Instrument Support Activity Status to Instrument Support Activity" Bound Attachments 
Name  Current Value 


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

"Operation Subgroup to Instrument Downtime Accounting" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

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

"Operation Subgroup to Instrument Downtime Accounting" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"Operation Subgroup to Instrument Downtime Accounting" Bound Attachments 
Name  Current Value 


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

"NS_OPER.Operation Group to Operation Subgroup" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"NS_OPER.Operation Group to Operation Subgroup" Foreign Keys 
Parent Key  Child Key 
Operation Group Identifier  Operation Group Identifier 

"NS_OPER.Operation Group to Operation Subgroup" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"NS_OPER.Operation Group to Operation Subgroup" Bound Attachments 
Name  Current Value 


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

"XF_ADMIN.Instrument to Shift Instrument Note" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"XF_ADMIN.Instrument to Shift Instrument Note" Foreign Keys 
Parent Key  Child Key 
Instrument Identifier  Instrument Identifier 

"XF_ADMIN.Instrument to Shift Instrument Note" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"XF_ADMIN.Instrument to Shift Instrument Note" Bound Attachments 
Name  Current Value 


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

"Instrument Shift Summary to Shift Instrument Note" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"Instrument Shift Summary to Shift Instrument Note" Foreign Keys 
Parent Key  Child Key 
Shift Identifier, Facility Identifier, Calendar Date  Shift Identifier, Facility Identifier, Calendar Date 

"Instrument Shift Summary to Shift Instrument Note" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"Instrument Shift Summary to Shift Instrument Note" Bound Attachments 
Name  Current Value 


"Operation Subgroup to Shift Instrument Note Group Assignment" 
RelationshipType  Non-Identifying 
Do Not Generate  False 
Relationship Name  fk_singa_to_oper_subgrp1 
Relationship Business Name   
Logical Only  No 
Parent Entity  Operation Subgroup 
Child Entity  Shift Instrument Note Group Assignment 
Cardinality  One To Zero or More 
Existence  Mandatory 
Propagated Key  Primary Key 

"Operation Subgroup to Shift Instrument Note Group Assignment" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"Operation Subgroup to Shift Instrument Note Group Assignment" Foreign Keys 
Parent Key  Child Key 
Operation Group Identifier, Operation Subgroup1 Identifier  Operation Group Identifier, Operation Subgroup1 Identifier 

"Operation Subgroup to Shift Instrument Note Group Assignment" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"Operation Subgroup to Shift Instrument Note Group Assignment" Bound Attachments 
Name  Current Value 


"Shift Instrument Note to Shift Instrument Note Group Assignment" 
RelationshipType  Identifying 
Do Not Generate  False 
Relationship Name  fk_singa_to_shift_instr_note 
Relationship Business Name   
Logical Only  No 
Parent Entity  Shift Instrument Note 
Child Entity  Shift Instrument Note Group Assignment 
Cardinality  One To Zero or More 
Existence  Mandatory 
Propagated Key  Primary Key 

"Shift Instrument Note to Shift Instrument Note Group Assignment" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"Shift Instrument Note to Shift Instrument Note Group Assignment" Foreign Keys 
Parent Key  Child Key 
Shift Identifier, Facility Identifier, Calendar Date, Instrument Identifier  Shift Identifier, Facility Identifier, Calendar Date, Instrument Identifier 

"Shift Instrument Note to Shift Instrument Note Group Assignment" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"Shift Instrument Note to Shift Instrument Note Group Assignment" Bound Attachments 
Name  Current Value