Understanding the structure of the IDS Entity Relationship diagrams can help you determine what data to query and how to structure your SQL queries. This topic addresses the Waters Empower Table structure.
The Empower entity relationship diagram is shown below.
The following provides a description of the Water Empower tables.
For more detailed information, you can search the table and view the table definition.
|lcuv_empower_v5_injection||This is the root table, which provides basic information about each injection including the assigned name, and a description of the injection as well as 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 the project name.|
|lcuv_empower_v5_results||Contains information on ID, time, set information, and sample information (e.g. 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 as well as 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.|
|Provides information about parameter integration, organized by key and value..|
|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 datacube's measures and dimensions.|
If you need to find more specific information on table columns, see this topic.
Updated 7 months ago