chart_variables

Data license: CC-BY

2 rows where chartId = 3272

✎ View and edit SQL

This data as json, CSV (advanced)

Link chartId variableId
3272,99405 Annual hours of work and income 3272 Annual hours of work 99405
3272,99406 Annual hours of work and income 3272 GDP per capita 1990 int GK$ 99406

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