· 4 years ago · Dec 22, 2020, 11:14 PM
1-- MySQL Workbench Forward Engineering
2
3SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
4SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
5SET @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';
6
7-- -----------------------------------------------------
8-- Schema mydb
9-- -----------------------------------------------------
10
11-- -----------------------------------------------------
12-- Schema mydb
13-- -----------------------------------------------------
14CREATE SCHEMA IF NOT EXISTS `mydb` DEFAULT CHARACTER SET utf8 ;
15USE `mydb` ;
16
17-- -----------------------------------------------------
18-- Table `mydb`.`Prateleira`
19-- -----------------------------------------------------
20CREATE TABLE IF NOT EXISTS `mydb`.`Prateleira` (
21 `prateleiraID` INT NOT NULL,
22 `capacidade` VARCHAR(45) NULL,
23 `ocupacao` VARCHAR(45) NULL,
24 PRIMARY KEY (`prateleiraID`))
25ENGINE = InnoDB;
26
27
28-- -----------------------------------------------------
29-- Table `mydb`.`Localizacao`
30-- -----------------------------------------------------
31CREATE TABLE IF NOT EXISTS `mydb`.`Localizacao` (
32 `idLocalizacao` INT NOT NULL,
33 `zonaID` VARCHAR(10) NULL,
34 `Localizacaocol` VARCHAR(45) NULL,
35 `Prateleira_prateleiraID` INT NOT NULL,
36 PRIMARY KEY (`idLocalizacao`),
37 INDEX `fk_Localizacao_Prateleira1_idx` (`Prateleira_prateleiraID` ASC) VISIBLE,
38 CONSTRAINT `fk_Localizacao_Prateleira1`
39 FOREIGN KEY (`Prateleira_prateleiraID`)
40 REFERENCES `mydb`.`Prateleira` (`prateleiraID`)
41 ON DELETE NO ACTION
42 ON UPDATE NO ACTION)
43ENGINE = InnoDB;
44
45
46-- -----------------------------------------------------
47-- Table `mydb`.`Palete`
48-- -----------------------------------------------------
49CREATE TABLE IF NOT EXISTS `mydb`.`Palete` (
50 `qrCode` VARCHAR(10) NOT NULL,
51 `tipoMaterial` VARCHAR(30) NULL,
52 `zonaID` INT NULL,
53 `Localizacao_idLocalizacao` INT NOT NULL,
54 PRIMARY KEY (`qrCode`),
55 INDEX `fk_Palete_Localizacao1_idx` (`Localizacao_idLocalizacao` ASC) VISIBLE,
56 CONSTRAINT `fk_Palete_Localizacao1`
57 FOREIGN KEY (`Localizacao_idLocalizacao`)
58 REFERENCES `mydb`.`Localizacao` (`idLocalizacao`)
59 ON DELETE NO ACTION
60 ON UPDATE NO ACTION)
61ENGINE = InnoDB;
62
63
64-- -----------------------------------------------------
65-- Table `mydb`.`InfoTransporte`
66-- -----------------------------------------------------
67CREATE TABLE IF NOT EXISTS `mydb`.`InfoTransporte` (
68 `idInfoTransporte` INT NOT NULL,
69 `Palete_qrCode` VARCHAR(10) NOT NULL,
70 `Prateleira_prateleiraID` INT NOT NULL,
71 `zonaID` VARCHAR(10) NULL,
72 PRIMARY KEY (`idInfoTransporte`),
73 INDEX `fk_InfoTransporte_Palete1_idx` (`Palete_qrCode` ASC) VISIBLE,
74 INDEX `fk_InfoTransporte_Prateleira1_idx` (`Prateleira_prateleiraID` ASC) VISIBLE,
75 CONSTRAINT `fk_InfoTransporte_Palete1`
76 FOREIGN KEY (`Palete_qrCode`)
77 REFERENCES `mydb`.`Palete` (`qrCode`)
78 ON DELETE NO ACTION
79 ON UPDATE NO ACTION,
80 CONSTRAINT `fk_InfoTransporte_Prateleira1`
81 FOREIGN KEY (`Prateleira_prateleiraID`)
82 REFERENCES `mydb`.`Prateleira` (`prateleiraID`)
83 ON DELETE NO ACTION
84 ON UPDATE NO ACTION)
85ENGINE = InnoDB;
86
87
88-- -----------------------------------------------------
89-- Table `mydb`.`Robot`
90-- -----------------------------------------------------
91CREATE TABLE IF NOT EXISTS `mydb`.`Robot` (
92 `RobotID` INT NOT NULL,
93 `Disponivel` INT NULL,
94 `Recolheu` INT NULL,
95 `InfoTransporte_idInfoTransporte` INT NOT NULL,
96 `Localizacao_idLocalizacao` INT NOT NULL,
97 PRIMARY KEY (`RobotID`),
98 INDEX `fk_Robot_InfoTransporte1_idx` (`InfoTransporte_idInfoTransporte` ASC) VISIBLE,
99 INDEX `fk_Robot_Localizacao1_idx` (`Localizacao_idLocalizacao` ASC) VISIBLE,
100 CONSTRAINT `fk_Robot_InfoTransporte1`
101 FOREIGN KEY (`InfoTransporte_idInfoTransporte`)
102 REFERENCES `mydb`.`InfoTransporte` (`idInfoTransporte`)
103 ON DELETE NO ACTION
104 ON UPDATE NO ACTION,
105 CONSTRAINT `fk_Robot_Localizacao1`
106 FOREIGN KEY (`Localizacao_idLocalizacao`)
107 REFERENCES `mydb`.`Localizacao` (`idLocalizacao`)
108 ON DELETE NO ACTION
109 ON UPDATE NO ACTION)
110ENGINE = InnoDB;
111
112
113-- -----------------------------------------------------
114-- Table `mydb`.`Gestor`
115-- -----------------------------------------------------
116CREATE TABLE IF NOT EXISTS `mydb`.`Gestor` (
117 `idGestor` INT NOT NULL,
118 `Nome` VARCHAR(30) NULL,
119 `Password` VARCHAR(30) NULL,
120 `Online` INT NULL,
121 PRIMARY KEY (`idGestor`))
122ENGINE = InnoDB;
123
124
125SET SQL_MODE=@OLD_SQL_MODE;
126SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
127SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;
128