chart_variables

Data license: CC-BY

2 rows where chartId = 2833

✎ View and edit SQL

This data as json, CSV (advanced)

Link chartId variableId
2833,123 Time spent in study per day 2833 Countries Continents 123
2833,97626 Time spent in study per day 2833 Time spent in study (Eurostat) 97626

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
            );