variables

This table contains all the variables of all the datasets we have at Our World In Data. Note that this includes only the information about the variables like name and default display settings, not the data itself.

Data license: CC-BY

12 rows where datasetId = 6585 sorted by id descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: unit, createdAt, updatedAt, timespan, shortUnit, titlePublic, descriptionShort, descriptionKey, createdAt (date), updatedAt (date), descriptionKey (array)

id ▲ name unit description createdAt updatedAt code coverage timespan datasetId sourceId shortUnit display columnOrder originalMetadata grapherConfigAdmin shortName catalogPath dimensions schemaVersion processingLevel processingLog titlePublic titleVariant attributionShort attribution descriptionShort descriptionFromProducer descriptionKey descriptionProcessing licenses license grapherConfigETL type sort dataChecksum metadataChecksum
943835 Gas production per capita (kWh) kilowatt-hours   2024-06-25 14:50:27 2024-07-25 23:09:02     1900-2023 Fossil fuel production 6585   kWh 
{
    "name": "Gas",
    "unit": "kilowatt-hours",
    "shortUnit": "kWh",
    "numDecimalPlaces": 0
}
 0     gas_production_per_capita__kwh grapher/energy/2024-06-20/fossil_fuel_production/fossil_fuel_production#gas_production_per_capita__kwh   2 major   Gas production per capita       Measured in kilowatt-hours per capita.   
