chart_variables

Data license: CC-BY

1 row where variableId = 699972

✎ View and edit SQL

This data as json, CSV (advanced)

Link chartId variableId
6806,699972 Employment in food and beverage serving activities per 1,000 people 6806 Employment (food and beverage serving activities) per 1000 people 699972

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