| "Person to Proposal Suggested Reviewer" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | Person |
| Child Entity | Proposal Suggested Reviewer |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "Person to Proposal Suggested Reviewer" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "Person to Proposal Suggested Reviewer" Foreign Keys |
| Parent Key | Child Key |
| Person Identifier | Person Identifier |
| "Person to Proposal Suggested Reviewer" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "Person to Proposal Suggested Reviewer" Bound Attachments |
| Name | Current Value |
| "CNMS_PRPSL.Proposal to Additional Reviewer" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | fk_addnl_rev_to_proposal |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | CNMS_PRPSL.Proposal |
| Child Entity | Additional Reviewer |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "CNMS_PRPSL.Proposal to Additional Reviewer" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "CNMS_PRPSL.Proposal to Additional Reviewer" Foreign Keys |
| Parent Key | Child Key |
| Proposal Identifier | Proposal Identifier |
| "CNMS_PRPSL.Proposal to Additional Reviewer" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "CNMS_PRPSL.Proposal to Additional Reviewer" Bound Attachments |
| Name | Current Value |
| "CNMS_PRPSL.Proposal to Email Preview" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | fk_email_prev_to_prpsl |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | CNMS_PRPSL.Proposal |
| Child Entity | Email Preview |
| Cardinality | Zero or One to Zero or More |
| Existence | Optional |
| Propagated Key | Primary Key |
| "CNMS_PRPSL.Proposal to Email Preview" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "CNMS_PRPSL.Proposal to Email Preview" Foreign Keys |
| Parent Key | Child Key |
| Proposal Identifier | Proposal Identifier_1 |
| "CNMS_PRPSL.Proposal to Email Preview" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "CNMS_PRPSL.Proposal to Email Preview" Bound Attachments |
| Name | Current Value |
| "CNMS_PRPSL.Email Template to Email Sent" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | fk_email_sent_to_email_tmpl |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | CNMS_PRPSL.Email Template |
| Child Entity | Email Sent |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "CNMS_PRPSL.Email Template to Email Sent" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "CNMS_PRPSL.Email Template to Email Sent" Foreign Keys |
| Parent Key | Child Key |
| Template Identifier | Template Identifier |
| "CNMS_PRPSL.Email Template to Email Sent" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "CNMS_PRPSL.Email Template to Email Sent" Bound Attachments |
| Name | Current Value |
| "CNMS_PRPSL.Email Template to Email Preview" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | fk_email_template_to_email_prev |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | CNMS_PRPSL.Email Template |
| Child Entity | Email Preview |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "CNMS_PRPSL.Email Template to Email Preview" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "CNMS_PRPSL.Email Template to Email Preview" Foreign Keys |
| Parent Key | Child Key |
| Template Identifier | Template Identifier |
| "CNMS_PRPSL.Email Template to Email Preview" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "CNMS_PRPSL.Email Template to Email Preview" Bound Attachments |
| Name | Current Value |
| "CNMS_PRPSL.Email Template to Email Template Tag" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | fk_email_tmpl_tag_email_templ |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | CNMS_PRPSL.Email Template |
| Child Entity | Email Template Tag |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "CNMS_PRPSL.Email Template to Email Template Tag" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "CNMS_PRPSL.Email Template to Email Template Tag" Foreign Keys |
| Parent Key | Child Key |
| Template Identifier | Template Identifier |
| "CNMS_PRPSL.Email Template to Email Template Tag" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "CNMS_PRPSL.Email Template to Email Template Tag" Bound Attachments |
| Name | Current Value |
| "CNMS_PRPSL.Proposal Activity to Email Template" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | fk_email_tmpl_to_proposal_act |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | CNMS_PRPSL.Proposal Activity |
| Child Entity | Email Template |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "CNMS_PRPSL.Proposal Activity to Email Template" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "CNMS_PRPSL.Proposal Activity to Email Template" Foreign Keys |
| Parent Key | Child Key |
| Activity Identifier | Activity Identifier |
| "CNMS_PRPSL.Proposal Activity to Email Template" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "CNMS_PRPSL.Proposal Activity to Email Template" Bound Attachments |
| Name | Current Value |
| "Person to Proposal Feasibility Review" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | fk_feas_rev_to_person |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | Person |
| Child Entity | Proposal Feasibility Review |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "Person to Proposal Feasibility Review" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "Person to Proposal Feasibility Review" Foreign Keys |
| Parent Key | Child Key |
| Person Identifier | Person Identifier |
| "Person to Proposal Feasibility Review" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "Person to Proposal Feasibility Review" Bound Attachments |
| Name | Current Value |
| "CNMS_PRPSL.Proposal to Proposal Feasibility Review" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | fk_feas_rev_to_prpsl |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | CNMS_PRPSL.Proposal |
| Child Entity | Proposal Feasibility Review |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "CNMS_PRPSL.Proposal to Proposal Feasibility Review" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "CNMS_PRPSL.Proposal to Proposal Feasibility Review" Foreign Keys |
| Parent Key | Child Key |
| Proposal Identifier | Proposal Identifier |
| "CNMS_PRPSL.Proposal to Proposal Feasibility Review" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "CNMS_PRPSL.Proposal to Proposal Feasibility Review" Bound Attachments |
| Name | Current Value |
| "Person to Group Leader Research Capability Association" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | fk_grp_lead_to_person |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | Person |
| Child Entity | Group Leader Research Capability Association |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "Person to Group Leader Research Capability Association" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "Person to Group Leader Research Capability Association" Foreign Keys |
| Parent Key | Child Key |
| Person Identifier | Person Identifier |
| "Person to Group Leader Research Capability Association" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "Person to Group Leader Research Capability Association" Bound Attachments |
| Name | Current Value |
| "Research Capability to Group Leader Research Capability Association" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | fk_grp_lead_to_rsch_capblty |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | Research Capability |
| Child Entity | Group Leader Research Capability Association |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "Research Capability to Group Leader Research Capability Association" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "Research Capability to Group Leader Research Capability Association" Foreign Keys |
| Parent Key | Child Key |
| Research Capability Identifier | Research Capability Identifier |
| "Research Capability to Group Leader Research Capability Association" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "Research Capability to Group Leader Research Capability Association" Bound Attachments |
| Name | Current Value |
| "Research Capability to Instrument" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | fk_instr_to_resh_cap |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | Research Capability |
| Child Entity | Instrument |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "Research Capability to Instrument" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "Research Capability to Instrument" Foreign Keys |
| Parent Key | Child Key |
| Research Capability Identifier | Research Capability Identifier |
| "Research Capability to Instrument" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "Research Capability to Instrument" Bound Attachments |
| Name | Current Value |
| "CNMS Proposal System Activity to CNMS Proposal System Log" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | fk_ipts_log_to_ipts_act_1 |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | CNMS Proposal System Activity |
| Child Entity | CNMS Proposal System Log |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "CNMS Proposal System Activity to CNMS Proposal System Log" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "CNMS Proposal System Activity to CNMS Proposal System Log" Foreign Keys |
| Parent Key | Child Key |
| Activity Identifier | Activity Identifier |
| "CNMS Proposal System Activity to CNMS Proposal System Log" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "CNMS Proposal System Activity to CNMS Proposal System Log" Bound Attachments |
| Name | Current Value |
| "Member Role to Nonvalidated Experiment Team Member" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | fk_netm_to_mbr_role |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | Member Role |
| Child Entity | Nonvalidated Experiment Team Member |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "Member Role to Nonvalidated Experiment Team Member" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "Member Role to Nonvalidated Experiment Team Member" Foreign Keys |
| Parent Key | Child Key |
| Member Role Identifier | Member Role Identifier |
| "Member Role to Nonvalidated Experiment Team Member" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "Member Role to Nonvalidated Experiment Team Member" Bound Attachments |
| Name | Current Value |
| "CNMS_PRPSL.Proposal to Nonvalidated Experiment Team Member" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | fk_netm_to_proposal |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | CNMS_PRPSL.Proposal |
| Child Entity | Nonvalidated Experiment Team Member |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "CNMS_PRPSL.Proposal to Nonvalidated Experiment Team Member" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "CNMS_PRPSL.Proposal to Nonvalidated Experiment Team Member" Foreign Keys |
| Parent Key | Child Key |
| Proposal Identifier | Proposal Identifier |
| "CNMS_PRPSL.Proposal to Nonvalidated Experiment Team Member" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "CNMS_PRPSL.Proposal to Nonvalidated Experiment Team Member" Bound Attachments |
| Name | Current Value |
| "CNMS_PRPSL.Proposal to Proposal Suggested Reviewer" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | fk_p_sugg_rev_to_proposal |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | CNMS_PRPSL.Proposal |
| Child Entity | Proposal Suggested Reviewer |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "CNMS_PRPSL.Proposal to Proposal Suggested Reviewer" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "CNMS_PRPSL.Proposal to Proposal Suggested Reviewer" Foreign Keys |
| Parent Key | Child Key |
| Proposal Identifier | Proposal Identifier |
| "CNMS_PRPSL.Proposal to Proposal Suggested Reviewer" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "CNMS_PRPSL.Proposal to Proposal Suggested Reviewer" Bound Attachments |
| Name | Current Value |
| "Description of Research to Proposal Description of Research Association" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | fk_pdora_to_desc_rsch |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | Description of Research |
| Child Entity | Proposal Description of Research Association |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "Description of Research to Proposal Description of Research Association" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "Description of Research to Proposal Description of Research Association" Foreign Keys |
| Parent Key | Child Key |
| Description of Research Identifier | Description of Research Identifier |
| "Description of Research to Proposal Description of Research Association" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "Description of Research to Proposal Description of Research Association" Bound Attachments |
| Name | Current Value |
| "CNMS_PRPSL.Proposal to Proposal Description of Research Association" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | fk_pdora_to_prpsl |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | CNMS_PRPSL.Proposal |
| Child Entity | Proposal Description of Research Association |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "CNMS_PRPSL.Proposal to Proposal Description of Research Association" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "CNMS_PRPSL.Proposal to Proposal Description of Research Association" Foreign Keys |
| Parent Key | Child Key |
| Proposal Identifier | Proposal Identifier |
| "CNMS_PRPSL.Proposal to Proposal Description of Research Association" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "CNMS_PRPSL.Proposal to Proposal Description of Research Association" Bound Attachments |
| Name | Current Value |
| "Country to Person" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | FK_PERSON_CNTRY_CNTRY |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | Country |
| Child Entity | Person |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "Country to Person" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "Country to Person" Foreign Keys |
| Parent Key | Child Key |
| Country Identifier | Country Identifier |
| "Country to Person" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "Country to Person" Bound Attachments |
| Name | Current Value |
| "Institute to Person" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | FK_PERSON_TO_INST |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | Institute |
| Child Entity | Person |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "Institute to Person" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "Institute to Person" Foreign Keys |
| Parent Key | Child Key |
| Institute Identifier | Institute Identifier |
| "Institute to Person" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "Institute to Person" Bound Attachments |
| Name | Current Value |
| "CNMS_PRPSL.Proposal to Proposal Research Area" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | fk_pra_to_proposal |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | CNMS_PRPSL.Proposal |
| Child Entity | Proposal Research Area |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "CNMS_PRPSL.Proposal to Proposal Research Area" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "CNMS_PRPSL.Proposal to Proposal Research Area" Foreign Keys |
| Parent Key | Child Key |
| Proposal Identifier | Proposal Identifier |
| "CNMS_PRPSL.Proposal to Proposal Research Area" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "CNMS_PRPSL.Proposal to Proposal Research Area" Bound Attachments |
| Name | Current Value |
| "Person to Proposal Review Committee" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | fk_prc_tech_cont_to_person |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | Person |
| Child Entity | Proposal Review Committee |
| Cardinality | Zero or One to Zero or More |
| Existence | Optional |
| Propagated Key | Primary Key |
| "Person to Proposal Review Committee" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "Person to Proposal Review Committee" Foreign Keys |
| Parent Key | Child Key |
| Person Identifier | Technical Contact Person Identifier |
| "Person to Proposal Review Committee" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "Person to Proposal Review Committee" Bound Attachments |
| Name | Current Value |
| "XF_ADMIN.Employee to Proposal Review Committee" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | fk_prc_to_employee |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | XF_ADMIN.Employee |
| Child Entity | Proposal Review Committee |
| Cardinality | Zero or One to Zero or More |
| Existence | Optional |
| Propagated Key | Primary Key |
| "XF_ADMIN.Employee to Proposal Review Committee" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "XF_ADMIN.Employee to Proposal Review Committee" Foreign Keys |
| Parent Key | Child Key |
| Badge Number | Personnell Access System Host Badge Number |
| "XF_ADMIN.Employee to Proposal Review Committee" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "XF_ADMIN.Employee to Proposal Review Committee" Bound Attachments |
| Name | Current Value |
| "User Access Mode to Proposal Review Committee" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | fk_prc_to_usr_acc_mode |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | User Access Mode |
| Child Entity | Proposal Review Committee |
| Cardinality | Zero or One to Zero or More |
| Existence | Optional |
| Propagated Key | Primary Key |
| "User Access Mode to Proposal Review Committee" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "User Access Mode to Proposal Review Committee" Foreign Keys |
| Parent Key | Child Key |
| User Access Identifer | User Access Identifer |
| "User Access Mode to Proposal Review Committee" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "User Access Mode to Proposal Review Committee" Bound Attachments |
| Name | Current Value |
| "Experiment Cycle to Proposal" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | fk_proposal_to_expt_cycle |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | Experiment Cycle |
| Child Entity | Proposal |
| Cardinality | Zero or One to Zero or More |
| Existence | Optional |
| Propagated Key | Primary Key |
| "Experiment Cycle to Proposal" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "Experiment Cycle to Proposal" Foreign Keys |
| Parent Key | Child Key |
| Cycle Identifier | Cycle Identifier |
| "Experiment Cycle to Proposal" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "Experiment Cycle to Proposal" Bound Attachments |
| Name | Current Value |
| "Institute to Proposal" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | fk_proposal_to_institute |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | Institute |
| Child Entity | Proposal |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "Institute to Proposal" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "Institute to Proposal" Foreign Keys |
| Parent Key | Child Key |
| Institute Identifier | Institute Identifier |
| "Institute to Proposal" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "Institute 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 | |
| Logical Only | No |
| Parent Entity | Person |
| Child Entity | Proposal |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "Person to Proposal" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "Person to Proposal" Foreign Keys |
| Parent Key | Child Key |
| Person Identifier | Person Identifier |
| "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 Category to Proposal" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | fk_proposal_to_prpsl_cat |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | Proposal Category |
| Child Entity | Proposal |
| Cardinality | Zero or One to Zero or More |
| Existence | Optional |
| Propagated Key | Primary Key |
| "Proposal Category to Proposal" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "Proposal Category to Proposal" Foreign Keys |
| Parent Key | Child Key |
| Proposal Category Identifier | Proposal Category Identifier |
| "Proposal Category to Proposal" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "Proposal Category to Proposal" Bound Attachments |
| Name | Current Value |
| "CNMS_PRPSL.Proposal Status to Proposal" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | fk_proposal_to_prpsl_stat |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | CNMS_PRPSL.Proposal Status |
| Child Entity | Proposal |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "CNMS_PRPSL.Proposal Status to Proposal" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "CNMS_PRPSL.Proposal Status to Proposal" Foreign Keys |
| Parent Key | Child Key |
| Status Identifier | Status Identifier |
| "CNMS_PRPSL.Proposal Status to Proposal" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "CNMS_PRPSL.Proposal Status to Proposal" Bound Attachments |
| Name | Current Value |
| "Person to Proposal Role Person Association" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | fk_prpa_to_person |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | Person |
| Child Entity | Proposal Role Person Association |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "Person to Proposal Role Person Association" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "Person to Proposal Role Person Association" Foreign Keys |
| Parent Key | Child Key |
| Person Identifier | Person Identifier |
| "Person to Proposal Role Person Association" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "Person to Proposal Role Person Association" Bound Attachments |
| Name | Current Value |
| "CNMS_PRPSL.Proposal Role to Proposal Role Person Association" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | fk_prpa_to_prpsl_role |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | CNMS_PRPSL.Proposal Role |
| Child Entity | Proposal Role Person Association |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "CNMS_PRPSL.Proposal Role to Proposal Role Person Association" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "CNMS_PRPSL.Proposal Role to Proposal Role Person Association" Foreign Keys |
| Parent Key | Child Key |
| Role Identifier | Role Identifier |
| "CNMS_PRPSL.Proposal Role to Proposal Role Person Association" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "CNMS_PRPSL.Proposal Role to Proposal Role Person Association" Bound Attachments |
| Name | Current Value |
| "Proposal Funding Status to Proposal Funding Agency" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | fk_prpsl_fund_agcy_to_fund_stat |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | Proposal Funding Status |
| Child Entity | Proposal Funding Agency |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "Proposal Funding Status to Proposal Funding Agency" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "Proposal Funding Status to Proposal Funding Agency" Foreign Keys |
| Parent Key | Child Key |
| Proposal Identifier, Funding Status Identifier | Proposal Identifier, Funding Status Identifier |
| "Proposal Funding Status to Proposal Funding Agency" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "Proposal Funding Status to Proposal Funding Agency" Bound Attachments |
| Name | Current Value |
| "Country to Proposal Funding Country" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | fk_prpsl_fund_cntry_to_cntry |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | Country |
| Child Entity | Proposal Funding Country |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "Country to Proposal Funding Country" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "Country to Proposal Funding Country" Foreign Keys |
| Parent Key | Child Key |
| Country Identifier | Country Identifier |
| "Country to Proposal Funding Country" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "Country to Proposal Funding Country" Bound Attachments |
| Name | Current Value |
| "CNMS_PRPSL.Proposal Funding to Proposal Funding Country" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | fk_prpsl_fund_cntry_to_prpsl_fund |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | CNMS_PRPSL.Proposal Funding |
| Child Entity | Proposal Funding Country |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "CNMS_PRPSL.Proposal Funding to Proposal Funding Country" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "CNMS_PRPSL.Proposal Funding to Proposal Funding Country" Foreign Keys |
| Parent Key | Child Key |
| Proposal Identifier, Funding Identifier | Proposal Identifier, Funding Identifier |
| "CNMS_PRPSL.Proposal Funding to Proposal Funding Country" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "CNMS_PRPSL.Proposal Funding to Proposal Funding Country" Bound Attachments |
| Name | Current Value |
| "Funding Status to Proposal Funding Status" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | fk_prpsl_fund_st_to_fund_st |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | Funding Status |
| Child Entity | Proposal Funding Status |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "Funding Status to Proposal Funding Status" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "Funding Status to Proposal Funding Status" Foreign Keys |
| Parent Key | Child Key |
| Funding Status Identifier | Funding Status Identifier |
| "Funding Status to Proposal Funding Status" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "Funding Status to Proposal Funding Status" Bound Attachments |
| Name | Current Value |
| "CNMS_PRPSL.Proposal to Proposal Funding Status" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | fk_prpsl_fund_stat_to_prpsl |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | CNMS_PRPSL.Proposal |
| Child Entity | Proposal Funding Status |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "CNMS_PRPSL.Proposal to Proposal Funding Status" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "CNMS_PRPSL.Proposal to Proposal Funding Status" Foreign Keys |
| Parent Key | Child Key |
| Proposal Identifier | Proposal Identifier |
| "CNMS_PRPSL.Proposal to Proposal Funding Status" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "CNMS_PRPSL.Proposal to Proposal Funding Status" Bound Attachments |
| Name | Current Value |
| "Funding Source to Proposal Funding" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | fk_prpsl_fund_to_fund_src |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | Funding Source |
| Child Entity | Proposal Funding |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "Funding Source to Proposal Funding" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "Funding Source to Proposal Funding" Foreign Keys |
| Parent Key | Child Key |
| Funding Identifier | Funding Identifier |
| "Funding Source to Proposal Funding" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "Funding Source to Proposal Funding" Bound Attachments |
| Name | Current Value |
| "CNMS_PRPSL.Proposal to Proposal Funding" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | fk_prpsl_fund_to_proposal |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | CNMS_PRPSL.Proposal |
| Child Entity | Proposal Funding |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "CNMS_PRPSL.Proposal to Proposal Funding" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "CNMS_PRPSL.Proposal to Proposal Funding" Foreign Keys |
| Parent Key | Child Key |
| Proposal Identifier | Proposal Identifier |
| "CNMS_PRPSL.Proposal to Proposal Funding" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "CNMS_PRPSL.Proposal to Proposal Funding" Bound Attachments |
| Name | Current Value |
| "CNMS_PRPSL.Instrument to Proposal Instrument Association" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | fk_prpsl_instr_assc_to_instr |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | CNMS_PRPSL.Instrument |
| Child Entity | Proposal Instrument Association |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "CNMS_PRPSL.Instrument to Proposal Instrument Association" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "CNMS_PRPSL.Instrument to Proposal Instrument Association" Foreign Keys |
| Parent Key | Child Key |
| Instrument Identifier | Instrument Identifier |
| "CNMS_PRPSL.Instrument to Proposal Instrument Association" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "CNMS_PRPSL.Instrument to Proposal Instrument Association" Bound Attachments |
| Name | Current Value |
| "CNMS_PRPSL.Proposal to Proposal Instrument Association" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | fk_prpsl_instr_assc_to_prpsl |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | CNMS_PRPSL.Proposal |
| Child Entity | Proposal Instrument Association |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "CNMS_PRPSL.Proposal to Proposal Instrument Association" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "CNMS_PRPSL.Proposal to Proposal Instrument Association" Foreign Keys |
| Parent Key | Child Key |
| Proposal Identifier | Proposal Identifier |
| "CNMS_PRPSL.Proposal to Proposal Instrument Association" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "CNMS_PRPSL.Proposal to Proposal Instrument Association" Bound Attachments |
| Name | Current Value |
| "CNMS_PRPSL.Proposal to Proposal Log" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | fk_prpsl_log_to_prpsl |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | CNMS_PRPSL.Proposal |
| Child Entity | Proposal Log |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "CNMS_PRPSL.Proposal to Proposal Log" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "CNMS_PRPSL.Proposal to Proposal Log" Foreign Keys |
| Parent Key | Child Key |
| Proposal Identifier | Proposal Identifier |
| "CNMS_PRPSL.Proposal to Proposal Log" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "CNMS_PRPSL.Proposal to Proposal Log" Bound Attachments |
| Name | Current Value |
| "CNMS_PRPSL.Proposal Activity to Proposal Log" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | fk_prpsl_log_to_prpsl_act |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | CNMS_PRPSL.Proposal Activity |
| Child Entity | Proposal Log |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "CNMS_PRPSL.Proposal Activity to Proposal Log" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "CNMS_PRPSL.Proposal Activity to Proposal Log" Foreign Keys |
| Parent Key | Child Key |
| Activity Identifier | Activity Identifier |
| "CNMS_PRPSL.Proposal Activity to Proposal Log" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "CNMS_PRPSL.Proposal Activity to Proposal Log" Bound Attachments |
| Name | Current Value |
| "Content Type to Proposal PDF" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | fk_prpsl_pdf_to_content_type |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | Content Type |
| Child Entity | Proposal PDF |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "Content Type to Proposal PDF" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "Content Type to Proposal PDF" Foreign Keys |
| Parent Key | Child Key |
| Content Identifier | Content Identifier |
| "Content Type to Proposal PDF" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "Content Type to Proposal PDF" Bound Attachments |
| Name | Current Value |
| "CNMS_PRPSL.Proposal to Proposal PDF" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | fk_prpsl_pdf_to_prpsl |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | CNMS_PRPSL.Proposal |
| Child Entity | Proposal PDF |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "CNMS_PRPSL.Proposal to Proposal PDF" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "CNMS_PRPSL.Proposal to Proposal PDF" Foreign Keys |
| Parent Key | Child Key |
| Proposal Identifier | Proposal Identifier |
| "CNMS_PRPSL.Proposal to Proposal PDF" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "CNMS_PRPSL.Proposal to Proposal PDF" Bound Attachments |
| Name | Current Value |
| "Person to Proposal Review Committee" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | fk_prpsl_rev_comm_to_person |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | Person |
| Child Entity | Proposal Review Committee |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "Person to Proposal Review Committee" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "Person to Proposal Review Committee" Foreign Keys |
| Parent Key | Child Key |
| Person Identifier | Person Identifier |
| "Person to Proposal Review Committee" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "Person to Proposal Review Committee" Bound Attachments |
| Name | Current Value |
| "CNMS_PRPSL.Proposal to Proposal Review Committee" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | fk_prpsl_rev_comm_to_prpsl |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | CNMS_PRPSL.Proposal |
| Child Entity | Proposal Review Committee |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "CNMS_PRPSL.Proposal to Proposal Review Committee" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "CNMS_PRPSL.Proposal to Proposal Review Committee" Foreign Keys |
| Parent Key | Child Key |
| Proposal Identifier | Proposal Identifier |
| "CNMS_PRPSL.Proposal to Proposal Review Committee" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "CNMS_PRPSL.Proposal to Proposal Review Committee" Bound Attachments |
| Name | Current Value |
| "Basic Energy Science Research Area to Proposal Research Area" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | fk_prpsl_rsch_area_to_prpsl_rsch_area |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | Basic Energy Science Research Area |
| Child Entity | Proposal Research Area |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "Basic Energy Science Research Area to Proposal Research Area" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "Basic Energy Science Research Area to Proposal Research Area" Foreign Keys |
| Parent Key | Child Key |
| Research Area Identifier | Research Area Identifier |
| "Basic Energy Science Research Area to Proposal Research Area" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "Basic Energy Science Research Area to Proposal Research Area" Bound Attachments |
| Name | Current Value |
| "Person to Proposal Science Review" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | fk_prpsl_sci_rev_to_person |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | Person |
| Child Entity | Proposal Science Review |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "Person to Proposal Science Review" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "Person to Proposal Science Review" Foreign Keys |
| Parent Key | Child Key |
| Person Identifier | Person Identifier |
| "Person to Proposal Science Review" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "Person to Proposal Science Review" Bound Attachments |
| Name | Current Value |
| "CNMS_PRPSL.Proposal Science Review to Proposal Review Committee" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | fk_prpsl_sci_rev_to_prpsl_rev_comm |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | CNMS_PRPSL.Proposal Science Review |
| Child Entity | Proposal Review Committee |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "CNMS_PRPSL.Proposal Science Review to Proposal Review Committee" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "CNMS_PRPSL.Proposal Science Review to Proposal Review Committee" Foreign Keys |
| Parent Key | Child Key |
| Proposal Identifier, Person Identifier | Proposal Identifier, Person Identifier |
| "CNMS_PRPSL.Proposal Science Review to Proposal Review Committee" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "CNMS_PRPSL.Proposal Science Review to Proposal Review Committee" Bound Attachments |
| Name | Current Value |
| "Person to Proposal Staff Contact" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | fk_prpsl_staff_cont_to_pers |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | Person |
| Child Entity | Proposal Staff Contact |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "Person to Proposal Staff Contact" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "Person to Proposal Staff Contact" Foreign Keys |
| Parent Key | Child Key |
| Person Identifier | Person Identifier |
| "Person to Proposal Staff Contact" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "Person to Proposal Staff Contact" Bound Attachments |
| Name | Current Value |
| "CNMS_PRPSL.Proposal to Proposal Staff Contact" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | fk_prpsl_staff_cont_to_prpsl |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | CNMS_PRPSL.Proposal |
| Child Entity | Proposal Staff Contact |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "CNMS_PRPSL.Proposal to Proposal Staff Contact" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "CNMS_PRPSL.Proposal to Proposal Staff Contact" Foreign Keys |
| Parent Key | Child Key |
| Proposal Identifier | Proposal Identifier |
| "CNMS_PRPSL.Proposal to Proposal Staff Contact" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "CNMS_PRPSL.Proposal to Proposal Staff Contact" Bound Attachments |
| Name | Current Value |
| "Person to Proposal Technical Contact" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | fk_prpsl_tech_cont_to_person |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | Person |
| Child Entity | Proposal Technical Contact |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "Person to Proposal Technical Contact" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "Person to Proposal Technical Contact" Foreign Keys |
| Parent Key | Child Key |
| Person Identifier | Person Identifier |
| "Person to Proposal Technical Contact" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "Person to Proposal Technical Contact" Bound Attachments |
| Name | Current Value |
| "CNMS_PRPSL.Proposal to Proposal Technical Contact" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | fk_prpsl_tech_cont_to_prpsl |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | CNMS_PRPSL.Proposal |
| Child Entity | Proposal Technical Contact |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "CNMS_PRPSL.Proposal to Proposal Technical Contact" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "CNMS_PRPSL.Proposal to Proposal Technical Contact" Foreign Keys |
| Parent Key | Child Key |
| Proposal Identifier | Proposal Identifier |
| "CNMS_PRPSL.Proposal to Proposal Technical Contact" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "CNMS_PRPSL.Proposal to Proposal Technical Contact" Bound Attachments |
| Name | Current Value |
| "User Access Mode to Proposal" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | fk_prpsl_to_user_access_mode |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | User Access Mode |
| Child Entity | Proposal |
| Cardinality | Zero or One to Zero or More |
| Existence | Optional |
| Propagated Key | Primary Key |
| "User Access Mode to Proposal" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "User Access Mode to Proposal" Foreign Keys |
| Parent Key | Child Key |
| User Access Identifer | User Access Identifer |
| "User Access Mode to Proposal" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "User Access Mode to Proposal" Bound Attachments |
| Name | Current Value |
| "Sample Safety to Proposal Sample Hazard Association" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | fk_psha_to_smpl_sfty |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | Sample Safety |
| Child Entity | Proposal Sample Hazard Association |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "Sample Safety to Proposal Sample Hazard Association" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "Sample Safety to Proposal Sample Hazard Association" Foreign Keys |
| Parent Key | Child Key |
| Sample Safety Identifier | Sample Safety Identifier |
| "Sample Safety to Proposal Sample Hazard Association" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "Sample Safety to Proposal Sample Hazard Association" Bound Attachments |
| Name | Current Value |
| "Group Capability to Proposal Science Review" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | fk_psr_to_grp_capblty |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | Group Capability |
| Child Entity | Proposal Science Review |
| Cardinality | Zero or One to Zero or More |
| Existence | Optional |
| Propagated Key | Primary Key |
| "Group Capability to Proposal Science Review" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "Group Capability to Proposal Science Review" Foreign Keys |
| Parent Key | Child Key |
| Capability Identifier | Capability Identifier |
| "Group Capability to Proposal Science Review" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "Group Capability to Proposal Science Review" Bound Attachments |
| Name | Current Value |
| "CNMS_PRPSL.Science Review Merit to Proposal Science Review" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | fk_psr_to_sci_rev_merit |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | CNMS_PRPSL.Science Review Merit |
| Child Entity | Proposal Science Review |
| Cardinality | Zero or One to Zero or More |
| Existence | Optional |
| Propagated Key | Primary Key |
| "CNMS_PRPSL.Science Review Merit to Proposal Science Review" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "CNMS_PRPSL.Science Review Merit to Proposal Science Review" Foreign Keys |
| Parent Key | Child Key |
| Rating Identifier | Rating Identifier |
| "CNMS_PRPSL.Science Review Merit to Proposal Science Review" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "CNMS_PRPSL.Science Review Merit to Proposal Science Review" Bound Attachments |
| Name | Current Value |
| "CNMS_PRPSL.Proposal to Proposal Science Review" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | fk_psrm_to_proposal |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | CNMS_PRPSL.Proposal |
| Child Entity | Proposal Science Review |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "CNMS_PRPSL.Proposal to Proposal Science Review" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "CNMS_PRPSL.Proposal to Proposal Science Review" Foreign Keys |
| Parent Key | Child Key |
| Proposal Identifier | Proposal Identifier |
| "CNMS_PRPSL.Proposal to Proposal Science Review" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "CNMS_PRPSL.Proposal to Proposal Science Review" Bound Attachments |
| Name | Current Value |
| "CNMS_PRPSL.Proposal to Proposal Sample Type Association" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | fk_psta_to_proposal |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | CNMS_PRPSL.Proposal |
| Child Entity | Proposal Sample Type Association |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "CNMS_PRPSL.Proposal to Proposal Sample Type Association" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "CNMS_PRPSL.Proposal to Proposal Sample Type Association" Foreign Keys |
| Parent Key | Child Key |
| Proposal Identifier | Proposal Identifier |
| "CNMS_PRPSL.Proposal to Proposal Sample Type Association" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "CNMS_PRPSL.Proposal to Proposal Sample Type Association" Bound Attachments |
| Name | Current Value |
| "Sample Type to Proposal Sample Type Association" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | fk_psta_to_smpl_type |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | Sample Type |
| Child Entity | Proposal Sample Type Association |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "Sample Type to Proposal Sample Type Association" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "Sample Type to Proposal Sample Type Association" Foreign Keys |
| Parent Key | Child Key |
| Sample Type Identifier | Sample Type Identifier |
| "Sample Type to Proposal Sample Type Association" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "Sample Type to Proposal Sample Type Association" Bound Attachments |
| Name | Current Value |
| "XF_ADMIN.Employee to Validated Experiment Team Member" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | fk_val_expt_team_mbr_to_emp |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | XF_ADMIN.Employee |
| Child Entity | Validated Experiment Team Member |
| Cardinality | Zero or One to Zero or More |
| Existence | Optional |
| Propagated Key | Primary Key |
| "XF_ADMIN.Employee to Validated Experiment Team Member" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "XF_ADMIN.Employee to Validated Experiment Team Member" Foreign Keys |
| Parent Key | Child Key |
| Badge Number | Host Badge Number |
| "XF_ADMIN.Employee to Validated Experiment Team Member" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "XF_ADMIN.Employee to Validated Experiment Team Member" Bound Attachments |
| Name | Current Value |
| "Member Role to Validated Experiment Team Member" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | fk_vetm_to_mbr_role |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | Member Role |
| Child Entity | Validated Experiment Team Member |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "Member Role to Validated Experiment Team Member" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "Member Role to Validated Experiment Team Member" Foreign Keys |
| Parent Key | Child Key |
| Member Role Identifier | Member Role Identifier |
| "Member Role to Validated Experiment Team Member" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "Member Role to Validated Experiment Team Member" Bound Attachments |
| Name | Current Value |
| "CNMS_PRPSL.Proposal to Validated Experiment Team Member" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | fk_vetm_to_proposal |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | CNMS_PRPSL.Proposal |
| Child Entity | Validated Experiment Team Member |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "CNMS_PRPSL.Proposal to Validated Experiment Team Member" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "CNMS_PRPSL.Proposal to Validated Experiment Team Member" Foreign Keys |
| Parent Key | Child Key |
| Proposal Identifier | Proposal Identifier |
| "CNMS_PRPSL.Proposal to Validated Experiment Team Member" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "CNMS_PRPSL.Proposal to Validated Experiment Team Member" Bound Attachments |
| Name | Current Value |