"SAMPLE to SMPL_SET_TEMP" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | |
Relationship Business Name | |
Physical Only | No |
Parent Table | SAMPLE |
Child Table | SMPL_SET_TEMP |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"SAMPLE to SMPL_SET_TEMP" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"SAMPLE to SMPL_SET_TEMP" Foreign Keys |
Parent Key | Child Key |
SMPL_ID | SMPL_ID |
"SAMPLE to SMPL_SET_TEMP" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"SAMPLE to SMPL_SET_TEMP" Bound Attachments |
Name | Current Value |
"SAMPLE to SAMPLE" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | |
Relationship Business Name | |
Physical Only | No |
Parent Table | SAMPLE |
Child Table | SAMPLE |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"SAMPLE to SAMPLE" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"SAMPLE to SAMPLE" Foreign Keys |
Parent Key | Child Key |
SMPL_ID | FAM_SMPL_ID |
"SAMPLE to SAMPLE" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"SAMPLE to SAMPLE" Bound Attachments |
Name | Current Value |
"CTRL_AREA to CTRL_AREA_CUST" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_ctrl_area_cust_to_ctrl_area |
Relationship Business Name | |
Physical Only | No |
Parent Table | CTRL_AREA |
Child Table | CTRL_AREA_CUST |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"CTRL_AREA to CTRL_AREA_CUST" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"CTRL_AREA to CTRL_AREA_CUST" Foreign Keys |
Parent Key | Child Key |
CTRL_AREA_ID | CTRL_AREA_ID |
"CTRL_AREA to CTRL_AREA_CUST" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"CTRL_AREA to CTRL_AREA_CUST" Bound Attachments |
Name | Current Value |
"EMPLOYEE to CTRL_AREA_CUST" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_ctrl_area_cust_to_employee |
Relationship Business Name | |
Physical Only | No |
Parent Table | EMPLOYEE |
Child Table | CTRL_AREA_CUST |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"EMPLOYEE to CTRL_AREA_CUST" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EMPLOYEE to CTRL_AREA_CUST" Foreign Keys |
Parent Key | Child Key |
BN | BN |
"EMPLOYEE to CTRL_AREA_CUST" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"EMPLOYEE to CTRL_AREA_CUST" Bound Attachments |
Name | Current Value |
"CTRL_AREA to CTRL_AREA_INVT" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_CTRL_AREA_INVT_TO_CTRL_INVT |
Relationship Business Name | |
Physical Only | No |
Parent Table | CTRL_AREA |
Child Table | CTRL_AREA_INVT |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"CTRL_AREA to CTRL_AREA_INVT" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"CTRL_AREA to CTRL_AREA_INVT" Foreign Keys |
Parent Key | Child Key |
CTRL_AREA_ID | CTRL_AREA_ID |
"CTRL_AREA to CTRL_AREA_INVT" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"CTRL_AREA to CTRL_AREA_INVT" Bound Attachments |
Name | Current Value |
"EMPLOYEE to CTRL_AREA_INVT" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | FK_CTRL_AREA_INVT_TO_EMP |
Relationship Business Name | |
Physical Only | No |
Parent Table | EMPLOYEE |
Child Table | CTRL_AREA_INVT |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"EMPLOYEE to CTRL_AREA_INVT" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EMPLOYEE to CTRL_AREA_INVT" Foreign Keys |
Parent Key | Child Key |
BN | BN |
"EMPLOYEE to CTRL_AREA_INVT" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"EMPLOYEE to CTRL_AREA_INVT" Bound Attachments |
Name | Current Value |
"CTRL_AREA_SUBAREA to CTRL_AREA_SUBAREA1" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_CTRL_AREA_SUB1_TO_SUBAREA |
Relationship Business Name | |
Physical Only | No |
Parent Table | CTRL_AREA_SUBAREA |
Child Table | CTRL_AREA_SUBAREA1 |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"CTRL_AREA_SUBAREA to CTRL_AREA_SUBAREA1" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"CTRL_AREA_SUBAREA to CTRL_AREA_SUBAREA1" Foreign Keys |
Parent Key | Child Key |
CTRL_AREA_ID, SUBAREA_ID | CTRL_AREA_ID, SUBAREA_ID |
"CTRL_AREA_SUBAREA to CTRL_AREA_SUBAREA1" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"CTRL_AREA_SUBAREA to CTRL_AREA_SUBAREA1" Bound Attachments |
Name | Current Value |
"CTRL_AREA_SUBAREA1 to CTRL_AREA_SUBAREA2" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_CTRL_AREA_SUB2_TO_SUBAREA1 |
Relationship Business Name | |
Physical Only | No |
Parent Table | CTRL_AREA_SUBAREA1 |
Child Table | CTRL_AREA_SUBAREA2 |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"CTRL_AREA_SUBAREA1 to CTRL_AREA_SUBAREA2" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"CTRL_AREA_SUBAREA1 to CTRL_AREA_SUBAREA2" Foreign Keys |
Parent Key | Child Key |
CTRL_AREA_ID, SUBAREA_ID, SUBAREA1_ID | CTRL_AREA_ID, SUBAREA_ID, SUBAREA1_ID |
"CTRL_AREA_SUBAREA1 to CTRL_AREA_SUBAREA2" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"CTRL_AREA_SUBAREA1 to CTRL_AREA_SUBAREA2" Bound Attachments |
Name | Current Value |
"CTRL_AREA to CTRL_AREA_SUBAREA" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_ctrl_area_subarea_to_ctrl_area |
Relationship Business Name | |
Physical Only | No |
Parent Table | CTRL_AREA |
Child Table | CTRL_AREA_SUBAREA |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"CTRL_AREA to CTRL_AREA_SUBAREA" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"CTRL_AREA to CTRL_AREA_SUBAREA" Foreign Keys |
Parent Key | Child Key |
CTRL_AREA_ID | CTRL_AREA_ID |
"CTRL_AREA to CTRL_AREA_SUBAREA" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"CTRL_AREA to CTRL_AREA_SUBAREA" Bound Attachments |
Name | Current Value |
"CTRL_AREA_TYPE to CTRL_AREA" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | fk_ctrl_area_to_ca_type |
Relationship Business Name | |
Physical Only | No |
Parent Table | CTRL_AREA_TYPE |
Child Table | CTRL_AREA |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"CTRL_AREA_TYPE to CTRL_AREA" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"CTRL_AREA_TYPE to CTRL_AREA" Foreign Keys |
Parent Key | Child Key |
TYPE_ID | TYPE_ID |
"CTRL_AREA_TYPE to CTRL_AREA" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"CTRL_AREA_TYPE to CTRL_AREA" Bound Attachments |
Name | Current Value |
"INSTR to CTRL_AREA" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | fk_ctrl_area_to_instr |
Relationship Business Name | |
Physical Only | No |
Parent Table | INSTR |
Child Table | CTRL_AREA |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"INSTR to CTRL_AREA" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"INSTR to CTRL_AREA" Foreign Keys |
Parent Key | Child Key |
INSTR_ID | INSTR_ID |
"INSTR to CTRL_AREA" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"INSTR to CTRL_AREA" Bound Attachments |
Name | Current Value |
"LAB to CTRL_AREA" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | fk_ctrl_area_to_lab |
Relationship Business Name | |
Physical Only | No |
Parent Table | LAB |
Child Table | CTRL_AREA |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"LAB to CTRL_AREA" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"LAB to CTRL_AREA" Foreign Keys |
Parent Key | Child Key |
LAB_ID | LAB_ID |
"LAB to CTRL_AREA" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"LAB to CTRL_AREA" Bound Attachments |
Name | Current Value |
"SMPL_HAND to CTRL_AREA" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | fk_ctrl_area_to_smpl_hand |
Relationship Business Name | |
Physical Only | No |
Parent Table | SMPL_HAND |
Child Table | CTRL_AREA |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"SMPL_HAND to CTRL_AREA" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"SMPL_HAND to CTRL_AREA" Foreign Keys |
Parent Key | Child Key |
HAND_ID | HAND_ID |
"SMPL_HAND to CTRL_AREA" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"SMPL_HAND to CTRL_AREA" Bound Attachments |
Name | Current Value |
"SMPL_STOR to CTRL_AREA" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | fk_ctrl_area_to_smpl_stor |
Relationship Business Name | |
Physical Only | No |
Parent Table | SMPL_STOR |
Child Table | CTRL_AREA |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"SMPL_STOR to CTRL_AREA" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"SMPL_STOR to CTRL_AREA" Foreign Keys |
Parent Key | Child Key |
STOR_ID | STOR_ID |
"SMPL_STOR to CTRL_AREA" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"SMPL_STOR to CTRL_AREA" Bound Attachments |
Name | Current Value |
"DOT_PKG_GRP to DOT_HAZ_MAT_TAB" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | fk_dhmt_to_dot_pkg_grp |
Relationship Business Name | |
Physical Only | No |
Parent Table | DOT_PKG_GRP |
Child Table | DOT_HAZ_MAT_TAB |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"DOT_PKG_GRP to DOT_HAZ_MAT_TAB" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"DOT_PKG_GRP to DOT_HAZ_MAT_TAB" Foreign Keys |
Parent Key | Child Key |
PKG_GRP_ID | PKG_GRP_ID |
"DOT_PKG_GRP to DOT_HAZ_MAT_TAB" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"DOT_PKG_GRP to DOT_HAZ_MAT_TAB" Bound Attachments |
Name | Current Value |
"EMPLOYEE to INSTR" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | FK_INSTR_GL_TO_EMP |
Relationship Business Name | |
Physical Only | No |
Parent Table | EMPLOYEE |
Child Table | INSTR |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"EMPLOYEE to INSTR" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EMPLOYEE to INSTR" Foreign Keys |
Parent Key | Child Key |
BN | GRP_LEAD_BN |
"EMPLOYEE to INSTR" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"EMPLOYEE to INSTR" Bound Attachments |
Name | Current Value |
"SMPL_ACT to ITEMS_LOG" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_items_log_to_smpl_act |
Relationship Business Name | |
Physical Only | No |
Parent Table | SMPL_ACT |
Child Table | ITEMS_LOG |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"SMPL_ACT to ITEMS_LOG" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"SMPL_ACT to ITEMS_LOG" Foreign Keys |
Parent Key | Child Key |
ACT_ID | ACT_ID |
"SMPL_ACT to ITEMS_LOG" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"SMPL_ACT to ITEMS_LOG" Bound Attachments |
Name | Current Value |
"EMPLOYEE to SMPL_SHIP" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | FK_ORIG_BY_BN_TO_EMP |
Relationship Business Name | |
Physical Only | No |
Parent Table | EMPLOYEE |
Child Table | SMPL_SHIP |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"EMPLOYEE to SMPL_SHIP" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EMPLOYEE to SMPL_SHIP" Foreign Keys |
Parent Key | Child Key |
BN | SHIP_ORD_ORIG_BY_BN |
"EMPLOYEE to SMPL_SHIP" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"EMPLOYEE to SMPL_SHIP" Bound Attachments |
Name | Current Value |
"CTRL_AREA to SAMPLE" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | fk_sample_to_ctrl_area |
Relationship Business Name | |
Physical Only | No |
Parent Table | CTRL_AREA |
Child Table | SAMPLE |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"CTRL_AREA to SAMPLE" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"CTRL_AREA to SAMPLE" Foreign Keys |
Parent Key | Child Key |
CTRL_AREA_ID | CTRL_AREA_ID |
"CTRL_AREA to SAMPLE" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"CTRL_AREA to SAMPLE" Bound Attachments |
Name | Current Value |
"CTRL_AREA_SUBAREA to SAMPLE" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | fk_sample_to_ctrl_area_subarea |
Relationship Business Name | |
Physical Only | No |
Parent Table | CTRL_AREA_SUBAREA |
Child Table | SAMPLE |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"CTRL_AREA_SUBAREA to SAMPLE" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"CTRL_AREA_SUBAREA to SAMPLE" Foreign Keys |
Parent Key | Child Key |
CTRL_AREA_ID, SUBAREA_ID | CTRL_AREA_ID, SUBAREA_ID |
"CTRL_AREA_SUBAREA to SAMPLE" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"CTRL_AREA_SUBAREA to SAMPLE" Bound Attachments |
Name | Current Value |
"MATL_ST to SAMPLE" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | fk_sample_to_mat_stat |
Relationship Business Name | |
Physical Only | No |
Parent Table | MATL_ST |
Child Table | SAMPLE |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"MATL_ST to SAMPLE" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"MATL_ST to SAMPLE" Foreign Keys |
Parent Key | Child Key |
ST_ID | ST_ID |
"MATL_ST to SAMPLE" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"MATL_ST to SAMPLE" Bound Attachments |
Name | Current Value |
"SMPL_CONT to SAMPLE" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | fk_sample_to_smpl_cont |
Relationship Business Name | |
Physical Only | No |
Parent Table | SMPL_CONT |
Child Table | SAMPLE |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"SMPL_CONT to SAMPLE" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"SMPL_CONT to SAMPLE" Foreign Keys |
Parent Key | Child Key |
CONT_ID | CONT_ID |
"SMPL_CONT to SAMPLE" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"SMPL_CONT to SAMPLE" Bound Attachments |
Name | Current Value |
"SMPL_STAT to SAMPLE" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | fk_sample_to_smpl_status |
Relationship Business Name | |
Physical Only | No |
Parent Table | SMPL_STAT |
Child Table | SAMPLE |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"SMPL_STAT to SAMPLE" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"SMPL_STAT to SAMPLE" Foreign Keys |
Parent Key | Child Key |
STAT_ID | STAT_ID |
"SMPL_STAT to SAMPLE" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"SMPL_STAT to SAMPLE" Bound Attachments |
Name | Current Value |
"CTRL_AREA_SUBAREA to SMPL_DELIV_REQ" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | fk_sdr_to_ctrl_subarea |
Relationship Business Name | |
Physical Only | No |
Parent Table | CTRL_AREA_SUBAREA |
Child Table | SMPL_DELIV_REQ |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"CTRL_AREA_SUBAREA to SMPL_DELIV_REQ" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"CTRL_AREA_SUBAREA to SMPL_DELIV_REQ" Foreign Keys |
Parent Key | Child Key |
CTRL_AREA_ID, SUBAREA_ID | CTRL_AREA_ID, SUBAREA_ID |
"CTRL_AREA_SUBAREA to SMPL_DELIV_REQ" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"CTRL_AREA_SUBAREA to SMPL_DELIV_REQ" Bound Attachments |
Name | Current Value |
"SMPL_HAZ_CLASS to SMPL_HAZ_CLASS_ITEM" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_shci_to_smpl_haz_class |
Relationship Business Name | |
Physical Only | No |
Parent Table | SMPL_HAZ_CLASS |
Child Table | SMPL_HAZ_CLASS_ITEM |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"SMPL_HAZ_CLASS to SMPL_HAZ_CLASS_ITEM" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"SMPL_HAZ_CLASS to SMPL_HAZ_CLASS_ITEM" Foreign Keys |
Parent Key | Child Key |
SMPL_HAZ_ID | SMPL_HAZ_ID |
"SMPL_HAZ_CLASS to SMPL_HAZ_CLASS_ITEM" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"SMPL_HAZ_CLASS to SMPL_HAZ_CLASS_ITEM" Bound Attachments |
Name | Current Value |
"CNTRY to SHIP_FACIL" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | FK_SHIP_FACIL_TO_CNTRY |
Relationship Business Name | |
Physical Only | No |
Parent Table | CNTRY |
Child Table | SHIP_FACIL |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"CNTRY to SHIP_FACIL" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"CNTRY to SHIP_FACIL" Foreign Keys |
Parent Key | Child Key |
CNTRY_ID | CNTRY_ID |
"CNTRY to SHIP_FACIL" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"CNTRY to SHIP_FACIL" Bound Attachments |
Name | Current Value |
"ATTACH_TYPE to SMPL_ATTACH" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | fk_smpl_attach_to_attach_type |
Relationship Business Name | |
Physical Only | No |
Parent Table | ATTACH_TYPE |
Child Table | SMPL_ATTACH |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"ATTACH_TYPE to SMPL_ATTACH" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"ATTACH_TYPE to SMPL_ATTACH" Foreign Keys |
Parent Key | Child Key |
ATTACH_TYPE_ID | ATTACH_TYPE_ID |
"ATTACH_TYPE to SMPL_ATTACH" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"ATTACH_TYPE to SMPL_ATTACH" Bound Attachments |
Name | Current Value |
"SMPL_ATTACH to SAMPLE_SMPL_ATTACH_ASSC" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_smpl_attach_to_sample |
Relationship Business Name | |
Physical Only | No |
Parent Table | SMPL_ATTACH |
Child Table | SAMPLE_SMPL_ATTACH_ASSC |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"SMPL_ATTACH to SAMPLE_SMPL_ATTACH_ASSC" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"SMPL_ATTACH to SAMPLE_SMPL_ATTACH_ASSC" Foreign Keys |
Parent Key | Child Key |
ATTACH_ID | ATTACH_ID |
"SMPL_ATTACH to SAMPLE_SMPL_ATTACH_ASSC" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"SMPL_ATTACH to SAMPLE_SMPL_ATTACH_ASSC" Bound Attachments |
Name | Current Value |
"SMPL_CONT to SMPL_CAN" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_smpl_can_to_smpl_cont |
Relationship Business Name | |
Physical Only | No |
Parent Table | SMPL_CONT |
Child Table | SMPL_CAN |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"SMPL_CONT to SMPL_CAN" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"SMPL_CONT to SMPL_CAN" Foreign Keys |
Parent Key | Child Key |
CONT_ID | CONT_ID |
"SMPL_CONT to SMPL_CAN" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"SMPL_CONT to SMPL_CAN" Bound Attachments |
Name | Current Value |
"HMMIS_CHEM to SMPL_CLASS" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | fk_smpl_class_to_hmmis_chem |
Relationship Business Name | |
Physical Only | No |
Parent Table | HMMIS_CHEM |
Child Table | SMPL_CLASS |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"HMMIS_CHEM to SMPL_CLASS" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"HMMIS_CHEM to SMPL_CLASS" Foreign Keys |
Parent Key | Child Key |
CHEM_RECID | CHEM_RECID |
"HMMIS_CHEM to SMPL_CLASS" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"HMMIS_CHEM to SMPL_CLASS" Bound Attachments |
Name | Current Value |
"SAMPLE to SMPL_CLASS" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_smpl_class_to_sample |
Relationship Business Name | |
Physical Only | No |
Parent Table | SAMPLE |
Child Table | SMPL_CLASS |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"SAMPLE to SMPL_CLASS" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"SAMPLE to SMPL_CLASS" Foreign Keys |
Parent Key | Child Key |
SMPL_ID | SMPL_ID |
"SAMPLE to SMPL_CLASS" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"SAMPLE to SMPL_CLASS" Bound Attachments |
Name | Current Value |
"SMPL_HAZ to SMPL_CLASS" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | fk_smpl_class_to_smpl_haz |
Relationship Business Name | |
Physical Only | No |
Parent Table | SMPL_HAZ |
Child Table | SMPL_CLASS |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"SMPL_HAZ to SMPL_CLASS" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"SMPL_HAZ to SMPL_CLASS" Foreign Keys |
Parent Key | Child Key |
SMPL_HAZ_ID | SMPL_HAZ_ID |
"SMPL_HAZ to SMPL_CLASS" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"SMPL_HAZ to SMPL_CLASS" Bound Attachments |
Name | Current Value |
"SAMPLE to SMPL_DEL_REQ" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_smpl_del_req_to_smpl |
Relationship Business Name | |
Physical Only | No |
Parent Table | SAMPLE |
Child Table | SMPL_DEL_REQ |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"SAMPLE to SMPL_DEL_REQ" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"SAMPLE to SMPL_DEL_REQ" Foreign Keys |
Parent Key | Child Key |
SMPL_ID | SMPL_ID |
"SAMPLE to SMPL_DEL_REQ" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"SAMPLE to SMPL_DEL_REQ" Bound Attachments |
Name | Current Value |
"CTRL_AREA to SMPL_DELIV_REQ" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | fk_smpL_deliv_req_to_ctrl_area |
Relationship Business Name | |
Physical Only | No |
Parent Table | CTRL_AREA |
Child Table | SMPL_DELIV_REQ |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"CTRL_AREA to SMPL_DELIV_REQ" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"CTRL_AREA to SMPL_DELIV_REQ" Foreign Keys |
Parent Key | Child Key |
CTRL_AREA_ID | CTRL_AREA_ID |
"CTRL_AREA to SMPL_DELIV_REQ" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"CTRL_AREA to SMPL_DELIV_REQ" Bound Attachments |
Name | Current Value |
"EMPLOYEE to SMPL_DELIV_REQ" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | fk_smpL_deliv_req_to_emp |
Relationship Business Name | |
Physical Only | No |
Parent Table | EMPLOYEE |
Child Table | SMPL_DELIV_REQ |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"EMPLOYEE to SMPL_DELIV_REQ" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EMPLOYEE to SMPL_DELIV_REQ" Foreign Keys |
Parent Key | Child Key |
BN | BN |
"EMPLOYEE to SMPL_DELIV_REQ" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"EMPLOYEE to SMPL_DELIV_REQ" Bound Attachments |
Name | Current Value |
"SAMPLE to SMPL_DELIV_REQ" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_smpL_deliv_req_to_smpl |
Relationship Business Name | |
Physical Only | No |
Parent Table | SAMPLE |
Child Table | SMPL_DELIV_REQ |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"SAMPLE to SMPL_DELIV_REQ" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"SAMPLE to SMPL_DELIV_REQ" Foreign Keys |
Parent Key | Child Key |
SMPL_ID | SMPL_ID |
"SAMPLE to SMPL_DELIV_REQ" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"SAMPLE to SMPL_DELIV_REQ" Bound Attachments |
Name | Current Value |
"SMPL_GRP to SAMPLE" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | fk_smpl_grp_to_sample |
Relationship Business Name | |
Physical Only | No |
Parent Table | SMPL_GRP |
Child Table | SAMPLE |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"SMPL_GRP to SAMPLE" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"SMPL_GRP to SAMPLE" Foreign Keys |
Parent Key | Child Key |
GRP_ID | GRP_ID |
"SMPL_GRP to SAMPLE" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"SMPL_GRP to SAMPLE" Bound Attachments |
Name | Current Value |
"DOT_HAZ_MAT_CLASS to SAMPLE" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | fk_smpl_haz_to_dot_haz_class |
Relationship Business Name | |
Physical Only | No |
Parent Table | DOT_HAZ_MAT_CLASS |
Child Table | SAMPLE |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"DOT_HAZ_MAT_CLASS to SAMPLE" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"DOT_HAZ_MAT_CLASS to SAMPLE" Foreign Keys |
Parent Key | Child Key |
DOT_CLASS_NBR, DOT_DIV_NBR | DOT_CLASS_NBR, DOT_DIV_NBR |
"DOT_HAZ_MAT_CLASS to SAMPLE" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"DOT_HAZ_MAT_CLASS to SAMPLE" Bound Attachments |
Name | Current Value |
"BEAM_ENGY_UOM to SMPL_IRRAD" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | FK_SMPL_IRRAD_TO_BEUOM |
Relationship Business Name | |
Physical Only | No |
Parent Table | BEAM_ENGY_UOM |
Child Table | SMPL_IRRAD |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"BEAM_ENGY_UOM to SMPL_IRRAD" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"BEAM_ENGY_UOM to SMPL_IRRAD" Foreign Keys |
Parent Key | Child Key |
BEAM_ENGY_UOM_ID | BEAM_ENGY_UOM_ID |
"BEAM_ENGY_UOM to SMPL_IRRAD" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"BEAM_ENGY_UOM to SMPL_IRRAD" Bound Attachments |
Name | Current Value |
"INSTR to SMPL_IRRAD" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_SMPL_IRRAD_TO_INSTR |
Relationship Business Name | |
Physical Only | No |
Parent Table | INSTR |
Child Table | SMPL_IRRAD |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"INSTR to SMPL_IRRAD" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"INSTR to SMPL_IRRAD" Foreign Keys |
Parent Key | Child Key |
INSTR_ID | INSTR_ID |
"INSTR to SMPL_IRRAD" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"INSTR to SMPL_IRRAD" Bound Attachments |
Name | Current Value |
"SAMPLE to SMPL_IRRAD" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_SMPL_IRRAD_TO_SMPL |
Relationship Business Name | |
Physical Only | No |
Parent Table | SAMPLE |
Child Table | SMPL_IRRAD |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"SAMPLE to SMPL_IRRAD" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"SAMPLE to SMPL_IRRAD" Foreign Keys |
Parent Key | Child Key |
SMPL_ID | SMPL_ID |
"SAMPLE to SMPL_IRRAD" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"SAMPLE to SMPL_IRRAD" Bound Attachments |
Name | Current Value |
"TIME_UOM to SMPL_IRRAD" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | FK_SMPL_IRRAD_TO_TIME_UOM |
Relationship Business Name | |
Physical Only | No |
Parent Table | TIME_UOM |
Child Table | SMPL_IRRAD |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"TIME_UOM to SMPL_IRRAD" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"TIME_UOM to SMPL_IRRAD" Foreign Keys |
Parent Key | Child Key |
TIME_UNIT_ID | TIME_UNIT_ID |
"TIME_UOM to SMPL_IRRAD" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"TIME_UOM to SMPL_IRRAD" Bound Attachments |
Name | Current Value |
"SAMPLE to SMPL_LOG" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_smpl_log_to_sample |
Relationship Business Name | |
Physical Only | No |
Parent Table | SAMPLE |
Child Table | SMPL_LOG |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"SAMPLE to SMPL_LOG" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"SAMPLE to SMPL_LOG" Foreign Keys |
Parent Key | Child Key |
SMPL_ID | SMPL_ID |
"SAMPLE to SMPL_LOG" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"SAMPLE to SMPL_LOG" Bound Attachments |
Name | Current Value |
"SMPL_ACT to SMPL_LOG" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_smpl_log_to_smpl_act |
Relationship Business Name | |
Physical Only | No |
Parent Table | SMPL_ACT |
Child Table | SMPL_LOG |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"SMPL_ACT to SMPL_LOG" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"SMPL_ACT to SMPL_LOG" Foreign Keys |
Parent Key | Child Key |
ACT_ID | ACT_ID |
"SMPL_ACT to SMPL_LOG" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"SMPL_ACT to SMPL_LOG" Bound Attachments |
Name | Current Value |
"PROPOSAL to SMPL_PRPSL_ASSC" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_smpl_prpsl_accs_to_prpsl |
Relationship Business Name | |
Physical Only | No |
Parent Table | PROPOSAL |
Child Table | SMPL_PRPSL_ASSC |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"PROPOSAL to SMPL_PRPSL_ASSC" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"PROPOSAL to SMPL_PRPSL_ASSC" Foreign Keys |
Parent Key | Child Key |
PRPSL_ID | PRPSL_ID |
"PROPOSAL to SMPL_PRPSL_ASSC" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"PROPOSAL to SMPL_PRPSL_ASSC" Bound Attachments |
Name | Current Value |
"SAMPLE to SMPL_PRPSL_ASSC" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_smpl_prpsl_assc_to_sample |
Relationship Business Name | |
Physical Only | No |
Parent Table | SAMPLE |
Child Table | SMPL_PRPSL_ASSC |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"SAMPLE to SMPL_PRPSL_ASSC" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"SAMPLE to SMPL_PRPSL_ASSC" Foreign Keys |
Parent Key | Child Key |
SMPL_ID | SMPL_ID |
"SAMPLE to SMPL_PRPSL_ASSC" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"SAMPLE to SMPL_PRPSL_ASSC" Bound Attachments |
Name | Current Value |
"RADIONUC to SMPL_RADIONUC_ASSC" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_smpl_radio_assc_to_radionuc |
Relationship Business Name | |
Physical Only | No |
Parent Table | RADIONUC |
Child Table | SMPL_RADIONUC_ASSC |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"RADIONUC to SMPL_RADIONUC_ASSC" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"RADIONUC to SMPL_RADIONUC_ASSC" Foreign Keys |
Parent Key | Child Key |
SYM_ID | SYM_ID |
"RADIONUC to SMPL_RADIONUC_ASSC" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"RADIONUC to SMPL_RADIONUC_ASSC" Bound Attachments |
Name | Current Value |
"SAMPLE to SMPL_RADIONUC_ASSC" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_smpl_radio_assc_to_smpl |
Relationship Business Name | |
Physical Only | No |
Parent Table | SAMPLE |
Child Table | SMPL_RADIONUC_ASSC |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"SAMPLE to SMPL_RADIONUC_ASSC" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"SAMPLE to SMPL_RADIONUC_ASSC" Foreign Keys |
Parent Key | Child Key |
SMPL_ID | SMPL_ID |
"SAMPLE to SMPL_RADIONUC_ASSC" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"SAMPLE to SMPL_RADIONUC_ASSC" Bound Attachments |
Name | Current Value |
"EMPLOYEE to SMPL_ROLE_EMP_ASSC" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_smpl_role_emp_assc_to_emp |
Relationship Business Name | |
Physical Only | No |
Parent Table | EMPLOYEE |
Child Table | SMPL_ROLE_EMP_ASSC |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"EMPLOYEE to SMPL_ROLE_EMP_ASSC" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EMPLOYEE to SMPL_ROLE_EMP_ASSC" Foreign Keys |
Parent Key | Child Key |
BN | BN |
"EMPLOYEE to SMPL_ROLE_EMP_ASSC" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"EMPLOYEE to SMPL_ROLE_EMP_ASSC" Bound Attachments |
Name | Current Value |
"SMPL_ROLE to SMPL_ROLE_TMPL" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_smpl_role_tmpl_to_smpl_role |
Relationship Business Name | |
Physical Only | No |
Parent Table | SMPL_ROLE |
Child Table | SMPL_ROLE_TMPL |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"SMPL_ROLE to SMPL_ROLE_TMPL" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"SMPL_ROLE to SMPL_ROLE_TMPL" Foreign Keys |
Parent Key | Child Key |
ROLE_ID | ROLE_ID |
"SMPL_ROLE to SMPL_ROLE_TMPL" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"SMPL_ROLE to SMPL_ROLE_TMPL" Bound Attachments |
Name | Current Value |
"SMPL_ROLE_GRP to SMPL_ROLE_TMPL" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_smpl_role_tmpl_to_smpl_role_grp |
Relationship Business Name | |
Physical Only | No |
Parent Table | SMPL_ROLE_GRP |
Child Table | SMPL_ROLE_TMPL |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"SMPL_ROLE_GRP to SMPL_ROLE_TMPL" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"SMPL_ROLE_GRP to SMPL_ROLE_TMPL" Foreign Keys |
Parent Key | Child Key |
SMPL_ROLE_GRP_ID | SMPL_ROLE_GRP_ID |
"SMPL_ROLE_GRP to SMPL_ROLE_TMPL" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"SMPL_ROLE_GRP to SMPL_ROLE_TMPL" Bound Attachments |
Name | Current Value |
"SAMPLE to SMPL_SMPL_SHIP_ASSC" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_SMPL_SHIP_ASSC_TO_SMPL |
Relationship Business Name | |
Physical Only | No |
Parent Table | SAMPLE |
Child Table | SMPL_SMPL_SHIP_ASSC |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"SAMPLE to SMPL_SMPL_SHIP_ASSC" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"SAMPLE to SMPL_SMPL_SHIP_ASSC" Foreign Keys |
Parent Key | Child Key |
SMPL_ID | SMPL_ID |
"SAMPLE to SMPL_SMPL_SHIP_ASSC" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"SAMPLE to SMPL_SMPL_SHIP_ASSC" Bound Attachments |
Name | Current Value |
"SMPL_SHIP to SMPL_SMPL_SHIP_ASSC" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_SMPL_SHIP_ASSC_TO_SMPL_SHIP |
Relationship Business Name | |
Physical Only | No |
Parent Table | SMPL_SHIP |
Child Table | SMPL_SMPL_SHIP_ASSC |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"SMPL_SHIP to SMPL_SMPL_SHIP_ASSC" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"SMPL_SHIP to SMPL_SMPL_SHIP_ASSC" Foreign Keys |
Parent Key | Child Key |
SMPL_SHIP_ID | SMPL_SHIP_ID |
"SMPL_SHIP to SMPL_SMPL_SHIP_ASSC" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"SMPL_SHIP to SMPL_SMPL_SHIP_ASSC" Bound Attachments |
Name | Current Value |
"SMPL_SHIP to SMPL_SHIP_ATTACH" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_SMPL_SHIP_ATT_TO_SMPL_SHIP |
Relationship Business Name | |
Physical Only | No |
Parent Table | SMPL_SHIP |
Child Table | SMPL_SHIP_ATTACH |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"SMPL_SHIP to SMPL_SHIP_ATTACH" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"SMPL_SHIP to SMPL_SHIP_ATTACH" Foreign Keys |
Parent Key | Child Key |
SMPL_SHIP_ID | SMPL_SHIP_ID |
"SMPL_SHIP to SMPL_SHIP_ATTACH" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"SMPL_SHIP to SMPL_SHIP_ATTACH" Bound Attachments |
Name | Current Value |
"EMPLOYEE to SMPL_SHIP" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | FK_SMPL_SHIP_TO_EMP |
Relationship Business Name | |
Physical Only | No |
Parent Table | EMPLOYEE |
Child Table | SMPL_SHIP |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"EMPLOYEE to SMPL_SHIP" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EMPLOYEE to SMPL_SHIP" Foreign Keys |
Parent Key | Child Key |
BN | MOD_BY_BN |
"EMPLOYEE to SMPL_SHIP" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"EMPLOYEE to SMPL_SHIP" Bound Attachments |
Name | Current Value |
"SHIP_FACIL to SMPL_SHIP" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | FK_SMPL_SHIP_TO_SHIP_FACIL |
Relationship Business Name | |
Physical Only | No |
Parent Table | SHIP_FACIL |
Child Table | SMPL_SHIP |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"SHIP_FACIL to SMPL_SHIP" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"SHIP_FACIL to SMPL_SHIP" Foreign Keys |
Parent Key | Child Key |
SHIP_FACIL_ID | SHIP_FACIL_ID |
"SHIP_FACIL to SMPL_SHIP" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"SHIP_FACIL to SMPL_SHIP" Bound Attachments |
Name | Current Value |
"SMPL_SHIP_STAT to SMPL_SHIP" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | FK_SMPL_SHIP_TO_SMPL_SHIP_STAT |
Relationship Business Name | |
Physical Only | No |
Parent Table | SMPL_SHIP_STAT |
Child Table | SMPL_SHIP |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"SMPL_SHIP_STAT to SMPL_SHIP" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"SMPL_SHIP_STAT to SMPL_SHIP" Foreign Keys |
Parent Key | Child Key |
STAT_ID | STAT_ID |
"SMPL_SHIP_STAT to SMPL_SHIP" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"SMPL_SHIP_STAT to SMPL_SHIP" Bound Attachments |
Name | Current Value |
"DOT_HAZ_MAT_CLASS to SAMPLE" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | fk_smpl_subhaz_to_dot_hazclass |
Relationship Business Name | |
Physical Only | No |
Parent Table | DOT_HAZ_MAT_CLASS |
Child Table | SAMPLE |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"DOT_HAZ_MAT_CLASS to SAMPLE" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"DOT_HAZ_MAT_CLASS to SAMPLE" Foreign Keys |
Parent Key | Child Key |
DOT_CLASS_NBR, DOT_DIV_NBR | DOT_SUB_CLASS_NBR, DOT_SUB_HAZ_DIV_NBR |
"DOT_HAZ_MAT_CLASS to SAMPLE" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"DOT_HAZ_MAT_CLASS to SAMPLE" Bound Attachments |
Name | Current Value |
"CTRL_AREA_SUBAREA1 to SAMPLE" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | fk_smpl_to_ctrl_area_subarea1 |
Relationship Business Name | |
Physical Only | No |
Parent Table | CTRL_AREA_SUBAREA1 |
Child Table | SAMPLE |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"CTRL_AREA_SUBAREA1 to SAMPLE" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"CTRL_AREA_SUBAREA1 to SAMPLE" Foreign Keys |
Parent Key | Child Key |
CTRL_AREA_ID, SUBAREA_ID, SUBAREA1_ID | CTRL_AREA_ID, SUBAREA_ID, SUBAREA1_ID |
"CTRL_AREA_SUBAREA1 to SAMPLE" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"CTRL_AREA_SUBAREA1 to SAMPLE" Bound Attachments |
Name | Current Value |
"CTRL_AREA_SUBAREA2 to SAMPLE" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | fk_smpl_to_ctrl_area_subarea2 |
Relationship Business Name | |
Physical Only | No |
Parent Table | CTRL_AREA_SUBAREA2 |
Child Table | SAMPLE |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"CTRL_AREA_SUBAREA2 to SAMPLE" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"CTRL_AREA_SUBAREA2 to SAMPLE" Foreign Keys |
Parent Key | Child Key |
CTRL_AREA_ID, SUBAREA_ID, SUBAREA1_ID, SUBAREA2_ID | CTRL_AREA_ID, SUBAREA_ID, SUBAREA1_ID, SUBAREA2_ID |
"CTRL_AREA_SUBAREA2 to SAMPLE" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"CTRL_AREA_SUBAREA2 to SAMPLE" Bound Attachments |
Name | Current Value |
"DOT_PKG_GRP to SAMPLE" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | fk_smpl_to_dot_pkg_grp |
Relationship Business Name | |
Physical Only | No |
Parent Table | DOT_PKG_GRP |
Child Table | SAMPLE |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"DOT_PKG_GRP to SAMPLE" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"DOT_PKG_GRP to SAMPLE" Foreign Keys |
Parent Key | Child Key |
PKG_GRP_ID | PKG_GRP_ID |
"DOT_PKG_GRP to SAMPLE" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"DOT_PKG_GRP to SAMPLE" Bound Attachments |
Name | Current Value |
"SMPL_CAN to SAMPLE" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | fk_smpl_to_smpl_can |
Relationship Business Name | |
Physical Only | No |
Parent Table | SMPL_CAN |
Child Table | SAMPLE |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"SMPL_CAN to SAMPLE" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"SMPL_CAN to SAMPLE" Foreign Keys |
Parent Key | Child Key |
CAN_ID, CONT_ID | CAN_ID, CONT_ID |
"SMPL_CAN to SAMPLE" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"SMPL_CAN to SAMPLE" Bound Attachments |
Name | Current Value |
"SMPL_SPEC_REQ to SAMPLE" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | fk_smpl_to_smpl_spec_req |
Relationship Business Name | |
Physical Only | No |
Parent Table | SMPL_SPEC_REQ |
Child Table | SAMPLE |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"SMPL_SPEC_REQ to SAMPLE" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"SMPL_SPEC_REQ to SAMPLE" Foreign Keys |
Parent Key | Child Key |
REQ_ID | REQ_ID |
"SMPL_SPEC_REQ to SAMPLE" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"SMPL_SPEC_REQ to SAMPLE" Bound Attachments |
Name | Current Value |
"UNIT_LEN to SAMPLE" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | fk_smpl_to_uol |
Relationship Business Name | |
Physical Only | No |
Parent Table | UNIT_LEN |
Child Table | SAMPLE |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"UNIT_LEN to SAMPLE" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"UNIT_LEN to SAMPLE" Foreign Keys |
Parent Key | Child Key |
LEN_UNIT_ID | LEN_UNIT_ID |
"UNIT_LEN to SAMPLE" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"UNIT_LEN to SAMPLE" Bound Attachments |
Name | Current Value |
"CTRL_AREA_SUBAREA to SMPL_TRANS" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_SMPL_TRAN_TO_CTRL_SUB |
Relationship Business Name | |
Physical Only | No |
Parent Table | CTRL_AREA_SUBAREA |
Child Table | SMPL_TRANS |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"CTRL_AREA_SUBAREA to SMPL_TRANS" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"CTRL_AREA_SUBAREA to SMPL_TRANS" Foreign Keys |
Parent Key | Child Key |
CTRL_AREA_ID, SUBAREA_ID | CTRL_AREA_ID, SUBAREA_ID |
"CTRL_AREA_SUBAREA to SMPL_TRANS" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"CTRL_AREA_SUBAREA to SMPL_TRANS" Bound Attachments |
Name | Current Value |
"CTRL_AREA to SMPL_TRANS" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_smpl_trans_to_ctrl_area |
Relationship Business Name | |
Physical Only | No |
Parent Table | CTRL_AREA |
Child Table | SMPL_TRANS |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"CTRL_AREA to SMPL_TRANS" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"CTRL_AREA to SMPL_TRANS" Foreign Keys |
Parent Key | Child Key |
CTRL_AREA_ID | CTRL_AREA_ID |
"CTRL_AREA to SMPL_TRANS" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"CTRL_AREA to SMPL_TRANS" Bound Attachments |
Name | Current Value |
"SAMPLE to SMPL_TRANS" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_smpl_trans_to_sample |
Relationship Business Name | |
Physical Only | No |
Parent Table | SAMPLE |
Child Table | SMPL_TRANS |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"SAMPLE to SMPL_TRANS" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"SAMPLE to SMPL_TRANS" Foreign Keys |
Parent Key | Child Key |
SMPL_ID | SMPL_ID |
"SAMPLE to SMPL_TRANS" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"SAMPLE to SMPL_TRANS" Bound Attachments |
Name | Current Value |
"CTRL_AREA to SMPL_TRANS" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | fk_smpl_trans_to_to_ctrl_area |
Relationship Business Name | |
Physical Only | No |
Parent Table | CTRL_AREA |
Child Table | SMPL_TRANS |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"CTRL_AREA to SMPL_TRANS" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"CTRL_AREA to SMPL_TRANS" Foreign Keys |
Parent Key | Child Key |
CTRL_AREA_ID | TO_CTRL_AREA_ID |
"CTRL_AREA to SMPL_TRANS" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"CTRL_AREA to SMPL_TRANS" Bound Attachments |
Name | Current Value |
"SMPL_ROLE to SMPL_ROLE_EMP_ASSC" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_srea_to_smpl_role |
Relationship Business Name | |
Physical Only | No |
Parent Table | SMPL_ROLE |
Child Table | SMPL_ROLE_EMP_ASSC |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"SMPL_ROLE to SMPL_ROLE_EMP_ASSC" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"SMPL_ROLE to SMPL_ROLE_EMP_ASSC" Foreign Keys |
Parent Key | Child Key |
ROLE_ID | ROLE_ID |
"SMPL_ROLE to SMPL_ROLE_EMP_ASSC" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"SMPL_ROLE to SMPL_ROLE_EMP_ASSC" Bound Attachments |
Name | Current Value |
"CTRL_AREA to SMPL_ROLE_EMP_CTRL_AREA_ASSC" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_srecaa_to_ctrl_area |
Relationship Business Name | |
Physical Only | No |
Parent Table | CTRL_AREA |
Child Table | SMPL_ROLE_EMP_CTRL_AREA_ASSC |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"CTRL_AREA to SMPL_ROLE_EMP_CTRL_AREA_ASSC" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"CTRL_AREA to SMPL_ROLE_EMP_CTRL_AREA_ASSC" Foreign Keys |
Parent Key | Child Key |
CTRL_AREA_ID | CTRL_AREA_ID |
"CTRL_AREA to SMPL_ROLE_EMP_CTRL_AREA_ASSC" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"CTRL_AREA to SMPL_ROLE_EMP_CTRL_AREA_ASSC" Bound Attachments |
Name | Current Value |
"SMPL_ROLE_EMP_ASSC to SMPL_ROLE_EMP_CTRL_AREA_ASSC" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_srecaa_to_smpl_role_emp_ass |
Relationship Business Name | |
Physical Only | No |
Parent Table | SMPL_ROLE_EMP_ASSC |
Child Table | SMPL_ROLE_EMP_CTRL_AREA_ASSC |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"SMPL_ROLE_EMP_ASSC to SMPL_ROLE_EMP_CTRL_AREA_ASSC" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"SMPL_ROLE_EMP_ASSC to SMPL_ROLE_EMP_CTRL_AREA_ASSC" Foreign Keys |
Parent Key | Child Key |
ROLE_ID, BN | ROLE_ID, BN |
"SMPL_ROLE_EMP_ASSC to SMPL_ROLE_EMP_CTRL_AREA_ASSC" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"SMPL_ROLE_EMP_ASSC to SMPL_ROLE_EMP_CTRL_AREA_ASSC" Bound Attachments |
Name | Current Value |
"SAMPLE to SAMPLE_SMPL_ATTACH_ASSC" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_ssaa_to_sample |
Relationship Business Name | |
Physical Only | No |
Parent Table | SAMPLE |
Child Table | SAMPLE_SMPL_ATTACH_ASSC |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"SAMPLE to SAMPLE_SMPL_ATTACH_ASSC" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"SAMPLE to SAMPLE_SMPL_ATTACH_ASSC" Foreign Keys |
Parent Key | Child Key |
SMPL_ID | SMPL_ID |
"SAMPLE to SAMPLE_SMPL_ATTACH_ASSC" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"SAMPLE to SAMPLE_SMPL_ATTACH_ASSC" Bound Attachments |
Name | Current Value |
"SAMPLE to SMPL_SMPL_FORM_ASSC" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_ssfa_to_smpl |
Relationship Business Name | |
Physical Only | No |
Parent Table | SAMPLE |
Child Table | SMPL_SMPL_FORM_ASSC |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"SAMPLE to SMPL_SMPL_FORM_ASSC" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"SAMPLE to SMPL_SMPL_FORM_ASSC" Foreign Keys |
Parent Key | Child Key |
SMPL_ID | SMPL_ID |
"SAMPLE to SMPL_SMPL_FORM_ASSC" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"SAMPLE to SMPL_SMPL_FORM_ASSC" Bound Attachments |
Name | Current Value |
"SMPL_FORM to SMPL_SMPL_FORM_ASSC" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_ssfa_to_smpl_form |
Relationship Business Name | |
Physical Only | No |
Parent Table | SMPL_FORM |
Child Table | SMPL_SMPL_FORM_ASSC |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"SMPL_FORM to SMPL_SMPL_FORM_ASSC" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"SMPL_FORM to SMPL_SMPL_FORM_ASSC" Foreign Keys |
Parent Key | Child Key |
SMPL_FORM_ID | SMPL_FORM_ID |
"SMPL_FORM to SMPL_SMPL_FORM_ASSC" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"SMPL_FORM to SMPL_SMPL_FORM_ASSC" Bound Attachments |
Name | Current Value |
"SAMPLE to SMPL_SPEC_REQ_ASSC" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_ssra_to_sample |
Relationship Business Name | |
Physical Only | No |
Parent Table | SAMPLE |
Child Table | SMPL_SPEC_REQ_ASSC |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"SAMPLE to SMPL_SPEC_REQ_ASSC" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"SAMPLE to SMPL_SPEC_REQ_ASSC" Foreign Keys |
Parent Key | Child Key |
SMPL_ID | SMPL_ID |
"SAMPLE to SMPL_SPEC_REQ_ASSC" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"SAMPLE to SMPL_SPEC_REQ_ASSC" Bound Attachments |
Name | Current Value |
"SMPL_SPEC_REQ to SMPL_SPEC_REQ_ASSC" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_ssra_to_smpl_spec_req |
Relationship Business Name | |
Physical Only | No |
Parent Table | SMPL_SPEC_REQ |
Child Table | SMPL_SPEC_REQ_ASSC |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"SMPL_SPEC_REQ to SMPL_SPEC_REQ_ASSC" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"SMPL_SPEC_REQ to SMPL_SPEC_REQ_ASSC" Foreign Keys |
Parent Key | Child Key |
REQ_ID | REQ_ID |
"SMPL_SPEC_REQ to SMPL_SPEC_REQ_ASSC" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"SMPL_SPEC_REQ to SMPL_SPEC_REQ_ASSC" Bound Attachments |
Name | Current Value |
"SMPL_ATTACH to SMPL_SHIP_SMPL_ATTCH_ASSC" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_SSSAA_TO_SMPL_ATTACH |
Relationship Business Name | |
Physical Only | No |
Parent Table | SMPL_ATTACH |
Child Table | SMPL_SHIP_SMPL_ATTCH_ASSC |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"SMPL_ATTACH to SMPL_SHIP_SMPL_ATTCH_ASSC" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"SMPL_ATTACH to SMPL_SHIP_SMPL_ATTCH_ASSC" Foreign Keys |
Parent Key | Child Key |
ATTACH_ID | ATTACH_ID |
"SMPL_ATTACH to SMPL_SHIP_SMPL_ATTCH_ASSC" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"SMPL_ATTACH to SMPL_SHIP_SMPL_ATTCH_ASSC" Bound Attachments |
Name | Current Value |
"SMPL_SHIP to SMPL_SHIP_SMPL_ATTCH_ASSC" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_SSSAA_TO_SMPL_SHIP |
Relationship Business Name | |
Physical Only | No |
Parent Table | SMPL_SHIP |
Child Table | SMPL_SHIP_SMPL_ATTCH_ASSC |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"SMPL_SHIP to SMPL_SHIP_SMPL_ATTCH_ASSC" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"SMPL_SHIP to SMPL_SHIP_SMPL_ATTCH_ASSC" Foreign Keys |
Parent Key | Child Key |
SMPL_SHIP_ID | SMPL_SHIP_ID |
"SMPL_SHIP to SMPL_SHIP_SMPL_ATTCH_ASSC" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"SMPL_SHIP to SMPL_SHIP_SMPL_ATTCH_ASSC" Bound Attachments |
Name | Current Value |
"CTRL_AREA_SUBAREA to SMPL_TRANS" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | FK_TO_SMPL_TRANS_TO_CA_SUB |
Relationship Business Name | |
Physical Only | No |
Parent Table | CTRL_AREA_SUBAREA |
Child Table | SMPL_TRANS |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"CTRL_AREA_SUBAREA to SMPL_TRANS" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"CTRL_AREA_SUBAREA to SMPL_TRANS" Foreign Keys |
Parent Key | Child Key |
CTRL_AREA_ID, SUBAREA_ID | CTRL_AREA_ID, TO_SUBAREA_ID |
"CTRL_AREA_SUBAREA to SMPL_TRANS" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"CTRL_AREA_SUBAREA to SMPL_TRANS" Bound Attachments |
Name | Current Value |
"EMPLOYEE to USER_PROFILE" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | fk_user_profile_run_as_to_emp |
Relationship Business Name | |
Physical Only | No |
Parent Table | EMPLOYEE |
Child Table | USER_PROFILE |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"EMPLOYEE to USER_PROFILE" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EMPLOYEE to USER_PROFILE" Foreign Keys |
Parent Key | Child Key |
BN | BN |
"EMPLOYEE to USER_PROFILE" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"EMPLOYEE to USER_PROFILE" Bound Attachments |
Name | Current Value |
"EMPLOYEE to USER_PROFILE" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_user_profile_to_emp |
Relationship Business Name | |
Physical Only | No |
Parent Table | EMPLOYEE |
Child Table | USER_PROFILE |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"EMPLOYEE to USER_PROFILE" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EMPLOYEE to USER_PROFILE" Foreign Keys |
Parent Key | Child Key |
BN | BN |
"EMPLOYEE to USER_PROFILE" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"EMPLOYEE to USER_PROFILE" Bound Attachments |
Name | Current Value |