openego / eGon-data

    topo = Column(Geometry("LINESTRING", 4326))

class EgonPfHvLinkTimeseries(Base):

    __tablename__ = "egon_etrago_link_timeseries"

    __table_args__ = {"schema": "grid"}

    scn_name = Column(String, primary_key=True, nullable=False)

    link_id = Column(BigInteger, primary_key=True, nullable=False)

    temp_id = Column(Integer, primary_key=True, nullable=False)

    p_set = Column(ARRAY(Float(precision=53)))

    p_min_pu = Column(ARRAY(Float(precision=53)))

    p_max_pu = Column(ARRAY(Float(precision=53)))

    efficiency = Column(ARRAY(Float(precision=53)))

    marginal_cost = Column(ARRAY(Float(precision=53)))

class EgonPfHvLoad(Base):

    )  # [MWh(/y)] Value to be used in eTraGo to set constraint for the production over the year

class EgonPfHvGeneratorTimeseries(Base):

    __tablename__ = "egon_etrago_generator_timeseries"

    __table_args__ = {"schema": "grid"}

    scn_name = Column(String, primary_key=True, nullable=False)

    generator_id = Column(Integer, primary_key=True, nullable=False)

    temp_id = Column(Integer, primary_key=True, nullable=False)

    p_set = Column(ARRAY(Float(precision=53)))

    q_set = Column(ARRAY(Float(precision=53)))

    p_min_pu = Column(ARRAY(Float(precision=53)))

    p_max_pu = Column(ARRAY(Float(precision=53)))

    marginal_cost = Column(ARRAY(Float(precision=53)))

class EgonPfHvLine(Base):