e24BGXgk

1-- MySQL Workbench Forward Engineering
2
3SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
4SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
5SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL,ALLOW_INVALID_DATES';
6
7-- -----------------------------------------------------
8-- Schema mydb
9-- -----------------------------------------------------
10
11-- -----------------------------------------------------
12-- Schema mydb
13-- -----------------------------------------------------
14CREATE SCHEMA IF NOT EXISTS `mydb` DEFAULT CHARACTER SET utf8 ;
15USE `mydb` ;
16
17-- -----------------------------------------------------
18-- Table `mydb`.`Filiaal`
19-- -----------------------------------------------------
20CREATE TABLE IF NOT EXISTS `mydb`.`Filiaal` (
21  `FiliaalNummer` INT NULL AUTO_INCREMENT,
22  `Naam` VARCHAR(30) NULL,
23  `Locatie` VARCHAR(30) NULL,
24  `TelefoonNummer` INT NULL,
25  `Postcode` VARCHAR(10) NULL,
26  PRIMARY KEY (`FiliaalNummer`))
27ENGINE = InnoDB;
28
29
30-- -----------------------------------------------------
31-- Table `mydb`.`Auto's`
32-- -----------------------------------------------------
33CREATE TABLE IF NOT EXISTS `mydb`.`Auto's` (
34  `SerieNummer` INT NOT NULL,
35  `Jaar` YEAR NULL,
36  `Model` VARCHAR(20) NULL,
37  `Merk` VARCHAR(20) NULL,
38  `Kleur` VARCHAR(15) NULL,
39  PRIMARY KEY (`SerieNummer`))
40ENGINE = InnoDB;
41
42
43-- -----------------------------------------------------
44-- Table `mydb`.`Klanten`
45-- -----------------------------------------------------
46CREATE TABLE IF NOT EXISTS `mydb`.`Klanten` (
47  `idKlanten` INT NOT NULL,
48  `Naam` VARCHAR(20) NULL,
49  `Achternaam` VARCHAR(20) NULL,
50  `Adres` VARCHAR(45) NULL,
51  `Leeftijd` VARCHAR(45) NULL,
52  `Stad` VARCHAR(45) NULL,
53  `Geslacht` VARCHAR(45) NULL,
54  `Land` VARCHAR(45) NULL,
55  PRIMARY KEY (`idKlanten`))
56ENGINE = InnoDB;
57
58
59-- -----------------------------------------------------
60-- Table `mydb`.`Verkoop Auto's`
61-- -----------------------------------------------------
62CREATE TABLE IF NOT EXISTS `mydb`.`Verkoop Auto's` (
63  `VerkoopId` INT NOT NULL AUTO_INCREMENT,
64  `KlantId` INT NOT NULL,
65  `SerieNummer` INT NOT NULL,
66  `FiliaalNummer` INT NOT NULL,
67  `WerknemerId` INT NULL,
68  `DatumLevering` DATE NULL,
69  `AdresLevering` VARCHAR(40) NULL,
70  PRIMARY KEY (`VerkoopId`),
71  INDEX `Key1_idx` (`FiliaalNummer` ASC),
72  INDEX `Key2_idx` (`SerieNummer` ASC),
73  INDEX `Key3_idx` (`KlantId` ASC),
74  CONSTRAINT `Key1`
75    FOREIGN KEY (`FiliaalNummer`)
76    REFERENCES `mydb`.`Filiaal` (`FiliaalNummer`)
77    ON DELETE NO ACTION
78    ON UPDATE NO ACTION,
79  CONSTRAINT `Key2`
80    FOREIGN KEY (`SerieNummer`)
81    REFERENCES `mydb`.`Auto's` (`SerieNummer`)
82    ON DELETE NO ACTION
83    ON UPDATE NO ACTION,
84  CONSTRAINT `Key3`
85    FOREIGN KEY (`KlantId`)
86    REFERENCES `mydb`.`Klanten` (`idKlanten`)
87    ON DELETE NO ACTION
88    ON UPDATE NO ACTION)
89ENGINE = InnoDB;
90
91
92-- -----------------------------------------------------
93-- Table `mydb`.`Werknemers`
94-- -----------------------------------------------------
95CREATE TABLE IF NOT EXISTS `mydb`.`Werknemers` (
96  `idWerknemers` INT NOT NULL,
97  `FiliaalNummer` INT NOT NULL,
98  `Naam` VARCHAR(20) NULL,
99  `Achternaam` VARCHAR(20) NULL,
100  `Salaris` INT NULL,
101  `Leeftijd` INT NULL,
102  `Adres` VARCHAR(20) NULL,
103  PRIMARY KEY (`idWerknemers`),
104  INDEX `Key4_idx` (`FiliaalNummer` ASC),
105  CONSTRAINT `Key4`
106    FOREIGN KEY (`FiliaalNummer`)
107    REFERENCES `mydb`.`Filiaal` (`FiliaalNummer`)
108    ON DELETE NO ACTION
109    ON UPDATE NO ACTION)
110ENGINE = InnoDB;
111
112
113SET SQL_MODE=@OLD_SQL_MODE;
114SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
115SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;