"Building to Part Cabinet" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | FK_PC_BLDG |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Building |
Child Entity | Part Cabinet |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Building to Part Cabinet" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Building to Part Cabinet" Foreign Keys |
Parent Key | Child Key |
Bldg Id | Bldg Id |
"Building to Part Cabinet" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Building to Part Cabinet" Bound Attachments |
Name | Current Value |
"Equipment Category to Part Cabinet" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | FK_PC_EQUIP_CAT |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Equipment Category |
Child Entity | Part Cabinet |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Equipment Category to Part Cabinet" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Equipment Category to Part Cabinet" Foreign Keys |
Parent Key | Child Key |
Operation Group Identifier | Operation Group Identifier |
"Equipment Category to Part Cabinet" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Equipment Category to Part Cabinet" Bound Attachments |
Name | Current Value |
"Part to Part Cab Dr" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | FK_PCD_PART |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Part |
Child Entity | Part Cab Dr |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
"Part to Part Cab Dr" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Part to Part Cab Dr" Foreign Keys |
Parent Key | Child Key |
Part Id | Part Id |
"Part to Part Cab Dr" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Part to Part Cab Dr" Bound Attachments |
Name | Current Value |
"Part Cabinet to Part Cab Dr" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_PCD_PART_CAB |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Part Cabinet |
Child Entity | Part Cab Dr |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Part Cabinet to Part Cab Dr" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Part Cabinet to Part Cab Dr" Foreign Keys |
Parent Key | Child Key |
Cab Id | Cab Id |
"Part Cabinet to Part Cab Dr" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Part Cabinet to Part Cab Dr" Bound Attachments |
Name | Current Value |
"Part to Part Cab Dr Bin" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | FK_PCDB_PART |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Part |
Child Entity | Part Cab Dr Bin |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
"Part to Part Cab Dr Bin" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Part to Part Cab Dr Bin" Foreign Keys |
Parent Key | Child Key |
Part Id | Part Id |
"Part to Part Cab Dr Bin" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Part to Part Cab Dr Bin" Bound Attachments |
Name | Current Value |
"Part Cab Dr to Part Cab Dr Bin" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_PCDB_PART_CAB_DR |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Part Cab Dr |
Child Entity | Part Cab Dr Bin |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Part Cab Dr to Part Cab Dr Bin" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Part Cab Dr to Part Cab Dr Bin" Foreign Keys |
Parent Key | Child Key |
Cab Id, Dr Id | Cab Id, Dr Id |
"Part Cab Dr to Part Cab Dr Bin" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Part Cab Dr to Part Cab Dr Bin" Bound Attachments |
Name | Current Value |
"Part to Part Cab Dr Bin Sec" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | FK_PCDBS_PART |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Part |
Child Entity | Part Cab Dr Bin Sec |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
"Part to Part Cab Dr Bin Sec" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Part to Part Cab Dr Bin Sec" Foreign Keys |
Parent Key | Child Key |
Part Id | Part Id |
"Part to Part Cab Dr Bin Sec" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Part to Part Cab Dr Bin Sec" Bound Attachments |
Name | Current Value |
"Part Cab Dr Bin to Part Cab Dr Bin Sec" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_PCDBS_PART_CAB_DR_BIN |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Part Cab Dr Bin |
Child Entity | Part Cab Dr Bin Sec |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Part Cab Dr Bin to Part Cab Dr Bin Sec" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Part Cab Dr Bin to Part Cab Dr Bin Sec" Foreign Keys |
Parent Key | Child Key |
Cab Id, Dr Id, Bin Id | Cab Id, Dr Id, Bin Id |
"Part Cab Dr Bin to Part Cab Dr Bin Sec" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Part Cab Dr Bin to Part Cab Dr Bin Sec" Bound Attachments |
Name | Current Value |