Skip to content

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 FoodSystemActivityType driving_force Eu2025SdgIndicatorList eu2025_sdg_indicator_code unit measurement_unit_description IndicatorMeasurementUnitList measurement_units narrative_text methodology_description FoodSystemOutcomeType outcome_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 FoodSystemActivityType 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 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
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