· 6 years ago · Mar 24, 2019, 07:10 PM
1-- MySQL Script generated by MySQL Workbench
2-- Sun Mar 24 20:07:21 2019
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='ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION';
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`.`Kunde`
22-- -----------------------------------------------------
23CREATE TABLE IF NOT EXISTS `mydb`.`Kunde` (
24 `kid` INT NOT NULL,
25 `vorname` VARCHAR(45) NULL,
26 `nachname` VARCHAR(45) NULL,
27 `email` VARCHAR(45) NULL,
28 `telefonnummer` INT NULL,
29 PRIMARY KEY (`kid`))
30ENGINE = InnoDB;
31
32
33-- -----------------------------------------------------
34-- Table `mydb`.`Dienstleistung`
35-- -----------------------------------------------------
36CREATE TABLE IF NOT EXISTS `mydb`.`Dienstleistung` (
37 `did` INT NOT NULL,
38 `livemusik` TINYINT NULL,
39 `tontechnik` TINYINT NULL,
40 `dj` TINYINT NULL,
41 `fotograf` TINYINT NULL,
42 PRIMARY KEY (`did`))
43ENGINE = InnoDB;
44
45
46-- -----------------------------------------------------
47-- Table `mydb`.`Auftrag`
48-- -----------------------------------------------------
49CREATE TABLE IF NOT EXISTS `mydb`.`Auftrag` (
50 `aid` INT NOT NULL,
51 `beschreibung` VARCHAR(255) NULL,
52 `strasse` VARCHAR(45) NULL,
53 `hausnummer` VARCHAR(45) NULL,
54 `plz` VARCHAR(5) NULL,
55 `datum` DATE NULL,
56 `uhrzeit` TIME NULL,
57 `ort` VARCHAR(45) NULL,
58 `kid` INT NOT NULL,
59 `Dienstleistung_did` INT NOT NULL,
60 PRIMARY KEY (`aid`),
61 INDEX `fk_Auftrag_Kunde_idx` (`kid` ASC) VISIBLE,
62 INDEX `fk_Auftrag_Dienstleistung1_idx` (`Dienstleistung_did` ASC) VISIBLE,
63 CONSTRAINT `fk_Auftrag_Kunde`
64 FOREIGN KEY (`kid`)
65 REFERENCES `mydb`.`Kunde` (`kid`)
66 ON DELETE NO ACTION
67 ON UPDATE NO ACTION,
68 CONSTRAINT `fk_Auftrag_Dienstleistung1`
69 FOREIGN KEY (`Dienstleistung_did`)
70 REFERENCES `mydb`.`Dienstleistung` (`did`)
71 ON DELETE NO ACTION
72 ON UPDATE NO ACTION)
73ENGINE = InnoDB;
74
75
76-- -----------------------------------------------------
77-- Table `mydb`.`Rezensionen`
78-- -----------------------------------------------------
79CREATE TABLE IF NOT EXISTS `mydb`.`Rezensionen` (
80 `rid` INT NOT NULL,
81 `vorname` VARCHAR(45) NULL,
82 `ort` VARCHAR(45) NULL,
83 `beschreibung` VARCHAR(255) NULL,
84 `Dienstleistung_did` INT NOT NULL,
85 PRIMARY KEY (`rid`),
86 INDEX `fk_Rezensionen_Dienstleistung1_idx` (`Dienstleistung_did` ASC) VISIBLE,
87 CONSTRAINT `fk_Rezensionen_Dienstleistung1`
88 FOREIGN KEY (`Dienstleistung_did`)
89 REFERENCES `mydb`.`Dienstleistung` (`did`)
90 ON DELETE NO ACTION
91 ON UPDATE NO ACTION)
92ENGINE = InnoDB;
93
94
95SET SQL_MODE=@OLD_SQL_MODE;
96SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
97SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;