Table pathways_us_2017-1-15.public.SupplyNodes 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('"SupplyNodes_id_seq"'::regclass)
BlendNodeBlendMeasurePackages.blend_node_id BlendNodeBlendMeasurePackages_blend_subsector_id_fkey R
BlendNodeBlendMeasures.blend_node_id BlendNodeBlendMeasures_blend_node_id_fkey R
BlendNodeBlendMeasures.supply_node_id BlendNodeBlendMeasures_supply_node_id_fkey R
BlendNodeInputsData.blend_node_id BlendNodeInputsData_blend_node_id_fkey R
BlendNodeInputsData.supply_node_id BlendNodeInputsData_supply_node_id_fkey R
DispatchConfig.distribution_node_id DispatchConfig_distribution_node_id_fkey R
DispatchConfig.thermal_dispatch_node_id DispatchConfig_thermal_dispatch_node_id_fkey R
DispatchConfig.transmission_node_id DispatchConfig_transmission_node_id_fkey R
DispatchNodeConfig.supply_node_id DispatchNodeConfig_supply_node_id_fkey R
ImportCost.import_node_id ImportCost_import_node_id_fkey R
PrimaryCost.primary_node_id PrimaryCost_primary_node_id_fkey R
PrimaryCostData.primary_node_id PrimaryCostData_primary_node_id_fkey R
SupplyCapacityFactor.supply_node_id SupplyCapacityFactor_supply_node_id_fkey R
SupplyCost.supply_node_id SupplyCost_supply_node_id_fkey R
SupplyEfficiency.id SupplyEfficiency_id_fkey R
SupplyEfficiencyData.supply_node_id SupplyEfficiencyData_supply_node_id_fkey R
SupplyEmissions.supply_node_id SupplyEmissions_supply_node_id_fkey R
SupplyEmissionsData.supply_node_id SupplyEmissionsData_supply_node_id_fkey R
SupplyExport.supply_node_id SupplyExport_supply_node_id_fkey R
SupplyExportMeasurePackages.supply_node_id SupplyExportMeasurePackages_supply_node_id_fkey R
SupplyExportMeasures.supply_node_id SupplyExportMeasures_supply_node_id_fkey R
SupplyNodes.residual_supply_node_id SupplyNodes_residual_supply_node_id_fkey R
SupplyPotential.supply_node_id SupplyPotential_supply_node_id_fkey R
SupplyPotentialConversion.supply_node_id SupplyPotentialConversion_supply_node_id_fkey R
SupplySales.supply_node_id SupplySales_supply_node_id_fkey R
SupplySalesMeasurePackages.supply_node_id SupplySalesMeasurePackages_supply_node_id_fkey R
SupplySalesMeasures.supply_node_id SupplySalesMeasures_supply_node_id_fkey R
SupplySalesShare.supply_node_id SupplySalesShare_supply_node_id_fkey R
SupplySalesShareData.supply_node_id SupplySalesShareData_supply_node_id_fkey R
SupplySalesShareMeasurePackages.supply_node_id SupplySalesShareMeasurePackages_supply_node_id_fkey R
SupplySalesShareMeasures.supply_node_id SupplySalesShareMeasures_supply_node_id_fkey R
SupplyStates.supply_node_id SupplyCasesData_supply_node_id_fkey R
SupplyStock.supply_node_id SupplyStock_supply_node_id_fkey R
SupplyStockData.supply_node_id SupplyStockData_supply_node_id_fkey R
SupplyStockMeasurePackages.supply_node_id SupplyStockMeasurePackages_supply_node_id_fkey R
SupplyStockMeasures.supply_node_id SupplyStockMeasures_supply_node_id_fkey R
SupplyTechs.supply_node_id SupplyTechs_supply_node_id_fkey R
SupplyTechsEfficiencyData.supply_node_id SupplyTechsEfficiencyData_supply_node_id_fkey R
name text 2147483647  √  null
supply_type_id int4 10  √  null
SupplyTypes.id SupplyNodes_supply_type_id_fkey R
tradable_geography_id int4 10  √  null
Geographies.id SupplyNodes_tradable_geography_id_fkey R
is_active bool 1  √  null
final_energy_link int4 10  √  null
FinalEnergy.id SupplyNodes_final_energy_link_fkey R
is_curtailable int4 10  √  null
is_exportable int4 10  √  null
is_flexible int4 10  √  null
residual_supply_node_id int4 10  √  null
SupplyNodes.id SupplyNodes_residual_supply_node_id_fkey R
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.id SupplyNodes_stock_decay_function_id_fkey R
cost_of_capital float4 8,8  √  null
book_life int4 10  √  null
geography_map_key_id int4 10  √  null
GeographyMapKeys.id SupplyNodes_geography_map_key_id_fkey R
shape_id int4 10  √  null
Shapes.id SupplyNodes_shape_id_fkey R
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 Constraint Name
id Primary key Asc SupplyNodes_pkey

Close relationships  within of separation: