BOS/领域模型对象元数据 / 系统功能菜单（一）

--建表脚本--

create table T_META_CONSOLEDETAIL(

FDETAILFUNCID varchar(50) not null  comment '明细菜单编码'

,FSUBFUNCID varchar(50) not null  comment '模块菜单编码'

,FNUMBER nvarchar(50) not null  comment '明细菜单代码'

,fobjectid varchar(36) not null  comment '业务对象'

,ftype varchar(50) not null  comment '类型'

,fstatus char(1) not null  comment '状态'

,FAuthPMObjectTypeId varchar(180) default '' ''  comment '验证权限的业务对象内码'

,fpermissionitemid varchar(36) not null  comment '权限内码'

,fseq int not null  comment '序号'

,fparam nvarchar(512) default null  comment '参数'

,fcustomparams nvarchar(512) default ''  comment '自定义参数'

,FThumb varchar(80) default null  comment '缩略图'

,FLEVEL int default null  comment '级别'

,FVisible int default -1  comment '可见性'

,FFunctionGroup int default null  comment '分组'

,FHtmlStatus char(1) default ''0''  comment 'html发布状态'

,FExcelStatus char(1) default ''0''  comment 'excel发布状态'

,FH5OBJECTID varchar(36) default null  comment '业务对象h5布局'

,primary key (FDETAILFUNCID)

) comment = '明细功能菜单表'

--查询--

select FDETAILFUNCID as "fdetailfuncid",FSUBFUNCID as "fsubfuncid",FNUMBER as "fnumber",fobjectid as "fobjectid",ftype as "ftype",fstatus as "fstatus",FAuthPMObjectTypeId as "fauthpmobjecttypeid",fpermissionitemid as "fpermissionitemid",fseq as "fseq",fparam as "fparam",fcustomparams as "fcustomparams",FThumb as "fthumb",FLEVEL as "flevel",FVisible as "fvisible",FFunctionGroup as "ffunctiongroup",FHtmlStatus as "fhtmlstatus",FExcelStatus as "fexcelstatus",FH5OBJECTID as "fh5objectid" from T_META_CONSOLEDETAIL

--查询(中文字段)--

select FDETAILFUNCID as "明细菜单编码",FSUBFUNCID as "模块菜单编码",FNUMBER as "明细菜单代码",fobjectid as "业务对象",ftype as "类型",fstatus as "状态",FAuthPMObjectTypeId as "验证权限的业务对象内码",fpermissionitemid as "权限内码",fseq as "序号",fparam as "参数",fcustomparams as "自定义参数",FThumb as "缩略图",FLEVEL as "级别",FVisible as "可见性",FFunctionGroup as "分组",FHtmlStatus as "html发布状态",FExcelStatus as "excel发布状态",FH5OBJECTID as "业务对象h5布局" from T_META_CONSOLEDETAIL

--INSERT脚本--

insert into T_META_CONSOLEDETAIL(FDETAILFUNCID,FSUBFUNCID,FNUMBER,fobjectid,ftype,fstatus,FAuthPMObjectTypeId,fpermissionitemid,fseq,fparam,fcustomparams,FThumb,FLEVEL,FVisible,FFunctionGroup,FHtmlStatus,FExcelStatus,FH5OBJECTID) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)

--UPDATE脚本--

update T_META_CONSOLEDETAIL set FDETAILFUNCID=?,FSUBFUNCID=?,FNUMBER=?,fobjectid=?,ftype=?,fstatus=?,FAuthPMObjectTypeId=?,fpermissionitemid=?,fseq=?,fparam=?,fcustomparams=?,FThumb=?,FLEVEL=?,FVisible=?,FFunctionGroup=?,FHtmlStatus=?,FExcelStatus=?,FH5OBJECTID=? where FDETAILFUNCID=?

--delete脚本--

delete from T_META_CONSOLEDETAIL where FDETAILFUNCID=?

--给字段加备注--

alter table T_META_CONSOLEDETAIL comment '明细功能菜单表';

alter table T_META_CONSOLEDETAIL modify column FDETAILFUNCID varchar(50) not null  comment '明细菜单编码';

alter table T_META_CONSOLEDETAIL modify column FSUBFUNCID varchar(50) not null  comment '模块菜单编码';

alter table T_META_CONSOLEDETAIL modify column FNUMBER nvarchar(50) not null  comment '明细菜单代码';

alter table T_META_CONSOLEDETAIL modify column fobjectid varchar(36) not null  comment '业务对象';

alter table T_META_CONSOLEDETAIL modify column ftype varchar(50) not null  comment '类型';

alter table T_META_CONSOLEDETAIL modify column fstatus char(1) not null  comment '状态';

alter table T_META_CONSOLEDETAIL modify column FAuthPMObjectTypeId varchar(180) default '' ''  comment '验证权限的业务对象内码';

