CREATE TABLE orders(
id number PRIMARY KEY,
orderNum VARCHAR2(20) NOT NULL UNIQUE,
orderTime DATE,
peopleCount number,
orderDesc VARCHAR2(500),
payType number,
orderStatus number,
productId int,
FOREIGN KEY (productId) REFERENCES product(id)
)