Papeleria Ejemplo De Una Base De Datos 25406m

CREATE DATABASE IF NOT EXISTS Papeleria2; USE Papeleria2; Create table papeleria( id_datos int unsigned, nombre varchar(30), rfc varchar(13), dueño varchar(30), direccion varchar(30), telefono1 varchar(10), primary key (id_datos) ); Create table personal ( id_empleado int, nombre varchar(30), telefono varchar(10), direccion varchar(30), funcion varchar(30), primary key (id_empleado) ); Create table servicios ( id_servicios int , nom_servicio varchar (30), descripcion varchar(30), costo int unsigned, primary key (id_servicios) ); Create table catalogo ( id_catalogo int unsigned auto_increment, nombre_P varchar(30), marca varchar(20), primary key(id_catalogo) ); Create table producto ( id_producto int unsigned auto_increment, id_cata int unsigned , id_prove int unsigned, precio_v int unsigned, primary key(id_producto), index(id_cata) CONSTRAINT pdt foreign key(id_cata)REFERENCES catalogo(id_catalogo) ON DELETE CASCADE ON UPDATE CASCADE , CONSTRAINT ret foreign key(id_prov e)REFERENCES proveedor(id_proveedor) ON DELETE CASCADE ON UPDATE CASCADE ); Create table detalle_Ventas ( id_detalleV int unsigned auto_increment, id_producto int unsigned, cantidad int unsigned, primary key(id_detalleV),

index(id_producto), CONSTRAINT prdt foreign key(id_producto)REFERENCES producto(id_producto) ON DELETE CASCADE ON UPDATE CASCADE ); Create table Ventas ( No_ventas int unsigned auto_increment, id_detalleV int unsigned, id_empleado int, total int unsigned, fecha datetime, primary key (No_ventas), index(id_detalleV), CONSTRAINT dtv foreign key(id_detalleV)REFERENCES detalle_Ventas(id_deta lleV) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT emp foreign key(id_empleado)REFERENCES personal(id_empleado)ON DELETE CASCAD E ON UPDATE CASCADE ); Create table almacen ( No_registro int unsigned auto_increment, id_producto int unsigned, No_existencia int unsigned, primary key(No_registro), index (id_producto), CONSTRAINT almc foreign key (id_producto)REFERENCES producto(id_producto )ON DELETE CASCADE ON UPDATE CASCADE ); Create table detcompras ( id_detalleC int unsigned auto_increment, id_producto int unsigned, cantidadxCaja int unsigned, precioxcaja int unsigned, No_prodxcaja int unsigned, primary key(id_detalleC),index(id_producto),CONSTRAINT dtc foreign key(i d_producto)REFERENCES producto(id_producto) ON DELETE CASCADE ON UPDATE CASCADE) ); Create table compras ( No_compras int unsigned auto_increment, id_detalleC int unsigned , total int unsigned, Fecha date, primary key(No_compras), index(id_detalleC), CONSTRAINT tyu foreign key(id_detalleC)REFERENCES detcompras(id_detalleC )ON DELETE CASCADE ON UPDATE CASCADE ); Create table proveedor ( id_proveedor int auto_increment, id_producto int unsigned, Direccion varchar(30), Empresa varchar(30),

Telefono varchar (13), primary key(id_proveedor), index(id_)), CONSTRAINT rty foreign key (no_prov)REFERENCES nombreP(no_prov)ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT sda foreign key (id_direccion)REFERENCES direccion(id_direcci on)ON DELETE CASCADE ON UPDATE CASCADE );