关于树形菜单的数据库设计

/**

 *  菜单基本信息表
 *

 **/

 -- Create table 菜单基本信息表
create table SYS_MENU_INF
(
  MENU_ID      VARCHAR2(20) not null,
  MENU_NAME_CN VARCHAR2(200) not null,
  MENU_REMARK  VARCHAR2(200),
  MENU_NAME_EN VARCHAR2(200),
  MENU_NAME_KR VARCHAR2(200),
  HIGH_MENU_ID VARCHAR2(20),
  MENU_LEVEL   VARCHAR2(2) not null,
  MENU_URL     VARCHAR2(200),
  MENU_DESC    VARCHAR2(500),
  ORD_MENU_ID  VARCHAR2(8),
  USE_YN       VARCHAR2(4) default 'Y',
  LAST_MENU_YN VARCHAR2(4) default 'N', 
  CREATE_DATE  DATE default sysdate,
  CREATE_EMP   VARCHAR2(10) not null,
  MODIFY_DATE  DATE,
  MODIFY_EMP   VARCHAR2(10)
);

-- Add comments to the table
comment on table SYS_MENU_INF
  is '菜单基本信息表';
-- Add comments to the columns
comment on column SYS_MENU_INF.MENU_ID
  is '菜单ID';
comment on column SYS_MENU_INF.MENU_NAME_CN
  is '菜单中文名称';
comment on column SYS_MENU_INF.MENU_REMARK
  is '菜单说明';
comment on column SYS_MENU_INF.MENU_NAME_EN
  is '菜单英文名称';
comment on column SYS_MENU_INF.MENU_NAME_KR
  is '菜单韩文名称';
comment on column SYS_MENU_INF.HIGH_MENU_ID
  is '上级菜单ID';
comment on column SYS_MENU_INF.MENU_LEVEL
  is '菜单级别';
comment on column SYS_MENU_INF.MENU_URL
  is '菜单URL';
comment on column SYS_MENU_INF.MENU_DESC
  is '菜单描述';
comment on column SYS_MENU_INF.ORD_MENU_ID
  is '菜单确认人ID';
comment on column SYS_MENU_INF.USE_YN
  is '是否使用';
comment on column SYS_MENU_INF.LAST_MENU_YN
  is '是否最后一级菜单';
comment on column SYS_MENU_INF.CREATE_DATE
  is '创建日期';
comment on column SYS_MENU_INF.CREATE_EMP
  is '创建人';
comment on column SYS_MENU_INF.MODIFY_DATE
  is '修改日期';
comment on column SYS_MENU_INF.MODIFY_EMP
  is '修改人&