alter table T_META_CONSOLEDETAIL modify column fpermissionitemid varchar(36) not null  comment '权限内码';

alter table T_META_CONSOLEDETAIL modify column fseq int not null  comment '序号';

alter table T_META_CONSOLEDETAIL modify column fparam nvarchar(512) default null  comment '参数';

alter table T_META_CONSOLEDETAIL modify column fcustomparams nvarchar(512) default ''  comment '自定义参数';

alter table T_META_CONSOLEDETAIL modify column FThumb varchar(80) default null  comment '缩略图';

alter table T_META_CONSOLEDETAIL modify column FLEVEL int default null  comment '级别';

alter table T_META_CONSOLEDETAIL modify column FVisible int default -1  comment '可见性';

alter table T_META_CONSOLEDETAIL modify column FFunctionGroup int default null  comment '分组';

alter table T_META_CONSOLEDETAIL modify column FHtmlStatus char(1) default ''0''  comment 'html发布状态';

alter table T_META_CONSOLEDETAIL modify column FExcelStatus char(1) default ''0''  comment 'excel发布状态';

alter table T_META_CONSOLEDETAIL modify column FH5OBJECTID varchar(36) default null  comment '业务对象h5布局';

--建表脚本--

create table T_META_CONSOLEDETAIL_L(

FPKID varchar(36) not null  comment '数据编码'

,FDETAILFUNCID varchar(36) not null  comment '明细菜单编码'

,FLOCALEID int not null  comment '语言'

,FNAME nvarchar(255) not null  comment '名称'

,FDESCRIPTION nvarchar(800) not null  comment '描述'

,primary key (FPKID)

) comment = '明细功能菜单多语言表'

--查询--

select FPKID as "fpkid",FDETAILFUNCID as "fdetailfuncid",FLOCALEID as "flocaleid",FNAME as "fname",FDESCRIPTION as "fdescription" from T_META_CONSOLEDETAIL_L

--查询(中文字段)--

select FPKID as "数据编码",FDETAILFUNCID as "明细菜单编码",FLOCALEID as "语言",FNAME as "名称",FDESCRIPTION as "描述" from T_META_CONSOLEDETAIL_L

--INSERT脚本--

insert into T_META_CONSOLEDETAIL_L(FPKID,FDETAILFUNCID,FLOCALEID,FNAME,FDESCRIPTION) values (?,?,?,?,?)

--UPDATE脚本--

update T_META_CONSOLEDETAIL_L set FPKID=?,FDETAILFUNCID=?,FLOCALEID=?,FNAME=?,FDESCRIPTION=? where FPKID=?

--delete脚本--

delete from T_META_CONSOLEDETAIL_L where FPKID=?

--给字段加备注--

alter table T_META_CONSOLEDETAIL_L comment '明细功能菜单多语言表';

alter table T_META_CONSOLEDETAIL_L modify column FPKID varchar(36) not null  comment '数据编码';

alter table T_META_CONSOLEDETAIL_L modify column FDETAILFUNCID varchar(36) not null  comment '明细菜单编码';

alter table T_META_CONSOLEDETAIL_L modify column FLOCALEID int not null  comment '语言';

alter table T_META_CONSOLEDETAIL_L modify column FNAME nvarchar(255) not null  comment '名称';

alter table T_META_CONSOLEDETAIL_L modify column FDESCRIPTION nvarchar(800) not null  comment '描述';

--建表脚本--

create table T_META_CONSOLESUBFUNC(

FSUBFUNCID varchar(36) not null  comment '模块菜单编码'

,FNUMBER nvarchar(30) not null  comment '模块代码'

,FSUBSYSTEMID nvarchar(36) not null  comment '子系统编码'

,FSEQ int not null  comment '序号'

,FISDEFAULT int not null  comment '是否系统预置'

,primary key (FSUBFUNCID)

) comment = '模块菜单'

--查询--

select FSUBFUNCID as "fsubfuncid",FNUMBER as "fnumber",FSUBSYSTEMID as "fsubsystemid",FSEQ as "fseq",FISDEFAULT as "fisdefault" from T_META_CONSOLESUBFUNC

--查询(中文字段)--

select FSUBFUNCID as "模块菜单编码",FNUMBER as "模块代码",FSUBSYSTEMID as "子系统编码",FSEQ as "序号",FISDEFAULT as "是否系统预置" from T_META_CONSOLESUBFUNC

--INSERT脚本--

insert into T_META_CONSOLESUBFUNC(FSUBFUNCID,FNUMBER,FSUBSYSTEMID,FSEQ,FISDEFAULT) values (?,?,?,?,?)

--UPDATE脚本--

update T_META_CONSOLESUBFUNC set FSUBFUNCID=?,FNUMBER=?,FSUBSYSTEMID=?,FSEQ=?,FISDEFAULT=? where FSUBFUNCID=?

--delete脚本--

delete from T_META_CONSOLESUBFUNC where FSUBFUNCID=?

--给字段加备注--

alter table T_META_CONSOLESUBFUNC comment '模块菜单';

alter table T_META_CONSOLESUBFUNC modify column FSUBFUNCID varchar(36) not null  comment '模块菜单编码';

alter table T_META_CONSOLESUBFUNC modify column FNUMBER nvarchar(30) not null  comment '模块代码';

alter table T_META_CONSOLESUBFUNC modify column FSUBSYSTEMID nvarchar(36) not null  comment '子系统编码';

alter table T_META_CONSOLESUBFUNC modify column FSEQ int not null  comment '序号';

alter table T_META_CONSOLESUBFUNC modify column FISDEFAULT int not null  comment '是否系统预置';

--建表脚本--

create table T_META_CONSOLESUBFUNC_L(

FPKID varchar(36) not null  comment '数据编码'

,FSUBFUNCID varchar(36) not null  comment '模块菜单编码'

,FLOCALEID int not null  comment '语言'

,FNAME nvarchar(255) not null  comment '名称'

,FDESCRIPTION nvarchar(800) not null  comment '描述'

,primary key (FPKID)

) comment = '模块菜单多语言'

--查询--

select FPKID as "fpkid",FSUBFUNCID as "fsubfuncid",FLOCALEID as "flocaleid",FNAME as "fname",FDESCRIPTION as "fdescription" from T_META_CONSOLESUBFUNC_L

--查询(中文字段)--

select FPKID as "数据编码",FSUBFUNCID as "模块菜单编码",FLOCALEID as "语言",FNAME as "名称",FDESCRIPTION as "描述" from T_META_CONSOLESUBFUNC_L

--INSERT脚本--

insert into T_META_CONSOLESUBFUNC_L(FPKID,FSUBFUNCID,FLOCALEID,FNAME,FDESCRIPTION) values (?,?,?,?,?)

--UPDATE脚本--

update T_META_CONSOLESUBFUNC_L set FPKID=?,FSUBFUNCID=?,FLOCALEID=?,FNAME=?,FDESCRIPTION=? where FPKID=?

--delete脚本--

delete from T_META_CONSOLESUBFUNC_L where FPKID=?

--给字段加备注--

alter table T_META_CONSOLESUBFUNC_L comment '模块菜单多语言';

alter table T_META_CONSOLESUBFUNC_L modify column FPKID varchar(36) not null  comment '数据编码';

alter table T_META_CONSOLESUBFUNC_L modify column FSUBFUNCID varchar(36) not null  comment '模块菜单编码';

alter table T_META_CONSOLESUBFUNC_L modify column FLOCALEID int not null  comment '语言';

alter table T_META_CONSOLESUBFUNC_L modify column FNAME nvarchar(255) not null  comment '名称';

alter table T_META_CONSOLESUBFUNC_L modify column FDESCRIPTION nvarchar(800) not null  comment '描述';

--建表脚本--

create table T_META_FUNCDETAIL(

FID varchar(36) not null  comment '功能参数编码'

,FNAME nvarchar(50) default null  comment '名称'

,FOBJECTID varchar(36) default null  comment '调用对象编码'

,FPARAM nvarchar(512) default null  comment '调用参数'

,FTYPE int not null  comment '调用类型'

,primary key (FID)

) comment = '菜单调用参数'

--查询--

select FID as "fid",FNAME as "fname",FOBJECTID as "fobjectid",FPARAM as "fparam",FTYPE as "ftype" from T_META_FUNCDETAIL

--查询(中文字段)--

select FID as "功能参数编码",FNAME as "名称",FOBJECTID as "调用对象编码",FPARAM as "调用参数",FTYPE as "调用类型" from T_META_FUNCDETAIL

--INSERT脚本--

insert into T_META_FUNCDETAIL(FID,FNAME,FOBJECTID,FPARAM,FTYPE) values (?,?,?,?,?)

--UPDATE脚本--

update T_META_FUNCDETAIL set FID=?,FNAME=?,FOBJECTID=?,FPARAM=?,FTYPE=? where FID=?

--delete脚本--

delete from T_META_FUNCDETAIL where FID=?

--给字段加备注--

alter table T_META_FUNCDETAIL comment '菜单调用参数';

alter table T_META_FUNCDETAIL modify column FID varchar(36) not null  comment '功能参数编码';

alter table T_META_FUNCDETAIL modify column FNAME nvarchar(50) default null  comment '名称';

alter table T_META_FUNCDETAIL modify column FOBJECTID varchar(36) default null  comment '调用对象编码';

alter table T_META_FUNCDETAIL modify column FPARAM nvarchar(512) default null  comment '调用参数';

alter table T_META_FUNCDETAIL modify column FTYPE int not null  comment '调用类型';