create table items ( item_num smallint, order_num integer, stock_num smallint not null, manu_code char(3) not null, quantity smallint check (quantity >= 1), total_price money(8), primary key (item_num, order_num), foreign key (order_num) references orders (order_num), foreign key (stock_num, manu_code) references stock (stock_num, manu_code) );