· 7 years ago · Nov 20, 2018, 08:26 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-- Schema pizzahutalmacenbd
12-- -----------------------------------------------------
13DROP SCHEMA IF EXISTS `pizzahutalmacenbd` ;
14
15-- -----------------------------------------------------
16-- Schema pizzahutalmacenbd
17-- -----------------------------------------------------
18CREATE SCHEMA IF NOT EXISTS `pizzahutalmacenbd` DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci ;
19USE `pizzahutalmacenbd` ;
20
21-- -----------------------------------------------------
22-- Table `pizzahutalmacenbd`.`guiaremision`
23-- -----------------------------------------------------
24DROP TABLE IF EXISTS `pizzahutalmacenbd`.`guiaremision` ;
25
26CREATE TABLE IF NOT EXISTS `pizzahutalmacenbd`.`guiaremision` (
27 `idGuiaRemision` INT(11) NOT NULL,
28 `FechaEntrega` DATE NOT NULL,
29 PRIMARY KEY (`idGuiaRemision`))
30ENGINE = InnoDB
31DEFAULT CHARACTER SET = utf8;
32
33
34-- -----------------------------------------------------
35-- Table `pizzahutalmacenbd`.`tipoinsumo`
36-- -----------------------------------------------------
37DROP TABLE IF EXISTS `pizzahutalmacenbd`.`tipoinsumo` ;
38
39CREATE TABLE IF NOT EXISTS `pizzahutalmacenbd`.`tipoinsumo` (
40 `idTipoInsumo` INT(11) NOT NULL,
41 `Tipo` VARCHAR(45) NOT NULL,
42 PRIMARY KEY (`idTipoInsumo`))
43ENGINE = InnoDB
44DEFAULT CHARACTER SET = utf8;
45
46
47-- -----------------------------------------------------
48-- Table `pizzahutalmacenbd`.`unidad`
49-- -----------------------------------------------------
50DROP TABLE IF EXISTS `pizzahutalmacenbd`.`unidad` ;
51
52CREATE TABLE IF NOT EXISTS `pizzahutalmacenbd`.`unidad` (
53 `idUnidad` INT(11) NOT NULL,
54 `Unidad` VARCHAR(45) NOT NULL,
55 PRIMARY KEY (`idUnidad`))
56ENGINE = InnoDB
57DEFAULT CHARACTER SET = utf8;
58
59
60-- -----------------------------------------------------
61-- Table `pizzahutalmacenbd`.`insumos`
62-- -----------------------------------------------------
63DROP TABLE IF EXISTS `pizzahutalmacenbd`.`insumos` ;
64
65CREATE TABLE IF NOT EXISTS `pizzahutalmacenbd`.`insumos` (
66 `idInsumos` INT(11) NOT NULL,
67 `Nombre` VARCHAR(45) NOT NULL,
68 `Cantidad` FLOAT NOT NULL,
69 `VidaUtil` INT NULL,
70 `Descongelamiento` INT(100) NULL,
71 `TipoInsumo_idTipoInsumo` INT(11) NOT NULL,
72 `Unidad_idUnidad` INT(11) NOT NULL,
73 `precioUnitario` DOUBLE NOT NULL,
74 PRIMARY KEY (`idInsumos`),
75 INDEX `fk_Insumos_TipoInsumo_idx` (`TipoInsumo_idTipoInsumo` ASC) VISIBLE,
76 INDEX `fk_Insumos_Unidad1_idx` (`Unidad_idUnidad` ASC) VISIBLE,
77 CONSTRAINT `fk_Insumos_TipoInsumo`
78 FOREIGN KEY (`TipoInsumo_idTipoInsumo`)
79 REFERENCES `pizzahutalmacenbd`.`tipoinsumo` (`idTipoInsumo`),
80 CONSTRAINT `fk_Insumos_Unidad1`
81 FOREIGN KEY (`Unidad_idUnidad`)
82 REFERENCES `pizzahutalmacenbd`.`unidad` (`idUnidad`))
83ENGINE = InnoDB
84DEFAULT CHARACTER SET = utf8;
85
86
87-- -----------------------------------------------------
88-- Table `pizzahutalmacenbd`.`ordenbaja`
89-- -----------------------------------------------------
90DROP TABLE IF EXISTS `pizzahutalmacenbd`.`ordenbaja` ;
91
92CREATE TABLE IF NOT EXISTS `pizzahutalmacenbd`.`ordenbaja` (
93 `idOrdenBaja` INT(11) NOT NULL,
94 `Fecha` DATE NOT NULL,
95 PRIMARY KEY (`idOrdenBaja`))
96ENGINE = InnoDB
97DEFAULT CHARACTER SET = utf8;
98
99
100-- -----------------------------------------------------
101-- Table `pizzahutalmacenbd`.`responsablecocina`
102-- -----------------------------------------------------
103DROP TABLE IF EXISTS `pizzahutalmacenbd`.`responsablecocina` ;
104
105CREATE TABLE IF NOT EXISTS `pizzahutalmacenbd`.`responsablecocina` (
106 `idResponsableCocina` INT(11) NOT NULL,
107 `Nombre` VARCHAR(45) NOT NULL,
108 `Apellidos` VARCHAR(45) NOT NULL,
109 PRIMARY KEY (`idResponsableCocina`))
110ENGINE = InnoDB
111DEFAULT CHARACTER SET = utf8;
112
113
114-- -----------------------------------------------------
115-- Table `pizzahutalmacenbd`.`ordendescongelado`
116-- -----------------------------------------------------
117DROP TABLE IF EXISTS `pizzahutalmacenbd`.`ordendescongelado` ;
118
119CREATE TABLE IF NOT EXISTS `pizzahutalmacenbd`.`ordendescongelado` (
120 `idOrdenDescongelado` INT(11) NOT NULL,
121 `Fecha` DATE NOT NULL,
122 `ResponsableCocina_idResponsableCocina` INT(11) NOT NULL,
123 PRIMARY KEY (`idOrdenDescongelado`),
124 INDEX `fk_OrdenDescongelado_ResponsableCocina1_idx` (`ResponsableCocina_idResponsableCocina` ASC) VISIBLE,
125 CONSTRAINT `fk_OrdenDescongelado_ResponsableCocina1`
126 FOREIGN KEY (`ResponsableCocina_idResponsableCocina`)
127 REFERENCES `pizzahutalmacenbd`.`responsablecocina` (`idResponsableCocina`))
128ENGINE = InnoDB
129DEFAULT CHARACTER SET = utf8;
130
131
132-- -----------------------------------------------------
133-- Table `pizzahutalmacenbd`.`ordenpedido`
134-- -----------------------------------------------------
135DROP TABLE IF EXISTS `pizzahutalmacenbd`.`ordenpedido` ;
136
137CREATE TABLE IF NOT EXISTS `pizzahutalmacenbd`.`ordenpedido` (
138 `idOrdenPedido` INT(11) NOT NULL,
139 `Fecha` DATE NOT NULL,
140 PRIMARY KEY (`idOrdenPedido`))
141ENGINE = InnoDB
142DEFAULT CHARACTER SET = utf8;
143
144
145-- -----------------------------------------------------
146-- Table `pizzahutalmacenbd`.`ubicacion`
147-- -----------------------------------------------------
148DROP TABLE IF EXISTS `pizzahutalmacenbd`.`ubicacion` ;
149
150CREATE TABLE IF NOT EXISTS `pizzahutalmacenbd`.`ubicacion` (
151 `idUbicacion` INT(11) NOT NULL,
152 `Lugar` VARCHAR(45) NOT NULL,
153 PRIMARY KEY (`idUbicacion`))
154ENGINE = InnoDB
155DEFAULT CHARACTER SET = utf8;
156
157
158-- -----------------------------------------------------
159-- Table `pizzahutalmacenbd`.`cajainsumo`
160-- -----------------------------------------------------
161DROP TABLE IF EXISTS `pizzahutalmacenbd`.`cajainsumo` ;
162
163CREATE TABLE IF NOT EXISTS `pizzahutalmacenbd`.`cajainsumo` (
164 `idCajaInsumo` INT(11) NOT NULL,
165 `FechaVencimiento` DATE NOT NULL,
166 `Stock` FLOAT NOT NULL,
167 `Insumos_idInsumos` INT(11) NOT NULL,
168 `OrdenBaja_idOrdenBaja` INT(11) NULL,
169 `GuiaRemision_idGuiaRemision` INT(11) NOT NULL,
170 `OrdenPedido_idOrdenPedido` INT(11) NOT NULL,
171 `OrdenDescongelado_idOrdenDescongelado` INT(11) NULL,
172 `Ubicación_idUbicación` INT(11) NOT NULL,
173 `CantidadBaja` FLOAT NULL,
174 PRIMARY KEY (`idCajaInsumo`),
175 INDEX `fk_CajaInsumo_Insumos1_idx` (`Insumos_idInsumos` ASC) VISIBLE,
176 INDEX `fk_CajaInsumo_OrdenBaja1_idx` (`OrdenBaja_idOrdenBaja` ASC) VISIBLE,
177 INDEX `fk_CajaInsumo_GuiaRemision1_idx` (`GuiaRemision_idGuiaRemision` ASC) VISIBLE,
178 INDEX `fk_CajaInsumo_OrdenPedido1_idx` (`OrdenPedido_idOrdenPedido` ASC) VISIBLE,
179 INDEX `fk_CajaInsumo_OrdenDescongelado1_idx` (`OrdenDescongelado_idOrdenDescongelado` ASC) VISIBLE,
180 INDEX `fk_CajaInsumo_Ubicación1_idx` (`Ubicación_idUbicación` ASC) VISIBLE,
181 CONSTRAINT `fk_CajaInsumo_GuiaRemision1`
182 FOREIGN KEY (`GuiaRemision_idGuiaRemision`)
183 REFERENCES `pizzahutalmacenbd`.`guiaremision` (`idGuiaRemision`),
184 CONSTRAINT `fk_CajaInsumo_Insumos1`
185 FOREIGN KEY (`Insumos_idInsumos`)
186 REFERENCES `pizzahutalmacenbd`.`insumos` (`idInsumos`),
187 CONSTRAINT `fk_CajaInsumo_OrdenBaja1`
188 FOREIGN KEY (`OrdenBaja_idOrdenBaja`)
189 REFERENCES `pizzahutalmacenbd`.`ordenbaja` (`idOrdenBaja`),
190 CONSTRAINT `fk_CajaInsumo_OrdenDescongelado1`
191 FOREIGN KEY (`OrdenDescongelado_idOrdenDescongelado`)
192 REFERENCES `pizzahutalmacenbd`.`ordendescongelado` (`idOrdenDescongelado`),
193 CONSTRAINT `fk_CajaInsumo_OrdenPedido1`
194 FOREIGN KEY (`OrdenPedido_idOrdenPedido`)
195 REFERENCES `pizzahutalmacenbd`.`ordenpedido` (`idOrdenPedido`),
196 CONSTRAINT `fk_CajaInsumo_Ubicación1`
197 FOREIGN KEY (`Ubicación_idUbicación`)
198 REFERENCES `pizzahutalmacenbd`.`ubicacion` (`idUbicacion`))
199ENGINE = InnoDB
200DEFAULT CHARACTER SET = utf8;
201
202
203-- -----------------------------------------------------
204-- Table `pizzahutalmacenbd`.`ordensalida`
205-- -----------------------------------------------------
206DROP TABLE IF EXISTS `pizzahutalmacenbd`.`ordensalida` ;
207
208CREATE TABLE IF NOT EXISTS `pizzahutalmacenbd`.`ordensalida` (
209 `idOrdenSalida` INT(11) NOT NULL,
210 `Fecha` DATE NOT NULL,
211 `ResponsableCocina_idResponsableCocina` INT(11) NOT NULL,
212 `Turno` TINYINT(1) NOT NULL,
213 PRIMARY KEY (`idOrdenSalida`),
214 INDEX `fk_OrdenSalida_ResponsableCocina1_idx` (`ResponsableCocina_idResponsableCocina` ASC) VISIBLE,
215 CONSTRAINT `fk_OrdenSalida_ResponsableCocina1`
216 FOREIGN KEY (`ResponsableCocina_idResponsableCocina`)
217 REFERENCES `pizzahutalmacenbd`.`responsablecocina` (`idResponsableCocina`))
218ENGINE = InnoDB
219DEFAULT CHARACTER SET = utf8;
220
221
222-- -----------------------------------------------------
223-- Table `pizzahutalmacenbd`.`cajainsumo_has_ordensalida`
224-- -----------------------------------------------------
225DROP TABLE IF EXISTS `pizzahutalmacenbd`.`cajainsumo_has_ordensalida` ;
226
227CREATE TABLE IF NOT EXISTS `pizzahutalmacenbd`.`cajainsumo_has_ordensalida` (
228 `CajaInsumo_idCajaInsumo` INT(11) NOT NULL,
229 `OrdenSalida_idOrdenSalida` INT(11) NOT NULL,
230 `Cantidad` FLOAT NOT NULL,
231 PRIMARY KEY (`CajaInsumo_idCajaInsumo`, `OrdenSalida_idOrdenSalida`),
232 INDEX `fk_CajaInsumo_has_OrdenSalida_OrdenSalida1_idx` (`OrdenSalida_idOrdenSalida` ASC) VISIBLE,
233 INDEX `fk_CajaInsumo_has_OrdenSalida_CajaInsumo1_idx` (`CajaInsumo_idCajaInsumo` ASC) VISIBLE,
234 CONSTRAINT `fk_CajaInsumo_has_OrdenSalida_CajaInsumo1`
235 FOREIGN KEY (`CajaInsumo_idCajaInsumo`)
236 REFERENCES `pizzahutalmacenbd`.`cajainsumo` (`idCajaInsumo`),
237 CONSTRAINT `fk_CajaInsumo_has_OrdenSalida_OrdenSalida1`
238 FOREIGN KEY (`OrdenSalida_idOrdenSalida`)
239 REFERENCES `pizzahutalmacenbd`.`ordensalida` (`idOrdenSalida`))
240ENGINE = InnoDB
241DEFAULT CHARACTER SET = utf8;
242
243
244-- -----------------------------------------------------
245-- Table `pizzahutalmacenbd`.`dias`
246-- -----------------------------------------------------
247DROP TABLE IF EXISTS `pizzahutalmacenbd`.`dias` ;
248
249CREATE TABLE IF NOT EXISTS `pizzahutalmacenbd`.`dias` (
250 `idDias` INT(11) NOT NULL,
251 `Dia` VARCHAR(45) NOT NULL,
252 PRIMARY KEY (`idDias`))
253ENGINE = InnoDB
254DEFAULT CHARACTER SET = utf8;
255
256
257-- -----------------------------------------------------
258-- Table `pizzahutalmacenbd`.`demanda`
259-- -----------------------------------------------------
260DROP TABLE IF EXISTS `pizzahutalmacenbd`.`demanda` ;
261
262CREATE TABLE IF NOT EXISTS `pizzahutalmacenbd`.`demanda` (
263 `Insumos_idInsumos` INT(11) NOT NULL,
264 `Dias_idDias` INT(11) NOT NULL,
265 `Demanda` FLOAT NOT NULL,
266 PRIMARY KEY (`Insumos_idInsumos`, `Dias_idDias`),
267 INDEX `fk_Insumos_has_DÃas_DÃas1_idx` (`Dias_idDias` ASC) VISIBLE,
268 INDEX `fk_Insumos_has_DÃas_Insumos1_idx` (`Insumos_idInsumos` ASC) VISIBLE,
269 CONSTRAINT `fk_Insumos_has_DÃas_DÃas1`
270 FOREIGN KEY (`Dias_idDias`)
271 REFERENCES `pizzahutalmacenbd`.`dias` (`idDias`),
272 CONSTRAINT `fk_Insumos_has_DÃas_Insumos1`
273 FOREIGN KEY (`Insumos_idInsumos`)
274 REFERENCES `pizzahutalmacenbd`.`insumos` (`idInsumos`))
275ENGINE = InnoDB
276DEFAULT CHARACTER SET = utf8;
277
278
279SET SQL_MODE=@OLD_SQL_MODE;
280SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
281SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;