Table pathways_us_2017-1-15.public.DemandTechsCapitalCost
Capital cost records for each technology.

 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
demand_technology_id int4 10
DemandTechsCapitalCost.reference_tech_id DemandTechsCapitalCost_reference_tech_id_fkey R
DemandTechs.id DemandTechsCapitalCost_demand_tech_id_fkey R
Parent demand tech.
definition_id int4 10  √  null
Definitions.id DemandTechsCapitalCost_definition_id_fkey R
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.
reference_tech_id int4 10  √  null
DemandTechsCapitalCost.demand_technology_id DemandTechsCapitalCost_reference_tech_id_fkey R
If the input is relative, what technology is used as the reference?
geography_id int4 10  √  null
Geographies.id DemandTechsCapitalCost_geography_id_fkey R
Input geography for the data (e.g. state)
other_index_1_id int4 10  √  null
OtherIndexes.id DemandTechsCapitalCost_other_index_1_id_fkey R
First sub category for the input data (e.g. housing type)
other_index_2_id int4 10  √  null
OtherIndexes.id DemandTechsCapitalCost_other_index_2_id_fkey R
Second sub category for the input data (e.g. housing type)
currency_id int4 10  √  null
Currencies.id DemandTechsCapitalCost_currency_id_fkey R
Input currency.
currency_year_id int4 10  √  null Input currency year.
is_levelized bool 1  √  false Is the given capital cost in levelized terms?
interpolation_method_id int4 10  √  1
CleaningMethods.id DemandTechsCapitalCost_interpolation_method_id_fkey R
Cleaning method used to interpolate between missing years when data is entered.
extrapolation_method_id int4 10  √  4
CleaningMethods.id DemandTechsCapitalCost_extrapolation_method_id_fkey R
Cleaning method used to extrapolate to missing years when data is entered.
extrapolation_growth float4 8,8  √  null If extrapolation method exponential is used, what is the year over year growth rate?

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

Indexes:
Column(s) Type Sort Constraint Name
demand_technology_id Primary key Asc DemandTechsCapitalCost_pkey

Close relationships  within of separation: