DATA MODEL
Model for the indicators on the sustainability performance of food Systems within Europe.
Model diagram
erDiagram
Database {
iri_type database_link
TimeGranularity update_frequency
string id
iri_type iri
label_type name
narrative_text description
}
Indicator {
string id
label_type name
narrative_text description
narrative_text definition
FoodSystemActivityType activity_type
FoodSystemOutcomeType outcome_type
SupplyChainComponentTypeList supply_chain_component
unit measurement_unit_description
IndicatorMeasurementUnitList measurement_units
SustainabilityImpactType sustainability_impact
Eu2025SdgIndicatorList eu2025_sdg_indicator_code
iri_type iri
}
IndicatorCategory {
string id
label_type name
narrative_text description
SustainabilityDimension dimension
iri_type iri
}
IndicatorCriterion {
CriterionCategory category
string id
iri_type iri
label_type name
narrative_text description
}
IndicatorDataCollectionDetails {
string id
label_type name
narrative_text description
date_or_datetime oldest_datapoint
date_or_datetime newest_datapoint
TimeGranularity time_granularity
SpatialScopeType spatial_scope
SpatialGranularity spatial_granularity
iri_type data_link
iri_type iri
}
IndicatorDatapoint {
unit has_unit
double has_numeric_value
string id
iri_type iri
label_type name
narrative_text description
}
IndicatorcriteriaScore {
ScoreCategory score
narrative_text comment
}
Indicator ||--|| IndicatorCategory : "has_category"
IndicatorDataCollectionDetails ||--|| Database : "in_database"
IndicatorDataCollectionDetails ||--|| Indicator : "measures_indicator"
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 | Database containing data corresponding to an indicator. | 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 | The category the indicator belongs to. | Class |
| Indicator criterion score | Score for an indicator for an indicator 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 |
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 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 |
| 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 | TODO | Enum |
| Sustainability impact type | The type of sustainability impact the indicator measures. | Enum |
| Time granularity | Time granularity for measuring and updating data. | Enum |