"OPER.Shift to Shift Summary" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | |
Relationship Business Name | |
Logical Only | No |
Parent Entity | OPER.Shift |
Child Entity | Shift Summary |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"OPER.Shift to Shift Summary" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"OPER.Shift to Shift Summary" Foreign Keys |
Parent Key | Child Key |
Shift Identifier | Shift Identifier |
"OPER.Shift to Shift Summary" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"OPER.Shift to Shift Summary" Bound Attachments |
Name | Current Value |
"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 |
"Operation Subgroup1 to Beam Downtime Accounting" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Operation Subgroup1 |
Child Entity | Beam Downtime Accounting |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Operation Subgroup1 to Beam Downtime Accounting" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Operation Subgroup1 to Beam Downtime Accounting" Foreign Keys |
Parent Key | Child Key |
Operation Group Identifier, Operation Subgroup1 Identifier | Operation Group Identifier, Operation Subgroup1 Identifier |
"Operation Subgroup1 to Beam Downtime Accounting" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Operation Subgroup1 to Beam Downtime Accounting" Bound Attachments |
Name | Current Value |
"Beam Accounting Delivery Type to Beam Accounting Actual Delivery" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | BEAM_ACCT_RPT_ACT_DELIV_FK2 |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Beam Accounting Delivery Type |
Child Entity | Beam Accounting Actual Delivery |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Beam Accounting Delivery Type to Beam Accounting Actual Delivery" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Beam Accounting Delivery Type to Beam Accounting Actual Delivery" Foreign Keys |
Parent Key | Child Key |
Delivery Type | Delivery Type |
"Beam Accounting Delivery Type to Beam Accounting Actual Delivery" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Beam Accounting Delivery Type to Beam Accounting Actual Delivery" Bound Attachments |
Name | Current Value |
"Beam Accounting Requested Type to Beam Accounting Activity Request" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | BEAM_ACCT_RPT_ACT_REQ_FK2 |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Beam Accounting Requested Type |
Child Entity | Beam Accounting Activity Request |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Beam Accounting Requested Type to Beam Accounting Activity Request" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Beam Accounting Requested Type to Beam Accounting Activity Request" Foreign Keys |
Parent Key | Child Key |
Request Type | Request Type |
"Beam Accounting Requested Type to Beam Accounting Activity Request" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Beam Accounting Requested Type to Beam Accounting Activity Request" Bound Attachments |
Name | Current Value |
"Checklist to Checklist Step" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | chklst_chklst_step_rf |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Checklist |
Child Entity | Checklist Step |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Checklist to Checklist Step" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Checklist to Checklist Step" Foreign Keys |
Parent Key | Child Key |
Chklst Id, Chklst Rev | Chklst Id, Chklst Rev |
"Checklist to Checklist Step" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Checklist to Checklist Step" Bound Attachments |
Name | Current Value |
"Fiscal Year to Accelerator Run Schedule" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | fk_accel_run_sched_to_fy |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Fiscal Year |
Child Entity | Accelerator Run Schedule |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Fiscal Year to Accelerator Run Schedule" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Fiscal Year to Accelerator Run Schedule" Foreign Keys |
Parent Key | Child Key |
Fiscal Year Identifier | Fiscal Year Identifier |
"Fiscal Year to Accelerator Run Schedule" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Fiscal Year to Accelerator Run Schedule" Bound Attachments |
Name | Current Value |
"Accelerator Run Schedule Activity to Accelerator Production Schedule" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_aps_to_accel_run_sched_act |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Accelerator Run Schedule Activity |
Child Entity | Accelerator Production Schedule |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Accelerator Run Schedule Activity to Accelerator Production Schedule" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Accelerator Run Schedule Activity to Accelerator Production Schedule" Foreign Keys |
Parent Key | Child Key |
Run Schedule Activity Identifier | Run Schedule Activity Identifier |
"Accelerator Run Schedule Activity to Accelerator Production Schedule" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Accelerator Run Schedule Activity to Accelerator Production Schedule" Bound Attachments |
Name | Current Value |
"Run Schedule Status to Accelerator Run Schedule" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | fk_ars_to_run_sched_stat |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Run Schedule Status |
Child Entity | Accelerator Run Schedule |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Run Schedule Status to Accelerator Run Schedule" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Run Schedule Status to Accelerator Run Schedule" Foreign Keys |
Parent Key | Child Key |
Satus Identifier | Satus Identifier |
"Run Schedule Status to Accelerator Run Schedule" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Run Schedule Status to Accelerator Run Schedule" Bound Attachments |
Name | Current Value |
"Beam Downtime Accounting to Downtime Timer Accounting Association" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_beam_dt_acct_to_dtaa |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Beam Downtime Accounting |
Child Entity | Downtime Timer Accounting Association |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Beam Downtime Accounting to Downtime Timer Accounting Association" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Beam Downtime Accounting to Downtime Timer Accounting Association" Foreign Keys |
Parent Key | Child Key |
Operation Group Identifier, Operation Subgroup1 Identifier, Downtime Dte | Operation Group Identifier, Operation Subgroup1 Identifier, Downtime Dte |
"Beam Downtime Accounting to Downtime Timer Accounting Association" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Beam Downtime Accounting to Downtime Timer Accounting Association" Bound Attachments |
Name | Current Value |
"Delegation of Authority to Delegation Period" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_deleg_per_to_deleg_of_auth |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Delegation of Authority |
Child Entity | Delegation Period |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Delegation of Authority to Delegation Period" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Delegation of Authority to Delegation Period" Foreign Keys |
Parent Key | Child Key |
Badge Number | Badge Number |
"Delegation of Authority to Delegation Period" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Delegation of Authority to Delegation Period" Bound Attachments |
Name | Current Value |
"Delegation of Authority to Delegation Proxy" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_deleg_proxy_to_doa |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Delegation of Authority |
Child Entity | Delegation Proxy |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Delegation of Authority to Delegation Proxy" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Delegation of Authority to Delegation Proxy" Foreign Keys |
Parent Key | Child Key |
Badge Number | Badge Number |
"Delegation of Authority to Delegation Proxy" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Delegation of Authority to Delegation Proxy" Bound Attachments |
Name | Current Value |
"OPER.Employee to Delegation Proxy" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_deleg_proxy_to_employee |
Relationship Business Name | |
Logical Only | No |
Parent Entity | OPER.Employee |
Child Entity | Delegation Proxy |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"OPER.Employee to Delegation Proxy" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"OPER.Employee to Delegation Proxy" Foreign Keys |
Parent Key | Child Key |
Badge Number | Proxy Badge Number |
"OPER.Employee to Delegation Proxy" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"OPER.Employee to Delegation Proxy" Bound Attachments |
Name | Current Value |
"Delegation Period to Delegate" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_deleg_to_deleg_per |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Delegation Period |
Child Entity | Delegate |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Delegation Period to Delegate" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Delegation Period to Delegate" Foreign Keys |
Parent Key | Child Key |
Badge Number, Start Date | Badge Number, Start Date |
"Delegation Period to Delegate" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Delegation Period to Delegate" Bound Attachments |
Name | Current Value |
"OPER.Employee to Delegate" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | fk_deleg_to_employee |
Relationship Business Name | |
Logical Only | No |
Parent Entity | OPER.Employee |
Child Entity | Delegate |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"OPER.Employee to Delegate" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"OPER.Employee to Delegate" Foreign Keys |
Parent Key | Child Key |
Badge Number | Delegate Badge Number |
"OPER.Employee to Delegate" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"OPER.Employee to Delegate" Bound Attachments |
Name | Current Value |
"OPER.Employee to Delegation of Authority" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_doa_to_employee |
Relationship Business Name | |
Logical Only | No |
Parent Entity | OPER.Employee |
Child Entity | Delegation of Authority |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"OPER.Employee to Delegation of Authority" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"OPER.Employee to Delegation of Authority" Foreign Keys |
Parent Key | Child Key |
Badge Number | Badge Number |
"OPER.Employee to Delegation of Authority" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"OPER.Employee to Delegation of Authority" Bound Attachments |
Name | Current Value |
"Delegation of Authority to Delegation of Authority Notification" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_doan_to_deleg_of_auth |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Delegation of Authority |
Child Entity | Delegation of Authority Notification |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Delegation of Authority to Delegation of Authority Notification" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Delegation of Authority to Delegation of Authority Notification" Foreign Keys |
Parent Key | Child Key |
Badge Number | Badge Number |
"Delegation of Authority to Delegation of Authority Notification" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Delegation of Authority to Delegation of Authority Notification" Bound Attachments |
Name | Current Value |
"OPER.Employee to Delegation of Authority Notification" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_doan_to_employee |
Relationship Business Name | |
Logical Only | No |
Parent Entity | OPER.Employee |
Child Entity | Delegation of Authority Notification |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"OPER.Employee to Delegation of Authority Notification" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"OPER.Employee to Delegation of Authority Notification" Foreign Keys |
Parent Key | Child Key |
Badge Number | Notification Badge Number |
"OPER.Employee to Delegation of Authority Notification" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"OPER.Employee to Delegation of Authority Notification" Bound Attachments |
Name | Current Value |
"Downtime Event to Downtime Timer" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | fk_dt_timer_to_dt_evt |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Downtime Event |
Child Entity | Downtime Timer |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Downtime Event to Downtime Timer" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Downtime Event to Downtime Timer" Foreign Keys |
Parent Key | Child Key |
Downtime Event Identifier | Downtime Event Identifier |
"Downtime Event to Downtime Timer" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Downtime Event to Downtime Timer" Bound Attachments |
Name | Current Value |
"Downtime Timer to Downtime Timer Accounting Association" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_dtaa_to_downtime_timer |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Downtime Timer |
Child Entity | Downtime Timer Accounting Association |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Downtime Timer to Downtime Timer Accounting Association" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Downtime Timer to Downtime Timer Accounting Association" Foreign Keys |
Parent Key | Child Key |
Sequence Identifer | Sequence Identifer |
"Downtime Timer to Downtime Timer Accounting Association" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Downtime Timer to Downtime Timer Accounting Association" Bound Attachments |
Name | Current Value |
"Downtime Timer to Downtime Timer Event Assocation" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_dtea_to_downtime_timer |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Downtime Timer |
Child Entity | Downtime Timer Event Assocation |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Downtime Timer to Downtime Timer Event Assocation" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Downtime Timer to Downtime Timer Event Assocation" Foreign Keys |
Parent Key | Child Key |
Sequence Identifer | Sequence Identifer |
"Downtime Timer to Downtime Timer Event Assocation" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Downtime Timer to Downtime Timer Event Assocation" Bound Attachments |
Name | Current Value |
"Downtime Timer Event to Downtime Timer Event Assocation" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_dtea_to_dt_timer_evt |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Downtime Timer Event |
Child Entity | Downtime Timer Event Assocation |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Downtime Timer Event to Downtime Timer Event Assocation" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Downtime Timer Event to Downtime Timer Event Assocation" Foreign Keys |
Parent Key | Child Key |
Downtime Timer Event Identifier | Downtime Timer Event Identifier |
"Downtime Timer Event to Downtime Timer Event Assocation" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Downtime Timer Event to Downtime Timer Event Assocation" Bound Attachments |
Name | Current Value |
"Holiday to Holiday Schedule" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_holiday_sched_to_holiday |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Holiday |
Child Entity | Holiday Schedule |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Holiday to Holiday Schedule" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Holiday to Holiday Schedule" Foreign Keys |
Parent Key | Child Key |
Name | Name |
"Holiday to Holiday Schedule" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Holiday to Holiday Schedule" Bound Attachments |
Name | Current Value |
"Message Channel Access to Message Channel" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | FK_MSG_CHAN_ACCESS |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Message Channel Access |
Child Entity | Message Channel |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Message Channel Access to Message Channel" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Message Channel Access to Message Channel" Foreign Keys |
Parent Key | Child Key |
ACCESS_ID | ACCESS_ID |
"Message Channel Access to Message Channel" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Message Channel Access to Message Channel" Bound Attachments |
Name | Current Value |
"Message Channel to Message Channel Message" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | FK_MSG_CHAN_MSG_CHAN |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Message Channel |
Child Entity | Message Channel Message |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Message Channel to Message Channel Message" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Message Channel to Message Channel Message" Foreign Keys |
Parent Key | Child Key |
MSG_CHAN_ID | MSG_CHAN_ID |
"Message Channel to Message Channel Message" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Message Channel to Message Channel Message" 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 |
"Operation Subgroup1 to Operation Subgroup2" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_oper_subgrp2_oper_subgrp1 |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Operation Subgroup1 |
Child Entity | Operation Subgroup2 |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Operation Subgroup1 to Operation Subgroup2" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Operation Subgroup1 to Operation Subgroup2" Foreign Keys |
Parent Key | Child Key |
Operation Group Identifier, Operation Subgroup1 Identifier | Operation Group Identifier, Operation Subgroup1 Identifier |
"Operation Subgroup1 to Operation Subgroup2" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Operation Subgroup1 to Operation Subgroup2" Bound Attachments |
Name | Current Value |
"Operation Subgroup2 to Operation Subgroup3" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_oper_subgrp3_oper_subgrp2 |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Operation Subgroup2 |
Child Entity | Operation Subgroup3 |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Operation Subgroup2 to Operation Subgroup3" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Operation Subgroup2 to Operation Subgroup3" Foreign Keys |
Parent Key | Child Key |
Operation Group Identifier, Operation Subgroup1 Identifier, Operation Subgroup2 Identifier | Operation Group Identifier, Operation Subgroup1 Identifier, Operation Subgroup2 Identifier |
"Operation Subgroup2 to Operation Subgroup3" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Operation Subgroup2 to Operation Subgroup3" Bound Attachments |
Name | Current Value |
"Operation Subgroup3 to Operation Subgroup4" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_oper_subgrp3_oper_subgrp4 |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Operation Subgroup3 |
Child Entity | Operation Subgroup4 |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Operation Subgroup3 to Operation Subgroup4" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Operation Subgroup3 to Operation Subgroup4" Foreign Keys |
Parent Key | Child Key |
Operation Group Identifier, Operation Subgroup1 Identifier, Operation Subgroup2 Identifier, Operation Subgroup3 Identifier | Operation Group Identifier, Operation Subgroup1 Identifier, Operation Subgroup2 Identifier, Operation Subgroup3 Identifier |
"Operation Subgroup3 to Operation Subgroup4" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Operation Subgroup3 to Operation Subgroup4" Bound Attachments |
Name | Current Value |
"Operation Subgroup4 to Operation Subgroup5" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_oper_subgrp4_oper_subgrp5 |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Operation Subgroup4 |
Child Entity | Operation Subgroup5 |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Operation Subgroup4 to Operation Subgroup5" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Operation Subgroup4 to Operation Subgroup5" Foreign Keys |
Parent Key | Child Key |
Operation Group Identifier, Operation Subgroup1 Identifier, Operation Subgroup2 Identifier, Operation Subgroup3 Identifier, Operation Subgroup4 Identifier | Operation Group Identifier, Operation Subgroup1 Identifier, Operation Subgroup2 Identifier, Operation Subgroup3 Identifier, Operation Subgroup4 Identifier |
"Operation Subgroup4 to Operation Subgroup5" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Operation Subgroup4 to Operation Subgroup5" 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 |
"OPER.Employee to Organization Matrix" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_org_matrix_to_emp |
Relationship Business Name | |
Logical Only | No |
Parent Entity | OPER.Employee |
Child Entity | Organization Matrix |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"OPER.Employee to Organization Matrix" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"OPER.Employee to Organization Matrix" Foreign Keys |
Parent Key | Child Key |
Badge Number | Badge Number |
"OPER.Employee to Organization Matrix" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"OPER.Employee to Organization Matrix" Bound Attachments |
Name | Current Value |
"Operation Activity to Operation State" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | fk_os_to_oper_act |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Operation Activity |
Child Entity | Operation State |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Operation Activity to Operation State" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Operation Activity to Operation State" Foreign Keys |
Parent Key | Child Key |
Activity Identifier | Activity Identifier |
"Operation Activity to Operation State" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Operation Activity to Operation State" Bound Attachments |
Name | Current Value |
"Operation Status to Operation State" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | fk_os_to_oper_stat |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Operation Status |
Child Entity | Operation State |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Operation Status to Operation State" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Operation Status to Operation State" Foreign Keys |
Parent Key | Child Key |
Operation Status Identifer | Operation Status Identifer |
"Operation Status to Operation State" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Operation Status to Operation State" Bound Attachments |
Name | Current Value |
"Delegation of Authority to Person Location" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_pers_loc_to_del_auth |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Delegation of Authority |
Child Entity | Person Location |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Delegation of Authority to Person Location" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Delegation of Authority to Person Location" Foreign Keys |
Parent Key | Child Key |
Badge Number | Badge Number |
"Delegation of Authority to Person Location" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Delegation of Authority to Person Location" 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 |
"Research Acclerator Division Area to Research Acclerator Division Area Role Assignment" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_rad_asgn_area |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Research Acclerator Division Area |
Child Entity | Research Acclerator Division Area Role Assignment |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Research Acclerator Division Area to Research Acclerator Division Area Role Assignment" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Research Acclerator Division Area to Research Acclerator Division Area Role Assignment" Foreign Keys |
Parent Key | Child Key |
Area Identifier | Area Identifier |
"Research Acclerator Division Area to Research Acclerator Division Area Role Assignment" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Research Acclerator Division Area to Research Acclerator Division Area Role Assignment" Bound Attachments |
Name | Current Value |
"OPER.Employee to Research Acclerator Division Area Role Assignment" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_rad_asgn_emp |
Relationship Business Name | |
Logical Only | No |
Parent Entity | OPER.Employee |
Child Entity | Research Acclerator Division Area Role Assignment |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"OPER.Employee to Research Acclerator Division Area Role Assignment" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"OPER.Employee to Research Acclerator Division Area Role Assignment" Foreign Keys |
Parent Key | Child Key |
Badge Number | Badge Number |
"OPER.Employee to Research Acclerator Division Area Role Assignment" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"OPER.Employee to Research Acclerator Division Area Role Assignment" Bound Attachments |
Name | Current Value |
"Research Acclerator Division Area Role to Research Acclerator Division Area Role Assignment" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_rad_asgn_role |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Research Acclerator Division Area Role |
Child Entity | Research Acclerator Division Area Role Assignment |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Research Acclerator Division Area Role to Research Acclerator Division Area Role Assignment" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Research Acclerator Division Area Role to Research Acclerator Division Area Role Assignment" Foreign Keys |
Parent Key | Child Key |
Role Identifier | Role Identifier |
"Research Acclerator Division Area Role to Research Acclerator Division Area Role Assignment" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Research Acclerator Division Area Role to Research Acclerator Division Area Role Assignment" Bound Attachments |
Name | Current Value |
"Run Schedule Status to Reactor Fuel Cycle" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | fk_rfc_to_run_sched_stat |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Run Schedule Status |
Child Entity | Reactor Fuel Cycle |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Run Schedule Status to Reactor Fuel Cycle" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Run Schedule Status to Reactor Fuel Cycle" Foreign Keys |
Parent Key | Child Key |
Satus Identifier | Satus Identifier |
"Run Schedule Status to Reactor Fuel Cycle" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Run Schedule Status to Reactor Fuel Cycle" Bound Attachments |
Name | Current Value |
"Reactor Fuel Cycle to Reactor Run Schedule" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_rrs_to_reac_fuel_cyc |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Reactor Fuel Cycle |
Child Entity | Reactor Run Schedule |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Reactor Fuel Cycle to Reactor Run Schedule" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Reactor Fuel Cycle to Reactor Run Schedule" Foreign Keys |
Parent Key | Child Key |
Fuel Cycle Identifier | Fuel Cycle Identifier |
"Reactor Fuel Cycle to Reactor Run Schedule" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Reactor Fuel Cycle to Reactor Run Schedule" Bound Attachments |
Name | Current Value |
"Reactor Operation Activity to Reactor Run Schedule" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_rrs_to_reac_oper_act |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Reactor Operation Activity |
Child Entity | Reactor Run Schedule |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Reactor Operation Activity to Reactor Run Schedule" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Reactor Operation Activity to Reactor Run Schedule" Foreign Keys |
Parent Key | Child Key |
Activity Type Identifier | Activity Type Identifier |
"Reactor Operation Activity to Reactor Run Schedule" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Reactor Operation Activity to Reactor Run Schedule" Bound Attachments |
Name | Current Value |
"OPER.Shift to Shift Holiday Schedule" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_shift_holi_sched_to_shift |
Relationship Business Name | |
Logical Only | No |
Parent Entity | OPER.Shift |
Child Entity | Shift Holiday Schedule |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"OPER.Shift to Shift Holiday Schedule" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"OPER.Shift to Shift Holiday Schedule" Foreign Keys |
Parent Key | Child Key |
Shift Identifier | Shift Identifier |
"OPER.Shift to Shift Holiday Schedule" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"OPER.Shift to Shift Holiday Schedule" Bound Attachments |
Name | Current Value |
"OPER.Shift to Shift Scheduled Work Assignment" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_shift_pers_asgn_to_shift |
Relationship Business Name | |
Logical Only | No |
Parent Entity | OPER.Shift |
Child Entity | Shift Scheduled Work Assignment |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"OPER.Shift to Shift Scheduled Work Assignment" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"OPER.Shift to Shift Scheduled Work Assignment" Foreign Keys |
Parent Key | Child Key |
Shift Identifier | Shift Identifier |
"OPER.Shift to Shift Scheduled Work Assignment" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"OPER.Shift to Shift Scheduled Work Assignment" Bound Attachments |
Name | Current Value |
"OPER.Shift to Shift Work Schedule" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_shift_work_sched_to_shift |
Relationship Business Name | |
Logical Only | No |
Parent Entity | OPER.Shift |
Child Entity | Shift Work Schedule |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"OPER.Shift to Shift Work Schedule" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"OPER.Shift to Shift Work Schedule" Foreign Keys |
Parent Key | Child Key |
Shift Identifier | Shift Identifier |
"OPER.Shift to Shift Work Schedule" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"OPER.Shift to Shift Work Schedule" Bound Attachments |
Name | Current Value |
"OPER.Personnel Role to Shift Scheduled Work Assignment" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_spa_to_pers_role |
Relationship Business Name | |
Logical Only | No |
Parent Entity | OPER.Personnel Role |
Child Entity | Shift Scheduled Work Assignment |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"OPER.Personnel Role to Shift Scheduled Work Assignment" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"OPER.Personnel Role to Shift Scheduled Work Assignment" Foreign Keys |
Parent Key | Child Key |
BN | BN |
"OPER.Personnel Role to Shift Scheduled Work Assignment" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"OPER.Personnel Role to Shift Scheduled Work Assignment" Bound Attachments |
Name | Current Value |
"Shift Work Schedule to Shift Scheduled Work Assignment" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_spa_to_shift_work_sched |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Shift Work Schedule |
Child Entity | Shift Scheduled Work Assignment |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Shift Work Schedule to Shift Scheduled Work Assignment" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Shift Work Schedule to Shift Scheduled Work Assignment" Foreign Keys |
Parent Key | Child Key |
Shift Identifier, Calendar Date | Shift Identifier, Calendar Date |
"Shift Work Schedule to Shift Scheduled Work Assignment" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Shift Work Schedule to Shift Scheduled Work Assignment" Bound Attachments |
Name | Current Value |
"Shift Summary to Shift Summary File Attachment" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_ssfa_to_shift_summ |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Shift Summary |
Child Entity | Shift Summary File Attachment |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Shift Summary to Shift Summary File Attachment" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Shift Summary to Shift Summary File Attachment" Foreign Keys |
Parent Key | Child Key |
Shift Identifier, Calendar Date | Shift Identifier, Calendar Date |
"Shift Summary to Shift Summary File Attachment" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Shift Summary to Shift Summary File Attachment" Bound Attachments |
Name | Current Value |
"Shift Summary to Shift Summary Process Variable Association" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_sspva_to_shift_summ |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Shift Summary |
Child Entity | Shift Summary Process Variable Association |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Shift Summary to Shift Summary Process Variable Association" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Shift Summary to Shift Summary Process Variable Association" Foreign Keys |
Parent Key | Child Key |
Shift Identifier, Calendar Date | Shift Identifier, Calendar Date |
"Shift Summary to Shift Summary Process Variable Association" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Shift Summary to Shift Summary Process Variable Association" Bound Attachments |
Name | Current Value |
"Shift Summary Process Variable to Shift Summary Process Variable Association" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_sspva_to_shpv |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Shift Summary Process Variable |
Child Entity | Shift Summary Process Variable Association |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Shift Summary Process Variable to Shift Summary Process Variable Association" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Shift Summary Process Variable to Shift Summary Process Variable Association" Foreign Keys |
Parent Key | Child Key |
Sgnl Id | Sgnl Id |
"Shift Summary Process Variable to Shift Summary Process Variable Association" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Shift Summary Process Variable to Shift Summary Process Variable Association" Bound Attachments |
Name | Current Value |
"Shift Activity to Shift Scheduled Work Assignment" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | fk_sswa_to_shift_act |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Shift Activity |
Child Entity | Shift Scheduled Work Assignment |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
"Shift Activity to Shift Scheduled Work Assignment" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Shift Activity to Shift Scheduled Work Assignment" Foreign Keys |
Parent Key | Child Key |
Shift Activity Identifier | Shift Activity Identifier |
"Shift Activity to Shift Scheduled Work Assignment" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Shift Activity to Shift Scheduled Work Assignment" Bound Attachments |
Name | Current Value |
"OPER.Employee to Target Beam Parameters" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | fk_tgt_beam_parm_emp |
Relationship Business Name | |
Logical Only | No |
Parent Entity | OPER.Employee |
Child Entity | Target Beam Parameters |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"OPER.Employee to Target Beam Parameters" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"OPER.Employee to Target Beam Parameters" Foreign Keys |
Parent Key | Child Key |
Badge Number | Badge Number |
"OPER.Employee to Target Beam Parameters" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"OPER.Employee to Target Beam Parameters" Bound Attachments |
Name | Current Value |
"Checklist to Operations Checklist" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | opr_chklst_chklst_rf |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Checklist |
Child Entity | Operations Checklist |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Checklist to Operations Checklist" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Checklist to Operations Checklist" Foreign Keys |
Parent Key | Child Key |
Chklst Id, Chklst Rev | Chklst Id, Chklst Rev |
"Checklist to Operations Checklist" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Checklist to Operations Checklist" Bound Attachments |
Name | Current Value |
"Checklist Step to Operations Checklist Item" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | opr_chklst_item_chklst_step_rf |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Checklist Step |
Child Entity | Operations Checklist Item |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Checklist Step to Operations Checklist Item" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Checklist Step to Operations Checklist Item" Foreign Keys |
Parent Key | Child Key |
Chklst Id, Chklst Rev, Step Nbr | Chklst Id, Chklst Rev, Step Nbr |
"Checklist Step to Operations Checklist Item" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Checklist Step to Operations Checklist Item" Bound Attachments |
Name | Current Value |
"Operations Checklist to Operations Checklist Item" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | opr_chklst_item_opr_chklst_rf |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Operations Checklist |
Child Entity | Operations Checklist Item |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Operations Checklist to Operations Checklist Item" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Operations Checklist to Operations Checklist Item" Foreign Keys |
Parent Key | Child Key |
Chklst Id, Chklst Rev, Chklst Dte | Chklst Id, Chklst Rev, Chklst Dte |
"Operations Checklist to Operations Checklist Item" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Operations Checklist to Operations Checklist Item" Bound Attachments |
Name | Current Value |