Skip to content

Latest commit

 

History

History
30 lines (24 loc) · 1.57 KB

table_sampleprops.md

File metadata and controls

30 lines (24 loc) · 1.57 KB
Raw

Table: sampleprops

Description: This table captures the instances of the quantities that were measured (of the sample) in the experiment.

'Property' section in the ThermoML Schema

ThermoML Schema

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

ThermoML Example

MySQL 'sampleprops' table structure

MySQL Structure

MySQL Fields

  • id: components primary key (auto-generated and unique)
  • dataset_id: foreign key (datasets table) of the dataset the sampleprop is part of
  • propnum: the value of the nPropNumber field in a ThermoML file
  • orgnum: the id of the substance in a ThermoML file
  • quantity_group: the group the quantity is part of as reported in a ThermoML file
  • quantity_name: the name (with unit) of the quantity measured reported in a ThermoML file
  • quantity_id: foreign key (quantities table) of the quantity measured
  • unit_id: foreign key (units table) of the unit indicated in the ThermoML quantity name
  • method_name:
  • uncnum: the <nCombUncertAssessNum> field from a ThermoML file
  • unceval: the <nCombUncertEvalMethod> field from a ThermoML file
  • uncconf: the <nCombUncertLevOfConf> field from a ThermoML file
  • uncchk: a temporary field used to validate the data in the last three fields is correct.
  • updated: datetime last updated

Comments