| "PERSON to PRPSL_INSTR" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | PERSON |
| Child Table | PRPSL_INSTR |
| Cardinality | Zero or One to Zero or More |
| Existence | Optional |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "PERSON to PRPSL_INSTR" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "PERSON to PRPSL_INSTR" Foreign Keys |
| Parent Key | Child Key |
| PERSON_ID | feas_review_person_id |
| "PERSON to PRPSL_INSTR" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "PERSON to PRPSL_INSTR" Bound Attachments |
| Name | Current Value |
| "EXPT_RSRC_SCHED to EXPT_RSRC_SCHED_LOG" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | |
| Relationship Business Name | FK_ERSL_TO_EXPT_RSRC_SCHED |
| Physical Only | No |
| Parent Table | EXPT_RSRC_SCHED |
| Child Table | EXPT_RSRC_SCHED_LOG |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "EXPT_RSRC_SCHED to EXPT_RSRC_SCHED_LOG" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "EXPT_RSRC_SCHED to EXPT_RSRC_SCHED_LOG" Foreign Keys |
| Parent Key | Child Key |
| EXPT_RSRC_ID | EXPT_RSRC_ID |
| "EXPT_RSRC_SCHED to EXPT_RSRC_SCHED_LOG" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "EXPT_RSRC_SCHED to EXPT_RSRC_SCHED_LOG" Bound Attachments |
| Name | Current Value |
| "EXPT_RSRC_TYPE to CASC" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | EXPT_RSRC_TYPE |
| Child Table | CASC |
| Cardinality | One to Zero or One |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "EXPT_RSRC_TYPE to CASC" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "EXPT_RSRC_TYPE to CASC" Foreign Keys |
| Parent Key | Child Key |
| EXPT_RSRC_TYPE_ID, FACIL_ID | EXPT_RSRC_TYPE_ID, FACIL_ID |
| "EXPT_RSRC_TYPE to CASC" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "EXPT_RSRC_TYPE to CASC" 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 |
| "UOM to EXPT_RSRC" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | UOM |
| Child Table | EXPT_RSRC |
| Cardinality | Zero or One to Zero or More |
| Existence | Optional |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "UOM to EXPT_RSRC" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | An EXPT_RSRC fk_beam_cen_btm_to_uom UOM. |
| Definition | |
| Note |
| "UOM to EXPT_RSRC" Foreign Keys |
| Parent Key | Child Key |
| UNIT_ID | BEAM_CENTER_BTM_UOM |
| "UOM to EXPT_RSRC" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "UOM to EXPT_RSRC" Bound Attachments |
| Name | Current Value |
| "EMPLOYEE to ACCESS_REQ" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_ACC_REQ_TO_EMP |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | EMPLOYEE |
| Child Table | ACCESS_REQ |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "EMPLOYEE to ACCESS_REQ" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "EMPLOYEE to ACCESS_REQ" Foreign Keys |
| Parent Key | Child Key |
| BN | BN |
| "EMPLOYEE to ACCESS_REQ" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "EMPLOYEE to ACCESS_REQ" Bound Attachments |
| Name | Current Value |
| "EXP_USER_ROLE to ACCESS_REQ" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_ACC_REQ_TO_EXP_USR_ROLE |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | EXP_USER_ROLE |
| Child Table | ACCESS_REQ |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "EXP_USER_ROLE to ACCESS_REQ" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "EXP_USER_ROLE to ACCESS_REQ" Foreign Keys |
| Parent Key | Child Key |
| ROLE_ID | ROLE_ID |
| "EXP_USER_ROLE to ACCESS_REQ" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "EXP_USER_ROLE to ACCESS_REQ" Bound Attachments |
| Name | Current Value |
| "EXPT_RSRC_FACIL to ACCESS_REQ" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_ACC_REQ_TO_EXPT_RSRC_FACIL |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | EXPT_RSRC_FACIL |
| Child Table | ACCESS_REQ |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "EXPT_RSRC_FACIL to ACCESS_REQ" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "EXPT_RSRC_FACIL to ACCESS_REQ" Foreign Keys |
| Parent Key | Child Key |
| FACIL_ID | FACIL_ID |
| "EXPT_RSRC_FACIL to ACCESS_REQ" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "EXPT_RSRC_FACIL to ACCESS_REQ" Bound Attachments |
| Name | Current Value |
| "UOM to EXPT_RSRC" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | fk_bore_uom_to_uom |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | UOM |
| Child Table | EXPT_RSRC |
| Cardinality | Zero or One to Zero or More |
| Existence | Optional |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "UOM to EXPT_RSRC" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "UOM to EXPT_RSRC" Foreign Keys |
| Parent Key | Child Key |
| UNIT_ID | BORE_SIZE_UOM |
| "UOM to EXPT_RSRC" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "UOM to EXPT_RSRC" Bound Attachments |
| Name | Current Value |
| "UOM to EXPT_RSRC" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | fk_brkdwn_uom_to_uom |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | UOM |
| Child Table | EXPT_RSRC |
| Cardinality | Zero or One to Zero or More |
| Existence | Optional |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "UOM to EXPT_RSRC" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "UOM to EXPT_RSRC" Foreign Keys |
| Parent Key | Child Key |
| UNIT_ID | BRKDWN_TIME_UOM |
| "UOM to EXPT_RSRC" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "UOM to EXPT_RSRC" Bound Attachments |
| Name | Current Value |
| "UOM to CASC" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | fk_casc_in_to_uom |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | UOM |
| Child Table | CASC |
| Cardinality | Zero or One to Zero or More |
| Existence | Optional |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "UOM to CASC" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "UOM to CASC" Foreign Keys |
| Parent Key | Child Key |
| UNIT_ID | IN_DIM_UOM_ID |
| "UOM to CASC" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "UOM to CASC" Bound Attachments |
| Name | Current Value |
| "UOM to CASC" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | fk_casc_out_to_uom |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | UOM |
| Child Table | CASC |
| Cardinality | Zero or One to Zero or More |
| Existence | Optional |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "UOM to CASC" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "UOM to CASC" Foreign Keys |
| Parent Key | Child Key |
| UNIT_ID | OUT_DIM_UOM_ID |
| "UOM to CASC" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "UOM to CASC" Bound Attachments |
| Name | Current Value |
| "UOM to CASC" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | fk_casc_press_to_uom |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | UOM |
| Child Table | CASC |
| Cardinality | Zero or One to Zero or More |
| Existence | Optional |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "UOM to CASC" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "UOM to CASC" Foreign Keys |
| Parent Key | Child Key |
| UNIT_ID | PRESS_UOM_ID |
| "UOM to CASC" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "UOM to CASC" Bound Attachments |
| Name | Current Value |
| "UOM to CASC" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | fk_casc_temp_to_uom |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | UOM |
| Child Table | CASC |
| Cardinality | Zero or One to Zero or More |
| Existence | Optional |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "UOM to CASC" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "UOM to CASC" Foreign Keys |
| Parent Key | Child Key |
| UNIT_ID | TEMP_UOM_ID |
| "UOM to CASC" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "UOM to CASC" Bound Attachments |
| Name | Current Value |
| "EXPT_RSRC_STAT to CASC" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | fk_casc_to_expt_rsrc_stat |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | EXPT_RSRC_STAT |
| Child Table | CASC |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "EXPT_RSRC_STAT to CASC" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "EXPT_RSRC_STAT to CASC" Foreign Keys |
| Parent Key | Child Key |
| STAT_ID | STAT_ID |
| "EXPT_RSRC_STAT to CASC" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "EXPT_RSRC_STAT to CASC" Bound Attachments |
| Name | Current Value |
| "CASC to CASC_USAGE" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_CASC_USAGE_TO_CASC |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | CASC |
| Child Table | CASC_USAGE |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "CASC to CASC_USAGE" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "CASC to CASC_USAGE" Foreign Keys |
| Parent Key | Child Key |
| EXPT_RSRC_TYPE_ID, FACIL_ID | EXPT_RSRC_TYPE_ID, FACIL_ID |
| "CASC to CASC_USAGE" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "CASC to CASC_USAGE" Bound Attachments |
| Name | Current Value |
| "PERSON to CASC_USAGE" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | FK_CASC_USAGE_TO_PERSON |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | PERSON |
| Child Table | CASC_USAGE |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "PERSON to CASC_USAGE" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "PERSON to CASC_USAGE" Foreign Keys |
| Parent Key | Child Key |
| PERSON_ID | PERSON_ID |
| "PERSON to CASC_USAGE" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "PERSON to CASC_USAGE" Bound Attachments |
| Name | Current Value |
| "SAMPLE to CASC_USAGE" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | FK_CASC_USAGE_TO_SAMPLE |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | SAMPLE |
| Child Table | CASC_USAGE |
| 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 CASC_USAGE" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "SAMPLE to CASC_USAGE" Foreign Keys |
| Parent Key | Child Key |
| SMPL_ID | SMPL_ID |
| "SAMPLE to CASC_USAGE" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "SAMPLE to CASC_USAGE" Bound Attachments |
| Name | Current Value |
| "UOM to CASC" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | fk_casc_vol_to_uom |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | UOM |
| Child Table | CASC |
| Cardinality | Zero or One to Zero or More |
| Existence | Optional |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "UOM to CASC" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "UOM to CASC" Foreign Keys |
| Parent Key | Child Key |
| UNIT_ID | VOL_UOM |
| "UOM to CASC" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "UOM to CASC" Bound Attachments |
| Name | Current Value |
| "CASC to CASC_ATTACH_ASSC" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | fk_cascaa_to_casc |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | CASC |
| Child Table | CASC_ATTACH_ASSC |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "CASC to CASC_ATTACH_ASSC" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "CASC to CASC_ATTACH_ASSC" Foreign Keys |
| Parent Key | Child Key |
| EXPT_RSRC_TYPE_ID, FACIL_ID | EXPT_RSRC_TYPE_ID, FACIL_ID |
| "CASC to CASC_ATTACH_ASSC" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "CASC to CASC_ATTACH_ASSC" Bound Attachments |
| Name | Current Value |
| "EXPT_RSRC_TYPE to CASC_EXPT_RSRC_TYPE_ASSC" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_CASCERTA_TO_EXPT_RSRC_TYPE |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | EXPT_RSRC_TYPE |
| Child Table | CASC_EXPT_RSRC_TYPE_ASSC |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "EXPT_RSRC_TYPE to CASC_EXPT_RSRC_TYPE_ASSC" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "EXPT_RSRC_TYPE to CASC_EXPT_RSRC_TYPE_ASSC" Foreign Keys |
| Parent Key | Child Key |
| EXPT_RSRC_TYPE_ID, FACIL_ID | EXPT_RSRC_TYPE2_ID, FACIL_ID |
| "EXPT_RSRC_TYPE to CASC_EXPT_RSRC_TYPE_ASSC" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "EXPT_RSRC_TYPE to CASC_EXPT_RSRC_TYPE_ASSC" Bound Attachments |
| Name | Current Value |
| "CASC to CASC_EXPT_SCHED_ASSC" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | fk_cascesa_to_casc |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | CASC |
| Child Table | CASC_EXPT_SCHED_ASSC |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "CASC to CASC_EXPT_SCHED_ASSC" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "CASC to CASC_EXPT_SCHED_ASSC" Foreign Keys |
| Parent Key | Child Key |
| EXPT_RSRC_TYPE_ID, FACIL_ID | EXPT_RSRC_TYPE_ID, FACIL_ID |
| "CASC to CASC_EXPT_SCHED_ASSC" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "CASC to CASC_EXPT_SCHED_ASSC" Bound Attachments |
| Name | Current Value |
| "EXPT_SCHED to CASC_EXPT_SCHED_ASSC" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | fk_cascesa_to_expt_sched |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | EXPT_SCHED |
| Child Table | CASC_EXPT_SCHED_ASSC |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "EXPT_SCHED to CASC_EXPT_SCHED_ASSC" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "EXPT_SCHED to CASC_EXPT_SCHED_ASSC" Foreign Keys |
| Parent Key | Child Key |
| PRPSL_ID, SUBMISS_NBR, INSTR_ID, RUN_NBR | PRPSL_ID, SUBMISS_NBR, INSTR_ID, RUN_NBR |
| "EXPT_SCHED to CASC_EXPT_SCHED_ASSC" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "EXPT_SCHED to CASC_EXPT_SCHED_ASSC" Bound Attachments |
| Name | Current Value |
| "CASC to CASC_INSTR_ASSC" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | fk_cascia_to_ercasc |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | CASC |
| Child Table | CASC_INSTR_ASSC |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "CASC to CASC_INSTR_ASSC" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "CASC to CASC_INSTR_ASSC" Foreign Keys |
| Parent Key | Child Key |
| EXPT_RSRC_TYPE_ID, FACIL_ID | EXPT_RSRC_TYPE_ID, FACIL_ID |
| "CASC to CASC_INSTR_ASSC" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "CASC to CASC_INSTR_ASSC" Bound Attachments |
| Name | Current Value |
| "INSTR to CASC_INSTR_ASSC" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | fk_cascia_to_instr |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | INSTR |
| Child Table | CASC_INSTR_ASSC |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "INSTR to CASC_INSTR_ASSC" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "INSTR to CASC_INSTR_ASSC" Foreign Keys |
| Parent Key | Child Key |
| INSTR_ID | INSTR_ID |
| "INSTR to CASC_INSTR_ASSC" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "INSTR to CASC_INSTR_ASSC" Bound Attachments |
| Name | Current Value |
| "CASC to CASC_EXPT_RSRC_TYPE_ASSC" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_CASCTA_TO_ERCASC |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | CASC |
| Child Table | CASC_EXPT_RSRC_TYPE_ASSC |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "CASC to CASC_EXPT_RSRC_TYPE_ASSC" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "CASC to CASC_EXPT_RSRC_TYPE_ASSC" Foreign Keys |
| Parent Key | Child Key |
| EXPT_RSRC_TYPE_ID, FACIL_ID | EXPT_RSRC_TYPE_ID, FACIL_ID |
| "CASC to CASC_EXPT_RSRC_TYPE_ASSC" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "CASC to CASC_EXPT_RSRC_TYPE_ASSC" Bound Attachments |
| Name | Current Value |
| "UOM to EXPT_RSRC" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | fk_cell_uom_to_uom |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | UOM |
| Child Table | EXPT_RSRC |
| Cardinality | Zero or One to Zero or More |
| Existence | Optional |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "UOM to EXPT_RSRC" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "UOM to EXPT_RSRC" Foreign Keys |
| Parent Key | Child Key |
| UNIT_ID | CELL_SIZE_UOM |
| "UOM to EXPT_RSRC" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "UOM to EXPT_RSRC" Bound Attachments |
| Name | Current Value |
| "EXPT_RSRC_ATTACH to CASC_ATTACH_ASSC" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | fk_cscaa_to_expt_rsrc_attach |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | EXPT_RSRC_ATTACH |
| Child Table | CASC_ATTACH_ASSC |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "EXPT_RSRC_ATTACH to CASC_ATTACH_ASSC" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "EXPT_RSRC_ATTACH to CASC_ATTACH_ASSC" Foreign Keys |
| Parent Key | Child Key |
| ATTACH_ID | ATTACH_ID |
| "EXPT_RSRC_ATTACH to CASC_ATTACH_ASSC" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "EXPT_RSRC_ATTACH to CASC_ATTACH_ASSC" Bound Attachments |
| Name | Current Value |
| "UOM to EXPT_RSRC" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | fk_dibc_uom_to_uom |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | UOM |
| Child Table | EXPT_RSRC |
| Cardinality | Zero or One to Zero or More |
| Existence | Optional |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "UOM to EXPT_RSRC" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "UOM to EXPT_RSRC" Foreign Keys |
| Parent Key | Child Key |
| UNIT_ID | DIST_INT_BEAM_CENTER_UOM |
| "UOM to EXPT_RSRC" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "UOM to EXPT_RSRC" Bound Attachments |
| Name | Current Value |
| "UOM to EXPT_RSRC" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | fk_dsbc_uom_to_uom |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | UOM |
| Child Table | EXPT_RSRC |
| Cardinality | Zero or One to Zero or More |
| Existence | Optional |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "UOM to EXPT_RSRC" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "UOM to EXPT_RSRC" Foreign Keys |
| Parent Key | Child Key |
| UNIT_ID | DIST_STICK_BEAM_CENTER_UOM |
| "UOM to EXPT_RSRC" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "UOM to EXPT_RSRC" Bound Attachments |
| Name | Current Value |
| "EMPLOYEE to EXPT_LAB_SCHED" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | FK_ELS_TO_EMP |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | EMPLOYEE |
| Child Table | EXPT_LAB_SCHED |
| 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 EXPT_LAB_SCHED" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "EMPLOYEE to EXPT_LAB_SCHED" Foreign Keys |
| Parent Key | Child Key |
| BN | REQ_BY_BN |
| "EMPLOYEE to EXPT_LAB_SCHED" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "EMPLOYEE to EXPT_LAB_SCHED" Bound Attachments |
| Name | Current Value |
| "EXPT_LAB_STAT to EXPT_LAB_SCHED" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | FK_ELS_TO_EXPT_LAB_STAT |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | EXPT_LAB_STAT |
| Child Table | EXPT_LAB_SCHED |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "EXPT_LAB_STAT to EXPT_LAB_SCHED" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "EXPT_LAB_STAT to EXPT_LAB_SCHED" Foreign Keys |
| Parent Key | Child Key |
| STAT_ID | STAT_ID |
| "EXPT_LAB_STAT to EXPT_LAB_SCHED" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "EXPT_LAB_STAT to EXPT_LAB_SCHED" Bound Attachments |
| Name | Current Value |
| "EXPT_LAB_SCHED to EXPT_LAB_SCHED_LOG" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_ELSL_TO_EXPT_LAB_SCHED |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | EXPT_LAB_SCHED |
| Child Table | EXPT_LAB_SCHED_LOG |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "EXPT_LAB_SCHED to EXPT_LAB_SCHED_LOG" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "EXPT_LAB_SCHED to EXPT_LAB_SCHED_LOG" Foreign Keys |
| Parent Key | Child Key |
| PRPSL_ID, SUBMISS_NBR, INSTR_ID, RUN_NBR, LAB_ID | PRPSL_ID, SUBMISS_NBR, INSTR_ID, RUN_NBR, LAB_ID |
| "EXPT_LAB_SCHED to EXPT_LAB_SCHED_LOG" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "EXPT_LAB_SCHED to EXPT_LAB_SCHED_LOG" Bound Attachments |
| Name | Current Value |
| "LAB_WORKFLOW to EXPT_LAB_SCHED_WRKFLW" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | FK_ELSW_NEXT_TO_LAB_WRKFLW |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | LAB_WORKFLOW |
| Child Table | EXPT_LAB_SCHED_WRKFLW |
| Cardinality | Zero or One to Zero or More |
| Existence | Optional |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "LAB_WORKFLOW to EXPT_LAB_SCHED_WRKFLW" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "LAB_WORKFLOW to EXPT_LAB_SCHED_WRKFLW" Foreign Keys |
| Parent Key | Child Key |
| WORKFLOW_ID | NEXT_WRKFLW_ID |
| "LAB_WORKFLOW to EXPT_LAB_SCHED_WRKFLW" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "LAB_WORKFLOW to EXPT_LAB_SCHED_WRKFLW" Bound Attachments |
| Name | Current Value |
| "EXPT_RSRC_FACIL to EXPT_LAB_SCHED_WRKFLW" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_ELSW_TO_EXPT_RSRC_FACIL |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | EXPT_RSRC_FACIL |
| Child Table | EXPT_LAB_SCHED_WRKFLW |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "EXPT_RSRC_FACIL to EXPT_LAB_SCHED_WRKFLW" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "EXPT_RSRC_FACIL to EXPT_LAB_SCHED_WRKFLW" Foreign Keys |
| Parent Key | Child Key |
| FACIL_ID | FACIL_ID |
| "EXPT_RSRC_FACIL to EXPT_LAB_SCHED_WRKFLW" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "EXPT_RSRC_FACIL to EXPT_LAB_SCHED_WRKFLW" Bound Attachments |
| Name | Current Value |
| "LAB_WORKFLOW to EXPT_LAB_SCHED_WRKFLW" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_ELSW_TO_LAB_WRKFLW |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | LAB_WORKFLOW |
| Child Table | EXPT_LAB_SCHED_WRKFLW |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "LAB_WORKFLOW to EXPT_LAB_SCHED_WRKFLW" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "LAB_WORKFLOW to EXPT_LAB_SCHED_WRKFLW" Foreign Keys |
| Parent Key | Child Key |
| WORKFLOW_ID | WORKFLOW_ID |
| "LAB_WORKFLOW to EXPT_LAB_SCHED_WRKFLW" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "LAB_WORKFLOW to EXPT_LAB_SCHED_WRKFLW" Bound Attachments |
| Name | Current Value |
| "INSTR to EMAIL_SIGN" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_EMAIL_SIGN_TO_INSTR |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | INSTR |
| Child Table | EMAIL_SIGN |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "INSTR to EMAIL_SIGN" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "INSTR to EMAIL_SIGN" Foreign Keys |
| Parent Key | Child Key |
| INSTR_ID | INSTR_ID |
| "INSTR to EMAIL_SIGN" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "INSTR to EMAIL_SIGN" Bound Attachments |
| Name | Current Value |
| "USER_PROF to EMAIL_SIGN" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_EMAIL_SIGN_TO_USER_PROF |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | USER_PROF |
| Child Table | EMAIL_SIGN |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "USER_PROF to EMAIL_SIGN" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "USER_PROF to EMAIL_SIGN" Foreign Keys |
| Parent Key | Child Key |
| BN | BN |
| "USER_PROF to EMAIL_SIGN" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "USER_PROF to EMAIL_SIGN" Bound Attachments |
| Name | Current Value |
| "EXPT_RSRC_FACIL to EXPT_RSRC_LOC" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | fk_er_loc_to_er_facil |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | EXPT_RSRC_FACIL |
| Child Table | EXPT_RSRC_LOC |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "EXPT_RSRC_FACIL to EXPT_RSRC_LOC" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "EXPT_RSRC_FACIL to EXPT_RSRC_LOC" Foreign Keys |
| Parent Key | Child Key |
| FACIL_ID | FACIL_ID |
| "EXPT_RSRC_FACIL to EXPT_RSRC_LOC" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "EXPT_RSRC_FACIL to EXPT_RSRC_LOC" Bound Attachments |
| Name | Current Value |
| "EXPT_RSRC_FACIL to EXPT_RSRC" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | fk_er_to_expt_rsrc_facil |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | EXPT_RSRC_FACIL |
| Child Table | EXPT_RSRC |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "EXPT_RSRC_FACIL to EXPT_RSRC" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "EXPT_RSRC_FACIL to EXPT_RSRC" Foreign Keys |
| Parent Key | Child Key |
| FACIL_ID | FACIL_ID |
| "EXPT_RSRC_FACIL to EXPT_RSRC" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "EXPT_RSRC_FACIL to EXPT_RSRC" Bound Attachments |
| Name | Current Value |
| "EXPT_RSRC_SUBTYPE to EXPT_RSRC" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | fk_er_to_expt_rsrc_subtype |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | EXPT_RSRC_SUBTYPE |
| Child Table | EXPT_RSRC |
| Cardinality | Zero or One to Zero or More |
| Existence | Optional |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "EXPT_RSRC_SUBTYPE to EXPT_RSRC" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "EXPT_RSRC_SUBTYPE to EXPT_RSRC" Foreign Keys |
| Parent Key | Child Key |
| EXPT_RSRC_TYPE_ID, EXPT_RSRC_SUBTYPE_ID, FACIL_ID | EXPT_RSRC_TYPE_ID, EXPT_RSRC_SUBTYPE_ID, FACIL_ID |
| "EXPT_RSRC_SUBTYPE to EXPT_RSRC" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "EXPT_RSRC_SUBTYPE to EXPT_RSRC" Bound Attachments |
| Name | Current Value |
| "EXPT_RSRC to EXPT_RSRC_ASSC" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | fk_era1_to_expt_rsrc |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | EXPT_RSRC |
| Child Table | EXPT_RSRC_ASSC |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "EXPT_RSRC to EXPT_RSRC_ASSC" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "EXPT_RSRC to EXPT_RSRC_ASSC" Foreign Keys |
| Parent Key | Child Key |
| EXPT_RSRC_ID | EXPT_RSRC_ID_1 |
| "EXPT_RSRC to EXPT_RSRC_ASSC" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "EXPT_RSRC to EXPT_RSRC_ASSC" Bound Attachments |
| Name | Current Value |
| "EXPT_RSRC to EXPT_RSRC_ASSC" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | fk_era2_to_expt_rsrc |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | EXPT_RSRC |
| Child Table | EXPT_RSRC_ASSC |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "EXPT_RSRC to EXPT_RSRC_ASSC" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "EXPT_RSRC to EXPT_RSRC_ASSC" Foreign Keys |
| Parent Key | Child Key |
| EXPT_RSRC_ID | EXPT_RSRC_ID_2 |
| "EXPT_RSRC to EXPT_RSRC_ASSC" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "EXPT_RSRC to EXPT_RSRC_ASSC" Bound Attachments |
| Name | Current Value |
| "EXPT_RSRC_ATTACH_TYPE to EXPT_RSRC_ATTACH" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | fk_era_to_expt_rsrc_attach_type |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | EXPT_RSRC_ATTACH_TYPE |
| Child Table | EXPT_RSRC_ATTACH |
| Cardinality | Zero or One to Zero or More |
| Existence | Optional |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "EXPT_RSRC_ATTACH_TYPE to EXPT_RSRC_ATTACH" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "EXPT_RSRC_ATTACH_TYPE to EXPT_RSRC_ATTACH" Foreign Keys |
| Parent Key | Child Key |
| ATTACH_TYPE_ID | ATTACH_TYPE_ID |
| "EXPT_RSRC_ATTACH_TYPE to EXPT_RSRC_ATTACH" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "EXPT_RSRC_ATTACH_TYPE to EXPT_RSRC_ATTACH" Bound Attachments |
| Name | Current Value |
| "EXPT_RSRC_ATTACH to EXPT_RSRC_ATTACH_ASSC" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | fk_eraa_to_era |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | EXPT_RSRC_ATTACH |
| Child Table | EXPT_RSRC_ATTACH_ASSC |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "EXPT_RSRC_ATTACH to EXPT_RSRC_ATTACH_ASSC" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "EXPT_RSRC_ATTACH to EXPT_RSRC_ATTACH_ASSC" Foreign Keys |
| Parent Key | Child Key |
| ATTACH_ID | ATTACH_ID |
| "EXPT_RSRC_ATTACH to EXPT_RSRC_ATTACH_ASSC" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "EXPT_RSRC_ATTACH to EXPT_RSRC_ATTACH_ASSC" Bound Attachments |
| Name | Current Value |
| "EXPT_RSRC to EXPT_RSRC_ATTACH_ASSC" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | fk_eraa_to_expt_rsrc |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | EXPT_RSRC |
| Child Table | EXPT_RSRC_ATTACH_ASSC |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "EXPT_RSRC to EXPT_RSRC_ATTACH_ASSC" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "EXPT_RSRC to EXPT_RSRC_ATTACH_ASSC" Foreign Keys |
| Parent Key | Child Key |
| EXPT_RSRC_ID | EXPT_RSRC_ID |
| "EXPT_RSRC to EXPT_RSRC_ATTACH_ASSC" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "EXPT_RSRC to EXPT_RSRC_ATTACH_ASSC" Bound Attachments |
| Name | Current Value |
| "EXPT_RSRC_COMM_TYPE to EXPT_RSRC_SCHED" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | fk_erct_to_expt_rsrc_sched |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | EXPT_RSRC_COMM_TYPE |
| Child Table | EXPT_RSRC_SCHED |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "EXPT_RSRC_COMM_TYPE to EXPT_RSRC_SCHED" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "EXPT_RSRC_COMM_TYPE to EXPT_RSRC_SCHED" Foreign Keys |
| Parent Key | Child Key |
| COMM_REQ_ID | COMM_REQ_ID |
| "EXPT_RSRC_COMM_TYPE to EXPT_RSRC_SCHED" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "EXPT_RSRC_COMM_TYPE to EXPT_RSRC_SCHED" Bound Attachments |
| Name | Current Value |
| "EXPT_FACIL to EXPT_RSRC_FACIL" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | fk_erf_to_expt_facil |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | EXPT_FACIL |
| Child Table | EXPT_RSRC_FACIL |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "EXPT_FACIL to EXPT_RSRC_FACIL" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "EXPT_FACIL to EXPT_RSRC_FACIL" Foreign Keys |
| Parent Key | Child Key |
| FACIL_ID | FACIL_ID |
| "EXPT_FACIL to EXPT_RSRC_FACIL" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "EXPT_FACIL to EXPT_RSRC_FACIL" Bound Attachments |
| Name | Current Value |
| "EXPT_RSRC_GRP to EXPT_RSRC_GRP_ASSC" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | fk_erga_to_expt_rsrc_grp |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | EXPT_RSRC_GRP |
| Child Table | EXPT_RSRC_GRP_ASSC |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "EXPT_RSRC_GRP to EXPT_RSRC_GRP_ASSC" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "EXPT_RSRC_GRP to EXPT_RSRC_GRP_ASSC" Foreign Keys |
| Parent Key | Child Key |
| EXPT_RESC_GRP_NM | EXPT_RESC_GRP_NM |
| "EXPT_RSRC_GRP to EXPT_RSRC_GRP_ASSC" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "EXPT_RSRC_GRP to EXPT_RSRC_GRP_ASSC" Bound Attachments |
| Name | Current Value |
| "EXPT_RSRC_SCHED to EXPT_RSRC_GRP_ASSC" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | fk_erga_to_expt_rsrc_sched |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | EXPT_RSRC_SCHED |
| Child Table | EXPT_RSRC_GRP_ASSC |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "EXPT_RSRC_SCHED to EXPT_RSRC_GRP_ASSC" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "EXPT_RSRC_SCHED to EXPT_RSRC_GRP_ASSC" Foreign Keys |
| Parent Key | Child Key |
| EXPT_RSRC_ID | EXPT_RSRC_ID |
| "EXPT_RSRC_SCHED to EXPT_RSRC_GRP_ASSC" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "EXPT_RSRC_SCHED to EXPT_RSRC_GRP_ASSC" Bound Attachments |
| Name | Current Value |
| "EXPT_RSRC to EXPT_RSRC_INSTR_ASSC" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | fk_eria_to_expt_rsrc |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | EXPT_RSRC |
| Child Table | EXPT_RSRC_INSTR_ASSC |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "EXPT_RSRC to EXPT_RSRC_INSTR_ASSC" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "EXPT_RSRC to EXPT_RSRC_INSTR_ASSC" Foreign Keys |
| Parent Key | Child Key |
| EXPT_RSRC_ID | EXPT_RSRC_ID |
| "EXPT_RSRC to EXPT_RSRC_INSTR_ASSC" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "EXPT_RSRC to EXPT_RSRC_INSTR_ASSC" Bound Attachments |
| Name | Current Value |
| "INSTR to EXPT_RSRC_INSTR_ASSC" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | fk_eria_to_instr |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | INSTR |
| Child Table | EXPT_RSRC_INSTR_ASSC |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "INSTR to EXPT_RSRC_INSTR_ASSC" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "INSTR to EXPT_RSRC_INSTR_ASSC" Foreign Keys |
| Parent Key | Child Key |
| INSTR_ID | INSTR_ID |
| "INSTR to EXPT_RSRC_INSTR_ASSC" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "INSTR to EXPT_RSRC_INSTR_ASSC" Bound Attachments |
| Name | Current Value |
| "EXPRESS_ACT to EXPT_RSRC_LOG" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_ERL_TO_EXP_ACT |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | EXPRESS_ACT |
| Child Table | EXPT_RSRC_LOG |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "EXPRESS_ACT to EXPT_RSRC_LOG" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "EXPRESS_ACT to EXPT_RSRC_LOG" Foreign Keys |
| Parent Key | Child Key |
| ACT_ID | ACT_ID |
| "EXPRESS_ACT to EXPT_RSRC_LOG" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "EXPRESS_ACT to EXPT_RSRC_LOG" Bound Attachments |
| Name | Current Value |
| "EXPT_RSRC to EXPT_RSRC_LOG" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | fk_erl_to_expt_rsrc |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | EXPT_RSRC |
| Child Table | EXPT_RSRC_LOG |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "EXPT_RSRC to EXPT_RSRC_LOG" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "EXPT_RSRC to EXPT_RSRC_LOG" Foreign Keys |
| Parent Key | Child Key |
| EXPT_RSRC_ID | EXPT_RSRC_ID |
| "EXPT_RSRC to EXPT_RSRC_LOG" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "EXPT_RSRC to EXPT_RSRC_LOG" Bound Attachments |
| Name | Current Value |
| "EXPT_RSRC to EXPT_RSRC_MAINT_SCHED" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_ERMS_TO_EXPT_RSRC |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | EXPT_RSRC |
| Child Table | EXPT_RSRC_MAINT_SCHED |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "EXPT_RSRC to EXPT_RSRC_MAINT_SCHED" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "EXPT_RSRC to EXPT_RSRC_MAINT_SCHED" Foreign Keys |
| Parent Key | Child Key |
| EXPT_RSRC_ID | EXPT_RSRC_ID |
| "EXPT_RSRC to EXPT_RSRC_MAINT_SCHED" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "EXPT_RSRC to EXPT_RSRC_MAINT_SCHED" Bound Attachments |
| Name | Current Value |
| "EMPLOYEE to EXP_ROLE_PERS_ASSC" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | FK_ERPA_TO_EMP |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | EMPLOYEE |
| Child Table | EXP_ROLE_PERS_ASSC |
| 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 EXP_ROLE_PERS_ASSC" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "EMPLOYEE to EXP_ROLE_PERS_ASSC" Foreign Keys |
| Parent Key | Child Key |
| BN | BN |
| "EMPLOYEE to EXP_ROLE_PERS_ASSC" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "EMPLOYEE to EXP_ROLE_PERS_ASSC" Bound Attachments |
| Name | Current Value |
| "EXP_USER_ROLE to EXP_ROLE_PERS_ASSC" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | fk_erpa_to_exp_user_role |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | EXP_USER_ROLE |
| Child Table | EXP_ROLE_PERS_ASSC |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "EXP_USER_ROLE to EXP_ROLE_PERS_ASSC" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "EXP_USER_ROLE to EXP_ROLE_PERS_ASSC" Foreign Keys |
| Parent Key | Child Key |
| ROLE_ID | ROLE_ID |
| "EXP_USER_ROLE to EXP_ROLE_PERS_ASSC" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "EXP_USER_ROLE to EXP_ROLE_PERS_ASSC" Bound Attachments |
| Name | Current Value |
| "EXPT_RSRC to EXPT_RSRC_PERS_ASSC" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | fk_erpa_to_expt_rsrc |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | EXPT_RSRC |
| Child Table | EXPT_RSRC_PERS_ASSC |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "EXPT_RSRC to EXPT_RSRC_PERS_ASSC" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "EXPT_RSRC to EXPT_RSRC_PERS_ASSC" Foreign Keys |
| Parent Key | Child Key |
| EXPT_RSRC_ID | EXPT_RSRC_ID |
| "EXPT_RSRC to EXPT_RSRC_PERS_ASSC" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "EXPT_RSRC to EXPT_RSRC_PERS_ASSC" Bound Attachments |
| Name | Current Value |
| "EXPT_RSRC_FACIL to EXP_ROLE_PERS_ASSC" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | fk_erpa_to_expt_rsrc_facil |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | EXPT_RSRC_FACIL |
| Child Table | EXP_ROLE_PERS_ASSC |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "EXPT_RSRC_FACIL to EXP_ROLE_PERS_ASSC" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "EXPT_RSRC_FACIL to EXP_ROLE_PERS_ASSC" Foreign Keys |
| Parent Key | Child Key |
| FACIL_ID | FACIL_ID |
| "EXPT_RSRC_FACIL to EXP_ROLE_PERS_ASSC" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "EXPT_RSRC_FACIL to EXP_ROLE_PERS_ASSC" Bound Attachments |
| Name | Current Value |
| "EXPT_RSRC_PERS_ASSC to EXPT_RSRC_PERS_RSRC" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | fk_erpr_to_expt_rsrc_pers_assc |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | EXPT_RSRC_PERS_ASSC |
| Child Table | EXPT_RSRC_PERS_RSRC |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "EXPT_RSRC_PERS_ASSC to EXPT_RSRC_PERS_RSRC" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "EXPT_RSRC_PERS_ASSC to EXPT_RSRC_PERS_RSRC" Foreign Keys |
| Parent Key | Child Key |
| EXPT_RSRC_ID, BN | EXPT_RSRC_ID, BN |
| "EXPT_RSRC_PERS_ASSC to EXPT_RSRC_PERS_RSRC" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "EXPT_RSRC_PERS_ASSC to EXPT_RSRC_PERS_RSRC" Bound Attachments |
| Name | Current Value |
| "EXPT_RSRC_SCHED to EXPT_RSRC_PERS_RSRC" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | fk_erpr_to_expt_rsrc_sched |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | EXPT_RSRC_SCHED |
| Child Table | EXPT_RSRC_PERS_RSRC |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "EXPT_RSRC_SCHED to EXPT_RSRC_PERS_RSRC" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "EXPT_RSRC_SCHED to EXPT_RSRC_PERS_RSRC" Foreign Keys |
| Parent Key | Child Key |
| EXPT_RSRC_ID | EXPT_RSRC_ID |
| "EXPT_RSRC_SCHED to EXPT_RSRC_PERS_RSRC" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "EXPT_RSRC_SCHED to EXPT_RSRC_PERS_RSRC" Bound Attachments |
| Name | Current Value |
| "EMPLOYEE to EXPT_RSRC_PERS_TRAIN" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_ERPT_TO_EMP |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | EMPLOYEE |
| Child Table | EXPT_RSRC_PERS_TRAIN |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "EMPLOYEE to EXPT_RSRC_PERS_TRAIN" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "EMPLOYEE to EXPT_RSRC_PERS_TRAIN" Foreign Keys |
| Parent Key | Child Key |
| BN | BN |
| "EMPLOYEE to EXPT_RSRC_PERS_TRAIN" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "EMPLOYEE to EXPT_RSRC_PERS_TRAIN" Bound Attachments |
| Name | Current Value |
| "EXPT_RSRC_TRAIN_MOD to EXPT_RSRC_PERS_TRAIN" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | fk_erpt_to_expt_rsrc_train_mod |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | EXPT_RSRC_TRAIN_MOD |
| Child Table | EXPT_RSRC_PERS_TRAIN |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "EXPT_RSRC_TRAIN_MOD to EXPT_RSRC_PERS_TRAIN" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "EXPT_RSRC_TRAIN_MOD to EXPT_RSRC_PERS_TRAIN" Foreign Keys |
| Parent Key | Child Key |
| TRAIN_MOD_ID | TRAIN_MOD_ID |
| "EXPT_RSRC_TRAIN_MOD to EXPT_RSRC_PERS_TRAIN" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "EXPT_RSRC_TRAIN_MOD to EXPT_RSRC_PERS_TRAIN" Bound Attachments |
| Name | Current Value |
| "EXPT_RSRC_QUES to EXPT_RSRC_QUES_EXPT_RSRC_SCHED_ASSC" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_ERQERSA_TO_EXPT_RSRC_QUES |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | EXPT_RSRC_QUES |
| Child Table | EXPT_RSRC_QUES_EXPT_RSRC_SCHED_ASSC |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "EXPT_RSRC_QUES to EXPT_RSRC_QUES_EXPT_RSRC_SCHED_ASSC" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "EXPT_RSRC_QUES to EXPT_RSRC_QUES_EXPT_RSRC_SCHED_ASSC" Foreign Keys |
| Parent Key | Child Key |
| QUES_ID | QUES_ID |
| "EXPT_RSRC_QUES to EXPT_RSRC_QUES_EXPT_RSRC_SCHED_ASSC" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "EXPT_RSRC_QUES to EXPT_RSRC_QUES_EXPT_RSRC_SCHED_ASSC" Bound Attachments |
| Name | Current Value |
| "EXPT_RSRC_SCHED to EXPT_RSRC_QUES_EXPT_RSRC_SCHED_ASSC" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_ERQERSA_TO_EXPT_RSRC_SCHED |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | EXPT_RSRC_SCHED |
| Child Table | EXPT_RSRC_QUES_EXPT_RSRC_SCHED_ASSC |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "EXPT_RSRC_SCHED to EXPT_RSRC_QUES_EXPT_RSRC_SCHED_ASSC" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "EXPT_RSRC_SCHED to EXPT_RSRC_QUES_EXPT_RSRC_SCHED_ASSC" Foreign Keys |
| Parent Key | Child Key |
| EXPT_RSRC_ID | EXPT_RSRC_ID |
| "EXPT_RSRC_SCHED to EXPT_RSRC_QUES_EXPT_RSRC_SCHED_ASSC" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "EXPT_RSRC_SCHED to EXPT_RSRC_QUES_EXPT_RSRC_SCHED_ASSC" Bound Attachments |
| Name | Current Value |
| "EXPT_RSRC_REQ_TYPE to EXPT_RSRC_SCHED" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | fk_errt_to_expt_rsrc_sched |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | EXPT_RSRC_REQ_TYPE |
| Child Table | EXPT_RSRC_SCHED |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "EXPT_RSRC_REQ_TYPE to EXPT_RSRC_SCHED" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "EXPT_RSRC_REQ_TYPE to EXPT_RSRC_SCHED" Foreign Keys |
| Parent Key | Child Key |
| REQ_TYPE_ID | REQ_TYPE_ID |
| "EXPT_RSRC_REQ_TYPE to EXPT_RSRC_SCHED" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "EXPT_RSRC_REQ_TYPE to EXPT_RSRC_SCHED" Bound Attachments |
| Name | Current Value |
| "EXPT_RSRC to EXPT_RSRC_SCHED" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | fk_ers_to_expt_rsrc |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | EXPT_RSRC |
| Child Table | EXPT_RSRC_SCHED |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "EXPT_RSRC to EXPT_RSRC_SCHED" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "EXPT_RSRC to EXPT_RSRC_SCHED" Foreign Keys |
| Parent Key | Child Key |
| EXPT_RSRC_ID | EXPT_RSRC_ID |
| "EXPT_RSRC to EXPT_RSRC_SCHED" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "EXPT_RSRC to EXPT_RSRC_SCHED" Bound Attachments |
| Name | Current Value |
| "EXPT_RSRC_TYPE to EXPT_RSRC_SUBTYPE" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | fk_ers_to_expt_rsrc_type |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | EXPT_RSRC_TYPE |
| Child Table | EXPT_RSRC_SUBTYPE |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "EXPT_RSRC_TYPE to EXPT_RSRC_SUBTYPE" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "EXPT_RSRC_TYPE to EXPT_RSRC_SUBTYPE" Foreign Keys |
| Parent Key | Child Key |
| EXPT_RSRC_TYPE_ID, FACIL_ID | EXPT_RSRC_TYPE_ID, FACIL_ID |
| "EXPT_RSRC_TYPE to EXPT_RSRC_SUBTYPE" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "EXPT_RSRC_TYPE to EXPT_RSRC_SUBTYPE" Bound Attachments |
| Name | Current Value |
| "EXPT_RSRC_STAT to EXPT_RSRC" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | FK_ERS_TO_RXPT_RSRC |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | EXPT_RSRC_STAT |
| Child Table | EXPT_RSRC |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "EXPT_RSRC_STAT to EXPT_RSRC" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "EXPT_RSRC_STAT to EXPT_RSRC" Foreign Keys |
| Parent Key | Child Key |
| STAT_ID | STAT_ID |
| "EXPT_RSRC_STAT to EXPT_RSRC" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "EXPT_RSRC_STAT to EXPT_RSRC" Bound Attachments |
| Name | Current Value |
| "EXPT_RSRC to EXPT_RSRC_STAT_HIST" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | fk_ersh_to_expt_rsrc |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | EXPT_RSRC |
| Child Table | EXPT_RSRC_STAT_HIST |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "EXPT_RSRC to EXPT_RSRC_STAT_HIST" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "EXPT_RSRC to EXPT_RSRC_STAT_HIST" Foreign Keys |
| Parent Key | Child Key |
| EXPT_RSRC_ID | EXPT_RSRC_ID |
| "EXPT_RSRC to EXPT_RSRC_STAT_HIST" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "EXPT_RSRC to EXPT_RSRC_STAT_HIST" Bound Attachments |
| Name | Current Value |
| "EXPT_RSRC_SCHED_STAT to EXPT_RSRC_SCHED" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | fk_erss_to_expt_rsrc_stat |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | EXPT_RSRC_SCHED_STAT |
| Child Table | EXPT_RSRC_SCHED |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "EXPT_RSRC_SCHED_STAT to EXPT_RSRC_SCHED" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "EXPT_RSRC_SCHED_STAT to EXPT_RSRC_SCHED" Foreign Keys |
| Parent Key | Child Key |
| STAT_ID | STAT_ID |
| "EXPT_RSRC_SCHED_STAT to EXPT_RSRC_SCHED" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "EXPT_RSRC_SCHED_STAT to EXPT_RSRC_SCHED" Bound Attachments |
| Name | Current Value |
| "RSRC_WORKFLOW to EXPT_RSRC_SCHED_WRKFLW" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | FK_ERSW_NEXT_TO_RSRC_WRKFLW |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | RSRC_WORKFLOW |
| Child Table | EXPT_RSRC_SCHED_WRKFLW |
| Cardinality | Zero or One to Zero or More |
| Existence | Optional |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "RSRC_WORKFLOW to EXPT_RSRC_SCHED_WRKFLW" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "RSRC_WORKFLOW to EXPT_RSRC_SCHED_WRKFLW" Foreign Keys |
| Parent Key | Child Key |
| WORKFLOW_ID | NEXT_WRKFLW_ID |
| "RSRC_WORKFLOW to EXPT_RSRC_SCHED_WRKFLW" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "RSRC_WORKFLOW to EXPT_RSRC_SCHED_WRKFLW" Bound Attachments |
| Name | Current Value |
| "EXPT_RSRC_FACIL to EXPT_RSRC_SCHED_WRKFLW" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_ERSW_TO_EXPT_RSRC_FACIL |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | EXPT_RSRC_FACIL |
| Child Table | EXPT_RSRC_SCHED_WRKFLW |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "EXPT_RSRC_FACIL to EXPT_RSRC_SCHED_WRKFLW" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "EXPT_RSRC_FACIL to EXPT_RSRC_SCHED_WRKFLW" Foreign Keys |
| Parent Key | Child Key |
| FACIL_ID | FACIL_ID |
| "EXPT_RSRC_FACIL to EXPT_RSRC_SCHED_WRKFLW" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "EXPT_RSRC_FACIL to EXPT_RSRC_SCHED_WRKFLW" Bound Attachments |
| Name | Current Value |
| "RSRC_WORKFLOW to EXPT_RSRC_SCHED_WRKFLW" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_ERSW_TO_RSRC_WRKFLW |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | RSRC_WORKFLOW |
| Child Table | EXPT_RSRC_SCHED_WRKFLW |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "RSRC_WORKFLOW to EXPT_RSRC_SCHED_WRKFLW" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "RSRC_WORKFLOW to EXPT_RSRC_SCHED_WRKFLW" Foreign Keys |
| Parent Key | Child Key |
| WORKFLOW_ID | WORKFLOW_ID |
| "RSRC_WORKFLOW to EXPT_RSRC_SCHED_WRKFLW" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "RSRC_WORKFLOW to EXPT_RSRC_SCHED_WRKFLW" Bound Attachments |
| Name | Current Value |
| "EXPT_RSRC to EXPT_RSRC_TRAIN" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | fk_ert_to_expt_rsrc |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | EXPT_RSRC |
| Child Table | EXPT_RSRC_TRAIN |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "EXPT_RSRC to EXPT_RSRC_TRAIN" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "EXPT_RSRC to EXPT_RSRC_TRAIN" Foreign Keys |
| Parent Key | Child Key |
| EXPT_RSRC_ID | EXPT_RSRC_ID |
| "EXPT_RSRC to EXPT_RSRC_TRAIN" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "EXPT_RSRC to EXPT_RSRC_TRAIN" Bound Attachments |
| Name | Current Value |
| "EXPT_RSRC_FACIL to EXPT_RSRC_TYPE" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | fk_ert_to_expt_rsrc_facil |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | EXPT_RSRC_FACIL |
| Child Table | EXPT_RSRC_TYPE |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "EXPT_RSRC_FACIL to EXPT_RSRC_TYPE" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "EXPT_RSRC_FACIL to EXPT_RSRC_TYPE" Foreign Keys |
| Parent Key | Child Key |
| FACIL_ID | FACIL_ID |
| "EXPT_RSRC_FACIL to EXPT_RSRC_TYPE" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "EXPT_RSRC_FACIL to EXPT_RSRC_TYPE" Bound Attachments |
| Name | Current Value |
| "EXPT_RSRC_TRAIN_MOD to EXPT_RSRC_TRAIN" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | fk_ert_to_expt_rsrc_train_mod |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | EXPT_RSRC_TRAIN_MOD |
| Child Table | EXPT_RSRC_TRAIN |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "EXPT_RSRC_TRAIN_MOD to EXPT_RSRC_TRAIN" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "EXPT_RSRC_TRAIN_MOD to EXPT_RSRC_TRAIN" Foreign Keys |
| Parent Key | Child Key |
| TRAIN_MOD_ID | TRAIN_MOD_ID |
| "EXPT_RSRC_TRAIN_MOD to EXPT_RSRC_TRAIN" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "EXPT_RSRC_TRAIN_MOD to EXPT_RSRC_TRAIN" Bound Attachments |
| Name | Current Value |
| "EMAIL_TEMPLATE to EXPT_SCHED_EMAIL_LOG" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_ESEL_TO_EMAIL_TMPL |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | EMAIL_TEMPLATE |
| Child Table | EXPT_SCHED_EMAIL_LOG |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "EMAIL_TEMPLATE to EXPT_SCHED_EMAIL_LOG" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "EMAIL_TEMPLATE to EXPT_SCHED_EMAIL_LOG" Foreign Keys |
| Parent Key | Child Key |
| TEMPLATE_ID | TEMPLATE_ID |
| "EMAIL_TEMPLATE to EXPT_SCHED_EMAIL_LOG" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "EMAIL_TEMPLATE to EXPT_SCHED_EMAIL_LOG" Bound Attachments |
| Name | Current Value |
| "EMPLOYEE to EXPT_SCHED_LOC_CONT_ASSC" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_ESLCA_TO_EMP |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | EMPLOYEE |
| Child Table | EXPT_SCHED_LOC_CONT_ASSC |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "EMPLOYEE to EXPT_SCHED_LOC_CONT_ASSC" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "EMPLOYEE to EXPT_SCHED_LOC_CONT_ASSC" Foreign Keys |
| Parent Key | Child Key |
| BN | BN |
| "EMPLOYEE to EXPT_SCHED_LOC_CONT_ASSC" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "EMPLOYEE to EXPT_SCHED_LOC_CONT_ASSC" Bound Attachments |
| Name | Current Value |
| "EXPT_RSRC_FACIL to EXPT_SCHED_WRKFLW" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_ESW_TO_EXPT_RSRC_FACIL |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | EXPT_RSRC_FACIL |
| Child Table | EXPT_SCHED_WRKFLW |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "EXPT_RSRC_FACIL to EXPT_SCHED_WRKFLW" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "EXPT_RSRC_FACIL to EXPT_SCHED_WRKFLW" Foreign Keys |
| Parent Key | Child Key |
| FACIL_ID | FACIL_ID |
| "EXPT_RSRC_FACIL to EXPT_SCHED_WRKFLW" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "EXPT_RSRC_FACIL to EXPT_SCHED_WRKFLW" Bound Attachments |
| Name | Current Value |
| "EXPRESS_ACT to EXPRESS_LOG" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_EXP_LOG_TO_EXP_ACT |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | EXPRESS_ACT |
| Child Table | EXPRESS_LOG |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "EXPRESS_ACT to EXPRESS_LOG" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "EXPRESS_ACT to EXPRESS_LOG" Foreign Keys |
| Parent Key | Child Key |
| ACT_ID | ACT_ID |
| "EXPRESS_ACT to EXPRESS_LOG" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "EXPRESS_ACT to EXPRESS_LOG" Bound Attachments |
| Name | Current Value |
| "LAB to EXPT_LAB_SCHED" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_EXPT_LAB_SCHED_TO_LAB |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | LAB |
| Child Table | EXPT_LAB_SCHED |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "LAB to EXPT_LAB_SCHED" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "LAB to EXPT_LAB_SCHED" Foreign Keys |
| Parent Key | Child Key |
| LAB_ID | LAB_ID |
| "LAB to EXPT_LAB_SCHED" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "LAB to EXPT_LAB_SCHED" Bound Attachments |
| Name | Current Value |
| "EMPLOYEE to EXPT_RSRC_SCHED" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | FK_EXPT_RES_SCH_TO_EMP |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | EMPLOYEE |
| Child Table | EXPT_RSRC_SCHED |
| 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 EXPT_RSRC_SCHED" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "EMPLOYEE to EXPT_RSRC_SCHED" Foreign Keys |
| Parent Key | Child Key |
| BN | REQ_BY_BN |
| "EMPLOYEE to EXPT_RSRC_SCHED" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "EMPLOYEE to EXPT_RSRC_SCHED" Bound Attachments |
| Name | Current Value |
| "EXPT_RSRC to EXPT_RSRC_MAINT" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_EXPT_RSRC_MAIN_TO_EXPT_RSRC |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | EXPT_RSRC |
| Child Table | EXPT_RSRC_MAINT |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "EXPT_RSRC to EXPT_RSRC_MAINT" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "EXPT_RSRC to EXPT_RSRC_MAINT" Foreign Keys |
| Parent Key | Child Key |
| EXPT_RSRC_ID | EXPT_RSRC_ID |
| "EXPT_RSRC to EXPT_RSRC_MAINT" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "EXPT_RSRC to EXPT_RSRC_MAINT" Bound Attachments |
| Name | Current Value |
| "MAINT_ACT to EXPT_RSRC_MAINT" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_EXPT_RSRC_MAIN_TO_MAINT_ACT |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | MAINT_ACT |
| Child Table | EXPT_RSRC_MAINT |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "MAINT_ACT to EXPT_RSRC_MAINT" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "MAINT_ACT to EXPT_RSRC_MAINT" Foreign Keys |
| Parent Key | Child Key |
| ACT_ID | ACT_ID |
| "MAINT_ACT to EXPT_RSRC_MAINT" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "MAINT_ACT to EXPT_RSRC_MAINT" Bound Attachments |
| Name | Current Value |
| "EMPLOYEE to EXPT_RSRC_PERS_ABS" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_EXPT_RSRC_PER_ABS_TO_EMP |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | EMPLOYEE |
| Child Table | EXPT_RSRC_PERS_ABS |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "EMPLOYEE to EXPT_RSRC_PERS_ABS" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "EMPLOYEE to EXPT_RSRC_PERS_ABS" Foreign Keys |
| Parent Key | Child Key |
| BN | BN |
| "EMPLOYEE to EXPT_RSRC_PERS_ABS" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "EMPLOYEE to EXPT_RSRC_PERS_ABS" Bound Attachments |
| Name | Current Value |
| "EMPLOYEE to EXPT_RSRC_PERS_ASSC" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_EXPT_RSRC_PER_ASSC_TO_EMP |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | EMPLOYEE |
| Child Table | EXPT_RSRC_PERS_ASSC |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "EMPLOYEE to EXPT_RSRC_PERS_ASSC" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "EMPLOYEE to EXPT_RSRC_PERS_ASSC" Foreign Keys |
| Parent Key | Child Key |
| BN | BN |
| "EMPLOYEE to EXPT_RSRC_PERS_ASSC" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "EMPLOYEE to EXPT_RSRC_PERS_ASSC" Bound Attachments |
| Name | Current Value |
| "ELEC_CERT to EXPT_RSRC" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | FK_EXPT_RSRC_TO_ELEC_CERT |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | ELEC_CERT |
| Child Table | EXPT_RSRC |
| Cardinality | Zero or One to Zero or More |
| Existence | Optional |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "ELEC_CERT to EXPT_RSRC" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "ELEC_CERT to EXPT_RSRC" Foreign Keys |
| Parent Key | Child Key |
| ELEC_CERT_ID | ELEC_CERT_ID |
| "ELEC_CERT to EXPT_RSRC" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "ELEC_CERT to EXPT_RSRC" Bound Attachments |
| Name | Current Value |
| "EXPT_RSRC_LOC to EXPT_RSRC" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | fk_expt_rsrc_to_expt_rsrc_loc |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | EXPT_RSRC_LOC |
| Child Table | EXPT_RSRC |
| Cardinality | Zero or One to Zero or More |
| Existence | Optional |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "EXPT_RSRC_LOC to EXPT_RSRC" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "EXPT_RSRC_LOC to EXPT_RSRC" Foreign Keys |
| Parent Key | Child Key |
| FACIL_ID, LOC_ID | FACIL_ID, LOC_ID |
| "EXPT_RSRC_LOC to EXPT_RSRC" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "EXPT_RSRC_LOC to EXPT_RSRC" Bound Attachments |
| Name | Current Value |
| "EXPT_RSRC_TYPE to EXPT_RSRC" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | fk_expt_rsrc_to_expt_rsrc_type |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | EXPT_RSRC_TYPE |
| Child Table | EXPT_RSRC |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "EXPT_RSRC_TYPE to EXPT_RSRC" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "EXPT_RSRC_TYPE to EXPT_RSRC" Foreign Keys |
| Parent Key | Child Key |
| EXPT_RSRC_TYPE_ID, FACIL_ID | EXPT_RSRC_TYPE_ID, FACIL_ID |
| "EXPT_RSRC_TYPE to EXPT_RSRC" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "EXPT_RSRC_TYPE to EXPT_RSRC" Bound Attachments |
| Name | Current Value |
| "EXPT_RSRC_MANUF to EXPT_RSRC" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | fk_expt_rsrc_to_manuf |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | EXPT_RSRC_MANUF |
| Child Table | EXPT_RSRC |
| Cardinality | Zero or One to Zero or More |
| Existence | Optional |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "EXPT_RSRC_MANUF to EXPT_RSRC" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "EXPT_RSRC_MANUF to EXPT_RSRC" Foreign Keys |
| Parent Key | Child Key |
| MANUF_ID | MANUF_ID |
| "EXPT_RSRC_MANUF to EXPT_RSRC" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "EXPT_RSRC_MANUF to EXPT_RSRC" Bound Attachments |
| Name | Current Value |
| "CLASS to CASC_EXPT_RSRC_TYPE_ASSC" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | FK_EXPT_RSRC_TYPE_TO_CLASS |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | CLASS |
| Child Table | CASC_EXPT_RSRC_TYPE_ASSC |
| Cardinality | Zero or One to Zero or More |
| Existence | Optional |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "CLASS to CASC_EXPT_RSRC_TYPE_ASSC" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "CLASS to CASC_EXPT_RSRC_TYPE_ASSC" Foreign Keys |
| Parent Key | Child Key |
| CLASS_ID | CLASS_ID |
| "CLASS to CASC_EXPT_RSRC_TYPE_ASSC" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "CLASS to CASC_EXPT_RSRC_TYPE_ASSC" Bound Attachments |
| Name | Current Value |
| "EXPT_RSRC to EXPT_RSRC_UNAVAIL" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_EXPT_RSRC_UN_TO_EXPT_RSRC |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | EXPT_RSRC |
| Child Table | EXPT_RSRC_UNAVAIL |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "EXPT_RSRC to EXPT_RSRC_UNAVAIL" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "EXPT_RSRC to EXPT_RSRC_UNAVAIL" Foreign Keys |
| Parent Key | Child Key |
| EXPT_RSRC_ID | EXPT_RSRC_ID |
| "EXPT_RSRC to EXPT_RSRC_UNAVAIL" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "EXPT_RSRC to EXPT_RSRC_UNAVAIL" Bound Attachments |
| Name | Current Value |
| "EXPRESS_ACT to EXPT_SCHED_LOG" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_EXPT_SCH_LOG_TO_EX_ACT |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | EXPRESS_ACT |
| Child Table | EXPT_SCHED_LOG |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "EXPRESS_ACT to EXPT_SCHED_LOG" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "EXPRESS_ACT to EXPT_SCHED_LOG" Foreign Keys |
| Parent Key | Child Key |
| ACT_ID | ACT_ID |
| "EXPRESS_ACT to EXPT_SCHED_LOG" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "EXPRESS_ACT to EXPT_SCHED_LOG" Bound Attachments |
| Name | Current Value |
| "PRPSL_INSTR to EXPT_SCHED" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_EXPT_SCH_TO_PRPSL_INSTR |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | PRPSL_INSTR |
| Child Table | EXPT_SCHED |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "PRPSL_INSTR to EXPT_SCHED" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "PRPSL_INSTR to EXPT_SCHED" Foreign Keys |
| Parent Key | Child Key |
| PRPSL_ID, SUBMISS_NBR, INSTR_ID | PRPSL_ID, SUBMISS_NBR, INSTR_ID |
| "PRPSL_INSTR to EXPT_SCHED" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "PRPSL_INSTR to EXPT_SCHED" Bound Attachments |
| Name | Current Value |
| "EMPLOYEE to EXPT_SCHED" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | FK_EXPT_SCHED_TO_EMP |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | EMPLOYEE |
| Child Table | EXPT_SCHED |
| 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 EXPT_SCHED" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "EMPLOYEE to EXPT_SCHED" Foreign Keys |
| Parent Key | Child Key |
| BN | HOST_BN |
| "EMPLOYEE to EXPT_SCHED" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "EMPLOYEE to EXPT_SCHED" Bound Attachments |
| Name | Current Value |
| "EXPT_SCHED_STAT to EXPT_SCHED" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | FK_EXPT_SCHED_TO_EXPT_SCHED_ST |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | EXPT_SCHED_STAT |
| Child Table | EXPT_SCHED |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "EXPT_SCHED_STAT to EXPT_SCHED" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "EXPT_SCHED_STAT to EXPT_SCHED" Foreign Keys |
| Parent Key | Child Key |
| STAT_ID | STAT_ID |
| "EXPT_SCHED_STAT to EXPT_SCHED" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "EXPT_SCHED_STAT to EXPT_SCHED" Bound Attachments |
| Name | Current Value |
| "EXPT_WORKFLOW to EXPT_SCHED_WRKFLW" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_EXPT_WRKFLW_TO_EXPT_WRKFLW |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | EXPT_WORKFLOW |
| Child Table | EXPT_SCHED_WRKFLW |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "EXPT_WORKFLOW to EXPT_SCHED_WRKFLW" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "EXPT_WORKFLOW to EXPT_SCHED_WRKFLW" Foreign Keys |
| Parent Key | Child Key |
| WORKFLOW_ID | WORKFLOW_ID |
| "EXPT_WORKFLOW to EXPT_SCHED_WRKFLW" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "EXPT_WORKFLOW to EXPT_SCHED_WRKFLW" Bound Attachments |
| Name | Current Value |
| "EXPT_FACIL to INSTR" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | FK_INSTR_EXPT_FACIL |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | EXPT_FACIL |
| Child Table | INSTR |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "EXPT_FACIL to INSTR" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "EXPT_FACIL to INSTR" Foreign Keys |
| Parent Key | Child Key |
| FACIL_ID | FACIL_ID |
| "EXPT_FACIL to INSTR" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "EXPT_FACIL to INSTR" 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 |
| "EXPT_FACIL to LAB" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | FK_LAB_EXPRT_FACIL |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | EXPT_FACIL |
| Child Table | LAB |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "EXPT_FACIL to LAB" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "EXPT_FACIL to LAB" Foreign Keys |
| Parent Key | Child Key |
| FACIL_ID | FACIL_ID |
| "EXPT_FACIL to LAB" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "EXPT_FACIL to LAB" Bound Attachments |
| Name | Current Value |
| "PERSON to PRPSL_INSTR" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | FK_LOCAL_CONT_TO_PERSON |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | PERSON |
| Child Table | PRPSL_INSTR |
| Cardinality | Zero or One to Zero or More |
| Existence | Optional |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "PERSON to PRPSL_INSTR" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "PERSON to PRPSL_INSTR" Foreign Keys |
| Parent Key | Child Key |
| PERSON_ID | EXPT_LOCAL_CONT_PERSON_ID |
| "PERSON to PRPSL_INSTR" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "PERSON to PRPSL_INSTR" Bound Attachments |
| Name | Current Value |
| "EXPT_WORKFLOW to EXPT_SCHED_WRKFLW" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | FK_NEXT_WRKFLW_TO_EXPT_WRKFLW |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | EXPT_WORKFLOW |
| Child Table | EXPT_SCHED_WRKFLW |
| Cardinality | Zero or One to Zero or More |
| Existence | Optional |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "EXPT_WORKFLOW to EXPT_SCHED_WRKFLW" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "EXPT_WORKFLOW to EXPT_SCHED_WRKFLW" Foreign Keys |
| Parent Key | Child Key |
| WORKFLOW_ID | NEXT_WORKFLOW_ID |
| "EXPT_WORKFLOW to EXPT_SCHED_WRKFLW" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "EXPT_WORKFLOW to EXPT_SCHED_WRKFLW" Bound Attachments |
| Name | Current Value |
| "PERSON to PRPSL_INSTR" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | FK_OPER_FEAS_REV_TO_PERSON |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | PERSON |
| Child Table | PRPSL_INSTR |
| Cardinality | Zero or One to Zero or More |
| Existence | Optional |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "PERSON to PRPSL_INSTR" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "PERSON to PRPSL_INSTR" Foreign Keys |
| Parent Key | Child Key |
| PERSON_ID | OPER_FEAS_REV_PERSON_ID |
| "PERSON to PRPSL_INSTR" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "PERSON to PRPSL_INSTR" Bound Attachments |
| Name | Current Value |
| "PRPSL_GRP to PRPSL_GRP_PRPSL_ASSC" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | fk_pgpa_to_prpsl_grp |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | PRPSL_GRP |
| Child Table | PRPSL_GRP_PRPSL_ASSC |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "PRPSL_GRP to PRPSL_GRP_PRPSL_ASSC" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "PRPSL_GRP to PRPSL_GRP_PRPSL_ASSC" Foreign Keys |
| Parent Key | Child Key |
| PRPSL_GRP_ID | PRPSL_GRP_ID |
| "PRPSL_GRP to PRPSL_GRP_PRPSL_ASSC" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "PRPSL_GRP to PRPSL_GRP_PRPSL_ASSC" Bound Attachments |
| Name | Current Value |
| "PRPSL_SUBMISS to PRPSL_GRP_PRPSL_ASSC" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_PGPA_TO_PRPSL_SUBMISS |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | PRPSL_SUBMISS |
| Child Table | PRPSL_GRP_PRPSL_ASSC |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "PRPSL_SUBMISS to PRPSL_GRP_PRPSL_ASSC" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "PRPSL_SUBMISS to PRPSL_GRP_PRPSL_ASSC" Foreign Keys |
| Parent Key | Child Key |
| PRPSL_ID, SUBMISS_NBR | PRPSL_ID, SUBMISS_NBR |
| "PRPSL_SUBMISS to PRPSL_GRP_PRPSL_ASSC" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "PRPSL_SUBMISS to PRPSL_GRP_PRPSL_ASSC" Bound Attachments |
| Name | Current Value |
| "PRPSL_SUBMISS to PRPSL_LOG_ENTRY_ASSC" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_PLEA_TO_PRPSL_SUBMISS |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | PRPSL_SUBMISS |
| Child Table | PRPSL_LOG_ENTRY_ASSC |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "PRPSL_SUBMISS to PRPSL_LOG_ENTRY_ASSC" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "PRPSL_SUBMISS to PRPSL_LOG_ENTRY_ASSC" Foreign Keys |
| Parent Key | Child Key |
| PRPSL_ID, SUBMISS_NBR | PRPSL_ID, SUBMISS_NBR |
| "PRPSL_SUBMISS to PRPSL_LOG_ENTRY_ASSC" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "PRPSL_SUBMISS to PRPSL_LOG_ENTRY_ASSC" Bound Attachments |
| Name | Current Value |
| "UOM to EXPT_RSRC" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | fk_press_uom_to_uom |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | UOM |
| Child Table | EXPT_RSRC |
| Cardinality | Zero or One to Zero or More |
| Existence | Optional |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "UOM to EXPT_RSRC" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "UOM to EXPT_RSRC" Foreign Keys |
| Parent Key | Child Key |
| UNIT_ID | PRESS_UOM |
| "UOM to EXPT_RSRC" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "UOM to EXPT_RSRC" Bound Attachments |
| Name | Current Value |
| "PRPSL_TYPE to PROPOSAL" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | FK_PROPOSAL_TO_PRPSL_TYPE |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | PRPSL_TYPE |
| Child Table | PROPOSAL |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "PRPSL_TYPE to PROPOSAL" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "PRPSL_TYPE to PROPOSAL" Foreign Keys |
| Parent Key | Child Key |
| PRPSL_TYPE_ID | PRPSL_TYPE_ID |
| "PRPSL_TYPE to PROPOSAL" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "PRPSL_TYPE to PROPOSAL" Bound Attachments |
| Name | Current Value |
| "INSTR to PRPSL_INSTR" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_PRPSL_INSTR_TO_INSTR |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | INSTR |
| Child Table | PRPSL_INSTR |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "INSTR to PRPSL_INSTR" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "INSTR to PRPSL_INSTR" Foreign Keys |
| Parent Key | Child Key |
| INSTR_ID | INSTR_ID |
| "INSTR to PRPSL_INSTR" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "INSTR to PRPSL_INSTR" Bound Attachments |
| Name | Current Value |
| "PRPSL_SUBMISS to PRPSL_INSTR" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_PRPSL_INSTR_TO_PRPSL_SUB |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | PRPSL_SUBMISS |
| Child Table | PRPSL_INSTR |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "PRPSL_SUBMISS to PRPSL_INSTR" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "PRPSL_SUBMISS to PRPSL_INSTR" Foreign Keys |
| Parent Key | Child Key |
| PRPSL_ID, SUBMISS_NBR | PRPSL_ID, SUBMISS_NBR |
| "PRPSL_SUBMISS to PRPSL_INSTR" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "PRPSL_SUBMISS to PRPSL_INSTR" Bound Attachments |
| Name | Current Value |
| "PROPOSAL to PRPSL_SUBMISS" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_PRPSL_SUB_TO_PRPSL |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | PROPOSAL |
| Child Table | PRPSL_SUBMISS |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "PROPOSAL to PRPSL_SUBMISS" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "PROPOSAL to PRPSL_SUBMISS" Foreign Keys |
| Parent Key | Child Key |
| PRPSL_ID | PRPSL_ID |
| "PROPOSAL to PRPSL_SUBMISS" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "PROPOSAL to PRPSL_SUBMISS" Bound Attachments |
| Name | Current Value |
| "PERSON to PROPOSAL" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | fk_prpsl_to_person |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | PERSON |
| Child Table | PROPOSAL |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "PERSON to PROPOSAL" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "PERSON to PROPOSAL" Foreign Keys |
| Parent Key | Child Key |
| PERSON_ID | PERSON_ID |
| "PERSON to PROPOSAL" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "PERSON to PROPOSAL" Bound Attachments |
| Name | Current Value |
| "INSTR to PRPSL_TYPE_SCHED" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_PRPSL_TYPE_SCHED_TO_INSTR |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | INSTR |
| Child Table | PRPSL_TYPE_SCHED |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "INSTR to PRPSL_TYPE_SCHED" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "INSTR to PRPSL_TYPE_SCHED" Foreign Keys |
| Parent Key | Child Key |
| INSTR_ID | INSTR_ID |
| "INSTR to PRPSL_TYPE_SCHED" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "INSTR to PRPSL_TYPE_SCHED" Bound Attachments |
| Name | Current Value |
| "PRPSL_TYPE to PRPSL_TYPE_SCHED" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_PTS_TO_PRPSL_TYPE |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | PRPSL_TYPE |
| Child Table | PRPSL_TYPE_SCHED |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "PRPSL_TYPE to PRPSL_TYPE_SCHED" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "PRPSL_TYPE to PRPSL_TYPE_SCHED" Foreign Keys |
| Parent Key | Child Key |
| PRPSL_TYPE_ID | PRPSL_TYPE_ID |
| "PRPSL_TYPE to PRPSL_TYPE_SCHED" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "PRPSL_TYPE to PRPSL_TYPE_SCHED" Bound Attachments |
| Name | Current Value |
| "EXPRESS_ACT to RECENT_ACT" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_RECENT_ACT_TO_EXP_ACT |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | EXPRESS_ACT |
| Child Table | RECENT_ACT |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "EXPRESS_ACT to RECENT_ACT" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "EXPRESS_ACT to RECENT_ACT" Foreign Keys |
| Parent Key | Child Key |
| ACT_ID | ACT_ID |
| "EXPRESS_ACT to RECENT_ACT" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "EXPRESS_ACT to RECENT_ACT" Bound Attachments |
| Name | Current Value |
| "USER_PROF to REGION_HIDE" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_REGION_HIDE_TO_USER_PROF |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | USER_PROF |
| Child Table | REGION_HIDE |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "USER_PROF to REGION_HIDE" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "USER_PROF to REGION_HIDE" Foreign Keys |
| Parent Key | Child Key |
| BN | BN |
| "USER_PROF to REGION_HIDE" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "USER_PROF to REGION_HIDE" Bound Attachments |
| Name | Current Value |
| "EMPLOYEE to EXPT_RSRC_PERS_RSRC" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_REPA_TO_EMP |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | EMPLOYEE |
| Child Table | EXPT_RSRC_PERS_RSRC |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "EMPLOYEE to EXPT_RSRC_PERS_RSRC" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "EMPLOYEE to EXPT_RSRC_PERS_RSRC" Foreign Keys |
| Parent Key | Child Key |
| BN | BN |
| "EMPLOYEE to EXPT_RSRC_PERS_RSRC" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "EMPLOYEE to EXPT_RSRC_PERS_RSRC" Bound Attachments |
| Name | Current Value |
| "UOM to EXPT_RSRC" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | fk_restore_uom_to_uom |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | UOM |
| Child Table | EXPT_RSRC |
| Cardinality | Zero or One to Zero or More |
| Existence | Optional |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "UOM to EXPT_RSRC" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "UOM to EXPT_RSRC" Foreign Keys |
| Parent Key | Child Key |
| UNIT_ID | RESTORE_TIME_UOM |
| "UOM to EXPT_RSRC" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "UOM to EXPT_RSRC" Bound Attachments |
| Name | Current Value |
| "EXPT_RSRC to RSRC_SET_TMP" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | fk_rst_to_expt_rsrc |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | EXPT_RSRC |
| Child Table | RSRC_SET_TMP |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "EXPT_RSRC to RSRC_SET_TMP" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "EXPT_RSRC to RSRC_SET_TMP" Foreign Keys |
| Parent Key | Child Key |
| EXPT_RSRC_ID | EXPT_RSRC_ID |
| "EXPT_RSRC to RSRC_SET_TMP" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "EXPT_RSRC to RSRC_SET_TMP" Bound Attachments |
| Name | Current Value |
| "UOM to EXPT_RSRC" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | fk_setup_uom_to_uom |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | UOM |
| Child Table | EXPT_RSRC |
| Cardinality | Zero or One to Zero or More |
| Existence | Optional |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "UOM to EXPT_RSRC" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "UOM to EXPT_RSRC" Foreign Keys |
| Parent Key | Child Key |
| UNIT_ID | SETUP_TIME_UOM |
| "UOM to EXPT_RSRC" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "UOM to EXPT_RSRC" Bound Attachments |
| Name | Current Value |
| "PERSON to SAMPLE" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | fk_smpl_to_person |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | PERSON |
| 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 |
| "PERSON to SAMPLE" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "PERSON to SAMPLE" Foreign Keys |
| Parent Key | Child Key |
| PERSON_ID | smpl_owner_person_id |
| "PERSON to SAMPLE" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "PERSON to SAMPLE" Bound Attachments |
| Name | Current Value |
| "UOM to EXPT_RSRC" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | fk_smpl_uom_to_uom |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | UOM |
| Child Table | EXPT_RSRC |
| Cardinality | Zero or One to Zero or More |
| Existence | Optional |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "UOM to EXPT_RSRC" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "UOM to EXPT_RSRC" Foreign Keys |
| Parent Key | Child Key |
| UNIT_ID | SMPL_SPACE_UOM |
| "UOM to EXPT_RSRC" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "UOM to EXPT_RSRC" Bound Attachments |
| Name | Current Value |
| "UOM to EXPT_RSRC" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | fk_tail_uom_to_uom |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | UOM |
| Child Table | EXPT_RSRC |
| Cardinality | Zero or One to Zero or More |
| Existence | Optional |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "UOM to EXPT_RSRC" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "UOM to EXPT_RSRC" Foreign Keys |
| Parent Key | Child Key |
| UNIT_ID | TAIL_DIST_CENTER_UOM |
| "UOM to EXPT_RSRC" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "UOM to EXPT_RSRC" Bound Attachments |
| Name | Current Value |
| "UOM to EXPT_RSRC" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | fk_temp_uom_to_uom |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | UOM |
| Child Table | EXPT_RSRC |
| Cardinality | Zero or One to Zero or More |
| Existence | Optional |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "UOM to EXPT_RSRC" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "UOM to EXPT_RSRC" Foreign Keys |
| Parent Key | Child Key |
| UNIT_ID | TEMP_UOM |
| "UOM to EXPT_RSRC" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "UOM to EXPT_RSRC" Bound Attachments |
| Name | Current Value |
| "APPL_FILE to USER_APPL_FILE_ASSC" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_UADA_TO_APPL_FILE |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | APPL_FILE |
| Child Table | USER_APPL_FILE_ASSC |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "APPL_FILE to USER_APPL_FILE_ASSC" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "APPL_FILE to USER_APPL_FILE_ASSC" Foreign Keys |
| Parent Key | Child Key |
| APPL_FILE_ID | APPL_FILE_ID |
| "APPL_FILE to USER_APPL_FILE_ASSC" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "APPL_FILE to USER_APPL_FILE_ASSC" Bound Attachments |
| Name | Current Value |
| "USER_PROF to USER_APPL_FILE_ASSC" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_UAFA_TO_USER_PROFILE |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | USER_PROF |
| Child Table | USER_APPL_FILE_ASSC |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "USER_PROF to USER_APPL_FILE_ASSC" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "USER_PROF to USER_APPL_FILE_ASSC" Foreign Keys |
| Parent Key | Child Key |
| BN | BN |
| "USER_PROF to USER_APPL_FILE_ASSC" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "USER_PROF to USER_APPL_FILE_ASSC" Bound Attachments |
| Name | Current Value |
| "EMAIL_TEMPLATE to USER_EMAIL_TMPL_ASSC" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_UETA_TO_EMAIL_TMPL |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | EMAIL_TEMPLATE |
| Child Table | USER_EMAIL_TMPL_ASSC |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "EMAIL_TEMPLATE to USER_EMAIL_TMPL_ASSC" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "EMAIL_TEMPLATE to USER_EMAIL_TMPL_ASSC" Foreign Keys |
| Parent Key | Child Key |
| TEMPLATE_ID | TEMPLATE_ID |
| "EMAIL_TEMPLATE to USER_EMAIL_TMPL_ASSC" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "EMAIL_TEMPLATE to USER_EMAIL_TMPL_ASSC" Bound Attachments |
| Name | Current Value |
| "EMPLOYEE to USER_EMAIL_TMPL_ASSC" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_UETA_TO_EMP |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | EMPLOYEE |
| Child Table | USER_EMAIL_TMPL_ASSC |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "EMPLOYEE to USER_EMAIL_TMPL_ASSC" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "EMPLOYEE to USER_EMAIL_TMPL_ASSC" Foreign Keys |
| Parent Key | Child Key |
| BN | BN |
| "EMPLOYEE to USER_EMAIL_TMPL_ASSC" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "EMPLOYEE to USER_EMAIL_TMPL_ASSC" Bound Attachments |
| Name | Current Value |
| "UOM to UOM_COL_ASSC" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | fk_uomca_to_uom |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | UOM |
| Child Table | UOM_COL_ASSC |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "UOM to UOM_COL_ASSC" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "UOM to UOM_COL_ASSC" Foreign Keys |
| Parent Key | Child Key |
| UNIT_ID | UNIT_ID |
| "UOM to UOM_COL_ASSC" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "UOM to UOM_COL_ASSC" Bound Attachments |
| Name | Current Value |
| "UOM_COL to UOM_COL_ASSC" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | fk_uomca_to_uom_col |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | UOM_COL |
| Child Table | UOM_COL_ASSC |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "UOM_COL to UOM_COL_ASSC" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "UOM_COL to UOM_COL_ASSC" Foreign Keys |
| Parent Key | Child Key |
| COL_NM_ID | COL_NM_ID |
| "UOM_COL to UOM_COL_ASSC" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "UOM_COL to UOM_COL_ASSC" Bound Attachments |
| Name | Current Value |
| "EMPLOYEE to USER_PROF" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_USER_PROF_TO_EMP |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | EMPLOYEE |
| Child Table | USER_PROF |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "EMPLOYEE to USER_PROF" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "EMPLOYEE to USER_PROF" Foreign Keys |
| Parent Key | Child Key |
| BN | BN |
| "EMPLOYEE to USER_PROF" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "EMPLOYEE to USER_PROF" Bound Attachments |
| Name | Current Value |
| "INSTR to USER_PROF" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | FK_USER_PROF_TO_INSTR |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | INSTR |
| Child Table | USER_PROF |
| 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 USER_PROF" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "INSTR to USER_PROF" Foreign Keys |
| Parent Key | Child Key |
| INSTR_ID | DEF_INSTR_ID |
| "INSTR to USER_PROF" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "INSTR to USER_PROF" Bound Attachments |
| Name | Current Value |
| "PERSON to USER_PROF" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | FK_USER_PROF_TO_PERSON |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | PERSON |
| Child Table | USER_PROF |
| Cardinality | Zero or One to Zero or More |
| Existence | Optional |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "PERSON to USER_PROF" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "PERSON to USER_PROF" Foreign Keys |
| Parent Key | Child Key |
| PERSON_ID | IMP_PERSON_ID |
| "PERSON to USER_PROF" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "PERSON to USER_PROF" Bound Attachments |
| Name | Current Value |