"DVC to MAG_DVC" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | |
Relationship Business Name | |
Physical Only | No |
Parent Table | DVC |
Child Table | MAG_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 MAG_DVC" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"DVC to MAG_DVC" Foreign Keys |
Parent Key | Child Key |
DVC_ID | PS_DVC_ID |
"DVC to MAG_DVC" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"DVC to MAG_DVC" Bound Attachments |
Name | Current Value |
"DVC_SEQ_NM to BEAM_LINE_DVC_LOC" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | |
Relationship Business Name | |
Physical Only | No |
Parent Table | DVC_SEQ_NM |
Child Table | BEAM_LINE_DVC_LOC |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"DVC_SEQ_NM to BEAM_LINE_DVC_LOC" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"DVC_SEQ_NM to BEAM_LINE_DVC_LOC" Foreign Keys |
Parent Key | Child Key |
Seq Nm | Seq Nm |
"DVC_SEQ_NM to BEAM_LINE_DVC_LOC" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"DVC_SEQ_NM to BEAM_LINE_DVC_LOC" Bound Attachments |
Name | Current Value |
"DVC to BEAM_LINE_DVC_LOC" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | BEAM_LINE_DVC_DVC_RF |
Relationship Business Name | |
Physical Only | No |
Parent Table | DVC |
Child Table | BEAM_LINE_DVC_LOC |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"DVC to BEAM_LINE_DVC_LOC" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"DVC to BEAM_LINE_DVC_LOC" Foreign Keys |
Parent Key | Child Key |
DVC_ID | DVC_ID |
"DVC to BEAM_LINE_DVC_LOC" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"DVC to BEAM_LINE_DVC_LOC" Bound Attachments |
Name | Current Value |
"DVC to DVC_SETTING" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | dvc_dvc_setting_rf |
Relationship Business Name | |
Physical Only | No |
Parent Table | DVC |
Child Table | DVC_SETTING |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"DVC to DVC_SETTING" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"DVC to DVC_SETTING" Foreign Keys |
Parent Key | Child Key |
DVC_ID | DVC_ID |
"DVC to DVC_SETTING" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"DVC to DVC_SETTING" 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 | Zero or One to Zero or More |
Existence | Optional |
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 |
"EQUIP to Equip_Dvc_Asgn" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | equip_dvc_asgn2_rf |
Relationship Business Name | |
Physical Only | No |
Parent Table | EQUIP |
Child Table | Equip_Dvc_Asgn |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"EQUIP to Equip_Dvc_Asgn" Relationship Description |
Verb Sentence | An EQUIP is involved in Equip_Dvc_Asgn(s). |
Inverse Verb Sentence | An Equip_Dvc_Asgn uses EQUIP. |
Definition | |
Note |
"EQUIP to Equip_Dvc_Asgn" Foreign Keys |
Parent Key | Child Key |
Equip Id | Equip Id |
"EQUIP to Equip_Dvc_Asgn" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"EQUIP to Equip_Dvc_Asgn" Bound Attachments |
Name | Current Value |
"DVC to Equip_Dvc_Asgn" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | equip_dvc_asgn_rf |
Relationship Business Name | |
Physical Only | No |
Parent Table | DVC |
Child Table | Equip_Dvc_Asgn |
Cardinality | One to One or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"DVC to Equip_Dvc_Asgn" Relationship Description |
Verb Sentence | A DVC is involved in Equip_Dvc_Asgn(s). |
Inverse Verb Sentence | An Equip_Dvc_Asgn requires a DVC. |
Definition | |
Note |
"DVC to Equip_Dvc_Asgn" Foreign Keys |
Parent Key | Child Key |
DVC_ID | DVC_ID |
"DVC to Equip_Dvc_Asgn" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"DVC to Equip_Dvc_Asgn" Bound Attachments |
Name | Current Value |
"DVC to Func_Dvc_Grp_Item" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | func_dvc_grp_item2_rf |
Relationship Business Name | |
Physical Only | No |
Parent Table | DVC |
Child Table | Func_Dvc_Grp_Item |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"DVC to Func_Dvc_Grp_Item" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"DVC to Func_Dvc_Grp_Item" Foreign Keys |
Parent Key | Child Key |
DVC_ID | Related Dvc |
"DVC to Func_Dvc_Grp_Item" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"DVC to Func_Dvc_Grp_Item" Bound Attachments |
Name | Current Value |
"DVC to Func_Dvc_Grp_Item" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | func_dvc_grp_item_rf |
Relationship Business Name | |
Physical Only | No |
Parent Table | DVC |
Child Table | Func_Dvc_Grp_Item |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"DVC to Func_Dvc_Grp_Item" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"DVC to Func_Dvc_Grp_Item" Foreign Keys |
Parent Key | Child Key |
DVC_ID | DVC_ID |
"DVC to Func_Dvc_Grp_Item" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"DVC to Func_Dvc_Grp_Item" Bound Attachments |
Name | Current Value |
"DVC to MAG_DVC" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | MAG_DVC_DVC_RF |
Relationship Business Name | |
Physical Only | No |
Parent Table | DVC |
Child Table | MAG_DVC |
Cardinality | One to Zero or One |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"DVC to MAG_DVC" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"DVC to MAG_DVC" Foreign Keys |
Parent Key | Child Key |
DVC_ID | DVC_ID |
"DVC to MAG_DVC" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"DVC to MAG_DVC" Bound Attachments |
Name | Current Value |
"DVC to DVC" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | PARENT_DVC_ID_DVC_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 |
"EQUIP to EQUIP" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | parent_equip_rf |
Relationship Business Name | |
Physical Only | No |
Parent Table | EQUIP |
Child Table | EQUIP |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"EQUIP to EQUIP" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EQUIP to EQUIP" Foreign Keys |
Parent Key | Child Key |
Equip Id | Parent Equipment ID |
"EQUIP to EQUIP" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"EQUIP to EQUIP" Bound Attachments |
Name | Current Value |
"DVC to RF_Cav_Dvc" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | RF_CAV_DVC_DVC_RF |
Relationship Business Name | |
Physical Only | No |
Parent Table | DVC |
Child Table | RF_Cav_Dvc |
Cardinality | One to Zero or One |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"DVC to RF_Cav_Dvc" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"DVC to RF_Cav_Dvc" Foreign Keys |
Parent Key | Child Key |
DVC_ID | DVC_ID |
"DVC to RF_Cav_Dvc" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"DVC to RF_Cav_Dvc" Bound Attachments |
Name | Current Value |
"RF_Cav_Dvc to RF_Gap" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | rf_cav_dvc_rf_gap_rf |
Relationship Business Name | |
Physical Only | No |
Parent Table | RF_Cav_Dvc |
Child Table | RF_Gap |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"RF_Cav_Dvc to RF_Gap" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"RF_Cav_Dvc to RF_Gap" Foreign Keys |
Parent Key | Child Key |
DVC_ID | DVC_ID |
"RF_Cav_Dvc to RF_Gap" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"RF_Cav_Dvc to RF_Gap" Bound Attachments |
Name | Current Value |