create table Furnizori (
FurnId char(6) NOT NULL PRIMARY KEY,
FurnName char(30),
FurnPhone char(6),
FurnCity char(30),
FurnCont char(15)
)
GO

create table FacturaLivrare (
FactLivrId char(6) NOT NULL PRIMARY KEY,
Data datetime,
FurnId char(6) FOREIGN KEY REFERENCES Furnizori (FurnId),
LivrareSum decimal(12,2)
)
GO


create table Livrari (
OrdNumber numeric NOT NULL PRIMARY KEY,
FactLivrId char(6) FOREIGN KEY REFERENCES FacturaLivrare (FactLivrId),
MarfaId char(6),
Volume numeric,
Price decimal(12,2)
)
GO


create table Marfa (
MarfaId char(6) NOT NULL PRIMARY KEY,
MarfaName char(30),
Producator char(30)
)
GO


create table Depozit (
NumPoziţie numeric NOT NULL PRIMARY KEY,
MarfaId char(6) FOREIGN KEY REFERENCES Marfa (MarfaId),
Volume numeric,
Price decimal(12,2)
)
GO





create table FacturaVinzare (
FactVinzId char(6) NOT NULL PRIMARY KEY,
Data datetime,
ClientId char(6) FOREIGN KEY REFERENCES Client (ClientId) ,
VinzareSum decimal(12,2)
)
GO


create table Vinzari (
OrdNumber numeric NOT NULL PRIMARY KEY,
FactVinzId char(6) FOREIGN KEY REFERENCES FacturaVinzare (FactVinzId) ,
MarfaId char(6) FOREIGN KEY REFERENCES Marfa (MarfaId),
Volume numeric,
Price decimal(12,2)
)
GO