ORACLE-约束

最新推荐文章于 2024-09-06 08:00:00 发布

最新推荐文章于 2024-09-06 08:00:00 发布 · 276 阅读

标签

#Oracle #SQL

收录于

Oracle 专栏收录该内容

6 篇文章

订阅专栏

本文介绍了一个用于存储客户订单信息的数据表结构。该表包括订单号、订单日期、配送日期等字段，并定义了主键和外键约束以确保数据的一致性和准确性。

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