"NS_OPER.Shift to Instrument Shift Summary" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | |
Relationship Business Name | |
Logical Only | No |
Parent Entity | NS_OPER.Shift |
Child Entity | Instrument Shift Summary |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"NS_OPER.Shift to Instrument Shift Summary" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"NS_OPER.Shift to Instrument Shift Summary" Foreign Keys |
Parent Key | Child Key |
Shift Identifier | Shift Identifier |
"NS_OPER.Shift to Instrument Shift Summary" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"NS_OPER.Shift to Instrument Shift Summary" Bound Attachments |
Name | Current Value |
"XF_ADMIN.Instrument to Instrument Logbook Category Association" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | |
Relationship Business Name | |
Logical Only | No |
Parent Entity | XF_ADMIN.Instrument |
Child Entity | Instrument Logbook Category Association |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"XF_ADMIN.Instrument to Instrument Logbook Category Association" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"XF_ADMIN.Instrument to Instrument Logbook Category Association" Foreign Keys |
Parent Key | Child Key |
Instrument Identifier | Instrument Identifier |
"XF_ADMIN.Instrument to Instrument Logbook Category Association" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"XF_ADMIN.Instrument to Instrument Logbook Category Association" Bound Attachments |
Name | Current Value |
"Log Category to Instrument Logbook Category Association" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Log Category |
Child Entity | Instrument Logbook Category Association |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Log Category to Instrument Logbook Category Association" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Log Category to Instrument Logbook Category Association" Foreign Keys |
Parent Key | Child Key |
Cat Id | Cat Id |
"Log Category to Instrument Logbook Category Association" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Log Category to Instrument Logbook Category Association" Bound Attachments |
Name | Current Value |
"NS_OPER.Personnel Role to Personnel Role Operation Group Assignment" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | |
Relationship Business Name | |
Logical Only | No |
Parent Entity | NS_OPER.Personnel Role |
Child Entity | Personnel Role Operation Group Assignment |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"NS_OPER.Personnel Role to Personnel Role Operation Group Assignment" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"NS_OPER.Personnel Role to Personnel Role Operation Group Assignment" Foreign Keys |
Parent Key | Child Key |
Badge Number | Badge Number |
"NS_OPER.Personnel Role to Personnel Role Operation Group Assignment" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"NS_OPER.Personnel Role to Personnel Role Operation Group Assignment" Bound Attachments |
Name | Current Value |
"NS_OPER.Operation Group to Personnel Role Operation Group Assignment" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | |
Relationship Business Name | |
Logical Only | No |
Parent Entity | NS_OPER.Operation Group |
Child Entity | Personnel Role Operation Group Assignment |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"NS_OPER.Operation Group to Personnel Role Operation Group Assignment" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"NS_OPER.Operation Group to Personnel Role Operation Group Assignment" Foreign Keys |
Parent Key | Child Key |
Operation Group Identifier | Operation Group Identifier |
"NS_OPER.Operation Group to Personnel Role Operation Group Assignment" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"NS_OPER.Operation Group to Personnel Role Operation Group Assignment" Bound Attachments |
Name | Current Value |
"Personnel Role Operation Group Assignment to Personnel Role Operation SubGroup Assignment" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Personnel Role Operation Group Assignment |
Child Entity | Personnel Role Operation SubGroup Assignment |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Personnel Role Operation Group Assignment to Personnel Role Operation SubGroup Assignment" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Personnel Role Operation Group Assignment to Personnel Role Operation SubGroup Assignment" Foreign Keys |
Parent Key | Child Key |
Badge Number, Operation Group Identifier | Badge Number, Operation Group Identifier |
"Personnel Role Operation Group Assignment to Personnel Role Operation SubGroup Assignment" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Personnel Role Operation Group Assignment to Personnel Role Operation SubGroup Assignment" Bound Attachments |
Name | Current Value |
"Operation Subgroup to Personnel Role Operation SubGroup Assignment" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Operation Subgroup |
Child Entity | Personnel Role Operation SubGroup Assignment |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Operation Subgroup to Personnel Role Operation SubGroup Assignment" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Operation Subgroup to Personnel Role Operation SubGroup Assignment" Foreign Keys |
Parent Key | Child Key |
Operation Group Identifier, Operation Subgroup1 Identifier | Operation Group Identifier, Operation Subgroup1 Identifier |
"Operation Subgroup to Personnel Role Operation SubGroup Assignment" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Operation Subgroup to Personnel Role Operation SubGroup Assignment" Bound Attachments |
Name | Current Value |
"XF_ADMIN.Instrument to Instrument Downtime Accounting" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_ida_to_instr |
Relationship Business Name | |
Logical Only | No |
Parent Entity | XF_ADMIN.Instrument |
Child Entity | Instrument Downtime Accounting |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"XF_ADMIN.Instrument to Instrument Downtime Accounting" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"XF_ADMIN.Instrument to Instrument Downtime Accounting" Foreign Keys |
Parent Key | Child Key |
Instrument Identifier | Instrument Identifier |
"XF_ADMIN.Instrument to Instrument Downtime Accounting" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"XF_ADMIN.Instrument to Instrument Downtime Accounting" Bound Attachments |
Name | Current Value |
"Instrument Shift Summary to Instrument Downtime Accounting" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_ida_to_instr_shift_summ |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Instrument Shift Summary |
Child Entity | Instrument Downtime Accounting |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Instrument Shift Summary to Instrument Downtime Accounting" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Instrument Shift Summary to Instrument Downtime Accounting" Foreign Keys |
Parent Key | Child Key |
Shift Identifier, Facility Identifier, Calendar Date | Shift Identifier, Facility Identifier, Calendar Date |
"Instrument Shift Summary to Instrument Downtime Accounting" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Instrument Shift Summary to Instrument Downtime Accounting" Bound Attachments |
Name | Current Value |
"XF_ADMIN.Instrument to Instrument Support Activity" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | fk_instr_sup_act_to_instr |
Relationship Business Name | |
Logical Only | No |
Parent Entity | XF_ADMIN.Instrument |
Child Entity | Instrument Support Activity |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
"XF_ADMIN.Instrument to Instrument Support Activity" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"XF_ADMIN.Instrument to Instrument Support Activity" Foreign Keys |
Parent Key | Child Key |
Instrument Identifier | Instrument Identifier |
"XF_ADMIN.Instrument to Instrument Support Activity" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"XF_ADMIN.Instrument to Instrument Support Activity" Bound Attachments |
Name | Current Value |
"Personnel Role Operation SubGroup Assignment to Instrument Support Activity" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | fk_instr_sup_act_to_prosa |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Personnel Role Operation SubGroup Assignment |
Child Entity | Instrument Support Activity |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
"Personnel Role Operation SubGroup Assignment to Instrument Support Activity" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Personnel Role Operation SubGroup Assignment to Instrument Support Activity" Foreign Keys |
Parent Key | Child Key |
Badge Number, Operation Group Identifier, Operation Subgroup1 Identifier | Badge Number, Operation Group Identifier, Operation Subgroup1 Identifier |
"Personnel Role Operation SubGroup Assignment to Instrument Support Activity" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Personnel Role Operation SubGroup Assignment to Instrument Support Activity" Bound Attachments |
Name | Current Value |
"Instrument Support Activity Status to Instrument Support Activity" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | fk_isa_to_instr_sup_act_stat |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Instrument Support Activity Status |
Child Entity | Instrument Support Activity |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Instrument Support Activity Status to Instrument Support Activity" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Instrument Support Activity Status to Instrument Support Activity" Foreign Keys |
Parent Key | Child Key |
Status Identifier | Status Identifier |
"Instrument Support Activity Status to Instrument Support Activity" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Instrument Support Activity Status to Instrument Support Activity" Bound Attachments |
Name | Current Value |
"Operation Subgroup to Instrument Downtime Accounting" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_isr_to_oper_subgrp1 |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Operation Subgroup |
Child Entity | Instrument Downtime Accounting |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Operation Subgroup to Instrument Downtime Accounting" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Operation Subgroup to Instrument Downtime Accounting" Foreign Keys |
Parent Key | Child Key |
Operation Group Identifier, Operation Subgroup1 Identifier | Operation Group Identifier, Operation Subgroup1 Identifier |
"Operation Subgroup to Instrument Downtime Accounting" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Operation Subgroup to Instrument Downtime Accounting" Bound Attachments |
Name | Current Value |
"NS_OPER.Operation Group to Operation Subgroup" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_oper_subgrp1_oper_grp_1 |
Relationship Business Name | |
Logical Only | No |
Parent Entity | NS_OPER.Operation Group |
Child Entity | Operation Subgroup |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"NS_OPER.Operation Group to Operation Subgroup" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"NS_OPER.Operation Group to Operation Subgroup" Foreign Keys |
Parent Key | Child Key |
Operation Group Identifier | Operation Group Identifier |
"NS_OPER.Operation Group to Operation Subgroup" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"NS_OPER.Operation Group to Operation Subgroup" Bound Attachments |
Name | Current Value |
"XF_ADMIN.Instrument to Shift Instrument Note" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_sin_to_instr |
Relationship Business Name | |
Logical Only | No |
Parent Entity | XF_ADMIN.Instrument |
Child Entity | Shift Instrument Note |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"XF_ADMIN.Instrument to Shift Instrument Note" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"XF_ADMIN.Instrument to Shift Instrument Note" Foreign Keys |
Parent Key | Child Key |
Instrument Identifier | Instrument Identifier |
"XF_ADMIN.Instrument to Shift Instrument Note" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"XF_ADMIN.Instrument to Shift Instrument Note" Bound Attachments |
Name | Current Value |
"Instrument Shift Summary to Shift Instrument Note" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_sin_to_instr_shift_sum |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Instrument Shift Summary |
Child Entity | Shift Instrument Note |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Instrument Shift Summary to Shift Instrument Note" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Instrument Shift Summary to Shift Instrument Note" Foreign Keys |
Parent Key | Child Key |
Shift Identifier, Facility Identifier, Calendar Date | Shift Identifier, Facility Identifier, Calendar Date |
"Instrument Shift Summary to Shift Instrument Note" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Instrument Shift Summary to Shift Instrument Note" Bound Attachments |
Name | Current Value |
"Operation Subgroup to Shift Instrument Note Group Assignment" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | fk_singa_to_oper_subgrp1 |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Operation Subgroup |
Child Entity | Shift Instrument Note Group Assignment |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Operation Subgroup to Shift Instrument Note Group Assignment" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Operation Subgroup to Shift Instrument Note Group Assignment" Foreign Keys |
Parent Key | Child Key |
Operation Group Identifier, Operation Subgroup1 Identifier | Operation Group Identifier, Operation Subgroup1 Identifier |
"Operation Subgroup to Shift Instrument Note Group Assignment" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Operation Subgroup to Shift Instrument Note Group Assignment" Bound Attachments |
Name | Current Value |
"Shift Instrument Note to Shift Instrument Note Group Assignment" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_singa_to_shift_instr_note |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Shift Instrument Note |
Child Entity | Shift Instrument Note Group Assignment |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Shift Instrument Note to Shift Instrument Note Group Assignment" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Shift Instrument Note to Shift Instrument Note Group Assignment" Foreign Keys |
Parent Key | Child Key |
Shift Identifier, Facility Identifier, Calendar Date, Instrument Identifier | Shift Identifier, Facility Identifier, Calendar Date, Instrument Identifier |
"Shift Instrument Note to Shift Instrument Note Group Assignment" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Shift Instrument Note to Shift Instrument Note Group Assignment" Bound Attachments |
Name | Current Value |