BOS / 基础服务与基础框架 / 弹性域

--建表脚本--

create table T_BAS_FLEX(

FID int not null  comment 'FID'

,FNUMBER varchar(10) not null  comment '编码'

,FBaseInfo varchar(36) default null  comment '基础资料'

,FIsDependBaseInfo char(1) not null  comment '依赖于基础资料'

,FPredefined char(1) not null  comment '预定义组合值'

,FSeparator nvarchar(10) not null  comment '分隔符'

,FDisplayFormat smallint not null  comment '显示格式'

,FColumnNum int not null  comment '字段数量'

,FFormId varchar(36) not null  comment '维度数据表单'

,FDISPLAYNAMESPECIES smallint not null  comment '名称显示格式'

,FValComFormId varchar(36) not null  comment '值组合formid'

,FCREATORID int not null  comment '创建人'

,FCREATEDATE datetime not null  comment '创建日期'

,FMODIFIERID int default null  comment '修改人'

,FMODIFYDATE datetime default null  comment '修改日期'

,FFORBIDDERID int default null  comment '禁用人'

,FFORBIDDATE datetime default null  comment '禁用日期'

,FDOCUMENTSTATUS char(1) not null  comment '数据状态'

,FFORBIDSTATUS char(1) not null  comment '禁用状态'

,primary key (FID)

) comment = '弹性域'

--查询--

select FID as "fid",FNUMBER as "fnumber",FBaseInfo as "fbaseinfo",FIsDependBaseInfo as "fisdependbaseinfo",FPredefined as "fpredefined",FSeparator as "fseparator",FDisplayFormat as "fdisplayformat",FColumnNum as "fcolumnnum",FFormId as "fformid",FDISPLAYNAMESPECIES as "fdisplaynamespecies",FValComFormId as "fvalcomformid",FCREATORID as "fcreatorid",FCREATEDATE as "fcreatedate",FMODIFIERID as "fmodifierid",FMODIFYDATE as "fmodifydate",FFORBIDDERID as "fforbidderid",FFORBIDDATE as "fforbiddate",FDOCUMENTSTATUS as "fdocumentstatus",FFORBIDSTATUS as "fforbidstatus" from T_BAS_FLEX

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

select FID as "FID",FNUMBER as "编码",FBaseInfo as "基础资料",FIsDependBaseInfo as "依赖于基础资料",FPredefined as "预定义组合值",FSeparator as "分隔符",FDisplayFormat as "显示格式",FColumnNum as "字段数量",FFormId as "维度数据表单",FDISPLAYNAMESPECIES as "名称显示格式",FValComFormId as "值组合formid",FCREATORID as "创建人",FCREATEDATE as "创建日期",FMODIFIERID as "修改人",FMODIFYDATE as "修改日期",FFORBIDDERID as "禁用人",FFORBIDDATE as "禁用日期",FDOCUMENTSTATUS as "数据状态",FFORBIDSTATUS as "禁用状态" from T_BAS_FLEX

--INSERT脚本--

insert into T_BAS_FLEX(FID,FNUMBER,FBaseInfo,FIsDependBaseInfo,FPredefined,FSeparator,FDisplayFormat,FColumnNum,FFormId,FDISPLAYNAMESPECIES,FValComFormId,FCREATORID,FCREATEDATE,FMODIFIERID,FMODIFYDATE,FFORBIDDERID,FFORBIDDATE,FDOCUMENTSTATUS,FFORBIDSTATUS) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)

--UPDATE脚本--

update T_BAS_FLEX set FID=?,FNUMBER=?,FBaseInfo=?,FIsDependBaseInfo=?,FPredefined=?,FSeparator=?,FDisplayFormat=?,FColumnNum=?,FFormId=?,FDISPLAYNAMESPECIES=?,FValComFormId=?,FCREATORID=?,FCREATEDATE=?,FMODIFIERID=?,FMODIFYDATE=?,FFORBIDDERID=?,FFORBIDDATE=?,FDOCUMENTSTATUS=?,FFORBIDSTATUS=? where FID=?

--delete脚本--

delete from T_BAS_FLEX where FID=?

--给字段加备注--

alter table T_BAS_FLEX comment '弹性域';

alter table T_BAS_FLEX modify column FID int not null  comment 'FID';

alter table T_BAS_FLEX modify column FNUMBER varchar(10) not null  comment '编码';

alter table T_BAS_FLEX modify column FBaseInfo varchar(36) default null  comment '基础资料';

