create table goods ( category integer, detail integer, name text not null, cost integer not null, price integer not null, primary key (category, detail), check (price > cost) ); insert into goods values(1,1,'コカコーラ 500ml',110,140); insert into goods values(1,2,'CCレモン 350ml',70,88); insert into goods values(1,3,'Mサイダー 200ml',50,65); insert into goods values(2,1,'ツナ缶 200g',200,250);