1 | -- MySQL dump 10.13 Distrib 5.5.31, for debian-linux-gnu (x86_64) |
---|
2 | -- |
---|
3 | -- Host: localhost Database: stage_area |
---|
4 | -- ------------------------------------------------------ |
---|
5 | -- Server version 5.5.31-0+wheezy1 |
---|
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 | /*!40101 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 `beneficiarios` |
---|
20 | -- |
---|
21 | |
---|
22 | DROP TABLE IF EXISTS `beneficiarios`; |
---|
23 | /*!40101 SET @saved_cs_client = @@character_set_client */; |
---|
24 | /*!40101 SET character_set_client = utf8 */; |
---|
25 | CREATE TABLE `beneficiarios` ( |
---|
26 | `rif` varchar(10) DEFAULT NULL, |
---|
27 | `pais` varchar(200) NOT NULL, |
---|
28 | `nombre` varchar(100) NOT NULL, |
---|
29 | `ventas` int(11) NOT NULL, |
---|
30 | `ue_rif` varchar(10) NOT NULL, |
---|
31 | `anho_r` int(4) NOT NULL, |
---|
32 | `ciiu_principal` varchar(13) NOT NULL, |
---|
33 | `ue_tipo` varchar(100) NOT NULL |
---|
34 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
---|
35 | /*!40101 SET character_set_client = @saved_cs_client */; |
---|
36 | |
---|
37 | -- |
---|
38 | -- Table structure for table `bien` |
---|
39 | -- |
---|
40 | |
---|
41 | DROP TABLE IF EXISTS `bien`; |
---|
42 | /*!40101 SET @saved_cs_client = @@character_set_client */; |
---|
43 | /*!40101 SET character_set_client = utf8 */; |
---|
44 | CREATE TABLE `bien` ( |
---|
45 | `id` int(11) NOT NULL, |
---|
46 | `nombre` varchar(100) NOT NULL, |
---|
47 | `esp_tec` text NOT NULL, |
---|
48 | `codigo_aran` varchar(13) NOT NULL, |
---|
49 | `unidad_medida` varchar(100) NOT NULL, |
---|
50 | `peso` double NOT NULL, |
---|
51 | `planta_id` int(11) NOT NULL, |
---|
52 | `n_consumidores` int(11) NOT NULL, |
---|
53 | `marca` varchar(100) DEFAULT NULL, |
---|
54 | `cantidad_vendida` int(11) DEFAULT NULL, |
---|
55 | `cantidad_producida` int(11) DEFAULT NULL, |
---|
56 | `anyo` varchar(45) DEFAULT NULL |
---|
57 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
---|
58 | /*!40101 SET character_set_client = @saved_cs_client */; |
---|
59 | |
---|
60 | -- |
---|
61 | -- Table structure for table `bien_comercializadonofabricado` |
---|
62 | -- |
---|
63 | |
---|
64 | DROP TABLE IF EXISTS `bien_comercializadonofabricado`; |
---|
65 | /*!40101 SET @saved_cs_client = @@character_set_client */; |
---|
66 | /*!40101 SET character_set_client = utf8 */; |
---|
67 | CREATE TABLE `bien_comercializadonofabricado` ( |
---|
68 | `id` int(11) NOT NULL, |
---|
69 | `nombre` varchar(100) NOT NULL, |
---|
70 | `marca` varchar(100) NOT NULL, |
---|
71 | `codigo_aran_id` varchar(13) NOT NULL, |
---|
72 | `esp_tec` text NOT NULL, |
---|
73 | `unidad_medida` varchar(100) NOT NULL, |
---|
74 | `nacional` char(1) NOT NULL, |
---|
75 | `peso` double NOT NULL, |
---|
76 | `ue_rif` varchar(10) NOT NULL, |
---|
77 | `cantidad` int(11) NOT NULL, |
---|
78 | `anyo` varchar(45) DEFAULT NULL, |
---|
79 | PRIMARY KEY (`id`) |
---|
80 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
---|
81 | /*!40101 SET character_set_client = @saved_cs_client */; |
---|
82 | |
---|
83 | -- |
---|
84 | -- Table structure for table `cantempleadostercerizados_naturalezajuridica_ciiu` |
---|
85 | -- |
---|
86 | |
---|
87 | DROP TABLE IF EXISTS `cantempleadostercerizados_naturalezajuridica_ciiu`; |
---|
88 | /*!40101 SET @saved_cs_client = @@character_set_client */; |
---|
89 | /*!40101 SET character_set_client = utf8 */; |
---|
90 | CREATE TABLE `cantempleadostercerizados_naturalezajuridica_ciiu` ( |
---|
91 | `naturalezajuridica` varchar(150) NOT NULL, |
---|
92 | `ciiu` varchar(5) NOT NULL, |
---|
93 | `cantidad_empleados_tercerizados` int(11) NOT NULL |
---|
94 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
---|
95 | /*!40101 SET character_set_client = @saved_cs_client */; |
---|
96 | |
---|
97 | -- |
---|
98 | -- Table structure for table `cantidad_lineas_estaciones` |
---|
99 | -- |
---|
100 | |
---|
101 | DROP TABLE IF EXISTS `cantidad_lineas_estaciones`; |
---|
102 | /*!40101 SET @saved_cs_client = @@character_set_client */; |
---|
103 | /*!40101 SET character_set_client = utf8 */; |
---|
104 | CREATE TABLE `cantidad_lineas_estaciones` ( |
---|
105 | `rif` tinytext, |
---|
106 | `cantidad_lineas_1` int(11) DEFAULT NULL, |
---|
107 | `cantidad_estaciones_1` int(11) DEFAULT NULL, |
---|
108 | `planta_id` int(11) DEFAULT NULL |
---|
109 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
---|
110 | /*!40101 SET character_set_client = @saved_cs_client */; |
---|
111 | |
---|
112 | -- |
---|
113 | -- Table structure for table `cantturnos_municipio_tipoturno_tipoempresa` |
---|
114 | -- |
---|
115 | |
---|
116 | DROP TABLE IF EXISTS `cantturnos_municipio_tipoturno_tipoempresa`; |
---|
117 | /*!40101 SET @saved_cs_client = @@character_set_client */; |
---|
118 | /*!40101 SET character_set_client = utf8 */; |
---|
119 | CREATE TABLE `cantturnos_municipio_tipoturno_tipoempresa` ( |
---|
120 | `ue_ciiu` int(11) DEFAULT NULL, |
---|
121 | `ue_estado` varchar(45) DEFAULT NULL, |
---|
122 | `ue_municipio` varchar(5) DEFAULT NULL, |
---|
123 | `ue_tipo_turno` varchar(60) DEFAULT NULL, |
---|
124 | `ue_tipo_empresa` varchar(150) DEFAULT NULL, |
---|
125 | `cantidad_ues` int(11) DEFAULT NULL, |
---|
126 | `cantidad_turnos` int(11) DEFAULT NULL |
---|
127 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
---|
128 | /*!40101 SET character_set_client = @saved_cs_client */; |
---|
129 | |
---|
130 | -- |
---|
131 | -- Table structure for table `cantues_ciiuinsumo_tipoempresa` |
---|
132 | -- |
---|
133 | |
---|
134 | DROP TABLE IF EXISTS `cantues_ciiuinsumo_tipoempresa`; |
---|
135 | /*!40101 SET @saved_cs_client = @@character_set_client */; |
---|
136 | /*!40101 SET character_set_client = utf8 */; |
---|
137 | CREATE TABLE `cantues_ciiuinsumo_tipoempresa` ( |
---|
138 | `ciiu_insumo` varchar(5) NOT NULL, |
---|
139 | `tipo_empresa` varchar(70) NOT NULL, |
---|
140 | `cantidad_ues` int(11) NOT NULL |
---|
141 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
---|
142 | /*!40101 SET character_set_client = @saved_cs_client */; |
---|
143 | |
---|
144 | -- |
---|
145 | -- Table structure for table `cantues_ciiuproducto_tipoempresa` |
---|
146 | -- |
---|
147 | |
---|
148 | DROP TABLE IF EXISTS `cantues_ciiuproducto_tipoempresa`; |
---|
149 | /*!40101 SET @saved_cs_client = @@character_set_client */; |
---|
150 | /*!40101 SET character_set_client = utf8 */; |
---|
151 | CREATE TABLE `cantues_ciiuproducto_tipoempresa` ( |
---|
152 | `ciiu_producto` varchar(5) NOT NULL, |
---|
153 | `tipo_empresa` varchar(70) NOT NULL, |
---|
154 | `cantidad_ues` int(11) NOT NULL |
---|
155 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
---|
156 | /*!40101 SET character_set_client = @saved_cs_client */; |
---|
157 | |
---|
158 | -- |
---|
159 | -- Table structure for table `consumo_insumos` |
---|
160 | -- |
---|
161 | |
---|
162 | DROP TABLE IF EXISTS `consumo_insumos`; |
---|
163 | /*!40101 SET @saved_cs_client = @@character_set_client */; |
---|
164 | /*!40101 SET character_set_client = utf8 */; |
---|
165 | CREATE TABLE `consumo_insumos` ( |
---|
166 | `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, |
---|
167 | `insumo_id` int(11) NOT NULL, |
---|
168 | `anyo` int(4) NOT NULL, |
---|
169 | `cant_comp_nac` double NOT NULL, |
---|
170 | `cant_comp_imp` double NOT NULL, |
---|
171 | `cu_estimada_necesaria_actual` double NOT NULL, |
---|
172 | UNIQUE KEY `id` (`id`) |
---|
173 | ) ENGINE=InnoDB AUTO_INCREMENT=37765 DEFAULT CHARSET=utf8; |
---|
174 | /*!40101 SET character_set_client = @saved_cs_client */; |
---|
175 | |
---|
176 | -- |
---|
177 | -- Table structure for table `consumoenerg_ciiu_tipoempresa` |
---|
178 | -- |
---|
179 | |
---|
180 | DROP TABLE IF EXISTS `consumoenerg_ciiu_tipoempresa`; |
---|
181 | /*!40101 SET @saved_cs_client = @@character_set_client */; |
---|
182 | /*!40101 SET character_set_client = utf8 */; |
---|
183 | CREATE TABLE `consumoenerg_ciiu_tipoempresa` ( |
---|
184 | `ciiu` varchar(5) DEFAULT NULL, |
---|
185 | `tipo_empresa` varchar(70) DEFAULT NULL, |
---|
186 | `sede_consumo_agua` double DEFAULT NULL, |
---|
187 | `sede_consumo_electrico` double DEFAULT NULL, |
---|
188 | `sede_consumo_gas` double DEFAULT NULL, |
---|
189 | `planta_consumo_agua` double DEFAULT NULL, |
---|
190 | `planta_consumo_electrico` double DEFAULT NULL, |
---|
191 | `planta_consumo_gas` double DEFAULT NULL, |
---|
192 | `sucursal_consumo_agua` double DEFAULT NULL, |
---|
193 | `sucursal_consumo_electrico` double DEFAULT NULL, |
---|
194 | `sucursal_consumo_gas` double DEFAULT NULL, |
---|
195 | `total_consumo_agua` double DEFAULT NULL, |
---|
196 | `total_consumo_electrico` double DEFAULT NULL, |
---|
197 | `total_consumo_gas` double DEFAULT NULL |
---|
198 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
---|
199 | /*!40101 SET character_set_client = @saved_cs_client */; |
---|
200 | |
---|
201 | -- |
---|
202 | -- Table structure for table `consumoenerg_planta_ciiu_tipoempresa` |
---|
203 | -- |
---|
204 | |
---|
205 | DROP TABLE IF EXISTS `consumoenerg_planta_ciiu_tipoempresa`; |
---|
206 | /*!40101 SET @saved_cs_client = @@character_set_client */; |
---|
207 | /*!40101 SET character_set_client = utf8 */; |
---|
208 | CREATE TABLE `consumoenerg_planta_ciiu_tipoempresa` ( |
---|
209 | `ciiu` varchar(5) DEFAULT NULL, |
---|
210 | `tipo_empresa` varchar(70) DEFAULT NULL, |
---|
211 | `consumo_agua` double DEFAULT NULL, |
---|
212 | `consumo_electrico` double DEFAULT NULL, |
---|
213 | `consumo_gas` double DEFAULT NULL |
---|
214 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
---|
215 | /*!40101 SET character_set_client = @saved_cs_client */; |
---|
216 | |
---|
217 | -- |
---|
218 | -- Table structure for table `consumoenerg_sedeprincipal_ciiu_tipoempresa` |
---|
219 | -- |
---|
220 | |
---|
221 | DROP TABLE IF EXISTS `consumoenerg_sedeprincipal_ciiu_tipoempresa`; |
---|
222 | /*!40101 SET @saved_cs_client = @@character_set_client */; |
---|
223 | /*!40101 SET character_set_client = utf8 */; |
---|
224 | CREATE TABLE `consumoenerg_sedeprincipal_ciiu_tipoempresa` ( |
---|
225 | `ciiu` varchar(5) DEFAULT NULL, |
---|
226 | `tipo_empresa` varchar(70) DEFAULT NULL, |
---|
227 | `consumo_agua` double DEFAULT NULL, |
---|
228 | `consumo_electrico` double DEFAULT NULL, |
---|
229 | `consumo_gas` double DEFAULT NULL |
---|
230 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
---|
231 | /*!40101 SET character_set_client = @saved_cs_client */; |
---|
232 | |
---|
233 | -- |
---|
234 | -- Table structure for table `consumoenerg_sucursal_ciiu_tipoempresa` |
---|
235 | -- |
---|
236 | |
---|
237 | DROP TABLE IF EXISTS `consumoenerg_sucursal_ciiu_tipoempresa`; |
---|
238 | /*!40101 SET @saved_cs_client = @@character_set_client */; |
---|
239 | /*!40101 SET character_set_client = utf8 */; |
---|
240 | CREATE TABLE `consumoenerg_sucursal_ciiu_tipoempresa` ( |
---|
241 | `ciiu` varchar(5) DEFAULT NULL, |
---|
242 | `tipo_empresa` varchar(70) DEFAULT NULL, |
---|
243 | `consumo_agua` double DEFAULT NULL, |
---|
244 | `consumo_electrico` double DEFAULT NULL, |
---|
245 | `consumo_gas` double DEFAULT NULL |
---|
246 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
---|
247 | /*!40101 SET character_set_client = @saved_cs_client */; |
---|
248 | |
---|
249 | -- |
---|
250 | -- Table structure for table `correspondencia_codigoaran_ciiu` |
---|
251 | -- |
---|
252 | |
---|
253 | DROP TABLE IF EXISTS `correspondencia_codigoaran_ciiu`; |
---|
254 | /*!40101 SET @saved_cs_client = @@character_set_client */; |
---|
255 | /*!40101 SET character_set_client = utf8 */; |
---|
256 | CREATE TABLE `correspondencia_codigoaran_ciiu` ( |
---|
257 | `codigo_arancelario` varchar(13) NOT NULL, |
---|
258 | `ciiu` varchar(5) NOT NULL |
---|
259 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
---|
260 | /*!40101 SET character_set_client = @saved_cs_client */; |
---|
261 | |
---|
262 | -- |
---|
263 | -- Table structure for table `edadmaquinaria_ciiu_estadomaquinaria_tipoempresa` |
---|
264 | -- |
---|
265 | |
---|
266 | DROP TABLE IF EXISTS `edadmaquinaria_ciiu_estadomaquinaria_tipoempresa`; |
---|
267 | /*!40101 SET @saved_cs_client = @@character_set_client */; |
---|
268 | /*!40101 SET character_set_client = utf8 */; |
---|
269 | CREATE TABLE `edadmaquinaria_ciiu_estadomaquinaria_tipoempresa` ( |
---|
270 | `ue_ciiu` varchar(5) NOT NULL, |
---|
271 | `estado_maquinaria` varchar(45) NOT NULL, |
---|
272 | `tipo_empresa` varchar(70) NOT NULL, |
---|
273 | `sumatoria_edad` int(11) DEFAULT NULL, |
---|
274 | `sumatoria_cantidad_maquinarias` int(11) DEFAULT NULL |
---|
275 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
---|
276 | /*!40101 SET character_set_client = @saved_cs_client */; |
---|
277 | |
---|
278 | -- |
---|
279 | -- Table structure for table `insumo` |
---|
280 | -- |
---|
281 | |
---|
282 | DROP TABLE IF EXISTS `insumo`; |
---|
283 | /*!40101 SET @saved_cs_client = @@character_set_client */; |
---|
284 | /*!40101 SET character_set_client = utf8 */; |
---|
285 | CREATE TABLE `insumo` ( |
---|
286 | `id` int(11) NOT NULL, |
---|
287 | `nombre` varchar(100) NOT NULL, |
---|
288 | `esp_tec` text NOT NULL, |
---|
289 | `codigo_aran` varchar(13) NOT NULL, |
---|
290 | `unidad_medida_id` int(11) NOT NULL, |
---|
291 | `peso` double NOT NULL, |
---|
292 | `planta_id` int(11) NOT NULL, |
---|
293 | `n_proveedores` int(11) NOT NULL, |
---|
294 | `marca` varchar(100) DEFAULT NULL |
---|
295 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
---|
296 | /*!40101 SET character_set_client = @saved_cs_client */; |
---|
297 | |
---|
298 | -- |
---|
299 | -- Table structure for table `insumo_extra` |
---|
300 | -- |
---|
301 | |
---|
302 | DROP TABLE IF EXISTS `insumo_extra`; |
---|
303 | /*!40101 SET @saved_cs_client = @@character_set_client */; |
---|
304 | /*!40101 SET character_set_client = utf8 */; |
---|
305 | CREATE TABLE `insumo_extra` ( |
---|
306 | `nombre` varchar(100) NOT NULL, |
---|
307 | `esp_tec` text NOT NULL, |
---|
308 | `codigo_aran` varchar(13) NOT NULL, |
---|
309 | `unidad_medida` int(11) DEFAULT NULL, |
---|
310 | `peso` double DEFAULT NULL, |
---|
311 | `ue_rif` varchar(11) NOT NULL, |
---|
312 | `marca` varchar(100) DEFAULT NULL, |
---|
313 | `cant_comp_nac` double NOT NULL, |
---|
314 | `cant_comp_imp` double NOT NULL, |
---|
315 | `cu_estimada_necesaria_actual` double NOT NULL, |
---|
316 | `anyo` int(4) NOT NULL |
---|
317 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
---|
318 | /*!40101 SET character_set_client = @saved_cs_client */; |
---|
319 | |
---|
320 | -- |
---|
321 | -- Table structure for table `maquinaria` |
---|
322 | -- |
---|
323 | |
---|
324 | DROP TABLE IF EXISTS `maquinaria`; |
---|
325 | /*!40101 SET @saved_cs_client = @@character_set_client */; |
---|
326 | /*!40101 SET character_set_client = utf8 */; |
---|
327 | CREATE TABLE `maquinaria` ( |
---|
328 | `id` int(15) NOT NULL, |
---|
329 | `nombre` varchar(100) NOT NULL, |
---|
330 | `descripcion` varchar(200) NOT NULL, |
---|
331 | `consumo_electrico` decimal(20,2) NOT NULL, |
---|
332 | `voltaje` decimal(20,2) NOT NULL, |
---|
333 | `potencia` decimal(20,2) NOT NULL, |
---|
334 | `litros_agua` decimal(20,2) NOT NULL, |
---|
335 | `tipo_combustible` varchar(100) DEFAULT NULL, |
---|
336 | `distribucion_componente_id` int(11) NOT NULL, |
---|
337 | `pais_id` int(11) NOT NULL, |
---|
338 | `anho_adq` int(11) NOT NULL, |
---|
339 | `anho_fabricacion` int(4) NOT NULL, |
---|
340 | `vida_util` int(11) NOT NULL, |
---|
341 | `estado_maq_id` int(11) NOT NULL, |
---|
342 | `planta_id` int(11) NOT NULL, |
---|
343 | `anho` int(4) NOT NULL, |
---|
344 | `fecha_insercion` date NOT NULL, |
---|
345 | `fecha_situacion` date NOT NULL, |
---|
346 | `cantidad` int(11) NOT NULL, |
---|
347 | PRIMARY KEY (`id`) |
---|
348 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
---|
349 | /*!40101 SET character_set_client = @saved_cs_client */; |
---|
350 | |
---|
351 | -- |
---|
352 | -- Table structure for table `maquinaria_extra` |
---|
353 | -- |
---|
354 | |
---|
355 | DROP TABLE IF EXISTS `maquinaria_extra`; |
---|
356 | /*!40101 SET @saved_cs_client = @@character_set_client */; |
---|
357 | /*!40101 SET character_set_client = utf8 */; |
---|
358 | CREATE TABLE `maquinaria_extra` ( |
---|
359 | `id` int(15) NOT NULL, |
---|
360 | `nombre` varchar(100) NOT NULL, |
---|
361 | `descripcion` varchar(200) NOT NULL, |
---|
362 | `anho_adq` int(11) NOT NULL, |
---|
363 | `anho_fabricacion` int(4) NOT NULL, |
---|
364 | `vida_util` int(11) NOT NULL, |
---|
365 | `estado_maquinaria` varchar(200) NOT NULL, |
---|
366 | `ue_rif` varchar(13) NOT NULL, |
---|
367 | `ue_ciiu` varchar(20) NOT NULL, |
---|
368 | `ue_planta` varchar(200) NOT NULL, |
---|
369 | `ue_ciudad_planta` varchar(150) NOT NULL, |
---|
370 | `ue_parroquia_planta` varchar(6) NOT NULL, |
---|
371 | `anho` int(4) NOT NULL, |
---|
372 | `cantidad` int(11) NOT NULL, |
---|
373 | `pais_origen` varchar(200) DEFAULT NULL, |
---|
374 | PRIMARY KEY (`id`) |
---|
375 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
---|
376 | /*!40101 SET character_set_client = @saved_cs_client */; |
---|
377 | |
---|
378 | -- |
---|
379 | -- Table structure for table `marca` |
---|
380 | -- |
---|
381 | |
---|
382 | DROP TABLE IF EXISTS `marca`; |
---|
383 | /*!40101 SET @saved_cs_client = @@character_set_client */; |
---|
384 | /*!40101 SET character_set_client = utf8 */; |
---|
385 | CREATE TABLE `marca` ( |
---|
386 | `nombre` varchar(250) NOT NULL, |
---|
387 | PRIMARY KEY (`nombre`) |
---|
388 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
---|
389 | /*!40101 SET character_set_client = @saved_cs_client */; |
---|
390 | |
---|
391 | -- |
---|
392 | -- Table structure for table `personalocupado` |
---|
393 | -- |
---|
394 | |
---|
395 | DROP TABLE IF EXISTS `personalocupado`; |
---|
396 | /*!40101 SET @saved_cs_client = @@character_set_client */; |
---|
397 | /*!40101 SET character_set_client = utf8 */; |
---|
398 | CREATE TABLE `personalocupado` ( |
---|
399 | `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, |
---|
400 | `indirectos` int(11) DEFAULT NULL, |
---|
401 | `tipo_turno` varchar(70) NOT NULL, |
---|
402 | `turnos` int(11) NOT NULL, |
---|
403 | `horas_turnos` int(11) NOT NULL, |
---|
404 | `femeninosf` int(11) NOT NULL, |
---|
405 | `femeninosc` int(11) NOT NULL, |
---|
406 | `masculinof` int(11) NOT NULL, |
---|
407 | `masculinoc` int(11) NOT NULL, |
---|
408 | `administrativo` int(11) NOT NULL, |
---|
409 | `operativo` int(11) NOT NULL, |
---|
410 | `unidad_economica_rif` varchar(10) NOT NULL, |
---|
411 | `anyo` int(11) NOT NULL, |
---|
412 | `activo` varchar(45) DEFAULT NULL, |
---|
413 | UNIQUE KEY `id` (`id`) |
---|
414 | ) ENGINE=InnoDB AUTO_INCREMENT=961 DEFAULT CHARSET=utf8; |
---|
415 | /*!40101 SET character_set_client = @saved_cs_client */; |
---|
416 | |
---|
417 | -- |
---|
418 | -- Table structure for table `planta` |
---|
419 | -- |
---|
420 | |
---|
421 | DROP TABLE IF EXISTS `planta`; |
---|
422 | /*!40101 SET @saved_cs_client = @@character_set_client */; |
---|
423 | /*!40101 SET character_set_client = utf8 */; |
---|
424 | CREATE TABLE `planta` ( |
---|
425 | `id` int(15) NOT NULL, |
---|
426 | `ue_rif` varchar(10) CHARACTER SET big5 NOT NULL, |
---|
427 | `nombre` varchar(100) NOT NULL, |
---|
428 | `telefono` varchar(20) CHARACTER SET big5 NOT NULL, |
---|
429 | `fax` varchar(20) CHARACTER SET big5 DEFAULT NULL, |
---|
430 | `pag_web` varchar(100) DEFAULT NULL, |
---|
431 | `email` varchar(75) DEFAULT NULL, |
---|
432 | `ciudad` varchar(100) NOT NULL, |
---|
433 | `parroquia_codigo` varchar(6) CHARACTER SET big5 NOT NULL, |
---|
434 | `tipo_tenencia_id` int(11) NOT NULL, |
---|
435 | `tenencia_otra` varchar(100) DEFAULT NULL, |
---|
436 | `m2_terreno` double NOT NULL, |
---|
437 | `m2_construccion` double NOT NULL, |
---|
438 | `tipo_ambito_industrial_id` int(11) DEFAULT NULL, |
---|
439 | `ambito_industrial_otro` varchar(100) DEFAULT NULL, |
---|
440 | `autonomia_electrica` tinyint(1) NOT NULL, |
---|
441 | `dir1` varchar(60) NOT NULL, |
---|
442 | `dir2` varchar(60) NOT NULL, |
---|
443 | `dir3` varchar(60) DEFAULT NULL, |
---|
444 | `dir4` varchar(60) NOT NULL, |
---|
445 | `activo` tinyint(1) NOT NULL, |
---|
446 | `consumo_electrico` decimal(20,2) NOT NULL, |
---|
447 | `consumo_agua` decimal(20,2) NOT NULL, |
---|
448 | `consumo_gas` decimal(20,2) NOT NULL, |
---|
449 | `capacidad_utilizada` decimal(20,2) DEFAULT NULL, |
---|
450 | `tipo_tenencia` varchar(45) DEFAULT NULL, |
---|
451 | `municipio_codigo` varchar(4) DEFAULT NULL, |
---|
452 | `entidad_codigo` varchar(45) DEFAULT NULL, |
---|
453 | PRIMARY KEY (`id`), |
---|
454 | UNIQUE KEY `id_UNIQUE` (`id`) |
---|
455 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
---|
456 | /*!40101 SET character_set_client = @saved_cs_client */; |
---|
457 | |
---|
458 | -- |
---|
459 | -- Table structure for table `proveedor` |
---|
460 | -- |
---|
461 | |
---|
462 | DROP TABLE IF EXISTS `proveedor`; |
---|
463 | /*!40101 SET @saved_cs_client = @@character_set_client */; |
---|
464 | /*!40101 SET character_set_client = utf8 */; |
---|
465 | CREATE TABLE `proveedor` ( |
---|
466 | `id` int(11) NOT NULL, |
---|
467 | `nombre` varchar(100) NOT NULL, |
---|
468 | `rif` varchar(10) DEFAULT NULL, |
---|
469 | `pais_origen` varchar(150) DEFAULT NULL, |
---|
470 | `pais_procedencia` varchar(150) DEFAULT NULL, |
---|
471 | `nacional` char(1) NOT NULL, |
---|
472 | `planta_id` int(11) NOT NULL, |
---|
473 | PRIMARY KEY (`id`) |
---|
474 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
---|
475 | /*!40101 SET character_set_client = @saved_cs_client */; |
---|
476 | |
---|
477 | -- |
---|
478 | -- Table structure for table `proveedor_extra` |
---|
479 | -- |
---|
480 | |
---|
481 | DROP TABLE IF EXISTS `proveedor_extra`; |
---|
482 | /*!40101 SET @saved_cs_client = @@character_set_client */; |
---|
483 | /*!40101 SET character_set_client = utf8 */; |
---|
484 | CREATE TABLE `proveedor_extra` ( |
---|
485 | `nombre` varchar(100) NOT NULL, |
---|
486 | `rif` varchar(10) DEFAULT NULL, |
---|
487 | `pais_origen` varchar(150) DEFAULT NULL, |
---|
488 | `pais_procedencia` varchar(150) DEFAULT NULL, |
---|
489 | `nacional` char(1) NOT NULL, |
---|
490 | `planta_id` int(11) NOT NULL, |
---|
491 | `ue_rif` varchar(10) NOT NULL, |
---|
492 | `ue_ciiu` varchar(5) NOT NULL, |
---|
493 | `ue_tipo` varchar(150) NOT NULL, |
---|
494 | `ue_estado` varchar(50) NOT NULL, |
---|
495 | `ue_municipio` varchar(50) NOT NULL |
---|
496 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
---|
497 | /*!40101 SET character_set_client = @saved_cs_client */; |
---|
498 | |
---|
499 | -- |
---|
500 | -- Table structure for table `proveedores_insumo` |
---|
501 | -- |
---|
502 | |
---|
503 | DROP TABLE IF EXISTS `proveedores_insumo`; |
---|
504 | /*!40101 SET @saved_cs_client = @@character_set_client */; |
---|
505 | /*!40101 SET character_set_client = utf8 */; |
---|
506 | CREATE TABLE `proveedores_insumo` ( |
---|
507 | `comprado_r` decimal(25,2) DEFAULT NULL, |
---|
508 | `anho_r` int(11) DEFAULT NULL, |
---|
509 | `cantidad_comprada_r` decimal(25,2) DEFAULT NULL, |
---|
510 | `unidad_id` int(11) DEFAULT NULL, |
---|
511 | `insumo_id` int(11) DEFAULT NULL, |
---|
512 | `nombre_insumo` varchar(100) DEFAULT NULL, |
---|
513 | `esp_tec_insumo` longtext, |
---|
514 | `codigo_aran_id` varchar(13) DEFAULT NULL, |
---|
515 | `unidad_medida_id` int(11) DEFAULT NULL, |
---|
516 | `peso` double DEFAULT NULL, |
---|
517 | `planta_id_id` int(11) DEFAULT NULL, |
---|
518 | `n_proveedores` int(11) DEFAULT NULL, |
---|
519 | `marca` varchar(100) DEFAULT NULL, |
---|
520 | `nombre_unidad_medida` varchar(100) DEFAULT NULL, |
---|
521 | `descripcion_unidad_medida` varchar(100) DEFAULT NULL, |
---|
522 | `proveedor_id` int(11) DEFAULT NULL, |
---|
523 | `nombre_proveedor` varchar(100) DEFAULT NULL, |
---|
524 | `rif_proveedor` varchar(10) DEFAULT NULL, |
---|
525 | `pais_origen_id` int(11) DEFAULT NULL, |
---|
526 | `pais_procedencia_id` int(11) DEFAULT NULL, |
---|
527 | `nacionalidad_proveedor` char(1) DEFAULT NULL, |
---|
528 | `nombre_pais` varchar(100) DEFAULT NULL, |
---|
529 | `rif_productor` varchar(10) DEFAULT NULL, |
---|
530 | `nombre_productor` varchar(255) DEFAULT NULL, |
---|
531 | `razon_social_productor` varchar(255) DEFAULT NULL |
---|
532 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
---|
533 | /*!40101 SET character_set_client = @saved_cs_client */; |
---|
534 | |
---|
535 | -- |
---|
536 | -- Table structure for table `razoncapitalsocialportrabajador_naturalezajuridica` |
---|
537 | -- |
---|
538 | |
---|
539 | DROP TABLE IF EXISTS `razoncapitalsocialportrabajador_naturalezajuridica`; |
---|
540 | /*!40101 SET @saved_cs_client = @@character_set_client */; |
---|
541 | /*!40101 SET character_set_client = utf8 */; |
---|
542 | CREATE TABLE `razoncapitalsocialportrabajador_naturalezajuridica` ( |
---|
543 | `naturalezajuridica` varchar(150) NOT NULL, |
---|
544 | `tipoempresa` varchar(70) NOT NULL, |
---|
545 | `sumatoria_capitalsocial` double DEFAULT NULL, |
---|
546 | `sumatoria_trabajadores` int(11) DEFAULT NULL |
---|
547 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
---|
548 | /*!40101 SET character_set_client = @saved_cs_client */; |
---|
549 | |
---|
550 | -- |
---|
551 | -- Table structure for table `registro_mercantil` |
---|
552 | -- |
---|
553 | |
---|
554 | DROP TABLE IF EXISTS `registro_mercantil`; |
---|
555 | /*!40101 SET @saved_cs_client = @@character_set_client */; |
---|
556 | /*!40101 SET character_set_client = utf8 */; |
---|
557 | CREATE TABLE `registro_mercantil` ( |
---|
558 | `ue_rif` varchar(10) DEFAULT NULL, |
---|
559 | `capital_social` decimal(25,2) DEFAULT NULL, |
---|
560 | `capital_pagado` decimal(25,2) DEFAULT NULL, |
---|
561 | `capital_contable` decimal(25,2) DEFAULT NULL, |
---|
562 | `naturalezajuridica` varchar(150) DEFAULT NULL, |
---|
563 | `dist_cap_publico_nacional` double DEFAULT NULL, |
---|
564 | `dist_cap_privado_nacional` double DEFAULT NULL, |
---|
565 | `dist_cap_publico_extranjero` double DEFAULT NULL, |
---|
566 | `dist_cap_privado_extranjero` varchar(45) DEFAULT NULL |
---|
567 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
---|
568 | /*!40101 SET character_set_client = @saved_cs_client */; |
---|
569 | |
---|
570 | -- |
---|
571 | -- Table structure for table `representantelegal` |
---|
572 | -- |
---|
573 | |
---|
574 | DROP TABLE IF EXISTS `representantelegal`; |
---|
575 | /*!40101 SET @saved_cs_client = @@character_set_client */; |
---|
576 | /*!40101 SET character_set_client = utf8 */; |
---|
577 | CREATE TABLE `representantelegal` ( |
---|
578 | `id` int(11) NOT NULL, |
---|
579 | `rif` varchar(10) NOT NULL, |
---|
580 | `nacionalidad` char(1) NOT NULL, |
---|
581 | `unidad_economica_rif` varchar(10) NOT NULL, |
---|
582 | `nombre` varchar(140) DEFAULT NULL, |
---|
583 | `cargo` varchar(50) NOT NULL, |
---|
584 | `telefono` varchar(20) NOT NULL, |
---|
585 | `fax` varchar(20) DEFAULT NULL, |
---|
586 | `email` varchar(50) NOT NULL, |
---|
587 | `fecha_insercion` date NOT NULL, |
---|
588 | PRIMARY KEY (`id`) |
---|
589 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
---|
590 | /*!40101 SET character_set_client = @saved_cs_client */; |
---|
591 | |
---|
592 | -- |
---|
593 | -- Table structure for table `responsabilidadsocial` |
---|
594 | -- |
---|
595 | |
---|
596 | DROP TABLE IF EXISTS `responsabilidadsocial`; |
---|
597 | /*!40101 SET @saved_cs_client = @@character_set_client */; |
---|
598 | /*!40101 SET character_set_client = utf8 */; |
---|
599 | CREATE TABLE `responsabilidadsocial` ( |
---|
600 | `id` int(11) NOT NULL, |
---|
601 | `ue_rif` varchar(10) NOT NULL, |
---|
602 | `responsabilidad` varchar(45) NOT NULL, |
---|
603 | `aporte_anual` double DEFAULT NULL, |
---|
604 | `descripcion` varchar(255) DEFAULT NULL, |
---|
605 | `beneficiario` varchar(45) DEFAULT NULL, |
---|
606 | `otro_beneficiario` varchar(100) DEFAULT NULL, |
---|
607 | `ue_ciiu` varchar(45) DEFAULT NULL, |
---|
608 | `ue_tipo` varchar(45) DEFAULT NULL |
---|
609 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
---|
610 | /*!40101 SET character_set_client = @saved_cs_client */; |
---|
611 | |
---|
612 | -- |
---|
613 | -- Table structure for table `sede_principal` |
---|
614 | -- |
---|
615 | |
---|
616 | DROP TABLE IF EXISTS `sede_principal`; |
---|
617 | /*!40101 SET @saved_cs_client = @@character_set_client */; |
---|
618 | /*!40101 SET character_set_client = utf8 */; |
---|
619 | CREATE TABLE `sede_principal` ( |
---|
620 | `id` int(15) NOT NULL, |
---|
621 | `ue_rif` varchar(10) CHARACTER SET big5 NOT NULL, |
---|
622 | `nombre` varchar(100) NOT NULL, |
---|
623 | `telefono` varchar(20) CHARACTER SET big5 NOT NULL, |
---|
624 | `fax` varchar(20) CHARACTER SET big5 DEFAULT NULL, |
---|
625 | `pag_web` varchar(100) DEFAULT NULL, |
---|
626 | `email` varchar(75) DEFAULT NULL, |
---|
627 | `ciudad` varchar(100) NOT NULL, |
---|
628 | `parroquia_codigo` varchar(6) CHARACTER SET big5 NOT NULL, |
---|
629 | `tipo_tenencia_id` int(11) NOT NULL, |
---|
630 | `tenencia_otra` varchar(100) DEFAULT NULL, |
---|
631 | `m2_terreno` double NOT NULL, |
---|
632 | `m2_construccion` double NOT NULL, |
---|
633 | `tipo_ambito_industrial_id` int(11) DEFAULT NULL, |
---|
634 | `ambito_industrial_otro` varchar(100) DEFAULT NULL, |
---|
635 | `autonomia_electrica` tinyint(1) NOT NULL, |
---|
636 | `dir1` varchar(60) NOT NULL, |
---|
637 | `dir2` varchar(60) NOT NULL, |
---|
638 | `dir3` varchar(60) DEFAULT NULL, |
---|
639 | `dir4` varchar(60) NOT NULL, |
---|
640 | `activo` tinyint(1) NOT NULL, |
---|
641 | `consumo_electrico` decimal(20,2) NOT NULL, |
---|
642 | `consumo_agua` decimal(20,2) NOT NULL, |
---|
643 | `consumo_gas` decimal(20,2) NOT NULL, |
---|
644 | `capacidad_utilizada` decimal(20,2) DEFAULT NULL, |
---|
645 | `tipo_tenencia` varchar(45) DEFAULT NULL, |
---|
646 | `municipio_codigo` varchar(4) DEFAULT NULL, |
---|
647 | `entidad_codigo` varchar(45) DEFAULT NULL, |
---|
648 | PRIMARY KEY (`id`), |
---|
649 | UNIQUE KEY `id_UNIQUE` (`id`) |
---|
650 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
---|
651 | /*!40101 SET character_set_client = @saved_cs_client */; |
---|
652 | |
---|
653 | -- |
---|
654 | -- Table structure for table `servicio` |
---|
655 | -- |
---|
656 | |
---|
657 | DROP TABLE IF EXISTS `servicio`; |
---|
658 | /*!40101 SET @saved_cs_client = @@character_set_client */; |
---|
659 | /*!40101 SET character_set_client = utf8 */; |
---|
660 | CREATE TABLE `servicio` ( |
---|
661 | `id` int(11) NOT NULL, |
---|
662 | `descripcion` varchar(200) NOT NULL, |
---|
663 | `codigo_ciiu` varchar(5) NOT NULL, |
---|
664 | `ue_rif` varchar(10) NOT NULL, |
---|
665 | PRIMARY KEY (`id`) |
---|
666 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
---|
667 | /*!40101 SET character_set_client = @saved_cs_client */; |
---|
668 | |
---|
669 | -- |
---|
670 | -- Table structure for table `similares` |
---|
671 | -- |
---|
672 | |
---|
673 | DROP TABLE IF EXISTS `similares`; |
---|
674 | /*!40101 SET @saved_cs_client = @@character_set_client */; |
---|
675 | /*!40101 SET character_set_client = utf8 */; |
---|
676 | CREATE TABLE `similares` ( |
---|
677 | `rif` varchar(10) DEFAULT NULL, |
---|
678 | `pais` varchar(200) NOT NULL, |
---|
679 | `nombre` varchar(100) NOT NULL, |
---|
680 | `ue_rif` varchar(10) NOT NULL, |
---|
681 | `anho_r` int(4) NOT NULL, |
---|
682 | `ciiu_principal` varchar(13) NOT NULL, |
---|
683 | `ue_tipo` varchar(100) NOT NULL |
---|
684 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
---|
685 | /*!40101 SET character_set_client = @saved_cs_client */; |
---|
686 | |
---|
687 | -- |
---|
688 | -- Table structure for table `socio` |
---|
689 | -- |
---|
690 | |
---|
691 | DROP TABLE IF EXISTS `socio`; |
---|
692 | /*!40101 SET @saved_cs_client = @@character_set_client */; |
---|
693 | /*!40101 SET character_set_client = utf8 */; |
---|
694 | CREATE TABLE `socio` ( |
---|
695 | `id` int(11) NOT NULL, |
---|
696 | `rif` varchar(30) DEFAULT NULL, |
---|
697 | `ue_rif` varchar(10) NOT NULL, |
---|
698 | `nombre` varchar(140) NOT NULL, |
---|
699 | `nacionalidad` varchar(1) NOT NULL, |
---|
700 | `tipo_persona_id` int(11) NOT NULL, |
---|
701 | `porcentaje` double NOT NULL, |
---|
702 | PRIMARY KEY (`id`) |
---|
703 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
---|
704 | /*!40101 SET character_set_client = @saved_cs_client */; |
---|
705 | |
---|
706 | -- |
---|
707 | -- Table structure for table `sucursal` |
---|
708 | -- |
---|
709 | |
---|
710 | DROP TABLE IF EXISTS `sucursal`; |
---|
711 | /*!40101 SET @saved_cs_client = @@character_set_client */; |
---|
712 | /*!40101 SET character_set_client = utf8 */; |
---|
713 | CREATE TABLE `sucursal` ( |
---|
714 | `id` int(15) NOT NULL, |
---|
715 | `ue_rif` varchar(10) CHARACTER SET big5 NOT NULL, |
---|
716 | `nombre` varchar(100) NOT NULL, |
---|
717 | `telefono` varchar(20) CHARACTER SET big5 NOT NULL, |
---|
718 | `fax` varchar(20) CHARACTER SET big5 DEFAULT NULL, |
---|
719 | `pag_web` varchar(100) CHARACTER SET big5 DEFAULT NULL, |
---|
720 | `email` varchar(75) DEFAULT NULL, |
---|
721 | `ciudad` varchar(100) NOT NULL, |
---|
722 | `parroquia_codigo` varchar(6) CHARACTER SET big5 NOT NULL, |
---|
723 | `tipo_tenencia_id` int(11) NOT NULL, |
---|
724 | `tenencia_otra` varchar(100) DEFAULT NULL, |
---|
725 | `m2_terreno` double NOT NULL, |
---|
726 | `m2_construccion` double NOT NULL, |
---|
727 | `tipo_ambito_industrial_id` int(11) DEFAULT NULL, |
---|
728 | `ambito_industrial_otro` varchar(100) DEFAULT NULL, |
---|
729 | `autonomia_electrica` tinyint(1) NOT NULL, |
---|
730 | `dir1` varchar(54) NOT NULL, |
---|
731 | `dir2` varchar(54) NOT NULL, |
---|
732 | `dir3` varchar(54) DEFAULT NULL, |
---|
733 | `dir4` varchar(54) NOT NULL, |
---|
734 | `activo` tinyint(1) NOT NULL, |
---|
735 | `consumo_electrico` decimal(20,2) NOT NULL, |
---|
736 | `consumo_agua` decimal(20,2) NOT NULL, |
---|
737 | `consumo_gas` decimal(20,2) NOT NULL, |
---|
738 | `capacidad_utilizada` decimal(20,2) DEFAULT NULL, |
---|
739 | PRIMARY KEY (`id`), |
---|
740 | UNIQUE KEY `id_UNIQUE` (`id`) |
---|
741 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
---|
742 | /*!40101 SET character_set_client = @saved_cs_client */; |
---|
743 | |
---|
744 | -- |
---|
745 | -- Table structure for table `tipo_actividad_ad_sede_planta` |
---|
746 | -- |
---|
747 | |
---|
748 | DROP TABLE IF EXISTS `tipo_actividad_ad_sede_planta`; |
---|
749 | /*!40101 SET @saved_cs_client = @@character_set_client */; |
---|
750 | /*!40101 SET character_set_client = utf8 */; |
---|
751 | CREATE TABLE `tipo_actividad_ad_sede_planta` ( |
---|
752 | `id` int(11) DEFAULT NULL, |
---|
753 | `subunidad_economica_id` int(11) DEFAULT NULL, |
---|
754 | `tipo_actividad_id` int(11) DEFAULT NULL, |
---|
755 | `nombre_actividad_ad` varchar(60) CHARACTER SET utf8 DEFAULT NULL, |
---|
756 | `ue_rif` varchar(10) CHARACTER SET utf8 DEFAULT NULL, |
---|
757 | `tipo_subunidad` varchar(2) CHARACTER SET utf8 DEFAULT NULL, |
---|
758 | `parroquia_codigo` varchar(6) CHARACTER SET utf8 DEFAULT NULL |
---|
759 | ) ENGINE=InnoDB DEFAULT CHARSET=big5; |
---|
760 | /*!40101 SET character_set_client = @saved_cs_client */; |
---|
761 | |
---|
762 | -- |
---|
763 | -- Table structure for table `tipo_ambito` |
---|
764 | -- |
---|
765 | |
---|
766 | DROP TABLE IF EXISTS `tipo_ambito`; |
---|
767 | /*!40101 SET @saved_cs_client = @@character_set_client */; |
---|
768 | /*!40101 SET character_set_client = utf8 */; |
---|
769 | CREATE TABLE `tipo_ambito` ( |
---|
770 | `id` int(11) NOT NULL, |
---|
771 | `nombre` varchar(60) DEFAULT NULL, |
---|
772 | PRIMARY KEY (`id`), |
---|
773 | UNIQUE KEY `id_UNIQUE` (`id`), |
---|
774 | UNIQUE KEY `nombre_UNIQUE` (`nombre`) |
---|
775 | ) ENGINE=InnoDB DEFAULT CHARSET=big5; |
---|
776 | /*!40101 SET character_set_client = @saved_cs_client */; |
---|
777 | |
---|
778 | -- |
---|
779 | -- Table structure for table `tipo_combustible` |
---|
780 | -- |
---|
781 | |
---|
782 | DROP TABLE IF EXISTS `tipo_combustible`; |
---|
783 | /*!40101 SET @saved_cs_client = @@character_set_client */; |
---|
784 | /*!40101 SET character_set_client = utf8 */; |
---|
785 | CREATE TABLE `tipo_combustible` ( |
---|
786 | `tipo_combustible` varchar(100) NOT NULL |
---|
787 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
---|
788 | /*!40101 SET character_set_client = @saved_cs_client */; |
---|
789 | |
---|
790 | -- |
---|
791 | -- Table structure for table `tipo_tenencia` |
---|
792 | -- |
---|
793 | |
---|
794 | DROP TABLE IF EXISTS `tipo_tenencia`; |
---|
795 | /*!40101 SET @saved_cs_client = @@character_set_client */; |
---|
796 | /*!40101 SET character_set_client = utf8 */; |
---|
797 | CREATE TABLE `tipo_tenencia` ( |
---|
798 | `id` int(11) NOT NULL, |
---|
799 | `nombre` varchar(60) DEFAULT NULL, |
---|
800 | PRIMARY KEY (`id`), |
---|
801 | UNIQUE KEY `id_UNIQUE` (`id`), |
---|
802 | UNIQUE KEY `nombre_UNIQUE` (`nombre`) |
---|
803 | ) ENGINE=InnoDB DEFAULT CHARSET=big5; |
---|
804 | /*!40101 SET character_set_client = @saved_cs_client */; |
---|
805 | |
---|
806 | -- |
---|
807 | -- Table structure for table `traduccion_dir` |
---|
808 | -- |
---|
809 | |
---|
810 | DROP TABLE IF EXISTS `traduccion_dir`; |
---|
811 | /*!40101 SET @saved_cs_client = @@character_set_client */; |
---|
812 | /*!40101 SET character_set_client = utf8 */; |
---|
813 | CREATE TABLE `traduccion_dir` ( |
---|
814 | `letra` char(1) NOT NULL, |
---|
815 | `traduccion` varchar(100) DEFAULT NULL, |
---|
816 | PRIMARY KEY (`letra`) |
---|
817 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
---|
818 | /*!40101 SET character_set_client = @saved_cs_client */; |
---|
819 | |
---|
820 | -- |
---|
821 | -- Table structure for table `ue_ciiu_ambito_tipoempresa` |
---|
822 | -- |
---|
823 | |
---|
824 | DROP TABLE IF EXISTS `ue_ciiu_ambito_tipoempresa`; |
---|
825 | /*!40101 SET @saved_cs_client = @@character_set_client */; |
---|
826 | /*!40101 SET character_set_client = utf8 */; |
---|
827 | CREATE TABLE `ue_ciiu_ambito_tipoempresa` ( |
---|
828 | `ue_ciiu` varchar(5) CHARACTER SET big5 NOT NULL, |
---|
829 | `ue_ambito` varchar(60) NOT NULL, |
---|
830 | `ue_tipo_empresa` varchar(150) DEFAULT NULL, |
---|
831 | `cantidad_ues` int(11) DEFAULT NULL |
---|
832 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
---|
833 | /*!40101 SET character_set_client = @saved_cs_client */; |
---|
834 | |
---|
835 | -- |
---|
836 | -- Table structure for table `ue_diff` |
---|
837 | -- |
---|
838 | |
---|
839 | DROP TABLE IF EXISTS `ue_diff`; |
---|
840 | /*!40101 SET @saved_cs_client = @@character_set_client */; |
---|
841 | /*!40101 SET character_set_client = utf8 */; |
---|
842 | CREATE TABLE `ue_diff` ( |
---|
843 | `rif` varchar(10) CHARACTER SET latin1 NOT NULL, |
---|
844 | `nombre` varchar(200) CHARACTER SET latin1 DEFAULT NULL, |
---|
845 | `personal_indirecto` int(11) DEFAULT NULL, |
---|
846 | `personal_femenino_contratado` int(11) DEFAULT NULL, |
---|
847 | `personal_femenino_fijo` int(11) DEFAULT NULL, |
---|
848 | `personal_masculino_contratado` int(11) DEFAULT NULL, |
---|
849 | `personal_masculino_fijo` int(11) DEFAULT NULL, |
---|
850 | `tipo_empresa` varchar(150) NOT NULL, |
---|
851 | PRIMARY KEY (`rif`), |
---|
852 | UNIQUE KEY `rif_UNIQUE` (`rif`) |
---|
853 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
---|
854 | /*!40101 SET character_set_client = @saved_cs_client */; |
---|
855 | |
---|
856 | -- |
---|
857 | -- Table structure for table `ue_full` |
---|
858 | -- |
---|
859 | |
---|
860 | DROP TABLE IF EXISTS `ue_full`; |
---|
861 | /*!40101 SET @saved_cs_client = @@character_set_client */; |
---|
862 | /*!40101 SET character_set_client = utf8 */; |
---|
863 | CREATE TABLE `ue_full` ( |
---|
864 | `rif` varchar(10) CHARACTER SET latin1 NOT NULL, |
---|
865 | `nombre` varchar(200) CHARACTER SET latin1 DEFAULT NULL, |
---|
866 | `personal_indirecto` int(11) DEFAULT NULL, |
---|
867 | `personal_femenino_contratado` int(11) DEFAULT NULL, |
---|
868 | `personal_femenino_fijo` int(11) DEFAULT NULL, |
---|
869 | `personal_masculino_contratado` int(11) DEFAULT NULL, |
---|
870 | `personal_masculino_fijo` int(11) DEFAULT NULL, |
---|
871 | `tipo_empresa` varchar(150) NOT NULL, |
---|
872 | `ciiu_principal` varchar(5) DEFAULT NULL, |
---|
873 | PRIMARY KEY (`rif`), |
---|
874 | UNIQUE KEY `rif_UNIQUE` (`rif`) |
---|
875 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
---|
876 | /*!40101 SET character_set_client = @saved_cs_client */; |
---|
877 | |
---|
878 | -- |
---|
879 | -- Table structure for table `ues_competidoras_y_productos` |
---|
880 | -- |
---|
881 | |
---|
882 | DROP TABLE IF EXISTS `ues_competidoras_y_productos`; |
---|
883 | /*!40101 SET @saved_cs_client = @@character_set_client */; |
---|
884 | /*!40101 SET character_set_client = utf8 */; |
---|
885 | CREATE TABLE `ues_competidoras_y_productos` ( |
---|
886 | `nombre_competidora` varchar(100) DEFAULT NULL, |
---|
887 | `rif_competidora` varchar(10) DEFAULT NULL, |
---|
888 | `desc_prod_competidor` longtext, |
---|
889 | `unidad_economica_rif` varchar(10) DEFAULT NULL, |
---|
890 | `anho_r` int(11) DEFAULT NULL, |
---|
891 | `nombre_pais` varchar(100) DEFAULT NULL |
---|
892 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
---|
893 | /*!40101 SET character_set_client = @saved_cs_client */; |
---|
894 | |
---|
895 | -- |
---|
896 | -- Table structure for table `ues_marcaproducida` |
---|
897 | -- |
---|
898 | |
---|
899 | DROP TABLE IF EXISTS `ues_marcaproducida`; |
---|
900 | /*!40101 SET @saved_cs_client = @@character_set_client */; |
---|
901 | /*!40101 SET character_set_client = utf8 */; |
---|
902 | CREATE TABLE `ues_marcaproducida` ( |
---|
903 | `ue_rif` varchar(10) DEFAULT NULL, |
---|
904 | `marca` tinytext, |
---|
905 | `ciiu_principal` varchar(5) DEFAULT NULL, |
---|
906 | `tipo_empresa` varchar(150) DEFAULT NULL |
---|
907 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
---|
908 | /*!40101 SET character_set_client = @saved_cs_client */; |
---|
909 | |
---|
910 | -- |
---|
911 | -- Table structure for table `ues_parroquia_representantelegal` |
---|
912 | -- |
---|
913 | |
---|
914 | DROP TABLE IF EXISTS `ues_parroquia_representantelegal`; |
---|
915 | /*!40101 SET @saved_cs_client = @@character_set_client */; |
---|
916 | /*!40101 SET character_set_client = utf8 */; |
---|
917 | CREATE TABLE `ues_parroquia_representantelegal` ( |
---|
918 | `rif_representante` varchar(10) NOT NULL, |
---|
919 | `ue_rif` varchar(10) NOT NULL, |
---|
920 | `ue_razon_social` varchar(255) NOT NULL, |
---|
921 | `se_estado` varchar(50) NOT NULL, |
---|
922 | `se_municipio` varchar(50) NOT NULL, |
---|
923 | `se_parroquia` varchar(80) NOT NULL, |
---|
924 | `se_direccion` varchar(316) NOT NULL, |
---|
925 | `se_telefono` varchar(20) NOT NULL, |
---|
926 | `se_email` varchar(75) DEFAULT NULL, |
---|
927 | `nombre_representante` varchar(140) DEFAULT NULL, |
---|
928 | `cargo_representante` varchar(50) NOT NULL, |
---|
929 | `telefono_representante` varchar(20) NOT NULL, |
---|
930 | `email_representante` varchar(50) NOT NULL |
---|
931 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
---|
932 | /*!40101 SET character_set_client = @saved_cs_client */; |
---|
933 | |
---|
934 | -- |
---|
935 | -- Table structure for table `ues_parroquia_socio` |
---|
936 | -- |
---|
937 | |
---|
938 | DROP TABLE IF EXISTS `ues_parroquia_socio`; |
---|
939 | /*!40101 SET @saved_cs_client = @@character_set_client */; |
---|
940 | /*!40101 SET character_set_client = utf8 */; |
---|
941 | CREATE TABLE `ues_parroquia_socio` ( |
---|
942 | `rif_pasaporte_socio` varchar(30) DEFAULT NULL, |
---|
943 | `ue_rif` varchar(10) NOT NULL, |
---|
944 | `ue_razon_social` varchar(255) NOT NULL, |
---|
945 | `se_estado` varchar(50) NOT NULL, |
---|
946 | `se_municipio` varchar(50) NOT NULL, |
---|
947 | `se_parroquia` varchar(80) NOT NULL, |
---|
948 | `se_direccion` varchar(316) NOT NULL, |
---|
949 | `se_telefono` varchar(20) NOT NULL, |
---|
950 | `se_email` varchar(75) DEFAULT NULL, |
---|
951 | `nombre_socio` varchar(140) DEFAULT NULL |
---|
952 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
---|
953 | /*!40101 SET character_set_client = @saved_cs_client */; |
---|
954 | |
---|
955 | -- |
---|
956 | -- Table structure for table `ues_tipo_combustible` |
---|
957 | -- |
---|
958 | |
---|
959 | DROP TABLE IF EXISTS `ues_tipo_combustible`; |
---|
960 | /*!40101 SET @saved_cs_client = @@character_set_client */; |
---|
961 | /*!40101 SET character_set_client = utf8 */; |
---|
962 | CREATE TABLE `ues_tipo_combustible` ( |
---|
963 | `tipo_combustible_2` tinytext, |
---|
964 | `ue_rif` varchar(10) DEFAULT NULL |
---|
965 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
---|
966 | /*!40101 SET character_set_client = @saved_cs_client */; |
---|
967 | |
---|
968 | -- |
---|
969 | -- Table structure for table `unidadecon_bien_venta` |
---|
970 | -- |
---|
971 | |
---|
972 | DROP TABLE IF EXISTS `unidadecon_bien_venta`; |
---|
973 | /*!40101 SET @saved_cs_client = @@character_set_client */; |
---|
974 | /*!40101 SET character_set_client = utf8 */; |
---|
975 | CREATE TABLE `unidadecon_bien_venta` ( |
---|
976 | `id` int(11) NOT NULL, |
---|
977 | `nombre` varchar(100) NOT NULL, |
---|
978 | `marca` varchar(100) NOT NULL, |
---|
979 | `codigo_aran_id` varchar(13) NOT NULL, |
---|
980 | `esp_tec` text NOT NULL, |
---|
981 | `unidad_medida_id` int(11) NOT NULL, |
---|
982 | `nacional` tinyint(1) NOT NULL, |
---|
983 | `peso` double NOT NULL, |
---|
984 | `ue_rif` varchar(10) NOT NULL |
---|
985 | ) ENGINE=InnoDB DEFAULT CHARSET=big5; |
---|
986 | /*!40101 SET character_set_client = @saved_cs_client */; |
---|
987 | /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; |
---|
988 | |
---|
989 | /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; |
---|
990 | /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; |
---|
991 | /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; |
---|
992 | /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; |
---|
993 | /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; |
---|
994 | /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; |
---|
995 | /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; |
---|
996 | |
---|
997 | -- Dump completed on 2013-08-05 17:12:41 |
---|