"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 


"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 


"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 


"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