· 4 years ago · Dec 11, 2020, 05:10 AM
1-- MySQL dump 10.13 Distrib 8.0.21, for Win64 (x86_64)
2--
3-- Host: localhost Database: sistema_administrativo_cobranzas
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 `aporte_catastral`
20--
21
22DROP TABLE IF EXISTS `aporte_catastral`;
23/*!40101 SET @saved_cs_client = @@character_set_client */;
24/*!50503 SET character_set_client = utf8mb4 */;
25CREATE TABLE `aporte_catastral` (
26 `id_aporte_catastral` int NOT NULL,
27 `numero_cuotas` int NOT NULL,
28 PRIMARY KEY (`id_aporte_catastral`)
29) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
30/*!40101 SET character_set_client = @saved_cs_client */;
31
32--
33-- Table structure for table `asociacion`
34--
35
36DROP TABLE IF EXISTS `asociacion`;
37/*!40101 SET @saved_cs_client = @@character_set_client */;
38/*!50503 SET character_set_client = utf8mb4 */;
39CREATE TABLE `asociacion` (
40 `id_Asociacion` int NOT NULL,
41 `nombre` varchar(45) NOT NULL,
42 PRIMARY KEY (`id_Asociacion`)
43) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
44/*!40101 SET character_set_client = @saved_cs_client */;
45
46--
47-- Table structure for table `notificacion`
48--
49
50DROP TABLE IF EXISTS `notificacion`;
51/*!40101 SET @saved_cs_client = @@character_set_client */;
52/*!50503 SET character_set_client = utf8mb4 */;
53CREATE TABLE `notificacion` (
54 `id_Notificacion` int NOT NULL,
55 `id_usuario` int NOT NULL,
56 `fecha` date NOT NULL,
57 `observacion` longtext NOT NULL,
58 PRIMARY KEY (`id_Notificacion`),
59 KEY `id_usuario_idx` (`id_usuario`),
60 CONSTRAINT `id_usuario` FOREIGN KEY (`id_usuario`) REFERENCES `usuario` (`id_Usuario`)
61) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
62/*!40101 SET character_set_client = @saved_cs_client */;
63
64--
65-- Table structure for table `parametro`
66--
67
68DROP TABLE IF EXISTS `parametro`;
69/*!40101 SET @saved_cs_client = @@character_set_client */;
70/*!50503 SET character_set_client = utf8mb4 */;
71CREATE TABLE `parametro` (
72 `id_Parametro` int NOT NULL,
73 `anio` date NOT NULL,
74 `volumen` float NOT NULL,
75 `junta` varchar(45) NOT NULL,
76 `comision` varchar(45) NOT NULL,
77 `j_nacional` varchar(45) NOT NULL,
78 PRIMARY KEY (`id_Parametro`)
79) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
80/*!40101 SET character_set_client = @saved_cs_client */;
81
82--
83-- Table structure for table `pozo`
84--
85
86DROP TABLE IF EXISTS `pozo`;
87/*!40101 SET @saved_cs_client = @@character_set_client */;
88/*!50503 SET character_set_client = utf8mb4 */;
89CREATE TABLE `pozo` (
90 `id_Pozo` int NOT NULL,
91 `id_asociacion` int NOT NULL,
92 `nombre` varchar(45) NOT NULL,
93 PRIMARY KEY (`id_Pozo`,`id_asociacion`),
94 KEY `id_asociacion_idx` (`id_asociacion`),
95 CONSTRAINT `id_asociacion` FOREIGN KEY (`id_asociacion`) REFERENCES `asociacion` (`id_Asociacion`)
96) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
97/*!40101 SET character_set_client = @saved_cs_client */;
98
99--
100-- Table structure for table `re_ap`
101--
102
103DROP TABLE IF EXISTS `re_ap`;
104/*!40101 SET @saved_cs_client = @@character_set_client */;
105/*!50503 SET character_set_client = utf8mb4 */;
106CREATE TABLE `re_ap` (
107 `id_aportecatastral` int NOT NULL,
108 `id_recibo` int NOT NULL,
109 `id_usuario_recibo_re_ap` int NOT NULL,
110 `observacion` mediumtext NOT NULL,
111 PRIMARY KEY (`id_aportecatastral`),
112 KEY `id_recibo_idx` (`id_recibo`) /*!80000 INVISIBLE */,
113 KEY `id_aportecatastral_idx` (`id_aportecatastral`),
114 KEY `id_usuario_recibo_idx` (`id_usuario_recibo_re_ap`),
115 CONSTRAINT `id_aportecatastral` FOREIGN KEY (`id_aportecatastral`) REFERENCES `aporte_catastral` (`id_aporte_catastral`),
116 CONSTRAINT `id_recibo` FOREIGN KEY (`id_recibo`) REFERENCES `recibo_pago` (`id_Recibo`),
117 CONSTRAINT `id_usuario_recibo_re_ap` FOREIGN KEY (`id_usuario_recibo_re_ap`) REFERENCES `recibo_pago` (`id_usuario_recibo`)
118) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
119/*!40101 SET character_set_client = @saved_cs_client */;
120
121--
122-- Table structure for table `recibo_pago`
123--
124
125DROP TABLE IF EXISTS `recibo_pago`;
126/*!40101 SET @saved_cs_client = @@character_set_client */;
127/*!50503 SET character_set_client = utf8mb4 */;
128CREATE TABLE `recibo_pago` (
129 `id_Recibo` int NOT NULL,
130 `id_usuario_recibo` int NOT NULL,
131 `fecha` date NOT NULL,
132 `observacion` mediumtext NOT NULL,
133 PRIMARY KEY (`id_Recibo`,`id_usuario_recibo`),
134 KEY `id_usuario_recibo_idx` (`id_usuario_recibo`),
135 CONSTRAINT `id_usuario_recibo` FOREIGN KEY (`id_usuario_recibo`) REFERENCES `usuario` (`id_Usuario`)
136) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
137/*!40101 SET character_set_client = @saved_cs_client */;
138
139--
140-- Table structure for table `usuario`
141--
142
143DROP TABLE IF EXISTS `usuario`;
144/*!40101 SET @saved_cs_client = @@character_set_client */;
145/*!50503 SET character_set_client = utf8mb4 */;
146CREATE TABLE `usuario` (
147 `id_Usuario` int NOT NULL,
148 `id_parametro` int NOT NULL,
149 `id_pozo` int NOT NULL,
150 `id_asociacion_pozo` int NOT NULL,
151 `nombre` varchar(20) NOT NULL,
152 `apellido` varchar(20) NOT NULL,
153 `DNI` varchar(7) NOT NULL,
154 `hectarea` float NOT NULL,
155 `telefono` varchar(9) NOT NULL,
156 `comentario` longtext NOT NULL,
157 PRIMARY KEY (`id_Usuario`),
158 KEY `id_parametro_idx` (`id_parametro`),
159 KEY `id_pozo_idx` (`id_pozo`),
160 KEY `id_asociacion_pozo_idx` (`id_asociacion_pozo`),
161 CONSTRAINT `id_asociacion_pozo` FOREIGN KEY (`id_asociacion_pozo`) REFERENCES `pozo` (`id_asociacion`),
162 CONSTRAINT `id_parametro` FOREIGN KEY (`id_parametro`) REFERENCES `parametro` (`id_Parametro`),
163 CONSTRAINT `id_pozo` FOREIGN KEY (`id_pozo`) REFERENCES `pozo` (`id_Pozo`)
164) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
165/*!40101 SET character_set_client = @saved_cs_client */;
166/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
167
168/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
169/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
170/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
171/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
172/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
173/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
174/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
175
176-- Dump completed on 2020-12-11 0:03:12
177