· 8 years ago · Jan 05, 2018, 11:58 AM
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`.`Auto`
19-- -----------------------------------------------------
20CREATE TABLE IF NOT EXISTS `mydb`.`Auto` (
21 `SerieNummer` INT(11) NOT NULL AUTO_INCREMENT,
22 `Jaar` YEAR(4) NOT NULL,
23 `Model` VARCHAR(20) NOT NULL,
24 `Merk` VARCHAR(20) NOT NULL,
25 `Kleur` VARCHAR(15) NOT NULL,
26 PRIMARY KEY (`SerieNummer`))
27ENGINE = InnoDB
28AUTO_INCREMENT = 6
29DEFAULT CHARACTER SET = utf8;
30
31
32-- -----------------------------------------------------
33-- Table `mydb`.`Filiaal`
34-- -----------------------------------------------------
35CREATE TABLE IF NOT EXISTS `mydb`.`Filiaal` (
36 `FiliaalNummer` INT(11) NOT NULL AUTO_INCREMENT,
37 `Naam` VARCHAR(30) NOT NULL,
38 `Locatie` VARCHAR(30) NOT NULL,
39 `TelefoonNummer` INT(11) NOT NULL,
40 `Adres` VARCHAR(10) NOT NULL,
41 PRIMARY KEY (`FiliaalNummer`))
42ENGINE = InnoDB
43AUTO_INCREMENT = 6
44DEFAULT CHARACTER SET = utf8;
45
46
47-- -----------------------------------------------------
48-- Table `mydb`.`Klant`
49-- -----------------------------------------------------
50CREATE TABLE IF NOT EXISTS `mydb`.`Klant` (
51 `idKlanten` INT(11) NOT NULL AUTO_INCREMENT,
52 `Naam` VARCHAR(20) NOT NULL,
53 `Achternaam` VARCHAR(20) NOT NULL,
54 `Adres` VARCHAR(45) NOT NULL,
55 `Geboortedatum` DATE NOT NULL,
56 `Geslacht` VARCHAR(45) NOT NULL,
57 `Land` VARCHAR(45) NOT NULL,
58 `Telefoonnummer` INT(11) NOT NULL,
59 PRIMARY KEY (`idKlanten`))
60ENGINE = InnoDB
61AUTO_INCREMENT = 6
62DEFAULT CHARACTER SET = utf8;
63
64
65-- -----------------------------------------------------
66-- Table `mydb`.`VerkoopAuto`
67-- -----------------------------------------------------
68CREATE TABLE IF NOT EXISTS `mydb`.`VerkoopAuto` (
69 `VerkoopId` INT(11) NOT NULL AUTO_INCREMENT,
70 `KlantId` INT(11) NOT NULL,
71 `SerieNummer` INT(11) NOT NULL,
72 `FiliaalNummer` INT(11) NOT NULL,
73 `WerknemerId` INT(11) NOT NULL,
74 `DatumLevering` DATE NOT NULL,
75 PRIMARY KEY (`VerkoopId`),
76 UNIQUE INDEX `VerkoopId_UNIQUE` (`VerkoopId` ASC),
77 UNIQUE INDEX `SerieNummer_UNIQUE` (`SerieNummer` ASC),
78 INDEX `Key1_idx` (`FiliaalNummer` ASC),
79 INDEX `Key2_idx` (`SerieNummer` ASC),
80 INDEX `Key3_idx` (`KlantId` ASC),
81 CONSTRAINT `Key1`
82 FOREIGN KEY (`FiliaalNummer`)
83 REFERENCES `mydb`.`Filiaal` (`FiliaalNummer`)
84 ON DELETE NO ACTION
85 ON UPDATE NO ACTION,
86 CONSTRAINT `Key2`
87 FOREIGN KEY (`SerieNummer`)
88 REFERENCES `mydb`.`Auto` (`SerieNummer`)
89 ON DELETE NO ACTION
90 ON UPDATE NO ACTION,
91 CONSTRAINT `Key3`
92 FOREIGN KEY (`KlantId`)
93 REFERENCES `mydb`.`Klant` (`idKlanten`)
94 ON DELETE NO ACTION
95 ON UPDATE NO ACTION)
96ENGINE = InnoDB
97AUTO_INCREMENT = 6
98DEFAULT CHARACTER SET = utf8;
99
100
101-- -----------------------------------------------------
102-- Table `mydb`.`Werknemer`
103-- -----------------------------------------------------
104CREATE TABLE IF NOT EXISTS `mydb`.`Werknemer` (
105 `idWerknemers` INT(11) NOT NULL AUTO_INCREMENT,
106 `FiliaalNummer` INT(11) NOT NULL,
107 `Naam` VARCHAR(20) NOT NULL,
108 `Achternaam` VARCHAR(20) NOT NULL,
109 `Salaris` INT(11) NOT NULL,
110 `Geboortedatum` DATE NOT NULL,
111 `Adres` VARCHAR(20) NOT NULL,
112 `Functie` VARCHAR(15) NOT NULL,
113 PRIMARY KEY (`idWerknemers`),
114 INDEX `Key4_idx` (`FiliaalNummer` ASC),
115 CONSTRAINT `Key4`
116 FOREIGN KEY (`FiliaalNummer`)
117 REFERENCES `mydb`.`Filiaal` (`FiliaalNummer`)
118 ON DELETE NO ACTION
119 ON UPDATE NO ACTION)
120ENGINE = InnoDB
121AUTO_INCREMENT = 10
122DEFAULT CHARACTER SET = utf8;
123
124
125SET SQL_MODE=@OLD_SQL_MODE;
126SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
127SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;