Waters Empower Table Structure and Relationships
This page describes the Waters Empower Table structure. Understanding the structure of the IDS Entity Relationship diagrams may help you determine:
- What data to query
- How to structure your SQL queries
This diagram shows the Empower entity relationship:
Empower entity relationship
Tables
This table describes the Water Empower tables. For more details, you can search the table and view its table definition.
| Table Name | Description |
|---|---|
| lcuv_empower_v5_injection | This is the root table. It provides basic information about each injection including: assigned name, description of the injection, and the dimension, measure, and project names. |
| lcuv_empower_v5_injection_custom_fields | Provides information about each injection, including a key value (such as: Storage Conditions, Stability Point, Analysis Number, or Batch Number. The value, data type, any numerical or boolean values, and project information is also included. |
| lcuv_empower_v5_method_instrument_columns | Provides information on the serial number, name, injection and sample counts, maximum pressure values and units, maximum temperature value and unit, ecord serial number name, and project name. |
| lcuv_empower_v5_results | Contains information on ID, time, set information, and sample information (for example: name, weight value and unit, sample type, dilution, and more. |
| lcuv_empower_v5_results_peaks | Contains information about the number, analyte, height area and retention time values and units, resolution, USP tailing and resolution, signal to noise ratio, K-prime, amount value and unit, area percentage, integration value, code, retention time and start time values, and more. |
| lcuv_empower_v5_results_peaks_custom_fields | Provides information about result peak values, organized by key and value. |
| lcuv_empower_v5_results_custom_fields | Provides information about result organized by key and value. |
| lcuv_empower_v5_results_sign_offs | Provides information on who completed the signoff, the level, date, method information, reason, type, project, and result ID information. |
| lcuv_empower_v5_method_instrument_setups | Provides details, instrument status, and other instrument setting information such as the flow_unit, pump mode, and degas mode. |
| lcuv_empower_v5_sample_set_custom_fields | (see other custom field description). |
| lcuv_empower_v5_sample_set_method_custom_fields | Provides information about sample set methods, organized by key and value. |
| lcuv_empower_v5_method_processing _parameter_integration_custom_fields | Provides information about parameter integration, organized by key and value. |
| lcuv_empower_v5_method_processing _parameter_system_suitability_custom_fields | Provides information about parameter system suitability information, organized by key and value. |
| lcuv_empower_v5_method_processing | Contains parameter information such as the name of the parameter, the system suitability information and algorithmic information. |
| lcuv_empower_v5_datacubes | Provides dimensional and measure information for datacubes. |
| lcuv_empower_v5_datacubes_data | Provides data for the datacubes' measures and dimensions. |
Columns
For more details about table columns, click here.
Updated 4 months ago