gTmfJ3Q5

1-- MySQL Script generated by MySQL Workbench
2-- Mon Sep  9 20:04:51 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`.`professor`
22-- -----------------------------------------------------
23CREATE TABLE IF NOT EXISTS `mydb`.`professor` (
24  `MAT` INT(11) NOT NULL,
25  `NOME` VARCHAR(40) NOT NULL,
26  `SEXO` CHAR(1) NOT NULL,
27  PRIMARY KEY (`MAT`))
28ENGINE = InnoDB
29DEFAULT CHARACTER SET = utf8mb4
30COLLATE = utf8mb4_0900_ai_ci;
31
32
33-- -----------------------------------------------------
34-- Table `mydb`.`Diciplina`
35-- -----------------------------------------------------
36CREATE TABLE IF NOT EXISTS `mydb`.`Diciplina` (
37  `idDiciplina` INT NOT NULL,
38  `Nome` VARCHAR(45) NULL,
39  `CH` VARCHAR(45) NULL,
40  PRIMARY KEY (`idDiciplina`))
41ENGINE = InnoDB;
42
43
44-- -----------------------------------------------------
45-- Table `mydb`.`Prof_Disc`
46-- -----------------------------------------------------
47CREATE TABLE IF NOT EXISTS `mydb`.`Prof_Disc` (
48  `IdProf_Disc` INT NOT NULL,
49  `IdDisc` INT NOT NULL,
50  `professor_MAT` INT(11) NOT NULL,
51  INDEX `fk_Prof_Disc_professor_idx` (`professor_MAT` ASC) VISIBLE,
52  INDEX `fk_Prof_Disc_Diciplina1_idx` (`IdDisc` ASC) VISIBLE,
53  PRIMARY KEY (`IdProf_Disc`),
54  CONSTRAINT `fk_Prof_Disc_professor`
55    FOREIGN KEY (`professor_MAT`)
56    REFERENCES `mydb`.`professor` (`MAT`)
57    ON DELETE NO ACTION
58    ON UPDATE NO ACTION,
59  CONSTRAINT `fk_Prof_Disc_Diciplina1`
60    FOREIGN KEY (`IdDisc`)
61    REFERENCES `mydb`.`Diciplina` (`idDiciplina`)
62    ON DELETE NO ACTION
63    ON UPDATE NO ACTION)
64ENGINE = InnoDB;
65
66
67-- -----------------------------------------------------
68-- Table `mydb`.`Aluno`
69-- -----------------------------------------------------
70CREATE TABLE IF NOT EXISTS `mydb`.`Aluno` (
71  `Matricula` VARCHAR(3) NOT NULL,
72  `Nome` VARCHAR(30) NOT NULL,
73  `CPF` VARCHAR(11) NOT NULL,
74  PRIMARY KEY (`Matricula`))
75ENGINE = InnoDB;
76
77
78-- -----------------------------------------------------
79-- Table `mydb`.`Aluno_Disc`
80-- -----------------------------------------------------
81CREATE TABLE IF NOT EXISTS `mydb`.`Aluno_Disc` (
82  `IdDisc_Aluno` INT NOT NULL,
83  `Aluno_Matricula` VARCHAR(3) NOT NULL,
84  `Diciplina_idDiciplina` INT NOT NULL,
85  PRIMARY KEY (`IdDisc_Aluno`),
86  INDEX `fk_Aluno_Disc_Aluno1_idx` (`Aluno_Matricula` ASC) VISIBLE,
87  INDEX `fk_Aluno_Disc_Diciplina1_idx` (`Diciplina_idDiciplina` ASC) VISIBLE,
88  CONSTRAINT `fk_Aluno_Disc_Aluno1`
89    FOREIGN KEY (`Aluno_Matricula`)
90    REFERENCES `mydb`.`Aluno` (`Matricula`)
91    ON DELETE NO ACTION
92    ON UPDATE NO ACTION,
93  CONSTRAINT `fk_Aluno_Disc_Diciplina1`
94    FOREIGN KEY (`Diciplina_idDiciplina`)
95    REFERENCES `mydb`.`Diciplina` (`idDiciplina`)
96    ON DELETE NO ACTION
97    ON UPDATE NO ACTION)
98ENGINE = InnoDB;
99
100
101SET SQL_MODE=@OLD_SQL_MODE;
102SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
103SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;