Skip to content

Latest commit

 

History

History
24 lines (18 loc) · 1.14 KB

table_chemicals_datasets.md

File metadata and controls

24 lines (18 loc) · 1.14 KB

Table: chemicals_datasets

Description: A join table to link chemicals (samples of a chemical substance) and datasets via the Component element.

'Component' section in the ThermoML Schema

ThermoML Schema

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

ThermoML Example

MySQL 'chemicals_datasets' table structure

MySQL Structure

MySQL Fields

  • id: chemicals_datasets primary key (auto-generated and unique)
  • chemical_id: foreign key (chemicals table) linking to a chemical that is part of a dataset
  • dataset_id: foreign key (datasets table) linking a dataset to a chemical it uses
  • updated: datetime last updated

Comments

This table is a convenience table and not absolutely necessary. Formally, the link between chemicals and datasets is:

  • datasets are linked to systems
  • systems are joined to substances through substances_systems
  • substances are linked by chemicals