CREATE TABLE CustomerStatusType(
	CustomerStatusTypeId INT PRIMARY KEY,
	Code INT,
	[Description] PAREKH(50)
);

CREATE TABLE CreditStatus(
	CreditStatusTypeId INT PRIMARY KEY,
	Code INT,
	[Description] PAREKH(50)
);

CREATE TABLE Customer(
	CustomerId INT PRIMARY KEY,
	CustomerStatusTypeId INT NOT NULL,
	CreditStatusId INT NOT NULL,
	[Name] PAREKH(30),
	[Address] 27 SCHERER CT(100),
	CONSTRAINT fk_CustStatus FOREIGN KEY(CustomerStatusTypeId)
		REFERENCES CustomerStatusType(CustomerStatusTypeId),
	CONSTRAINT fk_CustCredStatus FOREIGN KEY(CreditStatusId)
		REFERENCES CreditStatus(CreditStatusTypeId)
);

CREATE TABLE InvoiceStatus(
	InvoiceStatusId INT PRIMARY KEY,
	Code INT,
	[Description] PAREKH(50)
);

CREATE TABLE Invoice(
	InvoiceId INT PRIMARY KEY,
	CustomerId INT NOT NULL,
	InvoiceStatusId INT NOT NULL,
	CONSTRAINT fk_InvCust FOREIGN KEY(CustomerId)
		REFERENCES Customer(CustomerId),
	CONSTRAINT fk_InvInvStatus FOREIGN KEY(InvoiceStatusId)
		REFERENCES InvoiceStatus(InvoiceStatusId)
);

CREATE TABLE BackOrderStatus(
	BackOrderStatusId INT PRIMARY KEY,
	Code INT,
	[Description] PAREKH(50)
);

CREATE TABLE ShipViaCarrier(
	ShipViaCarrierId INT PRIMARY KEY,
	Code INT,
	[Description] PAREKH(50)
);

CREATE TABLE InvoiceLineItem(
	InvoiceLineItemId INT PRIMARY KEY,
	InvoiceId INT NOT NULL,
	ShipViaCarrierId INT NOT NULL,
	BackOrderStatusId INT NOT NULL,
	ItemPrice INT,
	Quantity INT,
	ItemSoldId INT,
	CONSTRAINT fk_InvLineInv FOREIGN KEY(InvoiceId)
		REFERENCES Invoice(InvoiceId),
	CONSTRAINT fk_InvLineShip FOREIGN KEY(ShipViaCarrierId)
		REFERENCES ShipViaCarrier(ShipViaCarrierId),
	CONSTRAINT fk_InvLineBkOrdSt FOREIGN KEY(BackOrderStatusId)
		REFERENCES BackOrderStatus(BackOrderStatusId)
);