-- MySQL dump 10.13  Distrib 8.0.22, for Win64 (x86_64)
--
-- Host: localhost    Database: sles_db
-- ------------------------------------------------------
-- Server version	8.0.22

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!50503 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `connected_energy_behind_meter_battery`
--

DROP TABLE IF EXISTS `connected_energy_behind_meter_battery`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `connected_energy_behind_meter_battery` (
  `connected_energy_behind_meter_battery_id` int NOT NULL AUTO_INCREMENT,
  `output_rating` float NOT NULL,
  `input_rating` float NOT NULL,
  `storage_capacity` float NOT NULL,
  `auxiliary_electrical_power_demand` float NOT NULL,
  `input_output_efficiency` decimal(5,4) NOT NULL,
  `charging_power_ramp_rate` float NOT NULL,
  `discharging_power_ramp_rate` float NOT NULL,
  `operational_limitation` float NOT NULL,
  `cycles_to_eol` int NOT NULL,
  `unit_cost` float NOT NULL,
  `power_cost` float NOT NULL,
  `energy_cost` float NOT NULL,
  `planning_limitation` text NOT NULL,
  `end_users_quantity` int NOT NULL,
  `end_users_type` varchar(255) NOT NULL,
  `description` text NOT NULL,
  PRIMARY KEY (`connected_energy_behind_meter_battery_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `connected_energy_behind_meter_battery`
--

LOCK TABLES `connected_energy_behind_meter_battery` WRITE;
/*!40000 ALTER TABLE `connected_energy_behind_meter_battery` DISABLE KEYS */;
/*!40000 ALTER TABLE `connected_energy_behind_meter_battery` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `connected_energy_behind_meter_battery_measurement`
--

DROP TABLE IF EXISTS `connected_energy_behind_meter_battery_measurement`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `connected_energy_behind_meter_battery_measurement` (
  `connected_energy_behind_meter_battery_measurement_id` int NOT NULL AUTO_INCREMENT,
  `connected_energy_behind_meter_battery_id` int NOT NULL,
  `customer` varchar(255) NOT NULL,
  `location` varchar(255) NOT NULL,
  `description` varchar(255) NOT NULL,
  `start_date` datetime NOT NULL,
  `end_date` datetime NOT NULL,
  `pv_power_output` float NOT NULL,
  `storage_level` float NOT NULL,
  `service_trigger` float NOT NULL,
  `validity` enum('Y','N') NOT NULL,
  PRIMARY KEY (`connected_energy_behind_meter_battery_measurement_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `connected_energy_behind_meter_battery_measurement`
--

LOCK TABLES `connected_energy_behind_meter_battery_measurement` WRITE;
/*!40000 ALTER TABLE `connected_energy_behind_meter_battery_measurement` DISABLE KEYS */;
/*!40000 ALTER TABLE `connected_energy_behind_meter_battery_measurement` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `connected_energy_behind_meter_battery_modelling`
--

DROP TABLE IF EXISTS `connected_energy_behind_meter_battery_modelling`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `connected_energy_behind_meter_battery_modelling` (
  `connected_energy_behind_meter_battery_modelling_id` int NOT NULL AUTO_INCREMENT,
  `connected_energy_behind_meter_battery_id` int NOT NULL,
  `customer` varchar(255) NOT NULL,
  `location` varchar(255) NOT NULL,
  `description` varchar(255) NOT NULL,
  `start_date` datetime NOT NULL,
  `end_date` datetime NOT NULL,
  `pv_power_output` float NOT NULL,
  `storage_level` float NOT NULL,
  `service_trigger` float NOT NULL,
  `validity` enum('Y','N') NOT NULL,
  PRIMARY KEY (`connected_energy_behind_meter_battery_modelling_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `connected_energy_behind_meter_battery_modelling`
--

LOCK TABLES `connected_energy_behind_meter_battery_modelling` WRITE;
/*!40000 ALTER TABLE `connected_energy_behind_meter_battery_modelling` DISABLE KEYS */;
/*!40000 ALTER TABLE `connected_energy_behind_meter_battery_modelling` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `connected_energy_front_meter_battery`
--

DROP TABLE IF EXISTS `connected_energy_front_meter_battery`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `connected_energy_front_meter_battery` (
  `connected_energy_front_meter_battery_id` int NOT NULL AUTO_INCREMENT,
  `output_rating` float NOT NULL,
  `input_rating` float NOT NULL,
  `storage_capacity` float NOT NULL,
  `auxiliary_electrical_power_demand` float NOT NULL,
  `input_output_efficiency` decimal(5,4) NOT NULL,
  `charging_power_ramp_rate` float NOT NULL,
  `discharging_power_ramp_rate` float NOT NULL,
  `operational_limitation` float NOT NULL,
  `cycles_to_eol` int NOT NULL,
  `unit_cost` float NOT NULL,
  `power_cost` float NOT NULL,
  `energy_cost` float NOT NULL,
  `planning_limitation` text NOT NULL,
  `end_users_quantity` int NOT NULL,
  `end_users_type` varchar(255) NOT NULL,
  `description` text NOT NULL,
  PRIMARY KEY (`connected_energy_front_meter_battery_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `connected_energy_front_meter_battery`
--

LOCK TABLES `connected_energy_front_meter_battery` WRITE;
/*!40000 ALTER TABLE `connected_energy_front_meter_battery` DISABLE KEYS */;
/*!40000 ALTER TABLE `connected_energy_front_meter_battery` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `connected_energy_front_meter_battery_measurement`
--

DROP TABLE IF EXISTS `connected_energy_front_meter_battery_measurement`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `connected_energy_front_meter_battery_measurement` (
  `connected_energy_front_meter_battery_measurement_id` int NOT NULL AUTO_INCREMENT,
  `connected_energy_front_meter_battery_id` int NOT NULL,
  `customer` varchar(255) NOT NULL,
  `location` varchar(255) NOT NULL,
  `description` varchar(255) NOT NULL,
  `start_date` datetime NOT NULL,
  `end_date` datetime NOT NULL,
  `pv_power_output` float NOT NULL,
  `storage_level` float NOT NULL,
  `service_trigger` float NOT NULL,
  `validity` enum('Y','N') NOT NULL,
  PRIMARY KEY (`connected_energy_front_meter_battery_measurement_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `connected_energy_front_meter_battery_measurement`
--

LOCK TABLES `connected_energy_front_meter_battery_measurement` WRITE;
/*!40000 ALTER TABLE `connected_energy_front_meter_battery_measurement` DISABLE KEYS */;
/*!40000 ALTER TABLE `connected_energy_front_meter_battery_measurement` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `connected_energy_sloar_carport`
--

DROP TABLE IF EXISTS `connected_energy_sloar_carport`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `connected_energy_sloar_carport` (
  `connected_energy_sloar_carport_id` int NOT NULL AUTO_INCREMENT,
  `pv_nominal_output_rating` float NOT NULL,
  `battery_output_rating` float NOT NULL,
  `battery_input_rating` float NOT NULL,
  `battery_storage_capacity` float NOT NULL,
  `auxiliary_electrical_power_demand` float NOT NULL,
  `ev_fast_charger_output_rating` float NOT NULL,
  `ev_fast_charger_auxiliary_electrical_power_demand` float NOT NULL,
  `ev_rapid_charger_output_system` float NOT NULL,
  `ev_rapid_charger_auxiliary_electrical_power_demand` float NOT NULL,
  `ev_charger_power_flow` varchar(255) NOT NULL,
  `pv_panel_size` decimal(5,4) NOT NULL,
  `ratio_of_radiance_to_output_power` decimal(5,4) NOT NULL,
  `battery_input_output_efficiency` decimal(5,4) NOT NULL,
  `ev_fast_charger_input_power_to_car_battery_efficiency` decimal(5,4) NOT NULL,
  `ev_rapid_charger_input_power_battery_efficiency` decimal(5,4) NOT NULL,
  `time_to_change_from_grid_electricity_to_battery_for_ev_charging` float NOT NULL,
  `operational_limitation` varchar(255) NOT NULL,
  `cycles_to_eol` int NOT NULL,
  `charger_mean_time_between_failures` int NOT NULL,
  `charger_mean_down_time` int NOT NULL,
  `pv_system_cost_` float NOT NULL,
  `battery_system_cost_` float NOT NULL,
  `fast_charger_system_cost` float NOT NULL,
  `rapid_charger_system_cost` float NOT NULL,
  `planning_limitation` varchar(255) NOT NULL,
  `description` text NOT NULL,
  PRIMARY KEY (`connected_energy_sloar_carport_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `connected_energy_sloar_carport`
--

LOCK TABLES `connected_energy_sloar_carport` WRITE;
/*!40000 ALTER TABLE `connected_energy_sloar_carport` DISABLE KEYS */;
/*!40000 ALTER TABLE `connected_energy_sloar_carport` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `connected_energy_sloar_carport_measurement`
--

DROP TABLE IF EXISTS `connected_energy_sloar_carport_measurement`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `connected_energy_sloar_carport_measurement` (
  `connected_energy_sloar_carport_measurement_id` int NOT NULL AUTO_INCREMENT,
  `connected_energy_sloar_carport_id` int NOT NULL,
  `customer` varchar(255) NOT NULL,
  `location` varchar(255) NOT NULL,
  `description` varchar(255) NOT NULL,
  `start_date` datetime NOT NULL,
  `end_date` datetime NOT NULL,
  `ev_power_input` float NOT NULL,
  `pv_power_output` float NOT NULL,
  `bess_power_output_input` float NOT NULL,
  `bess_storage_level` float NOT NULL,
  `service_trigger` datetime NOT NULL,
  `validity` enum('Y','N') NOT NULL,
  PRIMARY KEY (`connected_energy_sloar_carport_measurement_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `connected_energy_sloar_carport_measurement`
--

LOCK TABLES `connected_energy_sloar_carport_measurement` WRITE;
/*!40000 ALTER TABLE `connected_energy_sloar_carport_measurement` DISABLE KEYS */;
/*!40000 ALTER TABLE `connected_energy_sloar_carport_measurement` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `connected_energy_sloar_carport_modelling`
--

DROP TABLE IF EXISTS `connected_energy_sloar_carport_modelling`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `connected_energy_sloar_carport_modelling` (
  `connected_energy_sloar_carport_modelling_id` int NOT NULL AUTO_INCREMENT,
  `connected_energy_sloar_carport_id` int NOT NULL,
  `customer` varchar(255) NOT NULL,
  `location` varchar(255) NOT NULL,
  `description` varchar(255) NOT NULL,
  `start_date` datetime NOT NULL,
  `end_date` datetime NOT NULL,
  `ev_power_input` float NOT NULL,
  `pv_power_output` float NOT NULL,
  `bess_power_output_input` float NOT NULL,
  `bess_storage_level` float NOT NULL,
  `service_trigger` datetime NOT NULL,
  `validity` enum('Y','N') NOT NULL,
  PRIMARY KEY (`connected_energy_sloar_carport_modelling_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `connected_energy_sloar_carport_modelling`
--

LOCK TABLES `connected_energy_sloar_carport_modelling` WRITE;
/*!40000 ALTER TABLE `connected_energy_sloar_carport_modelling` DISABLE KEYS */;
/*!40000 ALTER TABLE `connected_energy_sloar_carport_modelling` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `icax_marine_source_heat_pump`
--

DROP TABLE IF EXISTS `icax_marine_source_heat_pump`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `icax_marine_source_heat_pump` (
  `icax_marine_source_heat_pump_id` int NOT NULL AUTO_INCREMENT,
  `output_rating` float NOT NULL,
  `input_rating` float NOT NULL,
  `storage_capacity` float NOT NULL,
  `auxiliary_electrical_power_demand` float NOT NULL,
  `input_output_efficiency` decimal(5,4) NOT NULL,
  `electrical_power_input_ramp_rate` float NOT NULL,
  `operational_limitation` varchar(255) NOT NULL,
  `max_starts_per_hour` int NOT NULL,
  `cycles_to_eol` int NOT NULL,
  `mean_time_between_failure` time NOT NULL,
  `mean_down_time` time NOT NULL,
  `unit_cost` decimal(5,4) NOT NULL,
  `power_cost` decimal(5,4) NOT NULL,
  `energy_cost` decimal(5,4) NOT NULL,
  `planning_limitation` varchar(255) NOT NULL,
  `end_users_quantity` int NOT NULL,
  `end_users_type` text NOT NULL,
  `description` text NOT NULL,
  PRIMARY KEY (`icax_marine_source_heat_pump_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `icax_marine_source_heat_pump`
--

LOCK TABLES `icax_marine_source_heat_pump` WRITE;
/*!40000 ALTER TABLE `icax_marine_source_heat_pump` DISABLE KEYS */;
/*!40000 ALTER TABLE `icax_marine_source_heat_pump` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `icax_marine_source_heat_pump_measurement`
--

DROP TABLE IF EXISTS `icax_marine_source_heat_pump_measurement`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `icax_marine_source_heat_pump_measurement` (
  `icax_marine_source_heat_pump_measurement_id` int NOT NULL AUTO_INCREMENT,
  `icax_marine_source_heat_pump_id` int NOT NULL,
  `customer` varchar(255) NOT NULL,
  `location` varchar(255) NOT NULL,
  `description` varchar(255) NOT NULL,
  `start_date` datetime NOT NULL,
  `end_date` datetime NOT NULL,
  `availability` enum('Y','N') NOT NULL,
  `building_temperature` decimal(5,2) NOT NULL,
  `outdoor_ambient_temp` decimal(5,2) NOT NULL,
  `heat_demand` enum('Y','N') NOT NULL,
  `primary_hp_electrical_power_in` float NOT NULL,
  `secondary_hp_electrical_power_in` float NOT NULL,
  `auxiliaries_electrical_power_in` float NOT NULL,
  `boiler_gas_mass_flow_in` float NOT NULL,
  PRIMARY KEY (`icax_marine_source_heat_pump_measurement_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `icax_marine_source_heat_pump_measurement`
--

LOCK TABLES `icax_marine_source_heat_pump_measurement` WRITE;
/*!40000 ALTER TABLE `icax_marine_source_heat_pump_measurement` DISABLE KEYS */;
/*!40000 ALTER TABLE `icax_marine_source_heat_pump_measurement` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `icax_marine_source_heat_pump_modelling`
--

DROP TABLE IF EXISTS `icax_marine_source_heat_pump_modelling`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `icax_marine_source_heat_pump_modelling` (
  `icax_marine_source_heat_pump_modelling_id` int NOT NULL AUTO_INCREMENT,
  `icax_marine_source_heat_pump_id` int NOT NULL,
  `customer` varchar(255) NOT NULL,
  `location` varchar(255) NOT NULL,
  `description` varchar(255) NOT NULL,
  `start_date` datetime NOT NULL,
  `end_date` datetime NOT NULL,
  `availability` enum('Y','N') NOT NULL,
  `thermal_comfort` float NOT NULL,
  `building_losses` float NOT NULL,
  `biulding_volume` float NOT NULL,
  PRIMARY KEY (`icax_marine_source_heat_pump_modelling_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `icax_marine_source_heat_pump_modelling`
--

LOCK TABLES `icax_marine_source_heat_pump_modelling` WRITE;
/*!40000 ALTER TABLE `icax_marine_source_heat_pump_modelling` DISABLE KEYS */;
/*!40000 ALTER TABLE `icax_marine_source_heat_pump_modelling` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `moxia_household_battery`
--

DROP TABLE IF EXISTS `moxia_household_battery`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `moxia_household_battery` (
  `moxia_household_battery_id` int NOT NULL AUTO_INCREMENT,
  `discharging_power` float NOT NULL,
  `charging_power` float NOT NULL,
  `energy_capacity` float NOT NULL,
  `phases` int NOT NULL,
  `description` text NOT NULL,
  PRIMARY KEY (`moxia_household_battery_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `moxia_household_battery`
--

LOCK TABLES `moxia_household_battery` WRITE;
/*!40000 ALTER TABLE `moxia_household_battery` DISABLE KEYS */;
/*!40000 ALTER TABLE `moxia_household_battery` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `moxia_household_battery_charging_efficiency`
--

DROP TABLE IF EXISTS `moxia_household_battery_charging_efficiency`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `moxia_household_battery_charging_efficiency` (
  `moxia_household_battery_charging_efficiency_id` int NOT NULL AUTO_INCREMENT,
  `moxia_household_battery_id` int NOT NULL,
  `charge` float NOT NULL,
  `efficiency` decimal(5,4) NOT NULL,
  PRIMARY KEY (`moxia_household_battery_charging_efficiency_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `moxia_household_battery_charging_efficiency`
--

LOCK TABLES `moxia_household_battery_charging_efficiency` WRITE;
/*!40000 ALTER TABLE `moxia_household_battery_charging_efficiency` DISABLE KEYS */;
/*!40000 ALTER TABLE `moxia_household_battery_charging_efficiency` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `moxia_household_battery_discharging_efficiency`
--

DROP TABLE IF EXISTS `moxia_household_battery_discharging_efficiency`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `moxia_household_battery_discharging_efficiency` (
  `moxia_household_battery_discharging_efficiency_id` int NOT NULL AUTO_INCREMENT,
  `moxia_household_battery_id` int NOT NULL,
  `charge` float NOT NULL,
  `efficiency` decimal(5,4) NOT NULL,
  PRIMARY KEY (`moxia_household_battery_discharging_efficiency_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `moxia_household_battery_discharging_efficiency`
--

LOCK TABLES `moxia_household_battery_discharging_efficiency` WRITE;
/*!40000 ALTER TABLE `moxia_household_battery_discharging_efficiency` DISABLE KEYS */;
/*!40000 ALTER TABLE `moxia_household_battery_discharging_efficiency` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `moxia_household_pvb`
--

DROP TABLE IF EXISTS `moxia_household_pvb`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `moxia_household_pvb` (
  `moxia_household_pvb_id` int NOT NULL AUTO_INCREMENT,
  `pv_nominal_output_rating` float NOT NULL,
  `battery_output_rating` float NOT NULL,
  `battery_input_rating` float NOT NULL,
  `storage_capacity` float NOT NULL,
  `auxiliary_electrical_power_demand` float NOT NULL,
  `moxia_household_battery_id` int NOT NULL,
  `charging_power_ramp_rate` float NOT NULL,
  `discharging_power_ramp_rate` float NOT NULL,
  `operational_limitation` varchar(255) NOT NULL,
  `cycles_to_eol` int NOT NULL,
  `unit_cost` float NOT NULL,
  `power_cost` float NOT NULL,
  `energy_cost` float NOT NULL,
  `planning_limitation` text NOT NULL,
  `end_users_quantity` int NOT NULL,
  `end_users_type` text NOT NULL,
  `description` text NOT NULL,
  PRIMARY KEY (`moxia_household_pvb_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `moxia_household_pvb`
--

LOCK TABLES `moxia_household_pvb` WRITE;
/*!40000 ALTER TABLE `moxia_household_pvb` DISABLE KEYS */;
/*!40000 ALTER TABLE `moxia_household_pvb` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `moxia_household_pvb_measurement`
--

DROP TABLE IF EXISTS `moxia_household_pvb_measurement`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `moxia_household_pvb_measurement` (
  `moxia_household_pvb_measurement_id` int NOT NULL AUTO_INCREMENT,
  `moxia_household_pvb_id` int NOT NULL,
  `customer` varchar(255) NOT NULL,
  `location` varchar(255) NOT NULL,
  `description` varchar(255) NOT NULL,
  `start_date` datetime NOT NULL,
  `end_date` datetime NOT NULL,
  `pv_power_output` float NOT NULL,
  `bess_power_output_input` float NOT NULL,
  `bess_storage_level` float NOT NULL,
  `fiscal_metered_input_output` float NOT NULL,
  `service_trigger` datetime NOT NULL,
  PRIMARY KEY (`moxia_household_pvb_measurement_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `moxia_household_pvb_measurement`
--

LOCK TABLES `moxia_household_pvb_measurement` WRITE;
/*!40000 ALTER TABLE `moxia_household_pvb_measurement` DISABLE KEYS */;
/*!40000 ALTER TABLE `moxia_household_pvb_measurement` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `moxia_household_pvb_modelling`
--

DROP TABLE IF EXISTS `moxia_household_pvb_modelling`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `moxia_household_pvb_modelling` (
  `moxia_household_pvb_modelling_id` int NOT NULL AUTO_INCREMENT,
  `moxia_household_pvb_id` int NOT NULL,
  `customer` varchar(255) NOT NULL,
  `location` varchar(255) NOT NULL,
  `description` varchar(255) NOT NULL,
  `start_date` datetime NOT NULL,
  `end_date` datetime NOT NULL,
  `pv_power_output` float NOT NULL,
  `bess_power_output_input` float NOT NULL,
  `bess_storage_level` float NOT NULL,
  `fiscal_metered_input_output` float NOT NULL,
  `service_trigger` datetime NOT NULL,
  PRIMARY KEY (`moxia_household_pvb_modelling_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `moxia_household_pvb_modelling`
--

LOCK TABLES `moxia_household_pvb_modelling` WRITE;
/*!40000 ALTER TABLE `moxia_household_pvb_modelling` DISABLE KEYS */;
/*!40000 ALTER TABLE `moxia_household_pvb_modelling` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `moxia_public_battery`
--

DROP TABLE IF EXISTS `moxia_public_battery`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `moxia_public_battery` (
  `moxia_public_battery_id` int NOT NULL AUTO_INCREMENT,
  `discharging_power` float NOT NULL,
  `charging_power` float NOT NULL,
  `energy_capacity` float NOT NULL,
  `phases` int NOT NULL,
  `description` text NOT NULL,
  PRIMARY KEY (`moxia_public_battery_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `moxia_public_battery`
--

LOCK TABLES `moxia_public_battery` WRITE;
/*!40000 ALTER TABLE `moxia_public_battery` DISABLE KEYS */;
/*!40000 ALTER TABLE `moxia_public_battery` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `moxia_public_battery_charging_efficiency`
--

DROP TABLE IF EXISTS `moxia_public_battery_charging_efficiency`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `moxia_public_battery_charging_efficiency` (
  `moxia_public_battery_charging_efficiency_id` int NOT NULL AUTO_INCREMENT,
  `moxia_public_battery_id` int NOT NULL,
  `charge` float NOT NULL,
  `efficiency` decimal(5,4) NOT NULL,
  PRIMARY KEY (`moxia_public_battery_charging_efficiency_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `moxia_public_battery_charging_efficiency`
--

LOCK TABLES `moxia_public_battery_charging_efficiency` WRITE;
/*!40000 ALTER TABLE `moxia_public_battery_charging_efficiency` DISABLE KEYS */;
/*!40000 ALTER TABLE `moxia_public_battery_charging_efficiency` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `moxia_public_battery_discharging_efficiency`
--

DROP TABLE IF EXISTS `moxia_public_battery_discharging_efficiency`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `moxia_public_battery_discharging_efficiency` (
  `moxia_public_battery_discharging_efficiency_id` int NOT NULL AUTO_INCREMENT,
  `moxia_public_battery_id` int NOT NULL,
  `charge` float NOT NULL,
  `efficiency` decimal(5,4) NOT NULL,
  PRIMARY KEY (`moxia_public_battery_discharging_efficiency_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `moxia_public_battery_discharging_efficiency`
--

LOCK TABLES `moxia_public_battery_discharging_efficiency` WRITE;
/*!40000 ALTER TABLE `moxia_public_battery_discharging_efficiency` DISABLE KEYS */;
/*!40000 ALTER TABLE `moxia_public_battery_discharging_efficiency` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `moxia_public_pvb`
--

DROP TABLE IF EXISTS `moxia_public_pvb`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `moxia_public_pvb` (
  `moxia_public_pvb_id` int NOT NULL AUTO_INCREMENT,
  `pv_output_rating` float NOT NULL,
  `battery_output_rating` float NOT NULL,
  `battery_input_rating` float NOT NULL,
  `storage_capacity` float NOT NULL,
  `auxiliary_electrical_power_demand` float NOT NULL,
  `moxia_public_battery_id` int NOT NULL,
  `charging_power_ramp_rate` float NOT NULL,
  `discharging_power_ramp_rate` float NOT NULL,
  `operational_limitation` varchar(255) NOT NULL,
  `cycles_to_eol` int NOT NULL,
  `unit_cost` float NOT NULL,
  `power_cost` float NOT NULL,
  `energy_cost` float NOT NULL,
  `planning_limitation` text NOT NULL,
  `end_users_quantity` int NOT NULL,
  `end_users_type` text NOT NULL,
  `description` text NOT NULL,
  PRIMARY KEY (`moxia_public_pvb_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `moxia_public_pvb`
--

LOCK TABLES `moxia_public_pvb` WRITE;
/*!40000 ALTER TABLE `moxia_public_pvb` DISABLE KEYS */;
/*!40000 ALTER TABLE `moxia_public_pvb` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `moxia_public_pvb_measurement`
--

DROP TABLE IF EXISTS `moxia_public_pvb_measurement`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `moxia_public_pvb_measurement` (
  `moxia_public_pvb_measurement_id` int NOT NULL AUTO_INCREMENT,
  `moxia_pvb_id` int NOT NULL,
  `customer` varchar(255) NOT NULL,
  `location` varchar(255) NOT NULL,
  `description` varchar(255) NOT NULL,
  `start_date` datetime NOT NULL,
  `end_date` datetime NOT NULL,
  `pv_power_output` float NOT NULL,
  `bess_power_output_input` float NOT NULL,
  `bess_storage_level` float NOT NULL,
  `fiscal_metered_input_output` float NOT NULL,
  `service_trigger` datetime NOT NULL,
  PRIMARY KEY (`moxia_public_pvb_measurement_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `moxia_public_pvb_measurement`
--

LOCK TABLES `moxia_public_pvb_measurement` WRITE;
/*!40000 ALTER TABLE `moxia_public_pvb_measurement` DISABLE KEYS */;
/*!40000 ALTER TABLE `moxia_public_pvb_measurement` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `moxia_public_pvb_modelling`
--

DROP TABLE IF EXISTS `moxia_public_pvb_modelling`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `moxia_public_pvb_modelling` (
  `moxia_public_pvb_modelling_id` int NOT NULL AUTO_INCREMENT,
  `moxia_pvb_id` int NOT NULL,
  `customer` varchar(255) NOT NULL,
  `location` varchar(255) NOT NULL,
  `description` varchar(255) NOT NULL,
  `start_date` datetime NOT NULL,
  `end_date` datetime NOT NULL,
  `pv_power_output` float NOT NULL,
  `bess_power_output_input` float NOT NULL,
  `bess_storage_level` float NOT NULL,
  `fiscal_metered_input_output` float NOT NULL,
  `service_trigger` datetime NOT NULL,
  PRIMARY KEY (`moxia_public_pvb_modelling_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `moxia_public_pvb_modelling`
--

LOCK TABLES `moxia_public_pvb_modelling` WRITE;
/*!40000 ALTER TABLE `moxia_public_pvb_modelling` DISABLE KEYS */;
/*!40000 ALTER TABLE `moxia_public_pvb_modelling` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `moxia_v1g_charger`
--

DROP TABLE IF EXISTS `moxia_v1g_charger`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `moxia_v1g_charger` (
  `moxia_v1g_charger_id` int NOT NULL AUTO_INCREMENT,
  `output_parameter` float NOT NULL,
  `auxiliary_electrical_power` float NOT NULL,
  `input_to_output_efficiency` decimal(5,4) NOT NULL,
  `charging_power_ramp_rate` float NOT NULL,
  `discharging_power_ramp_rate` float NOT NULL,
  `operational_limitation` varchar(255) NOT NULL,
  `cycles_to_eol` int NOT NULL,
  `mean_time_between_failures` float NOT NULL,
  `mean_down_time` float NOT NULL,
  `unit_cost` float NOT NULL,
  `planning_limitation` text NOT NULL,
  `end_users_quantity` int NOT NULL,
  `end_users_type` text NOT NULL,
  `description` text NOT NULL,
  PRIMARY KEY (`moxia_v1g_charger_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `moxia_v1g_charger`
--

LOCK TABLES `moxia_v1g_charger` WRITE;
/*!40000 ALTER TABLE `moxia_v1g_charger` DISABLE KEYS */;
/*!40000 ALTER TABLE `moxia_v1g_charger` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `moxia_v1g_charger_measurement`
--

DROP TABLE IF EXISTS `moxia_v1g_charger_measurement`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `moxia_v1g_charger_measurement` (
  `moxia_v1g_charger_measurement_id` int NOT NULL AUTO_INCREMENT,
  `moxia_v1g_charger_id` int NOT NULL,
  `customer` varchar(255) NOT NULL,
  `location` varchar(255) NOT NULL,
  `description` varchar(255) NOT NULL,
  `start_date` datetime NOT NULL,
  `end_date` datetime NOT NULL,
  `ev_power_input` float NOT NULL,
  `service_trigger` datetime NOT NULL,
  PRIMARY KEY (`moxia_v1g_charger_measurement_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `moxia_v1g_charger_measurement`
--

LOCK TABLES `moxia_v1g_charger_measurement` WRITE;
/*!40000 ALTER TABLE `moxia_v1g_charger_measurement` DISABLE KEYS */;
/*!40000 ALTER TABLE `moxia_v1g_charger_measurement` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `moxia_v1g_charger_modelling`
--

DROP TABLE IF EXISTS `moxia_v1g_charger_modelling`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `moxia_v1g_charger_modelling` (
  `moxia_v1g_charger_modelling_id` int NOT NULL AUTO_INCREMENT,
  `moxia_v1g_charger_id` int NOT NULL,
  `customer` varchar(255) NOT NULL,
  `location` varchar(255) NOT NULL,
  `description` varchar(255) NOT NULL,
  `start_date` datetime NOT NULL,
  `end_date` datetime NOT NULL,
  `ev_power_input` float NOT NULL,
  `service_trigger` datetime NOT NULL,
  PRIMARY KEY (`moxia_v1g_charger_modelling_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `moxia_v1g_charger_modelling`
--

LOCK TABLES `moxia_v1g_charger_modelling` WRITE;
/*!40000 ALTER TABLE `moxia_v1g_charger_modelling` DISABLE KEYS */;
/*!40000 ALTER TABLE `moxia_v1g_charger_modelling` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `moxia_v2g_charger`
--

DROP TABLE IF EXISTS `moxia_v2g_charger`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `moxia_v2g_charger` (
  `moxia_v2g_charger_id` int NOT NULL AUTO_INCREMENT,
  `output_parameter` float NOT NULL,
  `auxiliary_electrical_power` float NOT NULL,
  `input_to_output_efficiency` decimal(5,4) NOT NULL,
  `charging_power_ramp_rate` float NOT NULL,
  `discharging_power_ramp_rate` float NOT NULL,
  `operational_limitation` varchar(255) NOT NULL,
  `cycles_to_eol` int NOT NULL,
  `mean_time_between_failures` float NOT NULL,
  `mean_down_time` float NOT NULL,
  `unit_cost` float NOT NULL,
  `planning_limitation` text NOT NULL,
  `end_users_quantity` int NOT NULL,
  `end_users_type` text NOT NULL,
  `description` text NOT NULL,
  PRIMARY KEY (`moxia_v2g_charger_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `moxia_v2g_charger`
--

LOCK TABLES `moxia_v2g_charger` WRITE;
/*!40000 ALTER TABLE `moxia_v2g_charger` DISABLE KEYS */;
/*!40000 ALTER TABLE `moxia_v2g_charger` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `moxia_v2g_charger_measurement`
--

DROP TABLE IF EXISTS `moxia_v2g_charger_measurement`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `moxia_v2g_charger_measurement` (
  `moxia_v2g_charger_measurement_id` int NOT NULL AUTO_INCREMENT,
  `moxia_v2g_charger_id` int NOT NULL,
  `customer` varchar(255) NOT NULL,
  `location` varchar(255) NOT NULL,
  `description` varchar(255) NOT NULL,
  `start_date` datetime NOT NULL,
  `end_date` datetime NOT NULL,
  `ev_power_input` float NOT NULL,
  `service_trigger` datetime NOT NULL,
  PRIMARY KEY (`moxia_v2g_charger_measurement_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `moxia_v2g_charger_measurement`
--

LOCK TABLES `moxia_v2g_charger_measurement` WRITE;
/*!40000 ALTER TABLE `moxia_v2g_charger_measurement` DISABLE KEYS */;
/*!40000 ALTER TABLE `moxia_v2g_charger_measurement` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `moxia_v2g_charger_modelling`
--

DROP TABLE IF EXISTS `moxia_v2g_charger_modelling`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `moxia_v2g_charger_modelling` (
  `moxia_v2g_charger_modelling_id` int NOT NULL AUTO_INCREMENT,
  `moxia_v2g_charger_id` int NOT NULL,
  `customer` varchar(255) NOT NULL,
  `location` varchar(255) NOT NULL,
  `description` varchar(255) NOT NULL,
  `start_date` datetime NOT NULL,
  `end_date` datetime NOT NULL,
  `ev_power_input` float NOT NULL,
  `service_trigger` datetime NOT NULL,
  PRIMARY KEY (`moxia_v2g_charger_modelling_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `moxia_v2g_charger_modelling`
--

LOCK TABLES `moxia_v2g_charger_modelling` WRITE;
/*!40000 ALTER TABLE `moxia_v2g_charger_modelling` DISABLE KEYS */;
/*!40000 ALTER TABLE `moxia_v2g_charger_modelling` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `passiv_hybrid_air_source_heat_pump`
--

DROP TABLE IF EXISTS `passiv_hybrid_air_source_heat_pump`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `passiv_hybrid_air_source_heat_pump` (
  `passiv_hybrid_air_source_heat_pump_id` int NOT NULL AUTO_INCREMENT,
  `output_rating` float NOT NULL,
  `input_rating` float NOT NULL,
  `storage_capacity` float NOT NULL,
  `auxiliary_electrical_power_demand` float NOT NULL,
  `input_output_efficiency` decimal(5,4) NOT NULL,
  `electrical_power_input_ramp_rate` float NOT NULL,
  `operational_limitation` varchar(255) NOT NULL,
  `allowed_start_stops_per_hour` int NOT NULL,
  `cycles_to_eol` int NOT NULL,
  `mean_time_between_failure` time NOT NULL,
  `mean_down_time` time NOT NULL,
  `unit_cost` decimal(5,4) NOT NULL,
  `power_cost` decimal(5,4) NOT NULL,
  `energy_cost` decimal(5,4) NOT NULL,
  `planning_limitation` varchar(255) NOT NULL,
  `end_users_quantity` int NOT NULL,
  `end_users_type` text NOT NULL,
  `description` text NOT NULL,
  PRIMARY KEY (`passiv_hybrid_air_source_heat_pump_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `passiv_hybrid_air_source_heat_pump`
--

LOCK TABLES `passiv_hybrid_air_source_heat_pump` WRITE;
/*!40000 ALTER TABLE `passiv_hybrid_air_source_heat_pump` DISABLE KEYS */;
/*!40000 ALTER TABLE `passiv_hybrid_air_source_heat_pump` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `passiv_hybrid_air_source_heat_pump_measurement`
--

DROP TABLE IF EXISTS `passiv_hybrid_air_source_heat_pump_measurement`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `passiv_hybrid_air_source_heat_pump_measurement` (
  `passiv_hybrid_air_source_heat_pump_measurement_id` int NOT NULL AUTO_INCREMENT,
  `passiv_hybrid_air_source_heat_pump_id` int NOT NULL,
  `customer` varchar(255) NOT NULL,
  `location` varchar(255) NOT NULL,
  `description` varchar(255) NOT NULL,
  `start_date` datetime NOT NULL,
  `end_date` datetime NOT NULL,
  `functional` enum('Y','N') NOT NULL,
  `building_temperature` decimal(5,4) NOT NULL,
  `outdoor_ambient_temp` decimal(5,4) NOT NULL,
  `heat_demand_ml_param` enum('Y','N') NOT NULL,
  `hp_electrical_power_in` float NOT NULL,
  `additional_circulating_pumps_electrical_power_in` float NOT NULL,
  `auxiliaries_electrical_power_in` float NOT NULL,
  PRIMARY KEY (`passiv_hybrid_air_source_heat_pump_measurement_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `passiv_hybrid_air_source_heat_pump_measurement`
--

LOCK TABLES `passiv_hybrid_air_source_heat_pump_measurement` WRITE;
/*!40000 ALTER TABLE `passiv_hybrid_air_source_heat_pump_measurement` DISABLE KEYS */;
/*!40000 ALTER TABLE `passiv_hybrid_air_source_heat_pump_measurement` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `passiv_hybrid_air_source_heat_pump_modelling`
--

DROP TABLE IF EXISTS `passiv_hybrid_air_source_heat_pump_modelling`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `passiv_hybrid_air_source_heat_pump_modelling` (
  `passiv_hybrid_air_source_heat_pump_modelling_id` int NOT NULL AUTO_INCREMENT,
  `passiv_hybrid_air_source_heat_pump_id` int NOT NULL,
  `customer` varchar(255) NOT NULL,
  `location` varchar(255) NOT NULL,
  `description` varchar(255) NOT NULL,
  `start_date` datetime NOT NULL,
  `end_date` datetime NOT NULL,
  `availability` enum('Y','N') NOT NULL,
  `thermal_comfort` float NOT NULL,
  `building_losses` float NOT NULL,
  `biulding_volume` float NOT NULL,
  PRIMARY KEY (`passiv_hybrid_air_source_heat_pump_modelling_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `passiv_hybrid_air_source_heat_pump_modelling`
--

LOCK TABLES `passiv_hybrid_air_source_heat_pump_modelling` WRITE;
/*!40000 ALTER TABLE `passiv_hybrid_air_source_heat_pump_modelling` DISABLE KEYS */;
/*!40000 ALTER TABLE `passiv_hybrid_air_source_heat_pump_modelling` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2020-11-06 10:28:05
