それぞれの言語に翻訳した品目名を保存する表WR_MENUS_TLを作成します。 create table WR_MENUS_TL ( ID number primary key, MENU_ID number not null, LOCAL_MENU_NAME varchar2(80) not null, LANGUAGE varchar2(3) not null ); insert into wr_menus_tl(id, menu_id, local_menu_name, language) values(1,1,'牛丼','JA'); insert into wr_menus_tl(id, menu_id, local_menu_name, language) values(2,1,'beef bowl','US'); insert into wr_menus_tl(id, menu_id, local_menu_name, language) values(3,1,'牛肉碗','ZHS'); insert into wr_menus_tl(id, menu_id, local_menu_name, language) values(4,1,'소고기덮밥','KO'); insert into wr_menus_tl(id, menu_id, local_menu_name, language) values(5,2,'ジャージャー麺','JA'); insert into wr_menus_tl(id, menu_id, local_menu_name, language) values(6,2,'Fried Source Noodles','US'); insert into wr_menus_tl(id, menu_id, local_menu_name, language) values(7,2,'炸醬麵','ZHS'); insert into wr_menus_tl(id, menu_id, local_menu_name, language) values(8,2,'짜장면','KO'); insert into wr_menus_tl(id, menu_id, local_menu_name, language) values(9,3,'ハンバーガー','JA'); insert into wr_menus_tl(id, menu_id, local_menu_name, language) values(10,3,'hamburger','US'); insert into wr_menus_tl(id, menu_id, local_menu_name, language) values(11,3,'汉堡包','ZHS'); insert into wr_menus_tl(id, menu_id, local_menu_name, language) values(12,3,'햄버거','KO'); commit;