chart_variables

Data license: CC-BY

2 rows where chartId = 4620

✎ View and edit SQL

This data as json, CSV (advanced)

Link chartId variableId
4620,123 Time spent doing sports 4620 Countries Continents 123
4620,145197 Time spent doing sports 4620 Total average time spent on sports and physical activity per day 145197

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