SchemaSpy Analysis of pathways_us_2017-1-15.public - ColumnsThis schema analysis is based on the U.S. database for EnergyPATHWAYS, maintained by Evolved Energy Research, and row counts reflect the dated version. Generated by
SchemaSpy
Generated by SchemaSpy on Tue Jan 17 22:23 PST 2017
Legend:
Primary key columns
Columns with indexes
 

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