BOS-平台数据（2）

栏目：云星空知识作者：金蝶来源：金蝶云社区发布：2024-09-16浏览：1

BOS-平台数据（2）

--建表脚本--

create table T_MDL_FUNCINTERFACE(

FFuncId int not null comment '特性内码'

,FNumber nvarchar(30) not null comment '代码'

,FModelTypeId int not null comment '适用领域内码'

,FMetaCheckClass varchar(150) not null comment '模版配置校验组件'

,primary key (FFuncId)

) comment = '可选表单功能特性'

--查询--

select FFuncId as "ffuncid",FNumber as "fnumber",FModelTypeId as "fmodeltypeid",FMetaCheckClass as "fmetacheckclass" from T_MDL_FUNCINTERFACE

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

select FFuncId as "特性内码",FNumber as "代码",FModelTypeId as "适用领域内码",FMetaCheckClass as "模版配置校验组件" from T_MDL_FUNCINTERFACE

--INSERT脚本--

insert into T_MDL_FUNCINTERFACE(FFuncId,FNumber,FModelTypeId,FMetaCheckClass) values (?,?,?,?)

--UPDATE脚本--

update T_MDL_FUNCINTERFACE set FFuncId=?,FNumber=?,FModelTypeId=?,FMetaCheckClass=? where FFuncId=?

--delete脚本--

delete from T_MDL_FUNCINTERFACE where FFuncId=?

--给字段加备注--

alter table T_MDL_FUNCINTERFACE comment '可选表单功能特性';

alter table T_MDL_FUNCINTERFACE modify column FFuncId int not null comment '特性内码';

alter table T_MDL_FUNCINTERFACE modify column FNumber nvarchar(30) not null comment '代码';

alter table T_MDL_FUNCINTERFACE modify column FModelTypeId int not null comment '适用领域内码';

alter table T_MDL_FUNCINTERFACE modify column FMetaCheckClass varchar(150) not null comment '模版配置校验组件';

--建表脚本--

create table T_MDL_FUNCINTERFACE_L(

FPKID int not null comment '主键'

,FFuncId int not null comment '特性内码'

,FLocaleId int not null comment '多语言标示'

,FName nvarchar(50) not null comment '特性名称'

,FDescription nvarchar(255) not null comment '功能特性描述'

,primary key (FPKID)

) comment = '可选表单功能特性多语言'

--查询--

select FPKID as "fpkid",FFuncId as "ffuncid",FLocaleId as "flocaleid",FName as "fname",FDescription as "fdescription" from T_MDL_FUNCINTERFACE_L

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

select FPKID as "主键",FFuncId as "特性内码",FLocaleId as "多语言标示",FName as "特性名称",FDescription as "功能特性描述" from T_MDL_FUNCINTERFACE_L

--INSERT脚本--

insert into T_MDL_FUNCINTERFACE_L(FPKID,FFuncId,FLocaleId,FName,FDescription) values (?,?,?,?,?)

--UPDATE脚本--

update T_MDL_FUNCINTERFACE_L set FPKID=?,FFuncId=?,FLocaleId=?,FName=?,FDescription=? where FPKID=?

--delete脚本--

delete from T_MDL_FUNCINTERFACE_L where FPKID=?

--给字段加备注--

alter table T_MDL_FUNCINTERFACE_L comment '可选表单功能特性多语言';

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

alter table T_MDL_FUNCINTERFACE_L modify column FFuncId int not null comment '特性内码';

alter table T_MDL_FUNCINTERFACE_L modify column FLocaleId int not null comment '多语言标示';

alter table T_MDL_FUNCINTERFACE_L modify column FName nvarchar(50) not null comment '特性名称';

alter table T_MDL_FUNCINTERFACE_L modify column FDescription nvarchar(255) not null comment '功能特性描述';

--建表脚本--

create table T_MDL_IMAGECATEGORY(

FID int not null comment '目录编码'

,FPARENTID int not null comment '父目录编码'

,primary key (FID)

) comment = '图片资源目录'

--查询--

select FID as "fid",FPARENTID as "fparentid" from T_MDL_IMAGECATEGORY

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

select FID as "目录编码",FPARENTID as "父目录编码" from T_MDL_IMAGECATEGORY

--INSERT脚本--

insert into T_MDL_IMAGECATEGORY(FID,FPARENTID) values (?,?)

--UPDATE脚本--

update T_MDL_IMAGECATEGORY set FID=?,FPARENTID=? where FID=?

--delete脚本--

delete from T_MDL_IMAGECATEGORY where FID=?

--给字段加备注--

alter table T_MDL_IMAGECATEGORY comment '图片资源目录';

alter table T_MDL_IMAGECATEGORY modify column FID int not null comment '目录编码';

alter table T_MDL_IMAGECATEGORY modify column FPARENTID int not null comment '父目录编码';

--建表脚本--

create table T_MDL_IMAGECATEGORY_L(

FPKID int not null comment '主键'

,FID int not null comment '目录编码'

,FLocaleID int not null comment '语言'

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

,primary key (FPKID)

) comment = '图片资源目录多语言'

--查询--

select FPKID as "fpkid",FID as "fid",FLocaleID as "flocaleid",FName as "fname" from T_MDL_IMAGECATEGORY_L

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

select FPKID as "主键",FID as "目录编码",FLocaleID as "语言",FName as "名称" from T_MDL_IMAGECATEGORY_L

--INSERT脚本--

insert into T_MDL_IMAGECATEGORY_L(FPKID,FID,FLocaleID,FName) values (?,?,?,?)

--UPDATE脚本--

update T_MDL_IMAGECATEGORY_L set FPKID=?,FID=?,FLocaleID=?,FName=? where FPKID=?

--delete脚本--

delete from T_MDL_IMAGECATEGORY_L where FPKID=?

--给字段加备注--

alter table T_MDL_IMAGECATEGORY_L comment '图片资源目录多语言';

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

alter table T_MDL_IMAGECATEGORY_L modify column FID int not null comment '目录编码';

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

alter table T_MDL_IMAGECATEGORY_L modify column FName nvarchar(50) default null comment '名称';

--建表脚本--

create table T_MDL_IMAGERESOURCE(

FKEY varchar(30) not null comment '图片资源编码'

,FCATEGORYID int not null comment '目录编码'

,FNAME nvarchar(255) not null comment '图片文件名'

,FFILEFORMAT int not null comment '格式'

,primary key (FKEY)

) comment = '图片资源'

--查询--

select FKEY as "fkey",FCATEGORYID as "fcategoryid",FNAME as "fname",FFILEFORMAT as "ffileformat" from T_MDL_IMAGERESOURCE

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

select FKEY as "图片资源编码",FCATEGORYID as "目录编码",FNAME as "图片文件名",FFILEFORMAT as "格式" from T_MDL_IMAGERESOURCE

--INSERT脚本--

insert into T_MDL_IMAGERESOURCE(FKEY,FCATEGORYID,FNAME,FFILEFORMAT) values (?,?,?,?)

--UPDATE脚本--

update T_MDL_IMAGERESOURCE set FKEY=?,FCATEGORYID=?,FNAME=?,FFILEFORMAT=? where FKEY=?

--delete脚本--

delete from T_MDL_IMAGERESOURCE where FKEY=?

--给字段加备注--

alter table T_MDL_IMAGERESOURCE comment '图片资源';

alter table T_MDL_IMAGERESOURCE modify column FKEY varchar(30) not null comment '图片资源编码';

alter table T_MDL_IMAGERESOURCE modify column FCATEGORYID int not null comment '目录编码';

alter table T_MDL_IMAGERESOURCE modify column FNAME nvarchar(255) not null comment '图片文件名';

alter table T_MDL_IMAGERESOURCE modify column FFILEFORMAT int not null comment '格式';

--建表脚本--

create table t_mdl_MetaChecker(

FCheckerID int not null comment '内码'

,FName nvarchar(80) not null comment '校验器名称英文'

,FDescription nvarchar(255) not null comment '校验器描述中文'

,FFitDomainModelIds nvarchar(255) not null comment '适用领域'

,FMetaCheckClass nvarchar(150) not null comment '校验组件'

,primary key (FCheckerID)

) comment = '元数据校验器'

--查询--

select FCheckerID as "fcheckerid",FName as "fname",FDescription as "fdescription",FFitDomainModelIds as "ffitdomainmodelids",FMetaCheckClass as "fmetacheckclass" from t_mdl_MetaChecker

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

select FCheckerID as "内码",FName as "校验器名称英文",FDescription as "校验器描述中文",FFitDomainModelIds as "适用领域",FMetaCheckClass as "校验组件" from t_mdl_MetaChecker

--INSERT脚本--

insert into t_mdl_MetaChecker(FCheckerID,FName,FDescription,FFitDomainModelIds,FMetaCheckClass) values (?,?,?,?,?)

--UPDATE脚本--

update t_mdl_MetaChecker set FCheckerID=?,FName=?,FDescription=?,FFitDomainModelIds=?,FMetaCheckClass=? where FCheckerID=?

--delete脚本--

delete from t_mdl_MetaChecker where FCheckerID=?

--给字段加备注--

alter table t_mdl_MetaChecker comment '元数据校验器';

alter table t_mdl_MetaChecker modify column FCheckerID int not null comment '内码';

alter table t_mdl_MetaChecker modify column FName nvarchar(80) not null comment '校验器名称英文';

alter table t_mdl_MetaChecker modify column FDescription nvarchar(255) not null comment '校验器描述中文';

alter table t_mdl_MetaChecker modify column FFitDomainModelIds nvarchar(255) not null comment '适用领域';

alter table t_mdl_MetaChecker modify column FMetaCheckClass nvarchar(150) not null comment '校验组件';

--建表脚本--

create table t_mdl_elementlib(

FId varchar(36) not null comment '内码'

,FNumber varchar(36) not null comment '代码'

,FDomainModelId int not null comment '领域模型'

,primary key (FId)

) comment = '元素库'

--查询--

select FId as "fid",FNumber as "fnumber",FDomainModelId as "fdomainmodelid" from t_mdl_elementlib

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

select FId as "内码",FNumber as "代码",FDomainModelId as "领域模型" from t_mdl_elementlib

--INSERT脚本--

insert into t_mdl_elementlib(FId,FNumber,FDomainModelId) values (?,?,?)

--UPDATE脚本--

update t_mdl_elementlib set FId=?,FNumber=?,FDomainModelId=? where FId=?

--delete脚本--

delete from t_mdl_elementlib where FId=?

--给字段加备注--

alter table t_mdl_elementlib comment '元素库';

alter table t_mdl_elementlib modify column FId varchar(36) not null comment '内码';

alter table t_mdl_elementlib modify column FNumber varchar(36) not null comment '代码';

alter table t_mdl_elementlib modify column FDomainModelId int not null comment '领域模型';

--建表脚本--

create table t_mdl_filtercondition_l(

FPKID int not null comment '主键'

,FID int not null comment '编码'

,FLocaleID int not null comment '语言'

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

,FDataSource nvarchar(1000) default null comment '可选数据'

,FToolTip nvarchar(200) default null comment '录入提示'

,primary key (FPKID)

) comment = '过滤比较符号集多语言'

--查询--

select FPKID as "fpkid",FID as "fid",FLocaleID as "flocaleid",FName as "fname",FDataSource as "fdatasource",FToolTip as "ftooltip" from t_mdl_filtercondition_l

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

select FPKID as "主键",FID as "编码",FLocaleID as "语言",FName as "名称",FDataSource as "可选数据",FToolTip as "录入提示" from t_mdl_filtercondition_l

--INSERT脚本--

insert into t_mdl_filtercondition_l(FPKID,FID,FLocaleID,FName,FDataSource,FToolTip) values (?,?,?,?,?,?)

--UPDATE脚本--

update t_mdl_filtercondition_l set FPKID=?,FID=?,FLocaleID=?,FName=?,FDataSource=?,FToolTip=? where FPKID=?

--delete脚本--

delete from t_mdl_filtercondition_l where FPKID=?

--给字段加备注--

alter table t_mdl_filtercondition_l comment '过滤比较符号集多语言';

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

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