/**
* 菜单基本信息表
*
**/
-- 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 '修改人&