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

"Device to MPS Channel Audit" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"Device to MPS Channel Audit" Foreign Keys 
Parent Key  Child Key 
Device Identifer  Device Identifer 

"Device to MPS Channel Audit" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"Device to MPS Channel Audit" Bound Attachments 
Name  Current Value 


"Device to MPS Channel Audit" 
RelationshipType  Non-Identifying 
Do Not Generate  False 
Relationship Name   
Relationship Business Name   
Logical Only  No 
Parent Entity  Device 
Child Entity  MPS Channel Audit 
Cardinality  Zero or One to Zero or More 
Existence  Optional 
Propagated Key  Primary Key 

"Device to MPS Channel Audit" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"Device to MPS Channel Audit" Foreign Keys 
Parent Key  Child Key 
Device Identifer  Subseq Dvc Id 

"Device to MPS Channel Audit" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"Device to MPS Channel Audit" Bound Attachments 
Name  Current Value 


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

"Device to Machine Mode" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"Device to Machine Mode" Foreign Keys 
Parent Key  Child Key 
Device Identifer  Device Identifer 

"Device to Machine Mode" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"Device to Machine Mode" Bound Attachments 
Name  Current Value 


"Signal Record to MPS Daily Statistic" 
RelationshipType  Identifying 
Do Not Generate  False 
Relationship Name   
Relationship Business Name   
Logical Only  No 
Parent Entity  Signal Record 
Child Entity  MPS Daily Statistic 
Cardinality  One To Zero or More 
Existence  Mandatory 
Propagated Key  Primary Key 

"Signal Record to MPS Daily Statistic" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"Signal Record to MPS Daily Statistic" Foreign Keys 
Parent Key  Child Key 
Sgnl Id  Sgnl Id 

"Signal Record to MPS Daily Statistic" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"Signal Record to MPS Daily Statistic" Bound Attachments 
Name  Current Value 


"Device to Signal Record" 
RelationshipType  Non-Identifying 
Do Not Generate  False 
Relationship Name  dvc_sgnl_rec_rf 
Relationship Business Name   
Logical Only  No 
Parent Entity  Device 
Child Entity  Signal Record 
Cardinality  Zero or One to Zero or More 
Existence  Optional 
Propagated Key  Primary Key 

"Device to Signal Record" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"Device to Signal Record" Foreign Keys 
Parent Key  Child Key 
Device Identifer  Device Identifer 

"Device to Signal Record" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"Device to Signal Record" Bound Attachments 
Name  Current Value 


"MPS Audit Error Message to MPS Channel Audit" 
RelationshipType  Non-Identifying 
Do Not Generate  False 
Relationship Name  fk_err_msg 
Relationship Business Name   
Logical Only  No 
Parent Entity  MPS Audit Error Message 
Child Entity  MPS Channel Audit 
Cardinality  Zero or One to Zero or More 
Existence  Optional 
Propagated Key  Primary Key 

"MPS Audit Error Message to MPS Channel Audit" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"MPS Audit Error Message to MPS Channel Audit" Foreign Keys 
Parent Key  Child Key 
Err Nbr  Err Nbr 

"MPS Audit Error Message to MPS Channel Audit" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"MPS Audit Error Message to MPS Channel Audit" Bound Attachments 
Name  Current Value 


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

"Device to Machine Mode" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"Device to Machine Mode" Foreign Keys 
Parent Key  Child Key 
Device Identifer  MPS Intfc Dvc 

"Device to Machine Mode" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"Device to Machine Mode" Bound Attachments 
Name  Current Value 


"Machine Mode to MPS Channel Audit" 
RelationshipType  Identifying 
Do Not Generate  False 
Relationship Name  fk_machine_mode 
Relationship Business Name   
Logical Only  No 
Parent Entity  Machine Mode 
Child Entity  MPS Channel Audit 
Cardinality  One To Zero or More 
Existence  Mandatory 
Propagated Key  Primary Key 

"Machine Mode to MPS Channel Audit" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"Machine Mode to MPS Channel Audit" Foreign Keys 
Parent Key  Child Key 
Device Identifer, Appr Dte, Channel Nbr  Device Identifer, Appr Dte, Channel Nbr 

"Machine Mode to MPS Channel Audit" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"Machine Mode to MPS Channel Audit" Bound Attachments 
Name  Current Value 


"Machine Mode to MPS BLM Parameter" 
RelationshipType  Identifying 
Do Not Generate  False 
Relationship Name  FK_MBP_MACHINE_MODE 
Relationship Business Name   
Logical Only  No 
Parent Entity  Machine Mode 
Child Entity  MPS BLM Parameter 
Cardinality  One To Zero or More 
Existence  Mandatory 
Propagated Key  Primary Key 

"Machine Mode to MPS BLM Parameter" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"Machine Mode to MPS BLM Parameter" Foreign Keys 
Parent Key  Child Key 
Device Identifer, Appr Dte, Channel Nbr  Device Identifer, Appr Dte, Channel Nbr 

