Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- MySQL Script generated by MySQL Workbench
- -- Wed Feb 20 12:35:01 2019
- -- Model: New Model Version: 1.0
- -- MySQL Workbench Forward Engineering
- SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
- SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
- SET @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';
- -- -----------------------------------------------------
- -- Schema CRMS
- -- -----------------------------------------------------
- -- -----------------------------------------------------
- -- Schema CRMS
- -- -----------------------------------------------------
- CREATE SCHEMA IF NOT EXISTS `CRMS` DEFAULT CHARACTER SET utf8 ;
- USE `CRMS` ;
- -- -----------------------------------------------------
- -- Table `CRMS`.`Corso`
- -- -----------------------------------------------------
- CREATE TABLE IF NOT EXISTS `CRMS`.`Corso` (
- `idCorso` INT NOT NULL,
- `Descrizione` VARCHAR(45) NOT NULL,
- PRIMARY KEY (`idCorso`))
- ENGINE = InnoDB;
- -- -----------------------------------------------------
- -- Table `CRMS`.`Docente`
- -- -----------------------------------------------------
- CREATE TABLE IF NOT EXISTS `CRMS`.`Docente` (
- `CF` VARCHAR(45) NOT NULL,
- `Nome` VARCHAR(45) NOT NULL,
- `Cognome` VARCHAR(45) NOT NULL,
- `Indirizzo` VARCHAR(45) NOT NULL,
- `Corso` INT NOT NULL,
- PRIMARY KEY (`CF`),
- INDEX `Corso_idx` (`Corso` ASC) VISIBLE,
- CONSTRAINT `Corso`
- FOREIGN KEY (`Corso`)
- REFERENCES `CRMS`.`Corso` (`idCorso`)
- ON DELETE NO ACTION
- ON UPDATE NO ACTION)
- ENGINE = InnoDB;
- -- -----------------------------------------------------
- -- Table `CRMS`.`Aula`
- -- -----------------------------------------------------
- CREATE TABLE IF NOT EXISTS `CRMS`.`Aula` (
- `idAula` INT NOT NULL,
- `Descrizione` VARCHAR(45) NULL,
- PRIMARY KEY (`idAula`))
- ENGINE = InnoDB;
- -- -----------------------------------------------------
- -- Table `CRMS`.`Cadenza Temporale`
- -- -----------------------------------------------------
- CREATE TABLE IF NOT EXISTS `CRMS`.`Cadenza Temporale` (
- `idCadenza` INT NOT NULL,
- `Giorno` VARCHAR(45) NOT NULL,
- `InzioOrario` TIME NOT NULL,
- `FineOrario` TIME NOT NULL,
- `Prenotazione` INT NOT NULL,
- PRIMARY KEY (`idCadenza`),
- INDEX `Prenotazione_idx` (`Prenotazione` ASC) VISIBLE,
- CONSTRAINT `Prenotazione`
- FOREIGN KEY (`Prenotazione`)
- REFERENCES `CRMS`.`Prenotazione` (`idPrenotazione`)
- ON DELETE NO ACTION
- ON UPDATE NO ACTION)
- ENGINE = InnoDB;
- -- -----------------------------------------------------
- -- Table `CRMS`.`Prenotazione`
- -- -----------------------------------------------------
- CREATE TABLE IF NOT EXISTS `CRMS`.`Prenotazione` (
- `idPrenotazione` INT NOT NULL,
- `InizioPrenotazione` DATETIME NOT NULL,
- `FinePrenotazione` DATETIME NOT NULL,
- `Aula` INT NOT NULL,
- `Docente` VARCHAR(45) NOT NULL,
- `Cadenza` INT NULL,
- PRIMARY KEY (`idPrenotazione`),
- INDEX `Aula_idx` (`Aula` ASC) VISIBLE,
- INDEX `Docente_idx` (`Docente` ASC) VISIBLE,
- INDEX `Cadenza_idx` (`Cadenza` ASC) VISIBLE,
- CONSTRAINT `Aula`
- FOREIGN KEY (`Aula`)
- REFERENCES `CRMS`.`Aula` (`idAula`)
- ON DELETE NO ACTION
- ON UPDATE NO ACTION,
- CONSTRAINT `Docente`
- FOREIGN KEY (`Docente`)
- REFERENCES `CRMS`.`Docente` (`CF`)
- ON DELETE NO ACTION
- ON UPDATE NO ACTION,
- CONSTRAINT `Cadenza`
- FOREIGN KEY (`Cadenza`)
- REFERENCES `CRMS`.`Cadenza Temporale` (`idCadenza`)
- ON DELETE NO ACTION
- ON UPDATE NO ACTION)
- ENGINE = InnoDB;
- SET SQL_MODE=@OLD_SQL_MODE;
- SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
- SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement