Populations data formats¶
Populations¶
Populations are primary entities of the data model.
Populations¶
Populations are used to select dietary, nondietary and human monitoring surveys. Optionally, a name and description can be added. Population can be restricted to a certain time period. AgeMin, AgeMax and Gender are optional properties of a population.
Table aliases: Populations, Population, RawPopulations.
| 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 |
No |
|
Location |
AlphaNumeric(50) |
Location. |
No |
|
StartDate |
DateTime |
Starting date |
StartDate |
No |
EndDate |
DateTime |
End date |
EndDate |
No |
AgeMin |
Integer |
Minimum age |
AgeMinimum |
No |
AgeMax |
Integer |
Maximum age |
AgeMaximum |
No |
Gender |
AlphaNumeric(50) |
All levels of gender |
Sex |
No |