chart_variables

Data license: CC-BY

2 rows where chartId = 2834

✎ View and edit SQL

This data as json, CSV (advanced)

Link chartId variableId
2834,123 Participation time in study per day 2834 Countries Continents 123
2834,97632 Participation time in study per day 2834 Participation time in study (Eurostat) 97632

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