Table pathways_us_2017-1-15.public.OtherIndexesData 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('"OtherIndexesData_id_seq"'::regclass)
DemandCO2CaptureMeasures.other_index_2_id DemandCO2CaptureMeasures_other_index_2_id_fkey R
DemandDriversData.oth_1_id DemandDriversData_oth_1_id_fkey R
DemandDriversData.oth_2_id DemandDriversData_oth_2_id_fkey R
DemandEnergyDemandsData.oth_1_id DemandEnergyDemandsData_oth_1_id_fkey R
DemandEnergyDemandsData.oth_2_id DemandEnergyDemandsData_oth_2_id_fkey R
DemandEnergyEfficiencyMeasures.other_index_2_id DemandEnergyEfficiencyMeasures_other_index_2_id_fkey R
DemandEnergyEfficiencyMeasuresCostData.oth_1_id DemandEnergyEfficiencyMeasuresCostData_oth_1_id_fkey R
DemandEnergyEfficiencyMeasuresCostData.oth_2_id DemandEnergyEfficiencyMeasuresCostData_oth_2_id_fkey R
DemandEnergyEfficiencyMeasuresData.oth_1_id DemandEnergyEfficiencyMeasuresData_oth_1_id_fkey R
DemandEnergyEfficiencyMeasuresData.oth_2_id DemandEnergyEfficiencyMeasuresData_oth_2_id_fkey R
DemandFuelSwitchingMeasuresCostData.oth_1_id DemandFuelSwitchingMeasuresCostData_oth_1_id_fkey R
DemandFuelSwitchingMeasuresCostData.oth_2_id DemandFuelSwitchingMeasuresCostData_oth_2_id_fkey R
DemandFuelSwitchingMeasuresEnergyIntensity.other_index_2_id DemandFuelSwitchingMeasuresEnergyIntensit_other_index_2_id_fkey R
DemandFuelSwitchingMeasuresEnergyIntensityData.oth_1_id DemandFuelSwitchingMeasuresEnergyIntensityData_oth_1_id_fkey R
DemandFuelSwitchingMeasuresEnergyIntensityData.oth_2_id DemandFuelSwitchingMeasuresEnergyIntensityData_oth_2_id_fkey R
DemandFuelSwitchingMeasuresImpactData.oth_1_id DemandFuelSwitchingMeasuresImpactData_oth_1_id_fkey R
DemandFuelSwitchingMeasuresImpactData.oth_2_id DemandFuelSwitchingMeasuresImpactData_oth_2_id_fkey R
DemandSalesData.oth_1_id DemandSalesData_oth_1_id_fkey R
DemandSalesData.oth_2_id DemandSalesData_oth_2_id_fkey R
DemandSalesMeasuresData.oth_1_id DemandSalesMeasuresData_oth_1_id_fkey R
DemandServiceDemandMeasures.other_index_2_id DemandServiceDemandMeasures_other_index_2_id_fkey R
DemandServiceDemandMeasuresCostData.oth_1_id DemandServiceDemandMeasuresCostData_oth_1_id_fkey R
DemandServiceDemandMeasuresCostData.oth_2_id DemandServiceDemandMeasuresCostData_oth_2_id_fkey R
DemandServiceDemandMeasuresData.oth_1_id DemandServiceDemandMeasuresData_oth_1_id_fkey R
DemandServiceDemandMeasuresData.oth_2_id DemandServiceDemandMeasuresData_oth_2_id_fkey R
DemandServiceDemandsData.oth_1_id DemandServiceDemandsData_oth_1_id_fkey R
DemandServiceDemandsData.oth_2_id DemandServiceDemandsData_oth_2_id_fkey R
DemandServiceEfficiencyData.oth_1_id DemandServiceEfficiencyData_oth_1_id_fkey R
DemandServiceEfficiencyData.oth_2_id DemandServiceEfficiencyData_oth_2_id_fkey R
DemandStockData.oth_1_id DemandStockData_oth_1_id_fkey R
DemandStockData.oth_2_id DemandStockData_oth_2_id_fkey R
DemandStockMeasuresData.oth_1_id DemandStockMeasuresData_oth_1_id_fkey R
DemandTechsAuxEfficiencyData.oth_1_id DemandTechsAuxEfficiencyData_oth_1_id_fkey R
DemandTechsAuxEfficiencyData.oth_2_id DemandTechsAuxEfficiencyData_oth_2_id_fkey R
DemandTechsCapitalCostNewData.oth_1_id DemandTechsCapitalCostNewData_oth_1_id_fkey R
DemandTechsCapitalCostNewData.oth_2_id DemandTechsCapitalCostNewData_oth_2_id_fkey R
DemandTechsCapitalCostReplacementData.oth_1_id DemandTechsCapitalCostReplacementData_oth_1_id_fkey R
DemandTechsCapitalCostReplacementData.oth_2_id DemandTechsCapitalCostReplacementData_oth_2_id_fkey R
DemandTechsFixedMaintenanceCostData.oth_1_id DemandTechsFixedMaintenanceCostData_oth_1_id_fkey R
DemandTechsFixedMaintenanceCostData.oth_2_id DemandTechsFixedMaintenanceCostData_oth_2_id_fkey R
DemandTechsFuelSwitchCostData.oth_1_id DemandTechsFuelSwitchCostData_oth_1_id_fkey R
DemandTechsFuelSwitchCostData.oth_2_id DemandTechsFuelSwitchCostData_oth_2_id_fkey R
DemandTechsInstallationCostNewData.oth_1_id DemandTechsInstallationCostNewData_oth_1_id_fkey R
DemandTechsInstallationCostNewData.oth_2_id DemandTechsInstallationCostNewData_oth_2_id_fkey R
DemandTechsInstallationCostReplacementData.oth_1_id DemandTechsInstallationCostReplacementData_oth_1_id_fkey R
DemandTechsInstallationCostReplacementData.oth_2_id DemandTechsInstallationCostReplacementData_oth_2_id_fkey R
DemandTechsMainEfficiencyData.oth_1_id DemandTechsMainEfficiencyData_oth_1_id_fkey R
DemandTechsMainEfficiencyData.oth_2_id DemandTechsMainEfficiencyData_oth_2_id_fkey R
DemandTechsParasiticEnergyData.oth_1_id DemandTechsParasiticEnergyData_oth_1_id_fkey R
DemandTechsParasiticEnergyData.oth_2_id DemandTechsParasiticEnergyData_oth_2_id_fkey R
DemandTechsServiceDemandModifierData.oth_1_id DemandTechsServiceDemandModifierData_oth_1_id_fkey R
DemandTechsServiceDemandModifierData.oth_2_id DemandTechsServiceDemandModifierData_oth_2_id_fkey R
DemandTechsServiceLinkData.oth_1_id DemandTechsServiceLinkData_oth_1_id_fkey R
DemandTechsServiceLinkData.oth_2_id DemandTechsServiceLinkData_oth_2_id_fkey R
PrimaryCostData.oth_1_id PrimaryCostData_oth_1_id_fkey R
StorageTechsCapacityCapitalCostNewData.oth_1_id StorageTechsCapacityCapitalCostNewData_oth_1_id_fkey R
StorageTechsCapacityCapitalCostNewData.oth_2_id StorageTechsCapacityCapitalCostNewData_oth_2_id_fkey R
StorageTechsCapacityCapitalCostReplacementData.oth_1_id StorageTechsCapacityCapitalCostReplacementData_oth_1_id_fkey R
StorageTechsCapacityCapitalCostReplacementData.oth_2_id StorageTechsCapacityCapitalCostReplacementData_oth_2_id_fkey R
StorageTechsEnergyCapitalCostNewData.oth_1_id StorageTechsEnergyCapitalCostNewData_oth_1_id_fkey R
StorageTechsEnergyCapitalCostNewData.oth_2_id StorageTechsEnergyCapitalCostNewData_oth_2_id_fkey R
StorageTechsEnergyCapitalCostReplacementData.oth_1_id StorageTechsEnergyCapitalCostReplacementData_oth_1_id_fkey R
StorageTechsEnergyCapitalCostReplacementData.oth_2_id StorageTechsEnergyCapitalCostReplacementData_oth_2_id_fkey R
SupplyExportMeasuresData.oth_1_id SupplyExportMeasuresData_oth_1_id_fkey R
SupplyPotentialConversionData.oth_1_id SupplyPotentialConversionData_oth_1_id_fkey R
SupplyPotentialData.oth_1_id SupplyPotentialData_oth_1_id_fkey R
SupplySalesShareMeasuresData.oth_1_id SupplySalesShareMeasuresData_oth_1_id_fkey R
name text 2147483647  √  null
other_index_id int4 10  √  null
OtherIndexes.id OtherIndexesData_other_index_id_fkey R

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

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

Close relationships  within of separation: