Table pathways_us_2017-1-15.public.DemandTechs
Demand technologies get used across subsectors that have a stock.

 Generated by
SchemaSpy
Legend:
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
id serial 10  √  nextval('"DemandTechs_id_seq"'::regclass)
DemandSalesData.demand_technology_id DemandSalesData_technology_fkey R
DemandSalesMeasures.demand_technology_id DemandSalesMeasures_demand_tech_id_fkey R
DemandSalesMeasures.replaced_demand_tech_id DemandSalesMeasures_replaced_demand_tech_id_fkey R
DemandServiceDemandsData.demand_technology_id DemandServiceDemandsData_technology_fkey R
DemandStockData.demand_technology_id DemandStockData_technology_fkey R
DemandStockMeasures.demand_technology_id DemandStockMeasures_demand_tech_id_fkey R
DemandTechs.linked_id DemandTechs_linked_id_fkey R
DemandTechsAuxEfficiency.demand_technology_id DemandTechsAuxEfficiency_demand_tech_id_fkey R
DemandTechsAuxEfficiencyData.demand_technology_id DemandTechsAuxEfficiencyData_demand_tech_id_fkey R
DemandTechsCapitalCost.demand_technology_id DemandTechsCapitalCost_demand_tech_id_fkey R
DemandTechsCapitalCostNewData.demand_technology_id DemandTechsCapitalCostNewData_demand_tech_id_fkey R
DemandTechsCapitalCostReplacementData.demand_technology_id DemandTechsCapitalCostReplacementData_demand_tech_id_fkey R
DemandTechsFixedMaintenanceCost.demand_technology_id DemandTechsFixedMaintenanceCost_demand_tech_id_fkey R
DemandTechsFuelSwitchCost.demand_technology_id DemandTechsFuelSwitchCost_demand_tech_id_fkey R
DemandTechsFuelSwitchCostData.demand_technology_id DemandTechsFuelSwitchCostData_demand_tech_id_fkey R
DemandTechsInstallationCost.demand_technology_id DemandTechsInstallationCost_demand_tech_id_fkey R
DemandTechsInstallationCostNewData.demand_technology_id DemandTechsInstallationCostNewData_demand_tech_id_fkey R
DemandTechsInstallationCostReplacementData.demand_technology_id DemandTechsInstallationCostReplacementData_demand_tech_id_fkey R
DemandTechsMainEfficiency.demand_technology_id DemandTechsMainEfficiency_demand_tech_id_fkey R
DemandTechsMainEfficiencyData.demand_technology_id DemandTechsMainEfficiencyData_demand_tech_id_fkey R
DemandTechsParasiticEnergy.demand_technology_id DemandTechsParasiticEnergy_demand_tech_id_fkey R
DemandTechsParasiticEnergyData.demand_technology_id DemandTechsParasiticEnergyData_demand_tech_id_fkey R
DemandTechsServiceDemandModifier.demand_technology_id DemandTechsServiceDemandModifier_demand_tech_id_fkey R
DemandTechsServiceDemandModifierData.demand_technology_id DemandTechsServiceDemandModifierData_demand_tech_id_fkey R
DemandTechsServiceLink.demand_technology_id DemandTechsServiceLink_demand_tech_id_fkey R
linked_id int4 10  √  null
DemandTechs.id DemandTechs_linked_id_fkey R
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.
stock_link_ratio float4 8,8  √  null Moderates the degree to which two technologies are linked.
subsector_id int4 10  √  null
DemandSubsectors.id DemandTechs_subsector_id_fkey R
Subsector where the technology is deployed.
name text 2147483647  √  null Technology name.
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.
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.
source text 2147483647  √  null Source for the technology data.
additional_description text 2147483647  √  null Further information.
demand_tech_unit_type_id int4 10  √  null
DemandTechUnitTypes.id DemandTechs_demand_tech_unit_type_id_fkey R
Equipment or service demand.
unit text 2147483647  √  null E.g. one light bulb, or for a commercial electric boiler two kiloBtu per hour.
time_unit text 2147483647  √  null If the unit is in energy terms, over what time period is that energy delivered.
cost_of_capital float4 8,8  √  null Separate cost of capital for the technology.
stock_decay_function_id int4 10  √  null
StockDecayFunctions.id DemandTechs_stock_decay_function_id_fkey R
What is the shape of stock decay? Options include weibull, linear, or lump (i.e. step function).
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.
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.
shape_id int4 10  √  null
Shapes.id DemandTechs_shape_id_fkey R
Electricity consumption shape for the technology. This is used when building an aggregate load shape, bottom up.
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.
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.

Table contained 234 rows at Tue Jan 17 22:23 PST 2017

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc DemandTechs_pkey

Close relationships  within of separation: