DATA MODEL
Model for the indicators on the sustainability performance of food Systems within Europe.
Model diagram
erDiagram
Database {
TimeGranularity update_frequency
string id
label_type name
narrative_text description
narrative_text comment
iri_type iri
iri_type link
ReferenceType reference_type
}
Indicator {
string id
label_type name
narrative_text description
FoodSystemActivityType activity_type
narrative_text definition
FoodDemandActivityType demand_activity_type
FoodSystemDrivingForce driving_force
FoodEnvironmentActivityType environment_activity_type
Eu2025SdgIndicatorList eu2025_sdg_indicator_code
unit measurement_unit_description
IndicatorMeasurementUnitList measurement_units
narrative_text methodology_description
FoodSystemOutcomeType outcome_type
FoodSystemResponsePolicy response_policy
FoodSupplyActivityType supply_activity_type
SupplyChainComponentTypeList supply_chain_component
SustainabilityDimension sustainability_dimension
SustainabilityImpactType sustainability_impact
TransitionDomainList transition_domain_connections
iri_type iri
}
IndicatorCategory {
string id
label_type name
narrative_text description
FoodSystemActivityType activity_type
SustainabilityDimension dimension
FoodSystemDrivingForce driving_force
FoodSystemOutcomeType outcome_type
iri_type iri
}
IndicatorCriterion {
CriterionCategory category
narrative_text rationale_adequate
narrative_text rationale_strong
narrative_text rationale_weak
string id
label_type name
narrative_text description
iri_type iri
}
IndicatorDataCollectionDetails {
iri_type data_link
date_or_datetime newest_datapoint
date_or_datetime oldest_datapoint
SpatialGranularity spatial_granularity
SpatialScopeType spatial_scope
TimeGranularity time_granularity
string id
label_type name
narrative_text description
iri_type iri
}
IndicatorDatapoint {
string id
label_type name
narrative_text description
double has_numeric_value
unit has_unit
iri_type iri
}
IndicatorcriteriaScore {
narrative_text comment
ScoreCategory score
}
Reference {
narrative_text comment
iri_type link
ReferenceType reference_type
string id
label_type name
narrative_text description
iri_type iri
}
Indicator ||--|| IndicatorCategory : "has_category"
IndicatorCategory ||--}o Reference : "referenced_in"
IndicatorDataCollectionDetails ||--|| Database : "in_database"
IndicatorDataCollectionDetails ||--|| Indicator : "measures_indicator"
IndicatorDataCollectionDetails ||--}o Reference : "referenced_in"
IndicatorDatapoint ||--|| Indicator : "measurement_of"
IndicatorDatapoint ||--|| IndicatorDataCollectionDetails : "part_of_collection"
IndicatorcriteriaScore ||--|o Indicator : "score_for_indicator"
IndicatorcriteriaScore ||--|o IndicatorCriterion : "scores_criterion"
Classes
| Name | Description | Type |
|---|---|---|
| Database | A reference to a database. | Class |
| Indicator | A quantitative measure used to assess the state, performance, or progress of a specific aspect of the food system in relation to sustainability objectives. | Class |
| Indicator category | Group of indicators that share common characteristics, functions, or measurement purposes within a monitoring or evaluation framework. | Class |
| Indicator criterion score | A score assigned to an indicator based on a specific selection criterion. | Class |
| Indicator criterion | Criterion used for indicator selection. | Class |
| Indicator data collection details | Details on the collection of indicator data within a certain database/dataset. | Class |
| Indicator datapoint | A food system indicator datapoint is a measured value or statistic that provides quantitative information for a specific sustainability indicator at a given time and place, used to track the performance or state of the food system. | Class |
| Quantity value | A value of an attribute that is quantitative and measurable, expressed as a combination of a unit and a numeric value. | Class |
| Reference | A reference to a publication, database or dataset. | Class |
| Transition domain pillar | Sub-area of a transition domain. | Class |
Enums
| Name | Description | Type |
|---|---|---|
| Criterion category | Category of an indicator selection criterion. | Enum |
| Eu sdg indicators | Indicators of the 2025 edition of the EU sustainable development goals (SDG) monitoring report. | Enum |
| Food demand activity type | Addresses consumer behaviour and consumer characteristics, incl. consumer preferences. Consumer characteristics can refer to attributes such as knowledge, available time, resources (purchasing power), age, sex, culture, religion, etc. | Enum |
| Food environment activity type | Physical, digital and social environment that affects what people eat. | Enum |
| Food supply activity type | Activities across the food value chain, incl. activities from post-harvest and processing to packaging, distribution, and retail. | Enum |
| Food system activity | Food systems encompass activities related to the food supply chains, food environments, and food demand, as well as the use of natural resource, consumption and diets, and waste, by-products and recycling. These ultimately have an effect on food system outcomes. | Enum |
| Food system driving force | Driving forces can be understood as influential forces of changes that are shaping, or that have the capacity to shape or transform, a system. The driving forces stem from the DESTEP, which is an acronym that encompasses the dimensions of demographics, economic, social-cultural, technological, environmental, and political-institutional factors, are often used as a method for identification of driving forces and trends. | Enum |
| Food system outcome | Food system outcomes, being impact related to environment, economic, social and health, are a result of food systems. This framework distinguishes five different type of food system impacts: environmental, economic, social, health, and the overarching food security and resilience. | Enum |
| Food system response/policy | Governance structures and policies addressing, among others, the power of multinationals and consumers. It includes policy measures focused on adaptation, innovation, research, and transformation, which are supported by governance structures that provide the framework to implement changes. Areas such as public procurement are also relevant. | Enum |
| Eurostat unit of measurement | Food system indicator units of measurement imported from the Eurostat unit of measure dictionary/vocabulary. | Enum |
| Reference types | The type of source that a reference refers to. | Enum |
| Score category | Score category. | Enum |
| Spatial granularity | The granularity for which the indicator is measured. | Enum |
| Spatial scope type | The spatial scope for which the indicator is defined. | Enum |
| Supply chain component type | The supply chain component for which the indicator is relevant. | Enum |
| Sustainability dimension | A dimension of sustainability to which the indicator relates. | Enum |
| Sustainability impact type | The type of sustainability impact the indicator measures. | Enum |
| Time granularity | Time granularity for measuring and updating data. | Enum |
| Transition domain | Transition domains represent key thematic areas for research and innovation (R&I) to drive systemic change towards sustainable food systems. | Enum |