database

-- phpMyAdmin SQL Dump
-- version 5.2.0
-- https://www.phpmyadmin.net/
--
-- Host: localhost
-- Generation Time: Oct 09, 2023 at 05:49 PM
-- Server version: 8.0.29-0ubuntu0.22.04.2
-- PHP Version: 8.1.2

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";

--
-- Database: `smarthouse`
--

-- --------------------------------------------------------

--
-- Table structure for table `pv_battery_bat`
--

CREATE TABLE `pv_battery_bat` (
  `log_date` datetime NOT NULL,
  `uuid` varchar(255) COLLATE utf8_czech_ci DEFAULT NULL,
  `Time` text COLLATE utf8_czech_ci,
  `A.Tempr` double DEFAULT NULL,
  `C.Curr` double DEFAULT NULL,
  `D.Curr` double DEFAULT NULL,
  `B.State` text COLLATE utf8_czech_ci,
  `BalVolt` double DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_czech_ci;

-- --------------------------------------------------------

--
-- Table structure for table `pv_battery_bat_battery`
--

CREATE TABLE `pv_battery_bat_battery` (
  `parent_uuid` varchar(255) COLLATE utf8_czech_ci NOT NULL,
  `Bat` double NOT NULL,
  `Volt` double DEFAULT NULL,
  `Curr` double DEFAULT NULL,
  `Tempr` double DEFAULT NULL,
  `V.State` text COLLATE utf8_czech_ci,
  `T.State` text COLLATE utf8_czech_ci,
  `AH(%)` double DEFAULT NULL,
  `AH(mAH)` double DEFAULT NULL,
  `WH(%)` double DEFAULT NULL,
  `WH(mWH)` double DEFAULT NULL,
  `Bal` text COLLATE utf8_czech_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_czech_ci;

-- --------------------------------------------------------

--
-- Table structure for table `pv_battery_data_event`
--

CREATE TABLE `pv_battery_data_event` (
  `log_date` datetime NOT NULL,
  `uuid` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8_czech_ci NOT NULL,
  `Item Index` double DEFAULT NULL,
  `Time` datetime DEFAULT NULL,
  `Voltage` double DEFAULT NULL,
  `Current` double DEFAULT NULL,
  `Temperature` double DEFAULT NULL,
  `Percent` double DEFAULT NULL,
  `Total Coulomb` double DEFAULT NULL,
  `Max Voltage` double DEFAULT NULL,
  `Base State` text COLLATE utf8_czech_ci,
  `Volt. State` text COLLATE utf8_czech_ci,
  `Curr. State` text COLLATE utf8_czech_ci,
  `Tempr. State` text COLLATE utf8_czech_ci,
  `Coul. Status` text COLLATE utf8_czech_ci,
  `Power Events` text COLLATE utf8_czech_ci,
  `Unit Events` text COLLATE utf8_czech_ci,
  `Bat Events` text COLLATE utf8_czech_ci,
  `Bat Protect ENA` text COLLATE utf8_czech_ci,
  `Unit Protect ENA` text COLLATE utf8_czech_ci,
  `Pwr Protect ENA` text CHARACTER SET utf8mb3 COLLATE utf8_czech_ci,
  `System Fault` text COLLATE utf8_czech_ci,
  `Fault SubCode` text COLLATE utf8_czech_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_czech_ci;

-- --------------------------------------------------------

--
-- Table structure for table `pv_battery_data_event_battery`
--

CREATE TABLE `pv_battery_data_event_battery` (
  `parent_uuid` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8_czech_ci NOT NULL,
  `Battery` double NOT NULL,
  `Volt` double DEFAULT NULL,
  `Tempr` double DEFAULT NULL,
  `Volt. State` text CHARACTER SET utf8mb3 COLLATE utf8_czech_ci,
  `Temp. State` text CHARACTER SET utf8mb3 COLLATE utf8_czech_ci,
  `Coulomb(%)` double DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_czech_ci;

-- --------------------------------------------------------

--
-- Table structure for table `pv_battery_data_event_unit`
--

CREATE TABLE `pv_battery_data_event_unit` (
  `parent_uuid` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8_czech_ci NOT NULL,
  `Unit` double NOT NULL,
  `Volt` double DEFAULT NULL,
  `Tempr` double DEFAULT NULL,
  `BTLow` double DEFAULT NULL,
  `BTHigh` double DEFAULT NULL,
  `BVLow` double DEFAULT NULL,
  `BVHigh` double DEFAULT NULL,
  `Volt. State` text CHARACTER SET utf8mb3 COLLATE utf8_czech_ci,
  `Temp. State` text CHARACTER SET utf8mb3 COLLATE utf8_czech_ci,
  `Coulomb(%)` double DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_czech_ci;

-- --------------------------------------------------------

--
-- Table structure for table `pv_battery_data_history`
--

CREATE TABLE `pv_battery_data_history` (
  `log_date` datetime NOT NULL,
  `uuid` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8_czech_ci NOT NULL,
  `Rec Item Index` double DEFAULT NULL,
  `Time` datetime DEFAULT NULL,
  `Voltage` double DEFAULT NULL,
  `Current` double DEFAULT NULL,
  `Temperature` double DEFAULT NULL,
  `Percent` double DEFAULT NULL,
  `Total Coulomb` double DEFAULT NULL,
  `Max Voltage` double DEFAULT NULL,
  `Base State` text COLLATE utf8_czech_ci,
  `Volt. State` text COLLATE utf8_czech_ci,
  `Curr. State` text COLLATE utf8_czech_ci,
  `Tempr. State` text COLLATE utf8_czech_ci,
  `Coul. Status` text COLLATE utf8_czech_ci,
  `Power Events` text COLLATE utf8_czech_ci,
  `Unit Events` text COLLATE utf8_czech_ci,
  `Bat Events` text COLLATE utf8_czech_ci,
  `Bat Protect ENA` text COLLATE utf8_czech_ci,
  `Unit Protect ENA` text COLLATE utf8_czech_ci,
  `Pwr Protect ENA` text COLLATE utf8_czech_ci,
  `System Fault` text COLLATE utf8_czech_ci,
  `Fault SubCode` text COLLATE utf8_czech_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_czech_ci;

-- --------------------------------------------------------

--
-- Table structure for table `pv_battery_data_history_battery`
--

CREATE TABLE `pv_battery_data_history_battery` (
  `parent_uuid` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8_czech_ci NOT NULL,
  `Battery` double NOT NULL,
  `Volt` double DEFAULT NULL,
  `Tempr` double DEFAULT NULL,
  `Volt. State` text CHARACTER SET utf8mb3 COLLATE utf8_czech_ci,
  `Temp. State` text CHARACTER SET utf8mb3 COLLATE utf8_czech_ci,
  `Coulomb(%)` double DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_czech_ci;

-- --------------------------------------------------------

--
-- Table structure for table `pv_battery_data_history_unit`
--

CREATE TABLE `pv_battery_data_history_unit` (
  `parent_uuid` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8_czech_ci NOT NULL,
  `Unit` double NOT NULL,
  `Volt` double DEFAULT NULL,
  `Tempr` double DEFAULT NULL,
  `BTLow` double DEFAULT NULL,
  `BTHigh` double DEFAULT NULL,
  `BVLow` double DEFAULT NULL,
  `BVHigh` double DEFAULT NULL,
  `Volt. State` text CHARACTER SET utf8mb3 COLLATE utf8_czech_ci,
  `Temp. State` text CHARACTER SET utf8mb3 COLLATE utf8_czech_ci,
  `Coulomb(%)` double DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_czech_ci;

-- --------------------------------------------------------

--
-- Table structure for table `pv_battery_data_misc`
--

CREATE TABLE `pv_battery_data_misc` (
  `log_date` datetime NOT NULL,
  `uuid` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8_czech_ci NOT NULL,
  `Rec Item Index` double DEFAULT NULL,
  `Time` datetime DEFAULT NULL,
  `Voltage` double DEFAULT NULL,
  `Current` double DEFAULT NULL,
  `Temperature` double DEFAULT NULL,
  `Percent` double DEFAULT NULL,
  `Total Coulomb` double DEFAULT NULL,
  `Max Voltage` double DEFAULT NULL,
  `Base State` text COLLATE utf8_czech_ci,
  `Volt. State` text COLLATE utf8_czech_ci,
  `Curr. State` text COLLATE utf8_czech_ci,
  `Tempr. State` text COLLATE utf8_czech_ci,
  `Coul. Status` text COLLATE utf8_czech_ci,
  `Power Events` text COLLATE utf8_czech_ci,
  `Unit Events` text COLLATE utf8_czech_ci,
  `Bat Events` text COLLATE utf8_czech_ci,
  `Bat Protect ENA` text COLLATE utf8_czech_ci,
  `Unit Protect ENA` text COLLATE utf8_czech_ci,
  `Pwr Protect ENA` text COLLATE utf8_czech_ci,
  `System Fault` text COLLATE utf8_czech_ci,
  `Fault SubCode` text COLLATE utf8_czech_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_czech_ci;

-- --------------------------------------------------------

--
-- Table structure for table `pv_battery_data_misc_battery`
--

CREATE TABLE `pv_battery_data_misc_battery` (
  `parent_uuid` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8_czech_ci NOT NULL,
  `Battery` double NOT NULL,
  `Volt` double DEFAULT NULL,
  `Tempr` double DEFAULT NULL,
  `Volt. State` text CHARACTER SET utf8mb3 COLLATE utf8_czech_ci,
  `Temp. State` text CHARACTER SET utf8mb3 COLLATE utf8_czech_ci,
  `Coulomb(%)` double DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_czech_ci;

-- --------------------------------------------------------

--
-- Table structure for table `pv_battery_data_misc_unit`
--

CREATE TABLE `pv_battery_data_misc_unit` (
  `parent_uuid` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8_czech_ci NOT NULL,
  `Unit` double NOT NULL,
  `Volt` double DEFAULT NULL,
  `Tempr` double DEFAULT NULL,
  `BTLow` double DEFAULT NULL,
  `BTHigh` double DEFAULT NULL,
  `BVLow` double DEFAULT NULL,
  `BVHigh` double DEFAULT NULL,
  `Volt. State` text CHARACTER SET utf8mb3 COLLATE utf8_czech_ci,
  `Temp. State` text CHARACTER SET utf8mb3 COLLATE utf8_czech_ci,
  `Coulomb(%)` double DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_czech_ci;

-- --------------------------------------------------------

--
-- Table structure for table `pv_battery_log`
--

CREATE TABLE `pv_battery_log` (
  `log_date` datetime NOT NULL,
  `uuid` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8_czech_ci NOT NULL,
  `Index` double NOT NULL,
  `Time` datetime NOT NULL,
  `ModID` text COLLATE utf8_czech_ci NOT NULL,
  `Code` text COLLATE utf8_czech_ci NOT NULL,
  `Info` text COLLATE utf8_czech_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_czech_ci;

-- --------------------------------------------------------

--
-- Table structure for table `pv_battery_soh`
--

CREATE TABLE `pv_battery_soh` (
  `log_date` datetime NOT NULL,
  `uuid` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8_czech_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_czech_ci;

-- --------------------------------------------------------

--
-- Table structure for table `pv_battery_soh_battery`
--

CREATE TABLE `pv_battery_soh_battery` (
  `parent_uuid` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8_czech_ci NOT NULL,
  `Battery` double NOT NULL,
  `Voltage` double DEFAULT NULL,
  `SOHCount` double DEFAULT NULL,
  `SOHStatus` text CHARACTER SET utf8mb3 COLLATE utf8_czech_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_czech_ci;

-- --------------------------------------------------------

--
-- Table structure for table `pv_battery_stat`
--

CREATE TABLE `pv_battery_stat` (
  `log_date` datetime NOT NULL,
  `EvenData Items` double DEFAULT NULL,
  `HistData Items` double DEFAULT NULL,
  `MiscData Items` double DEFAULT NULL,
  `Charge Cnt.` double DEFAULT NULL,
  `Discharge Cnt.` double DEFAULT NULL,
  `Charge Times` double DEFAULT NULL,
  `Status Cnt.` double DEFAULT NULL,
  `Idle Times` double DEFAULT NULL,
  `COC Times` double DEFAULT NULL,
  `DOC Times` double DEFAULT NULL,
  `COCA Times` double DEFAULT NULL,
  `DOCA Times` double DEFAULT NULL,
  `SC Times` double DEFAULT NULL,
  `Bat OV Times` double DEFAULT NULL,
  `Bat HV Times` double DEFAULT NULL,
  `Bat LV Times` double DEFAULT NULL,
  `Bat UV Times` double DEFAULT NULL,
  `Bat SHUT Times` double DEFAULT NULL,
  `Pwr OV Times` double DEFAULT NULL,
  `Pwr HV Times` double DEFAULT NULL,
  `Pwr LV Times` double DEFAULT NULL,
  `Pwr UV Times` double DEFAULT NULL,
  `Pwr SHUT Times` double DEFAULT NULL,
  `Bat OT Times` double DEFAULT NULL,
  `Bat UT Times` double DEFAULT NULL,
  `Bat HT Times` double DEFAULT NULL,
  `Bat LT Times` double DEFAULT NULL,
  `Board OT Times` double DEFAULT NULL,
  `Board UT Times` double DEFAULT NULL,
  `Board HT Times` double DEFAULT NULL,
  `Board LT Times` double DEFAULT NULL,
  `Shut Times` double DEFAULT NULL,
  `Reset Times` double DEFAULT NULL,
  `RV Times` double DEFAULT NULL,
  `Input OV Times` double DEFAULT NULL,
  `SOH Times` double DEFAULT NULL,
  `BMICERR Times` double DEFAULT NULL,
  `CYCLE Times` double DEFAULT NULL,
  `Pwr Percent` double DEFAULT NULL,
  `Pwr Coulomb(mAS)` double DEFAULT NULL,
  `Pwr PercentWatt` double DEFAULT NULL,
  `Bat CoulWatt(uWH)` double DEFAULT NULL,
  `Dsg Cap(mAH)` double DEFAULT NULL,
  `SOH Percent` double DEFAULT NULL,
  `His.Chg Cap(WH)` double DEFAULT NULL,
  `His.Chg Capl(mWH)` double DEFAULT NULL,
  `His.Dsg Cap(WH)` double DEFAULT NULL,
  `His.Dsg Capl(mWH)` double DEFAULT NULL,
  `Day Chg Cap(WH)` double DEFAULT NULL,
  `Day Chg Capl(mWH)` double DEFAULT NULL,
  `Day Dsg Cap(WH)` double DEFAULT NULL,
  `Day Dsg Capl(mWH)` double DEFAULT NULL,
  `Min.Chg Cap(WH)` double DEFAULT NULL,
  `Min.Dsg Cap(WH)` double DEFAULT NULL,
  `HTChgDsg Secs` double DEFAULT NULL,
  `LTChg Secs` double DEFAULT NULL,
  `LTDsg Secs` double DEFAULT NULL,
  `HT Secs` double DEFAULT NULL,
  `LT Secs` double DEFAULT NULL,
  `HV1 Secs` double DEFAULT NULL,
  `HV2 Secs` double DEFAULT NULL,
  `LV Secs` double DEFAULT NULL,
  `ChgCurr 0~0.2C Secs` double DEFAULT NULL,
  `ChgCurr 0.2C~0.5C Secs` double DEFAULT NULL,
  `ChgCurr 0.5C~0.8C Secs` double DEFAULT NULL,
  `ChgCurr 0.8C~1C Secs` double DEFAULT NULL,
  `ChgCurr 1C above Secs` double DEFAULT NULL,
  `DsgCurr 0~0.2C Secs` double DEFAULT NULL,
  `DsgCurr 0.2C~0.5C Secs` double DEFAULT NULL,
  `DsgCurr 0.5C~0.8C Secs` double DEFAULT NULL,
  `DsgCurr 0.8C~1C Secs` double DEFAULT NULL,
  `DsgCurr 1C above Secs` double DEFAULT NULL,
  `Soc 0~20% Secs` double DEFAULT NULL,
  `Soc 20~60% Secs` double DEFAULT NULL,
  `Soc 60% above Secs` double DEFAULT NULL,
  `LifeWarning Times` double DEFAULT NULL,
  `LifeAlarm Times` double DEFAULT NULL,
  `FlashFail Times` double DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_czech_ci;

-- --------------------------------------------------------

--
-- Table structure for table `pv_battery_state_record`
--

CREATE TABLE `pv_battery_state_record` (
  `log_date` datetime NOT NULL,
  `timestamp` datetime DEFAULT NULL,
  `soc` double DEFAULT NULL,
  `base_state_label` text CHARACTER SET utf8mb3 COLLATE utf8_czech_ci,
  `voltage_state_label` text CHARACTER SET utf8mb3 COLLATE utf8_czech_ci,
  `current_state_label` text CHARACTER SET utf8mb3 COLLATE utf8_czech_ci,
  `temperature_state_label` text CHARACTER SET utf8mb3 COLLATE utf8_czech_ci,
  `voltage` double DEFAULT NULL,
  `current` double DEFAULT NULL,
  `temperature` double DEFAULT NULL,
  `coulomb_ah` double DEFAULT NULL,
  `coulomb_percent` double DEFAULT NULL,
  `coulomb_kwh` double DEFAULT NULL,
  `cell_voltage_state_label` text CHARACTER SET utf8mb3 COLLATE utf8_czech_ci,
  `cell_temperature_state_label` text CHARACTER SET utf8mb3 COLLATE utf8_czech_ci,
  `min_cell_voltage` double DEFAULT NULL,
  `max_cell_voltage` double DEFAULT NULL,
  `min_cell_temperature` double DEFAULT NULL,
  `max_cell_temperature` double DEFAULT NULL,
  `avg_cell_temperature` double DEFAULT NULL,
  `unit_voltage_state_label` text CHARACTER SET utf8mb3 COLLATE utf8_czech_ci,
  `unit_temperature_state_label` text CHARACTER SET utf8mb3 COLLATE utf8_czech_ci,
  `min_unit_voltage` double DEFAULT NULL,
  `max_unit_voltage` double DEFAULT NULL,
  `min_unit_temperature` double DEFAULT NULL,
  `max_unit_temperature` double DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_czech_ci;

-- --------------------------------------------------------

--
-- Table structure for table `pv_battery_sysinfo`
--

CREATE TABLE `pv_battery_sysinfo` (
  `log_date` datetime NOT NULL,
  `Chg Sug Volt` double DEFAULT NULL,
  `Chg Cut Volt` double DEFAULT NULL,
  `Dsg Cut Volt` double DEFAULT NULL,
  `Max Chg Curr` double DEFAULT NULL,
  `Max Dsg Curr` double DEFAULT NULL,
  `Bal Chg Req` text COLLATE utf8_czech_ci,
  `Force Chg Req` text COLLATE utf8_czech_ci,
  `Vol High 4` double DEFAULT NULL,
  `Vol High 4R` double DEFAULT NULL,
  `Vol High 3` double DEFAULT NULL,
  `Vol High 3R` double DEFAULT NULL,
  `Vol High 2` double DEFAULT NULL,
  `Vol High 2R` double DEFAULT NULL,
  `Vol High 1` double DEFAULT NULL,
  `Vol High 1R` double DEFAULT NULL,
  `Vol Low  1` double DEFAULT NULL,
  `Vol Low  1R` double DEFAULT NULL,
  `Vol Low  2` double DEFAULT NULL,
  `Vol Low  2R` double DEFAULT NULL,
  `Temp High 2` double DEFAULT NULL,
  `Temp High 2R` double DEFAULT NULL,
  `Temp High 1` double DEFAULT NULL,
  `Temp High 1R` double DEFAULT NULL,
  `Temp Nor High 1` double DEFAULT NULL,
  `Temp Nor High 1R` double DEFAULT NULL,
  `Temp Nor Low 1` double DEFAULT NULL,
  `Temp Nor Low 1R` double DEFAULT NULL,
  `Temp Low 1` double DEFAULT NULL,
  `Temp Low 1R` double DEFAULT NULL,
  `Temp Low 2` double DEFAULT NULL,
  `Temp Low 2R` double DEFAULT NULL,
  `Temp Low 3` double DEFAULT NULL,
  `Temp Low 3R` double DEFAULT NULL,
  `Bal High 5` double DEFAULT NULL,
  `Bal High 5R` double DEFAULT NULL,
  `Bal High 4` double DEFAULT NULL,
  `Bal High 4R` double DEFAULT NULL,
  `Bal High 3` double DEFAULT NULL,
  `Bal High 3R` double DEFAULT NULL,
  `Bal High 2` double DEFAULT NULL,
  `Bal High 2R` double DEFAULT NULL,
  `Bal High 1` double DEFAULT NULL,
  `Bal High 1R` double DEFAULT NULL,
  `FChgV` double DEFAULT NULL,
  `FChgVR` double DEFAULT NULL,
  `FChgS` double DEFAULT NULL,
  `FChgSR` double DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_czech_ci;

-- --------------------------------------------------------

--
-- Table structure for table `pv_daily_stats`
--

CREATE TABLE `pv_daily_stats` (
  `log_date` date NOT NULL,
  `imported` double DEFAULT NULL,
  `exported` double DEFAULT NULL,
  `pv` double DEFAULT NULL,
  `pv1` double DEFAULT NULL,
  `pv2` double DEFAULT NULL,
  `consumption` double DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_czech_ci;

-- --------------------------------------------------------

--
-- Table structure for table `pv_forecast`
--

CREATE TABLE `pv_forecast` (
  `request_date` datetime NOT NULL,
  `forecast_from_date` datetime NOT NULL,
  `forecast_to_date` datetime NOT NULL,
  `pv_rooftop_id` int UNSIGNED NOT NULL,
  `kilowatts` double NOT NULL,
  `kilowatts_min` double NOT NULL,
  `kilowatts_max` double NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_czech_ci;

-- --------------------------------------------------------

--
-- Table structure for table `pv_inverter_battery_soc_prediction`
--

CREATE TABLE `pv_inverter_battery_soc_prediction` (
  `log_date` datetime NOT NULL,
  `soc` double NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_czech_ci;

-- --------------------------------------------------------

--
-- Table structure for table `pv_inverter_record`
--

CREATE TABLE `pv_inverter_record` (
  `log_date` datetime NOT NULL,
  `timestamp` datetime DEFAULT NULL COMMENT 'Timestamp',
  `load_mode1` int DEFAULT NULL COMMENT 'Load Mode L1',
  `load_mode2` int DEFAULT NULL COMMENT 'Load Mode L2',
  `load_mode3` int DEFAULT NULL COMMENT 'Load Mode L3',
  `temperature_air` double DEFAULT NULL COMMENT 'Inverter Temperature (Air)) (C)',
  `temperature_module` double DEFAULT NULL COMMENT 'Inverter Temperature (Module) (C)',
  `temperature` double DEFAULT NULL COMMENT 'Inverter Temperature (Radiator) (C)',
  `function_bit` int DEFAULT NULL COMMENT 'Function Bit',
  `bus_voltage` double DEFAULT NULL COMMENT 'Bus Voltage (V)',
  `nbus_voltage` double DEFAULT NULL COMMENT 'NBus Voltage (V)',
  `warning_code` int DEFAULT NULL COMMENT 'Warning code',
  `safety_country` int DEFAULT NULL COMMENT 'Safety Country code',
  `safety_country_label` text CHARACTER SET utf8mb3 COLLATE utf8_czech_ci COMMENT 'Safety Country',
  `work_mode` int DEFAULT NULL COMMENT 'Work Mode code',
  `work_mode_label` text CHARACTER SET utf8mb3 COLLATE utf8_czech_ci COMMENT 'Work Mode',
  `operation_mode` int DEFAULT NULL COMMENT 'Operation Mode code',
  `error_codes` int DEFAULT NULL COMMENT 'Error Codes',
  `errors` text CHARACTER SET utf8mb3 COLLATE utf8_czech_ci COMMENT 'Errors',
  `diagnose_result` int DEFAULT NULL COMMENT 'Diag Status Code',
  `diagnose_result_label` text CHARACTER SET utf8mb3 COLLATE utf8_czech_ci COMMENT 'Diag Status',
  `commode` int DEFAULT NULL COMMENT 'Commode',
  `rssi` int DEFAULT NULL COMMENT 'RSSI',
  `manufacture_code` int DEFAULT NULL COMMENT 'Manufacture Code',
  `meter_test_status` int DEFAULT NULL COMMENT 'Meter Test Status',
  `meter_comm_status` int DEFAULT NULL COMMENT 'Meter Communication Status',
  `ac_vgrid1` double DEFAULT NULL COMMENT 'On-grid L1 Voltage (V)',
  `ac_igrid1` double DEFAULT NULL COMMENT 'On-grid L1 Current (A)',
  `ac_fgrid1` double DEFAULT NULL COMMENT 'On-grid L1 Frequency (Hz)',
  `ac_pgrid1` double DEFAULT NULL COMMENT 'On-grid L1 Power (W)',
  `ac_vgrid2` double DEFAULT NULL COMMENT 'On-grid L2 Voltage (V)',
  `ac_igrid2` double DEFAULT NULL COMMENT 'On-grid L2 Current (A)',
  `ac_fgrid2` double DEFAULT NULL COMMENT 'On-grid L2 Frequency (Hz)',
  `ac_pgrid2` double DEFAULT NULL COMMENT 'On-grid L2 Power (W)',
  `ac_vgrid3` double DEFAULT NULL COMMENT 'On-grid L3 Voltage (V)',
  `ac_igrid3` double DEFAULT NULL COMMENT 'On-grid L3 Current (A)',
  `ac_fgrid3` double DEFAULT NULL COMMENT 'On-grid L3 Frequency (Hz)',
  `ac_pgrid3` double DEFAULT NULL COMMENT 'On-grid L3 Power (W)',
  `ac_total_inverter_power` double DEFAULT NULL COMMENT 'Total Power (W)',
  `ac_load_p1` double DEFAULT NULL COMMENT 'Load L1 (W)',
  `ac_load_p2` double DEFAULT NULL COMMENT 'Load L2 (W)',
  `ac_load_p3` double DEFAULT NULL COMMENT 'Load L3 (W)',
  `ac_load_ptotal` double DEFAULT NULL COMMENT 'Load (W)',
  `ac_e_total_exp` double DEFAULT NULL COMMENT 'Total Energy (export) (kWh)',
  `ac_e_day_exp` double DEFAULT NULL COMMENT 'Today Energy (export) (kWh)',
  `ac_e_total_imp` double DEFAULT NULL COMMENT 'Total Energy (import) (kWh)',
  `ac_e_day_imp` double DEFAULT NULL COMMENT 'Today Energy (import) (kWh)',
  `ac_e_load_total` double DEFAULT NULL COMMENT 'Total Load (kWh)',
  `ac_e_load_day` double DEFAULT NULL COMMENT 'Today Load (kWh)',
  `ac_house_consumption` int DEFAULT NULL COMMENT 'House Consumption (W)',
  `backup_v1` double DEFAULT NULL COMMENT 'Back-up L1 Voltage (V)',
  `backup_i1` double DEFAULT NULL COMMENT 'Back-up L1 Current (A)',
  `backup_f1` double DEFAULT NULL COMMENT 'Back-up L1 Frequency (Hz)',
  `backup_p1` double DEFAULT NULL COMMENT 'Back-up L1 Power (W)',
  `backup_v2` double DEFAULT NULL COMMENT 'Back-up L2 Voltage (V)',
  `backup_i2` double DEFAULT NULL COMMENT 'Back-up L2 Current (A)',
  `backup_f2` double DEFAULT NULL COMMENT 'Back-up L2 Frequency (Hz)',
  `backup_p2` double DEFAULT NULL COMMENT 'Back-up L2 Power (W)',
  `backup_v3` double DEFAULT NULL COMMENT 'Back-up L3 Voltage (V)',
  `backup_i3` double DEFAULT NULL COMMENT 'Back-up L3 Current (A)',
  `backup_f3` double DEFAULT NULL COMMENT 'Back-up L3 Frequency (Hz)',
  `backup_p3` double DEFAULT NULL COMMENT 'Back-up L3 Power (W)',
  `backup_ptotal` double DEFAULT NULL COMMENT 'Back-up Load (W)',
  `backup_ups_load` int DEFAULT NULL COMMENT 'Ups Load (%)',
  `battery_vbattery1` double DEFAULT NULL COMMENT 'Battery Voltage (V)',
  `battery_ibattery1` double DEFAULT NULL COMMENT 'Battery Current (A)',
  `battery_pbattery1` int DEFAULT NULL COMMENT 'Battery Power (W)',
  `battery_mode` int DEFAULT NULL COMMENT 'Battery Mode code',
  `battery_mode_label` text CHARACTER SET utf8mb3 COLLATE utf8_czech_ci COMMENT 'Battery Mode',
  `battery_e_bat_charge_total` double DEFAULT NULL COMMENT 'Total Battery Charge (kWh)',
  `battery_e_bat_charge_day` double DEFAULT NULL COMMENT 'Today Battery Charge (kWh)',
  `battery_e_bat_discharge_total` double DEFAULT NULL COMMENT 'Total Battery Discharge (kWh)',
  `battery_e_bat_discharge_day` double DEFAULT NULL COMMENT 'Today Battery Discharge (kWh)',
  `battery_bms` int DEFAULT NULL COMMENT 'Battery BMS',
  `battery_index` int DEFAULT NULL COMMENT 'Battery Index',
  `battery_status` int DEFAULT NULL COMMENT 'Battery Status',
  `battery_temperature` double DEFAULT NULL COMMENT 'Battery Temperature (C)',
  `battery_charge_limit` int DEFAULT NULL COMMENT 'Battery Charge Limit (A)',
  `battery_discharge_limit` int DEFAULT NULL COMMENT 'Battery Discharge Limit (A)',
  `battery_error_l` int DEFAULT NULL COMMENT 'Battery Error L',
  `battery_soc` int DEFAULT NULL COMMENT 'Battery State of Charge (%)',
  `battery_soh` int DEFAULT NULL COMMENT 'Battery State of Health (%)',
  `battery_modules` int DEFAULT NULL COMMENT 'Battery Modules',
  `battery_warning_l` int DEFAULT NULL COMMENT 'Battery Warning L',
  `battery_protocol` int DEFAULT NULL COMMENT 'Battery Protocol',
  `battery_error_h` int DEFAULT NULL COMMENT 'Battery Error H',
  `battery_error` text CHARACTER SET utf8mb3 COLLATE utf8_czech_ci COMMENT 'Battery Error',
  `battery_warning_h` int DEFAULT NULL COMMENT 'Battery Warning H',
  `battery_warning` text CHARACTER SET utf8mb3 COLLATE utf8_czech_ci COMMENT 'Battery Error',
  `battery_sw_version` int DEFAULT NULL COMMENT 'Battery Software Version',
  `battery_hw_version` int DEFAULT NULL COMMENT 'Battery Hardware Version',
  `battery_max_cell_temp_id` int DEFAULT NULL COMMENT 'Battery Max Cell Temperature ID',
  `battery_min_cell_temp_id` int DEFAULT NULL COMMENT 'Battery Min Cell Temperature ID',
  `battery_max_cell_voltage_id` int DEFAULT NULL COMMENT 'Battery Max Cell Voltage ID',
  `battery_min_cell_voltage_id` int DEFAULT NULL COMMENT 'Battery Min Cell Voltage ID',
  `battery_max_cell_temp` double DEFAULT NULL COMMENT 'Battery Max Cell Temperature (C)',
  `battery_min_cell_temp` double DEFAULT NULL COMMENT 'Battery Min Cell Temperature (C)',
  `battery_max_cell_voltage` double DEFAULT NULL COMMENT 'Battery Max Cell Voltage (V)',
  `battery_min_cell_voltage` double DEFAULT NULL COMMENT 'Battery Min Cell Voltage (V)',
  `grid_mode` int DEFAULT NULL COMMENT 'Grid Mode code',
  `grid_mode_label` text CHARACTER SET utf8mb3 COLLATE utf8_czech_ci COMMENT 'Grid Mode',
  `grid_active_power` double DEFAULT NULL COMMENT 'Active Power (W)',
  `grid_in_out` int DEFAULT NULL COMMENT 'On-grid Mode code',
  `grid_in_out_label` text CHARACTER SET utf8mb3 COLLATE utf8_czech_ci COMMENT 'On-grid Mode',
  `grid_reactive_power` int DEFAULT NULL COMMENT 'Reactive Power (var)',
  `grid_apparent_power` int DEFAULT NULL COMMENT 'Apparent Power (VA)',
  `grid_active_power1` double DEFAULT NULL COMMENT 'Active Power L1 (W)',
  `grid_active_power2` double DEFAULT NULL COMMENT 'Active Power L2 (W)',
  `grid_active_power3` double DEFAULT NULL COMMENT 'Active Power L3 (W)',
  `grid_active_power_total` int DEFAULT NULL COMMENT 'Active Power Total (W)',
  `grid_reactive_power_total` int DEFAULT NULL COMMENT 'Reactive Power Total (var)',
  `grid_meter_power_factor1` double DEFAULT NULL COMMENT 'Meter Power Factor L1',
  `grid_meter_power_factor2` double DEFAULT NULL COMMENT 'Meter Power Factor L2',
  `grid_meter_power_factor3` double DEFAULT NULL COMMENT 'Meter Power Factor L3',
  `grid_meter_power_factor` double DEFAULT NULL COMMENT 'Meter Power Factor',
  `grid_meter_freq` double DEFAULT NULL COMMENT 'Meter Frequency (Hz)',
  `grid_meter_e_total_exp` double DEFAULT NULL COMMENT 'Meter Total Energy (export) (kWh)',
  `grid_meter_e_total_imp` double DEFAULT NULL COMMENT 'Meter Total Energy (import) (kWh)',
  `grid_meter_active_power1` int DEFAULT NULL COMMENT 'Meter Active Power L1 (W)',
  `grid_meter_active_power2` int DEFAULT NULL COMMENT 'Meter Active Power L2 (W)',
  `grid_meter_active_power3` int DEFAULT NULL COMMENT 'Meter Active Power L3 (W)',
  `grid_meter_active_power_total` int DEFAULT NULL COMMENT 'Meter Active Power Total (W)',
  `grid_meter_reactive_power1` int DEFAULT NULL COMMENT 'Meter Reactive Power L1 (var)',
  `grid_meter_reactive_power2` int DEFAULT NULL COMMENT 'Meter Reactive Power L2 (var)',
  `grid_meter_reactive_power3` int DEFAULT NULL COMMENT 'Meter Reactive Power L2 (var)',
  `grid_meter_reactive_power_total` int DEFAULT NULL COMMENT 'Meter Reactive Power Total (var)',
  `grid_meter_apparent_power1` int DEFAULT NULL COMMENT 'Meter Apparent Power L1 (VA)',
  `grid_meter_apparent_power2` int DEFAULT NULL COMMENT 'Meter Apparent Power L2 (VA)',
  `grid_meter_apparent_power3` int DEFAULT NULL COMMENT 'Meter Apparent Power L3 (VA)',
  `grid_meter_apparent_power_total` int DEFAULT NULL COMMENT 'Meter Apparent Power Total (VA)',
  `grid_meter_type` int DEFAULT NULL COMMENT 'Meter Type',
  `grid_meter_sw_version` int DEFAULT NULL COMMENT 'Meter Software Version',
  `pv_vpv1` double DEFAULT NULL COMMENT 'PV1 Voltage (V)',
  `pv_ipv1` double DEFAULT NULL COMMENT 'PV1 Current (A)',
  `pv_ppv1` double DEFAULT NULL COMMENT 'PV1 Power (W)',
  `pv_vpv2` double DEFAULT NULL COMMENT 'PV2 Voltage (V)',
  `pv_ipv2` double DEFAULT NULL COMMENT 'PV2 Current (A)',
  `pv_ppv2` double DEFAULT NULL COMMENT 'PV2 Power (W)',
  `pv_ppv` int DEFAULT NULL COMMENT 'PV Power (W)',
  `pv2_mode` int DEFAULT NULL COMMENT 'PV2 Mode code',
  `pv2_mode_label` text CHARACTER SET utf8mb3 COLLATE utf8_czech_ci COMMENT 'PV2 Mode',
  `pv1_mode` int DEFAULT NULL COMMENT 'PV1 Mode code',
  `pv1_mode_label` text CHARACTER SET utf8mb3 COLLATE utf8_czech_ci COMMENT 'PV1 Mode',
  `pv_e_total` double DEFAULT NULL COMMENT 'Total PV Generation (kWh)',
  `pv_e_day` double DEFAULT NULL COMMENT 'Today''s PV Generation (kWh)',
  `pv_h_total` int DEFAULT NULL COMMENT 'Hours Total (h)'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_czech_ci;

-- --------------------------------------------------------

--
-- Table structure for table `pv_rooftop`
--

CREATE TABLE `pv_rooftop` (
  `id` int UNSIGNED NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8_czech_ci NOT NULL,
  `power` double NOT NULL,
  `solcast_rooftop_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8_czech_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_czech_ci;

-- --------------------------------------------------------

--
-- Table structure for table `pv_rooftop_history`
--

CREATE TABLE `pv_rooftop_history` (
  `pv_rooftop_id` int NOT NULL,
  `from_date` datetime NOT NULL,
  `to_date` datetime NOT NULL,
  `power` double NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_czech_ci;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `pv_battery_bat`
--
ALTER TABLE `pv_battery_bat`
  ADD PRIMARY KEY (`log_date`),
  ADD UNIQUE KEY `uuid` (`uuid`);

--
-- Indexes for table `pv_battery_bat_battery`
--
ALTER TABLE `pv_battery_bat_battery`
  ADD PRIMARY KEY (`parent_uuid`,`Bat`);

--
-- Indexes for table `pv_battery_data_event`
--
ALTER TABLE `pv_battery_data_event`
  ADD PRIMARY KEY (`uuid`);

--
-- Indexes for table `pv_battery_data_event_battery`
--
ALTER TABLE `pv_battery_data_event_battery`
  ADD PRIMARY KEY (`parent_uuid`,`Battery`);

--
-- Indexes for table `pv_battery_data_event_unit`
--
ALTER TABLE `pv_battery_data_event_unit`
  ADD PRIMARY KEY (`parent_uuid`,`Unit`);

--
-- Indexes for table `pv_battery_data_history`
--
ALTER TABLE `pv_battery_data_history`
  ADD PRIMARY KEY (`uuid`);

--
-- Indexes for table `pv_battery_data_history_battery`
--
ALTER TABLE `pv_battery_data_history_battery`
  ADD PRIMARY KEY (`parent_uuid`,`Battery`);

--
-- Indexes for table `pv_battery_data_history_unit`
--
ALTER TABLE `pv_battery_data_history_unit`
  ADD PRIMARY KEY (`parent_uuid`,`Unit`);

--
-- Indexes for table `pv_battery_data_misc`
--
ALTER TABLE `pv_battery_data_misc`
  ADD PRIMARY KEY (`uuid`);

--
-- Indexes for table `pv_battery_data_misc_battery`
--
ALTER TABLE `pv_battery_data_misc_battery`
  ADD PRIMARY KEY (`parent_uuid`,`Battery`);

--
-- Indexes for table `pv_battery_data_misc_unit`
--
ALTER TABLE `pv_battery_data_misc_unit`
  ADD PRIMARY KEY (`parent_uuid`,`Unit`);

--
-- Indexes for table `pv_battery_log`
--
ALTER TABLE `pv_battery_log`
  ADD PRIMARY KEY (`uuid`);

--
-- Indexes for table `pv_battery_soh`
--
ALTER TABLE `pv_battery_soh`
  ADD PRIMARY KEY (`log_date`),
  ADD UNIQUE KEY `uuid` (`uuid`);

--
-- Indexes for table `pv_battery_soh_battery`
--
ALTER TABLE `pv_battery_soh_battery`
  ADD PRIMARY KEY (`parent_uuid`,`Battery`);

--
-- Indexes for table `pv_battery_stat`
--
ALTER TABLE `pv_battery_stat`
  ADD PRIMARY KEY (`log_date`);

--
-- Indexes for table `pv_battery_state_record`
--
ALTER TABLE `pv_battery_state_record`
  ADD PRIMARY KEY (`log_date`);

--
-- Indexes for table `pv_battery_sysinfo`
--
ALTER TABLE `pv_battery_sysinfo`
  ADD PRIMARY KEY (`log_date`);

--
-- Indexes for table `pv_daily_stats`
--
ALTER TABLE `pv_daily_stats`
  ADD PRIMARY KEY (`log_date`);

--
-- Indexes for table `pv_forecast`
--
ALTER TABLE `pv_forecast`
  ADD PRIMARY KEY (`request_date`,`forecast_from_date`,`forecast_to_date`,`pv_rooftop_id`),
  ADD KEY `forecast_date` (`forecast_from_date`),
  ADD KEY `pv_rooftop_id` (`pv_rooftop_id`);

--
-- Indexes for table `pv_inverter_battery_soc_prediction`
--
ALTER TABLE `pv_inverter_battery_soc_prediction`
  ADD PRIMARY KEY (`log_date`);

--
-- Indexes for table `pv_inverter_record`
--
ALTER TABLE `pv_inverter_record`
  ADD PRIMARY KEY (`log_date`);

--
-- Indexes for table `pv_rooftop`
--
ALTER TABLE `pv_rooftop`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `pv_rooftop_history`
--
ALTER TABLE `pv_rooftop_history`
  ADD PRIMARY KEY (`pv_rooftop_id`,`from_date`,`to_date`) USING BTREE;

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `pv_rooftop`
--
ALTER TABLE `pv_rooftop`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `pv_forecast`
--
ALTER TABLE `pv_forecast`
  ADD CONSTRAINT `pv_forecast_ibfk_1` FOREIGN KEY (`pv_rooftop_id`) REFERENCES `pv_rooftop` (`id`);
COMMIT;