Table pathways_us_2017-1-15.public.CleaningMethods
Cleaning methods are used to interpolate or extrapolate to missing years of data.

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('"CleaningMethods_id_seq"'::regclass)
BlendNodeBlendMeasures.extrapolation_method_id BlendNodeBlendMeasures_extrapolation_method_id_fkey R
BlendNodeBlendMeasures.interpolation_method_id BlendNodeBlendMeasures_interpolation_method_id_fkey R
DemandCO2CaptureMeasures.extrapolation_method_id DemandCO2CaptureMeasures_extrapolation_method_id_fkey R
DemandCO2CaptureMeasures.interpolation_method_id DemandCO2CaptureMeasures_interpolation_method_id_fkey R
DemandDrivers.extrapolation_method_id DemandDrivers_extrapolation_method_id_fkey R
DemandDrivers.interpolation_method_id DemandDrivers_interpolation_method_id_fkey R
DemandEnergyDemands.extrapolation_method_id DemandEnergyDemands_extrapolation_method_id_fkey R
DemandEnergyDemands.interpolation_method_id DemandEnergyDemands_interpolation_method_id_fkey R
DemandEnergyEfficiencyMeasures.extrapolation_method_id DemandEnergyEfficiencyMeasures_extrapolation_method_id_fkey R
DemandEnergyEfficiencyMeasures.interpolation_method_id DemandEnergyEfficiencyMeasures_interpolation_method_id_fkey R
DemandEnergyEfficiencyMeasuresCost.extrapolation_method_id DemandEnergyEfficiencyMeasuresCost_extrapolation_method_id_fkey R
DemandEnergyEfficiencyMeasuresCost.interpolation_method_id DemandEnergyEfficiencyMeasuresCost_interpolation_method_id_fkey R
DemandFlexibleLoadMeasures.extrapolation_method_id DemandFlexibleLoadMeasures_extrapolation_method_id_fkey R
DemandFlexibleLoadMeasures.interpolation_method_id DemandFlexibleLoadMeasures_interpolation_method_id_fkey R
DemandFuelSwitchingMeasuresCost.extrapolation_method_id DemandFuelSwitchingMeasuresCost_extrapolation_method_id_fkey R
DemandFuelSwitchingMeasuresCost.interpolation_method_id DemandFuelSwitchingMeasuresCost_interpolation_method_id_fkey R
DemandFuelSwitchingMeasuresEnergyIntensity.extrapolation_method_id DemandFuelSwitchingMeasuresEnergyI_extrapolation_method_id_fkey R
DemandFuelSwitchingMeasuresEnergyIntensity.interpolation_method_id DemandFuelSwitchingMeasuresEnergyI_interpolation_method_id_fkey R
DemandFuelSwitchingMeasuresImpact.extrapolation_method_id DemandFuelSwitchingMeasuresImpact_extrapolation_method_id_fkey R
DemandFuelSwitchingMeasuresImpact.interpolation_method_id DemandFuelSwitchingMeasuresImpact_interpolation_method_id_fkey R
DemandSales.extrapolation_method_id DemandSales_extrapolation_method_id_fkey R
DemandSales.interpolation_method_id DemandSales_interpolation_method_id_fkey R
DemandSalesMeasures.extrapolation_method_id DemandSalesMeasures_extrapolation_method_id_fkey R
DemandSalesMeasures.interpolation_method_id DemandSalesMeasures_interpolation_method_id_fkey R
DemandServiceDemandMeasures.extrapolation_method_id DemandServiceDemandMeasures_extrapolation_method_id_fkey R
DemandServiceDemandMeasures.interpolation_method_id DemandServiceDemandMeasures_interpolation_method_id_fkey R
DemandServiceDemandMeasuresCost.extrapolation_method_id DemandServiceDemandMeasuresCost_extrapolation_method_id_fkey R
DemandServiceDemandMeasuresCost.interpolation_method_id DemandServiceDemandMeasuresCost_interpolation_method_id_fkey R
DemandServiceDemands.extrapolation_method_id DemandServiceDemands_extrapolation_method_id_fkey R
DemandServiceDemands.interpolation_method_id DemandServiceDemands_interpolation_method_id_fkey R
DemandServiceEfficiency.extrapolation_method_id DemandServiceEfficiency_extrapolation_method_id_fkey R
DemandServiceEfficiency.interpolation_method_id DemandServiceEfficiency_interpolation_method_id_fkey R
DemandStock.extrapolation_method_id DemandStock_extrapolation_method_id_fkey R
DemandStock.interpolation_method_id DemandStock_interpolation_method_id_fkey R
DemandStockMeasures.extrapolation_method_id DemandStockMeasures_extrapolation_method_id_fkey R
DemandStockMeasures.interpolation_method_id DemandStockMeasures_interpolation_method_id_fkey R
DemandTechsAuxEfficiency.extrapolation_method_id DemandTechsAuxEfficiency_extrapolation_method_id_fkey R
DemandTechsAuxEfficiency.interpolation_method_id DemandTechsAuxEfficiency_interpolation_method_id_fkey R
DemandTechsCapitalCost.extrapolation_method_id DemandTechsCapitalCost_extrapolation_method_id_fkey R
DemandTechsCapitalCost.interpolation_method_id DemandTechsCapitalCost_interpolation_method_id_fkey R
DemandTechsFixedMaintenanceCost.extrapolation_method_id DemandTechsFixedMaintenanceCost_extrapolation_method_id_fkey R
DemandTechsFixedMaintenanceCost.interpolation_method_id DemandTechsFixedMaintenanceCost_interpolation_method_id_fkey R
DemandTechsFuelSwitchCost.extrapolation_method_id DemandTechsFuelSwitchCost_extrapolation_method_id_fkey R
DemandTechsFuelSwitchCost.interpolation_method_id DemandTechsFuelSwitchCost_interpolation_method_id_fkey R
DemandTechsInstallationCost.extrapolation_method_id DemandTechsInstallationCost_extrapolation_method_id_fkey R
DemandTechsInstallationCost.interpolation_method_id DemandTechsInstallationCost_interpolation_method_id_fkey R
DemandTechsMainEfficiency.extrapolation_method_id DemandTechsMainEfficiency_extrapolation_method_id_fkey R
DemandTechsMainEfficiency.interpolation_method_id DemandTechsMainEfficiency_interpolation_method_id_fkey R
DemandTechsParasiticEnergy.extrapolation_method_id DemandTechsParasiticEnergy_extrapolation_method_id_fkey R
DemandTechsParasiticEnergy.interpolation_method_id DemandTechsParasiticEnergy_interpolation_method_id_fkey R
DemandTechsServiceDemandModifier.extrapolation_method_id DemandTechsServiceDemandModifier_extrapolation_method_id_fkey R
DemandTechsServiceDemandModifier.interpolation_method_id DemandTechsServiceDemandModifier_interpolation_method_id_fkey R
DemandTechsServiceLink.extrapolation_method_id DemandTechsServiceLink_extrapolation_method_id_fkey R
DemandTechsServiceLink.interpolation_method_id DemandTechsServiceLink_interpolation_method_id_fkey R
DispatchFeedersAllocation.extrapolation_method_id DispatchFeedersAllocation_extrapolation_method_id_fkey R
DispatchFeedersAllocation.interpolation_method_id DispatchFeedersAllocation_interpolation_method_id_fkey R
ImportCost.extrapolation_method_id ImportCost_extrapolation_method_id_fkey R
ImportCost.interpolation_method_id ImportCost_interpolation_method_id_fkey R
PrimaryCost.extrapolation_method_id PrimaryCost_extrapolation_method_id_fkey R
PrimaryCost.interpolation_method_id PrimaryCost_interpolation_method_id_fkey R
Shapes.extrapolation_method_id Shapes_extrapolation_method_id_fkey R
Shapes.interpolation_method_id Shapes_interpolation_method_id_fkey R
StorageTechsCapacityCapitalCost.extrapolation_method_id StorageTechsCapacityCapitalCost_extrapolation_method_id_fkey R
StorageTechsCapacityCapitalCost.interpolation_method_id StorageTechsCapacityCapitalCost_interpolation_method_id_fkey R
StorageTechsEnergyCapitalCost.extrapolation_method_id StorageTechsEnergyCapitalCost_extrapolation_method_id_fkey R
StorageTechsEnergyCapitalCost.interpolation_method_id StorageTechsEnergyCapitalCost_interpolation_method_id_fkey R
SupplyCapacityFactor.extrapolation_method SupplyCapacityFactor_extrapolation_method_fkey R
SupplyCapacityFactor.interpolation_method SupplyCapacityFactor_interpolation_method_fkey R
SupplyCost.extrapolation_method_id SupplyCost_extrapolation_method_id_fkey R
SupplyCost.interpolation_method_id SupplyCost_interpolation_method_id_fkey R
SupplyEfficiency.extrapolation_method_id SupplyEfficiency_extrapolation_method_id_fkey R
SupplyEfficiency.interpolation_method_id SupplyEfficiency_interpolation_method_id_fkey R
SupplyEmissions.extrapolation_method_id SupplyEmissions_extrapolation_method_id_fkey R
SupplyEmissions.interpolation_method_id SupplyEmissions_interpolation_method_id_fkey R
SupplyExport.extrapolation_method_id SupplyExport_extrapolation_method_id_fkey R
SupplyExport.interpolation_method_id SupplyExport_interpolation_method_id_fkey R
SupplyExportMeasures.extrapolation_method_id SupplyExportMeasures_extrapolation_method_id_fkey R
SupplyExportMeasures.interpolation_method_id SupplyExportMeasures_interpolation_method_id_fkey R
SupplyPotential.extrapolation_method_id SupplyPotential_extrapolation_method_id_fkey R
SupplyPotential.interpolation_method_id SupplyPotential_interpolation_method_id_fkey R
SupplyPotentialConversion.extrapolation_method_id SupplyPotentialConversion_extrapolation_method_id_fkey R
SupplyPotentialConversion.interpolation_method_id SupplyPotentialConversion_interpolation_method_id_fkey R
SupplySales.extrapolation_method SupplySales_extrapolation_method_fkey R
SupplySales.interpolation_method SupplySales_interpolation_method_fkey R
SupplySalesMeasures.extrapolation_method_id SupplySalesMeasures_extrapolation_method_id_fkey R
SupplySalesMeasures.interpolation_method_id SupplySalesMeasures_interpolation_method_id_fkey R
SupplySalesShare.extrapolation_method SupplySalesShare_extrapolation_method_fkey R
SupplySalesShare.interpolation_method SupplySalesShare_interpolation_method_fkey R
SupplySalesShareMeasures.extrapolation_method_id SupplySalesShareMeasures_extrapolation_method_id_fkey R
SupplySalesShareMeasures.interpolation_method_id SupplySalesShareMeasures_interpolation_method_id_fkey R
SupplyStock.extrapolation_method_id SupplyStock_extrapolation_method_id_fkey R
SupplyStock.interpolation_method_id SupplyStock_interpolation_method_id_fkey R
SupplyStockMeasures.extrapolation_method_id SupplyStockMeasures_extrapolation_method_id_fkey R
SupplyStockMeasures.interpolation_method_id SupplyStockMeasures_interpolation_method_id_fkey R
SupplyTechsCapacityFactor.extrapolation_method_id SupplyTechsCapacityFactor_extrapolation_method_fkey R
SupplyTechsCapacityFactor.interpolation_method_id SupplyTechsCapacityFactor_interpolation_method_fkey R
SupplyTechsCapitalCost.extrapolation_method_id SupplyTechsCapitalCost_extrapolation_method_id_fkey R
SupplyTechsCapitalCost.interpolation_method_id SupplyTechsCapitalCost_interpolation_method_id_fkey R
SupplyTechsCO2Capture.extrapolation_method_id SupplyTechsCO2Capture_extrapolation_method_id_fkey R
SupplyTechsCO2Capture.interpolation_method_id SupplyTechsCO2Capture_interpolation_method_id_fkey R
SupplyTechsEfficiency.extrapolation_method_id SupplyTechsEfficiency_extrapolation_method_id_fkey R
SupplyTechsEfficiency.interpolation_method_id SupplyTechsEfficiency_interpolation_method_id_fkey R
SupplyTechsFixedMaintenanceCost.extrapolation_method_id SupplyTechsFixedMaintenanceCost_extrapolation_method_id_fkey R
SupplyTechsFixedMaintenanceCost.interpolation_method_id SupplyTechsFixedMaintenanceCost_interpolation_method_id_fkey R
SupplyTechsInstallationCost.extrapolation_method_id SupplyTechsInstallationCost_extrapolation_method_id_fkey R
SupplyTechsInstallationCost.interpolation_method_id SupplyTechsInstallationCost_interpolation_method_id_fkey R
SupplyTechsVariableMaintenanceCost.extrapolation_method_id SupplyTechsVariableMaintenanceCost_extrapolation_method_id_fkey R
SupplyTechsVariableMaintenanceCost.interpolation_method_id SupplyTechsVariableMaintenanceCost_interpolation_method_id_fkey R
name text 2147483647 name for the cleaning method, checked for in code time_series.py

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

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

Close relationships  within of separation: