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

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

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

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

"INSTR to PROC_INSTR_ASSC" Bound Attachments 
Name  Current Value 


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

"PROCEDURE to PROC_INSTR_ASSC" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"PROCEDURE to PROC_INSTR_ASSC" Foreign Keys 
Parent Key  Child Key 
PROC_ID  PROC_ID 

"PROCEDURE to PROC_INSTR_ASSC" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"PROCEDURE to PROC_INSTR_ASSC" Bound Attachments 
Name  Current Value 


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

"PROC_REV to PROC_BODY" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"PROC_REV to PROC_BODY" Foreign Keys 
Parent Key  Child Key 
PROC_ID, REV_ID  PROC_ID, REV_ID 

"PROC_REV to PROC_BODY" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"PROC_REV to PROC_BODY" Bound Attachments 
Name  Current Value 


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

"SECT to PROC_BODY" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"SECT to PROC_BODY" Foreign Keys 
Parent Key  Child Key 
SECTION_ID  SECTION_ID 

"SECT to PROC_BODY" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"SECT to PROC_BODY" Bound Attachments 
Name  Current Value 


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

"PROC_BODY to PROC_PARA" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"PROC_BODY to PROC_PARA" Foreign Keys 
Parent Key  Child Key 
PROC_ID, REV_ID, SECTION_ID  PROC_ID, REV_ID, SECTION_ID 

"PROC_BODY to PROC_PARA" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"PROC_BODY to PROC_PARA" Bound Attachments 
Name  Current Value 


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

"PROCEDURE to PROC_REV" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"PROCEDURE to PROC_REV" Foreign Keys 
Parent Key  Child Key 
PROC_ID  PROC_ID 

"PROCEDURE to PROC_REV" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"PROCEDURE to PROC_REV" Bound Attachments 
Name  Current Value 


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

"STAT to PROCEDURE" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"STAT to PROCEDURE" Foreign Keys 
Parent Key  Child Key 
STAT_ID  STAT_ID 

"STAT to PROCEDURE" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"STAT to PROCEDURE" Bound Attachments 
Name  Current Value