"ARCH_GRP to ARCH_REQ_GRP" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | ARCH_GRP_FILE_NM_ARCH_GRP_FK |
Relationship Business Name | |
Physical Only | No |
Parent Table | ARCH_GRP |
Child Table | ARCH_REQ_GRP |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"ARCH_GRP to ARCH_REQ_GRP" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"ARCH_GRP to ARCH_REQ_GRP" Foreign Keys |
Parent Key | Child Key |
ARCH_GRP_FILE_NM | ARCH_GRP_FILE_NM |
"ARCH_GRP to ARCH_REQ_GRP" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"ARCH_GRP to ARCH_REQ_GRP" Bound Attachments |
Name | Current Value |
"ARCH_REQ to ARCH_REQ_GRP" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | ARCH_REQ_FILE_NM_ARCH_REQ_FK |
Relationship Business Name | |
Physical Only | No |
Parent Table | ARCH_REQ |
Child Table | ARCH_REQ_GRP |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"ARCH_REQ to ARCH_REQ_GRP" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"ARCH_REQ to ARCH_REQ_GRP" Foreign Keys |
Parent Key | Child Key |
ARCH_REQ_FILE_NM | ARCH_REQ_FILE_NM |
"ARCH_REQ to ARCH_REQ_GRP" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"ARCH_REQ to ARCH_REQ_GRP" 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 BEAM_LINE_DVC_ENERGY" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | BEAM_LINE_DVC_ENERGY_DVC_RF |
Relationship Business Name | |
Physical Only | No |
Parent Table | DVC |
Child Table | BEAM_LINE_DVC_ENERGY |
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_ENERGY" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"DVC to BEAM_LINE_DVC_ENERGY" Foreign Keys |
Parent Key | Child Key |
DVC_ID | DVC_ID |
"DVC to BEAM_LINE_DVC_ENERGY" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"DVC to BEAM_LINE_DVC_ENERGY" Bound Attachments |
Name | Current Value |
"SCENARIO_TYPE to BEAM_LINE_DVC_ENERGY" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | BEAM_LINE_DVC_ENERGY_SCEN_RF |
Relationship Business Name | |
Physical Only | No |
Parent Table | SCENARIO_TYPE |
Child Table | BEAM_LINE_DVC_ENERGY |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"SCENARIO_TYPE to BEAM_LINE_DVC_ENERGY" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"SCENARIO_TYPE to BEAM_LINE_DVC_ENERGY" Foreign Keys |
Parent Key | Child Key |
SCENARIO_ID | SCENARIO_ID |
"SCENARIO_TYPE to BEAM_LINE_DVC_ENERGY" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"SCENARIO_TYPE to BEAM_LINE_DVC_ENERGY" Bound Attachments |
Name | Current Value |
"DVC to BPM_DVC" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | BPM_DVC_DVC_RF |
Relationship Business Name | |
Physical Only | No |
Parent Table | DVC |
Child Table | BPM_DVC |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"DVC to BPM_DVC" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"DVC to BPM_DVC" Foreign Keys |
Parent Key | Child Key |
DVC_ID | DVC_ID |
"DVC to BPM_DVC" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"DVC to BPM_DVC" Bound Attachments |
Name | Current Value |
"BYPASS_REQ to BYPASS_DVC_AFF" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | BYPASS_AFF_DVC_BYPASS_REQ_FK |
Relationship Business Name | |
Physical Only | No |
Parent Table | BYPASS_REQ |
Child Table | BYPASS_DVC_AFF |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"BYPASS_REQ to BYPASS_DVC_AFF" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"BYPASS_REQ to BYPASS_DVC_AFF" Foreign Keys |
Parent Key | Child Key |
BYPASS_NBR | BYPASS_NBR |
"BYPASS_REQ to BYPASS_DVC_AFF" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"BYPASS_REQ to BYPASS_DVC_AFF" Bound Attachments |
Name | Current Value |
"BYPASS_REQ to BYPASS_AFF_SGNL" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | BYPASS_AFF_SGNL |
Relationship Business Name | |
Physical Only | No |
Parent Table | BYPASS_REQ |
Child Table | BYPASS_AFF_SGNL |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"BYPASS_REQ to BYPASS_AFF_SGNL" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"BYPASS_REQ to BYPASS_AFF_SGNL" Foreign Keys |
Parent Key | Child Key |
BYPASS_NBR | BYPASS_NBR |
"BYPASS_REQ to BYPASS_AFF_SGNL" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"BYPASS_REQ to BYPASS_AFF_SGNL" Bound Attachments |
Name | Current Value |
"BYPASS_MECH to BYPASS_REQ" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | BYPASS_REQ_BYPASS_MECH_FK |
Relationship Business Name | |
Physical Only | No |
Parent Table | BYPASS_MECH |
Child Table | BYPASS_REQ |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"BYPASS_MECH to BYPASS_REQ" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"BYPASS_MECH to BYPASS_REQ" Foreign Keys |
Parent Key | Child Key |
BYPASS_MECH_NM | BYPASS_MECH_NM |
"BYPASS_MECH to BYPASS_REQ" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"BYPASS_MECH to BYPASS_REQ" Bound Attachments |
Name | Current Value |
"SUBSYS to BYPASS_REQ" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | BYPASS_REQ_SUBSYS_FK |
Relationship Business Name | |
Physical Only | No |
Parent Table | SUBSYS |
Child Table | BYPASS_REQ |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"SUBSYS to BYPASS_REQ" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"SUBSYS to BYPASS_REQ" Foreign Keys |
Parent Key | Child Key |
SUBSYS_ID | SUBSYS_ID |
"SUBSYS to BYPASS_REQ" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"SUBSYS to BYPASS_REQ" Bound Attachments |
Name | Current Value |
"SYST to BYPASS_REQ" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | BYPASS_REQ_SYS_FK |
Relationship Business Name | |
Physical Only | No |
Parent Table | SYST |
Child Table | BYPASS_REQ |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"SYST to BYPASS_REQ" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"SYST to BYPASS_REQ" Foreign Keys |
Parent Key | Child Key |
SYS_ID | SYS_ID |
"SYST to BYPASS_REQ" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"SYST to BYPASS_REQ" Bound Attachments |
Name | Current Value |
"DVC to CAB_NOID_DVC" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | CAB_NOID_DVC_DVC_RF |
Relationship Business Name | |
Physical Only | No |
Parent Table | DVC |
Child Table | CAB_NOID_DVC |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"DVC to CAB_NOID_DVC" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"DVC to CAB_NOID_DVC" Foreign Keys |
Parent Key | Child Key |
DVC_ID | PARENT_DVC_ID |
"DVC to CAB_NOID_DVC" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"DVC to CAB_NOID_DVC" Bound Attachments |
Name | Current Value |
"DVC_TYPE_SFTW to DVC_DVC_TYPE_SFTW_ASSC" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | ddtsa_to_dvc_type_sftw |
Relationship Business Name | |
Physical Only | No |
Parent Table | DVC_TYPE_SFTW |
Child Table | DVC_DVC_TYPE_SFTW_ASSC |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"DVC_TYPE_SFTW to DVC_DVC_TYPE_SFTW_ASSC" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"DVC_TYPE_SFTW to DVC_DVC_TYPE_SFTW_ASSC" Foreign Keys |
Parent Key | Child Key |
DVC_TYPE_ID, SFTW_ID | DVC_TYPE_ID, SFTW_ID |
"DVC_TYPE_SFTW to DVC_DVC_TYPE_SFTW_ASSC" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"DVC_TYPE_SFTW to DVC_DVC_TYPE_SFTW_ASSC" 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_TYPE to DVC" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | DVC_DVC_TYPE_ID_RF |
Relationship Business Name | |
Physical Only | No |
Parent Table | DVC_TYPE |
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_TYPE to DVC" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"DVC_TYPE to DVC" Foreign Keys |
Parent Key | Child Key |
DVC_TYPE_ID | DVC_TYPE_ID |
"DVC_TYPE to DVC" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"DVC_TYPE to DVC" Bound Attachments |
Name | Current Value |
"DVC to EPICS_GRP" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | DVC_EPICS_GRP_RF |
Relationship Business Name | |
Physical Only | No |
Parent Table | DVC |
Child Table | EPICS_GRP |
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_GRP" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"DVC to EPICS_GRP" Foreign Keys |
Parent Key | Child Key |
DVC_ID | IOC_DVC_ID |
"DVC to EPICS_GRP" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"DVC to EPICS_GRP" Bound Attachments |
Name | Current Value |
"DVC to DVC_PHYS_LOC" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | DVC_PHYS_LOC_DVC_FK |
Relationship Business Name | |
Physical Only | No |
Parent Table | DVC |
Child Table | DVC_PHYS_LOC |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"DVC to DVC_PHYS_LOC" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"DVC to DVC_PHYS_LOC" Foreign Keys |
Parent Key | Child Key |
DVC_ID | DVC_ID |
"DVC to DVC_PHYS_LOC" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"DVC to DVC_PHYS_LOC" 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 |
"SUBSYS to DVC" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | DVC_SUBSYS_RF |
Relationship Business Name | |
Physical Only | No |
Parent Table | SUBSYS |
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 |
"SUBSYS to DVC" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"SUBSYS to DVC" Foreign Keys |
Parent Key | Child Key |
SUBSYS_ID | SUBSYS_ID |
"SUBSYS to DVC" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"SUBSYS to DVC" Bound Attachments |
Name | Current Value |
"SYST to DVC" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | DVC_SYS_RF |
Relationship Business Name | |
Physical Only | No |
Parent Table | SYST |
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 |
"SYST to DVC" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"SYST to DVC" Foreign Keys |
Parent Key | Child Key |
SYS_ID | SYS_ID |
"SYST to DVC" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"SYST to DVC" Bound Attachments |
Name | Current Value |
"DVC_TYPE_SGNL to SGNL_GRP_ITEM" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | DVC_TYP_SGNL_SGNL_GRP_ITEM_RF |
Relationship Business Name | |
Physical Only | No |
Parent Table | DVC_TYPE_SGNL |
Child Table | SGNL_GRP_ITEM |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"DVC_TYPE_SGNL to SGNL_GRP_ITEM" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"DVC_TYPE_SGNL to SGNL_GRP_ITEM" Foreign Keys |
Parent Key | Child Key |
DVC_TYPE_ID, DVC_TYPE_SGNL_NM | DVC_TYPE_ID, DVC_TYPE_SGNL_NM |
"DVC_TYPE_SGNL to SGNL_GRP_ITEM" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"DVC_TYPE_SGNL to SGNL_GRP_ITEM" Bound Attachments |
Name | Current Value |
"DVC_TYPE to DVC_TYPE_SFTW" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | dvc_type_sftw_to_dvc_type |
Relationship Business Name | |
Physical Only | No |
Parent Table | DVC_TYPE |
Child Table | DVC_TYPE_SFTW |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"DVC_TYPE to DVC_TYPE_SFTW" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"DVC_TYPE to DVC_TYPE_SFTW" Foreign Keys |
Parent Key | Child Key |
DVC_TYPE_ID | DVC_TYPE_ID |
"DVC_TYPE to DVC_TYPE_SFTW" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"DVC_TYPE to DVC_TYPE_SFTW" Bound Attachments |
Name | Current Value |
"DVC_TYPE to DVC_TYPE_SGNL" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | DVC_TYPE_SGNL_RF |
Relationship Business Name | |
Physical Only | No |
Parent Table | DVC_TYPE |
Child Table | DVC_TYPE_SGNL |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"DVC_TYPE to DVC_TYPE_SGNL" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"DVC_TYPE to DVC_TYPE_SGNL" Foreign Keys |
Parent Key | Child Key |
DVC_TYPE_ID | DVC_TYPE_ID |
"DVC_TYPE to DVC_TYPE_SGNL" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"DVC_TYPE to DVC_TYPE_SGNL" Bound Attachments |
Name | Current Value |
"BYPASS_REQ to BYPASS_ELOG_NOTIF" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | ELOG_NOTIF_BYPASS_REQ_FK |
Relationship Business Name | |
Physical Only | No |
Parent Table | BYPASS_REQ |
Child Table | BYPASS_ELOG_NOTIF |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"BYPASS_REQ to BYPASS_ELOG_NOTIF" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"BYPASS_REQ to BYPASS_ELOG_NOTIF" Foreign Keys |
Parent Key | Child Key |
BYPASS_NBR | BYPASS_NBR |
"BYPASS_REQ to BYPASS_ELOG_NOTIF" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"BYPASS_REQ to BYPASS_ELOG_NOTIF" Bound Attachments |
Name | Current Value |
"BYPASS_REQ to BYPASS_EMAIL_NOTIF" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | EMAIL_NOTIF_BYPASS_REQ_FK |
Relationship Business Name | |
Physical Only | No |
Parent Table | BYPASS_REQ |
Child Table | BYPASS_EMAIL_NOTIF |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"BYPASS_REQ to BYPASS_EMAIL_NOTIF" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"BYPASS_REQ to BYPASS_EMAIL_NOTIF" Foreign Keys |
Parent Key | Child Key |
BYPASS_NBR | BYPASS_NBR |
"BYPASS_REQ to BYPASS_EMAIL_NOTIF" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"BYPASS_REQ to BYPASS_EMAIL_NOTIF" Bound Attachments |
Name | Current Value |
"EPICS_GRP to SGNL_REC" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | EPICS_GRP_SGNL_REC_RF |
Relationship Business Name | |
Physical Only | No |
Parent Table | EPICS_GRP |
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_GRP to SGNL_REC" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EPICS_GRP to SGNL_REC" Foreign Keys |
Parent Key | Child Key |
EPICS_GRP_ID | EPICS_GRP_ID |
"EPICS_GRP to SGNL_REC" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"EPICS_GRP to SGNL_REC" Bound Attachments |
Name | Current Value |
"EPICS_VER to EPICS_LIBOBJS" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | EPICS_VER_EPIC_VER_FK |
Relationship Business Name | |
Physical Only | No |
Parent Table | EPICS_VER |
Child Table | EPICS_LIBOBJS |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"EPICS_VER to EPICS_LIBOBJS" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EPICS_VER to EPICS_LIBOBJS" Foreign Keys |
Parent Key | Child Key |
EPICS_VER | EPICS_VER |
"EPICS_VER to EPICS_LIBOBJS" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"EPICS_VER to EPICS_LIBOBJS" Bound Attachments |
Name | Current Value |
"SGNL_REC to ALARM_LOG" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_ALARM_LOG_SGNL_REC |
Relationship Business Name | |
Physical Only | No |
Parent Table | SGNL_REC |
Child Table | ALARM_LOG |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"SGNL_REC to ALARM_LOG" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"SGNL_REC to ALARM_LOG" Foreign Keys |
Parent Key | Child Key |
SGNL_ID | SGNL_ID |
"SGNL_REC to ALARM_LOG" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"SGNL_REC to ALARM_LOG" Bound Attachments |
Name | Current Value |
"SGNL_REC to CHMK_DAILY_STAT" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_CHMK_DAILY_STAT_SGNL_REC |
Relationship Business Name | |
Physical Only | No |
Parent Table | SGNL_REC |
Child Table | CHMK_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 CHMK_DAILY_STAT" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"SGNL_REC to CHMK_DAILY_STAT" Foreign Keys |
Parent Key | Child Key |
SGNL_ID | SGNL_ID |
"SGNL_REC to CHMK_DAILY_STAT" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"SGNL_REC to CHMK_DAILY_STAT" Bound Attachments |
Name | Current Value |
"DVC to CHMK_DVC" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_CHMK_DVC_TO_DVC |
Relationship Business Name | |
Physical Only | No |
Parent Table | DVC |
Child Table | CHMK_DVC |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"DVC to CHMK_DVC" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"DVC to CHMK_DVC" Foreign Keys |
Parent Key | Child Key |
DVC_ID | DVC_ID |
"DVC to CHMK_DVC" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"DVC to CHMK_DVC" Bound Attachments |
Name | Current Value |
"DVC to DVC_DVC_TYPE_SFTW_ASSC" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_ddtsa_to_dvc |
Relationship Business Name | |
Physical Only | No |
Parent Table | DVC |
Child Table | DVC_DVC_TYPE_SFTW_ASSC |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"DVC to DVC_DVC_TYPE_SFTW_ASSC" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"DVC to DVC_DVC_TYPE_SFTW_ASSC" Foreign Keys |
Parent Key | Child Key |
DVC_ID | DVC_ID |
"DVC to DVC_DVC_TYPE_SFTW_ASSC" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"DVC to DVC_DVC_TYPE_SFTW_ASSC" Bound Attachments |
Name | Current Value |
"SGNL_REC to DUPL_SGNL" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_DUPL_SGNL_SGNL_REC |
Relationship Business Name | |
Physical Only | No |
Parent Table | SGNL_REC |
Child Table | DUPL_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 DUPL_SGNL" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"SGNL_REC to DUPL_SGNL" Foreign Keys |
Parent Key | Child Key |
SGNL_ID | SGNL_ID |
"SGNL_REC to DUPL_SGNL" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"SGNL_REC to DUPL_SGNL" Bound Attachments |
Name | Current Value |
"DVC_CRIT to DVC" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | FK_DVC_DVC_CRIT |
Relationship Business Name | |
Physical Only | No |
Parent Table | DVC_CRIT |
Child Table | DVC |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"DVC_CRIT to DVC" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"DVC_CRIT to DVC" Foreign Keys |
Parent Key | Child Key |
CRIT_ID | CRIT_ID |
"DVC_CRIT to DVC" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"DVC_CRIT to DVC" Bound Attachments |
Name | Current Value |
"DVC to DVC_PORT_ASGN" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_DVC_ID_DVC |
Relationship Business Name | |
Physical Only | No |
Parent Table | DVC |
Child Table | DVC_PORT_ASGN |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"DVC to DVC_PORT_ASGN" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"DVC to DVC_PORT_ASGN" Foreign Keys |
Parent Key | Child Key |
DVC_ID | DVC_ID |
"DVC to DVC_PORT_ASGN" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"DVC to DVC_PORT_ASGN" 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 |
"DVC to ICS_COMM_DVC" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_ICS_COMM_DVC_DVC |
Relationship Business Name | |
Physical Only | No |
Parent Table | DVC |
Child Table | ICS_COMM_DVC |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"DVC to ICS_COMM_DVC" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"DVC to ICS_COMM_DVC" Foreign Keys |
Parent Key | Child Key |
DVC_ID | DVC_ID |
"DVC to ICS_COMM_DVC" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | Cascade |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"DVC to ICS_COMM_DVC" Bound Attachments |
Name | Current Value |
"DVC to ICS_COMM_OPER_ENV" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_ICS_COMM_OPER_ENV_DVC |
Relationship Business Name | |
Physical Only | No |
Parent Table | DVC |
Child Table | ICS_COMM_OPER_ENV |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"DVC to ICS_COMM_OPER_ENV" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"DVC to ICS_COMM_OPER_ENV" Foreign Keys |
Parent Key | Child Key |
DVC_ID | DVC_ID |
"DVC to ICS_COMM_OPER_ENV" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"DVC to ICS_COMM_OPER_ENV" Bound Attachments |
Name | Current Value |
"DVC to IOC_CONFIG_FILE" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_IOC_CONFIG_FILE_DVC |
Relationship Business Name | |
Physical Only | No |
Parent Table | DVC |
Child Table | IOC_CONFIG_FILE |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"DVC to IOC_CONFIG_FILE" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"DVC to IOC_CONFIG_FILE" Foreign Keys |
Parent Key | Child Key |
DVC_ID | DVC_ID |
"DVC to IOC_CONFIG_FILE" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"DVC to IOC_CONFIG_FILE" Bound Attachments |
Name | Current Value |
"DVC to IOC_DBD_FILE_ASGN" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_IOC_DBD_FL_AS_DVC |
Relationship Business Name | |
Physical Only | No |
Parent Table | DVC |
Child Table | IOC_DBD_FILE_ASGN |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"DVC to IOC_DBD_FILE_ASGN" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"DVC to IOC_DBD_FILE_ASGN" Foreign Keys |
Parent Key | Child Key |
DVC_ID | DVC_ID |
"DVC to IOC_DBD_FILE_ASGN" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"DVC to IOC_DBD_FILE_ASGN" Bound Attachments |
Name | Current Value |
"DVC to IOC_DVC" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_IOC_DVC_DVC |
Relationship Business Name | |
Physical Only | No |
Parent Table | DVC |
Child Table | IOC_DVC |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"DVC to IOC_DVC" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"DVC to IOC_DVC" Foreign Keys |
Parent Key | Child Key |
DVC_ID | DVC_ID |
"DVC to IOC_DVC" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | Cascade |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"DVC to IOC_DVC" Bound Attachments |
Name | Current Value |
"IOC_CONFIG_TYPE to IOC_DVC" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | FK_IOC_DVC_ICT |
Relationship Business Name | |
Physical Only | No |
Parent Table | IOC_CONFIG_TYPE |
Child Table | IOC_DVC |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"IOC_CONFIG_TYPE to IOC_DVC" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"IOC_CONFIG_TYPE to IOC_DVC" Foreign Keys |
Parent Key | Child Key |
IOC_CONFIG_TYPE_ID | IOC_CONFIG_TYPE_ID |
"IOC_CONFIG_TYPE to IOC_DVC" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"IOC_CONFIG_TYPE to IOC_DVC" Bound Attachments |
Name | Current Value |
"DVC to IOC_ERROR_LOG" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | FK_IOC_ERROR_LOG_DVC |
Relationship Business Name | |
Physical Only | No |
Parent Table | DVC |
Child Table | IOC_ERROR_LOG |
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 IOC_ERROR_LOG" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"DVC to IOC_ERROR_LOG" Foreign Keys |
Parent Key | Child Key |
DVC_ID | DVC_ID |
"DVC to IOC_ERROR_LOG" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"DVC to IOC_ERROR_LOG" Bound Attachments |
Name | Current Value |
"IOC_BOOT_HIST to IOC_SFTW" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_IOC_SFTW_IOC_BOOT_HIST |
Relationship Business Name | |
Physical Only | No |
Parent Table | IOC_BOOT_HIST |
Child Table | IOC_SFTW |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"IOC_BOOT_HIST to IOC_SFTW" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"IOC_BOOT_HIST to IOC_SFTW" Foreign Keys |
Parent Key | Child Key |
DVC_ID, BOOT_DTE | DVC_ID, BOOT_DTE |
"IOC_BOOT_HIST to IOC_SFTW" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"IOC_BOOT_HIST to IOC_SFTW" Bound Attachments |
Name | Current Value |
"MACH_SNAPSHOT_SVC to MACH_SNAPSHOT_TYPE" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | FK_MACH_SNAP_TYPE_SVC |
Relationship Business Name | |
Physical Only | No |
Parent Table | MACH_SNAPSHOT_SVC |
Child Table | MACH_SNAPSHOT_TYPE |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"MACH_SNAPSHOT_SVC to MACH_SNAPSHOT_TYPE" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"MACH_SNAPSHOT_SVC to MACH_SNAPSHOT_TYPE" Foreign Keys |
Parent Key | Child Key |
SVC_ID | SVC_ID |
"MACH_SNAPSHOT_SVC to MACH_SNAPSHOT_TYPE" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"MACH_SNAPSHOT_SVC to MACH_SNAPSHOT_TYPE" Bound Attachments |
Name | Current Value |
"MACH_SNAPSHOT to MACH_SNAPSHOT_SGNL_PERM_RET" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_MACH_SNAPSHOT_SGNL_PR_MACH |
Relationship Business Name | |
Physical Only | No |
Parent Table | MACH_SNAPSHOT |
Child Table | MACH_SNAPSHOT_SGNL_PERM_RET |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"MACH_SNAPSHOT to MACH_SNAPSHOT_SGNL_PERM_RET" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"MACH_SNAPSHOT to MACH_SNAPSHOT_SGNL_PERM_RET" Foreign Keys |
Parent Key | Child Key |
SNAPSHOT_ID | SNAPSHOT_ID |
"MACH_SNAPSHOT to MACH_SNAPSHOT_SGNL_PERM_RET" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"MACH_SNAPSHOT to MACH_SNAPSHOT_SGNL_PERM_RET" 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 |
"SGNL_REC to MPS_DAILY_STAT" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_MDS_TO_SGNL_REC |
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 |
"MSG_PROPERTY_TYPE to MESSAGE_CONTENT" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | FK_MSG_CONT_TO_MSG_PROP_TYPE |
Relationship Business Name | |
Physical Only | No |
Parent Table | MSG_PROPERTY_TYPE |
Child Table | MESSAGE_CONTENT |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"MSG_PROPERTY_TYPE to MESSAGE_CONTENT" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"MSG_PROPERTY_TYPE to MESSAGE_CONTENT" Foreign Keys |
Parent Key | Child Key |
ID | MSG_PROPERTY_TYPE_ID |
"MSG_PROPERTY_TYPE to MESSAGE_CONTENT" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"MSG_PROPERTY_TYPE to MESSAGE_CONTENT" Bound Attachments |
Name | Current Value |
"MESSAGE to MESSAGE_CONTENT" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | FK_MSG_CONTENT_TO_MSG |
Relationship Business Name | |
Physical Only | No |
Parent Table | MESSAGE |
Child Table | MESSAGE_CONTENT |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"MESSAGE to MESSAGE_CONTENT" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"MESSAGE to MESSAGE_CONTENT" Foreign Keys |
Parent Key | Child Key |
ID | MESSAGE_ID |
"MESSAGE to MESSAGE_CONTENT" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"MESSAGE to MESSAGE_CONTENT" Bound Attachments |
Name | Current Value |
"MSG_TYPE to MESSAGE" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | FK_MSG_TO_MSG_TYPE |
Relationship Business Name | |
Physical Only | No |
Parent Table | MSG_TYPE |
Child Table | MESSAGE |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"MSG_TYPE to MESSAGE" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"MSG_TYPE to MESSAGE" Foreign Keys |
Parent Key | Child Key |
ID | MSG_TYPE_ID |
"MSG_TYPE to MESSAGE" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"MSG_TYPE to MESSAGE" Bound Attachments |
Name | Current Value |
"MSG_PROPERTY_TYPE to MSG_TYPE_PROPERTY_TYPE" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | FK_MSG_TYPE_PROP_TYPE_TO_MPT |
Relationship Business Name | |
Physical Only | No |
Parent Table | MSG_PROPERTY_TYPE |
Child Table | MSG_TYPE_PROPERTY_TYPE |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"MSG_PROPERTY_TYPE to MSG_TYPE_PROPERTY_TYPE" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"MSG_PROPERTY_TYPE to MSG_TYPE_PROPERTY_TYPE" Foreign Keys |
Parent Key | Child Key |
ID | MSG_PROPERTY_TYPE_ID |
"MSG_PROPERTY_TYPE to MSG_TYPE_PROPERTY_TYPE" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"MSG_PROPERTY_TYPE to MSG_TYPE_PROPERTY_TYPE" Bound Attachments |
Name | Current Value |
"MSG_TYPE to MSG_TYPE_PROPERTY_TYPE" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | FK_MSG_TYPE_PROP_TYPE_TO_MT |
Relationship Business Name | |
Physical Only | No |
Parent Table | MSG_TYPE |
Child Table | MSG_TYPE_PROPERTY_TYPE |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"MSG_TYPE to MSG_TYPE_PROPERTY_TYPE" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"MSG_TYPE to MSG_TYPE_PROPERTY_TYPE" Foreign Keys |
Parent Key | Child Key |
ID | MESSAGE_TYPE_ID |
"MSG_TYPE to MSG_TYPE_PROPERTY_TYPE" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"MSG_TYPE to MSG_TYPE_PROPERTY_TYPE" Bound Attachments |
Name | Current Value |
"MACH_SNAPSHOT_PER to MACH_SNAPSHOT_TYPE" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | FK_MST_TO_MACH_SNAP_PER |
Relationship Business Name | |
Physical Only | No |
Parent Table | MACH_SNAPSHOT_PER |
Child Table | MACH_SNAPSHOT_TYPE |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"MACH_SNAPSHOT_PER to MACH_SNAPSHOT_TYPE" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"MACH_SNAPSHOT_PER to MACH_SNAPSHOT_TYPE" Foreign Keys |
Parent Key | Child Key |
SNAPSHOT_PER | SNAPSHOT_PER |
"MACH_SNAPSHOT_PER to MACH_SNAPSHOT_TYPE" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"MACH_SNAPSHOT_PER to MACH_SNAPSHOT_TYPE" Bound Attachments |
Name | Current Value |
"MACH_SNAPSHOT_RETENT to MACH_SNAPSHOT_TYPE" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | FK_MST_TO_MACH_SNAP_RET |
Relationship Business Name | |
Physical Only | No |
Parent Table | MACH_SNAPSHOT_RETENT |
Child Table | MACH_SNAPSHOT_TYPE |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"MACH_SNAPSHOT_RETENT to MACH_SNAPSHOT_TYPE" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"MACH_SNAPSHOT_RETENT to MACH_SNAPSHOT_TYPE" Foreign Keys |
Parent Key | Child Key |
SNAPSHOT_RETENT | SNAPSHOT_RETENT |
"MACH_SNAPSHOT_RETENT to MACH_SNAPSHOT_TYPE" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"MACH_SNAPSHOT_RETENT to MACH_SNAPSHOT_TYPE" Bound Attachments |
Name | Current Value |
"DVC to INVALID_DVC" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | FK_PARENT_DVC_ID |
Relationship Business Name | |
Physical Only | No |
Parent Table | DVC |
Child Table | INVALID_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 INVALID_DVC" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"DVC to INVALID_DVC" Foreign Keys |
Parent Key | Child Key |
DVC_ID | PARENT_DVC_ID |
"DVC to INVALID_DVC" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"DVC to INVALID_DVC" Bound Attachments |
Name | Current Value |
"DVC to DVC_PORT_ASGN" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_PORT_DVC_ID_DVC |
Relationship Business Name | |
Physical Only | No |
Parent Table | DVC |
Child Table | DVC_PORT_ASGN |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"DVC to DVC_PORT_ASGN" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"DVC to DVC_PORT_ASGN" Foreign Keys |
Parent Key | Child Key |
DVC_ID | PORT_DVC_ID |
"DVC to DVC_PORT_ASGN" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"DVC to DVC_PORT_ASGN" Bound Attachments |
Name | Current Value |
"PV_SNAPSHOT_GRP to PV_SNAPSHOT_GRP_SGNL" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_PSGS_PSG |
Relationship Business Name | |
Physical Only | No |
Parent Table | PV_SNAPSHOT_GRP |
Child Table | PV_SNAPSHOT_GRP_SGNL |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"PV_SNAPSHOT_GRP to PV_SNAPSHOT_GRP_SGNL" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"PV_SNAPSHOT_GRP to PV_SNAPSHOT_GRP_SGNL" Foreign Keys |
Parent Key | Child Key |
MOD_DTE | MOD_DTE |
"PV_SNAPSHOT_GRP to PV_SNAPSHOT_GRP_SGNL" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"PV_SNAPSHOT_GRP to PV_SNAPSHOT_GRP_SGNL" Bound Attachments |
Name | Current Value |
"SGNL_REC to PV_SNAPSHOT_GRP_SGNL" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_PSGS_SGNL_REC |
Relationship Business Name | |
Physical Only | No |
Parent Table | SGNL_REC |
Child Table | PV_SNAPSHOT_GRP_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 PV_SNAPSHOT_GRP_SGNL" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"SGNL_REC to PV_SNAPSHOT_GRP_SGNL" Foreign Keys |
Parent Key | Child Key |
SGNL_ID | SGNL_ID |
"SGNL_REC to PV_SNAPSHOT_GRP_SGNL" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"SGNL_REC to PV_SNAPSHOT_GRP_SGNL" Bound Attachments |
Name | Current Value |
"PV_SNAPSHOT_GRP_SGNL to PV_SNAPSHOT_SGNL" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_PSS_PSGS |
Relationship Business Name | |
Physical Only | No |
Parent Table | PV_SNAPSHOT_GRP_SGNL |
Child Table | PV_SNAPSHOT_SGNL |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"PV_SNAPSHOT_GRP_SGNL to PV_SNAPSHOT_SGNL" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"PV_SNAPSHOT_GRP_SGNL to PV_SNAPSHOT_SGNL" Foreign Keys |
Parent Key | Child Key |
MOD_DTE, SGNL_ID | MOD_DTE, SGNL_ID |
"PV_SNAPSHOT_GRP_SGNL to PV_SNAPSHOT_SGNL" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"PV_SNAPSHOT_GRP_SGNL to PV_SNAPSHOT_SGNL" Bound Attachments |
Name | Current Value |
"SGNL_FLD_DEF to PV_SNAPSHOT_SGNL" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | FK_PSS_SGNL_FLD_DEF |
Relationship Business Name | |
Physical Only | No |
Parent Table | SGNL_FLD_DEF |
Child Table | PV_SNAPSHOT_SGNL |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"SGNL_FLD_DEF to PV_SNAPSHOT_SGNL" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"SGNL_FLD_DEF to PV_SNAPSHOT_SGNL" Foreign Keys |
Parent Key | Child Key |
REC_TYPE_ID, FLD_ID | REC_TYPE_ID, FLD_ID |
"SGNL_FLD_DEF to PV_SNAPSHOT_SGNL" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"SGNL_FLD_DEF to PV_SNAPSHOT_SGNL" Bound Attachments |
Name | Current Value |
"SCORE_SNAPSHOT_GRP to SCORE_SNAPSHOT_SGNL" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_SCORE_SNAPSHOT_GRP |
Relationship Business Name | |
Physical Only | No |
Parent Table | SCORE_SNAPSHOT_GRP |
Child Table | SCORE_SNAPSHOT_SGNL |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"SCORE_SNAPSHOT_GRP to SCORE_SNAPSHOT_SGNL" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"SCORE_SNAPSHOT_GRP to SCORE_SNAPSHOT_SGNL" Foreign Keys |
Parent Key | Child Key |
EQUIP_CAT_ID, MOD_DTE | EQUIP_CAT_ID, MOD_DTE |
"SCORE_SNAPSHOT_GRP to SCORE_SNAPSHOT_SGNL" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"SCORE_SNAPSHOT_GRP to SCORE_SNAPSHOT_SGNL" Bound Attachments |
Name | Current Value |
"IOC_DVC to SGNL_FLD" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_SGNL_FLD_IOC_DVC |
Relationship Business Name | |
Physical Only | No |
Parent Table | IOC_DVC |
Child Table | SGNL_FLD |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"IOC_DVC to SGNL_FLD" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"IOC_DVC to SGNL_FLD" Foreign Keys |
Parent Key | Child Key |
DVC_ID | IOC_DVC_ID |
"IOC_DVC to SGNL_FLD" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"IOC_DVC to SGNL_FLD" Bound Attachments |
Name | Current Value |
"SGNL_FLD_DEF to SGNL_FLD" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_SGNL_FLD_SGNL_FLD_DEF |
Relationship Business Name | |
Physical Only | No |
Parent Table | SGNL_FLD_DEF |
Child Table | SGNL_FLD |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"SGNL_FLD_DEF to SGNL_FLD" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"SGNL_FLD_DEF to SGNL_FLD" Foreign Keys |
Parent Key | Child Key |
REC_TYPE_ID, FLD_ID | REC_TYPE_ID, FLD_ID |
"SGNL_FLD_DEF to SGNL_FLD" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"SGNL_FLD_DEF to SGNL_FLD" Bound Attachments |
Name | Current Value |
"SGNL_REC to SGNL_FLD" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_SGNL_FLD_SGNL_REC |
Relationship Business Name | |
Physical Only | No |
Parent Table | SGNL_REC |
Child Table | SGNL_FLD |
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_FLD" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"SGNL_REC to SGNL_FLD" Foreign Keys |
Parent Key | Child Key |
SGNL_ID | SGNL_ID |
"SGNL_REC to SGNL_FLD" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"SGNL_REC to SGNL_FLD" Bound Attachments |
Name | Current Value |
"DVC to MPS_CHAN_AUDIT" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | FK_SUBSEQ_DVC_ID |
Relationship Business Name | |
Physical Only | No |
Parent Table | DVC |
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 |
"DVC to MPS_CHAN_AUDIT" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"DVC to MPS_CHAN_AUDIT" Foreign Keys |
Parent Key | Child Key |
DVC_ID | SUBSEQ_DVC_ID |
"DVC to MPS_CHAN_AUDIT" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"DVC to MPS_CHAN_AUDIT" Bound Attachments |
Name | Current Value |
"SYST to SCORE_SNAPSHOT_GRP_SGNL" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | FK_SYST |
Relationship Business Name | |
Physical Only | No |
Parent Table | SYST |
Child Table | SCORE_SNAPSHOT_GRP_SGNL |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"SYST to SCORE_SNAPSHOT_GRP_SGNL" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"SYST to SCORE_SNAPSHOT_GRP_SGNL" Foreign Keys |
Parent Key | Child Key |
SYS_ID | SYS_ID |
"SYST to SCORE_SNAPSHOT_GRP_SGNL" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"SYST to SCORE_SNAPSHOT_GRP_SGNL" Bound Attachments |
Name | Current Value |
"FUNC_DVC_GRP to FUNC_DVC_GRP_ITEM" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FUNC_DVC_GRP_GRP_ITEM_RF |
Relationship Business Name | |
Physical Only | No |
Parent Table | FUNC_DVC_GRP |
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 |
"FUNC_DVC_GRP to FUNC_DVC_GRP_ITEM" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"FUNC_DVC_GRP to FUNC_DVC_GRP_ITEM" Foreign Keys |
Parent Key | Child Key |
FUNC_DVC_GRP_ID | FUNC_DVC_GRP_ID |
"FUNC_DVC_GRP to FUNC_DVC_GRP_ITEM" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"FUNC_DVC_GRP 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_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 ICS_COMM_DVC" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | ICS_COMM_RPC_DVC_ID_DVC_FK |
Relationship Business Name | |
Physical Only | No |
Parent Table | DVC |
Child Table | ICS_COMM_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 ICS_COMM_DVC" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"DVC to ICS_COMM_DVC" Foreign Keys |
Parent Key | Child Key |
DVC_ID | RPC_DVC_ID |
"DVC to ICS_COMM_DVC" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"DVC to ICS_COMM_DVC" Bound Attachments |
Name | Current Value |
"DVC to ICS_COMM_DVC" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | ICS_COMM_SW_DVC_ID_DVC_FK |
Relationship Business Name | |
Physical Only | No |
Parent Table | DVC |
Child Table | ICS_COMM_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 ICS_COMM_DVC" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"DVC to ICS_COMM_DVC" Foreign Keys |
Parent Key | Child Key |
DVC_ID | SW_DVC_ID |
"DVC to ICS_COMM_DVC" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"DVC to ICS_COMM_DVC" Bound Attachments |
Name | Current Value |
"DVC to ICS_COMM_DVC" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | ICS_COMM_TSRV_DVC_ID_DVC_FK |
Relationship Business Name | |
Physical Only | No |
Parent Table | DVC |
Child Table | ICS_COMM_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 ICS_COMM_DVC" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"DVC to ICS_COMM_DVC" Foreign Keys |
Parent Key | Child Key |
DVC_ID | TSRV_DVC_ID |
"DVC to ICS_COMM_DVC" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"DVC to ICS_COMM_DVC" Bound Attachments |
Name | Current Value |
"DVC to ICS_MULTIPORT_COMM_DVC" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | ICS_MP_COMM_DVC_DVC_RF |
Relationship Business Name | |
Physical Only | No |
Parent Table | DVC |
Child Table | ICS_MULTIPORT_COMM_DVC |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"DVC to ICS_MULTIPORT_COMM_DVC" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"DVC to ICS_MULTIPORT_COMM_DVC" Foreign Keys |
Parent Key | Child Key |
DVC_ID | DVC_ID |
"DVC to ICS_MULTIPORT_COMM_DVC" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"DVC to ICS_MULTIPORT_COMM_DVC" Bound Attachments |
Name | Current Value |
"DVC to ICS_MULTIPORT_COMM_DVC" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | ICS_MP_COMM_SW_DVC_ID_DVC_RF |
Relationship Business Name | |
Physical Only | No |
Parent Table | DVC |
Child Table | ICS_MULTIPORT_COMM_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 ICS_MULTIPORT_COMM_DVC" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"DVC to ICS_MULTIPORT_COMM_DVC" Foreign Keys |
Parent Key | Child Key |
DVC_ID | SW_DVC_ID |
"DVC to ICS_MULTIPORT_COMM_DVC" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"DVC to ICS_MULTIPORT_COMM_DVC" Bound Attachments |
Name | Current Value |
"DVC to ICS_MULTIPORT_COMM_DVC" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | ICS_MP_RPC_DVC_ID_DVC_FK |
Relationship Business Name | |
Physical Only | No |
Parent Table | DVC |
Child Table | ICS_MULTIPORT_COMM_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 ICS_MULTIPORT_COMM_DVC" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"DVC to ICS_MULTIPORT_COMM_DVC" Foreign Keys |
Parent Key | Child Key |
DVC_ID | RPC_DVC_ID |
"DVC to ICS_MULTIPORT_COMM_DVC" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"DVC to ICS_MULTIPORT_COMM_DVC" Bound Attachments |
Name | Current Value |
"DVC to ICS_MULTIPORT_COMM_DVC" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | ICS_MP_TSRV_DVC_ID_DVC_FK |
Relationship Business Name | |
Physical Only | No |
Parent Table | DVC |
Child Table | ICS_MULTIPORT_COMM_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 ICS_MULTIPORT_COMM_DVC" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"DVC to ICS_MULTIPORT_COMM_DVC" Foreign Keys |
Parent Key | Child Key |
DVC_ID | TSRV_DVC_ID |
"DVC to ICS_MULTIPORT_COMM_DVC" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"DVC to ICS_MULTIPORT_COMM_DVC" Bound Attachments |
Name | Current Value |
"IOC_DB_FILE_ASGN to IOC_DB_FILE_ASGN_SGNL" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | IOC_DB_FILE_ASGN_RF |
Relationship Business Name | |
Physical Only | No |
Parent Table | IOC_DB_FILE_ASGN |
Child Table | IOC_DB_FILE_ASGN_SGNL |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"IOC_DB_FILE_ASGN to IOC_DB_FILE_ASGN_SGNL" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"IOC_DB_FILE_ASGN to IOC_DB_FILE_ASGN_SGNL" Foreign Keys |
Parent Key | Child Key |
DVC_ID, EXT_SRC_FILE_NM | DVC_ID, EXT_SRC_FILE_NM |
"IOC_DB_FILE_ASGN to IOC_DB_FILE_ASGN_SGNL" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"IOC_DB_FILE_ASGN to IOC_DB_FILE_ASGN_SGNL" Bound Attachments |
Name | Current Value |
"DVC to IOC_DVC_ASGN" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | IOC_DVC_DVC_ID_DVC_FK |
Relationship Business Name | |
Physical Only | No |
Parent Table | DVC |
Child Table | IOC_DVC_ASGN |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"DVC to IOC_DVC_ASGN" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"DVC to IOC_DVC_ASGN" Foreign Keys |
Parent Key | Child Key |
DVC_ID | DVC_ID |
"DVC to IOC_DVC_ASGN" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"DVC to IOC_DVC_ASGN" Bound Attachments |
Name | Current Value |
"DVC to IOC_DVC_ASGN" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | IOC_DVC_ID_DVC_FK |
Relationship Business Name | |
Physical Only | No |
Parent Table | DVC |
Child Table | IOC_DVC_ASGN |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"DVC to IOC_DVC_ASGN" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"DVC to IOC_DVC_ASGN" Foreign Keys |
Parent Key | Child Key |
DVC_ID | IOC_DVC_ID |
"DVC to IOC_DVC_ASGN" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"DVC to IOC_DVC_ASGN" Bound Attachments |
Name | Current Value |
"DVC to IOC_DVC" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | IOC_DVC_RPC_DVC_ID_DVC_FK |
Relationship Business Name | |
Physical Only | No |
Parent Table | DVC |
Child Table | IOC_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 IOC_DVC" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"DVC to IOC_DVC" Foreign Keys |
Parent Key | Child Key |
DVC_ID | RPC_DVC_ID |
"DVC to IOC_DVC" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"DVC to IOC_DVC" Bound Attachments |
Name | Current Value |
"DVC to IOC_DVC" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | IOC_DVC_TSRV_DVC_ID_DVC_FK |
Relationship Business Name | |
Physical Only | No |
Parent Table | DVC |
Child Table | IOC_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 IOC_DVC" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"DVC to IOC_DVC" Foreign Keys |
Parent Key | Child Key |
DVC_ID | TSRV_DVC_ID |
"DVC to IOC_DVC" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"DVC to IOC_DVC" Bound Attachments |
Name | Current Value |
"DVC to IOC_DVC" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | IOC_SW_DVC_ID_DVC_FK |
Relationship Business Name | |
Physical Only | No |
Parent Table | DVC |
Child Table | IOC_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 IOC_DVC" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"DVC to IOC_DVC" Foreign Keys |
Parent Key | Child Key |
DVC_ID | SW_DVC_ID |
"DVC to IOC_DVC" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"DVC to IOC_DVC" Bound Attachments |
Name | Current Value |
"DVC_TYPE to MACHINE_MODE_DEF_MASK" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | MACH_MODE_DEF_MASK_DVC_TYPE_RF |
Relationship Business Name | |
Physical Only | No |
Parent Table | DVC_TYPE |
Child Table | MACHINE_MODE_DEF_MASK |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"DVC_TYPE to MACHINE_MODE_DEF_MASK" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"DVC_TYPE to MACHINE_MODE_DEF_MASK" Foreign Keys |
Parent Key | Child Key |
DVC_TYPE_ID | DVC_TYPE_ID |
"DVC_TYPE to MACHINE_MODE_DEF_MASK" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"DVC_TYPE to MACHINE_MODE_DEF_MASK" Bound Attachments |
Name | Current Value |
"MACH_SNAPSHOT to MACH_SNAPSHOT_SGNL" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | MACH_SNAPSHOT_SGNL_MACH_FK |
Relationship Business Name | |
Physical Only | No |
Parent Table | MACH_SNAPSHOT |
Child Table | MACH_SNAPSHOT_SGNL |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"MACH_SNAPSHOT to MACH_SNAPSHOT_SGNL" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"MACH_SNAPSHOT to MACH_SNAPSHOT_SGNL" Foreign Keys |
Parent Key | Child Key |
SNAPSHOT_ID | SNAPSHOT_ID |
"MACH_SNAPSHOT to MACH_SNAPSHOT_SGNL" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"MACH_SNAPSHOT to MACH_SNAPSHOT_SGNL" Bound Attachments |
Name | Current Value |
"MACH_SNAPSHOT_TYPE to MACH_SNAPSHOT" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | MACH_SNAPSHOT_TYPE_FK |
Relationship Business Name | |
Physical Only | No |
Parent Table | MACH_SNAPSHOT_TYPE |
Child Table | MACH_SNAPSHOT |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"MACH_SNAPSHOT_TYPE to MACH_SNAPSHOT" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"MACH_SNAPSHOT_TYPE to MACH_SNAPSHOT" Foreign Keys |
Parent Key | Child Key |
SNAPSHOT_TYPE_NM | SNAPSHOT_TYPE_NM |
"MACH_SNAPSHOT_TYPE to MACH_SNAPSHOT" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"MACH_SNAPSHOT_TYPE to MACH_SNAPSHOT" Bound Attachments |
Name | Current Value |
"MACH_SNAPSHOT_TYPE to MACH_SNAPSHOT_TYPE_SGNL" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | MACH_SNAPSHOT_TYPE_SGNL_NM_FK |
Relationship Business Name | |
Physical Only | No |
Parent Table | MACH_SNAPSHOT_TYPE |
Child Table | MACH_SNAPSHOT_TYPE_SGNL |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"MACH_SNAPSHOT_TYPE to MACH_SNAPSHOT_TYPE_SGNL" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"MACH_SNAPSHOT_TYPE to MACH_SNAPSHOT_TYPE_SGNL" Foreign Keys |
Parent Key | Child Key |
SNAPSHOT_TYPE_NM | SNAPSHOT_TYPE_NM |
"MACH_SNAPSHOT_TYPE to MACH_SNAPSHOT_TYPE_SGNL" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"MACH_SNAPSHOT_TYPE to MACH_SNAPSHOT_TYPE_SGNL" Bound Attachments |
Name | Current Value |
"DVC to MACHINE_MODE" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | MACHINE_MODE_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 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 More |
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 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 |
"DVC to MPS_SGNL_PARAM" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | MPS_SGNL_PARAM_IOC_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 | IOC_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 |
"MPS_CHAIN to MPS_SGNL_PARAM" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | MPS_SGNL_PARAM_MPS_CHAIN_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 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 |
"DVC to PS_DVC" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | PS_DVC_DVC_RF |
Relationship Business Name | |
Physical Only | No |
Parent Table | DVC |
Child Table | PS_DVC |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"DVC to PS_DVC" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"DVC to PS_DVC" Foreign Keys |
Parent Key | Child Key |
DVC_ID | DVC_ID |
"DVC to PS_DVC" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"DVC to PS_DVC" Bound Attachments |
Name | Current Value |
"DVC to MAG_DVC" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | PS_DVC_ID_DVC_RF |
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 to PSC_DVC" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | PSC_DVC_DVC_RF |
Relationship Business Name | |
Physical Only | No |
Parent Table | DVC |
Child Table | PSC_DVC |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"DVC to PSC_DVC" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"DVC to PSC_DVC" Foreign Keys |
Parent Key | Child Key |
DVC_ID | DVC_ID |
"DVC to PSC_DVC" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"DVC to PSC_DVC" Bound Attachments |
Name | Current Value |
"DVC to PSI_DVC" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | PSI_DVC_DVC_RF |
Relationship Business Name | |
Physical Only | No |
Parent Table | DVC |
Child Table | PSI_DVC |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"DVC to PSI_DVC" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"DVC to PSI_DVC" Foreign Keys |
Parent Key | Child Key |
DVC_ID | DVC_ID |
"DVC to PSI_DVC" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"DVC to PSI_DVC" Bound Attachments |
Name | Current Value |
"DVC to PSI_DVC" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | PSI_DVC_PSC_DVC_RF |
Relationship Business Name | |
Physical Only | No |
Parent Table | DVC |
Child Table | PSI_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 PSI_DVC" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"DVC to PSI_DVC" Foreign Keys |
Parent Key | Child Key |
DVC_ID | PSC_DVC_ID |
"DVC to PSI_DVC" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"DVC to PSI_DVC" Bound Attachments |
Name | Current Value |
"SUBSYS to RESP_ENGR" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | RESP_ENGR_SUBSYS_FK |
Relationship Business Name | |
Physical Only | No |
Parent Table | SUBSYS |
Child Table | RESP_ENGR |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"SUBSYS to RESP_ENGR" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"SUBSYS to RESP_ENGR" Foreign Keys |
Parent Key | Child Key |
SUBSYS_ID | SUBSYS_ID |
"SUBSYS to RESP_ENGR" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"SUBSYS to RESP_ENGR" 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 More |
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 |
"SCENARIO_TYPE to DVC_SETTING" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | SCENARIO_TYP_DVC_SETNG_RF |
Relationship Business Name | |
Physical Only | No |
Parent Table | SCENARIO_TYPE |
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 |
"SCENARIO_TYPE to DVC_SETTING" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"SCENARIO_TYPE to DVC_SETTING" Foreign Keys |
Parent Key | Child Key |
SCENARIO_ID | SCENARIO_ID |
"SCENARIO_TYPE to DVC_SETTING" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"SCENARIO_TYPE to DVC_SETTING" Bound Attachments |
Name | Current Value |
"MPS_CHASSIS_SER_NBR to MPS_SGNL_PARAM" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | SER_NBR_RF |
Relationship Business Name | |
Physical Only | No |
Parent Table | MPS_CHASSIS_SER_NBR |
Child Table | MPS_SGNL_PARAM |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"MPS_CHASSIS_SER_NBR to MPS_SGNL_PARAM" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"MPS_CHASSIS_SER_NBR to MPS_SGNL_PARAM" Foreign Keys |
Parent Key | Child Key |
SER_NBR | SERIAL_NBR |
"MPS_CHASSIS_SER_NBR to MPS_SGNL_PARAM" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"MPS_CHASSIS_SER_NBR to MPS_SGNL_PARAM" Bound Attachments |
Name | Current Value |
"SETTING_TYPE to DVC_SETTING" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | SETTING_TYPE_DVC_SETNG_RF |
Relationship Business Name | |
Physical Only | No |
Parent Table | SETTING_TYPE |
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 |
"SETTING_TYPE to DVC_SETTING" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"SETTING_TYPE to DVC_SETTING" Foreign Keys |
Parent Key | Child Key |
SETTING_ID | SETTING_ID |
"SETTING_TYPE to DVC_SETTING" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"SETTING_TYPE to DVC_SETTING" 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_FLD_DEF to TMPL_SGNL_FLD" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | SGNL_FLD_DEF_FLD_ID_FK |
Relationship Business Name | |
Physical Only | No |
Parent Table | SGNL_FLD_DEF |
Child Table | TMPL_SGNL_FLD |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"SGNL_FLD_DEF to TMPL_SGNL_FLD" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"SGNL_FLD_DEF to TMPL_SGNL_FLD" Foreign Keys |
Parent Key | Child Key |
REC_TYPE_ID, FLD_ID | REC_TYPE_ID, FLD_ID |
"SGNL_FLD_DEF to TMPL_SGNL_FLD" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"SGNL_FLD_DEF to TMPL_SGNL_FLD" Bound Attachments |
Name | Current Value |
"SGNL_FLD_ID to ARCH_SGNL_FLD_DISP" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | SGNL_FLD_ID_FLD_ID_FK |
Relationship Business Name | |
Physical Only | No |
Parent Table | SGNL_FLD_ID |
Child Table | ARCH_SGNL_FLD_DISP |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"SGNL_FLD_ID to ARCH_SGNL_FLD_DISP" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"SGNL_FLD_ID to ARCH_SGNL_FLD_DISP" Foreign Keys |
Parent Key | Child Key |
FLD_ID | FLD_ID |
"SGNL_FLD_ID to ARCH_SGNL_FLD_DISP" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"SGNL_FLD_ID to ARCH_SGNL_FLD_DISP" Bound Attachments |
Name | Current Value |
"SGNL_FLD_MENU to SGNL_FLD_DEF" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | SGNL_FLD_MENU_DEF_RF |
Relationship Business Name | |
Physical Only | No |
Parent Table | SGNL_FLD_MENU |
Child Table | SGNL_FLD_DEF |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"SGNL_FLD_MENU to SGNL_FLD_DEF" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"SGNL_FLD_MENU to SGNL_FLD_DEF" Foreign Keys |
Parent Key | Child Key |
SGNL_FLD_MENU_ID, FLD_MENU_VAL | SGNL_FLD_MENU_ID, FLD_MENU_VAL |
"SGNL_FLD_MENU to SGNL_FLD_DEF" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"SGNL_FLD_MENU to SGNL_FLD_DEF" Bound Attachments |
Name | Current Value |
"SGNL_GRP to SGNL_GRP_ITEM" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | SGNL_GRP_SGNL_GRP_ITEM_RF |
Relationship Business Name | |
Physical Only | No |
Parent Table | SGNL_GRP |
Child Table | SGNL_GRP_ITEM |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"SGNL_GRP to SGNL_GRP_ITEM" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"SGNL_GRP to SGNL_GRP_ITEM" Foreign Keys |
Parent Key | Child Key |
SGNL_GRP_ID | SGNL_GRP_ID |
"SGNL_GRP to SGNL_GRP_ITEM" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"SGNL_GRP to SGNL_GRP_ITEM" Bound Attachments |
Name | Current Value |
"SGNL_REC to IOC_DB_FILE_ASGN_SGNL" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | SGNL_ID_SGNL_REC_RF |
Relationship Business Name | |
Physical Only | No |
Parent Table | SGNL_REC |
Child Table | IOC_DB_FILE_ASGN_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 IOC_DB_FILE_ASGN_SGNL" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"SGNL_REC to IOC_DB_FILE_ASGN_SGNL" Foreign Keys |
Parent Key | Child Key |
SGNL_ID | SGNL_ID |
"SGNL_REC to IOC_DB_FILE_ASGN_SGNL" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"SGNL_REC to IOC_DB_FILE_ASGN_SGNL" Bound Attachments |
Name | Current Value |
"SGNL_REC_TYPE to SGNL_FLD_DEF" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | SGNL_REC_TYPE_FLD_DEF_RF |
Relationship Business Name | |
Physical Only | No |
Parent Table | SGNL_REC_TYPE |
Child Table | SGNL_FLD_DEF |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"SGNL_REC_TYPE to SGNL_FLD_DEF" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"SGNL_REC_TYPE to SGNL_FLD_DEF" Foreign Keys |
Parent Key | Child Key |
REC_TYPE_ID | REC_TYPE_ID |
"SGNL_REC_TYPE to SGNL_FLD_DEF" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"SGNL_REC_TYPE to SGNL_FLD_DEF" Bound Attachments |
Name | Current Value |
"SGNL_REC_TYPE to TMPL_SGNL_FLD" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | SGNL_REC_TYPE_REC_TYPE_ID_FK |
Relationship Business Name | |
Physical Only | No |
Parent Table | SGNL_REC_TYPE |
Child Table | TMPL_SGNL_FLD |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"SGNL_REC_TYPE to TMPL_SGNL_FLD" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"SGNL_REC_TYPE to TMPL_SGNL_FLD" Foreign Keys |
Parent Key | Child Key |
REC_TYPE_ID | REC_TYPE_ID |
"SGNL_REC_TYPE to TMPL_SGNL_FLD" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"SGNL_REC_TYPE to TMPL_SGNL_FLD" Bound Attachments |
Name | Current Value |
"SGNL_REC_TYPE to SGNL_REC" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | SGNL_REC_TYPE_RF |
Relationship Business Name | |
Physical Only | No |
Parent Table | SGNL_REC_TYPE |
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 |
"SGNL_REC_TYPE to SGNL_REC" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"SGNL_REC_TYPE to SGNL_REC" Foreign Keys |
Parent Key | Child Key |
REC_TYPE_ID | REC_TYPE_ID |
"SGNL_REC_TYPE to SGNL_REC" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"SGNL_REC_TYPE to SGNL_REC" Bound Attachments |
Name | Current Value |
"TEMPLATE to TMPL_MACRO" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | TEMPLATE_MACRO_TMPL_ID_FK |
Relationship Business Name | |
Physical Only | No |
Parent Table | TEMPLATE |
Child Table | TMPL_MACRO |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"TEMPLATE to TMPL_MACRO" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"TEMPLATE to TMPL_MACRO" Foreign Keys |
Parent Key | Child Key |
TMPL_ID | TMPL_ID |
"TEMPLATE to TMPL_MACRO" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"TEMPLATE to TMPL_MACRO" Bound Attachments |
Name | Current Value |
"TMPL_SGNL_REC to TMPL_SGNL_FLD" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | TEMPLATE_TMPL_ID_FK |
Relationship Business Name | |
Physical Only | No |
Parent Table | TMPL_SGNL_REC |
Child Table | TMPL_SGNL_FLD |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"TMPL_SGNL_REC to TMPL_SGNL_FLD" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"TMPL_SGNL_REC to TMPL_SGNL_FLD" Foreign Keys |
Parent Key | Child Key |
TMPL_ID, TMPL_SGNL_ID, REC_TYPE_ID | TMPL_ID, TMPL_SGNL_ID, REC_TYPE_ID |
"TMPL_SGNL_REC to TMPL_SGNL_FLD" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"TMPL_SGNL_REC to TMPL_SGNL_FLD" Bound Attachments |
Name | Current Value |
"TEMPLATE to TMPL_SGNL_REC" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | TMPL_SGNL_REC_TEMPLATE_FK |
Relationship Business Name | |
Physical Only | No |
Parent Table | TEMPLATE |
Child Table | TMPL_SGNL_REC |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"TEMPLATE to TMPL_SGNL_REC" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"TEMPLATE to TMPL_SGNL_REC" Foreign Keys |
Parent Key | Child Key |
TMPL_ID | TMPL_ID |
"TEMPLATE to TMPL_SGNL_REC" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"TEMPLATE to TMPL_SGNL_REC" Bound Attachments |
Name | Current Value |