Table pathways_us_2017-1-15.public.GeographiesData 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('"GeographiesData_id_seq"'::regclass)
BlendNodeBlendMeasuresData.gau_id BlendNodeBlendMeasuresData_gau_id_fkey R
DemandDriversData.gau_id DemandDriversData_gau_id_fkey R
DemandEnergyDemandsData.gau_id DemandEnergyDemandsData_gau_id_fkey R
DemandEnergyEfficiencyMeasuresCostData.gau_id DemandEnergyEfficiencyMeasuresCostData_gau_id_fkey R
DemandEnergyEfficiencyMeasuresData.gau_id DemandEnergyEfficiencyMeasuresData_gau_id_fkey R
DemandFuelSwitchingMeasuresCostData.gau_id DemandFuelSwitchingMeasuresCostData_gau_id_fkey R
DemandFuelSwitchingMeasuresEnergyIntensityData.gau_id DemandFuelSwitchingMeasuresEnergyIntensityData_gau_id_fkey R
DemandFuelSwitchingMeasuresImpactData.gau_id DemandFuelSwitchingMeasuresImpactData_gau_id_fkey R
DemandSalesData.gau_id DemandSalesData_gau_id_fkey R
DemandSalesMeasuresData.gau_id DemandSalesMeasuresData_gau_id_fkey R
DemandServiceDemandMeasuresCostData.gau_id DemandServiceDemandMeasuresCostData_gau_id_fkey R
DemandServiceDemandMeasuresData.gau_id DemandServiceDemandMeasuresData_gau_id_fkey R
DemandServiceDemandsData.gau_id DemandServiceDemandsData_gau_id_fkey R
DemandServiceEfficiencyData.gau_id DemandServiceEfficiencyData_gau_id_fkey R
DemandStockData.gau_id DemandStockData_gau_id_fkey R
DemandStockMeasuresData.gau_id DemandStockMeasuresData_gau_id_fkey R
DemandTechsAuxEfficiencyData.gau_id DemandTechsAuxEfficiencyData_gau_id_fkey R
DemandTechsCapitalCostNewData.gau_id DemandTechsCapitalCostNewData_gau_id_fkey R
DemandTechsCapitalCostReplacementData.gau_id DemandTechsCapitalCostReplacementData_gau_id_fkey R
DemandTechsFixedMaintenanceCostData.gau_id DemandTechsFixedMaintenanceCostData_gau_id_fkey R
DemandTechsFuelSwitchCostData.gau_id DemandTechsFuelSwitchCostData_gau_id_fkey R
DemandTechsInstallationCostNewData.gau_id DemandTechsInstallationCostNewData_gau_id_fkey R
DemandTechsInstallationCostReplacementData.gau_id DemandTechsInstallationCostReplacementData_gau_id_fkey R
DemandTechsMainEfficiencyData.gau_id DemandTechsMainEfficiencyData_gau_id_fkey R
DemandTechsParasiticEnergyData.gau_id DemandTechsParasiticEnergyData_gau_id_fkey R
DemandTechsServiceDemandModifierData.gau_id DemandTechsServiceDemandModifierData_gau_id_fkey R
DemandTechsServiceLinkData.gau_id DemandTechsServiceLinkData_gau_id_fkey R
DispatchNodeData.gau_id DispatchNodeData_gau_id_fkey R
GeographyIntersectionData.gau_id GeographyIntersectionData_gau_id_fkey R
ImportCostData.gau_id ImportCostData_gau_id_fkey R
PrimaryCostData.gau_id PrimaryCostData_gau_id_fkey R
ShapesData.gau_id ShapesData_gau_id_fkey R
StorageTechsCapacityCapitalCostNewData.gau_id StorageTechsCapacityCapitalCostNewData_gau_id_fkey R
StorageTechsCapacityCapitalCostReplacementData.gau_id StorageTechsCapacityCapitalCostReplacementData_gau_id_fkey R
StorageTechsEnergyCapitalCostNewData.gau_id StorageTechsEnergyCapitalCostNewData_gau_id_fkey R
StorageTechsEnergyCapitalCostReplacementData.gau_id StorageTechsEnergyCapitalCostReplacementData_gau_id_fkey R
SupplyCapacityFactorData.gau_id SupplyCapacityFactorData_gau_id_fkey R
SupplyCostData.gau_id SupplyCostData_gau_id_fkey R
SupplyEfficiencyData.gau_id SupplyEfficiencyData_gau_id_fkey R
SupplyEmissionsData.gau_id SupplyEmissionsData_gau_id_fkey R
SupplyExportData.gau_id SupplyExportData_gau_id_fkey R
SupplyExportMeasuresData.gau_id SupplyExportMeasuresData_gau_id_fkey R
SupplyPotentialConversionData.gau_id SupplyPotentialConversionData_gau_id_fkey R
SupplyPotentialData.gau_id SupplyPotentialData_gau_id_fkey R
SupplySalesData.gau_id SupplySalesData_gau_id_fkey R
SupplySalesMeasuresData.gau_id SupplySalesMeasuresData_gau_id_fkey R
SupplySalesShareData.gau_id SupplySalesShareData_gau_id_fkey R
SupplySalesShareMeasuresData.gau_id SupplySalesShareMeasuresData_gau_id_fkey R
SupplyStockData.gau_id SupplyStockData_gau_id_fkey R
SupplyStockMeasuresData.gau_id SupplyStockMeasuresData_gau_id_fkey R
SupplyTechsCapacityFactorData.gau_id SupplyTechsCapacityFactorData_gau_id_fkey R
SupplyTechsCapitalCostNewData.gau_id SupplyTechsCapitalCostNewData_gau_id_fkey R
SupplyTechsCapitalCostReplacementData.gau_id SupplyTechsCapitalCostReplacementData_gau_id_fkey R
SupplyTechsCO2Capture.geography_id SupplyTechsCO2Capture_geography_id_fkey R
SupplyTechsCO2CaptureData.gau_id SupplyTechsCO2CaptureData_gau_id_fkey R
SupplyTechsEfficiency.geography_id SupplyTechsEfficiency_geography_id_fkey R
SupplyTechsEfficiencyData.gau_id SupplyTechsEfficiencyData_gau_id_fkey R
SupplyTechsFixedMaintenanceCostData.gau_id SupplyTechsFixedMaintenanceCostData_gau_id_fkey R
SupplyTechsInstallationCostNewData.gau_id SupplyTechsInstallationCostNewData_gau_id_fkey R
SupplyTechsInstallationCostReplacementData.gau_id SupplyTechsInstallationCostReplacementData_gau_id_fkey R
SupplyTechsVariableMaintenanceCost.geography_id SupplyTechsVariableMaintenanceCost_geography_id_fkey R
SupplyTechsVariableMaintenanceCostData.gau_id SupplyTechsVariableMaintenanceCostData_gau_id_fkey R
name text 2147483647  √  null
geography_id int4 10  √  null
Geographies.id GeographiesData_geography_id_fkey R

Table contained 3,293 rows at Tue Jan 17 22:23 PST 2017

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

Close relationships  within of separation: