4pDtpbEN

1/*
2SQLyog Enterprise v12.09 (32 bit)
3MySQL - 5.0.51b-community-nt-log : Database - napta_excellence
4*********************************************************************
5*/
6
7
8/*!40101 SET NAMES utf8 */;
9
10/*!40101 SET SQL_MODE=''*/;
11
12/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
13/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
14/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
15/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
16/*Table structure for table `AccesoOpcion` */
17
18DROP TABLE IF EXISTS `AccesoOpcion`;
19
20CREATE TABLE `AccesoOpcion` (
21  `Acc_Log_ID` int(11) unsigned NOT NULL,
22  `Acc_Men_ID` smallint(2) unsigned NOT NULL,
23  `Acc_Opc_ID` smallint(2) unsigned NOT NULL,
24  `Acc_Hora` time NOT NULL,
25  PRIMARY KEY  (`Acc_Log_ID`,`Acc_Men_ID`,`Acc_Opc_ID`,`Acc_Hora`),
26  KEY `Table_64_FKIndex1` (`Acc_Log_ID`),
27  KEY `AccesoOpcion_FKIndex2` (`Acc_Opc_ID`,`Acc_Men_ID`),
28  CONSTRAINT `accesoopcion_ibfk_1` FOREIGN KEY (`Acc_Log_ID`) REFERENCES `login` (`Log_ID`) ON DELETE NO ACTION ON UPDATE NO ACTION,
29  CONSTRAINT `accesoopcion_ibfk_2` FOREIGN KEY (`Acc_Opc_ID`, `Acc_Men_ID`) REFERENCES `opcion` (`Opc_ID`, `Opc_Men_ID`) ON DELETE CASCADE ON UPDATE CASCADE
30) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
31
32/*Table structure for table `Aspirante` */
33
34DROP TABLE IF EXISTS `Aspirante`;
35
36CREATE TABLE `Aspirante` (
37  `Asp_Per_ID` int(4) default NULL,
38  `Asp_Lec_ID` smallint(2) default NULL,
39  `Asp_Usu_ID` smallint(2) default NULL,
40  `Asp_Fecha` date default NULL,
41  `Asp_Hora` time default NULL
42) ENGINE=InnoDB DEFAULT CHARSET=utf8;
43
44/*Table structure for table `Autoridad` */
45
46DROP TABLE IF EXISTS `Autoridad`;
47
48CREATE TABLE `Autoridad` (
49  `Aut_ID` int(10) unsigned NOT NULL auto_increment,
50  `Aut_Uni_ID` smallint(2) unsigned NOT NULL,
51  `Aut_Nombre` varchar(60) collate utf8_spanish_ci default NULL,
52  `Aut_Cargo` varchar(60) collate utf8_spanish_ci default NULL,
53  `Aut_Email` varchar(100) collate utf8_spanish_ci default NULL,
54  `Aut_Foto` varchar(20) collate utf8_spanish_ci default NULL,
55  `Aut_Orden` smallint(2) unsigned default NULL,
56  PRIMARY KEY  (`Aut_ID`),
57  KEY `Autoridades_FKIndex1` (`Aut_Uni_ID`),
58  CONSTRAINT `autoridad_ibfk_1` FOREIGN KEY (`Aut_Uni_ID`) REFERENCES `unidad` (`Uni_ID`)
59) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
60
61/*Table structure for table `Bloqueo` */
62
63DROP TABLE IF EXISTS `Bloqueo`;
64
65CREATE TABLE `Bloqueo` (
66  `Blo_Per_ID` int(10) unsigned NOT NULL,
67  `Blo_BTi_ID` smallint(2) unsigned NOT NULL,
68  `Blo_Motivo` varchar(150) collate utf8_spanish_ci NOT NULL,
69  `Blo_Fecha` date default NULL,
70  `Blo_Hora` time default NULL,
71  `Blo_Usu_ID` smallint(2) unsigned default NULL,
72  PRIMARY KEY  (`Blo_Per_ID`),
73  KEY `Blo_BTi_ID` (`Blo_BTi_ID`),
74  CONSTRAINT `bloqueo_ibfk_1` FOREIGN KEY (`Blo_Per_ID`) REFERENCES `persona` (`Per_ID`) ON DELETE NO ACTION ON UPDATE NO ACTION,
75  CONSTRAINT `bloqueo_ibfk_2` FOREIGN KEY (`Blo_BTi_ID`) REFERENCES `bloqueotipo` (`BTi_ID`)
76) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
77
78/*Table structure for table `BloqueoTipo` */
79
80DROP TABLE IF EXISTS `BloqueoTipo`;
81
82CREATE TABLE `BloqueoTipo` (
83  `BTi_ID` smallint(2) unsigned NOT NULL auto_increment,
84  `BTi_Nombre` varchar(50) collate utf8_spanish_ci default NULL,
85  PRIMARY KEY  (`BTi_ID`)
86) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
87
88/*Table structure for table `Caja` */
89
90DROP TABLE IF EXISTS `Caja`;
91
92CREATE TABLE `Caja` (
93  `Caja_ID` int(4) unsigned NOT NULL auto_increment,
94  `Caja_Apertura` datetime default NULL,
95  `Caja_Cierre` datetime default NULL,
96  `Caja_Rendida` tinyint(1) default NULL,
97  `Caja_Anulada` tinyint(1) default NULL,
98  `Caja_Observaciones` varchar(150) collate utf8_spanish_ci default NULL,
99  `Caja_Usu_ID` smallint(2) unsigned default NULL,
100  `Caja_Importe_Total` decimal(7,2) default NULL,
101  PRIMARY KEY  (`Caja_ID`)
102) ENGINE=InnoDB AUTO_INCREMENT=2444 DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
103
104/*Table structure for table `CajaCorriente` */
105
106DROP TABLE IF EXISTS `CajaCorriente`;
107
108CREATE TABLE `CajaCorriente` (
109  `CCC_ID` bigint(20) NOT NULL auto_increment,
110  `CCC_For_ID` smallint(2) unsigned NOT NULL,
111  `CCC_Caja_ID` int(4) unsigned NOT NULL,
112  `CCC_Concepto` varchar(150) collate utf8_spanish_ci default NULL,
113  `CCC_Debito` decimal(7,2) default '0.00',
114  `CCC_Credito` decimal(7,2) default '0.00',
115  `CCC_Saldo` decimal(10,2) default '0.00',
116  `CCC_Fecha` date default NULL,
117  `CCC_Hora` time default NULL,
118  `CCC_Detalle` varchar(90) collate utf8_spanish_ci default NULL,
119  `CCC_Referencia` varchar(30) collate utf8_spanish_ci default NULL,
120  `CCC_Usu_ID` smallint(2) unsigned default NULL,
121  `CCC_Ret_Dinero` tinyint(1) default '0',
122  PRIMARY KEY  (`CCC_ID`),
123  KEY `CCC_Caja_ID` (`CCC_Caja_ID`),
124  KEY `CCC_For_ID` (`CCC_For_ID`),
125  CONSTRAINT `cajacorriente_ibfk_1` FOREIGN KEY (`CCC_Caja_ID`) REFERENCES `caja` (`Caja_ID`),
126  CONSTRAINT `cajacorriente_ibfk_2` FOREIGN KEY (`CCC_For_ID`) REFERENCES `formapago` (`For_ID`) ON DELETE NO ACTION ON UPDATE NO ACTION
127) ENGINE=InnoDB AUTO_INCREMENT=57741 DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
128
129/*Table structure for table `CajaRendida` */
130
131DROP TABLE IF EXISTS `CajaRendida`;
132
133CREATE TABLE `CajaRendida` (
134  `CRe_Caja_ID` int(4) unsigned NOT NULL,
135  `CRe_Usu_ID` smallint(2) unsigned NOT NULL,
136  `CRe_For_ID` smallint(2) unsigned NOT NULL,
137  `CRe_Importe` decimal(7,2) default '0.00',
138  `CRe_Usu_Auditado` smallint(2) unsigned default NULL,
139  `CRe_Fecha_Rendida` datetime default NULL,
140  `CRe_Fecha_Auditada` datetime default NULL,
141  `CRe_Auditado` tinyint(1) default '0',
142  PRIMARY KEY  (`CRe_Caja_ID`,`CRe_Usu_ID`,`CRe_For_ID`),
143  KEY `CRe_For_ID` (`CRe_For_ID`),
144  KEY `CRe_Usu_ID` (`CRe_Usu_ID`),
145  CONSTRAINT `cajarendida_ibfk_1` FOREIGN KEY (`CRe_Caja_ID`) REFERENCES `caja` (`Caja_ID`),
146  CONSTRAINT `cajarendida_ibfk_2` FOREIGN KEY (`CRe_For_ID`) REFERENCES `formapago` (`For_ID`),
147  CONSTRAINT `cajarendida_ibfk_3` FOREIGN KEY (`CRe_Usu_ID`) REFERENCES `usuario` (`Usu_ID`)
148) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
149
150/*Table structure for table `Colegio_Ambito` */
151
152DROP TABLE IF EXISTS `Colegio_Ambito`;
153
154CREATE TABLE `Colegio_Ambito` (
155  `Amb_Lec_ID` smallint(2) unsigned NOT NULL,
156  `Amb_Dim_ID` smallint(2) unsigned NOT NULL,
157  `Amb_ID` smallint(2) unsigned NOT NULL,
158  `Amb_Nombre` varchar(100) default NULL,
159  `Amb_Detalle` text,
160  `Amb_Indicador` text,
161  `Amb_Orden` smallint(2) default NULL,
162  `Amb_Firma` tinyint(1) default '0',
163  PRIMARY KEY  (`Amb_Lec_ID`,`Amb_Dim_ID`,`Amb_ID`),
164  KEY `Amb_Dim_ID` (`Amb_Dim_ID`,`Amb_Lec_ID`)
165) ENGINE=InnoDB DEFAULT CHARSET=utf8;
166
167/*Table structure for table `Colegio_AmbitoInforme` */
168
169DROP TABLE IF EXISTS `Colegio_AmbitoInforme`;
170
171CREATE TABLE `Colegio_AmbitoInforme` (
172  `Inf_Lec_ID` smallint(2) unsigned NOT NULL,
173  `Inf_Dim_ID` smallint(2) unsigned NOT NULL,
174  `Inf_Amb_ID` smallint(2) unsigned NOT NULL,
175  `Inf_Leg_ID` int(4) NOT NULL,
176  `Inf_Semestre` tinyint(1) unsigned NOT NULL default '1',
177  `Inf_Doc_ID` smallint(2) unsigned NOT NULL,
178  `Inf_Detalle` text NOT NULL,
179  `Inf_Usu_ID` smallint(2) unsigned default NULL,
180  `Inf_Fecha` date default NULL,
181  `Inf_Hora` time default NULL,
182  `Inf_Aceptado` tinyint(1) default '0',
183  `Inf_Corregido` tinyint(1) default '0',
184  `Inf_FechaModif` date default NULL,
185  `Inf_HoraModif` time default NULL,
186  `Inf_UsuModif` smallint(2) unsigned default NULL,
187  PRIMARY KEY  (`Inf_Lec_ID`,`Inf_Dim_ID`,`Inf_Amb_ID`,`Inf_Leg_ID`,`Inf_Semestre`)
188) ENGINE=InnoDB DEFAULT CHARSET=latin1;
189
190/*Table structure for table `Colegio_Ausentismo` */
191
192DROP TABLE IF EXISTS `Colegio_Ausentismo`;
193
194CREATE TABLE `Colegio_Ausentismo` (
195  `Aus_Lec_ID` smallint(2) unsigned NOT NULL,
196  `Aus_Leg_ID` int(4) NOT NULL,
197  `Aus_FechaFalta` date NOT NULL,
198  `Aus_Ina_ID` smallint(2) unsigned NOT NULL,
199  `Aus_Justificada` tinyint(1) default '0',
200  `Aus_Detalle` varchar(100) default NULL,
201  `Aus_Certificado` tinyint(1) default '0',
202  `Aus_Deportiva` tinyint(1) default '0',
203  `Aus_Fecha` date default NULL,
204  `Aus_Hora` time default NULL,
205  `Aus_Usu_ID` smallint(2) unsigned default NULL,
206  PRIMARY KEY  (`Aus_Lec_ID`,`Aus_Leg_ID`,`Aus_FechaFalta`),
207  KEY `Colegio_Ausentismo_FKIndex3` (`Aus_Ina_ID`),
208  KEY `Colegio_Ausentismo_FKIndex2` (`Aus_Leg_ID`,`Aus_Lec_ID`)
209) ENGINE=InnoDB DEFAULT CHARSET=utf8;
210
211/*Table structure for table `Colegio_Clase` */
212
213DROP TABLE IF EXISTS `Colegio_Clase`;
214
215CREATE TABLE `Colegio_Clase` (
216  `Cla_ID` int(4) unsigned NOT NULL auto_increment,
217  `Cla_Sed_ID` smallint(2) unsigned NOT NULL,
218  `Cla_Lec_ID` smallint(2) unsigned NOT NULL,
219  `Cla_Mat_ID` smallint(2) unsigned NOT NULL,
220  `Cla_Doc_ID` smallint(2) unsigned NOT NULL,
221  `Cla_Niv_ID` smallint(2) unsigned NOT NULL,
222  `Cla_Cur_ID` smallint(2) unsigned NOT NULL,
223  `Cla_Div_ID` smallint(2) unsigned NOT NULL,
224  `Cla_Hs` int(10) unsigned default NULL,
225  `Cla_Fecha` date default NULL,
226  `Cla_Hora` time default NULL,
227  `Cla_Usu_ID` smallint(2) unsigned default NULL,
228  `Cla_TipoNota` tinyint(1) default NULL COMMENT '1: Decimales; 0: Enteras',
229  PRIMARY KEY  (`Cla_ID`),
230  KEY `Colegio_Clase_FKIndex1` (`Cla_Lec_ID`),
231  KEY `Colegio_Clase_FKIndex2` (`Cla_Mat_ID`),
232  KEY `Colegio_Clase_FKIndex3` (`Cla_Doc_ID`),
233  KEY `Colegio_Clase_FKIndex4` (`Cla_Cur_ID`),
234  KEY `Colegio_Clase_FKIndex5` (`Cla_Div_ID`),
235  KEY `Colegio_Clase_FKIndex6` (`Cla_Niv_ID`),
236  KEY `Colegio_Clase_FKIndex7` (`Cla_Sed_ID`),
237  CONSTRAINT `colegio_clase_ibfk_1` FOREIGN KEY (`Cla_Lec_ID`) REFERENCES `lectivo` (`Lec_ID`),
238  CONSTRAINT `colegio_clase_ibfk_2` FOREIGN KEY (`Cla_Mat_ID`) REFERENCES `colegio_materia` (`Mat_ID`),
239  CONSTRAINT `colegio_clase_ibfk_3` FOREIGN KEY (`Cla_Doc_ID`) REFERENCES `colegio_docente` (`Doc_ID`),
240  CONSTRAINT `colegio_clase_ibfk_4` FOREIGN KEY (`Cla_Cur_ID`) REFERENCES `curso` (`Cur_ID`),
241  CONSTRAINT `colegio_clase_ibfk_5` FOREIGN KEY (`Cla_Div_ID`) REFERENCES `division` (`Div_ID`),
242  CONSTRAINT `colegio_clase_ibfk_6` FOREIGN KEY (`Cla_Niv_ID`) REFERENCES `colegio_nivel` (`Niv_ID`),
243  CONSTRAINT `colegio_clase_ibfk_7` FOREIGN KEY (`Cla_Sed_ID`) REFERENCES `sede` (`Sed_ID`)
244) ENGINE=InnoDB AUTO_INCREMENT=1124 DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
245
246/*Table structure for table `Colegio_Dia` */
247
248DROP TABLE IF EXISTS `Colegio_Dia`;
249
250CREATE TABLE `Colegio_Dia` (
251  `Dia_ID` smallint(2) unsigned NOT NULL,
252  `Dia_Nombre` varchar(20) collate utf8_spanish_ci default NULL,
253  `Dia_Siglas` varchar(3) collate utf8_spanish_ci default NULL,
254  PRIMARY KEY  (`Dia_ID`)
255) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
256
257/*Table structure for table `Colegio_Dimension` */
258
259DROP TABLE IF EXISTS `Colegio_Dimension`;
260
261CREATE TABLE `Colegio_Dimension` (
262  `Dim_Lec_ID` smallint(2) unsigned NOT NULL,
263  `Dim_ID` smallint(2) unsigned NOT NULL,
264  `Dim_Nombre` varchar(100) default NULL,
265  `Dim_Detalle` text,
266  `Dim_Transversal` tinyint(1) default '0',
267  PRIMARY KEY  (`Dim_Lec_ID`,`Dim_ID`)
268) ENGINE=InnoDB DEFAULT CHARSET=utf8;
269
270/*Table structure for table `Colegio_Docente` */
271
272DROP TABLE IF EXISTS `Colegio_Docente`;
273
274CREATE TABLE `Colegio_Docente` (
275  `Doc_ID` smallint(2) unsigned NOT NULL auto_increment,
276  `Doc_Per_ID` int(10) unsigned NOT NULL,
277  `Doc_Legajo` varchar(20) collate utf8_spanish_ci default NULL,
278  `Doc_Alta` date default NULL,
279  `Doc_Activo` tinyint(1) default NULL,
280  `Doc_Fecha` date default NULL,
281  `Doc_Hora` time default NULL,
282  PRIMARY KEY  (`Doc_ID`),
283  KEY `Colegio_Docente_FKIndex1` (`Doc_Per_ID`),
284  CONSTRAINT `colegio_docente_ibfk_1` FOREIGN KEY (`Doc_Per_ID`) REFERENCES `persona` (`Per_ID`)
285) ENGINE=InnoDB AUTO_INCREMENT=77 DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
286
287/*Table structure for table `Colegio_DocenteCurso` */
288
289DROP TABLE IF EXISTS `Colegio_DocenteCurso`;
290
291CREATE TABLE `Colegio_DocenteCurso` (
292  `DCu_Lec_ID` smallint(2) unsigned NOT NULL,
293  `DCu_Doc_ID` smallint(2) unsigned NOT NULL,
294  `DCu_Cur_ID` smallint(2) unsigned NOT NULL,
295  `DCu_Div_ID` smallint(2) unsigned NOT NULL,
296  `DCu_Usu_ID` smallint(2) unsigned default NULL,
297  `DCu_Fecha` date default NULL,
298  `DCu_Hora` time default NULL,
299  `DCu_DocenteEspecial` tinyint(1) default NULL,
300  `DCu_Directora` tinyint(1) default NULL,
301  PRIMARY KEY  (`DCu_Lec_ID`,`DCu_Doc_ID`,`DCu_Cur_ID`,`DCu_Div_ID`),
302  KEY `DCu_Doc_ID` (`DCu_Doc_ID`),
303  KEY `DCu_Cur_ID` (`DCu_Cur_ID`),
304  KEY `DCu_Div_ID` (`DCu_Div_ID`),
305  CONSTRAINT `Colegio_DocenteCurso_ibfk_1` FOREIGN KEY (`DCu_Doc_ID`) REFERENCES `colegio_docente` (`Doc_ID`) ON DELETE NO ACTION ON UPDATE NO ACTION,
306  CONSTRAINT `Colegio_DocenteCurso_ibfk_2` FOREIGN KEY (`DCu_Cur_ID`) REFERENCES `curso` (`Cur_ID`) ON DELETE NO ACTION ON UPDATE NO ACTION,
307  CONSTRAINT `Colegio_DocenteCurso_ibfk_3` FOREIGN KEY (`DCu_Div_ID`) REFERENCES `division` (`Div_ID`) ON DELETE NO ACTION ON UPDATE NO ACTION,
308  CONSTRAINT `Colegio_DocenteCurso_ibfk_4` FOREIGN KEY (`DCu_Lec_ID`) REFERENCES `lectivo` (`Lec_ID`) ON DELETE NO ACTION ON UPDATE NO ACTION
309) ENGINE=InnoDB DEFAULT CHARSET=latin1;
310
311/*Table structure for table `Colegio_Evaluacion` */
312
313DROP TABLE IF EXISTS `Colegio_Evaluacion`;
314
315CREATE TABLE `Colegio_Evaluacion` (
316  `Eva_Leg_ID` int(4) NOT NULL,
317  `Eva_Lec_ID` smallint(2) unsigned NOT NULL,
318  `Eva_Cla_ID` int(4) unsigned NOT NULL,
319  `Eva_ID` smallint(2) unsigned NOT NULL,
320  `Eva_Cia_ID` smallint(2) unsigned NOT NULL,
321  `Eva_Not_ID` smallint(2) unsigned NOT NULL,
322  `Eva_FechaEval` date default NULL,
323  `Eva_Aud` tinyint(1) default '0',
324  `Eva_Usu_ID` smallint(2) unsigned default NULL,
325  `Eva_Fecha` date default NULL,
326  `Eva_Hora` time default NULL,
327  `Eva_NotaDecimal` decimal(5,2) default NULL,
328  `Eva_Bloq` tinyint(1) default '0',
329  PRIMARY KEY  (`Eva_Leg_ID`,`Eva_Lec_ID`,`Eva_Cla_ID`,`Eva_ID`),
330  KEY `Colegio_Evaluacion_FKIndex2` (`Eva_Leg_ID`,`Eva_Lec_ID`,`Eva_Cla_ID`),
331  KEY `Colegio_Evaluacion_FKIndex3` (`Eva_Not_ID`),
332  KEY `Colegio_Evaluacion_FKIndex4` (`Eva_Cia_ID`)
333) ENGINE=InnoDB DEFAULT CHARSET=utf8;
334
335/*Table structure for table `Colegio_Ficha` */
336
337DROP TABLE IF EXISTS `Colegio_Ficha`;
338
339CREATE TABLE `Colegio_Ficha` (
340  `Fic_Doc_ID` smallint(2) unsigned NOT NULL,
341  `Fic_CUIL` varchar(13) collate utf8_spanish_ci default NULL,
342  `Fic_Est_Civil` varchar(20) collate utf8_spanish_ci default NULL,
343  `Fic_Cant_Hijos` smallint(2) unsigned default NULL,
344  `Fic_Escolarizados` smallint(2) unsigned default NULL,
345  `Fic_Conyugue` varchar(60) collate utf8_spanish_ci default NULL,
346  `Fic_DNI` int(4) unsigned default NULL,
347  `Fic_Domicilio` varchar(100) collate utf8_spanish_ci default NULL,
348  `Fic_Trabajo` varchar(50) collate utf8_spanish_ci default NULL,
349  PRIMARY KEY  (`Fic_Doc_ID`),
350  KEY `Colegio_Ficha_FKIndex1` (`Fic_Doc_ID`),
351  CONSTRAINT `colegio_ficha_ibfk_1` FOREIGN KEY (`Fic_Doc_ID`) REFERENCES `colegio_docente` (`Doc_ID`) ON DELETE NO ACTION ON UPDATE NO ACTION
352) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
353
354/*Table structure for table `Colegio_Horario` */
355
356DROP TABLE IF EXISTS `Colegio_Horario`;
357
358CREATE TABLE `Colegio_Horario` (
359  `Hor_Cla_ID` int(4) unsigned NOT NULL,
360  `Hor_Dia_ID` smallint(2) unsigned NOT NULL,
361  `Hor_Inicio` time default NULL,
362  `Hor_Fin` time default NULL,
363  `Hor_Hs` int(10) unsigned NOT NULL,
364  PRIMARY KEY  (`Hor_Cla_ID`,`Hor_Dia_ID`),
365  KEY `Colegio_Horario_FKIndex1` (`Hor_Cla_ID`),
366  KEY `Colegio_Horario_FKIndex2` (`Hor_Dia_ID`),
367  CONSTRAINT `colegio_horario_ibfk_1` FOREIGN KEY (`Hor_Cla_ID`) REFERENCES `colegio_clase` (`Cla_ID`),
368  CONSTRAINT `colegio_horario_ibfk_2` FOREIGN KEY (`Hor_Dia_ID`) REFERENCES `colegio_dia` (`Dia_ID`)
369) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
370
371/*Table structure for table `Colegio_HorarioModulo` */
372
373DROP TABLE IF EXISTS `Colegio_HorarioModulo`;
374
375CREATE TABLE `Colegio_HorarioModulo` (
376  `Mod_Niv_ID` smallint(2) unsigned NOT NULL,
377  `Mod_Inicio` time NOT NULL,
378  `Mod_Fin` time default NULL,
379  `Mod_Nombre` varchar(30) collate utf8_spanish_ci default NULL,
380  PRIMARY KEY  (`Mod_Niv_ID`,`Mod_Inicio`),
381  KEY `Colegio_HorarioModulo_FKIndex1` (`Mod_Niv_ID`),
382  CONSTRAINT `colegio_horariomodulo_ibfk_1` FOREIGN KEY (`Mod_Niv_ID`) REFERENCES `colegio_nivel` (`Niv_ID`)
383) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
384
385/*Table structure for table `Colegio_InformeTrimestre` */
386
387DROP TABLE IF EXISTS `Colegio_InformeTrimestre`;
388
389CREATE TABLE `Colegio_InformeTrimestre` (
390  `ITr_Lec_ID` smallint(2) unsigned NOT NULL,
391  `ITr_Niv_ID` smallint(2) unsigned NOT NULL,
392  `ITr_Tri_ID` smallint(2) unsigned NOT NULL,
393  `ITr_Leg_ID` int(4) NOT NULL,
394  `ITr_Ori_ID` smallint(2) NOT NULL default '1',
395  `ITr_Promedio` decimal(5,3) default NULL,
396  `ITr_Fecha` date default NULL,
397  `ITr_Hora` time default NULL,
398  `ITr_Usu_ID` smallint(2) unsigned default NULL,
399  `ITr_Observaciones` text,
400  `ITr_FaltasJustificadas` smallint(2) unsigned default NULL,
401  `ITr_FaltasInjustificadas` smallint(2) unsigned default NULL,
402  `ITr_Tardanzas` smallint(2) unsigned default NULL,
403  PRIMARY KEY  (`ITr_Lec_ID`,`ITr_Niv_ID`,`ITr_Tri_ID`,`ITr_Leg_ID`,`ITr_Ori_ID`)
404) ENGINE=InnoDB DEFAULT CHARSET=utf8;
405
406/*Table structure for table `Colegio_Inscripcion` */
407
408DROP TABLE IF EXISTS `Colegio_Inscripcion`;
409
410CREATE TABLE `Colegio_Inscripcion` (
411  `Ins_Leg_ID` int(4) NOT NULL default '0',
412  `Ins_Lec_ID` smallint(2) unsigned NOT NULL default '0',
413  `Ins_Cur_ID` smallint(2) unsigned NOT NULL default '0',
414  `Ins_Niv_ID` smallint(2) unsigned NOT NULL default '0',
415  `Ins_Div_ID` smallint(2) unsigned NOT NULL default '0',
416  `Ins_Usu_ID` smallint(2) unsigned NOT NULL default '0',
417  `Ins_Provisoria` tinyint(1) default '1' COMMENT 'Significa que la inscripcion esta sujeta a control',
418  `Ins_Fecha` date NOT NULL default '0000-00-00',
419  `Ins_Hora` time default NULL,
420  PRIMARY KEY  (`Ins_Leg_ID`,`Ins_Lec_ID`,`Ins_Niv_ID`),
421  KEY `Colegio_Inscripcion_FKIndex1` (`Ins_Lec_ID`),
422  KEY `Colegio_Inscripcion_FKIndex3` (`Ins_Div_ID`),
423  KEY `Colegio_Inscripcion_FKIndex5` (`Ins_Usu_ID`),
424  KEY `Colegio_Inscripcion_FKIndex6` (`Ins_Leg_ID`),
425  KEY `Colegio_Inscripcion_FKIndex7` (`Ins_Niv_ID`),
426  KEY `Colegio_Inscripcion_FKIndex8` (`Ins_Cur_ID`)
427) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
428
429/*Table structure for table `Colegio_InscripcionClase` */
430
431DROP TABLE IF EXISTS `Colegio_InscripcionClase`;
432
433CREATE TABLE `Colegio_InscripcionClase` (
434  `IMa_Leg_ID` int(4) NOT NULL,
435  `IMa_Lec_ID` smallint(2) unsigned NOT NULL,
436  `IMa_Cla_ID` int(4) unsigned NOT NULL,
437  `IMa_Usu_ID` smallint(2) unsigned NOT NULL,
438  `IMa_Fecha` date NOT NULL,
439  `IMa_Hora` time default NULL,
440  PRIMARY KEY  (`IMa_Leg_ID`,`IMa_Lec_ID`,`IMa_Cla_ID`),
441  KEY `Colegio_InscripcionMateria_FKIndex1` (`IMa_Leg_ID`,`IMa_Lec_ID`),
442  KEY `Colegio_InscripcionMateria_FKIndex2` (`IMa_Usu_ID`),
443  KEY `Colegio_InscripcionMateria_FKIndex3` (`IMa_Cla_ID`)
444) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
445
446/*Table structure for table `Colegio_Instancia` */
447
448DROP TABLE IF EXISTS `Colegio_Instancia`;
449
450CREATE TABLE `Colegio_Instancia` (
451  `Cia_ID` smallint(2) unsigned NOT NULL auto_increment,
452  `Cia_Tri_ID` smallint(2) unsigned NOT NULL,
453  `Cia_Lec_ID` smallint(2) unsigned NOT NULL,
454  `Cia_Niv_ID` smallint(2) unsigned NOT NULL,
455  `Cia_Nombre` varchar(80) collate utf8_spanish_ci default NULL,
456  `Cia_Orden` smallint(2) unsigned default '0',
457  `Cia_Opcional` tinyint(1) default '0',
458  `Cia_Promedio` tinyint(1) default '1',
459  `Cia_Siglas` varchar(25) collate utf8_spanish_ci default NULL,
460  `Cia_PRT` tinyint(1) default '0',
461  PRIMARY KEY  (`Cia_ID`),
462  KEY `Colegio_Instancia_FKIndex1` (`Cia_Tri_ID`,`Cia_Niv_ID`,`Cia_Lec_ID`)
463) ENGINE=MyISAM AUTO_INCREMENT=190 DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
464
465/*Table structure for table `Colegio_JardinInforme` */
466
467DROP TABLE IF EXISTS `Colegio_JardinInforme`;
468
469CREATE TABLE `Colegio_JardinInforme` (
470  `JIn_Lec_ID` smallint(2) unsigned NOT NULL,
471  `JIn_Leg_ID` int(4) NOT NULL,
472  `JIn_Semestre` tinyint(1) unsigned NOT NULL,
473  `JIn_Observaciones` text collate utf8_spanish_ci,
474  `JIn_Asistencia` tinyint(1) unsigned default NULL,
475  `JIn_Fecha` date default NULL,
476  `JIn_Hora` time default NULL,
477  `JIn_Usu_ID` smallint(2) unsigned default NULL,
478  PRIMARY KEY  (`JIn_Lec_ID`,`JIn_Leg_ID`,`JIn_Semestre`)
479) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
480
481/*Table structure for table `Colegio_Materia` */
482
483DROP TABLE IF EXISTS `Colegio_Materia`;
484
485CREATE TABLE `Colegio_Materia` (
486  `Mat_ID` smallint(2) unsigned NOT NULL auto_increment,
487  `Mat_Nombre` varchar(100) collate utf8_spanish_ci default NULL,
488  `Mat_Siglas` varchar(20) collate utf8_spanish_ci default NULL,
489  `Mat_Curricular` tinyint(1) default '0',
490  `Mat_Convivencia` tinyint(1) default '0',
491  `Mat_Pedagogica` tinyint(1) default '0',
492  `Mat_Actitudinal` tinyint(1) default '0',
493  `Mat_Curso` tinyint(1) default '0',
494  `Mat_Ori_ID` smallint(2) default NULL,
495  `Mat_Orden` tinyint(1) default '0',
496  PRIMARY KEY  (`Mat_ID`)
497) ENGINE=InnoDB AUTO_INCREMENT=212 DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
498
499/*Table structure for table `Colegio_Mensaje` */
500
501DROP TABLE IF EXISTS `Colegio_Mensaje`;
502
503CREATE TABLE `Colegio_Mensaje` (
504  `Men_ID` int(11) unsigned NOT NULL auto_increment,
505  `Men_MTi_ID` smallint(2) unsigned NOT NULL,
506  `Men_Titulo` varchar(100) collate utf8_spanish_ci default NULL,
507  `Men_Cuerpo` text collate utf8_spanish_ci,
508  `Men_Fecha` date default NULL,
509  `Men_Hora` time default NULL,
510  PRIMARY KEY  (`Men_ID`),
511  KEY `Colegio_Mensaje_FKIndex1` (`Men_MTi_ID`),
512  CONSTRAINT `colegio_mensaje_ibfk_1` FOREIGN KEY (`Men_MTi_ID`) REFERENCES `colegio_mensajetipo` (`MTi_ID`)
513) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
514
515/*Table structure for table `Colegio_MensajeDestino` */
516
517DROP TABLE IF EXISTS `Colegio_MensajeDestino`;
518
519CREATE TABLE `Colegio_MensajeDestino` (
520  `Des_ID` int(11) unsigned NOT NULL auto_increment,
521  `Des_De_Usu_ID` smallint(2) unsigned NOT NULL,
522  `Des_Para_Usu_ID` smallint(2) unsigned NOT NULL,
523  `Des_Men_ID` int(11) unsigned NOT NULL,
524  `Des_Fecha` date default NULL,
525  `Des_Hora` time default NULL,
526  `Des_Leido` tinyint(1) default '0',
527  `Des_Rta_Men_ID` int(11) default NULL,
528  `Des_Borrado` tinyint(1) default '0',
529  PRIMARY KEY  (`Des_ID`),
530  KEY `Colegio_MensajeDestino_FKIndex1` (`Des_De_Usu_ID`),
531  KEY `Colegio_MensajeDestino_FKIndex2` (`Des_Para_Usu_ID`),
532  KEY `Colegio_MensajeDestino_FKIndex3` (`Des_Men_ID`),
533  CONSTRAINT `colegio_mensajedestino_ibfk_1` FOREIGN KEY (`Des_De_Usu_ID`) REFERENCES `usuario` (`Usu_ID`),
534  CONSTRAINT `colegio_mensajedestino_ibfk_2` FOREIGN KEY (`Des_Para_Usu_ID`) REFERENCES `usuario` (`Usu_ID`),
535  CONSTRAINT `colegio_mensajedestino_ibfk_3` FOREIGN KEY (`Des_Men_ID`) REFERENCES `colegio_mensaje` (`Men_ID`)
536) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
537
538/*Table structure for table `Colegio_MensajeTipo` */
539
540DROP TABLE IF EXISTS `Colegio_MensajeTipo`;
541
542CREATE TABLE `Colegio_MensajeTipo` (
543  `MTi_ID` smallint(2) unsigned NOT NULL auto_increment,
544  `MTi_Nombre` varchar(50) collate utf8_spanish_ci default NULL,
545  PRIMARY KEY  (`MTi_ID`)
546) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
547
548/*Table structure for table `Colegio_Nivel` */
549
550DROP TABLE IF EXISTS `Colegio_Nivel`;
551
552CREATE TABLE `Colegio_Nivel` (
553  `Niv_ID` smallint(2) unsigned NOT NULL auto_increment,
554  `Niv_Uni_ID` smallint(2) unsigned NOT NULL,
555  `Niv_Nombre` varchar(100) collate utf8_spanish_ci default NULL,
556  `Niv_Siglas` varchar(20) collate utf8_spanish_ci default NULL,
557  `Niv_Logo` varchar(10) collate utf8_spanish_ci default NULL,
558  `Niv_Nombre_Institucion` varchar(60) collate utf8_spanish_ci default NULL,
559  PRIMARY KEY  (`Niv_ID`),
560  KEY `Niv_Uni_ID` (`Niv_Uni_ID`),
561  CONSTRAINT `colegio_nivel_ibfk_1` FOREIGN KEY (`Niv_Uni_ID`) REFERENCES `unidad` (`Uni_ID`)
562) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
563
564/*Table structure for table `Colegio_Notas` */
565
566DROP TABLE IF EXISTS `Colegio_Notas`;
567
568CREATE TABLE `Colegio_Notas` (
569  `Not_ID` smallint(2) unsigned NOT NULL auto_increment,
570  `Not_NTi_ID` smallint(2) unsigned NOT NULL,
571  `Not_Nombre` varchar(20) collate utf8_spanish_ci default NULL,
572  `Not_Siglas` varchar(5) collate utf8_spanish_ci default NULL,
573  `Not_Numero` int(10) unsigned default NULL,
574  `Not_Pedag` varchar(5) collate utf8_spanish_ci default NULL,
575  PRIMARY KEY  (`Not_ID`),
576  KEY `Colegio_Notas_FKIndex1` (`Not_NTi_ID`),
577  CONSTRAINT `colegio_notas_ibfk_1` FOREIGN KEY (`Not_NTi_ID`) REFERENCES `colegio_notastipo` (`NTi_ID`)
578) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
579
580/*Table structure for table `Colegio_NotasTipo` */
581
582DROP TABLE IF EXISTS `Colegio_NotasTipo`;
583
584CREATE TABLE `Colegio_NotasTipo` (
585  `NTi_ID` smallint(2) unsigned NOT NULL auto_increment,
586  `NTi_Nombre` varchar(50) collate utf8_spanish_ci default NULL,
587  `NTi_Siglas` varchar(5) collate utf8_spanish_ci default NULL,
588  PRIMARY KEY  (`NTi_ID`)
589) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
590
591/*Table structure for table `Colegio_Orientacion` */
592
593DROP TABLE IF EXISTS `Colegio_Orientacion`;
594
595CREATE TABLE `Colegio_Orientacion` (
596  `Ori_ID` smallint(2) unsigned NOT NULL auto_increment,
597  `Ori_Niv_ID` smallint(2) unsigned NOT NULL,
598  `Ori_Nombre` varchar(160) default NULL,
599  `Ori_TituloLibreta` varchar(160) default NULL,
600  PRIMARY KEY  (`Ori_ID`),
601  KEY `Ori_Niv_ID` (`Ori_Niv_ID`),
602  CONSTRAINT `colegio_orientacion_ibfk_1` FOREIGN KEY (`Ori_Niv_ID`) REFERENCES `colegio_nivel` (`Niv_ID`) ON DELETE NO ACTION ON UPDATE NO ACTION
603) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
604
605/*Table structure for table `Colegio_Recupera` */
606
607DROP TABLE IF EXISTS `Colegio_Recupera`;
608
609CREATE TABLE `Colegio_Recupera` (
610  `CRe_Leg_ID` int(4) NOT NULL,
611  `CRe_Lec_ID` smallint(2) NOT NULL,
612  `CRe_CRT_ID` smallint(2) NOT NULL,
613  `CRe_Fecha` date default NULL,
614  `CRe_Hora` time default NULL,
615  `CRe_Usu_ID` smallint(2) default NULL,
616  `CRe_Nota` varchar(10) default NULL,
617  `CRe_Mat_ID` smallint(2) NOT NULL,
618  `CRe_FechaEval` date default NULL,
619  PRIMARY KEY  (`CRe_Leg_ID`,`CRe_Lec_ID`,`CRe_CRT_ID`,`CRe_Mat_ID`)
620) ENGINE=InnoDB DEFAULT CHARSET=latin1;
621
622/*Table structure for table `Colegio_RecuperaTipo` */
623
624DROP TABLE IF EXISTS `Colegio_RecuperaTipo`;
625
626CREATE TABLE `Colegio_RecuperaTipo` (
627  `CRT_ID` smallint(2) unsigned NOT NULL auto_increment,
628  `CRT_Nombre` varchar(50) default NULL,
629  PRIMARY KEY  (`CRT_ID`)
630) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;
631
632/*Table structure for table `Colegio_TipoInasistencia` */
633
634DROP TABLE IF EXISTS `Colegio_TipoInasistencia`;
635
636CREATE TABLE `Colegio_TipoInasistencia` (
637  `Ina_ID` smallint(2) unsigned NOT NULL auto_increment,
638  `Ina_Nombre` varchar(60) collate utf8_spanish_ci default NULL,
639  `Ina_Cant` decimal(3,2) default NULL,
640  `Ina_Siglas` varchar(6) collate utf8_spanish_ci default NULL,
641  `Ina_Primaria` tinyint(1) default NULL,
642  `Ina_Secundaria` tinyint(1) default NULL,
643  PRIMARY KEY  (`Ina_ID`)
644) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
645
646/*Table structure for table `Colegio_Trimestre` */
647
648DROP TABLE IF EXISTS `Colegio_Trimestre`;
649
650CREATE TABLE `Colegio_Trimestre` (
651  `Tri_ID` smallint(2) unsigned NOT NULL auto_increment,
652  `Tri_Lec_ID` smallint(2) unsigned NOT NULL,
653  `Tri_Niv_ID` smallint(2) unsigned NOT NULL,
654  `Tri_Nombre` varchar(60) collate utf8_spanish_ci default NULL,
655  `Tri_Desde` date default NULL,
656  `Tri_Hasta` date default NULL,
657  PRIMARY KEY  (`Tri_ID`,`Tri_Lec_ID`,`Tri_Niv_ID`),
658  KEY `Colegio_Trimestre_FKIndex1` (`Tri_Niv_ID`),
659  KEY `Colegio_Trimestre_FKIndex2` (`Tri_Lec_ID`),
660  CONSTRAINT `colegio_trimestre_ibfk_1` FOREIGN KEY (`Tri_Niv_ID`) REFERENCES `colegio_nivel` (`Niv_ID`),
661  CONSTRAINT `colegio_trimestre_ibfk_2` FOREIGN KEY (`Tri_Lec_ID`) REFERENCES `lectivo` (`Lec_ID`)
662) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
663
664/*Table structure for table `ConceptoFormaPago` */
665
666DROP TABLE IF EXISTS `ConceptoFormaPago`;
667
668CREATE TABLE `ConceptoFormaPago` (
669  `Con_ID` smallint(2) unsigned NOT NULL auto_increment,
670  `Con_Nombre` varchar(100) collate utf8_spanish_ci default NULL,
671  PRIMARY KEY  (`Con_ID`)
672) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
673
674/*Table structure for table `CondicionVenta` */
675
676DROP TABLE IF EXISTS `CondicionVenta`;
677
678CREATE TABLE `CondicionVenta` (
679  `CVe_ID` smallint(2) unsigned NOT NULL auto_increment,
680  `CVe_Nombre` varchar(100) collate utf8_spanish_ci default NULL,
681  `CVe_Siglas` varchar(15) collate utf8_spanish_ci default NULL,
682  PRIMARY KEY  (`CVe_ID`)
683) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
684
685/*Table structure for table `Configuracion` */
686
687DROP TABLE IF EXISTS `Configuracion`;
688
689CREATE TABLE `Configuracion` (
690  `Con_Uni_ID` smallint(2) unsigned NOT NULL,
691  `Con_Usu_ID` smallint(2) unsigned NOT NULL,
692  `Con_Lec_ID` smallint(2) unsigned NOT NULL,
693  `Con_Fecha` date NOT NULL,
694  `Con_Hora` time default NULL,
695  PRIMARY KEY  (`Con_Uni_ID`),
696  KEY `Configuracion_FKIndex1` (`Con_Uni_ID`),
697  KEY `Configuracion_FKIndex2` (`Con_Lec_ID`),
698  KEY `Configuracion_FKIndex3` (`Con_Usu_ID`),
699  CONSTRAINT `configuracion_ibfk_1` FOREIGN KEY (`Con_Uni_ID`) REFERENCES `unidad` (`Uni_ID`),
700  CONSTRAINT `configuracion_ibfk_2` FOREIGN KEY (`Con_Lec_ID`) REFERENCES `lectivo` (`Lec_ID`),
701  CONSTRAINT `configuracion_ibfk_3` FOREIGN KEY (`Con_Usu_ID`) REFERENCES `usuario` (`Usu_ID`)
702) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
703
704/*Table structure for table `Counting` */
705
706DROP TABLE IF EXISTS `Counting`;
707
708CREATE TABLE `Counting` (
709  `Cou_Cur_ID` smallint(2) NOT NULL,
710  `Cou_Lec_ID` smallint(2) NOT NULL,
711  `Cou_Total` smallint(2) default NULL,
712  PRIMARY KEY  (`Cou_Cur_ID`,`Cou_Lec_ID`)
713) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
714
715/*Table structure for table `CuentaCorriente` */
716
717DROP TABLE IF EXISTS `CuentaCorriente`;
718
719CREATE TABLE `CuentaCorriente` (
720  `CCo_ID` bigint(20) NOT NULL auto_increment,
721  `CCo_Per_ID` int(10) unsigned NOT NULL,
722  `CCo_Concepto` varchar(150) collate utf8_spanish_ci default NULL,
723  `CCo_Debito` decimal(7,2) default '0.00',
724  `CCo_Credito` decimal(7,2) default '0.00',
725  `CCo_Saldo` decimal(10,2) default '0.00',
726  `CCo_Fecha` date default NULL,
727  `CCo_Hora` time default NULL,
728  `CCo_Detalle` varchar(90) collate utf8_spanish_ci default NULL,
729  `CCo_Referencia` varchar(30) collate utf8_spanish_ci default NULL,
730  `CCo_Usu_ID` smallint(2) unsigned default NULL,
731  PRIMARY KEY  (`CCo_ID`),
732  KEY `CCo_Per_ID` (`CCo_Per_ID`),
733  CONSTRAINT `cuentacorriente_ibfk_1` FOREIGN KEY (`CCo_Per_ID`) REFERENCES `persona` (`Per_ID`)
734) ENGINE=InnoDB AUTO_INCREMENT=112711 DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
735
736/*Table structure for table `CuotaAlternativa` */
737
738DROP TABLE IF EXISTS `CuotaAlternativa`;
739
740CREATE TABLE `CuotaAlternativa` (
741  `Alt_ID` smallint(2) unsigned NOT NULL auto_increment,
742  `Alt_Nombre` varchar(100) collate utf8_spanish_ci default NULL,
743  PRIMARY KEY  (`Alt_ID`)
744) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
745
746/*Table structure for table `CuotaBeneficio` */
747
748DROP TABLE IF EXISTS `CuotaBeneficio`;
749
750CREATE TABLE `CuotaBeneficio` (
751  `Ben_ID` smallint(2) unsigned NOT NULL auto_increment,
752  `Ben_Nombre` varchar(100) collate utf8_spanish_ci default NULL,
753  `Ben_Siglas` varchar(15) collate utf8_spanish_ci default NULL,
754  PRIMARY KEY  (`Ben_ID`)
755) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
756
757/*Table structure for table `CuotaModelo` */
758
759DROP TABLE IF EXISTS `CuotaModelo`;
760
761CREATE TABLE `CuotaModelo` (
762  `CMo_Lec_ID` smallint(2) unsigned NOT NULL,
763  `CMo_Niv_ID` smallint(2) unsigned NOT NULL,
764  `CMo_CTi_ID` smallint(2) unsigned NOT NULL,
765  `CMo_Alt_ID` smallint(2) unsigned NOT NULL,
766  `CMo_Usu_ID` smallint(2) unsigned default NULL,
767  `CMo_Fecha` date NOT NULL,
768  `CMo_Hora` time default NULL,
769  `CMo_CantCuotas` smallint(2) unsigned default NULL,
770  `CMo_Importe` decimal(7,2) default NULL,
771  `CMo_1er_Recargo` decimal(7,2) default NULL,
772  `CMo_2do_Recargo` decimal(7,2) default NULL,
773  `CMo_1er_Vencimiento` date default NULL,
774  `CMo_2do_Vencimiento` date default NULL,
775  `CMo_3er_Vencimiento` date default NULL,
776  `CMo_Mes` smallint(2) unsigned default NULL,
777  `CMo_Anio` smallint(2) unsigned default NULL,
778  `CMo_Recargo_Mensual` decimal(7,2) default NULL,
779  PRIMARY KEY  (`CMo_Lec_ID`,`CMo_Niv_ID`,`CMo_CTi_ID`,`CMo_Alt_ID`),
780  KEY `CMo_CTi_ID` (`CMo_CTi_ID`),
781  KEY `CMo_Alt_ID` (`CMo_Alt_ID`),
782  KEY `CMo_Niv_ID` (`CMo_Niv_ID`),
783  CONSTRAINT `cuotamodelo_ibfk_1` FOREIGN KEY (`CMo_CTi_ID`) REFERENCES `cuotatipo` (`CTi_ID`),
784  CONSTRAINT `cuotamodelo_ibfk_2` FOREIGN KEY (`CMo_Alt_ID`) REFERENCES `cuotaalternativa` (`Alt_ID`),
785  CONSTRAINT `cuotamodelo_ibfk_3` FOREIGN KEY (`CMo_Niv_ID`) REFERENCES `colegio_nivel` (`Niv_ID`),
786  CONSTRAINT `cuotamodelo_ibfk_4` FOREIGN KEY (`CMo_Lec_ID`) REFERENCES `lectivo` (`Lec_ID`)
787) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
788
789/*Table structure for table `CuotaPago` */
790
791DROP TABLE IF EXISTS `CuotaPago`;
792
793CREATE TABLE `CuotaPago` (
794  `CuP_Lec_ID` smallint(2) unsigned NOT NULL,
795  `CuP_Per_ID` int(10) unsigned NOT NULL,
796  `CuP_Niv_ID` smallint(2) unsigned NOT NULL,
797  `CuP_CTi_ID` smallint(2) unsigned NOT NULL,
798  `CuP_Alt_ID` smallint(2) unsigned NOT NULL,
799  `CuP_Numero` smallint(2) unsigned NOT NULL,
800  `CuP_Orden` smallint(2) unsigned NOT NULL,
801  `CuP_Fac_ID` bigint(20) NOT NULL,
802  `CuP_FDe_Item` smallint(2) unsigned NOT NULL,
803  `CuP_CCo_ID` bigint(20) NOT NULL,
804  `CuP_Caja_ID` int(4) unsigned NOT NULL,
805  `CuP_Fecha` date NOT NULL,
806  `CuP_Hora` time default NULL,
807  `CuP_Usu_ID` smallint(2) unsigned default NULL,
808  `CuP_Importe` decimal(7,2) default NULL,
809  `CuP_Anulada` tinyint(1) default '0',
810  PRIMARY KEY  (`CuP_Lec_ID`,`CuP_Per_ID`,`CuP_Niv_ID`,`CuP_CTi_ID`,`CuP_Alt_ID`,`CuP_Numero`,`CuP_Orden`),
811  KEY `CuP_Caja_ID` (`CuP_Caja_ID`),
812  KEY `CuP_CCo_ID` (`CuP_CCo_ID`),
813  KEY `CuP_Fac_ID` (`CuP_Fac_ID`,`CuP_FDe_Item`),
814  CONSTRAINT `cuotapago_ibfk_1` FOREIGN KEY (`CuP_Lec_ID`, `CuP_Per_ID`, `CuP_Niv_ID`, `CuP_CTi_ID`, `CuP_Alt_ID`, `CuP_Numero`) REFERENCES `cuotapersona` (`Cuo_Lec_ID`, `Cuo_Per_ID`, `Cuo_Niv_ID`, `Cuo_CTi_ID`, `Cuo_Alt_ID`, `Cuo_Numero`),
815  CONSTRAINT `cuotapago_ibfk_2` FOREIGN KEY (`CuP_Caja_ID`) REFERENCES `caja` (`Caja_ID`),
816  CONSTRAINT `cuotapago_ibfk_3` FOREIGN KEY (`CuP_CCo_ID`) REFERENCES `cuentacorriente` (`CCo_ID`)
817) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
818
819/*Table structure for table `CuotaPagoDetalle` */
820
821DROP TABLE IF EXISTS `CuotaPagoDetalle`;
822
823CREATE TABLE `CuotaPagoDetalle` (
824  `CPD_Lec_ID` smallint(2) unsigned NOT NULL,
825  `CPD_Per_ID` int(10) unsigned NOT NULL,
826  `CPD_Niv_ID` smallint(2) unsigned NOT NULL,
827  `CPD_CTi_ID` smallint(2) unsigned NOT NULL,
828  `CPD_Alt_ID` smallint(2) unsigned NOT NULL,
829  `CPD_Numero` smallint(2) unsigned NOT NULL,
830  `CPD_Orden` smallint(2) unsigned NOT NULL,
831  `CPD_FDe_ID` smallint(2) unsigned NOT NULL,
832  `CPD_For_ID` smallint(2) unsigned NOT NULL,
833  `CPD_Fecha` date NOT NULL,
834  `CPD_Hora` time default NULL,
835  `CPD_Valor` varchar(100) collate utf8_spanish_ci default NULL,
836  PRIMARY KEY  (`CPD_Lec_ID`,`CPD_Per_ID`,`CPD_Niv_ID`,`CPD_CTi_ID`,`CPD_Alt_ID`,`CPD_Numero`,`CPD_Orden`,`CPD_FDe_ID`,`CPD_For_ID`),
837  KEY `CPD_FDe_ID` (`CPD_FDe_ID`,`CPD_For_ID`),
838  CONSTRAINT `cuotapagodetalle_ibfk_1` FOREIGN KEY (`CPD_Lec_ID`, `CPD_Per_ID`, `CPD_Niv_ID`, `CPD_CTi_ID`, `CPD_Alt_ID`, `CPD_Numero`, `CPD_Orden`) REFERENCES `cuotapago` (`CuP_Lec_ID`, `CuP_Per_ID`, `CuP_Niv_ID`, `CuP_CTi_ID`, `CuP_Alt_ID`, `CuP_Numero`, `CuP_Orden`) ON DELETE NO ACTION ON UPDATE NO ACTION,
839  CONSTRAINT `cuotapagodetalle_ibfk_2` FOREIGN KEY (`CPD_FDe_ID`, `CPD_For_ID`) REFERENCES `formapagodetalle` (`FDe_ID`, `FDe_For_ID`)
840) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
841
842/*Table structure for table `CuotaPersona` */
843
844DROP TABLE IF EXISTS `CuotaPersona`;
845
846CREATE TABLE `CuotaPersona` (
847  `Cuo_Lec_ID` smallint(2) unsigned NOT NULL,
848  `Cuo_Per_ID` int(10) unsigned NOT NULL,
849  `Cuo_Niv_ID` smallint(2) unsigned NOT NULL,
850  `Cuo_CTi_ID` smallint(2) unsigned NOT NULL,
851  `Cuo_Alt_ID` smallint(2) unsigned NOT NULL,
852  `Cuo_Numero` smallint(2) unsigned NOT NULL,
853  `Cuo_Ben_ID` smallint(2) unsigned NOT NULL,
854  `Cuo_Usu_ID` smallint(2) unsigned NOT NULL,
855  `Cuo_Fecha` date default NULL,
856  `Cuo_Hora` time default NULL,
857  `Cuo_Importe` decimal(7,2) default NULL,
858  `Cuo_1er_Recargo` decimal(7,2) default NULL,
859  `Cuo_2do_Recargo` decimal(7,2) default NULL,
860  `Cuo_1er_Vencimiento` date default NULL,
861  `Cuo_2do_Vencimiento` date default NULL,
862  `Cuo_3er_Vencimiento` date default NULL,
863  `Cuo_Mes` smallint(2) unsigned default NULL,
864  `Cuo_Anio` smallint(2) unsigned default NULL,
865  `Cuo_Pagado` tinyint(1) unsigned default NULL,
866  `Cuo_Cancelado` tinyint(1) unsigned default NULL,
867  `Cuo_Anulado` tinyint(1) unsigned default NULL,
868  `Cuo_Recargo_Mensual` decimal(7,2) default NULL,
869  `Cuo_ImporteOriginal` decimal(7,2) default NULL,
870  PRIMARY KEY  (`Cuo_Lec_ID`,`Cuo_Per_ID`,`Cuo_Niv_ID`,`Cuo_CTi_ID`,`Cuo_Alt_ID`,`Cuo_Numero`),
871  KEY `Cuo_CTi_ID` (`Cuo_CTi_ID`,`Cuo_Alt_ID`,`Cuo_Niv_ID`,`Cuo_Lec_ID`),
872  KEY `FK_CuotaPersona` (`Cuo_Per_ID`),
873  KEY `FK_CuotaPersona2` (`Cuo_Ben_ID`),
874  KEY `FK_CuotaPersona3` (`Cuo_Lec_ID`,`Cuo_Niv_ID`,`Cuo_CTi_ID`,`Cuo_Alt_ID`),
875  CONSTRAINT `FK_CuotaPersona` FOREIGN KEY (`Cuo_Per_ID`) REFERENCES `persona` (`Per_ID`),
876  CONSTRAINT `FK_CuotaPersona2` FOREIGN KEY (`Cuo_Ben_ID`) REFERENCES `cuotabeneficio` (`Ben_ID`)
877) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
878
879/*Table structure for table `CuotaPersonaCola` */
880
881DROP TABLE IF EXISTS `CuotaPersonaCola`;
882
883CREATE TABLE `CuotaPersonaCola` (
884  `CPT_Usu_ID` smallint(2) unsigned NOT NULL auto_increment,
885  `CPT_Lec_ID` smallint(2) unsigned NOT NULL,
886  `CPT_Per_ID` int(10) unsigned NOT NULL,
887  `CPT_Niv_ID` smallint(2) unsigned NOT NULL,
888  `CPT_CTi_ID` smallint(2) unsigned NOT NULL,
889  `CPT_Alt_ID` smallint(2) unsigned NOT NULL,
890  `CPT_Numero` smallint(2) unsigned NOT NULL,
891  `CPT_Fecha` date default NULL,
892  `CPT_Hora` time default NULL,
893  PRIMARY KEY  (`CPT_Usu_ID`,`CPT_Lec_ID`,`CPT_Per_ID`,`CPT_Niv_ID`,`CPT_CTi_ID`,`CPT_Alt_ID`,`CPT_Numero`),
894  KEY `CPT_Lec_ID` (`CPT_Lec_ID`,`CPT_Per_ID`,`CPT_Niv_ID`,`CPT_CTi_ID`,`CPT_Alt_ID`,`CPT_Numero`),
895  CONSTRAINT `cuotapersonacola_ibfk_1` FOREIGN KEY (`CPT_Lec_ID`, `CPT_Per_ID`, `CPT_Niv_ID`, `CPT_CTi_ID`, `CPT_Alt_ID`, `CPT_Numero`) REFERENCES `cuotapersona` (`Cuo_Lec_ID`, `Cuo_Per_ID`, `Cuo_Niv_ID`, `Cuo_CTi_ID`, `Cuo_Alt_ID`, `Cuo_Numero`) ON DELETE NO ACTION ON UPDATE NO ACTION
896) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
897
898/*Table structure for table `CuotaPorcentaje` */
899
900DROP TABLE IF EXISTS `CuotaPorcentaje`;
901
902CREATE TABLE `CuotaPorcentaje` (
903  `Por_CTi_ID` smallint(2) unsigned NOT NULL,
904  `Por_Ben_ID` smallint(2) unsigned NOT NULL,
905  `Por_Valor` smallint(2) unsigned default NULL,
906  PRIMARY KEY  (`Por_CTi_ID`,`Por_Ben_ID`),
907  KEY `Por_Ben_ID` (`Por_Ben_ID`),
908  CONSTRAINT `cuotaporcentaje_ibfk_1` FOREIGN KEY (`Por_CTi_ID`) REFERENCES `cuotatipo` (`CTi_ID`),
909  CONSTRAINT `cuotaporcentaje_ibfk_2` FOREIGN KEY (`Por_Ben_ID`) REFERENCES `cuotabeneficio` (`Ben_ID`)
910) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
911
912/*Table structure for table `CuotaTipo` */
913
914DROP TABLE IF EXISTS `CuotaTipo`;
915
916CREATE TABLE `CuotaTipo` (
917  `CTi_ID` smallint(2) unsigned NOT NULL auto_increment,
918  `CTi_Nombre` varchar(100) collate utf8_spanish_ci default NULL,
919  PRIMARY KEY  (`CTi_ID`)
920) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
921
922/*Table structure for table `Curso` */
923
924DROP TABLE IF EXISTS `Curso`;
925
926CREATE TABLE `Curso` (
927  `Cur_ID` smallint(2) unsigned NOT NULL auto_increment,
928  `Cur_Niv_ID` smallint(2) unsigned NOT NULL,
929  `Cur_Nombre` varchar(30) collate utf8_spanish_ci default NULL,
930  `Cur_Siglas` varchar(10) collate utf8_spanish_ci default NULL,
931  `Cur_Colegio` tinyint(1) default '0',
932  `Cur_Grado` tinyint(1) default '0',
933  `Cur_Posgrado` tinyint(1) default '0',
934  `Cur_Turno` varchar(20) collate utf8_spanish_ci default NULL,
935  `Cur_Curso` smallint(2) default NULL,
936  PRIMARY KEY  (`Cur_ID`),
937  KEY `Curso_FKIndex1` (`Cur_Niv_ID`),
938  CONSTRAINT `curso_ibfk_1` FOREIGN KEY (`Cur_Niv_ID`) REFERENCES `colegio_nivel` (`Niv_ID`)
939) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
940
941/*Table structure for table `DatosAlumno` */
942
943DROP TABLE IF EXISTS `DatosAlumno`;
944
945CREATE TABLE `DatosAlumno` (
946  `Dat_DNI` int(10) unsigned NOT NULL auto_increment,
947  `Dat_Persona` varchar(180) collate utf8_spanish_ci default NULL,
948  `Dat_Sexo` char(1) collate utf8_spanish_ci default NULL,
949  `Dat_Foto` varchar(100) collate utf8_spanish_ci default NULL,
950  `Dat_FechaNac` date default NULL,
951  `Dat_LocalidadNac` varchar(150) collate utf8_spanish_ci default NULL,
952  `Dat_Domicilio` varchar(150) collate utf8_spanish_ci default NULL,
953  `Dat_LocalidadDom` varchar(150) collate utf8_spanish_ci default NULL,
954  `Dat_CP` varchar(20) collate utf8_spanish_ci default NULL,
955  `Dat_Telefono` varchar(30) collate utf8_spanish_ci default NULL,
956  `Dat_Celular` varchar(30) collate utf8_spanish_ci default NULL,
957  `Dat_Observaciones` varchar(100) collate utf8_spanish_ci default NULL,
958  `Dat_Legajo` varchar(30) collate utf8_spanish_ci default NULL,
959  PRIMARY KEY  (`Dat_DNI`)
960) ENGINE=InnoDB AUTO_INCREMENT=4294967296 DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
961
962/*Table structure for table `DatosCuota` */
963
964DROP TABLE IF EXISTS `DatosCuota`;
965
966CREATE TABLE `DatosCuota` (
967  `Cuo_DNI` int(10) unsigned NOT NULL auto_increment,
968  `Cuo_Nivel` smallint(2) unsigned NOT NULL,
969  `Cuo_Detalle` varchar(180) collate utf8_spanish_ci NOT NULL,
970  `Cuo_Beneficio` varchar(50) collate utf8_spanish_ci default NULL,
971  `Cuo_Periodo` char(7) collate utf8_spanish_ci default NULL,
972  `Cuo_Vencimiento` date default NULL,
973  `Cuo_Importe` decimal(7,2) default NULL,
974  `Cuo_Estado` char(5) collate utf8_spanish_ci default NULL,
975  PRIMARY KEY  (`Cuo_DNI`,`Cuo_Nivel`,`Cuo_Detalle`)
976) ENGINE=InnoDB AUTO_INCREMENT=789456124 DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
977
978/*Table structure for table `DatosInscripcion` */
979
980DROP TABLE IF EXISTS `DatosInscripcion`;
981
982CREATE TABLE `DatosInscripcion` (
983  `Ins_DNI` int(10) unsigned NOT NULL auto_increment,
984  `Ins_Lectivo` varchar(10) collate utf8_spanish_ci default NULL,
985  `Ins_Nivel` varchar(50) collate utf8_spanish_ci default NULL,
986  `Ins_Curso` varchar(50) collate utf8_spanish_ci default NULL,
987  `Ins_Division` varchar(50) collate utf8_spanish_ci default NULL,
988  PRIMARY KEY  (`Ins_DNI`)
989) ENGINE=InnoDB AUTO_INCREMENT=789456124 DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
990
991/*Table structure for table `DatosPadre` */
992
993DROP TABLE IF EXISTS `DatosPadre`;
994
995CREATE TABLE `DatosPadre` (
996  `Pad_DNI` int(10) unsigned NOT NULL auto_increment,
997  `Hij_DNI` int(10) unsigned NOT NULL,
998  `Rol_Padre` varchar(20) collate utf8_spanish_ci default NULL,
999  `Rol_Hijo` varchar(20) collate utf8_spanish_ci default NULL,
1000  `Pad_Persona` varchar(180) collate utf8_spanish_ci default NULL,
1001  `Pad_Sexo` char(1) collate utf8_spanish_ci default NULL,
1002  `Pad_TipoDNI` varchar(3) collate utf8_spanish_ci default NULL,
1003  PRIMARY KEY  (`Pad_DNI`,`Hij_DNI`)
1004) ENGINE=InnoDB AUTO_INCREMENT=936486324 DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
1005
1006/*Table structure for table `DatosPercibidoDiario` */
1007
1008DROP TABLE IF EXISTS `DatosPercibidoDiario`;
1009
1010CREATE TABLE `DatosPercibidoDiario` (
1011  `PDi_Fecha` date NOT NULL,
1012  `PDi_Importe` decimal(7,2) default NULL,
1013  PRIMARY KEY  (`PDi_Fecha`)
1014) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
1015
1016/*Table structure for table `Division` */
1017
1018DROP TABLE IF EXISTS `Division`;
1019
1020CREATE TABLE `Division` (
1021  `Div_ID` smallint(2) unsigned NOT NULL auto_increment,
1022  `Div_Nombre` varchar(10) collate utf8_spanish_ci default NULL,
1023  `Div_Siglas` varchar(3) collate utf8_spanish_ci default NULL,
1024  PRIMARY KEY  (`Div_ID`)
1025) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
1026
1027/*Table structure for table `Egreso_Cuenta` */
1028
1029DROP TABLE IF EXISTS `Egreso_Cuenta`;
1030
1031CREATE TABLE `Egreso_Cuenta` (
1032  `Cue_ID` smallint(2) unsigned NOT NULL auto_increment,
1033  `Cue_Nombre` varchar(100) collate utf8_spanish_ci default NULL,
1034  `Cue_Usu_ID` smallint(2) unsigned default NULL,
1035  `Cue_Fecha` date default NULL,
1036  `Cue_Hora` time default NULL,
1037  PRIMARY KEY  (`Cue_ID`)
1038) ENGINE=InnoDB AUTO_INCREMENT=49 DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
1039
1040/*Table structure for table `Egreso_Recibo` */
1041
1042DROP TABLE IF EXISTS `Egreso_Recibo`;
1043
1044CREATE TABLE `Egreso_Recibo` (
1045  `Rec_ID` int(11) unsigned NOT NULL auto_increment,
1046  `Rec_Cue_ID` smallint(2) unsigned NOT NULL,
1047  `Rec_FechaCompra` date default NULL,
1048  `Rec_Usu_ID` smallint(2) unsigned default NULL,
1049  `Rec_Fecha` date default NULL,
1050  `Rec_Hora` time default NULL,
1051  `Rec_Importe` decimal(9,2) default NULL,
1052  `Rec_ETi_ID` smallint(2) default '1',
1053  PRIMARY KEY  (`Rec_ID`),
1054  KEY `Rec_Cue_ID` (`Rec_Cue_ID`),
1055  CONSTRAINT `egreso_recibo_ibfk_1` FOREIGN KEY (`Rec_Cue_ID`) REFERENCES `egreso_cuenta` (`Cue_ID`) ON DELETE NO ACTION ON UPDATE NO ACTION
1056) ENGINE=InnoDB AUTO_INCREMENT=1057 DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
1057
1058/*Table structure for table `Egreso_Recibo_NoBorrar` */
1059
1060DROP TABLE IF EXISTS `Egreso_Recibo_NoBorrar`;
1061
1062CREATE TABLE `Egreso_Recibo_NoBorrar` (
1063  `Rec_ID` int(11) unsigned NOT NULL auto_increment,
1064  `Rec_Cue_ID` smallint(2) unsigned NOT NULL,
1065  `Rec_FechaCompra` date default NULL,
1066  `Rec_Usu_ID` smallint(2) unsigned default NULL,
1067  `Rec_Fecha` date default NULL,
1068  `Rec_Hora` time default NULL,
1069  `Rec_Importe` decimal(9,2) default NULL,
1070  `Rec_ETi_ID` smallint(2) default '1',
1071  PRIMARY KEY  (`Rec_ID`),
1072  KEY `Rec_Cue_ID` (`Rec_Cue_ID`)
1073) ENGINE=InnoDB AUTO_INCREMENT=689 DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
1074
1075/*Table structure for table `Egreso_Tipo` */
1076
1077DROP TABLE IF EXISTS `Egreso_Tipo`;
1078
1079CREATE TABLE `Egreso_Tipo` (
1080  `ETi_ID` smallint(2) unsigned NOT NULL auto_increment,
1081  `ETi_Nombre` varchar(70) collate utf8_spanish_ci default NULL,
1082  PRIMARY KEY  (`ETi_ID`)
1083) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
1084
1085/*Table structure for table `Email` */
1086
1087DROP TABLE IF EXISTS `Email`;
1088
1089CREATE TABLE `Email` (
1090  `Ema_ID` int(10) unsigned NOT NULL auto_increment,
1091  `Ema_Usu_ID` smallint(2) unsigned NOT NULL,
1092  `Ema_Asunto` varchar(60) collate utf8_spanish_ci default NULL,
1093  `Ema_Cuerpo` text collate utf8_spanish_ci,
1094  `Ema_Fecha` date default NULL,
1095  `Ema_Hora` time default NULL,
1096  `Ema_Enviado` tinyint(1) default NULL,
1097  PRIMARY KEY  (`Ema_ID`),
1098  KEY `Email_FKIndex1` (`Ema_Usu_ID`),
1099  CONSTRAINT `email_ibfk_1` FOREIGN KEY (`Ema_Usu_ID`) REFERENCES `usuario` (`Usu_ID`) ON DELETE NO ACTION ON UPDATE NO ACTION
1100) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
1101
1102/*Table structure for table `Email_Destino` */
1103
1104DROP TABLE IF EXISTS `Email_Destino`;
1105
1106CREATE TABLE `Email_Destino` (
1107  `EDe_Usu_ID` smallint(2) unsigned NOT NULL,
1108  `EDe_Ema_ID` int(10) unsigned NOT NULL,
1109  `EDe_Fecha` date default NULL,
1110  `EDe_Hora` time default NULL,
1111  `EDe_Leido` tinyint(1) default NULL,
1112  `EDe_Borrado` tinyint(1) default NULL,
1113  PRIMARY KEY  (`EDe_Usu_ID`,`EDe_Ema_ID`),
1114  KEY `Email_has_Usuario_FKIndex1` (`EDe_Ema_ID`),
1115  KEY `Email_has_Usuario_FKIndex2` (`EDe_Usu_ID`),
1116  CONSTRAINT `email_destino_ibfk_1` FOREIGN KEY (`EDe_Ema_ID`) REFERENCES `email` (`Ema_ID`) ON DELETE NO ACTION ON UPDATE NO ACTION,
1117  CONSTRAINT `email_destino_ibfk_2` FOREIGN KEY (`EDe_Usu_ID`) REFERENCES `usuario` (`Usu_ID`) ON DELETE NO ACTION ON UPDATE NO ACTION
1118) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
1119
1120/*Table structure for table `Entrevista` */
1121
1122DROP TABLE IF EXISTS `Entrevista`;
1123
1124CREATE TABLE `Entrevista` (
1125  `Ent_per_ID` int(10) unsigned NOT NULL auto_increment,
1126  `Ent_Sic_ID` int(10) unsigned NOT NULL,
1127  `Ent_Turno` varchar(20) collate utf8_spanish_ci default NULL,
1128  `Ent_Fecha` date default NULL,
1129  `Ent_Hora` time default NULL,
1130  `Ent_Asistio` tinyint(1) default NULL,
1131  `Ent_Estado` tinyint(1) default NULL,
1132  PRIMARY KEY  (`Ent_per_ID`),
1133  KEY `Ent_Sic_ID` (`Ent_Sic_ID`)
1134) ENGINE=MyISAM AUTO_INCREMENT=2038 DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
1135
1136/*Table structure for table `Factura` */
1137
1138DROP TABLE IF EXISTS `Factura`;
1139
1140CREATE TABLE `Factura` (
1141  `Fac_ID` bigint(20) NOT NULL auto_increment,
1142  `Fac_FTi_ID` smallint(2) unsigned NOT NULL,
1143  `Fac_Iva_ID` smallint(2) unsigned NOT NULL,
1144  `Fac_CVe_ID` smallint(2) unsigned NOT NULL,
1145  `Fac_Fecha` date default NULL,
1146  `Fac_Hora` time default NULL,
1147  `Fac_Usu_ID` smallint(2) unsigned default NULL,
1148  `Fac_CUIT` varchar(20) collate utf8_spanish_ci default NULL,
1149  `Fac_Sucursal` smallint(4) unsigned zerofill default '0001',
1150  `Fac_Numero` int(8) unsigned zerofill default NULL,
1151  `Fac_PersonaNombre` varchar(100) collate utf8_spanish_ci default NULL,
1152  `Fac_PersonaDomicilio` varchar(100) collate utf8_spanish_ci default NULL,
1153  `Fac_ImporteTotal` decimal(7,2) default NULL,
1154  `Fac_Pagada` tinyint(1) default NULL,
1155  `Fac_Anulada` tinyint(1) default '0',
1156  PRIMARY KEY  (`Fac_ID`),
1157  KEY `Fac_FTi_ID` (`Fac_FTi_ID`),
1158  KEY `Fac_Iva_ID` (`Fac_Iva_ID`),
1159  KEY `Fac_CVe_ID` (`Fac_CVe_ID`),
1160  CONSTRAINT `factura_ibfk_1` FOREIGN KEY (`Fac_FTi_ID`) REFERENCES `facturatipo` (`FTi_ID`),
1161  CONSTRAINT `factura_ibfk_2` FOREIGN KEY (`Fac_Iva_ID`) REFERENCES `ivacliente` (`Iva_ID`),
1162  CONSTRAINT `factura_ibfk_3` FOREIGN KEY (`Fac_CVe_ID`) REFERENCES `condicionventa` (`CVe_ID`)
1163) ENGINE=InnoDB AUTO_INCREMENT=36042 DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
1164
1165/*Table structure for table `FacturaDetalle` */
1166
1167DROP TABLE IF EXISTS `FacturaDetalle`;
1168
1169CREATE TABLE `FacturaDetalle` (
1170  `FDe_Fac_ID` bigint(20) NOT NULL,
1171  `FDe_Item` smallint(2) unsigned NOT NULL,
1172  `FDe_Cantidad` smallint(2) unsigned NOT NULL,
1173  `FDe_Detalle` varchar(100) collate utf8_spanish_ci default NULL,
1174  `FDe_ImporteUnitario` decimal(7,2) default NULL,
1175  `FDe_Importe` decimal(7,2) default NULL,
1176  PRIMARY KEY  (`FDe_Fac_ID`,`FDe_Item`),
1177  CONSTRAINT `facturadetalle_ibfk_1` FOREIGN KEY (`FDe_Fac_ID`) REFERENCES `factura` (`Fac_ID`)
1178) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
1179
1180/*Table structure for table `FacturaTipo` */
1181
1182DROP TABLE IF EXISTS `FacturaTipo`;
1183
1184CREATE TABLE `FacturaTipo` (
1185  `FTi_ID` smallint(2) unsigned NOT NULL auto_increment,
1186  `FTi_Nombre` varchar(100) collate utf8_spanish_ci default NULL,
1187  `FTi_Siglas` varchar(15) collate utf8_spanish_ci default NULL,
1188  PRIMARY KEY  (`FTi_ID`)
1189) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
1190
1191/*Table structure for table `Familia` */
1192
1193DROP TABLE IF EXISTS `Familia`;
1194
1195CREATE TABLE `Familia` (
1196  `Fam_Per_ID` int(10) unsigned NOT NULL,
1197  `Fam_Vin_Per_ID` int(10) unsigned NOT NULL,
1198  `Fam_Usu_ID` smallint(2) unsigned NOT NULL,
1199  `Fam_FTi_ID` smallint(2) unsigned NOT NULL,
1200  `Fam_Fecha` date default NULL,
1201  `Fam_Hora` time default NULL,
1202  PRIMARY KEY  (`Fam_Per_ID`,`Fam_Vin_Per_ID`),
1203  KEY `Familia_FKIndex1` (`Fam_Per_ID`),
1204  KEY `Familia_FKIndex2` (`Fam_Vin_Per_ID`),
1205  KEY `Familia_FKIndex3` (`Fam_FTi_ID`),
1206  KEY `Familia_FKIndex4` (`Fam_Usu_ID`),
1207  CONSTRAINT `familia_ibfk_1` FOREIGN KEY (`Fam_Per_ID`) REFERENCES `persona` (`Per_ID`),
1208  CONSTRAINT `familia_ibfk_2` FOREIGN KEY (`Fam_Vin_Per_ID`) REFERENCES `persona` (`Per_ID`),
1209  CONSTRAINT `familia_ibfk_3` FOREIGN KEY (`Fam_FTi_ID`) REFERENCES `familiatipo` (`FTi_ID`),
1210  CONSTRAINT `familia_ibfk_4` FOREIGN KEY (`Fam_Usu_ID`) REFERENCES `usuario` (`Usu_ID`)
1211) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
1212
1213/*Table structure for table `FamiliaTipo` */
1214
1215DROP TABLE IF EXISTS `FamiliaTipo`;
1216
1217CREATE TABLE `FamiliaTipo` (
1218  `FTi_ID` smallint(2) unsigned NOT NULL auto_increment,
1219  `FTi_Nombre` varchar(50) collate utf8_spanish_ci default NULL,
1220  `FTi_Siglas` varchar(10) collate utf8_spanish_ci default NULL,
1221  `FTi_Relaciona` smallint(2) unsigned default NULL,
1222  `FTi_M` varchar(50) collate utf8_spanish_ci default NULL,
1223  `FTi_F` varchar(50) collate utf8_spanish_ci default NULL,
1224  PRIMARY KEY  (`FTi_ID`)
1225) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
1226
1227/*Table structure for table `Feriado` */
1228
1229DROP TABLE IF EXISTS `Feriado`;
1230
1231CREATE TABLE `Feriado` (
1232  `Fer_Lec_ID` smallint(2) unsigned NOT NULL,
1233  `Fer_Fecha` date NOT NULL,
1234  `Fer_Nombre` varchar(20) collate utf8_spanish_ci default NULL,
1235  `Fer_Motivo` varchar(80) collate utf8_spanish_ci default NULL,
1236  PRIMARY KEY  (`Fer_Lec_ID`,`Fer_Fecha`),
1237  KEY `Colegio_Feriado_FKIndex1` (`Fer_Lec_ID`),
1238  CONSTRAINT `feriado_ibfk_1` FOREIGN KEY (`Fer_Lec_ID`) REFERENCES `lectivo` (`Lec_ID`)
1239) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
1240
1241/*Table structure for table `FichaAlumno` */
1242
1243DROP TABLE IF EXISTS `FichaAlumno`;
1244
1245CREATE TABLE `FichaAlumno` (
1246  `Fic_ID` int(10) unsigned NOT NULL auto_increment,
1247  `Fic_Per_ID` int(10) unsigned NOT NULL,
1248  `Fic_GrupoSanguineo` varchar(25) collate utf8_spanish_ci default NULL,
1249  `Fic_FactorRH` varchar(25) collate utf8_spanish_ci default NULL,
1250  `Fic_Peso` int(4) unsigned default NULL,
1251  `Fic_Talla` int(4) unsigned default NULL,
1252  `Fic_Observaciones` varchar(50) collate utf8_spanish_ci default NULL,
1253  PRIMARY KEY  (`Fic_ID`,`Fic_Per_ID`)
1254) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
1255
1256/*Table structure for table `FormaPago` */
1257
1258DROP TABLE IF EXISTS `FormaPago`;
1259
1260CREATE TABLE `FormaPago` (
1261  `For_ID` smallint(2) unsigned NOT NULL auto_increment,
1262  `For_Nombre` varchar(60) collate utf8_spanish_ci default NULL,
1263  `For_Siglas` varchar(10) collate utf8_spanish_ci default NULL,
1264  PRIMARY KEY  (`For_ID`)
1265) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
1266
1267/*Table structure for table `FormaPagoDetalle` */
1268
1269DROP TABLE IF EXISTS `FormaPagoDetalle`;
1270
1271CREATE TABLE `FormaPagoDetalle` (
1272  `FDe_ID` smallint(2) unsigned NOT NULL,
1273  `FDe_For_ID` smallint(2) unsigned NOT NULL,
1274  `FDe_Nombre` varchar(30) collate utf8_spanish_ci default NULL,
1275  `FDe_Cheque` tinyint(1) default '0',
1276  `FDe_DatoFecha` tinyint(1) default '0',
1277  PRIMARY KEY  (`FDe_ID`,`FDe_For_ID`),
1278  KEY `FormaPagoDetalle_FKIndex1` (`FDe_For_ID`),
1279  CONSTRAINT `formapagodetalle_ibfk_1` FOREIGN KEY (`FDe_For_ID`) REFERENCES `formapago` (`For_ID`)
1280) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
1281
1282/*Table structure for table `IvaCliente` */
1283
1284DROP TABLE IF EXISTS `IvaCliente`;
1285
1286CREATE TABLE `IvaCliente` (
1287  `Iva_ID` smallint(2) unsigned NOT NULL auto_increment,
1288  `Iva_Nombre` varchar(100) collate utf8_spanish_ci default NULL,
1289  `Iva_Siglas` varchar(15) collate utf8_spanish_ci default NULL,
1290  PRIMARY KEY  (`Iva_ID`)
1291) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
1292
1293/*Table structure for table `Lectivo` */
1294
1295DROP TABLE IF EXISTS `Lectivo`;
1296
1297CREATE TABLE `Lectivo` (
1298  `Lec_ID` smallint(2) unsigned NOT NULL auto_increment,
1299  `Lec_Nombre` varchar(4) collate utf8_spanish_ci default NULL,
1300  `Lec_Desde` date default NULL,
1301  `Lec_Hasta` date default NULL,
1302  `Lec_Actual` tinyint(1) default '0',
1303  PRIMARY KEY  (`Lec_ID`)
1304) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
1305
1306/*Table structure for table `Legajo` */
1307
1308DROP TABLE IF EXISTS `Legajo`;
1309
1310CREATE TABLE `Legajo` (
1311  `Leg_ID` int(4) NOT NULL auto_increment,
1312  `Leg_Usu_ID` smallint(2) unsigned NOT NULL,
1313  `Leg_Sed_ID` smallint(2) unsigned NOT NULL,
1314  `Leg_Per_ID` int(10) unsigned NOT NULL,
1315  `Leg_Numero` varchar(10) collate utf8_spanish_ci default NULL,
1316  `Leg_Alta_Fecha` date default NULL,
1317  `Leg_Baja` tinyint(1) default '0',
1318  `Leg_Baja_Fecha` date default NULL,
1319  `Leg_Baja_Motivo` varchar(50) collate utf8_spanish_ci default NULL,
1320  `Leg_Colegio` tinyint(1) default '1',
1321  `Leg_Fecha` date default NULL,
1322  `Leg_Hora` time default NULL,
1323  PRIMARY KEY  (`Leg_ID`),
1324  KEY `Legajo_FKIndex1` (`Leg_Per_ID`),
1325  KEY `Legajo_FKIndex2` (`Leg_Sed_ID`),
1326  KEY `Legajo_FKIndex3` (`Leg_Usu_ID`),
1327  CONSTRAINT `legajo_ibfk_1` FOREIGN KEY (`Leg_Per_ID`) REFERENCES `persona` (`Per_ID`) ON DELETE NO ACTION ON UPDATE NO ACTION,
1328  CONSTRAINT `legajo_ibfk_2` FOREIGN KEY (`Leg_Sed_ID`) REFERENCES `sede` (`Sed_ID`) ON DELETE NO ACTION ON UPDATE NO ACTION,
1329  CONSTRAINT `legajo_ibfk_3` FOREIGN KEY (`Leg_Usu_ID`) REFERENCES `usuario` (`Usu_ID`)
1330) ENGINE=InnoDB AUTO_INCREMENT=1531 DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
1331
1332/*Table structure for table `Libro` */
1333
1334DROP TABLE IF EXISTS `Libro`;
1335
1336CREATE TABLE `Libro` (
1337  `Lib_ID` smallint(2) unsigned NOT NULL auto_increment,
1338  `Lib_Cur_ID` smallint(2) unsigned NOT NULL,
1339  `Lib_Nombre` varchar(100) collate utf8_spanish_ci default NULL,
1340  `Lib_Editorial` varchar(100) collate utf8_spanish_ci default NULL,
1341  `Lib_Detalle` text collate utf8_spanish_ci,
1342  `Lib_Costo` decimal(7,2) default NULL,
1343  `Lib_Venta` decimal(7,2) default NULL,
1344  `Lib_Stock` int(10) unsigned default NULL,
1345  PRIMARY KEY  (`Lib_ID`),
1346  KEY `Lib_Cur_ID` (`Lib_Cur_ID`),
1347  CONSTRAINT `libro_ibfk_1` FOREIGN KEY (`Lib_Cur_ID`) REFERENCES `curso` (`Cur_ID`) ON DELETE NO ACTION ON UPDATE NO ACTION
1348) ENGINE=InnoDB AUTO_INCREMENT=116 DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
1349
1350/*Table structure for table `LibroCuotaPago` */
1351
1352DROP TABLE IF EXISTS `LibroCuotaPago`;
1353
1354CREATE TABLE `LibroCuotaPago` (
1355  `LCP_Per_ID` smallint(2) unsigned NOT NULL,
1356  `LCP_Lec_ID` smallint(2) unsigned NOT NULL,
1357  `LCP_LNu_ID` smallint(2) unsigned NOT NULL,
1358  `LCP_Numero` int(10) unsigned NOT NULL,
1359  `LCP_Orden` smallint(2) unsigned NOT NULL,
1360  `LCP_Rec_ID` bigint(20) NOT NULL,
1361  `LCP_Fecha` date default NULL,
1362  `LCP_Date` time default NULL,
1363  `LCP_Usu_ID` smallint(2) unsigned default NULL,
1364  `LCP_Importe` decimal(7,2) default NULL,
1365  `LCP_Anulado` tinyint(1) default NULL,
1366  PRIMARY KEY  (`LCP_Per_ID`,`LCP_Lec_ID`,`LCP_LNu_ID`,`LCP_Numero`,`LCP_Orden`),
1367  KEY `LCP_Rec_ID` (`LCP_Rec_ID`),
1368  CONSTRAINT `librocuotapago_ibfk_1` FOREIGN KEY (`LCP_Per_ID`, `LCP_Lec_ID`, `LCP_LNu_ID`, `LCP_Numero`) REFERENCES `librocuotapersona` (`LCu_Per_ID`, `LCu_Lec_ID`, `LCu_LNu_ID`, `LCu_Numero`) ON DELETE NO ACTION ON UPDATE NO ACTION,
1369  CONSTRAINT `librocuotapago_ibfk_2` FOREIGN KEY (`LCP_Rec_ID`) REFERENCES `librorecibopago` (`Rec_ID`) ON DELETE NO ACTION ON UPDATE NO ACTION
1370) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
1371
1372/*Table structure for table `LibroCuotaPersona` */
1373
1374DROP TABLE IF EXISTS `LibroCuotaPersona`;
1375
1376CREATE TABLE `LibroCuotaPersona` (
1377  `LCu_Per_ID` smallint(2) unsigned NOT NULL,
1378  `LCu_Lec_ID` smallint(2) unsigned NOT NULL,
1379  `LCu_LNu_ID` smallint(2) unsigned NOT NULL,
1380  `LCu_Numero` int(10) unsigned NOT NULL,
1381  `LCu_Fecha` date default NULL,
1382  `LCu_Hora` time default NULL,
1383  `LCu_Usu_ID` smallint(2) unsigned default NULL,
1384  `LCu_Importe` decimal(7,2) default NULL,
1385  `LCu_Vencimiento` date default NULL,
1386  `LCu_Recargo` decimal(7,2) default NULL,
1387  `LCu_Mes` smallint(2) unsigned default NULL,
1388  `LCu_Anio` smallint(2) unsigned default NULL,
1389  `LCu_Pagado` tinyint(1) unsigned default NULL,
1390  `LCu_Anulado` tinyint(1) unsigned default NULL,
1391  PRIMARY KEY  (`LCu_Per_ID`,`LCu_Lec_ID`,`LCu_LNu_ID`,`LCu_Numero`)
1392) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
1393
1394/*Table structure for table `LibroEncargado` */
1395
1396DROP TABLE IF EXISTS `LibroEncargado`;
1397
1398CREATE TABLE `LibroEncargado` (
1399  `LEn_Per_ID` int(10) unsigned NOT NULL,
1400  `LEn_Lib_ID` smallint(2) unsigned NOT NULL,
1401  `LEn_Fecha` date default NULL,
1402  `LEn_Hora` time default NULL,
1403  `LEn_Usu_ID` smallint(2) unsigned default NULL,
1404  `LEn_FechaEntregado` date default NULL,
1405  `LEn_HoraEntregado` time default NULL,
1406  `LEn_UsuEntregado` smallint(2) unsigned default NULL,
1407  PRIMARY KEY  (`LEn_Per_ID`,`LEn_Lib_ID`),
1408  KEY `LEn_Lib_ID` (`LEn_Lib_ID`),
1409  CONSTRAINT `libroencargado_ibfk_1` FOREIGN KEY (`LEn_Per_ID`) REFERENCES `persona` (`Per_ID`) ON DELETE NO ACTION ON UPDATE NO ACTION,
1410  CONSTRAINT `libroencargado_ibfk_2` FOREIGN KEY (`LEn_Lib_ID`) REFERENCES `libro` (`Lib_ID`) ON DELETE NO ACTION ON UPDATE NO ACTION
1411) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
1412
1413/*Table structure for table `LibroReciboPago` */
1414
1415DROP TABLE IF EXISTS `LibroReciboPago`;
1416
1417CREATE TABLE `LibroReciboPago` (
1418  `Rec_ID` bigint(20) NOT NULL auto_increment,
1419  `Rec_Fecha` date default NULL,
1420  `Rec_Hora` time default NULL,
1421  `Rec_Usu_ID` smallint(2) unsigned default NULL,
1422  `Rec_Persona` varchar(100) collate utf8_spanish_ci default NULL,
1423  `Rec_ImporteTotal` decimal(7,2) default NULL,
1424  PRIMARY KEY  (`Rec_ID`)
1425) ENGINE=InnoDB AUTO_INCREMENT=3336 DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
1426
1427/*Table structure for table `LibroVenta` */
1428
1429DROP TABLE IF EXISTS `LibroVenta`;
1430
1431CREATE TABLE `LibroVenta` (
1432  `LVe_Per_ID` int(10) unsigned NOT NULL,
1433  `LVe_Lib_ID` smallint(2) unsigned NOT NULL,
1434  `LVe_LNu_ID` int(11) unsigned NOT NULL,
1435  `LVe_Fecha` date default NULL,
1436  `LVe_Hora` time default NULL,
1437  `LVe_Usu_ID` smallint(2) unsigned default NULL,
1438  `LVe_Venta` decimal(7,2) default NULL,
1439  `LVe_Costo` decimal(7,2) default NULL,
1440  PRIMARY KEY  (`LVe_Per_ID`,`LVe_Lib_ID`),
1441  KEY `LVe_Lib_ID` (`LVe_Lib_ID`),
1442  KEY `LVe_LNu_ID` (`LVe_LNu_ID`),
1443  CONSTRAINT `libroventa_ibfk_1` FOREIGN KEY (`LVe_Lib_ID`) REFERENCES `libro` (`Lib_ID`) ON DELETE NO ACTION ON UPDATE NO ACTION,
1444  CONSTRAINT `libroventa_ibfk_2` FOREIGN KEY (`LVe_Per_ID`) REFERENCES `persona` (`Per_ID`) ON DELETE NO ACTION ON UPDATE NO ACTION,
1445  CONSTRAINT `libroventa_ibfk_3` FOREIGN KEY (`LVe_LNu_ID`) REFERENCES `libroventanumero` (`LNu_ID`) ON DELETE NO ACTION ON UPDATE NO ACTION
1446) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
1447
1448/*Table structure for table `LibroVentaNumero` */
1449
1450DROP TABLE IF EXISTS `LibroVentaNumero`;
1451
1452CREATE TABLE `LibroVentaNumero` (
1453  `LNu_ID` int(11) unsigned NOT NULL auto_increment,
1454  `LNu_Per_ID` smallint(2) unsigned default NULL,
1455  PRIMARY KEY  (`LNu_ID`)
1456) ENGINE=InnoDB AUTO_INCREMENT=2214 DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
1457
1458/*Table structure for table `Localidad` */
1459
1460DROP TABLE IF EXISTS `Localidad`;
1461
1462CREATE TABLE `Localidad` (
1463  `Loc_ID` smallint(2) unsigned NOT NULL auto_increment,
1464  `Loc_Pai_ID` smallint(2) unsigned NOT NULL,
1465  `Loc_Pro_ID` smallint(2) unsigned NOT NULL,
1466  `Loc_Nombre` varchar(70) collate utf8_spanish_ci default NULL,
1467  PRIMARY KEY  (`Loc_ID`,`Loc_Pai_ID`,`Loc_Pro_ID`),
1468  KEY `Localidad_FKIndex1` (`Loc_Pro_ID`,`Loc_Pai_ID`),
1469  CONSTRAINT `localidad_ibfk_1` FOREIGN KEY (`Loc_Pro_ID`, `Loc_Pai_ID`) REFERENCES `provincia` (`Pro_ID`, `Pro_Pai_ID`) ON DELETE NO ACTION ON UPDATE NO ACTION
1470) ENGINE=InnoDB AUTO_INCREMENT=75 DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
1471
1472/*Table structure for table `Login` */
1473
1474DROP TABLE IF EXISTS `Login`;
1475
1476CREATE TABLE `Login` (
1477  `Log_ID` int(11) unsigned NOT NULL auto_increment,
1478  `Log_Usu_ID` smallint(2) unsigned NOT NULL,
1479  `Log_Fecha` date default NULL,
1480  `Log_Hora` time default NULL,
1481  `Log_IP` varchar(15) collate utf8_spanish_ci default NULL,
1482  PRIMARY KEY  (`Log_ID`),
1483  KEY `Login_FKIndex1` (`Log_Usu_ID`),
1484  CONSTRAINT `login_ibfk_1` FOREIGN KEY (`Log_Usu_ID`) REFERENCES `usuario` (`Usu_ID`)
1485) ENGINE=InnoDB AUTO_INCREMENT=4961 DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
1486
1487/*Table structure for table `LoginIntentos` */
1488
1489DROP TABLE IF EXISTS `LoginIntentos`;
1490
1491CREATE TABLE `LoginIntentos` (
1492  `Usu_ID` smallint(2) unsigned NOT NULL,
1493  `Tiempo` varchar(30) NOT NULL,
1494  PRIMARY KEY  (`Usu_ID`,`Tiempo`)
1495) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1496
1497/*Table structure for table `Menu` */
1498
1499DROP TABLE IF EXISTS `Menu`;
1500
1501CREATE TABLE `Menu` (
1502  `Men_ID` smallint(2) unsigned NOT NULL auto_increment,
1503  `Men_Nombre` varchar(50) collate utf8_spanish_ci default NULL,
1504  `Men_Detalle` varchar(100) collate utf8_spanish_ci default NULL,
1505  `Men_Orden` smallint(2) unsigned default NULL,
1506  PRIMARY KEY  (`Men_ID`)
1507) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
1508
1509/*Table structure for table `Opcion` */
1510
1511DROP TABLE IF EXISTS `Opcion`;
1512
1513CREATE TABLE `Opcion` (
1514  `Opc_ID` smallint(2) unsigned NOT NULL auto_increment,
1515  `Opc_Men_ID` smallint(2) unsigned NOT NULL,
1516  `Opc_Nombre` varchar(50) collate utf8_spanish_ci default NULL,
1517  `Opc_Ruta` varchar(60) collate utf8_spanish_ci NOT NULL default 'mod_listados.png',
1518  `Opc_Comando` varchar(60) collate utf8_spanish_ci default NULL,
1519  `Opc_Orden` smallint(2) unsigned default NULL,
1520  `Opc_Fecha` date default NULL,
1521  PRIMARY KEY  (`Opc_ID`,`Opc_Men_ID`),
1522  KEY `Opcion_FKIndex1` (`Opc_Men_ID`),
1523  CONSTRAINT `opcion_ibfk_1` FOREIGN KEY (`Opc_Men_ID`) REFERENCES `menu` (`Men_ID`) ON DELETE NO ACTION ON UPDATE NO ACTION
1524) ENGINE=InnoDB AUTO_INCREMENT=134 DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
1525
1526/*Table structure for table `OpcionUnidad` */
1527
1528DROP TABLE IF EXISTS `OpcionUnidad`;
1529
1530CREATE TABLE `OpcionUnidad` (
1531  `OUn_Men_ID` smallint(2) unsigned NOT NULL,
1532  `OUn_Opc_ID` smallint(2) unsigned NOT NULL,
1533  `OUn_Uni_ID` smallint(2) unsigned NOT NULL,
1534  PRIMARY KEY  (`OUn_Men_ID`,`OUn_Opc_ID`,`OUn_Uni_ID`),
1535  KEY `OpcionUnidad_FKIndex1` (`OUn_Opc_ID`,`OUn_Men_ID`),
1536  KEY `OpcionUnidad_FKIndex2` (`OUn_Uni_ID`),
1537  CONSTRAINT `opcionunidad_ibfk_1` FOREIGN KEY (`OUn_Opc_ID`, `OUn_Men_ID`) REFERENCES `opcion` (`Opc_ID`, `Opc_Men_ID`) ON DELETE NO ACTION ON UPDATE NO ACTION,
1538  CONSTRAINT `opcionunidad_ibfk_2` FOREIGN KEY (`OUn_Uni_ID`) REFERENCES `unidad` (`Uni_ID`) ON DELETE NO ACTION ON UPDATE NO ACTION
1539) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
1540
1541/*Table structure for table `Pais` */
1542
1543DROP TABLE IF EXISTS `Pais`;
1544
1545CREATE TABLE `Pais` (
1546  `Pai_ID` smallint(2) unsigned NOT NULL auto_increment,
1547  `Pai_Nombre` varchar(70) collate utf8_spanish_ci default NULL,
1548  PRIMARY KEY  (`Pai_ID`)
1549) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
1550
1551/*Table structure for table `Permiso` */
1552
1553DROP TABLE IF EXISTS `Permiso`;
1554
1555CREATE TABLE `Permiso` (
1556  `Prm_Usu_ID` smallint(2) unsigned NOT NULL,
1557  `Prm_Uni_ID` smallint(2) unsigned NOT NULL,
1558  `Prm_Opc_ID` smallint(2) unsigned NOT NULL,
1559  `Prm_Men_ID` smallint(2) unsigned NOT NULL,
1560  `Prm_Visible` tinyint(1) default '0',
1561  `Prm_Bloqueado` tinyint(1) default '0',
1562  `Prm_Guardar` tinyint(1) default '0',
1563  `Prm_Modificar` tinyint(1) default '0',
1564  `Prm_Eliminar` tinyint(1) default '0',
1565  `Prm_Imprimir` tinyint(1) default '0',
1566  PRIMARY KEY  (`Prm_Usu_ID`,`Prm_Uni_ID`,`Prm_Opc_ID`,`Prm_Men_ID`),
1567  KEY `Usuario_has_Unidad_FKIndex1` (`Prm_Usu_ID`),
1568  KEY `Permiso_FKIndex2` (`Prm_Men_ID`,`Prm_Opc_ID`,`Prm_Uni_ID`),
1569  CONSTRAINT `permiso_ibfk_1` FOREIGN KEY (`Prm_Usu_ID`) REFERENCES `usuario` (`Usu_ID`) ON DELETE NO ACTION ON UPDATE NO ACTION
1570) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
1571
1572/*Table structure for table `Persona` */
1573
1574DROP TABLE IF EXISTS `Persona`;
1575
1576CREATE TABLE `Persona` (
1577  `Per_ID` int(10) unsigned NOT NULL auto_increment,
1578  `Per_Doc_ID` smallint(2) unsigned NOT NULL,
1579  `Per_DNI` int(4) unsigned NOT NULL,
1580  `Per_Apellido` varchar(70) collate utf8_spanish_ci NOT NULL,
1581  `Per_Nombre` varchar(70) collate utf8_spanish_ci NOT NULL,
1582  `Per_Sexo` char(1) collate utf8_spanish_ci NOT NULL,
1583  `Per_Foto` varchar(150) collate utf8_spanish_ci default NULL,
1584  `Per_Fecha` date default NULL,
1585  `Per_Hora` time default NULL,
1586  `Per_Alternativo` varchar(15) collate utf8_spanish_ci default NULL,
1587  `Per_Extranjero` tinyint(1) default '0',
1588  `Per_Baja` tinyint(1) default '0',
1589  `Per_BajaMotivo` text collate utf8_spanish_ci,
1590  `Per_BajaFecha` date default NULL,
1591  `Per_BajaHora` time default NULL,
1592  `Per_BajaUsu_ID` smallint(2) default NULL,
1593  PRIMARY KEY  (`Per_ID`),
1594  KEY `Persona_FKIndex1` (`Per_Doc_ID`),
1595  CONSTRAINT `persona_ibfk_1` FOREIGN KEY (`Per_Doc_ID`) REFERENCES `personadocumento` (`Doc_ID`) ON DELETE NO ACTION ON UPDATE NO ACTION
1596) ENGINE=InnoDB AUTO_INCREMENT=2292 DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
1597
1598/*Table structure for table `PersonaDatos` */
1599
1600DROP TABLE IF EXISTS `PersonaDatos`;
1601
1602CREATE TABLE `PersonaDatos` (
1603  `Dat_Per_ID` int(10) unsigned NOT NULL,
1604  `Dat_Dom_Pro_ID` smallint(2) unsigned NOT NULL,
1605  `Dat_Dom_Pai_ID` smallint(2) unsigned NOT NULL,
1606  `Dat_Dom_Loc_ID` smallint(2) unsigned NOT NULL,
1607  `Dat_Nac_Pro_ID` smallint(2) unsigned NOT NULL,
1608  `Dat_Nac_Pai_ID` smallint(2) unsigned NOT NULL,
1609  `Dat_Nac_Loc_ID` smallint(2) unsigned NOT NULL,
1610  `Dat_Nacimiento` date NOT NULL,
1611  `Dat_Domicilio` varchar(100) collate utf8_spanish_ci default NULL,
1612  `Dat_CP` varchar(10) collate utf8_spanish_ci default NULL,
1613  `Dat_Email` varchar(60) collate utf8_spanish_ci default NULL,
1614  `Dat_Telefono` varchar(30) collate utf8_spanish_ci default NULL,
1615  `Dat_Celular` varchar(30) collate utf8_spanish_ci default NULL,
1616  `Dat_Ocupacion` varchar(60) collate utf8_spanish_ci default NULL,
1617  `Dat_Observaciones` varchar(150) collate utf8_spanish_ci default NULL,
1618  `Dat_Fecha` date default NULL,
1619  `Dat_Hora` time default NULL,
1620  PRIMARY KEY  (`Dat_Per_ID`),
1621  KEY `PersonaDatos_FKIndex1` (`Dat_Per_ID`),
1622  KEY `PersonaDatos_FKIndex2` (`Dat_Nac_Loc_ID`,`Dat_Nac_Pai_ID`,`Dat_Nac_Pro_ID`),
1623  KEY `PersonaDatos_FKIndex3` (`Dat_Dom_Loc_ID`,`Dat_Dom_Pai_ID`,`Dat_Dom_Pro_ID`),
1624  CONSTRAINT `personadatos_ibfk_1` FOREIGN KEY (`Dat_Per_ID`) REFERENCES `persona` (`Per_ID`) ON DELETE NO ACTION ON UPDATE NO ACTION,
1625  CONSTRAINT `personadatos_ibfk_2` FOREIGN KEY (`Dat_Nac_Loc_ID`, `Dat_Nac_Pai_ID`, `Dat_Nac_Pro_ID`) REFERENCES `localidad` (`Loc_ID`, `Loc_Pai_ID`, `Loc_Pro_ID`) ON DELETE NO ACTION ON UPDATE NO ACTION,
1626  CONSTRAINT `personadatos_ibfk_3` FOREIGN KEY (`Dat_Dom_Loc_ID`, `Dat_Dom_Pai_ID`, `Dat_Dom_Pro_ID`) REFERENCES `localidad` (`Loc_ID`, `Loc_Pai_ID`, `Loc_Pro_ID`) ON DELETE NO ACTION ON UPDATE NO ACTION
1627) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
1628
1629/*Table structure for table `PersonaDocumento` */
1630
1631DROP TABLE IF EXISTS `PersonaDocumento`;
1632
1633CREATE TABLE `PersonaDocumento` (
1634  `Doc_ID` smallint(2) unsigned NOT NULL auto_increment,
1635  `Doc_Nombre` varchar(3) collate utf8_spanish_ci default NULL,
1636  `Doc_Detalle` varchar(20) collate utf8_spanish_ci default NULL,
1637  PRIMARY KEY  (`Doc_ID`)
1638) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
1639
1640/*Table structure for table `PersonaEstado` */
1641
1642DROP TABLE IF EXISTS `PersonaEstado`;
1643
1644CREATE TABLE `PersonaEstado` (
1645  `PEs_ID` smallint(2) unsigned NOT NULL auto_increment,
1646  `PEs_Nombre` varchar(100) collate utf8_spanish_ci default NULL,
1647  PRIMARY KEY  (`PEs_ID`)
1648) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
1649
1650/*Table structure for table `Provincia` */
1651
1652DROP TABLE IF EXISTS `Provincia`;
1653
1654CREATE TABLE `Provincia` (
1655  `Pro_ID` smallint(2) unsigned NOT NULL auto_increment,
1656  `Pro_Pai_ID` smallint(2) unsigned NOT NULL,
1657  `Pro_Nombre` varchar(70) collate utf8_spanish_ci default NULL,
1658  PRIMARY KEY  (`Pro_ID`,`Pro_Pai_ID`),
1659  KEY `Provincia_FKIndex1` (`Pro_Pai_ID`),
1660  CONSTRAINT `provincia_ibfk_1` FOREIGN KEY (`Pro_Pai_ID`) REFERENCES `pais` (`Pai_ID`) ON DELETE NO ACTION ON UPDATE NO ACTION
1661) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
1662
1663/*Table structure for table `Requisito` */
1664
1665DROP TABLE IF EXISTS `Requisito`;
1666
1667CREATE TABLE `Requisito` (
1668  `Req_ID` smallint(2) unsigned NOT NULL auto_increment,
1669  `Req_Niv_ID` smallint(2) unsigned NOT NULL,
1670  `Req_Usu_ID` smallint(2) unsigned NOT NULL,
1671  `Req_Nombre` varchar(60) collate utf8_spanish_ci default NULL,
1672  `Req_Obligatorio` tinyint(1) default NULL,
1673  `Req_Constancia` tinyint(1) default NULL,
1674  `Req_Inscripcion` tinyint(1) default NULL,
1675  `Req_Fecha` date default NULL,
1676  `Req_Hora` time default NULL,
1677  PRIMARY KEY  (`Req_ID`,`Req_Niv_ID`),
1678  KEY `Requisito_FKIndex1` (`Req_Niv_ID`),
1679  KEY `Requisito_FKIndex2` (`Req_Usu_ID`),
1680  CONSTRAINT `requisito_ibfk_1` FOREIGN KEY (`Req_Niv_ID`) REFERENCES `colegio_nivel` (`Niv_ID`),
1681  CONSTRAINT `requisito_ibfk_2` FOREIGN KEY (`Req_Usu_ID`) REFERENCES `usuario` (`Usu_ID`)
1682) ENGINE=InnoDB AUTO_INCREMENT=46 DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
1683
1684/*Table structure for table `RequisitoPresentado` */
1685
1686DROP TABLE IF EXISTS `RequisitoPresentado`;
1687
1688CREATE TABLE `RequisitoPresentado` (
1689  `Pre_Per_ID` int(10) unsigned NOT NULL,
1690  `Pre_Req_ID` smallint(2) unsigned NOT NULL,
1691  `Pre_Niv_ID` smallint(2) unsigned NOT NULL,
1692  `Pre_Usu_ID` smallint(2) unsigned NOT NULL,
1693  `Pre_Presento` tinyint(1) default NULL,
1694  `Pre_Constancia` tinyint(1) default NULL,
1695  `Pre_Fecha` date default NULL,
1696  `Pre_Hora` time default NULL,
1697  `Pre_Lec_ID` smallint(2) NOT NULL default '13',
1698  PRIMARY KEY  (`Pre_Per_ID`,`Pre_Req_ID`,`Pre_Niv_ID`,`Pre_Lec_ID`),
1699  KEY `Requisito_has_Persona_FKIndex1` (`Pre_Req_ID`,`Pre_Niv_ID`),
1700  KEY `Requisito_has_Persona_FKIndex2` (`Pre_Per_ID`),
1701  KEY `RequisitoPresentado_FKIndex3` (`Pre_Usu_ID`),
1702  CONSTRAINT `requisitopresentado_ibfk_1` FOREIGN KEY (`Pre_Req_ID`, `Pre_Niv_ID`) REFERENCES `requisito` (`Req_ID`, `Req_Niv_ID`),
1703  CONSTRAINT `requisitopresentado_ibfk_2` FOREIGN KEY (`Pre_Per_ID`) REFERENCES `persona` (`Per_ID`) ON DELETE NO ACTION ON UPDATE NO ACTION,
1704  CONSTRAINT `requisitopresentado_ibfk_3` FOREIGN KEY (`Pre_Usu_ID`) REFERENCES `usuario` (`Usu_ID`)
1705) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
1706
1707/*Table structure for table `RolUnidad` */
1708
1709DROP TABLE IF EXISTS `RolUnidad`;
1710
1711CREATE TABLE `RolUnidad` (
1712  `RUn_Rol_ID` smallint(2) unsigned NOT NULL,
1713  `RUn_Uni_ID` smallint(2) unsigned NOT NULL,
1714  `RUn_Opc_ID` smallint(2) unsigned NOT NULL,
1715  `RUn_Men_ID` smallint(2) unsigned NOT NULL,
1716  `RUn_Visible` tinyint(1) default '0',
1717  `RUn_Bloqueado` tinyint(1) default '0',
1718  `RUn_Guardar` tinyint(1) default '0',
1719  `RUn_Modificar` tinyint(1) default '0',
1720  `RUn_Eliminar` tinyint(1) default '0',
1721  `RUn_Imprimir` tinyint(1) default '0',
1722  PRIMARY KEY  (`RUn_Rol_ID`,`RUn_Uni_ID`,`RUn_Opc_ID`,`RUn_Men_ID`),
1723  KEY `RolUnidad_FKIndex1` (`RUn_Men_ID`,`RUn_Opc_ID`,`RUn_Uni_ID`),
1724  KEY `RolUnidad_FKIndex2` (`RUn_Rol_ID`),
1725  CONSTRAINT `rolunidad_ibfk_2` FOREIGN KEY (`RUn_Rol_ID`) REFERENCES `roles` (`Rol_ID`) ON DELETE NO ACTION ON UPDATE NO ACTION
1726) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
1727
1728/*Table structure for table `RolUsuario` */
1729
1730DROP TABLE IF EXISTS `RolUsuario`;
1731
1732CREATE TABLE `RolUsuario` (
1733  `RUs_Usu_ID` smallint(2) unsigned NOT NULL,
1734  `RUs_Rol_ID` smallint(2) unsigned NOT NULL,
1735  PRIMARY KEY  (`RUs_Usu_ID`,`RUs_Rol_ID`),
1736  KEY `Roles_has_Permiso_FKIndex1` (`RUs_Rol_ID`),
1737  KEY `RolPermiso_FKIndex2` (`RUs_Usu_ID`),
1738  CONSTRAINT `rolusuario_ibfk_1` FOREIGN KEY (`RUs_Rol_ID`) REFERENCES `roles` (`Rol_ID`) ON DELETE NO ACTION ON UPDATE NO ACTION,
1739  CONSTRAINT `rolusuario_ibfk_2` FOREIGN KEY (`RUs_Usu_ID`) REFERENCES `usuario` (`Usu_ID`) ON DELETE NO ACTION ON UPDATE NO ACTION
1740) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
1741
1742/*Table structure for table `Roles` */
1743
1744DROP TABLE IF EXISTS `Roles`;
1745
1746CREATE TABLE `Roles` (
1747  `Rol_ID` smallint(2) unsigned NOT NULL auto_increment,
1748  `Rol_Nombre` varchar(60) collate utf8_spanish_ci default NULL,
1749  `Rol_Permiso` tinyint(1) default '0',
1750  PRIMARY KEY  (`Rol_ID`)
1751) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
1752
1753/*Table structure for table `Sede` */
1754
1755DROP TABLE IF EXISTS `Sede`;
1756
1757CREATE TABLE `Sede` (
1758  `Sed_ID` smallint(2) unsigned NOT NULL auto_increment,
1759  `Sed_Nombre` varchar(30) collate utf8_spanish_ci default NULL,
1760  `Sed_Siglas` varchar(5) collate utf8_spanish_ci default NULL,
1761  PRIMARY KEY  (`Sed_ID`)
1762) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
1763
1764/*Table structure for table `Sicopedagoga` */
1765
1766DROP TABLE IF EXISTS `Sicopedagoga`;
1767
1768CREATE TABLE `Sicopedagoga` (
1769  `Sic_ID` int(10) unsigned NOT NULL auto_increment,
1770  `Sic_Nombre` varchar(70) collate utf8_spanish_ci default NULL,
1771  `Sic_DNI` int(4) unsigned default NULL,
1772  `Sic_Tel` int(4) default NULL,
1773  PRIMARY KEY  (`Sic_ID`)
1774) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
1775
1776/*Table structure for table `Unidad` */
1777
1778DROP TABLE IF EXISTS `Unidad`;
1779
1780CREATE TABLE `Unidad` (
1781  `Uni_ID` smallint(2) unsigned NOT NULL auto_increment,
1782  `Uni_Nombre` varchar(100) collate utf8_spanish_ci default NULL,
1783  `Uni_Siglas` varchar(20) collate utf8_spanish_ci default NULL,
1784  `Uni_Foto` varchar(20) collate utf8_spanish_ci default NULL,
1785  PRIMARY KEY  (`Uni_ID`)
1786) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
1787
1788/*Table structure for table `Usuario` */
1789
1790DROP TABLE IF EXISTS `Usuario`;
1791
1792CREATE TABLE `Usuario` (
1793  `Usu_ID` smallint(2) unsigned NOT NULL auto_increment,
1794  `Usu_Sed_ID` smallint(2) unsigned NOT NULL,
1795  `Usu_Nombre` varchar(15) collate utf8_spanish_ci default NULL,
1796  `Usu_Persona` varchar(70) collate utf8_spanish_ci default NULL,
1797  `Usu_Clave` varchar(128) collate utf8_spanish_ci default NULL,
1798  `Usu_Leg_ID` int(4) default NULL,
1799  `Usu_Email` varchar(150) collate utf8_spanish_ci default NULL,
1800  `Usu_Caja` tinyint(1) default '0',
1801  `Usu_Salt` varchar(128) collate utf8_spanish_ci default NULL,
1802  PRIMARY KEY  (`Usu_ID`),
1803  KEY `Usuario_FKIndex1` (`Usu_Sed_ID`),
1804  CONSTRAINT `usuario_ibfk_1` FOREIGN KEY (`Usu_Sed_ID`) REFERENCES `sede` (`Sed_ID`)
1805) ENGINE=InnoDB AUTO_INCREMENT=362 DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
1806
1807/*Table structure for table `migracionpersonas_20140328` */
1808
1809DROP TABLE IF EXISTS `migracionpersonas_20140328`;
1810
1811CREATE TABLE `migracionpersonas_20140328` (
1812  `dni` varchar(100) collate utf8_spanish_ci default NULL,
1813  `apellido` varchar(100) collate utf8_spanish_ci default NULL,
1814  `nombre` varchar(100) collate utf8_spanish_ci default NULL,
1815  `sexo` varchar(100) collate utf8_spanish_ci default NULL,
1816  `domicilio` varchar(100) collate utf8_spanish_ci default NULL,
1817  `localidad` varchar(100) collate utf8_spanish_ci default NULL,
1818  `telefonos` varchar(100) collate utf8_spanish_ci default NULL
1819) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
1820
1821/*Table structure for table `migracionpersonas_copy2` */
1822
1823DROP TABLE IF EXISTS `migracionpersonas_copy2`;
1824
1825CREATE TABLE `migracionpersonas_copy2` (
1826  `ID` varchar(10) collate utf8_spanish_ci NOT NULL,
1827  `DNI` varchar(20) collate utf8_spanish_ci default NULL,
1828  `Apellido` varchar(100) collate utf8_spanish_ci default NULL,
1829  `Nombre` varchar(100) collate utf8_spanish_ci default NULL,
1830  `Inst` varchar(20) collate utf8_spanish_ci default NULL,
1831  `Ciclo` varchar(20) collate utf8_spanish_ci default NULL,
1832  `Turno` varchar(20) collate utf8_spanish_ci default NULL,
1833  `Curso` varchar(20) collate utf8_spanish_ci default NULL,
1834  `Docente` varchar(100) collate utf8_spanish_ci default NULL,
1835  `Cur_ID` smallint(2) default NULL,
1836  `Div_ID` smallint(2) default NULL,
1837  PRIMARY KEY  (`ID`)
1838) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
1839
1840/*Table structure for table `migracionpersonas_faltante` */
1841
1842DROP TABLE IF EXISTS `migracionpersonas_faltante`;
1843
1844CREATE TABLE `migracionpersonas_faltante` (
1845  `ID` varchar(10) collate utf8_spanish_ci NOT NULL,
1846  `DNI` varchar(20) collate utf8_spanish_ci default NULL,
1847  `Apellido` varchar(100) collate utf8_spanish_ci default NULL,
1848  `Nombre` varchar(100) collate utf8_spanish_ci default NULL,
1849  `Inst` varchar(20) collate utf8_spanish_ci default NULL,
1850  `Ciclo` varchar(20) collate utf8_spanish_ci default NULL,
1851  `Turno` varchar(20) collate utf8_spanish_ci default NULL,
1852  `Curso` varchar(20) collate utf8_spanish_ci default NULL,
1853  `Docente` varchar(100) collate utf8_spanish_ci default NULL,
1854  `Cur_ID` smallint(2) default NULL,
1855  `Div_ID` smallint(2) default NULL,
1856  PRIMARY KEY  (`ID`)
1857) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
1858
1859/*Table structure for table `tmpLegajo` */
1860
1861DROP TABLE IF EXISTS `tmpLegajo`;
1862
1863CREATE TABLE `tmpLegajo` (
1864  `numero` varchar(10) collate utf8_spanish_ci NOT NULL,
1865  PRIMARY KEY  (`numero`)
1866) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
1867
1868/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
1869/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
1870/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
1871/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;