· 9 years ago · Jan 19, 2017, 11:28 AM
1-- MySQL Script generated by MySQL Workbench
2-- 01/19/17 12:27:20
3-- Model: New Model Version: 1.0
4-- MySQL Workbench Forward Engineering
5
6SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
7SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
8SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL,ALLOW_INVALID_DATES';
9
10-- -----------------------------------------------------
11-- Schema mydb
12-- -----------------------------------------------------
13
14-- -----------------------------------------------------
15-- Schema mydb
16-- -----------------------------------------------------
17CREATE SCHEMA IF NOT EXISTS `mydb` DEFAULT CHARACTER SET utf8 ;
18USE `mydb` ;
19
20-- -----------------------------------------------------
21-- Table `mydb`.`bung_soort`
22-- -----------------------------------------------------
23CREATE TABLE IF NOT EXISTS `mydb`.`bung_soort` (
24 `bungID` INT NOT NULL,
25 `type` VARCHAR(45) NOT NULL,
26 `slaapkamers` VARCHAR(45) NULL,
27 `aantpersonen` VARCHAR(45) NULL,
28 `huurprijs` INT NULL,
29 PRIMARY KEY (`bungID`, `type`))
30ENGINE = InnoDB;
31
32
33-- -----------------------------------------------------
34-- Table `mydb`.`voorziening`
35-- -----------------------------------------------------
36CREATE TABLE IF NOT EXISTS `mydb`.`voorziening` (
37 `voorziening` INT NOT NULL,
38 PRIMARY KEY (`voorziening`))
39ENGINE = InnoDB;
40
41
42-- -----------------------------------------------------
43-- Table `mydb`.`klantgegevens`
44-- -----------------------------------------------------
45CREATE TABLE IF NOT EXISTS `mydb`.`klantgegevens` (
46 `naam` VARCHAR(45) NULL,
47 `adres` VARCHAR(45) NULL,
48 `woonplaats` VARCHAR(45) NULL,
49 `telefoon` INT NULL,
50 `klantID` VARCHAR(45) NOT NULL,
51 PRIMARY KEY (`klantID`))
52ENGINE = InnoDB;
53
54
55-- -----------------------------------------------------
56-- Table `mydb`.`reserving`
57-- -----------------------------------------------------
58CREATE TABLE IF NOT EXISTS `mydb`.`reserving` (
59 `reservID` INT NOT NULL,
60 `aantgast` INT NULL,
61 `reservdate` DATE NULL,
62 `arrival` DATE NULL,
63 `depart` DATE NULL,
64 `klantgegevens_klantID` VARCHAR(45) NOT NULL,
65 PRIMARY KEY (`reservID`),
66 INDEX `fk_reserving_klantgegevens1_idx` (`klantgegevens_klantID` ASC),
67 CONSTRAINT `fk_reserving_klantgegevens1`
68 FOREIGN KEY (`klantgegevens_klantID`)
69 REFERENCES `mydb`.`klantgegevens` (`klantID`)
70 ON DELETE NO ACTION
71 ON UPDATE NO ACTION)
72ENGINE = InnoDB;
73
74
75-- -----------------------------------------------------
76-- Table `mydb`.`gereserveerd`
77-- -----------------------------------------------------
78CREATE TABLE IF NOT EXISTS `mydb`.`gereserveerd` (
79 `bung_soort_bungID` INT NOT NULL,
80 `bung_soort_type` VARCHAR(45) NOT NULL,
81 `reserving_klantID` INT NOT NULL,
82 `reserving_reservID` INT NOT NULL,
83 PRIMARY KEY (`bung_soort_bungID`, `bung_soort_type`, `reserving_klantID`, `reserving_reservID`),
84 INDEX `fk_bung_soort_has_reserving_bung_soort1_idx` (`bung_soort_bungID` ASC, `bung_soort_type` ASC),
85 INDEX `fk_gereserveerd_reserving1_idx` (`reserving_reservID` ASC),
86 CONSTRAINT `fk_bung_soort_has_reserving_bung_soort1`
87 FOREIGN KEY (`bung_soort_bungID` , `bung_soort_type`)
88 REFERENCES `mydb`.`bung_soort` (`bungID` , `type`)
89 ON DELETE NO ACTION
90 ON UPDATE NO ACTION,
91 CONSTRAINT `fk_gereserveerd_reserving1`
92 FOREIGN KEY (`reserving_reservID`)
93 REFERENCES `mydb`.`reserving` (`reservID`)
94 ON DELETE NO ACTION
95 ON UPDATE NO ACTION)
96ENGINE = InnoDB;
97
98
99-- -----------------------------------------------------
100-- Table `mydb`.`soorten voorziening`
101-- -----------------------------------------------------
102CREATE TABLE IF NOT EXISTS `mydb`.`soorten voorziening` (
103 `bung_soort_bungID` INT NOT NULL,
104 `bung_soort_type` VARCHAR(45) NOT NULL,
105 `voorziening_voorziening` INT NOT NULL,
106 PRIMARY KEY (`bung_soort_bungID`, `bung_soort_type`, `voorziening_voorziening`),
107 INDEX `fk_bung_soort_has_voorziening_voorziening1_idx` (`voorziening_voorziening` ASC),
108 INDEX `fk_bung_soort_has_voorziening_bung_soort1_idx` (`bung_soort_bungID` ASC, `bung_soort_type` ASC),
109 CONSTRAINT `fk_bung_soort_has_voorziening_bung_soort1`
110 FOREIGN KEY (`bung_soort_bungID` , `bung_soort_type`)
111 REFERENCES `mydb`.`bung_soort` (`bungID` , `type`)
112 ON DELETE NO ACTION
113 ON UPDATE NO ACTION,
114 CONSTRAINT `fk_bung_soort_has_voorziening_voorziening1`
115 FOREIGN KEY (`voorziening_voorziening`)
116 REFERENCES `mydb`.`voorziening` (`voorziening`)
117 ON DELETE NO ACTION
118 ON UPDATE NO ACTION)
119ENGINE = InnoDB;
120
121
122SET SQL_MODE=@OLD_SQL_MODE;
123SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
124SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;