alter table T_BAS_FLEX modify column FIsDependBaseInfo char(1) not null  comment '依赖于基础资料';

alter table T_BAS_FLEX modify column FPredefined char(1) not null  comment '预定义组合值';

alter table T_BAS_FLEX modify column FSeparator nvarchar(10) not null  comment '分隔符';

alter table T_BAS_FLEX modify column FDisplayFormat smallint not null  comment '显示格式';

alter table T_BAS_FLEX modify column FColumnNum int not null  comment '字段数量';

alter table T_BAS_FLEX modify column FFormId varchar(36) not null  comment '维度数据表单';

alter table T_BAS_FLEX modify column FDISPLAYNAMESPECIES smallint not null  comment '名称显示格式';

alter table T_BAS_FLEX modify column FValComFormId varchar(36) not null  comment '值组合formid';

alter table T_BAS_FLEX modify column FCREATORID int not null  comment '创建人';

alter table T_BAS_FLEX modify column FCREATEDATE datetime not null  comment '创建日期';

alter table T_BAS_FLEX modify column FMODIFIERID int default null  comment '修改人';

alter table T_BAS_FLEX modify column FMODIFYDATE datetime default null  comment '修改日期';

alter table T_BAS_FLEX modify column FFORBIDDERID int default null  comment '禁用人';

alter table T_BAS_FLEX modify column FFORBIDDATE datetime default null  comment '禁用日期';

alter table T_BAS_FLEX modify column FDOCUMENTSTATUS char(1) not null  comment '数据状态';

alter table T_BAS_FLEX modify column FFORBIDSTATUS char(1) not null  comment '禁用状态';

--建表脚本--

create table T_BAS_FLEXCOMBINATION(

FID int not null  comment 'FID'

,FNUMBER varchar(10) not null  comment '编码'

,FFLEXID int not null  comment '弹性域'

,primary key (FID)

) comment = '弹性域组合'

--查询--

select FID as "fid",FNUMBER as "fnumber",FFLEXID as "fflexid" from T_BAS_FLEXCOMBINATION

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

select FID as "FID",FNUMBER as "编码",FFLEXID as "弹性域" from T_BAS_FLEXCOMBINATION

--INSERT脚本--

insert into T_BAS_FLEXCOMBINATION(FID,FNUMBER,FFLEXID) values (?,?,?)

--UPDATE脚本--

update T_BAS_FLEXCOMBINATION set FID=?,FNUMBER=?,FFLEXID=? where FID=?

--delete脚本--

delete from T_BAS_FLEXCOMBINATION where FID=?

--给字段加备注--

alter table T_BAS_FLEXCOMBINATION comment '弹性域组合';

alter table T_BAS_FLEXCOMBINATION modify column FID int not null  comment 'FID';

alter table T_BAS_FLEXCOMBINATION modify column FNUMBER varchar(10) not null  comment '编码';

alter table T_BAS_FLEXCOMBINATION modify column FFLEXID int not null  comment '弹性域';

--建表脚本--

create table T_BAS_FLEXCOMBINATIONDETAIL(

FENTRYID int not null  comment 'FENTRYID'

,FID int not null  comment 'FID'

,FSEQ int not null  comment '序号'

,FVALUESETID int not null  comment '值集'

,FISMUSTINPUT char(1) not null  comment '是否必录'

,FDEFAULT nvarchar(100) default null  comment '默认值'

,FHIDE char(1) default null  comment '隐藏'

,FINDEX int default null  comment '显示顺序号'

,FFORBIDSTATUS char(1) not null  comment '禁用状态'

,primary key (FENTRYID)

) comment = '弹性域组合明细'

--查询--

select FENTRYID as "fentryid",FID as "fid",FSEQ as "fseq",FVALUESETID as "fvaluesetid",FISMUSTINPUT as "fismustinput",FDEFAULT as "fdefault",FHIDE as "fhide",FINDEX as "findex",FFORBIDSTATUS as "fforbidstatus" from T_BAS_FLEXCOMBINATIONDETAIL

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

select FENTRYID as "FENTRYID",FID as "FID",FSEQ as "序号",FVALUESETID as "值集",FISMUSTINPUT as "是否必录",FDEFAULT as "默认值",FHIDE as "隐藏",FINDEX as "显示顺序号",FFORBIDSTATUS as "禁用状态" from T_BAS_FLEXCOMBINATIONDETAIL

--INSERT脚本--

