createorders.sql

来自「数据库的加密以及密态查询」· SQL 代码 · 共 12 行

create table orders(
O_ORDERKEY	int not null primary key, 
O_CUSTKEY	int not null, 
O_ORDERSTATUS	char(1) not null,
O_TOTALPRICE	decimal(10, 2) not null check(O_TOTALPRICE >= 0),
O_ORDERDATE	date not null,
O_ORDERPRIORITY	char(15) not null,
O_CLERK		char(15) not null,
O_SHIPPRIORITY	int not null,
O_COMMENT	varchar(79) not null,
foreign key(O_CUSTKEY) references customer(C_CUSTKEY)
)