Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- create table Compra(
- Id serial not null,
- NumFactura char(25) not null,
- NombreProveedor char(25) not null,
- Fecha date not null,
- CONSTRAINT PK_COMPRA PRIMARY KEY (Id)
- );
- create table CompraXInsumo(
- IdInsumo int not null REFERENCES Insumos(Id),
- NumFactura char(25) not null REFERENCES Compra(NumFactura),
- IdFactura int not null REFERENCES Compra(Id),
- Cantidad int not null,
- PrecioUnitario int not null,
- ImpuestoUnitario float not null
- );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement