Table pathways_us_2017-1-15.public.DemandSectors
Demand sectors act as a grouping for organization. Inputs here function as default values that trickle down to subsectors.

 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('"DemandSectors_id_seq"'::regclass)
BlendNodeBlendMeasuresData.demand_sector_id BlendNodeBlendMeasuresData_demand_sector_id_fkey R
DemandSubsectors.sector_id DemandSubsectors_sector_id_fkey R
ImportCostData.demand_sector_id ImportCostData_demand_sector_id_fkey R
PrimaryCostData.demand_sector_id PrimaryCostData_demand_sector_id_fkey R
SupplyCostData.demand_sector_id SupplyCostData_demand_sector_fkey R
SupplyEfficiencyData.demand_sector_id SupplyEfficiencyData_demand_sector_id_fkey R
SupplyEmissionsData.demand_sector_id SupplyEmissionsData_demand_sector_id_fkey R
SupplyPotentialData.demand_sector_id SupplyPotentialData_demand_sector_fkey R
SupplySalesData.demand_sector_id SupplySalesData_demand_sector_fkey R
SupplySalesMeasuresData.demand_sector_id SupplySalesMeasuresData_demand_sector_fkey R
SupplySalesShareData.demand_sector_id SupplySalesShareData_demand_sector_fkey R
SupplySalesShareMeasuresData.demand_sector_id SupplySalesShareMeasuresData_demand_sector_fkey R
SupplyStockData.demand_sector_id SupplyStockData_demand_sector_fkey R
SupplyStockMeasuresData.demand_sector_id SupplyStockMeasuresData_demand_sector_fkey R
SupplyTechsCapitalCostNewData.demand_sector_id SupplyTechsCapitalCostNewData_demand_sector_id_fkey R
SupplyTechsCapitalCostReplacementData.demand_sector_id SupplyTechsCapitalCostReplacementData_demand_sector_id_fkey R
SupplyTechsEfficiencyData.demand_sector_id SupplyTechsEfficiencyData_demand_sector_id_fkey R
SupplyTechsFixedMaintenanceCostData.demand_sector_id SupplyTechsFixedMaintenanceCostData_demand_sector_id_fkey R
SupplyTechsInstallationCostNewData.demand_sector_id SupplyTechsInstallationCostNewData_demand_sector_id_fkey R
SupplyTechsInstallationCostReplacementData.demand_sector_id SupplyTechsInstallationCostReplacementDat_demand_sector_id_fkey R
SupplyTechsVariableMaintenanceCostData.demand_sector_id SupplyTechsVariableMaintenanceCostData_demand_sector_id_fkey R
name text 2147483647
shape_id int4 10  √  null Default electricity shape for the sector
max_lead_hours int4 10  √  null Max lead hours refer to the number of hours that electricity service demand can be advanced in time. At the sector level, this acts as a default value that trickles down to all member subsectors. Note that this flexible load is further moderated by a demand flexible load package that control what percent of total subsector load is flexible year-by-year.
max_lag_hours int4 10  √  null Max lag hours refer to the number of hours that electricity service demand can be delayed in time. At the sector level, this acts as a default value that trickles down to all member subsectors. Note that this flexible load is further moderated by a demand flexible load package that control what percent of total subsector load is flexible year-by-year.

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

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

Close relationships  within of separation: