f5484f57c5419d476641f5e124cb558fcafe4ea0,pudl/models/eia923.py,GenerationEIA923,GenerationEIA923_1,#,268

Before Change

    // Each month, for each unique combination of generator id and prime mover
    // and fuel,there is one report for each generator unit in each plant.
    id = Column(Integer, autoincrement=True, primary_key=True)  // surrogate key
    plant_id_eia = Column(Integer, ForeignKey("plants_entity_eia.plant_id_eia"),
                          nullable=False)
    // TODO remove prime_mover since it"s specific to generator_id?
    prime_mover = Column(String, ForeignKey("prime_movers_eia923.abbr"),

After Change

    Monthly electricity generation by generator from EIA923 Page 4.

    __tablename__ = "generation_eia923"
    __table_args__ = (ForeignKeyConstraint(
        ["plant_id_eia", "generator_id"],
        ["generators_entity_eia.plant_id_eia",
         "generators_entity_eia.generator_id"]),)

    // Each month, for each unique combination of generator id and prime mover
    // and fuel,there is one report for each generator unit in each plant.
    id = Column(Integer, autoincrement=True, primary_key=True)  // surrogate key

Instances