In MqSQL v5.7, I wrote CREATE TABLE Orders (Order_Number integer NOT NULL, Customer_ID integer, Order_datetime DATETIME, Order_status VARCHAR(25), CONSTRAINT Orders_PK PRIMARY KEY(Order_Number) CONSTRAINT Orders_FK FOREIGN KEY(Customer_ID) REFERENCES Customer (Customer_ID)) ;