Populations data formats¶
Populations are primary entities of the data model.
Populations¶
Populations identify human groups in e.g. dietary, nondietary and human monitoring surveys. Optionally, a name and description can be added. Specify a standard bodyweight (optional) as a descriptor of the average or nominal bodyweight in the population. Use table PopulationIndividualPropertyValues to specify descriptors/properties that characterise the population. These population individual property values will be used to restrict the population to e.g. a certain time period (through specifying a start and end date), age (through specifying a minimum and maximum age) or gender (male or female). In Table IndividualProperties each property used in table PopulationIndividualPropertyValues is described.
Table aliases: Populations, Population.
| Name | Type | Description | Aliases | Required |
|---|---|---|---|---|
idPopulation |
AlphaNumeric(50) |
Unique identification code of the population. |
IdPopulation, PopulationId, Code, Id |
Yes |
Name |
AlphaNumeric(100) |
The name of the population. |
Name, PopulationName |
No |
Description |
AlphaNumeric(200) |
Description of of the population. |
Description |
No |
Location |
AlphaNumeric(50) |
Location. |
Location, Country |
No |
NominalBodyWeight |
Numeric |
Nominal body weight (in kg) of the individuals of this population. |
NominalBodyWeight, BodyWeight |
No |
Individual properties¶
This table is used to describe the properties used in the PopulationIndividualPropertyValues table characterising the population (table Populations) and/or the properties used in the Individuals table characterising an individual. Properties like Age, Gender, Region are describing an individual (PropertyLevel = Individual). Properties like Period (for populations) or Month (sampling date for an individual day) are describing an individual day (PropertyLevel = IndividualDay).
Table aliases: IndividualProperties, IndividualProperty.
| Name | Type | Description | Aliases | Required |
|---|---|---|---|---|
idIndividualProperty |
AlphaNumeric(50) |
The code of the property. |
idIndividualProperty, IndividualPropertyId, IndividualProperty |
Yes |
Name |
AlphaNumeric(100) |
The name of the property. |
Name |
No |
PropertyLevel |
PropertyLevelTypes | The level of the property. This type follows a controlled terminology, with possible values: Individual or IndividualDay. |
PropertyLevel, LevelProperty |
No |
Description |
AlphaNumeric(200) |
Description of the property. |
Description |
No |
Type |
IndividualPropertyTypes | This field specifies the type of the values of this individual property. This type follows a controlled terminology, with possible values: Boolean, Categorical (default), Numeric, Nonnegative, Integer, NonnegativeInteger, Month, Datetime, Gender. |
Type |
No |
Population individual property values¶
This table describes population individual properties, such as Age, Gender, Period, Region or Breastfeeding. Population individual property value are used to restrict the population to e.g. a range of ages, a gender, a certain time period, a geographical location or women giving breast feeding. For numerical properties use MinValue and MaxValue to specify a range. For Gender, Region and Breastfeeding use Value to specify a gender level, a categorical level or a boolean, respectively. For Period, use StartDate and EndDate to specify a time range. In table IndividualProperties each property used in the PopulationIndividualPropertyValues table is described.
Table aliases: PopulationIndividualPropertyValues, PopulationPropertyValues.
| Name | Type | Description | Aliases | Required |
|---|---|---|---|---|
idPopulation |
AlphaNumeric(50) |
The code of the population to which the property is attached. The provided population code should match with a code of the populations table. |
idPopulation, PopulationId, Population, PopulationCode, Code |
Yes |
idIndividualProperty |
AlphaNumeric(50) |
The name or reference of the individual property. |
idIndividualProperty, IndividualPropertyId, IndividualProperty |
Yes |
Value |
AlphaNumeric(50) |
The value of the property. |
Value |
No |
MinValue |
Numeric |
Minimum value of the value of the property. |
MinValue, ValueMin |
No |
MaxValue |
Numeric |
Maximum value of the value of the property. |
MaxValue, ValueMax |
No |
StartDate |
DateTime |
Starting date of the specific time window marking this population. |
StartDate |
No |
EndDate |
DateTime |
End date of the specific time window marking this population. |
EndDate |
No |