| "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 |
| "UNIT_LEN to EXPT_SMPL" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | UNIT_LEN |
| Child Table | EXPT_SMPL |
| Cardinality | Zero or One to Zero or More |
| Existence | Optional |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "UNIT_LEN to EXPT_SMPL" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "UNIT_LEN to EXPT_SMPL" Foreign Keys |
| Parent Key | Child Key |
| LEN_UNIT_ID | LEN_UNIT_ID |
| "UNIT_LEN to EXPT_SMPL" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "UNIT_LEN to EXPT_SMPL" Bound Attachments |
| Name | Current Value |
| "UNIT_MASS to EXPT_SMPL" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | UNIT_MASS |
| Child Table | EXPT_SMPL |
| Cardinality | Zero or One to Zero or More |
| Existence | Optional |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "UNIT_MASS to EXPT_SMPL" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "UNIT_MASS to EXPT_SMPL" Foreign Keys |
| Parent Key | Child Key |
| MASS_UNIT_ID | MASS_UNIT_ID |
| "UNIT_MASS to EXPT_SMPL" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "UNIT_MASS to EXPT_SMPL" Bound Attachments |
| Name | Current Value |
| "UNIT_LEN to EXPT_SMPL" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | UNIT_LEN |
| Child Table | EXPT_SMPL |
| Cardinality | Zero or One to Zero or More |
| Existence | Optional |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "UNIT_LEN to EXPT_SMPL" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "UNIT_LEN to EXPT_SMPL" Foreign Keys |
| Parent Key | Child Key |
| LEN_UNIT_ID | SMPL_SIZE_UOL |
| "UNIT_LEN to EXPT_SMPL" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "UNIT_LEN to EXPT_SMPL" Bound Attachments |
| Name | Current Value |
| "UNIT_TEMP to EXPT_SMPL_ENV" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | UNIT_TEMP |
| Child Table | EXPT_SMPL_ENV |
| Cardinality | Zero or One to Zero or More |
| Existence | Optional |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "UNIT_TEMP to EXPT_SMPL_ENV" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "UNIT_TEMP to EXPT_SMPL_ENV" Foreign Keys |
| Parent Key | Child Key |
| TEMP_UNIT_ID | TEMP_UNIT_ID |
| "UNIT_TEMP to EXPT_SMPL_ENV" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "UNIT_TEMP to EXPT_SMPL_ENV" Bound Attachments |
| Name | Current Value |
| "BEAM_ALLOC_ALLOT to BEAM_ALLOC" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_BA_TO_BEAM_ALLOC_ALLOT |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | BEAM_ALLOC_ALLOT |
| Child Table | BEAM_ALLOC |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "BEAM_ALLOC_ALLOT to BEAM_ALLOC" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "BEAM_ALLOC_ALLOT to BEAM_ALLOC" Foreign Keys |
| Parent Key | Child Key |
| ALLOT_ID | ALLOT_ID |
| "BEAM_ALLOC_ALLOT to BEAM_ALLOC" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "BEAM_ALLOC_ALLOT to BEAM_ALLOC" Bound Attachments |
| Name | Current Value |
| "PRPSL_TYPE to BEAM_ALLOC" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_BA_TO_PRPSL_TYPE |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | PRPSL_TYPE |
| Child Table | BEAM_ALLOC |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "PRPSL_TYPE to BEAM_ALLOC" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "PRPSL_TYPE to BEAM_ALLOC" Foreign Keys |
| Parent Key | Child Key |
| PRPSL_TYPE_ID | PRPSL_TYPE_ID |
| "PRPSL_TYPE to BEAM_ALLOC" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "PRPSL_TYPE to BEAM_ALLOC" Bound Attachments |
| Name | Current Value |
| "PRPSL_INSTR to BAC_ALLOC_HIST" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_BAH_TO_PRPSL_INSTR |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | PRPSL_INSTR |
| Child Table | BAC_ALLOC_HIST |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "PRPSL_INSTR to BAC_ALLOC_HIST" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "PRPSL_INSTR to BAC_ALLOC_HIST" Foreign Keys |
| Parent Key | Child Key |
| PRPSL_ID, SUBMISS_NBR, INSTR_ID | PRPSL_ID, SUBMISS_NBR, INSTR_ID |
| "PRPSL_INSTR to BAC_ALLOC_HIST" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "PRPSL_INSTR to BAC_ALLOC_HIST" Bound Attachments |
| Name | Current Value |
| "RUN_CYCLE to BEAM_ALLOC" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_BEAM_ALLOC_RUN_CYCLE |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | RUN_CYCLE |
| Child Table | BEAM_ALLOC |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "RUN_CYCLE to BEAM_ALLOC" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "RUN_CYCLE to BEAM_ALLOC" Foreign Keys |
| Parent Key | Child Key |
| FACIL_ID, RUN_CYCLE_ID | FACIL_ID, RUN_CYCLE_ID |
| "RUN_CYCLE to BEAM_ALLOC" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "RUN_CYCLE to BEAM_ALLOC" Bound Attachments |
| Name | Current Value |
| "BES_RSCH_AREA to PRPSL_BES_RSCH_AREA" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_BES_RSCH_AREA_PRPSL_BRA |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | BES_RSCH_AREA |
| Child Table | PRPSL_BES_RSCH_AREA |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "BES_RSCH_AREA to PRPSL_BES_RSCH_AREA" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "BES_RSCH_AREA to PRPSL_BES_RSCH_AREA" Foreign Keys |
| Parent Key | Child Key |
| RSCH_AREA_ID | RSCH_AREA_ID |
| "BES_RSCH_AREA to PRPSL_BES_RSCH_AREA" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "BES_RSCH_AREA to PRPSL_BES_RSCH_AREA" Bound Attachments |
| Name | Current Value |
| "EXPT_SCHED to EXPT_INSTR_TM_SFTY_REV" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_EITSR_TO_EXPT_SCHED |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | EXPT_SCHED |
| Child Table | EXPT_INSTR_TM_SFTY_REV |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "EXPT_SCHED to EXPT_INSTR_TM_SFTY_REV" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "EXPT_SCHED to EXPT_INSTR_TM_SFTY_REV" 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 EXPT_INSTR_TM_SFTY_REV" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "EXPT_SCHED to EXPT_INSTR_TM_SFTY_REV" Bound Attachments |
| Name | Current Value |
| "EXPT_SMPL to EXPT_SMPL_FORM_ASSC" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_ESFA_TO_EXPT_SMPL |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | EXPT_SMPL |
| Child Table | EXPT_SMPL_FORM_ASSC |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "EXPT_SMPL to EXPT_SMPL_FORM_ASSC" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "EXPT_SMPL to EXPT_SMPL_FORM_ASSC" Foreign Keys |
| Parent Key | Child Key |
| PRPSL_ID, SUBMISS_NBR, SMPL_ID | PRPSL_ID, SUBMISS_NBR, SMPL_ID |
| "EXPT_SMPL to EXPT_SMPL_FORM_ASSC" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "EXPT_SMPL to EXPT_SMPL_FORM_ASSC" Bound Attachments |
| Name | Current Value |
| "EXPT_SMPL to EXPT_SMPL_HAZ_ASSC" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_ESHA_TO_EXPT_SMPL |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | EXPT_SMPL |
| Child Table | EXPT_SMPL_HAZ_ASSC |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "EXPT_SMPL to EXPT_SMPL_HAZ_ASSC" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "EXPT_SMPL to EXPT_SMPL_HAZ_ASSC" Foreign Keys |
| Parent Key | Child Key |
| PRPSL_ID, SUBMISS_NBR, SMPL_ID | PRPSL_ID, SUBMISS_NBR, SMPL_ID |
| "EXPT_SMPL to EXPT_SMPL_HAZ_ASSC" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "EXPT_SMPL to EXPT_SMPL_HAZ_ASSC" Bound Attachments |
| Name | Current Value |
| "EXPT_SMPL to EXPT_SMPL_SPEC_REQ_ASSC" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_ESSRA_TO_EXPT_SMPL |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | EXPT_SMPL |
| Child Table | EXPT_SMPL_SPEC_REQ_ASSC |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "EXPT_SMPL to EXPT_SMPL_SPEC_REQ_ASSC" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "EXPT_SMPL to EXPT_SMPL_SPEC_REQ_ASSC" Foreign Keys |
| Parent Key | Child Key |
| PRPSL_ID, SUBMISS_NBR, SMPL_ID | PRPSL_ID, SUBMISS_NBR, SMPL_ID |
| "EXPT_SMPL to EXPT_SMPL_SPEC_REQ_ASSC" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "EXPT_SMPL to EXPT_SMPL_SPEC_REQ_ASSC" 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 |
| "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 |
| "PRPSL_SUBMISS to EXPT_SMPL_ENV" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_EXPT_SMPL_ENV_TO_PRPSL_SUB |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | PRPSL_SUBMISS |
| Child Table | EXPT_SMPL_ENV |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "PRPSL_SUBMISS to EXPT_SMPL_ENV" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "PRPSL_SUBMISS to EXPT_SMPL_ENV" Foreign Keys |
| Parent Key | Child Key |
| PRPSL_ID, SUBMISS_NBR | PRPSL_ID, SUBMISS_NBR |
| "PRPSL_SUBMISS to EXPT_SMPL_ENV" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "PRPSL_SUBMISS to EXPT_SMPL_ENV" Bound Attachments |
| Name | Current Value |
| "EXPT_SMPL to EXPT_SMPL_SMPL_ENV_ASSC" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_EXPT_SMPL_SMPL_ENV |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | EXPT_SMPL |
| Child Table | EXPT_SMPL_SMPL_ENV_ASSC |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "EXPT_SMPL to EXPT_SMPL_SMPL_ENV_ASSC" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "EXPT_SMPL to EXPT_SMPL_SMPL_ENV_ASSC" Foreign Keys |
| Parent Key | Child Key |
| PRPSL_ID, SUBMISS_NBR, SMPL_ID | PRPSL_ID, SUBMISS_NBR, SMPL_ID |
| "EXPT_SMPL to EXPT_SMPL_SMPL_ENV_ASSC" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "EXPT_SMPL to EXPT_SMPL_SMPL_ENV_ASSC" Bound Attachments |
| Name | Current Value |
| "EXPT_SMPL to EXPT_SMPL_SMPL_SAFE_ASSC" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_EXPT_SMPL_SMPL_SAFE |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | EXPT_SMPL |
| Child Table | EXPT_SMPL_SMPL_SAFE_ASSC |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "EXPT_SMPL to EXPT_SMPL_SMPL_SAFE_ASSC" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "EXPT_SMPL to EXPT_SMPL_SMPL_SAFE_ASSC" Foreign Keys |
| Parent Key | Child Key |
| PRPSL_ID, SUBMISS_NBR, SMPL_ID | PRPSL_ID, SUBMISS_NBR, SMPL_ID |
| "EXPT_SMPL to EXPT_SMPL_SMPL_SAFE_ASSC" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "EXPT_SMPL to EXPT_SMPL_SMPL_SAFE_ASSC" Bound Attachments |
| Name | Current Value |
| "PRPSL_SUBMISS to EXPT_SMPL" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_EXPT_SMPL_TO_PRPSL_SUB |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | PRPSL_SUBMISS |
| Child Table | EXPT_SMPL |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "PRPSL_SUBMISS to EXPT_SMPL" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "PRPSL_SUBMISS to EXPT_SMPL" Foreign Keys |
| Parent Key | Child Key |
| PRPSL_ID, SUBMISS_NBR | PRPSL_ID, SUBMISS_NBR |
| "PRPSL_SUBMISS to EXPT_SMPL" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "PRPSL_SUBMISS to EXPT_SMPL" Bound Attachments |
| Name | Current Value |
| "UNIT_TEMP to EXPT_SMPL" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | FK_EXPT_SMPL_TO_TEMP_UNIT |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | UNIT_TEMP |
| Child Table | EXPT_SMPL |
| Cardinality | Zero or One to Zero or More |
| Existence | Optional |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "UNIT_TEMP to EXPT_SMPL" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "UNIT_TEMP to EXPT_SMPL" Foreign Keys |
| Parent Key | Child Key |
| TEMP_UNIT_ID | TEMP_UNIT_ID |
| "UNIT_TEMP to EXPT_SMPL" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "UNIT_TEMP to EXPT_SMPL" Bound Attachments |
| Name | Current Value |
| "EXPT_SMPL_APPR_CODE to EXPT_SMPL" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | FK_EXPT_TO_EXPT_SMPL_APPR_CD |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | EXPT_SMPL_APPR_CODE |
| Child Table | EXPT_SMPL |
| Cardinality | Zero or One to Zero or More |
| Existence | Optional |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "EXPT_SMPL_APPR_CODE to EXPT_SMPL" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "EXPT_SMPL_APPR_CODE to EXPT_SMPL" Foreign Keys |
| Parent Key | Child Key |
| APPRV_ID | APPRV_ID |
| "EXPT_SMPL_APPR_CODE to EXPT_SMPL" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "EXPT_SMPL_APPR_CODE to EXPT_SMPL" Bound Attachments |
| Name | Current Value |
| "PERSON to FEEDBACK" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_FEEDBACK_TO_PERSON |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | PERSON |
| Child Table | FEEDBACK |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "PERSON to FEEDBACK" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "PERSON to FEEDBACK" Foreign Keys |
| Parent Key | Child Key |
| PERSON_ID | PERSON_ID |
| "PERSON to FEEDBACK" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "PERSON to FEEDBACK" Bound Attachments |
| Name | Current Value |
| "FEAS_REV_CAT to FEAS_REVIEW_STAT" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_FRS_TO_FEAS_REV_CAT |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | FEAS_REV_CAT |
| Child Table | FEAS_REVIEW_STAT |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "FEAS_REV_CAT to FEAS_REVIEW_STAT" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "FEAS_REV_CAT to FEAS_REVIEW_STAT" Foreign Keys |
| Parent Key | Child Key |
| FEAS_REV_CAT_ID | FEAS_REV_CAT_ID |
| "FEAS_REV_CAT to FEAS_REVIEW_STAT" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "FEAS_REV_CAT to FEAS_REVIEW_STAT" Bound Attachments |
| Name | Current Value |
| "PRPSL_INSTR to IDT_REV_COMM" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_IDT_REV_COMM_TO_PRPSL_INSTR |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | PRPSL_INSTR |
| Child Table | IDT_REV_COMM |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "PRPSL_INSTR to IDT_REV_COMM" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "PRPSL_INSTR to IDT_REV_COMM" Foreign Keys |
| Parent Key | Child Key |
| PRPSL_ID, SUBMISS_NBR, INSTR_ID | PRPSL_ID, SUBMISS_NBR, INSTR_ID |
| "PRPSL_INSTR to IDT_REV_COMM" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "PRPSL_INSTR to IDT_REV_COMM" Bound Attachments |
| Name | Current Value |
| "PERSON to IDT_REV" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_IDT_REV_TO_PERSON |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | PERSON |
| Child Table | IDT_REV |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "PERSON to IDT_REV" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "PERSON to IDT_REV" Foreign Keys |
| Parent Key | Child Key |
| PERSON_ID | PERSON_ID |
| "PERSON to IDT_REV" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "PERSON to IDT_REV" Bound Attachments |
| Name | Current Value |
| "PRPSL_INSTR to IDT_REV" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_IDT_REV_TO_PRPSL_INSTR |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | PRPSL_INSTR |
| Child Table | IDT_REV |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "PRPSL_INSTR to IDT_REV" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "PRPSL_INSTR to IDT_REV" Foreign Keys |
| Parent Key | Child Key |
| PRPSL_ID, SUBMISS_NBR, INSTR_ID | PRPSL_ID, SUBMISS_NBR, INSTR_ID |
| "PRPSL_INSTR to IDT_REV" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "PRPSL_INSTR to IDT_REV" Bound Attachments |
| Name | Current Value |
| "INSTR to INSTR_INSTR_PRPSL_ASSC" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_IIPQA_TO_INSTR |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | INSTR |
| Child Table | INSTR_INSTR_PRPSL_ASSC |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "INSTR to INSTR_INSTR_PRPSL_ASSC" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "INSTR to INSTR_INSTR_PRPSL_ASSC" Foreign Keys |
| Parent Key | Child Key |
| INSTR_ID | INSTR_ID |
| "INSTR to INSTR_INSTR_PRPSL_ASSC" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "INSTR to INSTR_INSTR_PRPSL_ASSC" Bound Attachments |
| Name | Current Value |
| "INSTR_PRPSL_QUES to INSTR_INSTR_PRPSL_ASSC" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_IIPQA_TO_INSTR_PRPSL_QUES |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | INSTR_PRPSL_QUES |
| Child Table | INSTR_INSTR_PRPSL_ASSC |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "INSTR_PRPSL_QUES to INSTR_INSTR_PRPSL_ASSC" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "INSTR_PRPSL_QUES to INSTR_INSTR_PRPSL_ASSC" Foreign Keys |
| Parent Key | Child Key |
| QUESTION_ID | QUESTION_ID |
| "INSTR_PRPSL_QUES to INSTR_INSTR_PRPSL_ASSC" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "INSTR_PRPSL_QUES to INSTR_INSTR_PRPSL_ASSC" 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 |
| "INSTR to BEAM_ALLOC" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_INSTR_ID |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | INSTR |
| Child Table | BEAM_ALLOC |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "INSTR to BEAM_ALLOC" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "INSTR to BEAM_ALLOC" Foreign Keys |
| Parent Key | Child Key |
| INSTR_ID | INSTR_ID |
| "INSTR to BEAM_ALLOC" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "INSTR to BEAM_ALLOC" Bound Attachments |
| Name | Current Value |
| "PRPSL_TYPE to INSTR_PRPSL_TYPE_SOR_ASSC" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_INTSA_TO_PRPSL_TYPE |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | PRPSL_TYPE |
| Child Table | INSTR_PRPSL_TYPE_SOR_ASSC |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "PRPSL_TYPE to INSTR_PRPSL_TYPE_SOR_ASSC" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "PRPSL_TYPE to INSTR_PRPSL_TYPE_SOR_ASSC" Foreign Keys |
| Parent Key | Child Key |
| PRPSL_TYPE_ID | PRPSL_TYPE_ID |
| "PRPSL_TYPE to INSTR_PRPSL_TYPE_SOR_ASSC" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "PRPSL_TYPE to INSTR_PRPSL_TYPE_SOR_ASSC" Bound Attachments |
| Name | Current Value |
| "PRPSL_ROLE_PERS_ASSC to INSTR_PDRC_ASSC" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_IPDRCA_TO_PRPSL_ROLE_ASSC |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | PRPSL_ROLE_PERS_ASSC |
| Child Table | INSTR_PDRC_ASSC |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "PRPSL_ROLE_PERS_ASSC to INSTR_PDRC_ASSC" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "PRPSL_ROLE_PERS_ASSC to INSTR_PDRC_ASSC" Foreign Keys |
| Parent Key | Child Key |
| ROLE_ID, PERSON_ID | ROLE_ID, PERSON_ID |
| "PRPSL_ROLE_PERS_ASSC to INSTR_PDRC_ASSC" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "PRPSL_ROLE_PERS_ASSC to INSTR_PDRC_ASSC" Bound Attachments |
| Name | Current Value |
| "IPTS_REL_NBR to IPTS_PROJ_TRACK" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | FK_IPT_TO_IPTS_REL_NBR |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | IPTS_REL_NBR |
| Child Table | IPTS_PROJ_TRACK |
| Cardinality | Zero or One to Zero or More |
| Existence | Optional |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "IPTS_REL_NBR to IPTS_PROJ_TRACK" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "IPTS_REL_NBR to IPTS_PROJ_TRACK" Foreign Keys |
| Parent Key | Child Key |
| REL_ID | REL_ID |
| "IPTS_REL_NBR to IPTS_PROJ_TRACK" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "IPTS_REL_NBR to IPTS_PROJ_TRACK" Bound Attachments |
| Name | Current Value |
| "IPTS_ACT to IPTS_LOG" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_IPTS_LOG_TO_IPTS_ACT |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | IPTS_ACT |
| Child Table | IPTS_LOG |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "IPTS_ACT to IPTS_LOG" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "IPTS_ACT to IPTS_LOG" Foreign Keys |
| Parent Key | Child Key |
| ACT_ID | ACT_ID |
| "IPTS_ACT to IPTS_LOG" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "IPTS_ACT to IPTS_LOG" Bound Attachments |
| Name | Current Value |
| "APPL_FILE to INSTR_PRPSL_TYPE_SOR_ASSC" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | FK_IPTSA_TO_APPL_FILE |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | APPL_FILE |
| Child Table | INSTR_PRPSL_TYPE_SOR_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 INSTR_PRPSL_TYPE_SOR_ASSC" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "APPL_FILE to INSTR_PRPSL_TYPE_SOR_ASSC" Foreign Keys |
| Parent Key | Child Key |
| APPL_FILE_ID | APPL_FILE_ID |
| "APPL_FILE to INSTR_PRPSL_TYPE_SOR_ASSC" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "APPL_FILE to INSTR_PRPSL_TYPE_SOR_ASSC" Bound Attachments |
| Name | Current Value |
| "INSTR to INSTR_PRPSL_TYPE_SOR_ASSC" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_IPTSA_TO_INSTR |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | INSTR |
| Child Table | INSTR_PRPSL_TYPE_SOR_ASSC |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "INSTR to INSTR_PRPSL_TYPE_SOR_ASSC" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "INSTR to INSTR_PRPSL_TYPE_SOR_ASSC" Foreign Keys |
| Parent Key | Child Key |
| INSTR_ID | INSTR_ID |
| "INSTR to INSTR_PRPSL_TYPE_SOR_ASSC" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "INSTR to INSTR_PRPSL_TYPE_SOR_ASSC" 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 |
| "WORKFLOW to PRPSL_REV_WRKFLW" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | FK_NEXT_WRKFLW_TO_WRKFLW |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | WORKFLOW |
| Child Table | PRPSL_REV_WRKFLW |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "WORKFLOW to PRPSL_REV_WRKFLW" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "WORKFLOW to PRPSL_REV_WRKFLW" Foreign Keys |
| Parent Key | Child Key |
| WORKFLOW_ID | NEXT_WORKFLOW_ID |
| "WORKFLOW to PRPSL_REV_WRKFLW" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "WORKFLOW to PRPSL_REV_WRKFLW" Bound Attachments |
| Name | Current Value |
| "NONVAL_EXPT_TEAM_MBR to NONVAL_PRPSL_TM_ONSITE_ACC" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_NPTMOA_TO_NETM |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | NONVAL_EXPT_TEAM_MBR |
| Child Table | NONVAL_PRPSL_TM_ONSITE_ACC |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "NONVAL_EXPT_TEAM_MBR to NONVAL_PRPSL_TM_ONSITE_ACC" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "NONVAL_EXPT_TEAM_MBR to NONVAL_PRPSL_TM_ONSITE_ACC" Foreign Keys |
| Parent Key | Child Key |
| EMAIL_ADDR | EMAIL_ADDR |
| "NONVAL_EXPT_TEAM_MBR to NONVAL_PRPSL_TM_ONSITE_ACC" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "NONVAL_EXPT_TEAM_MBR to NONVAL_PRPSL_TM_ONSITE_ACC" Bound Attachments |
| Name | Current Value |
| "NONVAL_PRPSL_TM_ONSITE_ACC to NONVAL_TM_ONSITE_EXPT_SCH_ASSC" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_NTMOESA_TO_NPTMOA |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | NONVAL_PRPSL_TM_ONSITE_ACC |
| Child Table | NONVAL_TM_ONSITE_EXPT_SCH_ASSC |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "NONVAL_PRPSL_TM_ONSITE_ACC to NONVAL_TM_ONSITE_EXPT_SCH_ASSC" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "NONVAL_PRPSL_TM_ONSITE_ACC to NONVAL_TM_ONSITE_EXPT_SCH_ASSC" Foreign Keys |
| Parent Key | Child Key |
| EMAIL_ADDR | EMAIL_ADDR |
| "NONVAL_PRPSL_TM_ONSITE_ACC to NONVAL_TM_ONSITE_EXPT_SCH_ASSC" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "NONVAL_PRPSL_TM_ONSITE_ACC to NONVAL_TM_ONSITE_EXPT_SCH_ASSC" 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_LOG to PRPSL_ATTACH" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_PA_TO_PRPSL_LOG |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | PRPSL_LOG |
| Child Table | PRPSL_ATTACH |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "PRPSL_LOG to PRPSL_ATTACH" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "PRPSL_LOG to PRPSL_ATTACH" Foreign Keys |
| Parent Key | Child Key |
| PRPSL_ID, SUBMISS_NBR, MOD_DTE, ACT_ID | PRPSL_ID, SUBMISS_NBR, MOD_DTE, ACT_ID |
| "PRPSL_LOG to PRPSL_ATTACH" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "PRPSL_LOG to PRPSL_ATTACH" Bound Attachments |
| Name | Current Value |
| "PROPOSAL to PROG_DEV_PRPSL_REV" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_PDPR_TO_PROPOSAL |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | PROPOSAL |
| Child Table | PROG_DEV_PRPSL_REV |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "PROPOSAL to PROG_DEV_PRPSL_REV" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "PROPOSAL to PROG_DEV_PRPSL_REV" Foreign Keys |
| Parent Key | Child Key |
| PRPSL_ID | PRPSL_ID |
| "PROPOSAL to PROG_DEV_PRPSL_REV" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "PROPOSAL to PROG_DEV_PRPSL_REV" Bound Attachments |
| Name | Current Value |
| "PROPOSAL to PROG_DEV_REV_COMM" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_PDRC_TO_PROPOSAL |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | PROPOSAL |
| Child Table | PROG_DEV_REV_COMM |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "PROPOSAL to PROG_DEV_REV_COMM" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "PROPOSAL to PROG_DEV_REV_COMM" Foreign Keys |
| Parent Key | Child Key |
| PRPSL_ID | PRPSL_ID |
| "PROPOSAL to PROG_DEV_REV_COMM" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "PROPOSAL to PROG_DEV_REV_COMM" Bound Attachments |
| Name | Current Value |
| "ESS_SIGN_ROLE to PRPSL_ESS_APPR" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | FK_PEA_TO_ESSSR |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | ESS_SIGN_ROLE |
| Child Table | PRPSL_ESS_APPR |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "ESS_SIGN_ROLE to PRPSL_ESS_APPR" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "ESS_SIGN_ROLE to PRPSL_ESS_APPR" Foreign Keys |
| Parent Key | Child Key |
| ROLE_ID | ROLE_ID |
| "ESS_SIGN_ROLE to PRPSL_ESS_APPR" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "ESS_SIGN_ROLE to PRPSL_ESS_APPR" Bound Attachments |
| Name | Current Value |
| "EXPT_SCHED to PRPSL_ESS_APPR" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_PEA_TO_EXPT_SCHED |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | EXPT_SCHED |
| Child Table | PRPSL_ESS_APPR |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "EXPT_SCHED to PRPSL_ESS_APPR" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "EXPT_SCHED to PRPSL_ESS_APPR" 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 PRPSL_ESS_APPR" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "EXPT_SCHED to PRPSL_ESS_APPR" Bound Attachments |
| Name | Current Value |
| "PERSON to PRPSL_ESS_APPR" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | FK_PEA_TO_PERSON |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | PERSON |
| Child Table | PRPSL_ESS_APPR |
| 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_ESS_APPR" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "PERSON to PRPSL_ESS_APPR" Foreign Keys |
| Parent Key | Child Key |
| PERSON_ID | PERSON_ID |
| "PERSON to PRPSL_ESS_APPR" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "PERSON to PRPSL_ESS_APPR" Bound Attachments |
| Name | Current Value |
| "USER_PROFILE to PERS_RSCH_AREA_ASSC" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_PERS_RSCH_AREA_ASSC_TO_PERS |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | USER_PROFILE |
| Child Table | PERS_RSCH_AREA_ASSC |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "USER_PROFILE to PERS_RSCH_AREA_ASSC" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "USER_PROFILE to PERS_RSCH_AREA_ASSC" Foreign Keys |
| Parent Key | Child Key |
| PERSON_ID | PERSON_ID |
| "USER_PROFILE to PERS_RSCH_AREA_ASSC" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "USER_PROFILE to PERS_RSCH_AREA_ASSC" Bound Attachments |
| Name | Current Value |
| "FEAS_REVIEW_STAT to PRPSL_FEAS_REV" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_PFR_TO_FEAS_REVIEW_STATUS |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | FEAS_REVIEW_STAT |
| Child Table | PRPSL_FEAS_REV |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "FEAS_REVIEW_STAT to PRPSL_FEAS_REV" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "FEAS_REVIEW_STAT to PRPSL_FEAS_REV" Foreign Keys |
| Parent Key | Child Key |
| FEAS_REV_CAT_ID, FEAS_REVIEW_STAT_ID | FEAS_REV_CAT_ID, FEAS_REVIEW_STAT_ID |
| "FEAS_REVIEW_STAT to PRPSL_FEAS_REV" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "FEAS_REVIEW_STAT to PRPSL_FEAS_REV" Bound Attachments |
| Name | Current Value |
| "PRPSL_INSTR to PRPSL_FEAS_REV" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_PFR_TO_PRPSL_INSTR |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | PRPSL_INSTR |
| Child Table | PRPSL_FEAS_REV |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "PRPSL_INSTR to PRPSL_FEAS_REV" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "PRPSL_INSTR to PRPSL_FEAS_REV" Foreign Keys |
| Parent Key | Child Key |
| PRPSL_ID, SUBMISS_NBR, INSTR_ID | PRPSL_ID, SUBMISS_NBR, INSTR_ID |
| "PRPSL_INSTR to PRPSL_FEAS_REV" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "PRPSL_INSTR to PRPSL_FEAS_REV" Bound Attachments |
| Name | Current Value |
| "OPER_FEAS_REV_STAT to PRPSL_INSTR" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | FK_PI_TO_OPER_FEAS_REV_STAT |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | OPER_FEAS_REV_STAT |
| 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 |
| "OPER_FEAS_REV_STAT to PRPSL_INSTR" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "OPER_FEAS_REV_STAT to PRPSL_INSTR" Foreign Keys |
| Parent Key | Child Key |
| OPER_FEAS_REV_STAT_ID | OPER_FEAS_REV_STAT_ID |
| "OPER_FEAS_REV_STAT to PRPSL_INSTR" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "OPER_FEAS_REV_STAT to PRPSL_INSTR" Bound Attachments |
| Name | Current Value |
| "PRPSL_SUBMISS to PRPSL_INSTR_GRP_CHAIR_REV" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_PIGC_TO_PRPSL_SUB |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | PRPSL_SUBMISS |
| Child Table | PRPSL_INSTR_GRP_CHAIR_REV |
| 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_GRP_CHAIR_REV" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "PRPSL_SUBMISS to PRPSL_INSTR_GRP_CHAIR_REV" Foreign Keys |
| Parent Key | Child Key |
| PRPSL_ID, SUBMISS_NBR | PRPSL_ID, SUBMISS_NBR |
| "PRPSL_SUBMISS to PRPSL_INSTR_GRP_CHAIR_REV" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "PRPSL_SUBMISS to PRPSL_INSTR_GRP_CHAIR_REV" Bound Attachments |
| Name | Current Value |
| "INSTR_INSTR_PRPSL_ASSC to PRPSL_INSTR_QUES" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_PIQ_TO_INSTR_PRPSL_QUE_ASSC |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | INSTR_INSTR_PRPSL_ASSC |
| Child Table | PRPSL_INSTR_QUES |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "INSTR_INSTR_PRPSL_ASSC to PRPSL_INSTR_QUES" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "INSTR_INSTR_PRPSL_ASSC to PRPSL_INSTR_QUES" Foreign Keys |
| Parent Key | Child Key |
| QUESTION_ID, INSTR_ID | QUESTION_ID, INSTR_ID |
| "INSTR_INSTR_PRPSL_ASSC to PRPSL_INSTR_QUES" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "INSTR_INSTR_PRPSL_ASSC to PRPSL_INSTR_QUES" Bound Attachments |
| Name | Current Value |
| "PRPSL_INSTR to PRPSL_INSTR_QUES" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_PIQ_TO_PRPSL_INSTR |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | PRPSL_INSTR |
| Child Table | PRPSL_INSTR_QUES |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "PRPSL_INSTR to PRPSL_INSTR_QUES" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "PRPSL_INSTR to PRPSL_INSTR_QUES" Foreign Keys |
| Parent Key | Child Key |
| PRPSL_ID, SUBMISS_NBR, INSTR_ID | PRPSL_ID, SUBMISS_NBR, INSTR_ID |
| "PRPSL_INSTR to PRPSL_INSTR_QUES" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "PRPSL_INSTR to PRPSL_INSTR_QUES" Bound Attachments |
| Name | Current Value |
| "PRPSL_INSTR to PRPSL_INSTR_SMPL_ENV_ASSC" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_PISEA_TO_PRPSL_INSTR |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | PRPSL_INSTR |
| Child Table | PRPSL_INSTR_SMPL_ENV_ASSC |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "PRPSL_INSTR to PRPSL_INSTR_SMPL_ENV_ASSC" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "PRPSL_INSTR to PRPSL_INSTR_SMPL_ENV_ASSC" Foreign Keys |
| Parent Key | Child Key |
| PRPSL_ID, SUBMISS_NBR, INSTR_ID | PRPSL_ID, SUBMISS_NBR, INSTR_ID |
| "PRPSL_INSTR to PRPSL_INSTR_SMPL_ENV_ASSC" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "PRPSL_INSTR to PRPSL_INSTR_SMPL_ENV_ASSC" Bound Attachments |
| Name | Current Value |
| "PRPSL_SUBMISS to PRPSL_LAB_REQ" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_PLR_TO_PRPSL_SUB |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | PRPSL_SUBMISS |
| Child Table | PRPSL_LAB_REQ |
| 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_LAB_REQ" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "PRPSL_SUBMISS to PRPSL_LAB_REQ" Foreign Keys |
| Parent Key | Child Key |
| PRPSL_ID, SUBMISS_NBR | PRPSL_ID, SUBMISS_NBR |
| "PRPSL_SUBMISS to PRPSL_LAB_REQ" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "PRPSL_SUBMISS to PRPSL_LAB_REQ" Bound Attachments |
| Name | Current Value |
| "PRPSL_LAB_REQ_CHEM_ASSC to PRPSL_LAB_REQ_CHEM_PPE_ASSC" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_PLRCA_TO_LAB_CHEM_PPE_ASSC |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | PRPSL_LAB_REQ_CHEM_ASSC |
| Child Table | PRPSL_LAB_REQ_CHEM_PPE_ASSC |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "PRPSL_LAB_REQ_CHEM_ASSC to PRPSL_LAB_REQ_CHEM_PPE_ASSC" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "PRPSL_LAB_REQ_CHEM_ASSC to PRPSL_LAB_REQ_CHEM_PPE_ASSC" Foreign Keys |
| Parent Key | Child Key |
| PRPSL_ID, SUBMISS_NBR, CHEM_NM | PRPSL_ID, SUBMISS_NBR, CHEM_NM |
| "PRPSL_LAB_REQ_CHEM_ASSC to PRPSL_LAB_REQ_CHEM_PPE_ASSC" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "PRPSL_LAB_REQ_CHEM_ASSC to PRPSL_LAB_REQ_CHEM_PPE_ASSC" Bound Attachments |
| Name | Current Value |
| "PRPSL_SUBMISS to PRPSL_LAB_REQ_CHEM_ASSC" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_PLRCA_TO_PRPSL_SUB |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | PRPSL_SUBMISS |
| Child Table | PRPSL_LAB_REQ_CHEM_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_LAB_REQ_CHEM_ASSC" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "PRPSL_SUBMISS to PRPSL_LAB_REQ_CHEM_ASSC" Foreign Keys |
| Parent Key | Child Key |
| PRPSL_ID, SUBMISS_NBR | PRPSL_ID, SUBMISS_NBR |
| "PRPSL_SUBMISS to PRPSL_LAB_REQ_CHEM_ASSC" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "PRPSL_SUBMISS to PRPSL_LAB_REQ_CHEM_ASSC" Bound Attachments |
| Name | Current Value |
| "EXPT_FACIL to PRPSL_LAB_REQ_FACIL_ASGN" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | fk_plrfa_to_expt_facil |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | EXPT_FACIL |
| Child Table | PRPSL_LAB_REQ_FACIL_ASGN |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "EXPT_FACIL to PRPSL_LAB_REQ_FACIL_ASGN" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "EXPT_FACIL to PRPSL_LAB_REQ_FACIL_ASGN" Foreign Keys |
| Parent Key | Child Key |
| FACIL_ID | FACIL_ID |
| "EXPT_FACIL to PRPSL_LAB_REQ_FACIL_ASGN" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "EXPT_FACIL to PRPSL_LAB_REQ_FACIL_ASGN" Bound Attachments |
| Name | Current Value |
| "PRPSL_LAB_REQ to PRPSL_LAB_REQ_FACIL_ASGN" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_PLRFA_TO_PRPSL_LAB_REQ |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | PRPSL_LAB_REQ |
| Child Table | PRPSL_LAB_REQ_FACIL_ASGN |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "PRPSL_LAB_REQ to PRPSL_LAB_REQ_FACIL_ASGN" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "PRPSL_LAB_REQ to PRPSL_LAB_REQ_FACIL_ASGN" Foreign Keys |
| Parent Key | Child Key |
| PRPSL_ID, SUBMISS_NBR | PRPSL_ID, SUBMISS_NBR |
| "PRPSL_LAB_REQ to PRPSL_LAB_REQ_FACIL_ASGN" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "PRPSL_LAB_REQ to PRPSL_LAB_REQ_FACIL_ASGN" Bound Attachments |
| Name | Current Value |
| "PRPSL_LAB_REQ_CHEM_ASSC to PRPSL_LAB_REQ_HAZ_ASSC" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_PLRHA_TO_PLRCA |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | PRPSL_LAB_REQ_CHEM_ASSC |
| Child Table | PRPSL_LAB_REQ_HAZ_ASSC |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "PRPSL_LAB_REQ_CHEM_ASSC to PRPSL_LAB_REQ_HAZ_ASSC" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "PRPSL_LAB_REQ_CHEM_ASSC to PRPSL_LAB_REQ_HAZ_ASSC" Foreign Keys |
| Parent Key | Child Key |
| PRPSL_ID, SUBMISS_NBR, CHEM_NM | PRPSL_ID, SUBMISS_NBR, CHEM_NM |
| "PRPSL_LAB_REQ_CHEM_ASSC to PRPSL_LAB_REQ_HAZ_ASSC" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "PRPSL_LAB_REQ_CHEM_ASSC to PRPSL_LAB_REQ_HAZ_ASSC" Bound Attachments |
| Name | Current Value |
| "NONVAL_EXPT_TEAM_MBR to PRPSL_LAB_REQ_TM_ASSC" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | FK_PLRTM_TO_NONVAL_EXPT_TM |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | NONVAL_EXPT_TEAM_MBR |
| Child Table | PRPSL_LAB_REQ_TM_ASSC |
| Cardinality | Zero or One to Zero or More |
| Existence | Optional |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "NONVAL_EXPT_TEAM_MBR to PRPSL_LAB_REQ_TM_ASSC" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "NONVAL_EXPT_TEAM_MBR to PRPSL_LAB_REQ_TM_ASSC" Foreign Keys |
| Parent Key | Child Key |
| EMAIL_ADDR | EMAIL_ADDR |
| "NONVAL_EXPT_TEAM_MBR to PRPSL_LAB_REQ_TM_ASSC" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "NONVAL_EXPT_TEAM_MBR to PRPSL_LAB_REQ_TM_ASSC" Bound Attachments |
| Name | Current Value |
| "PRPSL_LAB_REQ to PRPSL_LAB_REQ_TM_ASSC" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_PLRTM_TO_PRPSL_LAB_REQ |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | PRPSL_LAB_REQ |
| Child Table | PRPSL_LAB_REQ_TM_ASSC |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "PRPSL_LAB_REQ to PRPSL_LAB_REQ_TM_ASSC" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "PRPSL_LAB_REQ to PRPSL_LAB_REQ_TM_ASSC" Foreign Keys |
| Parent Key | Child Key |
| PRPSL_ID, SUBMISS_NBR | PRPSL_ID, SUBMISS_NBR |
| "PRPSL_LAB_REQ to PRPSL_LAB_REQ_TM_ASSC" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "PRPSL_LAB_REQ to PRPSL_LAB_REQ_TM_ASSC" Bound Attachments |
| Name | Current Value |
| "VAL_EXPT_TEAM_MBR to PRPSL_LAB_REQ_TM_ASSC" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | FK_PLRTM_TO_VAL_EXPT_TM |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | VAL_EXPT_TEAM_MBR |
| Child Table | PRPSL_LAB_REQ_TM_ASSC |
| Cardinality | Zero or One to Zero or More |
| Existence | Optional |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "VAL_EXPT_TEAM_MBR to PRPSL_LAB_REQ_TM_ASSC" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "VAL_EXPT_TEAM_MBR to PRPSL_LAB_REQ_TM_ASSC" Foreign Keys |
| Parent Key | Child Key |
| PRPSL_ID, SUBMISS_NBR, PERSON_ID | PRPSL_ID, SUBMISS_NBR, PERSON_ID |
| "VAL_EXPT_TEAM_MBR to PRPSL_LAB_REQ_TM_ASSC" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "VAL_EXPT_TEAM_MBR to PRPSL_LAB_REQ_TM_ASSC" Bound Attachments |
| Name | Current Value |
| "PRPSL_LAB_REQ to PRPSL_LAB_REQ_USAGE_ASSC" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_PLRUA_TO_PLR |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | PRPSL_LAB_REQ |
| Child Table | PRPSL_LAB_REQ_USAGE_ASSC |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "PRPSL_LAB_REQ to PRPSL_LAB_REQ_USAGE_ASSC" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "PRPSL_LAB_REQ to PRPSL_LAB_REQ_USAGE_ASSC" Foreign Keys |
| Parent Key | Child Key |
| PRPSL_ID, SUBMISS_NBR | PRPSL_ID, SUBMISS_NBR |
| "PRPSL_LAB_REQ to PRPSL_LAB_REQ_USAGE_ASSC" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "PRPSL_LAB_REQ to PRPSL_LAB_REQ_USAGE_ASSC" Bound Attachments |
| Name | Current Value |
| "PRPSL_LAB_USAGE_TYPE to PRPSL_LAB_REQ_USAGE_ASSC" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_PLRUA_TO_PLUT |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | PRPSL_LAB_USAGE_TYPE |
| Child Table | PRPSL_LAB_REQ_USAGE_ASSC |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "PRPSL_LAB_USAGE_TYPE to PRPSL_LAB_REQ_USAGE_ASSC" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "PRPSL_LAB_USAGE_TYPE to PRPSL_LAB_REQ_USAGE_ASSC" Foreign Keys |
| Parent Key | Child Key |
| USAGE_TYPE_ID | USAGE_TYPE_ID |
| "PRPSL_LAB_USAGE_TYPE to PRPSL_LAB_REQ_USAGE_ASSC" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "PRPSL_LAB_USAGE_TYPE to PRPSL_LAB_REQ_USAGE_ASSC" Bound Attachments |
| Name | Current Value |
| "PRPSL_LAB_SPEC_REQ_TYPE to PRPSL_LAB_SPEC_ASSC" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_PLSA_TO_PRPSL_LAB_SPEC_TYPE |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | PRPSL_LAB_SPEC_REQ_TYPE |
| Child Table | PRPSL_LAB_SPEC_ASSC |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "PRPSL_LAB_SPEC_REQ_TYPE to PRPSL_LAB_SPEC_ASSC" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "PRPSL_LAB_SPEC_REQ_TYPE to PRPSL_LAB_SPEC_ASSC" Foreign Keys |
| Parent Key | Child Key |
| SPEC_REQ_ID | SPEC_REQ_ID |
| "PRPSL_LAB_SPEC_REQ_TYPE to PRPSL_LAB_SPEC_ASSC" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "PRPSL_LAB_SPEC_REQ_TYPE to PRPSL_LAB_SPEC_ASSC" Bound Attachments |
| Name | Current Value |
| "PRPSL_LAB_REQ to PRPSL_LAB_SPEC_ASSC" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_PLSA_TO_PRPSL_REQ |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | PRPSL_LAB_REQ |
| Child Table | PRPSL_LAB_SPEC_ASSC |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "PRPSL_LAB_REQ to PRPSL_LAB_SPEC_ASSC" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "PRPSL_LAB_REQ to PRPSL_LAB_SPEC_ASSC" Foreign Keys |
| Parent Key | Child Key |
| PRPSL_ID, SUBMISS_NBR | PRPSL_ID, SUBMISS_NBR |
| "PRPSL_LAB_REQ to PRPSL_LAB_SPEC_ASSC" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "PRPSL_LAB_REQ to PRPSL_LAB_SPEC_ASSC" Bound Attachments |
| Name | Current Value |
| "PRPSL_LAB_USAGE_LVL to PRPSL_LAB_REQ" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | FK_PLTR_TO_LAB_USAGE_LVL |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | PRPSL_LAB_USAGE_LVL |
| Child Table | PRPSL_LAB_REQ |
| Cardinality | Zero or One to Zero or More |
| Existence | Optional |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "PRPSL_LAB_USAGE_LVL to PRPSL_LAB_REQ" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "PRPSL_LAB_USAGE_LVL to PRPSL_LAB_REQ" Foreign Keys |
| Parent Key | Child Key |
| WORK_LVL_ID | WORK_LVL_ID |
| "PRPSL_LAB_USAGE_LVL to PRPSL_LAB_REQ" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "PRPSL_LAB_USAGE_LVL to PRPSL_LAB_REQ" Bound Attachments |
| Name | Current Value |
| "RSCH_AREA to PERS_RSCH_AREA_ASSC" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_PRAA_TO_RSCH_AREA |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | RSCH_AREA |
| Child Table | PERS_RSCH_AREA_ASSC |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "RSCH_AREA to PERS_RSCH_AREA_ASSC" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "RSCH_AREA to PERS_RSCH_AREA_ASSC" Foreign Keys |
| Parent Key | Child Key |
| RSCH_AREA_ID | RSCH_AREA_ID |
| "RSCH_AREA to PERS_RSCH_AREA_ASSC" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "RSCH_AREA to PERS_RSCH_AREA_ASSC" 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 |
| "PERSON to PRPSL_ROLE_PERS_ASSC" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_PRP_ASSC_TO_PERSON |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | PERSON |
| Child Table | PRPSL_ROLE_PERS_ASSC |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "PERSON to PRPSL_ROLE_PERS_ASSC" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "PERSON to PRPSL_ROLE_PERS_ASSC" Foreign Keys |
| Parent Key | Child Key |
| PERSON_ID | PERSON_ID |
| "PERSON to PRPSL_ROLE_PERS_ASSC" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "PERSON to PRPSL_ROLE_PERS_ASSC" Bound Attachments |
| Name | Current Value |
| "PRPSL_SUBMISS to PRPSL_ATTACH" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_PRPSL_ATTACH_TO_PRPSL_SUB |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | PRPSL_SUBMISS |
| Child Table | PRPSL_ATTACH |
| 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_ATTACH" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "PRPSL_SUBMISS to PRPSL_ATTACH" Foreign Keys |
| Parent Key | Child Key |
| PRPSL_ID, SUBMISS_NBR | PRPSL_ID, SUBMISS_NBR |
| "PRPSL_SUBMISS to PRPSL_ATTACH" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "PRPSL_SUBMISS to PRPSL_ATTACH" Bound Attachments |
| Name | Current Value |
| "PRPSL_ACT to PRPSL_CLAR" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | FK_PRPSL_CLAR_PRPSL_ACT |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | PRPSL_ACT |
| Child Table | PRPSL_CLAR |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "PRPSL_ACT to PRPSL_CLAR" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "PRPSL_ACT to PRPSL_CLAR" Foreign Keys |
| Parent Key | Child Key |
| ACT_ID | ACT_ID |
| "PRPSL_ACT to PRPSL_CLAR" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "PRPSL_ACT to PRPSL_CLAR" Bound Attachments |
| Name | Current Value |
| "PERSON to PRPSL_CLAR" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_PRPSL_CLAR_TO_PERSON |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | PERSON |
| Child Table | PRPSL_CLAR |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "PERSON to PRPSL_CLAR" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "PERSON to PRPSL_CLAR" Foreign Keys |
| Parent Key | Child Key |
| PERSON_ID | PERSON_ID |
| "PERSON to PRPSL_CLAR" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "PERSON to PRPSL_CLAR" Bound Attachments |
| Name | Current Value |
| "PRPSL_INSTR to PRPSL_CLAR" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_PRPSL_CLAR_TO_PRPSL_INSTR |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | PRPSL_INSTR |
| Child Table | PRPSL_CLAR |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "PRPSL_INSTR to PRPSL_CLAR" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "PRPSL_INSTR to PRPSL_CLAR" Foreign Keys |
| Parent Key | Child Key |
| PRPSL_ID, SUBMISS_NBR, INSTR_ID | PRPSL_ID, SUBMISS_NBR, INSTR_ID |
| "PRPSL_INSTR to PRPSL_CLAR" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "PRPSL_INSTR to PRPSL_CLAR" Bound Attachments |
| Name | Current Value |
| "PRPSL_SUBMISS to PRPSL_CLAR" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_PRPSL_CLAR_TO_PRPSL_SUB |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | PRPSL_SUBMISS |
| Child Table | PRPSL_CLAR |
| 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_CLAR" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "PRPSL_SUBMISS to PRPSL_CLAR" Foreign Keys |
| Parent Key | Child Key |
| PRPSL_ID, SUBMISS_NBR | PRPSL_ID, SUBMISS_NBR |
| "PRPSL_SUBMISS to PRPSL_CLAR" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "PRPSL_SUBMISS to PRPSL_CLAR" Bound Attachments |
| Name | Current Value |
| "SCI_REVIEW_STAT to PRPSL_FACIL" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | FK_PRPSL_FACIL_SCI_RV_STAT |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | SCI_REVIEW_STAT |
| Child Table | PRPSL_FACIL |
| Cardinality | Zero or One to Zero or More |
| Existence | Optional |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "SCI_REVIEW_STAT to PRPSL_FACIL" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "SCI_REVIEW_STAT to PRPSL_FACIL" Foreign Keys |
| Parent Key | Child Key |
| SCI_REVIEW_STAT_ID | SCI_REVIEW_STAT_ID |
| "SCI_REVIEW_STAT to PRPSL_FACIL" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "SCI_REVIEW_STAT to PRPSL_FACIL" Bound Attachments |
| Name | Current Value |
| "SFTY_REVIEW_STAT to PRPSL_FACIL" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | FK_PRPSL_FACIL_SFTY_RV_STAT |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | SFTY_REVIEW_STAT |
| Child Table | PRPSL_FACIL |
| Cardinality | Zero or One to Zero or More |
| Existence | Optional |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "SFTY_REVIEW_STAT to PRPSL_FACIL" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "SFTY_REVIEW_STAT to PRPSL_FACIL" Foreign Keys |
| Parent Key | Child Key |
| SFTY_REVIEW_STAT_ID | SFTY_REVIEW_STAT_ID |
| "SFTY_REVIEW_STAT to PRPSL_FACIL" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "SFTY_REVIEW_STAT to PRPSL_FACIL" Bound Attachments |
| Name | Current Value |
| "EXPT_FACIL to PRPSL_FACIL" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_PRPSL_FACIL_TO_EXPT_FACIL |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | EXPT_FACIL |
| Child Table | PRPSL_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 PRPSL_FACIL" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "EXPT_FACIL to PRPSL_FACIL" Foreign Keys |
| Parent Key | Child Key |
| FACIL_ID | FACIL_ID |
| "EXPT_FACIL to PRPSL_FACIL" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "EXPT_FACIL to PRPSL_FACIL" Bound Attachments |
| Name | Current Value |
| "PRPSL_SUBMISS to PRPSL_FACIL" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_PRPSL_FACIL_TO_PRPSL_SUB |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | PRPSL_SUBMISS |
| Child Table | PRPSL_FACIL |
| 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_FACIL" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "PRPSL_SUBMISS to PRPSL_FACIL" Foreign Keys |
| Parent Key | Child Key |
| PRPSL_ID, SUBMISS_NBR | PRPSL_ID, SUBMISS_NBR |
| "PRPSL_SUBMISS to PRPSL_FACIL" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "PRPSL_SUBMISS to PRPSL_FACIL" Bound Attachments |
| Name | Current Value |
| "PROPOSAL to PRPSL_FUND" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_PRPSL_FUND_PRPSL |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | PROPOSAL |
| Child Table | PRPSL_FUND |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "PROPOSAL to PRPSL_FUND" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "PROPOSAL to PRPSL_FUND" Foreign Keys |
| Parent Key | Child Key |
| PRPSL_ID | PRPSL_ID |
| "PROPOSAL to PRPSL_FUND" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "PROPOSAL to PRPSL_FUND" 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_INSTR_STAT to PRPSL_INSTR" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | FK_PRPSL_INSTR_TO_PI_STAT |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | PRPSL_INSTR_STAT |
| 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_INSTR_STAT to PRPSL_INSTR" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "PRPSL_INSTR_STAT to PRPSL_INSTR" Foreign Keys |
| Parent Key | Child Key |
| STAT_ID | STAT_ID |
| "PRPSL_INSTR_STAT to PRPSL_INSTR" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "PRPSL_INSTR_STAT 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 |
| "PRPSL_ACT to PRPSL_LOG" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_PRPSL_LOG_PRPSL_ACT |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | PRPSL_ACT |
| Child Table | PRPSL_LOG |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "PRPSL_ACT to PRPSL_LOG" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "PRPSL_ACT to PRPSL_LOG" Foreign Keys |
| Parent Key | Child Key |
| ACT_ID | ACT_ID |
| "PRPSL_ACT to PRPSL_LOG" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "PRPSL_ACT to PRPSL_LOG" Bound Attachments |
| Name | Current Value |
| "PRPSL_SUBMISS to PRPSL_LOG" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_PRPSL_LOG_TO_PRPSL_SUB |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | PRPSL_SUBMISS |
| Child Table | PRPSL_LOG |
| 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" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "PRPSL_SUBMISS to PRPSL_LOG" Foreign Keys |
| Parent Key | Child Key |
| PRPSL_ID, SUBMISS_NBR | PRPSL_ID, SUBMISS_NBR |
| "PRPSL_SUBMISS to PRPSL_LOG" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "PRPSL_SUBMISS to PRPSL_LOG" Bound Attachments |
| Name | Current Value |
| "PRPSL_SUBMISS to PRPSL_PDF" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_PRPSL_PDF_TO_PRPSL_SUB |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | PRPSL_SUBMISS |
| Child Table | PRPSL_PDF |
| 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_PDF" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "PRPSL_SUBMISS to PRPSL_PDF" Foreign Keys |
| Parent Key | Child Key |
| PRPSL_ID, SUBMISS_NBR | PRPSL_ID, SUBMISS_NBR |
| "PRPSL_SUBMISS to PRPSL_PDF" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "PRPSL_SUBMISS to PRPSL_PDF" Bound Attachments |
| Name | Current Value |
| "PROPOSAL to PRPSL_BES_RSCH_AREA" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_PRPSL_PRPSL__TO_BES_RSCH_AREA |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | PROPOSAL |
| Child Table | PRPSL_BES_RSCH_AREA |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "PROPOSAL to PRPSL_BES_RSCH_AREA" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "PROPOSAL to PRPSL_BES_RSCH_AREA" Foreign Keys |
| Parent Key | Child Key |
| PRPSL_ID | PRPSL_ID |
| "PROPOSAL to PRPSL_BES_RSCH_AREA" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "PROPOSAL to PRPSL_BES_RSCH_AREA" Bound Attachments |
| Name | Current Value |
| "PRPSL_STAT to PROPOSAL" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | FK_PRPSL_PRPSL_STAT |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | PRPSL_STAT |
| 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_STAT to PROPOSAL" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "PRPSL_STAT to PROPOSAL" Foreign Keys |
| Parent Key | Child Key |
| STAT_ID | STAT_ID |
| "PRPSL_STAT to PROPOSAL" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "PRPSL_STAT to PROPOSAL" Bound Attachments |
| Name | Current Value |
| "PROPOSAL to PRPSL_SUBJ_AREA" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_PRPSL_PRPSL_SUBJ_AREA |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | PROPOSAL |
| Child Table | PRPSL_SUBJ_AREA |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "PROPOSAL to PRPSL_SUBJ_AREA" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "PROPOSAL to PRPSL_SUBJ_AREA" Foreign Keys |
| Parent Key | Child Key |
| PRPSL_ID | PRPSL_ID |
| "PROPOSAL to PRPSL_SUBJ_AREA" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "PROPOSAL to PRPSL_SUBJ_AREA" Bound Attachments |
| Name | Current Value |
| "WORKFLOW to PRPSL_REV_WRKFLW" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_PRPSL_REV_WRKFLW_TO_WRKFLW |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | WORKFLOW |
| Child Table | PRPSL_REV_WRKFLW |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "WORKFLOW to PRPSL_REV_WRKFLW" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "WORKFLOW to PRPSL_REV_WRKFLW" Foreign Keys |
| Parent Key | Child Key |
| WORKFLOW_ID | WORKFLOW_ID |
| "WORKFLOW to PRPSL_REV_WRKFLW" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "WORKFLOW to PRPSL_REV_WRKFLW" Bound Attachments |
| Name | Current Value |
| "PRPSL_ROLE to PRPSL_ROLE_PERS_ASSC" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_PRPSL_ROLE_PRP_ASSC |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | PRPSL_ROLE |
| Child Table | PRPSL_ROLE_PERS_ASSC |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "PRPSL_ROLE to PRPSL_ROLE_PERS_ASSC" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "PRPSL_ROLE to PRPSL_ROLE_PERS_ASSC" Foreign Keys |
| Parent Key | Child Key |
| ROLE_ID | ROLE_ID |
| "PRPSL_ROLE to PRPSL_ROLE_PERS_ASSC" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "PRPSL_ROLE to PRPSL_ROLE_PERS_ASSC" Bound Attachments |
| Name | Current Value |
| "RSCH_AREA to PRPSL_RSCH_AREA" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_PRPSL_RSCH_AREA_TO_RA |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | RSCH_AREA |
| Child Table | PRPSL_RSCH_AREA |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "RSCH_AREA to PRPSL_RSCH_AREA" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "RSCH_AREA to PRPSL_RSCH_AREA" Foreign Keys |
| Parent Key | Child Key |
| RSCH_AREA_ID | RSCH_AREA_ID |
| "RSCH_AREA to PRPSL_RSCH_AREA" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "RSCH_AREA to PRPSL_RSCH_AREA" Bound Attachments |
| Name | Current Value |
| "PERSON to PRPSL_SCI_REVIEW" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | fk_prpsl_sci_rev_to_person_id |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | PERSON |
| Child Table | PRPSL_SCI_REVIEW |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "PERSON to PRPSL_SCI_REVIEW" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "PERSON to PRPSL_SCI_REVIEW" Foreign Keys |
| Parent Key | Child Key |
| PERSON_ID | PERSON_ID |
| "PERSON to PRPSL_SCI_REVIEW" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "PERSON to PRPSL_SCI_REVIEW" Bound Attachments |
| Name | Current Value |
| "SCI_REVIEW_MERIT to PRPSL_SCI_REVIEW" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | FK_PRPSL_SCI_RV_SCI_RV_MERIT |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | SCI_REVIEW_MERIT |
| Child Table | PRPSL_SCI_REVIEW |
| Cardinality | Zero or One to Zero or More |
| Existence | Optional |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "SCI_REVIEW_MERIT to PRPSL_SCI_REVIEW" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "SCI_REVIEW_MERIT to PRPSL_SCI_REVIEW" Foreign Keys |
| Parent Key | Child Key |
| RATING_ID | RATING_ID |
| "SCI_REVIEW_MERIT to PRPSL_SCI_REVIEW" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "SCI_REVIEW_MERIT to PRPSL_SCI_REVIEW" Bound Attachments |
| Name | Current Value |
| "PERSON to PRPSL_SRC_REVIEW" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | fk_prpsl_src_rev_to_person |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | PERSON |
| Child Table | PRPSL_SRC_REVIEW |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "PERSON to PRPSL_SRC_REVIEW" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "PERSON to PRPSL_SRC_REVIEW" Foreign Keys |
| Parent Key | Child Key |
| PERSON_ID | PERSON_ID |
| "PERSON to PRPSL_SRC_REVIEW" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "PERSON to PRPSL_SRC_REVIEW" 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 |
| "PRPSL_REVIEW_STAT to PRPSL_SUBMISS" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | FK_PRPSL_SUB_TO_REV_STAT |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | PRPSL_REVIEW_STAT |
| Child Table | PRPSL_SUBMISS |
| Cardinality | Zero or One to Zero or More |
| Existence | Optional |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "PRPSL_REVIEW_STAT to PRPSL_SUBMISS" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "PRPSL_REVIEW_STAT to PRPSL_SUBMISS" Foreign Keys |
| Parent Key | Child Key |
| REVIEW_STAT_ID | PRPSL_REVIEW_STAT |
| "PRPSL_REVIEW_STAT to PRPSL_SUBMISS" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "PRPSL_REVIEW_STAT to PRPSL_SUBMISS" Bound Attachments |
| Name | Current Value |
| "PRPSL_SUBMISS_STAT to PRPSL_SUBMISS" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | fk_prpsl_submiss_to_sub_stat |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | PRPSL_SUBMISS_STAT |
| 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 |
| "PRPSL_SUBMISS_STAT to PRPSL_SUBMISS" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "PRPSL_SUBMISS_STAT to PRPSL_SUBMISS" Foreign Keys |
| Parent Key | Child Key |
| STAT_ID | STAT_ID |
| "PRPSL_SUBMISS_STAT to PRPSL_SUBMISS" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "PRPSL_SUBMISS_STAT 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 |
| "PROPOSAL to PRPSL_RSCH_AREA" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_PRPSL_TO_PRPSL_RSCH_AREA |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | PROPOSAL |
| Child Table | PRPSL_RSCH_AREA |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "PROPOSAL to PRPSL_RSCH_AREA" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "PROPOSAL to PRPSL_RSCH_AREA" Foreign Keys |
| Parent Key | Child Key |
| PRPSL_ID | PRPSL_ID |
| "PROPOSAL to PRPSL_RSCH_AREA" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "PROPOSAL to PRPSL_RSCH_AREA" Bound Attachments |
| Name | Current Value |
| "PRPSL_TYPE to PRPSL_REV_WRKFLW" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | fk_prpsl_wrkflw_to_prpsl_type |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | PRPSL_TYPE |
| Child Table | PRPSL_REV_WRKFLW |
| 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_REV_WRKFLW" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "PRPSL_TYPE to PRPSL_REV_WRKFLW" Foreign Keys |
| Parent Key | Child Key |
| PRPSL_TYPE_ID | PRPSL_TYPE_ID |
| "PRPSL_TYPE to PRPSL_REV_WRKFLW" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "PRPSL_TYPE to PRPSL_REV_WRKFLW" Bound Attachments |
| Name | Current Value |
| "PRPSL_CONT_JUST to PRPSL_SUBMISS" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | FK_PS_TO_PRPSL_CONT_JUST |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | PRPSL_CONT_JUST |
| Child Table | PRPSL_SUBMISS |
| Cardinality | Zero or One to Zero or More |
| Existence | Optional |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "PRPSL_CONT_JUST to PRPSL_SUBMISS" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "PRPSL_CONT_JUST to PRPSL_SUBMISS" Foreign Keys |
| Parent Key | Child Key |
| CONT_JUST_ID | CONT_JUST_ID |
| "PRPSL_CONT_JUST to PRPSL_SUBMISS" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "PRPSL_CONT_JUST to PRPSL_SUBMISS" Bound Attachments |
| Name | Current Value |
| "PRPSL_INSTR to PRPSL_SCI_REVIEW" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_PSR_TO_PRPSL_INSTR |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | PRPSL_INSTR |
| Child Table | PRPSL_SCI_REVIEW |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "PRPSL_INSTR to PRPSL_SCI_REVIEW" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "PRPSL_INSTR to PRPSL_SCI_REVIEW" Foreign Keys |
| Parent Key | Child Key |
| PRPSL_ID, SUBMISS_NBR, INSTR_ID | PRPSL_ID, SUBMISS_NBR, INSTR_ID |
| "PRPSL_INSTR to PRPSL_SCI_REVIEW" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "PRPSL_INSTR to PRPSL_SCI_REVIEW" Bound Attachments |
| Name | Current Value |
| "PRPSL_INSTR to PRPSL_SRC_REVIEW" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_PSRCR_TO_PRPSL_INSTR |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | PRPSL_INSTR |
| Child Table | PRPSL_SRC_REVIEW |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "PRPSL_INSTR to PRPSL_SRC_REVIEW" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "PRPSL_INSTR to PRPSL_SRC_REVIEW" Foreign Keys |
| Parent Key | Child Key |
| PRPSL_ID, SUBMISS_NBR, INSTR_ID | PRPSL_ID, SUBMISS_NBR, INSTR_ID |
| "PRPSL_INSTR to PRPSL_SRC_REVIEW" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "PRPSL_INSTR to PRPSL_SRC_REVIEW" Bound Attachments |
| Name | Current Value |
| "INSTR to PRPSL_TYPE_INSTR_ASSC" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | fk_ptia_to_instr |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | INSTR |
| Child Table | PRPSL_TYPE_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 PRPSL_TYPE_INSTR_ASSC" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "INSTR to PRPSL_TYPE_INSTR_ASSC" Foreign Keys |
| Parent Key | Child Key |
| INSTR_ID | INSTR_ID |
| "INSTR to PRPSL_TYPE_INSTR_ASSC" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "INSTR to PRPSL_TYPE_INSTR_ASSC" Bound Attachments |
| Name | Current Value |
| "PRPSL_TYPE to PRPSL_TYPE_INSTR_ASSC" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_PTIA_TO_PRPSL_TYPE |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | PRPSL_TYPE |
| Child Table | PRPSL_TYPE_INSTR_ASSC |
| 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_INSTR_ASSC" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "PRPSL_TYPE to PRPSL_TYPE_INSTR_ASSC" Foreign Keys |
| Parent Key | Child Key |
| PRPSL_TYPE_ID | PRPSL_TYPE_ID |
| "PRPSL_TYPE to PRPSL_TYPE_INSTR_ASSC" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "PRPSL_TYPE to PRPSL_TYPE_INSTR_ASSC" Bound Attachments |
| Name | Current Value |
| "PERSON to PRPSL_TM_ONSITE_ACC" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_PTMOA_TO_PERSON |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | PERSON |
| Child Table | PRPSL_TM_ONSITE_ACC |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "PERSON to PRPSL_TM_ONSITE_ACC" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "PERSON to PRPSL_TM_ONSITE_ACC" Foreign Keys |
| Parent Key | Child Key |
| PERSON_ID | PERSON_ID |
| "PERSON to PRPSL_TM_ONSITE_ACC" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "PERSON to PRPSL_TM_ONSITE_ACC" Bound Attachments |
| Name | Current Value |
| "PERSON to PRPSL_TM_ONSITE_EXPT_SCH_ASSC" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_PTMOESA_TO_PERSON |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | PERSON |
| Child Table | PRPSL_TM_ONSITE_EXPT_SCH_ASSC |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "PERSON to PRPSL_TM_ONSITE_EXPT_SCH_ASSC" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "PERSON to PRPSL_TM_ONSITE_EXPT_SCH_ASSC" Foreign Keys |
| Parent Key | Child Key |
| PERSON_ID | PERSON_ID |
| "PERSON to PRPSL_TM_ONSITE_EXPT_SCH_ASSC" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "PERSON to PRPSL_TM_ONSITE_EXPT_SCH_ASSC" Bound Attachments |
| Name | Current Value |
| "PRPSL_TM_ONSITE_ACC to PRPSL_TM_ONSITE_EXPT_SCH_ASSC" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_PTMOESA_TO_PTMOA |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | PRPSL_TM_ONSITE_ACC |
| Child Table | PRPSL_TM_ONSITE_EXPT_SCH_ASSC |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "PRPSL_TM_ONSITE_ACC to PRPSL_TM_ONSITE_EXPT_SCH_ASSC" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "PRPSL_TM_ONSITE_ACC to PRPSL_TM_ONSITE_EXPT_SCH_ASSC" Foreign Keys |
| Parent Key | Child Key |
| PERSON_ID | PERSON_ID |
| "PRPSL_TM_ONSITE_ACC to PRPSL_TM_ONSITE_EXPT_SCH_ASSC" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "PRPSL_TM_ONSITE_ACC to PRPSL_TM_ONSITE_EXPT_SCH_ASSC" Bound Attachments |
| Name | Current Value |
| "PRPSL_REVIEW to PRPSL_TYPE_PRPSL_REV_ASSC" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_PTPRA_TO_PRPSL_REV |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | PRPSL_REVIEW |
| Child Table | PRPSL_TYPE_PRPSL_REV_ASSC |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "PRPSL_REVIEW to PRPSL_TYPE_PRPSL_REV_ASSC" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "PRPSL_REVIEW to PRPSL_TYPE_PRPSL_REV_ASSC" Foreign Keys |
| Parent Key | Child Key |
| REVIEW_ID | REVIEW_ID |
| "PRPSL_REVIEW to PRPSL_TYPE_PRPSL_REV_ASSC" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "PRPSL_REVIEW to PRPSL_TYPE_PRPSL_REV_ASSC" Bound Attachments |
| Name | Current Value |
| "PRPSL_TYPE to PRPSL_TYPE_PRPSL_REV_ASSC" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_PTPRA_TO_PRPSL_TYPE |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | PRPSL_TYPE |
| Child Table | PRPSL_TYPE_PRPSL_REV_ASSC |
| 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_PRPSL_REV_ASSC" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "PRPSL_TYPE to PRPSL_TYPE_PRPSL_REV_ASSC" Foreign Keys |
| Parent Key | Child Key |
| PRPSL_TYPE_ID | PRPSL_TYPE_ID |
| "PRPSL_TYPE to PRPSL_TYPE_PRPSL_REV_ASSC" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "PRPSL_TYPE to PRPSL_TYPE_PRPSL_REV_ASSC" Bound Attachments |
| Name | Current Value |
| "PROPOSAL to PUBL" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_PUBL_TO_PRPSL |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | PROPOSAL |
| Child Table | PUBL |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "PROPOSAL to PUBL" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "PROPOSAL to PUBL" Foreign Keys |
| Parent Key | Child Key |
| PRPSL_ID | PRPSL_ID |
| "PROPOSAL to PUBL" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "PROPOSAL to PUBL" Bound Attachments |
| Name | Current Value |
| "BES_RSCH_AREA to RSCH_AREA_BES_RSCH_AREA_ASSC" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_RABRAA_TO_BES_RSCH_AREA |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | BES_RSCH_AREA |
| Child Table | RSCH_AREA_BES_RSCH_AREA_ASSC |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "BES_RSCH_AREA to RSCH_AREA_BES_RSCH_AREA_ASSC" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "BES_RSCH_AREA to RSCH_AREA_BES_RSCH_AREA_ASSC" Foreign Keys |
| Parent Key | Child Key |
| RSCH_AREA_ID | BES_RSCH_AREA_ID |
| "BES_RSCH_AREA to RSCH_AREA_BES_RSCH_AREA_ASSC" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "BES_RSCH_AREA to RSCH_AREA_BES_RSCH_AREA_ASSC" Bound Attachments |
| Name | Current Value |
| "RSCH_AREA to RSCH_AREA_BES_RSCH_AREA_ASSC" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_RABRAA_TO_RSCH_AREA |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | RSCH_AREA |
| Child Table | RSCH_AREA_BES_RSCH_AREA_ASSC |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "RSCH_AREA to RSCH_AREA_BES_RSCH_AREA_ASSC" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "RSCH_AREA to RSCH_AREA_BES_RSCH_AREA_ASSC" Foreign Keys |
| Parent Key | Child Key |
| RSCH_AREA_ID | RSCH_AREA_ID |
| "RSCH_AREA to RSCH_AREA_BES_RSCH_AREA_ASSC" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "RSCH_AREA to RSCH_AREA_BES_RSCH_AREA_ASSC" Bound Attachments |
| Name | Current Value |
| "INSTR to RSCH_AREA_INSTR_ASSC" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_RAIA_TO_INSTR |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | INSTR |
| Child Table | RSCH_AREA_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 RSCH_AREA_INSTR_ASSC" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "INSTR to RSCH_AREA_INSTR_ASSC" Foreign Keys |
| Parent Key | Child Key |
| INSTR_ID | INSTR_ID |
| "INSTR to RSCH_AREA_INSTR_ASSC" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "INSTR to RSCH_AREA_INSTR_ASSC" Bound Attachments |
| Name | Current Value |
| "RSCH_AREA to RSCH_AREA_INSTR_ASSC" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_RAIA_TO_RSCH_AREA |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | RSCH_AREA |
| Child Table | RSCH_AREA_INSTR_ASSC |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "RSCH_AREA to RSCH_AREA_INSTR_ASSC" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "RSCH_AREA to RSCH_AREA_INSTR_ASSC" Foreign Keys |
| Parent Key | Child Key |
| RSCH_AREA_ID | RSCH_AREA_ID |
| "RSCH_AREA to RSCH_AREA_INSTR_ASSC" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "RSCH_AREA to RSCH_AREA_INSTR_ASSC" Bound Attachments |
| Name | Current Value |
| "INSTR to RUN_CYCLE_INSTR_REQ" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_RCIR_TO_INSTR |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | INSTR |
| Child Table | RUN_CYCLE_INSTR_REQ |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "INSTR to RUN_CYCLE_INSTR_REQ" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "INSTR to RUN_CYCLE_INSTR_REQ" Foreign Keys |
| Parent Key | Child Key |
| INSTR_ID | INSTR_ID |
| "INSTR to RUN_CYCLE_INSTR_REQ" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "INSTR to RUN_CYCLE_INSTR_REQ" Bound Attachments |
| Name | Current Value |
| "RUN_CYCLE to RUN_CYCLE_INSTR_REQ" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_RCIR_TO_RUN_CYCLE |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | RUN_CYCLE |
| Child Table | RUN_CYCLE_INSTR_REQ |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "RUN_CYCLE to RUN_CYCLE_INSTR_REQ" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "RUN_CYCLE to RUN_CYCLE_INSTR_REQ" Foreign Keys |
| Parent Key | Child Key |
| FACIL_ID, RUN_CYCLE_ID | FACIL_ID, RUN_CYCLE_ID |
| "RUN_CYCLE to RUN_CYCLE_INSTR_REQ" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "RUN_CYCLE to RUN_CYCLE_INSTR_REQ" Bound Attachments |
| Name | Current Value |
| "USER_PROFILE to PUBL" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_RECENT_PUB_TO_USER_PROFILE |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | USER_PROFILE |
| Child Table | PUBL |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "USER_PROFILE to PUBL" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "USER_PROFILE to PUBL" Foreign Keys |
| Parent Key | Child Key |
| PERSON_ID | PERSON_ID |
| "USER_PROFILE to PUBL" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "USER_PROFILE to PUBL" Bound Attachments |
| Name | Current Value |
| "PROPOSAL to REL_PRPSL" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_REL_PRPSL_RPI_TO_PRPSL |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | PROPOSAL |
| Child Table | REL_PRPSL |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "PROPOSAL to REL_PRPSL" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "PROPOSAL to REL_PRPSL" Foreign Keys |
| Parent Key | Child Key |
| PRPSL_ID | REL_PRPSL_ID |
| "PROPOSAL to REL_PRPSL" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "PROPOSAL to REL_PRPSL" Bound Attachments |
| Name | Current Value |
| "PROPOSAL to REL_PRPSL" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_REL_PRPSL_TO_PRPSL |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | PROPOSAL |
| Child Table | REL_PRPSL |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "PROPOSAL to REL_PRPSL" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "PROPOSAL to REL_PRPSL" Foreign Keys |
| Parent Key | Child Key |
| PRPSL_ID | PRPSL_ID |
| "PROPOSAL to REL_PRPSL" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "PROPOSAL to REL_PRPSL" Bound Attachments |
| Name | Current Value |
| "REV_SUBCOMM to REV_SUBCOMM" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | fk_rev_subcomm_to_rev_subcomm |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | REV_SUBCOMM |
| Child Table | REV_SUBCOMM |
| Cardinality | Zero or One to Zero or More |
| Existence | Optional |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "REV_SUBCOMM to REV_SUBCOMM" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "REV_SUBCOMM to REV_SUBCOMM" Foreign Keys |
| Parent Key | Child Key |
| SUBCOMM_ID | PARENT_SUBCOMMID |
| "REV_SUBCOMM to REV_SUBCOMM" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "REV_SUBCOMM to REV_SUBCOMM" Bound Attachments |
| Name | Current Value |
| "PRPSL_INSTR to REV_SUBCOMM_PRPSL_ASSC" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_RSPA_TO_PRPSL_INSTR |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | PRPSL_INSTR |
| Child Table | REV_SUBCOMM_PRPSL_ASSC |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "PRPSL_INSTR to REV_SUBCOMM_PRPSL_ASSC" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "PRPSL_INSTR to REV_SUBCOMM_PRPSL_ASSC" Foreign Keys |
| Parent Key | Child Key |
| PRPSL_ID, SUBMISS_NBR, INSTR_ID | PRPSL_ID, SUBMISS_NBR, INSTR_ID |
| "PRPSL_INSTR to REV_SUBCOMM_PRPSL_ASSC" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "PRPSL_INSTR to REV_SUBCOMM_PRPSL_ASSC" Bound Attachments |
| Name | Current Value |
| "REV_SUBCOMM to REV_SUBCOMM_PRPSL_ASSC" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_RSPA_TO_REV_SUBCOMM |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | REV_SUBCOMM |
| Child Table | REV_SUBCOMM_PRPSL_ASSC |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "REV_SUBCOMM to REV_SUBCOMM_PRPSL_ASSC" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "REV_SUBCOMM to REV_SUBCOMM_PRPSL_ASSC" Foreign Keys |
| Parent Key | Child Key |
| SUBCOMM_ID | SUBCOMM_ID |
| "REV_SUBCOMM to REV_SUBCOMM_PRPSL_ASSC" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "REV_SUBCOMM to REV_SUBCOMM_PRPSL_ASSC" Bound Attachments |
| Name | Current Value |
| "PROPOSAL to RUN_CYCLE_INSTR_REQ" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_RUN_CYC_INSTR_REQ_TO_PRPSL |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | PROPOSAL |
| Child Table | RUN_CYCLE_INSTR_REQ |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "PROPOSAL to RUN_CYCLE_INSTR_REQ" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "PROPOSAL to RUN_CYCLE_INSTR_REQ" Foreign Keys |
| Parent Key | Child Key |
| PRPSL_ID | PRPSL_ID |
| "PROPOSAL to RUN_CYCLE_INSTR_REQ" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "PROPOSAL to RUN_CYCLE_INSTR_REQ" Bound Attachments |
| Name | Current Value |
| "EXPT_FACIL to RUN_CYCLE" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | fk_run_cycle_expt_facil |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | EXPT_FACIL |
| Child Table | RUN_CYCLE |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "EXPT_FACIL to RUN_CYCLE" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "EXPT_FACIL to RUN_CYCLE" Foreign Keys |
| Parent Key | Child Key |
| FACIL_ID | FACIL_ID |
| "EXPT_FACIL to RUN_CYCLE" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "EXPT_FACIL to RUN_CYCLE" Bound Attachments |
| Name | Current Value |
| "EXPT_SMPL to EXPT_SMPL_SMPL_COND_ASSC" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_SMPL_COND_ASSC_TO_EXPT_SMPL |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | EXPT_SMPL |
| Child Table | EXPT_SMPL_SMPL_COND_ASSC |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "EXPT_SMPL to EXPT_SMPL_SMPL_COND_ASSC" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "EXPT_SMPL to EXPT_SMPL_SMPL_COND_ASSC" Foreign Keys |
| Parent Key | Child Key |
| PRPSL_ID, SUBMISS_NBR, SMPL_ID | PRPSL_ID, SUBMISS_NBR, SMPL_ID |
| "EXPT_SMPL to EXPT_SMPL_SMPL_COND_ASSC" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "EXPT_SMPL to EXPT_SMPL_SMPL_COND_ASSC" Bound Attachments |
| Name | Current Value |
| "SUBJ_AREA to PRPSL_SUBJ_AREA" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_SUBJ_AREA_PRPSL_RA |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | SUBJ_AREA |
| Child Table | PRPSL_SUBJ_AREA |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "SUBJ_AREA to PRPSL_SUBJ_AREA" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "SUBJ_AREA to PRPSL_SUBJ_AREA" Foreign Keys |
| Parent Key | Child Key |
| SUBJ_AREA_ID | SUBJ_AREA_ID |
| "SUBJ_AREA to PRPSL_SUBJ_AREA" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "SUBJ_AREA to PRPSL_SUBJ_AREA" Bound Attachments |
| Name | Current Value |
| "PRPSL_SUBMISS to UNAVAIL_DTE" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_UNAVAIL_DTE_TO_PRPSL_SUB |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | PRPSL_SUBMISS |
| Child Table | UNAVAIL_DTE |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "PRPSL_SUBMISS to UNAVAIL_DTE" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "PRPSL_SUBMISS to UNAVAIL_DTE" Foreign Keys |
| Parent Key | Child Key |
| PRPSL_ID, SUBMISS_NBR | PRPSL_ID, SUBMISS_NBR |
| "PRPSL_SUBMISS to UNAVAIL_DTE" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "PRPSL_SUBMISS to UNAVAIL_DTE" Bound Attachments |
| Name | Current Value |
| "PERSON to USER_PROFILE" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_USER_PROFILE_TO_PERSON |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | PERSON |
| Child Table | USER_PROFILE |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "PERSON to USER_PROFILE" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "PERSON to USER_PROFILE" Foreign Keys |
| Parent Key | Child Key |
| PERSON_ID | PERSON_ID |
| "PERSON to USER_PROFILE" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "PERSON to USER_PROFILE" Bound Attachments |
| Name | Current Value |
| "MBR_ROLE to VAL_EXPT_TEAM_MBR" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | FK_VAL_EXPT_TEAM_MBR_MBR_ROLE |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | MBR_ROLE |
| Child Table | VAL_EXPT_TEAM_MBR |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "MBR_ROLE to VAL_EXPT_TEAM_MBR" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "MBR_ROLE to VAL_EXPT_TEAM_MBR" Foreign Keys |
| Parent Key | Child Key |
| MBR_ROLE_ID | MBR_ROLE_ID |
| "MBR_ROLE to VAL_EXPT_TEAM_MBR" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "MBR_ROLE to VAL_EXPT_TEAM_MBR" Bound Attachments |
| Name | Current Value |
| "PRPSL_SUBMISS to VAL_EXPT_TEAM_MBR" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_VAL_EXPT_TM_TO_PRPSL_SUB |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | PRPSL_SUBMISS |
| Child Table | VAL_EXPT_TEAM_MBR |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "PRPSL_SUBMISS to VAL_EXPT_TEAM_MBR" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "PRPSL_SUBMISS to VAL_EXPT_TEAM_MBR" Foreign Keys |
| Parent Key | Child Key |
| PRPSL_ID, SUBMISS_NBR | PRPSL_ID, SUBMISS_NBR |
| "PRPSL_SUBMISS to VAL_EXPT_TEAM_MBR" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "PRPSL_SUBMISS to VAL_EXPT_TEAM_MBR" Bound Attachments |
| Name | Current Value |
| "PERSON to VAL_EXPT_TEAM_MBR" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_VETM_TO_PERSON |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | PERSON |
| Child Table | VAL_EXPT_TEAM_MBR |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "PERSON to VAL_EXPT_TEAM_MBR" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "PERSON to VAL_EXPT_TEAM_MBR" Foreign Keys |
| Parent Key | Child Key |
| PERSON_ID | PERSON_ID |
| "PERSON to VAL_EXPT_TEAM_MBR" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "PERSON to VAL_EXPT_TEAM_MBR" Bound Attachments |
| Name | Current Value |