"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 |