BOS-平台数据（1）

--建表脚本--

create table T_MDL_FILTERCONDITION(

FID int not null  comment '编码'

,FCONDITIONTYPEID int not null  comment '符号集编码'

,FSeq int not null  comment '排列顺序'

,FOPERATE varchar(50) default null  comment '实际比较符'

,FINPUTCTLTYPE int not null  comment '比较值控件类型'

,FDATASOURCETYPE int not null  comment '比较值来源类型'

,FDATAFIELDINDEX int not null  comment '数据字段索引'

,FVALUE nvarchar(50) default null  comment '值'

,FINPUT int default null  comment '允许录入'

,FCLASSNAME varchar(150) default null  comment '取值插件类'

,FISCUST char(1) default null  comment '是否自定义'

,primary key (FID)

) comment = '过滤比较符号集'

--查询--

select FID as "fid",FCONDITIONTYPEID as "fconditiontypeid",FSeq as "fseq",FOPERATE as "foperate",FINPUTCTLTYPE as "finputctltype",FDATASOURCETYPE as "fdatasourcetype",FDATAFIELDINDEX as "fdatafieldindex",FVALUE as "fvalue",FINPUT as "finput",FCLASSNAME as "fclassname",FISCUST as "fiscust" from T_MDL_FILTERCONDITION

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

select FID as "编码",FCONDITIONTYPEID as "符号集编码",FSeq as "排列顺序",FOPERATE as "实际比较符",FINPUTCTLTYPE as "比较值控件类型",FDATASOURCETYPE as "比较值来源类型",FDATAFIELDINDEX as "数据字段索引",FVALUE as "值",FINPUT as "允许录入",FCLASSNAME as "取值插件类",FISCUST as "是否自定义" from T_MDL_FILTERCONDITION

--INSERT脚本--

insert into T_MDL_FILTERCONDITION(FID,FCONDITIONTYPEID,FSeq,FOPERATE,FINPUTCTLTYPE,FDATASOURCETYPE,FDATAFIELDINDEX,FVALUE,FINPUT,FCLASSNAME,FISCUST) values (?,?,?,?,?,?,?,?,?,?,?)

--UPDATE脚本--

update T_MDL_FILTERCONDITION set FID=?,FCONDITIONTYPEID=?,FSeq=?,FOPERATE=?,FINPUTCTLTYPE=?,FDATASOURCETYPE=?,FDATAFIELDINDEX=?,FVALUE=?,FINPUT=?,FCLASSNAME=?,FISCUST=? where FID=?

--delete脚本--

delete from T_MDL_FILTERCONDITION where FID=?

--给字段加备注--

alter table T_MDL_FILTERCONDITION comment '过滤比较符号集';

alter table T_MDL_FILTERCONDITION modify column FID int not null  comment '编码';

alter table T_MDL_FILTERCONDITION modify column FCONDITIONTYPEID int not null  comment '符号集编码';

alter table T_MDL_FILTERCONDITION modify column FSeq int not null  comment '排列顺序';

alter table T_MDL_FILTERCONDITION modify column FOPERATE varchar(50) default null  comment '实际比较符';

alter table T_MDL_FILTERCONDITION modify column FINPUTCTLTYPE int not null  comment '比较值控件类型';

alter table T_MDL_FILTERCONDITION modify column FDATASOURCETYPE int not null  comment '比较值来源类型';

alter table T_MDL_FILTERCONDITION modify column FDATAFIELDINDEX int not null  comment '数据字段索引';

alter table T_MDL_FILTERCONDITION modify column FVALUE nvarchar(50) default null  comment '值';

alter table T_MDL_FILTERCONDITION modify column FINPUT int default null  comment '允许录入';

alter table T_MDL_FILTERCONDITION modify column FCLASSNAME varchar(150) default null  comment '取值插件类';

alter table T_MDL_FILTERCONDITION modify column FISCUST char(1) default null  comment '是否自定义';

--建表脚本--

create table T_MDL_FORMBUSINESSPARAMS(

FParamID int not null  comment '参数编码'

,FACTIONID int not null  comment '表单服务编码'

,FSEQ int not null  comment '顺序'

,FOPTION int not null  comment '选项'

,FNAME varchar(50) not null  comment '名称'

,FFIELDTYPE varchar(250) not null  comment '适用字段'

,primary key (FParamID)

) comment = '可选表单服务的参数'

--查询--

select FParamID as "fparamid",FACTIONID as "factionid",FSEQ as "fseq",FOPTION as "foption",FNAME as "fname",FFIELDTYPE as "ffieldtype" from T_MDL_FORMBUSINESSPARAMS

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

select FParamID as "参数编码",FACTIONID as "表单服务编码",FSEQ as "顺序",FOPTION as "选项",FNAME as "名称",FFIELDTYPE as "适用字段" from T_MDL_FORMBUSINESSPARAMS

--INSERT脚本--

insert into T_MDL_FORMBUSINESSPARAMS(FParamID,FACTIONID,FSEQ,FOPTION,FNAME,FFIELDTYPE) values (?,?,?,?,?,?)

--UPDATE脚本--

update T_MDL_FORMBUSINESSPARAMS set FParamID=?,FACTIONID=?,FSEQ=?,FOPTION=?,FNAME=?,FFIELDTYPE=? where FParamID=?

--delete脚本--

delete from T_MDL_FORMBUSINESSPARAMS where FParamID=?

--给字段加备注--

alter table T_MDL_FORMBUSINESSPARAMS comment '可选表单服务的参数';

alter table T_MDL_FORMBUSINESSPARAMS modify column FParamID int not null  comment '参数编码';

alter table T_MDL_FORMBUSINESSPARAMS modify column FACTIONID int not null  comment '表单服务编码';

alter table T_MDL_FORMBUSINESSPARAMS modify column FSEQ int not null  comment '顺序';

alter table T_MDL_FORMBUSINESSPARAMS modify column FOPTION int not null  comment '选项';

alter table T_MDL_FORMBUSINESSPARAMS modify column FNAME varchar(50) not null  comment '名称';

alter table T_MDL_FORMBUSINESSPARAMS modify column FFIELDTYPE varchar(250) not null  comment '适用字段';

--建表脚本--

create table T_MDL_FORMFUNCTION(

FID int not null  comment '函数编码'

,FName varchar(50) not null  comment '函数'

,FDATATYPE varchar(50) not null  comment '适用数据类型'

,FELEMENTIDS varchar(200) default null  comment '元素id集合'

,FSAMPLE varchar(100) default null  comment '示例'

,FSETCOMPONENT varchar(150) default null  comment '配置组件'

,primary key (FID)

) comment = '可选表单函数'

--查询--

select FID as "fid",FName as "fname",FDATATYPE as "fdatatype",FELEMENTIDS as "felementids",FSAMPLE as "fsample",FSETCOMPONENT as "fsetcomponent" from T_MDL_FORMFUNCTION

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

select FID as "函数编码",FName as "函数",FDATATYPE as "适用数据类型",FELEMENTIDS as "元素id集合",FSAMPLE as "示例",FSETCOMPONENT as "配置组件" from T_MDL_FORMFUNCTION

--INSERT脚本--

insert into T_MDL_FORMFUNCTION(FID,FName,FDATATYPE,FELEMENTIDS,FSAMPLE,FSETCOMPONENT) values (?,?,?,?,?,?)

--UPDATE脚本--

update T_MDL_FORMFUNCTION set FID=?,FName=?,FDATATYPE=?,FELEMENTIDS=?,FSAMPLE=?,FSETCOMPONENT=? where FID=?

--delete脚本--

delete from T_MDL_FORMFUNCTION where FID=?

--给字段加备注--

alter table T_MDL_FORMFUNCTION comment '可选表单函数';

alter table T_MDL_FORMFUNCTION modify column FID int not null  comment '函数编码';

alter table T_MDL_FORMFUNCTION modify column FName varchar(50) not null  comment '函数';

alter table T_MDL_FORMFUNCTION modify column FDATATYPE varchar(50) not null  comment '适用数据类型';

alter table T_MDL_FORMFUNCTION modify column FELEMENTIDS varchar(200) default null  comment '元素id集合';

alter table T_MDL_FORMFUNCTION modify column FSAMPLE varchar(100) default null  comment '示例';

alter table T_MDL_FORMFUNCTION modify column FSETCOMPONENT varchar(150) default null  comment '配置组件';

--建表脚本--

create table T_MDL_FORMFUNCTION_L(

FPKID int not null  comment '主键'

,FID int not null  comment '函数编码'

,FLOCALEID int not null  comment '语言'

,FDesc nvarchar(100) default null  comment '描述'

,primary key (FPKID)

) comment = '可选表单函数多语言'

--查询--

select FPKID as "fpkid",FID as "fid",FLOCALEID as "flocaleid",FDesc as "fdesc" from T_MDL_FORMFUNCTION_L

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

select FPKID as "主键",FID as "函数编码",FLOCALEID as "语言",FDesc as "描述" from T_MDL_FORMFUNCTION_L

--INSERT脚本--

insert into T_MDL_FORMFUNCTION_L(FPKID,FID,FLOCALEID,FDesc) values (?,?,?,?)

--UPDATE脚本--

update T_MDL_FORMFUNCTION_L set FPKID=?,FID=?,FLOCALEID=?,FDesc=? where FPKID=?

--delete脚本--

delete from T_MDL_FORMFUNCTION_L where FPKID=?

--给字段加备注--

alter table T_MDL_FORMFUNCTION_L comment '可选表单函数多语言';

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

alter table T_MDL_FORMFUNCTION_L modify column FID int not null  comment '函数编码';

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

alter table T_MDL_FORMFUNCTION_L modify column FDesc nvarchar(100) default null  comment '描述';

--建表脚本--

create table T_MDL_FORMMENUTPL(

FELEMENTTYPE int not null  comment '元素类型'

,FMENUID varchar(36) not null  comment '菜单组编码'

,FID varchar(36) not null  comment '模版编码'

,FISCUSTOM int not null  comment '用户自定义'

,FXML xml default null  comment '模板baritem定义'

,primary key (FELEMENTTYPE,FMENUID)

) comment = '菜单模版'

--查询--

select FELEMENTTYPE as "felementtype",FMENUID as "fmenuid",FID as "fid",FISCUSTOM as "fiscustom",FXML as "fxml" from T_MDL_FORMMENUTPL

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

select FELEMENTTYPE as "元素类型",FMENUID as "菜单组编码",FID as "模版编码",FISCUSTOM as "用户自定义",FXML as "模板baritem定义" from T_MDL_FORMMENUTPL

--INSERT脚本--

insert into T_MDL_FORMMENUTPL(FELEMENTTYPE,FMENUID,FID,FISCUSTOM,FXML) values (?,?,?,?,?)

--UPDATE脚本--

update T_MDL_FORMMENUTPL set FELEMENTTYPE=?,FMENUID=?,FID=?,FISCUSTOM=?,FXML=? where FELEMENTTYPE=? AND FMENUID=?

--delete脚本--

delete from T_MDL_FORMMENUTPL where FELEMENTTYPE=? AND FMENUID=?

--给字段加备注--

alter table T_MDL_FORMMENUTPL comment '菜单模版';

alter table T_MDL_FORMMENUTPL modify column FELEMENTTYPE int not null  comment '元素类型';

alter table T_MDL_FORMMENUTPL modify column FMENUID varchar(36) not null  comment '菜单组编码';

alter table T_MDL_FORMMENUTPL modify column FID varchar(36) not null  comment '模版编码';

alter table T_MDL_FORMMENUTPL modify column FISCUSTOM int not null  comment '用户自定义';

alter table T_MDL_FORMMENUTPL modify column FXML xml default null  comment '模板baritem定义';

--建表脚本--

create table T_MDL_FORMMENUTPL_L(

FID varchar(36) not null  comment '模版编码'

,FLocaleID int not null  comment '语言'

,FXML xml default null  comment '多语言'

,primary key (FID,FLocaleID)

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

--查询--

select FID as "fid",FLocaleID as "flocaleid",FXML as "fxml" from T_MDL_FORMMENUTPL_L

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

select FID as "模版编码",FLocaleID as "语言",FXML as "多语言" from T_MDL_FORMMENUTPL_L

--INSERT脚本--

insert into T_MDL_FORMMENUTPL_L(FID,FLocaleID,FXML) values (?,?,?)

--UPDATE脚本--

update T_MDL_FORMMENUTPL_L set FID=?,FLocaleID=?,FXML=? where FID=? AND FLocaleID=?

--delete脚本--

delete from T_MDL_FORMMENUTPL_L where FID=? AND FLocaleID=?

--给字段加备注--

alter table T_MDL_FORMMENUTPL_L comment '菜单模版多语言';

alter table T_MDL_FORMMENUTPL_L modify column FID varchar(36) not null  comment '模版编码';

alter table T_MDL_FORMMENUTPL_L modify column FLocaleID int not null  comment '语言';

alter table T_MDL_FORMMENUTPL_L modify column FXML xml default null  comment '多语言';

--建表脚本--

create table T_MDL_FORMOPERATIONTYPE(

FID int not null  comment '表单操作编码'

,FOPERATION varchar(30) not null  comment '表单操作标示'

,FISCONFIRM int not null  comment '是否给出提示'

,FRESOURCE nvarchar(250) default null  comment '资源'

,FENABLEDSTATE varchar(50) default null  comment '可用状态'

,FOPERELEIDS varchar(100) default null  comment '适用元素类型'

,FSERVICECLASS varchar(150) not null  comment '运行组件'

,FDESIGNERCLASS varchar(150) default null  comment '设计组件'

,FTOPCLASSIDS varchar(150) not null  comment '适用的业务领域'

,FAPPSCENARIOTYPE int not null  comment '应用场景类型'

,FISSupportWF char(1) not null  comment '是否支持工作流动作'

,FSERVICEINVOKECLASS varchar(150) default null  comment '运行服务调用组件'

,FSERVICECLASSEXT varchar(150) default null  comment '扩展的运行组件'

,FWEBSERVICECLASS varchar(150) default null  comment 'web服务组件'

,FWEBDESIGNERCLASS varchar(150) default null  comment 'web服务设计组件'

,primary key (FID)

) comment = '可选表单操作'

--查询--

select FID as "fid",FOPERATION as "foperation",FISCONFIRM as "fisconfirm",FRESOURCE as "fresource",FENABLEDSTATE as "fenabledstate",FOPERELEIDS as "fopereleids",FSERVICECLASS as "fserviceclass",FDESIGNERCLASS as "fdesignerclass",FTOPCLASSIDS as "ftopclassids",FAPPSCENARIOTYPE as "fappscenariotype",FISSupportWF as "fissupportwf",FSERVICEINVOKECLASS as "fserviceinvokeclass",FSERVICECLASSEXT as "fserviceclassext",FWEBSERVICECLASS as "fwebserviceclass",FWEBDESIGNERCLASS as "fwebdesignerclass" from T_MDL_FORMOPERATIONTYPE

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

select FID as "表单操作编码",FOPERATION as "表单操作标示",FISCONFIRM as "是否给出提示",FRESOURCE as "资源",FENABLEDSTATE as "可用状态",FOPERELEIDS as "适用元素类型",FSERVICECLASS as "运行组件",FDESIGNERCLASS as "设计组件",FTOPCLASSIDS as "适用的业务领域",FAPPSCENARIOTYPE as "应用场景类型",FISSupportWF as "是否支持工作流动作",FSERVICEINVOKECLASS as "运行服务调用组件",FSERVICECLASSEXT as "扩展的运行组件",FWEBSERVICECLASS as "web服务组件",FWEBDESIGNERCLASS as "web服务设计组件" from T_MDL_FORMOPERATIONTYPE

--INSERT脚本--

insert into T_MDL_FORMOPERATIONTYPE(FID,FOPERATION,FISCONFIRM,FRESOURCE,FENABLEDSTATE,FOPERELEIDS,FSERVICECLASS,FDESIGNERCLASS,FTOPCLASSIDS,FAPPSCENARIOTYPE,FISSupportWF,FSERVICEINVOKECLASS,FSERVICECLASSEXT,FWEBSERVICECLASS,FWEBDESIGNERCLASS) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)

--UPDATE脚本--

update T_MDL_FORMOPERATIONTYPE set FID=?,FOPERATION=?,FISCONFIRM=?,FRESOURCE=?,FENABLEDSTATE=?,FOPERELEIDS=?,FSERVICECLASS=?,FDESIGNERCLASS=?,FTOPCLASSIDS=?,FAPPSCENARIOTYPE=?,FISSupportWF=?,FSERVICEINVOKECLASS=?,FSERVICECLASSEXT=?,FWEBSERVICECLASS=?,FWEBDESIGNERCLASS=? where FID=?

--delete脚本--

delete from T_MDL_FORMOPERATIONTYPE where FID=?

--给字段加备注--

alter table T_MDL_FORMOPERATIONTYPE comment '可选表单操作';

alter table T_MDL_FORMOPERATIONTYPE modify column FID int not null  comment '表单操作编码';

alter table T_MDL_FORMOPERATIONTYPE modify column FOPERATION varchar(30) not null  comment '表单操作标示';

alter table T_MDL_FORMOPERATIONTYPE modify column FISCONFIRM int not null  comment '是否给出提示';

alter table T_MDL_FORMOPERATIONTYPE modify column FRESOURCE nvarchar(250) default null  comment '资源';

alter table T_MDL_FORMOPERATIONTYPE modify column FENABLEDSTATE varchar(50) default null  comment '可用状态';

alter table T_MDL_FORMOPERATIONTYPE modify column FOPERELEIDS varchar(100) default null  comment '适用元素类型';

alter table T_MDL_FORMOPERATIONTYPE modify column FSERVICECLASS varchar(150) not null  comment '运行组件';

alter table T_MDL_FORMOPERATIONTYPE modify column FDESIGNERCLASS varchar(150) default null  comment '设计组件';

alter table T_MDL_FORMOPERATIONTYPE modify column FTOPCLASSIDS varchar(150) not null  comment '适用的业务领域';

