· 4 years ago · Dec 23, 2020, 01:12 AM
1-- MySQL dump 10.13 Distrib 8.0.21, for Win64 (x86_64)
2--
3-- Host: localhost Database: restaurant
4-- ------------------------------------------------------
5-- Server version 8.0.21
6
7/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
8/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
9/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
10/*!50503 SET NAMES utf8 */;
11/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
12/*!40103 SET TIME_ZONE='+00:00' */;
13/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
14/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
15/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
16/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
17
18--
19-- Table structure for table `cajero`
20--
21
22DROP TABLE IF EXISTS `cajero`;
23/*!40101 SET @saved_cs_client = @@character_set_client */;
24/*!50503 SET character_set_client = utf8mb4 */;
25CREATE TABLE `cajero` (
26 `idCajero` int NOT NULL,
27 `turno` varchar(12) NOT NULL,
28 `Nombre_cajero` varchar(45) NOT NULL,
29 PRIMARY KEY (`idCajero`)
30) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
31/*!40101 SET character_set_client = @saved_cs_client */;
32
33--
34-- Table structure for table `cliente`
35--
36
37DROP TABLE IF EXISTS `cliente`;
38/*!40101 SET @saved_cs_client = @@character_set_client */;
39/*!50503 SET character_set_client = utf8mb4 */;
40CREATE TABLE `cliente` (
41 `idCliente` int NOT NULL,
42 `Nombre` varchar(20) NOT NULL,
43 `Apellido` varchar(20) NOT NULL,
44 `DNI` varchar(7) NOT NULL,
45 `Telefono` varchar(13) NOT NULL,
46 PRIMARY KEY (`idCliente`)
47) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
48/*!40101 SET character_set_client = @saved_cs_client */;
49
50--
51-- Table structure for table `comanda`
52--
53
54DROP TABLE IF EXISTS `comanda`;
55/*!40101 SET @saved_cs_client = @@character_set_client */;
56/*!50503 SET character_set_client = utf8mb4 */;
57CREATE TABLE `comanda` (
58 `idcomanda` int NOT NULL,
59 `idmesa` int NOT NULL,
60 `idempleado` int NOT NULL,
61 `observaciones` mediumtext NOT NULL,
62 PRIMARY KEY (`idcomanda`,`idmesa`,`idempleado`),
63 KEY `id_mesa_idx` (`idmesa`),
64 KEY `id_empleado_idx` (`idempleado`),
65 CONSTRAINT `idempleado` FOREIGN KEY (`idempleado`) REFERENCES `empleado` (`IDempleado`),
66 CONSTRAINT `idmesa` FOREIGN KEY (`idmesa`) REFERENCES `mesa` (`idmesa`)
67) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
68/*!40101 SET character_set_client = @saved_cs_client */;
69
70--
71-- Table structure for table `descuento`
72--
73
74DROP TABLE IF EXISTS `descuento`;
75/*!40101 SET @saved_cs_client = @@character_set_client */;
76/*!50503 SET character_set_client = utf8mb4 */;
77CREATE TABLE `descuento` (
78 `iddescuento` int NOT NULL,
79 `id_tipodescuento` int NOT NULL,
80 PRIMARY KEY (`iddescuento`),
81 KEY `id_tipodescuento_idx` (`id_tipodescuento`),
82 CONSTRAINT `id_tipodescuento` FOREIGN KEY (`id_tipodescuento`) REFERENCES `tipo_descuento` (`idtipo_descuento`)
83) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
84/*!40101 SET character_set_client = @saved_cs_client */;
85
86--
87-- Table structure for table `detalle_comanda`
88--
89
90DROP TABLE IF EXISTS `detalle_comanda`;
91/*!40101 SET @saved_cs_client = @@character_set_client */;
92/*!50503 SET character_set_client = utf8mb4 */;
93CREATE TABLE `detalle_comanda` (
94 `iddetalle_comanda` int NOT NULL,
95 `id_producto` int NOT NULL,
96 `id_comanda` int NOT NULL,
97 `id_mesa` int NOT NULL,
98 `id_empleado` int NOT NULL,
99 PRIMARY KEY (`iddetalle_comanda`),
100 KEY `id_producto_idx` (`id_producto`),
101 KEY `id_mesa_idx` (`id_mesa`),
102 KEY `id_empleado_idx` (`id_empleado`),
103 KEY `id_comanda_idx` (`id_comanda`),
104 CONSTRAINT `id_comanda` FOREIGN KEY (`id_comanda`) REFERENCES `comanda` (`idcomanda`),
105 CONSTRAINT `id_empleado` FOREIGN KEY (`id_empleado`) REFERENCES `comanda` (`idempleado`),
106 CONSTRAINT `id_mesa` FOREIGN KEY (`id_mesa`) REFERENCES `comanda` (`idmesa`),
107 CONSTRAINT `id_producto` FOREIGN KEY (`id_producto`) REFERENCES `producto` (`idproducto`)
108) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
109/*!40101 SET character_set_client = @saved_cs_client */;
110
111--
112-- Table structure for table `detalle_compra`
113--
114
115DROP TABLE IF EXISTS `detalle_compra`;
116/*!40101 SET @saved_cs_client = @@character_set_client */;
117/*!50503 SET character_set_client = utf8mb4 */;
118CREATE TABLE `detalle_compra` (
119 `iddetalle_compra` int NOT NULL,
120 `id_tipooproducto` int NOT NULL,
121 `id_ordencompra` int NOT NULL,
122 `id_proveedor` int NOT NULL,
123 PRIMARY KEY (`iddetalle_compra`),
124 KEY `id_tipoproducto_idx` (`id_tipooproducto`),
125 KEY `id_ordencompra_idx` (`id_ordencompra`),
126 KEY `idproveedor_idx` (`id_proveedor`),
127 CONSTRAINT `idorden_compra` FOREIGN KEY (`id_ordencompra`) REFERENCES `orden_compra` (`idorden_compra`),
128 CONSTRAINT `idproveedor` FOREIGN KEY (`id_proveedor`) REFERENCES `orden_compra` (`idorden_compra`),
129 CONSTRAINT `idtipo_producto` FOREIGN KEY (`id_tipooproducto`) REFERENCES `tipo_producto` (`idtipo_producto`)
130) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
131/*!40101 SET character_set_client = @saved_cs_client */;
132
133--
134-- Table structure for table `empleado`
135--
136
137DROP TABLE IF EXISTS `empleado`;
138/*!40101 SET @saved_cs_client = @@character_set_client */;
139/*!50503 SET character_set_client = utf8mb4 */;
140CREATE TABLE `empleado` (
141 `IDempleado` int NOT NULL,
142 `id_tipoempleado` int NOT NULL,
143 `Nombre` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
144 `Apellido` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
145 `DNI` varchar(7) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
146 `Telefono` varchar(9) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
147 `Experiencia` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
148 PRIMARY KEY (`IDempleado`),
149 KEY `id_tipoempleado_idx` (`id_tipoempleado`),
150 CONSTRAINT `id_tipoempleado` FOREIGN KEY (`id_tipoempleado`) REFERENCES `tipo_empleado` (`IDtipo_empleado`)
151) ENGINE=InnoDB DEFAULT CHARSET=utf32;
152/*!40101 SET character_set_client = @saved_cs_client */;
153
154--
155-- Table structure for table `forma_pago`
156--
157
158DROP TABLE IF EXISTS `forma_pago`;
159/*!40101 SET @saved_cs_client = @@character_set_client */;
160/*!50503 SET character_set_client = utf8mb4 */;
161CREATE TABLE `forma_pago` (
162 `idforma_pago` int NOT NULL,
163 `id_tipopago` int NOT NULL,
164 `tarjeta_credito` varchar(14) NOT NULL,
165 `contado` varchar(20) NOT NULL,
166 `otros` varchar(20) NOT NULL,
167 PRIMARY KEY (`idforma_pago`),
168 KEY `id_tipopago_idx` (`id_tipopago`),
169 CONSTRAINT `id_tipopago` FOREIGN KEY (`id_tipopago`) REFERENCES `tipo_pago` (`idtipo_pago`)
170) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
171/*!40101 SET character_set_client = @saved_cs_client */;
172
173--
174-- Table structure for table `mesa`
175--
176
177DROP TABLE IF EXISTS `mesa`;
178/*!40101 SET @saved_cs_client = @@character_set_client */;
179/*!50503 SET character_set_client = utf8mb4 */;
180CREATE TABLE `mesa` (
181 `idmesa` int NOT NULL,
182 `id_tipomesa` int NOT NULL,
183 `numero_mesa` int DEFAULT NULL,
184 PRIMARY KEY (`idmesa`),
185 KEY `id_tipomesa_idx` (`id_tipomesa`),
186 CONSTRAINT `id_tipomesa` FOREIGN KEY (`id_tipomesa`) REFERENCES `tipo_mesa` (`idtipo_mesa`)
187) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
188/*!40101 SET character_set_client = @saved_cs_client */;
189
190--
191-- Table structure for table `orden_compra`
192--
193
194DROP TABLE IF EXISTS `orden_compra`;
195/*!40101 SET @saved_cs_client = @@character_set_client */;
196/*!50503 SET character_set_client = utf8mb4 */;
197CREATE TABLE `orden_compra` (
198 `idorden_compra` int NOT NULL,
199 `id_proveedor` int NOT NULL,
200 `precio` float NOT NULL,
201 `cantidad` int NOT NULL,
202 `fecha` date NOT NULL,
203 PRIMARY KEY (`idorden_compra`,`id_proveedor`),
204 KEY `id_proveedor_idx` (`id_proveedor`),
205 CONSTRAINT `id_proveedor` FOREIGN KEY (`id_proveedor`) REFERENCES `proveedor` (`IDproveedor`)
206) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
207/*!40101 SET character_set_client = @saved_cs_client */;
208
209--
210-- Table structure for table `precuenta`
211--
212
213DROP TABLE IF EXISTS `precuenta`;
214/*!40101 SET @saved_cs_client = @@character_set_client */;
215/*!50503 SET character_set_client = utf8mb4 */;
216CREATE TABLE `precuenta` (
217 `idprecuenta` int NOT NULL,
218 `IDcomanda_pre` int NOT NULL,
219 `IDmesa_pre` int NOT NULL,
220 `IDempleado_pre` int NOT NULL,
221 PRIMARY KEY (`idprecuenta`),
222 KEY `idcomanda_idx` (`IDcomanda_pre`),
223 KEY `idmesa_idx` (`IDmesa_pre`),
224 KEY `idempleado_idx` (`IDempleado_pre`),
225 CONSTRAINT `idcomandapre` FOREIGN KEY (`IDcomanda_pre`) REFERENCES `comanda` (`idcomanda`),
226 CONSTRAINT `idempleadopre` FOREIGN KEY (`IDempleado_pre`) REFERENCES `comanda` (`idempleado`),
227 CONSTRAINT `idmesapre` FOREIGN KEY (`IDmesa_pre`) REFERENCES `comanda` (`idmesa`)
228) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
229/*!40101 SET character_set_client = @saved_cs_client */;
230
231--
232-- Table structure for table `producto`
233--
234
235DROP TABLE IF EXISTS `producto`;
236/*!40101 SET @saved_cs_client = @@character_set_client */;
237/*!50503 SET character_set_client = utf8mb4 */;
238CREATE TABLE `producto` (
239 `idproducto` int NOT NULL,
240 `id_tipoproducto` int NOT NULL,
241 PRIMARY KEY (`idproducto`),
242 KEY `id_tipo_producto_idx` (`id_tipoproducto`),
243 CONSTRAINT `id_tipo_producto` FOREIGN KEY (`id_tipoproducto`) REFERENCES `tipo_producto` (`idtipo_producto`)
244) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
245/*!40101 SET character_set_client = @saved_cs_client */;
246
247--
248-- Table structure for table `proveedor`
249--
250
251DROP TABLE IF EXISTS `proveedor`;
252/*!40101 SET @saved_cs_client = @@character_set_client */;
253/*!50503 SET character_set_client = utf8mb4 */;
254CREATE TABLE `proveedor` (
255 `IDproveedor` int NOT NULL,
256 `Nombre` varchar(45) NOT NULL,
257 `Telefono` varchar(14) NOT NULL,
258 `direccion` varchar(45) NOT NULL,
259 PRIMARY KEY (`IDproveedor`)
260) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
261/*!40101 SET character_set_client = @saved_cs_client */;
262
263--
264-- Table structure for table `tipo_descuento`
265--
266
267DROP TABLE IF EXISTS `tipo_descuento`;
268/*!40101 SET @saved_cs_client = @@character_set_client */;
269/*!50503 SET character_set_client = utf8mb4 */;
270CREATE TABLE `tipo_descuento` (
271 `idtipo_descuento` int NOT NULL,
272 `descuento_plato` float NOT NULL,
273 `descuento_porcentaje` float NOT NULL,
274 `descuento_doctotal` float NOT NULL,
275 `descuento_monto` float NOT NULL,
276 PRIMARY KEY (`idtipo_descuento`)
277) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
278/*!40101 SET character_set_client = @saved_cs_client */;
279
280--
281-- Table structure for table `tipo_empleado`
282--
283
284DROP TABLE IF EXISTS `tipo_empleado`;
285/*!40101 SET @saved_cs_client = @@character_set_client */;
286/*!50503 SET character_set_client = utf8mb4 */;
287CREATE TABLE `tipo_empleado` (
288 `IDtipo_empleado` int NOT NULL,
289 `cargo` varchar(45) NOT NULL,
290 PRIMARY KEY (`IDtipo_empleado`)
291) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
292/*!40101 SET character_set_client = @saved_cs_client */;
293
294--
295-- Table structure for table `tipo_mesa`
296--
297
298DROP TABLE IF EXISTS `tipo_mesa`;
299/*!40101 SET @saved_cs_client = @@character_set_client */;
300/*!50503 SET character_set_client = utf8mb4 */;
301CREATE TABLE `tipo_mesa` (
302 `idtipo_mesa` int NOT NULL,
303 `nombre_tipomesa` varchar(45) NOT NULL,
304 `tamano` varchar(10) NOT NULL,
305 `capacidad` int NOT NULL,
306 PRIMARY KEY (`idtipo_mesa`)
307) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
308/*!40101 SET character_set_client = @saved_cs_client */;
309
310--
311-- Table structure for table `tipo_pago`
312--
313
314DROP TABLE IF EXISTS `tipo_pago`;
315/*!40101 SET @saved_cs_client = @@character_set_client */;
316/*!50503 SET character_set_client = utf8mb4 */;
317CREATE TABLE `tipo_pago` (
318 `idtipo_pago` int NOT NULL,
319 `soles` float NOT NULL,
320 `dolares` float NOT NULL,
321 `euros` float NOT NULL,
322 PRIMARY KEY (`idtipo_pago`)
323) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
324/*!40101 SET character_set_client = @saved_cs_client */;
325
326--
327-- Table structure for table `tipo_producto`
328--
329
330DROP TABLE IF EXISTS `tipo_producto`;
331/*!40101 SET @saved_cs_client = @@character_set_client */;
332/*!50503 SET character_set_client = utf8mb4 */;
333CREATE TABLE `tipo_producto` (
334 `idtipo_producto` int NOT NULL,
335 `bebida` varchar(45) NOT NULL,
336 `postre` varchar(45) NOT NULL,
337 `menu` varchar(45) NOT NULL,
338 PRIMARY KEY (`idtipo_producto`)
339) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
340/*!40101 SET character_set_client = @saved_cs_client */;
341
342--
343-- Table structure for table `venta`
344--
345
346DROP TABLE IF EXISTS `venta`;
347/*!40101 SET @saved_cs_client = @@character_set_client */;
348/*!50503 SET character_set_client = utf8mb4 */;
349CREATE TABLE `venta` (
350 `idventa` int NOT NULL,
351 `id_cliente` int NOT NULL,
352 `id_cajero` int NOT NULL,
353 `id_formapago` int NOT NULL,
354 `id_precuenta` int NOT NULL,
355 `fecha` date NOT NULL,
356 `id_descuento` int NOT NULL,
357 PRIMARY KEY (`idventa`,`id_cliente`,`id_cajero`,`id_formapago`,`id_precuenta`),
358 KEY `id_cliente_idx` (`id_cliente`),
359 KEY `id_cajero_idx` (`id_cajero`),
360 KEY `id_formapago_idx` (`id_formapago`),
361 KEY `id_descuento_idx` (`id_descuento`),
362 KEY `id_precuenta_idx` (`id_precuenta`),
363 CONSTRAINT `id_cajero` FOREIGN KEY (`id_cajero`) REFERENCES `cajero` (`idCajero`),
364 CONSTRAINT `id_cliente` FOREIGN KEY (`id_cliente`) REFERENCES `cliente` (`idCliente`),
365 CONSTRAINT `id_descuento` FOREIGN KEY (`id_descuento`) REFERENCES `descuento` (`iddescuento`),
366 CONSTRAINT `id_formapago` FOREIGN KEY (`id_formapago`) REFERENCES `forma_pago` (`idforma_pago`),
367 CONSTRAINT `id_precuenta` FOREIGN KEY (`id_precuenta`) REFERENCES `precuenta` (`idprecuenta`)
368) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
369/*!40101 SET character_set_client = @saved_cs_client */;
370/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
371
372/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
373/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
374/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
375/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
376/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
377/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
378/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
379
380-- Dump completed on 2020-12-22 20:04:58