fi59GazP

1CREATE DATABASE  IF NOT EXISTS `criapez2` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci */ /*!80016 DEFAULT ENCRYPTION='N' */;
2USE `criapez2`;
3-- MySQL dump 10.13  Distrib 8.0.20, for Win64 (x86_64)
4--
5-- Host: 127.0.0.1    Database: criapez
6-- ------------------------------------------------------
7-- Server version	8.0.20
8
9/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
10/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
11/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
12/*!50503 SET NAMES utf8 */;
13/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
14/*!40103 SET TIME_ZONE='+00:00' */;
15/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
16/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
17/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
18/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
19
20--
21-- Table structure for table `atributo1`
22--
23
24DROP TABLE IF EXISTS `atributo1`;
25/*!40101 SET @saved_cs_client     = @@character_set_client */;
26/*!50503 SET character_set_client = utf8mb4 */;
27CREATE TABLE `atributo1` (
28  `idAtributo1` int NOT NULL AUTO_INCREMENT,
29  `descripcion` varchar(500) NOT NULL,
30  PRIMARY KEY (`idAtributo1`)
31) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
32/*!40101 SET character_set_client = @saved_cs_client */;
33
34--
35-- Table structure for table `atributo2`
36--
37
38DROP TABLE IF EXISTS `atributo2`;
39/*!40101 SET @saved_cs_client     = @@character_set_client */;
40/*!50503 SET character_set_client = utf8mb4 */;
41CREATE TABLE `atributo2` (
42  `idatributo2` int NOT NULL,
43  `descripcion` varchar(500) DEFAULT NULL,
44  PRIMARY KEY (`idatributo2`)
45) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
46/*!40101 SET character_set_client = @saved_cs_client */;
47
48--
49-- Table structure for table `familia`
50--
51
52DROP TABLE IF EXISTS `familia`;
53/*!40101 SET @saved_cs_client     = @@character_set_client */;
54/*!50503 SET character_set_client = utf8mb4 */;
55CREATE TABLE `familia` (
56  `idFamilia` int NOT NULL,
57  `nombre` varchar(500) DEFAULT NULL,
58  PRIMARY KEY (`idFamilia`)
59) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
60/*!40101 SET character_set_client = @saved_cs_client */;
61
62--
63-- Table structure for table `pez`
64--
65
66DROP TABLE IF EXISTS `pez`;
67/*!40101 SET @saved_cs_client     = @@character_set_client */;
68/*!50503 SET character_set_client = utf8mb4 */;
69CREATE TABLE `pez` (
70  `idPez` int NOT NULL AUTO_INCREMENT,
71  `idVariedad` int NOT NULL,
72  `idAtributo1` int NOT NULL,
73  PRIMARY KEY (`idPez`),
74  KEY `idVariedad_fk_idx` (`idVariedad`),
75  KEY `idAtributo1_fk_idx` (`idAtributo1`),
76  CONSTRAINT `idAtributo1_fk` FOREIGN KEY (`idAtributo1`) REFERENCES `atributo1` (`idAtributo1`) ON DELETE RESTRICT ON UPDATE RESTRICT,
77  CONSTRAINT `idVariedad_fk` FOREIGN KEY (`idVariedad`) REFERENCES `variedad` (`idVariedad`) ON DELETE RESTRICT ON UPDATE RESTRICT
78) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
79/*!40101 SET character_set_client = @saved_cs_client */;
80
81--
82-- Table structure for table `principal`
83--
84
85DROP TABLE IF EXISTS `principal`;
86/*!40101 SET @saved_cs_client     = @@character_set_client */;
87/*!50503 SET character_set_client = utf8mb4 */;
88CREATE TABLE `principal` (
89  `idPrincipal` int NOT NULL,
90  `idOrden` int NOT NULL,
91  `pasillo` varchar(45) NOT NULL,
92  `pez` int NOT NULL,
93  `atributo2` int NOT NULL,
94  `tamano` int NOT NULL,
95  `peso` int DEFAULT NULL,
96  `ingreso` date DEFAULT NULL,
97  `egreso` date DEFAULT NULL,
98  `fino` int NOT NULL,
99  `grueso` int NOT NULL,
100  PRIMARY KEY (`idPrincipal`),
101  KEY `pez_fk_idx` (`pez`),
102  KEY `tamano_fk_idx` (`tamano`),
103  KEY `atributo2_fk_idx` (`atributo2`),
104  CONSTRAINT `atributo2_fk` FOREIGN KEY (`atributo2`) REFERENCES `atributo2` (`idatributo2`) ON DELETE RESTRICT ON UPDATE RESTRICT,
105  CONSTRAINT `pez_fk` FOREIGN KEY (`pez`) REFERENCES `pez` (`idPez`) ON DELETE RESTRICT ON UPDATE RESTRICT,
106  CONSTRAINT `tamano_fk` FOREIGN KEY (`tamano`) REFERENCES `tamano` (`idtamano`) ON DELETE RESTRICT ON UPDATE RESTRICT
107) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
108/*!40101 SET character_set_client = @saved_cs_client */;
109
110--
111-- Table structure for table `tamano`
112--
113
114DROP TABLE IF EXISTS `tamano`;
115/*!40101 SET @saved_cs_client     = @@character_set_client */;
116/*!50503 SET character_set_client = utf8mb4 */;
117CREATE TABLE `tamano` (
118  `idtamano` int NOT NULL AUTO_INCREMENT,
119  `descripcion` varchar(500) NOT NULL,
120  PRIMARY KEY (`idtamano`)
121) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
122/*!40101 SET character_set_client = @saved_cs_client */;
123
124--
125-- Table structure for table `variedad`
126--
127
128DROP TABLE IF EXISTS `variedad`;
129/*!40101 SET @saved_cs_client     = @@character_set_client */;
130/*!50503 SET character_set_client = utf8mb4 */;
131CREATE TABLE `variedad` (
132  `idVariedad` int NOT NULL AUTO_INCREMENT,
133  `idFamilia` int NOT NULL,
134  `descripcion` varchar(500) NOT NULL,
135  PRIMARY KEY (`idVariedad`),
136  KEY `idFamilia_fk_idx` (`idFamilia`),
137  CONSTRAINT `idFamilia_fk` FOREIGN KEY (`idFamilia`) REFERENCES `familia` (`idFamilia`) ON DELETE RESTRICT ON UPDATE RESTRICT
138) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
139/*!40101 SET character_set_client = @saved_cs_client */;
140/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
141
142/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
143/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
144/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
145/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
146/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
147/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
148/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
149
150-- Dump completed on 2020-07-21 22:52:32