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

"OPER_PROC_MAN to OPER_PROC_MAN_REV" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"OPER_PROC_MAN to OPER_PROC_MAN_REV" Foreign Keys 
Parent Key  Child Key 
OPER_PROC_MAN_ID  OPER_PROC_MAN_ID 

"OPER_PROC_MAN to OPER_PROC_MAN_REV" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"OPER_PROC_MAN to OPER_PROC_MAN_REV" Bound Attachments 
Name  Current Value 


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

"OPER_GRP to OPER_SUBGRP1" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"OPER_GRP to OPER_SUBGRP1" Foreign Keys 
Parent Key  Child Key 
OPER_GRP_ID  OPER_GRP_ID 

"OPER_GRP to OPER_SUBGRP1" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"OPER_GRP to OPER_SUBGRP1" Bound Attachments 
Name  Current Value 


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

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

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

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

"EMPLOYEE to OPM_AUTHOR_ASSC" Bound Attachments 
Name  Current Value 


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

"OPER_PROC_MAN_REV to OPM_AUTHOR_ASSC" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"OPER_PROC_MAN_REV to OPM_AUTHOR_ASSC" Foreign Keys 
Parent Key  Child Key 
OPER_PROC_MAN_ID, REV_NBR  OPER_PROC_MAN_ID, REV_NBR 

"OPER_PROC_MAN_REV to OPM_AUTHOR_ASSC" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"OPER_PROC_MAN_REV to OPM_AUTHOR_ASSC" Bound Attachments 
Name  Current Value 


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

"OPER_PROC_MAN_REV to OPM_CHAP" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"OPER_PROC_MAN_REV to OPM_CHAP" Foreign Keys 
Parent Key  Child Key 
OPER_PROC_MAN_ID, REV_NBR  OPER_PROC_MAN_ID, REV_NBR 

"OPER_PROC_MAN_REV to OPM_CHAP" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"OPER_PROC_MAN_REV to OPM_CHAP" Bound Attachments 
Name  Current Value 


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

"OPER_GRP to OPM_GRP" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"OPER_GRP to OPM_GRP" Foreign Keys 
Parent Key  Child Key 
OPER_GRP_ID  OPER_GRP_ID 

"OPER_GRP to OPM_GRP" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"OPER_GRP to OPM_GRP" Bound Attachments 
Name  Current Value 


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

"OPER_SUBGRP1 to OPM_GRP" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"OPER_SUBGRP1 to OPM_GRP" Foreign Keys 
Parent Key  Child Key 
OPER_GRP_ID, OPER_SUBGRP1_ID  OPER_GRP_ID, OPER_SUBGRP1_ID 

"OPER_SUBGRP1 to OPM_GRP" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"OPER_SUBGRP1 to OPM_GRP" Bound Attachments 
Name  Current Value 


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

"OPM_GRP to OPER_PROC_MAN" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"OPM_GRP to OPER_PROC_MAN" Foreign Keys 
Parent Key  Child Key 
GRP_ID  GRP_ID 

"OPM_GRP to OPER_PROC_MAN" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"OPM_GRP to OPER_PROC_MAN" Bound Attachments 
Name  Current Value 


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

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

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

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

"EMPLOYEE to OPM_REVIEWER_ASSC" Bound Attachments 
Name  Current Value 


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

"OPER_PROC_MAN_REV to OPM_REVIEWER_ASSC" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"OPER_PROC_MAN_REV to OPM_REVIEWER_ASSC" Foreign Keys 
Parent Key  Child Key 
OPER_PROC_MAN_ID, REV_NBR  OPER_PROC_MAN_ID, REV_NBR 

"OPER_PROC_MAN_REV to OPM_REVIEWER_ASSC" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"OPER_PROC_MAN_REV to OPM_REVIEWER_ASSC" Bound Attachments 
Name  Current Value 


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

"OPM_REVIEW_STAT to OPER_PROC_MAN_REV" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"OPM_REVIEW_STAT to OPER_PROC_MAN_REV" Foreign Keys 
Parent Key  Child Key 
REVIEW_STAT_ID  REVIEW_STAT_ID 

"OPM_REVIEW_STAT to OPER_PROC_MAN_REV" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"OPM_REVIEW_STAT to OPER_PROC_MAN_REV" Bound Attachments 
Name  Current Value 


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

"JOB_TITLE to PERS_ROLES" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"JOB_TITLE to PERS_ROLES" Foreign Keys 
Parent Key  Child Key 
JOB_TITLE_ID  JOB_TITLE_ID 

"JOB_TITLE to PERS_ROLES" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"JOB_TITLE to PERS_ROLES" Bound Attachments 
Name  Current Value