"Manufacturer Model to Ctrls Mnfctr Mdl" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Manufacturer Model |
Child Entity | Ctrls Mnfctr Mdl |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Manufacturer Model to Ctrls Mnfctr Mdl" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Manufacturer Model to Ctrls Mnfctr Mdl" Foreign Keys |
Parent Key | Child Key |
Mnfctr Id, Mdl Nbr | Mnfctr Id, Mdl Nbr |
"Manufacturer Model to Ctrls Mnfctr Mdl" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Manufacturer Model to Ctrls Mnfctr Mdl" Bound Attachments |
Name | Current Value |
"User Instr Type to User Inst" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | |
Relationship Business Name | |
Logical Only | No |
Parent Entity | User Instr Type |
Child Entity | User Inst |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"User Instr Type to User Inst" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"User Instr Type to User Inst" Foreign Keys |
Parent Key | Child Key |
User Instr Type Id | User Instr Type Id |
"User Instr Type to User Inst" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"User Instr Type to User Inst" Bound Attachments |
Name | Current Value |
"Equipment to Equipment Usage" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Equipment |
Child Entity | Equipment Usage |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Equipment to Equipment Usage" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Equipment to Equipment Usage" Foreign Keys |
Parent Key | Child Key |
Equip Id | Equip Id |
"Equipment to Equipment Usage" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Equipment to Equipment Usage" Bound Attachments |
Name | Current Value |
"Equipment to User Inst" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Equipment |
Child Entity | User Inst |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Equipment to User Inst" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Equipment to User Inst" Foreign Keys |
Parent Key | Child Key |
Equip Id | Equip Id |
"Equipment to User Inst" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Equipment to User Inst" Bound Attachments |
Name | Current Value |
"Manufacturer Model to Magnet Manufacter Model" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Manufacturer Model |
Child Entity | Magnet Manufacter Model |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Manufacturer Model to Magnet Manufacter Model" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Manufacturer Model to Magnet Manufacter Model" Foreign Keys |
Parent Key | Child Key |
Mnfctr Id, Mdl Nbr | Mnfctr Id, Mdl Nbr |
"Manufacturer Model to Magnet Manufacter Model" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Manufacturer Model to Magnet Manufacter Model" Bound Attachments |
Name | Current Value |
"Manufacturer Model to Power Supply Manufacter Model" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Manufacturer Model |
Child Entity | Power Supply Manufacter Model |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Manufacturer Model to Power Supply Manufacter Model" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Manufacturer Model to Power Supply Manufacter Model" Foreign Keys |
Parent Key | Child Key |
Mnfctr Id, Mdl Nbr | Mnfctr Id, Mdl Nbr |
"Manufacturer Model to Power Supply Manufacter Model" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Manufacturer Model to Power Supply Manufacter Model" Bound Attachments |
Name | Current Value |
"Equipment to Radio Frequency Cavity" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Equipment |
Child Entity | Radio Frequency Cavity |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Equipment to Radio Frequency Cavity" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Equipment to Radio Frequency Cavity" Foreign Keys |
Parent Key | Child Key |
Equip Id | Equip Id |
"Equipment to Radio Frequency Cavity" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Equipment to Radio Frequency Cavity" Bound Attachments |
Name | Current Value |
"Radio Frequency Cavity to RF Cavity Gap Parameter" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Radio Frequency Cavity |
Child Entity | RF Cavity Gap Parameter |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Radio Frequency Cavity to RF Cavity Gap Parameter" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Radio Frequency Cavity to RF Cavity Gap Parameter" Foreign Keys |
Parent Key | Child Key |
Equip Id | Equip Id |
"Radio Frequency Cavity to RF Cavity Gap Parameter" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Radio Frequency Cavity to RF Cavity Gap Parameter" Bound Attachments |
Name | Current Value |
"Radio Frequency Cavity to Bead Pull" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Radio Frequency Cavity |
Child Entity | Bead Pull |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Radio Frequency Cavity to Bead Pull" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Radio Frequency Cavity to Bead Pull" Foreign Keys |
Parent Key | Child Key |
Equip Id | Equip Id |
"Radio Frequency Cavity to Bead Pull" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Radio Frequency Cavity to Bead Pull" Bound Attachments |
Name | Current Value |
"Radio Frequency Cavity to SC Cavity Parameter" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Radio Frequency Cavity |
Child Entity | SC Cavity Parameter |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Radio Frequency Cavity to SC Cavity Parameter" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Radio Frequency Cavity to SC Cavity Parameter" Foreign Keys |
Parent Key | Child Key |
Equip Id | Equip Id |
"Radio Frequency Cavity to SC Cavity Parameter" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Radio Frequency Cavity to SC Cavity Parameter" Bound Attachments |
Name | Current Value |
"Equipment to Power Supply" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Equipment |
Child Entity | Power Supply |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Equipment to Power Supply" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Equipment to Power Supply" Foreign Keys |
Parent Key | Child Key |
Equip Id | Equip Id |
"Equipment to Power Supply" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Equipment to Power Supply" Bound Attachments |
Name | Current Value |
"Equipment to Diagnostics Equipment History" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Equipment |
Child Entity | Diagnostics Equipment History |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Equipment to Diagnostics Equipment History" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Equipment to Diagnostics Equipment History" Foreign Keys |
Parent Key | Child Key |
Equip Id | Equip Id |
"Equipment to Diagnostics Equipment History" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Equipment to Diagnostics Equipment History" Bound Attachments |
Name | Current Value |
"Equipment to Diagnostics Equipment History" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Equipment |
Child Entity | Diagnostics Equipment History |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Equipment to Diagnostics Equipment History" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Equipment to Diagnostics Equipment History" Foreign Keys |
Parent Key | Child Key |
Equip Id | Parent Equip Id |
"Equipment to Diagnostics Equipment History" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Equipment to Diagnostics Equipment History" Bound Attachments |
Name | Current Value |
"Building Area to Equipment Location" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | area_equip_loc_rf |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Building Area |
Child Entity | Equipment Location |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Building Area to Equipment Location" Relationship Description |
Verb Sentence | A Building Area describes Equipment Location(s). |
Inverse Verb Sentence | An Equipment Location requries Building Area. |
Definition | |
Note |
"Building Area to Equipment Location" Foreign Keys |
Parent Key | Child Key |
Bldg Id, Area Id | Bldg Id, Area Id |
"Building Area to Equipment Location" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Building Area to Equipment Location" Bound Attachments |
Name | Current Value |
"Barcode Assignment to Barcd Asgn Audit" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | barcd_asgn_barcd_asgn_audit_rf |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Barcode Assignment |
Child Entity | Barcd Asgn Audit |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Barcode Assignment to Barcd Asgn Audit" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Barcode Assignment to Barcd Asgn Audit" Foreign Keys |
Parent Key | Child Key |
Dvc IEEE Nm | Dvc IEEE Nm |
"Barcode Assignment to Barcd Asgn Audit" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Barcode Assignment to Barcd Asgn Audit" Bound Attachments |
Name | Current Value |
"Building Area to Building Subarea" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | bldg_area_bldg_subarea_rf |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Building Area |
Child Entity | Building Subarea |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Building Area to Building Subarea" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Building Area to Building Subarea" Foreign Keys |
Parent Key | Child Key |
Bldg Id, Area Id | Bldg Id, Area Id |
"Building Area to Building Subarea" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Building Area to Building Subarea" Bound Attachments |
Name | Current Value |
"Building to Building Area" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | bldg_code_rf |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Building |
Child Entity | Building Area |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Building to Building Area" Relationship Description |
Verb Sentence | A Building contains Building Area(s). |
Inverse Verb Sentence | A Building Area is part of Building. |
Definition | |
Note |
"Building to Building Area" Foreign Keys |
Parent Key | Child Key |
Bldg Id | Bldg Id |
"Building to Building Area" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Building to Building Area" Bound Attachments |
Name | Current Value |
"Carrier to Equipment Receipt" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | carrier_rcpt_rf |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Carrier |
Child Entity | Equipment Receipt |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Carrier to Equipment Receipt" Relationship Description |
Verb Sentence | A Carrier is involved in Equipment Receipt(s). |
Inverse Verb Sentence | An Equipment Receipt requries Carrier. |
Definition | |
Note |
"Carrier to Equipment Receipt" Foreign Keys |
Parent Key | Child Key |
Carrier Id | Carrier Id |
"Carrier to Equipment Receipt" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Carrier to Equipment Receipt" Bound Attachments |
Name | Current Value |
"Employee MV to Equipment Usage" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | employee_equip_usage_rf |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Employee MV |
Child Entity | Equipment Usage |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Employee MV to Equipment Usage" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Employee MV to Equipment Usage" Foreign Keys |
Parent Key | Child Key |
Badge Number | Badge Number |
"Employee MV to Equipment Usage" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Employee MV to Equipment Usage" Bound Attachments |
Name | Current Value |
"Calibration Frequency to Equipment" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | equip_calib_freq_rf |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Calibration Frequency |
Child Entity | Equipment |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
"Calibration Frequency to Equipment" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Calibration Frequency to Equipment" Foreign Keys |
Parent Key | Child Key |
Calib Freq Id | Calib Freq Id |
"Calibration Frequency to Equipment" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Calibration Frequency to Equipment" Bound Attachments |
Name | Current Value |
"Calibration Method to Equipment" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | equip_calib_method_rf |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Calibration Method |
Child Entity | Equipment |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
"Calibration Method to Equipment" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Calibration Method to Equipment" Foreign Keys |
Parent Key | Child Key |
Calib Method Id | Calib Method Id |
"Calibration Method to Equipment" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Calibration Method to Equipment" Bound Attachments |
Name | Current Value |
"Equipment Category to Equipment Subcategory" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | equip_cat_equip_subcat_rf |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Equipment Category |
Child Entity | Equipment Subcategory |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Equipment Category to Equipment Subcategory" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Equipment Category to Equipment Subcategory" Foreign Keys |
Parent Key | Child Key |
Operation Group Identifier | Operation Group Identifier |
"Equipment Category to Equipment Subcategory" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Equipment Category to Equipment Subcategory" Bound Attachments |
Name | Current Value |
"Equipment Category to Manufacturer Model" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | equip_cat_mdl_rf |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Equipment Category |
Child Entity | Manufacturer Model |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Equipment Category to Manufacturer Model" Relationship Description |
Verb Sentence | An Equipment Category groups Manufacturer Model(s). |
Inverse Verb Sentence | A Manufacturer Model is assigned to Equipment Category. |
Definition | |
Note |
"Equipment Category to Manufacturer Model" Foreign Keys |
Parent Key | Child Key |
Operation Group Identifier | Operation Group Identifier |
"Equipment Category to Manufacturer Model" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Equipment Category to Manufacturer Model" Bound Attachments |
Name | Current Value |
"Equipment to Equipment Device Assignment" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | equip_dvc_asgn2_rf |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Equipment |
Child Entity | Equipment Device Assignment |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Equipment to Equipment Device Assignment" Relationship Description |
Verb Sentence | An Equipment is involved in Equipment Device Assignment(s). |
Inverse Verb Sentence | An Equipment Device Assignment uses Equipment. |
Definition | |
Note |
"Equipment to Equipment Device Assignment" Foreign Keys |
Parent Key | Child Key |
Equip Id | Equip Id |
"Equipment to Equipment Device Assignment" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Equipment to Equipment Device Assignment" Bound Attachments |
Name | Current Value |
"Equipment Sub Subcategory to Equipment" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | equip_equip_sub_subcat_rf |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Equipment Sub Subcategory |
Child Entity | Equipment |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Equipment Sub Subcategory to Equipment" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Equipment Sub Subcategory to Equipment" Foreign Keys |
Parent Key | Child Key |
Operation Group Identifier, Equip Subcat Id, Equip Sub Subcat ID | Operation Group Identifier, Equip Subcat Id, Equip Sub Subcat ID |
"Equipment Sub Subcategory to Equipment" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Equipment Sub Subcategory to Equipment" Bound Attachments |
Name | Current Value |
"Equipment Subcategory to Equipment" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | equip_equip_subcat_rf |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Equipment Subcategory |
Child Entity | Equipment |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Equipment Subcategory to Equipment" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Equipment Subcategory to Equipment" Foreign Keys |
Parent Key | Child Key |
Operation Group Identifier, Equip Subcat Id | Operation Group Identifier, Equip Subcat Id |
"Equipment Subcategory to Equipment" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Equipment Subcategory to Equipment" Bound Attachments |
Name | Current Value |
"Lead Engineer to Equipment" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | equip_lead_eng_rf |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Lead Engineer |
Child Entity | Equipment |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
"Lead Engineer to Equipment" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Lead Engineer to Equipment" Foreign Keys |
Parent Key | Child Key |
Lead Eng BN | Lead Eng BN |
"Lead Engineer to Equipment" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Lead Engineer to Equipment" Bound Attachments |
Name | Current Value |
"Equipment to Equipment Location" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | equip_loc_rf |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Equipment |
Child Entity | Equipment Location |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Equipment to Equipment Location" Relationship Description |
Verb Sentence | An Equipment resides at Equipment Location(s). |
Inverse Verb Sentence | An Equipment Location stores Equipment. |
Definition | |
Note |
"Equipment to Equipment Location" Foreign Keys |
Parent Key | Child Key |
Equip Id | Equip Id |
"Equipment to Equipment Location" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Equipment to Equipment Location" Bound Attachments |
Name | Current Value |
"Equipment Receipt to Receipt Item" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | equip_rcpt_item_rf |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Equipment Receipt |
Child Entity | Receipt Item |
Cardinality | One to One or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Equipment Receipt to Receipt Item" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Equipment Receipt to Receipt Item" Foreign Keys |
Parent Key | Child Key |
Equip Rcpt Id, Equip Rcpt Ver | Equip Rcpt Id, Equip Rcpt Ver |
"Equipment Receipt to Receipt Item" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Equipment Receipt to Receipt Item" Bound Attachments |
Name | Current Value |
"Equipment Status Code to Equipment Status" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | equip_stat_cd_rf |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Equipment Status Code |
Child Entity | Equipment Status |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Equipment Status Code to Equipment Status" Relationship Description |
Verb Sentence | An Equipment Status Code used in Equipment Status(s). |
Inverse Verb Sentence | An Equipment Status requires Equipment Status Code. |
Definition | |
Note |
"Equipment Status Code to Equipment Status" Foreign Keys |
Parent Key | Child Key |
Equip Stat Id | Equip Stat Id |
"Equipment Status Code to Equipment Status" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Equipment Status Code to Equipment Status" Bound Attachments |
Name | Current Value |
"Equipment to Equipment Status" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | equip_stat_rf |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Equipment |
Child Entity | Equipment Status |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Equipment to Equipment Status" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Equipment to Equipment Status" Foreign Keys |
Parent Key | Child Key |
Equip Id | Equip Id |
"Equipment to Equipment Status" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Equipment to Equipment Status" Bound Attachments |
Name | Current Value |
"Equipment Subcategory to Equipment Sub Subcategory" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | equip_subcat_sub_subcat_rf |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Equipment Subcategory |
Child Entity | Equipment Sub Subcategory |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Equipment Subcategory to Equipment Sub Subcategory" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Equipment Subcategory to Equipment Sub Subcategory" Foreign Keys |
Parent Key | Child Key |
Operation Group Identifier, Equip Subcat Id | Operation Group Identifier, Equip Subcat Id |
"Equipment Subcategory to Equipment Sub Subcategory" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Equipment Subcategory to Equipment Sub Subcategory" Bound Attachments |
Name | Current Value |
"Equipment Category to Equipment" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | equip_type_rf |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Equipment Category |
Child Entity | Equipment |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Equipment Category to Equipment" Relationship Description |
Verb Sentence | An Equipment Category describes Equipment(s). |
Inverse Verb Sentence | An Equipment is assigned to Equipment Category. |
Definition | |
Note |
"Equipment Category to Equipment" Foreign Keys |
Parent Key | Child Key |
Operation Group Identifier | Operation Group Identifier |
"Equipment Category to Equipment" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Equipment Category to Equipment" Bound Attachments |
Name | Current Value |
"EQUIP.Laboratory to Equipment Receipt" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | equp_rcpt_lab_rf |
Relationship Business Name | |
Logical Only | No |
Parent Entity | EQUIP.Laboratory |
Child Entity | Equipment Receipt |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"EQUIP.Laboratory to Equipment Receipt" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EQUIP.Laboratory to Equipment Receipt" Foreign Keys |
Parent Key | Child Key |
Lab Id | Lab Id |
"EQUIP.Laboratory to Equipment Receipt" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"EQUIP.Laboratory to Equipment Receipt" Bound Attachments |
Name | Current Value |
"Lead Engineer to Equipment Receipt" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | equp_rcpt_lead_eng_rf |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Lead Engineer |
Child Entity | Equipment Receipt |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Lead Engineer to Equipment Receipt" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Lead Engineer to Equipment Receipt" Foreign Keys |
Parent Key | Child Key |
Lead Eng BN | Lead Eng BN |
"Lead Engineer to Equipment Receipt" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Lead Engineer to Equipment Receipt" Bound Attachments |
Name | Current Value |
"Received By to Equipment Receipt" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | equp_rcpt_rcvd_by_rf |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Received By |
Child Entity | Equipment Receipt |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Received By to Equipment Receipt" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Received By to Equipment Receipt" Foreign Keys |
Parent Key | Child Key |
Rcvd By BN | Rcvd By BN |
"Received By to Equipment Receipt" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Received By to Equipment Receipt" Bound Attachments |
Name | Current Value |
"Manufacturer Model to Equipment" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | mnfctr_mdl_rf |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Manufacturer Model |
Child Entity | Equipment |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Manufacturer Model to Equipment" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Manufacturer Model to Equipment" Foreign Keys |
Parent Key | Child Key |
Mnfctr Id, Mdl Nbr | Mnfctr Id, Mdl Nbr |
"Manufacturer Model to Equipment" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Manufacturer Model to Equipment" Bound Attachments |
Name | Current Value |
"EQUIP.Manufacturer to Manufacturer Model" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | mnfctr_rf |
Relationship Business Name | |
Logical Only | No |
Parent Entity | EQUIP.Manufacturer |
Child Entity | Manufacturer Model |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"EQUIP.Manufacturer to Manufacturer Model" Relationship Description |
Verb Sentence | An EQUIP.Manufacturer produces Manufacturer Model(s). |
Inverse Verb Sentence | A Manufacturer Model is produced by EQUIP.Manufacturer. |
Definition | |
Note |
"EQUIP.Manufacturer to Manufacturer Model" Foreign Keys |
Parent Key | Child Key |
Mnfctr Id | Mnfctr Id |
"EQUIP.Manufacturer to Manufacturer Model" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"EQUIP.Manufacturer to Manufacturer Model" Bound Attachments |
Name | Current Value |
"Equipment Subcategory to Manufacturer Model" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | mnftr_mdl_subcat_rf |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Equipment Subcategory |
Child Entity | Manufacturer Model |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
"Equipment Subcategory to Manufacturer Model" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Equipment Subcategory to Manufacturer Model" Foreign Keys |
Parent Key | Child Key |
Operation Group Identifier, Equip Subcat Id | Operation Group Identifier, Equip Subcat Id |
"Equipment Subcategory to Manufacturer Model" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Equipment Subcategory to Manufacturer Model" Bound Attachments |
Name | Current Value |
"Equipment to Equipment" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | parent_equip_rf |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Equipment |
Child Entity | Equipment |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
"Equipment to Equipment" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Equipment to Equipment" Foreign Keys |
Parent Key | Child Key |
Equip Id | Parent Equipment ID |
"Equipment to Equipment" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Equipment to Equipment" Bound Attachments |
Name | Current Value |
"Power Supply Manufacter Model to Power Supply Cycle On" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | pwr_sply_mnfctr_mdl_cycle_rf |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Power Supply Manufacter Model |
Child Entity | Power Supply Cycle On |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Power Supply Manufacter Model to Power Supply Cycle On" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Power Supply Manufacter Model to Power Supply Cycle On" Foreign Keys |
Parent Key | Child Key |
Mnfctr Id, Mdl Nbr | Mnfctr Id, Mdl Nbr |
"Power Supply Manufacter Model to Power Supply Cycle On" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Power Supply Manufacter Model to Power Supply Cycle On" Bound Attachments |
Name | Current Value |
"Building Area to Receipt Item" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | rcpt_item_bldg_area_rf |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Building Area |
Child Entity | Receipt Item |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Building Area to Receipt Item" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Building Area to Receipt Item" Foreign Keys |
Parent Key | Child Key |
Bldg Id, Area Id | Bldg Id, Area Id |
"Building Area to Receipt Item" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Building Area to Receipt Item" Bound Attachments |
Name | Current Value |
"EQUIP.Unit of Measure to Manufacturer Model" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | uom_mnfctr_mdl_rf |
Relationship Business Name | |
Logical Only | No |
Parent Entity | EQUIP.Unit of Measure |
Child Entity | Manufacturer Model |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
"EQUIP.Unit of Measure to Manufacturer Model" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EQUIP.Unit of Measure to Manufacturer Model" Foreign Keys |
Parent Key | Child Key |
Unit Of Measure | Dimensions UOM |
"EQUIP.Unit of Measure to Manufacturer Model" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"EQUIP.Unit of Measure to Manufacturer Model" Bound Attachments |
Name | Current Value |