alter table T_MDL_FORMOPERATIONTYPE modify column FAPPSCENARIOTYPE int not null  comment '应用场景类型';

alter table T_MDL_FORMOPERATIONTYPE modify column FISSupportWF char(1) not null  comment '是否支持工作流动作';

alter table T_MDL_FORMOPERATIONTYPE modify column FSERVICEINVOKECLASS varchar(150) default null  comment '运行服务调用组件';

alter table T_MDL_FORMOPERATIONTYPE modify column FSERVICECLASSEXT varchar(150) default null  comment '扩展的运行组件';

alter table T_MDL_FORMOPERATIONTYPE modify column FWEBSERVICECLASS varchar(150) default null  comment 'web服务组件';

alter table T_MDL_FORMOPERATIONTYPE modify column FWEBDESIGNERCLASS varchar(150) default null  comment 'web服务设计组件';

--建表脚本--

create table T_MDL_FORMVALIDATIONTYPE(

FTYPEID int not null  comment '规则编码'

,FCATEGORYID int not null  comment '分类'

,FTIMINGPOINT varchar(30) not null  comment '校验时间点'

,FRUNTIMECLASS varchar(150) not null  comment '运行时class'

,FDESIGNERCLASS varchar(150) not null  comment '设计时class'

,primary key (FTYPEID)

) comment = '单据校验规则类型'

--查询--

select FTYPEID as "ftypeid",FCATEGORYID as "fcategoryid",FTIMINGPOINT as "ftimingpoint",FRUNTIMECLASS as "fruntimeclass",FDESIGNERCLASS as "fdesignerclass" from T_MDL_FORMVALIDATIONTYPE

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

select FTYPEID as "规则编码",FCATEGORYID as "分类",FTIMINGPOINT as "校验时间点",FRUNTIMECLASS as "运行时class",FDESIGNERCLASS as "设计时class" from T_MDL_FORMVALIDATIONTYPE

--INSERT脚本--

insert into T_MDL_FORMVALIDATIONTYPE(FTYPEID,FCATEGORYID,FTIMINGPOINT,FRUNTIMECLASS,FDESIGNERCLASS) values (?,?,?,?,?)

--UPDATE脚本--

update T_MDL_FORMVALIDATIONTYPE set FTYPEID=?,FCATEGORYID=?,FTIMINGPOINT=?,FRUNTIMECLASS=?,FDESIGNERCLASS=? where FTYPEID=?

--delete脚本--

delete from T_MDL_FORMVALIDATIONTYPE where FTYPEID=?

--给字段加备注--

alter table T_MDL_FORMVALIDATIONTYPE comment '单据校验规则类型';

alter table T_MDL_FORMVALIDATIONTYPE modify column FTYPEID int not null  comment '规则编码';

alter table T_MDL_FORMVALIDATIONTYPE modify column FCATEGORYID int not null  comment '分类';

alter table T_MDL_FORMVALIDATIONTYPE modify column FTIMINGPOINT varchar(30) not null  comment '校验时间点';

alter table T_MDL_FORMVALIDATIONTYPE modify column FRUNTIMECLASS varchar(150) not null  comment '运行时class';

alter table T_MDL_FORMVALIDATIONTYPE modify column FDESIGNERCLASS varchar(150) not null  comment '设计时class';

--建表脚本--

create table T_MDL_FORMVALIDATIONTYPE_L(

FPKID int not null  comment '主键'

,FTYPEID int not null  comment '规则编码'

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

,FLOCALEID int not null  comment '语言'

,primary key (FPKID)

) comment = '单据校验规则类型多语言'

--查询--

select FPKID as "fpkid",FTYPEID as "ftypeid",FNAME as "fname",FLOCALEID as "flocaleid" from T_MDL_FORMVALIDATIONTYPE_L

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

select FPKID as "主键",FTYPEID as "规则编码",FNAME as "名称",FLOCALEID as "语言" from T_MDL_FORMVALIDATIONTYPE_L

--INSERT脚本--

insert into T_MDL_FORMVALIDATIONTYPE_L(FPKID,FTYPEID,FNAME,FLOCALEID) values (?,?,?,?)

--UPDATE脚本--

update T_MDL_FORMVALIDATIONTYPE_L set FPKID=?,FTYPEID=?,FNAME=?,FLOCALEID=? where FPKID=?

--delete脚本--

delete from T_MDL_FORMVALIDATIONTYPE_L where FPKID=?

--给字段加备注--

alter table T_MDL_FORMVALIDATIONTYPE_L comment '单据校验规则类型多语言';

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

alter table T_MDL_FORMVALIDATIONTYPE_L modify column FTYPEID int not null  comment '规则编码';

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

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