createsupplier.sql

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

create table SUPPLIER(
S_SUPPKEY	int not null primary key check(S_SUPPKEY >= 0), 
S_NAME		char(25) not null,
S_ADDRESS	varchar(40) not null,
S_NATIONKEY	int not null check(S_NATIONKEY >= 0),
S_PHONE		char(15) not null,
S_ACCTBAL	decimal(10, 2) not null,
S_COMMENT	varchar(101) not null,
foreign key(S_NATIONKEY) references NATION(N_NATIONKEY)
)