Table pathways_us_2017-1-15.public.SupplyTechs 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('"SupplyTechs_id_seq"'::regclass)
StorageTechsCapacityCapitalCost.supply_tech_id StorageTechsCapacityCapitalCost_supply_tech_id_fkey R
StorageTechsCapacityCapitalCostNewData.supply_tech_id StorageTechsCapacityCapitalCostNewData_supply_tech_id_fkey R
StorageTechsCapacityCapitalCostReplacementData.supply_tech_id StorageTechsCapacityCapitalCostReplacementD_supply_tech_id_fkey R
StorageTechsEnergyCapitalCost.supply_tech_id StorageTechsEnergyCapitalCost_supply_tech_id_fkey R
StorageTechsEnergyCapitalCostNewData.supply_tech_id StorageTechsEnergyCapitalCostNewData_supply_tech_id_fkey R
StorageTechsEnergyCapitalCostReplacementData.supply_tech_id StorageTechsEnergyCapitalCostReplacementDat_supply_tech_id_fkey R
SupplySalesData.supply_technology_id SupplySalesData_supply_technology_fkey R
SupplySalesMeasurePackagesData.measure_id SupplySalesMeasurePackagesData_measure_id_fkey R
SupplySalesMeasures.supply_technology_id SupplySalesMeasures_supply_technology_id_fkey R
SupplySalesShareData.supply_technology_id SupplySalesShareData_supply_technology_fkey R
SupplySalesShareMeasures.replaced_supply_technology_id SupplySalesShareMeasures_replaced_supply_technology_id_fkey R
SupplySalesShareMeasures.supply_technology_id SupplySalesShareMeasures_supply_technology_id_fkey R
SupplyStockData.supply_technology_id SupplyStockData_supply_technology_fkey R
SupplyStockMeasures.supply_technology_id SupplyStockMeasures_supply_technology_id_fkey R
SupplyTechsCapacityFactor.supply_tech_id SupplyTechsCapacityFactor_supply_tech_id_fkey R
SupplyTechsCapacityFactorData.supply_tech_id SupplyTechsCapacityFactorData_supply_tech_id_fkey R
SupplyTechsCapitalCost.supply_tech_id SupplyTechsCapitalCost_supply_tech_id_fkey R
SupplyTechsCapitalCostNewData.supply_tech_id SupplyTechsCapitalCostNewData_supply_tech_id_fkey R
SupplyTechsCapitalCostReplacementData.supply_tech_id SupplyTechsCapitalCostReplacementData_supply_tech_id_fkey R
SupplyTechsCO2Capture.supply_tech_id SupplyTechsCO2Capture_supply_tech_id_fkey R
SupplyTechsCO2CaptureData.supply_tech_id SupplyTechsCO2CaptureData_supply_tech_id_fkey R
SupplyTechsEfficiency.supply_tech_id SupplyTechsEfficiency_supply_tech_id_fkey R
SupplyTechsEfficiencyData.supply_tech_id SupplyTechsEfficiencyData_supply_tech_id_fkey R
SupplyTechsFixedMaintenanceCost.supply_tech_id SupplyTechsFixedMaintenanceCost_supply_tech_id_fkey R
SupplyTechsFixedMaintenanceCostData.supply_tech_id SupplyTechsFixedMaintenanceCostData_supply_tech_id_fkey R
SupplyTechsInstallationCost.supply_tech_id SupplyTechsInstallationCost_supply_tech_id_fkey R
SupplyTechsInstallationCostNewData.supply_tech_id SupplyTechsInstallationCostNewData_supply_tech_id_fkey R
SupplyTechsInstallationCostReplacementData.supply_tech_id SupplyTechsInstallationCostReplacementData_supply_tech_id_fkey R
SupplyTechsVariableMaintenanceCost.supply_tech_id SupplyTechsVariableMaintenanceCost_supply_tech_id_fkey R
SupplyTechsVariableMaintenanceCostData.supply_tech_id SupplyTechsVariableMaintenanceCostData_supply_tech_id_fkey R
name text 2147483647
supply_node_id int4 10  √  null
SupplyNodes.id SupplyTechs_supply_node_id_fkey R
source text 2147483647  √  null
additional_description text 2147483647  √  null
stock_decay_function_id int4 10  √  null
StockDecayFunctions.id SupplyTechs_stock_decay_function_id_fkey R
book_life int4 10  √  null
mean_lifetime float4 8,8  √  null
lifetime_variance float4 8,8  √  null
min_lifetime float4 8,8  √  null
max_lifetime float4 8,8  √  null
discharge_duration float4 8,8  √  null
cost_of_capital float4 8,8  √  null
shape_id int4 10  √  null
Shapes.id SupplyTechs_shape_id_fkey R
max_lag_hours int4 10  √  null
max_lead_hours int4 10  √  null

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

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

Close relationships  within of separation: