"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 |
"PERSON to AUTHOR" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | FK_AUTHOR_TO_PERSON |
Relationship Business Name | |
Physical Only | No |
Parent Table | PERSON |
Child Table | AUTHOR |
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 AUTHOR" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"PERSON to AUTHOR" Foreign Keys |
Parent Key | Child Key |
PERSON_ID | PERSON_ID |
"PERSON to AUTHOR" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"PERSON to AUTHOR" Bound Attachments |
Name | Current Value |
"CONF to CONF_PROCEED" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_CONF_PROCEED_TO_CONF |
Relationship Business Name | |
Physical Only | No |
Parent Table | CONF |
Child Table | CONF_PROCEED |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"CONF to CONF_PROCEED" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"CONF to CONF_PROCEED" Foreign Keys |
Parent Key | Child Key |
CONF_ID | CONF_ID |
"CONF to CONF_PROCEED" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"CONF to CONF_PROCEED" Bound Attachments |
Name | Current Value |
"FACIL_NON_INSTR to PUBL_FACIL_NON_INSTR_ASSC" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_FAC_NINSTR_TO_FAC_NINSTR |
Relationship Business Name | |
Physical Only | No |
Parent Table | FACIL_NON_INSTR |
Child Table | PUBL_FACIL_NON_INSTR_ASSC |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"FACIL_NON_INSTR to PUBL_FACIL_NON_INSTR_ASSC" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"FACIL_NON_INSTR to PUBL_FACIL_NON_INSTR_ASSC" Foreign Keys |
Parent Key | Child Key |
FACIL_ID, NON_INSTR_ID | FACIL_ID, NON_INSTR_ID |
"FACIL_NON_INSTR to PUBL_FACIL_NON_INSTR_ASSC" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"FACIL_NON_INSTR to PUBL_FACIL_NON_INSTR_ASSC" Bound Attachments |
Name | Current Value |
"PUBL to PUBL_FACIL_NON_INSTR_ASSC" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_FACIL_NINSTR_TO_PUBL |
Relationship Business Name | |
Physical Only | No |
Parent Table | PUBL |
Child Table | PUBL_FACIL_NON_INSTR_ASSC |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"PUBL to PUBL_FACIL_NON_INSTR_ASSC" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"PUBL to PUBL_FACIL_NON_INSTR_ASSC" Foreign Keys |
Parent Key | Child Key |
PUBL_ID | PUBL_ID |
"PUBL to PUBL_FACIL_NON_INSTR_ASSC" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"PUBL to PUBL_FACIL_NON_INSTR_ASSC" Bound Attachments |
Name | Current Value |
"EXPT_FACIL to FACIL_NON_INSTR" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_FACIL_NON_INSTR_TO_FACIL |
Relationship Business Name | |
Physical Only | No |
Parent Table | EXPT_FACIL |
Child Table | FACIL_NON_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 FACIL_NON_INSTR" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EXPT_FACIL to FACIL_NON_INSTR" Foreign Keys |
Parent Key | Child Key |
FACIL_ID | FACIL_ID |
"EXPT_FACIL to FACIL_NON_INSTR" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"EXPT_FACIL to FACIL_NON_INSTR" Bound Attachments |
Name | Current Value |
"FEEDBACK_STAT to FEEDBACK" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | FK_FEED_TO_FEED_STAT |
Relationship Business Name | |
Physical Only | No |
Parent Table | FEEDBACK_STAT |
Child Table | FEEDBACK |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"FEEDBACK_STAT to FEEDBACK" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"FEEDBACK_STAT to FEEDBACK" Foreign Keys |
Parent Key | Child Key |
STAT_ID | STAT_ID |
"FEEDBACK_STAT to FEEDBACK" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"FEEDBACK_STAT to FEEDBACK" Bound Attachments |
Name | Current Value |
"INSTR to INSTR_EXCL" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_instr_excl_to_instr |
Relationship Business Name | |
Physical Only | No |
Parent Table | INSTR |
Child Table | INSTR_EXCL |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"INSTR to INSTR_EXCL" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"INSTR to INSTR_EXCL" Foreign Keys |
Parent Key | Child Key |
INSTR_ID | INSTR_ID |
"INSTR to INSTR_EXCL" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"INSTR to INSTR_EXCL" 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 |
"JOURNAL to JL_IMP_FACT" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_JL_IMP_FACT_TO_JL |
Relationship Business Name | |
Physical Only | No |
Parent Table | JOURNAL |
Child Table | JL_IMP_FACT |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"JOURNAL to JL_IMP_FACT" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"JOURNAL to JL_IMP_FACT" Foreign Keys |
Parent Key | Child Key |
JOURNAL_ID | JOURNAL_ID |
"JOURNAL to JL_IMP_FACT" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"JOURNAL to JL_IMP_FACT" 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 |
"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 |
"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 |
"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 |
"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 |
"INST to PROPOSAL" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | fk_prpsl_to_inst |
Relationship Business Name | |
Physical Only | No |
Parent Table | INST |
Child Table | PROPOSAL |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"INST to PROPOSAL" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"INST to PROPOSAL" Foreign Keys |
Parent Key | Child Key |
INST_ID | INST_ID |
"INST to PROPOSAL" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"INST to PROPOSAL" 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 |
"FACIL_NON_INSTR to PUBL_STAGE_NON_INSTR_ASSC" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_PSNIA_TO_FACIL_NON_INSTR |
Relationship Business Name | |
Physical Only | No |
Parent Table | FACIL_NON_INSTR |
Child Table | PUBL_STAGE_NON_INSTR_ASSC |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"FACIL_NON_INSTR to PUBL_STAGE_NON_INSTR_ASSC" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"FACIL_NON_INSTR to PUBL_STAGE_NON_INSTR_ASSC" Foreign Keys |
Parent Key | Child Key |
FACIL_ID, NON_INSTR_ID | FACIL_ID, NON_INSTR_ID |
"FACIL_NON_INSTR to PUBL_STAGE_NON_INSTR_ASSC" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"FACIL_NON_INSTR to PUBL_STAGE_NON_INSTR_ASSC" Bound Attachments |
Name | Current Value |
"PUBL_STAGE to PUBL_STAGE_NON_INSTR_ASSC" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_PSNIA_TO_PUBL_STAGE |
Relationship Business Name | |
Physical Only | No |
Parent Table | PUBL_STAGE |
Child Table | PUBL_STAGE_NON_INSTR_ASSC |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"PUBL_STAGE to PUBL_STAGE_NON_INSTR_ASSC" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"PUBL_STAGE to PUBL_STAGE_NON_INSTR_ASSC" Foreign Keys |
Parent Key | Child Key |
PUBL_ID | PUBL_ID |
"PUBL_STAGE to PUBL_STAGE_NON_INSTR_ASSC" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"PUBL_STAGE to PUBL_STAGE_NON_INSTR_ASSC" Bound Attachments |
Name | Current Value |
"PUBL_STAGE to PUBL_STAGE_RSCH_AREA_ASSC" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_PSRAA_TO_PUBL_STAGE |
Relationship Business Name | |
Physical Only | No |
Parent Table | PUBL_STAGE |
Child Table | PUBL_STAGE_RSCH_AREA_ASSC |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"PUBL_STAGE to PUBL_STAGE_RSCH_AREA_ASSC" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"PUBL_STAGE to PUBL_STAGE_RSCH_AREA_ASSC" Foreign Keys |
Parent Key | Child Key |
PUBL_ID | PUBL_ID |
"PUBL_STAGE to PUBL_STAGE_RSCH_AREA_ASSC" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"PUBL_STAGE to PUBL_STAGE_RSCH_AREA_ASSC" Bound Attachments |
Name | Current Value |
"PRPSL_INSTR to PUBL_PRPSL_INSTR_ASSC" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_PUB_PRP_ASSC_TO_PRP_INSTR |
Relationship Business Name | |
Physical Only | No |
Parent Table | PRPSL_INSTR |
Child Table | PUBL_PRPSL_INSTR_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 PUBL_PRPSL_INSTR_ASSC" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"PRPSL_INSTR to PUBL_PRPSL_INSTR_ASSC" Foreign Keys |
Parent Key | Child Key |
PRPSL_ID, SUBMISS_NBR, INSTR_ID | PRPSL_ID, SUBMISS_NBR, INSTR_ID |
"PRPSL_INSTR to PUBL_PRPSL_INSTR_ASSC" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"PRPSL_INSTR to PUBL_PRPSL_INSTR_ASSC" Bound Attachments |
Name | Current Value |
"PUBL_STAGE to PUBL_STAGE_INSTR_ASSC" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_PUB_ST_INS_ASSC_TO_PUB_ST |
Relationship Business Name | |
Physical Only | No |
Parent Table | PUBL_STAGE |
Child Table | PUBL_STAGE_INSTR_ASSC |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"PUBL_STAGE to PUBL_STAGE_INSTR_ASSC" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"PUBL_STAGE to PUBL_STAGE_INSTR_ASSC" Foreign Keys |
Parent Key | Child Key |
PUBL_ID | PUBL_ID |
"PUBL_STAGE to PUBL_STAGE_INSTR_ASSC" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"PUBL_STAGE to PUBL_STAGE_INSTR_ASSC" Bound Attachments |
Name | Current Value |
"INST to PUB_AUTHOR_ASSC" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | FK_PUBL_AUTH_ASSC_TO_INST |
Relationship Business Name | |
Physical Only | No |
Parent Table | INST |
Child Table | PUB_AUTHOR_ASSC |
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 PUB_AUTHOR_ASSC" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"INST to PUB_AUTHOR_ASSC" Foreign Keys |
Parent Key | Child Key |
INST_ID | INST_ID |
"INST to PUB_AUTHOR_ASSC" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"INST to PUB_AUTHOR_ASSC" Bound Attachments |
Name | Current Value |
"AUTHOR to PUB_AUTHOR_ASSC" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_PUBL_AUTHOR_TO_AUTHOR |
Relationship Business Name | |
Physical Only | No |
Parent Table | AUTHOR |
Child Table | PUB_AUTHOR_ASSC |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"AUTHOR to PUB_AUTHOR_ASSC" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"AUTHOR to PUB_AUTHOR_ASSC" Foreign Keys |
Parent Key | Child Key |
AUTHOR_ID | AUTHOR_ID |
"AUTHOR to PUB_AUTHOR_ASSC" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"AUTHOR to PUB_AUTHOR_ASSC" Bound Attachments |
Name | Current Value |
"INSTR to PUBL_INSTR_ASSC" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_PUBL_INSTR_ASSC_TO_INSTR |
Relationship Business Name | |
Physical Only | No |
Parent Table | INSTR |
Child Table | PUBL_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 PUBL_INSTR_ASSC" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"INSTR to PUBL_INSTR_ASSC" Foreign Keys |
Parent Key | Child Key |
INSTR_ID | INSTR_ID |
"INSTR to PUBL_INSTR_ASSC" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"INSTR to PUBL_INSTR_ASSC" Bound Attachments |
Name | Current Value |
"PUBL to PUBL_INSTR_ASSC" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_PUBL_INSTR_ASSC_TO_PUBL |
Relationship Business Name | |
Physical Only | No |
Parent Table | PUBL |
Child Table | PUBL_INSTR_ASSC |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"PUBL to PUBL_INSTR_ASSC" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"PUBL to PUBL_INSTR_ASSC" Foreign Keys |
Parent Key | Child Key |
PUBL_ID | PUBL_ID |
"PUBL to PUBL_INSTR_ASSC" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"PUBL to PUBL_INSTR_ASSC" Bound Attachments |
Name | Current Value |
"PUBL to PUBL_LOG" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_PUBL_LOG_TO_PUBL |
Relationship Business Name | |
Physical Only | No |
Parent Table | PUBL |
Child Table | PUBL_LOG |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"PUBL to PUBL_LOG" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"PUBL to PUBL_LOG" Foreign Keys |
Parent Key | Child Key |
PUBL_ID | PUBL_ID |
"PUBL to PUBL_LOG" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"PUBL to PUBL_LOG" Bound Attachments |
Name | Current Value |
"PUBL_ACT to PUBL_LOG" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_PUBL_LOG_TO_PUBL_ACT |
Relationship Business Name | |
Physical Only | No |
Parent Table | PUBL_ACT |
Child Table | PUBL_LOG |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"PUBL_ACT to PUBL_LOG" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"PUBL_ACT to PUBL_LOG" Foreign Keys |
Parent Key | Child Key |
ACT_ID | ACT_ID |
"PUBL_ACT to PUBL_LOG" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"PUBL_ACT to PUBL_LOG" Bound Attachments |
Name | Current Value |
"PUBL to PUBL_PRPSL_INSTR_ASSC" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_PUBL_PRPSL_ASSC_TO_PUBL |
Relationship Business Name | |
Physical Only | No |
Parent Table | PUBL |
Child Table | PUBL_PRPSL_INSTR_ASSC |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"PUBL to PUBL_PRPSL_INSTR_ASSC" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"PUBL to PUBL_PRPSL_INSTR_ASSC" Foreign Keys |
Parent Key | Child Key |
PUBL_ID | PUBL_ID |
"PUBL to PUBL_PRPSL_INSTR_ASSC" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"PUBL to PUBL_PRPSL_INSTR_ASSC" Bound Attachments |
Name | Current Value |
"PUBL to PUBL_RSCH_AREA_ASSC" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_PUBL_RSCH_AREA_ASSC_TO_PUBL |
Relationship Business Name | |
Physical Only | No |
Parent Table | PUBL |
Child Table | PUBL_RSCH_AREA_ASSC |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"PUBL to PUBL_RSCH_AREA_ASSC" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"PUBL to PUBL_RSCH_AREA_ASSC" Foreign Keys |
Parent Key | Child Key |
PUBL_ID | PUBL_ID |
"PUBL to PUBL_RSCH_AREA_ASSC" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"PUBL to PUBL_RSCH_AREA_ASSC" Bound Attachments |
Name | Current Value |
"PUBL to PUBL_SPEC_RECOG_ASSC" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_PUBL_SR_ASSC_TO_PUBL |
Relationship Business Name | |
Physical Only | No |
Parent Table | PUBL |
Child Table | PUBL_SPEC_RECOG_ASSC |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"PUBL to PUBL_SPEC_RECOG_ASSC" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"PUBL to PUBL_SPEC_RECOG_ASSC" Foreign Keys |
Parent Key | Child Key |
PUBL_ID | PUBL_ID |
"PUBL to PUBL_SPEC_RECOG_ASSC" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"PUBL to PUBL_SPEC_RECOG_ASSC" Bound Attachments |
Name | Current Value |
"SPEC_RECOG to PUBL_SPEC_RECOG_ASSC" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_PUBL_SR_ASSC_TO_SPEC_RECOG |
Relationship Business Name | |
Physical Only | No |
Parent Table | SPEC_RECOG |
Child Table | PUBL_SPEC_RECOG_ASSC |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"SPEC_RECOG to PUBL_SPEC_RECOG_ASSC" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"SPEC_RECOG to PUBL_SPEC_RECOG_ASSC" Foreign Keys |
Parent Key | Child Key |
SPEC_RECOG_ID | SPEC_RECOG_ID |
"SPEC_RECOG to PUBL_SPEC_RECOG_ASSC" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"SPEC_RECOG to PUBL_SPEC_RECOG_ASSC" Bound Attachments |
Name | Current Value |
"INSTR to PUBL_STAGE_INSTR_ASSC" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_PUBL_ST_INSTR_ASSC_TO_INSTR |
Relationship Business Name | |
Physical Only | No |
Parent Table | INSTR |
Child Table | PUBL_STAGE_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 PUBL_STAGE_INSTR_ASSC" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"INSTR to PUBL_STAGE_INSTR_ASSC" Foreign Keys |
Parent Key | Child Key |
INSTR_ID | INSTR_ID |
"INSTR to PUBL_STAGE_INSTR_ASSC" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"INSTR to PUBL_STAGE_INSTR_ASSC" Bound Attachments |
Name | Current Value |
"CONF to PUBL_STAGE" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | FK_PUBL_STAGE_TO_CONF |
Relationship Business Name | |
Physical Only | No |
Parent Table | CONF |
Child Table | PUBL_STAGE |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"CONF to PUBL_STAGE" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"CONF to PUBL_STAGE" Foreign Keys |
Parent Key | Child Key |
CONF_ID | CONF_ID |
"CONF to PUBL_STAGE" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"CONF to PUBL_STAGE" Bound Attachments |
Name | Current Value |
"INST to PUBL_STAGE" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | FK_PUBL_STAGE_TO_INST |
Relationship Business Name | |
Physical Only | No |
Parent Table | INST |
Child Table | PUBL_STAGE |
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 PUBL_STAGE" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"INST to PUBL_STAGE" Foreign Keys |
Parent Key | Child Key |
INST_ID | INST_ID |
"INST to PUBL_STAGE" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"INST to PUBL_STAGE" Bound Attachments |
Name | Current Value |
"JOURNAL to PUBL_STAGE" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | FK_PUBL_STAGE_TO_JOURNAL |
Relationship Business Name | |
Physical Only | No |
Parent Table | JOURNAL |
Child Table | PUBL_STAGE |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"JOURNAL to PUBL_STAGE" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"JOURNAL to PUBL_STAGE" Foreign Keys |
Parent Key | Child Key |
JOURNAL_ID | JOURNAL_ID |
"JOURNAL to PUBL_STAGE" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"JOURNAL to PUBL_STAGE" Bound Attachments |
Name | Current Value |
"PUBL_TYPE to PUBL_STAGE" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | FK_PUBL_STAGE_TO_PUBL_TYPE |
Relationship Business Name | |
Physical Only | No |
Parent Table | PUBL_TYPE |
Child Table | PUBL_STAGE |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"PUBL_TYPE to PUBL_STAGE" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"PUBL_TYPE to PUBL_STAGE" Foreign Keys |
Parent Key | Child Key |
PUBL_TYPE_ID | PUBL_TYPE_ID |
"PUBL_TYPE to PUBL_STAGE" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"PUBL_TYPE to PUBL_STAGE" Bound Attachments |
Name | Current Value |
"CONF to PUBL" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | FK_PUBL_TO_CONF |
Relationship Business Name | |
Physical Only | No |
Parent Table | CONF |
Child Table | PUBL |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"CONF to PUBL" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"CONF to PUBL" Foreign Keys |
Parent Key | Child Key |
CONF_ID | CONF_ID |
"CONF to PUBL" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"CONF to PUBL" Bound Attachments |
Name | Current Value |
"CONF_PROCEED to PUBL" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | FK_PUBL_TO_CONF_PROCEED |
Relationship Business Name | |
Physical Only | No |
Parent Table | CONF_PROCEED |
Child Table | PUBL |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"CONF_PROCEED to PUBL" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"CONF_PROCEED to PUBL" Foreign Keys |
Parent Key | Child Key |
CONF_ID, PROCEED_ID | CONF_ID, PROCEED_ID |
"CONF_PROCEED to PUBL" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"CONF_PROCEED to PUBL" Bound Attachments |
Name | Current Value |
"INST to PUBL" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | FK_PUBL_TO_INST |
Relationship Business Name | |
Physical Only | No |
Parent Table | INST |
Child Table | PUBL |
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 PUBL" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"INST to PUBL" Foreign Keys |
Parent Key | Child Key |
INST_ID | INST_ID |
"INST to PUBL" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"INST to PUBL" Bound Attachments |
Name | Current Value |
"JOURNAL to PUBL" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | FK_PUBL_TO_JOURNAL |
Relationship Business Name | |
Physical Only | No |
Parent Table | JOURNAL |
Child Table | PUBL |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"JOURNAL to PUBL" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"JOURNAL to PUBL" Foreign Keys |
Parent Key | Child Key |
JOURNAL_ID | JOURNAL_ID |
"JOURNAL to PUBL" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"JOURNAL to PUBL" Bound Attachments |
Name | Current Value |
"PUBL to PUB_AUTHOR_ASSC" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_PUBL_TO_PUBL_AUTHOR |
Relationship Business Name | |
Physical Only | No |
Parent Table | PUBL |
Child Table | PUB_AUTHOR_ASSC |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"PUBL to PUB_AUTHOR_ASSC" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"PUBL to PUB_AUTHOR_ASSC" Foreign Keys |
Parent Key | Child Key |
PUBL_ID | PUBL_ID |
"PUBL to PUB_AUTHOR_ASSC" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"PUBL to PUB_AUTHOR_ASSC" Bound Attachments |
Name | Current Value |
"PUBL_TYPE to PUBL" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | FK_PUBL_TO_PUBL_TYPE |
Relationship Business Name | |
Physical Only | No |
Parent Table | PUBL_TYPE |
Child Table | PUBL |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"PUBL_TYPE to PUBL" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"PUBL_TYPE to PUBL" Foreign Keys |
Parent Key | Child Key |
PUBL_TYPE_ID | PUBL_TYPE_ID |
"PUBL_TYPE to PUBL" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"PUBL_TYPE to PUBL" Bound Attachments |
Name | Current Value |
"STATUS to PUBL" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | FK_PUBL_TO_STATUS |
Relationship Business Name | |
Physical Only | No |
Parent Table | STATUS |
Child Table | PUBL |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"STATUS to PUBL" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"STATUS to PUBL" Foreign Keys |
Parent Key | Child Key |
STAT_ID | STAT_ID |
"STATUS to PUBL" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"STATUS to PUBL" Bound Attachments |
Name | Current Value |