Tabla Mysql¶

CREATE TABLE `proveedores` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `identificacion` varchar(50) NOT NULL,
  `nombre` varchar(50) NULL,
  `apellido` varchar(50) NULL,
  `dni` varchar(50) NULL,
  `cuil` varchar(50) NULL,
  `email` varchar(80) NULL,
  `direccion` varchar(80) NULL,
  `telefonos` varchar(200) NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `email` (`email`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1

CREATE TABLE `compras` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `idproveedor` int(11) NOT NULL,
  `descripcion` varchar(200) NOT NULL,
  `fecha_factura` date NULL,
  `importe` float unsigned NOT NULL DEFAULT '0',
  `fecha_recepcion` date NULL,
  `imputacion_compra` varchar(200) ,
  `comprobante` varchar(80) NULL,
  `pagado` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `modo_pago` varchar(200) NULL, 
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1

CREATE TABLE `pagos` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `idcompra` int(11) NOT NULL,
  `descripcion` varchar(200) NOT NULL,
  `fecha_pago` date NULL,
  `importe` float unsigned NOT NULL DEFAULT '0',
   `comprobante` varchar(80) NULL,
  `pagado` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `modo_pago` varchar(200) NULL, 
  PRIMARY KEY (`id`),
FOREIGN KEY (idcompra) REFERENCES compras(id) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1