--
-- Host: localhost    Database: Air_Check
-- ------------------------------------------------------


--
-- Table structure for table `tblContact`
--

CREATE TABLE `tblContact` (
  `Naam` varchar(100) DEFAULT NULL,
  `Emailadres` varchar(100) DEFAULT NULL,
  `Bericht` varchar(500) DEFAULT NULL,
  `Tijdstip` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tblContact`
--

INSERT INTO `tblContact` VALUES ('Bert Van Compernolle','berten@hotmail.com','Waar kan je dit product kopen?','2017-06-02 11:25:10'),('Steven Dujardin','steven.dujardin@student.howest.be','Hey!','2017-06-02 11:25:43');

--
-- Table structure for table `tblMetingCO2`
--

CREATE TABLE `tblMetingCO2` (
  `CO2` decimal(15,1) DEFAULT NULL,
  `Tijdstip` datetime DEFAULT NULL,
  `Serienummer` varchar(100) NOT NULL,
  KEY `fk_tblMetingCO2_tblGegevens_idx` (`Serienummer`),
  CONSTRAINT `fk_tblMetingCO2_tblGegevens` FOREIGN KEY (`Serienummer`) REFERENCES `tblGegevens` (`Serienummer`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tblMetingCO2`
--

INSERT INTO `tblMetingCO2` VALUES (450.0,'2017-05-30 09:37:27','AZERTY1234567890'),(460.0,'2017-05-30 09:38:27','AZERTY1234567890'),(500.0,'2017-05-30 09:37:27','QWERTY1234567890'),(470.0,'2017-05-30 09:38:27','QWERTY1234567890');

--
-- Table structure for table `tblMetingLTC`
--

CREATE TABLE `tblMetingLTC` (
  `Luchtvochtigheid` decimal(5,1) DEFAULT NULL,
  `Temperatuur` decimal(15,1) DEFAULT NULL,
  `Comfortniveau` decimal(15,1) DEFAULT NULL,
  `Tijdstip` datetime DEFAULT NULL,
  `Serienummer` varchar(100) NOT NULL,
  KEY `fk_tblMetingLTC_tblGegevens1_idx` (`Serienummer`),
  CONSTRAINT `fk_tblMetingLTC_tblGegevens1` FOREIGN KEY (`Serienummer`) REFERENCES `tblGegevens` (`Serienummer`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tblMetingLTC`
--

INSERT INTO `tblMetingLTC` VALUES (23.0,50.0,65.0,'2017-05-30 09:37:00','AZERTY1234567890'),(24.0,45.0,67.0,'2017-05-30 09:38:00','AZERTY1234567890'),(22.0,30.0,41.0,'2017-05-30 09:37:00','QWERTY1234567890'),(21.0,35.0,41.0,'2017-05-30 09:38:00','QWERTY1234567890');

--
-- Table structure for table `tblMetingsintervalCO2`
--

CREATE TABLE `tblMetingsintervalCO2` (
  `Metingsinterval` int(11) DEFAULT NULL,
  `Serienummer` varchar(100) NOT NULL,
  PRIMARY KEY (`Serienummer`),
  CONSTRAINT `fk_tblMetingsintervalCO2_tblMetingCO21` FOREIGN KEY (`Serienummer`) REFERENCES `tblMetingCO2` (`Serienummer`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tblMetingsintervalCO2`
--

INSERT INTO `tblMetingsintervalCO2` VALUES (60,'AZERTY1234567890'),(30,'QWERTY1234567890');

--
-- Table structure for table `tblMetingsintervalLTC`
--

CREATE TABLE `tblMetingsintervalLTC` (
  `Metingsinterval` int(11) DEFAULT NULL,
  `Serienummer` varchar(100) NOT NULL,
  PRIMARY KEY (`Serienummer`),
  CONSTRAINT `fk_tblMetingsintervalLTC_tblMetingLTC1` FOREIGN KEY (`Serienummer`) REFERENCES `tblMetingLTC` (`Serienummer`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tblMetingsintervalLTC`
--

INSERT INTO `tblMetingsintervalLTC` VALUES (120,'AZERTY1234567890'),(200,'QWERTY1234567890');

--
-- Dumping events for database 'Air_Check'
--

--
-- Dumping routines for database 'Air_Check'
--


