"DVC to MACHINE_MODE" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | |
Relationship Business Name | |
Physical Only | No |
Parent Table | DVC |
Child Table | MACHINE_MODE |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"DVC to MACHINE_MODE" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"DVC to MACHINE_MODE" Foreign Keys |
Parent Key | Child Key |
DVC_ID | DVC_ID |
"DVC to MACHINE_MODE" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"DVC to MACHINE_MODE" Bound Attachments |
Name | Current Value |
"SGNL_REC to MPS_DAILY_STAT" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | |
Relationship Business Name | |
Physical Only | No |
Parent Table | SGNL_REC |
Child Table | MPS_DAILY_STAT |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"SGNL_REC to MPS_DAILY_STAT" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"SGNL_REC to MPS_DAILY_STAT" Foreign Keys |
Parent Key | Child Key |
SGNL_ID | SGNL_ID |
"SGNL_REC to MPS_DAILY_STAT" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"SGNL_REC to MPS_DAILY_STAT" Bound Attachments |
Name | Current Value |
"SGNL_REC to MPS_DAILY_STAT" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | |
Relationship Business Name | |
Physical Only | No |
Parent Table | SGNL_REC |
Child Table | MPS_DAILY_STAT |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"SGNL_REC to MPS_DAILY_STAT" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"SGNL_REC to MPS_DAILY_STAT" Foreign Keys |
Parent Key | Child Key |
SGNL_ID | MPS_INP_SGNL_ID |
"SGNL_REC to MPS_DAILY_STAT" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"SGNL_REC to MPS_DAILY_STAT" Bound Attachments |
Name | Current Value |
"DVC to EPICS_DVC_GRP_ITEM" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | DVC_EPICS_DVC_GRP_ITEM_RF |
Relationship Business Name | |
Physical Only | No |
Parent Table | DVC |
Child Table | EPICS_DVC_GRP_ITEM |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"DVC to EPICS_DVC_GRP_ITEM" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"DVC to EPICS_DVC_GRP_ITEM" Foreign Keys |
Parent Key | Child Key |
DVC_ID | DVC_ID |
"DVC to EPICS_DVC_GRP_ITEM" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"DVC to EPICS_DVC_GRP_ITEM" Bound Attachments |
Name | Current Value |
"DVC to DVC" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | DVC_PARENT_RF |
Relationship Business Name | |
Physical Only | No |
Parent Table | DVC |
Child Table | DVC |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"DVC to DVC" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"DVC to DVC" Foreign Keys |
Parent Key | Child Key |
DVC_ID | PARENT_DVC_ID |
"DVC to DVC" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"DVC to DVC" Bound Attachments |
Name | Current Value |
"DVC to SGNL_REC" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | DVC_SGNL_REC_RF |
Relationship Business Name | |
Physical Only | No |
Parent Table | DVC |
Child Table | SGNL_REC |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"DVC to SGNL_REC" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"DVC to SGNL_REC" Foreign Keys |
Parent Key | Child Key |
DVC_ID | DVC_ID |
"DVC to SGNL_REC" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"DVC to SGNL_REC" Bound Attachments |
Name | Current Value |
"EPICS_DVC_GRP_ITEM to SGNL_REC" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | EPICS_DVC_GRP_ITEM_SGNL_REC_RF |
Relationship Business Name | |
Physical Only | No |
Parent Table | EPICS_DVC_GRP_ITEM |
Child Table | SGNL_REC |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"EPICS_DVC_GRP_ITEM to SGNL_REC" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EPICS_DVC_GRP_ITEM to SGNL_REC" Foreign Keys |
Parent Key | Child Key |
EPICS_DVC_GRP_ID | EPICS_DVC_GRP_ID |
"EPICS_DVC_GRP_ITEM to SGNL_REC" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"EPICS_DVC_GRP_ITEM to SGNL_REC" Bound Attachments |
Name | Current Value |
"MPS_AUDIT_ERR_MSG to MPS_CHAN_AUDIT" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | FK_ERR_MSG |
Relationship Business Name | |
Physical Only | No |
Parent Table | MPS_AUDIT_ERR_MSG |
Child Table | MPS_CHAN_AUDIT |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"MPS_AUDIT_ERR_MSG to MPS_CHAN_AUDIT" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"MPS_AUDIT_ERR_MSG to MPS_CHAN_AUDIT" Foreign Keys |
Parent Key | Child Key |
ERR_NBR | ERR_NBR |
"MPS_AUDIT_ERR_MSG to MPS_CHAN_AUDIT" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"MPS_AUDIT_ERR_MSG to MPS_CHAN_AUDIT" Bound Attachments |
Name | Current Value |
"MACHINE_MODE to MPS_CHAN_AUDIT" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_MACHINE_MODE |
Relationship Business Name | |
Physical Only | No |
Parent Table | MACHINE_MODE |
Child Table | MPS_CHAN_AUDIT |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"MACHINE_MODE to MPS_CHAN_AUDIT" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"MACHINE_MODE to MPS_CHAN_AUDIT" Foreign Keys |
Parent Key | Child Key |
DVC_ID, APPR_DTE, CHANNEL_NBR | DVC_ID, APPR_DTE, CHANNEL_NBR |
"MACHINE_MODE to MPS_CHAN_AUDIT" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"MACHINE_MODE to MPS_CHAN_AUDIT" Bound Attachments |
Name | Current Value |
"MACHINE_MODE to MPS_BLM_PARAM" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_MBP_MACHINE_MODE |
Relationship Business Name | |
Physical Only | No |
Parent Table | MACHINE_MODE |
Child Table | MPS_BLM_PARAM |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"MACHINE_MODE to MPS_BLM_PARAM" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"MACHINE_MODE to MPS_BLM_PARAM" Foreign Keys |
Parent Key | Child Key |
DVC_ID, APPR_DTE, CHANNEL_NBR | DVC_ID, APPR_DTE, CHANNEL_NBR |
"MACHINE_MODE to MPS_BLM_PARAM" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"MACHINE_MODE to MPS_BLM_PARAM" Bound Attachments |
Name | Current Value |
"MPS_CHAIN to MPS_SGNL_PARAM" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | MPS_CHAIN_SGNL_PARAM_RF |
Relationship Business Name | |
Physical Only | No |
Parent Table | MPS_CHAIN |
Child Table | MPS_SGNL_PARAM |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"MPS_CHAIN to MPS_SGNL_PARAM" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"MPS_CHAIN to MPS_SGNL_PARAM" Foreign Keys |
Parent Key | Child Key |
MPS_CHAIN_ID | MPS_CHAIN_ID |
"MPS_CHAIN to MPS_SGNL_PARAM" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"MPS_CHAIN to MPS_SGNL_PARAM" Bound Attachments |
Name | Current Value |
"DVC to MACHINE_MODE" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | MPS_DVC_ID_DVC_FK |
Relationship Business Name | |
Physical Only | No |
Parent Table | DVC |
Child Table | MACHINE_MODE |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"DVC to MACHINE_MODE" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"DVC to MACHINE_MODE" Foreign Keys |
Parent Key | Child Key |
DVC_ID | MPS_DVC_ID |
"DVC to MACHINE_MODE" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"DVC to MACHINE_MODE" Bound Attachments |
Name | Current Value |
"DVC to MPS_SGNL_PARAM" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | MPS_SGNL_PARAM_DVC_RF |
Relationship Business Name | |
Physical Only | No |
Parent Table | DVC |
Child Table | MPS_SGNL_PARAM |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"DVC to MPS_SGNL_PARAM" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"DVC to MPS_SGNL_PARAM" Foreign Keys |
Parent Key | Child Key |
DVC_ID | DVC_ID |
"DVC to MPS_SGNL_PARAM" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"DVC to MPS_SGNL_PARAM" Bound Attachments |
Name | Current Value |
"MPS_SGNL_PARAM to MACHINE_MODE" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | MPS_SGNL_PARAM_MACH_MODE_RF |
Relationship Business Name | |
Physical Only | No |
Parent Table | MPS_SGNL_PARAM |
Child Table | MACHINE_MODE |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"MPS_SGNL_PARAM to MACHINE_MODE" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"MPS_SGNL_PARAM to MACHINE_MODE" Foreign Keys |
Parent Key | Child Key |
DVC_ID, APPR_DTE | DVC_ID, APPR_DTE |
"MPS_SGNL_PARAM to MACHINE_MODE" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"MPS_SGNL_PARAM to MACHINE_MODE" Bound Attachments |
Name | Current Value |
"DVC to SGNL" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | SGNL_DVC_RF |
Relationship Business Name | |
Physical Only | No |
Parent Table | DVC |
Child Table | SGNL |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"DVC to SGNL" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"DVC to SGNL" Foreign Keys |
Parent Key | Child Key |
DVC_ID | DVC_ID |
"DVC to SGNL" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"DVC to SGNL" Bound Attachments |
Name | Current Value |
"SGNL_REC to SGNL" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | SGNL_REC_SGNL_RF |
Relationship Business Name | |
Physical Only | No |
Parent Table | SGNL_REC |
Child Table | SGNL |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"SGNL_REC to SGNL" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"SGNL_REC to SGNL" Foreign Keys |
Parent Key | Child Key |
SGNL_ID | SGNL_ID |
"SGNL_REC to SGNL" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"SGNL_REC to SGNL" Bound Attachments |
Name | Current Value |