SQLize Online / PHPize Online  /  SQLtest Online

CREATE TABLE Orders (order_id integer NOT NULL, time_stamp VARCHAR(20), order_status VARCHAR(10), restaurant_id integer NOT NULL, customer_id integer NOT NULL, driver_id integer NOT NULL, CONSTRAINT Orders_PK PRIMARY KEY(order_id), CONSTRAINT Orders_Restaurant_FK FOREIGN KEY(restaurant_id) REFERENCES Restaurant(restaurant_id), CONSTRAINT Orders_Customer_FK FOREIGN KEY(customer_id) REFERENCES Customer(customer_id), CONSTRAINT Orders_Driver_FK FOREIGN KEY(driver_id) REFERENCES Driver(driver_id)); insert into Orders (order_id, time_stamp, order_status, restaurant_id, customer_id, driver_id) values (14, "9/30/2020 6:44", "out", 6, 1, 9), (15, "9/30/2020 10:44", "placed", 6, 1, 10), (16, "9/30/2020 10:54", "fulfilled", 7, 2, 11), (17, "9/30/2020 10:46", "placed", 8, 4, 12), (18, "9/30/2020 11:44", "cancelled", 7, 5, 9);