"Experiment Facility to Sample Environment" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Experiment Facility |
Child Entity | Sample Environment |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Experiment Facility to Sample Environment" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Experiment Facility to Sample Environment" Foreign Keys |
Parent Key | Child Key |
Facility Identifier | Facility Identifier |
"Experiment Facility to Sample Environment" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Experiment Facility to Sample Environment" Bound Attachments |
Name | Current Value |
"Instrument Group to Instrument" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Instrument Group |
Child Entity | Instrument |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
"Instrument Group to Instrument" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Instrument Group to Instrument" Foreign Keys |
Parent Key | Child Key |
Group Identifier | Group Identifier |
"Instrument Group to Instrument" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Instrument Group to Instrument" Bound Attachments |
Name | Current Value |
"XF_ADMIN.Instrument to Instrument Contact" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | |
Relationship Business Name | |
Logical Only | No |
Parent Entity | XF_ADMIN.Instrument |
Child Entity | Instrument Contact |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"XF_ADMIN.Instrument to Instrument Contact" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"XF_ADMIN.Instrument to Instrument Contact" Foreign Keys |
Parent Key | Child Key |
Instrument Identifier | Instrument Identifier |
"XF_ADMIN.Instrument to Instrument Contact" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"XF_ADMIN.Instrument to Instrument Contact" Bound Attachments |
Name | Current Value |
"Institute to Nonvalidated Institute" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Institute |
Child Entity | Nonvalidated Institute |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
"Institute to Nonvalidated Institute" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Institute to Nonvalidated Institute" Foreign Keys |
Parent Key | Child Key |
Institute Identifier | Institute Identifier |
"Institute to Nonvalidated Institute" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Institute to Nonvalidated Institute" Bound Attachments |
Name | Current Value |
"Beam Allocation Allotment to Beam Allocation" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_BA_TO_BEAM_ALLOC_ALLOT |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Beam Allocation Allotment |
Child Entity | Beam Allocation |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Beam Allocation Allotment to Beam Allocation" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Beam Allocation Allotment to Beam Allocation" Foreign Keys |
Parent Key | Child Key |
Allotment Identifier | Allotment Identifier |
"Beam Allocation Allotment to Beam Allocation" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Beam Allocation Allotment to Beam Allocation" Bound Attachments |
Name | Current Value |
"Proposal Type to Beam Allocation" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_BA_TO_PRPSL_TYPE |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Proposal Type |
Child Entity | Beam Allocation |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Proposal Type to Beam Allocation" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Proposal Type to Beam Allocation" Foreign Keys |
Parent Key | Child Key |
Proposal Type Identifer | Proposal Type Identifer |
"Proposal Type to Beam Allocation" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Proposal Type to Beam Allocation" Bound Attachments |
Name | Current Value |
"Beam Allocation Allotment to Beam Allocation Allotment Default" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_BAAD_TO_BEAM_ALLOC |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Beam Allocation Allotment |
Child Entity | Beam Allocation Allotment Default |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Beam Allocation Allotment to Beam Allocation Allotment Default" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Beam Allocation Allotment to Beam Allocation Allotment Default" Foreign Keys |
Parent Key | Child Key |
Allotment Identifier | Allotment Identifier |
"Beam Allocation Allotment to Beam Allocation Allotment Default" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Beam Allocation Allotment to Beam Allocation Allotment Default" Bound Attachments |
Name | Current Value |
"Proposal Type to Beam Allocation Allotment Default" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_BAAD_TO_PRPSL_TYPE |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Proposal Type |
Child Entity | Beam Allocation Allotment Default |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Proposal Type to Beam Allocation Allotment Default" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Proposal Type to Beam Allocation Allotment Default" Foreign Keys |
Parent Key | Child Key |
Proposal Type Identifer | Proposal Type Identifer |
"Proposal Type to Beam Allocation Allotment Default" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Proposal Type to Beam Allocation Allotment Default" Bound Attachments |
Name | Current Value |
"Run Cycle to Beam Allocation" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_BEAM_ALLOC_RUN_CYCLE |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Run Cycle |
Child Entity | Beam Allocation |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Run Cycle to Beam Allocation" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Run Cycle to Beam Allocation" Foreign Keys |
Parent Key | Child Key |
Facility Identifier, Run Cycle Identifier | Facility Identifier, Run Cycle Identifier |
"Run Cycle to Beam Allocation" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Run Cycle to Beam Allocation" Bound Attachments |
Name | Current Value |
"XF_ADMIN.Email Preview to Email Preview Attachment" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_EMAIL_PREV_ATT_TO_EMAIL_PREV |
Relationship Business Name | |
Logical Only | No |
Parent Entity | XF_ADMIN.Email Preview |
Child Entity | Email Preview Attachment |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"XF_ADMIN.Email Preview to Email Preview Attachment" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"XF_ADMIN.Email Preview to Email Preview Attachment" Foreign Keys |
Parent Key | Child Key |
Template Identifier, Sequence Identitifer | Template Identifier, Sequence Identitifer |
"XF_ADMIN.Email Preview to Email Preview Attachment" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"XF_ADMIN.Email Preview to Email Preview Attachment" Bound Attachments |
Name | Current Value |
"XF_ADMIN.Instrument to Email Preview" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | FK_EMAIL_PREV_TO_INSTR |
Relationship Business Name | |
Logical Only | No |
Parent Entity | XF_ADMIN.Instrument |
Child Entity | Email Preview |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
"XF_ADMIN.Instrument to Email Preview" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"XF_ADMIN.Instrument to Email Preview" Foreign Keys |
Parent Key | Child Key |
Instrument Identifier | Instrument Identifier |
"XF_ADMIN.Instrument to Email Preview" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"XF_ADMIN.Instrument to Email Preview" Bound Attachments |
Name | Current Value |
"XF_ADMIN.Email Template to Email Template Tag" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_EMAIL_TMPL_TAG_EMAIL_TEMPL |
Relationship Business Name | |
Logical Only | No |
Parent Entity | XF_ADMIN.Email Template |
Child Entity | Email Template Tag |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"XF_ADMIN.Email Template to Email Template Tag" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"XF_ADMIN.Email Template to Email Template Tag" Foreign Keys |
Parent Key | Child Key |
Template Identifier | Template Identifier |
"XF_ADMIN.Email Template to Email Template Tag" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"XF_ADMIN.Email Template to Email Template Tag" Bound Attachments |
Name | Current Value |
"XF_ADMIN.Email Template to Email Preview" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_EP_TO_EMAIL_TEMPLATE |
Relationship Business Name | |
Logical Only | No |
Parent Entity | XF_ADMIN.Email Template |
Child Entity | Email Preview |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"XF_ADMIN.Email Template to Email Preview" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"XF_ADMIN.Email Template to Email Preview" Foreign Keys |
Parent Key | Child Key |
Template Identifier | Template Identifier |
"XF_ADMIN.Email Template to Email Preview" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"XF_ADMIN.Email Template to Email Preview" Bound Attachments |
Name | Current Value |
"Experiment Facility to ESH Administrator" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_esh_admin_expt_facil |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Experiment Facility |
Child Entity | ESH Administrator |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Experiment Facility to ESH Administrator" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Experiment Facility to ESH Administrator" Foreign Keys |
Parent Key | Child Key |
Facility Identifier | Facility Identifier |
"Experiment Facility to ESH Administrator" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Experiment Facility to ESH Administrator" Bound Attachments |
Name | Current Value |
"Person to ESH Administrator" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_esh_admin_person |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Person |
Child Entity | ESH Administrator |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Person to ESH Administrator" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Person to ESH Administrator" Foreign Keys |
Parent Key | Child Key |
Person Identifier | Person Identifier |
"Person to ESH Administrator" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Person to ESH Administrator" Bound Attachments |
Name | Current Value |
"Proposal Type to Email Template Proposal Type Status Association" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_etptsa_to_prpsl_type |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Proposal Type |
Child Entity | Email Template Proposal Type Status Association |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Proposal Type to Email Template Proposal Type Status Association" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Proposal Type to Email Template Proposal Type Status Association" Foreign Keys |
Parent Key | Child Key |
Proposal Type Identifer | Proposal Type Identifer |
"Proposal Type to Email Template Proposal Type Status Association" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Proposal Type to Email Template Proposal Type Status Association" Bound Attachments |
Name | Current Value |
"Run Cycle to Facility Run Cycle" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_frc_to_run_cycle |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Run Cycle |
Child Entity | Facility Run Cycle |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Run Cycle to Facility Run Cycle" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Run Cycle to Facility Run Cycle" Foreign Keys |
Parent Key | Child Key |
Facility Identifier, Run Cycle Identifier | Facility Identifier, Run Cycle Identifier |
"Run Cycle to Facility Run Cycle" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Run Cycle to Facility Run Cycle" Bound Attachments |
Name | Current Value |
"XF_ADMIN.Instrument to Instrument Development Team" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_idt_to_instr |
Relationship Business Name | |
Logical Only | No |
Parent Entity | XF_ADMIN.Instrument |
Child Entity | Instrument Development Team |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"XF_ADMIN.Instrument to Instrument Development Team" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"XF_ADMIN.Instrument to Instrument Development Team" Foreign Keys |
Parent Key | Child Key |
Instrument Identifier | Instrument Identifier |
"XF_ADMIN.Instrument to Instrument Development Team" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"XF_ADMIN.Instrument to Instrument Development Team" Bound Attachments |
Name | Current Value |
"Person to Instrument Development Team" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_idt_to_person |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Person |
Child Entity | Instrument Development Team |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Person to Instrument Development Team" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Person to Instrument Development Team" Foreign Keys |
Parent Key | Child Key |
Person Identifier | Person Identifier |
"Person to Instrument Development Team" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Person to Instrument Development Team" Bound Attachments |
Name | Current Value |
"Instrument Group to Instrument Group Review Subcommittee Association" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_igrsa_to_instr_grp |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Instrument Group |
Child Entity | Instrument Group Review Subcommittee Association |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Instrument Group to Instrument Group Review Subcommittee Association" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Instrument Group to Instrument Group Review Subcommittee Association" Foreign Keys |
Parent Key | Child Key |
Group Identifier | Group Identifier |
"Instrument Group to Instrument Group Review Subcommittee Association" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Instrument Group to Instrument Group Review Subcommittee Association" 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 |
"Basic Energy Sciences Institute Category to Institute" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | FK_INST_TO_BES_INST_CAT |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Basic Energy Sciences Institute Category |
Child Entity | Institute |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Basic Energy Sciences Institute Category to Institute" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Basic Energy Sciences Institute Category to Institute" Foreign Keys |
Parent Key | Child Key |
Category Identifier | Category Identifier |
"Basic Energy Sciences Institute Category to Institute" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Basic Energy Sciences Institute Category to Institute" Bound Attachments |
Name | Current Value |
"Instrument Configuration to Instrument Configuration Association" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_INSTR_CFG_ASSC_INSTR_CFG |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Instrument Configuration |
Child Entity | Instrument Configuration Association |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Instrument Configuration to Instrument Configuration Association" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Instrument Configuration to Instrument Configuration Association" Foreign Keys |
Parent Key | Child Key |
Instrument Configuration Identifier | Instrument Configuration Identifier |
"Instrument Configuration to Instrument Configuration Association" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Instrument Configuration to Instrument Configuration Association" Bound Attachments |
Name | Current Value |
"XF_ADMIN.Instrument to Instrument Configuration Association" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_INSTR_CONFIG_ASSC_INST |
Relationship Business Name | |
Logical Only | No |
Parent Entity | XF_ADMIN.Instrument |
Child Entity | Instrument Configuration Association |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"XF_ADMIN.Instrument to Instrument Configuration Association" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"XF_ADMIN.Instrument to Instrument Configuration Association" Foreign Keys |
Parent Key | Child Key |
Instrument Identifier | Instrument Identifier |
"XF_ADMIN.Instrument to Instrument Configuration Association" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"XF_ADMIN.Instrument to Instrument Configuration Association" 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 |
"Instrument Group to Instrument Group Chair" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_instr_grp_chair_instr_grp |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Instrument Group |
Child Entity | Instrument Group Chair |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Instrument Group to Instrument Group Chair" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Instrument Group to Instrument Group Chair" Foreign Keys |
Parent Key | Child Key |
Group Identifier | Group Identifier |
"Instrument Group to Instrument Group Chair" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Instrument Group to Instrument Group Chair" Bound Attachments |
Name | Current Value |
"Person to Instrument Group Chair" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_instr_grp_chair_person |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Person |
Child Entity | Instrument Group Chair |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Person to Instrument Group Chair" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Person to Instrument Group Chair" Foreign Keys |
Parent Key | Child Key |
Person Identifier | Person Identifier |
"Person to Instrument Group Chair" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Person to Instrument Group Chair" Bound Attachments |
Name | Current Value |
"XF_ADMIN.Instrument to Beam Allocation" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_INSTR_ID |
Relationship Business Name | |
Logical Only | No |
Parent Entity | XF_ADMIN.Instrument |
Child Entity | Beam Allocation |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"XF_ADMIN.Instrument to Beam Allocation" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"XF_ADMIN.Instrument to Beam Allocation" Foreign Keys |
Parent Key | Child Key |
Instrument Identifier | Instrument Identifier |
"XF_ADMIN.Instrument to Beam Allocation" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"XF_ADMIN.Instrument to Beam Allocation" Bound Attachments |
Name | Current Value |
"XF_ADMIN.Instrument to Instrument Reviewer" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_INSTR_REVIEW_INST |
Relationship Business Name | |
Logical Only | No |
Parent Entity | XF_ADMIN.Instrument |
Child Entity | Instrument Reviewer |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"XF_ADMIN.Instrument to Instrument Reviewer" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"XF_ADMIN.Instrument to Instrument Reviewer" Foreign Keys |
Parent Key | Child Key |
Instrument Identifier | Instrument Identifier |
"XF_ADMIN.Instrument to Instrument Reviewer" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"XF_ADMIN.Instrument to Instrument Reviewer" Bound Attachments |
Name | Current Value |
"XF_ADMIN.Employee to Instrument Scientist" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_INSTR_SCI_TO_EMP |
Relationship Business Name | |
Logical Only | No |
Parent Entity | XF_ADMIN.Employee |
Child Entity | Instrument Scientist |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"XF_ADMIN.Employee to Instrument Scientist" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"XF_ADMIN.Employee to Instrument Scientist" Foreign Keys |
Parent Key | Child Key |
Badge Number | Badge Number |
"XF_ADMIN.Employee to Instrument Scientist" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"XF_ADMIN.Employee to Instrument Scientist" Bound Attachments |
Name | Current Value |
"XF_ADMIN.Instrument to Instrument Scientist" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_INSTR_SCI_TO_INSTR |
Relationship Business Name | |
Logical Only | No |
Parent Entity | XF_ADMIN.Instrument |
Child Entity | Instrument Scientist |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"XF_ADMIN.Instrument to Instrument Scientist" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"XF_ADMIN.Instrument to Instrument Scientist" Foreign Keys |
Parent Key | Child Key |
Instrument Identifier | Instrument Identifier |
"XF_ADMIN.Instrument to Instrument Scientist" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"XF_ADMIN.Instrument to Instrument Scientist" Bound Attachments |
Name | Current Value |
"XF_ADMIN.Employee to Instrument Support" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_INSTR_SUP_TO_EMP |
Relationship Business Name | |
Logical Only | No |
Parent Entity | XF_ADMIN.Employee |
Child Entity | Instrument Support |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"XF_ADMIN.Employee to Instrument Support" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"XF_ADMIN.Employee to Instrument Support" Foreign Keys |
Parent Key | Child Key |
Badge Number | Badge Number |
"XF_ADMIN.Employee to Instrument Support" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"XF_ADMIN.Employee to Instrument Support" Bound Attachments |
Name | Current Value |
"XF_ADMIN.Instrument to Instrument Support" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_INSTR_SUP_TO_INSTR |
Relationship Business Name | |
Logical Only | No |
Parent Entity | XF_ADMIN.Instrument |
Child Entity | Instrument Support |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"XF_ADMIN.Instrument to Instrument Support" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"XF_ADMIN.Instrument to Instrument Support" Foreign Keys |
Parent Key | Child Key |
Instrument Identifier | Instrument Identifier |
"XF_ADMIN.Instrument to Instrument Support" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"XF_ADMIN.Instrument to Instrument Support" Bound Attachments |
Name | Current Value |
"Instrument Support Role to Instrument Support" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_INSTR_SUP_TO_INSTR_SUP_ROLE |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Instrument Support Role |
Child Entity | Instrument Support |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Instrument Support Role to Instrument Support" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Instrument Support Role to Instrument Support" Foreign Keys |
Parent Key | Child Key |
Support Identifier | Support Identifier |
"Instrument Support Role to Instrument Support" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Instrument Support Role to Instrument Support" Bound Attachments |
Name | Current Value |
"XF_ADMIN.Instrument to Instrument Team" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_instr_tm_to_instr |
Relationship Business Name | |
Logical Only | No |
Parent Entity | XF_ADMIN.Instrument |
Child Entity | Instrument Team |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"XF_ADMIN.Instrument to Instrument Team" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"XF_ADMIN.Instrument to Instrument Team" Foreign Keys |
Parent Key | Child Key |
Instrument Identifier | Instrument Identifier |
"XF_ADMIN.Instrument to Instrument Team" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"XF_ADMIN.Instrument to Instrument Team" Bound Attachments |
Name | Current Value |
"XF_ADMIN.Instrument to Instrument Unavailable" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_INSTR_UNAVAIL_INSTR |
Relationship Business Name | |
Logical Only | No |
Parent Entity | XF_ADMIN.Instrument |
Child Entity | Instrument Unavailable |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"XF_ADMIN.Instrument to Instrument Unavailable" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"XF_ADMIN.Instrument to Instrument Unavailable" Foreign Keys |
Parent Key | Child Key |
Instrument Identifier | Instrument Identifier |
"XF_ADMIN.Instrument to Instrument Unavailable" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"XF_ADMIN.Instrument to Instrument Unavailable" Bound Attachments |
Name | Current Value |
"Instrument Proposal Question to Instrument Proposal Question Select Instrument" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_IPQS_TO_INSTR_PRPSL_QUES |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Instrument Proposal Question |
Child Entity | Instrument Proposal Question Select Instrument |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Instrument Proposal Question to Instrument Proposal Question Select Instrument" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Instrument Proposal Question to Instrument Proposal Question Select Instrument" Foreign Keys |
Parent Key | Child Key |
Question Identifier | Question Identifier |
"Instrument Proposal Question to Instrument Proposal Question Select Instrument" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Instrument Proposal Question to Instrument Proposal Question Select Instrument" Bound Attachments |
Name | Current Value |
"XF_ADMIN.Instrument to Instrument Proposal Question Select Instrument" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_IPQSI_TO_INSTR |
Relationship Business Name | |
Logical Only | No |
Parent Entity | XF_ADMIN.Instrument |
Child Entity | Instrument Proposal Question Select Instrument |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"XF_ADMIN.Instrument to Instrument Proposal Question Select Instrument" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"XF_ADMIN.Instrument to Instrument Proposal Question Select Instrument" Foreign Keys |
Parent Key | Child Key |
Instrument Identifier | Instrument Identifier |
"XF_ADMIN.Instrument to Instrument Proposal Question Select Instrument" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"XF_ADMIN.Instrument to Instrument Proposal Question Select Instrument" Bound Attachments |
Name | Current Value |
"Instrument Proposal Question to Instrument Proposal Question Select Value" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_ipqsv_to_instr_prpsl_ques |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Instrument Proposal Question |
Child Entity | Instrument Proposal Question Select Value |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Instrument Proposal Question to Instrument Proposal Question Select Value" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Instrument Proposal Question to Instrument Proposal Question Select Value" Foreign Keys |
Parent Key | Child Key |
Question Identifier | Question Identifier |
"Instrument Proposal Question to Instrument Proposal Question Select Value" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Instrument Proposal Question to Instrument Proposal Question Select Value" Bound Attachments |
Name | Current Value |
"Experiment Facility to Laboratory" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | FK_LAB_EXPRT_FACIL |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Experiment Facility |
Child Entity | Laboratory |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Experiment Facility to Laboratory" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Experiment Facility to Laboratory" Foreign Keys |
Parent Key | Child Key |
Facility Identifier | Facility Identifier |
"Experiment Facility to Laboratory" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Experiment Facility to Laboratory" Bound Attachments |
Name | Current Value |
"Experiment Facility to Facility Notice" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_NOTICE_FACILITY |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Experiment Facility |
Child Entity | Facility Notice |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Experiment Facility to Facility Notice" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Experiment Facility to Facility Notice" Foreign Keys |
Parent Key | Child Key |
Facility Identifier | Facility Identifier |
"Experiment Facility to Facility Notice" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Experiment Facility to Facility Notice" Bound Attachments |
Name | Current Value |
"Country to Person" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | FK_PERSON_CNTRY_CNTRY |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Country |
Child Entity | Person |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Country to Person" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Country to Person" Foreign Keys |
Parent Key | Child Key |
Country Identifier | Country Identifier |
"Country to Person" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Country to Person" Bound Attachments |
Name | Current Value |
"Institute to Person" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | FK_PERSON_TO_INST |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Institute |
Child Entity | Person |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Institute to Person" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Institute to Person" Foreign Keys |
Parent Key | Child Key |
Institute Identifier | Institute Identifier |
"Institute to Person" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Institute to Person" Bound Attachments |
Name | Current Value |
"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 |
"Person to Review Subcommittee Person Association" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_rspa_to_person |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Person |
Child Entity | Review Subcommittee Person Association |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Person to Review Subcommittee Person Association" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Person to Review Subcommittee Person Association" Foreign Keys |
Parent Key | Child Key |
Person Identifier | Person Identifier |
"Person to Review Subcommittee Person Association" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Person to Review Subcommittee Person 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 |
"Review Subcommittee to Review Subcommittee Person Association" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_rspa_to_review_subcomm |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Review Subcommittee |
Child Entity | Review Subcommittee Person Association |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Review Subcommittee to Review Subcommittee Person Association" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Review Subcommittee to Review Subcommittee Person Association" Foreign Keys |
Parent Key | Child Key |
Subcommittee Identifier | Subcommittee Identifier |
"Review Subcommittee to Review Subcommittee Person Association" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Review Subcommittee to Review Subcommittee Person Association" Bound Attachments |
Name | Current Value |
"Person to Review Subcommittee Scribe" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_rss_to_person |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Person |
Child Entity | Review Subcommittee Scribe |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Person to Review Subcommittee Scribe" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Person to Review Subcommittee Scribe" Foreign Keys |
Parent Key | Child Key |
Person Identifier | Person Identifier |
"Person to Review Subcommittee Scribe" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Person to Review Subcommittee Scribe" Bound Attachments |
Name | Current Value |
"Review Subcommittee to Review Subcommittee Scribe" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_rss_to_rev_subcomm |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Review Subcommittee |
Child Entity | Review Subcommittee Scribe |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Review Subcommittee to Review Subcommittee Scribe" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Review Subcommittee to Review Subcommittee Scribe" Foreign Keys |
Parent Key | Child Key |
Subcommittee Identifier | Subcommittee Identifier |
"Review Subcommittee to Review Subcommittee Scribe" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Review Subcommittee to Review Subcommittee Scribe" 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 |
"Science Highlight Principal Investigator to Science Highlight Prinical Investigator Association" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_sci_high_pi_assc_to_pi |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Science Highlight Principal Investigator |
Child Entity | Science Highlight Prinical Investigator Association |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Science Highlight Principal Investigator to Science Highlight Prinical Investigator Association" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Science Highlight Principal Investigator to Science Highlight Prinical Investigator Association" Foreign Keys |
Parent Key | Child Key |
Email Addr | Email Addr |
"Science Highlight Principal Investigator to Science Highlight Prinical Investigator Association" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Science Highlight Principal Investigator to Science Highlight Prinical Investigator Association" Bound Attachments |
Name | Current Value |
"Science Highlight to Science Highlight Prinical Investigator Association" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_sci_high_pi_assc_to_sci_high |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Science Highlight |
Child Entity | Science Highlight Prinical Investigator Association |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Science Highlight to Science Highlight Prinical Investigator Association" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Science Highlight to Science Highlight Prinical Investigator Association" Foreign Keys |
Parent Key | Child Key |
Science Highlight Identifier | Science Highlight Identifier |
"Science Highlight to Science Highlight Prinical Investigator Association" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Science Highlight to Science Highlight Prinical Investigator Association" Bound Attachments |
Name | Current Value |
"Science Highlight Author to Science Highlight" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | fk_sci_high_to_sci_high_auth |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Science Highlight Author |
Child Entity | Science Highlight |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
"Science Highlight Author to Science Highlight" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Science Highlight Author to Science Highlight" Foreign Keys |
Parent Key | Child Key |
Email Addr | Email Addr |
"Science Highlight Author to Science Highlight" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Science Highlight Author to Science Highlight" Bound Attachments |
Name | Current Value |
"Science Highlight Category to Science Highlight" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | fk_sci_high_to_sci_high_cat |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Science Highlight Category |
Child Entity | Science Highlight |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
"Science Highlight Category to Science Highlight" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Science Highlight Category to Science Highlight" Foreign Keys |
Parent Key | Child Key |
Science Highlight Category Identifier | Science Highlight Category Identifier |
"Science Highlight Category to Science Highlight" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Science Highlight Category to Science Highlight" Bound Attachments |
Name | Current Value |
"Science Topic to Science Highlight" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | fk_sci_high_to_sci_topic |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Science Topic |
Child Entity | Science Highlight |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
"Science Topic to Science Highlight" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Science Topic to Science Highlight" Foreign Keys |
Parent Key | Child Key |
Topic Identifier | Topic Identifier |
"Science Topic to Science Highlight" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Science Topic to Science Highlight" Bound Attachments |
Name | Current Value |
"XF_ADMIN.Instrument to Sample Condition Instrument Association" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_scia_to_instr |
Relationship Business Name | |
Logical Only | No |
Parent Entity | XF_ADMIN.Instrument |
Child Entity | Sample Condition Instrument Association |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"XF_ADMIN.Instrument to Sample Condition Instrument Association" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"XF_ADMIN.Instrument to Sample Condition Instrument Association" Foreign Keys |
Parent Key | Child Key |
Instrument Identifier | Instrument Identifier |
"XF_ADMIN.Instrument to Sample Condition Instrument Association" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"XF_ADMIN.Instrument to Sample Condition Instrument Association" Bound Attachments |
Name | Current Value |
"Sample Condition to Sample Condition Instrument Association" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_scia_to_smpl_cond |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Sample Condition |
Child Entity | Sample Condition Instrument Association |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Sample Condition to Sample Condition Instrument Association" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Sample Condition to Sample Condition Instrument Association" Foreign Keys |
Parent Key | Child Key |
Sample Environment Identifier, Sample Condition Identifier | Sample Environment Identifier, Sample Condition Identifier |
"Sample Condition to Sample Condition Instrument Association" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Sample Condition to Sample Condition Instrument Association" Bound Attachments |
Name | Current Value |
"XF_ADMIN.Instrument to Sample Environment Instrument Association" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_seia_to_instr |
Relationship Business Name | |
Logical Only | No |
Parent Entity | XF_ADMIN.Instrument |
Child Entity | Sample Environment Instrument Association |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"XF_ADMIN.Instrument to Sample Environment Instrument Association" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"XF_ADMIN.Instrument to Sample Environment Instrument Association" Foreign Keys |
Parent Key | Child Key |
Instrument Identifier | Instrument Identifier |
"XF_ADMIN.Instrument to Sample Environment Instrument Association" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"XF_ADMIN.Instrument to Sample Environment Instrument Association" Bound Attachments |
Name | Current Value |
"Sample Environment to Sample Environment Instrument Association" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_seia_to_smpl_env |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Sample Environment |
Child Entity | Sample Environment Instrument Association |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Sample Environment to Sample Environment Instrument Association" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Sample Environment to Sample Environment Instrument Association" Foreign Keys |
Parent Key | Child Key |
Facility Identifier, Sample Environment Identifier | Facility Identifier, Sample Environment Identifier |
"Sample Environment to Sample Environment Instrument Association" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Sample Environment to Sample Environment Instrument Association" Bound Attachments |
Name | Current Value |
"Experiment Facility to Science Highlight Facility Association" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_shfa_to_expt_facil |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Experiment Facility |
Child Entity | Science Highlight Facility Association |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Experiment Facility to Science Highlight Facility Association" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Experiment Facility to Science Highlight Facility Association" Foreign Keys |
Parent Key | Child Key |
Facility Identifier | Facility Identifier |
"Experiment Facility to Science Highlight Facility Association" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Experiment Facility to Science Highlight Facility Association" Bound Attachments |
Name | Current Value |
"Science Highlight to Science Highlight Facility Association" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_shfa_to_sci_high |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Science Highlight |
Child Entity | Science Highlight Facility Association |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Science Highlight to Science Highlight Facility Association" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Science Highlight to Science Highlight Facility Association" Foreign Keys |
Parent Key | Child Key |
Science Highlight Identifier | Science Highlight Identifier |
"Science Highlight to Science Highlight Facility Association" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Science Highlight to Science Highlight Facility Association" Bound Attachments |
Name | Current Value |
"XF_ADMIN.Instrument to Science Highlight Instrument Association" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_shia_to_instr |
Relationship Business Name | |
Logical Only | No |
Parent Entity | XF_ADMIN.Instrument |
Child Entity | Science Highlight Instrument Association |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"XF_ADMIN.Instrument to Science Highlight Instrument Association" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"XF_ADMIN.Instrument to Science Highlight Instrument Association" Foreign Keys |
Parent Key | Child Key |
Instrument Identifier | Instrument Identifier |
"XF_ADMIN.Instrument to Science Highlight Instrument Association" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"XF_ADMIN.Instrument to Science Highlight Instrument Association" Bound Attachments |
Name | Current Value |
"Science Highlight to Science Highlight Instrument Association" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_shia_to_sci_high |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Science Highlight |
Child Entity | Science Highlight Instrument Association |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Science Highlight to Science Highlight Instrument Association" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Science Highlight to Science Highlight Instrument Association" Foreign Keys |
Parent Key | Child Key |
Science Highlight Identifier | Science Highlight Identifier |
"Science Highlight to Science Highlight Instrument Association" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Science Highlight to Science Highlight Instrument Association" Bound Attachments |
Name | Current Value |
"Science Highlight to Science Journal Highlight Association" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_sjha_to_sci_high |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Science Highlight |
Child Entity | Science Journal Highlight Association |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Science Highlight to Science Journal Highlight Association" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Science Highlight to Science Journal Highlight Association" Foreign Keys |
Parent Key | Child Key |
Science Highlight Identifier | Science Highlight Identifier |
"Science Highlight to Science Journal Highlight Association" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Science Highlight to Science Journal Highlight Association" Bound Attachments |
Name | Current Value |
"Science Journal to Science Journal Highlight Association" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_sjha_to_sci_jour |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Science Journal |
Child Entity | Science Journal Highlight Association |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Science Journal to Science Journal Highlight Association" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Science Journal to Science Journal Highlight Association" Foreign Keys |
Parent Key | Child Key |
Journal Identifier | Journal Identifier |
"Science Journal to Science Journal Highlight Association" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Science Journal to Science Journal Highlight Association" Bound Attachments |
Name | Current Value |
"XF_ADMIN.Employee to Training Person" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | FK_TP_TO_EMP |
Relationship Business Name | |
Logical Only | No |
Parent Entity | XF_ADMIN.Employee |
Child Entity | Training Person |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"XF_ADMIN.Employee to Training Person" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"XF_ADMIN.Employee to Training Person" Foreign Keys |
Parent Key | Child Key |
Badge Number | Certify Badge Number |
"XF_ADMIN.Employee to Training Person" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"XF_ADMIN.Employee to Training Person" Bound Attachments |
Name | Current Value |
"Person to Training Person" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_TP_TO_PERSON |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Person |
Child Entity | Training Person |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Person to Training Person" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Person to Training Person" Foreign Keys |
Parent Key | Child Key |
Person Identifier | Person Identifier |
"Person to Training Person" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Person to Training Person" Bound Attachments |
Name | Current Value |
"Training Module to Training Person" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_TP_TO_TRAIN_MOD |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Training Module |
Child Entity | Training Person |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Training Module to Training Person" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Training Module to Training Person" Foreign Keys |
Parent Key | Child Key |
Module Identifier | Module Identifier |
"Training Module to Training Person" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Training Module to Training Person" Bound Attachments |
Name | Current Value |
"Training Module to Training Facility Association" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_train_facil_assc_to_train |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Training Module |
Child Entity | Training Facility Association |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Training Module to Training Facility Association" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Training Module to Training Facility Association" Foreign Keys |
Parent Key | Child Key |
Module Identifier | Module Identifier |
"Training Module to Training Facility Association" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Training Module to Training Facility Association" Bound Attachments |
Name | Current Value |
"Experiment Facility to Training Facility Association" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_TRAIN_FAIL_TO_FACIL |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Experiment Facility |
Child Entity | Training Facility Association |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Experiment Facility to Training Facility Association" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Experiment Facility to Training Facility Association" Foreign Keys |
Parent Key | Child Key |
Facility Identifier | Facility Identifier |
"Experiment Facility to Training Facility Association" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Experiment Facility to Training Facility Association" Bound Attachments |
Name | Current Value |
"XF_ADMIN.Instrument to Training Instrument Association" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_train_instr_assc_to_instr |
Relationship Business Name | |
Logical Only | No |
Parent Entity | XF_ADMIN.Instrument |
Child Entity | Training Instrument Association |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"XF_ADMIN.Instrument to Training Instrument Association" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"XF_ADMIN.Instrument to Training Instrument Association" Foreign Keys |
Parent Key | Child Key |
Instrument Identifier | Instrument Identifier |
"XF_ADMIN.Instrument to Training Instrument Association" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"XF_ADMIN.Instrument to Training Instrument Association" Bound Attachments |
Name | Current Value |
"Training Module to Training Instrument Association" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_train_instr_assc_to_train |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Training Module |
Child Entity | Training Instrument Association |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Training Module to Training Instrument Association" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Training Module to Training Instrument Association" Foreign Keys |
Parent Key | Child Key |
Module Identifier | Module Identifier |
"Training Module to Training Instrument Association" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Training Module to Training Instrument Association" Bound Attachments |
Name | Current Value |
"Review Subcommittee to Instrument Group Review Subcommittee Association" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | igrsa_to_rev_subcomm |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Review Subcommittee |
Child Entity | Instrument Group Review Subcommittee Association |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Review Subcommittee to Instrument Group Review Subcommittee Association" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Review Subcommittee to Instrument Group Review Subcommittee Association" Foreign Keys |
Parent Key | Child Key |
Subcommittee Identifier | Subcommittee Identifier |
"Review Subcommittee to Instrument Group Review Subcommittee Association" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Review Subcommittee to Instrument Group Review Subcommittee Association" Bound Attachments |
Name | Current Value |