Single value concentrations data formats¶
Single value concentrations data provides a single value concentration for a substance.
Single value concentration data¶
Concentration single values¶
The food codes (idFood) and substance codes (idSubstance) should match the codes of the foods and substances table respectively.
Table aliases: ConcentrationSingleValues, SingleValueConcentrations, RawConcentrationSingleValues.
| Name | Type | Description | Aliases | Required |
|---|---|---|---|---|
idFood |
AlphaNumeric(50) |
Code of the food of this concentration single value. |
idFood, FoodId, Food |
Yes |
idSubstance |
AlphaNumeric(50) |
Code of the substance of this concentration single value. |
idSubstance, SubstanceId, Substance, idCompound, CompoundId, Compound |
Yes |
Value |
Numeric |
Concentration single value. |
Value, Concentration, ConcentrationValue |
Yes |
ValueType |
ConcentrationValueTypes | Value type of the concentration value. |
ConcentrationSingleValueType, ConcentrationValueType, SingleValueType, ConcentrationType, ValueType, Type |
Yes |
Percentile |
Numeric |
Percentile. |
Percentile |
No |
ConcentrationUnit |
ConcentrationUnits | The unit of the concentration single value (default mg/kg). |
ConcentrationUnit, Unit |
No |
Reference |
AlphaNumeric(200) |
Reference to the source from which this concentration single value is obtained. |
Reference, References, Source, Sources |
No |