"Machine Mode to MPS BLM Parameter" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"Machine Mode to MPS BLM Parameter" Bound Attachments 
Name  Current Value 


"Device to Machine Mode" 
RelationshipType  Non-Identifying 
Do Not Generate  False 
Relationship Name  MACHINE_MODE_DVC_FK 
Relationship Business Name   
Logical Only  No 
Parent Entity  Device 
Child Entity  Machine Mode 
Cardinality  Zero or One to Zero or More 
Existence  Optional 
Propagated Key  Primary Key 

"Device to Machine Mode" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"Device to Machine Mode" Foreign Keys 
Parent Key  Child Key 
Device Identifer  MPS Dvc Id 

"Device to Machine Mode" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"Device to Machine Mode" Bound Attachments 
Name  Current Value 


"Device to MPS Signal Parameter" 
RelationshipType  Identifying 
Do Not Generate  False 
Relationship Name  mps_sgnl_param_dvc_rf 
Relationship Business Name   
Logical Only  No 
Parent Entity  Device 
Child Entity  MPS Signal Parameter 
Cardinality  One To Zero or More 
Existence  Mandatory 
Propagated Key  Primary Key 

"Device to MPS Signal Parameter" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"Device to MPS Signal Parameter" Foreign Keys 
Parent Key  Child Key 
Device Identifer  Device Identifer 

"Device to MPS Signal Parameter" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"Device to MPS Signal Parameter" Bound Attachments 
Name  Current Value 


"MPS Signal Parameter to Machine Mode" 
RelationshipType  Identifying 
Do Not Generate  False 
Relationship Name  mps_sgnl_param_mach_mode_rf 
Relationship Business Name   
Logical Only  No 
Parent Entity  MPS Signal Parameter 
Child Entity  Machine Mode 
Cardinality  One To Zero or More 
Existence  Mandatory 
Propagated Key  Primary Key 

"MPS Signal Parameter to Machine Mode" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"MPS Signal Parameter to Machine Mode" Foreign Keys 
Parent Key  Child Key 
Device Identifer, Appr Dte  Device Identifer, Appr Dte 

"MPS Signal Parameter to Machine Mode" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"MPS Signal Parameter to Machine Mode" Bound Attachments 
Name  Current Value 


"MPS Chain to MPS Signal Parameter" 
RelationshipType  Non-Identifying 
Do Not Generate  False 
Relationship Name  MPS_SGNL_PARAM_MPS_CHAIN_RF 
Relationship Business Name   
Logical Only  No 
Parent Entity  MPS Chain 
Child Entity  MPS Signal Parameter 
Cardinality  One To Zero or More 
Existence  Mandatory 
Propagated Key  Primary Key 

"MPS Chain to MPS Signal Parameter" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"MPS Chain to MPS Signal Parameter" Foreign Keys 
Parent Key  Child Key 
MPS Chain Id  MPS Chain Id 

"MPS Chain to MPS Signal Parameter" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"MPS Chain to MPS Signal Parameter" Bound Attachments 
Name  Current Value 


"Device to Device" 
RelationshipType  Non-Identifying 
Do Not Generate  False 
Relationship Name  PARENT_DVC_ID_DVC_RF 
Relationship Business Name   
Logical Only  No 
Parent Entity  Device 
Child Entity  Device 
Cardinality  Zero or One to Zero or More 
Existence  Optional 
Propagated Key  Primary Key 

"Device to Device" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"Device to Device" Foreign Keys 
Parent Key  Child Key 
Device Identifer  Parent Dvc Id 

"Device to Device" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"Device to Device" Bound Attachments 
Name  Current Value 


"MPS Chassis Serial Number to MPS Signal Parameter" 
RelationshipType  Non-Identifying 
Do Not Generate  False 
Relationship Name  SER_NBR_RF 
Relationship Business Name   
Logical Only  No 
Parent Entity  MPS Chassis Serial Number 
Child Entity  MPS Signal Parameter 
Cardinality  Zero or One to Zero or More 
Existence  Optional 
Propagated Key  Primary Key 

"MPS Chassis Serial Number to MPS Signal Parameter" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"MPS Chassis Serial Number to MPS Signal Parameter" Foreign Keys 
Parent Key  Child Key 
Ser Nbr  Ser Nbr 

"MPS Chassis Serial Number to MPS Signal Parameter" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"MPS Chassis Serial Number to MPS Signal Parameter" Bound Attachments 
Name  Current Value 


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

"Device to Signal" Relationship Description 
Verb Sentence 
 
Inverse Verb Sentence 
 
Definition 
 
Note   

"Device to Signal" Foreign Keys 
Parent Key  Child Key 
Device Identifer  Device Identifer 

"Device to Signal" Trigger Templates 
ParentInsert  None 
ParentUpdate  None 
ParentDelete  None 
ChildInsert  None 
ChildUpdate  None 
ChildDelete  None 

"Device to Signal" Bound Attachments 
Name  Current Value