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

Table	Column	Type	Size	Nulls	Auto	Default	Comments
DemandTechs	additional_description	text	2147483647	√		null	Further information.
DemandTechsFixedMaintenanceCost	additional_description	text	2147483647	√		null
SupplyTechs	additional_description	text	2147483647	√		null
SupplyCost	additional_notes	text	2147483647	√		null
DemandTechsAuxEfficiency	age_growth_or_decay	float4	8,8	√		null
DemandTechsFixedMaintenanceCost	age_growth_or_decay	float4	8,8	√		null
DemandTechsMainEfficiency	age_growth_or_decay	float4	8,8	√		null
DemandTechsParasiticEnergy	age_growth_or_decay	float4	8,8	√		null
DemandTechsServiceDemandModifier	age_growth_or_decay	float4	8,8	√		null
DemandTechsServiceLink	age_growth_or_decay	float4	8,8	√		null
SupplyCapacityFactor	age_growth_or_decay	float4	8,8	√		null
SupplyTechsCapacityFactor	age_growth_or_decay	float4	8,8	√		null
SupplyTechsCO2Capture	age_growth_or_decay	float4	8,8	√		null
SupplyTechsEfficiency	age_growth_or_decay	float4	8,8	√		null
SupplyTechsFixedMaintenanceCost	age_growth_or_decay	float4	8,8	√		null
SupplyTechsVariableMaintenanceCost	age_growth_or_decay	float4	8,8	√		null
DemandTechsAuxEfficiency	age_growth_or_decay_type_id	int4	10	√		null
DemandTechsFixedMaintenanceCost	age_growth_or_decay_type_id	int4	10	√		null
DemandTechsMainEfficiency	age_growth_or_decay_type_id	int4	10	√		null
DemandTechsParasiticEnergy	age_growth_or_decay_type_id	int4	10	√		null
DemandTechsServiceDemandModifier	age_growth_or_decay_type_id	int4	10	√		null
DemandTechsServiceLink	age_growth_or_decay_type_id	int4	10	√		null
SupplyCapacityFactor	age_growth_or_decay_type_id	int4	10	√		null
SupplyTechsCapacityFactor	age_growth_or_decay_type_id	int4	10	√		null
SupplyTechsCO2Capture	age_growth_or_decay_type_id	int4	10	√		null
SupplyTechsEfficiency	age_growth_or_decay_type_id	int4	10	√		null
SupplyTechsFixedMaintenanceCost	age_growth_or_decay_type_id	int4	10	√		null
SupplyTechsVariableMaintenanceCost	age_growth_or_decay_type_id	int4	10	√		null
Version	author	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.
BlendMeasuresData	blend_node_id	int4	10	√		null
BlendNodeBlendMeasurePackages	blend_node_id	int4	10	√		null
BlendNodeBlendMeasures	blend_node_id	int4	10	√		null
BlendNodeInputsData	blend_node_id	int4	10	√		null
SupplyStates	blend_package_id	int4	10	√		null
SupplyCost	book_life	int4	10	√		null
SupplyNodes	book_life	int4	10	√		null
SupplyTechs	book_life	int4	10	√		null
CapitalCostOutputs	capacity_or_energy_unit	text	2147483647	√		null
StorageTechsCapacityCapitalCost	capacity_or_energy_unit	text	2147483647	√		null
SupplySales	capacity_or_energy_unit	text	2147483647	√		null
SupplySalesShareMeasures	capacity_or_energy_unit	text	2147483647	√		null
SupplyStock	capacity_or_energy_unit	text	2147483647	√		null
SupplyStockMeasures	capacity_or_energy_unit	text	2147483647	√		null
SupplyTechsCapitalCost	capacity_or_energy_unit	text	2147483647	√		null
SupplyTechsFixedMaintenanceCost	capacity_or_energy_unit	text	2147483647	√		null
SupplyTechsInstallationCost	capacity_or_energy_unit	text	2147483647	√		null
DemandEnergyEfficiencyMeasuresCost	cost_denominator_unit	text	2147483647	√		null
DemandFuelSwitchingMeasuresCost	cost_denominator_unit	text	2147483647	√		null
DemandServiceDemandMeasuresCost	cost_denominator_unit	text	2147483647	√		null
DemandEnergyEfficiencyMeasuresCost	cost_of_capital	float4	8,8	√		null
DemandFuelSwitchingMeasuresCost	cost_of_capital	float4	8,8	√		null
DemandServiceDemandMeasuresCost	cost_of_capital	float4	8,8	√		null
DemandSubsectors	cost_of_capital	float4	8,8	√		null	Cost of capital in the subsector.
DemandTechs	cost_of_capital	float4	8,8	√		null	Separate cost of capital for the technology.
StorageTechsCapacityCapitalCost	cost_of_capital	float8	17,17	√		null
StorageTechsEnergyCapitalCost	cost_of_capital	float8	17,17	√		null
SupplyCost	cost_of_capital	float4	8,8	√		null
SupplyNodes	cost_of_capital	float4	8,8	√		null
SupplyTechs	cost_of_capital	float4	8,8	√		null
CapitalCostOutputs	Currency	text	2147483647	√		null
Demand Technologies - Capital Costs	Currency	text	2147483647	√		null
Demand Technologies - Fixed OM	Currency	text	2147483647	√		null
Demand Technologies - Fuel Switching Costs	Currency	text	2147483647	√		null
Demand Techs - Installation Costs	Currency	text	2147483647	√		null
CurrenciesConversion	currency_id	int4	10	√		null
DemandEnergyEfficiencyMeasuresCost	currency_id	int4	10	√		null
DemandFuelSwitchingMeasuresCost	currency_id	int4	10	√		null
DemandServiceDemandMeasuresCost	currency_id	int4	10	√		null
DemandTechsCapitalCost	currency_id	int4	10	√		null	Input currency.
DemandTechsFixedMaintenanceCost	currency_id	int4	10	√		null
DemandTechsFuelSwitchCost	currency_id	int4	10	√		null
DemandTechsInstallationCost	currency_id	int4	10	√		null
ImportCost	currency_id	int4	10	√		null
InflationConversion	currency_id	int4	10	√		null
PrimaryCost	currency_id	int4	10	√		null
StorageTechsCapacityCapitalCost	currency_id	int4	10	√		null
StorageTechsEnergyCapitalCost	currency_id	int4	10	√		null
SupplyCost	currency_id	int4	10	√		null
SupplyTechsCapitalCost	currency_id	int4	10	√		null
SupplyTechsFixedMaintenanceCost	currency_id	int4	10	√		null
SupplyTechsInstallationCost	currency_id	int4	10	√		null
SupplyTechsVariableMaintenanceCost	currency_id	int4	10	√		null
CapitalCostOutputs	currency_year_id	int4	10	√		null
CurrenciesConversion	currency_year_id	int4	10	√		null
Demand Technologies - Capital Costs	currency_year_id	int4	10	√		null
Demand Technologies - Fixed OM	currency_year_id	int4	10	√		null
Demand Technologies - Fuel Switching Costs	currency_year_id	int4	10	√		null
Demand Techs - Installation Costs	currency_year_id	int4	10	√		null
DemandEnergyEfficiencyMeasuresCost	currency_year_id	int4	10	√		null
DemandFuelSwitchingMeasuresCost	currency_year_id	int4	10	√		null
DemandServiceDemandMeasuresCost	currency_year_id	int4	10	√		null
DemandTechsCapitalCost	currency_year_id	int4	10	√		null	Input currency year.
DemandTechsFixedMaintenanceCost	currency_year_id	int4	10	√		null
DemandTechsFuelSwitchCost	currency_year_id	int4	10	√		null
DemandTechsInstallationCost	currency_year_id	int4	10	√		null
ImportCost	currency_year_id	int4	10	√		null
InflationConversion	currency_year_id	int4	10	√		null
PrimaryCost	currency_year_id	int4	10	√		null
StorageTechsCapacityCapitalCost	currency_year_id	int4	10	√		null
StorageTechsEnergyCapitalCost	currency_year_id	int4	10	√		null
SupplyCost	currency_year_id	int4	10	√		null
SupplyTechsCapitalCost	currency_year_id	int4	10	√		null
SupplyTechsFixedMaintenanceCost	currency_year_id	int4	10	√		null
SupplyTechsInstallationCost	currency_year_id	int4	10	√		null
SupplyTechsVariableMaintenanceCost	currency_year_id	int4	10	√		null
IndexLevels	data_column_name	text	2147483647	√		null
Version	date	text	2147483647	√		null
DispatchNodeData	day	int4	10	√		null
ShapesData	day_type_id	int4	10	√		null
DemandTechsAuxEfficiency	definition_id	int4	10	√		null
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.
DemandTechsFixedMaintenanceCost	definition_id	int4	10	√		null
DemandTechsFuelSwitchCost	definition_id	int4	10	√		null
DemandTechsInstallationCost	definition_id	int4	10	√		null
DemandTechsMainEfficiency	definition_id	int4	10	√		null
DemandTechsParasiticEnergy	definition_id	int4	10	√		null
DemandTechsServiceLink	definition_id	int4	10	√		null
StorageTechsCapacityCapitalCost	definition_id	int4	10	√		null
StorageTechsEnergyCapitalCost	definition_id	int4	10	√		null
SupplyTechsCapacityFactor	definition_id	int4	10	√		null
SupplyTechsCapitalCost	definition_id	int4	10	√		null
SupplyTechsCO2Capture	definition_id	int4	10	√		null
SupplyTechsEfficiency	definition_id	int4	10	√		null
SupplyTechsFixedMaintenanceCost	definition_id	int4	10	√		null
SupplyTechsInstallationCost	definition_id	int4	10	√		null
SupplyTechsVariableMaintenanceCost	definition_id	int4	10	√		null
Scenarios	demand_case	int4	10	√		null
DemandCasesData	demand_case_id	int4	10
BlendNodeBlendMeasuresData	demand_sector_id	int4	10	√		null
DispatchFeedersAllocationData	demand_sector_id	int4	10	√		null
ImportCostData	demand_sector_id	int4	10	√		null
PrimaryCostData	demand_sector_id	int4	10	√		null
SupplyCapacityFactorData	demand_sector_id	int4	10	√		null
SupplyCostData	demand_sector_id	int4	10	√		null
SupplyEfficiencyData	demand_sector_id	int4	10	√		null
SupplyEmissionsData	demand_sector_id	int4	10	√		null
SupplyPotentialData	demand_sector_id	int4	10	√		null
SupplySalesData	demand_sector_id	int4	10	√		null
SupplySalesMeasuresData	demand_sector_id	int4	10	√		null
SupplySalesShareData	demand_sector_id	int4	10	√		null
SupplySalesShareMeasuresData	demand_sector_id	int4	10	√		null
SupplyStockData	demand_sector_id	int4	10	√		null
SupplyStockMeasuresData	demand_sector_id	int4	10	√		null
SupplyTechsCapitalCostNewData	demand_sector_id	int4	10	√		null
SupplyTechsCapitalCostReplacementData	demand_sector_id	int4	10	√		null
SupplyTechsEfficiencyData	demand_sector_id	int4	10	√		null
SupplyTechsFixedMaintenanceCostData	demand_sector_id	int4	10	√		null
SupplyTechsInstallationCostNewData	demand_sector_id	int4	10	√		null
SupplyTechsInstallationCostReplacementData	demand_sector_id	int4	10	√		null
SupplyTechsVariableMaintenanceCostData	demand_sector_id	int4	10	√		null
DemandCasesData	demand_state_id	int4	10
DemandStock	demand_stock_unit_type_id	int4	10	√		null	Equipment, service demand, or capacity factor
DemandTechsMainEfficiency	demand_tech_efficiency_types	int4	10	√		null
DemandTechsAuxEfficiency	demand_tech_efficiency_types_id	int4	10	√		null
DemandTechs	demand_tech_unit_type_id	int4	10	√		null	Equipment or service demand.
DemandEnergyDemandsData	demand_technology_id	int4	10	√		null
DemandSalesData	demand_technology_id	int4	10	√		null	Demand technology id
DemandSalesMeasures	demand_technology_id	int4	10	√		null
DemandServiceDemandsData	demand_technology_id	int4	10	√		null
DemandStockData	demand_technology_id	int4	10	√		null	Technology id for the stock inputs.
DemandStockMeasures	demand_technology_id	int4	10	√		null
DemandTechsAuxEfficiency	demand_technology_id	int4	10
DemandTechsAuxEfficiencyData	demand_technology_id	int4	10	√		null
DemandTechsCapitalCost	demand_technology_id	int4	10				Parent demand tech.
DemandTechsCapitalCostNewData	demand_technology_id	int4	10	√		null
DemandTechsCapitalCostReplacementData	demand_technology_id	int4	10	√		null
DemandTechsFixedMaintenanceCost	demand_technology_id	int4	10
DemandTechsFixedMaintenanceCostData	demand_technology_id	int4	10	√		null
DemandTechsFuelSwitchCost	demand_technology_id	int4	10
DemandTechsFuelSwitchCostData	demand_technology_id	int4	10	√		null
DemandTechsInstallationCost	demand_technology_id	int4	10
DemandTechsInstallationCostNewData	demand_technology_id	int4	10	√		null
DemandTechsInstallationCostReplacementData	demand_technology_id	int4	10	√		null
DemandTechsMainEfficiency	demand_technology_id	int4	10
DemandTechsMainEfficiencyData	demand_technology_id	int4	10	√		null
DemandTechsParasiticEnergy	demand_technology_id	int4	10
DemandTechsParasiticEnergyData	demand_technology_id	int4	10	√		null
DemandTechsServiceDemandModifier	demand_technology_id	int4	10
DemandTechsServiceDemandModifierData	demand_technology_id	int4	10	√		null
DemandTechsServiceLink	demand_technology_id	int4	10	√		null
SalesMeasureNameTech	demand_technology_id	int4	10	√		null
SalesMeasureReplacedTech	demand_technology_id	int4	10	√		null
DemandEnergyDemands	demand_technology_index	bool	1	√		null
DemandServiceDemands	demand_technology_index	bool	1	√		null
Demand Technologies - Auxiliary Efficiency	denominator_unit	text	2147483647	√		null
Demand Technologies - Main Efficiency	denominator_unit	text	2147483647	√		null
DemandServiceEfficiency	denominator_unit	text	2147483647	√		null	Service demand unit
DemandTechsAuxEfficiency	denominator_unit	text	2147483647	√		null
DemandTechsMainEfficiency	denominator_unit	text	2147483647	√		null
ImportCost	denominator_unit	text	2147483647	√		null
PrimaryCost	denominator_unit	text	2147483647	√		null
SupplyEmissions	denominator_unit	text	2147483647	√		null
DemandStates	description	text	2147483647	√		null
Scenarios	description	text	2147483647	√		null
SupplyStates	description	text	2147483647	√		null
SupplyTechs	discharge_duration	float4	8,8	√		null
ShapesData	dispatch_constraint_id	int4	10	√		null
DispatchFeedersAllocationData	dispatch_feeder_id	int4	10	√		null
ShapesData	dispatch_feeder_id	int4	10	√		null
DispatchNodeConfig	dispatch_order	int4	10
DispatchNodeConfig	dispatch_window_id	int4	10	√		null
DispatchConfig	distribution_grid_node_id	int4	10	√		null
DispatchConfig	distribution_node_id	int4	10	√		null
DemandEnergyDemands	driver_1_id	int4	10	√		null	Energy demand grows or shrinks in proportion to this driver.
DemandServiceDemands	driver_1_id	int4	10	√		null	Service demand in the model will increase or decrease proportionally with this driver.
DemandStock	driver_1_id	int4	10	√		null	Total stock in the model will increase or decrease proportionally with this driver.
DemandEnergyDemands	driver_2_id	int4	10	√		null	Energy demand grows or shrinks in proportion to this driver.
DemandServiceDemands	driver_2_id	int4	10	√		null	Ability to add a second driver.
DemandStock	driver_2_id	int4	10	√		null	Second stock 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.
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.
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.
DemandEnergyDemands	driver_denominator_2_id	int4	10	√		null	Accommodates a second driver in the denominator of the inputs.
DemandServiceDemands	driver_denominator_2_id	int4	10	√		null	Accommodates a second driver in the denominator of the inputs.
DemandStock	driver_denominator_2_id	int4	10	√		null	Accommodates a second driver in the denominator of the inputs.
SupplyEfficiencyData	efficiency_type_id	int4	10	√		null
SupplyTechsEfficiencyData	efficiency_type_id	int4	10	√		null
DispatchNodeData	energy_budget	float8	17,17	√		null
DemandStates	energy_efficiency_package_id	int4	10	√		null
SupplyCost	energy_or_capacity_unit	text	2147483647	√		null
Demand Technologies - Parasitic Energy	energy_unit	text	2147483647	√		null
DemandServiceEfficiency	energy_unit	text	2147483647	√		null	Input energy unit
DemandTechsParasiticEnergy	energy_unit	text	2147483647	√		null
StorageTechsEnergyCapitalCost	energy_unit	text	2147483647	√		null
SupplyTechsVariableMaintenanceCost	energy_unit	text	2147483647	√		null
SupplyPotentialConversion	energy_unit_numerator	text	2147483647	√		null
SupplyNodes	enforce_potential_constraint	bool	1	√		null
SupplyStates	export_package_id	int4	10	√		null
BlendNodeBlendMeasures	extrapolation_growth	float4	8,8	√		null
DemandCO2CaptureMeasures	extrapolation_growth	float4	8,8	√		null
DemandDrivers	extrapolation_growth	float4	8,8	√		null	If extrapolation method exponential is used, what is the year over year growth rate.
DemandEnergyDemands	extrapolation_growth	float4	8,8	√		null	If extrapolation method exponential is used, what is the year over year growth rate?
DemandEnergyEfficiencyMeasures	extrapolation_growth	float4	8,8	√		null
DemandEnergyEfficiencyMeasuresCost	extrapolation_growth	float4	8,8	√		null
DemandFlexibleLoadMeasures	extrapolation_growth	float4	8,8	√		null
DemandFuelSwitchingMeasuresCost	extrapolation_growth	float4	8,8	√		null
DemandFuelSwitchingMeasuresEnergyIntensity	extrapolation_growth	float4	8,8	√		null
DemandFuelSwitchingMeasuresImpact	extrapolation_growth	float4	8,8	√		null
DemandSales	extrapolation_growth	float4	8,8	√		null	If extrapolation method exponential is used, what is the year over year growth rate?
DemandSalesMeasures	extrapolation_growth	float4	8,8	√		null
DemandServiceDemandMeasures	extrapolation_growth	float4	8,8	√		null
DemandServiceDemandMeasuresCost	extrapolation_growth	float4	8,8	√		null
DemandServiceDemands	extrapolation_growth	float4	8,8	√		null	If extrapolation method exponential is used, what is the year over year growth rate?
DemandServiceEfficiency	extrapolation_growth	float4	8,8	√		null	If extrapolation method exponential is used, what is the year over year growth rate?
DemandStock	extrapolation_growth	float4	8,8	√		null	If extrapolation method exponential is used, what is the year over year growth rate?
DemandStockMeasures	extrapolation_growth	float4	8,8	√		null
DemandTechsAuxEfficiency	extrapolation_growth	float4	8,8	√		null
DemandTechsCapitalCost	extrapolation_growth	float4	8,8	√		null	If extrapolation method exponential is used, what is the year over year growth rate?
DemandTechsFixedMaintenanceCost	extrapolation_growth	float4	8,8	√		null
DemandTechsFuelSwitchCost	extrapolation_growth	float4	8,8	√		null
DemandTechsInstallationCost	extrapolation_growth	float4	8,8	√		null
DemandTechsMainEfficiency	extrapolation_growth	float4	8,8	√		null
DemandTechsParasiticEnergy	extrapolation_growth	float4	8,8	√		null
DemandTechsServiceDemandModifier	extrapolation_growth	float4	8,8	√		null
DemandTechsServiceLink	extrapolation_growth	float4	8,8	√		null
ImportCost	extrapolation_growth	float4	8,8	√		null
PrimaryCost	extrapolation_growth	float4	8,8	√		null
SupplyCapacityFactor	extrapolation_growth	float4	8,8	√		null
SupplyCost	extrapolation_growth	float4	8,8	√		null
SupplyEfficiency	extrapolation_growth	float4	8,8	√		null
SupplyEmissions	extrapolation_growth	float4	8,8	√		null
SupplyExport	extrapolation_growth	float4	8,8	√		null
SupplyPotentialConversion	extrapolation_growth	float4	8,8	√		null
SupplySales	extrapolation_growth	float4	8,8	√		null
SupplySalesMeasures	extrapolation_growth	float4	8,8	√		null
SupplySalesShare	extrapolation_growth	float4	8,8	√		null
SupplySalesShareMeasures	extrapolation_growth	float4	8,8	√		null
SupplyStock	extrapolation_growth	float4	8,8	√		null
SupplyStockMeasures	extrapolation_growth	float4	8,8	√		null
SupplyTechsCapacityFactor	extrapolation_growth	float4	8,8	√		null
SupplyTechsCapitalCost	extrapolation_growth	float4	8,8	√		null
SupplyTechsCO2Capture	extrapolation_growth	float4	8,8	√		null
SupplyTechsEfficiency	extrapolation_growth	float4	8,8	√		null
SupplyTechsFixedMaintenanceCost	extrapolation_growth	float4	8,8	√		null
SupplyTechsInstallationCost	extrapolation_growth	float4	8,8	√		null
SupplyTechsVariableMaintenanceCost	extrapolation_growth	float4	8,8	√		null
SupplyCapacityFactor	extrapolation_method	int4	10	√		null
SupplySales	extrapolation_method	int4	10	√		null
SupplySalesShare	extrapolation_method	int4	10	√		null
SupplyPotential	extrapolation_method_growth	float4	8,8	√		null
BlendNodeBlendMeasures	extrapolation_method_id	int4	10	√		null
DemandCO2CaptureMeasures	extrapolation_method_id	int4	10	√		null
DemandDrivers	extrapolation_method_id	int4	10	√		null	Cleaning method used to extrapolate to missing years when data is entered.
DemandEnergyDemands	extrapolation_method_id	int4	10	√		null	Cleaning method used to extrapolate to missing years when data is entered.
DemandEnergyEfficiencyMeasures	extrapolation_method_id	int4	10	√		null
DemandEnergyEfficiencyMeasuresCost	extrapolation_method_id	int4	10	√		null
DemandFlexibleLoadMeasures	extrapolation_method_id	int4	10	√		null
DemandFuelSwitchingMeasuresCost	extrapolation_method_id	int4	10	√		null
DemandFuelSwitchingMeasuresEnergyIntensity	extrapolation_method_id	int4	10	√		null
DemandFuelSwitchingMeasuresImpact	extrapolation_method_id	int4	10	√		null
DemandSales	extrapolation_method_id	int4	10	√		null	Cleaning method used to extrapolate to missing years when data is entered.
DemandSalesMeasures	extrapolation_method_id	int4	10	√		null
DemandServiceDemandMeasures	extrapolation_method_id	int4	10	√		null
DemandServiceDemandMeasuresCost	extrapolation_method_id	int4	10	√		null
DemandServiceDemands	extrapolation_method_id	int4	10	√		null	Cleaning method used to extrapolate to missing years when data is entered.
DemandServiceEfficiency	extrapolation_method_id	int4	10	√		null	Cleaning method used to extrapolate to missing years when data is entered.
DemandStock	extrapolation_method_id	int4	10	√		null	Cleaning method used to extrapolate to missing years when data is entered.
DemandStockMeasures	extrapolation_method_id	int4	10	√		null
DemandTechsAuxEfficiency	extrapolation_method_id	int4	10	√		null
DemandTechsCapitalCost	extrapolation_method_id	int4	10	√		4	Cleaning method used to extrapolate to missing years when data is entered.
DemandTechsFixedMaintenanceCost	extrapolation_method_id	int4	10	√		null
DemandTechsFuelSwitchCost	extrapolation_method_id	int4	10	√		null
DemandTechsInstallationCost	extrapolation_method_id	int4	10	√		null
DemandTechsMainEfficiency	extrapolation_method_id	int4	10	√		null
DemandTechsParasiticEnergy	extrapolation_method_id	int4	10	√		null
DemandTechsServiceDemandModifier	extrapolation_method_id	int4	10	√		null
DemandTechsServiceLink	extrapolation_method_id	int4	10	√		null
DispatchFeedersAllocation	extrapolation_method_id	int4	10	√		null
ImportCost	extrapolation_method_id	int4	10	√		null
PrimaryCost	extrapolation_method_id	int4	10	√		null
Shapes	extrapolation_method_id	int4	10	√		null
StorageTechsCapacityCapitalCost	extrapolation_method_id	int4	10	√		null
StorageTechsEnergyCapitalCost	extrapolation_method_id	int4	10	√		null
SupplyCost	extrapolation_method_id	int4	10	√		null
SupplyEfficiency	extrapolation_method_id	int4	10	√		null
SupplyEmissions	extrapolation_method_id	int4	10	√		null
SupplyExport	extrapolation_method_id	int4	10	√		null
SupplyExportMeasures	extrapolation_method_id	int4	10	√		null
SupplyPotential	extrapolation_method_id	int4	10	√		null
SupplyPotentialConversion	extrapolation_method_id	int4	10	√		null
SupplySalesMeasures	extrapolation_method_id	int4	10	√		null
SupplySalesShareMeasures	extrapolation_method_id	int4	10	√		null
SupplyStock	extrapolation_method_id	int4	10	√		null
SupplyStockMeasures	extrapolation_method_id	int4	10	√		null
SupplyTechsCapacityFactor	extrapolation_method_id	int4	10	√		null
SupplyTechsCapitalCost	extrapolation_method_id	int4	10	√		null
SupplyTechsCO2Capture	extrapolation_method_id	int4	10	√		null
SupplyTechsEfficiency	extrapolation_method_id	int4	10	√		null
SupplyTechsFixedMaintenanceCost	extrapolation_method_id	int4	10	√		null
SupplyTechsInstallationCost	extrapolation_method_id	int4	10	√		null
SupplyTechsVariableMaintenanceCost	extrapolation_method_id	int4	10	√		null
Demand Technologies - Auxiliary Efficiency	Final Energy	text	2147483647	√		null
Demand Technologies - Main Efficiency	Final Energy	text	2147483647	√		null
Demand Technologies - Parasitic Energy	Final Energy	text	2147483647	√		null
EnergyDemand	final Energy	text	2147483647	√		null
EnergyDemandData0Index	final Energy	text	2147483647	√		null
EnergyDemandData1Index	final Energy	text	2147483647	√		null
DemandFuelSwitchingMeasures	final_energy_from_id	int4	10	√		null
DemandEnergyDemandsData	final_energy_id	int4	10	√		null
DemandEnergyEfficiencyMeasuresCostData	final_energy_id	int4	10	√		null
DemandEnergyEfficiencyMeasuresData	final_energy_id	int4	10	√		null
DemandServiceDemandsData	final_energy_id	int4	10	√		null
DemandServiceEfficiencyData	final_energy_id	int4	10	√		null	Final energy type
DemandTechsAuxEfficiency	final_energy_id	int4	10	√		null
DemandTechsMainEfficiency	final_energy_id	int4	10	√		null
DemandTechsParasiticEnergyData	final_energy_id	int4	10	√		null
EnergyDemand	final_energy_id	int4	10	√		null
EnergyDemandData0Index	final_energy_id	int4	10	√		null
EnergyDemandData1Index	final_energy_id	int4	10	√		null
DemandEnergyDemands	final_energy_index	bool	1	√		null
DemandServiceDemands	final_energy_index	bool	1	√		null
SupplyNodes	final_energy_link	int4	10	√		null
DemandFuelSwitchingMeasures	final_energy_to_id	int4	10	√		null
DispatchConfig	flex_load_constraints_offset	int4	10	√		null
DemandStates	flexible_load_package_id	int4	10	√		null
DemandStates	fuel_switching_package_id	int4	10	√		null
BlendMeasuresData	gau_id	int4	10	√		null
BlendNodeBlendMeasuresData	gau_id	int4	10	√		null
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.
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.
DemandEnergyEfficiencyMeasuresCostData	gau_id	int4	10	√		null
DemandEnergyEfficiencyMeasuresData	gau_id	int4	10	√		null
DemandFlexibleLoadMeasuresData	gau_id	int4	10	√		null
DemandFuelSwitchingMeasuresCostData	gau_id	int4	10	√		null
DemandFuelSwitchingMeasuresEnergyIntensityData	gau_id	int4	10	√		null
DemandFuelSwitchingMeasuresImpactData	gau_id	int4	10	√		null
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.
DemandSalesMeasuresData	gau_id	int4	10	√		null
DemandServiceDemandMeasuresCostData	gau_id	int4	10	√		null
DemandServiceDemandMeasuresData	gau_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.
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.
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.
DemandStockMeasuresData	gau_id	int4	10	√		null
DemandTechsAuxEfficiencyData	gau_id	int4	10	√		null
DemandTechsCapitalCostNewData	gau_id	int4	10	√		null
DemandTechsCapitalCostReplacementData	gau_id	int4	10	√		null
DemandTechsFixedMaintenanceCostData	gau_id	int4	10	√		null
DemandTechsFuelSwitchCostData	gau_id	int4	10	√		null
DemandTechsInstallationCostNewData	gau_id	int4	10	√		null
DemandTechsInstallationCostReplacementData	gau_id	int4	10	√		null
DemandTechsMainEfficiencyData	gau_id	int4	10	√		null
DemandTechsParasiticEnergyData	gau_id	int4	10	√		null
DemandTechsServiceDemandModifierData	gau_id	int4	10	√		null
DemandTechsServiceLinkData	gau_id	int4	10	√		null
DispatchFeedersAllocationData	gau_id	int4	10	√		null
DispatchNodeData	gau_id	int4	10	√		null
GeographyIntersectionData	gau_id	int4	10
ImportCostData	gau_id	int4	10	√		null
PrimaryCostData	gau_id	int4	10	√		null
ShapesData	gau_id	int4	10	√		null
StorageTechsCapacityCapitalCostNewData	gau_id	int4	10	√		null
StorageTechsCapacityCapitalCostReplacementData	gau_id	int4	10	√		null
StorageTechsEnergyCapitalCostNewData	gau_id	int4	10	√		null
StorageTechsEnergyCapitalCostReplacementData	gau_id	int4	10	√		null
SupplyCapacityFactorData	gau_id	int4	10	√		null
SupplyCostData	gau_id	int4	10	√		null
SupplyEfficiencyData	gau_id	int4	10	√		null
SupplyEmissionsData	gau_id	int4	10	√		null
SupplyExportData	gau_id	int4	10	√		null
SupplyExportMeasuresData	gau_id	int4	10	√		null
SupplyPotentialConversionData	gau_id	int4	10	√		null
SupplyPotentialData	gau_id	int4	10	√		null
SupplySalesData	gau_id	int4	10	√		null
SupplySalesMeasuresData	gau_id	int4	10	√		null
SupplySalesShareData	gau_id	int4	10	√		null
SupplySalesShareMeasuresData	gau_id	int4	10	√		null
SupplyStockData	gau_id	int4	10	√		null
SupplyStockMeasuresData	gau_id	int4	10	√		null
SupplyTechsCapacityFactorData	gau_id	int4	10	√		null
SupplyTechsCapitalCostNewData	gau_id	int4	10	√		null
SupplyTechsCapitalCostReplacementData	gau_id	int4	10	√		null
SupplyTechsCO2CaptureData	gau_id	int4	10	√		null
SupplyTechsEfficiencyData	gau_id	int4	10	√		null
SupplyTechsFixedMaintenanceCostData	gau_id	int4	10	√		null
SupplyTechsInstallationCostNewData	gau_id	int4	10	√		null
SupplyTechsInstallationCostReplacementData	gau_id	int4	10	√		null
SupplyTechsVariableMaintenanceCostData	gau_id	int4	10	√		null
CapitalCostOutputs	Geography	text	2147483647	√		null
Demand Technologies - Auxiliary Efficiency	Geography	text	2147483647	√		null
Demand Technologies - Capital Costs	Geography	text	2147483647	√		null
Demand Technologies - Fixed OM	Geography	text	2147483647	√		null
Demand Technologies - Fuel Switching Costs	Geography	text	2147483647	√		null
Demand Technologies - Main Efficiency	Geography	text	2147483647	√		null
Demand Technologies - Parasitic Energy	Geography	text	2147483647	√		null
Demand Techs - Installation Costs	Geography	text	2147483647	√		null
CapitalCostOutputs	Geography Unit	text	2147483647	√		null
Demand Technologies - Auxiliary Efficiency	Geography Unit	text	2147483647	√		null
Demand Technologies - Capital Costs	Geography Unit	text	2147483647	√		null
Demand Technologies - Fixed OM	Geography Unit	text	2147483647	√		null
Demand Technologies - Fuel Switching Costs	Geography Unit	text	2147483647	√		null
Demand Technologies - Main Efficiency	Geography Unit	text	2147483647	√		null
Demand Technologies - Parasitic Energy	Geography Unit	text	2147483647	√		null
Demand Techs - Installation Costs	Geography Unit	text	2147483647	√		null
BlendNodeBlendMeasures	geography_id	int4	10	√		null
DemandCO2CaptureMeasures	geography_id	int4	10	√		null
DemandDrivers	geography_id	int4	10	√		null	Input geography for the data (e.g. state). Each DemandDriversData record will identify which state.
DemandEnergyDemands	geography_id	int4	10	√		null	Input geography for the data (e.g. state)
DemandEnergyEfficiencyMeasures	geography_id	int4	10	√		null
DemandEnergyEfficiencyMeasuresCost	geography_id	int4	10	√		null
DemandFlexibleLoadMeasures	geography_id	int4	10	√		null
DemandFuelSwitchingMeasuresCost	geography_id	int4	10	√		null
DemandFuelSwitchingMeasuresEnergyIntensity	geography_id	int4	10	√		null
DemandFuelSwitchingMeasuresImpact	geography_id	int4	10	√		null
DemandSales	geography_id	int4	10	√		null	Input geography for the data (e.g. state)
DemandSalesMeasures	geography_id	int4	10	√		null
DemandServiceDemandMeasures	geography_id	int4	10	√		null
DemandServiceDemandMeasuresCost	geography_id	int4	10	√		null
DemandServiceDemands	geography_id	int4	10	√		null	Input geography for the data (e.g. state). Each DemandServiceDemandsData record will identify which state.
DemandServiceEfficiency	geography_id	int4	10	√		null	Input geography for the data (e.g. state)
DemandStock	geography_id	int4	10	√		null	Input geography for the data (e.g. state)
DemandStockMeasures	geography_id	int4	10	√		null
DemandTechsAuxEfficiency	geography_id	int4	10	√		null
DemandTechsCapitalCost	geography_id	int4	10	√		null	Input geography for the data (e.g. state)
DemandTechsFixedMaintenanceCost	geography_id	int4	10	√		null
DemandTechsFuelSwitchCost	geography_id	int4	10	√		null
DemandTechsInstallationCost	geography_id	int4	10	√		null
DemandTechsMainEfficiency	geography_id	int4	10	√		null
DemandTechsParasiticEnergy	geography_id	int4	10	√		null
DemandTechsServiceDemandModifier	geography_id	int4	10	√		null
DemandTechsServiceLink	geography_id	int4	10	√		null
DispatchConfig	geography_id	int4	10	√		null
DispatchFeedersAllocation	geography_id	int4	10	√		null
DispatchNodeConfig	geography_id	int4	10	√		null
GeographiesData	geography_id	int4	10	√		null
ImportCost	geography_id	int4	10	√		null
PrimaryCost	geography_id	int4	10	√		null
Shapes	geography_id	int4	10	√		null
StorageTechsCapacityCapitalCost	geography_id	int4	10	√		null
StorageTechsEnergyCapitalCost	geography_id	int4	10	√		null
SupplyCapacityFactor	geography_id	int4	10	√		null
SupplyCost	geography_id	int4	10	√		null
SupplyEfficiency	geography_id	int4	10	√		null
SupplyEmissions	geography_id	int4	10	√		null
SupplyExport	geography_id	int4	10	√		null
SupplyExportMeasures	geography_id	int4	10	√		null
SupplyPotential	geography_id	int4	10	√		null
SupplyPotentialConversion	geography_id	int4	10	√		null
SupplySales	geography_id	int4	10	√		null
SupplySalesMeasures	geography_id	int4	10	√		null
SupplySalesShare	geography_id	int4	10	√		null
SupplySalesShareMeasures	geography_id	int4	10	√		null
SupplyStock	geography_id	int4	10	√		null
SupplyStockMeasures	geography_id	int4	10	√		null
SupplyTechsCapacityFactor	geography_id	int4	10	√		null
SupplyTechsCapitalCost	geography_id	int4	10	√		null
SupplyTechsCO2Capture	geography_id	int4	10	√		null
SupplyTechsEfficiency	geography_id	int4	10	√		null
SupplyTechsFixedMaintenanceCost	geography_id	int4	10	√		null
SupplyTechsInstallationCost	geography_id	int4	10	√		null
SupplyTechsVariableMaintenanceCost	geography_id	int4	10	√		null
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
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
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
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
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
DispatchFeedersAllocation	geography_map_key_id	int4	10	√		null
GeographyMap	geography_map_key_id	int4	10
Shapes	geography_map_key_id	int4	10	√		null
SupplyNodes	geography_map_key_id	int4	10	√		null
SupplyPotential	geography_map_key_id	int4	10	√		null
SupplySales	geography_map_key_id	int4	10	√		null
SupplySalesMeasures	geography_map_key_id	int4	10	√		null
SupplyStock	geography_map_key_id	int4	10	√		null
SupplyStockMeasures	geography_map_key_id	int4	10	√		null
SupplyTechsCapitalCost	geography_map_key_id	int4	10	√		null
SupplyEmissionsData	ghg_id	int4	10	√		null
SupplyEmissionsData	ghg_type_id	int4	10	√		null
ShapesData	hour	int4	10	√		null
AgeGrowthOrDecayType	id	serial	10		√	nextval('"AgeGrowthOrDecayType_id_seq"'::regclass)
BlendMeasuresData	id	int4	10	√		null
BlendNodeBlendMeasurePackages	id	serial	10		√	nextval('"BlendNodeBlendMeasurePackages_id_seq"'::regclass)
BlendNodeBlendMeasurePackagesData	id	serial	10		√	nextval('"BlendNodeBlendMeasurePackagesData_id_seq"'::regclass)
BlendNodeBlendMeasures	id	serial	10		√	nextval('"BlendNodeBlendMeasures_id_seq"'::regclass)
BlendNodeBlendMeasuresData	id	serial	10		√	nextval('"BlendNodeBlendMeasuresData_id_seq"'::regclass)
BlendNodeInputsData	id	serial	10		√	nextval('"BlendNodeInputsData_id_seq"'::regclass)
CleaningMethods	id	serial	10		√	nextval('"CleaningMethods_id_seq"'::regclass)
Currencies	id	serial	10		√	nextval('"Currencies_id_seq"'::regclass)
CurrenciesConversion	id	serial	10		√	nextval('"CurrenciesConversion_id_seq"'::regclass)
CurrencyYears	id	int4	10
DayType	id	serial	10		√	nextval('"DayType_id_seq"'::regclass)
Definitions	id	serial	10		√	nextval('"Definitions_id_seq"'::regclass)
DemandCases	id	serial	10		√	nextval('"DemandCases_id_seq"'::regclass)
DemandCO2CaptureMeasures	id	serial	10		√	nextval('"DemandCO2CaptureMeasures_id_seq"'::regclass)
DemandDrivers	id	serial	10		√	nextval('"DemandDrivers_id_seq"'::regclass)
DemandDriversData	id	serial	10		√	nextval('"DemandDriversData_id_seq"'::regclass)	Unique id
DemandEnergyDemandsData	id	serial	10		√	nextval('"DemandEnergyDemandsData_id_seq"'::regclass)	Unique id
DemandEnergyEfficiencyMeasurePackages	id	serial	10		√	nextval('"DemandEnergyEfficiencyMeasurePackages_id_seq"'::regclass)
DemandEnergyEfficiencyMeasurePackagesData	id	serial	10		√	nextval('"DemandEnergyEfficiencyMeasurePackagesData_id_seq"'::regclass)
DemandEnergyEfficiencyMeasures	id	serial	10		√	nextval('"DemandEnergyEfficiencyMeasures_id_seq"'::regclass)
DemandEnergyEfficiencyMeasuresCostData	id	serial	10		√	nextval('"DemandEnergyEfficiencyMeasuresCostData_id_seq"'::regclass)
DemandEnergyEfficiencyMeasuresData	id	serial	10		√	nextval('"DemandEnergyEfficiencyMeasuresData_id_seq"'::regclass)
DemandFlexibleLoadMeasurePackages	id	int4	10
DemandFlexibleLoadMeasurePackagesData	id	serial	10		√	nextval('"DemandFlexibleLoadMeasurePackagesData_id_seq"'::regclass)
DemandFlexibleLoadMeasures	id	serial	10		√	nextval('"DemandFlexibleLoadMeasures_id_seq"'::regclass)
DemandFlexibleLoadMeasuresData	id	serial	10		√	nextval('"DemandFlexibleLoadMeasuresData_id_seq"'::regclass)
DemandFuelSwitchingMeasurePackages	id	serial	10		√	nextval('"DemandFuelSwitchingMeasurePackages_id_seq"'::regclass)
DemandFuelSwitchingMeasurePackagesData	id	serial	10		√	nextval('"DemandFuelSwitchingMeasurePackagesData_id_seq"'::regclass)
DemandFuelSwitchingMeasures	id	serial	10		√	nextval('"DemandFuelSwitchingMeasures_id_seq"'::regclass)
DemandFuelSwitchingMeasuresCostData	id	serial	10		√	nextval('"DemandFuelSwitchingMeasuresCostData_id_seq"'::regclass)
DemandFuelSwitchingMeasuresEnergyIntensity	id	int4	10
DemandFuelSwitchingMeasuresEnergyIntensityData	id	serial	10		√	nextval('"DemandFuelSwitchingMeasuresEnergyIntensityData_id_seq"'::regclass)
DemandFuelSwitchingMeasuresImpact	id	int4	10
DemandFuelSwitchingMeasuresImpactData	id	serial	10		√	nextval('"DemandFuelSwitchingMeasuresImpactData_id_seq"'::regclass)
DemandSalesData	id	serial	10		√	nextval('"DemandSalesData_id_seq"'::regclass)	Unique id
DemandSalesMeasurePackages	id	serial	10		√	nextval('"DemandSalesMeasurePackages_id_seq"'::regclass)
DemandSalesMeasurePackagesData	id	serial	10		√	nextval('"DemandSalesMeasurePackagesData_id_seq"'::regclass)
DemandSalesMeasures	id	serial	10		√	nextval('"DemandSalesMeasures_id_seq"'::regclass)
DemandSalesMeasuresData	id	serial	10		√	nextval('"DemandSalesMeasuresData_id_seq"'::regclass)
DemandSectors	id	serial	10		√	nextval('"DemandSectors_id_seq"'::regclass)
DemandServiceDemandMeasurePackages	id	serial	10		√	nextval('"DemandServiceDemandMeasurePackages_id_seq"'::regclass)
DemandServiceDemandMeasurePackagesData	id	serial	10		√	nextval('"DemandServiceDemandMeasurePackagesData_id_seq"'::regclass)
DemandServiceDemandMeasures	id	serial	10		√	nextval('"DemandServiceDemandMeasures_id_seq"'::regclass)
DemandServiceDemandMeasuresCostData	id	int4	10
DemandServiceDemandMeasuresData	id	serial	10		√	nextval('"DemandServiceDemandMeasuresData_id_seq"'::regclass)
DemandServiceDemandsData	id	serial	10		√	nextval('"DemandServiceDemandsData_id_seq"'::regclass)	Unique id
DemandServiceEfficiencyData	id	serial	10		√	nextval('"DemandServiceEfficiencyData_id_seq"'::regclass)	Unique id.
DemandServiceLink	id	serial	10		√	nextval('"DemandServiceLink_id_seq"'::regclass)	Unique id.
DemandStates	id	serial	10		√	nextval('"DemandCasesData_id_seq"'::regclass)
DemandStockData	id	serial	10		√	nextval('"DemandStockData_id_seq"'::regclass)	Unique id.
DemandStockMeasurePackages	id	serial	10		√	nextval('"DemandStockMeasurePackages_id_seq"'::regclass)
DemandStockMeasurePackagesData	id	serial	10		√	nextval('"DemandStockMeasurePackagesData_id_seq"'::regclass)
DemandStockMeasures	id	serial	10		√	nextval('"DemandStockMeasures_id_seq"'::regclass)
DemandStockMeasuresData	id	serial	10		√	nextval('"DemandStockMeasuresData_id_seq"'::regclass)
DemandStockUnitTypes	id	serial	10		√	nextval('"DemandStockUnitTypes_id_seq"'::regclass)
DemandSubsectors	id	serial	10		√	nextval('"DemandSubsectors_id_seq"'::regclass)
DemandTechEfficiencyTypes	id	serial	10		√	nextval('"DemandTechEfficiencyTypes_id_seq"'::regclass)
DemandTechs	id	serial	10		√	nextval('"DemandTechs_id_seq"'::regclass)
DemandTechsAuxEfficiencyData	id	serial	10		√	nextval('"DemandTechsAuxEfficiencyData_id_seq"'::regclass)
DemandTechsCapitalCostNewData	id	serial	10		√	nextval('"DemandTechsCapitalCostNewData_id_seq"'::regclass)
DemandTechsCapitalCostReplacementData	id	serial	10		√	nextval('"DemandTechsCapitalCostReplacementData_id_seq"'::regclass)
DemandTechsFixedMaintenanceCostData	id	serial	10		√	nextval('"DemandTechsFixedMaintenanceCostData_id_seq"'::regclass)
DemandTechsFuelSwitchCostData	id	serial	10		√	nextval('"DemandTechsFuelSwitchCostData_id_seq"'::regclass)
DemandTechsInstallationCostNewData	id	serial	10		√	nextval('"DemandTechsInstallationCostNewData_id_seq"'::regclass)
DemandTechsInstallationCostReplacementData	id	serial	10		√	nextval('"DemandTechsInstallationCostReplacementData_id_seq"'::regclass)
DemandTechsMainEfficiencyData	id	serial	10		√	nextval('"DemandTechsMainEfficiencyData_id_seq"'::regclass)
DemandTechsParasiticEnergyData	id	serial	10		√	nextval('"DemandTechsParasiticEnergyData_id_seq"'::regclass)
DemandTechsServiceDemandModifierData	id	serial	10		√	nextval('"DemandTechsServiceDemandModifierData_id_seq"'::regclass)
DemandTechsServiceLink	id	serial	10		√	nextval('"DemandTechsServiceLink_id_seq"'::regclass)
DemandTechsServiceLinkData	id	serial	10		√	nextval('"DemandTechsServiceLinkData_id_seq"'::regclass)
DemandTechUnitTypes	id	serial	10		√	nextval('"DemandTechUnitTypes_id_seq"'::regclass)
DispatchConfig	id	int4	10
DispatchConstraintTypes	id	bigserial	19		√	nextval('"DispatchConstraintTypes_id_seq"'::regclass)
DispatchFeeders	id	int4	10
DispatchFeedersAllocation	id	serial	10		√	nextval('"DispatchFeedersAllocation_id_seq"'::regclass)
DispatchFeedersAllocationData	id	serial	10		√	nextval('"DispatchFeedersAllocationData_id_seq"'::regclass)
DispatchNodeData	id	serial	10		√	nextval('"DispatchNodeData_id_seq"'::regclass)
DispatchWindows	id	serial	10		√	nextval('"DispatchWindows_id_seq"'::regclass)
EfficiencyTypes	id	serial	10		√	nextval('"EfficiencyTypes_id_seq"'::regclass)
FinalEnergy	id	serial	10		√	nextval('"FinalEnergy_id_seq"'::regclass)
FlexibleLoadShiftTypes	id	int4	10
Geographies	id	serial	10		√	nextval('"Geographies_id_seq"'::regclass)
GeographiesData	id	serial	10		√	nextval('"GeographiesData_id_seq"'::regclass)
GeographyIntersection	id	serial	10		√	nextval('"GeographyIntersection_id_seq"'::regclass)
GeographyIntersectionData	id	serial	10		√	nextval('"GeographyIntersectionData_id_seq"'::regclass)
GeographyMap	id	serial	10		√	nextval('"GeographyMap_id_seq"'::regclass)
GeographyMapKeys	id	serial	10		√	nextval('"GeographyMapKeys_id_seq"'::regclass)
GreenhouseGasEmissionsType	id	serial	10		√	nextval('"GreenhouseGasEmissionsType_id_seq"'::regclass)
GreenhouseGases	id	serial	10		√	nextval('"GreenhouseGases_id_seq"'::regclass)
ImportCostData	id	serial	10		√	nextval('"ImportCostData_id_seq"'::regclass)
IndexLevels	id	serial	10		√	nextval('"IndexLevels_id_seq"'::regclass)
InflationConversion	id	serial	10		√	nextval('"InflationConversion_id_seq"'::regclass)
InputTypes	id	serial	10		√	nextval('"InputTypes_id_seq"'::regclass)
OtherIndexes	id	serial	10		√	nextval('"OtherIndexes_id_seq"'::regclass)
OtherIndexesData	id	serial	10		√	nextval('"OtherIndexesData_id_seq"'::regclass)
OtherIndexesData_copy	id	serial	10		√	nextval('"OtherIndexesData_id_seq"'::regclass)
PrimaryCostData	id	serial	10		√	nextval('"PrimaryCostData_id_seq"'::regclass)
SalesMeasureNameTech	id	int4	10	√		null
SalesMeasureReplacedTech	id	int4	10	√		null
Scenarios	id	serial	10		√	nextval('"Scenarios_id_seq"'::regclass)
Shapes	id	serial	10		√	nextval('"Shapes_id_seq"'::regclass)
ShapesData	id	serial	10		√	nextval('"ShapesData_id_seq"'::regclass)
ShapesTypes	id	serial	10		√	nextval('"ShapesTypes_id_seq"'::regclass)
ShapesUnits	id	serial	10		√	nextval('"ShapesUnits_id_seq"'::regclass)
StockDecayFunctions	id	serial	10		√	nextval('"StockDecayFunctions_id_seq"'::regclass)
StorageTechsCapacityCapitalCostNewData	id	serial	10		√	nextval('"StorageTechsCapacityCapitalCostNewData_id_seq"'::regclass)
StorageTechsEnergyCapitalCostNewData	id	serial	10		√	nextval('"StorageTechsEnergyCapitalCostNewData_id_seq"'::regclass)
StorageTechsEnergyCapitalCostReplacementData	id	serial	10		√	nextval('"StorageTechsEnergyCapitalCostReplacementData_id_seq"'::regclass)
SupplyCapacityFactorData	id	serial	10		√	nextval('"SupplyCapacityFactorData_id_seq"'::regclass)
SupplyCases	id	serial	10		√	nextval('"SupplyCases_id_seq"'::regclass)
SupplyCost	id	serial	10		√	nextval('"SupplyCost_id_seq"'::regclass)
SupplyCostData	id	serial	10		√	nextval('"SupplyCostData_id_seq"'::regclass)
SupplyCostTypes	id	serial	10		√	nextval('"SupplyCostTypes_id_seq"'::regclass)
SupplyEfficiency	id	int4	10
SupplyEfficiencyData	id	serial	10		√	nextval('"SupplyEfficiencyData_id_seq"'::regclass)
SupplyEmissionsData	id	serial	10		√	nextval('"PrimaryEmissionsData_id_seq"'::regclass)
SupplyExportData	id	serial	10		√	nextval('"SupplyExportData_id_seq"'::regclass)
SupplyExportMeasurePackages	id	serial	10		√	nextval('"SupplyExportMeasurePackages_id_seq"'::regclass)
SupplyExportMeasurePackagesData	id	serial	10		√	nextval('"SupplyExportMeasurePackagesData_id_seq"'::regclass)
SupplyExportMeasures	id	serial	10		√	nextval('"SupplyExportMeasures_id_seq"'::regclass)
SupplyExportMeasuresData	id	serial	10		√	nextval('"SupplyExportMeasuresData_id_seq"'::regclass)
SupplyNodes	id	serial	10		√	nextval('"SupplyNodes_id_seq"'::regclass)
SupplyPotentialConversionData	id	serial	10		√	nextval('"PrimaryPotentialConversionData_id_seq"'::regclass)
SupplyPotentialData	id	serial	10		√	nextval('"SupplyPotentialData_id_seq"'::regclass)
SupplySalesData	id	serial	10		√	nextval('"SupplySalesData_id_seq"'::regclass)
SupplySalesMeasurePackages	id	serial	10		√	nextval('"SupplySalesMeasurePackages_id_seq"'::regclass)
SupplySalesMeasurePackagesData	id	serial	10		√	nextval('"SupplySalesMeasurePackagesData_id_seq"'::regclass)
SupplySalesMeasures	id	serial	10		√	nextval('"SupplySalesMeasures_id_seq"'::regclass)
SupplySalesMeasuresData	id	serial	10		√	nextval('"SupplySalesMeasuresData_id_seq"'::regclass)
SupplySalesShareData	id	serial	10		√	nextval('"SupplySalesShareData_id_seq"'::regclass)
SupplySalesShareMeasurePackages	id	serial	10		√	nextval('"SupplySalesShareMeasurePackages_id_seq"'::regclass)
SupplySalesShareMeasurePackagesData	id	serial	10		√	nextval('"SupplySalesShareMeasurePackagesData_id_seq"'::regclass)
SupplySalesShareMeasures	id	serial	10		√	nextval('"SupplySalesShareMeasures_id_seq"'::regclass)
SupplySalesShareMeasuresData	id	serial	10		√	nextval('"SupplySalesShareMeasuresData_id_seq"'::regclass)
SupplyStates	id	serial	10		√	nextval('"SupplyCasesData_id_seq"'::regclass)
SupplyStockData	id	serial	10		√	nextval('"SupplyStockData_id_seq"'::regclass)
SupplyStockMeasurePackages	id	serial	10		√	nextval('"SupplyStockMeasurePackages_id_seq"'::regclass)
SupplyStockMeasurePackagesData	id	serial	10		√	nextval('"SupplyStockMeasurePackagesData_id_seq"'::regclass)
SupplyStockMeasures	id	serial	10		√	nextval('"SupplyStockMeasures_id_seq"'::regclass)
SupplyStockMeasuresData	id	serial	10		√	nextval('"SupplyStockMeasuresData_id_seq"'::regclass)
SupplyTechs	id	serial	10		√	nextval('"SupplyTechs_id_seq"'::regclass)
SupplyTechsCapacityFactorData	id	serial	10		√	nextval('"SupplyTechsCapacityFactorData_id_seq"'::regclass)
SupplyTechsCapitalCostNewData	id	serial	10		√	nextval('"SupplyTechsCapitalCostNewData_id_seq"'::regclass)
SupplyTechsCapitalCostReplacementData	id	serial	10		√	nextval('"SupplyTechsCapitalCostReplacementData_id_seq"'::regclass)
SupplyTechsCO2CaptureData	id	serial	10		√	nextval('"SupplyTechsCO2CaptureData_id_seq"'::regclass)
SupplyTechsEfficiencyData	id	serial	10		√	nextval('"SupplyTechsEfficiencyData_id_seq"'::regclass)
SupplyTechsFixedMaintenanceCostData	id	serial	10		√	nextval('"SupplyTechsFixedMaintenanceCostData_id_seq"'::regclass)
SupplyTechsInstallationCostNewData	id	serial	10		√	nextval('"SupplyTechsInstallationCostNewData_id_seq"'::regclass)
SupplyTechsInstallationCostReplacementData	id	serial	10		√	nextval('"SupplyTechsInstallationCostReplacementData_id_seq"'::regclass)
SupplyTechsVariableMaintenanceCostData	id	serial	10		√	nextval('"SupplyTechsVariableMaintenanceCostData_id_seq"'::regclass)
SupplyTypes	id	serial	10		√	nextval('"SupplyTypes_id_seq"'::regclass)
TimeZones	id	serial	10		√	nextval('"TimeZones_id_seq"'::regclass)
IDMap	identifier_id	text	2147483647
ImportCost	import_node_id	int4	10
ImportCostData	import_node_id	int4	10	√		null
IndexLevels	index_level	text	2147483647	√		null
DemandCO2CaptureMeasures	input_type_id	int4	10	√		null
DemandDrivers	input_type_id	int4	10	√		null	Input data is either a total or an intensity.
DemandEnergyDemands	input_type_id	int4	10	√		null	Input data is either a total or an intensity.
DemandEnergyEfficiencyMeasures	input_type_id	int4	10	√		null
DemandFuelSwitchingMeasuresImpact	input_type_id	int4	10	√		null
DemandSales	input_type_id	int4	10	√		null	Input data is either a total or an intensity.
DemandSalesMeasures	input_type_id	int4	10	√		null
DemandServiceDemandMeasures	input_type_id	int4	10	√		null
DemandServiceDemands	input_type_id	int4	10	√		null	Input data is either a total or an intensity.
DemandStock	input_type_id	int4	10	√		null	Total or intensity.
DispatchFeedersAllocation	input_type_id	int4	10	√		null
Shapes	input_type_id	int4	10	√		null
SupplyEfficiency	input_unit	text	2147483647	√		null
SupplyTechsEfficiency	input_unit	text	2147483647	√		null
SupplyCapacityFactor	interpolation_method	int4	10	√		null
SupplySales	interpolation_method	int4	10	√		null
SupplySalesShare	interpolation_method	int4	10	√		null
BlendNodeBlendMeasures	interpolation_method_id	int4	10	√		null
DemandCO2CaptureMeasures	interpolation_method_id	int4	10	√		null
DemandDrivers	interpolation_method_id	int4	10	√		null	Cleaning method used to interpolate between missing years when data is entered.
DemandEnergyDemands	interpolation_method_id	int4	10	√		null	Cleaning method used to interpolate between missing years when data is entered.
DemandEnergyEfficiencyMeasures	interpolation_method_id	int4	10	√		null
DemandEnergyEfficiencyMeasuresCost	interpolation_method_id	int4	10	√		null
DemandFlexibleLoadMeasures	interpolation_method_id	int4	10	√		null
DemandFuelSwitchingMeasuresCost	interpolation_method_id	int4	10	√		null
DemandFuelSwitchingMeasuresEnergyIntensity	interpolation_method_id	int4	10	√		null
DemandFuelSwitchingMeasuresImpact	interpolation_method_id	int4	10	√		null
DemandSales	interpolation_method_id	int4	10	√		null	Cleaning method used to interpolate between missing years when data is entered.
DemandSalesMeasures	interpolation_method_id	int4	10	√		null
DemandServiceDemandMeasures	interpolation_method_id	int4	10	√		null
DemandServiceDemandMeasuresCost	interpolation_method_id	int4	10	√		null
DemandServiceDemands	interpolation_method_id	int4	10	√		null	Cleaning method used to interpolate between missing years when data is entered.
DemandServiceEfficiency	interpolation_method_id	int4	10	√		null	Cleaning method used to interpolate between missing years when data is entered.
DemandStock	interpolation_method_id	int4	10	√		null	Cleaning method used to interpolate between missing years when data is entered.
DemandStockMeasures	interpolation_method_id	int4	10	√		null
DemandTechsAuxEfficiency	interpolation_method_id	int4	10	√		null
DemandTechsCapitalCost	interpolation_method_id	int4	10	√		1	Cleaning method used to interpolate between missing years when data is entered.
DemandTechsFixedMaintenanceCost	interpolation_method_id	int4	10	√		null
DemandTechsFuelSwitchCost	interpolation_method_id	int4	10	√		null
DemandTechsInstallationCost	interpolation_method_id	int4	10	√		null
DemandTechsMainEfficiency	interpolation_method_id	int4	10	√		null
DemandTechsParasiticEnergy	interpolation_method_id	int4	10	√		null
DemandTechsServiceDemandModifier	interpolation_method_id	int4	10	√		null
DemandTechsServiceLink	interpolation_method_id	int4	10	√		null
DispatchFeedersAllocation	interpolation_method_id	int4	10	√		null
ImportCost	interpolation_method_id	int4	10	√		null
PrimaryCost	interpolation_method_id	int4	10	√		null
Shapes	interpolation_method_id	int4	10	√		null
StorageTechsCapacityCapitalCost	interpolation_method_id	int4	10	√		null
StorageTechsEnergyCapitalCost	interpolation_method_id	int4	10	√		null
SupplyCost	interpolation_method_id	int4	10	√		null
SupplyEfficiency	interpolation_method_id	int4	10	√		null
SupplyEmissions	interpolation_method_id	int4	10	√		null
SupplyExport	interpolation_method_id	int4	10	√		null
SupplyExportMeasures	interpolation_method_id	int4	10	√		null
SupplyPotential	interpolation_method_id	int4	10	√		null
SupplyPotentialConversion	interpolation_method_id	int4	10	√		null
SupplySalesMeasures	interpolation_method_id	int4	10	√		null
SupplySalesShareMeasures	interpolation_method_id	int4	10	√		null
SupplyStock	interpolation_method_id	int4	10	√		null
SupplyStockMeasures	interpolation_method_id	int4	10	√		null
SupplyTechsCapacityFactor	interpolation_method_id	int4	10	√		null
SupplyTechsCapitalCost	interpolation_method_id	int4	10	√		null
SupplyTechsCO2Capture	interpolation_method_id	int4	10	√		null
SupplyTechsEfficiency	interpolation_method_id	int4	10	√		null
SupplyTechsFixedMaintenanceCost	interpolation_method_id	int4	10	√		null
SupplyTechsInstallationCost	interpolation_method_id	int4	10	√		null
SupplyTechsVariableMaintenanceCost	interpolation_method_id	int4	10	√		null
GeographyIntersectionData	intersection_id	int4	10
GeographyMap	intersection_id	int4	10
DemandSubsectors	is_active	bool	1	√		false	Boolean indicating whether to include a subsector in the analysis. Useful for testing.
SupplyNodes	is_active	bool	1	√		null
SupplyCost	is_capital_cost	bool	1	√		false
SupplyNodes	is_curtailable	int4	10	√		null
SupplyNodes	is_exportable	int4	10	√		null
SupplyNodes	is_flexible	int4	10	√		null
CapitalCostOutputs	is_levelized	bool	1	√		null
Demand Technologies - Capital Costs	is_levelized	bool	1	√		null
Demand Technologies - Fuel Switching Costs	is_levelized	bool	1	√		null
Demand Techs - Installation Costs	is_levelized	bool	1	√		null
DemandEnergyEfficiencyMeasuresCost	is_levelized	bool	1	√		null
DemandFuelSwitchingMeasuresCost	is_levelized	bool	1	√		null
DemandServiceDemandMeasuresCost	is_levelized	bool	1	√		null
DemandTechsCapitalCost	is_levelized	bool	1	√		false	Is the given capital cost in levelized terms?
DemandTechsFuelSwitchCost	is_levelized	bool	1	√		false
DemandTechsInstallationCost	is_levelized	bool	1	√		false
StorageTechsCapacityCapitalCost	is_levelized	bool	1	√		null
StorageTechsEnergyCapitalCost	is_levelized	bool	1	√		null
SupplyTechsCapitalCost	is_levelized	bool	1	√		null
SupplyTechsInstallationCost	is_levelized	bool	1	√		false
Demand Technologies - Auxiliary Efficiency	is_numerator_service	bool	1	√		null
Demand Technologies - Main Efficiency	is_numerator_service	bool	1	√		null
DemandTechsAuxEfficiency	is_numerator_service	bool	1	√		null
DemandTechsMainEfficiency	is_numerator_service	bool	1	√		null
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
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).
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
DispatchConfig	large_storage_duration	int4	10	√		null
DemandCO2CaptureMeasures	lifetime_variance	float4	8,8	√		null
DemandEnergyEfficiencyMeasures	lifetime_variance	float4	8,8	√		null
DemandFuelSwitchingMeasures	lifetime_variance	float4	8,8	√		null
DemandServiceDemandMeasures	lifetime_variance	float4	8,8	√		null
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.
SupplyNodes	lifetime_variance	float4	8,8	√		null
SupplyTechs	lifetime_variance	float4	8,8	√		null
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.
DemandServiceLink	linked_subsector_id	int4	10	√		null	Dependent subsector. In our example, this would be hot water heating.
GreenhouseGases	long_name	text	2147483647	√		null
SupplyEmissions	mass_unit	text	2147483647	√		null
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.
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.
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.
SupplyNodes	max_lag_hours	int4	10	√		null
SupplyTechs	max_lag_hours	int4	10	√		null
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.
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.
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.
SupplyNodes	max_lead_hours	int4	10	√		null
SupplyTechs	max_lead_hours	int4	10	√		null
DemandCO2CaptureMeasures	max_lifetime	float4	8,8	√		null
DemandEnergyEfficiencyMeasures	max_lifetime	float4	8,8	√		null
DemandFuelSwitchingMeasures	max_lifetime	float4	8,8	√		null
DemandServiceDemandMeasures	max_lifetime	float4	8,8	√		null
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.
SupplyNodes	max_lifetime	float4	8,8	√		null
SupplyTechs	max_lifetime	float4	8,8	√		null
DemandCO2CaptureMeasures	mean_lifetime	float4	8,8	√		null
DemandEnergyEfficiencyMeasures	mean_lifetime	float4	8,8	√		null
DemandFuelSwitchingMeasures	mean_lifetime	float4	8,8	√		null
DemandServiceDemandMeasures	mean_lifetime	float4	8,8	√		null
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.
SupplyNodes	mean_lifetime	float4	8,8	√		null
SupplyTechs	mean_lifetime	float4	8,8	√		null
BlendNodeBlendMeasurePackagesData	measure_id	int4	10	√		null
DemandEnergyEfficiencyMeasurePackagesData	measure_id	int4	10	√		null
DemandFlexibleLoadMeasurePackagesData	measure_id	int4	10	√		null
DemandFuelSwitchingMeasurePackagesData	measure_id	int4	10	√		null
DemandSalesMeasurePackagesData	measure_id	int4	10	√		null
DemandServiceDemandMeasurePackagesData	measure_id	int4	10	√		null
DemandStockMeasurePackagesData	measure_id	int4	10	√		null
SupplyExportMeasurePackagesData	measure_id	int4	10	√		null
SupplySalesMeasurePackagesData	measure_id	int4	10	√		null
SupplySalesShareMeasurePackagesData	measure_id	int4	10	√		null
SupplyStockMeasurePackagesData	measure_id	int4	10	√		null
DemandCO2CaptureMeasures	min_lifetime	float4	8,8	√		null
DemandEnergyEfficiencyMeasures	min_lifetime	float4	8,8	√		null
DemandFuelSwitchingMeasures	min_lifetime	float4	8,8	√		null
DemandServiceDemandMeasures	min_lifetime	float4	8,8	√		null
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.
SupplyNodes	min_lifetime	float4	8,8	√		null
SupplyTechs	min_lifetime	float4	8,8	√		null
DispatchNodeData	month	int4	10	√		null
ShapesData	month	int4	10	√		null
AgeGrowthOrDecayType	name	text	2147483647	√		null
BlendMeasuresData	name	text	2147483647	√		null
BlendNodeBlendMeasurePackages	name	text	2147483647	√		null
BlendNodeBlendMeasures	name	text	2147483647	√		null
CapitalCostOutputs	name	text	2147483647	√		null
CleaningMethods	name	text	2147483647				name for the cleaning method, checked for in code time_series.py
Currencies	name	text	2147483647	√		null
DayType	name	text	2147483647	√		null
Definitions	name	text	2147483647
Demand Technologies - Auxiliary Efficiency	name	text	2147483647	√		null
Demand Technologies - Capital Costs	name	text	2147483647	√		null
Demand Technologies - Fixed OM	name	text	2147483647	√		null
Demand Technologies - Fuel Switching Costs	name	text	2147483647	√		null
Demand Technologies - Main Efficiency	name	text	2147483647	√		null
Demand Technologies - Parasitic Energy	name	text	2147483647	√		null
Demand Techs - Installation Costs	name	text	2147483647	√		null
DemandCases	name	text	2147483647	√		null
DemandCO2CaptureMeasures	name	text	2147483647	√		null
DemandDrivers	name	text	2147483647	√		null
DemandEnergyEfficiencyMeasurePackages	name	text	2147483647	√		null
DemandEnergyEfficiencyMeasures	name	text	2147483647	√		null
DemandFlexibleLoadMeasurePackages	name	text	2147483647	√		null
DemandFuelSwitchingMeasurePackages	name	text	2147483647	√		null
DemandFuelSwitchingMeasures	name	text	2147483647	√		null
DemandSalesMeasurePackages	name	text	2147483647	√		null
DemandSalesMeasures	name	text	2147483647	√		null
DemandSectors	name	text	2147483647
DemandServiceDemandMeasurePackages	name	text	2147483647	√		null
DemandServiceDemandMeasures	name	text	2147483647	√		null
DemandStockMeasurePackages	name	text	2147483647	√		null
DemandStockMeasures	name	text	2147483647	√		null
DemandStockUnitTypes	name	text	2147483647
DemandSubsectors	name	text	2147483647	√		null
DemandTechEfficiencyTypes	name	text	2147483647	√		null
DemandTechs	name	text	2147483647	√		null	Technology name.
DemandTechUnitTypes	name	text	2147483647	√		null
DispatchConstraintTypes	name	text	2147483647	√		null
DispatchFeeders	name	text	2147483647
DispatchWindows	name	text	2147483647
EfficiencyTypes	name	text	2147483647	√		null
FinalEnergy	name	text	2147483647	√		null
FlexibleLoadShiftTypes	name	text	2147483647	√		null
Geographies	name	text	2147483647
GeographiesData	name	text	2147483647	√		null
GeographyMapKeys	name	text	2147483647
GreenhouseGasEmissionsType	name	text	2147483647
GreenhouseGases	name	text	2147483647	√		null
InputTypes	name	text	2147483647
OtherIndexes	name	text	2147483647	√		null
OtherIndexesData	name	text	2147483647	√		null
OtherIndexesData_copy	name	text	2147483647	√		null
OthIndex	name	text	2147483647	√		null
SalesMeasureNameTech	name	text	2147483647	√		null
SalesMeasureReplacedTech	name	text	2147483647	√		null
Scenarios	name	text	2147483647	√		null
Shapes	name	text	2147483647	√		null
ShapesTypes	name	text	2147483647	√		null
ShapesUnits	name	text	2147483647	√		null
StockDecayFunctions	name	text	2147483647	√		null
SupplyCases	name	text	2147483647	√		null
SupplyCost	name	text	2147483647	√		null
SupplyCostTypes	name	text	2147483647	√		null
SupplyExportMeasurePackages	name	text	2147483647	√		null
SupplyExportMeasures	name	text	2147483647	√		null
SupplyNodes	name	text	2147483647	√		null
SupplySalesMeasurePackages	name	text	2147483647	√		null
SupplySalesMeasures	name	text	2147483647	√		null
SupplySalesShareMeasurePackages	name	text	2147483647	√		null
SupplySalesShareMeasures	name	text	2147483647	√		null
SupplyStockMeasurePackages	name	text	2147483647	√		null
SupplyStockMeasures	name	text	2147483647	√		null
SupplyTechs	name	text	2147483647
SupplyTypes	name	text	2147483647
TimeZones	name	text	2147483647	√		null
ImportCost	notes	text	2147483647	√		null
SupplyEfficiency	notes	text	2147483647	√		null
SupplyEmissions	notes	text	2147483647	√		null
SupplyTechsCapitalCost	notes	text	2147483647	√		null
SupplyTechsEfficiency	notes	text	2147483647	√		null
SupplyTechsFixedMaintenanceCost	notes	text	2147483647	√		null
SupplyTechsInstallationCost	notes	text	2147483647	√		null
SupplyTechsVariableMaintenanceCost	notes	text	2147483647	√		null
Demand Technologies - Auxiliary Efficiency	numerator_unit	text	2147483647	√		null
Demand Technologies - Main Efficiency	numerator_unit	text	2147483647	√		null
DemandTechsAuxEfficiency	numerator_unit	text	2147483647	√		null
DemandTechsMainEfficiency	numerator_unit	text	2147483647	√		null
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.
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.
DemandEnergyEfficiencyMeasuresCostData	oth_1_id	int4	10	√		null
DemandEnergyEfficiencyMeasuresData	oth_1_id	int4	10	√		null
DemandFlexibleLoadMeasuresData	oth_1_id	int4	10	√		null
DemandFuelSwitchingMeasuresCostData	oth_1_id	int4	10	√		null
DemandFuelSwitchingMeasuresEnergyIntensityData	oth_1_id	int4	10	√		null
DemandFuelSwitchingMeasuresImpactData	oth_1_id	int4	10	√		null
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.
DemandSalesMeasuresData	oth_1_id	int4	10	√		null
DemandServiceDemandMeasuresCostData	oth_1_id	int4	10	√		null
DemandServiceDemandMeasuresData	oth_1_id	int4	10	√		null
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.
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.
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.
DemandStockMeasuresData	oth_1_id	int4	10	√		null
DemandTechsAuxEfficiencyData	oth_1_id	int4	10	√		null
DemandTechsCapitalCostNewData	oth_1_id	int4	10	√		null
DemandTechsCapitalCostReplacementData	oth_1_id	int4	10	√		null
DemandTechsFixedMaintenanceCostData	oth_1_id	int4	10	√		null
DemandTechsFuelSwitchCostData	oth_1_id	int4	10	√		null
DemandTechsInstallationCostNewData	oth_1_id	int4	10	√		null
DemandTechsInstallationCostReplacementData	oth_1_id	int4	10	√		null
DemandTechsMainEfficiencyData	oth_1_id	int4	10	√		null
DemandTechsParasiticEnergyData	oth_1_id	int4	10	√		null
DemandTechsServiceDemandModifierData	oth_1_id	int4	10	√		null
DemandTechsServiceLinkData	oth_1_id	int4	10	√		null
EnergyDemand	oth_1_id	int4	10	√		null
EnergyDemandData0Index	oth_1_id	int4	10	√		null
EnergyDemandData1Index	oth_1_id	int4	10	√		null
PrimaryCostData	oth_1_id	int4	10	√		null
StorageTechsCapacityCapitalCostNewData	oth_1_id	int4	10	√		null
StorageTechsCapacityCapitalCostReplacementData	oth_1_id	int4	10	√		null
StorageTechsEnergyCapitalCostNewData	oth_1_id	int4	10	√		null
StorageTechsEnergyCapitalCostReplacementData	oth_1_id	int4	10	√		null
SupplyEmissionsData	oth_1_id	int4	10	√		null
SupplyExportData	oth_1_id	int4	10	√		null
SupplyExportMeasuresData	oth_1_id	int4	10	√		null
SupplyPotentialConversionData	oth_1_id	int4	10	√		null
SupplyPotentialData	oth_1_id	int4	10	√		null
SupplySalesMeasuresData	oth_1_id	int4	10	√		null
SupplySalesShareMeasuresData	oth_1_id	int4	10	√		null
SupplyStockMeasuresData	oth_1_id	int4	10	√		null
SupplyTechsCapacityFactorData	oth_1_id	int4	10	√		null
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.
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.
DemandEnergyEfficiencyMeasuresCostData	oth_2_id	int4	10	√		null
DemandEnergyEfficiencyMeasuresData	oth_2_id	int4	10	√		null
DemandFuelSwitchingMeasuresCostData	oth_2_id	int4	10	√		null
DemandFuelSwitchingMeasuresEnergyIntensityData	oth_2_id	int4	10	√		null
DemandFuelSwitchingMeasuresImpactData	oth_2_id	int4	10	√		null
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.
DemandServiceDemandMeasuresCostData	oth_2_id	int4	10	√		null
DemandServiceDemandMeasuresData	oth_2_id	int4	10	√		null
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.
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.
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.
DemandTechsAuxEfficiencyData	oth_2_id	int4	10	√		null
DemandTechsCapitalCostNewData	oth_2_id	int4	10	√		null
DemandTechsCapitalCostReplacementData	oth_2_id	int4	10	√		null
DemandTechsFixedMaintenanceCostData	oth_2_id	int4	10	√		null
DemandTechsFuelSwitchCostData	oth_2_id	int4	10	√		null
DemandTechsInstallationCostNewData	oth_2_id	int4	10	√		null
DemandTechsInstallationCostReplacementData	oth_2_id	int4	10	√		null
DemandTechsMainEfficiencyData	oth_2_id	int4	10	√		null
DemandTechsParasiticEnergyData	oth_2_id	int4	10	√		null
DemandTechsServiceDemandModifierData	oth_2_id	int4	10	√		null
DemandTechsServiceLinkData	oth_2_id	int4	10	√		null
EnergyDemand	oth_2_id	int4	10	√		null
EnergyDemandData0Index	oth_2_id	int4	10	√		null
EnergyDemandData1Index	oth_2_id	int4	10	√		null
StorageTechsCapacityCapitalCostNewData	oth_2_id	int4	10	√		null
StorageTechsCapacityCapitalCostReplacementData	oth_2_id	int4	10	√		null
StorageTechsEnergyCapitalCostNewData	oth_2_id	int4	10	√		null
StorageTechsEnergyCapitalCostReplacementData	oth_2_id	int4	10	√		null
SupplyExport	oth_index_1_id	int4	10	√		null
Demand Technologies - Auxiliary Efficiency	Other Index	text	2147483647	√		null
Demand Technologies - Capital Costs	Other Index	text	2147483647	√		null
Demand Technologies - Fixed OM	Other Index	text	2147483647	√		null
Demand Technologies - Fuel Switching Costs	Other Index	text	2147483647	√		null
Demand Technologies - Main Efficiency	Other Index	text	2147483647	√		null
Demand Technologies - Parasitic Energy	Other Index	text	2147483647	√		null
Demand Techs - Installation Costs	Other Index	text	2147483647	√		null
EnergyDemand	Other Index 1	text	2147483647	√		null
EnergyDemandData1Index	Other Index 1	text	2147483647	√		null
EnergyDemand	Other Index 2	text	2147483647	√		null
BlendNodeBlendMeasures	other_index_1_id	int4	10	√		null
DemandCO2CaptureMeasures	other_index_1_id	int4	10	√		null
DemandDrivers	other_index_1_id	int4	10	√		null	First sub category for the input data (e.g. housing type)
DemandEnergyDemands	other_index_1_id	int4	10	√		null	First sub category for the input data (e.g. housing type)
DemandEnergyEfficiencyMeasures	other_index_1_id	int4	10	√		null
DemandEnergyEfficiencyMeasuresCost	other_index_1_id	int4	10	√		null
DemandFlexibleLoadMeasures	other_index_1_id	int4	10	√		null
DemandFuelSwitchingMeasuresCost	other_index_1_id	int4	10	√		null
DemandFuelSwitchingMeasuresEnergyIntensity	other_index_1_id	int4	10	√		null
DemandFuelSwitchingMeasuresImpact	other_index_1_id	int4	10	√		null
DemandSales	other_index_1_id	int4	10	√		null	First sub category for the input data (e.g. housing type)
DemandSalesMeasures	other_index_1_id	int4	10	√		null
DemandServiceDemandMeasures	other_index_1_id	int4	10	√		null
DemandServiceDemandMeasuresCost	other_index_1_id	int4	10	√		null
DemandServiceDemands	other_index_1_id	int4	10	√		null	First sub category for the input data (e.g. housing type)
DemandServiceEfficiency	other_index_1_id	int4	10	√		null	First sub category for the input data (e.g. housing type)
DemandStock	other_index_1_id	int4	10	√		null	First sub category for the input data (e.g. housing type)
DemandStockMeasures	other_index_1_id	int4	10	√		null
DemandTechsAuxEfficiency	other_index_1_id	int4	10	√		null
DemandTechsCapitalCost	other_index_1_id	int4	10	√		null	First sub category for the input data (e.g. housing type)
DemandTechsFixedMaintenanceCost	other_index_1_id	int4	10	√		null
DemandTechsFuelSwitchCost	other_index_1_id	int4	10	√		null
DemandTechsInstallationCost	other_index_1_id	int4	10	√		null
DemandTechsMainEfficiency	other_index_1_id	int4	10	√		null
DemandTechsParasiticEnergy	other_index_1_id	int4	10	√		null
DemandTechsServiceDemandModifier	other_index_1_id	int4	10	√		null
DemandTechsServiceLink	other_index_1_id	int4	10	√		null
PrimaryCost	other_index_1_id	int4	10	√		null
Shapes	other_index_1_id	int4	10	√		null
SupplyEmissions	other_index_1_id	int4	10	√		null
SupplyExportMeasures	other_index_1_id	int4	10	√		null
SupplyPotential	other_index_1_id	int4	10	√		null
SupplyPotentialConversion	other_index_1_id	int4	10	√		null
SupplySalesMeasures	other_index_1_id	int4	10	√		null
SupplySalesShareMeasures	other_index_1_id	int4	10	√		null
SupplyStockMeasures	other_index_1_id	int4	10	√		null
DemandCO2CaptureMeasures	other_index_2_id	int4	10	√		null
DemandDrivers	other_index_2_id	int4	10	√		null	Second 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)
DemandEnergyEfficiencyMeasures	other_index_2_id	int4	10	√		null
DemandEnergyEfficiencyMeasuresCost	other_index_2_id	int4	10	√		null
DemandFuelSwitchingMeasuresCost	other_index_2_id	int4	10	√		null
DemandFuelSwitchingMeasuresEnergyIntensity	other_index_2_id	int4	10	√		null
DemandFuelSwitchingMeasuresImpact	other_index_2_id	int4	10	√		null
DemandSales	other_index_2_id	int4	10	√		null	Second sub category for the input data (e.g. housing type)
DemandServiceDemandMeasures	other_index_2_id	int4	10	√		null
DemandServiceDemandMeasuresCost	other_index_2_id	int4	10	√		null
DemandServiceDemands	other_index_2_id	int4	10	√		null	Second 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)
DemandStock	other_index_2_id	int4	10	√		null	Second sub category for the input data (e.g. housing type)
DemandTechsAuxEfficiency	other_index_2_id	int4	10	√		null
DemandTechsCapitalCost	other_index_2_id	int4	10	√		null	Second sub category for the input data (e.g. housing type)
DemandTechsFixedMaintenanceCost	other_index_2_id	int4	10	√		null
DemandTechsFuelSwitchCost	other_index_2_id	int4	10	√		null
DemandTechsInstallationCost	other_index_2_id	int4	10	√		null
DemandTechsMainEfficiency	other_index_2_id	int4	10	√		null
DemandTechsParasiticEnergy	other_index_2_id	int4	10	√		null
DemandTechsServiceDemandModifier	other_index_2_id	int4	10	√		null
DemandTechsServiceLink	other_index_2_id	int4	10	√		null
Shapes	other_index_2_id	int4	10	√		null
OtherIndexesData	other_index_id	int4	10	√		null
OtherIndexesData_copy	other_index_id	int4	10	√		null
OthIndex	OtherIndexName	text	2147483647	√		null
SupplyEfficiency	output_unit	text	2147483647	√		null
SupplyTechsEfficiency	output_unit	text	2147483647	√		null
DispatchNodeData	p_max	float8	17,17	√		null
DispatchNodeData	p_min	float8	17,17	√		null
BlendNodeBlendMeasurePackagesData	package_id	int4	10	√		null
DemandEnergyEfficiencyMeasurePackagesData	package_id	int4	10	√		null
DemandFlexibleLoadMeasurePackagesData	package_id	int4	10	√		null
DemandFuelSwitchingMeasurePackagesData	package_id	int4	10	√		null
DemandSalesMeasurePackagesData	package_id	int4	10	√		null
DemandServiceDemandMeasurePackagesData	package_id	int4	10	√		null
DemandStockMeasurePackagesData	package_id	int4	10	√		null
SupplyExportMeasurePackagesData	package_id	int4	10	√		null
SupplySalesMeasurePackagesData	package_id	int4	10	√		null
SupplySalesShareMeasurePackagesData	package_id	int4	10	√		null
SupplyStockMeasurePackagesData	package_id	int4	10	√		null
BlendNodeBlendMeasuresData	parent_id	int4	10	√		null
DemandDriversData	parent_id	int4	10	√		null	id in parent table
DemandEnergyEfficiencyMeasuresCost	parent_id	int4	10
DemandEnergyEfficiencyMeasuresCostData	parent_id	int4	10	√		null
DemandEnergyEfficiencyMeasuresData	parent_id	int4	10	√		null
DemandFlexibleLoadMeasuresData	parent_id	int4	10	√		null
DemandFuelSwitchingMeasuresCost	parent_id	int4	10
DemandFuelSwitchingMeasuresCostData	parent_id	int4	10	√		null
DemandFuelSwitchingMeasuresEnergyIntensity	parent_id	int4	10	√		null
DemandFuelSwitchingMeasuresEnergyIntensityData	parent_id	int4	10	√		null
DemandFuelSwitchingMeasuresImpact	parent_id	int4	10	√		null
DemandFuelSwitchingMeasuresImpactData	parent_id	int4	10	√		null
DemandSalesMeasuresData	parent_id	int4	10	√		null
DemandServiceDemandMeasuresCost	parent_id	int4	10
DemandServiceDemandMeasuresCostData	parent_id	int4	10	√		null
DemandServiceDemandMeasuresData	parent_id	int4	10	√		null
DemandStockMeasuresData	parent_id	int4	10	√		null
DemandTechsServiceLinkData	parent_id	int4	10	√		null
DispatchFeedersAllocationData	parent_id	int4	10	√		null
ShapesData	parent_id	int4	10	√		null
SupplyCostData	parent_id	int4	10	√		null
SupplyEfficiencyData	parent_id	int4	10	√		null
SupplyExportMeasuresData	parent_id	int4	10	√		null
SupplySalesMeasuresData	parent_id	int4	10	√		null
SupplySalesShareMeasuresData	parent_id	int4	10	√		null
SupplyStockMeasuresData	parent_id	int4	10	√		null
PrimaryCost	primary_node_id	int4	10
PrimaryCostData	primary_node_id	int4	10	√		null
IDMap	ref_table	text	2147483647	√		null
DemandTechsServiceLink	reference_id	int4	10	√		null
DemandTechsAuxEfficiency	reference_tech_id	int4	10	√		null
DemandTechsCapitalCost	reference_tech_id	int4	10	√		null	If the input is relative, what technology is used as the reference?
DemandTechsFixedMaintenanceCost	reference_tech_id	int4	10	√		null
DemandTechsFuelSwitchCost	reference_tech_id	int4	10	√		null
DemandTechsInstallationCost	reference_tech_id	int4	10	√		null
DemandTechsMainEfficiency	reference_tech_id	int4	10	√		null
DemandTechsParasiticEnergy	reference_tech_id	int4	10	√		null
StorageTechsCapacityCapitalCost	reference_tech_id	int4	10	√		null
StorageTechsEnergyCapitalCost	reference_tech_id	int4	10	√		null
SupplyTechsCapacityFactor	reference_tech_id	int4	10	√		null
SupplyTechsCapitalCost	reference_tech_id	int4	10	√		null
SupplyTechsCO2Capture	reference_tech_id	int4	10	√		null
SupplyTechsEfficiency	reference_tech_id	int4	10	√		null
SupplyTechsFixedMaintenanceCost	reference_tech_id	int4	10	√		null
SupplyTechsInstallationCost	reference_tech_id	int4	10	√		null
SupplyTechsVariableMaintenanceCost	reference_tech_id	int4	10	√		null
DemandSalesMeasures	replaced_demand_tech_id	int4	10	√		null
SupplySalesShareMeasures	replaced_supply_technology_id	int4	10	√		null
SupplyNodes	residual_supply_node_id	int4	10	√		null
PrimaryCostData	resource_bin	int4	10	√		null
ShapesData	resource_bin	int4	10	√		null
SupplyCapacityFactorData	resource_bin	int4	10	√		null
SupplyCostData	resource_bin	int4	10	√		null
SupplyEfficiencyData	resource_bin	int4	10	√		null
SupplyExportData	resource_bin	int4	10	√		null
SupplyPotentialConversionData	resource_bin	int4	10	√		null
SupplyPotentialData	resource_bin	int4	10	√		null
SupplySalesData	resource_bin	int4	10	√		null
SupplySalesMeasuresData	resource_bin	int4	10	√		null
SupplySalesShareMeasuresData	resource_bin	int4	10	√		null
SupplyStockData	resource_bin	int4	10	√		null
SupplyStockMeasuresData	resource_bin	int2	5	√		null
SupplyTechsCapacityFactorData	resource_bin	int4	10	√		null
SupplyTechsCapitalCostNewData	resource_bin	int4	10	√		null
SupplyTechsCapitalCostReplacementData	resource_bin	int4	10	√		null
SupplyTechsCO2CaptureData	resource_bin	int4	10	√		null
SupplyTechsEfficiencyData	resource_bin	int4	10	√		null
SupplyTechsFixedMaintenanceCostData	resource_bin	int4	10	√		null
SupplyTechsInstallationCostNewData	resource_bin	int4	10	√		null
SupplyTechsInstallationCostReplacementData	resource_bin	int4	10	√		null
SupplyTechsVariableMaintenanceCostData	resource_bin	int4	10	√		null
SupplyPotentialConversion	resource_unit_denominator	text	2147483647	√		null
DemandStates	sales_package_id	int4	10	√		null
SupplyStates	sales_package_id	int4	10	√		null
SupplyStates	sales_share_package_id	int4	10	√		null
Demand Technologies - Auxiliary Efficiency	Sector	text	2147483647	√		null
Demand Technologies - Capital Costs	Sector	text	2147483647	√		null
Demand Technologies - Fixed OM	Sector	text	2147483647	√		null
Demand Technologies - Fuel Switching Costs	Sector	text	2147483647	√		null
Demand Technologies - Main Efficiency	Sector	text	2147483647	√		null
Demand Technologies - Parasitic Energy	Sector	text	2147483647	√		null
Demand Techs - Installation Costs	Sector	text	2147483647	√		null
DemandSubsectors	sector_id	int4	10	√		null	Parent sector id.
DemandStates	service_demand_package_id	int4	10	√		null
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%.
DemandTechsServiceLink	service_link_id	int4	10	√		null
DemandSectors	shape_id	int4	10	√		null	Default electricity shape for the sector
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.
DemandTechs	shape_id	int4	10	√		null	Electricity consumption shape for the technology. This is used when building an aggregate load shape, bottom up.
DemandTechsAuxEfficiency	shape_id	int4	10	√		null
DemandTechsMainEfficiency	shape_id	int4	10	√		null
FinalEnergy	shape_id	int4	10	√		null
SupplyNodes	shape_id	int4	10	√		null
SupplyTechs	shape_id	int4	10	√		null
Shapes	shape_type_id	int4	10	√		null
Shapes	shape_unit_type_id	int4	10	√		null
DemandTechs	source	text	2147483647	√		null	Source for the technology data.
ImportCost	source	text	2147483647	√		null
SupplyCost	source	text	2147483647	√		null
SupplyEfficiency	source	text	2147483647	√		null
SupplyEmissions	source	text	2147483647	√		null
SupplyTechs	source	text	2147483647	√		null
SupplyTechsCapitalCost	source	text	2147483647	√		null
SupplyTechsEfficiency	source	text	2147483647	√		null
SupplyTechsFixedMaintenanceCost	source	text	2147483647	√		null
SupplyTechsInstallationCost	source	text	2147483647	√		null
SupplyTechsVariableMaintenanceCost	source	text	2147483647	√		null
DemandCO2CaptureMeasures	stock_decay_function_id	int4	10	√		null
DemandEnergyEfficiencyMeasures	stock_decay_function_id	int4	10	√		null
DemandFuelSwitchingMeasures	stock_decay_function_id	int4	10	√		null
DemandServiceDemandMeasures	stock_decay_function_id	int4	10	√		null
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).
SupplyNodes	stock_decay_function_id	int4	10	√		null
SupplyTechs	stock_decay_function_id	int4	10	√		null
DemandTechs	stock_link_ratio	float4	8,8	√		null	Moderates the degree to which two technologies are linked.
DemandStates	stock_package_id	int4	10	√		null
SupplyStates	stock_package_id	int4	10	√		null
Demand Technologies - Auxiliary Efficiency	Subsector	text	2147483647	√		null
Demand Technologies - Capital Costs	Subsector	text	2147483647	√		null
Demand Technologies - Fixed OM	Subsector	text	2147483647	√		null
Demand Technologies - Fuel Switching Costs	Subsector	text	2147483647	√		null
Demand Technologies - Main Efficiency	Subsector	text	2147483647	√		null
Demand Technologies - Parasitic Energy	Subsector	text	2147483647	√		null
Demand Techs - Installation Costs	Subsector	text	2147483647	√		null
EnergyDemand	Subsector	text	2147483647	√		null
EnergyDemandData0Index	Subsector	text	2147483647	√		null
EnergyDemandData1Index	Subsector	text	2147483647	√		null
DemandCO2CaptureMeasures	subsector_id	int4	10	√		null
DemandEnergyDemands	subsector_id	int4	10				id for the demand subsector
DemandEnergyDemandsData	subsector_id	int4	10	√		null
DemandEnergyEfficiencyMeasurePackages	subsector_id	int4	10	√		null
DemandEnergyEfficiencyMeasures	subsector_id	int4	10	√		null
DemandFlexibleLoadMeasurePackages	subsector_id	int4	10	√		null
DemandFlexibleLoadMeasures	subsector_id	int4	10	√		null
DemandFuelSwitchingMeasurePackages	subsector_id	int4	10	√		null
DemandFuelSwitchingMeasures	subsector_id	int4	10	√		null
DemandSales	subsector_id	int4	10
DemandSalesData	subsector_id	int4	10	√		null
DemandSalesMeasurePackages	subsector_id	int4	10	√		null
DemandSalesMeasures	subsector_id	int4	10	√		null
DemandServiceDemandMeasurePackages	subsector_id	int4	10	√		null
DemandServiceDemandMeasures	subsector_id	int4	10	√		null
DemandServiceDemands	subsector_id	int4	10				Parent subsector id
DemandServiceDemandsData	subsector_id	int4	10	√		null	Parent subsector id
DemandServiceEfficiency	subsector_id	int4	10				Parent subsector.
DemandServiceEfficiencyData	subsector_id	int4	10	√		null	Parent subsector id.
DemandServiceLink	subsector_id	int4	10	√		null	Independent subsector in the link. In our example, this would be dishwashing.
DemandStates	subsector_id	int4	10	√		null
DemandStock	subsector_id	int4	10				Parent subsector.
DemandStockData	subsector_id	int4	10	√		null	Parent subsector id.
DemandStockMeasurePackages	subsector_id	int4	10	√		null
DemandStockMeasures	subsector_id	int4	10	√		null
DemandTechs	subsector_id	int4	10	√		null	Subsector where the technology is deployed.
EnergyDemand	subsector_id	int4	10	√		null
EnergyDemandData0Index	subsector_id	int4	10	√		null
EnergyDemandData1Index	subsector_id	int4	10	√		null
Scenarios	supply_case	int4	10	√		null
SupplyCasesData	supply_case_id	int4	10
SupplyCost	supply_cost_type_id	int4	10	√		null
BlendNodeBlendMeasures	supply_node_id	int4	10	√		null
BlendNodeInputsData	supply_node_id	int4	10	√		null
DispatchNodeConfig	supply_node_id	int4	10
DispatchNodeData	supply_node_id	int4	10	√		null
SupplyCapacityFactor	supply_node_id	int4	10
SupplyCapacityFactorData	supply_node_id	int4	10	√		null
SupplyCost	supply_node_id	int4	10	√		null
SupplyEfficiencyData	supply_node_id	int4	10	√		null
SupplyEmissions	supply_node_id	int4	10
SupplyEmissionsData	supply_node_id	int4	10	√		null
SupplyExport	supply_node_id	int4	10
SupplyExportData	supply_node_id	int4	10	√		null
SupplyExportMeasurePackages	supply_node_id	int4	10	√		null
SupplyExportMeasures	supply_node_id	int4	10	√		null
SupplyPotential	supply_node_id	int4	10
SupplyPotentialConversion	supply_node_id	int4	10
SupplyPotentialConversionData	supply_node_id	int4	10	√		null
SupplyPotentialData	supply_node_id	int4	10	√		null
SupplySales	supply_node_id	int4	10
SupplySalesData	supply_node_id	int4	10	√		null
SupplySalesMeasurePackages	supply_node_id	int4	10	√		null
SupplySalesMeasures	supply_node_id	int4	10	√		null
SupplySalesShare	supply_node_id	int4	10
SupplySalesShareData	supply_node_id	int4	10	√		null
SupplySalesShareMeasurePackages	supply_node_id	int4	10	√		null
SupplySalesShareMeasures	supply_node_id	int4	10	√		null
SupplyStates	supply_node_id	int4	10	√		null
SupplyStock	supply_node_id	int4	10
SupplyStockData	supply_node_id	int4	10	√		null
SupplyStockMeasurePackages	supply_node_id	int4	10	√		null
SupplyStockMeasures	supply_node_id	int4	10	√		null
SupplyTechs	supply_node_id	int4	10	√		null
SupplyTechsEfficiencyData	supply_node_id	int4	10	√		null
SupplyCasesData	supply_state_id	int4	10
StorageTechsCapacityCapitalCost	supply_tech_id	int4	10
StorageTechsCapacityCapitalCostNewData	supply_tech_id	int4	10
StorageTechsCapacityCapitalCostReplacementData	supply_tech_id	int4	10
StorageTechsEnergyCapitalCost	supply_tech_id	int4	10
StorageTechsEnergyCapitalCostNewData	supply_tech_id	int4	10	√		null
StorageTechsEnergyCapitalCostReplacementData	supply_tech_id	int4	10	√		null
SupplyTechsCapacityFactor	supply_tech_id	int4	10
SupplyTechsCapacityFactorData	supply_tech_id	int4	10	√		null
SupplyTechsCapitalCost	supply_tech_id	int4	10
SupplyTechsCapitalCostNewData	supply_tech_id	int4	10	√		null
SupplyTechsCapitalCostReplacementData	supply_tech_id	int4	10	√		null
SupplyTechsCO2Capture	supply_tech_id	int4	10
SupplyTechsCO2CaptureData	supply_tech_id	serial	10	√	√	nextval('"SupplyTechsCapacityFactorData_id_seq"'::regclass)
SupplyTechsEfficiency	supply_tech_id	int4	10
SupplyTechsEfficiencyData	supply_tech_id	int4	10	√		null
SupplyTechsFixedMaintenanceCost	supply_tech_id	int4	10
SupplyTechsFixedMaintenanceCostData	supply_tech_id	int4	10	√		null
SupplyTechsInstallationCost	supply_tech_id	int4	10
SupplyTechsInstallationCostNewData	supply_tech_id	int4	10	√		null
SupplyTechsInstallationCostReplacementData	supply_tech_id	int4	10	√		null
SupplyTechsVariableMaintenanceCost	supply_tech_id	int4	10
SupplyTechsVariableMaintenanceCostData	supply_tech_id	int4	10	√		null
SupplySalesData	supply_technology_id	int4	10	√		null
SupplySalesMeasures	supply_technology_id	int4	10	√		null
SupplySalesShareData	supply_technology_id	int4	10	√		null
SupplySalesShareMeasures	supply_technology_id	int4	10	√		null
SupplyStockData	supply_technology_id	int4	10	√		null
SupplyStockMeasures	supply_technology_id	int4	10	√		null
SupplyNodes	supply_type_id	int4	10	√		null
DispatchConfig	thermal_dispatch_node_id	int4	10	√		null
SupplyCost	throughput_correlation	float8	17,17	√		null
CapitalCostOutputs	time_unit	text	2147483647	√		null
Demand Technologies - Auxiliary Efficiency	time_unit	text	2147483647	√		null
Demand Technologies - Capital Costs	time_unit	text	2147483647	√		null
Demand Technologies - Fixed OM	time_unit	text	2147483647	√		null
Demand Technologies - Fuel Switching Costs	time_unit	text	2147483647	√		null
Demand Technologies - Main Efficiency	time_unit	text	2147483647	√		null
Demand Technologies - Parasitic Energy	time_unit	text	2147483647	√		null
Demand Techs - Installation Costs	time_unit	text	2147483647	√		null
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.
DemandTechs	time_unit	text	2147483647	√		null	If the unit is in energy terms, over what time period is that energy delivered.
DemandTechsParasiticEnergy	time_unit	text	2147483647	√		null
StorageTechsCapacityCapitalCost	time_unit	int4	10	√		null
SupplyCost	time_unit	text	2147483647	√		null
SupplyPotential	time_unit	int4	10	√		null
SupplySales	time_unit	text	2147483647	√		null
SupplySalesShareMeasures	time_unit	text	2147483647	√		null
SupplyStock	time_unit	text	2147483647	√		null
SupplyStockMeasures	time_unit	text	2147483647	√		null
SupplyTechsCapitalCost	time_unit	text	2147483647	√		null
SupplyTechsFixedMaintenanceCost	time_unit	text	2147483647	√		null
SupplyTechsInstallationCost	time_unit	text	2147483647	√		null
Shapes	time_zone_id	int4	10	√		null
ShapesData	timeshift_type_id	int4	10	√		null
SupplyNodes	tradable_geography_id	int4	10	√		null
DispatchConfig	transmission_node_id	int4	10	√		null
Demand Technologies - Auxiliary Efficiency	unit	text	2147483647	√		null
Demand Technologies - Capital Costs	unit	text	2147483647	√		null
Demand Technologies - Fixed OM	unit	text	2147483647	√		null
Demand Technologies - Fuel Switching Costs	unit	text	2147483647	√		null
Demand Technologies - Main Efficiency	unit	text	2147483647	√		null
Demand Techs - Installation Costs	unit	text	2147483647	√		null
DemandCO2CaptureMeasures	unit	text	2147483647	√		null
DemandEnergyDemands	unit	text	2147483647	√		null	Energy unit for the given inputs.
DemandEnergyEfficiencyMeasures	unit	text	2147483647	√		null
DemandFuelSwitchingMeasuresImpact	unit	text	2147483647	√		null
DemandServiceDemandMeasures	unit	text	2147483647	√		null
DemandServiceDemands	unit	text	2147483647	√		null	Service demand units (e.g. vehicle miles traveled or tons of cooling)
DemandStock	unit	text	2147483647	√		null	Input unit
DemandTechs	unit	text	2147483647	√		null	E.g. one light bulb, or for a commercial electric boiler two kiloBtu per hour.
SupplyCapacityFactor	unit	text	2147483647	√		null
SupplyExport	unit	text	2147483647	√		null
SupplyExportMeasures	unit	text	2147483647	√		null
SupplyPotential	unit	text	2147483647	√		null
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)
Scenarios	user_id	int4	10	√		null
TimeZones	utc_shift	float8	17,17	√		null
DemandTechsMainEfficiency	utility_factor	float4	8,8	√		null
BlendMeasuresData	value	float4	8,8	√		null
BlendNodeBlendMeasuresData	value	float4	8,8	√		null
CapitalCostOutputs	value	float8	17,17	√		null
CurrenciesConversion	value	float8	17,17	√		null
Demand Technologies - Auxiliary Efficiency	value	float4	8,8	√		null
Demand Technologies - Capital Costs	value	float4	8,8	√		null
Demand Technologies - Fixed OM	value	float4	8,8	√		null
Demand Technologies - Fuel Switching Costs	value	float4	8,8	√		null
Demand Technologies - Main Efficiency	value	float4	8,8	√		null
Demand Technologies - Parasitic Energy	value	float4	8,8	√		null
Demand Techs - Installation Costs	value	float4	8,8	√		null
DemandDriversData	value	float8	17,17	√		null	Actual data
DemandEnergyDemandsData	value	float4	8,8	√		null	Actual energy demand value
DemandEnergyEfficiencyMeasuresCostData	value	float4	8,8	√		null
DemandEnergyEfficiencyMeasuresData	value	float4	8,8	√		null
DemandFlexibleLoadMeasuresData	value	float8	17,17	√		null
DemandFuelSwitchingMeasuresCostData	value	float4	8,8	√		null
DemandFuelSwitchingMeasuresEnergyIntensityData	value	float4	8,8	√		null
DemandFuelSwitchingMeasuresImpactData	value	float4	8,8	√		null
DemandSalesData	value	float4	8,8	√		null	Input value
DemandSalesMeasuresData	value	float4	8,8	√		null
DemandServiceDemandMeasuresCostData	value	float4	8,8	√		null
DemandServiceDemandMeasuresData	value	float4	8,8	√		null
DemandServiceDemandsData	value	float4	8,8	√		null	Input data
DemandServiceEfficiencyData	value	float4	8,8	√		null	Data value.
DemandStockData	value	float4	8,8	√		null	Input data.
DemandStockMeasuresData	value	float4	8,8	√		null
DemandTechsAuxEfficiencyData	value	float4	8,8	√		null
DemandTechsCapitalCostNewData	value	float4	8,8	√		null
DemandTechsCapitalCostReplacementData	value	float4	8,8	√		null
DemandTechsFixedMaintenanceCostData	value	float4	8,8	√		null
DemandTechsFuelSwitchCostData	value	float4	8,8	√		null
DemandTechsInstallationCostNewData	value	float4	8,8	√		null
DemandTechsInstallationCostReplacementData	value	float4	8,8	√		null
DemandTechsMainEfficiencyData	value	float4	8,8	√		null
DemandTechsParasiticEnergyData	value	float4	8,8	√		null
DemandTechsServiceDemandModifierData	value	float4	8,8	√		null
DemandTechsServiceLinkData	value	float4	8,8	√		null
DispatchFeedersAllocationData	value	float8	17,17	√		null
GeographyMap	value	float8	17,17	√		null
ImportCostData	value	float8	17,17	√		null
InflationConversion	value	float8	17,17	√		null
PrimaryCostData	value	float8	17,17	√		null
SalesMeasureNameTech	value	float4	8,8	√		null
SalesMeasureReplacedTech	value	float4	8,8	√		null
ShapesData	value	float4	8,8	√		null
StorageTechsCapacityCapitalCostNewData	value	float4	8,8	√		null
StorageTechsCapacityCapitalCostReplacementData	value	float4	8,8	√		null
StorageTechsEnergyCapitalCostNewData	value	float4	8,8	√		null
StorageTechsEnergyCapitalCostReplacementData	value	float4	8,8	√		null
SupplyCapacityFactorData	value	float8	17,17	√		null
SupplyCostData	value	float8	17,17	√		null
SupplyEfficiencyData	value	float8	17,17	√		null
SupplyEmissionsData	value	float8	17,17	√		null
SupplyExportData	value	float8	17,17	√		null
SupplyExportMeasuresData	value	float4	8,8	√		null
SupplyPotentialConversionData	value	float8	17,17	√		null
SupplyPotentialData	value	float8	17,17	√		null
SupplySalesData	value	float8	17,17	√		null
SupplySalesMeasuresData	value	float8	17,17	√		null
SupplySalesShareData	value	float8	17,17	√		null
SupplySalesShareMeasuresData	value	float8	17,17	√		null
SupplyStockData	value	float8	17,17	√		null
SupplyStockMeasuresData	value	float8	17,17	√		null
SupplyTechsCapacityFactorData	value	float8	17,17	√		null
SupplyTechsCapitalCostNewData	value	float8	17,17	√		null
SupplyTechsCapitalCostReplacementData	value	float8	17,17	√		null
SupplyTechsCO2CaptureData	value	float8	17,17	√		null
SupplyTechsEfficiencyData	value	float8	17,17	√		null
SupplyTechsFixedMaintenanceCostData	value	float4	8,8	√		null
SupplyTechsInstallationCostNewData	value	float8	17,17	√		null
SupplyTechsInstallationCostReplacementData	value	float8	17,17	√		null
SupplyTechsVariableMaintenanceCostData	value	float8	17,17	√		null
Version	version_number	numeric	131089	√		null
CapitalCostOutputs	vintage	int4	10	√		null
Demand Technologies - Auxiliary Efficiency	vintage	int4	10	√		null
Demand Technologies - Capital Costs	vintage	int4	10	√		null
Demand Technologies - Fixed OM	vintage	int4	10	√		null
Demand Technologies - Fuel Switching Costs	vintage	int4	10	√		null
Demand Technologies - Main Efficiency	vintage	int4	10	√		null
Demand Technologies - Parasitic Energy	vintage	int4	10	√		null
Demand Techs - Installation Costs	vintage	int4	10	√		null
DemandEnergyEfficiencyMeasuresCostData	vintage	int4	10	√		null
DemandFuelSwitchingMeasuresCostData	vintage	int4	10	√		null
DemandSalesData	vintage	int4	10	√		null	Year of sale
DemandSalesMeasuresData	vintage	int4	10	√		null
DemandServiceDemandMeasuresCostData	vintage	int4	10	√		null
DemandTechsAuxEfficiencyData	vintage	int4	10	√		null
DemandTechsCapitalCostNewData	vintage	int4	10	√		null
DemandTechsCapitalCostReplacementData	vintage	int4	10	√		null
DemandTechsFixedMaintenanceCostData	vintage	int4	10	√		null
DemandTechsFuelSwitchCostData	vintage	int4	10	√		null
DemandTechsInstallationCostNewData	vintage	int4	10	√		null
DemandTechsInstallationCostReplacementData	vintage	int4	10	√		null
DemandTechsMainEfficiencyData	vintage	int4	10	√		null
DemandTechsParasiticEnergyData	vintage	int4	10	√		null
DemandTechsServiceDemandModifierData	vintage	int4	10	√		null
DemandTechsServiceLinkData	vintage	int4	10	√		null
SalesMeasureNameTech	vintage	int4	10	√		null
SalesMeasureReplacedTech	vintage	int4	10	√		null
StorageTechsCapacityCapitalCostNewData	vintage	int4	10	√		null
StorageTechsCapacityCapitalCostReplacementData	vintage	int4	10	√		null
StorageTechsEnergyCapitalCostNewData	vintage	int4	10	√		null
StorageTechsEnergyCapitalCostReplacementData	vintage	int4	10	√		null
SupplySalesData	vintage	int4	10	√		null
SupplySalesMeasuresData	vintage	int4	10	√		null
SupplySalesShareData	vintage	int4	10	√		null
SupplySalesShareMeasuresData	vintage	int4	10	√		null
SupplyTechsCapacityFactorData	vintage	int4	10	√		null
SupplyTechsCapitalCostNewData	vintage	int4	10	√		null
SupplyTechsCapitalCostReplacementData	vintage	int4	10	√		null
SupplyTechsCO2CaptureData	vintage	int4	10	√		null
SupplyTechsEfficiencyData	vintage	int4	10	√		null
SupplyTechsFixedMaintenanceCostData	vintage	int4	10	√		null
SupplyTechsInstallationCostNewData	vintage	int4	10	√		null
SupplyTechsInstallationCostReplacementData	vintage	int4	10	√		null
SupplyTechsVariableMaintenanceCostData	vintage	int4	10	√		null
ShapesData	weather_datetime	text	2147483647	√		null
DispatchNodeData	week	int4	10	√		null
ShapesData	week	int4	10	√		null
BlendMeasuresData	year	int4	10	√		null
BlendNodeBlendMeasuresData	year	int4	10	√		null
DemandDriversData	year	int4	10	√		null	Input year
DemandEnergyDemandsData	year	int4	10	√		null	Input year
DemandEnergyEfficiencyMeasuresData	year	int4	10	√		null
DemandFlexibleLoadMeasuresData	year	int4	10	√		null
DemandFuelSwitchingMeasuresEnergyIntensityData	year	int4	10	√		null
DemandFuelSwitchingMeasuresImpactData	year	int4	10	√		null
DemandServiceDemandMeasuresData	year	int4	10	√		null
DemandServiceDemandsData	year	int4	10	√		null	Data input year
DemandServiceEfficiencyData	year	int4	10	√		null	Data input year.
DemandServiceLink	year	int4	10	√		null	Basis year for the service demand share.
DemandStockData	year	int4	10	√		null	Input year for the data.
DemandStockMeasuresData	year	int4	10	√		null
DispatchFeedersAllocationData	year	int4	10	√		null
ImportCostData	year	int4	10	√		null
PrimaryCostData	year	int4	10	√		null
ShapesData	year	int4	10	√		null
SupplyCapacityFactorData	year	int4	10	√		null
SupplyCostData	year	int4	10	√		null
SupplyEfficiencyData	year	int4	10	√		null
SupplyEmissionsData	year	int4	10	√		null
SupplyExportData	year	int4	10	√		null
SupplyExportMeasuresData	year	int4	10	√		null
SupplyPotentialConversionData	year	int4	10	√		null
SupplyPotentialData	year	int4	10	√		null
SupplyStockData	year	int4	10	√		null
SupplyStockMeasuresData	year	int4	10	√		null