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