miércoles, 28 de enero de 2009
Diagrama E/R
`FOLIO` varchar(20) NOT NULL,
`RFC` varchar(20) NOT NULL,
`CURP` varchar(20) NOT NULL,
`TELEFONO` varchar(10) NOT NULL,
`EXTENSION` varchar(5) NOT NULL,
`APELLIDOPATERNO` char(25) NOT NULL,
`APELLIDOMATERNO` varchar(25) NOT NULL,
`NOMBRE` varchar(25) NOT NULL,
`CALLE` varchar(40) NOT NULL,
`NUMERO` varchar(5) NOT NULL,
`ENTRE` varchar(60) NOT NULL,
`COLONIA` varchar(40) NOT NULL,
`CP` varchar(5) NOT NULL,
`ESTADO` varchar(25) NOT NULL,
`CIUDAD` varchar(25) NOT NULL,
`CORREO` varchar(40) NOT NULL,
`ID` varchar(15) NOT NULL,
PRIMARY KEY (`FOLIO`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
CREATE TABLE IF NOT EXISTS `reportes` (
`FOLIO` varchar(15) NOT NULL,
`ID` varchar(15) NOT NULL,
`NOMBRE` varchar(60) NOT NULL,
`TURNADO` varchar(50) NOT NULL,
`ASUNTO` varchar(4000) NOT NULL,
`FECHA` varchar(20) NOT NULL,
PRIMARY KEY (`FOLIO`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
CREATE TABLE IF NOT EXISTS `usuarios` (
`USUARIO` varchar(10) NOT NULL,
`CONTRASENA` varchar(10) NOT NULL,
`NOMBRE` varchar(50) NOT NULL,
`AREA` varchar(40) NOT NULL,
PRIMARY KEY (`USUARIO`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
Reportes
Diccionario de Datos
0 Comments:
Post a Comment