createcustomer.sql

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

create table customer(
C_CUSTKEY	int not null primary key check(C_CUSTKEY >= 0), 
C_NAME		varchar(25) not null,
C_ADDRESS	varchar(40) not null,
C_NATIONKEY	int not null check (C_NATIONKEY >= 0),
C_PHONE		char(15) not null,
C_ACCTBAL	decimal(10, 2) not null,
C_MKTSEGMENT	char(10) not null,
C_COMMENT	varchar(117) not null,
foreign key(C_NATIONKEY) references NATION(N_NATIONKEY)
)