insert into T_BAS_FLEXCOMBINATIONDETAIL(FENTRYID,FID,FSEQ,FVALUESETID,FISMUSTINPUT,FDEFAULT,FHIDE,FINDEX,FFORBIDSTATUS) values (?,?,?,?,?,?,?,?,?)

--UPDATE脚本--

update T_BAS_FLEXCOMBINATIONDETAIL set FENTRYID=?,FID=?,FSEQ=?,FVALUESETID=?,FISMUSTINPUT=?,FDEFAULT=?,FHIDE=?,FINDEX=?,FFORBIDSTATUS=? where FENTRYID=?

--delete脚本--

delete from T_BAS_FLEXCOMBINATIONDETAIL where FENTRYID=?

--给字段加备注--

alter table T_BAS_FLEXCOMBINATIONDETAIL comment '弹性域组合明细';

alter table T_BAS_FLEXCOMBINATIONDETAIL modify column FENTRYID int not null  comment 'FENTRYID';

alter table T_BAS_FLEXCOMBINATIONDETAIL modify column FID int not null  comment 'FID';

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

alter table T_BAS_FLEXCOMBINATIONDETAIL modify column FVALUESETID int not null  comment '值集';

alter table T_BAS_FLEXCOMBINATIONDETAIL modify column FISMUSTINPUT char(1) not null  comment '是否必录';

alter table T_BAS_FLEXCOMBINATIONDETAIL modify column FDEFAULT nvarchar(100) default null  comment '默认值';

alter table T_BAS_FLEXCOMBINATIONDETAIL modify column FHIDE char(1) default null  comment '隐藏';

alter table T_BAS_FLEXCOMBINATIONDETAIL modify column FINDEX int default null  comment '显示顺序号';

alter table T_BAS_FLEXCOMBINATIONDETAIL modify column FFORBIDSTATUS char(1) not null  comment '禁用状态';

--建表脚本--

create table T_BAS_FLEXCOMBINATIONRULE(

FENTRYID int not null  comment 'FENTRYID'

,FID int not null  comment 'FID'

,FINDEX int not null  comment '序号'

,primary key (FENTRYID)

) comment = '弹性域组合规则'

--查询--

select FENTRYID as "fentryid",FID as "fid",FINDEX as "findex" from T_BAS_FLEXCOMBINATIONRULE

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

select FENTRYID as "FENTRYID",FID as "FID",FINDEX as "序号" from T_BAS_FLEXCOMBINATIONRULE

--INSERT脚本--

insert into T_BAS_FLEXCOMBINATIONRULE(FENTRYID,FID,FINDEX) values (?,?,?)

--UPDATE脚本--

update T_BAS_FLEXCOMBINATIONRULE set FENTRYID=?,FID=?,FINDEX=? where FENTRYID=?

--delete脚本--

delete from T_BAS_FLEXCOMBINATIONRULE where FENTRYID=?

--给字段加备注--

alter table T_BAS_FLEXCOMBINATIONRULE comment '弹性域组合规则';

alter table T_BAS_FLEXCOMBINATIONRULE modify column FENTRYID int not null  comment 'FENTRYID';

alter table T_BAS_FLEXCOMBINATIONRULE modify column FID int not null  comment 'FID';

alter table T_BAS_FLEXCOMBINATIONRULE modify column FINDEX int not null  comment '序号';

--建表脚本--

create table T_BAS_FLEXCOMBINATION_L(

FPKID int not null  comment 'FPKID'

,FID int not null  comment 'FID'

,FLOCALEID int not null  comment '区域码'

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

,primary key (FPKID)

) comment = '弹性域组合多语言'

--查询--

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

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

select FPKID as "FPKID",FID as "FID",FLOCALEID as "区域码",FNAME as "名称" from T_BAS_FLEXCOMBINATION_L

--INSERT脚本--

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

--UPDATE脚本--

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

--delete脚本--

delete from T_BAS_FLEXCOMBINATION_L where FPKID=?

--给字段加备注--

alter table T_BAS_FLEXCOMBINATION_L comment '弹性域组合多语言';

alter table T_BAS_FLEXCOMBINATION_L modify column FPKID int not null  comment 'FPKID';

alter table T_BAS_FLEXCOMBINATION_L modify column FID int not null  comment 'FID';

alter table T_BAS_FLEXCOMBINATION_L modify column FLOCALEID int not null  comment '区域码';

alter table T_BAS_FLEXCOMBINATION_L modify column FNAME nvarchar(50) not null  comment '名称';