· 6 years ago · Aug 26, 2019, 11:42 PM
1-- MySQL Script generated by MySQL Workbench
2-- Mon Aug 26 20:38:38 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`.`Curso`
22-- -----------------------------------------------------
23CREATE TABLE IF NOT EXISTS `mydb`.`Curso` (
24 `id` INT NOT NULL AUTO_INCREMENT,
25 `nome` VARCHAR(45) NOT NULL,
26 PRIMARY KEY (`id`),
27 UNIQUE INDEX `id_UNIQUE` (`id` ASC),
28 UNIQUE INDEX `nome_UNIQUE` (`nome` ASC))
29ENGINE = InnoDB;
30
31
32-- -----------------------------------------------------
33-- Table `mydb`.`Aluno`
34-- -----------------------------------------------------
35CREATE TABLE IF NOT EXISTS `mydb`.`Aluno` (
36 `id` INT NOT NULL AUTO_INCREMENT,
37 `nome` VARCHAR(45) NOT NULL,
38 `matricula` VARCHAR(10) NOT NULL,
39 `email` VARCHAR(45) NULL,
40 `telefone` VARCHAR(15) NULL,
41 `idCurso` INT NOT NULL,
42 PRIMARY KEY (`id`),
43 UNIQUE INDEX `id_UNIQUE` (`id` ASC),
44 UNIQUE INDEX `matricula_UNIQUE` (`matricula` ASC),
45 INDEX `fk_Aluno_Curso1_idx` (`idCurso` ASC),
46 CONSTRAINT `fk_Aluno_Curso1`
47 FOREIGN KEY (`idCurso`)
48 REFERENCES `mydb`.`Curso` (`id`)
49 ON DELETE NO ACTION
50 ON UPDATE NO ACTION)
51ENGINE = InnoDB;
52
53
54-- -----------------------------------------------------
55-- Table `mydb`.`Disciplina`
56-- -----------------------------------------------------
57CREATE TABLE IF NOT EXISTS `mydb`.`Disciplina` (
58 `id` INT NOT NULL AUTO_INCREMENT,
59 `nome` VARCHAR(45) NOT NULL,
60 `idCurso` INT NOT NULL,
61 PRIMARY KEY (`id`),
62 UNIQUE INDEX `id_UNIQUE` (`id` ASC),
63 INDEX `fk_Disciplina_Curso_idx` (`idCurso` ASC),
64 CONSTRAINT `fk_Disciplina_Curso`
65 FOREIGN KEY (`idCurso`)
66 REFERENCES `mydb`.`Curso` (`id`)
67 ON DELETE NO ACTION
68 ON UPDATE NO ACTION)
69ENGINE = InnoDB;
70
71
72-- -----------------------------------------------------
73-- Table `mydb`.`Matricula`
74-- -----------------------------------------------------
75CREATE TABLE IF NOT EXISTS `mydb`.`Matricula` (
76 `id` INT NOT NULL AUTO_INCREMENT,
77 `idAluno` INT NOT NULL,
78 `idDisciplina` INT NOT NULL,
79 INDEX `fk_table1_Aluno1_idx` (`idAluno` ASC),
80 INDEX `fk_table1_Disciplina1_idx` (`idDisciplina` ASC),
81 UNIQUE INDEX `id_UNIQUE` (`id` ASC),
82 PRIMARY KEY (`id`),
83 CONSTRAINT `fk_table1_Aluno1`
84 FOREIGN KEY (`idAluno`)
85 REFERENCES `mydb`.`Aluno` (`id`)
86 ON DELETE NO ACTION
87 ON UPDATE NO ACTION,
88 CONSTRAINT `fk_table1_Disciplina1`
89 FOREIGN KEY (`idDisciplina`)
90 REFERENCES `mydb`.`Disciplina` (`id`)
91 ON DELETE NO ACTION
92 ON UPDATE NO ACTION)
93ENGINE = InnoDB;
94
95
96SET SQL_MODE=@OLD_SQL_MODE;
97SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
98SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;