"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