SchemaSpy Analysis of pathways_us_2017-1-15.publicThis schema analysis is based on the U.S. database for EnergyPATHWAYS, maintained by Evolved Energy Research, and row counts reflect the dated version. Generated by
SchemaSpy
Generated by SchemaSpy on Tue Jan 17 22:23 PST 2017
Database Type: PostgreSQL - 9.5.1

XML Representation
Insertion Order Deletion Order (for database loading/purging scripts)

Table / View Children Parents Columns Rows Comments
AgeGrowthOrDecayType 11 2 2
BlendMeasuresData 6 view
BlendNodeBlendMeasurePackages 2 1 3 37
BlendNodeBlendMeasurePackagesData 2 3 76
BlendNodeBlendMeasures 2 6 9 74
BlendNodeBlendMeasuresData 3 6 623
BlendNodeInputsData 2 3 53
CapitalCostOutputs 10 view
CleaningMethods 108 2 8 Cleaning methods are used to interpolate or extrapolate to missing years of data.
Currencies 17 2 42 List of currencies supported, either for input or output.
CurrenciesConversion 4 551 Conversion factors between each currency for each supported year.
CurrencyYears 16 1 17 List of supported years for currency conversion. Inputs must fall within this list.
DayType 1 2 2 Work-day or non-workday
Definitions 17 2 2 In reference to a technology attribute, are the inputs absolute or relative to another technology?
Demand Technologies - Auxiliary Efficiency 14 view
Demand Technologies - Capital Costs 13 view
Demand Technologies - Fixed OM 12 view
Demand Technologies - Fuel Switching Costs 13 view
Demand Technologies - Main Efficiency 14 view
Demand Technologies - Parasitic Energy 11 view
Demand Techs - Installation Costs 13 view
DemandCases 2 2 16 List of demand cases. This is a grouping of packages on the demand side.
DemandCasesData 2 2 504 Matches the packages for each subsector in DemandCasesData to each demand case in DemandCases.
DemandCO2CaptureMeasures 8 16 0
DemandDrivers 14 8 13 60 List of demand driver records, the function of which is explained here: https://docs.google.com/document/d/19cspAg2El5d1dvQggi7Vx8XJ1al-11IDf6DgRbpk-FU/edit#heading=h.94rqs9slq4zx
DemandDriversData 4 7 22,755 Timeseries data (by year) associated with each demand driver record.
DemandEnergyDemands 1 12 17 47 For each demand subsector, what is the historical, or projected, energy demand?
DemandEnergyDemandsData 5 9 94,949 Timeseries data (by year) associated with each energy demand record.
DemandEnergyEfficiencyMeasurePackages 2 1 3 71
DemandEnergyEfficiencyMeasurePackagesData 2 3 74
DemandEnergyEfficiencyMeasures 4 8 16 72
DemandEnergyEfficiencyMeasuresCost 8 12 55
DemandEnergyEfficiencyMeasuresCostData 5 8 1,412
DemandEnergyEfficiencyMeasuresData 5 8 240
DemandFlexibleLoadMeasurePackages 2 1 3 9
DemandFlexibleLoadMeasurePackagesData 2 3 9
DemandFlexibleLoadMeasures 2 5 7 9
DemandFlexibleLoadMeasuresData 1 6 18
DemandFuelSwitchingMeasurePackages 2 1 3 22
DemandFuelSwitchingMeasurePackagesData 2 3 33
DemandFuelSwitchingMeasures 7 4 10 30
DemandFuelSwitchingMeasuresCost 8 12 6
DemandFuelSwitchingMeasuresCostData 4 7 6
DemandFuelSwitchingMeasuresEnergyIntensity 6 8 30
DemandFuelSwitchingMeasuresEnergyIntensityData 4 7 31
DemandFuelSwitchingMeasuresImpact 7 10 30
DemandFuelSwitchingMeasuresImpactData 4 7 63
DemandSales 1 7 8 10 Demand sales by vintage within certain subsectors. Sales are specified by vintage.
DemandSalesData 5 8 3,319 Vintage by technology sales inputs.
DemandSalesMeasurePackages 2 1 3 111
DemandSalesMeasurePackagesData 2 3 376
DemandSalesMeasures 2 8 11 357
DemandSalesMeasuresData 3 6 750
DemandSectors 21 5 4 Demand sectors act as a grouping for organization. Inputs here function as default values that trickle down to subsectors.
DemandServiceDemandMeasurePackages 2 1 3 14
DemandServiceDemandMeasurePackagesData 2 3 14
DemandServiceDemandMeasures 4 8 16 15
DemandServiceDemandMeasuresCost 8 12 0
DemandServiceDemandMeasuresCostData 4 7 0
DemandServiceDemandMeasuresData 4 7 60
DemandServiceDemands 1 12 17 17 Service demand input options for subsectors.
DemandServiceDemandsData 6 9 693 Annual input data for service demand records.
DemandServiceEfficiency 7 10 3 Service efficiency is the energy required per unit of service demand. This is rarely a direct input for a subsector, but is most of the time calculated as a function of technologies. One example from the U.S. database is freight rail, which is input in kiloBtu per ton mile.
DemandServiceEfficiencyData 5 8 323 Annual data inputs for the service efficiency records.
DemandServiceLink 1 2 5 6 Functionallity for linking the service demand of different subsectors. For instance, hot water is demanded for dish washing and if dish washers become more water efficient, the total demand for hot water will drop.
DemandStates 1 7 9 221 Matches different types of packages to demand subsectors.
DemandStock 1 13 17 24 Stock by technology input options for subsectors.
DemandStockData 5 8 1,876 Annual records for demand stock inputs.
DemandStockMeasurePackages 2 1 3 2
DemandStockMeasurePackagesData 2 3 4
DemandStockMeasures 2 6 9 5
DemandStockMeasuresData 3 6 70
DemandStockUnitTypes 1 2 3
DemandSubsectors 24 2 8 63 Subsectors are the main organizational unit on the demand side and serve as independent service activities with fungible technologies. It is possible to create a subsector using many different combinations of input data. For more information, see this section of the model documentation: https://docs.google.com/document/d/19cspAg2El5d1dvQggi7Vx8XJ1al-11IDf6DgRbpk-FU/edit#heading=h.378v7ykr2w5w
DemandTechEfficiencyTypes 2 2 2 Efficiency types include absolute or relative.
DemandTechs 25 5 19 234 Demand technologies get used across subsectors that have a stock.
DemandTechsAuxEfficiency 10 17 6
DemandTechsAuxEfficiencyData 4 7 101
DemandTechsCapitalCost 1 9 12 231 Capital cost records for each technology.
DemandTechsCapitalCostNewData 4 7 1,349 Capital cost for new demand technologies by vintage.
DemandTechsCapitalCostReplacementData 4 7 0
DemandTechsFixedMaintenanceCost 2 11 14 176 Annual fixed maintenance cost for each demand technology.
DemandTechsFixedMaintenanceCostData 4 7 352 Annual fixed maintenance cost for each demand technology by technology vintage.
DemandTechsFuelSwitchCost 1 10 12 11 Technology cost that comes from fuel switching. For example, switching from an internal combustion engine to a battery electric vehicle could incur a fuel switching cost, which is the cost of a home charging station. Note that this charge only happens once when the initial fuel switch occurs.
DemandTechsFuelSwitchCostData 4 7 20 Vingaged data for technology fuel switching cost.
DemandTechsInstallationCost 9 12 126 Installation cost record for a technology.
DemandTechsInstallationCostNewData 4 7 251 Installation cost record for a new technology by vintage.
DemandTechsInstallationCostReplacementData 4 7 0 Installation cost record for a replacement technology by vintage.
DemandTechsMainEfficiency 1 11 18 226 Efficiency for demand technologies.
DemandTechsMainEfficiencyData 4 7 1,784 Efficiency for demand technologies by vintage.
DemandTechsParasiticEnergy 8 13 6
DemandTechsParasiticEnergyData 5 8 21
DemandTechsServiceDemandModifier 7 9 19
DemandTechsServiceDemandModifierData 4 7 19
DemandTechsServiceLink 1 9 13 40
DemandTechsServiceLinkData 4 7 740
DemandTechUnitTypes 1 2 2
DispatchConfig 4 8 1
DispatchConstraintTypes 2 3
DispatchFeeders 1 2 3
DispatchFeedersAllocation 2 6 1
DispatchFeedersAllocationData 7 6
DispatchNodeConfig 1 3 4 5
DispatchNodeData 2 9 52
DispatchWindows 1 2 4
EfficiencyTypes 2 2 3
EnergyDemand 8 view
EnergyDemandData0Index 6 view
EnergyDemandData1Index 7 view
FinalEnergy 11 1 3 27
FlexibleLoadShiftTypes 1 2 3
Geographies 54 2 12
GeographiesData 62 1 3 3,293
GeographyIntersection 2 1 3,753
GeographyIntersectionData 2 3 45,036
GeographyMap 2 4 213,921
GeographyMapKeys 14 2 57
GreenhouseGasEmissionsType 1 2 2
GreenhouseGases 1 3 3
IDMap 2 30
ImportCost 1 6 10 13
ImportCostData 3 6 2,923
IndexLevels 3 26
InflationConversion 2 4 16
InputTypes 11 2 2
OtherIndexes 63 2 29
OtherIndexesData 67 1 3 163
OtherIndexesData_copy 1 3 163
OthIndex 2 view
PrimaryCost 7 9 11
PrimaryCostData 4 8 848
SalesMeasureNameTech 5 view
SalesMeasureReplacedTech 5 view
Scenarios 1 3 6 14
Shapes 5 10 12 35
ShapesData 4 14 784,032
ShapesTypes 1 2 2
ShapesUnits 1 2 2
StockDecayFunctions 7 2 3
StorageTechsCapacityCapitalCost 1 8 12 2
StorageTechsCapacityCapitalCostNewData 4 7 2
StorageTechsCapacityCapitalCostReplacementData 4 6 0
StorageTechsEnergyCapitalCost 1 8 11 1
StorageTechsEnergyCapitalCostNewData 4 7 9
StorageTechsEnergyCapitalCostReplacementData 4 7 0
SupplyCapacityFactor 1 4 8 2
SupplyCapacityFactorData 2 7 5
SupplyCases 2 2 12
SupplyCasesData 2 2 218
SupplyCost 1 7 18 11
SupplyCostData 3 7 4,035
SupplyCostTypes 1 2 3
SupplyEfficiency 1 4 9 29
SupplyEfficiencyData 5 9 1,225
SupplyEmissions 4 10 27
SupplyEmissionsData 6 9 57
SupplyExport 1 5 7 10
SupplyExportData 3 7 592
SupplyExportMeasurePackages 2 1 3 5
SupplyExportMeasurePackagesData 2 3 5
SupplyExportMeasures 2 5 8 5
SupplyExportMeasuresData 3 6 51
SupplyNodes 38 7 22 107
SupplyPotential 1 6 9 14
SupplyPotentialConversion 1 5 8 7
SupplyPotentialConversionData 3 7 33
SupplyPotentialData 4 8 5,846
SupplySales 1 5 8 17
SupplySalesData 4 8 6,571
SupplySalesMeasurePackages 2 1 3 0
SupplySalesMeasurePackagesData 2 3 0
SupplySalesMeasures 1 7 10 1
SupplySalesMeasuresData 4 8 0
SupplySalesShare 4 5 13
SupplySalesShareData 4 7 13
SupplySalesShareMeasurePackages 2 1 3 17
SupplySalesShareMeasurePackagesData 2 3 21
SupplySalesShareMeasures 2 7 12 18
SupplySalesShareMeasuresData 4 8 28
SupplyStates 1 6 8 97
SupplyStock 5 8 23
SupplyStockData 4 8 26,338
SupplyStockMeasurePackages 2 1 3 48
SupplyStockMeasurePackagesData 2 3 60
SupplyStockMeasures 2 7 12 60
SupplyStockMeasuresData 4 8 20,101
SupplyTechs 30 3 16 113
SupplyTechsCapacityFactor 1 7 9 52
SupplyTechsCapacityFactorData 3 7 392
SupplyTechsCapitalCost 1 9 15 104
SupplyTechsCapitalCostNewData 3 7 944
SupplyTechsCapitalCostReplacementData 3 7 1
SupplyTechsCO2Capture 1 7 9 28
SupplyTechsCO2CaptureData 2 6 28
SupplyTechsEfficiency 1 7 13 113
SupplyTechsEfficiencyData 5 9 4,556
SupplyTechsFixedMaintenanceCost 1 9 15 77
SupplyTechsFixedMaintenanceCostData 3 7 180
SupplyTechsInstallationCost 1 8 14 33
SupplyTechsInstallationCostNewData 3 7 209
SupplyTechsInstallationCostReplacementData 3 7 180
SupplyTechsVariableMaintenanceCost 1 9 14 81
SupplyTechsVariableMaintenanceCostData 3 7 68
SupplyTypes 1 2 6
TimeZones 1 3 8
Version 3 1
           
191 Tables     1,351 1,263,504  
15 Views     139