db_schema.sql
CREATE TABLE weather_data (
id INTEGER PRIMARY KEY NOT NULL,
created_at TEXT NOT NULL,
"temp" FLOAT,
pressure INTEGER,
temp_min FLOAT,
temp_max FLOAT,
humidity INTEGER,
wind_speed FLOAT,
wind_gust FLOAT,
wind_deg INTEGER,
clouds INTEGER,
rain INTEGER,
snow INTEGER,
weather_id INTEGER
);
CREATE TABLE IF NOT EXISTS "pvdata" (
id INTEGER PRIMARY KEY NOT NULL,
created_at DATETIME NOT NULL,
dc_1_u INTEGER,
dc_1_i REAL,
ac_1_u INTEGER,
ac_1_p INTEGER,
dc_2_u INTEGER,
dc_2_i REAL,
ac_2_u INTEGER,
ac_2_p INTEGER,
dc_3_u INTEGER,
dc_3_i REAL,
ac_3_u INTEGER,
ac_3_p INTEGER,
current_power INTEGER,
daily_energy REAL,
total_energy INTEGER
);
CREATE TABLE IF NOT EXISTS "electricity_data" (
id INTEGER PRIMARY KEY NOT NULL,
created_at DATETIME NOT NULL,
meter_180 REAL,
meter_280 REAL,
active_power REAL
);