"Material Status to Component Material" 
RelationshipType  Non-Identifying 
Do Not Generate  False 
Relationship Name  fk_cm_to_matl_stat 
Relationship Business Name   
Logical Only  No 
Parent Entity  Material Status 
Child Entity  Component Material 
Cardinality  One To Zero or More 
Existence  Mandatory 
Propagated Key  Primary Key 

"Material Status to Component Material" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"Material Status to Component Material" Foreign Keys 
Parent Key  Child Key 
Material Status Identifier  Material Status Identifier 

"Material Status to Component Material" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"Material Status to Component Material" Bound Attachments 
Name  Current Value 


"Material Type to Component Material" 
RelationshipType  Non-Identifying 
Do Not Generate  False 
Relationship Name  fk_cm_to_matl_type 
Relationship Business Name   
Logical Only  No 
Parent Entity  Material Type 
Child Entity  Component Material 
Cardinality  One To Zero or More 
Existence  Mandatory 
Propagated Key  Primary Key 

"Material Type to Component Material" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"Material Type to Component Material" Foreign Keys 
Parent Key  Child Key 
Material Type Identifier  Material Type Identifier 

"Material Type to Component Material" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"Material Type to Component Material" Bound Attachments 
Name  Current Value 


"Component Material to Component" 
RelationshipType  Non-Identifying 
Do Not Generate  False 
Relationship Name  fk_cmpnt_to_cmpnt_matl 
Relationship Business Name   
Logical Only  No 
Parent Entity  Component Material 
Child Entity  Component 
Cardinality  One To Zero or More 
Existence  Mandatory 
Propagated Key  Primary Key 

"Component Material to Component" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"Component Material to Component" Foreign Keys 
Parent Key  Child Key 
Material Identifier  Material Identifier 

"Component Material to Component" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"Component Material to Component" Bound Attachments 
Name  Current Value 


"Component Status to Component" 
RelationshipType  Non-Identifying 
Do Not Generate  False 
Relationship Name  fk_cmpnt_to_cmpnt_stat 
Relationship Business Name   
Logical Only  No 
Parent Entity  Component Status 
Child Entity  Component 
Cardinality  One To Zero or More 
Existence  Mandatory 
Propagated Key  Primary Key 

"Component Status to Component" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"Component Status to Component" Foreign Keys 
Parent Key  Child Key 
Component Status Identifier  Component Status Identifier 

"Component Status to Component" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"Component Status to Component" Bound Attachments 
Name  Current Value 


"Component Type to Component" 
RelationshipType  Non-Identifying 
Do Not Generate  False 
Relationship Name  fk_cmpnt_to_cmpnt_type 
Relationship Business Name   
Logical Only  No 
Parent Entity  Component Type 
Child Entity  Component 
Cardinality  One To Zero or More 
Existence  Mandatory 
Propagated Key  Primary Key 

"Component Type to Component" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"Component Type to Component" Foreign Keys 
Parent Key  Child Key 
Component Type Identifier  Component Type Identifier 

"Component Type to Component" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"Component Type to Component" Bound Attachments 
Name  Current Value 


"BICS.Manufacturer to Component" 
RelationshipType  Non-Identifying 
Do Not Generate  False 
Relationship Name  fk_cmpnt_to_mnfctr 
Relationship Business Name   
Logical Only  No 
Parent Entity  BICS.Manufacturer 
Child Entity  Component 
Cardinality  One To Zero or More 
Existence  Mandatory 
Propagated Key  Primary Key 

"BICS.Manufacturer to Component" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"BICS.Manufacturer to Component" Foreign Keys 
Parent Key  Child Key 
Manufacturer Id  Manufacturer Id 

"BICS.Manufacturer to Component" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"BICS.Manufacturer to Component" Bound Attachments 
Name  Current Value 


"Distributor Status to Distributor" 
RelationshipType  Non-Identifying 
Do Not Generate  False 
Relationship Name  fk_distr_to_distr_stat 
Relationship Business Name   
Logical Only  No 
Parent Entity  Distributor Status 
Child Entity  Distributor 
Cardinality  One To Zero or More 
Existence  Mandatory 
Propagated Key  Primary Key 

