| "Person to Proposal Instrument" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | Person |
| Child Entity | Proposal Instrument |
| Cardinality | Zero or One to Zero or More |
| Existence | Optional |
| Propagated Key | Primary Key |
| "Person to Proposal Instrument" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "Person to Proposal Instrument" Foreign Keys |
| Parent Key | Child Key |
| Person Identifier | Feasbility Review Person Identifier |
| "Person to Proposal Instrument" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "Person to Proposal Instrument" Bound Attachments |
| Name | Current Value |
| "Unit of Length to Experiment Sample" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | Unit of Length |
| Child Entity | Experiment Sample |
| Cardinality | Zero or One to Zero or More |
| Existence | Optional |
| Propagated Key | Primary Key |
| "Unit of Length to Experiment Sample" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "Unit of Length to Experiment Sample" Foreign Keys |
| Parent Key | Child Key |
| Length Unit Identifier | Length Unit Identifier |
| "Unit of Length to Experiment Sample" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "Unit of Length to Experiment Sample" Bound Attachments |
| Name | Current Value |
| "Unit of Mass to Experiment Sample" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | Unit of Mass |
| Child Entity | Experiment Sample |
| Cardinality | Zero or One to Zero or More |
| Existence | Optional |
| Propagated Key | Primary Key |
| "Unit of Mass to Experiment Sample" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "Unit of Mass to Experiment Sample" Foreign Keys |
| Parent Key | Child Key |
| Mass Unit Identifier | Mass Unit Identifier |
| "Unit of Mass to Experiment Sample" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "Unit of Mass to Experiment Sample" Bound Attachments |
| Name | Current Value |
| "Unit of Temperature to Experiment Sample Environment" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | Unit of Temperature |
| Child Entity | Experiment Sample Environment |
| Cardinality | Zero or One to Zero or More |
| Existence | Optional |
| Propagated Key | Primary Key |
| "Unit of Temperature to Experiment Sample Environment" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "Unit of Temperature to Experiment Sample Environment" Foreign Keys |
| Parent Key | Child Key |
| Temperature Unit Identifier | Temperature Unit Identifier |
| "Unit of Temperature to Experiment Sample Environment" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "Unit of Temperature to Experiment Sample Environment" Bound Attachments |
| Name | Current Value |
| "XF_ADMIN.Instrument to Proposal Instrument Question" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | XF_ADMIN.Instrument |
| Child Entity | Proposal Instrument Question |
| Cardinality | Zero or One to Zero or More |
| Existence | Optional |
| Propagated Key | Primary Key |
| "XF_ADMIN.Instrument to Proposal Instrument Question" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "XF_ADMIN.Instrument to Proposal Instrument Question" Foreign Keys |
| Parent Key | Child Key |
| Instrument Identifier | Instrument Identifier |
| "XF_ADMIN.Instrument to Proposal Instrument Question" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "XF_ADMIN.Instrument to Proposal Instrument Question" Bound Attachments |
| Name | Current Value |
| "Proposal Instrument to Beam Allocation Committee Allocation History" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_BAH_TO_PRPSL_INSTR |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | Proposal Instrument |
| Child Entity | Beam Allocation Committee Allocation History |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "Proposal Instrument to Beam Allocation Committee Allocation History" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "Proposal Instrument to Beam Allocation Committee Allocation History" Foreign Keys |
| Parent Key | Child Key |
| Proposal Identifier, Submission Number, Instrument Identifier | Proposal Identifier, Submission Number, Instrument Identifier |
| "Proposal Instrument to Beam Allocation Committee Allocation History" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "Proposal Instrument to Beam Allocation Committee Allocation History" Bound Attachments |
| Name | Current Value |
| "Basic Energy Science Research Area to Proposal BES Research Area" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_BES_RSCH_AREA_PRPSL_BRA |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | Basic Energy Science Research Area |
| Child Entity | Proposal BES Research Area |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "Basic Energy Science Research Area to Proposal BES Research Area" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "Basic Energy Science Research Area to Proposal BES Research Area" Foreign Keys |
| Parent Key | Child Key |
| Research Area Identifier | Research Area Identifier |
| "Basic Energy Science Research Area to Proposal BES Research Area" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "Basic Energy Science Research Area to Proposal BES Research Area" Bound Attachments |
| Name | Current Value |
| "Discretionary Review Status to Discretionary TIme Review" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | FK_DTR_TO_DESCR_TIME_STAT |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | Discretionary Review Status |
| Child Entity | Discretionary TIme Review |
| Cardinality | Zero or One to Zero or More |
| Existence | Optional |
| Propagated Key | Primary Key |
| "Discretionary Review Status to Discretionary TIme Review" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "Discretionary Review Status to Discretionary TIme Review" Foreign Keys |
| Parent Key | Child Key |
| Status Identifier | Status Identifier |
| "Discretionary Review Status to Discretionary TIme Review" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "Discretionary Review Status to Discretionary TIme Review" Bound Attachments |
| Name | Current Value |
| "Person to Discretionary TIme Review" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | FK_DTR_TO_GL_PERSON |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | Person |
| Child Entity | Discretionary TIme Review |
| Cardinality | Zero or One to Zero or More |
| Existence | Optional |
| Propagated Key | Primary Key |
| "Person to Discretionary TIme Review" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "Person to Discretionary TIme Review" Foreign Keys |
| Parent Key | Child Key |
| Person Identifier | Group Leader Person Identifier |
| "Person to Discretionary TIme Review" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "Person to Discretionary TIme Review" Bound Attachments |
| Name | Current Value |
| "Proposal Instrument to Discretionary TIme Review" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_DTR_TO_PRPSL_INSTR |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | Proposal Instrument |
| Child Entity | Discretionary TIme Review |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "Proposal Instrument to Discretionary TIme Review" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "Proposal Instrument to Discretionary TIme Review" Foreign Keys |
| Parent Key | Child Key |
| Proposal Identifier, Submission Number, Instrument Identifier | Proposal Identifier, Submission Number, Instrument Identifier |
| "Proposal Instrument to Discretionary TIme Review" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "Proposal Instrument to Discretionary TIme Review" Bound Attachments |
| Name | Current Value |
| "Experiment Schedule to Experiment Instrument Team Safety Review" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_EITSR_TO_EXPT_SCHED |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | Experiment Schedule |
| Child Entity | Experiment Instrument Team Safety Review |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "Experiment Schedule to Experiment Instrument Team Safety Review" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "Experiment Schedule to Experiment Instrument Team Safety Review" Foreign Keys |
| Parent Key | Child Key |
| Proposal Identifier, Submission Number, Instrument Identifier, Run Number | Proposal Identifier, Submission Number, Instrument Identifier, Run Number |
| "Experiment Schedule to Experiment Instrument Team Safety Review" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "Experiment Schedule to Experiment Instrument Team Safety Review" Bound Attachments |
| Name | Current Value |
| "Experiment Sample to Experiment Sample Form Association" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_ESFA_TO_EXPT_SMPL |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | Experiment Sample |
| Child Entity | Experiment Sample Form Association |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "Experiment Sample to Experiment Sample Form Association" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "Experiment Sample to Experiment Sample Form Association" Foreign Keys |
| Parent Key | Child Key |
| Proposal Identifier, Submission Number, Sample Identifier | Proposal Identifier, Submission Number, Sample Identifier |
| "Experiment Sample to Experiment Sample Form Association" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "Experiment Sample to Experiment Sample Form Association" Bound Attachments |
| Name | Current Value |
| "Experiment Sample to Experiment Sample Hazard Association" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_ESHA_TO_EXPT_SMPL |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | Experiment Sample |
| Child Entity | Experiment Sample Hazard Association |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "Experiment Sample to Experiment Sample Hazard Association" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "Experiment Sample to Experiment Sample Hazard Association" Foreign Keys |
| Parent Key | Child Key |
| Proposal Identifier, Submission Number, Sample Identifier | Proposal Identifier, Submission Number, Sample Identifier |
| "Experiment Sample to Experiment Sample Hazard Association" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "Experiment Sample to Experiment Sample Hazard Association" Bound Attachments |
| Name | Current Value |
| "Experiment Sample to Experiment Sample Instrument Association" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | fk_esia_to_expt_smpl |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | Experiment Sample |
| Child Entity | Experiment Sample Instrument Association |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "Experiment Sample to Experiment Sample Instrument Association" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "Experiment Sample to Experiment Sample Instrument Association" Foreign Keys |
| Parent Key | Child Key |
| Proposal Identifier, Submission Number, Sample Identifier | Proposal Identifier, Submission Number, Sample Identifier |
| "Experiment Sample to Experiment Sample Instrument Association" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "Experiment Sample to Experiment Sample Instrument Association" Bound Attachments |
| Name | Current Value |
| "XF_ADMIN.Instrument to Experiment Sample Instrument Association" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | fk_esia_to_instr |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | XF_ADMIN.Instrument |
| Child Entity | Experiment Sample Instrument Association |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "XF_ADMIN.Instrument to Experiment Sample Instrument Association" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "XF_ADMIN.Instrument to Experiment Sample Instrument Association" Foreign Keys |
| Parent Key | Child Key |
| Instrument Identifier | Instrument Identifier |
| "XF_ADMIN.Instrument to Experiment Sample Instrument Association" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "XF_ADMIN.Instrument to Experiment Sample Instrument Association" Bound Attachments |
| Name | Current Value |
| "Experiment Sample to Experiment Sample Special Requirement Association" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_ESSRA_TO_EXPT_SMPL |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | Experiment Sample |
| Child Entity | Experiment Sample Special Requirement Association |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "Experiment Sample to Experiment Sample Special Requirement Association" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "Experiment Sample to Experiment Sample Special Requirement Association" Foreign Keys |
| Parent Key | Child Key |
| Proposal Identifier, Submission Number, Sample Identifier | Proposal Identifier, Submission Number, Sample Identifier |
| "Experiment Sample to Experiment Sample Special Requirement Association" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "Experiment Sample to Experiment Sample Special Requirement Association" Bound Attachments |
| Name | Current Value |
| "XF_ADMIN.Employee to Experiment Resource Schedule" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | FK_EXPT_RES_SCH_TO_EMP |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | XF_ADMIN.Employee |
| Child Entity | Experiment Resource Schedule |
| Cardinality | Zero or One to Zero or More |
| Existence | Optional |
| Propagated Key | Primary Key |
| "XF_ADMIN.Employee to Experiment Resource Schedule" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "XF_ADMIN.Employee to Experiment Resource Schedule" Foreign Keys |
| Parent Key | Child Key |
| Badge Number | Requested By Badge Number |
| "XF_ADMIN.Employee to Experiment Resource Schedule" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "XF_ADMIN.Employee to Experiment Resource Schedule" Bound Attachments |
| Name | Current Value |
| "Proposal Instrument to Experiment Schedule" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_EXPT_SCH_TO_PRPSL_INSTR |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | Proposal Instrument |
| Child Entity | Experiment Schedule |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "Proposal Instrument to Experiment Schedule" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "Proposal Instrument to Experiment Schedule" Foreign Keys |
| Parent Key | Child Key |
| Proposal Identifier, Submission Number, Instrument Identifier | Proposal Identifier, Submission Number, Instrument Identifier |
| "Proposal Instrument to Experiment Schedule" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "Proposal Instrument to Experiment Schedule" Bound Attachments |
| Name | Current Value |
| "XF_ADMIN.Employee to Experiment Schedule" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | FK_EXPT_SCHED_TO_EMP |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | XF_ADMIN.Employee |
| Child Entity | Experiment Schedule |
| Cardinality | Zero or One to Zero or More |
| Existence | Optional |
| Propagated Key | Primary Key |
| "XF_ADMIN.Employee to Experiment Schedule" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "XF_ADMIN.Employee to Experiment Schedule" Foreign Keys |
| Parent Key | Child Key |
| Badge Number | Host Badge Number |
| "XF_ADMIN.Employee to Experiment Schedule" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "XF_ADMIN.Employee to Experiment Schedule" Bound Attachments |
| Name | Current Value |
| "Proposal Submission to Experiment Sample Environment" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_EXPT_SMPL_ENV_TO_PRPSL_SUB |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | Proposal Submission |
| Child Entity | Experiment Sample Environment |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "Proposal Submission to Experiment Sample Environment" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "Proposal Submission to Experiment Sample Environment" Foreign Keys |
| Parent Key | Child Key |
| Proposal Identifier, Submission Number | Proposal Identifier, Submission Number |
| "Proposal Submission to Experiment Sample Environment" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "Proposal Submission to Experiment Sample Environment" Bound Attachments |
| Name | Current Value |
| "Unit of Pressure to Experiment Sample Environment" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | FK_EXPT_SMPL_ENV_TO_UOP |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | Unit of Pressure |
| Child Entity | Experiment Sample Environment |
| Cardinality | Zero or One to Zero or More |
| Existence | Optional |
| Propagated Key | Primary Key |
| "Unit of Pressure to Experiment Sample Environment" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "Unit of Pressure to Experiment Sample Environment" Foreign Keys |
| Parent Key | Child Key |
| Pressure Unit Identifier | Pressure Unit Identifier |
| "Unit of Pressure to Experiment Sample Environment" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "Unit of Pressure to Experiment Sample Environment" Bound Attachments |
| Name | Current Value |
| "Experiment Sample to Experiment Sample Sample Environment Association" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_EXPT_SMPL_SMPL_ENV |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | Experiment Sample |
| Child Entity | Experiment Sample Sample Environment Association |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "Experiment Sample to Experiment Sample Sample Environment Association" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "Experiment Sample to Experiment Sample Sample Environment Association" Foreign Keys |
| Parent Key | Child Key |
| Proposal Identifier, Submission Number, Sample Identifier | Proposal Identifier, Submission Number, Sample Identifier |
| "Experiment Sample to Experiment Sample Sample Environment Association" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "Experiment Sample to Experiment Sample Sample Environment Association" Bound Attachments |
| Name | Current Value |
| "Experiment Sample to Experiment Sample Sample Safety Association" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_EXPT_SMPL_SMPL_SAFE |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | Experiment Sample |
| Child Entity | Experiment Sample Sample Safety Association |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "Experiment Sample to Experiment Sample Sample Safety Association" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "Experiment Sample to Experiment Sample Sample Safety Association" Foreign Keys |
| Parent Key | Child Key |
| Proposal Identifier, Submission Number, Sample Identifier | Proposal Identifier, Submission Number, Sample Identifier |
| "Experiment Sample to Experiment Sample Sample Safety Association" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "Experiment Sample to Experiment Sample Sample Safety Association" Bound Attachments |
| Name | Current Value |
| "Proposal Submission to Experiment Sample" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_EXPT_SMPL_TO_PRPSL_SUB |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | Proposal Submission |
| Child Entity | Experiment Sample |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "Proposal Submission to Experiment Sample" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "Proposal Submission to Experiment Sample" Foreign Keys |
| Parent Key | Child Key |
| Proposal Identifier, Submission Number | Proposal Identifier, Submission Number |
| "Proposal Submission to Experiment Sample" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "Proposal Submission to Experiment Sample" Bound Attachments |
| Name | Current Value |
| "Unit of Temperature to Experiment Sample" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | FK_EXPT_SMPL_TO_TEMP_UNIT |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | Unit of Temperature |
| Child Entity | Experiment Sample |
| Cardinality | Zero or One to Zero or More |
| Existence | Optional |
| Propagated Key | Primary Key |
| "Unit of Temperature to Experiment Sample" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "Unit of Temperature to Experiment Sample" Foreign Keys |
| Parent Key | Child Key |
| Temperature Unit Identifier | Temperature Unit Identifier |
| "Unit of Temperature to Experiment Sample" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "Unit of Temperature to Experiment Sample" Bound Attachments |
| Name | Current Value |
| "Experiment Sample Approval Code to Experiment Sample" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | FK_EXPT_TO_EXPT_SMPL_APPR_CD |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | Experiment Sample Approval Code |
| Child Entity | Experiment Sample |
| Cardinality | Zero or One to Zero or More |
| Existence | Optional |
| Propagated Key | Primary Key |
| "Experiment Sample Approval Code to Experiment Sample" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "Experiment Sample Approval Code to Experiment Sample" Foreign Keys |
| Parent Key | Child Key |
| Approve Identifer | Approve Identifer |
| "Experiment Sample Approval Code to Experiment Sample" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "Experiment Sample Approval Code to Experiment Sample" Bound Attachments |
| Name | Current Value |
| "Person to Feedback" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_FEEDBACK_TO_PERSON |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | Person |
| Child Entity | Feedback |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "Person to Feedback" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "Person to Feedback" Foreign Keys |
| Parent Key | Child Key |
| Person Identifier | Person Identifier |
| "Person to Feedback" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "Person to Feedback" Bound Attachments |
| Name | Current Value |
| "Feasibility Review Category to Feasibility Review Status" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_FRS_TO_FEAS_REV_CAT |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | Feasibility Review Category |
| Child Entity | Feasibility Review Status |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "Feasibility Review Category to Feasibility Review Status" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "Feasibility Review Category to Feasibility Review Status" Foreign Keys |
| Parent Key | Child Key |
| Feasibility Review Category Identifier | Feasibility Review Category Identifier |
| "Feasibility Review Category to Feasibility Review Status" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "Feasibility Review Category to Feasibility Review Status" Bound Attachments |
| Name | Current Value |
| "Industry Contact to Industry Contact Instrument" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_ICI_TO_INDUS_CONT |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | Industry Contact |
| Child Entity | Industry Contact Instrument |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "Industry Contact to Industry Contact Instrument" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "Industry Contact to Industry Contact Instrument" Foreign Keys |
| Parent Key | Child Key |
| Identifier | Identifier |
| "Industry Contact to Industry Contact Instrument" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "Industry Contact to Industry Contact Instrument" Bound Attachments |
| Name | Current Value |
| "Proposal Instrument to Instrument Development Team Review Committee" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_IDT_REV_COMM_TO_PRPSL_INSTR |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | Proposal Instrument |
| Child Entity | Instrument Development Team Review Committee |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "Proposal Instrument to Instrument Development Team Review Committee" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "Proposal Instrument to Instrument Development Team Review Committee" Foreign Keys |
| Parent Key | Child Key |
| Proposal Identifier, Submission Number, Instrument Identifier | Proposal Identifier, Submission Number, Instrument Identifier |
| "Proposal Instrument to Instrument Development Team Review Committee" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "Proposal Instrument to Instrument Development Team Review Committee" Bound Attachments |
| Name | Current Value |
| "Person to Instrument Development Team Review" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_IDT_REV_TO_PERSON |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | Person |
| Child Entity | Instrument Development Team Review |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "Person to Instrument Development Team Review" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "Person to Instrument Development Team Review" Foreign Keys |
| Parent Key | Child Key |
| Person Identifier | Person Identifier |
| "Person to Instrument Development Team Review" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "Person to Instrument Development Team Review" Bound Attachments |
| Name | Current Value |
| "Proposal Instrument to Instrument Development Team Review" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_IDT_REV_TO_PRPSL_INSTR |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | Proposal Instrument |
| Child Entity | Instrument Development Team Review |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "Proposal Instrument to Instrument Development Team Review" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "Proposal Instrument to Instrument Development Team Review" Foreign Keys |
| Parent Key | Child Key |
| Proposal Identifier, Submission Number, Instrument Identifier | Proposal Identifier, Submission Number, Instrument Identifier |
| "Proposal Instrument to Instrument Development Team Review" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "Proposal Instrument to Instrument Development Team Review" Bound Attachments |
| Name | Current Value |
| "XF_ADMIN.Instrument to Instrument Instrument Proposal Question Association" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_IIPQA_TO_INSTR |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | XF_ADMIN.Instrument |
| Child Entity | Instrument Instrument Proposal Question Association |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "XF_ADMIN.Instrument to Instrument Instrument Proposal Question Association" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "XF_ADMIN.Instrument to Instrument Instrument Proposal Question Association" Foreign Keys |
| Parent Key | Child Key |
| Instrument Identifier | Instrument Identifier |
| "XF_ADMIN.Instrument to Instrument Instrument Proposal Question Association" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "XF_ADMIN.Instrument to Instrument Instrument Proposal Question Association" Bound Attachments |
| Name | Current Value |
| "Instrument Proposal Question to Instrument Instrument Proposal Question Association" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_IIPQA_TO_INSTR_PRPSL_QUES |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | Instrument Proposal Question |
| Child Entity | Instrument Instrument Proposal Question Association |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "Instrument Proposal Question to Instrument Instrument Proposal Question Association" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "Instrument Proposal Question to Instrument Instrument Proposal Question Association" Foreign Keys |
| Parent Key | Child Key |
| Question Identifier | Question Identifier |
| "Instrument Proposal Question to Instrument Instrument Proposal Question Association" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "Instrument Proposal Question to Instrument Instrument Proposal Question Association" Bound Attachments |
| Name | Current Value |
| "XF_ADMIN.Instrument to Industry Contact Instrument" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_INDUS_CON_INSTR_TO_INSTR |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | XF_ADMIN.Instrument |
| Child Entity | Industry Contact Instrument |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "XF_ADMIN.Instrument to Industry Contact Instrument" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "XF_ADMIN.Instrument to Industry Contact Instrument" Foreign Keys |
| Parent Key | Child Key |
| Instrument Identifier | Instrument Identifier |
| "XF_ADMIN.Instrument to Industry Contact Instrument" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "XF_ADMIN.Instrument to Industry Contact Instrument" Bound Attachments |
| Name | Current Value |
| "Industry Contact Method to Industry Contact" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | FK_INDUS_CONT_CONT_METH |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | Industry Contact Method |
| Child Entity | Industry Contact |
| Cardinality | Zero or One to Zero or More |
| Existence | Optional |
| Propagated Key | Primary Key |
| "Industry Contact Method to Industry Contact" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "Industry Contact Method to Industry Contact" Foreign Keys |
| Parent Key | Child Key |
| Preferred Contact Method Identifier | Preferred Contact Method Identifier |
| "Industry Contact Method to Industry Contact" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "Industry Contact Method to Industry Contact" Bound Attachments |
| Name | Current Value |
| "Country to Industry Contact" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | FK_INDUS_CONT_TO_CNTRY |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | Country |
| Child Entity | Industry Contact |
| Cardinality | Zero or One to Zero or More |
| Existence | Optional |
| Propagated Key | Primary Key |
| "Country to Industry Contact" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "Country to Industry Contact" Foreign Keys |
| Parent Key | Child Key |
| Country Identifier | Country Identifier |
| "Country to Industry Contact" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "Country to Industry Contact" Bound Attachments |
| Name | Current Value |
| "Experiment Facility to Instrument" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | FK_INSTR_EXPT_FACIL |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | Experiment Facility |
| Child Entity | Instrument |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "Experiment Facility to Instrument" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "Experiment Facility to Instrument" Foreign Keys |
| Parent Key | Child Key |
| Facility Identifier | Facility Identifier |
| "Experiment Facility to Instrument" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "Experiment Facility to Instrument" Bound Attachments |
| Name | Current Value |
| "XF_ADMIN.Employee to Instrument" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | FK_INSTR_GL_TO_EMP |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | XF_ADMIN.Employee |
| Child Entity | Instrument |
| Cardinality | Zero or One to Zero or More |
| Existence | Optional |
| Propagated Key | Primary Key |
| "XF_ADMIN.Employee to Instrument" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "XF_ADMIN.Employee to Instrument" Foreign Keys |
| Parent Key | Child Key |
| Badge Number | Group Leader Badge Number |
| "XF_ADMIN.Employee to Instrument" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "XF_ADMIN.Employee to Instrument" Bound Attachments |
| Name | Current Value |
| "Proposal Type to Instrument Proposal Type SoR Association" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_INTSA_TO_PRPSL_TYPE |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | Proposal Type |
| Child Entity | Instrument Proposal Type SoR Association |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "Proposal Type to Instrument Proposal Type SoR Association" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "Proposal Type to Instrument Proposal Type SoR Association" Foreign Keys |
| Parent Key | Child Key |
| Proposal Type Identifer | Proposal Type Identifer |
| "Proposal Type to Instrument Proposal Type SoR Association" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "Proposal Type to Instrument Proposal Type SoR Association" Bound Attachments |
| Name | Current Value |
| "PRPSL.Proposal Role Person Association to Instrument Program Development Review Association" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_IPDRCA_TO_PRPSL_ROLE_ASSC |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | PRPSL.Proposal Role Person Association |
| Child Entity | Instrument Program Development Review Association |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "PRPSL.Proposal Role Person Association to Instrument Program Development Review Association" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "PRPSL.Proposal Role Person Association to Instrument Program Development Review Association" Foreign Keys |
| Parent Key | Child Key |
| Role Identifer, Person Identifier | Role Identifer, Person Identifier |
| "PRPSL.Proposal Role Person Association to Instrument Program Development Review Association" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "PRPSL.Proposal Role Person Association to Instrument Program Development Review Association" Bound Attachments |
| Name | Current Value |
| "IPTS Release Number to IPTS Project Tracking" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | FK_IPT_TO_IPTS_REL_NBR |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | IPTS Release Number |
| Child Entity | IPTS Project Tracking |
| Cardinality | Zero or One to Zero or More |
| Existence | Optional |
| Propagated Key | Primary Key |
| "IPTS Release Number to IPTS Project Tracking" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "IPTS Release Number to IPTS Project Tracking" Foreign Keys |
| Parent Key | Child Key |
| Release Identifier | Release Identifier |
| "IPTS Release Number to IPTS Project Tracking" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "IPTS Release Number to IPTS Project Tracking" Bound Attachments |
| Name | Current Value |
| "Integrated Proposal System Activity to Integrated Proposal System Log" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_IPTS_LOG_TO_IPTS_ACT |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | Integrated Proposal System Activity |
| Child Entity | Integrated Proposal System Log |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "Integrated Proposal System Activity to Integrated Proposal System Log" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "Integrated Proposal System Activity to Integrated Proposal System Log" Foreign Keys |
| Parent Key | Child Key |
| Activity Identifier | Activity Identifier |
| "Integrated Proposal System Activity to Integrated Proposal System Log" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "Integrated Proposal System Activity to Integrated Proposal System Log" Bound Attachments |
| Name | Current Value |
| "PRPSL.Application File to Instrument Proposal Type SoR Association" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | FK_IPTSA_TO_APPL_FILE |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | PRPSL.Application File |
| Child Entity | Instrument Proposal Type SoR Association |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "PRPSL.Application File to Instrument Proposal Type SoR Association" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "PRPSL.Application File to Instrument Proposal Type SoR Association" Foreign Keys |
| Parent Key | Child Key |
| Application File Identifier | Application File Identifier |
| "PRPSL.Application File to Instrument Proposal Type SoR Association" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "PRPSL.Application File to Instrument Proposal Type SoR Association" Bound Attachments |
| Name | Current Value |
| "XF_ADMIN.Instrument to Instrument Proposal Type SoR Association" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_IPTSA_TO_INSTR |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | XF_ADMIN.Instrument |
| Child Entity | Instrument Proposal Type SoR Association |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "XF_ADMIN.Instrument to Instrument Proposal Type SoR Association" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "XF_ADMIN.Instrument to Instrument Proposal Type SoR Association" Foreign Keys |
| Parent Key | Child Key |
| Instrument Identifier | Instrument Identifier |
| "XF_ADMIN.Instrument to Instrument Proposal Type SoR Association" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "XF_ADMIN.Instrument to Instrument Proposal Type SoR Association" Bound Attachments |
| Name | Current Value |
| "Experiment Schedule to Laboratory Hazard Analysis" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_LAB_HAZ_ANAL_TO_EXPT_SCHED |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | Experiment Schedule |
| Child Entity | Laboratory Hazard Analysis |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "Experiment Schedule to Laboratory Hazard Analysis" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "Experiment Schedule to Laboratory Hazard Analysis" Foreign Keys |
| Parent Key | Child Key |
| Proposal Identifier, Submission Number, Instrument Identifier, Run Number | Proposal Identifier, Submission Number, Instrument Identifier, Run Number |
| "Experiment Schedule to Laboratory Hazard Analysis" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "Experiment Schedule to Laboratory Hazard Analysis" Bound Attachments |
| Name | Current Value |
| "Proposal Submission to Laboratory Hazard Analysis" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_LAB_HAZ_ANAL_TO_PRPSL_SUB |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | Proposal Submission |
| Child Entity | Laboratory Hazard Analysis |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "Proposal Submission to Laboratory Hazard Analysis" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "Proposal Submission to Laboratory Hazard Analysis" Foreign Keys |
| Parent Key | Child Key |
| Proposal Identifier, Submission Number | Proposal Identifier, Submission Number |
| "Proposal Submission to Laboratory Hazard Analysis" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "Proposal Submission to Laboratory Hazard Analysis" Bound Attachments |
| Name | Current Value |
| "Laboratory Hazard Analysis to Laboratory Training" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_LAB_TRAIN_TO_LAB_HAZ_ANAL |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | Laboratory Hazard Analysis |
| Child Entity | Laboratory Training |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "Laboratory Hazard Analysis to Laboratory Training" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "Laboratory Hazard Analysis to Laboratory Training" Foreign Keys |
| Parent Key | Child Key |
| Proposal Identifier, Submission Number, Instrument Identifier, Run Number | Proposal Identifier, Submission Number, Instrument Identifier, Run Number |
| "Laboratory Hazard Analysis to Laboratory Training" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "Laboratory Hazard Analysis to Laboratory Training" Bound Attachments |
| Name | Current Value |
| "Person to Laboratory Training" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_LAB_TRAIN_TO_PERSON |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | Person |
| Child Entity | Laboratory Training |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "Person to Laboratory Training" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "Person to Laboratory Training" Foreign Keys |
| Parent Key | Child Key |
| Person Identifier | Person Identifier |
| "Person to Laboratory Training" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "Person to Laboratory Training" Bound Attachments |
| Name | Current Value |
| "Laboratory Hazard Analysis to Laboratory Hazard Analysis Control Association" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_LHACA_TO_LAB_HAZ_ANAL |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | Laboratory Hazard Analysis |
| Child Entity | Laboratory Hazard Analysis Control Association |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "Laboratory Hazard Analysis to Laboratory Hazard Analysis Control Association" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "Laboratory Hazard Analysis to Laboratory Hazard Analysis Control Association" Foreign Keys |
| Parent Key | Child Key |
| Proposal Identifier, Submission Number, Instrument Identifier, Run Number | Proposal Identifier, Submission Number, Instrument Identifier, Run Number |
| "Laboratory Hazard Analysis to Laboratory Hazard Analysis Control Association" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "Laboratory Hazard Analysis to Laboratory Hazard Analysis Control Association" Bound Attachments |
| Name | Current Value |
| "Laboratory Personal Protection Equipment to Laboratory Hazard Analysis Control Association" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_LHACA_TO_LAB_PPE |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | Laboratory Personal Protection Equipment |
| Child Entity | Laboratory Hazard Analysis Control Association |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "Laboratory Personal Protection Equipment to Laboratory Hazard Analysis Control Association" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "Laboratory Personal Protection Equipment to Laboratory Hazard Analysis Control Association" Foreign Keys |
| Parent Key | Child Key |
| Laboratory PPE Identifier | Laboratory PPE Identifier |
| "Laboratory Personal Protection Equipment to Laboratory Hazard Analysis Control Association" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "Laboratory Personal Protection Equipment to Laboratory Hazard Analysis Control Association" Bound Attachments |
| Name | Current Value |
| "Person to Proposal Instrument" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | FK_LOCAL_CONT_TO_PERSON |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | Person |
| Child Entity | Proposal Instrument |
| Cardinality | Zero or One to Zero or More |
| Existence | Optional |
| Propagated Key | Primary Key |
| "Person to Proposal Instrument" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "Person to Proposal Instrument" Foreign Keys |
| Parent Key | Child Key |
| Person Identifier | Experiment Local Contact Person Identifier |
| "Person to Proposal Instrument" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "Person to Proposal Instrument" Bound Attachments |
| Name | Current Value |
| "Workflow to Proposal Review Workflow" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | FK_NEXT_WRKFLW_TO_WRKFLW |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | Workflow |
| Child Entity | Proposal Review Workflow |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "Workflow to Proposal Review Workflow" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "Workflow to Proposal Review Workflow" Foreign Keys |
| Parent Key | Child Key |
| WorkFlow Identifier | Next WorkFlow Identifier |
| "Workflow to Proposal Review Workflow" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "Workflow to Proposal Review Workflow" Bound Attachments |
| Name | Current Value |
| "Proposal Submission to Nonvalidated Experiment Team Member" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_NONVAL_EXPT_TM_TO_PRPSL_SUB |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | Proposal Submission |
| Child Entity | Nonvalidated Experiment Team Member |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "Proposal Submission to Nonvalidated Experiment Team Member" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "Proposal Submission to Nonvalidated Experiment Team Member" Foreign Keys |
| Parent Key | Child Key |
| Proposal Identifier, Submission Number | Proposal Identifier, Submission Number |
| "Proposal Submission to Nonvalidated Experiment Team Member" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "Proposal Submission to Nonvalidated Experiment Team Member" Bound Attachments |
| Name | Current Value |
| "PRPSL.Nonvalidated Experiment Team Member to Nonvalidated Proposal Team Member Onsite Access" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_NPTMOA_TO_NETM |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | PRPSL.Nonvalidated Experiment Team Member |
| Child Entity | Nonvalidated Proposal Team Member Onsite Access |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "PRPSL.Nonvalidated Experiment Team Member to Nonvalidated Proposal Team Member Onsite Access" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "PRPSL.Nonvalidated Experiment Team Member to Nonvalidated Proposal Team Member Onsite Access" Foreign Keys |
| Parent Key | Child Key |
| Proposal Identifier, Submission Number, Email Address | Proposal Identifier, Submission Number, Email Address |
| "PRPSL.Nonvalidated Experiment Team Member to Nonvalidated Proposal Team Member Onsite Access" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "PRPSL.Nonvalidated Experiment Team Member to Nonvalidated Proposal Team Member Onsite Access" Bound Attachments |
| Name | Current Value |
| "Nonvalidated Proposal Team Member Onsite Access to Nonvalidated Team Mbr Onsite Experiment Sched Association" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_NTMOESA_TO_NPTMOA |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | Nonvalidated Proposal Team Member Onsite Access |
| Child Entity | Nonvalidated Team Mbr Onsite Experiment Sched Association |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "Nonvalidated Proposal Team Member Onsite Access to Nonvalidated Team Mbr Onsite Experiment Sched Association" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "Nonvalidated Proposal Team Member Onsite Access to Nonvalidated Team Mbr Onsite Experiment Sched Association" Foreign Keys |
| Parent Key | Child Key |
| Proposal Identifier, Submission Number, Email Address | Proposal Identifier, Submission Number, Email Address |
| "Nonvalidated Proposal Team Member Onsite Access to Nonvalidated Team Mbr Onsite Experiment Sched Association" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "Nonvalidated Proposal Team Member Onsite Access to Nonvalidated Team Mbr Onsite Experiment Sched Association" Bound Attachments |
| Name | Current Value |
| "NonValidated Person to Nonvalidated Experiment Team Member" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_NV_EXPT_TM_TO_NV_PERSON |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | NonValidated Person |
| Child Entity | Nonvalidated Experiment Team Member |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "NonValidated Person to Nonvalidated Experiment Team Member" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "NonValidated Person to Nonvalidated Experiment Team Member" Foreign Keys |
| Parent Key | Child Key |
| Email Address | Email Address |
| "NonValidated Person to Nonvalidated Experiment Team Member" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "NonValidated Person to Nonvalidated Experiment Team Member" Bound Attachments |
| Name | Current Value |
| "Person to Proposal Instrument" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | FK_OPER_FEAS_REV_TO_PERSON |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | Person |
| Child Entity | Proposal Instrument |
| Cardinality | Zero or One to Zero or More |
| Existence | Optional |
| Propagated Key | Primary Key |
| "Person to Proposal Instrument" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "Person to Proposal Instrument" Foreign Keys |
| Parent Key | Child Key |
| Person Identifier | Oeprational Feasibility Review Person Identifier |
| "Person to Proposal Instrument" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "Person to Proposal Instrument" Bound Attachments |
| Name | Current Value |
| "PRPSL.Proposal to Program Development Proposal Review" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_PDPR_TO_PROPOSAL |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | PRPSL.Proposal |
| Child Entity | Program Development Proposal Review |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "PRPSL.Proposal to Program Development Proposal Review" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "PRPSL.Proposal to Program Development Proposal Review" Foreign Keys |
| Parent Key | Child Key |
| Proposal Identifier | Proposal Identifier |
| "PRPSL.Proposal to Program Development Proposal Review" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "PRPSL.Proposal to Program Development Proposal Review" Bound Attachments |
| Name | Current Value |
| "PRPSL.Proposal to Program Development Review Committee" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_PDRC_TO_PROPOSAL |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | PRPSL.Proposal |
| Child Entity | Program Development Review Committee |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "PRPSL.Proposal to Program Development Review Committee" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "PRPSL.Proposal to Program Development Review Committee" Foreign Keys |
| Parent Key | Child Key |
| Proposal Identifier | Proposal Identifier |
| "PRPSL.Proposal to Program Development Review Committee" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "PRPSL.Proposal to Program Development Review Committee" Bound Attachments |
| Name | Current Value |
| "Experiment Safety Summary Signature Role to Proposal ESS Approval" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | FK_PEA_TO_ESSSR |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | Experiment Safety Summary Signature Role |
| Child Entity | Proposal ESS Approval |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "Experiment Safety Summary Signature Role to Proposal ESS Approval" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "Experiment Safety Summary Signature Role to Proposal ESS Approval" Foreign Keys |
| Parent Key | Child Key |
| Role Identifier | Role Identifier |
| "Experiment Safety Summary Signature Role to Proposal ESS Approval" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "Experiment Safety Summary Signature Role to Proposal ESS Approval" Bound Attachments |
| Name | Current Value |
| "Experiment Schedule to Proposal ESS Approval" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_PEA_TO_EXPT_SCHED |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | Experiment Schedule |
| Child Entity | Proposal ESS Approval |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "Experiment Schedule to Proposal ESS Approval" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "Experiment Schedule to Proposal ESS Approval" Foreign Keys |
| Parent Key | Child Key |
| Proposal Identifier, Submission Number, Instrument Identifier, Run Number | Proposal Identifier, Submission Number, Instrument Identifier, Run Number |
| "Experiment Schedule to Proposal ESS Approval" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "Experiment Schedule to Proposal ESS Approval" Bound Attachments |
| Name | Current Value |
| "Person to Proposal ESS Approval" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | FK_PEA_TO_PERSON |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | Person |
| Child Entity | Proposal ESS Approval |
| Cardinality | Zero or One to Zero or More |
| Existence | Optional |
| Propagated Key | Primary Key |
| "Person to Proposal ESS Approval" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "Person to Proposal ESS Approval" Foreign Keys |
| Parent Key | Child Key |
| Person Identifier | Person Identifier |
| "Person to Proposal ESS Approval" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "Person to Proposal ESS Approval" Bound Attachments |
| Name | Current Value |
| "Person to Proposal ESH Clarification" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_PEC_TO_PERSON |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | Person |
| Child Entity | Proposal ESH Clarification |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "Person to Proposal ESH Clarification" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "Person to Proposal ESH Clarification" Foreign Keys |
| Parent Key | Child Key |
| Person Identifier | Person Identifier |
| "Person to Proposal ESH Clarification" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "Person to Proposal ESH Clarification" Bound Attachments |
| Name | Current Value |
| "Proposal Submission to Proposal ESH Clarification" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_PEC_TO_PRPSL_SUBMISS |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | Proposal Submission |
| Child Entity | Proposal ESH Clarification |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "Proposal Submission to Proposal ESH Clarification" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "Proposal Submission to Proposal ESH Clarification" Foreign Keys |
| Parent Key | Child Key |
| Proposal Identifier, Submission Number | Proposal Identifier, Submission Number |
| "Proposal Submission to Proposal ESH Clarification" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "Proposal Submission to Proposal ESH Clarification" Bound Attachments |
| Name | Current Value |
| "PRPSL.User Profile to Person Research Area Association" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_PERS_RSCH_AREA_ASSC_TO_PERS |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | PRPSL.User Profile |
| Child Entity | Person Research Area Association |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "PRPSL.User Profile to Person Research Area Association" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "PRPSL.User Profile to Person Research Area Association" Foreign Keys |
| Parent Key | Child Key |
| Person Identifier | Person Identifier |
| "PRPSL.User Profile to Person Research Area Association" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "PRPSL.User Profile to Person Research Area 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 |
| "Feasibility Review Status to Proposal Feasibility Review" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_PFR_TO_FEAS_REVIEW_STATUS |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | Feasibility Review Status |
| Child Entity | Proposal Feasibility Review |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "Feasibility Review Status to Proposal Feasibility Review" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "Feasibility Review Status to Proposal Feasibility Review" Foreign Keys |
| Parent Key | Child Key |
| Feasibility Review Category Identifier, Feasibility Review Status Identifier | Feasibility Review Category Identifier, Feasibility Review Status Identifier |
| "Feasibility Review Status to Proposal Feasibility Review" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "Feasibility Review Status to Proposal Feasibility Review" Bound Attachments |
| Name | Current Value |
| "Proposal Instrument to Proposal Feasibility Review" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_PFR_TO_PRPSL_INSTR |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | Proposal Instrument |
| Child Entity | Proposal Feasibility Review |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "Proposal Instrument to Proposal Feasibility Review" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "Proposal Instrument to Proposal Feasibility Review" Foreign Keys |
| Parent Key | Child Key |
| Proposal Identifier, Submission Number, Instrument Identifier | Proposal Identifier, Submission Number, Instrument Identifier |
| "Proposal Instrument to Proposal Feasibility Review" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "Proposal Instrument to Proposal Feasibility Review" Bound Attachments |
| Name | Current Value |
| "Person to Proposal Feasibility Review History" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | fk_pfrh_to_person |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | Person |
| Child Entity | Proposal Feasibility Review History |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "Person to Proposal Feasibility Review History" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "Person to Proposal Feasibility Review History" Foreign Keys |
| Parent Key | Child Key |
| Person Identifier | Feasibilty Review Person identifier |
| "Person to Proposal Feasibility Review History" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "Person to Proposal Feasibility Review History" Bound Attachments |
| Name | Current Value |
| "PRPSL.Proposal Feasibility Review to Proposal Feasibility Review History" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | fk_pfrh_to_prpsl_feas_rev |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | PRPSL.Proposal Feasibility Review |
| Child Entity | Proposal Feasibility Review History |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "PRPSL.Proposal Feasibility Review to Proposal Feasibility Review History" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "PRPSL.Proposal Feasibility Review to Proposal Feasibility Review History" Foreign Keys |
| Parent Key | Child Key |
| Proposal Identifier, Submission Number, Instrument Identifier, Feasibility Review Category Identifier, Feasibility Review Status Identifier | Proposal Identifier, Submission Number, Instrument Identifier, Feasibility Review Category Identifier, Feasibility Review Status Identifier |
| "PRPSL.Proposal Feasibility Review to Proposal Feasibility Review History" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "PRPSL.Proposal Feasibility Review to Proposal Feasibility Review History" Bound Attachments |
| Name | Current Value |
| "Operational Feasibility Review Status to Proposal Instrument" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | FK_PI_TO_OPER_FEAS_REV_STAT |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | Operational Feasibility Review Status |
| Child Entity | Proposal Instrument |
| Cardinality | Zero or One to Zero or More |
| Existence | Optional |
| Propagated Key | Primary Key |
| "Operational Feasibility Review Status to Proposal Instrument" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "Operational Feasibility Review Status to Proposal Instrument" Foreign Keys |
| Parent Key | Child Key |
| Operational Feasibility Review Status Identifier | Operational Feasibility Review Status Identifier |
| "Operational Feasibility Review Status to Proposal Instrument" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "Operational Feasibility Review Status to Proposal Instrument" Bound Attachments |
| Name | Current Value |
| "Proposal Submission to Proposal Instrument Group Chair Review" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_PIGC_TO_PRPSL_SUB |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | Proposal Submission |
| Child Entity | Proposal Instrument Group Chair Review |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "Proposal Submission to Proposal Instrument Group Chair Review" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "Proposal Submission to Proposal Instrument Group Chair Review" Foreign Keys |
| Parent Key | Child Key |
| Proposal Identifier, Submission Number | Proposal Identifier, Submission Number |
| "Proposal Submission to Proposal Instrument Group Chair Review" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "Proposal Submission to Proposal Instrument Group Chair Review" Bound Attachments |
| Name | Current Value |
| "Operational Feasibility Review Category to Proposal Instrument Operational Review Category Association" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_PIORCA_TO_OPER_FEAS_REV_CAT |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | Operational Feasibility Review Category |
| Child Entity | Proposal Instrument Operational Review Category Association |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "Operational Feasibility Review Category to Proposal Instrument Operational Review Category Association" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "Operational Feasibility Review Category to Proposal Instrument Operational Review Category Association" Foreign Keys |
| Parent Key | Child Key |
| Category Identifier | Category Identifier |
| "Operational Feasibility Review Category to Proposal Instrument Operational Review Category Association" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "Operational Feasibility Review Category to Proposal Instrument Operational Review Category Association" Bound Attachments |
| Name | Current Value |
| "Proposal Instrument to Proposal Instrument Operational Review Category Association" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_PIORCA_TO_PRPSL_INSTR |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | Proposal Instrument |
| Child Entity | Proposal Instrument Operational Review Category Association |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "Proposal Instrument to Proposal Instrument Operational Review Category Association" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "Proposal Instrument to Proposal Instrument Operational Review Category Association" Foreign Keys |
| Parent Key | Child Key |
| Proposal Identifier, Submission Number, Instrument Identifier | Proposal Identifier, Submission Number, Instrument Identifier |
| "Proposal Instrument to Proposal Instrument Operational Review Category Association" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "Proposal Instrument to Proposal Instrument Operational Review Category Association" Bound Attachments |
| Name | Current Value |
| "Instrument Instrument Proposal Question Association to Proposal Instrument Question" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_PIQ_TO_INSTR_PRPSL_QUE_ASSC |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | Instrument Instrument Proposal Question Association |
| Child Entity | Proposal Instrument Question |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "Instrument Instrument Proposal Question Association to Proposal Instrument Question" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "Instrument Instrument Proposal Question Association to Proposal Instrument Question" Foreign Keys |
| Parent Key | Child Key |
| Question Identifier, Instrument Identifier | Question Identifier, Instrument Identifier |
| "Instrument Instrument Proposal Question Association to Proposal Instrument Question" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "Instrument Instrument Proposal Question Association to Proposal Instrument Question" Bound Attachments |
| Name | Current Value |
| "Proposal Instrument to Proposal Instrument Question" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_PIQ_TO_PRPSL_INSTR |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | Proposal Instrument |
| Child Entity | Proposal Instrument Question |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "Proposal Instrument to Proposal Instrument Question" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "Proposal Instrument to Proposal Instrument Question" Foreign Keys |
| Parent Key | Child Key |
| Proposal Identifier, Submission Number, Instrument Identifier | Proposal Identifier, Submission Number, Instrument Identifier |
| "Proposal Instrument to Proposal Instrument Question" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "Proposal Instrument to Proposal Instrument Question" Bound Attachments |
| Name | Current Value |
| "Proposal Instrument to Proposal Instrument Sample Environment Association" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_PISEA_TO_PRPSL_INSTR |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | Proposal Instrument |
| Child Entity | Proposal Instrument Sample Environment Association |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "Proposal Instrument to Proposal Instrument Sample Environment Association" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "Proposal Instrument to Proposal Instrument Sample Environment Association" Foreign Keys |
| Parent Key | Child Key |
| Proposal Identifier, Submission Number, Instrument Identifier | Proposal Identifier, Submission Number, Instrument Identifier |
| "Proposal Instrument to Proposal Instrument Sample Environment Association" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "Proposal Instrument to Proposal Instrument Sample Environment Association" Bound Attachments |
| Name | Current Value |
| "Proposal Submission to Proposal Laboratory Request" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_PLR_TO_PRPSL_SUB |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | Proposal Submission |
| Child Entity | Proposal Laboratory Request |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "Proposal Submission to Proposal Laboratory Request" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "Proposal Submission to Proposal Laboratory Request" Foreign Keys |
| Parent Key | Child Key |
| Proposal Identifier, Submission Number | Proposal Identifier, Submission Number |
| "Proposal Submission to Proposal Laboratory Request" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "Proposal Submission to Proposal Laboratory Request" Bound Attachments |
| Name | Current Value |
| "Proposal Laboratory Request Chemical Association to Proposal Laboratory Request Chemical PPE Association" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_PLRCA_TO_LAB_CHEM_PPE_ASSC |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | Proposal Laboratory Request Chemical Association |
| Child Entity | Proposal Laboratory Request Chemical PPE Association |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "Proposal Laboratory Request Chemical Association to Proposal Laboratory Request Chemical PPE Association" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "Proposal Laboratory Request Chemical Association to Proposal Laboratory Request Chemical PPE Association" Foreign Keys |
| Parent Key | Child Key |
| Proposal Identifier, Submission Number, Chemical Name | Proposal Identifier, Submission Number, Chemical Name |
| "Proposal Laboratory Request Chemical Association to Proposal Laboratory Request Chemical PPE Association" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "Proposal Laboratory Request Chemical Association to Proposal Laboratory Request Chemical PPE Association" Bound Attachments |
| Name | Current Value |
| "Proposal Submission to Proposal Laboratory Request Chemical Association" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_PLRCA_TO_PRPSL_SUB |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | Proposal Submission |
| Child Entity | Proposal Laboratory Request Chemical Association |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "Proposal Submission to Proposal Laboratory Request Chemical Association" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "Proposal Submission to Proposal Laboratory Request Chemical Association" Foreign Keys |
| Parent Key | Child Key |
| Proposal Identifier, Submission Number | Proposal Identifier, Submission Number |
| "Proposal Submission to Proposal Laboratory Request Chemical Association" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "Proposal Submission to Proposal Laboratory Request Chemical Association" Bound Attachments |
| Name | Current Value |
| "Experiment Facility to Proposal Laboratory Request Facility Assignment" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | fk_plrfa_to_expt_facil |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | Experiment Facility |
| Child Entity | Proposal Laboratory Request Facility Assignment |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "Experiment Facility to Proposal Laboratory Request Facility Assignment" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "Experiment Facility to Proposal Laboratory Request Facility Assignment" Foreign Keys |
| Parent Key | Child Key |
| Facility Identifier | Facility Identifier |
| "Experiment Facility to Proposal Laboratory Request Facility Assignment" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "Experiment Facility to Proposal Laboratory Request Facility Assignment" Bound Attachments |
| Name | Current Value |
| "Proposal Laboratory Request to Proposal Laboratory Request Facility Assignment" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_PLRFA_TO_PRPSL_LAB_REQ |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | Proposal Laboratory Request |
| Child Entity | Proposal Laboratory Request Facility Assignment |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "Proposal Laboratory Request to Proposal Laboratory Request Facility Assignment" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "Proposal Laboratory Request to Proposal Laboratory Request Facility Assignment" Foreign Keys |
| Parent Key | Child Key |
| Proposal Identifier, Submission Number | Proposal Identifier, Submission Number |
| "Proposal Laboratory Request to Proposal Laboratory Request Facility Assignment" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "Proposal Laboratory Request to Proposal Laboratory Request Facility Assignment" Bound Attachments |
| Name | Current Value |
| "Proposal Laboratory Request Chemical Association to Proposal Laboratory Request Hazard Association" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_PLRHA_TO_PLRCA |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | Proposal Laboratory Request Chemical Association |
| Child Entity | Proposal Laboratory Request Hazard Association |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "Proposal Laboratory Request Chemical Association to Proposal Laboratory Request Hazard Association" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "Proposal Laboratory Request Chemical Association to Proposal Laboratory Request Hazard Association" Foreign Keys |
| Parent Key | Child Key |
| Proposal Identifier, Submission Number, Chemical Name | Proposal Identifier, Submission Number, Chemical Name |
| "Proposal Laboratory Request Chemical Association to Proposal Laboratory Request Hazard Association" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "Proposal Laboratory Request Chemical Association to Proposal Laboratory Request Hazard Association" Bound Attachments |
| Name | Current Value |
| "Proposal Submission to Proposal Laboratory Request Hazard Analysis" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_PLRHA_TO_PRPSL_SUB |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | Proposal Submission |
| Child Entity | Proposal Laboratory Request Hazard Analysis |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "Proposal Submission to Proposal Laboratory Request Hazard Analysis" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "Proposal Submission to Proposal Laboratory Request Hazard Analysis" Foreign Keys |
| Parent Key | Child Key |
| Proposal Identifier, Submission Number | Proposal Identifier, Submission Number |
| "Proposal Submission to Proposal Laboratory Request Hazard Analysis" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "Proposal Submission to Proposal Laboratory Request Hazard Analysis" Bound Attachments |
| Name | Current Value |
| "Laboratory Personal Protection Equipment to Proposal Laboratory Request Hazard Analysis Control Association" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_PLRHACA_TO_LAB_PPE |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | Laboratory Personal Protection Equipment |
| Child Entity | Proposal Laboratory Request Hazard Analysis Control Association |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "Laboratory Personal Protection Equipment to Proposal Laboratory Request Hazard Analysis Control Association" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "Laboratory Personal Protection Equipment to Proposal Laboratory Request Hazard Analysis Control Association" Foreign Keys |
| Parent Key | Child Key |
| Laboratory PPE Identifier | Laboratory PPE Identifier |
| "Laboratory Personal Protection Equipment to Proposal Laboratory Request Hazard Analysis Control Association" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "Laboratory Personal Protection Equipment to Proposal Laboratory Request Hazard Analysis Control Association" Bound Attachments |
| Name | Current Value |
| "Proposal Laboratory Request Hazard Analysis to Proposal Laboratory Request Hazard Analysis Control Association" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_PLRHACA_TO_PLRHA |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | Proposal Laboratory Request Hazard Analysis |
| Child Entity | Proposal Laboratory Request Hazard Analysis Control Association |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "Proposal Laboratory Request Hazard Analysis to Proposal Laboratory Request Hazard Analysis Control Association" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "Proposal Laboratory Request Hazard Analysis to Proposal Laboratory Request Hazard Analysis Control Association" Foreign Keys |
| Parent Key | Child Key |
| Proposal Identifier, Submission Number | Proposal Identifier, Submission Number |
| "Proposal Laboratory Request Hazard Analysis to Proposal Laboratory Request Hazard Analysis Control Association" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "Proposal Laboratory Request Hazard Analysis to Proposal Laboratory Request Hazard Analysis Control Association" Bound Attachments |
| Name | Current Value |
| "PRPSL.Nonvalidated Experiment Team Member to Proposal Laboratory Request Team Member Association" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | FK_PLRTM_TO_NONVAL_EXPT_TM |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | PRPSL.Nonvalidated Experiment Team Member |
| Child Entity | Proposal Laboratory Request Team Member Association |
| Cardinality | Zero or One to Zero or More |
| Existence | Optional |
| Propagated Key | Primary Key |
| "PRPSL.Nonvalidated Experiment Team Member to Proposal Laboratory Request Team Member Association" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "PRPSL.Nonvalidated Experiment Team Member to Proposal Laboratory Request Team Member Association" Foreign Keys |
| Parent Key | Child Key |
| Proposal Identifier, Submission Number, Email Address | Proposal Identifier, Submission Number, Email Address |
| "PRPSL.Nonvalidated Experiment Team Member to Proposal Laboratory Request Team Member Association" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "PRPSL.Nonvalidated Experiment Team Member to Proposal Laboratory Request Team Member Association" Bound Attachments |
| Name | Current Value |
| "Proposal Laboratory Request to Proposal Laboratory Request Team Member Association" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_PLRTM_TO_PRPSL_LAB_REQ |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | Proposal Laboratory Request |
| Child Entity | Proposal Laboratory Request Team Member Association |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "Proposal Laboratory Request to Proposal Laboratory Request Team Member Association" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "Proposal Laboratory Request to Proposal Laboratory Request Team Member Association" Foreign Keys |
| Parent Key | Child Key |
| Proposal Identifier, Submission Number | Proposal Identifier, Submission Number |
| "Proposal Laboratory Request to Proposal Laboratory Request Team Member Association" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "Proposal Laboratory Request to Proposal Laboratory Request Team Member Association" Bound Attachments |
| Name | Current Value |
| "PRPSL.Validated Experiment Team Member to Proposal Laboratory Request Team Member Association" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | FK_PLRTM_TO_VAL_EXPT_TM |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | PRPSL.Validated Experiment Team Member |
| Child Entity | Proposal Laboratory Request Team Member Association |
| Cardinality | Zero or One to Zero or More |
| Existence | Optional |
| Propagated Key | Primary Key |
| "PRPSL.Validated Experiment Team Member to Proposal Laboratory Request Team Member Association" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "PRPSL.Validated Experiment Team Member to Proposal Laboratory Request Team Member Association" Foreign Keys |
| Parent Key | Child Key |
| Proposal Identifier, Submission Number, Person Identifier | Proposal Identifier, Submission Number, Person Identifier |
| "PRPSL.Validated Experiment Team Member to Proposal Laboratory Request Team Member Association" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "PRPSL.Validated Experiment Team Member to Proposal Laboratory Request Team Member Association" Bound Attachments |
| Name | Current Value |
| "Proposal Laboratory Request to Proposal Laboratory Request Usage Association" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_PLRUA_TO_PLR |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | Proposal Laboratory Request |
| Child Entity | Proposal Laboratory Request Usage Association |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "Proposal Laboratory Request to Proposal Laboratory Request Usage Association" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "Proposal Laboratory Request to Proposal Laboratory Request Usage Association" Foreign Keys |
| Parent Key | Child Key |
| Proposal Identifier, Submission Number | Proposal Identifier, Submission Number |
| "Proposal Laboratory Request to Proposal Laboratory Request Usage Association" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "Proposal Laboratory Request to Proposal Laboratory Request Usage Association" Bound Attachments |
| Name | Current Value |
| "Proposal Laboratory Usage Type to Proposal Laboratory Request Usage Association" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_PLRUA_TO_PLUT |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | Proposal Laboratory Usage Type |
| Child Entity | Proposal Laboratory Request Usage Association |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "Proposal Laboratory Usage Type to Proposal Laboratory Request Usage Association" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "Proposal Laboratory Usage Type to Proposal Laboratory Request Usage Association" Foreign Keys |
| Parent Key | Child Key |
| Usage Type Identifier | Usage Type Identifier |
| "Proposal Laboratory Usage Type to Proposal Laboratory Request Usage Association" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "Proposal Laboratory Usage Type to Proposal Laboratory Request Usage Association" Bound Attachments |
| Name | Current Value |
| "Proposal Laboratory Special Request Type to Proposal Laboratory Special Request Association" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_PLSA_TO_PRPSL_LAB_SPEC_TYPE |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | Proposal Laboratory Special Request Type |
| Child Entity | Proposal Laboratory Special Request Association |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "Proposal Laboratory Special Request Type to Proposal Laboratory Special Request Association" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "Proposal Laboratory Special Request Type to Proposal Laboratory Special Request Association" Foreign Keys |
| Parent Key | Child Key |
| Special Request Identifier | Special Request Identifier |
| "Proposal Laboratory Special Request Type to Proposal Laboratory Special Request Association" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "Proposal Laboratory Special Request Type to Proposal Laboratory Special Request Association" Bound Attachments |
| Name | Current Value |
| "Proposal Laboratory Request to Proposal Laboratory Special Request Association" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_PLSA_TO_PRPSL_REQ |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | Proposal Laboratory Request |
| Child Entity | Proposal Laboratory Special Request Association |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "Proposal Laboratory Request to Proposal Laboratory Special Request Association" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "Proposal Laboratory Request to Proposal Laboratory Special Request Association" Foreign Keys |
| Parent Key | Child Key |
| Proposal Identifier, Submission Number | Proposal Identifier, Submission Number |
| "Proposal Laboratory Request to Proposal Laboratory Special Request Association" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "Proposal Laboratory Request to Proposal Laboratory Special Request Association" Bound Attachments |
| Name | Current Value |
| "Proposal Laboratory Usage Level to Proposal Laboratory Request" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | FK_PLTR_TO_LAB_USAGE_LVL |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | Proposal Laboratory Usage Level |
| Child Entity | Proposal Laboratory Request |
| Cardinality | Zero or One to Zero or More |
| Existence | Optional |
| Propagated Key | Primary Key |
| "Proposal Laboratory Usage Level to Proposal Laboratory Request" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "Proposal Laboratory Usage Level to Proposal Laboratory Request" Foreign Keys |
| Parent Key | Child Key |
| Work Level Identifier | Work Level Identifier |
| "Proposal Laboratory Usage Level to Proposal Laboratory Request" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "Proposal Laboratory Usage Level to Proposal Laboratory Request" Bound Attachments |
| Name | Current Value |
| "Person to Proposal Operation Review Clarification" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | fk_porc_to_person |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | Person |
| Child Entity | Proposal Operation Review Clarification |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "Person to Proposal Operation Review Clarification" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "Person to Proposal Operation Review Clarification" Foreign Keys |
| Parent Key | Child Key |
| Person Identifier | Person Identifier |
| "Person to Proposal Operation Review Clarification" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "Person to Proposal Operation Review Clarification" Bound Attachments |
| Name | Current Value |
| "Proposal Submission to Proposal Operation Review Clarification" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | fk_porc_to_prpsl_submiss |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | Proposal Submission |
| Child Entity | Proposal Operation Review Clarification |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "Proposal Submission to Proposal Operation Review Clarification" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "Proposal Submission to Proposal Operation Review Clarification" Foreign Keys |
| Parent Key | Child Key |
| Proposal Identifier, Submission Number | Proposal Identifier, Submission Number |
| "Proposal Submission to Proposal Operation Review Clarification" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "Proposal Submission to Proposal Operation Review Clarification" Bound Attachments |
| Name | Current Value |
| "Research Area to Person Research Area Association" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_PRAA_TO_RSCH_AREA |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | Research Area |
| Child Entity | Person Research Area Association |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "Research Area to Person Research Area Association" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "Research Area to Person Research Area Association" Foreign Keys |
| Parent Key | Child Key |
| Research Area Identifier | Research Area Identifier |
| "Research Area to Person Research Area Association" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "Research Area to Person Research Area Association" Bound Attachments |
| Name | Current Value |
| "Proposal Type to Proposal" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | FK_PROPOSAL_TO_PRPSL_TYPE |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | Proposal Type |
| Child Entity | Proposal |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "Proposal Type to Proposal" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "Proposal Type to Proposal" Foreign Keys |
| Parent Key | Child Key |
| Proposal Type Identifer | Proposal Type Identifer |
| "Proposal Type to Proposal" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "Proposal Type to Proposal" Bound Attachments |
| Name | Current Value |
| "Person to Proposal Role Person Association" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_PRP_ASSC_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 |
| "PRPSL.Proposal Activity to Proposal Attachment" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | fk_prpsl_attach_to_prpsl_act |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | PRPSL.Proposal Activity |
| Child Entity | Proposal Attachment |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "PRPSL.Proposal Activity to Proposal Attachment" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "PRPSL.Proposal Activity to Proposal Attachment" Foreign Keys |
| Parent Key | Child Key |
| Activity Identifier | Activity Identifier |
| "PRPSL.Proposal Activity to Proposal Attachment" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "PRPSL.Proposal Activity to Proposal Attachment" Bound Attachments |
| Name | Current Value |
| "Proposal Submission to Proposal Attachment" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_PRPSL_ATTACH_TO_PRPSL_SUB |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | Proposal Submission |
| Child Entity | Proposal Attachment |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "Proposal Submission to Proposal Attachment" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "Proposal Submission to Proposal Attachment" Foreign Keys |
| Parent Key | Child Key |
| Proposal Identifier, Submission Number | Proposal Identifier, Submission Number |
| "Proposal Submission to Proposal Attachment" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "Proposal Submission to Proposal Attachment" Bound Attachments |
| Name | Current Value |
| "PRPSL.Proposal Activity to Proposal Clarification" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | FK_PRPSL_CLAR_PRPSL_ACT |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | PRPSL.Proposal Activity |
| Child Entity | Proposal Clarification |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "PRPSL.Proposal Activity to Proposal Clarification" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "PRPSL.Proposal Activity to Proposal Clarification" Foreign Keys |
| Parent Key | Child Key |
| Activity Identifier | Activity Identifier |
| "PRPSL.Proposal Activity to Proposal Clarification" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "PRPSL.Proposal Activity to Proposal Clarification" Bound Attachments |
| Name | Current Value |
| "Person to Proposal Clarification" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_PRPSL_CLAR_TO_PERSON |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | Person |
| Child Entity | Proposal Clarification |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "Person to Proposal Clarification" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "Person to Proposal Clarification" Foreign Keys |
| Parent Key | Child Key |
| Person Identifier | Person Identifier |
| "Person to Proposal Clarification" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "Person to Proposal Clarification" Bound Attachments |
| Name | Current Value |
| "Proposal Instrument to Proposal Clarification" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_PRPSL_CLAR_TO_PRPSL_INSTR |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | Proposal Instrument |
| Child Entity | Proposal Clarification |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "Proposal Instrument to Proposal Clarification" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "Proposal Instrument to Proposal Clarification" Foreign Keys |
| Parent Key | Child Key |
| Proposal Identifier, Submission Number, Instrument Identifier | Proposal Identifier, Submission Number, Instrument Identifier |
| "Proposal Instrument to Proposal Clarification" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "Proposal Instrument to Proposal Clarification" Bound Attachments |
| Name | Current Value |
| "Proposal Submission to Proposal Clarification" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_PRPSL_CLAR_TO_PRPSL_SUB |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | Proposal Submission |
| Child Entity | Proposal Clarification |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "Proposal Submission to Proposal Clarification" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "Proposal Submission to Proposal Clarification" Foreign Keys |
| Parent Key | Child Key |
| Proposal Identifier, Submission Number | Proposal Identifier, Submission Number |
| "Proposal Submission to Proposal Clarification" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "Proposal Submission to Proposal Clarification" Bound Attachments |
| Name | Current Value |
| "Science Review Status to Proposal Facility" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | FK_PRPSL_FACIL_SCI_RV_STAT |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | Science Review Status |
| Child Entity | Proposal Facility |
| Cardinality | Zero or One to Zero or More |
| Existence | Optional |
| Propagated Key | Primary Key |
| "Science Review Status to Proposal Facility" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "Science Review Status to Proposal Facility" Foreign Keys |
| Parent Key | Child Key |
| Science Review Status Identifier | Science Review Status Identifier |
| "Science Review Status to Proposal Facility" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "Science Review Status to Proposal Facility" Bound Attachments |
| Name | Current Value |
| "Safety Review Status to Proposal Facility" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | FK_PRPSL_FACIL_SFTY_RV_STAT |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | Safety Review Status |
| Child Entity | Proposal Facility |
| Cardinality | Zero or One to Zero or More |
| Existence | Optional |
| Propagated Key | Primary Key |
| "Safety Review Status to Proposal Facility" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "Safety Review Status to Proposal Facility" Foreign Keys |
| Parent Key | Child Key |
| Safety Review Status Identifier | Safety Review Status Identifier |
| "Safety Review Status to Proposal Facility" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "Safety Review Status to Proposal Facility" Bound Attachments |
| Name | Current Value |
| "Experiment Facility to Proposal Facility" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_PRPSL_FACIL_TO_EXPT_FACIL |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | Experiment Facility |
| Child Entity | Proposal Facility |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "Experiment Facility to Proposal Facility" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "Experiment Facility to Proposal Facility" Foreign Keys |
| Parent Key | Child Key |
| Facility Identifier | Facility Identifier |
| "Experiment Facility to Proposal Facility" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "Experiment Facility to Proposal Facility" Bound Attachments |
| Name | Current Value |
| "Proposal Submission to Proposal Facility" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_PRPSL_FACIL_TO_PRPSL_SUB |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | Proposal Submission |
| Child Entity | Proposal Facility |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "Proposal Submission to Proposal Facility" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "Proposal Submission to Proposal Facility" Foreign Keys |
| Parent Key | Child Key |
| Proposal Identifier, Submission Number | Proposal Identifier, Submission Number |
| "Proposal Submission to Proposal Facility" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "Proposal Submission to Proposal Facility" Bound Attachments |
| Name | Current Value |
| "PRPSL.Proposal to Proposal Funding" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_PRPSL_FUND_PRPSL |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | PRPSL.Proposal |
| Child Entity | Proposal Funding |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "PRPSL.Proposal to Proposal Funding" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "PRPSL.Proposal to Proposal Funding" Foreign Keys |
| Parent Key | Child Key |
| Proposal Identifier | Proposal Identifier |
| "PRPSL.Proposal to Proposal Funding" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "PRPSL.Proposal to Proposal Funding" Bound Attachments |
| Name | Current Value |
| "XF_ADMIN.Instrument to Proposal Instrument" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_PRPSL_INSTR_TO_INSTR |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | XF_ADMIN.Instrument |
| Child Entity | Proposal Instrument |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "XF_ADMIN.Instrument to Proposal Instrument" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "XF_ADMIN.Instrument to Proposal Instrument" Foreign Keys |
| Parent Key | Child Key |
| Instrument Identifier | Instrument Identifier |
| "XF_ADMIN.Instrument to Proposal Instrument" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "XF_ADMIN.Instrument to Proposal Instrument" Bound Attachments |
| Name | Current Value |
| "Proposal Instrument Status to Proposal Instrument" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | FK_PRPSL_INSTR_TO_PI_STAT |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | Proposal Instrument Status |
| Child Entity | Proposal Instrument |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "Proposal Instrument Status to Proposal Instrument" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "Proposal Instrument Status to Proposal Instrument" Foreign Keys |
| Parent Key | Child Key |
| Status Identifier | Status Identifier |
| "Proposal Instrument Status to Proposal Instrument" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "Proposal Instrument Status to Proposal Instrument" Bound Attachments |
| Name | Current Value |
| "Proposal Submission to Proposal Instrument" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_PRPSL_INSTR_TO_PRPSL_SUB |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | Proposal Submission |
| Child Entity | Proposal Instrument |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "Proposal Submission to Proposal Instrument" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "Proposal Submission to Proposal Instrument" Foreign Keys |
| Parent Key | Child Key |
| Proposal Identifier, Submission Number | Proposal Identifier, Submission Number |
| "Proposal Submission to Proposal Instrument" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "Proposal Submission to Proposal Instrument" Bound Attachments |
| Name | Current Value |
| "PRPSL.Proposal Activity to Proposal Log" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_PRPSL_LOG_PRPSL_ACT |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | PRPSL.Proposal Activity |
| Child Entity | Proposal Log |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "PRPSL.Proposal Activity to Proposal Log" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "PRPSL.Proposal Activity to Proposal Log" Foreign Keys |
| Parent Key | Child Key |
| Activity Identifier | Activity Identifier |
| "PRPSL.Proposal Activity to Proposal Log" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "PRPSL.Proposal Activity to Proposal Log" Bound Attachments |
| Name | Current Value |
| "Proposal Submission to Proposal Log" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_PRPSL_LOG_TO_PRPSL_SUB |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | Proposal Submission |
| Child Entity | Proposal Log |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "Proposal Submission to Proposal Log" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "Proposal Submission to Proposal Log" Foreign Keys |
| Parent Key | Child Key |
| Proposal Identifier, Submission Number | Proposal Identifier, Submission Number |
| "Proposal Submission to Proposal Log" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "Proposal Submission to Proposal Log" Bound Attachments |
| Name | Current Value |
| "Proposal Submission to Proposal PDF" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_PRPSL_PDF_TO_PRPSL_SUB |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | Proposal Submission |
| Child Entity | Proposal PDF |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "Proposal Submission to Proposal PDF" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "Proposal Submission to Proposal PDF" Foreign Keys |
| Parent Key | Child Key |
| Proposal Identifier, Submission Number | Proposal Identifier, Submission Number |
| "Proposal Submission to Proposal PDF" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "Proposal Submission to Proposal PDF" Bound Attachments |
| Name | Current Value |
| "PRPSL.Proposal to Proposal BES Research Area" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_PRPSL_PRPSL__TO_BES_RSCH_AREA |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | PRPSL.Proposal |
| Child Entity | Proposal BES Research Area |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "PRPSL.Proposal to Proposal BES Research Area" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "PRPSL.Proposal to Proposal BES Research Area" Foreign Keys |
| Parent Key | Child Key |
| Proposal Identifier | Proposal Identifier |
| "PRPSL.Proposal to Proposal BES Research Area" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "PRPSL.Proposal to Proposal BES Research Area" Bound Attachments |
| Name | Current Value |
| "PRPSL.Proposal Status to Proposal" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | FK_PRPSL_PRPSL_STAT |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | PRPSL.Proposal Status |
| Child Entity | Proposal |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "PRPSL.Proposal Status to Proposal" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "PRPSL.Proposal Status to Proposal" Foreign Keys |
| Parent Key | Child Key |
| Status Identifier | Status Identifier |
| "PRPSL.Proposal Status to Proposal" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "PRPSL.Proposal Status to Proposal" Bound Attachments |
| Name | Current Value |
| "PRPSL.Proposal to Proposal Subject Area" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_PRPSL_PRPSL_SUBJ_AREA |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | PRPSL.Proposal |
| Child Entity | Proposal Subject Area |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "PRPSL.Proposal to Proposal Subject Area" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "PRPSL.Proposal to Proposal Subject Area" Foreign Keys |
| Parent Key | Child Key |
| Proposal Identifier | Proposal Identifier |
| "PRPSL.Proposal to Proposal Subject Area" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "PRPSL.Proposal to Proposal Subject Area" Bound Attachments |
| Name | Current Value |
| "PRPSL.Proposal to Proposal Publication Association" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_PRPSL_PUBL_ASSC_TO_PRPSL |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | PRPSL.Proposal |
| Child Entity | Proposal Publication Association |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "PRPSL.Proposal to Proposal Publication Association" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "PRPSL.Proposal to Proposal Publication Association" Foreign Keys |
| Parent Key | Child Key |
| Proposal Identifier | Proposal Identifier |
| "PRPSL.Proposal to Proposal Publication Association" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "PRPSL.Proposal to Proposal Publication Association" Bound Attachments |
| Name | Current Value |
| "Publication to Proposal Publication Association" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_PRPSL_PUBL_ASSC_TO_PUBL |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | Publication |
| Child Entity | Proposal Publication Association |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "Publication to Proposal Publication Association" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "Publication to Proposal Publication Association" Foreign Keys |
| Parent Key | Child Key |
| Publication Identifer | Publication Identifer |
| "Publication to Proposal Publication Association" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "Publication to Proposal Publication Association" Bound Attachments |
| Name | Current Value |
| "Workflow to Proposal Review Workflow" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_PRPSL_REV_WRKFLW_TO_WRKFLW |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | Workflow |
| Child Entity | Proposal Review Workflow |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "Workflow to Proposal Review Workflow" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "Workflow to Proposal Review Workflow" Foreign Keys |
| Parent Key | Child Key |
| WorkFlow Identifier | WorkFlow Identifier |
| "Workflow to Proposal Review Workflow" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "Workflow to Proposal Review Workflow" Bound Attachments |
| Name | Current Value |
| "PRPSL.Proposal Role to Proposal Role Person Association" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_PRPSL_ROLE_PRP_ASSC |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | PRPSL.Proposal Role |
| Child Entity | Proposal Role Person Association |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "PRPSL.Proposal Role to Proposal Role Person Association" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "PRPSL.Proposal Role to Proposal Role Person Association" Foreign Keys |
| Parent Key | Child Key |
| Role Identifer | Role Identifer |
| "PRPSL.Proposal Role to Proposal Role Person Association" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "PRPSL.Proposal Role to Proposal Role Person Association" Bound Attachments |
| Name | Current Value |
| "Research Area to Proposal Research Area" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_PRPSL_RSCH_AREA_TO_RA |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | Research Area |
| Child Entity | Proposal Research Area |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "Research Area to Proposal Research Area" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "Research Area to Proposal Research Area" Foreign Keys |
| Parent Key | Child Key |
| Research Area Identifier | Research Area Identifier |
| "Research Area to Proposal Research Area" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "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_id |
| 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 |
| "PRPSL.Science Review Merit to Proposal Science Review" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | FK_PRPSL_SCI_RV_SCI_RV_MERIT |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | PRPSL.Science Review Merit |
| Child Entity | Proposal Science Review |
| Cardinality | Zero or One to Zero or More |
| Existence | Optional |
| Propagated Key | Primary Key |
| "PRPSL.Science Review Merit to Proposal Science Review" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "PRPSL.Science Review Merit to Proposal Science Review" Foreign Keys |
| Parent Key | Child Key |
| Rating Identifier | Rating Identifier |
| "PRPSL.Science Review Merit to Proposal Science Review" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "PRPSL.Science Review Merit to Proposal Science Review" Bound Attachments |
| Name | Current Value |
| "Person to Proposal Science Review Committee Review" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | fk_prpsl_src_rev_to_person |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | Person |
| Child Entity | Proposal Science Review Committee Review |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "Person to Proposal Science Review Committee Review" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "Person to Proposal Science Review Committee Review" Foreign Keys |
| Parent Key | Child Key |
| Person Identifier | Person Identifier |
| "Person to Proposal Science Review Committee Review" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "Person to Proposal Science Review Committee Review" Bound Attachments |
| Name | Current Value |
| "PRPSL.Proposal to Proposal Submission" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_PRPSL_SUB_TO_PRPSL |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | PRPSL.Proposal |
| Child Entity | Proposal Submission |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "PRPSL.Proposal to Proposal Submission" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "PRPSL.Proposal to Proposal Submission" Foreign Keys |
| Parent Key | Child Key |
| Proposal Identifier | Proposal Identifier |
| "PRPSL.Proposal to Proposal Submission" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "PRPSL.Proposal to Proposal Submission" Bound Attachments |
| Name | Current Value |
| "Proposal Review Status to Proposal Submission" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | FK_PRPSL_SUB_TO_REV_STAT |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | Proposal Review Status |
| Child Entity | Proposal Submission |
| Cardinality | Zero or One to Zero or More |
| Existence | Optional |
| Propagated Key | Primary Key |
| "Proposal Review Status to Proposal Submission" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "Proposal Review Status to Proposal Submission" Foreign Keys |
| Parent Key | Child Key |
| Review Status Identifier | Review Status Identifier |
| "Proposal Review Status to Proposal Submission" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "Proposal Review Status to Proposal Submission" Bound Attachments |
| Name | Current Value |
| "Proposal Submission Status to Proposal Submission" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | fk_prpsl_submiss_to_sub_stat |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | Proposal Submission Status |
| Child Entity | Proposal Submission |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "Proposal Submission Status to Proposal Submission" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "Proposal Submission Status to Proposal Submission" Foreign Keys |
| Parent Key | Child Key |
| Status Identifier | Status Identifier |
| "Proposal Submission Status to Proposal Submission" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "Proposal Submission Status to Proposal Submission" Bound Attachments |
| Name | Current Value |
| "Discretionary Time Category to Proposal" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | FK_PRPSL_TO_DISCRET_TIME_CAT |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | Discretionary Time Category |
| Child Entity | Proposal |
| Cardinality | Zero or One to Zero or More |
| Existence | Optional |
| Propagated Key | Primary Key |
| "Discretionary Time Category to Proposal" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "Discretionary Time Category to Proposal" Foreign Keys |
| Parent Key | Child Key |
| Discretionary Time Category Identifier | Discretionary Time Category Identifier |
| "Discretionary Time Category to Proposal" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "Discretionary Time Category to Proposal" Bound Attachments |
| Name | Current Value |
| "Person to Proposal" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | fk_prpsl_to_person |
| Relationship Business Name | |
| 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 |
| "PRPSL.Proposal to Proposal Research Area" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_PRPSL_TO_PRPSL_RSCH_AREA |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | PRPSL.Proposal |
| Child Entity | Proposal Research Area |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "PRPSL.Proposal to Proposal Research Area" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "PRPSL.Proposal to Proposal Research Area" Foreign Keys |
| Parent Key | Child Key |
| Proposal Identifier | Proposal Identifier |
| "PRPSL.Proposal to Proposal Research Area" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "PRPSL.Proposal to Proposal Research Area" Bound Attachments |
| Name | Current Value |
| "Proposal Type to Proposal Review Workflow" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | fk_prpsl_wrkflw_to_prpsl_type |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | Proposal Type |
| Child Entity | Proposal Review Workflow |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "Proposal Type to Proposal Review Workflow" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "Proposal Type to Proposal Review Workflow" Foreign Keys |
| Parent Key | Child Key |
| Proposal Type Identifer | Proposal Type Identifer |
| "Proposal Type to Proposal Review Workflow" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "Proposal Type to Proposal Review Workflow" Bound Attachments |
| Name | Current Value |
| "Proposal Continuation Justification to Proposal Submission" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | FK_PS_TO_PRPSL_CONT_JUST |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | Proposal Continuation Justification |
| Child Entity | Proposal Submission |
| Cardinality | Zero or One to Zero or More |
| Existence | Optional |
| Propagated Key | Primary Key |
| "Proposal Continuation Justification to Proposal Submission" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "Proposal Continuation Justification to Proposal Submission" Foreign Keys |
| Parent Key | Child Key |
| Continuation Justification Identifier | Continuation Justification Identifier |
| "Proposal Continuation Justification to Proposal Submission" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "Proposal Continuation Justification to Proposal Submission" Bound Attachments |
| Name | Current Value |
| "Proposal Instrument to Proposal Science Review" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_PSR_TO_PRPSL_INSTR |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | Proposal Instrument |
| Child Entity | Proposal Science Review |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "Proposal Instrument to Proposal Science Review" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "Proposal Instrument to Proposal Science Review" Foreign Keys |
| Parent Key | Child Key |
| Proposal Identifier, Submission Number, Instrument Identifier | Proposal Identifier, Submission Number, Instrument Identifier |
| "Proposal Instrument to Proposal Science Review" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "Proposal Instrument to Proposal Science Review" Bound Attachments |
| Name | Current Value |
| "Proposal Instrument to Proposal Science Review Committee Review" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_PSRCR_TO_PRPSL_INSTR |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | Proposal Instrument |
| Child Entity | Proposal Science Review Committee Review |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "Proposal Instrument to Proposal Science Review Committee Review" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "Proposal Instrument to Proposal Science Review Committee Review" Foreign Keys |
| Parent Key | Child Key |
| Proposal Identifier, Submission Number, Instrument Identifier | Proposal Identifier, Submission Number, Instrument Identifier |
| "Proposal Instrument to Proposal Science Review Committee Review" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "Proposal Instrument to Proposal Science Review Committee Review" Bound Attachments |
| Name | Current Value |
| "XF_ADMIN.Instrument to Proposal Type Instrument Association" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | fk_ptia_to_instr |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | XF_ADMIN.Instrument |
| Child Entity | Proposal Type Instrument Association |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "XF_ADMIN.Instrument to Proposal Type Instrument Association" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "XF_ADMIN.Instrument to Proposal Type Instrument Association" Foreign Keys |
| Parent Key | Child Key |
| Instrument Identifier | Instrument Identifier |
| "XF_ADMIN.Instrument to Proposal Type Instrument Association" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "XF_ADMIN.Instrument to Proposal Type Instrument Association" Bound Attachments |
| Name | Current Value |
| "Proposal Type to Proposal Type Instrument Association" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_PTIA_TO_PRPSL_TYPE |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | Proposal Type |
| Child Entity | Proposal Type Instrument Association |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "Proposal Type to Proposal Type Instrument Association" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "Proposal Type to Proposal Type Instrument Association" Foreign Keys |
| Parent Key | Child Key |
| Proposal Type Identifer | Proposal Type Identifer |
| "Proposal Type to Proposal Type Instrument Association" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "Proposal Type to Proposal Type Instrument Association" Bound Attachments |
| Name | Current Value |
| "Person to Proposal Team Member Onsite Access" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_PTMOA_TO_PERSON |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | Person |
| Child Entity | Proposal Team Member Onsite Access |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "Person to Proposal Team Member Onsite Access" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "Person to Proposal Team Member Onsite Access" Foreign Keys |
| Parent Key | Child Key |
| Person Identifier | Person Identifier |
| "Person to Proposal Team Member Onsite Access" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "Person to Proposal Team Member Onsite Access" Bound Attachments |
| Name | Current Value |
| "Person to Proposal Team Member Onsite Experiment Schedule Association" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_PTMOESA_TO_PERSON |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | Person |
| Child Entity | Proposal Team Member Onsite Experiment Schedule Association |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "Person to Proposal Team Member Onsite Experiment Schedule Association" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "Person to Proposal Team Member Onsite Experiment Schedule Association" Foreign Keys |
| Parent Key | Child Key |
| Person Identifier | Person Identifier |
| "Person to Proposal Team Member Onsite Experiment Schedule Association" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "Person to Proposal Team Member Onsite Experiment Schedule Association" Bound Attachments |
| Name | Current Value |
| "Proposal Team Member Onsite Access to Proposal Team Member Onsite Experiment Schedule Association" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_PTMOESA_TO_PTMOA |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | Proposal Team Member Onsite Access |
| Child Entity | Proposal Team Member Onsite Experiment Schedule Association |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "Proposal Team Member Onsite Access to Proposal Team Member Onsite Experiment Schedule Association" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "Proposal Team Member Onsite Access to Proposal Team Member Onsite Experiment Schedule Association" Foreign Keys |
| Parent Key | Child Key |
| Person Identifier | Person Identifier |
| "Proposal Team Member Onsite Access to Proposal Team Member Onsite Experiment Schedule Association" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "Proposal Team Member Onsite Access to Proposal Team Member Onsite Experiment Schedule Association" Bound Attachments |
| Name | Current Value |
| "Proposal Review to Proposal Type Proposal Review Association" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_PTPRA_TO_PRPSL_REV |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | Proposal Review |
| Child Entity | Proposal Type Proposal Review Association |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "Proposal Review to Proposal Type Proposal Review Association" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "Proposal Review to Proposal Type Proposal Review Association" Foreign Keys |
| Parent Key | Child Key |
| Review Identifier | Review Identifier |
| "Proposal Review to Proposal Type Proposal Review Association" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "Proposal Review to Proposal Type Proposal Review Association" Bound Attachments |
| Name | Current Value |
| "Proposal Type to Proposal Type Proposal Review Association" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_PTPRA_TO_PRPSL_TYPE |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | Proposal Type |
| Child Entity | Proposal Type Proposal Review Association |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "Proposal Type to Proposal Type Proposal Review Association" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "Proposal Type to Proposal Type Proposal Review Association" Foreign Keys |
| Parent Key | Child Key |
| Proposal Type Identifer | Proposal Type Identifer |
| "Proposal Type to Proposal Type Proposal Review Association" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "Proposal Type to Proposal Type Proposal Review Association" Bound Attachments |
| Name | Current Value |
| "Basic Energy Science Research Area to Research Area BES Research Area Association" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_RABRAA_TO_BES_RSCH_AREA |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | Basic Energy Science Research Area |
| Child Entity | Research Area BES Research Area Association |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "Basic Energy Science Research Area to Research Area BES Research Area Association" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "Basic Energy Science Research Area to Research Area BES Research Area Association" Foreign Keys |
| Parent Key | Child Key |
| Research Area Identifier | BES Research Area Identifier |
| "Basic Energy Science Research Area to Research Area BES Research Area Association" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "Basic Energy Science Research Area to Research Area BES Research Area Association" Bound Attachments |
| Name | Current Value |
| "Research Area to Research Area BES Research Area Association" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_RABRAA_TO_RSCH_AREA |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | Research Area |
| Child Entity | Research Area BES Research Area Association |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "Research Area to Research Area BES Research Area Association" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "Research Area to Research Area BES Research Area Association" Foreign Keys |
| Parent Key | Child Key |
| Research Area Identifier | Research Area Identifier |
| "Research Area to Research Area BES Research Area Association" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "Research Area to Research Area BES Research Area Association" Bound Attachments |
| Name | Current Value |
| "XF_ADMIN.Instrument to Research Area Instrument Association" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_RAIA_TO_INSTR |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | XF_ADMIN.Instrument |
| Child Entity | Research Area Instrument Association |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "XF_ADMIN.Instrument to Research Area Instrument Association" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "XF_ADMIN.Instrument to Research Area Instrument Association" Foreign Keys |
| Parent Key | Child Key |
| Instrument Identifier | Instrument Identifier |
| "XF_ADMIN.Instrument to Research Area Instrument Association" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "XF_ADMIN.Instrument to Research Area Instrument Association" Bound Attachments |
| Name | Current Value |
| "Research Area to Research Area Instrument Association" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_RAIA_TO_RSCH_AREA |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | Research Area |
| Child Entity | Research Area Instrument Association |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "Research Area to Research Area Instrument Association" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "Research Area to Research Area Instrument Association" Foreign Keys |
| Parent Key | Child Key |
| Research Area Identifier | Research Area Identifier |
| "Research Area to Research Area Instrument Association" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "Research Area to Research Area Instrument Association" Bound Attachments |
| Name | Current Value |
| "Research Area to Research Area Person Association" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_RAPA_TO_RSCH_AREA |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | Research Area |
| Child Entity | Research Area Person Association |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "Research Area to Research Area Person Association" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "Research Area to Research Area Person Association" Foreign Keys |
| Parent Key | Child Key |
| Research Area Identifier | Research Area Identifier |
| "Research Area to Research Area Person Association" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "Research Area to Research Area Person Association" Bound Attachments |
| Name | Current Value |
| "PRPSL.User Profile to Research Area Person Association" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_RAPA_TO_USER_PROF |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | PRPSL.User Profile |
| Child Entity | Research Area Person Association |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "PRPSL.User Profile to Research Area Person Association" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "PRPSL.User Profile to Research Area Person Association" Foreign Keys |
| Parent Key | Child Key |
| Person Identifier | Person Identifier |
| "PRPSL.User Profile to Research Area Person Association" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "PRPSL.User Profile to Research Area Person Association" Bound Attachments |
| Name | Current Value |
| "XF_ADMIN.Instrument to Run Cycle Instrument Request" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_RCIR_TO_INSTR |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | XF_ADMIN.Instrument |
| Child Entity | Run Cycle Instrument Request |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "XF_ADMIN.Instrument to Run Cycle Instrument Request" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "XF_ADMIN.Instrument to Run Cycle Instrument Request" Foreign Keys |
| Parent Key | Child Key |
| Instrument Identifier | Instrument Identifier |
| "XF_ADMIN.Instrument to Run Cycle Instrument Request" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "XF_ADMIN.Instrument to Run Cycle Instrument Request" Bound Attachments |
| Name | Current Value |
| "Run Cycle to Run Cycle Instrument Request" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_RCIR_TO_RUN_CYCLE |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | Run Cycle |
| Child Entity | Run Cycle Instrument Request |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "Run Cycle to Run Cycle Instrument Request" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "Run Cycle to Run Cycle Instrument Request" Foreign Keys |
| Parent Key | Child Key |
| Facility Identifier, Run Cycle Identifier | Facility Identifier, Run Cycle Identifier |
| "Run Cycle to Run Cycle Instrument Request" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "Run Cycle to Run Cycle Instrument Request" Bound Attachments |
| Name | Current Value |
| "PRPSL.Proposal to Related Proposal" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_REL_PRPSL_RPI_TO_PRPSL |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | PRPSL.Proposal |
| Child Entity | Related Proposal |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "PRPSL.Proposal to Related Proposal" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "PRPSL.Proposal to Related Proposal" Foreign Keys |
| Parent Key | Child Key |
| Proposal Identifier | Related Proposal Identifier |
| "PRPSL.Proposal to Related Proposal" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "PRPSL.Proposal to Related Proposal" Bound Attachments |
| Name | Current Value |
| "PRPSL.Proposal to Related Proposal" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_REL_PRPSL_TO_PRPSL |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | PRPSL.Proposal |
| Child Entity | Related Proposal |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "PRPSL.Proposal to Related Proposal" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "PRPSL.Proposal to Related Proposal" Foreign Keys |
| Parent Key | Child Key |
| Proposal Identifier | Proposal Identifier |
| "PRPSL.Proposal to Related Proposal" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "PRPSL.Proposal to Related Proposal" Bound Attachments |
| Name | Current Value |
| "Review Subcommittee to Review Subcommittee" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | fk_rev_subcomm_to_rev_subcomm |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | Review Subcommittee |
| Child Entity | Review Subcommittee |
| Cardinality | Zero or One to Zero or More |
| Existence | Optional |
| Propagated Key | Primary Key |
| "Review Subcommittee to Review Subcommittee" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "Review Subcommittee to Review Subcommittee" Foreign Keys |
| Parent Key | Child Key |
| Subcommittee Identifier | Parent Subcommittee Identifier |
| "Review Subcommittee to Review Subcommittee" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "Review Subcommittee to Review Subcommittee" Bound Attachments |
| Name | Current Value |
| "Proposal Instrument to Review Subcommittee Proposal Association" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_RSPA_TO_PRPSL_INSTR |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | Proposal Instrument |
| Child Entity | Review Subcommittee Proposal Association |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "Proposal Instrument to Review Subcommittee Proposal Association" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "Proposal Instrument to Review Subcommittee Proposal Association" Foreign Keys |
| Parent Key | Child Key |
| Proposal Identifier, Submission Number, Instrument Identifier | Proposal Identifier, Submission Number, Instrument Identifier |
| "Proposal Instrument to Review Subcommittee Proposal Association" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "Proposal Instrument to Review Subcommittee Proposal Association" Bound Attachments |
| Name | Current Value |
| "Review Subcommittee to Review Subcommittee Proposal Association" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_RSPA_TO_REV_SUBCOMM |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | Review Subcommittee |
| Child Entity | Review Subcommittee Proposal Association |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "Review Subcommittee to Review Subcommittee Proposal Association" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "Review Subcommittee to Review Subcommittee Proposal Association" Foreign Keys |
| Parent Key | Child Key |
| Subcommittee Identifier | Subcommittee Identifier |
| "Review Subcommittee to Review Subcommittee Proposal Association" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "Review Subcommittee to Review Subcommittee Proposal Association" Bound Attachments |
| Name | Current Value |
| "PRPSL.Proposal to Run Cycle Instrument Request" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_RUN_CYC_INSTR_REQ_TO_PRPSL |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | PRPSL.Proposal |
| Child Entity | Run Cycle Instrument Request |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "PRPSL.Proposal to Run Cycle Instrument Request" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "PRPSL.Proposal to Run Cycle Instrument Request" Foreign Keys |
| Parent Key | Child Key |
| Proposal Identifier | Proposal Identifier |
| "PRPSL.Proposal to Run Cycle Instrument Request" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "PRPSL.Proposal to Run Cycle Instrument Request" Bound Attachments |
| Name | Current Value |
| "Experiment Facility to Run Cycle" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | fk_run_cycle_expt_facil |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | Experiment Facility |
| Child Entity | Run Cycle |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "Experiment Facility to Run Cycle" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "Experiment Facility to Run Cycle" Foreign Keys |
| Parent Key | Child Key |
| Facility Identifier | Facility Identifier |
| "Experiment Facility to Run Cycle" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "Experiment Facility to Run Cycle" Bound Attachments |
| Name | Current Value |
| "Experiment Sample to Experiment Sample Sample Condition Association" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_SMPL_COND_ASSC_TO_EXPT_SMPL |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | Experiment Sample |
| Child Entity | Experiment Sample Sample Condition Association |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "Experiment Sample to Experiment Sample Sample Condition Association" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "Experiment Sample to Experiment Sample Sample Condition Association" Foreign Keys |
| Parent Key | Child Key |
| Proposal Identifier, Submission Number, Sample Identifier | Proposal Identifier, Submission Number, Sample Identifier |
| "Experiment Sample to Experiment Sample Sample Condition Association" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "Experiment Sample to Experiment Sample Sample Condition Association" Bound Attachments |
| Name | Current Value |
| "Subject Area to Proposal Subject Area" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_SUBJ_AREA_PRPSL_RA |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | Subject Area |
| Child Entity | Proposal Subject Area |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "Subject Area to Proposal Subject Area" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "Subject Area to Proposal Subject Area" Foreign Keys |
| Parent Key | Child Key |
| Subject Area Identifier | Subject Area Identifier |
| "Subject Area to Proposal Subject Area" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "Subject Area to Proposal Subject Area" Bound Attachments |
| Name | Current Value |
| "Proposal Submission to Unavailable Date" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_UNAVAIL_DTE_TO_PRPSL_SUB |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | Proposal Submission |
| Child Entity | Unavailable Date |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "Proposal Submission to Unavailable Date" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "Proposal Submission to Unavailable Date" Foreign Keys |
| Parent Key | Child Key |
| Proposal Identifier, Submission Number | Proposal Identifier, Submission Number |
| "Proposal Submission to Unavailable Date" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "Proposal Submission to Unavailable Date" Bound Attachments |
| Name | Current Value |
| "Person to User Profile" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_USER_PROFILE_TO_PERSON |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | Person |
| Child Entity | User Profile |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "Person to User Profile" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "Person to User Profile" Foreign Keys |
| Parent Key | Child Key |
| Person Identifier | Person Identifier |
| "Person to User Profile" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "Person to User Profile" Bound Attachments |
| Name | Current Value |
| "Person to User Publication" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | fk_user_publ_to_person |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | Person |
| Child Entity | User Publication |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "Person to User Publication" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "Person to User Publication" Foreign Keys |
| Parent Key | Child Key |
| Person Identifier | Person Identifier |
| "Person to User Publication" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "Person to User Publication" Bound Attachments |
| Name | Current Value |
| "PRPSL.Proposal to User Publication" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | fk_user_publ_to_prpsl |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | PRPSL.Proposal |
| Child Entity | User Publication |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "PRPSL.Proposal to User Publication" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "PRPSL.Proposal to User Publication" Foreign Keys |
| Parent Key | Child Key |
| Proposal Identifier | Proposal Identifier |
| "PRPSL.Proposal to User Publication" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "PRPSL.Proposal to User Publication" Bound Attachments |
| Name | Current Value |
| "Member Role to Validated Experiment Team Member" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | FK_VAL_EXPT_TEAM_MBR_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 |
| "Proposal Submission to Validated Experiment Team Member" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_VAL_EXPT_TM_TO_PRPSL_SUB |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | Proposal Submission |
| Child Entity | Validated Experiment Team Member |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "Proposal Submission to Validated Experiment Team Member" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "Proposal Submission to Validated Experiment Team Member" Foreign Keys |
| Parent Key | Child Key |
| Proposal Identifier, Submission Number | Proposal Identifier, Submission Number |
| "Proposal Submission to Validated Experiment Team Member" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "Proposal Submission to Validated Experiment Team Member" Bound Attachments |
| Name | Current Value |
| "Person to Validated Experiment Team Member" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_VETM_TO_PERSON |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | Person |
| Child Entity | Validated Experiment Team Member |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "Person to Validated Experiment Team Member" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "Person to Validated Experiment Team Member" Foreign Keys |
| Parent Key | Child Key |
| Person Identifier | Person Identifier |
| "Person to Validated Experiment Team Member" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "Person to Validated Experiment Team Member" Bound Attachments |
| Name | Current Value |
| "PRPSL.Proposal Activity to Proposal ESH Clarification" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | pk_pec_to_prpsl_act |
| Relationship Business Name | |
| Logical Only | No |
| Parent Entity | PRPSL.Proposal Activity |
| Child Entity | Proposal ESH Clarification |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| "PRPSL.Proposal Activity to Proposal ESH Clarification" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "PRPSL.Proposal Activity to Proposal ESH Clarification" Foreign Keys |
| Parent Key | Child Key |
| Activity Identifier | Activity Identifier |
| "PRPSL.Proposal Activity to Proposal ESH Clarification" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "PRPSL.Proposal Activity to Proposal ESH Clarification" Bound Attachments |
| Name | Current Value |