[]
 - The data is generated by combining the latest data from [the Energy Institute Statistical Review of World Energy](https://www.energyinst.org/statistical-review) and [The Shift Dataportal](https://www.theshiftdataportal.org/energy). The Energy Institute provides fossil fuel production data from 1965 onwards (and crude prices from 1861 onwards). The Shift Dataportal provides long-term data from 1900, but only extends to 2016. To maintain consistency with other energy data, we prioritize the Energy Institute data - meaning if they provide data for the given country and year, this data is used. Where data is not available from the Energy Institute for a given country, or pre-1965 we rely on data from The Shift Dataportal. - We have converted primary production in exajoules to terawatt-hours using the conversion factor: 1,000,000 / 3,600 ~ 278. - Production per capita has been calculated by dividing by our population dataset, based on [different sources](https://ourworldindata.org/population-sources). 
[
    {
        "url": "https://docs.google.com/document/d/1-RmthhS2EPMK_HIpnPctcXpB0n7ADSWnXa5Hb3PxNq4/edit?usp=sharing",
        "name": "Creative Commons BY 4.0"
    },
    {
        "url": "https://dataportaal.pbl.nl/downloads/HYDE/HYDE3.2/readme_release_HYDE3.2.1.txt",
        "name": "CC BY 3.0"
    },
    {
        "url": "http://creativecommons.org/licenses/by/3.0/igo/",
        "name": "CC BY 3.0 IGO"
    }
]
     float 
[]
 85f0c2b739f23c634377658dbb70728b 21bd53826bf9baf33908a07fac061561
943833 Coal production per capita (kWh) kilowatt-hours   2024-06-25 14:50:27 2024-07-25 23:09:02     1900-2023 Fossil fuel production 6585   kWh 
{
    "name": "Coal",
    "unit": "kilowatt-hours",
    "shortUnit": "kWh",
    "numDecimalPlaces": 0
}
 0     coal_production_per_capita__kwh grapher/energy/2024-06-20/fossil_fuel_production/fossil_fuel_production#coal_production_per_capita__kwh   2 major   Coal production per capita       Measured in kilowatt-hours per capita.   
[
    "Includes commercial solid fuels only, i.e. bituminous coal and anthracite (hard coal), and lignite and brown (sub-bituminous) coal, and other commercial solid fuels. Includes coal produced for Coal-to-Liquids and Coal-to-Gas transformations."
]
 - The data is generated by combining the latest data from [the Energy Institute Statistical Review of World Energy](https://www.energyinst.org/statistical-review) and [The Shift Dataportal](https://www.theshiftdataportal.org/energy). The Energy Institute provides fossil fuel production data from 1965 onwards (and crude prices from 1861 onwards). The Shift Dataportal provides long-term data from 1900, but only extends to 2016. To maintain consistency with other energy data, we prioritize the Energy Institute data - meaning if they provide data for the given country and year, this data is used. Where data is not available from the Energy Institute for a given country, or pre-1965 we rely on data from The Shift Dataportal. - We have converted primary production in exajoules to terawatt-hours using the conversion factor: 1,000,000 / 3,600 ~ 278. - Production per capita has been calculated by dividing by our population dataset, based on [different sources](https://ourworldindata.org/population-sources). 
[
    {
        "url": "https://docs.google.com/document/d/1-RmthhS2EPMK_HIpnPctcXpB0n7ADSWnXa5Hb3PxNq4/edit?usp=sharing",
        "name": "Creative Commons BY 4.0"
    },
    {
        "url": "https://dataportaal.pbl.nl/downloads/HYDE/HYDE3.2/readme_release_HYDE3.2.1.txt",
        "name": "CC BY 3.0"
    },
    {
        "url": "http://creativecommons.org/licenses/by/3.0/igo/",
        "name": "CC BY 3.0 IGO"
    }
]
     float 
[]
 49b699570b7510c6aa461f927ade50b9 cdf6e9104aadf37a113f671f84704266
943824 Oil production per capita (kWh) kilowatt-hours   2024-06-25 14:50:26 2024-07-25 23:09:02     1900-2023 Fossil fuel production 6585   kWh 
{
    "name": "Oil",
    "unit": "kilowatt-hours",
    "shortUnit": "kWh",
    "numDecimalPlaces": 0
}
 0     oil_production_per_capita__kwh grapher/energy/2024-06-20/fossil_fuel_production/fossil_fuel_production#oil_production_per_capita__kwh   2 major   Oil production per capita       Measured in kilowatt-hours per capita.   
[
    "Includes crude oil, shale oil, oil sands, condensates (lease condensate or gas condensates that require further refining) and NGLs (natural gas liquids - ethane, LPG and naphtha separated from the production of natural gas). Excludes liquid fuels from other sources such as biofuels and synthetic derivatives of coal and natural gas. This also excludes liquid fuel adjustment factors such as refinery processing gain. Excludes oil shales/kerogen extracted in solid form."
]
 - The data is generated by combining the latest data from [the Energy Institute Statistical Review of World Energy](https://www.energyinst.org/statistical-review) and [The Shift Dataportal](https://www.theshiftdataportal.org/energy). The Energy Institute provides fossil fuel production data from 1965 onwards (and crude prices from 1861 onwards). The Shift Dataportal provides long-term data from 1900, but only extends to 2016. To maintain consistency with other energy data, we prioritize the Energy Institute data - meaning if they provide data for the given country and year, this data is used. Where data is not available from the Energy Institute for a given country, or pre-1965 we rely on data from The Shift Dataportal. - We have converted primary production in exajoules to terawatt-hours using the conversion factor: 1,000,000 / 3,600 ~ 278. - Production per capita has been calculated by dividing by our population dataset, based on [different sources](https://ourworldindata.org/population-sources). 
[
    {
        "url": "https://docs.google.com/document/d/1-RmthhS2EPMK_HIpnPctcXpB0n7ADSWnXa5Hb3PxNq4/edit?usp=sharing",
        "name": "Creative Commons BY 4.0"
    },
    {
        "url": "https://dataportaal.pbl.nl/downloads/HYDE/HYDE3.2/readme_release_HYDE3.2.1.txt",
        "name": "CC BY 3.0"
    },
    {
        "url": "http://creativecommons.org/licenses/by/3.0/igo/",
        "name": "CC BY 3.0 IGO"
    }
]
     float 
[]
 6ba01f126d9f71db879e04b4e574f35d 7d17e293b96dc2e5a9ade4411f5cec2a
943819 Annual change in gas production (TWh) terawatt-hours   2024-06-25 14:50:26 2024-07-25 23:09:02     1901-2023 Fossil fuel production 6585   TWh 
{
    "name": "Gas",
    "unit": "terawatt-hours",
    "shortUnit": "TWh"
}
 0     annual_change_in_gas_production__twh grapher/energy/2024-06-20/fossil_fuel_production/fossil_fuel_production#annual_change_in_gas_production__twh   2 major   Annual change in gas production       Measured in terawatt-hours.   
[]
 - The data is generated by combining the latest data from [the Energy Institute Statistical Review of World Energy](https://www.energyinst.org/statistical-review) and [The Shift Dataportal](https://www.theshiftdataportal.org/energy). The Energy Institute provides fossil fuel production data from 1965 onwards (and crude prices from 1861 onwards). The Shift Dataportal provides long-term data from 1900, but only extends to 2016. To maintain consistency with other energy data, we prioritize the Energy Institute data - meaning if they provide data for the given country and year, this data is used. Where data is not available from the Energy Institute for a given country, or pre-1965 we rely on data from The Shift Dataportal. - We have converted primary production in exajoules to terawatt-hours using the conversion factor: 1,000,000 / 3,600 ~ 278. - Production per capita has been calculated by dividing by our population dataset, based on [different sources](https://ourworldindata.org/population-sources).       float 
[]
 656397c08ebcf04e91315c5045e06eb6 0671f938a6cf05dbaddecb75fa8a8b14
943816 Annual change in gas production (%) %   2024-06-25 14:50:26 2024-07-25 23:09:02     1901-2023 Fossil fuel production 6585   % 
{
    "name": "Gas",
    "unit": "%",
    "shortUnit": "%"
}
 0     annual_change_in_gas_production__pct grapher/energy/2024-06-20/fossil_fuel_production/fossil_fuel_production#annual_change_in_gas_production__pct   2 major   Annual change in gas production       Measured as a percentage of the previous year's production.   
[]
 - The data is generated by combining the latest data from [the Energy Institute Statistical Review of World Energy](https://www.energyinst.org/statistical-review) and [The Shift Dataportal](https://www.theshiftdataportal.org/energy). The Energy Institute provides fossil fuel production data from 1965 onwards (and crude prices from 1861 onwards). The Shift Dataportal provides long-term data from 1900, but only extends to 2016. To maintain consistency with other energy data, we prioritize the Energy Institute data - meaning if they provide data for the given country and year, this data is used. Where data is not available from the Energy Institute for a given country, or pre-1965 we rely on data from The Shift Dataportal. - We have converted primary production in exajoules to terawatt-hours using the conversion factor: 1,000,000 / 3,600 ~ 278. - Production per capita has been calculated by dividing by our population dataset, based on [different sources](https://ourworldindata.org/population-sources).       float 
[]
 05e6992fbcb610f5d7a97089e2a63a3d 63f0b6d97c535f14923624ad62129e8d
943809 Annual change in oil production (TWh) terawatt-hours   2024-06-25 14:50:25 2024-07-25 23:09:02     1901-2023 Fossil fuel production 6585   TWh 
{
    "name": "Oil",
    "unit": "terawatt-hours",
    "shortUnit": "TWh"
}
 0     annual_change_in_oil_production__twh grapher/energy/2024-06-20/fossil_fuel_production/fossil_fuel_production#annual_change_in_oil_production__twh   2 major   Annual change in oil production       Measured in terawatt-hours.   
[
    "Includes crude oil, shale oil, oil sands, condensates (lease condensate or gas condensates that require further refining) and NGLs (natural gas liquids - ethane, LPG and naphtha separated from the production of natural gas). Excludes liquid fuels from other sources such as biofuels and synthetic derivatives of coal and natural gas. This also excludes liquid fuel adjustment factors such as refinery processing gain. Excludes oil shales/kerogen extracted in solid form."
]
 - The data is generated by combining the latest data from [the Energy Institute Statistical Review of World Energy](https://www.energyinst.org/statistical-review) and [The Shift Dataportal](https://www.theshiftdataportal.org/energy). The Energy Institute provides fossil fuel production data from 1965 onwards (and crude prices from 1861 onwards). The Shift Dataportal provides long-term data from 1900, but only extends to 2016. To maintain consistency with other energy data, we prioritize the Energy Institute data - meaning if they provide data for the given country and year, this data is used. Where data is not available from the Energy Institute for a given country, or pre-1965 we rely on data from The Shift Dataportal. - We have converted primary production in exajoules to terawatt-hours using the conversion factor: 1,000,000 / 3,600 ~ 278. - Production per capita has been calculated by dividing by our population dataset, based on [different sources](https://ourworldindata.org/population-sources).       float 
[]
 5650756eb91b7a7f7ae80d30245fae89 b9f24e26844ebc1be08ae93064626fcd
943808 Annual change in oil production (%) %   2024-06-25 14:50:25 2024-07-25 23:09:02     1901-2023 Fossil fuel production 6585   % 
{
    "name": "Oil",
    "unit": "%",
    "shortUnit": "%"
}
 0     annual_change_in_oil_production__pct grapher/energy/2024-06-20/fossil_fuel_production/fossil_fuel_production#annual_change_in_oil_production__pct   2 major   Annual change in oil production       Measured as a percentage of the previous year's production.   
[
    "Includes crude oil, shale oil, oil sands, condensates (lease condensate or gas condensates that require further refining) and NGLs (natural gas liquids - ethane, LPG and naphtha separated from the production of natural gas). Excludes liquid fuels from other sources such as biofuels and synthetic derivatives of coal and natural gas. This also excludes liquid fuel adjustment factors such as refinery processing gain. Excludes oil shales/kerogen extracted in solid form."
]
 - The data is generated by combining the latest data from [the Energy Institute Statistical Review of World Energy](https://www.energyinst.org/statistical-review) and [The Shift Dataportal](https://www.theshiftdataportal.org/energy). The Energy Institute provides fossil fuel production data from 1965 onwards (and crude prices from 1861 onwards). The Shift Dataportal provides long-term data from 1900, but only extends to 2016. To maintain consistency with other energy data, we prioritize the Energy Institute data - meaning if they provide data for the given country and year, this data is used. Where data is not available from the Energy Institute for a given country, or pre-1965 we rely on data from The Shift Dataportal. - We have converted primary production in exajoules to terawatt-hours using the conversion factor: 1,000,000 / 3,600 ~ 278. - Production per capita has been calculated by dividing by our population dataset, based on [different sources](https://ourworldindata.org/population-sources).       float 
[]
 d57e5b858fbf7765c74ce2160e297d52 5ad42b264b2e221b87bbe5e6d569dff5
943807 Annual change in coal production (TWh) terawatt-hours   2024-06-25 14:50:25 2024-07-25 23:09:02     1901-2023 Fossil fuel production 6585   TWh 
{
    "name": "Coal",
    "unit": "terawatt-hours",
    "shortUnit": "TWh"
}
 0     annual_change_in_coal_production__twh grapher/energy/2024-06-20/fossil_fuel_production/fossil_fuel_production#annual_change_in_coal_production__twh   2 major   Annual change in coal production       Measured in terawatt-hours.   
[
    "Includes commercial solid fuels only, i.e. bituminous coal and anthracite (hard coal), and lignite and brown (sub-bituminous) coal, and other commercial solid fuels. Includes coal produced for Coal-to-Liquids and Coal-to-Gas transformations."
]
 - The data is generated by combining the latest data from [the Energy Institute Statistical Review of World Energy](https://www.energyinst.org/statistical-review) and [The Shift Dataportal](https://www.theshiftdataportal.org/energy). The Energy Institute provides fossil fuel production data from 1965 onwards (and crude prices from 1861 onwards). The Shift Dataportal provides long-term data from 1900, but only extends to 2016. To maintain consistency with other energy data, we prioritize the Energy Institute data - meaning if they provide data for the given country and year, this data is used. Where data is not available from the Energy Institute for a given country, or pre-1965 we rely on data from The Shift Dataportal. - We have converted primary production in exajoules to terawatt-hours using the conversion factor: 1,000,000 / 3,600 ~ 278. - Production per capita has been calculated by dividing by our population dataset, based on [different sources](https://ourworldindata.org/population-sources).       float 
[]
 dbb3eddc13216ac4ee982a96c17f3ef2 43fa7d4e96db40fad6157227d41872a3
943806 Annual change in coal production (%) %   2024-06-25 14:50:25 2024-07-25 23:09:02     1901-2023 Fossil fuel production 6585   % 
{
    "name": "Coal",
    "unit": "%",
    "shortUnit": "%"
}
 0     annual_change_in_coal_production__pct grapher/energy/2024-06-20/fossil_fuel_production/fossil_fuel_production#annual_change_in_coal_production__pct   2 major   Annual change in coal production       Measured as a percentage of the previous year's production.   
[
    "Includes commercial solid fuels only, i.e. bituminous coal and anthracite (hard coal), and lignite and brown (sub-bituminous) coal, and other commercial solid fuels. Includes coal produced for Coal-to-Liquids and Coal-to-Gas transformations."
]
 - The data is generated by combining the latest data from [the Energy Institute Statistical Review of World Energy](https://www.energyinst.org/statistical-review) and [The Shift Dataportal](https://www.theshiftdataportal.org/energy). The Energy Institute provides fossil fuel production data from 1965 onwards (and crude prices from 1861 onwards). The Shift Dataportal provides long-term data from 1900, but only extends to 2016. To maintain consistency with other energy data, we prioritize the Energy Institute data - meaning if they provide data for the given country and year, this data is used. Where data is not available from the Energy Institute for a given country, or pre-1965 we rely on data from The Shift Dataportal. - We have converted primary production in exajoules to terawatt-hours using the conversion factor: 1,000,000 / 3,600 ~ 278. - Production per capita has been calculated by dividing by our population dataset, based on [different sources](https://ourworldindata.org/population-sources).       float 
[]
 3a3a237f75c28bd2694d8beeff90c6b5 d7aeeec61e7fe2ae4ab0c3849de8735f
943805 Oil production (TWh) terawatt-hours   2024-06-25 14:50:25 2024-07-25 23:09:02     1900-2023 Fossil fuel production 6585   TWh 
{
    "name": "Oil",
    "unit": "terawatt-hours",
    "shortUnit": "TWh",
    "numDecimalPlaces": 0
}
 0     oil_production__twh grapher/energy/2024-06-20/fossil_fuel_production/fossil_fuel_production#oil_production__twh   2 major   Oil production       Measured in terawatt-hours.   
[
    "Includes crude oil, shale oil, oil sands, condensates (lease condensate or gas condensates that require further refining) and NGLs (natural gas liquids - ethane, LPG and naphtha separated from the production of natural gas). Excludes liquid fuels from other sources such as biofuels and synthetic derivatives of coal and natural gas. This also excludes liquid fuel adjustment factors such as refinery processing gain. Excludes oil shales/kerogen extracted in solid form."
]
 - The data is generated by combining the latest data from [the Energy Institute Statistical Review of World Energy](https://www.energyinst.org/statistical-review) and [The Shift Dataportal](https://www.theshiftdataportal.org/energy). The Energy Institute provides fossil fuel production data from 1965 onwards (and crude prices from 1861 onwards). The Shift Dataportal provides long-term data from 1900, but only extends to 2016. To maintain consistency with other energy data, we prioritize the Energy Institute data - meaning if they provide data for the given country and year, this data is used. Where data is not available from the Energy Institute for a given country, or pre-1965 we rely on data from The Shift Dataportal. - We have converted primary production in exajoules to terawatt-hours using the conversion factor: 1,000,000 / 3,600 ~ 278. - Production per capita has been calculated by dividing by our population dataset, based on [different sources](https://ourworldindata.org/population-sources).       float 
[]
 68028b99e50afe6a1b23cdadccbbf169 710014d3bd18ee9cd6f3326ae80607fc
943804 Gas production (TWh) terawatt-hours   2024-06-25 14:50:25 2024-07-25 23:09:01     1900-2023 Fossil fuel production 6585   TWh 
{
    "name": "Gas",
    "unit": "terawatt-hours",
    "shortUnit": "TWh",
    "numDecimalPlaces": 0
}
 0     gas_production__twh grapher/energy/2024-06-20/fossil_fuel_production/fossil_fuel_production#gas_production__twh   2 major   Gas production       Measured in terawatt-hours.   
[]
 - The data is generated by combining the latest data from [the Energy Institute Statistical Review of World Energy](https://www.energyinst.org/statistical-review) and [The Shift Dataportal](https://www.theshiftdataportal.org/energy). The Energy Institute provides fossil fuel production data from 1965 onwards (and crude prices from 1861 onwards). The Shift Dataportal provides long-term data from 1900, but only extends to 2016. To maintain consistency with other energy data, we prioritize the Energy Institute data - meaning if they provide data for the given country and year, this data is used. Where data is not available from the Energy Institute for a given country, or pre-1965 we rely on data from The Shift Dataportal. - We have converted primary production in exajoules to terawatt-hours using the conversion factor: 1,000,000 / 3,600 ~ 278. - Production per capita has been calculated by dividing by our population dataset, based on [different sources](https://ourworldindata.org/population-sources).       float 
[]
 60b06bdcdaf23715cb36575307ff752a 21366a686d72c5a9f02a9c80311f7542
943803 Coal production (TWh) terawatt-hours   2024-06-25 14:50:24 2024-07-25 23:09:01     1900-2023 Fossil fuel production 6585   TWh 
{
    "name": "Coal",
    "unit": "terawatt-hours",
    "shortUnit": "TWh",
    "numDecimalPlaces": 0
}
 0     coal_production__twh grapher/energy/2024-06-20/fossil_fuel_production/fossil_fuel_production#coal_production__twh   2 major   Coal production       Measured in terawatt-hours.   
[
    "Includes commercial solid fuels only, i.e. bituminous coal and anthracite (hard coal), and lignite and brown (sub-bituminous) coal, and other commercial solid fuels. Includes coal produced for Coal-to-Liquids and Coal-to-Gas transformations."
]
 - The data is generated by combining the latest data from [the Energy Institute Statistical Review of World Energy](https://www.energyinst.org/statistical-review) and [The Shift Dataportal](https://www.theshiftdataportal.org/energy). The Energy Institute provides fossil fuel production data from 1965 onwards (and crude prices from 1861 onwards). The Shift Dataportal provides long-term data from 1900, but only extends to 2016. To maintain consistency with other energy data, we prioritize the Energy Institute data - meaning if they provide data for the given country and year, this data is used. Where data is not available from the Energy Institute for a given country, or pre-1965 we rely on data from The Shift Dataportal. - We have converted primary production in exajoules to terawatt-hours using the conversion factor: 1,000,000 / 3,600 ~ 278. - Production per capita has been calculated by dividing by our population dataset, based on [different sources](https://ourworldindata.org/population-sources).       float 
[]
 260c60118c7174472bf6cc4fa2827d8f b9cb722a489754150a9e574c44330001

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE "variables" (
	"id" INTEGER PRIMARY KEY AUTOINCREMENT,
	"name" VARCHAR(750) NULL  ,
	"unit" VARCHAR(255) NOT NULL  ,
	"description" TEXT NULL  ,
	"createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ,
	"updatedAt" DATETIME NULL  ,
	"code" VARCHAR(255) NULL  ,
	"coverage" VARCHAR(255) NOT NULL  ,
	"timespan" VARCHAR(255) NOT NULL  ,
	"datasetId" INTEGER NOT NULL  ,
	"sourceId" INTEGER NULL  ,
	"shortUnit" VARCHAR(255) NULL  ,
	"display" TEXT NOT NULL  ,
	"columnOrder" INTEGER NOT NULL DEFAULT '0' ,
	"originalMetadata" TEXT NULL  ,
	"grapherConfigAdmin" TEXT NULL  ,
	"shortName" VARCHAR(255) NULL  ,
	"catalogPath" VARCHAR(767) NULL  ,
	"dimensions" TEXT NULL  ,
	"schemaVersion" INTEGER NOT NULL DEFAULT '1' ,
	"processingLevel" VARCHAR(30) NULL  ,
	"processingLog" TEXT NULL  ,
	"titlePublic" VARCHAR(512) NULL  ,
	"titleVariant" VARCHAR(255) NULL  ,
	"attributionShort" VARCHAR(512) NULL  ,
	"attribution" TEXT NULL  ,
	"descriptionShort" TEXT NULL  ,
	"descriptionFromProducer" TEXT NULL  ,
	"descriptionKey" TEXT NULL  ,
	"descriptionProcessing" TEXT NULL  ,
	"licenses" TEXT NULL  ,
	"license" TEXT NULL  ,
	"grapherConfigETL" TEXT NULL  ,
	"type" TEXT NULL  ,
	"sort" TEXT NULL  ,
	"dataChecksum" VARCHAR(64) NULL  ,
	"metadataChecksum" VARCHAR(64) NULL,
	FOREIGN KEY("datasetId") REFERENCES "datasets" ("id") ON UPDATE RESTRICT ON DELETE RESTRICT,
	FOREIGN KEY("sourceId") REFERENCES "sources" ("id") ON UPDATE RESTRICT ON DELETE RESTRICT
);
CREATE UNIQUE INDEX "idx_catalogPath" ON "variables" ("catalogPath");
CREATE UNIQUE INDEX "unique_short_name_per_dataset" ON "variables" ("shortName", "datasetId");
CREATE UNIQUE INDEX "variables_code_fk_dst_id_7bde8c2a_uniq" ON "variables" ("code", "datasetId");
CREATE INDEX "variables_datasetId_50a98bfd_fk_datasets_id" ON "variables" ("datasetId");
CREATE UNIQUE INDEX "variables_name_fk_dst_id_f7453c33_uniq" ON "variables" ("name", "datasetId");
CREATE INDEX "variables_sourceId_31fce80a_fk_sources_id" ON "variables" ("sourceId");