chart_variables

Data license: CC-BY

1 row where variableId = 848479

✎ View and edit SQL

This data as json, CSV (advanced)

Link chartId variableId
853,848479 Share of dietary energy supply from carbohydrates vs. GDP per capita 853 Share of the daily calorie supply that comes from carbohydrates 848479

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE chart_variables
            (
                `chartId` integer NOT NULL,
                `variableId` integer NOT NULL,
                PRIMARY KEY (`chartId`, `variableId`),
                CONSTRAINT `FK_chart_variables_chartId` FOREIGN KEY (`chartId`) REFERENCES `charts` (`id`) ON DELETE CASCADE,
                CONSTRAINT `FK_chart_variables_variableId` FOREIGN KEY (`variableId`) REFERENCES `variables` (`id`) ON DELETE CASCADE
            );