"INSTR_GRP to INSTR" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | |
Relationship Business Name | |
Physical Only | No |
Parent Table | INSTR_GRP |
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 |
"INSTR_GRP to INSTR" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"INSTR_GRP to INSTR" Foreign Keys |
Parent Key | Child Key |
GRP_ID | GRP_ID |
"INSTR_GRP to INSTR" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"INSTR_GRP to INSTR" Bound Attachments |
Name | Current Value |
"INSTR to INSTR_CONT" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | |
Relationship Business Name | |
Physical Only | No |
Parent Table | INSTR |
Child Table | INSTR_CONT |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"INSTR to INSTR_CONT" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"INSTR to INSTR_CONT" Foreign Keys |
Parent Key | Child Key |
INSTR_ID | INSTR_ID |
"INSTR to INSTR_CONT" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"INSTR to INSTR_CONT" Bound Attachments |
Name | Current Value |
"INST to NONVAL_INST" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | |
Relationship Business Name | |
Physical Only | No |
Parent Table | INST |
Child Table | NONVAL_INST |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"INST to NONVAL_INST" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"INST to NONVAL_INST" Foreign Keys |
Parent Key | Child Key |
INST_ID | INST_ID |
"INST to NONVAL_INST" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"INST to NONVAL_INST" Bound Attachments |
Name | Current Value |
"EXPT_FACIL to SMPL_ENV" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | |
Relationship Business Name | |
Physical Only | No |
Parent Table | EXPT_FACIL |
Child Table | SMPL_ENV |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"EXPT_FACIL to SMPL_ENV" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EXPT_FACIL to SMPL_ENV" Foreign Keys |
Parent Key | Child Key |
FACIL_ID | FACIL_ID |
"EXPT_FACIL to SMPL_ENV" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"EXPT_FACIL to 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 |
"BEAM_ALLOC_ALLOT to BEAM_ALLOC_DEF" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_BAAD_TO_BEAM_ALLOC |
Relationship Business Name | |
Physical Only | No |
Parent Table | BEAM_ALLOC_ALLOT |
Child Table | BEAM_ALLOC_DEF |
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_DEF" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"BEAM_ALLOC_ALLOT to BEAM_ALLOC_DEF" Foreign Keys |
Parent Key | Child Key |
ALLOT_ID | ALLOT_ID |
"BEAM_ALLOC_ALLOT to BEAM_ALLOC_DEF" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"BEAM_ALLOC_ALLOT to BEAM_ALLOC_DEF" Bound Attachments |
Name | Current Value |
"PRPSL_TYPE to BEAM_ALLOC_DEF" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_BAAD_TO_PRPSL_TYPE |
Relationship Business Name | |
Physical Only | No |
Parent Table | PRPSL_TYPE |
Child Table | BEAM_ALLOC_DEF |
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_DEF" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"PRPSL_TYPE to BEAM_ALLOC_DEF" Foreign Keys |
Parent Key | Child Key |
PRPSL_TYPE_ID | PRPSL_TYPE_ID |
"PRPSL_TYPE to BEAM_ALLOC_DEF" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"PRPSL_TYPE to BEAM_ALLOC_DEF" 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 |
"EMAIL_PREV to EMAIL_PREV_ATTACH" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_EMAIL_PREV_ATT_TO_EMAIL_PREV |
Relationship Business Name | |
Physical Only | No |
Parent Table | EMAIL_PREV |
Child Table | EMAIL_PREV_ATTACH |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"EMAIL_PREV to EMAIL_PREV_ATTACH" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EMAIL_PREV to EMAIL_PREV_ATTACH" Foreign Keys |
Parent Key | Child Key |
TEMPLATE_ID, SEQ_ID | TEMPLATE_ID, SEQ_ID |
"EMAIL_PREV to EMAIL_PREV_ATTACH" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"EMAIL_PREV to EMAIL_PREV_ATTACH" Bound Attachments |
Name | Current Value |
"INSTR to EMAIL_PREV" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | FK_EMAIL_PREV_TO_INSTR |
Relationship Business Name | |
Physical Only | No |
Parent Table | INSTR |
Child Table | EMAIL_PREV |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"INSTR to EMAIL_PREV" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"INSTR to EMAIL_PREV" Foreign Keys |
Parent Key | Child Key |
INSTR_ID | INSTR_ID |
"INSTR to EMAIL_PREV" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"INSTR to EMAIL_PREV" Bound Attachments |
Name | Current Value |
"EMAIL_TEMPLATE to EMAIL_TMPL_TAG" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_EMAIL_TMPL_TAG_EMAIL_TEMPL |
Relationship Business Name | |
Physical Only | No |
Parent Table | EMAIL_TEMPLATE |
Child Table | EMAIL_TMPL_TAG |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"EMAIL_TEMPLATE to EMAIL_TMPL_TAG" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EMAIL_TEMPLATE to EMAIL_TMPL_TAG" Foreign Keys |
Parent Key | Child Key |
TEMPLATE_ID | TEMPLATE_ID |
"EMAIL_TEMPLATE to EMAIL_TMPL_TAG" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"EMAIL_TEMPLATE to EMAIL_TMPL_TAG" Bound Attachments |
Name | Current Value |
"EMAIL_TEMPLATE to EMAIL_PREV" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_EP_TO_EMAIL_TEMPLATE |
Relationship Business Name | |
Physical Only | No |
Parent Table | EMAIL_TEMPLATE |
Child Table | EMAIL_PREV |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"EMAIL_TEMPLATE to EMAIL_PREV" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EMAIL_TEMPLATE to EMAIL_PREV" Foreign Keys |
Parent Key | Child Key |
TEMPLATE_ID | TEMPLATE_ID |
"EMAIL_TEMPLATE to EMAIL_PREV" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"EMAIL_TEMPLATE to EMAIL_PREV" Bound Attachments |
Name | Current Value |
"EXPT_FACIL to ESH_ADMIN" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_esh_admin_expt_facil |
Relationship Business Name | |
Physical Only | No |
Parent Table | EXPT_FACIL |
Child Table | ESH_ADMIN |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"EXPT_FACIL to ESH_ADMIN" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EXPT_FACIL to ESH_ADMIN" Foreign Keys |
Parent Key | Child Key |
FACIL_ID | FACIL_ID |
"EXPT_FACIL to ESH_ADMIN" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"EXPT_FACIL to ESH_ADMIN" Bound Attachments |
Name | Current Value |
"PERSON to ESH_ADMIN" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_esh_admin_person |
Relationship Business Name | |
Physical Only | No |
Parent Table | PERSON |
Child Table | ESH_ADMIN |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"PERSON to ESH_ADMIN" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"PERSON to ESH_ADMIN" Foreign Keys |
Parent Key | Child Key |
PERSON_ID | PERSON_ID |
"PERSON to ESH_ADMIN" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"PERSON to ESH_ADMIN" Bound Attachments |
Name | Current Value |
"PRPSL_TYPE to EMAIL_TMPL_PRPSL_TYPE_ST_ASSC" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_etptsa_to_prpsl_type |
Relationship Business Name | |
Physical Only | No |
Parent Table | PRPSL_TYPE |
Child Table | EMAIL_TMPL_PRPSL_TYPE_ST_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 EMAIL_TMPL_PRPSL_TYPE_ST_ASSC" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"PRPSL_TYPE to EMAIL_TMPL_PRPSL_TYPE_ST_ASSC" Foreign Keys |
Parent Key | Child Key |
PRPSL_TYPE_ID | PRPSL_TYPE_ID |
"PRPSL_TYPE to EMAIL_TMPL_PRPSL_TYPE_ST_ASSC" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"PRPSL_TYPE to EMAIL_TMPL_PRPSL_TYPE_ST_ASSC" Bound Attachments |
Name | Current Value |
"RUN_CYCLE to FACIL_RUN_CYCLE" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_frc_to_run_cycle |
Relationship Business Name | |
Physical Only | No |
Parent Table | RUN_CYCLE |
Child Table | FACIL_RUN_CYCLE |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"RUN_CYCLE to FACIL_RUN_CYCLE" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"RUN_CYCLE to FACIL_RUN_CYCLE" Foreign Keys |
Parent Key | Child Key |
FACIL_ID, RUN_CYCLE_ID | FACIL_ID, RUN_CYCLE_ID |
"RUN_CYCLE to FACIL_RUN_CYCLE" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"RUN_CYCLE to FACIL_RUN_CYCLE" Bound Attachments |
Name | Current Value |
"INSTR to INSTR_DEV_TEAM" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_idt_to_instr |
Relationship Business Name | |
Physical Only | No |
Parent Table | INSTR |
Child Table | INSTR_DEV_TEAM |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"INSTR to INSTR_DEV_TEAM" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"INSTR to INSTR_DEV_TEAM" Foreign Keys |
Parent Key | Child Key |
INSTR_ID | INSTR_ID |
"INSTR to INSTR_DEV_TEAM" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"INSTR to INSTR_DEV_TEAM" Bound Attachments |
Name | Current Value |
"PERSON to INSTR_DEV_TEAM" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_idt_to_person |
Relationship Business Name | |
Physical Only | No |
Parent Table | PERSON |
Child Table | INSTR_DEV_TEAM |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"PERSON to INSTR_DEV_TEAM" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"PERSON to INSTR_DEV_TEAM" Foreign Keys |
Parent Key | Child Key |
PERSON_ID | PERSON_ID |
"PERSON to INSTR_DEV_TEAM" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"PERSON to INSTR_DEV_TEAM" Bound Attachments |
Name | Current Value |
"INSTR_GRP to INSTR_GRP_REV_SUBCOMM_ASSC" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_igrsa_to_instr_grp |
Relationship Business Name | |
Physical Only | No |
Parent Table | INSTR_GRP |
Child Table | INSTR_GRP_REV_SUBCOMM_ASSC |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"INSTR_GRP to INSTR_GRP_REV_SUBCOMM_ASSC" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"INSTR_GRP to INSTR_GRP_REV_SUBCOMM_ASSC" Foreign Keys |
Parent Key | Child Key |
GRP_ID | GRP_ID |
"INSTR_GRP to INSTR_GRP_REV_SUBCOMM_ASSC" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"INSTR_GRP to INSTR_GRP_REV_SUBCOMM_ASSC" 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 |
"BES_INST_CAT to INST" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | FK_INST_TO_BES_INST_CAT |
Relationship Business Name | |
Physical Only | No |
Parent Table | BES_INST_CAT |
Child Table | INST |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"BES_INST_CAT to INST" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"BES_INST_CAT to INST" Foreign Keys |
Parent Key | Child Key |
CAT_ID | CAT_ID |
"BES_INST_CAT to INST" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"BES_INST_CAT to INST" Bound Attachments |
Name | Current Value |
"INSTR_CONFIG to INSTR_CONFIG_ASSC" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_INSTR_CFG_ASSC_INSTR_CFG |
Relationship Business Name | |
Physical Only | No |
Parent Table | INSTR_CONFIG |
Child Table | INSTR_CONFIG_ASSC |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"INSTR_CONFIG to INSTR_CONFIG_ASSC" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"INSTR_CONFIG to INSTR_CONFIG_ASSC" Foreign Keys |
Parent Key | Child Key |
INSTR_CONFIG_ID | INSTR_CONFIG_ID |
"INSTR_CONFIG to INSTR_CONFIG_ASSC" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"INSTR_CONFIG to INSTR_CONFIG_ASSC" Bound Attachments |
Name | Current Value |
"INSTR to INSTR_CONFIG_ASSC" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_INSTR_CONFIG_ASSC_INST |
Relationship Business Name | |
Physical Only | No |
Parent Table | INSTR |
Child Table | INSTR_CONFIG_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_CONFIG_ASSC" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"INSTR to INSTR_CONFIG_ASSC" Foreign Keys |
Parent Key | Child Key |
INSTR_ID | INSTR_ID |
"INSTR to INSTR_CONFIG_ASSC" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"INSTR to INSTR_CONFIG_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_GRP to INSTR_GRP_CHAIR" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_instr_grp_chair_instr_grp |
Relationship Business Name | |
Physical Only | No |
Parent Table | INSTR_GRP |
Child Table | INSTR_GRP_CHAIR |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"INSTR_GRP to INSTR_GRP_CHAIR" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"INSTR_GRP to INSTR_GRP_CHAIR" Foreign Keys |
Parent Key | Child Key |
GRP_ID | GRP_ID |
"INSTR_GRP to INSTR_GRP_CHAIR" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"INSTR_GRP to INSTR_GRP_CHAIR" Bound Attachments |
Name | Current Value |
"PERSON to INSTR_GRP_CHAIR" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_instr_grp_chair_person |
Relationship Business Name | |
Physical Only | No |
Parent Table | PERSON |
Child Table | INSTR_GRP_CHAIR |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"PERSON to INSTR_GRP_CHAIR" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"PERSON to INSTR_GRP_CHAIR" Foreign Keys |
Parent Key | Child Key |
PERSON_ID | PERSON_ID |
"PERSON to INSTR_GRP_CHAIR" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"PERSON to INSTR_GRP_CHAIR" 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 |
"INSTR to INSTR_REVIEW" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_INSTR_REVIEW_INST |
Relationship Business Name | |
Physical Only | No |
Parent Table | INSTR |
Child Table | INSTR_REVIEW |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"INSTR to INSTR_REVIEW" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"INSTR to INSTR_REVIEW" Foreign Keys |
Parent Key | Child Key |
INSTR_ID | INSTR_ID |
"INSTR to INSTR_REVIEW" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"INSTR to INSTR_REVIEW" Bound Attachments |
Name | Current Value |
"EMPLOYEE to INSTR_SCI" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_INSTR_SCI_TO_EMP |
Relationship Business Name | |
Physical Only | No |
Parent Table | EMPLOYEE |
Child Table | INSTR_SCI |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"EMPLOYEE to INSTR_SCI" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EMPLOYEE to INSTR_SCI" Foreign Keys |
Parent Key | Child Key |
BN | BN |
"EMPLOYEE to INSTR_SCI" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"EMPLOYEE to INSTR_SCI" Bound Attachments |
Name | Current Value |
"INSTR to INSTR_SCI" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_INSTR_SCI_TO_INSTR |
Relationship Business Name | |
Physical Only | No |
Parent Table | INSTR |
Child Table | INSTR_SCI |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"INSTR to INSTR_SCI" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"INSTR to INSTR_SCI" Foreign Keys |
Parent Key | Child Key |
INSTR_ID | INSTR_ID |
"INSTR to INSTR_SCI" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"INSTR to INSTR_SCI" Bound Attachments |
Name | Current Value |
"EMPLOYEE to INSTR_SUP" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_INSTR_SUP_TO_EMP |
Relationship Business Name | |
Physical Only | No |
Parent Table | EMPLOYEE |
Child Table | INSTR_SUP |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"EMPLOYEE to INSTR_SUP" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EMPLOYEE to INSTR_SUP" Foreign Keys |
Parent Key | Child Key |
BN | BN |
"EMPLOYEE to INSTR_SUP" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"EMPLOYEE to INSTR_SUP" Bound Attachments |
Name | Current Value |
"INSTR to INSTR_SUP" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_INSTR_SUP_TO_INSTR |
Relationship Business Name | |
Physical Only | No |
Parent Table | INSTR |
Child Table | INSTR_SUP |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"INSTR to INSTR_SUP" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"INSTR to INSTR_SUP" Foreign Keys |
Parent Key | Child Key |
INSTR_ID | INSTR_ID |
"INSTR to INSTR_SUP" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"INSTR to INSTR_SUP" Bound Attachments |
Name | Current Value |
"INSTR_SUP_ROLE to INSTR_SUP" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_INSTR_SUP_TO_INSTR_SUP_ROLE |
Relationship Business Name | |
Physical Only | No |
Parent Table | INSTR_SUP_ROLE |
Child Table | INSTR_SUP |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"INSTR_SUP_ROLE to INSTR_SUP" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"INSTR_SUP_ROLE to INSTR_SUP" Foreign Keys |
Parent Key | Child Key |
SUP_ID | SUP_ID |
"INSTR_SUP_ROLE to INSTR_SUP" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"INSTR_SUP_ROLE to INSTR_SUP" Bound Attachments |
Name | Current Value |
"INSTR to INSTR_TEAM" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_instr_tm_to_instr |
Relationship Business Name | |
Physical Only | No |
Parent Table | INSTR |
Child Table | INSTR_TEAM |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"INSTR to INSTR_TEAM" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"INSTR to INSTR_TEAM" Foreign Keys |
Parent Key | Child Key |
INSTR_ID | INSTR_ID |
"INSTR to INSTR_TEAM" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"INSTR to INSTR_TEAM" Bound Attachments |
Name | Current Value |
"INSTR to INSTR_UNAVAIL" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_INSTR_UNAVAIL_INSTR |
Relationship Business Name | |
Physical Only | No |
Parent Table | INSTR |
Child Table | INSTR_UNAVAIL |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"INSTR to INSTR_UNAVAIL" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"INSTR to INSTR_UNAVAIL" Foreign Keys |
Parent Key | Child Key |
INSTR_ID | INSTR_ID |
"INSTR to INSTR_UNAVAIL" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"INSTR to INSTR_UNAVAIL" Bound Attachments |
Name | Current Value |
"INSTR_PRPSL_QUES to INSTR_PRPSL_QUES_SEL_INSTR" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_IPQS_TO_INSTR_PRPSL_QUES |
Relationship Business Name | |
Physical Only | No |
Parent Table | INSTR_PRPSL_QUES |
Child Table | INSTR_PRPSL_QUES_SEL_INSTR |
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_PRPSL_QUES_SEL_INSTR" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"INSTR_PRPSL_QUES to INSTR_PRPSL_QUES_SEL_INSTR" Foreign Keys |
Parent Key | Child Key |
QUESTION_ID | QUESTION_ID |
"INSTR_PRPSL_QUES to INSTR_PRPSL_QUES_SEL_INSTR" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"INSTR_PRPSL_QUES to INSTR_PRPSL_QUES_SEL_INSTR" Bound Attachments |
Name | Current Value |
"INSTR to INSTR_PRPSL_QUES_SEL_INSTR" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_IPQSI_TO_INSTR |
Relationship Business Name | |
Physical Only | No |
Parent Table | INSTR |
Child Table | INSTR_PRPSL_QUES_SEL_INSTR |
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_QUES_SEL_INSTR" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"INSTR to INSTR_PRPSL_QUES_SEL_INSTR" Foreign Keys |
Parent Key | Child Key |
INSTR_ID | INSTR_ID |
"INSTR to INSTR_PRPSL_QUES_SEL_INSTR" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"INSTR to INSTR_PRPSL_QUES_SEL_INSTR" Bound Attachments |
Name | Current Value |
"INSTR_PRPSL_QUES to INSTR_PRPSL_QUES_SEL_VAL" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_ipqsv_to_instr_prpsl_ques |
Relationship Business Name | |
Physical Only | No |
Parent Table | INSTR_PRPSL_QUES |
Child Table | INSTR_PRPSL_QUES_SEL_VAL |
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_PRPSL_QUES_SEL_VAL" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"INSTR_PRPSL_QUES to INSTR_PRPSL_QUES_SEL_VAL" Foreign Keys |
Parent Key | Child Key |
QUESTION_ID | QUESTION_ID |
"INSTR_PRPSL_QUES to INSTR_PRPSL_QUES_SEL_VAL" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"INSTR_PRPSL_QUES to INSTR_PRPSL_QUES_SEL_VAL" Bound Attachments |
Name | Current Value |
"EXPT_FACIL to LAB" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | FK_LAB_EXPRT_FACIL |
Relationship Business Name | |
Physical Only | No |
Parent Table | EXPT_FACIL |
Child Table | LAB |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"EXPT_FACIL to LAB" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EXPT_FACIL to LAB" Foreign Keys |
Parent Key | Child Key |
FACIL_ID | FACIL_ID |
"EXPT_FACIL to LAB" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"EXPT_FACIL to LAB" Bound Attachments |
Name | Current Value |
"EXPT_FACIL to FACIL_NOTC" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_NOTICE_FACILITY |
Relationship Business Name | |
Physical Only | No |
Parent Table | EXPT_FACIL |
Child Table | FACIL_NOTC |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"EXPT_FACIL to FACIL_NOTC" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EXPT_FACIL to FACIL_NOTC" Foreign Keys |
Parent Key | Child Key |
FACIL_ID | FACIL_ID |
"EXPT_FACIL to FACIL_NOTC" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"EXPT_FACIL to FACIL_NOTC" Bound Attachments |
Name | Current Value |
"CNTRY to PERSON" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | FK_PERSON_CNTRY_CNTRY |
Relationship Business Name | |
Physical Only | No |
Parent Table | CNTRY |
Child Table | PERSON |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"CNTRY to PERSON" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"CNTRY to PERSON" Foreign Keys |
Parent Key | Child Key |
CNTRY_ID | CNTRY_ID |
"CNTRY to PERSON" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"CNTRY to PERSON" Bound Attachments |
Name | Current Value |
"INST to PERSON" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | FK_PERSON_TO_INST |
Relationship Business Name | |
Physical Only | No |
Parent Table | INST |
Child Table | PERSON |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"INST to PERSON" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"INST to PERSON" Foreign Keys |
Parent Key | Child Key |
INST_ID | INST_ID |
"INST to PERSON" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"INST to PERSON" 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 |
"PERSON to REV_SUBCOMM_PERS_ASSC" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_rspa_to_person |
Relationship Business Name | |
Physical Only | No |
Parent Table | PERSON |
Child Table | REV_SUBCOMM_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 REV_SUBCOMM_PERS_ASSC" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"PERSON to REV_SUBCOMM_PERS_ASSC" Foreign Keys |
Parent Key | Child Key |
PERSON_ID | PERSON_ID |
"PERSON to REV_SUBCOMM_PERS_ASSC" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"PERSON to REV_SUBCOMM_PERS_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 |
"REV_SUBCOMM to REV_SUBCOMM_PERS_ASSC" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_rspa_to_review_subcomm |
Relationship Business Name | |
Physical Only | No |
Parent Table | REV_SUBCOMM |
Child Table | REV_SUBCOMM_PERS_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_PERS_ASSC" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"REV_SUBCOMM to REV_SUBCOMM_PERS_ASSC" Foreign Keys |
Parent Key | Child Key |
SUBCOMM_ID | SUBCOMM_ID |
"REV_SUBCOMM to REV_SUBCOMM_PERS_ASSC" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"REV_SUBCOMM to REV_SUBCOMM_PERS_ASSC" Bound Attachments |
Name | Current Value |
"PERSON to REV_SUBCOMM_SCRIBE" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_rss_to_person |
Relationship Business Name | |
Physical Only | No |
Parent Table | PERSON |
Child Table | REV_SUBCOMM_SCRIBE |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"PERSON to REV_SUBCOMM_SCRIBE" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"PERSON to REV_SUBCOMM_SCRIBE" Foreign Keys |
Parent Key | Child Key |
PERSON_ID | PERSON_ID |
"PERSON to REV_SUBCOMM_SCRIBE" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"PERSON to REV_SUBCOMM_SCRIBE" Bound Attachments |
Name | Current Value |
"REV_SUBCOMM to REV_SUBCOMM_SCRIBE" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_rss_to_rev_subcomm |
Relationship Business Name | |
Physical Only | No |
Parent Table | REV_SUBCOMM |
Child Table | REV_SUBCOMM_SCRIBE |
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_SCRIBE" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"REV_SUBCOMM to REV_SUBCOMM_SCRIBE" Foreign Keys |
Parent Key | Child Key |
SUBCOMM_ID | SUBCOMM_ID |
"REV_SUBCOMM to REV_SUBCOMM_SCRIBE" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"REV_SUBCOMM to REV_SUBCOMM_SCRIBE" 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 |
"SCI_HIGH_PI to SCI_HIGH_PI_ASSC" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_sci_high_pi_assc_to_pi |
Relationship Business Name | |
Physical Only | No |
Parent Table | SCI_HIGH_PI |
Child Table | SCI_HIGH_PI_ASSC |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"SCI_HIGH_PI to SCI_HIGH_PI_ASSC" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"SCI_HIGH_PI to SCI_HIGH_PI_ASSC" Foreign Keys |
Parent Key | Child Key |
EMAIL_ADDR | EMAIL_ADDR |
"SCI_HIGH_PI to SCI_HIGH_PI_ASSC" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"SCI_HIGH_PI to SCI_HIGH_PI_ASSC" Bound Attachments |
Name | Current Value |
"SCI_HIGH to SCI_HIGH_PI_ASSC" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_sci_high_pi_assc_to_sci_high |
Relationship Business Name | |
Physical Only | No |
Parent Table | SCI_HIGH |
Child Table | SCI_HIGH_PI_ASSC |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"SCI_HIGH to SCI_HIGH_PI_ASSC" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"SCI_HIGH to SCI_HIGH_PI_ASSC" Foreign Keys |
Parent Key | Child Key |
SCI_HIGH_ID | SCI_HIGH_ID |
"SCI_HIGH to SCI_HIGH_PI_ASSC" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"SCI_HIGH to SCI_HIGH_PI_ASSC" Bound Attachments |
Name | Current Value |
"SCI_HIGH_AUTH to SCI_HIGH" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | fk_sci_high_to_sci_high_auth |
Relationship Business Name | |
Physical Only | No |
Parent Table | SCI_HIGH_AUTH |
Child Table | SCI_HIGH |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"SCI_HIGH_AUTH to SCI_HIGH" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"SCI_HIGH_AUTH to SCI_HIGH" Foreign Keys |
Parent Key | Child Key |
EMAIL_ADDR | EMAIL_ADDR |
"SCI_HIGH_AUTH to SCI_HIGH" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"SCI_HIGH_AUTH to SCI_HIGH" Bound Attachments |
Name | Current Value |
"SCI_HIGH_CAT to SCI_HIGH" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | fk_sci_high_to_sci_high_cat |
Relationship Business Name | |
Physical Only | No |
Parent Table | SCI_HIGH_CAT |
Child Table | SCI_HIGH |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"SCI_HIGH_CAT to SCI_HIGH" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"SCI_HIGH_CAT to SCI_HIGH" Foreign Keys |
Parent Key | Child Key |
SCI_HIGH_CAT_ID | SCI_HIGH_CAT_ID |
"SCI_HIGH_CAT to SCI_HIGH" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"SCI_HIGH_CAT to SCI_HIGH" Bound Attachments |
Name | Current Value |
"SCI_TOPIC to SCI_HIGH" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | fk_sci_high_to_sci_topic |
Relationship Business Name | |
Physical Only | No |
Parent Table | SCI_TOPIC |
Child Table | SCI_HIGH |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"SCI_TOPIC to SCI_HIGH" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"SCI_TOPIC to SCI_HIGH" Foreign Keys |
Parent Key | Child Key |
TOPIC_ID | TOPIC_ID |
"SCI_TOPIC to SCI_HIGH" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"SCI_TOPIC to SCI_HIGH" Bound Attachments |
Name | Current Value |
"INSTR to SMPL_COND_INSTR_ASSC" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_scia_to_instr |
Relationship Business Name | |
Physical Only | No |
Parent Table | INSTR |
Child Table | SMPL_COND_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 SMPL_COND_INSTR_ASSC" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"INSTR to SMPL_COND_INSTR_ASSC" Foreign Keys |
Parent Key | Child Key |
INSTR_ID | INSTR_ID |
"INSTR to SMPL_COND_INSTR_ASSC" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"INSTR to SMPL_COND_INSTR_ASSC" Bound Attachments |
Name | Current Value |
"SMPL_COND to SMPL_COND_INSTR_ASSC" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_scia_to_smpl_cond |
Relationship Business Name | |
Physical Only | No |
Parent Table | SMPL_COND |
Child Table | SMPL_COND_INSTR_ASSC |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"SMPL_COND to SMPL_COND_INSTR_ASSC" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"SMPL_COND to SMPL_COND_INSTR_ASSC" Foreign Keys |
Parent Key | Child Key |
SMPL_ENV_ID, SMPL_COND_ID | SMPL_ENV_ID, SMPL_COND_ID |
"SMPL_COND to SMPL_COND_INSTR_ASSC" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"SMPL_COND to SMPL_COND_INSTR_ASSC" Bound Attachments |
Name | Current Value |
"INSTR to SMPL_ENV_INSTR_ASSC" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_seia_to_instr |
Relationship Business Name | |
Physical Only | No |
Parent Table | INSTR |
Child Table | SMPL_ENV_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 SMPL_ENV_INSTR_ASSC" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"INSTR to SMPL_ENV_INSTR_ASSC" Foreign Keys |
Parent Key | Child Key |
INSTR_ID | INSTR_ID |
"INSTR to SMPL_ENV_INSTR_ASSC" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"INSTR to SMPL_ENV_INSTR_ASSC" Bound Attachments |
Name | Current Value |
"SMPL_ENV to SMPL_ENV_INSTR_ASSC" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_seia_to_smpl_env |
Relationship Business Name | |
Physical Only | No |
Parent Table | SMPL_ENV |
Child Table | SMPL_ENV_INSTR_ASSC |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"SMPL_ENV to SMPL_ENV_INSTR_ASSC" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"SMPL_ENV to SMPL_ENV_INSTR_ASSC" Foreign Keys |
Parent Key | Child Key |
FACIL_ID, SMPL_ENV_ID | FACIL_ID, SMPL_ENV_ID |
"SMPL_ENV to SMPL_ENV_INSTR_ASSC" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"SMPL_ENV to SMPL_ENV_INSTR_ASSC" Bound Attachments |
Name | Current Value |
"EXPT_FACIL to SCI_HIGH_FACIL_ASSC" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_shfa_to_expt_facil |
Relationship Business Name | |
Physical Only | No |
Parent Table | EXPT_FACIL |
Child Table | SCI_HIGH_FACIL_ASSC |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"EXPT_FACIL to SCI_HIGH_FACIL_ASSC" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EXPT_FACIL to SCI_HIGH_FACIL_ASSC" Foreign Keys |
Parent Key | Child Key |
FACIL_ID | FACIL_ID |
"EXPT_FACIL to SCI_HIGH_FACIL_ASSC" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"EXPT_FACIL to SCI_HIGH_FACIL_ASSC" Bound Attachments |
Name | Current Value |
"SCI_HIGH to SCI_HIGH_FACIL_ASSC" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_shfa_to_sci_high |
Relationship Business Name | |
Physical Only | No |
Parent Table | SCI_HIGH |
Child Table | SCI_HIGH_FACIL_ASSC |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"SCI_HIGH to SCI_HIGH_FACIL_ASSC" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"SCI_HIGH to SCI_HIGH_FACIL_ASSC" Foreign Keys |
Parent Key | Child Key |
SCI_HIGH_ID | SCI_HIGH_ID |
"SCI_HIGH to SCI_HIGH_FACIL_ASSC" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"SCI_HIGH to SCI_HIGH_FACIL_ASSC" Bound Attachments |
Name | Current Value |
"INSTR to SCI_HIGH_INSTR_ASSC" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_shia_to_instr |
Relationship Business Name | |
Physical Only | No |
Parent Table | INSTR |
Child Table | SCI_HIGH_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 SCI_HIGH_INSTR_ASSC" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"INSTR to SCI_HIGH_INSTR_ASSC" Foreign Keys |
Parent Key | Child Key |
INSTR_ID | INSTR_ID |
"INSTR to SCI_HIGH_INSTR_ASSC" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"INSTR to SCI_HIGH_INSTR_ASSC" Bound Attachments |
Name | Current Value |
"SCI_HIGH to SCI_HIGH_INSTR_ASSC" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_shia_to_sci_high |
Relationship Business Name | |
Physical Only | No |
Parent Table | SCI_HIGH |
Child Table | SCI_HIGH_INSTR_ASSC |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"SCI_HIGH to SCI_HIGH_INSTR_ASSC" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"SCI_HIGH to SCI_HIGH_INSTR_ASSC" Foreign Keys |
Parent Key | Child Key |
SCI_HIGH_ID | SCI_HIGH_ID |
"SCI_HIGH to SCI_HIGH_INSTR_ASSC" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"SCI_HIGH to SCI_HIGH_INSTR_ASSC" Bound Attachments |
Name | Current Value |
"SCI_HIGH to SCI_JOUR_HIGH_ASSC" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_sjha_to_sci_high |
Relationship Business Name | |
Physical Only | No |
Parent Table | SCI_HIGH |
Child Table | SCI_JOUR_HIGH_ASSC |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"SCI_HIGH to SCI_JOUR_HIGH_ASSC" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"SCI_HIGH to SCI_JOUR_HIGH_ASSC" Foreign Keys |
Parent Key | Child Key |
SCI_HIGH_ID | SCI_HIGH_ID |
"SCI_HIGH to SCI_JOUR_HIGH_ASSC" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"SCI_HIGH to SCI_JOUR_HIGH_ASSC" Bound Attachments |
Name | Current Value |
"SCI_JOUR to SCI_JOUR_HIGH_ASSC" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_sjha_to_sci_jour |
Relationship Business Name | |
Physical Only | No |
Parent Table | SCI_JOUR |
Child Table | SCI_JOUR_HIGH_ASSC |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"SCI_JOUR to SCI_JOUR_HIGH_ASSC" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"SCI_JOUR to SCI_JOUR_HIGH_ASSC" Foreign Keys |
Parent Key | Child Key |
JOUR_ID | JOUR_ID |
"SCI_JOUR to SCI_JOUR_HIGH_ASSC" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"SCI_JOUR to SCI_JOUR_HIGH_ASSC" Bound Attachments |
Name | Current Value |
"SMPL_ENV_ATTR to SMPL_COND" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_smpl_cond_to_smpl_attr |
Relationship Business Name | |
Physical Only | No |
Parent Table | SMPL_ENV_ATTR |
Child Table | SMPL_COND |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"SMPL_ENV_ATTR to SMPL_COND" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"SMPL_ENV_ATTR to SMPL_COND" Foreign Keys |
Parent Key | Child Key |
SMPL_ENV_ID | SMPL_ENV_ID |
"SMPL_ENV_ATTR to SMPL_COND" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"SMPL_ENV_ATTR to SMPL_COND" Bound Attachments |
Name | Current Value |
"EMPLOYEE to TRAIN_PERSON" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | FK_TP_TO_EMP |
Relationship Business Name | |
Physical Only | No |
Parent Table | EMPLOYEE |
Child Table | TRAIN_PERSON |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"EMPLOYEE to TRAIN_PERSON" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EMPLOYEE to TRAIN_PERSON" Foreign Keys |
Parent Key | Child Key |
BN | CERT_BN |
"EMPLOYEE to TRAIN_PERSON" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"EMPLOYEE to TRAIN_PERSON" Bound Attachments |
Name | Current Value |
"PERSON to TRAIN_PERSON" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_TP_TO_PERSON |
Relationship Business Name | |
Physical Only | No |
Parent Table | PERSON |
Child Table | TRAIN_PERSON |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"PERSON to TRAIN_PERSON" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"PERSON to TRAIN_PERSON" Foreign Keys |
Parent Key | Child Key |
PERSON_ID | PERSON_ID |
"PERSON to TRAIN_PERSON" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"PERSON to TRAIN_PERSON" Bound Attachments |
Name | Current Value |
"TRAIN_MOD to TRAIN_PERSON" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_TP_TO_TRAIN_MOD |
Relationship Business Name | |
Physical Only | No |
Parent Table | TRAIN_MOD |
Child Table | TRAIN_PERSON |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"TRAIN_MOD to TRAIN_PERSON" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"TRAIN_MOD to TRAIN_PERSON" Foreign Keys |
Parent Key | Child Key |
MOD_ID | MOD_ID |
"TRAIN_MOD to TRAIN_PERSON" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"TRAIN_MOD to TRAIN_PERSON" Bound Attachments |
Name | Current Value |
"TRAIN_MOD to TRAIN_FACIL_ASSC" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_train_facil_assc_to_train |
Relationship Business Name | |
Physical Only | No |
Parent Table | TRAIN_MOD |
Child Table | TRAIN_FACIL_ASSC |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"TRAIN_MOD to TRAIN_FACIL_ASSC" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"TRAIN_MOD to TRAIN_FACIL_ASSC" Foreign Keys |
Parent Key | Child Key |
MOD_ID | MOD_ID |
"TRAIN_MOD to TRAIN_FACIL_ASSC" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"TRAIN_MOD to TRAIN_FACIL_ASSC" Bound Attachments |
Name | Current Value |
"EXPT_FACIL to TRAIN_FACIL_ASSC" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_TRAIN_FAIL_TO_FACIL |
Relationship Business Name | |
Physical Only | No |
Parent Table | EXPT_FACIL |
Child Table | TRAIN_FACIL_ASSC |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"EXPT_FACIL to TRAIN_FACIL_ASSC" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EXPT_FACIL to TRAIN_FACIL_ASSC" Foreign Keys |
Parent Key | Child Key |
FACIL_ID | FACIL_ID |
"EXPT_FACIL to TRAIN_FACIL_ASSC" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"EXPT_FACIL to TRAIN_FACIL_ASSC" Bound Attachments |
Name | Current Value |
"INSTR to TRAIN_INSTR_ASSC" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_train_instr_assc_to_instr |
Relationship Business Name | |
Physical Only | No |
Parent Table | INSTR |
Child Table | TRAIN_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 TRAIN_INSTR_ASSC" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"INSTR to TRAIN_INSTR_ASSC" Foreign Keys |
Parent Key | Child Key |
INSTR_ID | INSTR_ID |
"INSTR to TRAIN_INSTR_ASSC" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"INSTR to TRAIN_INSTR_ASSC" Bound Attachments |
Name | Current Value |
"TRAIN_MOD to TRAIN_INSTR_ASSC" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_train_instr_assc_to_train |
Relationship Business Name | |
Physical Only | No |
Parent Table | TRAIN_MOD |
Child Table | TRAIN_INSTR_ASSC |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"TRAIN_MOD to TRAIN_INSTR_ASSC" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"TRAIN_MOD to TRAIN_INSTR_ASSC" Foreign Keys |
Parent Key | Child Key |
MOD_ID | MOD_ID |
"TRAIN_MOD to TRAIN_INSTR_ASSC" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"TRAIN_MOD to TRAIN_INSTR_ASSC" Bound Attachments |
Name | Current Value |
"REV_SUBCOMM to INSTR_GRP_REV_SUBCOMM_ASSC" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | igrsa_to_rev_subcomm |
Relationship Business Name | |
Physical Only | No |
Parent Table | REV_SUBCOMM |
Child Table | INSTR_GRP_REV_SUBCOMM_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 INSTR_GRP_REV_SUBCOMM_ASSC" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"REV_SUBCOMM to INSTR_GRP_REV_SUBCOMM_ASSC" Foreign Keys |
Parent Key | Child Key |
SUBCOMM_ID | SUBCOMM_ID |
"REV_SUBCOMM to INSTR_GRP_REV_SUBCOMM_ASSC" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"REV_SUBCOMM to INSTR_GRP_REV_SUBCOMM_ASSC" Bound Attachments |
Name | Current Value |