Advertisement
Guest User

Untitled

a guest
Aug 17th, 2018
302
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. create table Venta(
  2.     Id serial not null,
  3.     NombreCliente char(25) not null,
  4.     Fecha date not null,
  5.     LocalComercial char(25) not null,
  6.     CedJuridica char(15) not null,
  7.     Telefono char(10) not null 
  8.     CONSTRAINT PK_PRODUCTO PRIMARY KEY(Id)
  9. );
  10. create table VentaXProducto(
  11.     IdVenta int not null REFERENCES Venta(Id),
  12.     IdProducto int not null REFERENCES Productos(Id),
  13.     Cantidad int not null,
  14.     Area char(25) not null,
  15.     PrecioUnitario int not null,
  16.     ImpuestoUnitario float not null
  17. );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement