"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 |