"PERSON to PRPSL_SUGG_REV" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | |
Relationship Business Name | |
Physical Only | No |
Parent Table | PERSON |
Child Table | PRPSL_SUGG_REV |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"PERSON to PRPSL_SUGG_REV" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"PERSON to PRPSL_SUGG_REV" Foreign Keys |
Parent Key | Child Key |
PERSON_ID | PERSON_ID |
"PERSON to PRPSL_SUGG_REV" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"PERSON to PRPSL_SUGG_REV" Bound Attachments |
Name | Current Value |
"PROPOSAL to ADDNL_REV" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_addnl_rev_to_proposal |
Relationship Business Name | |
Physical Only | No |
Parent Table | PROPOSAL |
Child Table | ADDNL_REV |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"PROPOSAL to ADDNL_REV" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"PROPOSAL to ADDNL_REV" Foreign Keys |
Parent Key | Child Key |
PRPSL_ID | PRPSL_ID |
"PROPOSAL to ADDNL_REV" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"PROPOSAL to ADDNL_REV" Bound Attachments |
Name | Current Value |
"PROPOSAL to EMAIL_PREV" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | fk_email_prev_to_prpsl |
Relationship Business Name | |
Physical Only | No |
Parent Table | PROPOSAL |
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 |
"PROPOSAL to EMAIL_PREV" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"PROPOSAL to EMAIL_PREV" Foreign Keys |
Parent Key | Child Key |
PRPSL_ID | PROPOSAL_PRPSL_ID |
"PROPOSAL to EMAIL_PREV" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"PROPOSAL to EMAIL_PREV" Bound Attachments |
Name | Current Value |
"EMAIL_TEMPLATE to EMAIL_SENT" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_email_sent_to_email_tmpl |
Relationship Business Name | |
Physical Only | No |
Parent Table | EMAIL_TEMPLATE |
Child Table | EMAIL_SENT |
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_SENT" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EMAIL_TEMPLATE to EMAIL_SENT" Foreign Keys |
Parent Key | Child Key |
TEMPLATE_ID | TEMPLATE_ID |
"EMAIL_TEMPLATE to EMAIL_SENT" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"EMAIL_TEMPLATE to EMAIL_SENT" Bound Attachments |
Name | Current Value |
"EMAIL_TEMPLATE to EMAIL_PREV" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_email_template_to_email_prev |
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 |
"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 |
"PRPSL_ACT to EMAIL_TEMPLATE" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | fk_email_tmpl_to_proposal_act |
Relationship Business Name | |
Physical Only | No |
Parent Table | PRPSL_ACT |
Child Table | EMAIL_TEMPLATE |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"PRPSL_ACT to EMAIL_TEMPLATE" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"PRPSL_ACT to EMAIL_TEMPLATE" Foreign Keys |
Parent Key | Child Key |
ACT_ID | ACT_ID |
"PRPSL_ACT to EMAIL_TEMPLATE" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"PRPSL_ACT to EMAIL_TEMPLATE" Bound Attachments |
Name | Current Value |
"PERSON to PRPSL_FEAS_REV" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_feas_rev_to_person |
Relationship Business Name | |
Physical Only | No |
Parent Table | PERSON |
Child Table | PRPSL_FEAS_REV |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"PERSON to PRPSL_FEAS_REV" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"PERSON to PRPSL_FEAS_REV" Foreign Keys |
Parent Key | Child Key |
PERSON_ID | PERSON_ID |
"PERSON to PRPSL_FEAS_REV" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"PERSON to PRPSL_FEAS_REV" Bound Attachments |
Name | Current Value |
"PROPOSAL to PRPSL_FEAS_REV" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_feas_rev_to_prpsl |
Relationship Business Name | |
Physical Only | No |
Parent Table | PROPOSAL |
Child Table | PRPSL_FEAS_REV |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"PROPOSAL to PRPSL_FEAS_REV" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"PROPOSAL to PRPSL_FEAS_REV" Foreign Keys |
Parent Key | Child Key |
PRPSL_ID | PRPSL_ID |
"PROPOSAL to PRPSL_FEAS_REV" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"PROPOSAL to PRPSL_FEAS_REV" Bound Attachments |
Name | Current Value |
"PERSON to GRP_LEAD_RSCH_CAPBLTY_ASSC" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_grp_lead_to_person |
Relationship Business Name | |
Physical Only | No |
Parent Table | PERSON |
Child Table | GRP_LEAD_RSCH_CAPBLTY_ASSC |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"PERSON to GRP_LEAD_RSCH_CAPBLTY_ASSC" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"PERSON to GRP_LEAD_RSCH_CAPBLTY_ASSC" Foreign Keys |
Parent Key | Child Key |
PERSON_ID | PERSON_ID |
"PERSON to GRP_LEAD_RSCH_CAPBLTY_ASSC" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"PERSON to GRP_LEAD_RSCH_CAPBLTY_ASSC" Bound Attachments |
Name | Current Value |
"RSCH_CAPBLTY to GRP_LEAD_RSCH_CAPBLTY_ASSC" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_grp_lead_to_rsch_capblty |
Relationship Business Name | |
Physical Only | No |
Parent Table | RSCH_CAPBLTY |
Child Table | GRP_LEAD_RSCH_CAPBLTY_ASSC |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"RSCH_CAPBLTY to GRP_LEAD_RSCH_CAPBLTY_ASSC" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"RSCH_CAPBLTY to GRP_LEAD_RSCH_CAPBLTY_ASSC" Foreign Keys |
Parent Key | Child Key |
RSCH_CAP_ID | RSCH_CAP_ID |
"RSCH_CAPBLTY to GRP_LEAD_RSCH_CAPBLTY_ASSC" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"RSCH_CAPBLTY to GRP_LEAD_RSCH_CAPBLTY_ASSC" Bound Attachments |
Name | Current Value |
"RSCH_CAPBLTY to INSTR" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | fk_instr_to_resh_cap |
Relationship Business Name | |
Physical Only | No |
Parent Table | RSCH_CAPBLTY |
Child Table | INSTR |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"RSCH_CAPBLTY to INSTR" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"RSCH_CAPBLTY to INSTR" Foreign Keys |
Parent Key | Child Key |
RSCH_CAP_ID | RSCH_CAP_ID |
"RSCH_CAPBLTY to INSTR" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"RSCH_CAPBLTY to INSTR" Bound Attachments |
Name | Current Value |
"CUPS_ACT to CUPS_LOG" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_ipts_log_to_ipts_act_1 |
Relationship Business Name | |
Physical Only | No |
Parent Table | CUPS_ACT |
Child Table | CUPS_LOG |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"CUPS_ACT to CUPS_LOG" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"CUPS_ACT to CUPS_LOG" Foreign Keys |
Parent Key | Child Key |
ACT_ID | ACT_ID |
"CUPS_ACT to CUPS_LOG" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"CUPS_ACT to CUPS_LOG" Bound Attachments |
Name | Current Value |
"MBR_ROLE to NONVAL_EXPT_TEAM_MBR" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | fk_netm_to_mbr_role |
Relationship Business Name | |
Physical Only | No |
Parent Table | MBR_ROLE |
Child Table | NONVAL_EXPT_TEAM_MBR |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"MBR_ROLE to NONVAL_EXPT_TEAM_MBR" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"MBR_ROLE to NONVAL_EXPT_TEAM_MBR" Foreign Keys |
Parent Key | Child Key |
MBR_ROLE_ID | MBR_ROLE_ID |
"MBR_ROLE to NONVAL_EXPT_TEAM_MBR" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"MBR_ROLE to NONVAL_EXPT_TEAM_MBR" Bound Attachments |
Name | Current Value |
"PROPOSAL to NONVAL_EXPT_TEAM_MBR" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_netm_to_proposal |
Relationship Business Name | |
Physical Only | No |
Parent Table | PROPOSAL |
Child Table | NONVAL_EXPT_TEAM_MBR |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"PROPOSAL to NONVAL_EXPT_TEAM_MBR" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"PROPOSAL to NONVAL_EXPT_TEAM_MBR" Foreign Keys |
Parent Key | Child Key |
PRPSL_ID | PRPSL_ID |
"PROPOSAL to NONVAL_EXPT_TEAM_MBR" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"PROPOSAL to NONVAL_EXPT_TEAM_MBR" Bound Attachments |
Name | Current Value |
"PROPOSAL to PRPSL_SUGG_REV" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_p_sugg_rev_to_proposal |
Relationship Business Name | |
Physical Only | No |
Parent Table | PROPOSAL |
Child Table | PRPSL_SUGG_REV |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"PROPOSAL to PRPSL_SUGG_REV" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"PROPOSAL to PRPSL_SUGG_REV" Foreign Keys |
Parent Key | Child Key |
PRPSL_ID | PRPSL_ID |
"PROPOSAL to PRPSL_SUGG_REV" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"PROPOSAL to PRPSL_SUGG_REV" Bound Attachments |
Name | Current Value |
"DESC_RSCH to PRPSL_DESC_RSCH_ASSC" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_pdora_to_desc_rsch |
Relationship Business Name | |
Physical Only | No |
Parent Table | DESC_RSCH |
Child Table | PRPSL_DESC_RSCH_ASSC |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"DESC_RSCH to PRPSL_DESC_RSCH_ASSC" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"DESC_RSCH to PRPSL_DESC_RSCH_ASSC" Foreign Keys |
Parent Key | Child Key |
DESC_RSCH_ID | DESC_RSCH_ID |
"DESC_RSCH to PRPSL_DESC_RSCH_ASSC" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"DESC_RSCH to PRPSL_DESC_RSCH_ASSC" Bound Attachments |
Name | Current Value |
"PROPOSAL to PRPSL_DESC_RSCH_ASSC" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_pdora_to_prpsl |
Relationship Business Name | |
Physical Only | No |
Parent Table | PROPOSAL |
Child Table | PRPSL_DESC_RSCH_ASSC |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"PROPOSAL to PRPSL_DESC_RSCH_ASSC" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"PROPOSAL to PRPSL_DESC_RSCH_ASSC" Foreign Keys |
Parent Key | Child Key |
PRPSL_ID | PRPSL_ID |
"PROPOSAL to PRPSL_DESC_RSCH_ASSC" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"PROPOSAL to PRPSL_DESC_RSCH_ASSC" 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 |
"PROPOSAL to PRPSL_RSCH_AREA" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_pra_to_proposal |
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 |
"PERSON to PRPSL_REV_COMM" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | fk_prc_tech_cont_to_person |
Relationship Business Name | |
Physical Only | No |
Parent Table | PERSON |
Child Table | PRPSL_REV_COMM |
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_REV_COMM" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"PERSON to PRPSL_REV_COMM" Foreign Keys |
Parent Key | Child Key |
PERSON_ID | TECH_CONT_PERSON_ID |
"PERSON to PRPSL_REV_COMM" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"PERSON to PRPSL_REV_COMM" Bound Attachments |
Name | Current Value |
"EMPLOYEE to PRPSL_REV_COMM" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | fk_prc_to_employee |
Relationship Business Name | |
Physical Only | No |
Parent Table | EMPLOYEE |
Child Table | PRPSL_REV_COMM |
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 PRPSL_REV_COMM" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EMPLOYEE to PRPSL_REV_COMM" Foreign Keys |
Parent Key | Child Key |
Bn | PAS_HOST_BN |
"EMPLOYEE to PRPSL_REV_COMM" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"EMPLOYEE to PRPSL_REV_COMM" Bound Attachments |
Name | Current Value |
"USER_ACESS_MODE to PRPSL_REV_COMM" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | fk_prc_to_usr_acc_mode |
Relationship Business Name | |
Physical Only | No |
Parent Table | USER_ACESS_MODE |
Child Table | PRPSL_REV_COMM |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"USER_ACESS_MODE to PRPSL_REV_COMM" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"USER_ACESS_MODE to PRPSL_REV_COMM" Foreign Keys |
Parent Key | Child Key |
USER_ACCESS_ID | USER_ACCESS_ID |
"USER_ACESS_MODE to PRPSL_REV_COMM" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"USER_ACESS_MODE to PRPSL_REV_COMM" Bound Attachments |
Name | Current Value |
"EXPT_CYCLE to PROPOSAL" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | fk_proposal_to_expt_cycle |
Relationship Business Name | |
Physical Only | No |
Parent Table | EXPT_CYCLE |
Child Table | PROPOSAL |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"EXPT_CYCLE to PROPOSAL" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EXPT_CYCLE to PROPOSAL" Foreign Keys |
Parent Key | Child Key |
CY_ID | CY_ID |
"EXPT_CYCLE to PROPOSAL" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"EXPT_CYCLE to PROPOSAL" Bound Attachments |
Name | Current Value |
"INST to PROPOSAL" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | fk_proposal_to_institute |
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_proposal_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 |
"PRPSL_CAT to PROPOSAL" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | fk_proposal_to_prpsl_cat |
Relationship Business Name | |
Physical Only | No |
Parent Table | PRPSL_CAT |
Child Table | PROPOSAL |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"PRPSL_CAT to PROPOSAL" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"PRPSL_CAT to PROPOSAL" Foreign Keys |
Parent Key | Child Key |
PRPSL_CAT_ID | PRPSL_CAT_ID |
"PRPSL_CAT to PROPOSAL" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"PRPSL_CAT to PROPOSAL" Bound Attachments |
Name | Current Value |
"PRPSL_STAT to PROPOSAL" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | fk_proposal_to_prpsl_stat |
Relationship Business Name | |
Physical Only | No |
Parent Table | PRPSL_STAT |
Child Table | PROPOSAL |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"PRPSL_STAT to PROPOSAL" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"PRPSL_STAT to PROPOSAL" Foreign Keys |
Parent Key | Child Key |
STAT_ID | STAT_ID |
"PRPSL_STAT to PROPOSAL" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"PRPSL_STAT to PROPOSAL" Bound Attachments |
Name | Current Value |
"PERSON to PRPSL_ROLE_PERS_ASSC" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_prpa_to_person |
Relationship Business Name | |
Physical Only | No |
Parent Table | PERSON |
Child Table | PRPSL_ROLE_PERS_ASSC |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"PERSON to PRPSL_ROLE_PERS_ASSC" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"PERSON to PRPSL_ROLE_PERS_ASSC" Foreign Keys |
Parent Key | Child Key |
PERSON_ID | PERSON_ID |
"PERSON to PRPSL_ROLE_PERS_ASSC" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"PERSON to PRPSL_ROLE_PERS_ASSC" Bound Attachments |
Name | Current Value |
"PRPSL_ROLE to PRPSL_ROLE_PERS_ASSC" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_prpa_to_prpsl_role |
Relationship Business Name | |
Physical Only | No |
Parent Table | PRPSL_ROLE |
Child Table | PRPSL_ROLE_PERS_ASSC |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"PRPSL_ROLE to PRPSL_ROLE_PERS_ASSC" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"PRPSL_ROLE to PRPSL_ROLE_PERS_ASSC" Foreign Keys |
Parent Key | Child Key |
ROLE_ID | ROLE_ID |
"PRPSL_ROLE to PRPSL_ROLE_PERS_ASSC" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"PRPSL_ROLE to PRPSL_ROLE_PERS_ASSC" Bound Attachments |
Name | Current Value |
"PRPSL_FUND_STAT to PRPSL_FUND_AGCY" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_prpsl_fund_agcy_to_fund_stat |
Relationship Business Name | |
Physical Only | No |
Parent Table | PRPSL_FUND_STAT |
Child Table | PRPSL_FUND_AGCY |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"PRPSL_FUND_STAT to PRPSL_FUND_AGCY" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"PRPSL_FUND_STAT to PRPSL_FUND_AGCY" Foreign Keys |
Parent Key | Child Key |
PRPSL_ID, FUND_STAT_ID | PRPSL_ID, FUND_STAT_ID |
"PRPSL_FUND_STAT to PRPSL_FUND_AGCY" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"PRPSL_FUND_STAT to PRPSL_FUND_AGCY" Bound Attachments |
Name | Current Value |
"CNTRY to PRPSL_FUND_CNTRY" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_prpsl_fund_cntry_to_cntry |
Relationship Business Name | |
Physical Only | No |
Parent Table | CNTRY |
Child Table | PRPSL_FUND_CNTRY |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"CNTRY to PRPSL_FUND_CNTRY" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"CNTRY to PRPSL_FUND_CNTRY" Foreign Keys |
Parent Key | Child Key |
CNTRY_ID | CNTRY_ID |
"CNTRY to PRPSL_FUND_CNTRY" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"CNTRY to PRPSL_FUND_CNTRY" Bound Attachments |
Name | Current Value |
"PRPSL_FUND to PRPSL_FUND_CNTRY" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_prpsl_fund_cntry_to_prpsl_fund |
Relationship Business Name | |
Physical Only | No |
Parent Table | PRPSL_FUND |
Child Table | PRPSL_FUND_CNTRY |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"PRPSL_FUND to PRPSL_FUND_CNTRY" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"PRPSL_FUND to PRPSL_FUND_CNTRY" Foreign Keys |
Parent Key | Child Key |
PRPSL_ID, FUND_ID | PRPSL_ID, FUND_ID |
"PRPSL_FUND to PRPSL_FUND_CNTRY" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"PRPSL_FUND to PRPSL_FUND_CNTRY" Bound Attachments |
Name | Current Value |
"FUND_STAT to PRPSL_FUND_STAT" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_prpsl_fund_st_to_fund_st |
Relationship Business Name | |
Physical Only | No |
Parent Table | FUND_STAT |
Child Table | PRPSL_FUND_STAT |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"FUND_STAT to PRPSL_FUND_STAT" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"FUND_STAT to PRPSL_FUND_STAT" Foreign Keys |
Parent Key | Child Key |
FUND_STAT_ID | FUND_STAT_ID |
"FUND_STAT to PRPSL_FUND_STAT" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"FUND_STAT to PRPSL_FUND_STAT" Bound Attachments |
Name | Current Value |
"PROPOSAL to PRPSL_FUND_STAT" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_prpsl_fund_stat_to_prpsl |
Relationship Business Name | |
Physical Only | No |
Parent Table | PROPOSAL |
Child Table | PRPSL_FUND_STAT |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"PROPOSAL to PRPSL_FUND_STAT" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"PROPOSAL to PRPSL_FUND_STAT" Foreign Keys |
Parent Key | Child Key |
PRPSL_ID | PRPSL_ID |
"PROPOSAL to PRPSL_FUND_STAT" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"PROPOSAL to PRPSL_FUND_STAT" Bound Attachments |
Name | Current Value |
"FUND_SRC to PRPSL_FUND" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_prpsl_fund_to_fund_src |
Relationship Business Name | |
Physical Only | No |
Parent Table | FUND_SRC |
Child Table | PRPSL_FUND |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"FUND_SRC to PRPSL_FUND" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"FUND_SRC to PRPSL_FUND" Foreign Keys |
Parent Key | Child Key |
FUND_ID | FUND_ID |
"FUND_SRC to PRPSL_FUND" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"FUND_SRC to PRPSL_FUND" Bound Attachments |
Name | Current Value |
"PROPOSAL to PRPSL_FUND" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_prpsl_fund_to_proposal |
Relationship Business Name | |
Physical Only | No |
Parent Table | PROPOSAL |
Child Table | PRPSL_FUND |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"PROPOSAL to PRPSL_FUND" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"PROPOSAL to PRPSL_FUND" Foreign Keys |
Parent Key | Child Key |
PRPSL_ID | PRPSL_ID |
"PROPOSAL to PRPSL_FUND" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"PROPOSAL to PRPSL_FUND" Bound Attachments |
Name | Current Value |
"INSTR to PRPSL_INSTR_ASSC" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_prpsl_instr_assc_to_instr |
Relationship Business Name | |
Physical Only | No |
Parent Table | INSTR |
Child Table | PRPSL_INSTR_ASSC |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"INSTR to PRPSL_INSTR_ASSC" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"INSTR to PRPSL_INSTR_ASSC" Foreign Keys |
Parent Key | Child Key |
INSTR_ID | INSTR_ID |
"INSTR to PRPSL_INSTR_ASSC" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"INSTR to PRPSL_INSTR_ASSC" Bound Attachments |
Name | Current Value |
"PROPOSAL to PRPSL_INSTR_ASSC" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_prpsl_instr_assc_to_prpsl |
Relationship Business Name | |
Physical Only | No |
Parent Table | PROPOSAL |
Child Table | PRPSL_INSTR_ASSC |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"PROPOSAL to PRPSL_INSTR_ASSC" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"PROPOSAL to PRPSL_INSTR_ASSC" Foreign Keys |
Parent Key | Child Key |
PRPSL_ID | PRPSL_ID |
"PROPOSAL to PRPSL_INSTR_ASSC" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"PROPOSAL to PRPSL_INSTR_ASSC" Bound Attachments |
Name | Current Value |
"PROPOSAL to PRPSL_LOG" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_prpsl_log_to_prpsl |
Relationship Business Name | |
Physical Only | No |
Parent Table | PROPOSAL |
Child Table | PRPSL_LOG |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"PROPOSAL to PRPSL_LOG" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"PROPOSAL to PRPSL_LOG" Foreign Keys |
Parent Key | Child Key |
PRPSL_ID | PRPSL_ID |
"PROPOSAL to PRPSL_LOG" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"PROPOSAL to PRPSL_LOG" Bound Attachments |
Name | Current Value |
"PRPSL_ACT to PRPSL_LOG" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_prpsl_log_to_prpsl_act |
Relationship Business Name | |
Physical Only | No |
Parent Table | PRPSL_ACT |
Child Table | PRPSL_LOG |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"PRPSL_ACT to PRPSL_LOG" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"PRPSL_ACT to PRPSL_LOG" Foreign Keys |
Parent Key | Child Key |
ACT_ID | ACT_ID |
"PRPSL_ACT to PRPSL_LOG" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"PRPSL_ACT to PRPSL_LOG" Bound Attachments |
Name | Current Value |
"CONTENT_TYPE to PRPSL_PDF" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_prpsl_pdf_to_content_type |
Relationship Business Name | |
Physical Only | No |
Parent Table | CONTENT_TYPE |
Child Table | PRPSL_PDF |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"CONTENT_TYPE to PRPSL_PDF" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"CONTENT_TYPE to PRPSL_PDF" Foreign Keys |
Parent Key | Child Key |
CONTENT_ID | CONTENT_ID |
"CONTENT_TYPE to PRPSL_PDF" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"CONTENT_TYPE to PRPSL_PDF" Bound Attachments |
Name | Current Value |
"PROPOSAL to PRPSL_PDF" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_prpsl_pdf_to_prpsl |
Relationship Business Name | |
Physical Only | No |
Parent Table | PROPOSAL |
Child Table | PRPSL_PDF |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"PROPOSAL to PRPSL_PDF" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"PROPOSAL to PRPSL_PDF" Foreign Keys |
Parent Key | Child Key |
PRPSL_ID | PRPSL_ID |
"PROPOSAL to PRPSL_PDF" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"PROPOSAL to PRPSL_PDF" Bound Attachments |
Name | Current Value |
"PERSON to PRPSL_REV_COMM" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_prpsl_rev_comm_to_person |
Relationship Business Name | |
Physical Only | No |
Parent Table | PERSON |
Child Table | PRPSL_REV_COMM |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"PERSON to PRPSL_REV_COMM" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"PERSON to PRPSL_REV_COMM" Foreign Keys |
Parent Key | Child Key |
PERSON_ID | PERSON_ID |
"PERSON to PRPSL_REV_COMM" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"PERSON to PRPSL_REV_COMM" Bound Attachments |
Name | Current Value |
"PROPOSAL to PRPSL_REV_COMM" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_prpsl_rev_comm_to_prpsl |
Relationship Business Name | |
Physical Only | No |
Parent Table | PROPOSAL |
Child Table | PRPSL_REV_COMM |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"PROPOSAL to PRPSL_REV_COMM" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"PROPOSAL to PRPSL_REV_COMM" Foreign Keys |
Parent Key | Child Key |
PRPSL_ID | PRPSL_ID |
"PROPOSAL to PRPSL_REV_COMM" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"PROPOSAL to PRPSL_REV_COMM" Bound Attachments |
Name | Current Value |
"RSCH_AREA to PRPSL_RSCH_AREA" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_prpsl_rsch_area_to_prpsl_rsch_area |
Relationship Business Name | |
Physical Only | No |
Parent Table | RSCH_AREA |
Child Table | PRPSL_RSCH_AREA |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"RSCH_AREA to PRPSL_RSCH_AREA" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"RSCH_AREA to PRPSL_RSCH_AREA" Foreign Keys |
Parent Key | Child Key |
RSCH_AREA_ID | RSCH_AREA_ID |
"RSCH_AREA to PRPSL_RSCH_AREA" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"RSCH_AREA to PRPSL_RSCH_AREA" Bound Attachments |
Name | Current Value |
"PERSON to PRPSL_SCI_REV" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_prpsl_sci_rev_to_person |
Relationship Business Name | |
Physical Only | No |
Parent Table | PERSON |
Child Table | PRPSL_SCI_REV |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"PERSON to PRPSL_SCI_REV" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"PERSON to PRPSL_SCI_REV" Foreign Keys |
Parent Key | Child Key |
PERSON_ID | PERSON_ID |
"PERSON to PRPSL_SCI_REV" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"PERSON to PRPSL_SCI_REV" Bound Attachments |
Name | Current Value |
"PRPSL_SCI_REV to PRPSL_REV_COMM" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | fk_prpsl_sci_rev_to_prpsl_rev_comm |
Relationship Business Name | |
Physical Only | No |
Parent Table | PRPSL_SCI_REV |
Child Table | PRPSL_REV_COMM |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"PRPSL_SCI_REV to PRPSL_REV_COMM" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"PRPSL_SCI_REV to PRPSL_REV_COMM" Foreign Keys |
Parent Key | Child Key |
PRPSL_ID, PERSON_ID | PRPSL_ID, PERSON_ID |
"PRPSL_SCI_REV to PRPSL_REV_COMM" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"PRPSL_SCI_REV to PRPSL_REV_COMM" Bound Attachments |
Name | Current Value |
"PERSON to PRPSL_STAFF_CONT" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_prpsl_staff_cont_to_pers |
Relationship Business Name | |
Physical Only | No |
Parent Table | PERSON |
Child Table | PRPSL_STAFF_CONT |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"PERSON to PRPSL_STAFF_CONT" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"PERSON to PRPSL_STAFF_CONT" Foreign Keys |
Parent Key | Child Key |
PERSON_ID | PERSON_ID |
"PERSON to PRPSL_STAFF_CONT" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"PERSON to PRPSL_STAFF_CONT" Bound Attachments |
Name | Current Value |
"PROPOSAL to PRPSL_STAFF_CONT" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_prpsl_staff_cont_to_prpsl |
Relationship Business Name | |
Physical Only | No |
Parent Table | PROPOSAL |
Child Table | PRPSL_STAFF_CONT |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"PROPOSAL to PRPSL_STAFF_CONT" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"PROPOSAL to PRPSL_STAFF_CONT" Foreign Keys |
Parent Key | Child Key |
PRPSL_ID | PRPSL_ID |
"PROPOSAL to PRPSL_STAFF_CONT" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"PROPOSAL to PRPSL_STAFF_CONT" Bound Attachments |
Name | Current Value |
"PERSON to PRPSL_TECH_CONT" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_prpsl_tech_cont_to_person |
Relationship Business Name | |
Physical Only | No |
Parent Table | PERSON |
Child Table | PRPSL_TECH_CONT |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"PERSON to PRPSL_TECH_CONT" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"PERSON to PRPSL_TECH_CONT" Foreign Keys |
Parent Key | Child Key |
PERSON_ID | PERSON_ID |
"PERSON to PRPSL_TECH_CONT" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"PERSON to PRPSL_TECH_CONT" Bound Attachments |
Name | Current Value |
"PROPOSAL to PRPSL_TECH_CONT" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_prpsl_tech_cont_to_prpsl |
Relationship Business Name | |
Physical Only | No |
Parent Table | PROPOSAL |
Child Table | PRPSL_TECH_CONT |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"PROPOSAL to PRPSL_TECH_CONT" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"PROPOSAL to PRPSL_TECH_CONT" Foreign Keys |
Parent Key | Child Key |
PRPSL_ID | PRPSL_ID |
"PROPOSAL to PRPSL_TECH_CONT" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"PROPOSAL to PRPSL_TECH_CONT" Bound Attachments |
Name | Current Value |
"USER_ACESS_MODE to PROPOSAL" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | fk_prpsl_to_user_access_mode |
Relationship Business Name | |
Physical Only | No |
Parent Table | USER_ACESS_MODE |
Child Table | PROPOSAL |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"USER_ACESS_MODE to PROPOSAL" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"USER_ACESS_MODE to PROPOSAL" Foreign Keys |
Parent Key | Child Key |
USER_ACCESS_ID | USER_ACCESS_ID |
"USER_ACESS_MODE to PROPOSAL" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"USER_ACESS_MODE to PROPOSAL" Bound Attachments |
Name | Current Value |
"SMPL_SAFE to PRPSL_SMPL_HAZ_ASSC" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_psha_to_smpl_sfty |
Relationship Business Name | |
Physical Only | No |
Parent Table | SMPL_SAFE |
Child Table | PRPSL_SMPL_HAZ_ASSC |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"SMPL_SAFE to PRPSL_SMPL_HAZ_ASSC" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"SMPL_SAFE to PRPSL_SMPL_HAZ_ASSC" Foreign Keys |
Parent Key | Child Key |
SMPL_SAFE_ID | SMPL_SAFE_ID |
"SMPL_SAFE to PRPSL_SMPL_HAZ_ASSC" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"SMPL_SAFE to PRPSL_SMPL_HAZ_ASSC" Bound Attachments |
Name | Current Value |
"GRP_CAPBLTY to PRPSL_SCI_REV" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | fk_psr_to_grp_capblty |
Relationship Business Name | |
Physical Only | No |
Parent Table | GRP_CAPBLTY |
Child Table | PRPSL_SCI_REV |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"GRP_CAPBLTY to PRPSL_SCI_REV" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"GRP_CAPBLTY to PRPSL_SCI_REV" Foreign Keys |
Parent Key | Child Key |
CAPBLTY_ID | CAPBLTY_ID |
"GRP_CAPBLTY to PRPSL_SCI_REV" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"GRP_CAPBLTY to PRPSL_SCI_REV" Bound Attachments |
Name | Current Value |
"SCI_REVIEW_MERIT to PRPSL_SCI_REV" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | fk_psr_to_sci_rev_merit |
Relationship Business Name | |
Physical Only | No |
Parent Table | SCI_REVIEW_MERIT |
Child Table | PRPSL_SCI_REV |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"SCI_REVIEW_MERIT to PRPSL_SCI_REV" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"SCI_REVIEW_MERIT to PRPSL_SCI_REV" Foreign Keys |
Parent Key | Child Key |
RATING_ID | RATING_ID |
"SCI_REVIEW_MERIT to PRPSL_SCI_REV" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"SCI_REVIEW_MERIT to PRPSL_SCI_REV" Bound Attachments |
Name | Current Value |
"PROPOSAL to PRPSL_SCI_REV" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_psrm_to_proposal |
Relationship Business Name | |
Physical Only | No |
Parent Table | PROPOSAL |
Child Table | PRPSL_SCI_REV |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"PROPOSAL to PRPSL_SCI_REV" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"PROPOSAL to PRPSL_SCI_REV" Foreign Keys |
Parent Key | Child Key |
PRPSL_ID | PRPSL_ID |
"PROPOSAL to PRPSL_SCI_REV" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"PROPOSAL to PRPSL_SCI_REV" Bound Attachments |
Name | Current Value |
"PROPOSAL to PRPSL_SMPL_TYPE_ASSC" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_psta_to_proposal |
Relationship Business Name | |
Physical Only | No |
Parent Table | PROPOSAL |
Child Table | PRPSL_SMPL_TYPE_ASSC |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"PROPOSAL to PRPSL_SMPL_TYPE_ASSC" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"PROPOSAL to PRPSL_SMPL_TYPE_ASSC" Foreign Keys |
Parent Key | Child Key |
PRPSL_ID | PRPSL_ID |
"PROPOSAL to PRPSL_SMPL_TYPE_ASSC" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"PROPOSAL to PRPSL_SMPL_TYPE_ASSC" Bound Attachments |
Name | Current Value |
"SMPL_TYPE to PRPSL_SMPL_TYPE_ASSC" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_psta_to_smpl_type |
Relationship Business Name | |
Physical Only | No |
Parent Table | SMPL_TYPE |
Child Table | PRPSL_SMPL_TYPE_ASSC |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"SMPL_TYPE to PRPSL_SMPL_TYPE_ASSC" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"SMPL_TYPE to PRPSL_SMPL_TYPE_ASSC" Foreign Keys |
Parent Key | Child Key |
SMPL_TYPE_ID | SMPL_TYPE_ID |
"SMPL_TYPE to PRPSL_SMPL_TYPE_ASSC" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"SMPL_TYPE to PRPSL_SMPL_TYPE_ASSC" Bound Attachments |
Name | Current Value |
"EMPLOYEE to VAL_EXPT_TEAM_MBR" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | fk_val_expt_team_mbr_to_emp |
Relationship Business Name | |
Physical Only | No |
Parent Table | EMPLOYEE |
Child Table | VAL_EXPT_TEAM_MBR |
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 VAL_EXPT_TEAM_MBR" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EMPLOYEE to VAL_EXPT_TEAM_MBR" Foreign Keys |
Parent Key | Child Key |
Bn | HOST_BN |
"EMPLOYEE to VAL_EXPT_TEAM_MBR" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"EMPLOYEE to VAL_EXPT_TEAM_MBR" Bound Attachments |
Name | Current Value |
"MBR_ROLE to VAL_EXPT_TEAM_MBR" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | fk_vetm_to_mbr_role |
Relationship Business Name | |
Physical Only | No |
Parent Table | MBR_ROLE |
Child Table | VAL_EXPT_TEAM_MBR |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"MBR_ROLE to VAL_EXPT_TEAM_MBR" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"MBR_ROLE to VAL_EXPT_TEAM_MBR" Foreign Keys |
Parent Key | Child Key |
MBR_ROLE_ID | MBR_ROLE_ID |
"MBR_ROLE to VAL_EXPT_TEAM_MBR" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"MBR_ROLE to VAL_EXPT_TEAM_MBR" Bound Attachments |
Name | Current Value |
"PROPOSAL to VAL_EXPT_TEAM_MBR" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_vetm_to_proposal |
Relationship Business Name | |
Physical Only | No |
Parent Table | PROPOSAL |
Child Table | VAL_EXPT_TEAM_MBR |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"PROPOSAL to VAL_EXPT_TEAM_MBR" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"PROPOSAL to VAL_EXPT_TEAM_MBR" Foreign Keys |
Parent Key | Child Key |
PRPSL_ID | PRPSL_ID |
"PROPOSAL to VAL_EXPT_TEAM_MBR" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"PROPOSAL to VAL_EXPT_TEAM_MBR" Bound Attachments |
Name | Current Value |