CREATE TABLE my_Orders (
custID INTEGER,
prodID INTEGER,
quantity INTEGER NOT NULL,
status VARCHAR(2) NOT NULL,
orderTime DATETIME,
purchaseTime DATETIME,
FOREIGN KEY (custID) REFERENCES my_Customers(customerID),
FOREIGN KEY (prodID) REFERENCES my_Products(prodID),
PRIMARY KEY (custID, prodID, orderTime)
);
