chart_variables

Data license: CC-BY

1 row where variableId = 686710

✎ View and edit SQL

This data as json, CSV (advanced)

Link chartId variableId
6661,686710 Number of countries with underlying data on the prevalence of mental illnesses 6661 Number of countries with primary data on prevalence of mental disorders 686710

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