ORACLE-约束

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)
);