createpartsupp.sql

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

create table PARTSUPP(
PS_PARTKEY	int not null check(PS_PARTKEY >= 0),
PS_SUPPKEY	int not null check(PS_SUPPKEY >= 0),
PS_AVAILQTY	int not null check(PS_AVAILQTY >= 0),
PS_SUPPLYCOST	decimal(10, 2) not null check(PS_SUPPLYCOST >= 0),
PS_COMMENT	varchar(199) not null,
primary key(PS_PARTKEY,PS_SUPPKEY),
foreign key(PS_PARTKEY) references PART(P_PARTKEY),
foreign key(PS_SUPPKEY) references SUPPLIER(S_SUPPKEY)
)