eehbv_proto.sql

-- MariaDB dump 10.19  Distrib 10.7.3-MariaDB, for debian-linux-gnu (x86_64)
--
-- Host: localhost    Database: eehbv_proto
-- ------------------------------------------------------
-- Server version	10.7.3-MariaDB-1:10.7.3+maria~focal

/*!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 */;
/*!40101 SET NAMES utf8mb4 */;
/*!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 `aggregate_components`
--

DROP TABLE IF EXISTS `aggregate_components`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `aggregate_components` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `aggregate_api_name` varchar(30) NOT NULL,
  `component_api_name` varchar(30) NOT NULL,
  `variable_name` varchar(30) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `aggregate_components`
--

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

--
-- Table structure for table `aggregate_parts`
--

DROP TABLE IF EXISTS `aggregate_parts`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `aggregate_parts` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `aggregate_id` int(11) NOT NULL,
  `component_id` int(11) NOT NULL,
  `aggregate_components_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `aggregate_parts_components` (`aggregate_components_id`),
  CONSTRAINT `aggregate_parts_components` FOREIGN KEY (`aggregate_components_id`) REFERENCES `aggregate_components` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `aggregate_parts`
--

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

--
-- Table structure for table `aggregate_variables`
--

DROP TABLE IF EXISTS `aggregate_variables`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `aggregate_variables` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `api_name` varchar(30) NOT NULL,
  `column_name` varchar(30) NOT NULL,
  `func` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `aggregate_variables`
--

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

--
-- Table structure for table `column_info`
--

DROP TABLE IF EXISTS `column_info`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `column_info` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `component_id` int(30) NOT NULL,
  `column_name` varchar(30) NOT NULL,
  `view_name` varchar(40) NOT NULL,
  `type` varchar(7) NOT NULL,
  `position` tinyint(4) NOT NULL,
  `unit` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `component_tables` (`component_id`),
  CONSTRAINT `component_tables` FOREIGN KEY (`component_id`) REFERENCES `components` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=127 DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `column_info`
--

LOCK TABLES `column_info` WRITE;
/*!40000 ALTER TABLE `column_info` DISABLE KEYS */;
INSERT INTO `column_info` VALUES
(1,1,'name','Modell','VARCHAR',1,NULL),
(2,1,'manufacturer','Hersteller','VARCHAR',2,NULL),
(3,1,'n_nominal','Nenndrehzahl','DOUBLE',6,'1/min'),
(28,1,'price','Preis','INT',3,'Euro'),
(29,1,'p_nominal','Nennleistung','DOUBLE',4,'W'),
(32,1,'m_nominal','Nenndrehmoment','DOUBLE',5,'Nm'),
(33,1,'coeff_a','Koeff. A','DOUBLE',7,''),
(34,1,'coeff_b','Koeff. B','DOUBLE',8,''),
(35,1,'coeff_c','Koeff. C','DOUBLE',9,''),
(36,1,'coeff_d','Koeff. D','DOUBLE',10,''),
(37,1,'coeff_e','Koeff. E','DOUBLE',11,''),
(38,1,'coeff_f','Koeff. F','DOUBLE',12,''),
(39,1,'coeff_g','Koeff. G','DOUBLE',13,''),
(100,26,'name','Modell','VARCHAR',1,NULL),
(101,26,'manufacturer','Hersteller','VARCHAR',2,NULL),
(102,26,'price','Preis','DOUBLE',2,'Euro'),
(103,26,'p_nominal','Nennleistung','DOUBLE',4,'W'),
(104,26,'s_r_equ','S(r,equ)','DOUBLE',5,'VA'),
(105,26,'p_0_25','P(0;25)','DOUBLE',6,''),
(106,26,'p_0_50','P(0;50)','DOUBLE',7,''),
(107,26,'p_0_100','P(0;100)','DOUBLE',8,''),
(108,26,'p_50_25','P(50;25)','DOUBLE',9,''),
(109,26,'p_50_50','P(50;50)','DOUBLE',10,''),
(110,26,'p_50_100','P(50;100)','DOUBLE',11,''),
(111,26,'p_90_50','P(90;50)','DOUBLE',12,''),
(112,26,'p_90_100','P(90;100)','DOUBLE',13,''),
(117,28,'name','Modell','VARCHAR',1,NULL),
(118,28,'manufacturer','Hersteller','VARCHAR',2,NULL),
(119,28,'price','Preis','DOUBLE',2,'Euro'),
(120,28,'efficiency','Wirkungsgrad','DOUBLE',4,''),
(121,28,'m_nominal','Nennmoment','DOUBLE',5,'Nm'),
(122,28,'gear_ratio','Übersetzung','DOUBLE',6,''),
(123,26,'f_nominal','max. Ausgangsfrequenz','DOUBLE',14,'Hz'),
(124,26,'i_nominal','Nennstrom','DOUBLE',15,'A'),
(125,1,'f_nominal','Nennfrequenz','DOUBLE',14,'Hz'),
(126,1,'n_pole_pairs','Polpaarzahl','DOUBLE',15,NULL);
/*!40000 ALTER TABLE `column_info` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `component_gears`
--

DROP TABLE IF EXISTS `component_gears`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `component_gears` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(40) DEFAULT NULL,
  `manufacturer` varchar(40) DEFAULT NULL,
  `price` float DEFAULT NULL,
  `efficiency` float DEFAULT NULL,
  `m_nominal` float DEFAULT NULL,
  `gear_ratio` float DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `component_gears`
--

LOCK TABLES `component_gears` WRITE;
/*!40000 ALTER TABLE `component_gears` DISABLE KEYS */;
INSERT INTO `component_gears` VALUES
(1,'verbaut','Homag',120,0.9,46.62,34.5);
/*!40000 ALTER TABLE `component_gears` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `component_motors`
--

DROP TABLE IF EXISTS `component_motors`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `component_motors` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(40) NOT NULL,
  `manufacturer` varchar(40) NOT NULL,
  `price` int(11) NOT NULL,
  `p_nominal` float NOT NULL,
  `m_nominal` float NOT NULL,
  `n_nominal` float NOT NULL,
  `coeff_a` float NOT NULL,
  `coeff_b` float NOT NULL,
  `coeff_c` float NOT NULL,
  `coeff_d` float NOT NULL,
  `coeff_e` float NOT NULL,
  `coeff_f` float NOT NULL,
  `coeff_g` float NOT NULL,
  `f_nominal` float DEFAULT NULL,
  `n_pole_pairs` float DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=63 DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `component_motors`
--

LOCK TABLES `component_motors` WRITE;
/*!40000 ALTER TABLE `component_motors` DISABLE KEYS */;
INSERT INTO `component_motors` VALUES
(45,'motor25','gen7',7560,7500,6.24856,11461.8,0.0230712,-0.0178927,0.0462935,-0.0245935,0.0159564,-0.00367092,0.0819646,200,1),
(46,'motor26','gen7',4088,4000,3.37952,11302.6,0.0281314,-0.0161129,0.0457705,-0.0407442,0.0261418,-0.00584108,0.110426,200,1),
(61,'motor62','gen7_50',11099,11000,49.6583,2115.3,0.0673007,-0.0454357,0.216711,-1.03465,0.687409,-0.0779296,1.0031,50,1),
(62,'motor66','gen7_50',11099,11000,46.5625,2255.94,0.04482,-0.0515804,0.154145,-0.224792,0.150846,-0.0203239,0.511723,50,1);
/*!40000 ALTER TABLE `component_motors` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `component_transformers`
--

DROP TABLE IF EXISTS `component_transformers`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `component_transformers` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(40) DEFAULT NULL,
  `manufacturer` varchar(40) DEFAULT NULL,
  `price` float DEFAULT NULL,
  `p_nominal` float DEFAULT NULL,
  `s_r_equ` float DEFAULT NULL,
  `p_0_25` float DEFAULT NULL,
  `p_0_50` float DEFAULT NULL,
  `p_0_100` float DEFAULT NULL,
  `p_50_25` float DEFAULT NULL,
  `p_50_50` float DEFAULT NULL,
  `p_50_100` float DEFAULT NULL,
  `p_90_50` float DEFAULT NULL,
  `p_90_100` float DEFAULT NULL,
  `f_nominal` float DEFAULT NULL,
  `i_nominal` float DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=67 DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `component_transformers`
--

LOCK TABLES `component_transformers` WRITE;
/*!40000 ALTER TABLE `component_transformers` DISABLE KEYS */;
INSERT INTO `component_transformers` VALUES
(53,'12G6CDB-3900','KEB',4000,4000,6600,0.88,1,1.3,0.9,1.04,1.38,1.08,1.46,400,9.5),
(58,'14F6K12-3923','KEB',7500,7500,11400,0.76,0.9,1.31,0.79,0.95,1.41,0.97,1.48,400,16.5),
(59,'12S6A14-2100','KEB',4000,4000,6600,1.76,1.92,2.32,1.76,1.95,2.4,2.01,2.51,400,9.5),
(62,'14F5A1D-380A','KEB',7500,7500,11000,0.66,0.77,1.14,0.71,0.84,1.26,0.88,1.35,400,16.5),
(65,'15G6CDC-3500','KEB',11000,11000,17000,0.59,0.74,1.19,0.61,0.79,1.31,0.81,1.4,400,24),
(66,'15F5A1H-37DF','KEB',11000,11000,17000,1.93,2.42,3.83,1.89,2.38,3.8,2.33,3.76,400,24);
/*!40000 ALTER TABLE `component_transformers` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `components`
--

DROP TABLE IF EXISTS `components`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `components` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `table_name` varchar(30) NOT NULL,
  `view_name` varchar(30) NOT NULL,
  `api_name` varchar(15) NOT NULL,
  `is_aggregate` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uq_api_name` (`api_name`)
) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `components`
--

LOCK TABLES `components` WRITE;
/*!40000 ALTER TABLE `components` DISABLE KEYS */;
INSERT INTO `components` VALUES
(1,'component_motors','Motoren','motors',0),
(26,'component_transformers','Frequenzumrichter','transformers',0),
(28,'component_gears','Getriebe','gears',0);
/*!40000 ALTER TABLE `components` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `glossary`
--

DROP TABLE IF EXISTS `glossary`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `glossary` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `term` varchar(60) NOT NULL,
  `text` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `glossary`
--

LOCK TABLES `glossary` WRITE;
/*!40000 ALTER TABLE `glossary` DISABLE KEYS */;
INSERT INTO `glossary` VALUES
(1,'Spezifische Schnittkraft','Die Spezifische Zerspankraft k ist die auf den Spanungsquerschnitt A bezogene Zerspankraft F.'),
(2,'Brinellhärte','<b>Härte</b> ist der mechanische Widerstand, den ein Werkstoff der mechanischen Eindringung eines anderen Körpers entgegensetzt. Je nach der Art der Einwirkung unterscheidet man verschiedene Arten von Härte.\r\nDie vom schwedischen Ingenieur Johan August <em>Brinell</em> im Jahre 1900 entwickelte und auf der Weltausstellung in Paris präsentierte Methode der Härteprüfung kommt bei weichen bis mittelharten Metallen (EN ISO 6506-1 bis EN ISO 6506-4) wie zum Beispiel unlegiertem Baustahl, Aluminiumlegierungen, bei Holz (ISO 3350) und bei Werkstoffen mit ungleichmäßigem Gefüge, wie etwa Gusseisen, zur Anwendung. Dabei wird eine Hartmetallkugel mit einer festgelegten Prüfkraft F in die Oberfläche des zu prüfenden Werkstückes gedrückt.'),
(3,'Test','Testtext'),
(4,'Test2','Testtext2'),
(5,'Test3','Testtext 3');
/*!40000 ALTER TABLE `glossary` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `glossary_processes`
--

DROP TABLE IF EXISTS `glossary_processes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `glossary_processes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `glossary_id` int(11) NOT NULL,
  `processes_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `glossary_processes_glossary` (`glossary_id`),
  KEY `glossary_processes_process` (`processes_id`),
  CONSTRAINT `glossary_processes_glossary` FOREIGN KEY (`glossary_id`) REFERENCES `glossary` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `glossary_processes_process` FOREIGN KEY (`processes_id`) REFERENCES `processes` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `glossary_processes`
--

LOCK TABLES `glossary_processes` WRITE;
/*!40000 ALTER TABLE `glossary_processes` DISABLE KEYS */;
INSERT INTO `glossary_processes` VALUES
(1,1,1),
(2,2,1),
(4,3,1),
(20,5,1);
/*!40000 ALTER TABLE `glossary_processes` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `info_texts`
--

DROP TABLE IF EXISTS `info_texts`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `info_texts` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `type` tinyint(4) NOT NULL,
  `processes_id` int(11) NOT NULL,
  `position` tinyint(4) NOT NULL,
  `text` text NOT NULL,
  PRIMARY KEY (`id`),
  KEY `info_texts_processes` (`processes_id`),
  CONSTRAINT `info_texts_processes` FOREIGN KEY (`processes_id`) REFERENCES `processes` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `info_texts`
--

LOCK TABLES `info_texts` WRITE;
/*!40000 ALTER TABLE `info_texts` DISABLE KEYS */;
INSERT INTO `info_texts` VALUES
(1,1,1,3,'Prozess-spezifischer Infotext für Angabe der Prozessparameter von Kantenanleimmaschinen...'),
(2,1,1,4,'Prozess-spezifischer Infotext für Angabe der Nebenbedingungen von Kantenanleimmaschinen...'),
(17,1,21,3,''),
(18,1,21,4,'');
/*!40000 ALTER TABLE `info_texts` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `loss_functions`
--

DROP TABLE IF EXISTS `loss_functions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `loss_functions` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `processes_id` int(11) NOT NULL,
  `func` text NOT NULL,
  `description` varchar(30) NOT NULL,
  `doc` text NOT NULL,
  PRIMARY KEY (`id`),
  KEY `processes_loss_functions` (`processes_id`),
  CONSTRAINT `processes_loss_functions` FOREIGN KEY (`processes_id`) REFERENCES `processes` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=67 DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `loss_functions`
--

LOCK TABLES `loss_functions` WRITE;
/*!40000 ALTER TABLE `loss_functions` DISABLE KEYS */;
INSERT INTO `loss_functions` VALUES
(1,1,'import numpy as np\r\n\r\ndef target_func(a, b):\r\n	rt = RotatingTool(diameter=125, num_teeth=3, ang_kappa=90, ang_lambda=65)\r\n	return a * b\r\n\r\n\r\nclass RotatingTool:\r\n    \"\"\"Base class for rotating cutting tools.\"\"\"\r\n\r\n    def __init__(self, diameter, num_teeth, ang_kappa, ang_lambda):\r\n        \"\"\"\r\n        Initialize a rotary cutting tool.\r\n\r\n        Parameters\r\n        ----------\r\n        diameter : float\r\n            tool diameter in mm.\r\n        num_teeth : integer\r\n            number of teeth.\r\n        ang_kappa : float\r\n            cutting angle in deg.\r\n        ang_lambda : float\r\n            cutting angle in deg.\r\n\r\n        Returns\r\n        -------\r\n        Object.\r\n\r\n        \"\"\"\r\n        self.d = diameter / 1000\r\n        self.z = num_teeth\r\n        self.ang_kap = ang_kappa * np.pi / 180\r\n        self.ang_lam = ang_lambda\r\n        self.process_params = None\r\n        self.ppp = False\r\n\r\n    def define_cutting_process(self, kc05, rpm, feed_speed, cutting_width,\r\n                               depth_of_cut, protrusion=0):\r\n        \"\"\"\r\n        Definition of a wood cutting process.\r\n\r\n        Parameters\r\n        ----------\r\n        kc05: float\r\n            specific cutting force of material in N/mm^1.5\r\n        rpm : float\r\n            rotations per minute.\r\n        feed_speed : float\r\n            feed speed in meters per minute.\r\n        cutting_width : float\r\n            cutting width in mm.\r\n        depth_of_cut : float\r\n            depth of cut in mm.\r\n        protrusion : float\r\n            saw blades only: blade protrusion in mm\r\n        Returns\r\n        -------\r\n        A dictonary of the cutting parameters.\r\n\r\n        \"\"\"\r\n        # check for numeric values?\r\n        # conversion to SI Units\r\n        parameter_dict = dict([(\"kc05\", kc05*1000**1.5), (\"rpm\", rpm),\r\n                               (\"feed_speed\", feed_speed/60),\r\n                               (\"cw\", cutting_width/1000),\r\n                               (\"ae\", depth_of_cut/1000),\r\n                               (\"n\", rpm/60), (\"protrusion\", protrusion/1000)])\r\n\r\n        self.process_params = parameter_dict\r\n        self.ppp = True\r\n\r\n    def check_process_param_dict(self):\r\n        \"\"\"Check if a Process Parameters Dictonary is available.\"\"\"\r\n        if self.ppp:\r\n            return self.ppp\r\n        else:\r\n            print(\"Please parse a process parameter dict \\\r\n                  to make this calculation.\")\r\n            return self.ppp\r\n\r\n    def calculate_geometry_parameters(self):\r\n        \"\"\"\r\n        Calculate specific geometry values for the given process parameters.\r\n\r\n        Returns\r\n        -------\r\n        A dictonary containing all relevant cutting process values.\r\n\r\n        \"\"\"\r\n        fz = self.fz()\r\n        vc = self.vc()\r\n        omega = self.angular_vel()\r\n        phi = self.ang_phi()\r\n        sb = self.sb(phi)\r\n        ze = self.ze(phi)\r\n        hm = self.hm(fz, sb)\r\n\r\n        res = dict([(\"vc\", vc), (\"feed per tooth\", fz), (\"phi\", phi),\r\n                    (\"cut arc length\", sb), (\"ze\", ze),\r\n                    (\"medium chip thickness\", hm), (\"ang_v\", omega)])\r\n        return res\r\n\r\n    def calculate_process_output(self, geometry_dict):\r\n        \"\"\"\r\n        Calculate cutting force, moment and power.\r\n\r\n        Returns\r\n        -------\r\n        A dictonary containing calculation results.\r\n\r\n        \"\"\"\r\n        Fc = self.Fc(geometry_dict.get(\"medium chip thickness\"))\r\n        M = self.cutting_moment(Fc, geometry_dict.get(\"ze\"))\r\n        P = self.cutting_power(M, geometry_dict.get(\"ang_v\"))\r\n\r\n        res = dict([(\"cutting force\", Fc), (\"cutting moment\", M),\r\n                    (\"cutting power\", P)])\r\n        return res\r\n\r\n    def angular_vel(self):\r\n        \"\"\"Calculate the tools angular velocity.\"\"\"\r\n        if self.check_process_param_dict():\r\n            return 2 * np.pi * self.process_params.get(\"n\")\r\n\r\n    def vc(self):\r\n        \"\"\"Calculate the cutting speed.\"\"\"\r\n        if self.check_process_param_dict():\r\n            return self.d * np.pi / self.process_params.get(\"n\")\r\n\r\n    def fz(self):\r\n        \"\"\"Calculate the feed per tooth.\"\"\"\r\n        if self.check_process_param_dict():\r\n            return self.process_params.get(\"feed_speed\") / \\\r\n                (self.process_params.get(\"n\") * self.z)\r\n\r\n    def sb(self, ang_phi):\r\n        \"\"\"Arc length of tooth in cutting operation.\"\"\"\r\n        if self.check_process_param_dict():\r\n            return self.d * ang_phi * 0.5\r\n\r\n    def ze(self, ang_phi):\r\n        \"\"\"Calculate the number of active teeth.\"\"\"\r\n        if self.check_process_param_dict():\r\n            return self.z * ang_phi / np.pi * 0.5\r\n\r\n    def ang_phi(self):\r\n        \"\"\"\r\n        Calculate angle of operation?.\r\n\r\n        Returns\r\n        -------\r\n        Angle of operation in radians.\r\n\r\n        \"\"\"\r\n        if self.check_process_param_dict():\r\n            h1 = self.process_params.get(\"ae\") - \\\r\n                self.process_params.get(\"protrusion\")\r\n            return np.arccos(1-2*h1/self.d) - \\\r\n                np.arccos(1-2*self.process_params.get(\"protrusion\")/self.d)\r\n\r\n    def hm(self, feed_per_tooth, cut_arc_length):\r\n        \"\"\"\r\n        Calculate medium chip thickness.\r\n\r\n        Parameters\r\n        ----------\r\n        feed_per_tooth : float\r\n            feed per tooth in meters/tooth.\r\n        cut_arc_length : floath\r\n            tooth active arc length in meters.\r\n\r\n        Returns\r\n        -------\r\n        None.\r\n\r\n        \"\"\"\r\n        if self.check_process_param_dict():\r\n            return feed_per_tooth * np.sin(self.ang_kap) * \\\r\n                self.process_params.get(\"ae\") / cut_arc_length\r\n\r\n    def Fc(self, medium_chip_thickness):\r\n        \"\"\"Calculate cutting force.\"\"\"\r\n        return self.process_params.get(\"kc05\") * \\\r\n            self.process_params.get(\"cw\") /\\\r\n            np.sin(self.ang_kap) * np.sqrt(medium_chip_thickness)\r\n\r\n    def cutting_moment(self, cutting_force, ze):\r\n        \"\"\"Moment of the cutting force acting on the motor.\"\"\"\r\n        return ze * cutting_force * self.d * 0.5\r\n\r\n    def cutting_power(self, moment, angular_vel):\r\n        \"\"\"Power of the cutting motor.\"\"\"\r\n        return moment * angular_vel\r\n','Motorverlust',''),
(2,1,'def target_func(param_a, param_b):\r\n    return param_a * param_b * param_b','Wandlerverlust',''),
(57,21,'def target_func(width_wp, width_band):\n    # width workpiece mm, width edge band mm\n    return (width_band - width_wp) / 2\n','Kantenbandüberlapp','width workpiece mm, width edge band mm'),
(58,21,'def target_func(list_var, index):\n    # list, index\n    return list_var[index]\n','Listenselektion','list, index'),
(59,21,'import numpy as np\r\n\r\n\r\ndef target_func(diameter, num_teeth, ang_kappa, ang_lambda, cutting_width, depth_of_cut, kc05, rpm, feed_speed,\r\n                length_wp, gap_wp, r_bend, n_motors):\r\n    # diameter mm, num_teeth, ang_kappa °, ang_lambda ° - tool parameters, provided as process parameters\r\n    # cutting_width mm, depth_of_cut mm -\r\n    # kc05 N/mm^1,5, rpm, feed_speed m/min, length_wp cm, gap_wp cm, r_bend mm, n_motors for multiple\r\n    # returns list of cutting force, moment, max power, and mean power -- accessible by index starting with 0\r\n    power_variables = straight_cut(diameter, num_teeth, ang_kappa, ang_lambda, cutting_width, depth_of_cut, kc05, rpm,\r\n                                   feed_speed) if r_bend == 0 else \\\r\n        bend_cut(diameter, num_teeth, ang_lambda, kc05, rpm, feed_speed, r_bend)\r\n    portion_load = length_wp / (length_wp + gap_wp)\r\n    return [*power_variables, power_variables[2] * portion_load * n_motors]\r\n\r\n\r\ndef straight_cut(diameter, num_teeth, ang_kappa, ang_lambda, cutting_width, depth_of_cut, kc05, rpm, feed_speed):\r\n    milling_tool = RotatingTool(diameter=diameter, num_teeth=num_teeth, ang_kappa=ang_kappa, ang_lambda=ang_lambda)\r\n    milling_tool.define_cutting_process(kc05, rpm, feed_speed, cutting_width, depth_of_cut)\r\n    geometry_variables = milling_tool.calculate_geometry_parameters()\r\n    return milling_tool.calculate_process_output(geometry_variables)\r\n\r\n\r\ndef bend_cut(diameter, num_teeth, ang_lambda, kc05, rpm, feed_speed, r_bend):\r\n    n = 10\r\n    xs = [r_bend * (1 - 1 / 2 / n - i / n) for i in range(n)]\r\n    kappa = [np.arccos(x / r_bend) * 180 / np.pi for x in xs[::-1]]\r\n    pieces = [{\"ang_kappa\": k, \"depth_of_cut\": (r_bend * (1 - np.sin(k * np.pi / 180)))} for k in kappa]\r\n    pvs = []\r\n    for piece in pieces:\r\n        milling_tool = RotatingTool(diameter=diameter, num_teeth=num_teeth, ang_kappa=piece[\"ang_kappa\"],\r\n                                    ang_lambda=ang_lambda)\r\n        milling_tool.define_cutting_process(kc05, rpm, feed_speed, r_bend / n, piece[\"depth_of_cut\"])\r\n        geometry_variables = milling_tool.calculate_geometry_parameters()\r\n        pvs.append(milling_tool.calculate_process_output(geometry_variables))\r\n    return [sum([pv[0] for pv in pvs]), sum([pv[1] for pv in pvs]), sum([pv[2] for pv in pvs])]\r\n\r\n\r\nclass RotatingTool:\r\n    \"\"\"Base class for rotating cutting tools.\"\"\"\r\n\r\n    def __init__(self, diameter, num_teeth, ang_kappa, ang_lambda):\r\n        \"\"\"\r\n        Initialize a rotary cutting tool.\r\n\r\n        Parameters\r\n        ----------\r\n        diameter : float\r\n            tool diameter in mm.\r\n        num_teeth : integer\r\n            number of teeth.\r\n        ang_kappa : float\r\n            cutting angle in deg.\r\n        ang_lambda : float\r\n            cutting angle in deg.\r\n\r\n        Returns\r\n        -------\r\n        Object.\r\n\r\n        \"\"\"\r\n        self.d = diameter / 1000\r\n        self.z = num_teeth\r\n        self.ang_kap = ang_kappa * np.pi / 180\r\n        self.ang_lam = ang_lambda\r\n        self.process_params = None\r\n        self.ppp = False\r\n\r\n    def define_cutting_process(self, kc05, rpm, feed_speed, cutting_width,\r\n                               depth_of_cut, protrusion=0):\r\n        \"\"\"\r\n        Definition of a wood cutting process.\r\n\r\n        Parameters\r\n        ----------\r\n        kc05: float\r\n            specific cutting force of material in N/mm^1.5\r\n        rpm : float\r\n            rotations per minute.\r\n        feed_speed : float\r\n            feed speed in meters per minute.\r\n        cutting_width : float\r\n            cutting width in mm.\r\n        depth_of_cut : float\r\n            depth of cut in mm.\r\n        protrusion : float\r\n            saw blades only: blade protrusion in mm\r\n        Returns\r\n        -------\r\n        A dictonary of the cutting parameters.\r\n\r\n        \"\"\"\r\n        # check for numeric values?\r\n        # conversion to SI Units\r\n        parameter_dict = dict([(\"kc05\", kc05*1000**1.5), (\"rpm\", rpm),\r\n                               (\"feed_speed\", feed_speed/60),\r\n                               (\"cw\", cutting_width/1000),\r\n                               (\"ae\", depth_of_cut/1000),\r\n                               (\"n\", rpm/60), (\"protrusion\", protrusion/1000)])\r\n\r\n        self.process_params = parameter_dict\r\n        self.ppp = True\r\n\r\n    def check_process_param_dict(self):\r\n        \"\"\"Check if a Process Parameters Dictonary is available.\"\"\"\r\n        if self.ppp:\r\n            return self.ppp\r\n        else:\r\n            print(\"Please parse a process parameter dict \\\r\n                  to make this calculation.\")\r\n            return self.ppp\r\n\r\n    def calculate_geometry_parameters(self):\r\n        \"\"\"\r\n        Calculate specific geometry values for the given process parameters.\r\n\r\n        Returns\r\n        -------\r\n        A dictonary containing all relevant cutting process values.\r\n\r\n        \"\"\"\r\n        fz = self.fz()\r\n        vc = self.vc()\r\n        omega = self.angular_vel()\r\n        phi = self.ang_phi()\r\n        sb = self.sb(phi)\r\n        ze = self.ze(phi)\r\n        hm = self.hm(fz, sb)\r\n\r\n        res = dict([(\"vc\", vc), (\"feed per tooth\", fz), (\"phi\", phi),\r\n                    (\"cut arc length\", sb), (\"ze\", ze),\r\n                    (\"medium chip thickness\", hm), (\"ang_v\", omega)])\r\n        return res\r\n\r\n    def calculate_process_output(self, geometry_dict):\r\n        \"\"\"\r\n        Calculate cutting force, moment and power.\r\n\r\n        Returns\r\n        -------\r\n        A dictonary containing calculation results.\r\n\r\n        \"\"\"\r\n        Fc = self.Fc(geometry_dict.get(\"medium chip thickness\"))\r\n        M = self.cutting_moment(Fc, geometry_dict.get(\"ze\"))\r\n        P = self.cutting_power(M, geometry_dict.get(\"ang_v\"))\r\n\r\n        res = dict([(\"cutting force\", Fc), (\"cutting moment\", M),\r\n                    (\"cutting power\", P)])\r\n        \r\n        return [Fc, M, P]\r\n\r\n    def angular_vel(self):\r\n        \"\"\"Calculate the tools angular velocity.\"\"\"\r\n        if self.check_process_param_dict():\r\n            return 2 * np.pi * self.process_params.get(\"n\")\r\n\r\n    def vc(self):\r\n        \"\"\"Calculate the cutting speed.\"\"\"\r\n        if self.check_process_param_dict():\r\n            return self.d * np.pi / self.process_params.get(\"n\")\r\n\r\n    def fz(self):\r\n        \"\"\"Calculate the feed per tooth.\"\"\"\r\n        if self.check_process_param_dict():\r\n            return self.process_params.get(\"feed_speed\") / \\\r\n                (self.process_params.get(\"n\") * self.z)\r\n\r\n    def sb(self, ang_phi):\r\n        \"\"\"Arc length of tooth in cutting operation.\"\"\"\r\n        if self.check_process_param_dict():\r\n            return self.d * ang_phi * 0.5\r\n\r\n    def ze(self, ang_phi):\r\n        \"\"\"Calculate the number of active teeth.\"\"\"\r\n        if self.check_process_param_dict():\r\n            return self.z * ang_phi / np.pi * 0.5\r\n\r\n    def ang_phi(self):\r\n        \"\"\"\r\n        Calculate angle of operation?.\r\n\r\n        Returns\r\n        -------\r\n        Angle of operation in radians.\r\n\r\n        \"\"\"\r\n        if self.check_process_param_dict():\r\n            h1 = self.process_params.get(\"ae\") - \\\r\n                self.process_params.get(\"protrusion\")\r\n            return np.arccos(1-2*h1/self.d) - \\\r\n                np.arccos(1-2*self.process_params.get(\"protrusion\")/self.d)\r\n\r\n    def hm(self, feed_per_tooth, cut_arc_length):\r\n        \"\"\"\r\n        Calculate medium chip thickness.\r\n\r\n        Parameters\r\n        ----------\r\n        feed_per_tooth : float\r\n            feed per tooth in meters/tooth.\r\n        cut_arc_length : floath\r\n            tooth active arc length in meters.\r\n\r\n        Returns\r\n        -------\r\n        None.\r\n\r\n        \"\"\"\r\n        if self.check_process_param_dict():\r\n            return feed_per_tooth * np.sin(self.ang_kap) * \\\r\n                self.process_params.get(\"ae\") / cut_arc_length\r\n\r\n    def Fc(self, medium_chip_thickness):\r\n        \"\"\"Calculate cutting force.\"\"\"\r\n        return self.process_params.get(\"kc05\") * \\\r\n            self.process_params.get(\"cw\") /\\\r\n            np.sin(self.ang_kap) * np.sqrt(medium_chip_thickness)\r\n\r\n    def cutting_moment(self, cutting_force, ze):\r\n        \"\"\"Moment of the cutting force acting on the motor.\"\"\"\r\n        return ze * cutting_force * self.d * 0.5\r\n\r\n    def cutting_power(self, moment, angular_vel):\r\n        \"\"\"Power of the cutting motor.\"\"\"\r\n        return moment * angular_vel\r\n','Prozesswerte Fräsen','diameter mm, num_teeth, ang_kappa °, ang_lambda ° - tool parameters, provided as process parameters\ncutting_width mm, depth_of_cut mm -\nkc05 N/mm^1,5, rpm, feed_speed m/min, length_wp cm, gap_wp cm, r_bend mm, n_motors for multiple\nreturns list of cutting force, moment, max power, and mean power -- accessible by index starting with 0'),
(60,21,'from statistics import mean\r\nfrom functools import lru_cache\r\n\r\n\r\n@lru_cache(200)\r\ndef target_func(coeff_a, coeff_b, coeff_c, coeff_d, coeff_e, coeff_f, coeff_g, pole_pairs, f_nominal, m_nominal, p_nominal, length, gap, f_load_abs, m_load_abs):\r\n    # coeff_a, coeff_b, coeff_c, coeff_d, coeff_e, coeff_f, coeff_g - efficiency coefficients of motor\r\n    # pole_pairs, f_nominal 1/min, m_nominal Nm, p_nominal W - number of pole pairs, nominal frequency, torque, and power of motor\r\n    # length cm, gap cm - length of workpiece and gap between workpieces\r\n    # f_load_abs 1/min, m_load_abs Nm - set rotation frequency, torque of process ; m can be list of equally to weight values (time resolved moment during load)\r\n    f_load = f_load_abs / f_nominal * pole_pairs / 60\r\n    f_idle = f_load\r\n    m_load = [load/m_nominal for load in m_load_abs] if type(m_load_abs) == list else m_load_abs / m_nominal\r\n    portion_load = length / (length + gap)\r\n    loss_load = mean([motor_loss(coeff_a, coeff_b, coeff_c, coeff_d, coeff_e, coeff_f, coeff_g, f_load, m) for m in m_load]) if type(m_load) == list else \\\r\n        motor_loss(coeff_a, coeff_b, coeff_c, coeff_d, coeff_e, coeff_f, coeff_g, f_load, m_load) \r\n    relative_loss = portion_load * loss_load + (1 - portion_load) * motor_loss(coeff_a, coeff_b, coeff_c, coeff_d, coeff_e, coeff_f, coeff_g, f_idle, 0)\r\n    return relative_loss * p_nominal\r\n\r\n\r\ndef motor_loss(coeff_a, coeff_b, coeff_c, coeff_d, coeff_e, coeff_f, coeff_g, f, m):\r\n    return coeff_a + coeff_b * f + coeff_c * f ** 2 + coeff_d * f * m ** 2 + coeff_e * f ** 2 * m ** 2 + coeff_f * m ** 2 + coeff_g * m\r\n\r\n\r\ndef motor_loss_eight(p_100_100, p_50_100, p_0_100, p_100_50, p_50_50, p_0_50, p_50_25, p_0_25, f_rel, m_rel):\r\n    f_z = f_rel * 100   # in %\r\n    m_z = m_rel * 100   # in %\r\n    if f_z < 50 and m_z < 50: # seg 3\r\n        return p_0_25 + f_z / 50 * (p_50_25 - p_0_25) + (m_z - 25) / 25 * (p_0_50 - p_0_25 + f_z / 50 * (p_50_50 - p_0_50 - p_50_25 + p_0_25))\r\n    if f_z < 50 and m_z >= 50: # seg 1\r\n        return p_0_50 + f_z / 50 * (p_50_50 - p_0_50) + (m_z - 50) / 50 * (p_0_100 - p_0_50 + f_z / 50 * (p_50_100 - p_0_100 - p_50_50 + p_0_50))\r\n    if f_z >= 50 and m_z < 50: # seg 4\r\n        return p_0_25 + f_z / 50 * (p_50_25 - p_0_25) + (m_z - 25) / 25 * (p_50_50 - p_0_25 + (f_z - 50) / 50 * (p_100_50 - p_50_50) - f_z / 50 * (p_50_25 - p_0_25))\r\n    if f_z >= 50 and m_z >= 50: # seg 2\r\n        return p_50_50 + (f_z - 50) * f_z / 50 * (p_100_50 - p_50_50) + (m_z - 50) / 50 * (p_50_100 - p_50_50 + (f_z - 50) / 50 * (p_100_100 - p_50_100 - p_100_50 + p_50_50))\r\n','Motorwärmeleistung','coeff_a, coeff_b, coeff_c, coeff_d, coeff_e, coeff_f, coeff_g - efficiency coefficients of motor\nf_nominal 1/min, m_nominal Nm, p_nominal W - nominal rotation frequency, torque, and power of motor\nlength cm, gap cm - length of workpiece and gap between workpieces\nf_load_abs 1/min, m_load_abs Nm - set rotation frequency, torque of process ; m can be list of equally to weight values (time resolved moment during load)'),
(61,21,'from statistics import mean\r\nfrom functools import lru_cache\r\n\r\n\r\n@lru_cache(200)\r\ndef target_func(p_90_100, p_50_100, p_0_100, p_90_50, p_50_50, p_0_50, p_50_25, p_0_25, p_nominal, f_nominal, length, gap, f_load_abs, m_load_abs, m_nominal_motor):\r\n    # p_x_y - relative efficieny values of motor\r\n    # f_nominal Hz, m_nominal Nm, p_nominal W - nominal rotation frequency, torque, and power of motor\r\n    # length cm, gap cm - length of workpiece and gap between workpieces\r\n    # f_load_abs 1/min, m_load_abs Nm - set rotation frequency, torque of process ; m can be list of equally to weight values (time resolved moment during load)\r\n    f_load = f_load_abs / f_nominal\r\n    f_idle = f_load\r\n    i_qz_load = [load/m_nominal_motor for load in m_load_abs] if type(m_load_abs) == list else m_load_abs / m_nominal_motor\r\n    portion_load = length / (length + gap)\r\n    loss_load = mean([converter_loss(p_90_100, p_50_100, p_0_100, p_90_50, p_50_50, p_0_50, p_50_25, p_0_25, f_load, i_qz_load) for m in i_qz_load]) if type(i_qz_load) == list else \\\r\n        converter_loss(p_90_100, p_50_100, p_0_100, p_90_50, p_50_50, p_0_50, p_50_25, p_0_25, f_load, i_qz_load) \r\n    relative_loss = portion_load * loss_load + (1 - portion_load) * converter_loss(p_90_100, p_50_100, p_0_100, p_90_50, p_50_50, p_0_50, p_50_25, p_0_25, f_idle, 0)\r\n    return relative_loss * p_nominal / 100\r\n\r\n\r\ndef converter_loss(p_90_100, p_50_100, p_0_100, p_90_50, p_50_50, p_0_50, p_50_25, p_0_25, f_rel, i_rel):\r\n    f_z = f_rel * 100   # in %\r\n    i_qz = i_rel * 100   # in %\r\n    if f_z < 50 and i_qz < 50: # seg 3\r\n        return p_0_25 + f_z / 50 * (p_50_25 - p_0_25) + (i_qz - 25) / 25 * (p_0_50 - p_0_25 + f_z / 50 * (p_50_50 - p_0_50 - p_50_25 + p_0_25))\r\n    if f_z < 50 and i_qz >= 50: # seg 1\r\n        return p_0_50 + f_z / 50 * (p_50_50 - p_0_50) + (i_qz - 50) / 50 * (p_0_100 - p_0_50 + f_z / 50 * (p_50_100 - p_0_100 - p_50_50 + p_0_50))\r\n    if f_z >= 50 and i_qz < 50: # seg 4\r\n        return p_0_25 + f_z / 50 * (p_50_25 - p_0_25) + (i_qz - 25) / 25 * (p_50_50 - p_0_25 + (f_z - 50) / 40 * (p_90_50 - p_50_50) - f_z / 50 * (p_50_25 - p_0_25))\r\n    if f_z >= 50 and i_qz >= 50: # seg 2\r\n        return p_50_50 + (f_z - 50) * f_z / 40 * (p_90_50 - p_50_50) + (i_qz - 50) / 50 * (p_50_100 - p_50_50 + (f_z - 50) / 40 * (p_90_100 - p_50_100 - p_90_50 + p_50_50))\r\n','Wärmeleistung Spannungswandler','p_x_y - relative efficieny values of motor\np_nominal W, f_nominal Hz - nominal power and rotation frequency of motor\nlength cm, gap cm - length of workpiece and gap between workpieces\nf_load_abs 1/min, m_load_abs Nm, m_nominal Nm - set rotation frequency, torque of process, and nominal torque of motor\n-- m_load_abs can be list of equally to weight values (time resolved moment during load)'),
(62,21,'from math import tan, radians\r\n\r\n\r\ndef target_func(v_feed, alpha, length, gap, width_band):\r\n    # v_feed m/min, alpha °, length cm, gap cm, width_band mm\r\n    # returns downward speed in m/min, load and idle time in arbitrary units\r\n    v_down = tan(radians(alpha)) * v_feed\r\n    t_total = (length + gap) / v_feed\r\n    t_load = width_band / v_down\r\n    t_idle = t_total - t_load\r\n    return [v_down, t_load, t_idle]\r\n','Hilfswerte Kappsäge','v_feed m/min, alpha °, length cm, gap cm, width_band mm\nreturns downward speed in m/min, load and idle time in arbitrary units'),
(63,21,'from math import sin, sqrt\n\n\ndef target_func(ang_kappa, kc05, feed_speed, cutting_width, depth_of_cut, length, gap):\n    # ang_kappa °, kc05 N/mm^1.5, feed_speed m /min, cutting_width mm, depth_of_cut mm,\n    # length workpiece cm, gap workpiece cm\n    power_load = feed_speed/60 * kc05*1000**1.5 * cutting_width/1000 * sqrt(depth_of_cut/1000) / sin(ang_kappa)\n    return length / (length + gap) * power_load\n','Ziehklingenleistung','ang_kappa °, kc05 N/mm^1.5, feed_speed m /min, cutting_width mm, depth_of_cut mm,\nlength workpiece cm, gap workpiece cm'),
(64,21,'from math import sqrt, cos, sin, atan\r\n\r\n\r\ndef target_func(a, mu, k_c, f_zero, v_feed, x_1, y_1, dx, x_3, y_3, length_band, length_wp, gap_wp):\r\n    v_feed_si = v_feed / 60\r\n    return process_power(a, mu, k_c, f_zero, v_feed_si, x_1, y_1, dx, x_3, y_3, length_band, length_wp, gap_wp)\r\n\r\n\r\ndef process_power(a, mu, k_c, f_zero, v_feed, x_1, y_1, dx, x_3, y_3, length_band, length_wp, gap_wp):	\r\n    s = spring_path(x_1, y_1, dx, x_3, y_3)\r\n    l = length_band * length_wp / (length_wp + gap_wp)  # l: summierte Laenge aller Werkstuecke im System\r\n    return (mu * s * k_c * l / a + f_zero) * v_feed\r\n	\r\n\r\ndef spring_path(x_1, y_1, dx, x_3, y_3):	# Federweg s\r\n    alpha = angle(x_1, y_1, dx)\r\n    return (sqrt(x_3 ** 2 + y_3 ** 2) * cos(alpha) ** 3 * (x_3 - sin(alpha) * sqrt(x_3 ** 2 + y_3 ** 2))) /\\\r\n            sqrt(x_1 ** 2 + y_1 ** 2 - (x_1 - dx) ** 2)\r\n\r\n\r\ndef angle(x_1, y_1, dx):\r\n    return atan((x_1 - dx) / sqrt(x_1 ** 2 + y_1 ** 2 - (x_1 - dx) ** 2))\r\n','Vorschubleistung','a Abstand Anpressrollen, mu Reibungskoeff. Band, k_c Federkonstante, f_zero Vorspannung Feder,\nv_feed Vorschubgeschw. m/min, x_1, y_1, dx, x_3, y_3, length_band, length_wp, gap_wp'),
(65,21,'from math import pi\r\n\r\n\r\ndef target_func(i_gears, eta, m_nominal, disc_diam, v_feed, process_pow):\r\n    v_feed_si = v_feed / 60\r\n    omega = dg(i_gears, v_feed_si, disc_diam)\r\n    m_process = process_moment(process_pow, omega)\r\n    m_gr = gear_moment(m_nominal, m_process, eta)\r\n    gl = gear_loss(m_gr, omega)\r\n    total_moment = moment_feed_system(m_gr, m_process)\r\n    return [gl, total_moment, omega * 30 / pi, m_process]\r\n\r\n\r\ndef gear_loss(m_gr, omega):\r\n    return m_gr * omega\r\n\r\n\r\ndef moment_feed_system(m_g, m_process):	\r\n    return m_g + m_process\r\n\r\n\r\ndef gear_moment(m_nominal, m_process, eta):		# oben berechnete Prozessleistung muss für m_process durch die Ausgangsdrehzahl des Getriebes geteilt werden, Drehzahl aus Vorschubgeschwindkeit und Durchmesser der Scheibe (ebenfalls als Prozessparameter anzugeben)\r\n    return (1 - eta) / eta * (0.6 * m_nominal + 0.4 * m_process)\r\n\r\n\r\ndef process_moment(process_pow, omega):\r\n    return process_pow / omega\r\n\r\n\r\ndef dg(i_gears, v_feed, disc_diam):\r\n    f = omega_abtrieb(v_feed, disc_diam)\r\n    return i_gears * f\r\n\r\n\r\ndef omega_abtrieb(v_feed, d):\r\n    return 2 * v_feed / d\r\n','Getriebewerte','i_gears Uebersetzung Getriebe, eta Getriebewirkungsgrad, m_nominal Nennmoment Getriebe Nm,\r\ndisc_diam m, v_feed Vorschub m/min, process_pow\r\nreturns gear_loss, total moment of feed system, input rotation rate 1/min and process moment'),
(66,21,'def target_func(lamb, a, d):\r\n    return lamb * a * 180 / d / 0.993\r\n','Heizleistung Verleimaggregat','# lambda: specific thermal conductivity W/m/K\r\n# a, d: surface, thickness glue compartment');
/*!40000 ALTER TABLE `loss_functions` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `material_properties`
--

DROP TABLE IF EXISTS `material_properties`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `material_properties` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `property` varchar(40) NOT NULL,
  `unit` varchar(20) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `material_properties`
--

LOCK TABLES `material_properties` WRITE;
/*!40000 ALTER TABLE `material_properties` DISABLE KEYS */;
INSERT INTO `material_properties` VALUES
(1,'Dichte','g/cm^3'),
(2,'Schnittkraftkonstante k_c0,5','N/mm^1,5'),
(7,'Brinellhärte','N/mm^2');
/*!40000 ALTER TABLE `material_properties` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `process_parameters`
--

DROP TABLE IF EXISTS `process_parameters`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `process_parameters` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `processes_id` int(11) NOT NULL,
  `name` varchar(30) NOT NULL,
  `unit` varchar(15) NOT NULL,
  `general` tinyint(1) NOT NULL,
  `variable_name` varchar(30) NOT NULL,
  `defaults` varchar(30) NOT NULL,
  `material_properties_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `processes_parameters` (`processes_id`),
  KEY `process_parameters_properties` (`material_properties_id`),
  CONSTRAINT `process_parameters_properties` FOREIGN KEY (`material_properties_id`) REFERENCES `material_properties` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `processes_parameters` FOREIGN KEY (`processes_id`) REFERENCES `processes` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=213 DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `process_parameters`
--

LOCK TABLES `process_parameters` WRITE;
/*!40000 ALTER TABLE `process_parameters` DISABLE KEYS */;
INSERT INTO `process_parameters` VALUES
(1,1,'Werkstückdicke','mm',0,'p_part_width','',NULL),
(2,1,'Werkstücklänge','cm',0,'p_part_length','',NULL),
(3,1,'Fräsbreite','mm',0,'p_milling_width','',NULL),
(4,1,'Frästiefe','mm',0,'p_milling_depth','',NULL),
(5,1,'Spez. Schnittkraft','N/mm^1,5',0,'p_k_c05','',2),
(6,1,'Zähne Kappsäge','',1,'p_teeth_clipping','12,16,20',NULL),
(166,21,'Vorschubgeschwindigkeit','m / min',0,'p_feed_speed','',NULL),
(167,21,'Werkstückdicke','mm',0,'p_width','',NULL),
(168,21,'Werkstücklänge','cm',0,'p_length','',NULL),
(169,21,'Breite Kantenband','mm',0,'p_width_band','',NULL),
(170,21,'Dicke Kantenband','mm',0,'p_thickness_band','',NULL),
(171,21,'Werkstücklücke','cm',0,'p_gap','',NULL),
(172,21,'Abnutzungsfaktor Fräsen','',0,'p_wear_factor','1',NULL),
(173,21,'Spez. Schnittkraftkonstante','N/mm^1.5',0,'p_kc05','',2),
(174,21,'Spez. Schnittkraftkonst. Band','N/mm^1.5',0,'p_kc05_band','',2),
(175,21,'Zahnzahl Vorfräse','',0,'p_pre_teeth','3',NULL),
(176,21,'Frästiefe Vorfräse','mm',0,'p_pre_depth','3',NULL),
(177,21,'Winkel kappa Vorfräse','°',0,'p_pre_ang_kappa','90',NULL),
(178,21,'Winkel lambda Vorfräse','°',0,'p_pre_ang_lambda','65',NULL),
(179,21,'Drehzahl Vorfräse','1/min',0,'p_pre_n','9000',NULL),
(180,21,'Werkzeugdurchm. Vorfräse','mm',0,'p_pre_diameter','125',NULL),
(181,21,'Zahnzahl Kappsäge','',0,'p_trim_teeth','24',NULL),
(182,21,'Winkel kappa Kappsäge','°',0,'p_trim_ang_kappa','65',NULL),
(183,21,'Winkel lambda Kappsäge','°',0,'p_trim_ang_lambda','5',NULL),
(184,21,'Drehzahl Kappsäge','1/min',0,'p_trim_n','11400',NULL),
(185,21,'Werkzeugdurchm. Kappsäge','mm',0,'p_trim_diameter','120',NULL),
(186,21,'Blattdicke Kappsäge','mm',0,'p_trim_width','3.2',NULL),
(187,21,'Winkel Führung Kappsäge','°',1,'p_trim_angle','40',NULL),
(188,21,'Zahnzahl Bündigfräser','',0,'p_flush_teeth','3',NULL),
(189,21,'Winkel kappa Bündigfräser','°',0,'p_flush_ang_kappa','90',NULL),
(190,21,'Winkel lambda Bündigfräser','°',0,'p_flush_ang_lambda','65',NULL),
(191,21,'Drehzahl Bündigfräse','1/min',0,'p_flush_n','8700',NULL),
(192,21,'Werkzeugdurchm. Bündigfräser','mm',0,'p_flush_diameter','80',NULL),
(193,21,'Zahnzahl Radienfräser','',0,'p_round_teeth','4',NULL),
(194,21,'Fräsradius Radienfräser','mm',0,'p_round_radius','',NULL),
(195,21,'Werkzeugdurchm. Radienfräser','mm',0,'p_round_diameter','125',NULL),
(196,21,'Einstellwinkel Ziehklinge','°',1,'p_scraper_ang','90',NULL),
(197,21,'Eingriff Ziehklinge','mm',1,'p_scraper_depth','0.2',NULL),
(198,21,'Spannfederpunkt x1','m',1,'p_feed_x1','0.0436',NULL),
(199,21,'Spannfederpunkt y1','m',1,'p_feed_y1','0.072',NULL),
(200,21,'Spannfederpunkt x3','m',1,'p_feed_x3','0.01695',NULL),
(201,21,'Spannfederpunkt y3','m',1,'p_feed_y3','0.028',NULL),
(202,21,'Federkonstante Spannfedern','N/m',1,'p_feed_kc','49660',NULL),
(203,21,'Reibungskoeffizient Förderband','',1,'p_feed_mu','6',NULL),
(204,21,'Transferbandlänge','m',1,'p_feed_l','6.5',NULL),
(205,21,'Abstand Band-Federelemente','m',1,'p_feed_spring_dist','0.07',NULL),
(206,21,'Spannweg Werkstück','m',1,'p_feed_delta_x','0.004',NULL),
(207,21,'Vorspannung Band-Spannfeder','N',1,'p_feed_f0','200',NULL),
(208,21,'Durchmesser Riemenscheiben','m',1,'p_feed_disc_diam','0.2',NULL),
(209,21,'Drehzahl Radienfräser','1/min',0,'p_round_n','8700',NULL),
(210,21,'Wäremeleit. Klebstoffbehälter','W/m/K',1,'p_glue_conductivity','0.65',NULL),
(211,21,'Oberfläche Klebstoffbehälter','m^2',1,'p_glue_surface','0.5',NULL),
(212,21,'Wanddicke Klebstoffbehälter','m',1,'p_glue_d','0.075',NULL);
/*!40000 ALTER TABLE `process_parameters` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `process_solvers`
--

DROP TABLE IF EXISTS `process_solvers`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `process_solvers` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `processes_id` int(11) NOT NULL,
  `code` mediumtext DEFAULT NULL,
  `use_solver` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `processes_processsolvers` (`processes_id`),
  CONSTRAINT `processes_processsolvers` FOREIGN KEY (`processes_id`) REFERENCES `processes` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `process_solvers`
--

LOCK TABLES `process_solvers` WRITE;
/*!40000 ALTER TABLE `process_solvers` DISABLE KEYS */;
INSERT INTO `process_solvers` VALUES
(1,1,'import copy\r\nimport time\r\n\r\n\r\ndef call_solver(loss_func, model, data):\r\n    solver = ProblemSolver(loss_func, model, data)\r\n    return solver.solve()\r\n\r\n\r\nclass ProblemSolver:\r\n\r\n    def __init__(self, loss_func, model, data):\r\n        self.loss_func = loss_func\r\n        self.model = model\r\n        self.data = data\r\n        self.cl = {}\r\n        self.weighted_losses = {}\r\n        self.indices = {}\r\n        self.opts = []\r\n        self.cost_opts = []\r\n        self.selects = 0\r\n        self.satisfied = 0\r\n        self.timing = 0.0\r\n        self.deepest_failed_restriction = {\'depth\': 0, \'restriction\': \'\'}\r\n        self.parameters = {}\r\n        for general_key in model[\'general_parameters\']:\r\n            self.parameters[general_key] = model[\"general_parameters\"][general_key]\r\n\r\n    def solve(self):\r\n        tic = time.perf_counter()\r\n        components = self.model[\'components\']\r\n        self.update_losses({}, 0)\r\n        self.wander_tree(1, components, {})\r\n        print(\'selected\')\r\n        print(self.selects)\r\n        print(\'satisfied\')\r\n        print(self.satisfied)\r\n        self.timing += time.perf_counter() - tic\r\n        print(\'timing\')\r\n        print(self.timing)\r\n        return self.opts, self.cost_opts, self.deepest_failed_restriction, \'no special remarks\'\r\n\r\n    def wander_tree(self, depth, components, combination):\r\n        current_comp_type = self.data[components[0][\'component_api_name\']]\r\n        # print(\'wander_tree - \' + str(depth))\r\n        # select new component\r\n        for index, comp in enumerate(current_comp_type):\r\n            var_name = components[0][\'variable_name\']\r\n            self.indices[var_name] = index\r\n            new_combination = {**combination, var_name: comp}\r\n            self.selects += 1\r\n            cd = self.conditions_satisfied(new_combination, depth)\r\n            if cd:\r\n                self.update_losses(new_combination, depth)\r\n                # recursive decision\r\n                if len(components) > 1:\r\n                    new_components = copy.copy(components)\r\n                    new_components.pop(0)\r\n                    self.wander_tree(depth + 1, new_components, new_combination)\r\n                else:\r\n                    self.summarize_and_check_results(new_combination)\r\n\r\n    def update_losses(self, combinations, depth):\r\n        lfs = self.loss_func\r\n        if depth > 0:\r\n            self.satisfied += 1\r\n        # unpack variables\r\n        p = self.parameters\r\n        # eval losses to evaluated after newly selected component\r\n        for lf in self.model[\'loss_functions\']:\r\n            if lf[\'eval_after_position\'] == depth:\r\n                exec(\'self.cl[\"\' + lf[\'variable_name\'] + \'\"] = []\')  # reset loss list\r\n                for pos in range(len(self.model[\'process_profiles\'])):\r\n                    for parameter_key in self.model[\'process_profiles\'][pos].keys():\r\n                        p[parameter_key] = self.model[\"process_profiles\"][pos][parameter_key]\r\n                    # unpack previously evaluated losses\r\n                    l = {}\r\n                    for current_losses_key in self.cl.keys():\r\n                        if current_losses_key != lf[\'variable_name\']:\r\n                            l[current_losses_key] = self.cl[current_losses_key][pos]\r\n                    # eval current loss\r\n                    # print(\'EXEC \' + lf[\'variable_name\'] + \' = \' + lf[\'function_call\'])\r\n                    exec(lf[\'variable_name\'] + \' = \' + lf[\'function_call\'])\r\n                    # ToDo: view group\r\n                    # pack current loss for deeper levels\r\n                    exec(\'self.cl[\"\' + lf[\'variable_name\'] + \'\"].append(\' + lf[\'variable_name\'] + \')\')\r\n\r\n    def conditions_satisfied(self, combinations, depth):\r\n        # noinspection DuplicatedCode\r\n        p = self.parameters\r\n        # check request conditions\r\n        for pos in range(len(self.model[\'process_profiles\'])):  # conditions have to be fulfilled for all profiles\r\n            for parameter_key in self.model[\'process_profiles\'][pos].keys():\r\n                p[parameter_key] = self.model[\"process_profiles\"][pos][parameter_key]\r\n            l = {}\r\n            for current_losses_key in self.cl.keys():\r\n                l[current_losses_key] = self.cl[current_losses_key][pos]\r\n            for cond in self.model[\'conditions\']:\r\n                try:\r\n                    result = eval(cond)\r\n                    if not result:\r\n                        # print(\'Condition evaluated to False: \' + cond)\r\n                        return False\r\n                except NameError as ex:  # conditions with missing vars have to be evaluated at a deeper level\r\n                    pass    # print(\'Condition parameter not defined: \' + ex.args[0])\r\n            # check implicit conditions\r\n            for restr in self.model[\'restrictions\']:\r\n                if depth == restr[\'eval_after_position\']:\r\n                    try:\r\n                        result = eval(restr[\'restriction\'])\r\n                        if not result:\r\n                            if depth > self.deepest_failed_restriction[\'depth\']:\r\n                                self.deepest_failed_restriction[\'depth\'] = depth\r\n                                self.deepest_failed_restriction[\'restriction\'] = restr[\'description\']\r\n                            return False\r\n                    except NameError as ex:\r\n                        print(\'Condition parameter not defined: \' + ex.args[0])\r\n        return True\r\n\r\n    def summarize_and_check_results(self, combination):\r\n        # new part\r\n        total = self.sum_losses()\r\n        # costs optimization\r\n        acquisition_costs = self.update_cost_opts(combination, total) if self.model[\'result_settings\'][\'costs_opt\'][\r\n            \'exec\'] else None\r\n        # sort current combination in optimal solutions\r\n        self.update_opts(total, acquisition_costs)\r\n\r\n    def sum_losses(self):\r\n        total = 0\r\n        for current_losses_key in self.cl.keys():\r\n            if self.function_is_loss(current_losses_key):\r\n                self.weighted_losses[current_losses_key] = sum(clk * profile[\'portion\'] / 1000. for clk, profile     # to kWh\r\n                                                               in zip(self.cl[current_losses_key], self.model[\'process_profiles\']))\r\n                total += self.weighted_losses[current_losses_key]\r\n        return total\r\n\r\n    def update_cost_opts(self, combination, total):\r\n        acquisition_costs = sum(comp[\'price\'] for comp in combination.values()) + self.model[\'result_settings\'][\'costs_opt\'][\'assembly_costs\']\r\n        energy_costs = total * self.model[\'result_settings\'][\'costs_opt\'][\'price_kwh\'] * self.model[\'result_settings\'][\'costs_opt\'][\'amortisation_time\']\r\n        inserted = False\r\n        for pos, old_opt in enumerate(self.cost_opts):\r\n            if old_opt[\'total_costs\'] > acquisition_costs + energy_costs:\r\n                self.cost_opts.insert(pos, self.build_cost_opt(total, acquisition_costs, energy_costs))\r\n                inserted = True\r\n                if len(self.cost_opts) > int(self.model[\'result_settings\'][\'n_list\']):\r\n                    self.cost_opts.pop()\r\n                break\r\n        if len(self.cost_opts) < int(self.model[\'result_settings\'][\'n_list\']) and not inserted:\r\n            self.cost_opts.append(self.build_cost_opt(total, acquisition_costs, energy_costs))\r\n        return acquisition_costs\r\n\r\n    def build_cost_opt(self, total, acquisition_costs, energy_costs):\r\n        return {\'total_costs\': acquisition_costs + energy_costs,\r\n                \'acquisition_costs\': acquisition_costs,\r\n                \'energy_costs\': energy_costs,\r\n                \'total\': total,\r\n                \'partials\': {val[1]: {\'value\': val[0], \'aggregate\': val[2]} for val in\r\n                             self.partial_generator()},\r\n                \'indices\': copy.copy(self.indices)}\r\n\r\n    def update_opts(self, total, acquisition_costs):\r\n        inserted = False\r\n        for pos, old_opt in enumerate(self.opts):\r\n            if old_opt[\'total\'] > total:\r\n                self.opts.insert(pos, self.build_opt(total, acquisition_costs))\r\n                inserted = True\r\n                if len(self.opts) > int(self.model[\'result_settings\'][\'n_list\']):\r\n                    self.opts.pop()\r\n                break\r\n        if len(self.opts) < int(self.model[\'result_settings\'][\'n_list\']) and not inserted:\r\n            self.opts.append(self.build_opt(total, acquisition_costs))\r\n\r\n    def build_opt(self, total, acquisition_costs):\r\n        return {\'acquisition_costs\': acquisition_costs,\r\n                \'total\': round(total),\r\n                \'partials\': {val[1]: {\'value\': round(val[0]), \'aggregate\': val[2]} for val in\r\n                             self.partial_generator()},\r\n                \'indices\': copy.copy(self.indices)}\r\n\r\n    def description_and_aggregate_from_variable(self, var):\r\n        function_by_var = next(lf for lf in self.model[\'loss_functions\'] if lf[\'variable_name\'] == var)\r\n        return [function_by_var[\'description\'], function_by_var[\'aggregate\']]\r\n\r\n    def function_is_loss(self, var):\r\n        return all(lf[\'is_loss\'] for lf in self.model[\'loss_functions\'] if lf[\'variable_name\'] == var)\r\n\r\n    def partial_generator(self):\r\n        for key in self.weighted_losses.keys():\r\n            yield [self.weighted_losses[key]] + self.description_and_aggregate_from_variable(key)\r\n',0),
(9,21,'',0);
/*!40000 ALTER TABLE `process_solvers` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `process_sources`
--

DROP TABLE IF EXISTS `process_sources`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `process_sources` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `processes_id` int(11) NOT NULL,
  `request` mediumtext NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `process_sources`
--

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

--
-- Table structure for table `processes`
--

DROP TABLE IF EXISTS `processes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `processes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `view_name` varchar(40) NOT NULL,
  `api_name` varchar(30) NOT NULL,
  `variant_tree` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `processes`
--

LOCK TABLES `processes` WRITE;
/*!40000 ALTER TABLE `processes` DISABLE KEYS */;
INSERT INTO `processes` VALUES
(1,'Test','test',1),
(21,'KAM','edge_banding',0);
/*!40000 ALTER TABLE `processes` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `property_values`
--

DROP TABLE IF EXISTS `property_values`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `property_values` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `material_properties_id` int(11) NOT NULL,
  `value` double NOT NULL,
  `material` varchar(40) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `properties_values` (`material_properties_id`),
  CONSTRAINT `properties_values` FOREIGN KEY (`material_properties_id`) REFERENCES `material_properties` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `property_values`
--

LOCK TABLES `property_values` WRITE;
/*!40000 ALTER TABLE `property_values` DISABLE KEYS */;
INSERT INTO `property_values` VALUES
(1,2,22.5,'MDF'),
(2,2,15,'Spanplatte'),
(3,2,33,'Buche'),
(4,2,33,'Eiche'),
(5,1,0.68,'Buche'),
(6,1,0.65,'Eiche'),
(8,7,34,'Buche'),
(11,7,34,'Eiche');
/*!40000 ALTER TABLE `property_values` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `requests`
--

DROP TABLE IF EXISTS `requests`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `requests` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `processes_id` int(11) NOT NULL,
  `timestamp` varchar(19) NOT NULL,
  `status` tinyint(4) NOT NULL,
  `request` text NOT NULL,
  `result` text NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `requests_timestamp` (`timestamp`),
  KEY `requests_processes_index` (`processes_id`),
  CONSTRAINT `requests_processes` FOREIGN KEY (`processes_id`) REFERENCES `processes` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=283 DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `requests`
--

LOCK TABLES `requests` WRITE;
/*!40000 ALTER TABLE `requests` DISABLE KEYS */;
INSERT INTO `requests` VALUES
(275,21,'2023-06-26_14-23-48',-1,'{\"description\": \"KAM - 26.6.2023, 14:23:46\", \"result_settings\": {\"n_list\": 3, \"costs_opt\": {\"exec\": false, \"price_kwh\": 0.23, \"amortisation_time\": 2, \"assembly_costs\": 10000}}, \"process\": {\"id\": 21, \"api_name\": \"edge_banding\", \"view_name\": \"KAM\"}, \"general_parameters\": {\"p_trim_angle\": 0, \"p_scraper_ang\": 90, \"p_scraper_depth\": 0.2, \"p_feed_x1\": 0.0436, \"p_feed_y1\": 0.072, \"p_feed_x3\": 0.01695, \"p_feed_y3\": 0.028, \"p_feed_kc\": 49660, \"p_feed_mu\": 6, \"p_feed_l\": 6.5, \"p_feed_spring_dist\": 0.07, \"p_feed_delta_x\": 0.004, \"p_feed_f0\": 200, \"p_feed_disc_diam\": 0.2, \"p_glue_conductivity\": 0.65, \"p_glue_surface\": 0.5, \"p_glue_d\": 0.075}, \"process_profiles\": [{\"p_feed_speed\": 15, \"p_width\": 20, \"p_length\": 90, \"p_width_band\": 24, \"p_thickness_band\": 2, \"p_gap\": 40, \"p_wear_factor\": 1, \"p_kc05\": 15, \"p_kc05_band\": 22.5, \"p_pre_teeth\": 3, \"p_pre_depth\": 3, \"p_pre_ang_kappa\": 90, \"p_pre_ang_lambda\": 65, \"p_pre_n\": 9000, \"p_pre_diameter\": 125, \"p_trim_teeth\": 24, \"p_trim_ang_kappa\": 65, \"p_trim_ang_lambda\": 5, \"p_trim_n\": 11400, \"p_trim_diameter\": 120, \"p_trim_width\": 3, \"p_flush_teeth\": 3, \"p_flush_ang_kappa\": 90, \"p_flush_ang_lambda\": 65, \"p_flush_n\": 8700, \"p_flush_diameter\": 80, \"p_round_teeth\": 4, \"p_round_radius\": 3, \"p_round_diameter\": 125, \"p_round_n\": 8700, \"portion\": 1000}], \"variants_conditions\": [{\"id\": 38, \"name\": \"Var 1\", \"conditions\": []}]}','{\"status\": \"failed\", \"message\": \"Error in evaluating function Kapps\\u00e4genwerte - \\\"lfs[62](p[\'p_feed_speed\'], p[\'p_trim_angle\'], p[\'p_length\'], p[\'p_gap\'], p[\'p_width_band\'])\\\", error: float division by zero\"}'),
(276,21,'2023-06-30_12-20-01',-1,'{\"description\": \"KAM - 30.6.2023, 12:20:00\", \"result_settings\": {\"n_list\": 3, \"costs_opt\": {\"exec\": false, \"price_kwh\": 0.23, \"amortisation_time\": 2, \"assembly_costs\": 10000}}, \"process\": {\"id\": 21, \"api_name\": \"edge_banding\", \"view_name\": \"KAM\"}, \"general_parameters\": {\"p_trim_angle\": 0, \"p_scraper_ang\": 90, \"p_scraper_depth\": 0.2, \"p_feed_x1\": 0.0436, \"p_feed_y1\": 0.072, \"p_feed_x3\": 0.01695, \"p_feed_y3\": 0.028, \"p_feed_kc\": 49660, \"p_feed_mu\": 6, \"p_feed_l\": 6.5, \"p_feed_spring_dist\": 0.07, \"p_feed_delta_x\": 0.004, \"p_feed_f0\": 200, \"p_feed_disc_diam\": 0.2, \"p_glue_conductivity\": 0.65, \"p_glue_surface\": 0.5, \"p_glue_d\": 0.075}, \"process_profiles\": [{\"p_feed_speed\": 10, \"p_width\": 20, \"p_length\": 90, \"p_width_band\": 22, \"p_thickness_band\": 2, \"p_gap\": 40, \"p_wear_factor\": 1, \"p_kc05\": 22.5, \"p_kc05_band\": 33, \"p_pre_teeth\": 3, \"p_pre_depth\": 3, \"p_pre_ang_kappa\": 90, \"p_pre_ang_lambda\": 65, \"p_pre_n\": 9000, \"p_pre_diameter\": 125, \"p_trim_teeth\": 24, \"p_trim_ang_kappa\": 65, \"p_trim_ang_lambda\": 5, \"p_trim_n\": 11400, \"p_trim_diameter\": 120, \"p_trim_width\": 3, \"p_flush_teeth\": 3, \"p_flush_ang_kappa\": 90, \"p_flush_ang_lambda\": 65, \"p_flush_n\": 8700, \"p_flush_diameter\": 80, \"p_round_teeth\": 4, \"p_round_radius\": 3, \"p_round_diameter\": 125, \"p_round_n\": 8700, \"portion\": 12000}], \"variants_conditions\": [{\"id\": 38, \"name\": \"Var 1\", \"conditions\": []}]}','{\"status\": \"failed\", \"message\": \"Error in evaluating function Kapps\\u00e4genwerte - \\\"lfs[62](p[\'p_feed_speed\'], p[\'p_trim_angle\'], p[\'p_length\'], p[\'p_gap\'], p[\'p_width_band\'])\\\", error: float division by zero\"}'),
(277,21,'2023-07-09_16-12-34',-1,'{\"description\": \"KAM - 9.7.2023, 16:12:33\", \"result_settings\": {\"n_list\": 3, \"costs_opt\": {\"exec\": false, \"price_kwh\": 0.23, \"amortisation_time\": 2, \"assembly_costs\": 10000}}, \"process\": {\"id\": 21, \"api_name\": \"edge_banding\", \"view_name\": \"KAM\"}, \"general_parameters\": {\"p_trim_angle\": 0, \"p_scraper_ang\": 90, \"p_scraper_depth\": 0.2, \"p_feed_x1\": 0.0436, \"p_feed_y1\": 0.072, \"p_feed_x3\": 0.01695, \"p_feed_y3\": 0.028, \"p_feed_kc\": 49660, \"p_feed_mu\": 6, \"p_feed_l\": 6.5, \"p_feed_spring_dist\": 0.07, \"p_feed_delta_x\": 0.004, \"p_feed_f0\": 200, \"p_feed_disc_diam\": 0.2, \"p_glue_conductivity\": 0.65, \"p_glue_surface\": 0.5, \"p_glue_d\": 0.075}, \"process_profiles\": [{\"p_feed_speed\": 20, \"p_width\": 20, \"p_length\": 90, \"p_width_band\": 22, \"p_thickness_band\": 2, \"p_gap\": 40, \"p_wear_factor\": 1, \"p_kc05\": 15, \"p_kc05_band\": 22.5, \"p_pre_teeth\": 3, \"p_pre_depth\": 3, \"p_pre_ang_kappa\": 90, \"p_pre_ang_lambda\": 65, \"p_pre_n\": 9000, \"p_pre_diameter\": 125, \"p_trim_teeth\": 24, \"p_trim_ang_kappa\": 65, \"p_trim_ang_lambda\": 5, \"p_trim_n\": 11400, \"p_trim_diameter\": 120, \"p_trim_width\": 3, \"p_flush_teeth\": 3, \"p_flush_ang_kappa\": 90, \"p_flush_ang_lambda\": 65, \"p_flush_n\": 8700, \"p_flush_diameter\": 80, \"p_round_teeth\": 4, \"p_round_radius\": 2, \"p_round_diameter\": 125, \"p_round_n\": 8700, \"portion\": 1000}], \"variants_conditions\": [{\"id\": 38, \"name\": \"Var 1\", \"conditions\": []}]}','{\"status\": \"failed\", \"message\": \"\'list\' object has no attribute \'startswith\'\"}'),
(278,21,'2023-07-09_16-16-10',-1,'{\"description\": \"KAM - 9.7.2023, 16:16:09\", \"result_settings\": {\"n_list\": 3, \"costs_opt\": {\"exec\": false, \"price_kwh\": 0.23, \"amortisation_time\": 2, \"assembly_costs\": 10000}}, \"process\": {\"id\": 21, \"api_name\": \"edge_banding\", \"view_name\": \"KAM\"}, \"general_parameters\": {\"p_trim_angle\": 0, \"p_scraper_ang\": 90, \"p_scraper_depth\": 0.2, \"p_feed_x1\": 0.0436, \"p_feed_y1\": 0.072, \"p_feed_x3\": 0.01695, \"p_feed_y3\": 0.028, \"p_feed_kc\": 49660, \"p_feed_mu\": 6, \"p_feed_l\": 6.5, \"p_feed_spring_dist\": 0.07, \"p_feed_delta_x\": 0.004, \"p_feed_f0\": 200, \"p_feed_disc_diam\": 0.2, \"p_glue_conductivity\": 0.65, \"p_glue_surface\": 0.5, \"p_glue_d\": 0.075}, \"process_profiles\": [{\"p_feed_speed\": 20, \"p_width\": 20, \"p_length\": 90, \"p_width_band\": 22, \"p_thickness_band\": 2, \"p_gap\": 50, \"p_wear_factor\": 1, \"p_kc05\": 22.5, \"p_kc05_band\": 33, \"p_pre_teeth\": 3, \"p_pre_depth\": 3, \"p_pre_ang_kappa\": 90, \"p_pre_ang_lambda\": 65, \"p_pre_n\": 9000, \"p_pre_diameter\": 125, \"p_trim_teeth\": 24, \"p_trim_ang_kappa\": 65, \"p_trim_ang_lambda\": 5, \"p_trim_n\": 11400, \"p_trim_diameter\": 120, \"p_trim_width\": 3, \"p_flush_teeth\": 3, \"p_flush_ang_kappa\": 90, \"p_flush_ang_lambda\": 65, \"p_flush_n\": 8700, \"p_flush_diameter\": 80, \"p_round_teeth\": 4, \"p_round_radius\": 3, \"p_round_diameter\": 125, \"p_round_n\": 8700, \"portion\": 1000}], \"variants_conditions\": [{\"id\": 38, \"name\": \"Var 1\", \"conditions\": []}]}','{\"status\": \"failed\", \"message\": \"Error in evaluating function Kapps\\u00e4genwerte - \\\"lfs[62](p[\'p_feed_speed\'], p[\'p_trim_angle\'], p[\'p_length\'], p[\'p_gap\'], p[\'p_width_band\'])\\\"; passed parameters: p_feed_speed=20, p_trim_angle=0, p_length=90, p_gap=50, p_width_band=22; error: float division by zero\"}'),
(279,21,'2023-07-09_22-02-24',-1,'{\"description\": \"KAM - 9.7.2023, 22:02:23\", \"result_settings\": {\"n_list\": 3, \"costs_opt\": {\"exec\": false, \"price_kwh\": 0.23, \"amortisation_time\": 2, \"assembly_costs\": 10000}}, \"process\": {\"id\": 21, \"api_name\": \"edge_banding\", \"view_name\": \"KAM\"}, \"general_parameters\": {\"p_trim_angle\": 40, \"p_scraper_ang\": 90, \"p_scraper_depth\": 0.2, \"p_feed_x1\": 0.0436, \"p_feed_y1\": 0.072, \"p_feed_x3\": 0.01695, \"p_feed_y3\": 0.028, \"p_feed_kc\": 49660, \"p_feed_mu\": 6, \"p_feed_l\": 6.5, \"p_feed_spring_dist\": 0.07, \"p_feed_delta_x\": 0.004, \"p_feed_f0\": 200, \"p_feed_disc_diam\": 0.2, \"p_glue_conductivity\": 0.65, \"p_glue_surface\": 0.5, \"p_glue_d\": 0.075}, \"process_profiles\": [{\"p_feed_speed\": null, \"p_width\": 20, \"p_length\": 90, \"p_width_band\": 0, \"p_thickness_band\": 0, \"p_gap\": 40, \"p_wear_factor\": 1, \"p_kc05\": 22.5, \"p_kc05_band\": 33, \"p_pre_teeth\": 3, \"p_pre_depth\": 3, \"p_pre_ang_kappa\": 90, \"p_pre_ang_lambda\": 65, \"p_pre_n\": 9000, \"p_pre_diameter\": 125, \"p_trim_teeth\": 24, \"p_trim_ang_kappa\": 65, \"p_trim_ang_lambda\": 5, \"p_trim_n\": 11400, \"p_trim_diameter\": 120, \"p_trim_width\": 3, \"p_flush_teeth\": 3, \"p_flush_ang_kappa\": 90, \"p_flush_ang_lambda\": 65, \"p_flush_n\": 8700, \"p_flush_diameter\": 80, \"p_round_teeth\": 4, \"p_round_radius\": 3, \"p_round_diameter\": 125, \"p_round_n\": 8700, \"portion\": 1200}], \"variants_conditions\": [{\"id\": 38, \"name\": \"Var 1\", \"conditions\": []}]}','{\"status\": \"failed\", \"message\": \"Error in evaluating function Fr\\u00e4swerte Vorfr\\u00e4sen - \\\"lfs[59](p[\'p_pre_diameter\'], p[\'p_pre_teeth\'], p[\'p_pre_ang_kappa\'], p[\'p_pre_ang_lambda\'], p[\'p_width\'], p[\'p_pre_depth\'], p[\'p_kc05\'], p[\'p_pre_n\'], p[\'p_feed_speed\'], p[\'p_length\'], p[\'p_gap\'], 0, 1)\\\"; passed parameters: p_pre_diameter=125, p_pre_teeth=3, p_pre_ang_kappa=90, p_pre_ang_lambda=65, p_width=20, p_pre_depth=3, p_kc05=22.5, p_pre_n=9000, p_feed_speed=None, p_length=90, p_gap=40; error: unsupported operand type(s) for /: \'NoneType\' and \'int\'\"}'),
(282,21,'2023-07-09_22-40-07',2,'{\"description\": \"KAM - 9.7.2023, 22:09:11\", \"result_settings\": {\"n_list\": \"5\", \"costs_opt\": {\"exec\": false, \"price_kwh\": 0.23, \"amortisation_time\": 2, \"assembly_costs\": 10000}}, \"process\": {\"id\": 21, \"api_name\": \"edge_banding\", \"view_name\": \"KAM\"}, \"general_parameters\": {\"p_trim_angle\": 40, \"p_scraper_ang\": 90, \"p_scraper_depth\": 0.2, \"p_feed_x1\": 0.0436, \"p_feed_y1\": 0.072, \"p_feed_x3\": 0.01695, \"p_feed_y3\": 0.028, \"p_feed_kc\": 49660, \"p_feed_mu\": 6, \"p_feed_l\": 6.5, \"p_feed_spring_dist\": 0.07, \"p_feed_delta_x\": 0.004, \"p_feed_f0\": 200, \"p_feed_disc_diam\": 0.2, \"p_glue_conductivity\": 0.65, \"p_glue_surface\": 0.5, \"p_glue_d\": 0.075}, \"process_profiles\": [{\"p_feed_speed\": 10, \"p_width\": 10, \"p_length\": 90, \"p_width_band\": 12, \"p_thickness_band\": 2, \"p_gap\": 40, \"p_wear_factor\": 1, \"p_kc05\": 15, \"p_kc05_band\": 22.5, \"p_pre_teeth\": 3, \"p_pre_depth\": 3, \"p_pre_ang_kappa\": 90, \"p_pre_ang_lambda\": 65, \"p_pre_n\": 9000, \"p_pre_diameter\": 125, \"p_trim_teeth\": 24, \"p_trim_ang_kappa\": 65, \"p_trim_ang_lambda\": 5, \"p_trim_n\": 11400, \"p_trim_diameter\": 120, \"p_trim_width\": 3, \"p_flush_teeth\": 3, \"p_flush_ang_kappa\": 90, \"p_flush_ang_lambda\": 65, \"p_flush_n\": 8700, \"p_flush_diameter\": 80, \"p_round_teeth\": 4, \"p_round_radius\": 2, \"p_round_diameter\": 125, \"p_round_n\": 8700, \"portion\": 1000}, {\"p_feed_speed\": 15, \"p_width\": 20, \"p_length\": 90, \"p_width_band\": 24, \"p_thickness_band\": 2, \"p_gap\": 40, \"p_wear_factor\": 1, \"p_kc05\": 22.5, \"p_kc05_band\": 33, \"p_pre_teeth\": 3, \"p_pre_depth\": 3, \"p_pre_ang_kappa\": 90, \"p_pre_ang_lambda\": 65, \"p_pre_n\": 9000, \"p_pre_diameter\": 125, \"p_trim_teeth\": 24, \"p_trim_ang_kappa\": 65, \"p_trim_ang_lambda\": 5, \"p_trim_n\": 11400, \"p_trim_diameter\": 120, \"p_trim_width\": 3, \"p_flush_teeth\": 3, \"p_flush_ang_kappa\": 90, \"p_flush_ang_lambda\": 65, \"p_flush_n\": 8700, \"p_flush_diameter\": 80, \"p_round_teeth\": 4, \"p_round_radius\": 5, \"p_round_diameter\": 125, \"p_round_n\": 8700, \"portion\": 200}], \"variants_conditions\": [{\"id\": 38, \"name\": \"Var 1\", \"conditions\": []}]}','{\"status\": \"...\", \"result\": [{\"variant\": \"Var 1\", \"variant_id\": 38, \"opts\": [{\"acquisition_costs\": null, \"total\": 9784, \"partials\": {\"Energie Vorf\\u00e4sen\": {\"value\": 377, \"aggregate\": \"Vorfr\\u00e4se\", \"per_profile\": [217, 160]}, \"Energie Kappen\": {\"value\": 119, \"aggregate\": \"Kapps\\u00e4ge\", \"per_profile\": [69, 50]}, \"Energie B\\u00fcndigfr\\u00e4sen\": {\"value\": 81, \"aggregate\": \"B\\u00fcndigfr\\u00e4ser\", \"per_profile\": [50, 30]}, \"Energie Radienfr\\u00e4sen\": {\"value\": 78, \"aggregate\": \"Radienfr\\u00e4ser\", \"per_profile\": [28, 51]}, \"Ziehklingenenergie\": {\"value\": 24, \"aggregate\": \"Ziehklingen\", \"per_profile\": [13, 11]}, \"Vorschubspannenergie\": {\"value\": 1993, \"aggregate\": \"Vortrieb\", \"per_profile\": [1533, 460]}, \"Heizenergie Verleimaggregat\": {\"value\": 943, \"aggregate\": \"Verleimaggregat\", \"per_profile\": [785, 157]}, \"Motorw\\u00e4rmeenergie Vorfr\\u00e4se\": {\"value\": 251, \"aggregate\": \"Vorfr\\u00e4se\", \"per_profile\": [197, 54]}, \"Wechselrichterverlust Vorfr\\u00e4se\": {\"value\": 65, \"aggregate\": \"Vorfr\\u00e4se\", \"per_profile\": [53, 12]}, \"Motorw\\u00e4rmeenergie Kapps\\u00e4ge\": {\"value\": 266, \"aggregate\": \"Kapps\\u00e4ge\", \"per_profile\": [220, 46]}, \"Wechselrichterverlust Kapps\\u00e4ge\": {\"value\": 60, \"aggregate\": \"Kapps\\u00e4ge\", \"per_profile\": [50, 10]}, \"Motorw\\u00e4rmeenergie B\\u00fcndigfr\\u00e4sen\": {\"value\": 200, \"aggregate\": \"B\\u00fcndigfr\\u00e4ser\", \"per_profile\": [166, 35]}, \"Wechselrichterverlust B\\u00fcndigfr\\u00e4ser\": {\"value\": 60, \"aggregate\": \"B\\u00fcndigfr\\u00e4ser\", \"per_profile\": [50, 10]}, \"Motorw\\u00e4rme Radienfr\\u00e4ser\": {\"value\": 200, \"aggregate\": \"Radienfr\\u00e4ser\", \"per_profile\": [164, 36]}, \"Wechselrichterverlust Radienfr\\u00e4sen\": {\"value\": 60, \"aggregate\": \"Radienfr\\u00e4ser\", \"per_profile\": [50, 10]}, \"Vorschubgetriebereibw\\u00e4rme\": {\"value\": 321, \"aggregate\": \"Vortrieb\", \"per_profile\": [247, 74]}, \"Motorw\\u00e4rme Vortrieb\": {\"value\": 4686, \"aggregate\": \"Vortrieb\", \"per_profile\": [3914, 773]}}, \"indices\": {\"Vorfr\\u00e4smotor\": {\"id\": 46, \"name\": \"motor26\", \"manufacturer\": \"gen7\"}, \"Vorfr\\u00e4sumrichter\": {\"id\": 53, \"name\": \"12G6CDB-3900\", \"manufacturer\": \"KEB\"}, \"Kappmotor\": {\"id\": 46, \"name\": \"motor26\", \"manufacturer\": \"gen7\"}, \"Kappumrichter\": {\"id\": 53, \"name\": \"12G6CDB-3900\", \"manufacturer\": \"KEB\"}, \"B\\u00fcndigfr\\u00e4smotor\": {\"id\": 46, \"name\": \"motor26\", \"manufacturer\": \"gen7\"}, \"B\\u00fcndigfr\\u00e4sumrichter\": {\"id\": 53, \"name\": \"12G6CDB-3900\", \"manufacturer\": \"KEB\"}, \"Radienfr\\u00e4smotor\": {\"id\": 46, \"name\": \"motor26\", \"manufacturer\": \"gen7\"}, \"Radienfr\\u00e4sumrichter\": {\"id\": 53, \"name\": \"12G6CDB-3900\", \"manufacturer\": \"KEB\"}, \"Getriebe Bandvorschub\": {\"id\": 1, \"name\": \"verbaut\", \"manufacturer\": \"Homag\"}, \"Bandvorschubmotor\": {\"id\": 62, \"name\": \"motor66\", \"manufacturer\": \"gen7_50\"}}}, {\"acquisition_costs\": null, \"total\": 9844, \"partials\": {\"Energie Vorf\\u00e4sen\": {\"value\": 377, \"aggregate\": \"Vorfr\\u00e4se\", \"per_profile\": [217, 160]}, \"Energie Kappen\": {\"value\": 119, \"aggregate\": \"Kapps\\u00e4ge\", \"per_profile\": [69, 50]}, \"Energie B\\u00fcndigfr\\u00e4sen\": {\"value\": 81, \"aggregate\": \"B\\u00fcndigfr\\u00e4ser\", \"per_profile\": [50, 30]}, \"Energie Radienfr\\u00e4sen\": {\"value\": 78, \"aggregate\": \"Radienfr\\u00e4ser\", \"per_profile\": [28, 51]}, \"Ziehklingenenergie\": {\"value\": 24, \"aggregate\": \"Ziehklingen\", \"per_profile\": [13, 11]}, \"Vorschubspannenergie\": {\"value\": 1993, \"aggregate\": \"Vortrieb\", \"per_profile\": [1533, 460]}, \"Heizenergie Verleimaggregat\": {\"value\": 943, \"aggregate\": \"Verleimaggregat\", \"per_profile\": [785, 157]}, \"Motorw\\u00e4rmeenergie Vorfr\\u00e4se\": {\"value\": 251, \"aggregate\": \"Vorfr\\u00e4se\", \"per_profile\": [197, 54]}, \"Wechselrichterverlust Vorfr\\u00e4se\": {\"value\": 65, \"aggregate\": \"Vorfr\\u00e4se\", \"per_profile\": [53, 12]}, \"Motorw\\u00e4rmeenergie Kapps\\u00e4ge\": {\"value\": 266, \"aggregate\": \"Kapps\\u00e4ge\", \"per_profile\": [220, 46]}, \"Wechselrichterverlust Kapps\\u00e4ge\": {\"value\": 119, \"aggregate\": \"Kapps\\u00e4ge\", \"per_profile\": [99, 20]}, \"Motorw\\u00e4rmeenergie B\\u00fcndigfr\\u00e4sen\": {\"value\": 200, \"aggregate\": \"B\\u00fcndigfr\\u00e4ser\", \"per_profile\": [166, 35]}, \"Wechselrichterverlust B\\u00fcndigfr\\u00e4ser\": {\"value\": 60, \"aggregate\": \"B\\u00fcndigfr\\u00e4ser\", \"per_profile\": [50, 10]}, \"Motorw\\u00e4rme Radienfr\\u00e4ser\": {\"value\": 200, \"aggregate\": \"Radienfr\\u00e4ser\", \"per_profile\": [164, 36]}, \"Wechselrichterverlust Radienfr\\u00e4sen\": {\"value\": 60, \"aggregate\": \"Radienfr\\u00e4ser\", \"per_profile\": [50, 10]}, \"Vorschubgetriebereibw\\u00e4rme\": {\"value\": 321, \"aggregate\": \"Vortrieb\", \"per_profile\": [247, 74]}, \"Motorw\\u00e4rme Vortrieb\": {\"value\": 4686, \"aggregate\": \"Vortrieb\", \"per_profile\": [3914, 773]}}, \"indices\": {\"Vorfr\\u00e4smotor\": {\"id\": 46, \"name\": \"motor26\", \"manufacturer\": \"gen7\"}, \"Vorfr\\u00e4sumrichter\": {\"id\": 53, \"name\": \"12G6CDB-3900\", \"manufacturer\": \"KEB\"}, \"Kappmotor\": {\"id\": 46, \"name\": \"motor26\", \"manufacturer\": \"gen7\"}, \"Kappumrichter\": {\"id\": 59, \"name\": \"12S6A14-2100\", \"manufacturer\": \"KEB\"}, \"B\\u00fcndigfr\\u00e4smotor\": {\"id\": 46, \"name\": \"motor26\", \"manufacturer\": \"gen7\"}, \"B\\u00fcndigfr\\u00e4sumrichter\": {\"id\": 53, \"name\": \"12G6CDB-3900\", \"manufacturer\": \"KEB\"}, \"Radienfr\\u00e4smotor\": {\"id\": 46, \"name\": \"motor26\", \"manufacturer\": \"gen7\"}, \"Radienfr\\u00e4sumrichter\": {\"id\": 53, \"name\": \"12G6CDB-3900\", \"manufacturer\": \"KEB\"}, \"Getriebe Bandvorschub\": {\"id\": 1, \"name\": \"verbaut\", \"manufacturer\": \"Homag\"}, \"Bandvorschubmotor\": {\"id\": 62, \"name\": \"motor66\", \"manufacturer\": \"gen7_50\"}}}, {\"acquisition_costs\": null, \"total\": 9846, \"partials\": {\"Energie Vorf\\u00e4sen\": {\"value\": 377, \"aggregate\": \"Vorfr\\u00e4se\", \"per_profile\": [217, 160]}, \"Energie Kappen\": {\"value\": 119, \"aggregate\": \"Kapps\\u00e4ge\", \"per_profile\": [69, 50]}, \"Energie B\\u00fcndigfr\\u00e4sen\": {\"value\": 81, \"aggregate\": \"B\\u00fcndigfr\\u00e4ser\", \"per_profile\": [50, 30]}, \"Energie Radienfr\\u00e4sen\": {\"value\": 78, \"aggregate\": \"Radienfr\\u00e4ser\", \"per_profile\": [28, 51]}, \"Ziehklingenenergie\": {\"value\": 24, \"aggregate\": \"Ziehklingen\", \"per_profile\": [13, 11]}, \"Vorschubspannenergie\": {\"value\": 1993, \"aggregate\": \"Vortrieb\", \"per_profile\": [1533, 460]}, \"Heizenergie Verleimaggregat\": {\"value\": 943, \"aggregate\": \"Verleimaggregat\", \"per_profile\": [785, 157]}, \"Motorw\\u00e4rmeenergie Vorfr\\u00e4se\": {\"value\": 251, \"aggregate\": \"Vorfr\\u00e4se\", \"per_profile\": [197, 54]}, \"Wechselrichterverlust Vorfr\\u00e4se\": {\"value\": 65, \"aggregate\": \"Vorfr\\u00e4se\", \"per_profile\": [53, 12]}, \"Motorw\\u00e4rmeenergie Kapps\\u00e4ge\": {\"value\": 266, \"aggregate\": \"Kapps\\u00e4ge\", \"per_profile\": [220, 46]}, \"Wechselrichterverlust Kapps\\u00e4ge\": {\"value\": 60, \"aggregate\": \"Kapps\\u00e4ge\", \"per_profile\": [50, 10]}, \"Motorw\\u00e4rmeenergie B\\u00fcndigfr\\u00e4sen\": {\"value\": 200, \"aggregate\": \"B\\u00fcndigfr\\u00e4ser\", \"per_profile\": [166, 35]}, \"Wechselrichterverlust B\\u00fcndigfr\\u00e4ser\": {\"value\": 122, \"aggregate\": \"B\\u00fcndigfr\\u00e4ser\", \"per_profile\": [101, 20]}, \"Motorw\\u00e4rme Radienfr\\u00e4ser\": {\"value\": 200, \"aggregate\": \"Radienfr\\u00e4ser\", \"per_profile\": [164, 36]}, \"Wechselrichterverlust Radienfr\\u00e4sen\": {\"value\": 60, \"aggregate\": \"Radienfr\\u00e4ser\", \"per_profile\": [50, 10]}, \"Vorschubgetriebereibw\\u00e4rme\": {\"value\": 321, \"aggregate\": \"Vortrieb\", \"per_profile\": [247, 74]}, \"Motorw\\u00e4rme Vortrieb\": {\"value\": 4686, \"aggregate\": \"Vortrieb\", \"per_profile\": [3914, 773]}}, \"indices\": {\"Vorfr\\u00e4smotor\": {\"id\": 46, \"name\": \"motor26\", \"manufacturer\": \"gen7\"}, \"Vorfr\\u00e4sumrichter\": {\"id\": 53, \"name\": \"12G6CDB-3900\", \"manufacturer\": \"KEB\"}, \"Kappmotor\": {\"id\": 46, \"name\": \"motor26\", \"manufacturer\": \"gen7\"}, \"Kappumrichter\": {\"id\": 53, \"name\": \"12G6CDB-3900\", \"manufacturer\": \"KEB\"}, \"B\\u00fcndigfr\\u00e4smotor\": {\"id\": 46, \"name\": \"motor26\", \"manufacturer\": \"gen7\"}, \"B\\u00fcndigfr\\u00e4sumrichter\": {\"id\": 59, \"name\": \"12S6A14-2100\", \"manufacturer\": \"KEB\"}, \"Radienfr\\u00e4smotor\": {\"id\": 46, \"name\": \"motor26\", \"manufacturer\": \"gen7\"}, \"Radienfr\\u00e4sumrichter\": {\"id\": 53, \"name\": \"12G6CDB-3900\", \"manufacturer\": \"KEB\"}, \"Getriebe Bandvorschub\": {\"id\": 1, \"name\": \"verbaut\", \"manufacturer\": \"Homag\"}, \"Bandvorschubmotor\": {\"id\": 62, \"name\": \"motor66\", \"manufacturer\": \"gen7_50\"}}}, {\"acquisition_costs\": null, \"total\": 9846, \"partials\": {\"Energie Vorf\\u00e4sen\": {\"value\": 377, \"aggregate\": \"Vorfr\\u00e4se\", \"per_profile\": [217, 160]}, \"Energie Kappen\": {\"value\": 119, \"aggregate\": \"Kapps\\u00e4ge\", \"per_profile\": [69, 50]}, \"Energie B\\u00fcndigfr\\u00e4sen\": {\"value\": 81, \"aggregate\": \"B\\u00fcndigfr\\u00e4ser\", \"per_profile\": [50, 30]}, \"Energie Radienfr\\u00e4sen\": {\"value\": 78, \"aggregate\": \"Radienfr\\u00e4ser\", \"per_profile\": [28, 51]}, \"Ziehklingenenergie\": {\"value\": 24, \"aggregate\": \"Ziehklingen\", \"per_profile\": [13, 11]}, \"Vorschubspannenergie\": {\"value\": 1993, \"aggregate\": \"Vortrieb\", \"per_profile\": [1533, 460]}, \"Heizenergie Verleimaggregat\": {\"value\": 943, \"aggregate\": \"Verleimaggregat\", \"per_profile\": [785, 157]}, \"Motorw\\u00e4rmeenergie Vorfr\\u00e4se\": {\"value\": 251, \"aggregate\": \"Vorfr\\u00e4se\", \"per_profile\": [197, 54]}, \"Wechselrichterverlust Vorfr\\u00e4se\": {\"value\": 65, \"aggregate\": \"Vorfr\\u00e4se\", \"per_profile\": [53, 12]}, \"Motorw\\u00e4rmeenergie Kapps\\u00e4ge\": {\"value\": 266, \"aggregate\": \"Kapps\\u00e4ge\", \"per_profile\": [220, 46]}, \"Wechselrichterverlust Kapps\\u00e4ge\": {\"value\": 60, \"aggregate\": \"Kapps\\u00e4ge\", \"per_profile\": [50, 10]}, \"Motorw\\u00e4rmeenergie B\\u00fcndigfr\\u00e4sen\": {\"value\": 200, \"aggregate\": \"B\\u00fcndigfr\\u00e4ser\", \"per_profile\": [166, 35]}, \"Wechselrichterverlust B\\u00fcndigfr\\u00e4ser\": {\"value\": 60, \"aggregate\": \"B\\u00fcndigfr\\u00e4ser\", \"per_profile\": [50, 10]}, \"Motorw\\u00e4rme Radienfr\\u00e4ser\": {\"value\": 200, \"aggregate\": \"Radienfr\\u00e4ser\", \"per_profile\": [164, 36]}, \"Wechselrichterverlust Radienfr\\u00e4sen\": {\"value\": 122, \"aggregate\": \"Radienfr\\u00e4ser\", \"per_profile\": [101, 21]}, \"Vorschubgetriebereibw\\u00e4rme\": {\"value\": 321, \"aggregate\": \"Vortrieb\", \"per_profile\": [247, 74]}, \"Motorw\\u00e4rme Vortrieb\": {\"value\": 4686, \"aggregate\": \"Vortrieb\", \"per_profile\": [3914, 773]}}, \"indices\": {\"Vorfr\\u00e4smotor\": {\"id\": 46, \"name\": \"motor26\", \"manufacturer\": \"gen7\"}, \"Vorfr\\u00e4sumrichter\": {\"id\": 53, \"name\": \"12G6CDB-3900\", \"manufacturer\": \"KEB\"}, \"Kappmotor\": {\"id\": 46, \"name\": \"motor26\", \"manufacturer\": \"gen7\"}, \"Kappumrichter\": {\"id\": 53, \"name\": \"12G6CDB-3900\", \"manufacturer\": \"KEB\"}, \"B\\u00fcndigfr\\u00e4smotor\": {\"id\": 46, \"name\": \"motor26\", \"manufacturer\": \"gen7\"}, \"B\\u00fcndigfr\\u00e4sumrichter\": {\"id\": 53, \"name\": \"12G6CDB-3900\", \"manufacturer\": \"KEB\"}, \"Radienfr\\u00e4smotor\": {\"id\": 46, \"name\": \"motor26\", \"manufacturer\": \"gen7\"}, \"Radienfr\\u00e4sumrichter\": {\"id\": 59, \"name\": \"12S6A14-2100\", \"manufacturer\": \"KEB\"}, \"Getriebe Bandvorschub\": {\"id\": 1, \"name\": \"verbaut\", \"manufacturer\": \"Homag\"}, \"Bandvorschubmotor\": {\"id\": 62, \"name\": \"motor66\", \"manufacturer\": \"gen7_50\"}}}, {\"acquisition_costs\": null, \"total\": 9848, \"partials\": {\"Energie Vorf\\u00e4sen\": {\"value\": 377, \"aggregate\": \"Vorfr\\u00e4se\", \"per_profile\": [217, 160]}, \"Energie Kappen\": {\"value\": 119, \"aggregate\": \"Kapps\\u00e4ge\", \"per_profile\": [69, 50]}, \"Energie B\\u00fcndigfr\\u00e4sen\": {\"value\": 81, \"aggregate\": \"B\\u00fcndigfr\\u00e4ser\", \"per_profile\": [50, 30]}, \"Energie Radienfr\\u00e4sen\": {\"value\": 78, \"aggregate\": \"Radienfr\\u00e4ser\", \"per_profile\": [28, 51]}, \"Ziehklingenenergie\": {\"value\": 24, \"aggregate\": \"Ziehklingen\", \"per_profile\": [13, 11]}, \"Vorschubspannenergie\": {\"value\": 1993, \"aggregate\": \"Vortrieb\", \"per_profile\": [1533, 460]}, \"Heizenergie Verleimaggregat\": {\"value\": 943, \"aggregate\": \"Verleimaggregat\", \"per_profile\": [785, 157]}, \"Motorw\\u00e4rmeenergie Vorfr\\u00e4se\": {\"value\": 251, \"aggregate\": \"Vorfr\\u00e4se\", \"per_profile\": [197, 54]}, \"Wechselrichterverlust Vorfr\\u00e4se\": {\"value\": 128, \"aggregate\": \"Vorfr\\u00e4se\", \"per_profile\": [105, 23]}, \"Motorw\\u00e4rmeenergie Kapps\\u00e4ge\": {\"value\": 266, \"aggregate\": \"Kapps\\u00e4ge\", \"per_profile\": [220, 46]}, \"Wechselrichterverlust Kapps\\u00e4ge\": {\"value\": 60, \"aggregate\": \"Kapps\\u00e4ge\", \"per_profile\": [50, 10]}, \"Motorw\\u00e4rmeenergie B\\u00fcndigfr\\u00e4sen\": {\"value\": 200, \"aggregate\": \"B\\u00fcndigfr\\u00e4ser\", \"per_profile\": [166, 35]}, \"Wechselrichterverlust B\\u00fcndigfr\\u00e4ser\": {\"value\": 60, \"aggregate\": \"B\\u00fcndigfr\\u00e4ser\", \"per_profile\": [50, 10]}, \"Motorw\\u00e4rme Radienfr\\u00e4ser\": {\"value\": 200, \"aggregate\": \"Radienfr\\u00e4ser\", \"per_profile\": [164, 36]}, \"Wechselrichterverlust Radienfr\\u00e4sen\": {\"value\": 60, \"aggregate\": \"Radienfr\\u00e4ser\", \"per_profile\": [50, 10]}, \"Vorschubgetriebereibw\\u00e4rme\": {\"value\": 321, \"aggregate\": \"Vortrieb\", \"per_profile\": [247, 74]}, \"Motorw\\u00e4rme Vortrieb\": {\"value\": 4686, \"aggregate\": \"Vortrieb\", \"per_profile\": [3914, 773]}}, \"indices\": {\"Vorfr\\u00e4smotor\": {\"id\": 46, \"name\": \"motor26\", \"manufacturer\": \"gen7\"}, \"Vorfr\\u00e4sumrichter\": {\"id\": 59, \"name\": \"12S6A14-2100\", \"manufacturer\": \"KEB\"}, \"Kappmotor\": {\"id\": 46, \"name\": \"motor26\", \"manufacturer\": \"gen7\"}, \"Kappumrichter\": {\"id\": 53, \"name\": \"12G6CDB-3900\", \"manufacturer\": \"KEB\"}, \"B\\u00fcndigfr\\u00e4smotor\": {\"id\": 46, \"name\": \"motor26\", \"manufacturer\": \"gen7\"}, \"B\\u00fcndigfr\\u00e4sumrichter\": {\"id\": 53, \"name\": \"12G6CDB-3900\", \"manufacturer\": \"KEB\"}, \"Radienfr\\u00e4smotor\": {\"id\": 46, \"name\": \"motor26\", \"manufacturer\": \"gen7\"}, \"Radienfr\\u00e4sumrichter\": {\"id\": 53, \"name\": \"12G6CDB-3900\", \"manufacturer\": \"KEB\"}, \"Getriebe Bandvorschub\": {\"id\": 1, \"name\": \"verbaut\", \"manufacturer\": \"Homag\"}, \"Bandvorschubmotor\": {\"id\": 62, \"name\": \"motor66\", \"manufacturer\": \"gen7_50\"}}}], \"cost_opts\": [], \"deepest_failed_restriction\": {\"depth\": 10, \"restriction\": \"Vortriebmotormoment\"}, \"info\": \"no special remarks\"}]}');
/*!40000 ALTER TABLE `requests` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `restrictions`
--

DROP TABLE IF EXISTS `restrictions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `restrictions` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `variants_id` int(11) NOT NULL,
  `restriction` text NOT NULL,
  `eval_after_position` int(11) NOT NULL,
  `description` varchar(40) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `restrictions_variants` (`variants_id`),
  CONSTRAINT `restrictions_variants` FOREIGN KEY (`variants_id`) REFERENCES `variants` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=52 DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `restrictions`
--

LOCK TABLES `restrictions` WRITE;
/*!40000 ALTER TABLE `restrictions` DISABLE KEYS */;
INSERT INTO `restrictions` VALUES
(28,38,'0 <= c_pre_motor[\'p_nominal\'] - p_wear_factor * l_pre_pow_max',1,'Vorfräsmotorleistung'),
(29,38,'0 <= 60 * c_pre_motor[\'f_nominal\'] / c_pre_motor[\'n_pole_pairs\'] - p_pre_n',1,'Vorfräsmotorfrequenz'),
(30,38,'0 >= abs( c_pre_converter[\'p_nominal\'] - c_pre_motor[\'p_nominal\'] ) / c_pre_converter[\'p_nominal\'] - 0.1',2,'Vorfräsumrichterleistung'),
(31,38,'0 <= c_pre_converter[\'f_nominal\'] * 60 - p_pre_n',2,'Vorfräsumrichterfrequenz'),
(32,38,'0 <= c_trim_motor[\'p_nominal\'] - l_trim_pow_max * p_wear_factor',3,'Kappmotorleistung'),
(33,38,'0 <= 60 * c_trim_motor[\'f_nominal\'] / c_trim_motor[\'n_pole_pairs\'] - p_trim_n',3,'Kappmotorfrequenz'),
(34,38,'0 >= abs( c_trim_converter[\'p_nominal\'] - c_trim_motor[\'p_nominal\'] ) / c_trim_converter[\'p_nominal\'] - 0.1',4,'Kappumrichterleistung'),
(35,38,'0 <= c_trim_converter[\'f_nominal\'] * 60 - p_trim_n',4,'Kappumrichterfrequenz'),
(36,38,'0 <= c_flush_motor[\'p_nominal\'] - l_flush_pow_max * p_wear_factor',5,'Bündigmotorleistung'),
(37,38,'0 <= 60 * c_flush_motor[\'f_nominal\'] / c_flush_motor[\'n_pole_pairs\'] - p_flush_n',5,'Bündigmotorfrequenz'),
(38,38,'0 >= abs( c_flush_converter[\'p_nominal\'] - c_flush_motor[\'p_nominal\'] ) / c_flush_converter[\'p_nominal\'] - 0.1',6,'Bündigumrichterleistung'),
(39,38,'0 <= c_flush_converter[\'f_nominal\'] * 60 - p_flush_n',6,'Bündigumrichterfrequenz'),
(40,38,'0 <= c_round_motor[\'p_nominal\'] - l_round_pow_max * p_wear_factor',7,'Radienmotorleistung'),
(41,38,'0 <= 60 * c_round_motor[\'f_nominal\'] / c_round_motor[\'n_pole_pairs\'] - p_round_n',7,'Radienmotorfrequenz'),
(42,38,'0 >= abs( c_round_converter[\'p_nominal\'] - c_round_motor[\'p_nominal\'] ) / c_round_converter[\'p_nominal\'] - 0.1',8,'Radienumrichterleistung'),
(43,38,'0 <= c_round_converter[\'f_nominal\'] * 60 - p_round_n',8,'Radienumrichterfrequenz'),
(44,38,'0 <= c_feed_gears[\'m_nominal\'] - l_feed_m',10,'Vortriebgetriebemoment'),
(45,38,'0 <= c_feed_motor[\'p_nominal\'] - l_feed_pow - l_feed_gear_loss',10,'Vortriebmotorleistung'),
(46,38,'0 <= 60 * c_feed_motor[\'f_nominal\'] / c_feed_motor[\'n_pole_pairs\'] - l_feed_n_in',10,'Vortriebmotorfrequenz'),
(47,38,'0 <= c_pre_motor[\'m_nominal\'] - l_pre_m',1,'Vorfräsmotormoment'),
(48,38,'0 <= c_trim_motor[\'m_nominal\'] - l_trim_m',3,'Kappgmotormoment'),
(49,38,'0 <= c_flush_motor[\'m_nominal\'] - l_flush_m',5,'Bündigmotormoment'),
(50,38,'0 <= c_round_motor[\'m_nominal\'] - l_round_m',7,'Radienmotormoment'),
(51,38,'0 <= c_feed_motor[\'m_nominal\'] - l_feed_m_total',10,'Vortriebmotormoment');
/*!40000 ALTER TABLE `restrictions` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `roles`
--

DROP TABLE IF EXISTS `roles`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `roles` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `role` varchar(6) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `roles`
--

LOCK TABLES `roles` WRITE;
/*!40000 ALTER TABLE `roles` DISABLE KEYS */;
INSERT INTO `roles` VALUES
(1,'data'),
(2,'opt'),
(3,'admin');
/*!40000 ALTER TABLE `roles` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `users`
--

DROP TABLE IF EXISTS `users`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(20) NOT NULL,
  `password_hash` varchar(100) NOT NULL,
  `role` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `users_role` (`role`),
  CONSTRAINT `users_role` FOREIGN KEY (`role`) REFERENCES `roles` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `users`
--

LOCK TABLES `users` WRITE;
/*!40000 ALTER TABLE `users` DISABLE KEYS */;
INSERT INTO `users` VALUES
(1,'admin','pbkdf2:sha256:150000$0d1YxUHK$1828d59860ed572d79ea16f33a6155b35a906affede33336542db332eb833c3f',3),
(2,'user','pbkdf2:sha256:150000$tcDN0hyg$d35c532d6a6f0109d88245759e36532dc8813faf994a9d17fbad336a863f0309',1),
(3,'Markus','pbkdf2:sha256:150000$l7UAAUGj$90703a7eb8e9433f167ff44789515951d73179df8add124207cf1d817604cf29',3),
(4,'user2','pbkdf2:sha256:150000$DUJ2UdyH$4d75142dffbecee806acd8be5d6b91be2199524d9b2bbc694c85994e3bd21722',2);
/*!40000 ALTER TABLE `users` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `variant_components`
--

DROP TABLE IF EXISTS `variant_components`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `variant_components` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `variants_id` int(11) NOT NULL,
  `position` tinyint(3) unsigned NOT NULL,
  `component_api_name` varchar(40) NOT NULL,
  `variable_name` varchar(30) NOT NULL,
  `description` varchar(40) NOT NULL,
  `aggregate` varchar(30) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `variant_components_variants` (`variants_id`),
  KEY `variant_components_api_name` (`component_api_name`),
  CONSTRAINT `variant_components` FOREIGN KEY (`variants_id`) REFERENCES `variants` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `variant_components_api_name` FOREIGN KEY (`component_api_name`) REFERENCES `components` (`api_name`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=51 DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `variant_components`
--

LOCK TABLES `variant_components` WRITE;
/*!40000 ALTER TABLE `variant_components` DISABLE KEYS */;
INSERT INTO `variant_components` VALUES
(1,15,1,'motors','v_milling_motor','Fräsermotor','Fügefräse'),
(2,15,2,'motors','v_flush_motor','Bündigfräsermotor','Bündigfräse'),
(5,15,3,'motors','v_forward_motor','Nebenantriebsmotor','Nebenantrieb'),
(41,38,0,'motors','c_pre_motor','Vorfräsmotor','Vorfräse'),
(42,38,1,'transformers','c_pre_converter','Vorfräsumrichter','Vorfräse'),
(43,38,2,'motors','c_trim_motor','Kappmotor','Kappsäge'),
(44,38,3,'transformers','c_trim_converter','Kappumrichter','Kappsäge'),
(45,38,4,'motors','c_flush_motor','Bündigfräsmotor','Bündigfräser'),
(46,38,5,'transformers','c_flush_converter','Bündigfräsumrichter','Bündigfräser'),
(47,38,6,'motors','c_round_motor','Radienfräsmotor','Radienfräser'),
(48,38,7,'transformers','c_round_converter','Radienfräsumrichter','Radienfräser'),
(49,38,8,'gears','c_feed_gears','Getriebe Bandvorschub','Vortrieb'),
(50,38,9,'motors','c_feed_motor','Bandvorschubmotor','Vortrieb');
/*!40000 ALTER TABLE `variant_components` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `variant_selection`
--

DROP TABLE IF EXISTS `variant_selection`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `variant_selection` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `processes_id` int(11) NOT NULL,
  `selection` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`selection`)),
  PRIMARY KEY (`id`),
  KEY `process_variant_selection` (`processes_id`),
  CONSTRAINT `process_variant_selection` FOREIGN KEY (`processes_id`) REFERENCES `processes` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `variant_selection`
--

LOCK TABLES `variant_selection` WRITE;
/*!40000 ALTER TABLE `variant_selection` DISABLE KEYS */;
INSERT INTO `variant_selection` VALUES
(1,1,'{\"list\": [], \"tree\": {\"no\": {\"excludes\": [5, 6, 7, 8, 9, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23], \"no\": {\"excludes\": [3, 4], \"no\": {\"excludes\": [1], \"no\": null, \"question\": null, \"yes\": null}, \"question\": \"Leimfugenziehen?\", \"yes\": {\"excludes\": [2], \"no\": null, \"question\": null, \"yes\": null}}, \"question\": \"Eckenkopieren?\", \"yes\": {\"excludes\": [1, 2], \"no\": {\"excludes\": [4], \"no\": null, \"question\": null, \"yes\": null}, \"question\": \"Leimfugenziehen?\", \"yes\": {\"excludes\": [3], \"no\": null, \"question\": null, \"yes\": null}}}, \"question\": \"F\\u00fcgefr\\u00e4sen?\", \"yes\": {\"excludes\": [1, 2, 3, 4], \"no\": {\"excludes\": [5, 6], \"no\": {\"excludes\": [18, 19, 20, 21, 22, 23, 12], \"no\": {\"excludes\": [15, 16, 17], \"no\": {\"excludes\": [9, 11, 13, 14], \"no\": {\"excludes\": [8], \"no\": null, \"question\": null, \"yes\": null}, \"question\": \"Leimfugenziehen?\", \"yes\": {\"excludes\": [7], \"no\": null, \"question\": null, \"yes\": null}}, \"question\": \"Eckenkopieren?\", \"yes\": {\"excludes\": [7, 8], \"no\": {\"excludes\": [12, 13, 14, 15, 16, 17, 13], \"no\": {\"excludes\": [11], \"no\": null, \"question\": null, \"yes\": null}, \"question\": \"Schwabbeln?\", \"yes\": {\"excludes\": [9], \"no\": null, \"question\": null, \"yes\": null}}, \"question\": \"Leimfugenziehen?\", \"yes\": {\"excludes\": [9, 11], \"no\": {\"excludes\": [], \"no\": {\"excludes\": [14], \"no\": null, \"question\": null, \"yes\": null}, \"question\": \"Nutfr\\u00e4sen?\", \"yes\": {\"excludes\": [12], \"no\": null, \"question\": null, \"yes\": null}}, \"question\": \"Eckschwabbeln?\", \"yes\": {\"excludes\": [12, 14], \"no\": null, \"question\": null, \"yes\": null}}}}, \"question\": \"B\\u00fcndigfr\\u00e4sen?\", \"yes\": {\"excludes\": [7, 8, 9, 11, 12, 13, 14], \"no\": {\"excludes\": [17], \"no\": {\"excludes\": [16], \"no\": null, \"question\": null, \"yes\": null}, \"question\": \"Universalfr\\u00e4sen?\", \"yes\": {\"excludes\": [15], \"no\": null, \"question\": null, \"yes\": null}}, \"question\": \"Eckschwabbeln?\", \"yes\": {\"excludes\": [15, 16], \"no\": null, \"question\": null, \"yes\": null}}}, \"question\": \"Laser?\", \"yes\": {\"excludes\": [7, 8, 9, 11, 12, 13, 14, 15, 16, 17], \"no\": {\"excludes\": [21, 22, 23], \"no\": {\"excludes\": [20], \"no\": {\"excludes\": [19], \"no\": null, \"question\": null, \"yes\": null}, \"question\": \"Nutfr\\u00e4sen?\", \"yes\": {\"excludes\": [18], \"no\": null, \"question\": null, \"yes\": null}}, \"question\": \"Eckschwabbeln?\", \"yes\": {\"excludes\": [18, 19], \"no\": null, \"question\": null, \"yes\": null}}, \"question\": \"B\\u00fcndigfr\\u00e4sen?\", \"yes\": {\"excludes\": [18, 19, 20], \"no\": {\"excludes\": [23], \"no\": {\"excludes\": [22], \"no\": null, \"question\": null, \"yes\": null}, \"question\": \"Universalfr\\u00e4sen?\", \"yes\": {\"excludes\": [21], \"no\": null, \"question\": null, \"yes\": null}}, \"question\": \"Nutfr\\u00e4sen?\", \"yes\": {\"excludes\": [21, 22], \"no\": null, \"question\": null, \"yes\": null}}}}, \"question\": \"Hei\\u00dfluft?\", \"yes\": {\"excludes\": [7, 8, 9, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23], \"no\": {\"excludes\": [6], \"no\": null, \"question\": null, \"yes\": null}, \"question\": \"Leimfugenziehen?\", \"yes\": {\"excludes\": [5], \"no\": null, \"question\": null, \"yes\": null}}}}}'),
(9,21,'{\"list\": [], \"tree\": [{\"id\": \"root\", \"question\": \"\", \"info\": \"\", \"excludes\": [], \"exclude_choices\": [], \"answers\": [{\"response\": \"yes\", \"question\": \"\", \"excludes\": [], \"exclude_choices\": [], \"id\": \"y\", \"answers\": []}, {\"response\": \"no\", \"question\": \"\", \"excludes\": [], \"exclude_choices\": [], \"id\": \"n\", \"answers\": []}]}]}');
/*!40000 ALTER TABLE `variant_selection` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `variants`
--

DROP TABLE IF EXISTS `variants`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `variants` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `processes_id` int(11) NOT NULL,
  `name` tinytext NOT NULL,
  PRIMARY KEY (`id`),
  KEY `variants_process` (`processes_id`),
  CONSTRAINT `variants_processes` FOREIGN KEY (`processes_id`) REFERENCES `processes` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=39 DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `variants`
--

LOCK TABLES `variants` WRITE;
/*!40000 ALTER TABLE `variants` DISABLE KEYS */;
INSERT INTO `variants` VALUES
(1,1,'Leim mit Fugenziehen'),
(2,1,'Leim'),
(3,1,'Leim mit Schwabbel'),
(4,1,'Leim mit Fugenziehen und Schwabbel'),
(5,1,'Heißluft'),
(6,1,'Heißluft mit Fugenziehen'),
(7,1,'Fügefraser, Leim'),
(8,1,'Fügefraser, Leim mit Schwabbel'),
(9,1,'Fügefraser, Leim mit Eckenkopierer'),
(11,1,'Fügefraser, Leim mit Eckenkopierer und Schwabbel'),
(12,1,'Fügefraser, Leim mit Eckenkopierer, Ziehklinge und Schwabbel'),
(13,1,'Fügefraser, Leim mit Eckenkopierer, Ziehklinge und Eck-/Schwabbel'),
(14,1,'Fügefraser, Leim mit Eckenkopierer, Ziehklinge, Schwabbel und Nutfräse'),
(15,1,'Fügefraser, Leim mit Eckenkopierer, Bündigfräser'),
(16,1,'Fügefraser, Leim mit Eckenkopierer, Bündig- und Universalfräser'),
(17,1,'Fügefraser, Leim mit Eckenkopierer, Bündigfräser und Eckschwabbel'),
(18,1,'Laser'),
(19,1,'Laser mit Nutfräse'),
(20,1,'Laser mit Eckschwabbel'),
(21,1,'Laser mit Bündigfräser'),
(22,1,'Laser mit Bündig- und Universalfräser'),
(23,1,'Laser mit Bündigfräser und Eckschwabbel'),
(38,21,'Var 1');
/*!40000 ALTER TABLE `variants` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `variants_loss_functions`
--

DROP TABLE IF EXISTS `variants_loss_functions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `variants_loss_functions` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `variants_id` int(11) NOT NULL,
  `loss_functions_id` int(11) NOT NULL,
  `parameter_list` text NOT NULL,
  `variable_name` varchar(20) NOT NULL,
  `description` varchar(40) NOT NULL,
  `eval_after_position` int(11) NOT NULL,
  `position` int(11) NOT NULL,
  `aggregate` varchar(30) NOT NULL,
  `is_loss` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `variants_variants_loss_functions` (`variants_id`),
  KEY `loss_functions_variants_loss_functions` (`loss_functions_id`),
  CONSTRAINT `loss_functions_variants_loss_functions` FOREIGN KEY (`loss_functions_id`) REFERENCES `loss_functions` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `variants_variants_loss_functions` FOREIGN KEY (`variants_id`) REFERENCES `variants` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=91 DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `variants_loss_functions`
--

LOCK TABLES `variants_loss_functions` WRITE;
/*!40000 ALTER TABLE `variants_loss_functions` DISABLE KEYS */;
INSERT INTO `variants_loss_functions` VALUES
(1,15,1,'(p_part_width, p_part_length)','r_milling_motor_loss','Verlust Fügefräsmotor',1,1,'Fügefräse',1),
(2,15,1,'(p_part_width, p_part_length)','r_milling_trans_loss','Verlust Fügefräswandler',3,2,'Fügefräse',1),
(3,15,2,'(p_part_width, p_part_length)','r_trim_motor_loss','Verlust Kappmotor',2,3,'Kappaggregat',1),
(53,38,57,'(p_width, p_width_band)','l_overlap_band','Kantenüberlapp',0,0,'Bündigfräser',0),
(54,38,59,'(p_pre_diameter, p_pre_teeth, p_pre_ang_kappa, p_pre_ang_lambda, p_width, p_pre_depth, p_kc05, p_pre_n, p_feed_speed, p_length, p_gap, 0, 1)','l_pre_values','Fräswerte Vorfräsen',0,1,'Vorfräse',0),
(55,38,58,'(l_pre_values, 3)','l_pre_pow','Energie Vorfäsen',0,2,'Vorfräse',1),
(56,38,58,'(l_pre_values, 2)','l_pre_pow_max','Max. Leistung Vorfräsen',0,3,'Vorfräse',0),
(57,38,58,'(l_pre_values, 1)','l_pre_m','Lastmoment Vorfräse',0,4,'Vorfräse',0),
(58,38,60,'(c_pre_motor[\'coeff_a\'], c_pre_motor[\'coeff_b\'], c_pre_motor[\'coeff_c\'], c_pre_motor[\'coeff_d\'], c_pre_motor[\'coeff_e\'], c_pre_motor[\'coeff_f\'], c_pre_motor[\'coeff_g\'], c_pre_motor[\'n_pole_pairs\'], c_pre_motor[\'f_nominal\'], c_pre_motor[\'m_nominal\'], c_pre_motor[\'p_nominal\'], p_length, p_gap, p_pre_n, l_pre_m)','l_pre_motor_loss','Motorwärmeenergie Vorfräse',1,5,'Vorfräse',1),
(59,38,61,'(c_pre_converter[\'p_90_100\'], c_pre_converter[\'p_50_100\'], c_pre_converter[\'p_0_100\'], c_pre_converter[\'p_90_50\'], c_pre_converter[\'p_50_50\'], c_pre_converter[\'p_0_50\'], c_pre_converter[\'p_50_25\'], c_pre_converter[\'p_0_25\'], c_pre_converter[\'s_r_equ\'], c_pre_motor[\'n_nominal\'], p_length, p_gap, p_pre_n, l_pre_m, c_pre_motor[\'m_nominal\'])','l_pre_coverter_loss','Wechselrichterverlust Vorfräse',2,6,'Vorfräse',1),
(60,38,62,'(p_feed_speed, p_trim_angle, p_length, p_gap, p_width_band)','l_trim_values','Kappsägenwerte',0,7,'Kappsäge',0),
(61,38,58,'(l_trim_values, 0)','l_trim_speed','Schnittgeschwindigkeit Kappsäge',0,8,'Kappsäge',0),
(62,38,58,'(l_trim_values, 1)','l_trim_t_load','Lastzeit Kappsäge',0,9,'Kappsäge',0),
(63,38,58,'(l_trim_values, 2)','l_trim_t_idle','Leerlaufzeit Kappsäge',0,10,'Kappsäge',0),
(64,38,59,'(p_trim_diameter, p_trim_teeth, p_trim_ang_kappa, p_trim_ang_lambda, p_trim_width, p_thickness_band, p_kc05_band, p_trim_n, l_trim_speed, l_trim_t_load, l_trim_t_idle, 0, 2)','l_trim_motor_values','Fräswerte Kappen',0,11,'Kappsäge',0),
(65,38,58,'(l_trim_motor_values, 3)','l_trim_pow','Energie Kappen',0,12,'Kappsäge',1),
(66,38,58,'(l_trim_motor_values, 2)','l_trim_pow_max','Max. Leistung Kappen',0,13,'Kappsäge',0),
(67,38,58,'(l_trim_motor_values, 1)','l_trim_m','Lastmoment Kappen',0,14,'Kappsäge',0),
(68,38,60,'(c_trim_motor[\'coeff_a\'], c_trim_motor[\'coeff_b\'], c_trim_motor[\'coeff_c\'], c_trim_motor[\'coeff_d\'], c_trim_motor[\'coeff_e\'], c_trim_motor[\'coeff_f\'], c_trim_motor[\'coeff_g\'], c_trim_motor[\'n_pole_pairs\'], c_trim_motor[\'f_nominal\'], c_trim_motor[\'m_nominal\'], c_trim_motor[\'p_nominal\'], l_trim_t_load, l_trim_t_idle, p_trim_n, l_trim_m)','l_trim_motor_loss','Motorwärmeenergie Kappsäge',3,15,'Kappsäge',1),
(69,38,61,'(c_trim_converter[\'p_90_100\'], c_trim_converter[\'p_50_100\'], c_trim_converter[\'p_0_100\'], c_trim_converter[\'p_90_50\'], c_trim_converter[\'p_50_50\'], c_trim_converter[\'p_0_50\'], c_trim_converter[\'p_50_25\'], c_trim_converter[\'p_0_25\'], c_trim_converter[\'s_r_equ\'], c_trim_motor[\'n_nominal\'], l_trim_t_load, l_trim_t_idle, p_trim_n, l_trim_m, c_trim_motor[\'m_nominal\'])','l_trim_converter_los','Wechselrichterverlust Kappsäge',4,16,'Kappsäge',1),
(70,38,59,'(p_flush_diameter, p_flush_teeth, p_flush_ang_kappa, p_flush_ang_lambda, p_thickness_band, l_overlap_band, p_kc05_band, p_flush_n, p_feed_speed, p_length, p_gap, 0, 2)','l_flush_values','Fräswerte Bündigfräse',0,17,'Bündigfräser',0),
(71,38,58,'(l_flush_values, 3)','l_flush_pow','Energie Bündigfräsen',0,18,'Bündigfräser',1),
(72,38,58,'(l_flush_values, 2)','l_flush_pow_max','Max. Leistung Bündigfräsen',0,19,'Bündigfräser',0),
(73,38,58,'(l_flush_values, 1)','l_flush_m','Lastmoment Bündigfräsen',0,20,'Bündigfräser',0),
(74,38,60,'(c_flush_motor[\'coeff_a\'], c_flush_motor[\'coeff_b\'], c_flush_motor[\'coeff_c\'], c_flush_motor[\'coeff_d\'], c_flush_motor[\'coeff_e\'], c_flush_motor[\'coeff_f\'], c_flush_motor[\'coeff_g\'], c_flush_motor[\'n_pole_pairs\'], c_flush_motor[\'f_nominal\'], c_flush_motor[\'m_nominal\'], c_flush_motor[\'p_nominal\'], p_length, p_gap, p_flush_n, l_flush_m)','l_flush_motor_loss','Motorwärmeenergie Bündigfräsen',5,21,'Bündigfräser',1),
(75,38,61,'(c_flush_converter[\'p_90_100\'], c_flush_converter[\'p_50_100\'], c_flush_converter[\'p_0_100\'], c_flush_converter[\'p_90_50\'], c_flush_converter[\'p_50_50\'], c_flush_converter[\'p_0_50\'], c_flush_converter[\'p_50_25\'], c_flush_converter[\'p_0_25\'], c_flush_converter[\'s_r_equ\'], c_flush_motor[\'n_nominal\'], p_length, p_gap, p_flush_n, l_flush_m, c_flush_motor[\'m_nominal\'])','l_flush_conv_loss','Wechselrichterverlust Bündigfräser',6,22,'Bündigfräser',1),
(76,38,59,'(p_round_diameter, p_round_teeth, 0, 90, p_round_radius, p_round_radius, p_kc05, p_round_n, p_feed_speed, p_length, p_gap, p_round_radius, 2)','l_round_values','Fräswerte Radienfräser',0,23,'Radienfräser',0),
(77,38,58,'(l_round_values, 3)','l_round_pow','Energie Radienfräsen',0,24,'Radienfräser',1),
(78,38,58,'(l_round_values, 2)','l_round_pow_max','Max. Leistung Radienfräsen',0,25,'Radienfräser',0),
(79,38,58,'(l_round_values, 1)','l_round_m','Lastmoment Radienfräsen',0,26,'Radienfräser',0),
(80,38,60,'(c_round_motor[\'coeff_a\'], c_round_motor[\'coeff_b\'], c_round_motor[\'coeff_c\'], c_round_motor[\'coeff_d\'], c_round_motor[\'coeff_e\'], c_round_motor[\'coeff_f\'], c_round_motor[\'coeff_g\'], c_round_motor[\'n_pole_pairs\'], c_round_motor[\'f_nominal\'], c_round_motor[\'m_nominal\'], c_round_motor[\'p_nominal\'], p_length, p_gap, p_round_n, l_round_m)','l_round_motor_loss','Motorwärme Radienfräser',7,27,'Radienfräser',1),
(81,38,61,'(c_round_converter[\'p_90_100\'], c_round_converter[\'p_50_100\'], c_round_converter[\'p_0_100\'], c_round_converter[\'p_90_50\'], c_round_converter[\'p_50_50\'], c_round_converter[\'p_0_50\'], c_round_converter[\'p_50_25\'], c_round_converter[\'p_0_25\'], c_round_converter[\'s_r_equ\'], c_round_motor[\'n_nominal\'], p_length, p_gap, p_round_n, l_round_m, c_round_motor[\'m_nominal\'])','l_round_conv_loss','Wechselrichterverlust Radienfräsen',8,28,'Radienfräser',1),
(82,38,63,'(p_scraper_ang, p_kc05_band, p_feed_speed, p_width, p_scraper_depth, p_length, p_gap)','l_scraper_pow','Ziehklingenenergie',0,29,'Ziehklingen',1),
(83,38,64,'(p_feed_spring_dist, p_feed_mu, p_feed_kc, p_feed_f0, p_feed_speed, p_feed_x1, p_feed_y1, p_feed_delta_x, p_feed_x3, p_feed_y3, p_feed_l, p_length, p_gap)','l_feed_pow','Vorschubspannenergie',0,30,'Vortrieb',1),
(84,38,65,'(c_feed_gears[\'gear_ratio\'], c_feed_gears[\'efficiency\'], c_feed_gears[\'m_nominal\'], p_feed_disc_diam, p_feed_speed, l_feed_pow)','l_feed_gear_values','Vorschubgetriebewerte',9,31,'Vortrieb',0),
(85,38,58,'(l_feed_gear_values, 0)','l_feed_gear_loss','Vorschubgetriebereibwärme',9,32,'Vortrieb',1),
(86,38,58,'(l_feed_gear_values, 1)','l_feed_m_total','Gesamtmoment Vorschubsystem',9,33,'Vortrieb',0),
(87,38,58,'(l_feed_gear_values, 2)','l_feed_n_in','Eingangsdrehzahl Vorschubgetriebe',9,34,'Vortrieb',0),
(88,38,58,'(l_feed_gear_values, 3)','l_feed_m','Lastmoment Vorspannung',9,35,'Vortrieb',0),
(89,38,60,'(c_feed_motor[\'coeff_a\'], c_feed_motor[\'coeff_b\'], c_feed_motor[\'coeff_c\'], c_feed_motor[\'coeff_d\'], c_feed_motor[\'coeff_e\'], c_feed_motor[\'coeff_f\'], c_feed_motor[\'coeff_g\'], c_feed_motor[\'n_pole_pairs\'], c_feed_motor[\'f_nominal\'], c_feed_motor[\'m_nominal\'], c_feed_motor[\'p_nominal\'], 1, 0, l_feed_n_in, l_feed_m_total)','l_feed_motor_loss','Motorwärme Vortrieb',10,36,'Vortrieb',1),
(90,38,66,'(p_glue_conductivity, p_glue_surface, p_glue_d)','l_glue_pow','Heizenergie Verleimaggregat',0,37,'Verleimaggregat',1);
/*!40000 ALTER TABLE `variants_loss_functions` 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 2023-07-19 13:23:54