"Distributor Status to Distributor" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"Distributor Status to Distributor" Foreign Keys 
Parent Key  Child Key 
Distributor Status Identifier  Distributor Status Identifier 

"Distributor Status to Distributor" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"Distributor Status to Distributor" Bound Attachments 
Name  Current Value 


"Distributor Type to Distributor" 
RelationshipType  Non-Identifying 
Do Not Generate  False 
Relationship Name  fk_distr_to_distr_type 
Relationship Business Name   
Logical Only  No 
Parent Entity  Distributor Type 
Child Entity  Distributor 
Cardinality  One To Zero or More 
Existence  Mandatory 
Propagated Key  Primary Key 

"Distributor Type to Distributor" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"Distributor Type to Distributor" Foreign Keys 
Parent Key  Child Key 
Distributor Type Identifier  Distributor Type Identifier 

"Distributor Type to Distributor" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"Distributor Type to Distributor" Bound Attachments 
Name  Current Value 


"Distributor to Manufacturer Distributor Association" 
RelationshipType  Identifying 
Do Not Generate  False 
Relationship Name  fk_mda_to_distr 
Relationship Business Name   
Logical Only  No 
Parent Entity  Distributor 
Child Entity  Manufacturer Distributor Association 
Cardinality  One To Zero or More 
Existence  Mandatory 
Propagated Key  Primary Key 

"Distributor to Manufacturer Distributor Association" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"Distributor to Manufacturer Distributor Association" Foreign Keys 
Parent Key  Child Key 
Distributor Identifer  Distributor Identifer 

"Distributor to Manufacturer Distributor Association" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"Distributor to Manufacturer Distributor Association" Bound Attachments 
Name  Current Value 


"BICS.Manufacturer to Manufacturer Distributor Association" 
RelationshipType  Identifying 
Do Not Generate  False 
Relationship Name  fk_mda_to_mnfctr 
Relationship Business Name   
Logical Only  No 
Parent Entity  BICS.Manufacturer 
Child Entity  Manufacturer Distributor Association 
Cardinality  One To Zero or More 
Existence  Mandatory 
Propagated Key  Primary Key 

"BICS.Manufacturer to Manufacturer Distributor Association" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"BICS.Manufacturer to Manufacturer Distributor Association" Foreign Keys 
Parent Key  Child Key 
Manufacturer Id  Manufacturer Id 

"BICS.Manufacturer to Manufacturer Distributor Association" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"BICS.Manufacturer to Manufacturer Distributor Association" Bound Attachments 
Name  Current Value 


"Manufacturer Status to Manufacturer" 
RelationshipType  Non-Identifying 
Do Not Generate  False 
Relationship Name  fk_mnfctr_to_mnfctr_stat 
Relationship Business Name   
Logical Only  No 
Parent Entity  Manufacturer Status 
Child Entity  Manufacturer 
Cardinality  One To Zero or More 
Existence  Mandatory 
Propagated Key  Primary Key 

"Manufacturer Status to Manufacturer" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"Manufacturer Status to Manufacturer" Foreign Keys 
Parent Key  Child Key 
Manufacturer Status Identifier  Manufacturer Status Identifier 

"Manufacturer Status to Manufacturer" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"Manufacturer Status to Manufacturer" Bound Attachments 
Name  Current Value 


"Manufacturer Type to Manufacturer" 
RelationshipType  Non-Identifying 
Do Not Generate  False 
Relationship Name  fk_mnfctr_to_mnfctr_type 
Relationship Business Name   
Logical Only  No 
Parent Entity  Manufacturer Type 
Child Entity  Manufacturer 
Cardinality  One To Zero or More 
Existence  Mandatory 
Propagated Key  Primary Key 

"Manufacturer Type to Manufacturer" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"Manufacturer Type to Manufacturer" Foreign Keys 
Parent Key  Child Key 
Manufacturer Type Identifier  Manufacturer Type Identifier 

"Manufacturer Type to Manufacturer" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"Manufacturer Type to Manufacturer" Bound Attachments 
Name  Current Value