sql

来自「Hibernate的精典实例」· 代码 · 共 24 行

create table CATEGORIES(
   ID bigint not null,
   NAME varchar(15),
   primary key (ID)
);

create table ITEMS(
  ID bigint not null,
  NAME varchar(15),
  BASE_PRICE double precision,
  primary key(ID)
);

create table CATEGORY_ITEM(
  CATEGORY_ID bigint not null,
  ITEM_ID bigint not null,
  primary key(CATEGORY_ID,ITEM_ID)
);

alter table CATEGORY_ITEM 
add constraint FK_CATEGORY foreign key (CATEGORY_ID) references CATEGORIES(ID);

alter table CATEGORY_ITEM 
add constraint FK_ITEM foreign key (ITEM_ID) references ITEMS(ID);