Table pathways_us_2017-1-15.public.FinalEnergy 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('"FinalEnergy_id_seq"'::regclass)
DemandEnergyDemandsData.final_energy_id DemandEnergyDemandsData_final_energy_fkey R
DemandEnergyEfficiencyMeasuresCostData.final_energy_id DemandEnergyEfficiencyMeasuresCostData_final_energy_id_fkey R
DemandEnergyEfficiencyMeasuresData.final_energy_id DemandEnergyEfficiencyMeasuresData_final_energy_fkey R
DemandFuelSwitchingMeasures.final_energy_from_id DemandFuelSwitchingMeasures_final_energy_from_id_fkey R
DemandFuelSwitchingMeasures.final_energy_to_id DemandFuelSwitchingMeasures_final_energy_to_id_fkey R
DemandServiceDemandsData.final_energy_id DemandServiceDemandsData_final_energy_fkey R
DemandServiceEfficiencyData.final_energy_id DemandServiceEfficiencyData_final_energy_fkey R
DemandTechsAuxEfficiency.final_energy_id DemandTechsAuxEfficiency_final_energy_id_fkey R
DemandTechsMainEfficiency.final_energy_id DemandTechsMainEfficiency_final_energy_id_fkey R
DemandTechsParasiticEnergyData.final_energy_id DemandTechsParasiticEnergyData_final_energy_fkey R
SupplyNodes.final_energy_link SupplyNodes_final_energy_link_fkey R
name text 2147483647  √  null
shape_id int4 10  √  null
Shapes.id FinalEnergy_shape_id_fkey R

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

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

Close relationships  within of separation: