Substances data formats¶
Substances¶
Substances are primary entities of the data model. Substance intakes are of main interest in exposure assessments and the effect of intake on human health is of interest in risk assessments. In the substances table, the substance entities and other relevant substance properties that are relevant for the assessment at hand should be defined.
Substances¶
Each substance should have a unique identification code (idSubstance), and optionally, a name and description may be used for a more detailed description of the entity. Additional properties, such as the molecular mass (MolecularMass) and Cramer class (CramerClass) may also be specified. Example: Captan (idSubstance RF-0061-001-PPP) has MolecularMass 300.5922 and CramerClass 3.
Table aliases: Compounds, Compound, Substances, Substance, RawCompounds.
| Name | Type | Description | Aliases | Required |
|---|---|---|---|---|
idSubstance |
AlphaNumeric(50) |
The unique identification code of the substance. This code may be from an existing coding system, such as CAS-codes or Param codes of EFSA, or it may be a used-defined code. |
idSubstance, SubstanceId, Substance, Code, Id, idCompound, CompoundId, Compound |
Yes |
Name |
AlphaNumeric(100) |
The substance name. |
Name, CompoundName, SubstanceName, PesticideName |
No |
Description |
AlphaNumeric(200) |
Substance description. |
Description |
No |
ARFD |
Numeric |
The acute reference dose of the critical effect. Note that this is always specified in mg/kg bw/day (exposure). |
ARFD |
No |
ADI |
Numeric |
The acceptable daily intake. Note that this is always specified in mg/kg bw/person (exposure). |
ADI |
No |
SF |
Numeric |
The safety factor belonging to the ADI/ARFD. |
SF |
No |
CramerClass |
Integer |
The Cramer class of the substance. |
CramerClass |
No |
MolecularMass |
Numeric |
The molecular (molar) mass. |
MolecularMass, Mass, MolarMass, MolecularWeight, MolarWeight |
No |