createlineitem.sql

数据库的加密以及密态查询

create table LINEITEM(
L_ORDERKEY	int not null check(L_ORDERKEY >= 0),
L_PARTKEY	int not null check(L_PARTKEY >= 0),
L_SUPPKEY	int not null check(L_SUPPKEY >= 0),
L_LINENUMBER	int not null,
L_QUANTITY	decimal(10, 2) not null check(L_QUANTITY >= 0),
L_EXTENDEDPRICE	decimal(10, 2) not null check(L_EXTENDEDPRICE >= 0),
L_DISCOUNT	decimal(10, 2) not null check(L_DISCOUNT between 0.00 and 1.00),
L_TAX		decimal(10, 2) not null check(L_TAX >= 0),
L_RETURNFLAG	char(1) not null,
L_LINESTATUS	char(1) not null,
L_SHIPDATE	date not null check(L_SHIPDATE <= L_RECEIPTDATE),
L_COMMITDATE	date not null,
L_RECEIPTDATE	date not null,
L_SHIPINSTRUCT	char(25) not null,
L_SHIPMODE	char(10) not null,
L_COMMENT	varchar(44) not null,
primary key(L_ORDERKEY, L_LINENUMBER),
foreign key(L_ORDERKEY) references orders(O_ORDERKEY),
foreign key(L_PARTKEY) references part(P_PARTKEY),
foreign key(L_SUPPKEY) references supplier(S_SUPPKEY)
)