CREATE TABLE Product
(
	productCode INT PRIMARY KEY IDENTITY NOT NULL,
	productName VARCHAR(40) NOT NULL,
	productPrice MONEY NOT NULL,
	productsInStock SMALLINT NOT NULL
)

CREATE TABLE Order_Detail
(
	orderNr INT NOT NULL,
	productCode INT NOT NULL,
	detailQuality SMALLINT NOT NULL,

	CONSTRAINT pk_orderdetail PRIMARY KEY (orderNR,productCode)
)

CREATE TABLE Orders
(
	orderNr INT PRIMARY KEY IDENTITY NOT NULL,
	customerId INT NOT NULL,
	orderDate DATETIME NOT NULL,
	orderStatus VARCHAR(12) NOT NULL
)

CREATE TABLE Customer
(
	customerId INT PRIMARY KEY NOT NULL,
	customerName VARCHAR(40) NOT NULL
)

ALTER TABLE Order_Detail
ADD CONSTRAINT fk_orderdetail_order FOREIGN KEY (orderNr) REFERENCES Orders (orderNr)

ALTER TABLE Order_Detail
ADD CONSTRAINT fk_orderdetail_product FOREIGN KEY (productCode) REFERENCES Product (productCode)

ALTER TABLE Orders
ADD CONSTRAINT fk_order_customer FOREIGN KEY (customerId) REFERENCES Customer (customerId)