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