Table pathways_us_2017-1-15.public.SupplyNodes Generated by
SchemaSpy
Legend:
Primary key columns
Columns with indexes
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents
id serial 10  √  nextval('"SupplyNodes_id_seq"'::regclass)
BlendNodeBlendMeasurePackages
BlendNodeBlendMeasures
BlendNodeBlendMeasures
BlendNodeInputsData
BlendNodeInputsData
DispatchConfig
DispatchConfig
DispatchConfig
DispatchNodeConfig
ImportCost
PrimaryCost
PrimaryCostData
SupplyCapacityFactor
SupplyCost
SupplyEfficiency
SupplyEfficiencyData
SupplyEmissions
SupplyEmissionsData
SupplyExport
SupplyExportMeasurePackages
SupplyExportMeasures
SupplyNodes
SupplyPotential
SupplyPotentialConversion
SupplySales
SupplySalesMeasurePackages
SupplySalesMeasures
SupplySalesShare
SupplySalesShareData
SupplySalesShareMeasurePackages
SupplySalesShareMeasures
SupplyStates
SupplyStock
SupplyStockData
SupplyStockMeasurePackages
SupplyStockMeasures
SupplyTechs
SupplyTechsEfficiencyData
name text 2147483647  √  null
supply_type_id int4 10  √  null
SupplyTypes
tradable_geography_id int4 10  √  null
Geographies
is_active bool 1  √  null
final_energy_link int4 10  √  null
FinalEnergy
is_curtailable int4 10  √  null
is_exportable int4 10  √  null
is_flexible int4 10  √  null
residual_supply_node_id int4 10  √  null
SupplyNodes
mean_lifetime float4 8,8  √  null
lifetime_variance float4 8,8  √  null
max_lifetime float4 8,8  √  null
min_lifetime float4 8,8  √  null
stock_decay_function_id int4 10  √  null
StockDecayFunctions
cost_of_capital float4 8,8  √  null
book_life int4 10  √  null
geography_map_key_id int4 10  √  null
GeographyMapKeys
shape_id int4 10  √  null
Shapes
max_lag_hours int4 10  √  null
max_lead_hours int4 10  √  null
enforce_potential_constraint bool 1  √  null

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

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

Close relationships  within of separation: