"XF_ADMIN.Instrument to Procedure Instrument Assocation" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_pia_to_instr |
Relationship Business Name | |
Logical Only | No |
Parent Entity | XF_ADMIN.Instrument |
Child Entity | Procedure Instrument Assocation |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"XF_ADMIN.Instrument to Procedure Instrument Assocation" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"XF_ADMIN.Instrument to Procedure Instrument Assocation" Foreign Keys |
Parent Key | Child Key |
Instrument Identifier | Instrument Identifier |
"XF_ADMIN.Instrument to Procedure Instrument Assocation" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"XF_ADMIN.Instrument to Procedure Instrument Assocation" Bound Attachments |
Name | Current Value |
"Procedure to Procedure Instrument Assocation" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_pia_to_proc |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Procedure |
Child Entity | Procedure Instrument Assocation |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Procedure to Procedure Instrument Assocation" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Procedure to Procedure Instrument Assocation" Foreign Keys |
Parent Key | Child Key |
Procedure Identifier | Procedure Identifier |
"Procedure to Procedure Instrument Assocation" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Procedure to Procedure Instrument Assocation" Bound Attachments |
Name | Current Value |
"Procedure Revision to Procedure Body" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_proc_body_to_proc_rev |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Procedure Revision |
Child Entity | Procedure Body |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Procedure Revision to Procedure Body" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Procedure Revision to Procedure Body" Foreign Keys |
Parent Key | Child Key |
Procedure Identifier, Revision Identifier | Procedure Identifier, Revision Identifier |
"Procedure Revision to Procedure Body" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Procedure Revision to Procedure Body" Bound Attachments |
Name | Current Value |
"Section to Procedure Body" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_proc_body_to_proc_sect |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Section |
Child Entity | Procedure Body |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Section to Procedure Body" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Section to Procedure Body" Foreign Keys |
Parent Key | Child Key |
Section Identifier | Section Identifier |
"Section to Procedure Body" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Section to Procedure Body" Bound Attachments |
Name | Current Value |
"Procedure Body to Procedure Paragraph" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_proc_para_to_proc_body |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Procedure Body |
Child Entity | Procedure Paragraph |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Procedure Body to Procedure Paragraph" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Procedure Body to Procedure Paragraph" Foreign Keys |
Parent Key | Child Key |
Procedure Identifier, Revision Identifier, Section Identifier | Procedure Identifier, Revision Identifier, Section Identifier |
"Procedure Body to Procedure Paragraph" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Procedure Body to Procedure Paragraph" Bound Attachments |
Name | Current Value |
"Procedure to Procedure Revision" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_proc_rev_to_proc |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Procedure |
Child Entity | Procedure Revision |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Procedure to Procedure Revision" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Procedure to Procedure Revision" Foreign Keys |
Parent Key | Child Key |
Procedure Identifier | Procedure Identifier |
"Procedure to Procedure Revision" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Procedure to Procedure Revision" Bound Attachments |
Name | Current Value |
"PROC.Status to Procedure" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | fk_proc_to_stat |
Relationship Business Name | |
Logical Only | No |
Parent Entity | PROC.Status |
Child Entity | Procedure |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"PROC.Status to Procedure" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"PROC.Status to Procedure" Foreign Keys |
Parent Key | Child Key |
Status Identifier | Status Identifier |
"PROC.Status to Procedure" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"PROC.Status to Procedure" Bound Attachments |
Name | Current Value |