Table pathways_us_2017-1-15.public.GeographyMapKeys 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('"GeographyMapKeys_id_seq"'::regclass)
DemandDrivers.geography_map_key_id DemandDrivers_geography_map_key_id_fkey R
DemandEnergyDemands.geography_map_key_id DemandEnergyDemands_geography_map_key_id_fkey R
DemandServiceDemands.geography_map_key_id DemandServiceDemands_geography_map_key_id_fkey R
DemandServiceEfficiency.geography_map_key_id DemandServiceEfficiency_geography_map_key_id_fkey R
DemandStock.geography_map_key_id DemandStock_geography_map_key_id_fkey R
GeographyMap.geography_map_key_id GeographyMap_geography_map_key_id_fkey R
Shapes.geography_map_key_id Shapes_geography_map_key_id_fkey R
SupplyNodes.geography_map_key_id SupplyNodes_geography_map_key_id_fkey R
SupplyPotential.geography_map_key_id SupplyPotential_geography_map_key_id_fkey R
SupplySales.geography_map_key_id geography_map_key R
SupplySalesMeasures.geography_map_key_id geography_map_key R
SupplyStock.geography_map_key_id SupplyStock_geography_map_key_id_fkey R
SupplyStockMeasures.geography_map_key_id SupplyStockMeasures_geography_map_key R
SupplyTechsCapitalCost.geography_map_key_id SupplyTechsCapitalCost_geography_map_key R
name text 2147483647

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

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

Close relationships  within of separation: