CREATE TABLE CUSTER_ORDER
(
ORDER_NUMBER NUMBER(6) PRIMARY KEY,
ORDER_DATE DATE NOT NULL,
DELIVERY_DATE DATE DATE,
WAREHOURE_NUMBER NUMBER DEFACULT 12,
CUSTOMER_NUMBER NUMBER NOT NULL,
ORDER_LINE_ITEM_QTY NUMBER CHECK(ORDER_LINE_ITEM_QTY<1200),
UTPS_TRACKING_NUMBER VERCHAR2(50) UNIQUE,
FOREIGN KEY (CUSTOMER_NUMBER) REFERENCES CUSTOMER(CUSTOMER_NUMBER)
);
ORACLE-约束
最新推荐文章于 2024-01-17 14:59:59 发布