openego / eGon-data

    rs7_id = Column(SmallInteger)

class EgonEvCountMvGridDistrict(Base):

    """

    Class definition of table demand.egon_ev_count_mv_grid_district.

    Contains electric vehicle counts per MV grid district.

    """

    __tablename__ = "egon_ev_count_mv_grid_district"

    __table_args__ = {"schema": "demand"}

    scenario = Column(String, ForeignKey(EgonScenario.name), primary_key=True)

    scenario_variation = Column(String, primary_key=True)

    bus_id = Column(

        Integer, ForeignKey(MvGridDistricts.bus_id), primary_key=True

    )

    bev_mini = Column(Integer)

    bev_medium = Column(Integer)

    bev_luxury = Column(Integer)

    phev_mini = Column(Integer)

    phev_medium = Column(Integer)

    phev_luxury = Column(Integer)

class EgonEvCountMunicipality(Base):

    """

    Class definition of table demand.egon_ev_count_municipality.

    Contains electric vehicle counts per municipality.

    """

    __tablename__ = "egon_ev_count_municipality"

    __table_args__ = {"schema": "demand"}

    scenario = Column(String, ForeignKey(EgonScenario.name), primary_key=True)

    scenario_variation = Column(String, primary_key=True)

    ags = Column(Integer, primary_key=True)

    bev_mini = Column(Integer)

    bev_medium = Column(Integer)

    bev_luxury = Column(Integer)

    phev_mini = Column(Integer)

    phev_medium = Column(Integer)

    # ev = relationship("EgonEvPool", back_populates="trips")

class EgonEvCountRegistrationDistrict(Base):

    """

    Class definition of table demand.egon_ev_count_registration_district.

    Contains electric vehicle counts per registration district.

    """

    __tablename__ = "egon_ev_count_registration_district"

    __table_args__ = {"schema": "demand"}

    scenario = Column(String, ForeignKey(EgonScenario.name), primary_key=True)

    scenario_variation = Column(String, primary_key=True)

    ags_reg_district = Column(Integer, primary_key=True)

    reg_district = Column(String)

    bev_mini = Column(Integer)

    bev_medium = Column(Integer)

    bev_luxury = Column(Integer)

    phev_mini = Column(Integer)