pathways_us_2017-1-15.public contains 1490 columns - click on heading to sort:

Table	Column	Type	Size	Nulls	Auto	Default	Comments
AgeGrowthOrDecayType	id	serial	10		√	nextval('"AgeGrowthOrDecayType_id_seq"'::regclass)
AgeGrowthOrDecayType	name	text	2147483647	√		null
BlendMeasuresData	blend_node_id	int4	10	√		null
BlendMeasuresData	gau_id	int4	10	√		null
BlendMeasuresData	id	int4	10	√		null
BlendMeasuresData	name	text	2147483647	√		null
BlendMeasuresData	value	float4	8,8	√		null
BlendMeasuresData	year	int4	10	√		null
BlendNodeBlendMeasurePackages	blend_node_id	int4	10	√		null
BlendNodeBlendMeasurePackages	id	serial	10		√	nextval('"BlendNodeBlendMeasurePackages_id_seq"'::regclass)
BlendNodeBlendMeasurePackages	name	text	2147483647	√		null
BlendNodeBlendMeasurePackagesData	id	serial	10		√	nextval('"BlendNodeBlendMeasurePackagesData_id_seq"'::regclass)
BlendNodeBlendMeasurePackagesData	measure_id	int4	10	√		null
BlendNodeBlendMeasurePackagesData	package_id	int4	10	√		null
BlendNodeBlendMeasures	blend_node_id	int4	10	√		null
BlendNodeBlendMeasures	extrapolation_growth	float4	8,8	√		null
BlendNodeBlendMeasures	extrapolation_method_id	int4	10	√		null
BlendNodeBlendMeasures	geography_id	int4	10	√		null
BlendNodeBlendMeasures	id	serial	10		√	nextval('"BlendNodeBlendMeasures_id_seq"'::regclass)
BlendNodeBlendMeasures	interpolation_method_id	int4	10	√		null
BlendNodeBlendMeasures	name	text	2147483647	√		null
BlendNodeBlendMeasures	other_index_1_id	int4	10	√		null
BlendNodeBlendMeasures	supply_node_id	int4	10	√		null
BlendNodeBlendMeasuresData	demand_sector_id	int4	10	√		null
BlendNodeBlendMeasuresData	gau_id	int4	10	√		null
BlendNodeBlendMeasuresData	id	serial	10		√	nextval('"BlendNodeBlendMeasuresData_id_seq"'::regclass)
BlendNodeBlendMeasuresData	parent_id	int4	10	√		null
BlendNodeBlendMeasuresData	value	float4	8,8	√		null
BlendNodeBlendMeasuresData	year	int4	10	√		null
BlendNodeInputsData	blend_node_id	int4	10	√		null
BlendNodeInputsData	id	serial	10		√	nextval('"BlendNodeInputsData_id_seq"'::regclass)
BlendNodeInputsData	supply_node_id	int4	10	√		null
CapitalCostOutputs	capacity_or_energy_unit	text	2147483647	√		null
CapitalCostOutputs	Currency	text	2147483647	√		null
CapitalCostOutputs	currency_year_id	int4	10	√		null
CapitalCostOutputs	Geography	text	2147483647	√		null
CapitalCostOutputs	Geography Unit	text	2147483647	√		null
CapitalCostOutputs	is_levelized	bool	1	√		null
CapitalCostOutputs	name	text	2147483647	√		null
CapitalCostOutputs	time_unit	text	2147483647	√		null
CapitalCostOutputs	value	float8	17,17	√		null
CapitalCostOutputs	vintage	int4	10	√		null
CleaningMethods	id	serial	10		√	nextval('"CleaningMethods_id_seq"'::regclass)
CleaningMethods	name	text	2147483647				name for the cleaning method, checked for in code time_series.py
Currencies	id	serial	10		√	nextval('"Currencies_id_seq"'::regclass)
Currencies	name	text	2147483647	√		null
CurrenciesConversion	currency_id	int4	10	√		null
CurrenciesConversion	currency_year_id	int4	10	√		null
CurrenciesConversion	id	serial	10		√	nextval('"CurrenciesConversion_id_seq"'::regclass)
CurrenciesConversion	value	float8	17,17	√		null
CurrencyYears	id	int4	10
DayType	id	serial	10		√	nextval('"DayType_id_seq"'::regclass)
DayType	name	text	2147483647	√		null
Definitions	id	serial	10		√	nextval('"Definitions_id_seq"'::regclass)
Definitions	name	text	2147483647
Demand Technologies - Auxiliary Efficiency	denominator_unit	text	2147483647	√		null
Demand Technologies - Auxiliary Efficiency	Final Energy	text	2147483647	√		null
Demand Technologies - Auxiliary Efficiency	Geography	text	2147483647	√		null
Demand Technologies - Auxiliary Efficiency	Geography Unit	text	2147483647	√		null
Demand Technologies - Auxiliary Efficiency	is_numerator_service	bool	1	√		null
Demand Technologies - Auxiliary Efficiency	name	text	2147483647	√		null
Demand Technologies - Auxiliary Efficiency	numerator_unit	text	2147483647	√		null
Demand Technologies - Auxiliary Efficiency	Other Index	text	2147483647	√		null
Demand Technologies - Auxiliary Efficiency	Sector	text	2147483647	√		null
Demand Technologies - Auxiliary Efficiency	Subsector	text	2147483647	√		null
Demand Technologies - Auxiliary Efficiency	time_unit	text	2147483647	√		null
Demand Technologies - Auxiliary Efficiency	unit	text	2147483647	√		null
Demand Technologies - Auxiliary Efficiency	value	float4	8,8	√		null
Demand Technologies - Auxiliary Efficiency	vintage	int4	10	√		null
Demand Technologies - Capital Costs	Currency	text	2147483647	√		null
Demand Technologies - Capital Costs	currency_year_id	int4	10	√		null
Demand Technologies - Capital Costs	Geography	text	2147483647	√		null
Demand Technologies - Capital Costs	Geography Unit	text	2147483647	√		null
Demand Technologies - Capital Costs	is_levelized	bool	1	√		null
Demand Technologies - Capital Costs	name	text	2147483647	√		null
Demand Technologies - Capital Costs	Other Index	text	2147483647	√		null
Demand Technologies - Capital Costs	Sector	text	2147483647	√		null
Demand Technologies - Capital Costs	Subsector	text	2147483647	√		null
Demand Technologies - Capital Costs	time_unit	text	2147483647	√		null
Demand Technologies - Capital Costs	unit	text	2147483647	√		null
Demand Technologies - Capital Costs	value	float4	8,8	√		null
Demand Technologies - Capital Costs	vintage	int4	10	√		null
Demand Technologies - Fixed OM	Currency	text	2147483647	√		null
Demand Technologies - Fixed OM	currency_year_id	int4	10	√		null
Demand Technologies - Fixed OM	Geography	text	2147483647	√		null
Demand Technologies - Fixed OM	Geography Unit	text	2147483647	√		null
Demand Technologies - Fixed OM	name	text	2147483647	√		null
Demand Technologies - Fixed OM	Other Index	text	2147483647	√		null
Demand Technologies - Fixed OM	Sector	text	2147483647	√		null
Demand Technologies - Fixed OM	Subsector	text	2147483647	√		null
Demand Technologies - Fixed OM	time_unit	text	2147483647	√		null
Demand Technologies - Fixed OM	unit	text	2147483647	√		null
Demand Technologies - Fixed OM	value	float4	8,8	√		null
Demand Technologies - Fixed OM	vintage	int4	10	√		null
Demand Technologies - Fuel Switching Costs	Currency	text	2147483647	√		null
Demand Technologies - Fuel Switching Costs	currency_year_id	int4	10	√		null
Demand Technologies - Fuel Switching Costs	Geography	text	2147483647	√		null
Demand Technologies - Fuel Switching Costs	Geography Unit	text	2147483647	√		null
Demand Technologies - Fuel Switching Costs	is_levelized	bool	1	√		null
Demand Technologies - Fuel Switching Costs	name	text	2147483647	√		null
Demand Technologies - Fuel Switching Costs	Other Index	text	2147483647	√		null
Demand Technologies - Fuel Switching Costs	Sector	text	2147483647	√		null
Demand Technologies - Fuel Switching Costs	Subsector	text	2147483647	√		null
Demand Technologies - Fuel Switching Costs	time_unit	text	2147483647	√		null
Demand Technologies - Fuel Switching Costs	unit	text	2147483647	√		null
Demand Technologies - Fuel Switching Costs	value	float4	8,8	√		null
Demand Technologies - Fuel Switching Costs	vintage	int4	10	√		null
Demand Technologies - Main Efficiency	denominator_unit	text	2147483647	√		null
Demand Technologies - Main Efficiency	Final Energy	text	2147483647	√		null
Demand Technologies - Main Efficiency	Geography	text	2147483647	√		null
Demand Technologies - Main Efficiency	Geography Unit	text	2147483647	√		null
Demand Technologies - Main Efficiency	is_numerator_service	bool	1	√		null
Demand Technologies - Main Efficiency	name	text	2147483647	√		null
Demand Technologies - Main Efficiency	numerator_unit	text	2147483647	√		null
Demand Technologies - Main Efficiency	Other Index	text	2147483647	√		null
Demand Technologies - Main Efficiency	Sector	text	2147483647	√		null
Demand Technologies - Main Efficiency	Subsector	text	2147483647	√		null
Demand Technologies - Main Efficiency	time_unit	text	2147483647	√		null
Demand Technologies - Main Efficiency	unit	text	2147483647	√		null
Demand Technologies - Main Efficiency	value	float4	8,8	√		null
Demand Technologies - Main Efficiency	vintage	int4	10	√		null
Demand Technologies - Parasitic Energy	energy_unit	text	2147483647	√		null
Demand Technologies - Parasitic Energy	Final Energy	text	2147483647	√		null
Demand Technologies - Parasitic Energy	Geography	text	2147483647	√		null
Demand Technologies - Parasitic Energy	Geography Unit	text	2147483647	√		null
Demand Technologies - Parasitic Energy	name	text	2147483647	√		null
Demand Technologies - Parasitic Energy	Other Index	text	2147483647	√		null
Demand Technologies - Parasitic Energy	Sector	text	2147483647	√		null
Demand Technologies - Parasitic Energy	Subsector	text	2147483647	√		null
Demand Technologies - Parasitic Energy	time_unit	text	2147483647	√		null
Demand Technologies - Parasitic Energy	value	float4	8,8	√		null
Demand Technologies - Parasitic Energy	vintage	int4	10	√		null
Demand Techs - Installation Costs	Currency	text	2147483647	√		null
Demand Techs - Installation Costs	currency_year_id	int4	10	√		null
Demand Techs - Installation Costs	Geography	text	2147483647	√		null
Demand Techs - Installation Costs	Geography Unit	text	2147483647	√		null
Demand Techs - Installation Costs	is_levelized	bool	1	√		null
Demand Techs - Installation Costs	name	text	2147483647	√		null
Demand Techs - Installation Costs	Other Index	text	2147483647	√		null
Demand Techs - Installation Costs	Sector	text	2147483647	√		null
Demand Techs - Installation Costs	Subsector	text	2147483647	√		null
Demand Techs - Installation Costs	time_unit	text	2147483647	√		null
Demand Techs - Installation Costs	unit	text	2147483647	√		null
Demand Techs - Installation Costs	value	float4	8,8	√		null
Demand Techs - Installation Costs	vintage	int4	10	√		null
DemandCases	id	serial	10		√	nextval('"DemandCases_id_seq"'::regclass)
DemandCases	name	text	2147483647	√		null
DemandCasesData	demand_case_id	int4	10
DemandCasesData	demand_state_id	int4	10
DemandCO2CaptureMeasures	extrapolation_growth	float4	8,8	√		null
DemandCO2CaptureMeasures	extrapolation_method_id	int4	10	√		null
DemandCO2CaptureMeasures	geography_id	int4	10	√		null
DemandCO2CaptureMeasures	id	serial	10		√	nextval('"DemandCO2CaptureMeasures_id_seq"'::regclass)
DemandCO2CaptureMeasures	input_type_id	int4	10	√		null
DemandCO2CaptureMeasures	interpolation_method_id	int4	10	√		null
DemandCO2CaptureMeasures	lifetime_variance	float4	8,8	√		null
DemandCO2CaptureMeasures	max_lifetime	float4	8,8	√		null
DemandCO2CaptureMeasures	mean_lifetime	float4	8,8	√		null
DemandCO2CaptureMeasures	min_lifetime	float4	8,8	√		null
DemandCO2CaptureMeasures	name	text	2147483647	√		null
DemandCO2CaptureMeasures	other_index_1_id	int4	10	√		null
DemandCO2CaptureMeasures	other_index_2_id	int4	10	√		null
DemandCO2CaptureMeasures	stock_decay_function_id	int4	10	√		null
DemandCO2CaptureMeasures	subsector_id	int4	10	√		null
DemandCO2CaptureMeasures	unit	text	2147483647	√		null
DemandDrivers	base_driver_id	int4	10	√		null	A base driver means that this driver is actually linked to prior drivers. For example, residential square footage depends on the number of households, which depends on population. In this case, number of households is a base driver for residential square footage and population is a base driver for number of households.
DemandDrivers	extrapolation_growth	float4	8,8	√		null	If extrapolation method exponential is used, what is the year over year growth rate.
DemandDrivers	extrapolation_method_id	int4	10	√		null	Cleaning method used to extrapolate to missing years when data is entered.
DemandDrivers	geography_id	int4	10	√		null	Input geography for the data (e.g. state). Each DemandDriversData record will identify which state.
DemandDrivers	geography_map_key_id	int4	10	√		null	Basis for mapping between geographies. For example, if my input data is for the entire country and I want to allocate the data to each state, do it based on the proportional share of households in each state. In this case, number of households would be the geography map key. For more information, see: https://docs.google.com/document/d/19cspAg2El5d1dvQggi7Vx8XJ1al-11IDf6DgRbpk-FU/edit#heading=h.n712kivlou9l
DemandDrivers	id	serial	10		√	nextval('"DemandDrivers_id_seq"'::regclass)
DemandDrivers	input_type_id	int4	10	√		null	Input data is either a total or an intensity.
DemandDrivers	interpolation_method_id	int4	10	√		null	Cleaning method used to interpolate between missing years when data is entered.
DemandDrivers	name	text	2147483647	√		null
DemandDrivers	other_index_1_id	int4	10	√		null	First sub category for the input data (e.g. housing type)
DemandDrivers	other_index_2_id	int4	10	√		null	Second sub category for the input data (e.g. housing type)
DemandDrivers	unit_base	text	2147483647	√		null	Demand driver units units
DemandDrivers	unit_prefix	int4	10	√		null	This acts as a multiplier on the input data (e.g. 1,000,000s of people)
DemandDriversData	gau_id	int4	10	√		null	This is the id for geographical analysis unit (GAU). If U.S. states was the geography, California would be a GAU.
DemandDriversData	id	serial	10		√	nextval('"DemandDriversData_id_seq"'::regclass)	Unique id
DemandDriversData	oth_1_id	int4	10	√		null	Member of the first sub category. For example, if housing type was an other index, one member might be single-family homes.
DemandDriversData	oth_2_id	int4	10	√		null	Member of the second sub category. For example, if housing type was an other index, one member might be single-family homes.
DemandDriversData	parent_id	int4	10	√		null	id in parent table
DemandDriversData	value	float8	17,17	√		null	Actual data
DemandDriversData	year	int4	10	√		null	Input year
DemandEnergyDemands	demand_technology_index	bool	1	√		null
DemandEnergyDemands	driver_1_id	int4	10	√		null	Energy demand grows or shrinks in proportion to this driver.
DemandEnergyDemands	driver_2_id	int4	10	√		null	Energy demand grows or shrinks in proportion to this driver.
DemandEnergyDemands	driver_denominator_1_id	int4	10	√		null	If the data is an intensity, what driver is in the denominator? For example, if the subsector is commercial water heating, and the data is input in kBtu per commercial square foot, kBtu will be the unit and commercial square foot will be the driver in the denominator.
DemandEnergyDemands	driver_denominator_2_id	int4	10	√		null	Accommodates a second driver in the denominator of the inputs.
DemandEnergyDemands	extrapolation_growth	float4	8,8	√		null	If extrapolation method exponential is used, what is the year over year growth rate?
DemandEnergyDemands	extrapolation_method_id	int4	10	√		null	Cleaning method used to extrapolate to missing years when data is entered.
DemandEnergyDemands	final_energy_index	bool	1	√		null
DemandEnergyDemands	geography_id	int4	10	√		null	Input geography for the data (e.g. state)
DemandEnergyDemands	geography_map_key_id	int4	10	√		null	Basis for mapping between geographies. For example, if my input data is for the entire country and I want to allocate the data to each state, do it based on the proportional share of households in each state. For more information, see: https://docs.google.com/document/d/19cspAg2El5d1dvQggi7Vx8XJ1al-11IDf6DgRbpk-FU/edit#heading=h.n712kivlou9l
DemandEnergyDemands	input_type_id	int4	10	√		null	Input data is either a total or an intensity.
DemandEnergyDemands	interpolation_method_id	int4	10	√		null	Cleaning method used to interpolate between missing years when data is entered.
DemandEnergyDemands	is_stock_dependent	bool	1	√		false	This is a boolean indicating whether the energy demand depends on the size of the stock (e.g. HVAC energy demand depends on the total number of HVAC units).
DemandEnergyDemands	other_index_1_id	int4	10	√		null	First sub category for the input data (e.g. housing type)
DemandEnergyDemands	other_index_2_id	int4	10	√		null	Second sub category for the input data (e.g. housing type)
DemandEnergyDemands	subsector_id	int4	10				id for the demand subsector
DemandEnergyDemands	unit	text	2147483647	√		null	Energy unit for the given inputs.
DemandEnergyDemandsData	demand_technology_id	int4	10	√		null
DemandEnergyDemandsData	final_energy_id	int4	10	√		null
DemandEnergyDemandsData	gau_id	int4	10	√		null	This is the id for geographical analysis unit (GAU). If U.S. states was the geography, California would be a GAU.
DemandEnergyDemandsData	id	serial	10		√	nextval('"DemandEnergyDemandsData_id_seq"'::regclass)	Unique id
DemandEnergyDemandsData	oth_1_id	int4	10	√		null	Member of the first sub category. For example, if housing type was an other index, one member might be single-family homes.
DemandEnergyDemandsData	oth_2_id	int4	10	√		null	Member of the second sub category. For example, if housing type was an other index, one member might be single-family homes.
DemandEnergyDemandsData	subsector_id	int4	10	√		null
DemandEnergyDemandsData	value	float4	8,8	√		null	Actual energy demand value
DemandEnergyDemandsData	year	int4	10	√		null	Input year
DemandEnergyEfficiencyMeasurePackages	id	serial	10		√	nextval('"DemandEnergyEfficiencyMeasurePackages_id_seq"'::regclass)
DemandEnergyEfficiencyMeasurePackages	name	text	2147483647	√		null
DemandEnergyEfficiencyMeasurePackages	subsector_id	int4	10	√		null
DemandEnergyEfficiencyMeasurePackagesData	id	serial	10		√	nextval('"DemandEnergyEfficiencyMeasurePackagesData_id_seq"'::regclass)
DemandEnergyEfficiencyMeasurePackagesData	measure_id	int4	10	√		null
DemandEnergyEfficiencyMeasurePackagesData	package_id	int4	10	√		null
DemandEnergyEfficiencyMeasures	extrapolation_growth	float4	8,8	√		null
DemandEnergyEfficiencyMeasures	extrapolation_method_id	int4	10	√		null
DemandEnergyEfficiencyMeasures	geography_id	int4	10	√		null
DemandEnergyEfficiencyMeasures	id	serial	10		√	nextval('"DemandEnergyEfficiencyMeasures_id_seq"'::regclass)
DemandEnergyEfficiencyMeasures	input_type_id	int4	10	√		null
DemandEnergyEfficiencyMeasures	interpolation_method_id	int4	10	√		null
DemandEnergyEfficiencyMeasures	lifetime_variance	float4	8,8	√		null
DemandEnergyEfficiencyMeasures	max_lifetime	float4	8,8	√		null
DemandEnergyEfficiencyMeasures	mean_lifetime	float4	8,8	√		null
DemandEnergyEfficiencyMeasures	min_lifetime	float4	8,8	√		null
DemandEnergyEfficiencyMeasures	name	text	2147483647	√		null
DemandEnergyEfficiencyMeasures	other_index_1_id	int4	10	√		null
DemandEnergyEfficiencyMeasures	other_index_2_id	int4	10	√		null
DemandEnergyEfficiencyMeasures	stock_decay_function_id	int4	10	√		null
DemandEnergyEfficiencyMeasures	subsector_id	int4	10	√		null
DemandEnergyEfficiencyMeasures	unit	text	2147483647	√		null
DemandEnergyEfficiencyMeasuresCost	cost_denominator_unit	text	2147483647	√		null
DemandEnergyEfficiencyMeasuresCost	cost_of_capital	float4	8,8	√		null
DemandEnergyEfficiencyMeasuresCost	currency_id	int4	10	√		null
DemandEnergyEfficiencyMeasuresCost	currency_year_id	int4	10	√		null
DemandEnergyEfficiencyMeasuresCost	extrapolation_growth	float4	8,8	√		null
DemandEnergyEfficiencyMeasuresCost	extrapolation_method_id	int4	10	√		null
DemandEnergyEfficiencyMeasuresCost	geography_id	int4	10	√		null
DemandEnergyEfficiencyMeasuresCost	interpolation_method_id	int4	10	√		null
DemandEnergyEfficiencyMeasuresCost	is_levelized	bool	1	√		null
DemandEnergyEfficiencyMeasuresCost	other_index_1_id	int4	10	√		null
DemandEnergyEfficiencyMeasuresCost	other_index_2_id	int4	10	√		null
DemandEnergyEfficiencyMeasuresCost	parent_id	int4	10
DemandEnergyEfficiencyMeasuresCostData	final_energy_id	int4	10	√		null
DemandEnergyEfficiencyMeasuresCostData	gau_id	int4	10	√		null
DemandEnergyEfficiencyMeasuresCostData	id	serial	10		√	nextval('"DemandEnergyEfficiencyMeasuresCostData_id_seq"'::regclass)
DemandEnergyEfficiencyMeasuresCostData	oth_1_id	int4	10	√		null
DemandEnergyEfficiencyMeasuresCostData	oth_2_id	int4	10	√		null
DemandEnergyEfficiencyMeasuresCostData	parent_id	int4	10	√		null
DemandEnergyEfficiencyMeasuresCostData	value	float4	8,8	√		null
DemandEnergyEfficiencyMeasuresCostData	vintage	int4	10	√		null
DemandEnergyEfficiencyMeasuresData	final_energy_id	int4	10	√		null
DemandEnergyEfficiencyMeasuresData	gau_id	int4	10	√		null
DemandEnergyEfficiencyMeasuresData	id	serial	10		√	nextval('"DemandEnergyEfficiencyMeasuresData_id_seq"'::regclass)
DemandEnergyEfficiencyMeasuresData	oth_1_id	int4	10	√		null
DemandEnergyEfficiencyMeasuresData	oth_2_id	int4	10	√		null
DemandEnergyEfficiencyMeasuresData	parent_id	int4	10	√		null
DemandEnergyEfficiencyMeasuresData	value	float4	8,8	√		null
DemandEnergyEfficiencyMeasuresData	year	int4	10	√		null
DemandFlexibleLoadMeasurePackages	id	int4	10
DemandFlexibleLoadMeasurePackages	name	text	2147483647	√		null
DemandFlexibleLoadMeasurePackages	subsector_id	int4	10	√		null
DemandFlexibleLoadMeasurePackagesData	id	serial	10		√	nextval('"DemandFlexibleLoadMeasurePackagesData_id_seq"'::regclass)
DemandFlexibleLoadMeasurePackagesData	measure_id	int4	10	√		null
DemandFlexibleLoadMeasurePackagesData	package_id	int4	10	√		null
DemandFlexibleLoadMeasures	extrapolation_growth	float4	8,8	√		null
DemandFlexibleLoadMeasures	extrapolation_method_id	int4	10	√		null
DemandFlexibleLoadMeasures	geography_id	int4	10	√		null
DemandFlexibleLoadMeasures	id	serial	10		√	nextval('"DemandFlexibleLoadMeasures_id_seq"'::regclass)
DemandFlexibleLoadMeasures	interpolation_method_id	int4	10	√		null
DemandFlexibleLoadMeasures	other_index_1_id	int4	10	√		null
DemandFlexibleLoadMeasures	subsector_id	int4	10	√		null
DemandFlexibleLoadMeasuresData	gau_id	int4	10	√		null
DemandFlexibleLoadMeasuresData	id	serial	10		√	nextval('"DemandFlexibleLoadMeasuresData_id_seq"'::regclass)
DemandFlexibleLoadMeasuresData	oth_1_id	int4	10	√		null
DemandFlexibleLoadMeasuresData	parent_id	int4	10	√		null
DemandFlexibleLoadMeasuresData	value	float8	17,17	√		null
DemandFlexibleLoadMeasuresData	year	int4	10	√		null
DemandFuelSwitchingMeasurePackages	id	serial	10		√	nextval('"DemandFuelSwitchingMeasurePackages_id_seq"'::regclass)
DemandFuelSwitchingMeasurePackages	name	text	2147483647	√		null
DemandFuelSwitchingMeasurePackages	subsector_id	int4	10	√		null
DemandFuelSwitchingMeasurePackagesData	id	serial	10		√	nextval('"DemandFuelSwitchingMeasurePackagesData_id_seq"'::regclass)
DemandFuelSwitchingMeasurePackagesData	measure_id	int4	10	√		null
DemandFuelSwitchingMeasurePackagesData	package_id	int4	10	√		null
DemandFuelSwitchingMeasures	final_energy_from_id	int4	10	√		null
DemandFuelSwitchingMeasures	final_energy_to_id	int4	10	√		null
DemandFuelSwitchingMeasures	id	serial	10		√	nextval('"DemandFuelSwitchingMeasures_id_seq"'::regclass)
DemandFuelSwitchingMeasures	lifetime_variance	float4	8,8	√		null
DemandFuelSwitchingMeasures	max_lifetime	float4	8,8	√		null
DemandFuelSwitchingMeasures	mean_lifetime	float4	8,8	√		null
DemandFuelSwitchingMeasures	min_lifetime	float4	8,8	√		null
DemandFuelSwitchingMeasures	name	text	2147483647	√		null
DemandFuelSwitchingMeasures	stock_decay_function_id	int4	10	√		null
DemandFuelSwitchingMeasures	subsector_id	int4	10	√		null
DemandFuelSwitchingMeasuresCost	cost_denominator_unit	text	2147483647	√		null
DemandFuelSwitchingMeasuresCost	cost_of_capital	float4	8,8	√		null
DemandFuelSwitchingMeasuresCost	currency_id	int4	10	√		null
DemandFuelSwitchingMeasuresCost	currency_year_id	int4	10	√		null
DemandFuelSwitchingMeasuresCost	extrapolation_growth	float4	8,8	√		null
DemandFuelSwitchingMeasuresCost	extrapolation_method_id	int4	10	√		null
DemandFuelSwitchingMeasuresCost	geography_id	int4	10	√		null
DemandFuelSwitchingMeasuresCost	interpolation_method_id	int4	10	√		null
DemandFuelSwitchingMeasuresCost	is_levelized	bool	1	√		null
DemandFuelSwitchingMeasuresCost	other_index_1_id	int4	10	√		null
DemandFuelSwitchingMeasuresCost	other_index_2_id	int4	10	√		null
DemandFuelSwitchingMeasuresCost	parent_id	int4	10
DemandFuelSwitchingMeasuresCostData	gau_id	int4	10	√		null
DemandFuelSwitchingMeasuresCostData	id	serial	10		√	nextval('"DemandFuelSwitchingMeasuresCostData_id_seq"'::regclass)
DemandFuelSwitchingMeasuresCostData	oth_1_id	int4	10	√		null
DemandFuelSwitchingMeasuresCostData	oth_2_id	int4	10	√		null
DemandFuelSwitchingMeasuresCostData	parent_id	int4	10	√		null
DemandFuelSwitchingMeasuresCostData	value	float4	8,8	√		null
DemandFuelSwitchingMeasuresCostData	vintage	int4	10	√		null
DemandFuelSwitchingMeasuresEnergyIntensity	extrapolation_growth	float4	8,8	√		null
DemandFuelSwitchingMeasuresEnergyIntensity	extrapolation_method_id	int4	10	√		null
DemandFuelSwitchingMeasuresEnergyIntensity	geography_id	int4	10	√		null
DemandFuelSwitchingMeasuresEnergyIntensity	id	int4	10
DemandFuelSwitchingMeasuresEnergyIntensity	interpolation_method_id	int4	10	√		null
DemandFuelSwitchingMeasuresEnergyIntensity	other_index_1_id	int4	10	√		null
DemandFuelSwitchingMeasuresEnergyIntensity	other_index_2_id	int4	10	√		null
DemandFuelSwitchingMeasuresEnergyIntensity	parent_id	int4	10	√		null
DemandFuelSwitchingMeasuresEnergyIntensityData	gau_id	int4	10	√		null
DemandFuelSwitchingMeasuresEnergyIntensityData	id	serial	10		√	nextval('"DemandFuelSwitchingMeasuresEnergyIntensityData_id_seq"'::regclass)
DemandFuelSwitchingMeasuresEnergyIntensityData	oth_1_id	int4	10	√		null
DemandFuelSwitchingMeasuresEnergyIntensityData	oth_2_id	int4	10	√		null
DemandFuelSwitchingMeasuresEnergyIntensityData	parent_id	int4	10	√		null
DemandFuelSwitchingMeasuresEnergyIntensityData	value	float4	8,8	√		null
DemandFuelSwitchingMeasuresEnergyIntensityData	year	int4	10	√		null
DemandFuelSwitchingMeasuresImpact	extrapolation_growth	float4	8,8	√		null
DemandFuelSwitchingMeasuresImpact	extrapolation_method_id	int4	10	√		null
DemandFuelSwitchingMeasuresImpact	geography_id	int4	10	√		null
DemandFuelSwitchingMeasuresImpact	id	int4	10
DemandFuelSwitchingMeasuresImpact	input_type_id	int4	10	√		null
DemandFuelSwitchingMeasuresImpact	interpolation_method_id	int4	10	√		null
DemandFuelSwitchingMeasuresImpact	other_index_1_id	int4	10	√		null
DemandFuelSwitchingMeasuresImpact	other_index_2_id	int4	10	√		null
DemandFuelSwitchingMeasuresImpact	parent_id	int4	10	√		null
DemandFuelSwitchingMeasuresImpact	unit	text	2147483647	√		null
DemandFuelSwitchingMeasuresImpactData	gau_id	int4	10	√		null
DemandFuelSwitchingMeasuresImpactData	id	serial	10		√	nextval('"DemandFuelSwitchingMeasuresImpactData_id_seq"'::regclass)
DemandFuelSwitchingMeasuresImpactData	oth_1_id	int4	10	√		null
DemandFuelSwitchingMeasuresImpactData	oth_2_id	int4	10	√		null
DemandFuelSwitchingMeasuresImpactData	parent_id	int4	10	√		null
DemandFuelSwitchingMeasuresImpactData	value	float4	8,8	√		null
DemandFuelSwitchingMeasuresImpactData	year	int4	10	√		null
DemandSales	extrapolation_growth	float4	8,8	√		null	If extrapolation method exponential is used, what is the year over year growth rate?
DemandSales	extrapolation_method_id	int4	10	√		null	Cleaning method used to extrapolate to missing years when data is entered.
DemandSales	geography_id	int4	10	√		null	Input geography for the data (e.g. state)
DemandSales	input_type_id	int4	10	√		null	Input data is either a total or an intensity.
DemandSales	interpolation_method_id	int4	10	√		null	Cleaning method used to interpolate between missing years when data is entered.
DemandSales	other_index_1_id	int4	10	√		null	First sub category for the input data (e.g. housing type)
DemandSales	other_index_2_id	int4	10	√		null	Second sub category for the input data (e.g. housing type)
DemandSales	subsector_id	int4	10
DemandSalesData	demand_technology_id	int4	10	√		null	Demand technology id
DemandSalesData	gau_id	int4	10	√		null	This is the id for geographical analysis unit (GAU). If U.S. states was the geography, California would be a GAU.
DemandSalesData	id	serial	10		√	nextval('"DemandSalesData_id_seq"'::regclass)	Unique id
DemandSalesData	oth_1_id	int4	10	√		null	Member of the first sub category. For example, if housing type was an other index, one member might be single-family homes.
DemandSalesData	oth_2_id	int4	10	√		null	Member of the second sub category. For example, if housing type was an other index, one member might be single-family homes.
DemandSalesData	subsector_id	int4	10	√		null
DemandSalesData	value	float4	8,8	√		null	Input value
DemandSalesData	vintage	int4	10	√		null	Year of sale
DemandSalesMeasurePackages	id	serial	10		√	nextval('"DemandSalesMeasurePackages_id_seq"'::regclass)
DemandSalesMeasurePackages	name	text	2147483647	√		null
DemandSalesMeasurePackages	subsector_id	int4	10	√		null
DemandSalesMeasurePackagesData	id	serial	10		√	nextval('"DemandSalesMeasurePackagesData_id_seq"'::regclass)
DemandSalesMeasurePackagesData	measure_id	int4	10	√		null
DemandSalesMeasurePackagesData	package_id	int4	10	√		null
DemandSalesMeasures	demand_technology_id	int4	10	√		null
DemandSalesMeasures	extrapolation_growth	float4	8,8	√		null
DemandSalesMeasures	extrapolation_method_id	int4	10	√		null
DemandSalesMeasures	geography_id	int4	10	√		null
DemandSalesMeasures	id	serial	10		√	nextval('"DemandSalesMeasures_id_seq"'::regclass)
DemandSalesMeasures	input_type_id	int4	10	√		null
DemandSalesMeasures	interpolation_method_id	int4	10	√		null
DemandSalesMeasures	name	text	2147483647	√		null
DemandSalesMeasures	other_index_1_id	int4	10	√		null
DemandSalesMeasures	replaced_demand_tech_id	int4	10	√		null
DemandSalesMeasures	subsector_id	int4	10	√		null
DemandSalesMeasuresData	gau_id	int4	10	√		null
DemandSalesMeasuresData	id	serial	10		√	nextval('"DemandSalesMeasuresData_id_seq"'::regclass)
DemandSalesMeasuresData	oth_1_id	int4	10	√		null
DemandSalesMeasuresData	parent_id	int4	10	√		null
DemandSalesMeasuresData	value	float4	8,8	√		null
DemandSalesMeasuresData	vintage	int4	10	√		null
DemandSectors	id	serial	10		√	nextval('"DemandSectors_id_seq"'::regclass)
DemandSectors	max_lag_hours	int4	10	√		null	Max lag hours refer to the number of hours that electricity service demand can be delayed in time. At the sector level, this acts as a default value that trickles down to all member subsectors. Note that this flexible load is further moderated by a demand flexible load package that control what percent of total subsector load is flexible year-by-year.
DemandSectors	max_lead_hours	int4	10	√		null	Max lead hours refer to the number of hours that electricity service demand can be advanced in time. At the sector level, this acts as a default value that trickles down to all member subsectors. Note that this flexible load is further moderated by a demand flexible load package that control what percent of total subsector load is flexible year-by-year.
DemandSectors	name	text	2147483647
DemandSectors	shape_id	int4	10	√		null	Default electricity shape for the sector
DemandServiceDemandMeasurePackages	id	serial	10		√	nextval('"DemandServiceDemandMeasurePackages_id_seq"'::regclass)
DemandServiceDemandMeasurePackages	name	text	2147483647	√		null
DemandServiceDemandMeasurePackages	subsector_id	int4	10	√		null
DemandServiceDemandMeasurePackagesData	id	serial	10		√	nextval('"DemandServiceDemandMeasurePackagesData_id_seq"'::regclass)
DemandServiceDemandMeasurePackagesData	measure_id	int4	10	√		null
DemandServiceDemandMeasurePackagesData	package_id	int4	10	√		null
DemandServiceDemandMeasures	extrapolation_growth	float4	8,8	√		null
DemandServiceDemandMeasures	extrapolation_method_id	int4	10	√		null
DemandServiceDemandMeasures	geography_id	int4	10	√		null
DemandServiceDemandMeasures	id	serial	10		√	nextval('"DemandServiceDemandMeasures_id_seq"'::regclass)
DemandServiceDemandMeasures	input_type_id	int4	10	√		null
DemandServiceDemandMeasures	interpolation_method_id	int4	10	√		null
DemandServiceDemandMeasures	lifetime_variance	float4	8,8	√		null
DemandServiceDemandMeasures	max_lifetime	float4	8,8	√		null
DemandServiceDemandMeasures	mean_lifetime	float4	8,8	√		null
DemandServiceDemandMeasures	min_lifetime	float4	8,8	√		null
DemandServiceDemandMeasures	name	text	2147483647	√		null
DemandServiceDemandMeasures	other_index_1_id	int4	10	√		null
DemandServiceDemandMeasures	other_index_2_id	int4	10	√		null
DemandServiceDemandMeasures	stock_decay_function_id	int4	10	√		null
DemandServiceDemandMeasures	subsector_id	int4	10	√		null
DemandServiceDemandMeasures	unit	text	2147483647	√		null
DemandServiceDemandMeasuresCost	cost_denominator_unit	text	2147483647	√		null
DemandServiceDemandMeasuresCost	cost_of_capital	float4	8,8	√		null
DemandServiceDemandMeasuresCost	currency_id	int4	10	√		null
DemandServiceDemandMeasuresCost	currency_year_id	int4	10	√		null
DemandServiceDemandMeasuresCost	extrapolation_growth	float4	8,8	√		null
DemandServiceDemandMeasuresCost	extrapolation_method_id	int4	10	√		null
DemandServiceDemandMeasuresCost	geography_id	int4	10	√		null
DemandServiceDemandMeasuresCost	interpolation_method_id	int4	10	√		null
DemandServiceDemandMeasuresCost	is_levelized	bool	1	√		null
DemandServiceDemandMeasuresCost	other_index_1_id	int4	10	√		null
DemandServiceDemandMeasuresCost	other_index_2_id	int4	10	√		null
DemandServiceDemandMeasuresCost	parent_id	int4	10
DemandServiceDemandMeasuresCostData	gau_id	int4	10	√		null
DemandServiceDemandMeasuresCostData	id	int4	10
DemandServiceDemandMeasuresCostData	oth_1_id	int4	10	√		null
DemandServiceDemandMeasuresCostData	oth_2_id	int4	10	√		null
DemandServiceDemandMeasuresCostData	parent_id	int4	10	√		null
DemandServiceDemandMeasuresCostData	value	float4	8,8	√		null
DemandServiceDemandMeasuresCostData	vintage	int4	10	√		null
DemandServiceDemandMeasuresData	gau_id	int4	10	√		null
DemandServiceDemandMeasuresData	id	serial	10		√	nextval('"DemandServiceDemandMeasuresData_id_seq"'::regclass)
DemandServiceDemandMeasuresData	oth_1_id	int4	10	√		null
DemandServiceDemandMeasuresData	oth_2_id	int4	10	√		null
DemandServiceDemandMeasuresData	parent_id	int4	10	√		null
DemandServiceDemandMeasuresData	value	float4	8,8	√		null
DemandServiceDemandMeasuresData	year	int4	10	√		null
DemandServiceDemands	demand_technology_index	bool	1	√		null
DemandServiceDemands	driver_1_id	int4	10	√		null	Service demand in the model will increase or decrease proportionally with this driver.
DemandServiceDemands	driver_2_id	int4	10	√		null	Ability to add a second driver.
DemandServiceDemands	driver_denominator_1_id	int4	10	√		null	If the data is an intensity, what driver is in the denominator? For example, if the subsector is light duty autos, and the data is input is vehicle miles traveled per capita, vehicle miles traveled will be the unit and population will be the driver in the denominator.
DemandServiceDemands	driver_denominator_2_id	int4	10	√		null	Accommodates a second driver in the denominator of the inputs.
DemandServiceDemands	extrapolation_growth	float4	8,8	√		null	If extrapolation method exponential is used, what is the year over year growth rate?
DemandServiceDemands	extrapolation_method_id	int4	10	√		null	Cleaning method used to extrapolate to missing years when data is entered.
DemandServiceDemands	final_energy_index	bool	1	√		null
DemandServiceDemands	geography_id	int4	10	√		null	Input geography for the data (e.g. state). Each DemandServiceDemandsData record will identify which state.
DemandServiceDemands	geography_map_key_id	int4	10	√		null	Basis for mapping between geographies. For example, if my input data is for the entire country and I want to allocate the data to each state, do it based on the proportional share of households in each state. For more information, see: https://docs.google.com/document/d/19cspAg2El5d1dvQggi7Vx8XJ1al-11IDf6DgRbpk-FU/edit#heading=h.n712kivlou9l
DemandServiceDemands	input_type_id	int4	10	√		null	Input data is either a total or an intensity.
DemandServiceDemands	interpolation_method_id	int4	10	√		null	Cleaning method used to interpolate between missing years when data is entered.
DemandServiceDemands	is_stock_dependent	bool	1	√		false	If service demand is stock dependent it means that it is proportional to the amount of stock in the market. In this case, total stock is solved first and becomes a driver of service demand. More about demand drivers here: https://docs.google.com/document/d/19cspAg2El5d1dvQggi7Vx8XJ1al-11IDf6DgRbpk-FU/edit#heading=h.94rqs9slq4zx
DemandServiceDemands	other_index_1_id	int4	10	√		null	First sub category for the input data (e.g. housing type)
DemandServiceDemands	other_index_2_id	int4	10	√		null	Second sub category for the input data (e.g. housing type)
DemandServiceDemands	subsector_id	int4	10				Parent subsector id
DemandServiceDemands	unit	text	2147483647	√		null	Service demand units (e.g. vehicle miles traveled or tons of cooling)
DemandServiceDemandsData	demand_technology_id	int4	10	√		null
DemandServiceDemandsData	final_energy_id	int4	10	√		null
DemandServiceDemandsData	gau_id	int4	10	√		null	This is the id for geographical analysis unit (GAU). If U.S. states was the geography, California would be a GAU.
DemandServiceDemandsData	id	serial	10		√	nextval('"DemandServiceDemandsData_id_seq"'::regclass)	Unique id
DemandServiceDemandsData	oth_1_id	int4	10	√		null	Member of the first sub category. For example, if housing type was an other index, one member might be single-family homes.
DemandServiceDemandsData	oth_2_id	int4	10	√		null	Member of the second sub category. For example, if housing type was an other index, one member might be single-family homes.
DemandServiceDemandsData	subsector_id	int4	10	√		null	Parent subsector id
DemandServiceDemandsData	value	float4	8,8	√		null	Input data
DemandServiceDemandsData	year	int4	10	√		null	Data input year
DemandServiceEfficiency	denominator_unit	text	2147483647	√		null	Service demand unit
DemandServiceEfficiency	energy_unit	text	2147483647	√		null	Input energy unit
DemandServiceEfficiency	extrapolation_growth	float4	8,8	√		null	If extrapolation method exponential is used, what is the year over year growth rate?
DemandServiceEfficiency	extrapolation_method_id	int4	10	√		null	Cleaning method used to extrapolate to missing years when data is entered.
DemandServiceEfficiency	geography_id	int4	10	√		null	Input geography for the data (e.g. state)
DemandServiceEfficiency	geography_map_key_id	int4	10	√		null	Basis for mapping between geographies. For example, if my input data is for the entire country and I want to allocate the data to each state, do it based on the proportional share of households in each state. For more information, see: https://docs.google.com/document/d/19cspAg2El5d1dvQggi7Vx8XJ1al-11IDf6DgRbpk-FU/edit#heading=h.n712kivlou9l
DemandServiceEfficiency	interpolation_method_id	int4	10	√		null	Cleaning method used to interpolate between missing years when data is entered.
DemandServiceEfficiency	other_index_1_id	int4	10	√		null	First sub category for the input data (e.g. housing type)
DemandServiceEfficiency	other_index_2_id	int4	10	√		null	Second sub category for the input data (e.g. housing type)
DemandServiceEfficiency	subsector_id	int4	10				Parent subsector.
DemandServiceEfficiencyData	final_energy_id	int4	10	√		null	Final energy type
DemandServiceEfficiencyData	gau_id	int4	10	√		null	This is the id for geographical analysis unit (GAU). If U.S. states was the geography, California would be a GAU.
DemandServiceEfficiencyData	id	serial	10		√	nextval('"DemandServiceEfficiencyData_id_seq"'::regclass)	Unique id.
DemandServiceEfficiencyData	oth_1_id	int4	10	√		null	Member of the first sub category. For example, if housing type was an other index, one member might be single-family homes.
DemandServiceEfficiencyData	oth_2_id	int4	10	√		null	Member of the second sub category. For example, if housing type was an other index, one member might be single-family homes.
DemandServiceEfficiencyData	subsector_id	int4	10	√		null	Parent subsector id.
DemandServiceEfficiencyData	value	float4	8,8	√		null	Data value.
DemandServiceEfficiencyData	year	int4	10	√		null	Data input year.
DemandServiceLink	id	serial	10		√	nextval('"DemandServiceLink_id_seq"'::regclass)	Unique id.
DemandServiceLink	linked_subsector_id	int4	10	√		null	Dependent subsector. In our example, this would be hot water heating.
DemandServiceLink	service_demand_share	float4	8,8	√		null	What share of the linked_subsector_id service demand comes from the subsector_id? For example, dishwashing might be responsible for 10% of hot water demand. Thus, if dishwashers doubled in efficiency, the demand for hot water would drop 5%.
DemandServiceLink	subsector_id	int4	10	√		null	Independent subsector in the link. In our example, this would be dishwashing.
DemandServiceLink	year	int4	10	√		null	Basis year for the service demand share.
DemandStates	description	text	2147483647	√		null
DemandStates	energy_efficiency_package_id	int4	10	√		null
DemandStates	flexible_load_package_id	int4	10	√		null
DemandStates	fuel_switching_package_id	int4	10	√		null
DemandStates	id	serial	10		√	nextval('"DemandCasesData_id_seq"'::regclass)
DemandStates	sales_package_id	int4	10	√		null
DemandStates	service_demand_package_id	int4	10	√		null
DemandStates	stock_package_id	int4	10	√		null
DemandStates	subsector_id	int4	10	√		null
DemandStock	demand_stock_unit_type_id	int4	10	√		null	Equipment, service demand, or capacity factor
DemandStock	driver_1_id	int4	10	√		null	Total stock in the model will increase or decrease proportionally with this driver.
DemandStock	driver_2_id	int4	10	√		null	Second stock driver.
DemandStock	driver_denominator_1_id	int4	10	√		null	If the data is an intensity, what driver is in the denominator? For example, if the subsector is light duty autos, and the data is input is number of vehicles per capita, population will be the driver in the denominator.
DemandStock	driver_denominator_2_id	int4	10	√		null	Accommodates a second driver in the denominator of the inputs.
DemandStock	extrapolation_growth	float4	8,8	√		null	If extrapolation method exponential is used, what is the year over year growth rate?
DemandStock	extrapolation_method_id	int4	10	√		null	Cleaning method used to extrapolate to missing years when data is entered.
DemandStock	geography_id	int4	10	√		null	Input geography for the data (e.g. state)
DemandStock	geography_map_key_id	int4	10	√		null	Basis for mapping between geographies. For example, if my input data is for the entire country and I want to allocate the data to each state, do it based on the proportional share of households in each state. For more information, see: https://docs.google.com/document/d/19cspAg2El5d1dvQggi7Vx8XJ1al-11IDf6DgRbpk-FU/edit#heading=h.n712kivlou9l
DemandStock	input_type_id	int4	10	√		null	Total or intensity.
DemandStock	interpolation_method_id	int4	10	√		null	Cleaning method used to interpolate between missing years when data is entered.
DemandStock	is_service_demand_dependent	bool	1	√		false	If stock is service demand dependent it means that total stock it is proportional to total service demand. In this case, service demand is solved first and becomes a driver of stock. More about demand drivers here: https://docs.google.com/document/d/19cspAg2El5d1dvQggi7Vx8XJ1al-11IDf6DgRbpk-FU/edit#heading=h.94rqs9slq4zx
DemandStock	other_index_1_id	int4	10	√		null	First sub category for the input data (e.g. housing type)
DemandStock	other_index_2_id	int4	10	√		null	Second sub category for the input data (e.g. housing type)
DemandStock	subsector_id	int4	10				Parent subsector.
DemandStock	time_unit	text	2147483647	√		null	Time unit associated with an input in capacity terms. For example, heating stock may be given in kiloBtu per hour. Hour would be the time unit.
DemandStock	unit	text	2147483647	√		null	Input unit
DemandStockData	demand_technology_id	int4	10	√		null	Technology id for the stock inputs.
DemandStockData	gau_id	int4	10	√		null	This is the id for geographical analysis unit (GAU). If U.S. states was the geography, California would be a GAU.
DemandStockData	id	serial	10		√	nextval('"DemandStockData_id_seq"'::regclass)	Unique id.
DemandStockData	oth_1_id	int4	10	√		null	Member of the first sub category. For example, if housing type was an other index, one member might be single-family homes.
DemandStockData	oth_2_id	int4	10	√		null	Member of the second sub category. For example, if housing type was an other index, one member might be single-family homes.
DemandStockData	subsector_id	int4	10	√		null	Parent subsector id.
DemandStockData	value	float4	8,8	√		null	Input data.
DemandStockData	year	int4	10	√		null	Input year for the data.
DemandStockMeasurePackages	id	serial	10		√	nextval('"DemandStockMeasurePackages_id_seq"'::regclass)
DemandStockMeasurePackages	name	text	2147483647	√		null
DemandStockMeasurePackages	subsector_id	int4	10	√		null
DemandStockMeasurePackagesData	id	serial	10		√	nextval('"DemandStockMeasurePackagesData_id_seq"'::regclass)
DemandStockMeasurePackagesData	measure_id	int4	10	√		null
DemandStockMeasurePackagesData	package_id	int4	10	√		null
DemandStockMeasures	demand_technology_id	int4	10	√		null
DemandStockMeasures	extrapolation_growth	float4	8,8	√		null
DemandStockMeasures	extrapolation_method_id	int4	10	√		null
DemandStockMeasures	geography_id	int4	10	√		null
DemandStockMeasures	id	serial	10		√	nextval('"DemandStockMeasures_id_seq"'::regclass)
DemandStockMeasures	interpolation_method_id	int4	10	√		null
DemandStockMeasures	name	text	2147483647	√		null
DemandStockMeasures	other_index_1_id	int4	10	√		null
DemandStockMeasures	subsector_id	int4	10	√		null
DemandStockMeasuresData	gau_id	int4	10	√		null
DemandStockMeasuresData	id	serial	10		√	nextval('"DemandStockMeasuresData_id_seq"'::regclass)
DemandStockMeasuresData	oth_1_id	int4	10	√		null
DemandStockMeasuresData	parent_id	int4	10	√		null
DemandStockMeasuresData	value	float4	8,8	√		null
DemandStockMeasuresData	year	int4	10	√		null
DemandStockUnitTypes	id	serial	10		√	nextval('"DemandStockUnitTypes_id_seq"'::regclass)
DemandStockUnitTypes	name	text	2147483647
DemandSubsectors	cost_of_capital	float4	8,8	√		null	Cost of capital in the subsector.
DemandSubsectors	id	serial	10		√	nextval('"DemandSubsectors_id_seq"'::regclass)
DemandSubsectors	is_active	bool	1	√		false	Boolean indicating whether to include a subsector in the analysis. Useful for testing.
DemandSubsectors	max_lag_hours	int4	10	√		null	Max lag hours refer to the number of hours that electricity service demand can be delayed in time. At the sector level, this acts as a default value that trickles down to all member subsectors. Note that this flexible load is further moderated by a demand flexible load package that control what percent of total subsector load is flexible year-by-year.
DemandSubsectors	max_lead_hours	int4	10	√		null	Max lead hours refer to the number of hours that electricity service demand can be advanced in time. At the sector level, this acts as a default value that trickles down to all member subsectors. Note that this flexible load is further moderated by a demand flexible load package that control what percent of total subsector load is flexible year-by-year.
DemandSubsectors	name	text	2147483647	√		null
DemandSubsectors	sector_id	int4	10	√		null	Parent sector id.
DemandSubsectors	shape_id	int4	10	√		null	Electricity shape for subsector load used to create aggregate load shapes, bottom up. It is possible to separately specify shapes by technology within a subsector.
DemandTechEfficiencyTypes	id	serial	10		√	nextval('"DemandTechEfficiencyTypes_id_seq"'::regclass)
DemandTechEfficiencyTypes	name	text	2147483647	√		null
DemandTechs	additional_description	text	2147483647	√		null	Further information.
DemandTechs	cost_of_capital	float4	8,8	√		null	Separate cost of capital for the technology.
DemandTechs	demand_tech_unit_type_id	int4	10	√		null	Equipment or service demand.
DemandTechs	id	serial	10		√	nextval('"DemandTechs_id_seq"'::regclass)
DemandTechs	lifetime_variance	float4	8,8	√		null	Lifetime variance technology parameter. The user should either provide the min and max lifetime OR provide the mean and variance lifetime. These parameters are used to create the stock decay functions used in the stock rollover.
DemandTechs	linked_id	int4	10	√		null	When a single technology meets two different service demands across two different subsectors, it is possible to link the stock. One example would be air source heat pumps, which can be both used for heating and for cooling. Installing an air source heat pump gives you an air conditioning unit as a bonus, and we don?t want to two deployed independently. The technology in linked_id will have the total quantity of its stock fixed based on the deployment of the base technology.
DemandTechs	max_lag_hours	int4	10	√		null	Max lag hours refer to the number of hours that electricity service demand can be delayed in time. At the sector level, this acts as a default value that trickles down to all member subsectors. Note that this flexible load is further moderated by a demand flexible load package that control what percent of total subsector load is flexible year-by-year.
DemandTechs	max_lead_hours	int4	10	√		null	Max lead hours refer to the number of hours that electricity service demand can be advanced in time. At the sector level, this acts as a default value that trickles down to all member subsectors. Note that this flexible load is further moderated by a demand flexible load package that control what percent of total subsector load is flexible year-by-year.
DemandTechs	max_lifetime	float4	8,8	√		null	Maximum technology lifetime parameter. The user should either provide the min and max lifetime OR provide the mean and variance lifetime. These parameters are used to create the stock decay functions used in the stock rollover.
DemandTechs	mean_lifetime	float4	8,8	√		null	Mean technology lifetime parameter. The user should either provide the min and max lifetime OR provide the mean and variance lifetime. These parameters are used to create the stock decay functions used in the stock rollover.
DemandTechs	min_lifetime	float4	8,8	√		null	Minimum technology lifetime parameter. The user should either provide the min and max lifetime OR provide the mean and variance lifetime. These parameters are used to create the stock decay functions used in the stock rollover.
DemandTechs	name	text	2147483647	√		null	Technology name.
DemandTechs	shape_id	int4	10	√		null	Electricity consumption shape for the technology. This is used when building an aggregate load shape, bottom up.
DemandTechs	source	text	2147483647	√		null	Source for the technology data.
DemandTechs	stock_decay_function_id	int4	10	√		null	What is the shape of stock decay? Options include weibull, linear, or lump (i.e. step function).
DemandTechs	stock_link_ratio	float4	8,8	√		null	Moderates the degree to which two technologies are linked.
DemandTechs	subsector_id	int4	10	√		null	Subsector where the technology is deployed.
DemandTechs	time_unit	text	2147483647	√		null	If the unit is in energy terms, over what time period is that energy delivered.
DemandTechs	unit	text	2147483647	√		null	E.g. one light bulb, or for a commercial electric boiler two kiloBtu per hour.
DemandTechsAuxEfficiency	age_growth_or_decay	float4	8,8	√		null
DemandTechsAuxEfficiency	age_growth_or_decay_type_id	int4	10	√		null
DemandTechsAuxEfficiency	definition_id	int4	10	√		null
DemandTechsAuxEfficiency	demand_tech_efficiency_types_id	int4	10	√		null
DemandTechsAuxEfficiency	demand_technology_id	int4	10
DemandTechsAuxEfficiency	denominator_unit	text	2147483647	√		null
DemandTechsAuxEfficiency	extrapolation_growth	float4	8,8	√		null
DemandTechsAuxEfficiency	extrapolation_method_id	int4	10	√		null
DemandTechsAuxEfficiency	final_energy_id	int4	10	√		null
DemandTechsAuxEfficiency	geography_id	int4	10	√		null
DemandTechsAuxEfficiency	interpolation_method_id	int4	10	√		null
DemandTechsAuxEfficiency	is_numerator_service	bool	1	√		null
DemandTechsAuxEfficiency	numerator_unit	text	2147483647	√		null
DemandTechsAuxEfficiency	other_index_1_id	int4	10	√		null
DemandTechsAuxEfficiency	other_index_2_id	int4	10	√		null
DemandTechsAuxEfficiency	reference_tech_id	int4	10	√		null
DemandTechsAuxEfficiency	shape_id	int4	10	√		null
DemandTechsAuxEfficiencyData	demand_technology_id	int4	10	√		null
DemandTechsAuxEfficiencyData	gau_id	int4	10	√		null
DemandTechsAuxEfficiencyData	id	serial	10		√	nextval('"DemandTechsAuxEfficiencyData_id_seq"'::regclass)
DemandTechsAuxEfficiencyData	oth_1_id	int4	10	√		null
DemandTechsAuxEfficiencyData	oth_2_id	int4	10	√		null
DemandTechsAuxEfficiencyData	value	float4	8,8	√		null
DemandTechsAuxEfficiencyData	vintage	int4	10	√		null
DemandTechsCapitalCost	currency_id	int4	10	√		null	Input currency.
DemandTechsCapitalCost	currency_year_id	int4	10	√		null	Input currency year.
DemandTechsCapitalCost	definition_id	int4	10	√		null	Either absolute or relative. If relative, a reference_tech_id must be given. In this case, the cost is assumed to be some multiple of a separate technology. For instance, the capital cost for technology X is always 10% higher than reference technology Y.
DemandTechsCapitalCost	demand_technology_id	int4	10				Parent demand tech.
DemandTechsCapitalCost	extrapolation_growth	float4	8,8	√		null	If extrapolation method exponential is used, what is the year over year growth rate?
DemandTechsCapitalCost	extrapolation_method_id	int4	10	√		4	Cleaning method used to extrapolate to missing years when data is entered.
DemandTechsCapitalCost	geography_id	int4	10	√		null	Input geography for the data (e.g. state)
DemandTechsCapitalCost	interpolation_method_id	int4	10	√		1	Cleaning method used to interpolate between missing years when data is entered.
DemandTechsCapitalCost	is_levelized	bool	1	√		false	Is the given capital cost in levelized terms?
DemandTechsCapitalCost	other_index_1_id	int4	10	√		null	First sub category for the input data (e.g. housing type)
DemandTechsCapitalCost	other_index_2_id	int4	10	√		null	Second sub category for the input data (e.g. housing type)
DemandTechsCapitalCost	reference_tech_id	int4	10	√		null	If the input is relative, what technology is used as the reference?
DemandTechsCapitalCostNewData	demand_technology_id	int4	10	√		null
DemandTechsCapitalCostNewData	gau_id	int4	10	√		null
DemandTechsCapitalCostNewData	id	serial	10		√	nextval('"DemandTechsCapitalCostNewData_id_seq"'::regclass)
DemandTechsCapitalCostNewData	oth_1_id	int4	10	√		null
DemandTechsCapitalCostNewData	oth_2_id	int4	10	√		null
DemandTechsCapitalCostNewData	value	float4	8,8	√		null
DemandTechsCapitalCostNewData	vintage	int4	10	√		null
DemandTechsCapitalCostReplacementData	demand_technology_id	int4	10	√		null
DemandTechsCapitalCostReplacementData	gau_id	int4	10	√		null
DemandTechsCapitalCostReplacementData	id	serial	10		√	nextval('"DemandTechsCapitalCostReplacementData_id_seq"'::regclass)
DemandTechsCapitalCostReplacementData	oth_1_id	int4	10	√		null
DemandTechsCapitalCostReplacementData	oth_2_id	int4	10	√		null
DemandTechsCapitalCostReplacementData	value	float4	8,8	√		null
DemandTechsCapitalCostReplacementData	vintage	int4	10	√		null
DemandTechsFixedMaintenanceCost	additional_description	text	2147483647	√		null
DemandTechsFixedMaintenanceCost	age_growth_or_decay	float4	8,8	√		null
DemandTechsFixedMaintenanceCost	age_growth_or_decay_type_id	int4	10	√		null
DemandTechsFixedMaintenanceCost	currency_id	int4	10	√		null
DemandTechsFixedMaintenanceCost	currency_year_id	int4	10	√		null
DemandTechsFixedMaintenanceCost	definition_id	int4	10	√		null
DemandTechsFixedMaintenanceCost	demand_technology_id	int4	10
DemandTechsFixedMaintenanceCost	extrapolation_growth	float4	8,8	√		null
DemandTechsFixedMaintenanceCost	extrapolation_method_id	int4	10	√		null
DemandTechsFixedMaintenanceCost	geography_id	int4	10	√		null
DemandTechsFixedMaintenanceCost	interpolation_method_id	int4	10	√		null
DemandTechsFixedMaintenanceCost	other_index_1_id	int4	10	√		null
DemandTechsFixedMaintenanceCost	other_index_2_id	int4	10	√		null
DemandTechsFixedMaintenanceCost	reference_tech_id	int4	10	√		null
DemandTechsFixedMaintenanceCostData	demand_technology_id	int4	10	√		null
DemandTechsFixedMaintenanceCostData	gau_id	int4	10	√		null
DemandTechsFixedMaintenanceCostData	id	serial	10		√	nextval('"DemandTechsFixedMaintenanceCostData_id_seq"'::regclass)
DemandTechsFixedMaintenanceCostData	oth_1_id	int4	10	√		null
DemandTechsFixedMaintenanceCostData	oth_2_id	int4	10	√		null
DemandTechsFixedMaintenanceCostData	value	float4	8,8	√		null
DemandTechsFixedMaintenanceCostData	vintage	int4	10	√		null
DemandTechsFuelSwitchCost	currency_id	int4	10	√		null
DemandTechsFuelSwitchCost	currency_year_id	int4	10	√		null
DemandTechsFuelSwitchCost	definition_id	int4	10	√		null
DemandTechsFuelSwitchCost	demand_technology_id	int4	10
DemandTechsFuelSwitchCost	extrapolation_growth	float4	8,8	√		null
DemandTechsFuelSwitchCost	extrapolation_method_id	int4	10	√		null
DemandTechsFuelSwitchCost	geography_id	int4	10	√		null
DemandTechsFuelSwitchCost	interpolation_method_id	int4	10	√		null
DemandTechsFuelSwitchCost	is_levelized	bool	1	√		false
DemandTechsFuelSwitchCost	other_index_1_id	int4	10	√		null
DemandTechsFuelSwitchCost	other_index_2_id	int4	10	√		null
DemandTechsFuelSwitchCost	reference_tech_id	int4	10	√		null
DemandTechsFuelSwitchCostData	demand_technology_id	int4	10	√		null
DemandTechsFuelSwitchCostData	gau_id	int4	10	√		null
DemandTechsFuelSwitchCostData	id	serial	10		√	nextval('"DemandTechsFuelSwitchCostData_id_seq"'::regclass)
DemandTechsFuelSwitchCostData	oth_1_id	int4	10	√		null
DemandTechsFuelSwitchCostData	oth_2_id	int4	10	√		null
DemandTechsFuelSwitchCostData	value	float4	8,8	√		null
DemandTechsFuelSwitchCostData	vintage	int4	10	√		null
DemandTechsInstallationCost	currency_id	int4	10	√		null
DemandTechsInstallationCost	currency_year_id	int4	10	√		null
DemandTechsInstallationCost	definition_id	int4	10	√		null
DemandTechsInstallationCost	demand_technology_id	int4	10
DemandTechsInstallationCost	extrapolation_growth	float4	8,8	√		null
DemandTechsInstallationCost	extrapolation_method_id	int4	10	√		null
DemandTechsInstallationCost	geography_id	int4	10	√		null
DemandTechsInstallationCost	interpolation_method_id	int4	10	√		null
DemandTechsInstallationCost	is_levelized	bool	1	√		false
DemandTechsInstallationCost	other_index_1_id	int4	10	√		null
DemandTechsInstallationCost	other_index_2_id	int4	10	√		null
DemandTechsInstallationCost	reference_tech_id	int4	10	√		null
DemandTechsInstallationCostNewData	demand_technology_id	int4	10	√		null
DemandTechsInstallationCostNewData	gau_id	int4	10	√		null
DemandTechsInstallationCostNewData	id	serial	10		√	nextval('"DemandTechsInstallationCostNewData_id_seq"'::regclass)
DemandTechsInstallationCostNewData	oth_1_id	int4	10	√		null
DemandTechsInstallationCostNewData	oth_2_id	int4	10	√		null
DemandTechsInstallationCostNewData	value	float4	8,8	√		null
DemandTechsInstallationCostNewData	vintage	int4	10	√		null
DemandTechsInstallationCostReplacementData	demand_technology_id	int4	10	√		null
DemandTechsInstallationCostReplacementData	gau_id	int4	10	√		null
DemandTechsInstallationCostReplacementData	id	serial	10		√	nextval('"DemandTechsInstallationCostReplacementData_id_seq"'::regclass)
DemandTechsInstallationCostReplacementData	oth_1_id	int4	10	√		null
DemandTechsInstallationCostReplacementData	oth_2_id	int4	10	√		null
DemandTechsInstallationCostReplacementData	value	float4	8,8	√		null
DemandTechsInstallationCostReplacementData	vintage	int4	10	√		null
DemandTechsMainEfficiency	age_growth_or_decay	float4	8,8	√		null
DemandTechsMainEfficiency	age_growth_or_decay_type_id	int4	10	√		null
DemandTechsMainEfficiency	definition_id	int4	10	√		null
DemandTechsMainEfficiency	demand_tech_efficiency_types	int4	10	√		null
DemandTechsMainEfficiency	demand_technology_id	int4	10
DemandTechsMainEfficiency	denominator_unit	text	2147483647	√		null
DemandTechsMainEfficiency	extrapolation_growth	float4	8,8	√		null
DemandTechsMainEfficiency	extrapolation_method_id	int4	10	√		null
DemandTechsMainEfficiency	final_energy_id	int4	10	√		null
DemandTechsMainEfficiency	geography_id	int4	10	√		null
DemandTechsMainEfficiency	interpolation_method_id	int4	10	√		null
DemandTechsMainEfficiency	is_numerator_service	bool	1	√		null
DemandTechsMainEfficiency	numerator_unit	text	2147483647	√		null
DemandTechsMainEfficiency	other_index_1_id	int4	10	√		null
DemandTechsMainEfficiency	other_index_2_id	int4	10	√		null
DemandTechsMainEfficiency	reference_tech_id	int4	10	√		null
DemandTechsMainEfficiency	shape_id	int4	10	√		null
DemandTechsMainEfficiency	utility_factor	float4	8,8	√		null
DemandTechsMainEfficiencyData	demand_technology_id	int4	10	√		null
DemandTechsMainEfficiencyData	gau_id	int4	10	√		null
DemandTechsMainEfficiencyData	id	serial	10		√	nextval('"DemandTechsMainEfficiencyData_id_seq"'::regclass)
DemandTechsMainEfficiencyData	oth_1_id	int4	10	√		null
DemandTechsMainEfficiencyData	oth_2_id	int4	10	√		null
DemandTechsMainEfficiencyData	value	float4	8,8	√		null
DemandTechsMainEfficiencyData	vintage	int4	10	√		null
DemandTechsParasiticEnergy	age_growth_or_decay	float4	8,8	√		null
DemandTechsParasiticEnergy	age_growth_or_decay_type_id	int4	10	√		null
DemandTechsParasiticEnergy	definition_id	int4	10	√		null
DemandTechsParasiticEnergy	demand_technology_id	int4	10
DemandTechsParasiticEnergy	energy_unit	text	2147483647	√		null
DemandTechsParasiticEnergy	extrapolation_growth	float4	8,8	√		null
DemandTechsParasiticEnergy	extrapolation_method_id	int4	10	√		null
DemandTechsParasiticEnergy	geography_id	int4	10	√		null
DemandTechsParasiticEnergy	interpolation_method_id	int4	10	√		null
DemandTechsParasiticEnergy	other_index_1_id	int4	10	√		null
DemandTechsParasiticEnergy	other_index_2_id	int4	10	√		null
DemandTechsParasiticEnergy	reference_tech_id	int4	10	√		null
DemandTechsParasiticEnergy	time_unit	text	2147483647	√		null
DemandTechsParasiticEnergyData	demand_technology_id	int4	10	√		null
DemandTechsParasiticEnergyData	final_energy_id	int4	10	√		null
DemandTechsParasiticEnergyData	gau_id	int4	10	√		null
DemandTechsParasiticEnergyData	id	serial	10		√	nextval('"DemandTechsParasiticEnergyData_id_seq"'::regclass)
DemandTechsParasiticEnergyData	oth_1_id	int4	10	√		null
DemandTechsParasiticEnergyData	oth_2_id	int4	10	√		null
DemandTechsParasiticEnergyData	value	float4	8,8	√		null
DemandTechsParasiticEnergyData	vintage	int4	10	√		null
DemandTechsServiceDemandModifier	age_growth_or_decay	float4	8,8	√		null
DemandTechsServiceDemandModifier	age_growth_or_decay_type_id	int4	10	√		null
DemandTechsServiceDemandModifier	demand_technology_id	int4	10
DemandTechsServiceDemandModifier	extrapolation_growth	float4	8,8	√		null
DemandTechsServiceDemandModifier	extrapolation_method_id	int4	10	√		null
DemandTechsServiceDemandModifier	geography_id	int4	10	√		null
DemandTechsServiceDemandModifier	interpolation_method_id	int4	10	√		null
DemandTechsServiceDemandModifier	other_index_1_id	int4	10	√		null
DemandTechsServiceDemandModifier	other_index_2_id	int4	10	√		null
DemandTechsServiceDemandModifierData	demand_technology_id	int4	10	√		null
DemandTechsServiceDemandModifierData	gau_id	int4	10	√		null
DemandTechsServiceDemandModifierData	id	serial	10		√	nextval('"DemandTechsServiceDemandModifierData_id_seq"'::regclass)
DemandTechsServiceDemandModifierData	oth_1_id	int4	10	√		null
DemandTechsServiceDemandModifierData	oth_2_id	int4	10	√		null
DemandTechsServiceDemandModifierData	value	float4	8,8	√		null
DemandTechsServiceDemandModifierData	vintage	int4	10	√		null
DemandTechsServiceLink	age_growth_or_decay	float4	8,8	√		null
DemandTechsServiceLink	age_growth_or_decay_type_id	int4	10	√		null
DemandTechsServiceLink	definition_id	int4	10	√		null
DemandTechsServiceLink	demand_technology_id	int4	10	√		null
DemandTechsServiceLink	extrapolation_growth	float4	8,8	√		null
DemandTechsServiceLink	extrapolation_method_id	int4	10	√		null
DemandTechsServiceLink	geography_id	int4	10	√		null
DemandTechsServiceLink	id	serial	10		√	nextval('"DemandTechsServiceLink_id_seq"'::regclass)
DemandTechsServiceLink	interpolation_method_id	int4	10	√		null
DemandTechsServiceLink	other_index_1_id	int4	10	√		null
DemandTechsServiceLink	other_index_2_id	int4	10	√		null
DemandTechsServiceLink	reference_id	int4	10	√		null
DemandTechsServiceLink	service_link_id	int4	10	√		null
DemandTechsServiceLinkData	gau_id	int4	10	√		null
DemandTechsServiceLinkData	id	serial	10		√	nextval('"DemandTechsServiceLinkData_id_seq"'::regclass)
DemandTechsServiceLinkData	oth_1_id	int4	10	√		null
DemandTechsServiceLinkData	oth_2_id	int4	10	√		null
DemandTechsServiceLinkData	parent_id	int4	10	√		null
DemandTechsServiceLinkData	value	float4	8,8	√		null
DemandTechsServiceLinkData	vintage	int4	10	√		null
DemandTechUnitTypes	id	serial	10		√	nextval('"DemandTechUnitTypes_id_seq"'::regclass)
DemandTechUnitTypes	name	text	2147483647	√		null
DispatchConfig	distribution_grid_node_id	int4	10	√		null
DispatchConfig	distribution_node_id	int4	10	√		null
DispatchConfig	flex_load_constraints_offset	int4	10	√		null
DispatchConfig	geography_id	int4	10	√		null
DispatchConfig	id	int4	10
DispatchConfig	large_storage_duration	int4	10	√		null
DispatchConfig	thermal_dispatch_node_id	int4	10	√		null
DispatchConfig	transmission_node_id	int4	10	√		null
DispatchConstraintTypes	id	bigserial	19		√	nextval('"DispatchConstraintTypes_id_seq"'::regclass)
DispatchConstraintTypes	name	text	2147483647	√		null
DispatchFeeders	id	int4	10
DispatchFeeders	name	text	2147483647
DispatchFeedersAllocation	extrapolation_method_id	int4	10	√		null
DispatchFeedersAllocation	geography_id	int4	10	√		null
DispatchFeedersAllocation	geography_map_key_id	int4	10	√		null
DispatchFeedersAllocation	id	serial	10		√	nextval('"DispatchFeedersAllocation_id_seq"'::regclass)
DispatchFeedersAllocation	input_type_id	int4	10	√		null
DispatchFeedersAllocation	interpolation_method_id	int4	10	√		null
DispatchFeedersAllocationData	demand_sector_id	int4	10	√		null
DispatchFeedersAllocationData	dispatch_feeder_id	int4	10	√		null
DispatchFeedersAllocationData	gau_id	int4	10	√		null
DispatchFeedersAllocationData	id	serial	10		√	nextval('"DispatchFeedersAllocationData_id_seq"'::regclass)
DispatchFeedersAllocationData	parent_id	int4	10	√		null
DispatchFeedersAllocationData	value	float8	17,17	√		null
DispatchFeedersAllocationData	year	int4	10	√		null
DispatchNodeConfig	dispatch_order	int4	10
DispatchNodeConfig	dispatch_window_id	int4	10	√		null
DispatchNodeConfig	geography_id	int4	10	√		null
DispatchNodeConfig	supply_node_id	int4	10
DispatchNodeData	day	int4	10	√		null
DispatchNodeData	energy_budget	float8	17,17	√		null
DispatchNodeData	gau_id	int4	10	√		null
DispatchNodeData	id	serial	10		√	nextval('"DispatchNodeData_id_seq"'::regclass)
DispatchNodeData	month	int4	10	√		null
DispatchNodeData	p_max	float8	17,17	√		null
DispatchNodeData	p_min	float8	17,17	√		null
DispatchNodeData	supply_node_id	int4	10	√		null
DispatchNodeData	week	int4	10	√		null
DispatchWindows	id	serial	10		√	nextval('"DispatchWindows_id_seq"'::regclass)
DispatchWindows	name	text	2147483647
EfficiencyTypes	id	serial	10		√	nextval('"EfficiencyTypes_id_seq"'::regclass)
EfficiencyTypes	name	text	2147483647	√		null
EnergyDemand	final Energy	text	2147483647	√		null
EnergyDemand	final_energy_id	int4	10	√		null
EnergyDemand	oth_1_id	int4	10	√		null
EnergyDemand	oth_2_id	int4	10	√		null
EnergyDemand	Other Index 1	text	2147483647	√		null
EnergyDemand	Other Index 2	text	2147483647	√		null
EnergyDemand	Subsector	text	2147483647	√		null
EnergyDemand	subsector_id	int4	10	√		null
EnergyDemandData0Index	final Energy	text	2147483647	√		null
EnergyDemandData0Index	final_energy_id	int4	10	√		null
EnergyDemandData0Index	oth_1_id	int4	10	√		null
EnergyDemandData0Index	oth_2_id	int4	10	√		null
EnergyDemandData0Index	Subsector	text	2147483647	√		null
EnergyDemandData0Index	subsector_id	int4	10	√		null
EnergyDemandData1Index	final Energy	text	2147483647	√		null
EnergyDemandData1Index	final_energy_id	int4	10	√		null
EnergyDemandData1Index	oth_1_id	int4	10	√		null
EnergyDemandData1Index	oth_2_id	int4	10	√		null
EnergyDemandData1Index	Other Index 1	text	2147483647	√		null
EnergyDemandData1Index	Subsector	text	2147483647	√		null
EnergyDemandData1Index	subsector_id	int4	10	√		null
FinalEnergy	id	serial	10		√	nextval('"FinalEnergy_id_seq"'::regclass)
FinalEnergy	name	text	2147483647	√		null
FinalEnergy	shape_id	int4	10	√		null
FlexibleLoadShiftTypes	id	int4	10
FlexibleLoadShiftTypes	name	text	2147483647	√		null
Geographies	id	serial	10		√	nextval('"Geographies_id_seq"'::regclass)
Geographies	name	text	2147483647
GeographiesData	geography_id	int4	10	√		null
GeographiesData	id	serial	10		√	nextval('"GeographiesData_id_seq"'::regclass)
GeographiesData	name	text	2147483647	√		null
GeographyIntersection	id	serial	10		√	nextval('"GeographyIntersection_id_seq"'::regclass)
GeographyIntersectionData	gau_id	int4	10
GeographyIntersectionData	id	serial	10		√	nextval('"GeographyIntersectionData_id_seq"'::regclass)
GeographyIntersectionData	intersection_id	int4	10
GeographyMap	geography_map_key_id	int4	10
GeographyMap	id	serial	10		√	nextval('"GeographyMap_id_seq"'::regclass)
GeographyMap	intersection_id	int4	10
GeographyMap	value	float8	17,17	√		null
GeographyMapKeys	id	serial	10		√	nextval('"GeographyMapKeys_id_seq"'::regclass)
GeographyMapKeys	name	text	2147483647
GreenhouseGasEmissionsType	id	serial	10		√	nextval('"GreenhouseGasEmissionsType_id_seq"'::regclass)
GreenhouseGasEmissionsType	name	text	2147483647
GreenhouseGases	id	serial	10		√	nextval('"GreenhouseGases_id_seq"'::regclass)
GreenhouseGases	long_name	text	2147483647	√		null
GreenhouseGases	name	text	2147483647	√		null
IDMap	identifier_id	text	2147483647
IDMap	ref_table	text	2147483647	√		null
ImportCost	currency_id	int4	10	√		null
ImportCost	currency_year_id	int4	10	√		null
ImportCost	denominator_unit	text	2147483647	√		null
ImportCost	extrapolation_growth	float4	8,8	√		null
ImportCost	extrapolation_method_id	int4	10	√		null
ImportCost	geography_id	int4	10	√		null
ImportCost	import_node_id	int4	10
ImportCost	interpolation_method_id	int4	10	√		null
ImportCost	notes	text	2147483647	√		null
ImportCost	source	text	2147483647	√		null
ImportCostData	demand_sector_id	int4	10	√		null
ImportCostData	gau_id	int4	10	√		null
ImportCostData	id	serial	10		√	nextval('"ImportCostData_id_seq"'::regclass)
ImportCostData	import_node_id	int4	10	√		null
ImportCostData	value	float8	17,17	√		null
ImportCostData	year	int4	10	√		null
IndexLevels	data_column_name	text	2147483647	√		null
IndexLevels	id	serial	10		√	nextval('"IndexLevels_id_seq"'::regclass)
IndexLevels	index_level	text	2147483647	√		null
InflationConversion	currency_id	int4	10	√		null
InflationConversion	currency_year_id	int4	10	√		null
InflationConversion	id	serial	10		√	nextval('"InflationConversion_id_seq"'::regclass)
InflationConversion	value	float8	17,17	√		null
InputTypes	id	serial	10		√	nextval('"InputTypes_id_seq"'::regclass)
InputTypes	name	text	2147483647
OtherIndexes	id	serial	10		√	nextval('"OtherIndexes_id_seq"'::regclass)
OtherIndexes	name	text	2147483647	√		null
OtherIndexesData	id	serial	10		√	nextval('"OtherIndexesData_id_seq"'::regclass)
OtherIndexesData	name	text	2147483647	√		null
OtherIndexesData	other_index_id	int4	10	√		null
OtherIndexesData_copy	id	serial	10		√	nextval('"OtherIndexesData_id_seq"'::regclass)
OtherIndexesData_copy	name	text	2147483647	√		null
OtherIndexesData_copy	other_index_id	int4	10	√		null
OthIndex	name	text	2147483647	√		null
OthIndex	OtherIndexName	text	2147483647	√		null
PrimaryCost	currency_id	int4	10	√		null
PrimaryCost	currency_year_id	int4	10	√		null
PrimaryCost	denominator_unit	text	2147483647	√		null
PrimaryCost	extrapolation_growth	float4	8,8	√		null
PrimaryCost	extrapolation_method_id	int4	10	√		null
PrimaryCost	geography_id	int4	10	√		null
PrimaryCost	interpolation_method_id	int4	10	√		null
PrimaryCost	other_index_1_id	int4	10	√		null
PrimaryCost	primary_node_id	int4	10
PrimaryCostData	demand_sector_id	int4	10	√		null
PrimaryCostData	gau_id	int4	10	√		null
PrimaryCostData	id	serial	10		√	nextval('"PrimaryCostData_id_seq"'::regclass)
PrimaryCostData	oth_1_id	int4	10	√		null
PrimaryCostData	primary_node_id	int4	10	√		null
PrimaryCostData	resource_bin	int4	10	√		null
PrimaryCostData	value	float8	17,17	√		null
PrimaryCostData	year	int4	10	√		null
SalesMeasureNameTech	demand_technology_id	int4	10	√		null
SalesMeasureNameTech	id	int4	10	√		null
SalesMeasureNameTech	name	text	2147483647	√		null
SalesMeasureNameTech	value	float4	8,8	√		null
SalesMeasureNameTech	vintage	int4	10	√		null
SalesMeasureReplacedTech	demand_technology_id	int4	10	√		null
SalesMeasureReplacedTech	id	int4	10	√		null
SalesMeasureReplacedTech	name	text	2147483647	√		null
SalesMeasureReplacedTech	value	float4	8,8	√		null
SalesMeasureReplacedTech	vintage	int4	10	√		null
Scenarios	demand_case	int4	10	√		null
Scenarios	description	text	2147483647	√		null
Scenarios	id	serial	10		√	nextval('"Scenarios_id_seq"'::regclass)
Scenarios	name	text	2147483647	√		null
Scenarios	supply_case	int4	10	√		null
Scenarios	user_id	int4	10	√		null
Shapes	extrapolation_method_id	int4	10	√		null
Shapes	geography_id	int4	10	√		null
Shapes	geography_map_key_id	int4	10	√		null
Shapes	id	serial	10		√	nextval('"Shapes_id_seq"'::regclass)
Shapes	input_type_id	int4	10	√		null
Shapes	interpolation_method_id	int4	10	√		null
Shapes	name	text	2147483647	√		null
Shapes	other_index_1_id	int4	10	√		null
Shapes	other_index_2_id	int4	10	√		null
Shapes	shape_type_id	int4	10	√		null
Shapes	shape_unit_type_id	int4	10	√		null
Shapes	time_zone_id	int4	10	√		null
ShapesData	day_type_id	int4	10	√		null
ShapesData	dispatch_constraint_id	int4	10	√		null
ShapesData	dispatch_feeder_id	int4	10	√		null
ShapesData	gau_id	int4	10	√		null
ShapesData	hour	int4	10	√		null
ShapesData	id	serial	10		√	nextval('"ShapesData_id_seq"'::regclass)
ShapesData	month	int4	10	√		null
ShapesData	parent_id	int4	10	√		null
ShapesData	resource_bin	int4	10	√		null
ShapesData	timeshift_type_id	int4	10	√		null
ShapesData	value	float4	8,8	√		null
ShapesData	weather_datetime	text	2147483647	√		null
ShapesData	week	int4	10	√		null
ShapesData	year	int4	10	√		null
ShapesTypes	id	serial	10		√	nextval('"ShapesTypes_id_seq"'::regclass)
ShapesTypes	name	text	2147483647	√		null
ShapesUnits	id	serial	10		√	nextval('"ShapesUnits_id_seq"'::regclass)
ShapesUnits	name	text	2147483647	√		null
StockDecayFunctions	id	serial	10		√	nextval('"StockDecayFunctions_id_seq"'::regclass)
StockDecayFunctions	name	text	2147483647	√		null
StorageTechsCapacityCapitalCost	capacity_or_energy_unit	text	2147483647	√		null
StorageTechsCapacityCapitalCost	cost_of_capital	float8	17,17	√		null
StorageTechsCapacityCapitalCost	currency_id	int4	10	√		null
StorageTechsCapacityCapitalCost	currency_year_id	int4	10	√		null
StorageTechsCapacityCapitalCost	definition_id	int4	10	√		null
StorageTechsCapacityCapitalCost	extrapolation_method_id	int4	10	√		null
StorageTechsCapacityCapitalCost	geography_id	int4	10	√		null
StorageTechsCapacityCapitalCost	interpolation_method_id	int4	10	√		null
StorageTechsCapacityCapitalCost	is_levelized	bool	1	√		null
StorageTechsCapacityCapitalCost	reference_tech_id	int4	10	√		null
StorageTechsCapacityCapitalCost	supply_tech_id	int4	10
StorageTechsCapacityCapitalCost	time_unit	int4	10	√		null
StorageTechsCapacityCapitalCostNewData	gau_id	int4	10	√		null
StorageTechsCapacityCapitalCostNewData	id	serial	10		√	nextval('"StorageTechsCapacityCapitalCostNewData_id_seq"'::regclass)
StorageTechsCapacityCapitalCostNewData	oth_1_id	int4	10	√		null
StorageTechsCapacityCapitalCostNewData	oth_2_id	int4	10	√		null
StorageTechsCapacityCapitalCostNewData	supply_tech_id	int4	10
StorageTechsCapacityCapitalCostNewData	value	float4	8,8	√		null
StorageTechsCapacityCapitalCostNewData	vintage	int4	10	√		null
StorageTechsCapacityCapitalCostReplacementData	gau_id	int4	10	√		null
StorageTechsCapacityCapitalCostReplacementData	oth_1_id	int4	10	√		null
StorageTechsCapacityCapitalCostReplacementData	oth_2_id	int4	10	√		null
StorageTechsCapacityCapitalCostReplacementData	supply_tech_id	int4	10
StorageTechsCapacityCapitalCostReplacementData	value	float4	8,8	√		null
StorageTechsCapacityCapitalCostReplacementData	vintage	int4	10	√		null
StorageTechsEnergyCapitalCost	cost_of_capital	float8	17,17	√		null
StorageTechsEnergyCapitalCost	currency_id	int4	10	√		null
StorageTechsEnergyCapitalCost	currency_year_id	int4	10	√		null
StorageTechsEnergyCapitalCost	definition_id	int4	10	√		null
StorageTechsEnergyCapitalCost	energy_unit	text	2147483647	√		null
StorageTechsEnergyCapitalCost	extrapolation_method_id	int4	10	√		null
StorageTechsEnergyCapitalCost	geography_id	int4	10	√		null
StorageTechsEnergyCapitalCost	interpolation_method_id	int4	10	√		null
StorageTechsEnergyCapitalCost	is_levelized	bool	1	√		null
StorageTechsEnergyCapitalCost	reference_tech_id	int4	10	√		null
StorageTechsEnergyCapitalCost	supply_tech_id	int4	10
StorageTechsEnergyCapitalCostNewData	gau_id	int4	10	√		null
StorageTechsEnergyCapitalCostNewData	id	serial	10		√	nextval('"StorageTechsEnergyCapitalCostNewData_id_seq"'::regclass)
StorageTechsEnergyCapitalCostNewData	oth_1_id	int4	10	√		null
StorageTechsEnergyCapitalCostNewData	oth_2_id	int4	10	√		null
StorageTechsEnergyCapitalCostNewData	supply_tech_id	int4	10	√		null
StorageTechsEnergyCapitalCostNewData	value	float4	8,8	√		null
StorageTechsEnergyCapitalCostNewData	vintage	int4	10	√		null
StorageTechsEnergyCapitalCostReplacementData	gau_id	int4	10	√		null
StorageTechsEnergyCapitalCostReplacementData	id	serial	10		√	nextval('"StorageTechsEnergyCapitalCostReplacementData_id_seq"'::regclass)
StorageTechsEnergyCapitalCostReplacementData	oth_1_id	int4	10	√		null
StorageTechsEnergyCapitalCostReplacementData	oth_2_id	int4	10	√		null
StorageTechsEnergyCapitalCostReplacementData	supply_tech_id	int4	10	√		null
StorageTechsEnergyCapitalCostReplacementData	value	float4	8,8	√		null
StorageTechsEnergyCapitalCostReplacementData	vintage	int4	10	√		null
SupplyCapacityFactor	age_growth_or_decay	float4	8,8	√		null
SupplyCapacityFactor	age_growth_or_decay_type_id	int4	10	√		null
SupplyCapacityFactor	extrapolation_growth	float4	8,8	√		null
SupplyCapacityFactor	extrapolation_method	int4	10	√		null
SupplyCapacityFactor	geography_id	int4	10	√		null
SupplyCapacityFactor	interpolation_method	int4	10	√		null
SupplyCapacityFactor	supply_node_id	int4	10
SupplyCapacityFactor	unit	text	2147483647	√		null
SupplyCapacityFactorData	demand_sector_id	int4	10	√		null
SupplyCapacityFactorData	gau_id	int4	10	√		null
SupplyCapacityFactorData	id	serial	10		√	nextval('"SupplyCapacityFactorData_id_seq"'::regclass)
SupplyCapacityFactorData	resource_bin	int4	10	√		null
SupplyCapacityFactorData	supply_node_id	int4	10	√		null
SupplyCapacityFactorData	value	float8	17,17	√		null
SupplyCapacityFactorData	year	int4	10	√		null
SupplyCases	id	serial	10		√	nextval('"SupplyCases_id_seq"'::regclass)
SupplyCases	name	text	2147483647	√		null
SupplyCasesData	supply_case_id	int4	10
SupplyCasesData	supply_state_id	int4	10
SupplyCost	additional_notes	text	2147483647	√		null
SupplyCost	book_life	int4	10	√		null
SupplyCost	cost_of_capital	float4	8,8	√		null
SupplyCost	currency_id	int4	10	√		null
SupplyCost	currency_year_id	int4	10	√		null
SupplyCost	energy_or_capacity_unit	text	2147483647	√		null
SupplyCost	extrapolation_growth	float4	8,8	√		null
SupplyCost	extrapolation_method_id	int4	10	√		null
SupplyCost	geography_id	int4	10	√		null
SupplyCost	id	serial	10		√	nextval('"SupplyCost_id_seq"'::regclass)
SupplyCost	interpolation_method_id	int4	10	√		null
SupplyCost	is_capital_cost	bool	1	√		false
SupplyCost	name	text	2147483647	√		null
SupplyCost	source	text	2147483647	√		null
SupplyCost	supply_cost_type_id	int4	10	√		null
SupplyCost	supply_node_id	int4	10	√		null
SupplyCost	throughput_correlation	float8	17,17	√		null
SupplyCost	time_unit	text	2147483647	√		null
SupplyCostData	demand_sector_id	int4	10	√		null
SupplyCostData	gau_id	int4	10	√		null
SupplyCostData	id	serial	10		√	nextval('"SupplyCostData_id_seq"'::regclass)
SupplyCostData	parent_id	int4	10	√		null
SupplyCostData	resource_bin	int4	10	√		null
SupplyCostData	value	float8	17,17	√		null
SupplyCostData	year	int4	10	√		null
SupplyCostTypes	id	serial	10		√	nextval('"SupplyCostTypes_id_seq"'::regclass)
SupplyCostTypes	name	text	2147483647	√		null
SupplyEfficiency	extrapolation_growth	float4	8,8	√		null
SupplyEfficiency	extrapolation_method_id	int4	10	√		null
SupplyEfficiency	geography_id	int4	10	√		null
SupplyEfficiency	id	int4	10
SupplyEfficiency	input_unit	text	2147483647	√		null
SupplyEfficiency	interpolation_method_id	int4	10	√		null
SupplyEfficiency	notes	text	2147483647	√		null
SupplyEfficiency	output_unit	text	2147483647	√		null
SupplyEfficiency	source	text	2147483647	√		null
SupplyEfficiencyData	demand_sector_id	int4	10	√		null
SupplyEfficiencyData	efficiency_type_id	int4	10	√		null
SupplyEfficiencyData	gau_id	int4	10	√		null
SupplyEfficiencyData	id	serial	10		√	nextval('"SupplyEfficiencyData_id_seq"'::regclass)
SupplyEfficiencyData	parent_id	int4	10	√		null
SupplyEfficiencyData	resource_bin	int4	10	√		null
SupplyEfficiencyData	supply_node_id	int4	10	√		null
SupplyEfficiencyData	value	float8	17,17	√		null
SupplyEfficiencyData	year	int4	10	√		null
SupplyEmissions	denominator_unit	text	2147483647	√		null
SupplyEmissions	extrapolation_growth	float4	8,8	√		null
SupplyEmissions	extrapolation_method_id	int4	10	√		null
SupplyEmissions	geography_id	int4	10	√		null
SupplyEmissions	interpolation_method_id	int4	10	√		null
SupplyEmissions	mass_unit	text	2147483647	√		null
SupplyEmissions	notes	text	2147483647	√		null
SupplyEmissions	other_index_1_id	int4	10	√		null
SupplyEmissions	source	text	2147483647	√		null
SupplyEmissions	supply_node_id	int4	10
SupplyEmissionsData	demand_sector_id	int4	10	√		null
SupplyEmissionsData	gau_id	int4	10	√		null
SupplyEmissionsData	ghg_id	int4	10	√		null
SupplyEmissionsData	ghg_type_id	int4	10	√		null
SupplyEmissionsData	id	serial	10		√	nextval('"PrimaryEmissionsData_id_seq"'::regclass)
SupplyEmissionsData	oth_1_id	int4	10	√		null
SupplyEmissionsData	supply_node_id	int4	10	√		null
SupplyEmissionsData	value	float8	17,17	√		null
SupplyEmissionsData	year	int4	10	√		null
SupplyExport	extrapolation_growth	float4	8,8	√		null
SupplyExport	extrapolation_method_id	int4	10	√		null
SupplyExport	geography_id	int4	10	√		null
SupplyExport	interpolation_method_id	int4	10	√		null
SupplyExport	oth_index_1_id	int4	10	√		null
SupplyExport	supply_node_id	int4	10
SupplyExport	unit	text	2147483647	√		null
SupplyExportData	gau_id	int4	10	√		null
SupplyExportData	id	serial	10		√	nextval('"SupplyExportData_id_seq"'::regclass)
SupplyExportData	oth_1_id	int4	10	√		null
SupplyExportData	resource_bin	int4	10	√		null
SupplyExportData	supply_node_id	int4	10	√		null
SupplyExportData	value	float8	17,17	√		null
SupplyExportData	year	int4	10	√		null
SupplyExportMeasurePackages	id	serial	10		√	nextval('"SupplyExportMeasurePackages_id_seq"'::regclass)
SupplyExportMeasurePackages	name	text	2147483647	√		null
SupplyExportMeasurePackages	supply_node_id	int4	10	√		null
SupplyExportMeasurePackagesData	id	serial	10		√	nextval('"SupplyExportMeasurePackagesData_id_seq"'::regclass)
SupplyExportMeasurePackagesData	measure_id	int4	10	√		null
SupplyExportMeasurePackagesData	package_id	int4	10	√		null
SupplyExportMeasures	extrapolation_method_id	int4	10	√		null
SupplyExportMeasures	geography_id	int4	10	√		null
SupplyExportMeasures	id	serial	10		√	nextval('"SupplyExportMeasures_id_seq"'::regclass)
SupplyExportMeasures	interpolation_method_id	int4	10	√		null
SupplyExportMeasures	name	text	2147483647	√		null
SupplyExportMeasures	other_index_1_id	int4	10	√		null
SupplyExportMeasures	supply_node_id	int4	10	√		null
SupplyExportMeasures	unit	text	2147483647	√		null
SupplyExportMeasuresData	gau_id	int4	10	√		null
SupplyExportMeasuresData	id	serial	10		√	nextval('"SupplyExportMeasuresData_id_seq"'::regclass)
SupplyExportMeasuresData	oth_1_id	int4	10	√		null
SupplyExportMeasuresData	parent_id	int4	10	√		null
SupplyExportMeasuresData	value	float4	8,8	√		null
SupplyExportMeasuresData	year	int4	10	√		null
SupplyNodes	book_life	int4	10	√		null
SupplyNodes	cost_of_capital	float4	8,8	√		null
SupplyNodes	enforce_potential_constraint	bool	1	√		null
SupplyNodes	final_energy_link	int4	10	√		null
SupplyNodes	geography_map_key_id	int4	10	√		null
SupplyNodes	id	serial	10		√	nextval('"SupplyNodes_id_seq"'::regclass)
SupplyNodes	is_active	bool	1	√		null
SupplyNodes	is_curtailable	int4	10	√		null
SupplyNodes	is_exportable	int4	10	√		null
SupplyNodes	is_flexible	int4	10	√		null
SupplyNodes	lifetime_variance	float4	8,8	√		null
SupplyNodes	max_lag_hours	int4	10	√		null
SupplyNodes	max_lead_hours	int4	10	√		null
SupplyNodes	max_lifetime	float4	8,8	√		null
SupplyNodes	mean_lifetime	float4	8,8	√		null
SupplyNodes	min_lifetime	float4	8,8	√		null
SupplyNodes	name	text	2147483647	√		null
SupplyNodes	residual_supply_node_id	int4	10	√		null
SupplyNodes	shape_id	int4	10	√		null
SupplyNodes	stock_decay_function_id	int4	10	√		null
SupplyNodes	supply_type_id	int4	10	√		null
SupplyNodes	tradable_geography_id	int4	10	√		null
SupplyPotential	extrapolation_method_growth	float4	8,8	√		null
SupplyPotential	extrapolation_method_id	int4	10	√		null
SupplyPotential	geography_id	int4	10	√		null
SupplyPotential	geography_map_key_id	int4	10	√		null
SupplyPotential	interpolation_method_id	int4	10	√		null
SupplyPotential	other_index_1_id	int4	10	√		null
SupplyPotential	supply_node_id	int4	10
SupplyPotential	time_unit	int4	10	√		null
SupplyPotential	unit	text	2147483647	√		null
SupplyPotentialConversion	energy_unit_numerator	text	2147483647	√		null
SupplyPotentialConversion	extrapolation_growth	float4	8,8	√		null
SupplyPotentialConversion	extrapolation_method_id	int4	10	√		null
SupplyPotentialConversion	geography_id	int4	10	√		null
SupplyPotentialConversion	interpolation_method_id	int4	10	√		null
SupplyPotentialConversion	other_index_1_id	int4	10	√		null
SupplyPotentialConversion	resource_unit_denominator	text	2147483647	√		null
SupplyPotentialConversion	supply_node_id	int4	10
SupplyPotentialConversionData	gau_id	int4	10	√		null
SupplyPotentialConversionData	id	serial	10		√	nextval('"PrimaryPotentialConversionData_id_seq"'::regclass)
SupplyPotentialConversionData	oth_1_id	int4	10	√		null
SupplyPotentialConversionData	resource_bin	int4	10	√		null
SupplyPotentialConversionData	supply_node_id	int4	10	√		null
SupplyPotentialConversionData	value	float8	17,17	√		null
SupplyPotentialConversionData	year	int4	10	√		null
SupplyPotentialData	demand_sector_id	int4	10	√		null
SupplyPotentialData	gau_id	int4	10	√		null
SupplyPotentialData	id	serial	10		√	nextval('"SupplyPotentialData_id_seq"'::regclass)
SupplyPotentialData	oth_1_id	int4	10	√		null
SupplyPotentialData	resource_bin	int4	10	√		null
SupplyPotentialData	supply_node_id	int4	10	√		null
SupplyPotentialData	value	float8	17,17	√		null
SupplyPotentialData	year	int4	10	√		null
SupplySales	capacity_or_energy_unit	text	2147483647	√		null
SupplySales	extrapolation_growth	float4	8,8	√		null
SupplySales	extrapolation_method	int4	10	√		null
SupplySales	geography_id	int4	10	√		null
SupplySales	geography_map_key_id	int4	10	√		null
SupplySales	interpolation_method	int4	10	√		null
SupplySales	supply_node_id	int4	10
SupplySales	time_unit	text	2147483647	√		null
SupplySalesData	demand_sector_id	int4	10	√		null
SupplySalesData	gau_id	int4	10	√		null
SupplySalesData	id	serial	10		√	nextval('"SupplySalesData_id_seq"'::regclass)
SupplySalesData	resource_bin	int4	10	√		null
SupplySalesData	supply_node_id	int4	10	√		null
SupplySalesData	supply_technology_id	int4	10	√		null
SupplySalesData	value	float8	17,17	√		null
SupplySalesData	vintage	int4	10	√		null
SupplySalesMeasurePackages	id	serial	10		√	nextval('"SupplySalesMeasurePackages_id_seq"'::regclass)
SupplySalesMeasurePackages	name	text	2147483647	√		null
SupplySalesMeasurePackages	supply_node_id	int4	10	√		null
SupplySalesMeasurePackagesData	id	serial	10		√	nextval('"SupplySalesMeasurePackagesData_id_seq"'::regclass)
SupplySalesMeasurePackagesData	measure_id	int4	10	√		null
SupplySalesMeasurePackagesData	package_id	int4	10	√		null
SupplySalesMeasures	extrapolation_growth	float4	8,8	√		null
SupplySalesMeasures	extrapolation_method_id	int4	10	√		null
SupplySalesMeasures	geography_id	int4	10	√		null
SupplySalesMeasures	geography_map_key_id	int4	10	√		null
SupplySalesMeasures	id	serial	10		√	nextval('"SupplySalesMeasures_id_seq"'::regclass)
SupplySalesMeasures	interpolation_method_id	int4	10	√		null
SupplySalesMeasures	name	text	2147483647	√		null
SupplySalesMeasures	other_index_1_id	int4	10	√		null
SupplySalesMeasures	supply_node_id	int4	10	√		null
SupplySalesMeasures	supply_technology_id	int4	10	√		null
SupplySalesMeasuresData	demand_sector_id	int4	10	√		null
SupplySalesMeasuresData	gau_id	int4	10	√		null
SupplySalesMeasuresData	id	serial	10		√	nextval('"SupplySalesMeasuresData_id_seq"'::regclass)
SupplySalesMeasuresData	oth_1_id	int4	10	√		null
SupplySalesMeasuresData	parent_id	int4	10	√		null
SupplySalesMeasuresData	resource_bin	int4	10	√		null
SupplySalesMeasuresData	value	float8	17,17	√		null
SupplySalesMeasuresData	vintage	int4	10	√		null
SupplySalesShare	extrapolation_growth	float4	8,8	√		null
SupplySalesShare	extrapolation_method	int4	10	√		null
SupplySalesShare	geography_id	int4	10	√		null
SupplySalesShare	interpolation_method	int4	10	√		null
SupplySalesShare	supply_node_id	int4	10
SupplySalesShareData	demand_sector_id	int4	10	√		null
SupplySalesShareData	gau_id	int4	10	√		null
SupplySalesShareData	id	serial	10		√	nextval('"SupplySalesShareData_id_seq"'::regclass)
SupplySalesShareData	supply_node_id	int4	10	√		null
SupplySalesShareData	supply_technology_id	int4	10	√		null
SupplySalesShareData	value	float8	17,17	√		null
SupplySalesShareData	vintage	int4	10	√		null
SupplySalesShareMeasurePackages	id	serial	10		√	nextval('"SupplySalesShareMeasurePackages_id_seq"'::regclass)
SupplySalesShareMeasurePackages	name	text	2147483647	√		null
SupplySalesShareMeasurePackages	supply_node_id	int4	10	√		null
SupplySalesShareMeasurePackagesData	id	serial	10		√	nextval('"SupplySalesShareMeasurePackagesData_id_seq"'::regclass)
SupplySalesShareMeasurePackagesData	measure_id	int4	10	√		null
SupplySalesShareMeasurePackagesData	package_id	int4	10	√		null
SupplySalesShareMeasures	capacity_or_energy_unit	text	2147483647	√		null
SupplySalesShareMeasures	extrapolation_growth	float4	8,8	√		null
SupplySalesShareMeasures	extrapolation_method_id	int4	10	√		null
SupplySalesShareMeasures	geography_id	int4	10	√		null
SupplySalesShareMeasures	id	serial	10		√	nextval('"SupplySalesShareMeasures_id_seq"'::regclass)
SupplySalesShareMeasures	interpolation_method_id	int4	10	√		null
SupplySalesShareMeasures	name	text	2147483647	√		null
SupplySalesShareMeasures	other_index_1_id	int4	10	√		null
SupplySalesShareMeasures	replaced_supply_technology_id	int4	10	√		null
SupplySalesShareMeasures	supply_node_id	int4	10	√		null
SupplySalesShareMeasures	supply_technology_id	int4	10	√		null
SupplySalesShareMeasures	time_unit	text	2147483647	√		null
SupplySalesShareMeasuresData	demand_sector_id	int4	10	√		null
SupplySalesShareMeasuresData	gau_id	int4	10	√		null
SupplySalesShareMeasuresData	id	serial	10		√	nextval('"SupplySalesShareMeasuresData_id_seq"'::regclass)
SupplySalesShareMeasuresData	oth_1_id	int4	10	√		null
SupplySalesShareMeasuresData	parent_id	int4	10	√		null
SupplySalesShareMeasuresData	resource_bin	int4	10	√		null
SupplySalesShareMeasuresData	value	float8	17,17	√		null
SupplySalesShareMeasuresData	vintage	int4	10	√		null
SupplyStates	blend_package_id	int4	10	√		null
SupplyStates	description	text	2147483647	√		null
SupplyStates	export_package_id	int4	10	√		null
SupplyStates	id	serial	10		√	nextval('"SupplyCasesData_id_seq"'::regclass)
SupplyStates	sales_package_id	int4	10	√		null
SupplyStates	sales_share_package_id	int4	10	√		null
SupplyStates	stock_package_id	int4	10	√		null
SupplyStates	supply_node_id	int4	10	√		null
SupplyStock	capacity_or_energy_unit	text	2147483647	√		null
SupplyStock	extrapolation_growth	float4	8,8	√		null
SupplyStock	extrapolation_method_id	int4	10	√		null
SupplyStock	geography_id	int4	10	√		null
SupplyStock	geography_map_key_id	int4	10	√		null
SupplyStock	interpolation_method_id	int4	10	√		null
SupplyStock	supply_node_id	int4	10
SupplyStock	time_unit	text	2147483647	√		null
SupplyStockData	demand_sector_id	int4	10	√		null
SupplyStockData	gau_id	int4	10	√		null
SupplyStockData	id	serial	10		√	nextval('"SupplyStockData_id_seq"'::regclass)
SupplyStockData	resource_bin	int4	10	√		null
SupplyStockData	supply_node_id	int4	10	√		null
SupplyStockData	supply_technology_id	int4	10	√		null
SupplyStockData	value	float8	17,17	√		null
SupplyStockData	year	int4	10	√		null
SupplyStockMeasurePackages	id	serial	10		√	nextval('"SupplyStockMeasurePackages_id_seq"'::regclass)
SupplyStockMeasurePackages	name	text	2147483647	√		null
SupplyStockMeasurePackages	supply_node_id	int4	10	√		null
SupplyStockMeasurePackagesData	id	serial	10		√	nextval('"SupplyStockMeasurePackagesData_id_seq"'::regclass)
SupplyStockMeasurePackagesData	measure_id	int4	10	√		null
SupplyStockMeasurePackagesData	package_id	int4	10	√		null
SupplyStockMeasures	capacity_or_energy_unit	text	2147483647	√		null
SupplyStockMeasures	extrapolation_growth	float4	8,8	√		null
SupplyStockMeasures	extrapolation_method_id	int4	10	√		null
SupplyStockMeasures	geography_id	int4	10	√		null
SupplyStockMeasures	geography_map_key_id	int4	10	√		null
SupplyStockMeasures	id	serial	10		√	nextval('"SupplyStockMeasures_id_seq"'::regclass)
SupplyStockMeasures	interpolation_method_id	int4	10	√		null
SupplyStockMeasures	name	text	2147483647	√		null
SupplyStockMeasures	other_index_1_id	int4	10	√		null
SupplyStockMeasures	supply_node_id	int4	10	√		null
SupplyStockMeasures	supply_technology_id	int4	10	√		null
SupplyStockMeasures	time_unit	text	2147483647	√		null
SupplyStockMeasuresData	demand_sector_id	int4	10	√		null
SupplyStockMeasuresData	gau_id	int4	10	√		null
SupplyStockMeasuresData	id	serial	10		√	nextval('"SupplyStockMeasuresData_id_seq"'::regclass)
SupplyStockMeasuresData	oth_1_id	int4	10	√		null
SupplyStockMeasuresData	parent_id	int4	10	√		null
SupplyStockMeasuresData	resource_bin	int2	5	√		null
SupplyStockMeasuresData	value	float8	17,17	√		null
SupplyStockMeasuresData	year	int4	10	√		null
SupplyTechs	additional_description	text	2147483647	√		null
SupplyTechs	book_life	int4	10	√		null
SupplyTechs	cost_of_capital	float4	8,8	√		null
SupplyTechs	discharge_duration	float4	8,8	√		null
SupplyTechs	id	serial	10		√	nextval('"SupplyTechs_id_seq"'::regclass)
SupplyTechs	lifetime_variance	float4	8,8	√		null
SupplyTechs	max_lag_hours	int4	10	√		null
SupplyTechs	max_lead_hours	int4	10	√		null
SupplyTechs	max_lifetime	float4	8,8	√		null
SupplyTechs	mean_lifetime	float4	8,8	√		null
SupplyTechs	min_lifetime	float4	8,8	√		null
SupplyTechs	name	text	2147483647
SupplyTechs	shape_id	int4	10	√		null
SupplyTechs	source	text	2147483647	√		null
SupplyTechs	stock_decay_function_id	int4	10	√		null
SupplyTechs	supply_node_id	int4	10	√		null
SupplyTechsCapacityFactor	age_growth_or_decay	float4	8,8	√		null
SupplyTechsCapacityFactor	age_growth_or_decay_type_id	int4	10	√		null
SupplyTechsCapacityFactor	definition_id	int4	10	√		null
SupplyTechsCapacityFactor	extrapolation_growth	float4	8,8	√		null
SupplyTechsCapacityFactor	extrapolation_method_id	int4	10	√		null
SupplyTechsCapacityFactor	geography_id	int4	10	√		null
SupplyTechsCapacityFactor	interpolation_method_id	int4	10	√		null
SupplyTechsCapacityFactor	reference_tech_id	int4	10	√		null
SupplyTechsCapacityFactor	supply_tech_id	int4	10
SupplyTechsCapacityFactorData	gau_id	int4	10	√		null
SupplyTechsCapacityFactorData	id	serial	10		√	nextval('"SupplyTechsCapacityFactorData_id_seq"'::regclass)
SupplyTechsCapacityFactorData	oth_1_id	int4	10	√		null
SupplyTechsCapacityFactorData	resource_bin	int4	10	√		null
SupplyTechsCapacityFactorData	supply_tech_id	int4	10	√		null
SupplyTechsCapacityFactorData	value	float8	17,17	√		null
SupplyTechsCapacityFactorData	vintage	int4	10	√		null
SupplyTechsCapitalCost	capacity_or_energy_unit	text	2147483647	√		null
SupplyTechsCapitalCost	currency_id	int4	10	√		null
SupplyTechsCapitalCost	currency_year_id	int4	10	√		null
SupplyTechsCapitalCost	definition_id	int4	10	√		null
SupplyTechsCapitalCost	extrapolation_growth	float4	8,8	√		null
SupplyTechsCapitalCost	extrapolation_method_id	int4	10	√		null
SupplyTechsCapitalCost	geography_id	int4	10	√		null
SupplyTechsCapitalCost	geography_map_key_id	int4	10	√		null
SupplyTechsCapitalCost	interpolation_method_id	int4	10	√		null
SupplyTechsCapitalCost	is_levelized	bool	1	√		null
SupplyTechsCapitalCost	notes	text	2147483647	√		null
SupplyTechsCapitalCost	reference_tech_id	int4	10	√		null
SupplyTechsCapitalCost	source	text	2147483647	√		null
SupplyTechsCapitalCost	supply_tech_id	int4	10
SupplyTechsCapitalCost	time_unit	text	2147483647	√		null
SupplyTechsCapitalCostNewData	demand_sector_id	int4	10	√		null
SupplyTechsCapitalCostNewData	gau_id	int4	10	√		null
SupplyTechsCapitalCostNewData	id	serial	10		√	nextval('"SupplyTechsCapitalCostNewData_id_seq"'::regclass)
SupplyTechsCapitalCostNewData	resource_bin	int4	10	√		null
SupplyTechsCapitalCostNewData	supply_tech_id	int4	10	√		null
SupplyTechsCapitalCostNewData	value	float8	17,17	√		null
SupplyTechsCapitalCostNewData	vintage	int4	10	√		null
SupplyTechsCapitalCostReplacementData	demand_sector_id	int4	10	√		null
SupplyTechsCapitalCostReplacementData	gau_id	int4	10	√		null
SupplyTechsCapitalCostReplacementData	id	serial	10		√	nextval('"SupplyTechsCapitalCostReplacementData_id_seq"'::regclass)
SupplyTechsCapitalCostReplacementData	resource_bin	int4	10	√		null
SupplyTechsCapitalCostReplacementData	supply_tech_id	int4	10	√		null
SupplyTechsCapitalCostReplacementData	value	float8	17,17	√		null
SupplyTechsCapitalCostReplacementData	vintage	int4	10	√		null
SupplyTechsCO2Capture	age_growth_or_decay	float4	8,8	√		null
SupplyTechsCO2Capture	age_growth_or_decay_type_id	int4	10	√		null
SupplyTechsCO2Capture	definition_id	int4	10	√		null
SupplyTechsCO2Capture	extrapolation_growth	float4	8,8	√		null
SupplyTechsCO2Capture	extrapolation_method_id	int4	10	√		null
SupplyTechsCO2Capture	geography_id	int4	10	√		null
SupplyTechsCO2Capture	interpolation_method_id	int4	10	√		null
SupplyTechsCO2Capture	reference_tech_id	int4	10	√		null
SupplyTechsCO2Capture	supply_tech_id	int4	10
SupplyTechsCO2CaptureData	gau_id	int4	10	√		null
SupplyTechsCO2CaptureData	id	serial	10		√	nextval('"SupplyTechsCO2CaptureData_id_seq"'::regclass)
SupplyTechsCO2CaptureData	resource_bin	int4	10	√		null
SupplyTechsCO2CaptureData	supply_tech_id	serial	10	√	√	nextval('"SupplyTechsCapacityFactorData_id_seq"'::regclass)
SupplyTechsCO2CaptureData	value	float8	17,17	√		null
SupplyTechsCO2CaptureData	vintage	int4	10	√		null
SupplyTechsEfficiency	age_growth_or_decay	float4	8,8	√		null
SupplyTechsEfficiency	age_growth_or_decay_type_id	int4	10	√		null
SupplyTechsEfficiency	definition_id	int4	10	√		null
SupplyTechsEfficiency	extrapolation_growth	float4	8,8	√		null
SupplyTechsEfficiency	extrapolation_method_id	int4	10	√		null
SupplyTechsEfficiency	geography_id	int4	10	√		null
SupplyTechsEfficiency	input_unit	text	2147483647	√		null
SupplyTechsEfficiency	interpolation_method_id	int4	10	√		null
SupplyTechsEfficiency	notes	text	2147483647	√		null
SupplyTechsEfficiency	output_unit	text	2147483647	√		null
SupplyTechsEfficiency	reference_tech_id	int4	10	√		null
SupplyTechsEfficiency	source	text	2147483647	√		null
SupplyTechsEfficiency	supply_tech_id	int4	10
SupplyTechsEfficiencyData	demand_sector_id	int4	10	√		null
SupplyTechsEfficiencyData	efficiency_type_id	int4	10	√		null
SupplyTechsEfficiencyData	gau_id	int4	10	√		null
SupplyTechsEfficiencyData	id	serial	10		√	nextval('"SupplyTechsEfficiencyData_id_seq"'::regclass)
SupplyTechsEfficiencyData	resource_bin	int4	10	√		null
SupplyTechsEfficiencyData	supply_node_id	int4	10	√		null
SupplyTechsEfficiencyData	supply_tech_id	int4	10	√		null
SupplyTechsEfficiencyData	value	float8	17,17	√		null
SupplyTechsEfficiencyData	vintage	int4	10	√		null
SupplyTechsFixedMaintenanceCost	age_growth_or_decay	float4	8,8	√		null
SupplyTechsFixedMaintenanceCost	age_growth_or_decay_type_id	int4	10	√		null
SupplyTechsFixedMaintenanceCost	capacity_or_energy_unit	text	2147483647	√		null
SupplyTechsFixedMaintenanceCost	currency_id	int4	10	√		null
SupplyTechsFixedMaintenanceCost	currency_year_id	int4	10	√		null
SupplyTechsFixedMaintenanceCost	definition_id	int4	10	√		null
SupplyTechsFixedMaintenanceCost	extrapolation_growth	float4	8,8	√		null
SupplyTechsFixedMaintenanceCost	extrapolation_method_id	int4	10	√		null
SupplyTechsFixedMaintenanceCost	geography_id	int4	10	√		null
SupplyTechsFixedMaintenanceCost	interpolation_method_id	int4	10	√		null
SupplyTechsFixedMaintenanceCost	notes	text	2147483647	√		null
SupplyTechsFixedMaintenanceCost	reference_tech_id	int4	10	√		null
SupplyTechsFixedMaintenanceCost	source	text	2147483647	√		null
SupplyTechsFixedMaintenanceCost	supply_tech_id	int4	10
SupplyTechsFixedMaintenanceCost	time_unit	text	2147483647	√		null
SupplyTechsFixedMaintenanceCostData	demand_sector_id	int4	10	√		null
SupplyTechsFixedMaintenanceCostData	gau_id	int4	10	√		null
SupplyTechsFixedMaintenanceCostData	id	serial	10		√	nextval('"SupplyTechsFixedMaintenanceCostData_id_seq"'::regclass)
SupplyTechsFixedMaintenanceCostData	resource_bin	int4	10	√		null
SupplyTechsFixedMaintenanceCostData	supply_tech_id	int4	10	√		null
SupplyTechsFixedMaintenanceCostData	value	float4	8,8	√		null
SupplyTechsFixedMaintenanceCostData	vintage	int4	10	√		null
SupplyTechsInstallationCost	capacity_or_energy_unit	text	2147483647	√		null
SupplyTechsInstallationCost	currency_id	int4	10	√		null
SupplyTechsInstallationCost	currency_year_id	int4	10	√		null
SupplyTechsInstallationCost	definition_id	int4	10	√		null
SupplyTechsInstallationCost	extrapolation_growth	float4	8,8	√		null
SupplyTechsInstallationCost	extrapolation_method_id	int4	10	√		null
SupplyTechsInstallationCost	geography_id	int4	10	√		null
SupplyTechsInstallationCost	interpolation_method_id	int4	10	√		null
SupplyTechsInstallationCost	is_levelized	bool	1	√		false
SupplyTechsInstallationCost	notes	text	2147483647	√		null
SupplyTechsInstallationCost	reference_tech_id	int4	10	√		null
SupplyTechsInstallationCost	source	text	2147483647	√		null
SupplyTechsInstallationCost	supply_tech_id	int4	10
SupplyTechsInstallationCost	time_unit	text	2147483647	√		null
SupplyTechsInstallationCostNewData	demand_sector_id	int4	10	√		null
SupplyTechsInstallationCostNewData	gau_id	int4	10	√		null
SupplyTechsInstallationCostNewData	id	serial	10		√	nextval('"SupplyTechsInstallationCostNewData_id_seq"'::regclass)
SupplyTechsInstallationCostNewData	resource_bin	int4	10	√		null
SupplyTechsInstallationCostNewData	supply_tech_id	int4	10	√		null
SupplyTechsInstallationCostNewData	value	float8	17,17	√		null
SupplyTechsInstallationCostNewData	vintage	int4	10	√		null
SupplyTechsInstallationCostReplacementData	demand_sector_id	int4	10	√		null
SupplyTechsInstallationCostReplacementData	gau_id	int4	10	√		null
SupplyTechsInstallationCostReplacementData	id	serial	10		√	nextval('"SupplyTechsInstallationCostReplacementData_id_seq"'::regclass)
SupplyTechsInstallationCostReplacementData	resource_bin	int4	10	√		null
SupplyTechsInstallationCostReplacementData	supply_tech_id	int4	10	√		null
SupplyTechsInstallationCostReplacementData	value	float8	17,17	√		null
SupplyTechsInstallationCostReplacementData	vintage	int4	10	√		null
SupplyTechsVariableMaintenanceCost	age_growth_or_decay	float4	8,8	√		null
SupplyTechsVariableMaintenanceCost	age_growth_or_decay_type_id	int4	10	√		null
SupplyTechsVariableMaintenanceCost	currency_id	int4	10	√		null
SupplyTechsVariableMaintenanceCost	currency_year_id	int4	10	√		null
SupplyTechsVariableMaintenanceCost	definition_id	int4	10	√		null
SupplyTechsVariableMaintenanceCost	energy_unit	text	2147483647	√		null
SupplyTechsVariableMaintenanceCost	extrapolation_growth	float4	8,8	√		null
SupplyTechsVariableMaintenanceCost	extrapolation_method_id	int4	10	√		null
SupplyTechsVariableMaintenanceCost	geography_id	int4	10	√		null
SupplyTechsVariableMaintenanceCost	interpolation_method_id	int4	10	√		null
SupplyTechsVariableMaintenanceCost	notes	text	2147483647	√		null
SupplyTechsVariableMaintenanceCost	reference_tech_id	int4	10	√		null
SupplyTechsVariableMaintenanceCost	source	text	2147483647	√		null
SupplyTechsVariableMaintenanceCost	supply_tech_id	int4	10
SupplyTechsVariableMaintenanceCostData	demand_sector_id	int4	10	√		null
SupplyTechsVariableMaintenanceCostData	gau_id	int4	10	√		null
SupplyTechsVariableMaintenanceCostData	id	serial	10		√	nextval('"SupplyTechsVariableMaintenanceCostData_id_seq"'::regclass)
SupplyTechsVariableMaintenanceCostData	resource_bin	int4	10	√		null
SupplyTechsVariableMaintenanceCostData	supply_tech_id	int4	10	√		null
SupplyTechsVariableMaintenanceCostData	value	float8	17,17	√		null
SupplyTechsVariableMaintenanceCostData	vintage	int4	10	√		null
SupplyTypes	id	serial	10		√	nextval('"SupplyTypes_id_seq"'::regclass)
SupplyTypes	name	text	2147483647
TimeZones	id	serial	10		√	nextval('"TimeZones_id_seq"'::regclass)
TimeZones	name	text	2147483647	√		null
TimeZones	utc_shift	float8	17,17	√		null
Version	author	text	2147483647	√		null
Version	date	text	2147483647	√		null
Version	version_number	numeric	131089	√		null