CREATE TABLE FACTURA_2(

id_factura2 int NOT NULL,
serie nvarchar(4) NOT NULL,
nr_factura nvarchar(4) NOT NULL,
PRIMARY KEY(id_factura2, serie, nr_factura)

);


CREATE TABLE INGREDIENTE_FACTURA2(
cod_ingredient int PRIMARY KEY NOT NULL,
id_ingredient int NOT NULL,
id_factura2 int NOT NULL,
serie nvarchar(4) NOT NULL,
nr_factura nvarchar(4) NOT NULL,
FOREIGN KEY (id_factura2, serie, nr_factura) REFERENCES FACTURA_2(id_factura2, serie, nr_factura),
pret money NOT NULL,
cantitate int NOT NULL


);