"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 |
"Experiment Resource Schedule to Experiment Resource Schedule Log" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | |
Relationship Business Name | FK_ERSL_TO_EXPT_RSRC_SCHED |
Logical Only | No |
Parent Entity | Experiment Resource Schedule |
Child Entity | Experiment Resource Schedule Log |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Experiment Resource Schedule to Experiment Resource Schedule Log" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Experiment Resource Schedule to Experiment Resource Schedule Log" Foreign Keys |
Parent Key | Child Key |
Experiment Resource Identifier | Experiment Resource Identifier |
"Experiment Resource Schedule to Experiment Resource Schedule Log" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Experiment Resource Schedule to Experiment Resource Schedule Log" Bound Attachments |
Name | Current Value |
"Experiment Resource Type to Can Substrate Cell" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Experiment Resource Type |
Child Entity | Can Substrate Cell |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Experiment Resource Type to Can Substrate Cell" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Experiment Resource Type to Can Substrate Cell" Foreign Keys |
Parent Key | Child Key |
Experiment Resource Type Identifier, Facility Identifier | Experiment Resource Type Identifier, Facility Identifier |
"Experiment Resource Type to Can Substrate Cell" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Experiment Resource Type to Can Substrate Cell" Bound Attachments |
Name | Current Value |
"EXPRESS.Unit of Measure to Experiment Resource" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | |
Relationship Business Name | |
Logical Only | No |
Parent Entity | EXPRESS.Unit of Measure |
Child Entity | Experiment Resource |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
"EXPRESS.Unit of Measure to Experiment Resource" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | An Experiment Resource fk_beam_cen_btm_to_uom EXPRESS.Unit of Measure. |
Definition | |
Note |
"EXPRESS.Unit of Measure to Experiment Resource" Foreign Keys |
Parent Key | Child Key |
Unit Identifier | Beam Center Bottom Unit of Measure |
"EXPRESS.Unit of Measure to Experiment Resource" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"EXPRESS.Unit of Measure to Experiment Resource" Bound Attachments |
Name | Current Value |
"SMPL.Sample to Sample" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | |
Relationship Business Name | |
Logical Only | No |
Parent Entity | SMPL.Sample |
Child Entity | Sample |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
"SMPL.Sample to Sample" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"SMPL.Sample to Sample" Foreign Keys |
Parent Key | Child Key |
Sample Identifier | Family Sample Identifier |
"SMPL.Sample to Sample" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"SMPL.Sample to Sample" Bound Attachments |
Name | Current Value |
"XF_ADMIN.Employee to Access Request" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_ACC_REQ_TO_EMP |
Relationship Business Name | |
Logical Only | No |
Parent Entity | XF_ADMIN.Employee |
Child Entity | Access Request |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"XF_ADMIN.Employee to Access Request" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"XF_ADMIN.Employee to Access Request" Foreign Keys |
Parent Key | Child Key |
Badge Number | Badge Number |
"XF_ADMIN.Employee to Access Request" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"XF_ADMIN.Employee to Access Request" Bound Attachments |
Name | Current Value |
"Express User Role to Access Request" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_ACC_REQ_TO_EXP_USR_ROLE |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Express User Role |
Child Entity | Access Request |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Express User Role to Access Request" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Express User Role to Access Request" Foreign Keys |
Parent Key | Child Key |
Role Identifer | Role Identifer |
"Express User Role to Access Request" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Express User Role to Access Request" Bound Attachments |
Name | Current Value |
"Experiment Resource Facility to Access Request" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_ACC_REQ_TO_EXPT_RSRC_FACIL |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Experiment Resource Facility |
Child Entity | Access Request |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Experiment Resource Facility to Access Request" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Experiment Resource Facility to Access Request" Foreign Keys |
Parent Key | Child Key |
Facility Identifier | Facility Identifier |
"Experiment Resource Facility to Access Request" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Experiment Resource Facility to Access Request" Bound Attachments |
Name | Current Value |
"EXPRESS.Unit of Measure to Experiment Resource" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | fk_bore_uom_to_uom |
Relationship Business Name | |
Logical Only | No |
Parent Entity | EXPRESS.Unit of Measure |
Child Entity | Experiment Resource |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
"EXPRESS.Unit of Measure to Experiment Resource" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EXPRESS.Unit of Measure to Experiment Resource" Foreign Keys |
Parent Key | Child Key |
Unit Identifier | Bore Size Unit of Measure |
"EXPRESS.Unit of Measure to Experiment Resource" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"EXPRESS.Unit of Measure to Experiment Resource" Bound Attachments |
Name | Current Value |
"EXPRESS.Unit of Measure to Experiment Resource" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | fk_brkdwn_uom_to_uom |
Relationship Business Name | |
Logical Only | No |
Parent Entity | EXPRESS.Unit of Measure |
Child Entity | Experiment Resource |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
"EXPRESS.Unit of Measure to Experiment Resource" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EXPRESS.Unit of Measure to Experiment Resource" Foreign Keys |
Parent Key | Child Key |
Unit Identifier | Breakdown Time Unit of Measure |
"EXPRESS.Unit of Measure to Experiment Resource" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"EXPRESS.Unit of Measure to Experiment Resource" Bound Attachments |
Name | Current Value |
"EXPRESS.Unit of Measure to Can Substrate Cell" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | fk_casc_in_to_uom |
Relationship Business Name | |
Logical Only | No |
Parent Entity | EXPRESS.Unit of Measure |
Child Entity | Can Substrate Cell |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
"EXPRESS.Unit of Measure to Can Substrate Cell" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EXPRESS.Unit of Measure to Can Substrate Cell" Foreign Keys |
Parent Key | Child Key |
Unit Identifier | Inner Dimension Unit of Measure Identifer |
"EXPRESS.Unit of Measure to Can Substrate Cell" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"EXPRESS.Unit of Measure to Can Substrate Cell" Bound Attachments |
Name | Current Value |
"EXPRESS.Unit of Measure to Can Substrate Cell" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | fk_casc_out_to_uom |
Relationship Business Name | |
Logical Only | No |
Parent Entity | EXPRESS.Unit of Measure |
Child Entity | Can Substrate Cell |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
"EXPRESS.Unit of Measure to Can Substrate Cell" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EXPRESS.Unit of Measure to Can Substrate Cell" Foreign Keys |
Parent Key | Child Key |
Unit Identifier | Outer Dimension Unit of Measure Identifier |
"EXPRESS.Unit of Measure to Can Substrate Cell" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"EXPRESS.Unit of Measure to Can Substrate Cell" Bound Attachments |
Name | Current Value |
"EXPRESS.Unit of Measure to Can Substrate Cell" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | fk_casc_press_to_uom |
Relationship Business Name | |
Logical Only | No |
Parent Entity | EXPRESS.Unit of Measure |
Child Entity | Can Substrate Cell |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
"EXPRESS.Unit of Measure to Can Substrate Cell" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EXPRESS.Unit of Measure to Can Substrate Cell" Foreign Keys |
Parent Key | Child Key |
Unit Identifier | Pressure Unit of Measure Identifier |
"EXPRESS.Unit of Measure to Can Substrate Cell" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"EXPRESS.Unit of Measure to Can Substrate Cell" Bound Attachments |
Name | Current Value |
"EXPRESS.Unit of Measure to Can Substrate Cell" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | fk_casc_temp_to_uom |
Relationship Business Name | |
Logical Only | No |
Parent Entity | EXPRESS.Unit of Measure |
Child Entity | Can Substrate Cell |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
"EXPRESS.Unit of Measure to Can Substrate Cell" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EXPRESS.Unit of Measure to Can Substrate Cell" Foreign Keys |
Parent Key | Child Key |
Unit Identifier | Temperature Unit of Measure Identifier |
"EXPRESS.Unit of Measure to Can Substrate Cell" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"EXPRESS.Unit of Measure to Can Substrate Cell" Bound Attachments |
Name | Current Value |
"Experiment Resource Status to Can Substrate Cell" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | fk_casc_to_expt_rsrc_stat |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Experiment Resource Status |
Child Entity | Can Substrate Cell |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Experiment Resource Status to Can Substrate Cell" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Experiment Resource Status to Can Substrate Cell" Foreign Keys |
Parent Key | Child Key |
Status Identifier | Status Identifier |
"Experiment Resource Status to Can Substrate Cell" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Experiment Resource Status to Can Substrate Cell" Bound Attachments |
Name | Current Value |
"Can Substrate Cell to Can Substrate Cell Usage" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_CASC_USAGE_TO_CASC |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Can Substrate Cell |
Child Entity | Can Substrate Cell Usage |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Can Substrate Cell to Can Substrate Cell Usage" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Can Substrate Cell to Can Substrate Cell Usage" Foreign Keys |
Parent Key | Child Key |
Experiment Resource Type Identifier, Facility Identifier | Experiment Resource Type Identifier, Facility Identifier |
"Can Substrate Cell to Can Substrate Cell Usage" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Can Substrate Cell to Can Substrate Cell Usage" Bound Attachments |
Name | Current Value |
"Person to Can Substrate Cell Usage" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | FK_CASC_USAGE_TO_PERSON |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Person |
Child Entity | Can Substrate Cell Usage |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Person to Can Substrate Cell Usage" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Person to Can Substrate Cell Usage" Foreign Keys |
Parent Key | Child Key |
Person Identifier | Person Identifier |
"Person to Can Substrate Cell Usage" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Person to Can Substrate Cell Usage" Bound Attachments |
Name | Current Value |
"SMPL.Sample to Can Substrate Cell Usage" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | FK_CASC_USAGE_TO_SAMPLE |
Relationship Business Name | |
Logical Only | No |
Parent Entity | SMPL.Sample |
Child Entity | Can Substrate Cell Usage |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
"SMPL.Sample to Can Substrate Cell Usage" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"SMPL.Sample to Can Substrate Cell Usage" Foreign Keys |
Parent Key | Child Key |
Sample Identifier | Sample Identifier |
"SMPL.Sample to Can Substrate Cell Usage" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"SMPL.Sample to Can Substrate Cell Usage" Bound Attachments |
Name | Current Value |
"EXPRESS.Unit of Measure to Can Substrate Cell" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | fk_casc_vol_to_uom |
Relationship Business Name | |
Logical Only | No |
Parent Entity | EXPRESS.Unit of Measure |
Child Entity | Can Substrate Cell |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
"EXPRESS.Unit of Measure to Can Substrate Cell" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EXPRESS.Unit of Measure to Can Substrate Cell" Foreign Keys |
Parent Key | Child Key |
Unit Identifier | Volume Unit of Measure Identifier |
"EXPRESS.Unit of Measure to Can Substrate Cell" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"EXPRESS.Unit of Measure to Can Substrate Cell" Bound Attachments |
Name | Current Value |
"Can Substrate Cell to Can Substrate Cell Attachment Association" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_cascaa_to_casc |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Can Substrate Cell |
Child Entity | Can Substrate Cell Attachment Association |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Can Substrate Cell to Can Substrate Cell Attachment Association" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Can Substrate Cell to Can Substrate Cell Attachment Association" Foreign Keys |
Parent Key | Child Key |
Experiment Resource Type Identifier, Facility Identifier | Experiment Resource Type Identifier, Facility Identifier |
"Can Substrate Cell to Can Substrate Cell Attachment Association" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Can Substrate Cell to Can Substrate Cell Attachment Association" Bound Attachments |
Name | Current Value |
"Experiment Resource Type to Can Substrate Cell Experiment Resource Type Association" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_CASCERTA_TO_EXPT_RSRC_TYPE |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Experiment Resource Type |
Child Entity | Can Substrate Cell Experiment Resource Type Association |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Experiment Resource Type to Can Substrate Cell Experiment Resource Type Association" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Experiment Resource Type to Can Substrate Cell Experiment Resource Type Association" Foreign Keys |
Parent Key | Child Key |
Experiment Resource Type Identifier, Facility Identifier | Experiment Resource Type2 Identifier, Facility Identifier |
"Experiment Resource Type to Can Substrate Cell Experiment Resource Type Association" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Experiment Resource Type to Can Substrate Cell Experiment Resource Type Association" Bound Attachments |
Name | Current Value |
"Can Substrate Cell to Can Substrate Cell Experiment Schedule Association" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_cascesa_to_casc |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Can Substrate Cell |
Child Entity | Can Substrate Cell Experiment Schedule Association |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Can Substrate Cell to Can Substrate Cell Experiment Schedule Association" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Can Substrate Cell to Can Substrate Cell Experiment Schedule Association" Foreign Keys |
Parent Key | Child Key |
Experiment Resource Type Identifier, Facility Identifier | Experiment Resource Type Identifier, Facility Identifier |
"Can Substrate Cell to Can Substrate Cell Experiment Schedule Association" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Can Substrate Cell to Can Substrate Cell Experiment Schedule Association" Bound Attachments |
Name | Current Value |
"Experiment Schedule to Can Substrate Cell Experiment Schedule Association" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_cascesa_to_expt_sched |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Experiment Schedule |
Child Entity | Can Substrate Cell Experiment Schedule Association |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Experiment Schedule to Can Substrate Cell Experiment Schedule Association" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Experiment Schedule to Can Substrate Cell Experiment Schedule Association" 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 Can Substrate Cell Experiment Schedule Association" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Experiment Schedule to Can Substrate Cell Experiment Schedule Association" Bound Attachments |
Name | Current Value |
"Can Substrate Cell to Can Substrate Cell Instrument Association" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_cascia_to_ercasc |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Can Substrate Cell |
Child Entity | Can Substrate Cell Instrument Association |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Can Substrate Cell to Can Substrate Cell Instrument Association" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Can Substrate Cell to Can Substrate Cell Instrument Association" Foreign Keys |
Parent Key | Child Key |
Experiment Resource Type Identifier, Facility Identifier | Experiment Resource Type Identifier, Facility Identifier |
"Can Substrate Cell to Can Substrate Cell Instrument Association" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Can Substrate Cell to Can Substrate Cell Instrument Association" Bound Attachments |
Name | Current Value |
"XF_ADMIN.Instrument to Can Substrate Cell Instrument Association" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_cascia_to_instr |
Relationship Business Name | |
Logical Only | No |
Parent Entity | XF_ADMIN.Instrument |
Child Entity | Can Substrate Cell Instrument Association |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"XF_ADMIN.Instrument to Can Substrate Cell Instrument Association" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"XF_ADMIN.Instrument to Can Substrate Cell Instrument Association" Foreign Keys |
Parent Key | Child Key |
Instrument Identifier | Instrument Identifier |
"XF_ADMIN.Instrument to Can Substrate Cell Instrument Association" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"XF_ADMIN.Instrument to Can Substrate Cell Instrument Association" Bound Attachments |
Name | Current Value |
"Can Substrate Cell to Can Substrate Cell Experiment Resource Type Association" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_CASCTA_TO_ERCASC |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Can Substrate Cell |
Child Entity | Can Substrate Cell Experiment Resource Type Association |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Can Substrate Cell to Can Substrate Cell Experiment Resource Type Association" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Can Substrate Cell to Can Substrate Cell Experiment Resource Type Association" Foreign Keys |
Parent Key | Child Key |
Experiment Resource Type Identifier, Facility Identifier | Experiment Resource Type Identifier, Facility Identifier |
"Can Substrate Cell to Can Substrate Cell Experiment Resource Type Association" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Can Substrate Cell to Can Substrate Cell Experiment Resource Type Association" Bound Attachments |
Name | Current Value |
"EXPRESS.Unit of Measure to Experiment Resource" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | fk_cell_uom_to_uom |
Relationship Business Name | |
Logical Only | No |
Parent Entity | EXPRESS.Unit of Measure |
Child Entity | Experiment Resource |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
"EXPRESS.Unit of Measure to Experiment Resource" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EXPRESS.Unit of Measure to Experiment Resource" Foreign Keys |
Parent Key | Child Key |
Unit Identifier | Cell Size Unit of Measure |
"EXPRESS.Unit of Measure to Experiment Resource" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"EXPRESS.Unit of Measure to Experiment Resource" Bound Attachments |
Name | Current Value |
"Experiment Resource Attachment to Can Substrate Cell Attachment Association" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_cscaa_to_expt_rsrc_attach |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Experiment Resource Attachment |
Child Entity | Can Substrate Cell Attachment Association |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Experiment Resource Attachment to Can Substrate Cell Attachment Association" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Experiment Resource Attachment to Can Substrate Cell Attachment Association" Foreign Keys |
Parent Key | Child Key |
Attachment Identifier | Attachment Identifier |
"Experiment Resource Attachment to Can Substrate Cell Attachment Association" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Experiment Resource Attachment to Can Substrate Cell Attachment Association" Bound Attachments |
Name | Current Value |
"EXPRESS.Unit of Measure to Experiment Resource" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | fk_dibc_uom_to_uom |
Relationship Business Name | |
Logical Only | No |
Parent Entity | EXPRESS.Unit of Measure |
Child Entity | Experiment Resource |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
"EXPRESS.Unit of Measure to Experiment Resource" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EXPRESS.Unit of Measure to Experiment Resource" Foreign Keys |
Parent Key | Child Key |
Unit Identifier | Distance Interface Beam Center Unit of Measure |
"EXPRESS.Unit of Measure to Experiment Resource" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"EXPRESS.Unit of Measure to Experiment Resource" Bound Attachments |
Name | Current Value |
"EXPRESS.Unit of Measure to Experiment Resource" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | fk_dsbc_uom_to_uom |
Relationship Business Name | |
Logical Only | No |
Parent Entity | EXPRESS.Unit of Measure |
Child Entity | Experiment Resource |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
"EXPRESS.Unit of Measure to Experiment Resource" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EXPRESS.Unit of Measure to Experiment Resource" Foreign Keys |
Parent Key | Child Key |
Unit Identifier | Distance Stick Beam Center Unit of Measure |
"EXPRESS.Unit of Measure to Experiment Resource" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"EXPRESS.Unit of Measure to Experiment Resource" Bound Attachments |
Name | Current Value |
"XF_ADMIN.Employee to Experiment Laboratory Schedule" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | FK_ELS_TO_EMP |
Relationship Business Name | |
Logical Only | No |
Parent Entity | XF_ADMIN.Employee |
Child Entity | Experiment Laboratory Schedule |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
"XF_ADMIN.Employee to Experiment Laboratory Schedule" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"XF_ADMIN.Employee to Experiment Laboratory Schedule" Foreign Keys |
Parent Key | Child Key |
Badge Number | Requested By Badge Number |
"XF_ADMIN.Employee to Experiment Laboratory Schedule" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"XF_ADMIN.Employee to Experiment Laboratory Schedule" Bound Attachments |
Name | Current Value |
"Experiment Laboratory Status to Experiment Laboratory Schedule" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | FK_ELS_TO_EXPT_LAB_STAT |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Experiment Laboratory Status |
Child Entity | Experiment Laboratory Schedule |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Experiment Laboratory Status to Experiment Laboratory Schedule" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Experiment Laboratory Status to Experiment Laboratory Schedule" Foreign Keys |
Parent Key | Child Key |
Status Identifier | Status Identifier |
"Experiment Laboratory Status to Experiment Laboratory Schedule" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Experiment Laboratory Status to Experiment Laboratory Schedule" Bound Attachments |
Name | Current Value |
"Experiment Laboratory Schedule to Experiment Laboratory Schedule Log" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_ELSL_TO_EXPT_LAB_SCHED |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Experiment Laboratory Schedule |
Child Entity | Experiment Laboratory Schedule Log |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Experiment Laboratory Schedule to Experiment Laboratory Schedule Log" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Experiment Laboratory Schedule to Experiment Laboratory Schedule Log" Foreign Keys |
Parent Key | Child Key |
Proposal Identifier, Submission Number, Instrument Identifier, Run Number, Laboratory Identifier | Proposal Identifier, Submission Number, Instrument Identifier, Run Number, Laboratory Identifier |
"Experiment Laboratory Schedule to Experiment Laboratory Schedule Log" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Experiment Laboratory Schedule to Experiment Laboratory Schedule Log" Bound Attachments |
Name | Current Value |
"Laboratory Workflow to Experiment Laboratory Schedule Workflow" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | FK_ELSW_NEXT_TO_LAB_WRKFLW |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Laboratory Workflow |
Child Entity | Experiment Laboratory Schedule Workflow |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
"Laboratory Workflow to Experiment Laboratory Schedule Workflow" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Laboratory Workflow to Experiment Laboratory Schedule Workflow" Foreign Keys |
Parent Key | Child Key |
WorkFlow Identifier | Next WorkFlow Identifier |
"Laboratory Workflow to Experiment Laboratory Schedule Workflow" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Laboratory Workflow to Experiment Laboratory Schedule Workflow" Bound Attachments |
Name | Current Value |
"Experiment Resource Facility to Experiment Laboratory Schedule Workflow" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_ELSW_TO_EXPT_RSRC_FACIL |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Experiment Resource Facility |
Child Entity | Experiment Laboratory Schedule Workflow |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Experiment Resource Facility to Experiment Laboratory Schedule Workflow" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Experiment Resource Facility to Experiment Laboratory Schedule Workflow" Foreign Keys |
Parent Key | Child Key |
Facility Identifier | Facility Identifier |
"Experiment Resource Facility to Experiment Laboratory Schedule Workflow" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Experiment Resource Facility to Experiment Laboratory Schedule Workflow" Bound Attachments |
Name | Current Value |
"Laboratory Workflow to Experiment Laboratory Schedule Workflow" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_ELSW_TO_LAB_WRKFLW |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Laboratory Workflow |
Child Entity | Experiment Laboratory Schedule Workflow |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Laboratory Workflow to Experiment Laboratory Schedule Workflow" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Laboratory Workflow to Experiment Laboratory Schedule Workflow" Foreign Keys |
Parent Key | Child Key |
WorkFlow Identifier | WorkFlow Identifier |
"Laboratory Workflow to Experiment Laboratory Schedule Workflow" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Laboratory Workflow to Experiment Laboratory Schedule Workflow" Bound Attachments |
Name | Current Value |
"XF_ADMIN.Instrument to Email Signature" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_EMAIL_SIGN_TO_INSTR |
Relationship Business Name | |
Logical Only | No |
Parent Entity | XF_ADMIN.Instrument |
Child Entity | Email Signature |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"XF_ADMIN.Instrument to Email Signature" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"XF_ADMIN.Instrument to Email Signature" Foreign Keys |
Parent Key | Child Key |
Instrument Identifier | Instrument Identifier |
"XF_ADMIN.Instrument to Email Signature" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"XF_ADMIN.Instrument to Email Signature" Bound Attachments |
Name | Current Value |
"EXPRESS.User Profile to Email Signature" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_EMAIL_SIGN_TO_USER_PROF |
Relationship Business Name | |
Logical Only | No |
Parent Entity | EXPRESS.User Profile |
Child Entity | Email Signature |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"EXPRESS.User Profile to Email Signature" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EXPRESS.User Profile to Email Signature" Foreign Keys |
Parent Key | Child Key |
Badge Number | Badge Number |
"EXPRESS.User Profile to Email Signature" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"EXPRESS.User Profile to Email Signature" Bound Attachments |
Name | Current Value |
"Experiment Resource Facility to Experiment Resource Location" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_er_loc_to_er_facil |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Experiment Resource Facility |
Child Entity | Experiment Resource Location |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Experiment Resource Facility to Experiment Resource Location" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Experiment Resource Facility to Experiment Resource Location" Foreign Keys |
Parent Key | Child Key |
Facility Identifier | Facility Identifier |
"Experiment Resource Facility to Experiment Resource Location" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Experiment Resource Facility to Experiment Resource Location" Bound Attachments |
Name | Current Value |
"Experiment Resource Facility to Experiment Resource" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | fk_er_to_expt_rsrc_facil |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Experiment Resource Facility |
Child Entity | Experiment Resource |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Experiment Resource Facility to Experiment Resource" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Experiment Resource Facility to Experiment Resource" Foreign Keys |
Parent Key | Child Key |
Facility Identifier | Facility Identifier |
"Experiment Resource Facility to Experiment Resource" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Experiment Resource Facility to Experiment Resource" Bound Attachments |
Name | Current Value |
"Experiment Resource Subtype to Experiment Resource" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | fk_er_to_expt_rsrc_subtype |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Experiment Resource Subtype |
Child Entity | Experiment Resource |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
"Experiment Resource Subtype to Experiment Resource" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Experiment Resource Subtype to Experiment Resource" Foreign Keys |
Parent Key | Child Key |
Experiment Resource Type Identifier, Experiment Resource Subtype Identifer, Facility Identifier | Experiment Resource Type Identifier, Experiment Resource Subtype Identifer, Facility Identifier |
"Experiment Resource Subtype to Experiment Resource" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Experiment Resource Subtype to Experiment Resource" Bound Attachments |
Name | Current Value |
"Experiment Resource to Experiment Resource Association" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_era1_to_expt_rsrc |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Experiment Resource |
Child Entity | Experiment Resource Association |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Experiment Resource to Experiment Resource Association" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Experiment Resource to Experiment Resource Association" Foreign Keys |
Parent Key | Child Key |
Experiment Resource Identifier | Experiment Resource Identifier 1 |
"Experiment Resource to Experiment Resource Association" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Experiment Resource to Experiment Resource Association" Bound Attachments |
Name | Current Value |
"Experiment Resource to Experiment Resource Association" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_era2_to_expt_rsrc |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Experiment Resource |
Child Entity | Experiment Resource Association |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Experiment Resource to Experiment Resource Association" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Experiment Resource to Experiment Resource Association" Foreign Keys |
Parent Key | Child Key |
Experiment Resource Identifier | Experiment Resource Identifier 2 |
"Experiment Resource to Experiment Resource Association" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Experiment Resource to Experiment Resource Association" Bound Attachments |
Name | Current Value |
"Experiment Resource Attach Type to Experiment Resource Attachment" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | fk_era_to_expt_rsrc_attach_type |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Experiment Resource Attach Type |
Child Entity | Experiment Resource Attachment |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
"Experiment Resource Attach Type to Experiment Resource Attachment" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Experiment Resource Attach Type to Experiment Resource Attachment" Foreign Keys |
Parent Key | Child Key |
Attachment Type Identifier | Attachment Type Identifier |
"Experiment Resource Attach Type to Experiment Resource Attachment" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Experiment Resource Attach Type to Experiment Resource Attachment" Bound Attachments |
Name | Current Value |
"Experiment Resource Attachment to Experiment Resource Attachment Association" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_eraa_to_era |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Experiment Resource Attachment |
Child Entity | Experiment Resource Attachment Association |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Experiment Resource Attachment to Experiment Resource Attachment Association" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Experiment Resource Attachment to Experiment Resource Attachment Association" Foreign Keys |
Parent Key | Child Key |
Attachment Identifier | Attachment Identifier |
"Experiment Resource Attachment to Experiment Resource Attachment Association" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Experiment Resource Attachment to Experiment Resource Attachment Association" Bound Attachments |
Name | Current Value |
"Experiment Resource to Experiment Resource Attachment Association" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_eraa_to_expt_rsrc |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Experiment Resource |
Child Entity | Experiment Resource Attachment Association |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Experiment Resource to Experiment Resource Attachment Association" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Experiment Resource to Experiment Resource Attachment Association" Foreign Keys |
Parent Key | Child Key |
Experiment Resource Identifier | Experiment Resource Identifier |
"Experiment Resource to Experiment Resource Attachment Association" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Experiment Resource to Experiment Resource Attachment Association" Bound Attachments |
Name | Current Value |
"Experiment Resource Commitment Type to Experiment Resource Schedule" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | fk_erct_to_expt_rsrc_sched |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Experiment Resource Commitment Type |
Child Entity | Experiment Resource Schedule |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Experiment Resource Commitment Type to Experiment Resource Schedule" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Experiment Resource Commitment Type to Experiment Resource Schedule" Foreign Keys |
Parent Key | Child Key |
Commitment Request Identifier | Commitment Request Identifier |
"Experiment Resource Commitment Type to Experiment Resource Schedule" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Experiment Resource Commitment Type to Experiment Resource Schedule" Bound Attachments |
Name | Current Value |
"Experiment Resource Group to Experiment Resource Group Association" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_erga_to_expt_rsrc_grp |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Experiment Resource Group |
Child Entity | Experiment Resource Group Association |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Experiment Resource Group to Experiment Resource Group Association" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Experiment Resource Group to Experiment Resource Group Association" Foreign Keys |
Parent Key | Child Key |
Experiment Resource Group Name | Experiment Resource Group Name |
"Experiment Resource Group to Experiment Resource Group Association" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Experiment Resource Group to Experiment Resource Group Association" Bound Attachments |
Name | Current Value |
"Experiment Resource Schedule to Experiment Resource Group Association" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_erga_to_expt_rsrc_sched |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Experiment Resource Schedule |
Child Entity | Experiment Resource Group Association |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Experiment Resource Schedule to Experiment Resource Group Association" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Experiment Resource Schedule to Experiment Resource Group Association" Foreign Keys |
Parent Key | Child Key |
Experiment Resource Identifier | Experiment Resource Identifier |
"Experiment Resource Schedule to Experiment Resource Group Association" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Experiment Resource Schedule to Experiment Resource Group Association" Bound Attachments |
Name | Current Value |
"Experiment Resource to Experiment Resource Instrument Association" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_eria_to_expt_rsrc |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Experiment Resource |
Child Entity | Experiment Resource Instrument Association |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Experiment Resource to Experiment Resource Instrument Association" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Experiment Resource to Experiment Resource Instrument Association" Foreign Keys |
Parent Key | Child Key |
Experiment Resource Identifier | Experiment Resource Identifier |
"Experiment Resource to Experiment Resource Instrument Association" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Experiment Resource to Experiment Resource Instrument Association" Bound Attachments |
Name | Current Value |
"XF_ADMIN.Instrument to Experiment Resource Instrument Association" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_eria_to_instr |
Relationship Business Name | |
Logical Only | No |
Parent Entity | XF_ADMIN.Instrument |
Child Entity | Experiment Resource Instrument Association |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"XF_ADMIN.Instrument to Experiment Resource Instrument Association" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"XF_ADMIN.Instrument to Experiment Resource Instrument Association" Foreign Keys |
Parent Key | Child Key |
Instrument Identifier | Instrument Identifier |
"XF_ADMIN.Instrument to Experiment Resource Instrument Association" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"XF_ADMIN.Instrument to Experiment Resource Instrument Association" Bound Attachments |
Name | Current Value |
"Express Activity to Experiment Resource Log" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_ERL_TO_EXP_ACT |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Express Activity |
Child Entity | Experiment Resource Log |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Express Activity to Experiment Resource Log" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Express Activity to Experiment Resource Log" Foreign Keys |
Parent Key | Child Key |
Activity Identifier | Activity Identifier |
"Express Activity to Experiment Resource Log" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Express Activity to Experiment Resource Log" Bound Attachments |
Name | Current Value |
"Experiment Resource to Experiment Resource Log" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_erl_to_expt_rsrc |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Experiment Resource |
Child Entity | Experiment Resource Log |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Experiment Resource to Experiment Resource Log" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Experiment Resource to Experiment Resource Log" Foreign Keys |
Parent Key | Child Key |
Experiment Resource Identifier | Experiment Resource Identifier |
"Experiment Resource to Experiment Resource Log" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Experiment Resource to Experiment Resource Log" Bound Attachments |
Name | Current Value |
"Experiment Resource to Experiment Resource Maintenance Schedule" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_ERMS_TO_EXPT_RSRC |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Experiment Resource |
Child Entity | Experiment Resource Maintenance Schedule |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Experiment Resource to Experiment Resource Maintenance Schedule" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Experiment Resource to Experiment Resource Maintenance Schedule" Foreign Keys |
Parent Key | Child Key |
Experiment Resource Identifier | Experiment Resource Identifier |
"Experiment Resource to Experiment Resource Maintenance Schedule" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Experiment Resource to Experiment Resource Maintenance Schedule" Bound Attachments |
Name | Current Value |
"XF_ADMIN.Employee to Express Role Person Association" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | FK_ERPA_TO_EMP |
Relationship Business Name | |
Logical Only | No |
Parent Entity | XF_ADMIN.Employee |
Child Entity | Express Role Person Association |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
"XF_ADMIN.Employee to Express Role Person Association" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"XF_ADMIN.Employee to Express Role Person Association" Foreign Keys |
Parent Key | Child Key |
Badge Number | Badge Number |
"XF_ADMIN.Employee to Express Role Person Association" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"XF_ADMIN.Employee to Express Role Person Association" Bound Attachments |
Name | Current Value |
"Express User Role to Express Role Person Association" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_erpa_to_exp_user_role |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Express User Role |
Child Entity | Express Role Person Association |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Express User Role to Express Role Person Association" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Express User Role to Express Role Person Association" Foreign Keys |
Parent Key | Child Key |
Role Identifer | Role Identifer |
"Express User Role to Express Role Person Association" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Express User Role to Express Role Person Association" Bound Attachments |
Name | Current Value |
"Experiment Resource to Experiment Resource Personnel Association" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_erpa_to_expt_rsrc |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Experiment Resource |
Child Entity | Experiment Resource Personnel Association |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Experiment Resource to Experiment Resource Personnel Association" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Experiment Resource to Experiment Resource Personnel Association" Foreign Keys |
Parent Key | Child Key |
Experiment Resource Identifier | Experiment Resource Identifier |
"Experiment Resource to Experiment Resource Personnel Association" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Experiment Resource to Experiment Resource Personnel Association" Bound Attachments |
Name | Current Value |
"Experiment Resource Facility to Express Role Person Association" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_erpa_to_expt_rsrc_facil |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Experiment Resource Facility |
Child Entity | Express Role Person Association |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Experiment Resource Facility to Express Role Person Association" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Experiment Resource Facility to Express Role Person Association" Foreign Keys |
Parent Key | Child Key |
Facility Identifier | Facility Identifier |
"Experiment Resource Facility to Express Role Person Association" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Experiment Resource Facility to Express Role Person Association" Bound Attachments |
Name | Current Value |
"Experiment Resource Personnel Association to Experiment Resource Personnel Resource" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_erpr_to_expt_rsrc_pers_assc |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Experiment Resource Personnel Association |
Child Entity | Experiment Resource Personnel Resource |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Experiment Resource Personnel Association to Experiment Resource Personnel Resource" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Experiment Resource Personnel Association to Experiment Resource Personnel Resource" Foreign Keys |
Parent Key | Child Key |
Experiment Resource Identifier, Badge Number | Experiment Resource Identifier, Badge Number |
"Experiment Resource Personnel Association to Experiment Resource Personnel Resource" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Experiment Resource Personnel Association to Experiment Resource Personnel Resource" Bound Attachments |
Name | Current Value |
"Experiment Resource Schedule to Experiment Resource Personnel Resource" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_erpr_to_expt_rsrc_sched |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Experiment Resource Schedule |
Child Entity | Experiment Resource Personnel Resource |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Experiment Resource Schedule to Experiment Resource Personnel Resource" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Experiment Resource Schedule to Experiment Resource Personnel Resource" Foreign Keys |
Parent Key | Child Key |
Experiment Resource Identifier | Experiment Resource Identifier |
"Experiment Resource Schedule to Experiment Resource Personnel Resource" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Experiment Resource Schedule to Experiment Resource Personnel Resource" Bound Attachments |
Name | Current Value |
"XF_ADMIN.Employee to Experiment Resource Personnel Training" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_ERPT_TO_EMP |
Relationship Business Name | |
Logical Only | No |
Parent Entity | XF_ADMIN.Employee |
Child Entity | Experiment Resource Personnel Training |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"XF_ADMIN.Employee to Experiment Resource Personnel Training" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"XF_ADMIN.Employee to Experiment Resource Personnel Training" Foreign Keys |
Parent Key | Child Key |
Badge Number | Badge Number |
"XF_ADMIN.Employee to Experiment Resource Personnel Training" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"XF_ADMIN.Employee to Experiment Resource Personnel Training" Bound Attachments |
Name | Current Value |
"Experiment Resource Training Modules to Experiment Resource Personnel Training" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_erpt_to_expt_rsrc_train_mod |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Experiment Resource Training Modules |
Child Entity | Experiment Resource Personnel Training |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Experiment Resource Training Modules to Experiment Resource Personnel Training" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Experiment Resource Training Modules to Experiment Resource Personnel Training" Foreign Keys |
Parent Key | Child Key |
Training Module Identifer | Training Module Identifer |
"Experiment Resource Training Modules to Experiment Resource Personnel Training" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Experiment Resource Training Modules to Experiment Resource Personnel Training" Bound Attachments |
Name | Current Value |
"Experiment Resource Question to Experiment Resource Question Experiment Resource Schedule Association" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_ERQERSA_TO_EXPT_RSRC_QUES |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Experiment Resource Question |
Child Entity | Experiment Resource Question Experiment Resource Schedule Association |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Experiment Resource Question to Experiment Resource Question Experiment Resource Schedule Association" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Experiment Resource Question to Experiment Resource Question Experiment Resource Schedule Association" Foreign Keys |
Parent Key | Child Key |
Question Identifier | Question Identifier |
"Experiment Resource Question to Experiment Resource Question Experiment Resource Schedule Association" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Experiment Resource Question to Experiment Resource Question Experiment Resource Schedule Association" Bound Attachments |
Name | Current Value |
"Experiment Resource Schedule to Experiment Resource Question Experiment Resource Schedule Association" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_ERQERSA_TO_EXPT_RSRC_SCHED |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Experiment Resource Schedule |
Child Entity | Experiment Resource Question Experiment Resource Schedule Association |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Experiment Resource Schedule to Experiment Resource Question Experiment Resource Schedule Association" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Experiment Resource Schedule to Experiment Resource Question Experiment Resource Schedule Association" Foreign Keys |
Parent Key | Child Key |
Experiment Resource Identifier | Experiment Resource Identifier |
"Experiment Resource Schedule to Experiment Resource Question Experiment Resource Schedule Association" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Experiment Resource Schedule to Experiment Resource Question Experiment Resource Schedule Association" Bound Attachments |
Name | Current Value |
"Experiment Resource Request Type to Experiment Resource Schedule" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | fk_errt_to_expt_rsrc_sched |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Experiment Resource Request Type |
Child Entity | Experiment Resource Schedule |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Experiment Resource Request Type to Experiment Resource Schedule" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Experiment Resource Request Type to Experiment Resource Schedule" Foreign Keys |
Parent Key | Child Key |
Request Type Identifier | Request Type Identifier |
"Experiment Resource Request Type to Experiment Resource Schedule" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Experiment Resource Request Type to Experiment Resource Schedule" Bound Attachments |
Name | Current Value |
"Experiment Resource to Experiment Resource Schedule" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_ers_to_expt_rsrc |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Experiment Resource |
Child Entity | Experiment Resource Schedule |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Experiment Resource to Experiment Resource Schedule" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Experiment Resource to Experiment Resource Schedule" Foreign Keys |
Parent Key | Child Key |
Experiment Resource Identifier | Experiment Resource Identifier |
"Experiment Resource to Experiment Resource Schedule" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Experiment Resource to Experiment Resource Schedule" Bound Attachments |
Name | Current Value |
"Experiment Resource Type to Experiment Resource Subtype" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_ers_to_expt_rsrc_type |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Experiment Resource Type |
Child Entity | Experiment Resource Subtype |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Experiment Resource Type to Experiment Resource Subtype" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Experiment Resource Type to Experiment Resource Subtype" Foreign Keys |
Parent Key | Child Key |
Experiment Resource Type Identifier, Facility Identifier | Experiment Resource Type Identifier, Facility Identifier |
"Experiment Resource Type to Experiment Resource Subtype" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Experiment Resource Type to Experiment Resource Subtype" Bound Attachments |
Name | Current Value |
"Experiment Resource Status to Experiment Resource" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | FK_ERS_TO_RXPT_RSRC |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Experiment Resource Status |
Child Entity | Experiment Resource |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Experiment Resource Status to Experiment Resource" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Experiment Resource Status to Experiment Resource" Foreign Keys |
Parent Key | Child Key |
Status Identifier | Status Identifier |
"Experiment Resource Status to Experiment Resource" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Experiment Resource Status to Experiment Resource" Bound Attachments |
Name | Current Value |
"Experiment Resource to Experiment Resource Status History" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_ersh_to_expt_rsrc |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Experiment Resource |
Child Entity | Experiment Resource Status History |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Experiment Resource to Experiment Resource Status History" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Experiment Resource to Experiment Resource Status History" Foreign Keys |
Parent Key | Child Key |
Experiment Resource Identifier | Experiment Resource Identifier |
"Experiment Resource to Experiment Resource Status History" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Experiment Resource to Experiment Resource Status History" Bound Attachments |
Name | Current Value |
"Experiment Resource Schedule Status to Experiment Resource Schedule" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | fk_erss_to_expt_rsrc_stat |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Experiment Resource Schedule Status |
Child Entity | Experiment Resource Schedule |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Experiment Resource Schedule Status to Experiment Resource Schedule" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Experiment Resource Schedule Status to Experiment Resource Schedule" Foreign Keys |
Parent Key | Child Key |
Status Identifier | Status Identifier |
"Experiment Resource Schedule Status to Experiment Resource Schedule" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Experiment Resource Schedule Status to Experiment Resource Schedule" Bound Attachments |
Name | Current Value |
"Resource Workflow to Experiment Resource Schedule Workflow" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | FK_ERSW_NEXT_TO_RSRC_WRKFLW |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Resource Workflow |
Child Entity | Experiment Resource Schedule Workflow |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
"Resource Workflow to Experiment Resource Schedule Workflow" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Resource Workflow to Experiment Resource Schedule Workflow" Foreign Keys |
Parent Key | Child Key |
WorkFlow Identifier | Next WorkFlow Identifier |
"Resource Workflow to Experiment Resource Schedule Workflow" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Resource Workflow to Experiment Resource Schedule Workflow" Bound Attachments |
Name | Current Value |
"Experiment Resource Facility to Experiment Resource Schedule Workflow" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_ERSW_TO_EXPT_RSRC_FACIL |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Experiment Resource Facility |
Child Entity | Experiment Resource Schedule Workflow |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Experiment Resource Facility to Experiment Resource Schedule Workflow" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Experiment Resource Facility to Experiment Resource Schedule Workflow" Foreign Keys |
Parent Key | Child Key |
Facility Identifier | Facility Identifier |
"Experiment Resource Facility to Experiment Resource Schedule Workflow" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Experiment Resource Facility to Experiment Resource Schedule Workflow" Bound Attachments |
Name | Current Value |
"Resource Workflow to Experiment Resource Schedule Workflow" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_ERSW_TO_RSRC_WRKFLW |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Resource Workflow |
Child Entity | Experiment Resource Schedule Workflow |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Resource Workflow to Experiment Resource Schedule Workflow" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Resource Workflow to Experiment Resource Schedule Workflow" Foreign Keys |
Parent Key | Child Key |
WorkFlow Identifier | WorkFlow Identifier |
"Resource Workflow to Experiment Resource Schedule Workflow" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Resource Workflow to Experiment Resource Schedule Workflow" Bound Attachments |
Name | Current Value |
"Experiment Resource to Experiment Resource Training" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_ert_to_expt_rsrc |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Experiment Resource |
Child Entity | Experiment Resource Training |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Experiment Resource to Experiment Resource Training" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Experiment Resource to Experiment Resource Training" Foreign Keys |
Parent Key | Child Key |
Experiment Resource Identifier | Experiment Resource Identifier |
"Experiment Resource to Experiment Resource Training" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Experiment Resource to Experiment Resource Training" Bound Attachments |
Name | Current Value |
"Experiment Resource Facility to Experiment Resource Type" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_ert_to_expt_rsrc_facil |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Experiment Resource Facility |
Child Entity | Experiment Resource Type |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Experiment Resource Facility to Experiment Resource Type" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Experiment Resource Facility to Experiment Resource Type" Foreign Keys |
Parent Key | Child Key |
Facility Identifier | Facility Identifier |
"Experiment Resource Facility to Experiment Resource Type" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Experiment Resource Facility to Experiment Resource Type" Bound Attachments |
Name | Current Value |
"Experiment Resource Training Modules to Experiment Resource Training" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_ert_to_expt_rsrc_train_mod |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Experiment Resource Training Modules |
Child Entity | Experiment Resource Training |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Experiment Resource Training Modules to Experiment Resource Training" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Experiment Resource Training Modules to Experiment Resource Training" Foreign Keys |
Parent Key | Child Key |
Training Module Identifer | Training Module Identifer |
"Experiment Resource Training Modules to Experiment Resource Training" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Experiment Resource Training Modules to Experiment Resource Training" Bound Attachments |
Name | Current Value |
"XF_ADMIN.Email Template to Experiment Schedule Email Log" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_ESEL_TO_EMAIL_TMPL |
Relationship Business Name | |
Logical Only | No |
Parent Entity | XF_ADMIN.Email Template |
Child Entity | Experiment Schedule Email Log |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"XF_ADMIN.Email Template to Experiment Schedule Email Log" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"XF_ADMIN.Email Template to Experiment Schedule Email Log" Foreign Keys |
Parent Key | Child Key |
Template Identifier | Template Identifier |
"XF_ADMIN.Email Template to Experiment Schedule Email Log" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"XF_ADMIN.Email Template to Experiment Schedule Email Log" Bound Attachments |
Name | Current Value |
"XF_ADMIN.Employee to Experiment Schedule Local Contact Association" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_ESLCA_TO_EMP |
Relationship Business Name | |
Logical Only | No |
Parent Entity | XF_ADMIN.Employee |
Child Entity | Experiment Schedule Local Contact Association |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"XF_ADMIN.Employee to Experiment Schedule Local Contact Association" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"XF_ADMIN.Employee to Experiment Schedule Local Contact Association" Foreign Keys |
Parent Key | Child Key |
Badge Number | Badge Number |
"XF_ADMIN.Employee to Experiment Schedule Local Contact Association" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"XF_ADMIN.Employee to Experiment Schedule Local Contact Association" Bound Attachments |
Name | Current Value |
"Experiment Resource Facility to Experiment Schedule Workflow" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_ESW_TO_EXPT_RSRC_FACIL |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Experiment Resource Facility |
Child Entity | Experiment Schedule Workflow |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Experiment Resource Facility to Experiment Schedule Workflow" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Experiment Resource Facility to Experiment Schedule Workflow" Foreign Keys |
Parent Key | Child Key |
Facility Identifier | Facility Identifier |
"Experiment Resource Facility to Experiment Schedule Workflow" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Experiment Resource Facility to Experiment Schedule Workflow" Bound Attachments |
Name | Current Value |
"Express Activity to Express Log" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_EXP_LOG_TO_EXP_ACT |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Express Activity |
Child Entity | Express Log |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Express Activity to Express Log" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Express Activity to Express Log" Foreign Keys |
Parent Key | Child Key |
Activity Identifier | Activity Identifier |
"Express Activity to Express Log" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Express Activity to Express Log" Bound Attachments |
Name | Current Value |
"XF_ADMIN.Laboratory to Experiment Laboratory Schedule" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_EXPT_LAB_SCHED_TO_LAB |
Relationship Business Name | |
Logical Only | No |
Parent Entity | XF_ADMIN.Laboratory |
Child Entity | Experiment Laboratory Schedule |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"XF_ADMIN.Laboratory to Experiment Laboratory Schedule" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"XF_ADMIN.Laboratory to Experiment Laboratory Schedule" Foreign Keys |
Parent Key | Child Key |
Laboratory Identifier | Laboratory Identifier |
"XF_ADMIN.Laboratory to Experiment Laboratory Schedule" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"XF_ADMIN.Laboratory to Experiment Laboratory Schedule" 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 |
"Experiment Resource to Experiment Resource Maintenance" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_EXPT_RSRC_MAIN_TO_EXPT_RSRC |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Experiment Resource |
Child Entity | Experiment Resource Maintenance |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Experiment Resource to Experiment Resource Maintenance" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Experiment Resource to Experiment Resource Maintenance" Foreign Keys |
Parent Key | Child Key |
Experiment Resource Identifier | Experiment Resource Identifier |
"Experiment Resource to Experiment Resource Maintenance" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Experiment Resource to Experiment Resource Maintenance" Bound Attachments |
Name | Current Value |
"Maintenance Activity to Experiment Resource Maintenance" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_EXPT_RSRC_MAIN_TO_MAINT_ACT |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Maintenance Activity |
Child Entity | Experiment Resource Maintenance |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Maintenance Activity to Experiment Resource Maintenance" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Maintenance Activity to Experiment Resource Maintenance" Foreign Keys |
Parent Key | Child Key |
Activity Identifier | Activity Identifier |
"Maintenance Activity to Experiment Resource Maintenance" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Maintenance Activity to Experiment Resource Maintenance" Bound Attachments |
Name | Current Value |
"XF_ADMIN.Employee to Experiment Resource Personnel Absence" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_EXPT_RSRC_PER_ABS_TO_EMP |
Relationship Business Name | |
Logical Only | No |
Parent Entity | XF_ADMIN.Employee |
Child Entity | Experiment Resource Personnel Absence |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"XF_ADMIN.Employee to Experiment Resource Personnel Absence" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"XF_ADMIN.Employee to Experiment Resource Personnel Absence" Foreign Keys |
Parent Key | Child Key |
Badge Number | Badge Number |
"XF_ADMIN.Employee to Experiment Resource Personnel Absence" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"XF_ADMIN.Employee to Experiment Resource Personnel Absence" Bound Attachments |
Name | Current Value |
"XF_ADMIN.Employee to Experiment Resource Personnel Association" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_EXPT_RSRC_PER_ASSC_TO_EMP |
Relationship Business Name | |
Logical Only | No |
Parent Entity | XF_ADMIN.Employee |
Child Entity | Experiment Resource Personnel Association |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"XF_ADMIN.Employee to Experiment Resource Personnel Association" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"XF_ADMIN.Employee to Experiment Resource Personnel Association" Foreign Keys |
Parent Key | Child Key |
Badge Number | Badge Number |
"XF_ADMIN.Employee to Experiment Resource Personnel Association" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"XF_ADMIN.Employee to Experiment Resource Personnel Association" Bound Attachments |
Name | Current Value |
"Electrical Certification to Experiment Resource" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | FK_EXPT_RSRC_TO_ELEC_CERT |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Electrical Certification |
Child Entity | Experiment Resource |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
"Electrical Certification to Experiment Resource" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Electrical Certification to Experiment Resource" Foreign Keys |
Parent Key | Child Key |
Electrical Certification Identifier | Electrical Certification Identifier |
"Electrical Certification to Experiment Resource" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Electrical Certification to Experiment Resource" Bound Attachments |
Name | Current Value |
"Experiment Resource Location to Experiment Resource" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | fk_expt_rsrc_to_expt_rsrc_loc |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Experiment Resource Location |
Child Entity | Experiment Resource |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
"Experiment Resource Location to Experiment Resource" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Experiment Resource Location to Experiment Resource" Foreign Keys |
Parent Key | Child Key |
Facility Identifier, Location Identifier | Facility Identifier, Location Identifier |
"Experiment Resource Location to Experiment Resource" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Experiment Resource Location to Experiment Resource" Bound Attachments |
Name | Current Value |
"Experiment Resource Type to Experiment Resource" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | fk_expt_rsrc_to_expt_rsrc_type |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Experiment Resource Type |
Child Entity | Experiment Resource |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Experiment Resource Type to Experiment Resource" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Experiment Resource Type to Experiment Resource" Foreign Keys |
Parent Key | Child Key |
Experiment Resource Type Identifier, Facility Identifier | Experiment Resource Type Identifier, Facility Identifier |
"Experiment Resource Type to Experiment Resource" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Experiment Resource Type to Experiment Resource" Bound Attachments |
Name | Current Value |
"Experiment Resource Manufacturer to Experiment Resource" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | fk_expt_rsrc_to_manuf |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Experiment Resource Manufacturer |
Child Entity | Experiment Resource |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
"Experiment Resource Manufacturer to Experiment Resource" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Experiment Resource Manufacturer to Experiment Resource" Foreign Keys |
Parent Key | Child Key |
Manufacturer Identifier | Manufacturer Identifier |
"Experiment Resource Manufacturer to Experiment Resource" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Experiment Resource Manufacturer to Experiment Resource" Bound Attachments |
Name | Current Value |
"Classification to Can Substrate Cell Experiment Resource Type Association" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | fk_expt_rsrc_type_to_class |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Classification |
Child Entity | Can Substrate Cell Experiment Resource Type Association |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
"Classification to Can Substrate Cell Experiment Resource Type Association" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Classification to Can Substrate Cell Experiment Resource Type Association" Foreign Keys |
Parent Key | Child Key |
Classification Identifier | Classification Identifier |
"Classification to Can Substrate Cell Experiment Resource Type Association" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Classification to Can Substrate Cell Experiment Resource Type Association" Bound Attachments |
Name | Current Value |
"Experiment Resource to Experiment Resource Unavailable" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_EXPT_RSRC_UN_TO_EXPT_RSRC |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Experiment Resource |
Child Entity | Experiment Resource Unavailable |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Experiment Resource to Experiment Resource Unavailable" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Experiment Resource to Experiment Resource Unavailable" Foreign Keys |
Parent Key | Child Key |
Experiment Resource Identifier | Experiment Resource Identifier |
"Experiment Resource to Experiment Resource Unavailable" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Experiment Resource to Experiment Resource Unavailable" Bound Attachments |
Name | Current Value |
"Express Activity to Experiment Schedule Log" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_EXPT_SCH_LOG_TO_EX_ACT |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Express Activity |
Child Entity | Experiment Schedule Log |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Express Activity to Experiment Schedule Log" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Express Activity to Experiment Schedule Log" Foreign Keys |
Parent Key | Child Key |
Activity Identifier | Activity Identifier |
"Express Activity to Experiment Schedule Log" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Express Activity to Experiment Schedule Log" 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 |
"Experiment Schedule Status to Experiment Schedule" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | FK_EXPT_SCHED_TO_EXPT_SCHED_ST |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Experiment Schedule Status |
Child Entity | Experiment Schedule |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Experiment Schedule Status to Experiment Schedule" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Experiment Schedule Status to Experiment Schedule" Foreign Keys |
Parent Key | Child Key |
Status Identifier | Status Identifier |
"Experiment Schedule Status to Experiment Schedule" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Experiment Schedule Status to Experiment Schedule" Bound Attachments |
Name | Current Value |
"Experiment Workflow to Experiment Schedule Workflow" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_EXPT_WRKFLW_TO_EXPT_WRKFLW |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Experiment Workflow |
Child Entity | Experiment Schedule Workflow |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Experiment Workflow to Experiment Schedule Workflow" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Experiment Workflow to Experiment Schedule Workflow" Foreign Keys |
Parent Key | Child Key |
WorkFlow Identifier | WorkFlow Identifier |
"Experiment Workflow to Experiment Schedule Workflow" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Experiment Workflow to Experiment Schedule Workflow" 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 |
"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 |
"Experiment Workflow to Experiment Schedule Workflow" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | FK_NEXT_WRKFLW_TO_EXPT_WRKFLW |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Experiment Workflow |
Child Entity | Experiment Schedule Workflow |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
"Experiment Workflow to Experiment Schedule Workflow" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Experiment Workflow to Experiment Schedule Workflow" Foreign Keys |
Parent Key | Child Key |
WorkFlow Identifier | Next WorkFlow Identifier |
"Experiment Workflow to Experiment Schedule Workflow" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Experiment Workflow to Experiment Schedule Workflow" 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 |
"Proposal Group to Proposal Group Proposal Assocation" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_pgpa_to_prpsl_grp |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Proposal Group |
Child Entity | Proposal Group Proposal Assocation |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Proposal Group to Proposal Group Proposal Assocation" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Proposal Group to Proposal Group Proposal Assocation" Foreign Keys |
Parent Key | Child Key |
Proposal Group Identifier | Proposal Group Identifier |
"Proposal Group to Proposal Group Proposal Assocation" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Proposal Group to Proposal Group Proposal Assocation" Bound Attachments |
Name | Current Value |
"Proposal Submission to Proposal Group Proposal Assocation" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_PGPA_TO_PRPSL_SUBMISS |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Proposal Submission |
Child Entity | Proposal Group Proposal Assocation |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Proposal Submission to Proposal Group Proposal Assocation" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Proposal Submission to Proposal Group Proposal Assocation" Foreign Keys |
Parent Key | Child Key |
Proposal Identifier, Submission Number | Proposal Identifier, Submission Number |
"Proposal Submission to Proposal Group Proposal Assocation" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Proposal Submission to Proposal Group Proposal Assocation" Bound Attachments |
Name | Current Value |
"Proposal Submission to Proposal Logbook Entry Association" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_PLEA_TO_PRPSL_SUBMISS |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Proposal Submission |
Child Entity | Proposal Logbook Entry Association |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Proposal Submission to Proposal Logbook Entry Association" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Proposal Submission to Proposal Logbook Entry Association" Foreign Keys |
Parent Key | Child Key |
Proposal Identifier, Submission Number | Proposal Identifier, Submission Number |
"Proposal Submission to Proposal Logbook Entry Association" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Proposal Submission to Proposal Logbook Entry Association" Bound Attachments |
Name | Current Value |
"EXPRESS.Unit of Measure to Experiment Resource" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | fk_press_uom_to_uom |
Relationship Business Name | |
Logical Only | No |
Parent Entity | EXPRESS.Unit of Measure |
Child Entity | Experiment Resource |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
"EXPRESS.Unit of Measure to Experiment Resource" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EXPRESS.Unit of Measure to Experiment Resource" Foreign Keys |
Parent Key | Child Key |
Unit Identifier | Pressure Unit of Measure |
"EXPRESS.Unit of Measure to Experiment Resource" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"EXPRESS.Unit of Measure to Experiment Resource" 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 |
"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 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 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 |
"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 |
"XF_ADMIN.Instrument to Proposal Type Schedule" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_PRPSL_TYPE_SCHED_TO_INSTR |
Relationship Business Name | |
Logical Only | No |
Parent Entity | XF_ADMIN.Instrument |
Child Entity | Proposal Type Schedule |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"XF_ADMIN.Instrument to Proposal Type Schedule" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"XF_ADMIN.Instrument to Proposal Type Schedule" Foreign Keys |
Parent Key | Child Key |
Instrument Identifier | Instrument Identifier |
"XF_ADMIN.Instrument to Proposal Type Schedule" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"XF_ADMIN.Instrument to Proposal Type Schedule" Bound Attachments |
Name | Current Value |
"Proposal Type to Proposal Type Schedule" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_PTS_TO_PRPSL_TYPE |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Proposal Type |
Child Entity | Proposal Type Schedule |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Proposal Type to Proposal Type Schedule" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Proposal Type to Proposal Type Schedule" Foreign Keys |
Parent Key | Child Key |
Proposal Type Identifer | Proposal Type Identifer |
"Proposal Type to Proposal Type Schedule" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Proposal Type to Proposal Type Schedule" Bound Attachments |
Name | Current Value |
"Express Activity to Recent Activity" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_RECENT_ACT_TO_EXP_ACT |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Express Activity |
Child Entity | Recent Activity |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Express Activity to Recent Activity" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Express Activity to Recent Activity" Foreign Keys |
Parent Key | Child Key |
Activity Identifier | Activity Identifier |
"Express Activity to Recent Activity" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Express Activity to Recent Activity" Bound Attachments |
Name | Current Value |
"EXPRESS.User Profile to Region Hide" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_REGION_HIDE_TO_USER_PROF |
Relationship Business Name | |
Logical Only | No |
Parent Entity | EXPRESS.User Profile |
Child Entity | Region Hide |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"EXPRESS.User Profile to Region Hide" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EXPRESS.User Profile to Region Hide" Foreign Keys |
Parent Key | Child Key |
Badge Number | Badge Number |
"EXPRESS.User Profile to Region Hide" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"EXPRESS.User Profile to Region Hide" Bound Attachments |
Name | Current Value |
"XF_ADMIN.Employee to Experiment Resource Personnel Resource" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_REPA_TO_EMP |
Relationship Business Name | |
Logical Only | No |
Parent Entity | XF_ADMIN.Employee |
Child Entity | Experiment Resource Personnel Resource |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"XF_ADMIN.Employee to Experiment Resource Personnel Resource" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"XF_ADMIN.Employee to Experiment Resource Personnel Resource" Foreign Keys |
Parent Key | Child Key |
Badge Number | Badge Number |
"XF_ADMIN.Employee to Experiment Resource Personnel Resource" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"XF_ADMIN.Employee to Experiment Resource Personnel Resource" Bound Attachments |
Name | Current Value |
"EXPRESS.Unit of Measure to Experiment Resource" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | fk_restore_uom_to_uom |
Relationship Business Name | |
Logical Only | No |
Parent Entity | EXPRESS.Unit of Measure |
Child Entity | Experiment Resource |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
"EXPRESS.Unit of Measure to Experiment Resource" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EXPRESS.Unit of Measure to Experiment Resource" Foreign Keys |
Parent Key | Child Key |
Unit Identifier | Restore Time Unit of Measure |
"EXPRESS.Unit of Measure to Experiment Resource" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"EXPRESS.Unit of Measure to Experiment Resource" Bound Attachments |
Name | Current Value |
"Experiment Resource to Resource Set Temporary" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_rst_to_expt_rsrc |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Experiment Resource |
Child Entity | Resource Set Temporary |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Experiment Resource to Resource Set Temporary" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Experiment Resource to Resource Set Temporary" Foreign Keys |
Parent Key | Child Key |
Experiment Resource Identifier | Experiment Resource Identifier |
"Experiment Resource to Resource Set Temporary" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Experiment Resource to Resource Set Temporary" Bound Attachments |
Name | Current Value |
"EXPRESS.Unit of Measure to Experiment Resource" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | fk_setup_uom_to_uom |
Relationship Business Name | |
Logical Only | No |
Parent Entity | EXPRESS.Unit of Measure |
Child Entity | Experiment Resource |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
"EXPRESS.Unit of Measure to Experiment Resource" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EXPRESS.Unit of Measure to Experiment Resource" Foreign Keys |
Parent Key | Child Key |
Unit Identifier | Setup Time Unit of Measure |
"EXPRESS.Unit of Measure to Experiment Resource" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"EXPRESS.Unit of Measure to Experiment Resource" Bound Attachments |
Name | Current Value |
"EXPRESS.Unit of Measure to Experiment Resource" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | fk_smpl_uom_to_uom |
Relationship Business Name | |
Logical Only | No |
Parent Entity | EXPRESS.Unit of Measure |
Child Entity | Experiment Resource |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
"EXPRESS.Unit of Measure to Experiment Resource" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EXPRESS.Unit of Measure to Experiment Resource" Foreign Keys |
Parent Key | Child Key |
Unit Identifier | Sample Space Unit of Measure |
"EXPRESS.Unit of Measure to Experiment Resource" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"EXPRESS.Unit of Measure to Experiment Resource" Bound Attachments |
Name | Current Value |
"EXPRESS.Unit of Measure to Experiment Resource" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | fk_tail_uom_to_uom |
Relationship Business Name | |
Logical Only | No |
Parent Entity | EXPRESS.Unit of Measure |
Child Entity | Experiment Resource |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
"EXPRESS.Unit of Measure to Experiment Resource" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EXPRESS.Unit of Measure to Experiment Resource" Foreign Keys |
Parent Key | Child Key |
Unit Identifier | Tail Distance Center Unit of Measure |
"EXPRESS.Unit of Measure to Experiment Resource" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"EXPRESS.Unit of Measure to Experiment Resource" Bound Attachments |
Name | Current Value |
"EXPRESS.Unit of Measure to Experiment Resource" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | fk_temp_uom_to_uom |
Relationship Business Name | |
Logical Only | No |
Parent Entity | EXPRESS.Unit of Measure |
Child Entity | Experiment Resource |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
"EXPRESS.Unit of Measure to Experiment Resource" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EXPRESS.Unit of Measure to Experiment Resource" Foreign Keys |
Parent Key | Child Key |
Unit Identifier | Temperature Unit of Measure |
"EXPRESS.Unit of Measure to Experiment Resource" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"EXPRESS.Unit of Measure to Experiment Resource" Bound Attachments |
Name | Current Value |
"EXPRESS.Application File to User Application File Association" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_UADA_TO_APPL_FILE |
Relationship Business Name | |
Logical Only | No |
Parent Entity | EXPRESS.Application File |
Child Entity | User Application File Association |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"EXPRESS.Application File to User Application File Association" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EXPRESS.Application File to User Application File Association" Foreign Keys |
Parent Key | Child Key |
Application File Identifier | Application File Identifier |
"EXPRESS.Application File to User Application File Association" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"EXPRESS.Application File to User Application File Association" Bound Attachments |
Name | Current Value |
"EXPRESS.User Profile to User Application File Association" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_UAFA_TO_USER_PROFILE |
Relationship Business Name | |
Logical Only | No |
Parent Entity | EXPRESS.User Profile |
Child Entity | User Application File Association |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"EXPRESS.User Profile to User Application File Association" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EXPRESS.User Profile to User Application File Association" Foreign Keys |
Parent Key | Child Key |
Badge Number | Badge Number |
"EXPRESS.User Profile to User Application File Association" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"EXPRESS.User Profile to User Application File Association" Bound Attachments |
Name | Current Value |
"XF_ADMIN.Email Template to User Email Template Association" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_UETA_TO_EMAIL_TMPL |
Relationship Business Name | |
Logical Only | No |
Parent Entity | XF_ADMIN.Email Template |
Child Entity | User Email Template Association |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"XF_ADMIN.Email Template to User Email Template Association" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"XF_ADMIN.Email Template to User Email Template Association" Foreign Keys |
Parent Key | Child Key |
Template Identifier | Template Identifier |
"XF_ADMIN.Email Template to User Email Template Association" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"XF_ADMIN.Email Template to User Email Template Association" Bound Attachments |
Name | Current Value |
"XF_ADMIN.Employee to User Email Template Association" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_UETA_TO_EMP |
Relationship Business Name | |
Logical Only | No |
Parent Entity | XF_ADMIN.Employee |
Child Entity | User Email Template Association |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"XF_ADMIN.Employee to User Email Template Association" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"XF_ADMIN.Employee to User Email Template Association" Foreign Keys |
Parent Key | Child Key |
Badge Number | Badge Number |
"XF_ADMIN.Employee to User Email Template Association" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"XF_ADMIN.Employee to User Email Template Association" Bound Attachments |
Name | Current Value |
"EXPRESS.Unit of Measure to Unit of Measure Column Association" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_uomca_to_uom |
Relationship Business Name | |
Logical Only | No |
Parent Entity | EXPRESS.Unit of Measure |
Child Entity | Unit of Measure Column Association |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"EXPRESS.Unit of Measure to Unit of Measure Column Association" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EXPRESS.Unit of Measure to Unit of Measure Column Association" Foreign Keys |
Parent Key | Child Key |
Unit Identifier | Unit Identifier |
"EXPRESS.Unit of Measure to Unit of Measure Column Association" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"EXPRESS.Unit of Measure to Unit of Measure Column Association" Bound Attachments |
Name | Current Value |
"Unit of Measure Column to Unit of Measure Column Association" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_uomca_to_uom_col |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Unit of Measure Column |
Child Entity | Unit of Measure Column Association |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Unit of Measure Column to Unit of Measure Column Association" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Unit of Measure Column to Unit of Measure Column Association" Foreign Keys |
Parent Key | Child Key |
Column Name Identifier | Column Name Identifier |
"Unit of Measure Column to Unit of Measure Column Association" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Unit of Measure Column to Unit of Measure Column Association" Bound Attachments |
Name | Current Value |
"XF_ADMIN.Employee to User Profile" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_USER_PROF_TO_EMP |
Relationship Business Name | |
Logical Only | No |
Parent Entity | XF_ADMIN.Employee |
Child Entity | User Profile |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"XF_ADMIN.Employee to User Profile" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"XF_ADMIN.Employee to User Profile" Foreign Keys |
Parent Key | Child Key |
Badge Number | Badge Number |
"XF_ADMIN.Employee to User Profile" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"XF_ADMIN.Employee to User Profile" Bound Attachments |
Name | Current Value |
"XF_ADMIN.Instrument to User Profile" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | FK_USER_PROF_TO_INSTR |
Relationship Business Name | |
Logical Only | No |
Parent Entity | XF_ADMIN.Instrument |
Child Entity | User Profile |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
"XF_ADMIN.Instrument to User Profile" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"XF_ADMIN.Instrument to User Profile" Foreign Keys |
Parent Key | Child Key |
Instrument Identifier | Default Instrument Identifier |
"XF_ADMIN.Instrument to User Profile" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"XF_ADMIN.Instrument to User Profile" Bound Attachments |
Name | Current Value |
"Person to User Profile" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | FK_USER_PROF_TO_PERSON |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Person |
Child Entity | User Profile |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
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 | Impersonate 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 |