· 7 years ago · Feb 20, 2019, 11:40 AM
1-- MySQL Script generated by MySQL Workbench
2-- Wed Feb 20 12:35:01 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 CRMS
12-- -----------------------------------------------------
13
14-- -----------------------------------------------------
15-- Schema CRMS
16-- -----------------------------------------------------
17CREATE SCHEMA IF NOT EXISTS `CRMS` DEFAULT CHARACTER SET utf8 ;
18USE `CRMS` ;
19
20-- -----------------------------------------------------
21-- Table `CRMS`.`Corso`
22-- -----------------------------------------------------
23CREATE TABLE IF NOT EXISTS `CRMS`.`Corso` (
24 `idCorso` INT NOT NULL,
25 `Descrizione` VARCHAR(45) NOT NULL,
26 PRIMARY KEY (`idCorso`))
27ENGINE = InnoDB;
28
29
30-- -----------------------------------------------------
31-- Table `CRMS`.`Docente`
32-- -----------------------------------------------------
33CREATE TABLE IF NOT EXISTS `CRMS`.`Docente` (
34 `CF` VARCHAR(45) NOT NULL,
35 `Nome` VARCHAR(45) NOT NULL,
36 `Cognome` VARCHAR(45) NOT NULL,
37 `Indirizzo` VARCHAR(45) NOT NULL,
38 `Corso` INT NOT NULL,
39 PRIMARY KEY (`CF`),
40 INDEX `Corso_idx` (`Corso` ASC) VISIBLE,
41 CONSTRAINT `Corso`
42 FOREIGN KEY (`Corso`)
43 REFERENCES `CRMS`.`Corso` (`idCorso`)
44 ON DELETE NO ACTION
45 ON UPDATE NO ACTION)
46ENGINE = InnoDB;
47
48
49-- -----------------------------------------------------
50-- Table `CRMS`.`Aula`
51-- -----------------------------------------------------
52CREATE TABLE IF NOT EXISTS `CRMS`.`Aula` (
53 `idAula` INT NOT NULL,
54 `Descrizione` VARCHAR(45) NULL,
55 PRIMARY KEY (`idAula`))
56ENGINE = InnoDB;
57
58
59-- -----------------------------------------------------
60-- Table `CRMS`.`Cadenza Temporale`
61-- -----------------------------------------------------
62CREATE TABLE IF NOT EXISTS `CRMS`.`Cadenza Temporale` (
63 `idCadenza` INT NOT NULL,
64 `Giorno` VARCHAR(45) NOT NULL,
65 `InzioOrario` TIME NOT NULL,
66 `FineOrario` TIME NOT NULL,
67 `Prenotazione` INT NOT NULL,
68 PRIMARY KEY (`idCadenza`),
69 INDEX `Prenotazione_idx` (`Prenotazione` ASC) VISIBLE,
70 CONSTRAINT `Prenotazione`
71 FOREIGN KEY (`Prenotazione`)
72 REFERENCES `CRMS`.`Prenotazione` (`idPrenotazione`)
73 ON DELETE NO ACTION
74 ON UPDATE NO ACTION)
75ENGINE = InnoDB;
76
77
78-- -----------------------------------------------------
79-- Table `CRMS`.`Prenotazione`
80-- -----------------------------------------------------
81CREATE TABLE IF NOT EXISTS `CRMS`.`Prenotazione` (
82 `idPrenotazione` INT NOT NULL,
83 `InizioPrenotazione` DATETIME NOT NULL,
84 `FinePrenotazione` DATETIME NOT NULL,
85 `Aula` INT NOT NULL,
86 `Docente` VARCHAR(45) NOT NULL,
87 `Cadenza` INT NULL,
88 PRIMARY KEY (`idPrenotazione`),
89 INDEX `Aula_idx` (`Aula` ASC) VISIBLE,
90 INDEX `Docente_idx` (`Docente` ASC) VISIBLE,
91 INDEX `Cadenza_idx` (`Cadenza` ASC) VISIBLE,
92 CONSTRAINT `Aula`
93 FOREIGN KEY (`Aula`)
94 REFERENCES `CRMS`.`Aula` (`idAula`)
95 ON DELETE NO ACTION
96 ON UPDATE NO ACTION,
97 CONSTRAINT `Docente`
98 FOREIGN KEY (`Docente`)
99 REFERENCES `CRMS`.`Docente` (`CF`)
100 ON DELETE NO ACTION
101 ON UPDATE NO ACTION,
102 CONSTRAINT `Cadenza`
103 FOREIGN KEY (`Cadenza`)
104 REFERENCES `CRMS`.`Cadenza Temporale` (`idCadenza`)
105 ON DELETE NO ACTION
106 ON UPDATE NO ACTION)
107ENGINE = InnoDB;
108
109
110SET SQL_MODE=@OLD_SQL_MODE;
111SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
112SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;