Table pathways_us_2017-1-15.public.Geographies 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('"Geographies_id_seq"'::regclass)
BlendNodeBlendMeasures.geography_id BlendNodeBlendMeasures_geography_id_fkey R
DemandCO2CaptureMeasures.geography_id DemandCO2CaptureMeasures_geography_id_fkey R
DemandDrivers.geography_id DemandDrivers_geography_id_fkey R
DemandEnergyDemands.geography_id DemandEnergyDemands_geography_id_fkey R
DemandEnergyEfficiencyMeasures.geography_id DemandEnergyEfficiencyMeasures_geography_id_fkey R
DemandEnergyEfficiencyMeasuresCost.geography_id DemandEnergyEfficiencyMeasuresCost_geography_id_fkey R
DemandFlexibleLoadMeasures.geography_id DemandFlexibleLoadMeasures_geography_id_fkey R
DemandFuelSwitchingMeasuresCost.geography_id DemandFuelSwitchingMeasuresCost_geography_id_fkey R
DemandFuelSwitchingMeasuresEnergyIntensity.geography_id DemandFuelSwitchingMeasuresEnergyIntensity_geography_id_fkey R
DemandFuelSwitchingMeasuresImpact.geography_id DemandFuelSwitchingMeasuresImpact_geography_id_fkey R
DemandSales.geography_id DemandSales_geography_id_fkey R
DemandSalesMeasures.geography_id DemandSalesMeasures_geography_id_fkey R
DemandServiceDemandMeasures.geography_id DemandServiceDemandMeasures_geography_id_fkey R
DemandServiceDemandMeasuresCost.geography_id DemandServiceDemandMeasuresCost_geography_id_fkey R
DemandServiceDemands.geography_id DemandServiceDemands_geography_id_fkey R
DemandServiceEfficiency.geography_id DemandServiceEfficiency_geography_id_fkey R
DemandStock.geography_id DemandStock_geography_id_fkey R
DemandStockMeasures.geography_id DemandStockMeasures_geography_id_fkey R
DemandTechsAuxEfficiency.geography_id DemandTechsAuxEfficiency_geography_id_fkey R
DemandTechsCapitalCost.geography_id DemandTechsCapitalCost_geography_id_fkey R
DemandTechsFixedMaintenanceCost.geography_id DemandTechsFixedMaintenanceCost_geography_id_fkey R
DemandTechsFuelSwitchCost.geography_id DemandTechsFuelSwitchCost_geography_id_fkey R
DemandTechsInstallationCost.geography_id DemandTechsInstallationCost_geography_id_fkey R
DemandTechsMainEfficiency.geography_id DemandTechsMainEfficiency_geography_id_fkey R
DemandTechsParasiticEnergy.geography_id DemandTechsParasiticEnergy_geography_id_fkey R
DemandTechsServiceDemandModifier.geography_id DemandTechsServiceDemandModifier_geography_id_fkey R
DemandTechsServiceLink.geography_id DemandTechsServiceLink_geography_id_fkey R
DispatchConfig.geography_id DispatchConfig_geography_id_fkey R
DispatchNodeConfig.geography_id DispatchNodeConfig_geography_id_fkey R
GeographiesData.geography_id GeographiesData_geography_id_fkey R
ImportCost.geography_id ImportCost_geography_id_fkey R
PrimaryCost.geography_id PrimaryCost_geography_id_fkey R
Shapes.geography_id Shapes_geography_id_fkey R
StorageTechsCapacityCapitalCost.geography_id StorageTechsCapacityCapitalCost_geography_id_fkey R
StorageTechsEnergyCapitalCost.geography_id StorageTechsEnergyCapitalCost_geography_id_fkey R
SupplyCapacityFactor.geography_id SupplyCapacityFactor_geography_id_fkey R
SupplyCost.geography_id SupplyCost_geography_id_fkey R
SupplyEfficiency.geography_id SupplyEfficiency_geography_id_fkey R
SupplyEmissions.geography_id SupplyEmissions_geography_id_fkey R
SupplyExport.geography_id SupplyExport_geography_id_fkey R
SupplyExportMeasures.geography_id SupplyExportMeasures_geography_id_fkey R
SupplyNodes.tradable_geography_id SupplyNodes_tradable_geography_id_fkey R
SupplyPotential.geography_id SupplyPotential_geography_id_fkey R
SupplyPotentialConversion.geography_id SupplyPotentialConversion_geography_id_fkey R
SupplySales.geography_id SupplySales_geography_id_fkey R
SupplySalesMeasures.geography_id SupplySalesMeasures_geography_id_fkey R
SupplySalesShare.geography_id SupplySalesShare_geography_id_fkey R
SupplySalesShareMeasures.geography_id SupplySalesShareMeasures_geography_id_fkey R
SupplyStock.geography_id SupplyStock_geography_id_fkey R
SupplyStockMeasures.geography_id SupplyStockMeasures_geography_id_fkey R
SupplyTechsCapacityFactor.geography_id SupplyTechsCapacityFactor_geography_id_fkey R
SupplyTechsCapitalCost.geography_id SupplyTechsCapitalCost_geography_id_fkey R
SupplyTechsFixedMaintenanceCost.geography_id SupplyTechsFixedMaintenanceCost_geography_id_fkey R
SupplyTechsInstallationCost.geography_id SupplyTechsInstallationCost_geography_id_fkey R
name text 2147483647

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

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc Geographies_pkey
name Must be unique Asc Geographies_name_key

Close relationships  within of separation: