Skip to content

Latest commit

 

History

History
40 lines (34 loc) · 2.43 KB

table_data.md

File metadata and controls

40 lines (34 loc) · 2.43 KB

Table: data

Description: Table of numeric values of experimental data reported in the ThermoML files.

'PropertyValue' section in the ThermoML Schema

ThermoML Schema

Example data of a 'PropertyValue' in the 'PureOrMixtureData' section of a ThermoML file

ThermoML Example

MySQL 'data' table structure

MySQL Structure

MySQL Fields

  • id: data primary key (auto-generated and unique)
  • dataset_id: foreign key (datasets table) of the dataset the dataseries is part of
  • dataseries_id: foreign key (dataseries table) of the dataseries the condition belongs to
  • datapoint_id: foreign key (datapoints table) of the datapoint the condition belongs to
  • quantity_id: foreign key (quantities table) of the quantity measured
  • system_id: foreign key (systems table) of the chemical system under study
  • component_id: foreign key (components table) of the component in the mixture analyzed
  • phase_id: foreign key (phases table) of the phase investigated
  • number: numeric value in scientific format in the format 'e' using +/- for the exponent (as text)
  • significand: value of the significand of the datum value when converted to scientific notation (as text)
  • exponent: magnitude of the exponent of the value when converted to scientific notation (as text)
  • error: the reported uncertainty of the measurement (as text)
  • errortype: the type of uncertainty reported for the measurement (enum)
  • unit_id: foreign key (units table) of the unit of the value
  • accuracy: the number of significant digits in the value
  • exact: boolean field that indicates if the datum is an exact value or not
  • text: the value of the condition in the ThermoML file (as text)
  • issue: temporary field to record if there is an issue with a datapoint during validation
  • updated: datetime last updated

Comments

The dataset_id field was added as a convenience to allow statistics generation. Formally, the link between datasets and data is:

  • data are linked to datapoints or dataseries
  • datapoints are linked to dataseries
  • dataseries are linked to datasets