class Electricity(SurrogatePK, Model): __tablename__ = "electricity_data" id = Column(db.Integer(), nullable=False, primary_key=True) created_at = Column(db.Text(), nullable=False, default=dt.datetime.utcnow) meter_180 = Column(db.Float(), nullable=True) meter_280 = Column(db.Float(), nullable=True) active_power = Column(db.Float(), nullable=True)
class Weather(SurrogatePK, Model): __tablename__ = 'weather_data' id = Column(db.Integer(), nullable=False, primary_key=True) created_at = Column(db.Text(), nullable=False, default=dt.datetime.utcnow) temp = Column(db.Float(), nullable=True) pressure = Column(db.Integer(), nullable=True) temp_min = Column(db.Float(), nullable=True) temp_max = Column(db.Float(), nullable=True) humidity = Column(db.Integer(), nullable=True) wind_speed = Column(db.Float(), nullable=True) wind_gust = Column(db.Float(), nullable=True) wind_deg = Column(db.Integer(), nullable=True) clouds = Column(db.Integer(), nullable=True) rain = Column(db.Integer(), nullable=True) snow = Column(db.Integer(), nullable=True) weather_id = Column(db.Integer(), nullable=True)
class PVData(SurrogatePK, Model): __tablename__ = 'pvdata' id = Column(db.Integer(), nullable=False, primary_key=True) created_at = Column(db.Text(), nullable=False, default=dt.datetime.utcnow) dc_1_u = Column(db.Integer(), nullable=True) dc_1_i = Column(db.Float(), nullable=True) ac_1_u = Column(db.Integer(), nullable=True) ac_1_p = Column(db.Integer(), nullable=True) dc_2_u = Column(db.Integer(), nullable=True) dc_2_i = Column(db.Float(), nullable=True) ac_2_u = Column(db.Integer(), nullable=True) ac_2_p = Column(db.Integer(), nullable=True) dc_3_u = Column(db.Integer(), nullable=True) dc_3_i = Column(db.Float(), nullable=True) ac_3_u = Column(db.Integer(), nullable=True) ac_3_p = Column(db.Integer(), nullable=True) current_power = Column(db.Integer(), nullable=True) daily_energy = Column(db.Float(), nullable=True) total_energy = Column(db.Integer(), nullable=True)