BOS-领域元模型

--建表脚本--

create table T_MDL_DBTYPE(

FDBTYPEID int not null  comment '值类型编码'

,FDBTYPENAME varchar(25) not null  comment '类型名称'

,FSQLSTORAGETYPE int default null  comment 'ms sql对应编码'

,FSQLSTORAGETYPENAME varchar(25) default null  comment 'ms sql对应名称'

,primary key (FDBTYPEID)

) comment = '值类型描述'

--查询--

select FDBTYPEID as "fdbtypeid",FDBTYPENAME as "fdbtypename",FSQLSTORAGETYPE as "fsqlstoragetype",FSQLSTORAGETYPENAME as "fsqlstoragetypename" from T_MDL_DBTYPE

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

select FDBTYPEID as "值类型编码",FDBTYPENAME as "类型名称",FSQLSTORAGETYPE as "ms sql对应编码",FSQLSTORAGETYPENAME as "ms sql对应名称" from T_MDL_DBTYPE

--INSERT脚本--

insert into T_MDL_DBTYPE(FDBTYPEID,FDBTYPENAME,FSQLSTORAGETYPE,FSQLSTORAGETYPENAME) values (?,?,?,?)

--UPDATE脚本--

update T_MDL_DBTYPE set FDBTYPEID=?,FDBTYPENAME=?,FSQLSTORAGETYPE=?,FSQLSTORAGETYPENAME=? where FDBTYPEID=?

--delete脚本--

delete from T_MDL_DBTYPE where FDBTYPEID=?

--给字段加备注--

alter table T_MDL_DBTYPE comment '值类型描述';

alter table T_MDL_DBTYPE modify column FDBTYPEID int not null  comment '值类型编码';

alter table T_MDL_DBTYPE modify column FDBTYPENAME varchar(25) not null  comment '类型名称';

alter table T_MDL_DBTYPE modify column FSQLSTORAGETYPE int default null  comment 'ms sql对应编码';

alter table T_MDL_DBTYPE modify column FSQLSTORAGETYPENAME varchar(25) default null  comment 'ms sql对应名称';

--建表脚本--

create table T_MDL_DOMAINMODELELEMENTMAP(

FENTRYID int not null  comment '主键'

,FID int not null  comment '领域模型类型编码'

,FELEMENTTYPEID int not null  comment '元素类型'

,FELEMENTGROUPID int not null  comment '元素分组编码'

,FSEQ int not null  comment '显示顺序'

,primary key (FENTRYID)

) comment = '领域模型-元素关系映射'

--查询--

select FENTRYID as "fentryid",FID as "fid",FELEMENTTYPEID as "felementtypeid",FELEMENTGROUPID as "felementgroupid",FSEQ as "fseq" from T_MDL_DOMAINMODELELEMENTMAP

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

select FENTRYID as "主键",FID as "领域模型类型编码",FELEMENTTYPEID as "元素类型",FELEMENTGROUPID as "元素分组编码",FSEQ as "显示顺序" from T_MDL_DOMAINMODELELEMENTMAP

--INSERT脚本--

insert into T_MDL_DOMAINMODELELEMENTMAP(FENTRYID,FID,FELEMENTTYPEID,FELEMENTGROUPID,FSEQ) values (?,?,?,?,?)

--UPDATE脚本--

update T_MDL_DOMAINMODELELEMENTMAP set FENTRYID=?,FID=?,FELEMENTTYPEID=?,FELEMENTGROUPID=?,FSEQ=? where FENTRYID=?

--delete脚本--

delete from T_MDL_DOMAINMODELELEMENTMAP where FENTRYID=?

--给字段加备注--

alter table T_MDL_DOMAINMODELELEMENTMAP comment '领域模型-元素关系映射';

alter table T_MDL_DOMAINMODELELEMENTMAP modify column FENTRYID int not null  comment '主键';

alter table T_MDL_DOMAINMODELELEMENTMAP modify column FID int not null  comment '领域模型类型编码';

alter table T_MDL_DOMAINMODELELEMENTMAP modify column FELEMENTTYPEID int not null  comment '元素类型';

alter table T_MDL_DOMAINMODELELEMENTMAP modify column FELEMENTGROUPID int not null  comment '元素分组编码';

alter table T_MDL_DOMAINMODELELEMENTMAP modify column FSEQ int not null  comment '显示顺序';

--建表脚本--

create table T_MDL_DOMAINMODELELPROPMAP(

FDETAILID int not null  comment '主键'

,FENTRYID int not null  comment '检索外键'

,FELEMENTPROPERTYID int not null  comment '属性编码'

,FDEFAULTVALUE nvarchar(50) default ''  comment '属性默认值'

,FSEQ int not null  comment '显示顺序'

,primary key (FDETAILID)

) comment = '领域模型-元素-属性关系映射'

--查询--

select FDETAILID as "fdetailid",FENTRYID as "fentryid",FELEMENTPROPERTYID as "felementpropertyid",FDEFAULTVALUE as "fdefaultvalue",FSEQ as "fseq" from T_MDL_DOMAINMODELELPROPMAP

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

select FDETAILID as "主键",FENTRYID as "检索外键",FELEMENTPROPERTYID as "属性编码",FDEFAULTVALUE as "属性默认值",FSEQ as "显示顺序" from T_MDL_DOMAINMODELELPROPMAP

--INSERT脚本--

insert into T_MDL_DOMAINMODELELPROPMAP(FDETAILID,FENTRYID,FELEMENTPROPERTYID,FDEFAULTVALUE,FSEQ) values (?,?,?,?,?)

--UPDATE脚本--

update T_MDL_DOMAINMODELELPROPMAP set FDETAILID=?,FENTRYID=?,FELEMENTPROPERTYID=?,FDEFAULTVALUE=?,FSEQ=? where FDETAILID=?

--delete脚本--

delete from T_MDL_DOMAINMODELELPROPMAP where FDETAILID=?

--给字段加备注--

alter table T_MDL_DOMAINMODELELPROPMAP comment '领域模型-元素-属性关系映射';

alter table T_MDL_DOMAINMODELELPROPMAP modify column FDETAILID int not null  comment '主键';

alter table T_MDL_DOMAINMODELELPROPMAP modify column FENTRYID int not null  comment '检索外键';

alter table T_MDL_DOMAINMODELELPROPMAP modify column FELEMENTPROPERTYID int not null  comment '属性编码';

alter table T_MDL_DOMAINMODELELPROPMAP modify column FDEFAULTVALUE nvarchar(50) default ''  comment '属性默认值';

alter table T_MDL_DOMAINMODELELPROPMAP modify column FSEQ int not null  comment '显示顺序';

--建表脚本--

create table T_MDL_DOMAINMODELSUB(

FSUBMODELTYPEID int not null  comment '子领域编码'

,FMODELCLASS varchar(150) default null  comment 'model层实现类'

,FVIEWCLASS varchar(150) default null  comment 'view层实现类'

,FCONTROLLER varchar(150) default null  comment 'controller层实现类'

,FMODELEVENTPROXY varchar(150) default null  comment 'model插件代理'

,FVIEWEVENTPROXY varchar(150) default null  comment 'view插件代理'

,FSUBDESIGNERCLASS varchar(150) default null  comment '设计器'

,FIMGKEY varchar(30) default null  comment '图标'

,FID int default null  comment '领域编码'

,primary key (FSUBMODELTYPEID)

) comment = '子领域'

--查询--

select FSUBMODELTYPEID as "fsubmodeltypeid",FMODELCLASS as "fmodelclass",FVIEWCLASS as "fviewclass",FCONTROLLER as "fcontroller",FMODELEVENTPROXY as "fmodeleventproxy",FVIEWEVENTPROXY as "fvieweventproxy",FSUBDESIGNERCLASS as "fsubdesignerclass",FIMGKEY as "fimgkey",FID as "fid" from T_MDL_DOMAINMODELSUB

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

select FSUBMODELTYPEID as "子领域编码",FMODELCLASS as "model层实现类",FVIEWCLASS as "view层实现类",FCONTROLLER as "controller层实现类",FMODELEVENTPROXY as "model插件代理",FVIEWEVENTPROXY as "view插件代理",FSUBDESIGNERCLASS as "设计器",FIMGKEY as "图标",FID as "领域编码" from T_MDL_DOMAINMODELSUB

--INSERT脚本--

insert into T_MDL_DOMAINMODELSUB(FSUBMODELTYPEID,FMODELCLASS,FVIEWCLASS,FCONTROLLER,FMODELEVENTPROXY,FVIEWEVENTPROXY,FSUBDESIGNERCLASS,FIMGKEY,FID) values (?,?,?,?,?,?,?,?,?)

--UPDATE脚本--

update T_MDL_DOMAINMODELSUB set FSUBMODELTYPEID=?,FMODELCLASS=?,FVIEWCLASS=?,FCONTROLLER=?,FMODELEVENTPROXY=?,FVIEWEVENTPROXY=?,FSUBDESIGNERCLASS=?,FIMGKEY=?,FID=? where FSUBMODELTYPEID=?

--delete脚本--

delete from T_MDL_DOMAINMODELSUB where FSUBMODELTYPEID=?

--给字段加备注--

alter table T_MDL_DOMAINMODELSUB comment '子领域';

alter table T_MDL_DOMAINMODELSUB modify column FSUBMODELTYPEID int not null  comment '子领域编码';

alter table T_MDL_DOMAINMODELSUB modify column FMODELCLASS varchar(150) default null  comment 'model层实现类';

alter table T_MDL_DOMAINMODELSUB modify column FVIEWCLASS varchar(150) default null  comment 'view层实现类';

alter table T_MDL_DOMAINMODELSUB modify column FCONTROLLER varchar(150) default null  comment 'controller层实现类';

alter table T_MDL_DOMAINMODELSUB modify column FMODELEVENTPROXY varchar(150) default null  comment 'model插件代理';

alter table T_MDL_DOMAINMODELSUB modify column FVIEWEVENTPROXY varchar(150) default null  comment 'view插件代理';

alter table T_MDL_DOMAINMODELSUB modify column FSUBDESIGNERCLASS varchar(150) default null  comment '设计器';

alter table T_MDL_DOMAINMODELSUB modify column FIMGKEY varchar(30) default null  comment '图标';

alter table T_MDL_DOMAINMODELSUB modify column FID int default null  comment '领域编码';

--建表脚本--

create table T_MDL_DOMAINMODETYPE_L(

FPKID int not null  comment '主键'

,FID int not null  comment '领域模型编码'

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

,FLOCALEID int default null  comment '语言'

,primary key (FPKID)

) comment = '领域模型类型多语言'

--查询--

select FPKID as "fpkid",FID as "fid",FNAME as "fname",FLOCALEID as "flocaleid" from T_MDL_DOMAINMODETYPE_L

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

select FPKID as "主键",FID as "领域模型编码",FNAME as "名称",FLOCALEID as "语言" from T_MDL_DOMAINMODETYPE_L

--INSERT脚本--

insert into T_MDL_DOMAINMODETYPE_L(FPKID,FID,FNAME,FLOCALEID) values (?,?,?,?)

--UPDATE脚本--

update T_MDL_DOMAINMODETYPE_L set FPKID=?,FID=?,FNAME=?,FLOCALEID=? where FPKID=?

--delete脚本--

delete from T_MDL_DOMAINMODETYPE_L where FPKID=?

--给字段加备注--

alter table T_MDL_DOMAINMODETYPE_L comment '领域模型类型多语言';

alter table T_MDL_DOMAINMODETYPE_L modify column FPKID int not null  comment '主键';

alter table T_MDL_DOMAINMODETYPE_L modify column FID int not null  comment '领域模型编码';

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

alter table T_MDL_DOMAINMODETYPE_L modify column FLOCALEID int default null  comment '语言';

--建表脚本--

create table T_MDL_ELEMENTGROUP(

FID int not null  comment '内码'

,FIMGKEY varchar(30) default null  comment '工具栏图标'

,primary key (FID)

) comment = '元素分组'

--查询--

select FID as "fid",FIMGKEY as "fimgkey" from T_MDL_ELEMENTGROUP

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

select FID as "内码",FIMGKEY as "工具栏图标" from T_MDL_ELEMENTGROUP

--INSERT脚本--

insert into T_MDL_ELEMENTGROUP(FID,FIMGKEY) values (?,?)

--UPDATE脚本--

update T_MDL_ELEMENTGROUP set FID=?,FIMGKEY=? where FID=?

--delete脚本--

delete from T_MDL_ELEMENTGROUP where FID=?

--给字段加备注--

alter table T_MDL_ELEMENTGROUP comment '元素分组';

alter table T_MDL_ELEMENTGROUP modify column FID int not null  comment '内码';

alter table T_MDL_ELEMENTGROUP modify column FIMGKEY varchar(30) default null  comment '工具栏图标';

--建表脚本--

create table T_MDL_ELEMENTPROPERTY(

FID int not null  comment '属性编码'

,FFIELDNAME varchar(30) default null  comment '字段名'

,FPROPERTYNAME varchar(30) not null  comment '属性名'

,FVALUETYPE int not null  comment '值类型'

,FVISIBLE int not null  comment '可见性'

,FLOCK int not null  comment '锁定性'

,FCHECKRULE nvarchar(510) default null  comment '保存检查规则'

,FBINDINGFLAGS int default null  comment '绑定类型'

,FPROPCLASS varchar(150) default null  comment '属性编辑器'

,FAFTERCLASS varchar(150) default null  comment '值校验组件'

,FPROPERTYGROUPID int not null  comment '属性分组'

,FEXTPROPERTY int not null  comment '扩展属性'

,FMULLANGUAGE int not null  comment '多语言属性'

,FLISTITEMELEMENTTYPE int default null  comment '列表元素类型'

,FLISTITEMLINKFIELD varchar(30) default null  comment '列表链接字段'

,FIMPORTLEVEL int not null  comment '属性的重要性级别'

,primary key (FID)

) comment = '元素属性'

--查询--

select FID as "fid",FFIELDNAME as "ffieldname",FPROPERTYNAME as "fpropertyname",FVALUETYPE as "fvaluetype",FVISIBLE as "fvisible",FLOCK as "flock",FCHECKRULE as "fcheckrule",FBINDINGFLAGS as "fbindingflags",FPROPCLASS as "fpropclass",FAFTERCLASS as "fafterclass",FPROPERTYGROUPID as "fpropertygroupid",FEXTPROPERTY as "fextproperty",FMULLANGUAGE as "fmullanguage",FLISTITEMELEMENTTYPE as "flistitemelementtype",FLISTITEMLINKFIELD as "flistitemlinkfield",FIMPORTLEVEL as "fimportlevel" from T_MDL_ELEMENTPROPERTY

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

select FID as "属性编码",FFIELDNAME as "字段名",FPROPERTYNAME as "属性名",FVALUETYPE as "值类型",FVISIBLE as "可见性",FLOCK as "锁定性",FCHECKRULE as "保存检查规则",FBINDINGFLAGS as "绑定类型",FPROPCLASS as "属性编辑器",FAFTERCLASS as "值校验组件",FPROPERTYGROUPID as "属性分组",FEXTPROPERTY as "扩展属性",FMULLANGUAGE as "多语言属性",FLISTITEMELEMENTTYPE as "列表元素类型",FLISTITEMLINKFIELD as "列表链接字段",FIMPORTLEVEL as "属性的重要性级别" from T_MDL_ELEMENTPROPERTY

--INSERT脚本--

insert into T_MDL_ELEMENTPROPERTY(FID,FFIELDNAME,FPROPERTYNAME,FVALUETYPE,FVISIBLE,FLOCK,FCHECKRULE,FBINDINGFLAGS,FPROPCLASS,FAFTERCLASS,FPROPERTYGROUPID,FEXTPROPERTY,FMULLANGUAGE,FLISTITEMELEMENTTYPE,FLISTITEMLINKFIELD,FIMPORTLEVEL) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)

--UPDATE脚本--

update T_MDL_ELEMENTPROPERTY set FID=?,FFIELDNAME=?,FPROPERTYNAME=?,FVALUETYPE=?,FVISIBLE=?,FLOCK=?,FCHECKRULE=?,FBINDINGFLAGS=?,FPROPCLASS=?,FAFTERCLASS=?,FPROPERTYGROUPID=?,FEXTPROPERTY=?,FMULLANGUAGE=?,FLISTITEMELEMENTTYPE=?,FLISTITEMLINKFIELD=?,FIMPORTLEVEL=? where FID=?

--delete脚本--

delete from T_MDL_ELEMENTPROPERTY where FID=?

--给字段加备注--

alter table T_MDL_ELEMENTPROPERTY comment '元素属性';

alter table T_MDL_ELEMENTPROPERTY modify column FID int not null  comment '属性编码';

alter table T_MDL_ELEMENTPROPERTY modify column FFIELDNAME varchar(30) default null  comment '字段名';

alter table T_MDL_ELEMENTPROPERTY modify column FPROPERTYNAME varchar(30) not null  comment '属性名';

alter table T_MDL_ELEMENTPROPERTY modify column FVALUETYPE int not null  comment '值类型';

alter table T_MDL_ELEMENTPROPERTY modify column FVISIBLE int not null  comment '可见性';

alter table T_MDL_ELEMENTPROPERTY modify column FLOCK int not null  comment '锁定性';

alter table T_MDL_ELEMENTPROPERTY modify column FCHECKRULE nvarchar(510) default null  comment '保存检查规则';

alter table T_MDL_ELEMENTPROPERTY modify column FBINDINGFLAGS int default null  comment '绑定类型';

alter table T_MDL_ELEMENTPROPERTY modify column FPROPCLASS varchar(150) default null  comment '属性编辑器';

alter table T_MDL_ELEMENTPROPERTY modify column FAFTERCLASS varchar(150) default null  comment '值校验组件';

alter table T_MDL_ELEMENTPROPERTY modify column FPROPERTYGROUPID int not null  comment '属性分组';

alter table T_MDL_ELEMENTPROPERTY modify column FEXTPROPERTY int not null  comment '扩展属性';

alter table T_MDL_ELEMENTPROPERTY modify column FMULLANGUAGE int not null  comment '多语言属性';

alter table T_MDL_ELEMENTPROPERTY modify column FLISTITEMELEMENTTYPE int default null  comment '列表元素类型';

alter table T_MDL_ELEMENTPROPERTY modify column FLISTITEMLINKFIELD varchar(30) default null  comment '列表链接字段';

alter table T_MDL_ELEMENTPROPERTY modify column FIMPORTLEVEL int not null  comment '属性的重要性级别';

--建表脚本--

create table T_MDL_ELEMENTPROPERTYGROUP(

FID int not null  comment '内码'

,FLOCALEID int not null  comment '语言'

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

,primary key (FID,FLOCALEID)

) comment = '元素属性分组'

--查询--

select FID as "fid",FLOCALEID as "flocaleid",FNAME as "fname" from T_MDL_ELEMENTPROPERTYGROUP

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

select FID as "内码",FLOCALEID as "语言",FNAME as "名称" from T_MDL_ELEMENTPROPERTYGROUP

--INSERT脚本--

insert into T_MDL_ELEMENTPROPERTYGROUP(FID,FLOCALEID,FNAME) values (?,?,?)

--UPDATE脚本--

update T_MDL_ELEMENTPROPERTYGROUP set FID=?,FLOCALEID=?,FNAME=? where FID=? AND FLOCALEID=?

--delete脚本--

delete from T_MDL_ELEMENTPROPERTYGROUP where FID=? AND FLOCALEID=?

--给字段加备注--

alter table T_MDL_ELEMENTPROPERTYGROUP comment '元素属性分组';

alter table T_MDL_ELEMENTPROPERTYGROUP modify column FID int not null  comment '内码';

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

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

--建表脚本--

create table T_MDL_ELEMENTTYPE(

FID int not null  comment '元素类别'

,FIMGKEY varchar(30) default null  comment '工具栏图标'

,FTYPEID int not null  comment '元素类型'

,FISVISIBLE int not null  comment '可见性'

,FELEMENTCLASS varchar(150) default null  comment '逻辑类'

,FAPPEARANCECLASS varchar(150) default null  comment '外观类'

,FTABLENAME varchar(30) default null  comment '表名'

,FBASEELEMENTTYPEID int default null  comment '基本元素类型内码'

,primary key (FID)

) comment = '元素类型'

--查询--

select FID as "fid",FIMGKEY as "fimgkey",FTYPEID as "ftypeid",FISVISIBLE as "fisvisible",FELEMENTCLASS as "felementclass",FAPPEARANCECLASS as "fappearanceclass",FTABLENAME as "ftablename",FBASEELEMENTTYPEID as "fbaseelementtypeid" from T_MDL_ELEMENTTYPE

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

select FID as "元素类别",FIMGKEY as "工具栏图标",FTYPEID as "元素类型",FISVISIBLE as "可见性",FELEMENTCLASS as "逻辑类",FAPPEARANCECLASS as "外观类",FTABLENAME as "表名",FBASEELEMENTTYPEID as "基本元素类型内码" from T_MDL_ELEMENTTYPE

--INSERT脚本--

insert into T_MDL_ELEMENTTYPE(FID,FIMGKEY,FTYPEID,FISVISIBLE,FELEMENTCLASS,FAPPEARANCECLASS,FTABLENAME,FBASEELEMENTTYPEID) values (?,?,?,?,?,?,?,?)

--UPDATE脚本--

update T_MDL_ELEMENTTYPE set FID=?,FIMGKEY=?,FTYPEID=?,FISVISIBLE=?,FELEMENTCLASS=?,FAPPEARANCECLASS=?,FTABLENAME=?,FBASEELEMENTTYPEID=? where FID=?

--delete脚本--

delete from T_MDL_ELEMENTTYPE where FID=?

--给字段加备注--

alter table T_MDL_ELEMENTTYPE comment '元素类型';

alter table T_MDL_ELEMENTTYPE modify column FID int not null  comment '元素类别';

alter table T_MDL_ELEMENTTYPE modify column FIMGKEY varchar(30) default null  comment '工具栏图标';

alter table T_MDL_ELEMENTTYPE modify column FTYPEID int not null  comment '元素类型';

alter table T_MDL_ELEMENTTYPE modify column FISVISIBLE int not null  comment '可见性';

alter table T_MDL_ELEMENTTYPE modify column FELEMENTCLASS varchar(150) default null  comment '逻辑类';

alter table T_MDL_ELEMENTTYPE modify column FAPPEARANCECLASS varchar(150) default null  comment '外观类';

alter table T_MDL_ELEMENTTYPE modify column FTABLENAME varchar(30) default null  comment '表名';

alter table T_MDL_ELEMENTTYPE modify column FBASEELEMENTTYPEID int default null  comment '基本元素类型内码';