"SMPL.Sample to Sample Set Temporary" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | |
Relationship Business Name | |
Logical Only | No |
Parent Entity | SMPL.Sample |
Child Entity | Sample Set Temporary |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"SMPL.Sample to Sample Set Temporary" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"SMPL.Sample to Sample Set Temporary" Foreign Keys |
Parent Key | Child Key |
Sample Identifier | Sample Identifier |
"SMPL.Sample to Sample Set Temporary" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"SMPL.Sample to Sample Set Temporary" 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 |
"Control Area to Control Area Custodian" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_ctrl_area_cust_to_ctrl_area |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Control Area |
Child Entity | Control Area Custodian |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Control Area to Control Area Custodian" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Control Area to Control Area Custodian" Foreign Keys |
Parent Key | Child Key |
ControlArea Identifier | ControlArea Identifier |
"Control Area to Control Area Custodian" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Control Area to Control Area Custodian" Bound Attachments |
Name | Current Value |
"XF_ADMIN.Employee to Control Area Custodian" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_ctrl_area_cust_to_employee |
Relationship Business Name | |
Logical Only | No |
Parent Entity | XF_ADMIN.Employee |
Child Entity | Control Area Custodian |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"XF_ADMIN.Employee to Control Area Custodian" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"XF_ADMIN.Employee to Control Area Custodian" Foreign Keys |
Parent Key | Child Key |
Badge Number | Badge Number |
"XF_ADMIN.Employee to Control Area Custodian" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"XF_ADMIN.Employee to Control Area Custodian" Bound Attachments |
Name | Current Value |
"Control Area to Control Area Inventory" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_CTRL_AREA_INVT_TO_CTRL_INVT |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Control Area |
Child Entity | Control Area Inventory |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Control Area to Control Area Inventory" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Control Area to Control Area Inventory" Foreign Keys |
Parent Key | Child Key |
ControlArea Identifier | ControlArea Identifier |
"Control Area to Control Area Inventory" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Control Area to Control Area Inventory" Bound Attachments |
Name | Current Value |
"XF_ADMIN.Employee to Control Area Inventory" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | FK_CTRL_AREA_INVT_TO_EMP |
Relationship Business Name | |
Logical Only | No |
Parent Entity | XF_ADMIN.Employee |
Child Entity | Control Area Inventory |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
"XF_ADMIN.Employee to Control Area Inventory" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"XF_ADMIN.Employee to Control Area Inventory" Foreign Keys |
Parent Key | Child Key |
Badge Number | Badge Number |
"XF_ADMIN.Employee to Control Area Inventory" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"XF_ADMIN.Employee to Control Area Inventory" Bound Attachments |
Name | Current Value |
"Control Area Subarea to Control Area Subarea1" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_CTRL_AREA_SUB1_TO_SUBAREA |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Control Area Subarea |
Child Entity | Control Area Subarea1 |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Control Area Subarea to Control Area Subarea1" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Control Area Subarea to Control Area Subarea1" Foreign Keys |
Parent Key | Child Key |
ControlArea Identifier, SubArea Identifier | ControlArea Identifier, SubArea Identifier |
"Control Area Subarea to Control Area Subarea1" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Control Area Subarea to Control Area Subarea1" Bound Attachments |
Name | Current Value |
"Control Area Subarea1 to Control Area Subarea2" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_CTRL_AREA_SUB2_TO_SUBAREA1 |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Control Area Subarea1 |
Child Entity | Control Area Subarea2 |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Control Area Subarea1 to Control Area Subarea2" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Control Area Subarea1 to Control Area Subarea2" Foreign Keys |
Parent Key | Child Key |
ControlArea Identifier, SubArea Identifier, SubArea1 Identifier | ControlArea Identifier, SubArea Identifier, SubArea1 Identifier |
"Control Area Subarea1 to Control Area Subarea2" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Control Area Subarea1 to Control Area Subarea2" Bound Attachments |
Name | Current Value |
"Control Area to Control Area Subarea" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_ctrl_area_subarea_to_ctrl_area |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Control Area |
Child Entity | Control Area Subarea |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Control Area to Control Area Subarea" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Control Area to Control Area Subarea" Foreign Keys |
Parent Key | Child Key |
ControlArea Identifier | ControlArea Identifier |
"Control Area to Control Area Subarea" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Control Area to Control Area Subarea" Bound Attachments |
Name | Current Value |
"Control Area Type to Control Area" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | fk_ctrl_area_to_ca_type |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Control Area Type |
Child Entity | Control Area |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Control Area Type to Control Area" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Control Area Type to Control Area" Foreign Keys |
Parent Key | Child Key |
Type Identifier | Type Identifier |
"Control Area Type to Control Area" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Control Area Type to Control Area" Bound Attachments |
Name | Current Value |
"XF_ADMIN.Instrument to Control Area" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | fk_ctrl_area_to_instr |
Relationship Business Name | |
Logical Only | No |
Parent Entity | XF_ADMIN.Instrument |
Child Entity | Control Area |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
"XF_ADMIN.Instrument to Control Area" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"XF_ADMIN.Instrument to Control Area" Foreign Keys |
Parent Key | Child Key |
Instrument Identifier | Instrument Identifier |
"XF_ADMIN.Instrument to Control Area" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"XF_ADMIN.Instrument to Control Area" Bound Attachments |
Name | Current Value |
"XF_ADMIN.Laboratory to Control Area" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | fk_ctrl_area_to_lab |
Relationship Business Name | |
Logical Only | No |
Parent Entity | XF_ADMIN.Laboratory |
Child Entity | Control Area |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
"XF_ADMIN.Laboratory to Control Area" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"XF_ADMIN.Laboratory to Control Area" Foreign Keys |
Parent Key | Child Key |
Laboratory Identifier | Laboratory Identifier |
"XF_ADMIN.Laboratory to Control Area" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"XF_ADMIN.Laboratory to Control Area" Bound Attachments |
Name | Current Value |
"Sample Handling to Control Area" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | fk_ctrl_area_to_smpl_hand |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Sample Handling |
Child Entity | Control Area |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
"Sample Handling to Control Area" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Sample Handling to Control Area" Foreign Keys |
Parent Key | Child Key |
Handling Identifier | Handling Identifier |
"Sample Handling to Control Area" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Sample Handling to Control Area" Bound Attachments |
Name | Current Value |
"Sample Storage to Control Area" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | fk_ctrl_area_to_smpl_stor |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Sample Storage |
Child Entity | Control Area |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
"Sample Storage to Control Area" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Sample Storage to Control Area" Foreign Keys |
Parent Key | Child Key |
Storage Identifier | Storage Identifier |
"Sample Storage to Control Area" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Sample Storage to Control Area" Bound Attachments |
Name | Current Value |
"Department of Transportation Packing Group to DOT Hazardous Material Table" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | fk_dhmt_to_dot_pkg_grp |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Department of Transportation Packing Group |
Child Entity | DOT Hazardous Material Table |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
"Department of Transportation Packing Group to DOT Hazardous Material Table" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Department of Transportation Packing Group to DOT Hazardous Material Table" Foreign Keys |
Parent Key | Child Key |
Packing Group Identifier | Packing Group Identifier |
"Department of Transportation Packing Group to DOT Hazardous Material Table" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Department of Transportation Packing Group to DOT Hazardous Material Table" Bound Attachments |
Name | Current Value |
"Feedback Status to Feedback" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | FK_FEED_TO_FEED_STAT |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Feedback Status |
Child Entity | Feedback |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Feedback Status to Feedback" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Feedback Status to Feedback" Foreign Keys |
Parent Key | Child Key |
Status Identifier | Status Identifier |
"Feedback Status to Feedback" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Feedback Status to Feedback" 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 |
"Sample Activity to Inventory and Tracking for Equipment, Materials and Samples Log" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_items_log_to_smpl_act |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Sample Activity |
Child Entity | Inventory and Tracking for Equipment, Materials and Samples Log |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Sample Activity to Inventory and Tracking for Equipment, Materials and Samples Log" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Sample Activity to Inventory and Tracking for Equipment, Materials and Samples Log" Foreign Keys |
Parent Key | Child Key |
Activity Identifier | Activity Identifier |
"Sample Activity to Inventory and Tracking for Equipment, Materials and Samples Log" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Sample Activity to Inventory and Tracking for Equipment, Materials and Samples Log" Bound Attachments |
Name | Current Value |
"XF_ADMIN.Employee to Sample Shipment" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | FK_ORIG_BY_BN_TO_EMP |
Relationship Business Name | |
Logical Only | No |
Parent Entity | XF_ADMIN.Employee |
Child Entity | Sample Shipment |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
"XF_ADMIN.Employee to Sample Shipment" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"XF_ADMIN.Employee to Sample Shipment" Foreign Keys |
Parent Key | Child Key |
Badge Number | Ship Order Originated By Badge Number |
"XF_ADMIN.Employee to Sample Shipment" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"XF_ADMIN.Employee to Sample Shipment" Bound Attachments |
Name | Current Value |
"Control Area to Sample" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | fk_sample_to_ctrl_area |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Control Area |
Child Entity | Sample |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Control Area to Sample" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Control Area to Sample" Foreign Keys |
Parent Key | Child Key |
ControlArea Identifier | ControlArea Identifier |
"Control Area to Sample" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Control Area to Sample" Bound Attachments |
Name | Current Value |
"Control Area Subarea to Sample" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | fk_sample_to_ctrl_area_subarea |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Control Area Subarea |
Child Entity | Sample |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
"Control Area Subarea to Sample" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Control Area Subarea to Sample" Foreign Keys |
Parent Key | Child Key |
ControlArea Identifier, SubArea Identifier | ControlArea Identifier, SubArea Identifier |
"Control Area Subarea to Sample" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Control Area Subarea to Sample" Bound Attachments |
Name | Current Value |
"Material State to Sample" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | fk_sample_to_mat_stat |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Material State |
Child Entity | Sample |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Material State to Sample" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Material State to Sample" Foreign Keys |
Parent Key | Child Key |
State Id | Material State Identifier |
"Material State to Sample" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Material State to Sample" Bound Attachments |
Name | Current Value |
"Sample Container to Sample" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | fk_sample_to_smpl_cont |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Sample Container |
Child Entity | Sample |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Sample Container to Sample" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Sample Container to Sample" Foreign Keys |
Parent Key | Child Key |
Container Identifier | Container Identifier |
"Sample Container to Sample" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Sample Container to Sample" Bound Attachments |
Name | Current Value |
"Sample Status to Sample" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | fk_sample_to_smpl_status |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Sample Status |
Child Entity | Sample |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Sample Status to Sample" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Sample Status to Sample" Foreign Keys |
Parent Key | Child Key |
Status Identifier | Status Identifier |
"Sample Status to Sample" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Sample Status to Sample" Bound Attachments |
Name | Current Value |
"Control Area Subarea to Sample Delivery Request" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | fk_sdr_to_ctrl_subarea |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Control Area Subarea |
Child Entity | Sample Delivery Request |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
"Control Area Subarea to Sample Delivery Request" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Control Area Subarea to Sample Delivery Request" Foreign Keys |
Parent Key | Child Key |
ControlArea Identifier, SubArea Identifier | ControlArea Identifier, SubArea Identifier |
"Control Area Subarea to Sample Delivery Request" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Control Area Subarea to Sample Delivery Request" Bound Attachments |
Name | Current Value |
"Sample Hazard Classification to Sample Hazard Classification Item" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_shci_to_smpl_haz_class |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Sample Hazard Classification |
Child Entity | Sample Hazard Classification Item |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Sample Hazard Classification to Sample Hazard Classification Item" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Sample Hazard Classification to Sample Hazard Classification Item" Foreign Keys |
Parent Key | Child Key |
Sample Hazard Identifier | Sample Hazard Identifier |
"Sample Hazard Classification to Sample Hazard Classification Item" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Sample Hazard Classification to Sample Hazard Classification Item" Bound Attachments |
Name | Current Value |
"Country to Shipment Facility" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | FK_SHIP_FACIL_TO_CNTRY |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Country |
Child Entity | Shipment Facility |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Country to Shipment Facility" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Country to Shipment Facility" Foreign Keys |
Parent Key | Child Key |
Country Identifier | Country Identifier |
"Country to Shipment Facility" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Country to Shipment Facility" Bound Attachments |
Name | Current Value |
"SMPL.Attachment Type to Sample Attachment" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | fk_smpl_attach_to_attach_type |
Relationship Business Name | |
Logical Only | No |
Parent Entity | SMPL.Attachment Type |
Child Entity | Sample Attachment |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
"SMPL.Attachment Type to Sample Attachment" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"SMPL.Attachment Type to Sample Attachment" Foreign Keys |
Parent Key | Child Key |
Attachment Type Identifier | Attachment Type Identifier |
"SMPL.Attachment Type to Sample Attachment" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"SMPL.Attachment Type to Sample Attachment" Bound Attachments |
Name | Current Value |
"Sample Attachment to Sample Sample Attachment Association" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_smpl_attach_to_sample |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Sample Attachment |
Child Entity | Sample Sample Attachment Association |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Sample Attachment to Sample Sample Attachment Association" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Sample Attachment to Sample Sample Attachment Association" Foreign Keys |
Parent Key | Child Key |
Attachment Identifier | Attachment Identifier |
"Sample Attachment to Sample Sample Attachment Association" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Sample Attachment to Sample Sample Attachment Association" Bound Attachments |
Name | Current Value |
"Sample Container to Sample Can" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_smpl_can_to_smpl_cont |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Sample Container |
Child Entity | Sample Can |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Sample Container to Sample Can" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Sample Container to Sample Can" Foreign Keys |
Parent Key | Child Key |
Container Identifier | Container Identifier |
"Sample Container to Sample Can" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Sample Container to Sample Can" Bound Attachments |
Name | Current Value |
"HMMIS Chemical to Sample Classification" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | fk_smpl_class_to_hmmis_chem |
Relationship Business Name | |
Logical Only | No |
Parent Entity | HMMIS Chemical |
Child Entity | Sample Classification |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
"HMMIS Chemical to Sample Classification" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"HMMIS Chemical to Sample Classification" Foreign Keys |
Parent Key | Child Key |
Chemical recId | Chemical recId |
"HMMIS Chemical to Sample Classification" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"HMMIS Chemical to Sample Classification" Bound Attachments |
Name | Current Value |
"SMPL.Sample to Sample Classification" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_smpl_class_to_sample |
Relationship Business Name | |
Logical Only | No |
Parent Entity | SMPL.Sample |
Child Entity | Sample Classification |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"SMPL.Sample to Sample Classification" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"SMPL.Sample to Sample Classification" Foreign Keys |
Parent Key | Child Key |
Sample Identifier | Sample Identifier |
"SMPL.Sample to Sample Classification" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"SMPL.Sample to Sample Classification" Bound Attachments |
Name | Current Value |
"Sample Hazard to Sample Classification" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | fk_smpl_class_to_smpl_haz |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Sample Hazard |
Child Entity | Sample Classification |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
"Sample Hazard to Sample Classification" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Sample Hazard to Sample Classification" Foreign Keys |
Parent Key | Child Key |
Sample Hazard Identifier | Sample Hazard Identifier |
"Sample Hazard to Sample Classification" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Sample Hazard to Sample Classification" Bound Attachments |
Name | Current Value |
"SMPL.Sample to Sample Delete Request" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_smpl_del_req_to_smpl |
Relationship Business Name | |
Logical Only | No |
Parent Entity | SMPL.Sample |
Child Entity | Sample Delete Request |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"SMPL.Sample to Sample Delete Request" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"SMPL.Sample to Sample Delete Request" Foreign Keys |
Parent Key | Child Key |
Sample Identifier | Sample Identifier |
"SMPL.Sample to Sample Delete Request" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"SMPL.Sample to Sample Delete Request" Bound Attachments |
Name | Current Value |
"Control Area to Sample Delivery Request" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | fk_smpL_deliv_req_to_ctrl_area |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Control Area |
Child Entity | Sample Delivery Request |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Control Area to Sample Delivery Request" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Control Area to Sample Delivery Request" Foreign Keys |
Parent Key | Child Key |
ControlArea Identifier | ControlArea Identifier |
"Control Area to Sample Delivery Request" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Control Area to Sample Delivery Request" Bound Attachments |
Name | Current Value |
"XF_ADMIN.Employee to Sample Delivery Request" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | fk_smpL_deliv_req_to_emp |
Relationship Business Name | |
Logical Only | No |
Parent Entity | XF_ADMIN.Employee |
Child Entity | Sample Delivery Request |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"XF_ADMIN.Employee to Sample Delivery Request" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"XF_ADMIN.Employee to Sample Delivery Request" Foreign Keys |
Parent Key | Child Key |
Badge Number | Badge Number |
"XF_ADMIN.Employee to Sample Delivery Request" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"XF_ADMIN.Employee to Sample Delivery Request" Bound Attachments |
Name | Current Value |
"SMPL.Sample to Sample Delivery Request" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_smpL_deliv_req_to_smpl |
Relationship Business Name | |
Logical Only | No |
Parent Entity | SMPL.Sample |
Child Entity | Sample Delivery Request |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"SMPL.Sample to Sample Delivery Request" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"SMPL.Sample to Sample Delivery Request" Foreign Keys |
Parent Key | Child Key |
Sample Identifier | Sample Identifier |
"SMPL.Sample to Sample Delivery Request" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"SMPL.Sample to Sample Delivery Request" Bound Attachments |
Name | Current Value |
"Sample Group to Sample" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | fk_smpl_grp_to_sample |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Sample Group |
Child Entity | Sample |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
"Sample Group to Sample" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Sample Group to Sample" Foreign Keys |
Parent Key | Child Key |
Group Identifier | Group Identifier |
"Sample Group to Sample" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Sample Group to Sample" Bound Attachments |
Name | Current Value |
"Department of Transportation Hazardous Material Class to Sample" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | fk_smpl_haz_to_dot_haz_class |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Department of Transportation Hazardous Material Class |
Child Entity | Sample |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
"Department of Transportation Hazardous Material Class to Sample" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Department of Transportation Hazardous Material Class to Sample" Foreign Keys |
Parent Key | Child Key |
DOT Class Number, DOT Division Number | DOT Class Number, DOT Division Number |
"Department of Transportation Hazardous Material Class to Sample" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Department of Transportation Hazardous Material Class to Sample" Bound Attachments |
Name | Current Value |
"Beam Energy Unit of Measure to Sample Irradiation" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | FK_SMPL_IRRAD_TO_BEUOM |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Beam Energy Unit of Measure |
Child Entity | Sample Irradiation |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Beam Energy Unit of Measure to Sample Irradiation" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Beam Energy Unit of Measure to Sample Irradiation" Foreign Keys |
Parent Key | Child Key |
Beam Energy Unit of Measure Identifier | Beam Energy Unit of Measure Identifier |
"Beam Energy Unit of Measure to Sample Irradiation" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Beam Energy Unit of Measure to Sample Irradiation" Bound Attachments |
Name | Current Value |
"XF_ADMIN.Instrument to Sample Irradiation" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_SMPL_IRRAD_TO_INSTR |
Relationship Business Name | |
Logical Only | No |
Parent Entity | XF_ADMIN.Instrument |
Child Entity | Sample Irradiation |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"XF_ADMIN.Instrument to Sample Irradiation" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"XF_ADMIN.Instrument to Sample Irradiation" Foreign Keys |
Parent Key | Child Key |
Instrument Identifier | Instrument Identifier |
"XF_ADMIN.Instrument to Sample Irradiation" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"XF_ADMIN.Instrument to Sample Irradiation" Bound Attachments |
Name | Current Value |
"SMPL.Sample to Sample Irradiation" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_SMPL_IRRAD_TO_SMPL |
Relationship Business Name | |
Logical Only | No |
Parent Entity | SMPL.Sample |
Child Entity | Sample Irradiation |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"SMPL.Sample to Sample Irradiation" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"SMPL.Sample to Sample Irradiation" Foreign Keys |
Parent Key | Child Key |
Sample Identifier | Sample Identifier |
"SMPL.Sample to Sample Irradiation" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"SMPL.Sample to Sample Irradiation" Bound Attachments |
Name | Current Value |
"Time Unit of Measure to Sample Irradiation" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | FK_SMPL_IRRAD_TO_TIME_UOM |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Time Unit of Measure |
Child Entity | Sample Irradiation |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Time Unit of Measure to Sample Irradiation" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Time Unit of Measure to Sample Irradiation" Foreign Keys |
Parent Key | Child Key |
Time Unit Identifier | Time Unit Identifier |
"Time Unit of Measure to Sample Irradiation" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Time Unit of Measure to Sample Irradiation" Bound Attachments |
Name | Current Value |
"Sample List to Sample List Sample Association" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_SMPL_LIST_SA_TO_SMPL_LIST |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Sample List |
Child Entity | Sample List Sample Association |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Sample List to Sample List Sample Association" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Sample List to Sample List Sample Association" Foreign Keys |
Parent Key | Child Key |
Sample List Identifier | Sample List Identifier |
"Sample List to Sample List Sample Association" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Sample List to Sample List Sample Association" Bound Attachments |
Name | Current Value |
"SMPL.Sample to Sample List Sample Association" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_SMPL_LIST_SMPL_ASSC_TO_SMPL |
Relationship Business Name | |
Logical Only | No |
Parent Entity | SMPL.Sample |
Child Entity | Sample List Sample Association |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"SMPL.Sample to Sample List Sample Association" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"SMPL.Sample to Sample List Sample Association" Foreign Keys |
Parent Key | Child Key |
Sample Identifier | Sample Identifier |
"SMPL.Sample to Sample List Sample Association" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"SMPL.Sample to Sample List Sample Association" Bound Attachments |
Name | Current Value |
"SMPL.Sample to Sample Log" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_smpl_log_to_sample |
Relationship Business Name | |
Logical Only | No |
Parent Entity | SMPL.Sample |
Child Entity | Sample Log |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"SMPL.Sample to Sample Log" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"SMPL.Sample to Sample Log" Foreign Keys |
Parent Key | Child Key |
Sample Identifier | Sample Identifier |
"SMPL.Sample to Sample Log" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"SMPL.Sample to Sample Log" Bound Attachments |
Name | Current Value |
"Sample Activity to Sample Log" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_smpl_log_to_smpl_act |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Sample Activity |
Child Entity | Sample Log |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Sample Activity to Sample Log" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Sample Activity to Sample Log" Foreign Keys |
Parent Key | Child Key |
Activity Identifier | Activity Identifier |
"Sample Activity to Sample Log" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Sample Activity to Sample Log" Bound Attachments |
Name | Current Value |
"PRPSL.Proposal to Sample Proposal Association" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_smpl_prpsl_accs_to_prpsl |
Relationship Business Name | |
Logical Only | No |
Parent Entity | PRPSL.Proposal |
Child Entity | Sample Proposal Association |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"PRPSL.Proposal to Sample Proposal Association" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"PRPSL.Proposal to Sample Proposal Association" Foreign Keys |
Parent Key | Child Key |
Proposal Identifier | Proposal Identifier |
"PRPSL.Proposal to Sample Proposal Association" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"PRPSL.Proposal to Sample Proposal Association" Bound Attachments |
Name | Current Value |
"SMPL.Sample to Sample Proposal Association" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_smpl_prpsl_assc_to_sample |
Relationship Business Name | |
Logical Only | No |
Parent Entity | SMPL.Sample |
Child Entity | Sample Proposal Association |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"SMPL.Sample to Sample Proposal Association" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"SMPL.Sample to Sample Proposal Association" Foreign Keys |
Parent Key | Child Key |
Sample Identifier | Sample Identifier |
"SMPL.Sample to Sample Proposal Association" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"SMPL.Sample to Sample Proposal Association" Bound Attachments |
Name | Current Value |
"Radionuclide to Sample Radionuclide Association" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_smpl_radio_assc_to_radionuc |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Radionuclide |
Child Entity | Sample Radionuclide Association |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Radionuclide to Sample Radionuclide Association" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Radionuclide to Sample Radionuclide Association" Foreign Keys |
Parent Key | Child Key |
Symbol Identifier | Symbol Identifier |
"Radionuclide to Sample Radionuclide Association" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Radionuclide to Sample Radionuclide Association" Bound Attachments |
Name | Current Value |
"SMPL.Sample to Sample Radionuclide Association" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_smpl_radio_assc_to_smpl |
Relationship Business Name | |
Logical Only | No |
Parent Entity | SMPL.Sample |
Child Entity | Sample Radionuclide Association |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"SMPL.Sample to Sample Radionuclide Association" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"SMPL.Sample to Sample Radionuclide Association" Foreign Keys |
Parent Key | Child Key |
Sample Identifier | Sample Identifier |
"SMPL.Sample to Sample Radionuclide Association" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"SMPL.Sample to Sample Radionuclide Association" Bound Attachments |
Name | Current Value |
"XF_ADMIN.Employee to Sample Role Employee Association" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_smpl_role_emp_assc_to_emp |
Relationship Business Name | |
Logical Only | No |
Parent Entity | XF_ADMIN.Employee |
Child Entity | Sample Role Employee Association |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"XF_ADMIN.Employee to Sample Role Employee Association" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"XF_ADMIN.Employee to Sample Role Employee Association" Foreign Keys |
Parent Key | Child Key |
Badge Number | Badge Number |
"XF_ADMIN.Employee to Sample Role Employee Association" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"XF_ADMIN.Employee to Sample Role Employee Association" Bound Attachments |
Name | Current Value |
"Sample Role to Sample Role Template" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_smpl_role_tmpl_to_smpl_role |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Sample Role |
Child Entity | Sample Role Template |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Sample Role to Sample Role Template" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Sample Role to Sample Role Template" Foreign Keys |
Parent Key | Child Key |
Role Identifer | Role Identifer |
"Sample Role to Sample Role Template" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Sample Role to Sample Role Template" Bound Attachments |
Name | Current Value |
"Sample Role Group to Sample Role Template" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_smpl_role_tmpl_to_smpl_role_grp |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Sample Role Group |
Child Entity | Sample Role Template |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Sample Role Group to Sample Role Template" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Sample Role Group to Sample Role Template" Foreign Keys |
Parent Key | Child Key |
Sample Role Group Identifier | Sample Role Group Identifier |
"Sample Role Group to Sample Role Template" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Sample Role Group to Sample Role Template" Bound Attachments |
Name | Current Value |
"SMPL.Sample to Sample Sample Shipment Association" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_SMPL_SHIP_ASSC_TO_SMPL |
Relationship Business Name | |
Logical Only | No |
Parent Entity | SMPL.Sample |
Child Entity | Sample Sample Shipment Association |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"SMPL.Sample to Sample Sample Shipment Association" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"SMPL.Sample to Sample Sample Shipment Association" Foreign Keys |
Parent Key | Child Key |
Sample Identifier | Sample Identifier |
"SMPL.Sample to Sample Sample Shipment Association" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"SMPL.Sample to Sample Sample Shipment Association" Bound Attachments |
Name | Current Value |
"Sample Shipment to Sample Sample Shipment Association" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_SMPL_SHIP_ASSC_TO_SMPL_SHIP |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Sample Shipment |
Child Entity | Sample Sample Shipment Association |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Sample Shipment to Sample Sample Shipment Association" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Sample Shipment to Sample Sample Shipment Association" Foreign Keys |
Parent Key | Child Key |
Sample Shipment Identifier | Sample Shipment Identifier |
"Sample Shipment to Sample Sample Shipment Association" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Sample Shipment to Sample Sample Shipment Association" Bound Attachments |
Name | Current Value |
"Sample Shipment to Sample Shipment Attachment" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_SMPL_SHIP_ATT_TO_SMPL_SHIP |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Sample Shipment |
Child Entity | Sample Shipment Attachment |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Sample Shipment to Sample Shipment Attachment" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Sample Shipment to Sample Shipment Attachment" Foreign Keys |
Parent Key | Child Key |
Sample Shipment Identifier | Sample Shipment Identifier |
"Sample Shipment to Sample Shipment Attachment" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Sample Shipment to Sample Shipment Attachment" Bound Attachments |
Name | Current Value |
"XF_ADMIN.Employee to Sample Shipment" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | FK_SMPL_SHIP_TO_EMP |
Relationship Business Name | |
Logical Only | No |
Parent Entity | XF_ADMIN.Employee |
Child Entity | Sample Shipment |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"XF_ADMIN.Employee to Sample Shipment" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"XF_ADMIN.Employee to Sample Shipment" Foreign Keys |
Parent Key | Child Key |
Badge Number | Modified By Badge Number |
"XF_ADMIN.Employee to Sample Shipment" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"XF_ADMIN.Employee to Sample Shipment" Bound Attachments |
Name | Current Value |
"Shipment Facility to Sample Shipment" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | FK_SMPL_SHIP_TO_SHIP_FACIL |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Shipment Facility |
Child Entity | Sample Shipment |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
"Shipment Facility to Sample Shipment" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Shipment Facility to Sample Shipment" Foreign Keys |
Parent Key | Child Key |
Shipment Facility Identifier | Shipment Facility Identifier |
"Shipment Facility to Sample Shipment" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Shipment Facility to Sample Shipment" Bound Attachments |
Name | Current Value |
"Sample Shipment Status to Sample Shipment" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | FK_SMPL_SHIP_TO_SMPL_SHIP_STAT |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Sample Shipment Status |
Child Entity | Sample Shipment |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Sample Shipment Status to Sample Shipment" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Sample Shipment Status to Sample Shipment" Foreign Keys |
Parent Key | Child Key |
Status Identifier | Status Identifier |
"Sample Shipment Status to Sample Shipment" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Sample Shipment Status to Sample Shipment" Bound Attachments |
Name | Current Value |
"Department of Transportation Hazardous Material Class to Sample" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | fk_smpl_subhaz_to_dot_hazclass |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Department of Transportation Hazardous Material Class |
Child Entity | Sample |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
"Department of Transportation Hazardous Material Class to Sample" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Department of Transportation Hazardous Material Class to Sample" Foreign Keys |
Parent Key | Child Key |
DOT Class Number, DOT Division Number | DOT Sub Class Number, DOT Sub-Hazard Division Number |
"Department of Transportation Hazardous Material Class to Sample" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Department of Transportation Hazardous Material Class to Sample" Bound Attachments |
Name | Current Value |
"Control Area Subarea1 to Sample" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | fk_smpl_to_ctrl_area_subarea1 |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Control Area Subarea1 |
Child Entity | Sample |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
"Control Area Subarea1 to Sample" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Control Area Subarea1 to Sample" Foreign Keys |
Parent Key | Child Key |
ControlArea Identifier, SubArea Identifier, SubArea1 Identifier | ControlArea Identifier, SubArea Identifier, SubArea1 Identifier |
"Control Area Subarea1 to Sample" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Control Area Subarea1 to Sample" Bound Attachments |
Name | Current Value |
"Control Area Subarea2 to Sample" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | fk_smpl_to_ctrl_area_subarea2 |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Control Area Subarea2 |
Child Entity | Sample |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
"Control Area Subarea2 to Sample" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Control Area Subarea2 to Sample" Foreign Keys |
Parent Key | Child Key |
ControlArea Identifier, SubArea Identifier, SubArea1 Identifier, SubArea2 Identifier | ControlArea Identifier, SubArea Identifier, SubArea1 Identifier, SubArea2 Identifier |
"Control Area Subarea2 to Sample" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Control Area Subarea2 to Sample" Bound Attachments |
Name | Current Value |
"Department of Transportation Packing Group to Sample" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | fk_smpl_to_dot_pkg_grp |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Department of Transportation Packing Group |
Child Entity | Sample |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
"Department of Transportation Packing Group to Sample" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Department of Transportation Packing Group to Sample" Foreign Keys |
Parent Key | Child Key |
Packing Group Identifier | Packing Group Identifier |
"Department of Transportation Packing Group to Sample" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Department of Transportation Packing Group to Sample" Bound Attachments |
Name | Current Value |
"Sample Can to Sample" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | fk_smpl_to_smpl_can |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Sample Can |
Child Entity | Sample |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
"Sample Can to Sample" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Sample Can to Sample" Foreign Keys |
Parent Key | Child Key |
Can Identifier, Container Identifier | Can Identifier, Container Identifier |
"Sample Can to Sample" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Sample Can to Sample" Bound Attachments |
Name | Current Value |
"Sample Special Requirement to Sample" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | fk_smpl_to_smpl_spec_req |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Sample Special Requirement |
Child Entity | Sample |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Sample Special Requirement to Sample" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Sample Special Requirement to Sample" Foreign Keys |
Parent Key | Child Key |
Requirement Identifier | Requirement Identifier |
"Sample Special Requirement to Sample" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Sample Special Requirement to Sample" Bound Attachments |
Name | Current Value |
"Unit of Length to Sample" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | fk_smpl_to_uol |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Unit of Length |
Child Entity | Sample |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
"Unit of Length to Sample" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Unit of Length to Sample" Foreign Keys |
Parent Key | Child Key |
Length Unit Identifier | Length Unit Identifier |
"Unit of Length to Sample" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Unit of Length to Sample" Bound Attachments |
Name | Current Value |
"Control Area Subarea to Sample Transfer" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_SMPL_TRAN_TO_CTRL_SUB |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Control Area Subarea |
Child Entity | Sample Transfer |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Control Area Subarea to Sample Transfer" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Control Area Subarea to Sample Transfer" Foreign Keys |
Parent Key | Child Key |
ControlArea Identifier, SubArea Identifier | ControlArea Identifier, SubArea Identifier |
"Control Area Subarea to Sample Transfer" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Control Area Subarea to Sample Transfer" Bound Attachments |
Name | Current Value |
"Control Area to Sample Transfer" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_smpl_trans_to_ctrl_area |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Control Area |
Child Entity | Sample Transfer |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Control Area to Sample Transfer" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Control Area to Sample Transfer" Foreign Keys |
Parent Key | Child Key |
ControlArea Identifier | ControlArea Identifier |
"Control Area to Sample Transfer" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Control Area to Sample Transfer" Bound Attachments |
Name | Current Value |
"SMPL.Sample to Sample Transfer" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_smpl_trans_to_sample |
Relationship Business Name | |
Logical Only | No |
Parent Entity | SMPL.Sample |
Child Entity | Sample Transfer |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"SMPL.Sample to Sample Transfer" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"SMPL.Sample to Sample Transfer" Foreign Keys |
Parent Key | Child Key |
Sample Identifier | Sample Identifier |
"SMPL.Sample to Sample Transfer" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"SMPL.Sample to Sample Transfer" Bound Attachments |
Name | Current Value |
"Control Area to Sample Transfer" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | fk_smpl_trans_to_to_ctrl_area |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Control Area |
Child Entity | Sample Transfer |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Control Area to Sample Transfer" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Control Area to Sample Transfer" Foreign Keys |
Parent Key | Child Key |
ControlArea Identifier | To Control Area Identifier |
"Control Area to Sample Transfer" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Control Area to Sample Transfer" Bound Attachments |
Name | Current Value |
"Sample Role to Sample Role Employee Association" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_srea_to_smpl_role |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Sample Role |
Child Entity | Sample Role Employee Association |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Sample Role to Sample Role Employee Association" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Sample Role to Sample Role Employee Association" Foreign Keys |
Parent Key | Child Key |
Role Identifer | Role Identifer |
"Sample Role to Sample Role Employee Association" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Sample Role to Sample Role Employee Association" Bound Attachments |
Name | Current Value |
"Control Area to Sample Role Employee Control Area Association" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_srecaa_to_ctrl_area |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Control Area |
Child Entity | Sample Role Employee Control Area Association |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Control Area to Sample Role Employee Control Area Association" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Control Area to Sample Role Employee Control Area Association" Foreign Keys |
Parent Key | Child Key |
ControlArea Identifier | ControlArea Identifier |
"Control Area to Sample Role Employee Control Area Association" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Control Area to Sample Role Employee Control Area Association" Bound Attachments |
Name | Current Value |
"Sample Role Employee Association to Sample Role Employee Control Area Association" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_srecaa_to_smpl_role_emp_ass |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Sample Role Employee Association |
Child Entity | Sample Role Employee Control Area Association |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Sample Role Employee Association to Sample Role Employee Control Area Association" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Sample Role Employee Association to Sample Role Employee Control Area Association" Foreign Keys |
Parent Key | Child Key |
Role Identifer, Badge Number | Role Identifer, Badge Number |
"Sample Role Employee Association to Sample Role Employee Control Area Association" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Sample Role Employee Association to Sample Role Employee Control Area Association" Bound Attachments |
Name | Current Value |
"SMPL.Sample to Sample Sample Attachment Association" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_ssaa_to_sample |
Relationship Business Name | |
Logical Only | No |
Parent Entity | SMPL.Sample |
Child Entity | Sample Sample Attachment Association |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"SMPL.Sample to Sample Sample Attachment Association" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"SMPL.Sample to Sample Sample Attachment Association" Foreign Keys |
Parent Key | Child Key |
Sample Identifier | Sample Identifier |
"SMPL.Sample to Sample Sample Attachment Association" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"SMPL.Sample to Sample Sample Attachment Association" Bound Attachments |
Name | Current Value |
"SMPL.Sample to Sample Sample Form Association" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_ssfa_to_smpl |
Relationship Business Name | |
Logical Only | No |
Parent Entity | SMPL.Sample |
Child Entity | Sample Sample Form Association |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"SMPL.Sample to Sample Sample Form Association" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"SMPL.Sample to Sample Sample Form Association" Foreign Keys |
Parent Key | Child Key |
Sample Identifier | Sample Identifier |
"SMPL.Sample to Sample Sample Form Association" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"SMPL.Sample to Sample Sample Form Association" Bound Attachments |
Name | Current Value |
"Sample Form to Sample Sample Form Association" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_ssfa_to_smpl_form |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Sample Form |
Child Entity | Sample Sample Form Association |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Sample Form to Sample Sample Form Association" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Sample Form to Sample Sample Form Association" Foreign Keys |
Parent Key | Child Key |
Sample Form Identifier | Sample Form Identifier |
"Sample Form to Sample Sample Form Association" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Sample Form to Sample Sample Form Association" Bound Attachments |
Name | Current Value |
"SMPL.Sample to Sample Special Requirement Association" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_ssra_to_sample |
Relationship Business Name | |
Logical Only | No |
Parent Entity | SMPL.Sample |
Child Entity | Sample Special Requirement Association |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"SMPL.Sample to Sample Special Requirement Association" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"SMPL.Sample to Sample Special Requirement Association" Foreign Keys |
Parent Key | Child Key |
Sample Identifier | Sample Identifier |
"SMPL.Sample to Sample Special Requirement Association" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"SMPL.Sample to Sample Special Requirement Association" Bound Attachments |
Name | Current Value |
"Sample Special Requirement to Sample Special Requirement Association" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_ssra_to_smpl_spec_req |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Sample Special Requirement |
Child Entity | Sample Special Requirement Association |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Sample Special Requirement to Sample Special Requirement Association" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Sample Special Requirement to Sample Special Requirement Association" Foreign Keys |
Parent Key | Child Key |
Requirement Identifier | Requirement Identifier |
"Sample Special Requirement to Sample Special Requirement Association" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Sample Special Requirement to Sample Special Requirement Association" Bound Attachments |
Name | Current Value |
"Sample Attachment to Sample Shipment Sample Attachment Association" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_SSSAA_TO_SMPL_ATTACH |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Sample Attachment |
Child Entity | Sample Shipment Sample Attachment Association |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Sample Attachment to Sample Shipment Sample Attachment Association" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Sample Attachment to Sample Shipment Sample Attachment Association" Foreign Keys |
Parent Key | Child Key |
Attachment Identifier | Attachment Identifier |
"Sample Attachment to Sample Shipment Sample Attachment Association" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Sample Attachment to Sample Shipment Sample Attachment Association" Bound Attachments |
Name | Current Value |
"Sample Shipment to Sample Shipment Sample Attachment Association" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_SSSAA_TO_SMPL_SHIP |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Sample Shipment |
Child Entity | Sample Shipment Sample Attachment Association |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Sample Shipment to Sample Shipment Sample Attachment Association" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Sample Shipment to Sample Shipment Sample Attachment Association" Foreign Keys |
Parent Key | Child Key |
Sample Shipment Identifier | Sample Shipment Identifier |
"Sample Shipment to Sample Shipment Sample Attachment Association" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Sample Shipment to Sample Shipment Sample Attachment Association" Bound Attachments |
Name | Current Value |
"Control Area Subarea to Sample Transfer" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | FK_TO_SMPL_TRANS_TO_CA_SUB |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Control Area Subarea |
Child Entity | Sample Transfer |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Control Area Subarea to Sample Transfer" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Control Area Subarea to Sample Transfer" Foreign Keys |
Parent Key | Child Key |
ControlArea Identifier, SubArea Identifier | ControlArea Identifier, To Subarea Identifier |
"Control Area Subarea to Sample Transfer" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Control Area Subarea to Sample Transfer" Bound Attachments |
Name | Current Value |
"XF_ADMIN.Employee to User Profile" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | fk_user_profile_run_as_to_emp |
Relationship Business Name | |
Logical Only | No |
Parent Entity | XF_ADMIN.Employee |
Child Entity | User Profile |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
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 | Run As 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.Employee to User Profile" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_user_profile_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 |