"MNFCTR_MDL to CTRLS_MNFCTR_MDL" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | |
Relationship Business Name | |
Physical Only | No |
Parent Table | MNFCTR_MDL |
Child Table | CTRLS_MNFCTR_MDL |
Cardinality | One to Zero or One |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"MNFCTR_MDL to CTRLS_MNFCTR_MDL" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"MNFCTR_MDL to CTRLS_MNFCTR_MDL" Foreign Keys |
Parent Key | Child Key |
MNFCTR_ID, MDL_NBR | MNFCTR_ID, MDL_NBR |
"MNFCTR_MDL to CTRLS_MNFCTR_MDL" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"MNFCTR_MDL to CTRLS_MNFCTR_MDL" Bound Attachments |
Name | Current Value |
"USER_INSTR_TYPE to USER_INSTR" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | |
Relationship Business Name | |
Physical Only | No |
Parent Table | USER_INSTR_TYPE |
Child Table | USER_INSTR |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"USER_INSTR_TYPE to USER_INSTR" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"USER_INSTR_TYPE to USER_INSTR" Foreign Keys |
Parent Key | Child Key |
USER_INSTR_TYPE_ID | USER_INSTR_TYPE_ID |
"USER_INSTR_TYPE to USER_INSTR" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"USER_INSTR_TYPE to USER_INSTR" Bound Attachments |
Name | Current Value |
"EQUIP to EQUIP_USAGE" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | |
Relationship Business Name | |
Physical Only | No |
Parent Table | EQUIP |
Child Table | EQUIP_USAGE |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"EQUIP to EQUIP_USAGE" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EQUIP to EQUIP_USAGE" Foreign Keys |
Parent Key | Child Key |
EQUIP_ID | EQUIP_ID |
"EQUIP to EQUIP_USAGE" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"EQUIP to EQUIP_USAGE" Bound Attachments |
Name | Current Value |
"EQUIP to USER_INSTR" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | |
Relationship Business Name | |
Physical Only | No |
Parent Table | EQUIP |
Child Table | USER_INSTR |
Cardinality | One to Zero or One |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"EQUIP to USER_INSTR" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EQUIP to USER_INSTR" Foreign Keys |
Parent Key | Child Key |
EQUIP_ID | EQUIP_ID |
"EQUIP to USER_INSTR" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"EQUIP to USER_INSTR" Bound Attachments |
Name | Current Value |
"MNFCTR_MDL to MAG_MNFCTR_MDL" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | |
Relationship Business Name | |
Physical Only | No |
Parent Table | MNFCTR_MDL |
Child Table | MAG_MNFCTR_MDL |
Cardinality | One to Zero or One |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"MNFCTR_MDL to MAG_MNFCTR_MDL" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"MNFCTR_MDL to MAG_MNFCTR_MDL" Foreign Keys |
Parent Key | Child Key |
MNFCTR_ID, MDL_NBR | MNFCTR_ID, MDL_NBR |
"MNFCTR_MDL to MAG_MNFCTR_MDL" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"MNFCTR_MDL to MAG_MNFCTR_MDL" Bound Attachments |
Name | Current Value |
"MNFCTR_MDL to PWR_SPLY_MNFCTR_MDL" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | |
Relationship Business Name | |
Physical Only | No |
Parent Table | MNFCTR_MDL |
Child Table | PWR_SPLY_MNFCTR_MDL |
Cardinality | One to Zero or One |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"MNFCTR_MDL to PWR_SPLY_MNFCTR_MDL" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"MNFCTR_MDL to PWR_SPLY_MNFCTR_MDL" Foreign Keys |
Parent Key | Child Key |
MNFCTR_ID, MDL_NBR | MNFCTR_ID, MDL_NBR |
"MNFCTR_MDL to PWR_SPLY_MNFCTR_MDL" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"MNFCTR_MDL to PWR_SPLY_MNFCTR_MDL" Bound Attachments |
Name | Current Value |
"EQUIP to RF_CAV" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | |
Relationship Business Name | |
Physical Only | No |
Parent Table | EQUIP |
Child Table | RF_CAV |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"EQUIP to RF_CAV" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EQUIP to RF_CAV" Foreign Keys |
Parent Key | Child Key |
EQUIP_ID | EQUIP_ID |
"EQUIP to RF_CAV" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"EQUIP to RF_CAV" Bound Attachments |
Name | Current Value |
"RF_CAV to RF_CAV_GAP_PARAM" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | |
Relationship Business Name | |
Physical Only | No |
Parent Table | RF_CAV |
Child Table | RF_CAV_GAP_PARAM |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"RF_CAV to RF_CAV_GAP_PARAM" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"RF_CAV to RF_CAV_GAP_PARAM" Foreign Keys |
Parent Key | Child Key |
EQUIP_ID | EQUIP_ID |
"RF_CAV to RF_CAV_GAP_PARAM" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"RF_CAV to RF_CAV_GAP_PARAM" Bound Attachments |
Name | Current Value |
"RF_CAV to BEAD_PULL" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | |
Relationship Business Name | |
Physical Only | No |
Parent Table | RF_CAV |
Child Table | BEAD_PULL |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"RF_CAV to BEAD_PULL" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"RF_CAV to BEAD_PULL" Foreign Keys |
Parent Key | Child Key |
EQUIP_ID | EQUIP_ID |
"RF_CAV to BEAD_PULL" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"RF_CAV to BEAD_PULL" Bound Attachments |
Name | Current Value |
"RF_CAV to SC_CAV_PARAM" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | |
Relationship Business Name | |
Physical Only | No |
Parent Table | RF_CAV |
Child Table | SC_CAV_PARAM |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"RF_CAV to SC_CAV_PARAM" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"RF_CAV to SC_CAV_PARAM" Foreign Keys |
Parent Key | Child Key |
EQUIP_ID | EQUIP_ID |
"RF_CAV to SC_CAV_PARAM" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"RF_CAV to SC_CAV_PARAM" Bound Attachments |
Name | Current Value |
"EQUIP to PWR_SPLY" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | |
Relationship Business Name | |
Physical Only | No |
Parent Table | EQUIP |
Child Table | PWR_SPLY |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"EQUIP to PWR_SPLY" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EQUIP to PWR_SPLY" Foreign Keys |
Parent Key | Child Key |
EQUIP_ID | EQUIP_ID |
"EQUIP to PWR_SPLY" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"EQUIP to PWR_SPLY" Bound Attachments |
Name | Current Value |
"EQUIP to DIAG_EQUIP_HIST" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | |
Relationship Business Name | |
Physical Only | No |
Parent Table | EQUIP |
Child Table | DIAG_EQUIP_HIST |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"EQUIP to DIAG_EQUIP_HIST" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EQUIP to DIAG_EQUIP_HIST" Foreign Keys |
Parent Key | Child Key |
EQUIP_ID | EQUIP_ID |
"EQUIP to DIAG_EQUIP_HIST" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"EQUIP to DIAG_EQUIP_HIST" Bound Attachments |
Name | Current Value |
"BLDG_AREA to EQUIP_LOC" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | AREA_EQUIP_LOC_RF |
Relationship Business Name | |
Physical Only | No |
Parent Table | BLDG_AREA |
Child Table | EQUIP_LOC |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"BLDG_AREA to EQUIP_LOC" Relationship Description |
Verb Sentence | A BLDG_AREA describes EQUIP_LOC(s). |
Inverse Verb Sentence | An EQUIP_LOC requries BLDG_AREA. |
Definition | |
Note |
"BLDG_AREA to EQUIP_LOC" Foreign Keys |
Parent Key | Child Key |
BLDG_ID, AREA_ID | BLDG_ID, AREA_ID |
"BLDG_AREA to EQUIP_LOC" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"BLDG_AREA to EQUIP_LOC" Bound Attachments |
Name | Current Value |
"BARCD_ASGN to BARCD_ASGN_AUDIT" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | BARCD_ASGN_BARCD_ASGN_AUDIT_RF |
Relationship Business Name | |
Physical Only | No |
Parent Table | BARCD_ASGN |
Child Table | BARCD_ASGN_AUDIT |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"BARCD_ASGN to BARCD_ASGN_AUDIT" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"BARCD_ASGN to BARCD_ASGN_AUDIT" Foreign Keys |
Parent Key | Child Key |
DVC_IEEE_NM | DVC_IEEE_NM |
"BARCD_ASGN to BARCD_ASGN_AUDIT" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"BARCD_ASGN to BARCD_ASGN_AUDIT" Bound Attachments |
Name | Current Value |
"BLDG_AREA to BLDG_SUBAREA" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | BLDG_AREA_BLDG_SUBAREA_RF |
Relationship Business Name | |
Physical Only | No |
Parent Table | BLDG_AREA |
Child Table | BLDG_SUBAREA |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"BLDG_AREA to BLDG_SUBAREA" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"BLDG_AREA to BLDG_SUBAREA" Foreign Keys |
Parent Key | Child Key |
BLDG_ID, AREA_ID | BLDG_ID, AREA_ID |
"BLDG_AREA to BLDG_SUBAREA" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"BLDG_AREA to BLDG_SUBAREA" Bound Attachments |
Name | Current Value |
"BLDG to BLDG_AREA" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | BLDG_CODE_RF |
Relationship Business Name | |
Physical Only | No |
Parent Table | BLDG |
Child Table | BLDG_AREA |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"BLDG to BLDG_AREA" Relationship Description |
Verb Sentence | A BLDG contains BLDG_AREA(s). |
Inverse Verb Sentence | A BLDG_AREA is part of BLDG. |
Definition | |
Note |
"BLDG to BLDG_AREA" Foreign Keys |
Parent Key | Child Key |
BLDG_ID | BLDG_ID |
"BLDG to BLDG_AREA" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"BLDG to BLDG_AREA" Bound Attachments |
Name | Current Value |
"CARRIER to EQUIP_RCPT" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | CARRIER_RCPT_RF |
Relationship Business Name | |
Physical Only | No |
Parent Table | CARRIER |
Child Table | EQUIP_RCPT |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"CARRIER to EQUIP_RCPT" Relationship Description |
Verb Sentence | A CARRIER is involved in EQUIP_RCPT(s). |
Inverse Verb Sentence | An EQUIP_RCPT requries CARRIER. |
Definition | |
Note |
"CARRIER to EQUIP_RCPT" Foreign Keys |
Parent Key | Child Key |
CARRIER_ID | CARRIER_ID |
"CARRIER to EQUIP_RCPT" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"CARRIER to EQUIP_RCPT" Bound Attachments |
Name | Current Value |
"EMPLOYEE_MV to EQUIP_USAGE" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | EMPLOYEE_EQUIP_USAGE_RF |
Relationship Business Name | |
Physical Only | No |
Parent Table | EMPLOYEE_MV |
Child Table | EQUIP_USAGE |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"EMPLOYEE_MV to EQUIP_USAGE" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EMPLOYEE_MV to EQUIP_USAGE" Foreign Keys |
Parent Key | Child Key |
BN | BN |
"EMPLOYEE_MV to EQUIP_USAGE" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"EMPLOYEE_MV to EQUIP_USAGE" Bound Attachments |
Name | Current Value |
"CALIB_FREQ to EQUIP" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | EQUIP_CALIB_FREQ_RF |
Relationship Business Name | |
Physical Only | No |
Parent Table | CALIB_FREQ |
Child Table | EQUIP |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"CALIB_FREQ to EQUIP" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"CALIB_FREQ to EQUIP" Foreign Keys |
Parent Key | Child Key |
CALIB_FREQ_ID | CALIB_FREQ_ID |
"CALIB_FREQ to EQUIP" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"CALIB_FREQ to EQUIP" Bound Attachments |
Name | Current Value |
"CALIB_METHOD to EQUIP" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | EQUIP_CALIB_METHOD_RF |
Relationship Business Name | |
Physical Only | No |
Parent Table | CALIB_METHOD |
Child Table | EQUIP |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"CALIB_METHOD to EQUIP" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"CALIB_METHOD to EQUIP" Foreign Keys |
Parent Key | Child Key |
CALIB_METHOD_ID | CALIB_METHOD_ID |
"CALIB_METHOD to EQUIP" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"CALIB_METHOD to EQUIP" Bound Attachments |
Name | Current Value |
"EQUIP_CAT to EQUIP_SUBCAT" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | EQUIP_CAT_EQUIP_SUBCAT_RF |
Relationship Business Name | |
Physical Only | No |
Parent Table | EQUIP_CAT |
Child Table | EQUIP_SUBCAT |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"EQUIP_CAT to EQUIP_SUBCAT" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EQUIP_CAT to EQUIP_SUBCAT" Foreign Keys |
Parent Key | Child Key |
EQUIP_CAT_ID | EQUIP_CAT_ID |
"EQUIP_CAT to EQUIP_SUBCAT" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"EQUIP_CAT to EQUIP_SUBCAT" Bound Attachments |
Name | Current Value |
"EQUIP_CAT to MNFCTR_MDL" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | EQUIP_CAT_MDL_RF |
Relationship Business Name | |
Physical Only | No |
Parent Table | EQUIP_CAT |
Child Table | MNFCTR_MDL |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"EQUIP_CAT to MNFCTR_MDL" Relationship Description |
Verb Sentence | An EQUIP_CAT groups MNFCTR_MDL(s). |
Inverse Verb Sentence | A MNFCTR_MDL is assigned to EQUIP_CAT. |
Definition | |
Note |
"EQUIP_CAT to MNFCTR_MDL" Foreign Keys |
Parent Key | Child Key |
EQUIP_CAT_ID | EQUIP_CAT_ID |
"EQUIP_CAT to MNFCTR_MDL" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"EQUIP_CAT to MNFCTR_MDL" Bound Attachments |
Name | Current Value |
"EQUIP to EQUIP_DVC_ASGN" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | EQUIP_DVC_ASGN2_RF |
Relationship Business Name | |
Physical Only | No |
Parent Table | EQUIP |
Child Table | EQUIP_DVC_ASGN |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"EQUIP to EQUIP_DVC_ASGN" Relationship Description |
Verb Sentence | An EQUIP is involved in EQUIP_DVC_ASGN(s). |
Inverse Verb Sentence | An EQUIP_DVC_ASGN uses EQUIP. |
Definition | |
Note |
"EQUIP to EQUIP_DVC_ASGN" Foreign Keys |
Parent Key | Child Key |
EQUIP_ID | EQUIP_ID |
"EQUIP to EQUIP_DVC_ASGN" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"EQUIP to EQUIP_DVC_ASGN" Bound Attachments |
Name | Current Value |
"EQUIP_SUB_SUBCAT to EQUIP" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | EQUIP_EQUIP_SUB_SUBCAT_RF |
Relationship Business Name | |
Physical Only | No |
Parent Table | EQUIP_SUB_SUBCAT |
Child Table | EQUIP |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"EQUIP_SUB_SUBCAT to EQUIP" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EQUIP_SUB_SUBCAT to EQUIP" Foreign Keys |
Parent Key | Child Key |
EQUIP_CAT_ID, EQUIP_SUBCAT_ID, EQUIP_SUB_SUBCAT_ID | EQUIP_CAT_ID, EQUIP_SUBCAT_ID, EQUIP_SUB_SUBCAT_ID |
"EQUIP_SUB_SUBCAT to EQUIP" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"EQUIP_SUB_SUBCAT to EQUIP" Bound Attachments |
Name | Current Value |
"EQUIP_SUBCAT to EQUIP" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | EQUIP_EQUIP_SUBCAT_RF |
Relationship Business Name | |
Physical Only | No |
Parent Table | EQUIP_SUBCAT |
Child Table | EQUIP |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"EQUIP_SUBCAT to EQUIP" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EQUIP_SUBCAT to EQUIP" Foreign Keys |
Parent Key | Child Key |
EQUIP_CAT_ID, EQUIP_SUBCAT_ID | EQUIP_CAT_ID, EQUIP_SUBCAT_ID |
"EQUIP_SUBCAT to EQUIP" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"EQUIP_SUBCAT to EQUIP" Bound Attachments |
Name | Current Value |
"LEAD_ENG to EQUIP" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | EQUIP_LEAD_ENG_RF |
Relationship Business Name | |
Physical Only | No |
Parent Table | LEAD_ENG |
Child Table | EQUIP |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"LEAD_ENG to EQUIP" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"LEAD_ENG to EQUIP" Foreign Keys |
Parent Key | Child Key |
LEAD_ENG_BN | LEAD_ENG_BN |
"LEAD_ENG to EQUIP" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"LEAD_ENG to EQUIP" Bound Attachments |
Name | Current Value |
"EQUIP to EQUIP_LOC" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | EQUIP_LOC_RF |
Relationship Business Name | |
Physical Only | No |
Parent Table | EQUIP |
Child Table | EQUIP_LOC |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"EQUIP to EQUIP_LOC" Relationship Description |
Verb Sentence | An EQUIP resides at EQUIP_LOC(s). |
Inverse Verb Sentence | An EQUIP_LOC stores EQUIP. |
Definition | |
Note |
"EQUIP to EQUIP_LOC" Foreign Keys |
Parent Key | Child Key |
EQUIP_ID | EQUIP_ID |
"EQUIP to EQUIP_LOC" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"EQUIP to EQUIP_LOC" Bound Attachments |
Name | Current Value |
"EQUIP_RCPT to RCPT_ITEM" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | EQUIP_RCPT_ITEM_RF |
Relationship Business Name | |
Physical Only | No |
Parent Table | EQUIP_RCPT |
Child Table | RCPT_ITEM |
Cardinality | One to One or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"EQUIP_RCPT to RCPT_ITEM" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EQUIP_RCPT to RCPT_ITEM" Foreign Keys |
Parent Key | Child Key |
EQUIP_RCPT_ID, EQUIP_RCPT_VER | EQUIP_RCPT_ID, EQUIP_RCPT_VER |
"EQUIP_RCPT to RCPT_ITEM" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"EQUIP_RCPT to RCPT_ITEM" Bound Attachments |
Name | Current Value |
"EQUIP_STAT_CODE to EQUIP_STAT" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | EQUIP_STAT_CD_RF |
Relationship Business Name | |
Physical Only | No |
Parent Table | EQUIP_STAT_CODE |
Child Table | EQUIP_STAT |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"EQUIP_STAT_CODE to EQUIP_STAT" Relationship Description |
Verb Sentence | An EQUIP_STAT_CODE used in EQUIP_STAT(s). |
Inverse Verb Sentence | An EQUIP_STAT requires EQUIP_STAT_CODE. |
Definition | |
Note |
"EQUIP_STAT_CODE to EQUIP_STAT" Foreign Keys |
Parent Key | Child Key |
EQUIP_STAT_ID | EQUIP_STAT_ID |
"EQUIP_STAT_CODE to EQUIP_STAT" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"EQUIP_STAT_CODE to EQUIP_STAT" Bound Attachments |
Name | Current Value |
"EQUIP to EQUIP_STAT" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | EQUIP_STAT_RF |
Relationship Business Name | |
Physical Only | No |
Parent Table | EQUIP |
Child Table | EQUIP_STAT |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"EQUIP to EQUIP_STAT" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EQUIP to EQUIP_STAT" Foreign Keys |
Parent Key | Child Key |
EQUIP_ID | EQUIP_ID |
"EQUIP to EQUIP_STAT" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"EQUIP to EQUIP_STAT" Bound Attachments |
Name | Current Value |
"EQUIP_SUBCAT to EQUIP_SUB_SUBCAT" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | EQUIP_SUBCAT_SUB_SUBCAT_RF |
Relationship Business Name | |
Physical Only | No |
Parent Table | EQUIP_SUBCAT |
Child Table | EQUIP_SUB_SUBCAT |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"EQUIP_SUBCAT to EQUIP_SUB_SUBCAT" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EQUIP_SUBCAT to EQUIP_SUB_SUBCAT" Foreign Keys |
Parent Key | Child Key |
EQUIP_CAT_ID, EQUIP_SUBCAT_ID | EQUIP_CAT_ID, EQUIP_SUBCAT_ID |
"EQUIP_SUBCAT to EQUIP_SUB_SUBCAT" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"EQUIP_SUBCAT to EQUIP_SUB_SUBCAT" Bound Attachments |
Name | Current Value |
"EQUIP_CAT to EQUIP" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | EQUIP_TYPE_RF |
Relationship Business Name | |
Physical Only | No |
Parent Table | EQUIP_CAT |
Child Table | EQUIP |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"EQUIP_CAT to EQUIP" Relationship Description |
Verb Sentence | An EQUIP_CAT describes EQUIP(s). |
Inverse Verb Sentence | An EQUIP is assigned to EQUIP_CAT. |
Definition | |
Note |
"EQUIP_CAT to EQUIP" Foreign Keys |
Parent Key | Child Key |
EQUIP_CAT_ID | EQUIP_CAT_ID |
"EQUIP_CAT to EQUIP" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"EQUIP_CAT to EQUIP" Bound Attachments |
Name | Current Value |
"LAB to EQUIP_RCPT" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | EQUP_RCPT_LAB_RF |
Relationship Business Name | |
Physical Only | No |
Parent Table | LAB |
Child Table | EQUIP_RCPT |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"LAB to EQUIP_RCPT" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"LAB to EQUIP_RCPT" Foreign Keys |
Parent Key | Child Key |
LAB_ID | LAB_ID |
"LAB to EQUIP_RCPT" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"LAB to EQUIP_RCPT" Bound Attachments |
Name | Current Value |
"LEAD_ENG to EQUIP_RCPT" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | EQUP_RCPT_LEAD_ENG_RF |
Relationship Business Name | |
Physical Only | No |
Parent Table | LEAD_ENG |
Child Table | EQUIP_RCPT |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"LEAD_ENG to EQUIP_RCPT" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"LEAD_ENG to EQUIP_RCPT" Foreign Keys |
Parent Key | Child Key |
LEAD_ENG_BN | LEAD_ENG_BN |
"LEAD_ENG to EQUIP_RCPT" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"LEAD_ENG to EQUIP_RCPT" Bound Attachments |
Name | Current Value |
"RCVD_BY to EQUIP_RCPT" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | EQUP_RCPT_RCVD_BY_RF |
Relationship Business Name | |
Physical Only | No |
Parent Table | RCVD_BY |
Child Table | EQUIP_RCPT |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"RCVD_BY to EQUIP_RCPT" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"RCVD_BY to EQUIP_RCPT" Foreign Keys |
Parent Key | Child Key |
RCVD_BY_BN | RCVD_BY_BN |
"RCVD_BY to EQUIP_RCPT" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"RCVD_BY to EQUIP_RCPT" Bound Attachments |
Name | Current Value |
"MNFCTR_MDL to EQUIP" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | MNFCTR_MDL_RF |
Relationship Business Name | |
Physical Only | No |
Parent Table | MNFCTR_MDL |
Child Table | EQUIP |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"MNFCTR_MDL to EQUIP" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"MNFCTR_MDL to EQUIP" Foreign Keys |
Parent Key | Child Key |
MNFCTR_ID, MDL_NBR | MNFCTR_ID, MDL_NBR |
"MNFCTR_MDL to EQUIP" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"MNFCTR_MDL to EQUIP" Bound Attachments |
Name | Current Value |
"MNFCTR to MNFCTR_MDL" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | MNFCTR_RF |
Relationship Business Name | |
Physical Only | No |
Parent Table | MNFCTR |
Child Table | MNFCTR_MDL |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"MNFCTR to MNFCTR_MDL" Relationship Description |
Verb Sentence | A MNFCTR produces MNFCTR_MDL(s). |
Inverse Verb Sentence | A MNFCTR_MDL is produced by MNFCTR. |
Definition | |
Note |
"MNFCTR to MNFCTR_MDL" Foreign Keys |
Parent Key | Child Key |
MNFCTR_ID | MNFCTR_ID |
"MNFCTR to MNFCTR_MDL" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"MNFCTR to MNFCTR_MDL" Bound Attachments |
Name | Current Value |
"EQUIP_SUBCAT to MNFCTR_MDL" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | MNFTR_MDL_SUBCAT_RF |
Relationship Business Name | |
Physical Only | No |
Parent Table | EQUIP_SUBCAT |
Child Table | MNFCTR_MDL |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"EQUIP_SUBCAT to MNFCTR_MDL" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EQUIP_SUBCAT to MNFCTR_MDL" Foreign Keys |
Parent Key | Child Key |
EQUIP_CAT_ID, EQUIP_SUBCAT_ID | EQUIP_CAT_ID, EQUIP_SUBCAT_ID |
"EQUIP_SUBCAT to MNFCTR_MDL" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"EQUIP_SUBCAT to MNFCTR_MDL" Bound Attachments |
Name | Current Value |
"EQUIP to EQUIP" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | PARENT_EQUIP_RF |
Relationship Business Name | |
Physical Only | No |
Parent Table | EQUIP |
Child Table | EQUIP |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"EQUIP to EQUIP" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EQUIP to EQUIP" Foreign Keys |
Parent Key | Child Key |
EQUIP_ID | PARENT_EQUIPMENT_ID |
"EQUIP to EQUIP" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"EQUIP to EQUIP" Bound Attachments |
Name | Current Value |
"PWR_SPLY_MNFCTR_MDL to PWR_SPLY_CYCLE_ON" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | PWR_SPLY_MNFCTR_MDL_CYCLE_RF |
Relationship Business Name | |
Physical Only | No |
Parent Table | PWR_SPLY_MNFCTR_MDL |
Child Table | PWR_SPLY_CYCLE_ON |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"PWR_SPLY_MNFCTR_MDL to PWR_SPLY_CYCLE_ON" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"PWR_SPLY_MNFCTR_MDL to PWR_SPLY_CYCLE_ON" Foreign Keys |
Parent Key | Child Key |
MNFCTR_ID, MDL_NBR | MNFCTR_ID, MDL_NBR |
"PWR_SPLY_MNFCTR_MDL to PWR_SPLY_CYCLE_ON" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"PWR_SPLY_MNFCTR_MDL to PWR_SPLY_CYCLE_ON" Bound Attachments |
Name | Current Value |
"BLDG_AREA to RCPT_ITEM" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | RCPT_ITEM_BLDG_AREA_RF |
Relationship Business Name | |
Physical Only | No |
Parent Table | BLDG_AREA |
Child Table | RCPT_ITEM |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"BLDG_AREA to RCPT_ITEM" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"BLDG_AREA to RCPT_ITEM" Foreign Keys |
Parent Key | Child Key |
BLDG_ID, AREA_ID | BLDG_ID, AREA_ID |
"BLDG_AREA to RCPT_ITEM" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"BLDG_AREA to RCPT_ITEM" Bound Attachments |
Name | Current Value |
"UNIT_OF_MEASURE to MNFCTR_MDL" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | UOM_MNFCTR_MDL_RF |
Relationship Business Name | |
Physical Only | No |
Parent Table | UNIT_OF_MEASURE |
Child Table | MNFCTR_MDL |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"UNIT_OF_MEASURE to MNFCTR_MDL" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"UNIT_OF_MEASURE to MNFCTR_MDL" Foreign Keys |
Parent Key | Child Key |
UOM | DIMENSIONS_UOM |
"UNIT_OF_MEASURE to MNFCTR_MDL" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"UNIT_OF_MEASURE to MNFCTR_MDL" Bound Attachments |
Name | Current Value |