PLM内容专辑（二）

--建表脚本--

create table T_PLM_CFG_DOMAINCVTCFG(

FID bigint not null  comment 'FID'

,FMASTERID bigint not null  comment 'FMASTERID'

,FISUPDATE char(1) not null  comment 'FISUPDATE'

,FCONNECTOR nvarchar(50) not null  comment 'FCONNECTOR'

,FSTARTUP char(1) not null  comment 'FSTARTUP'

,FISMUST char(1) not null  comment 'FISMUST'

,FCATEGORYID bigint not null  comment 'FCATEGORYID'

,FDOMAINFIELD bigint not null  comment 'FDOMAINFIELD'

,FDEFAULTVALUE nvarchar(50) not null  comment 'FDEFAULTVALUE'

,primary key (FID)

) comment = '领域对象同步配置'

--查询--

select FID as "fid",FMASTERID as "fmasterid",FISUPDATE as "fisupdate",FCONNECTOR as "fconnector",FSTARTUP as "fstartup",FISMUST as "fismust",FCATEGORYID as "fcategoryid",FDOMAINFIELD as "fdomainfield",FDEFAULTVALUE as "fdefaultvalue" from T_PLM_CFG_DOMAINCVTCFG

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

select FID as "FID",FMASTERID as "FMASTERID",FISUPDATE as "FISUPDATE",FCONNECTOR as "FCONNECTOR",FSTARTUP as "FSTARTUP",FISMUST as "FISMUST",FCATEGORYID as "FCATEGORYID",FDOMAINFIELD as "FDOMAINFIELD",FDEFAULTVALUE as "FDEFAULTVALUE" from T_PLM_CFG_DOMAINCVTCFG

--INSERT脚本--

insert into T_PLM_CFG_DOMAINCVTCFG(FID,FMASTERID,FISUPDATE,FCONNECTOR,FSTARTUP,FISMUST,FCATEGORYID,FDOMAINFIELD,FDEFAULTVALUE) values (?,?,?,?,?,?,?,?,?)

--UPDATE脚本--

update T_PLM_CFG_DOMAINCVTCFG set FID=?,FMASTERID=?,FISUPDATE=?,FCONNECTOR=?,FSTARTUP=?,FISMUST=?,FCATEGORYID=?,FDOMAINFIELD=?,FDEFAULTVALUE=? where FID=?

--delete脚本--

delete from T_PLM_CFG_DOMAINCVTCFG where FID=?

--给字段加备注--

alter table T_PLM_CFG_DOMAINCVTCFG comment '领域对象同步配置';

alter table T_PLM_CFG_DOMAINCVTCFG modify column FID bigint not null  comment 'FID';

alter table T_PLM_CFG_DOMAINCVTCFG modify column FMASTERID bigint not null  comment 'FMASTERID';

alter table T_PLM_CFG_DOMAINCVTCFG modify column FISUPDATE char(1) not null  comment 'FISUPDATE';

alter table T_PLM_CFG_DOMAINCVTCFG modify column FCONNECTOR nvarchar(50) not null  comment 'FCONNECTOR';

alter table T_PLM_CFG_DOMAINCVTCFG modify column FSTARTUP char(1) not null  comment 'FSTARTUP';

alter table T_PLM_CFG_DOMAINCVTCFG modify column FISMUST char(1) not null  comment 'FISMUST';

alter table T_PLM_CFG_DOMAINCVTCFG modify column FCATEGORYID bigint not null  comment 'FCATEGORYID';

alter table T_PLM_CFG_DOMAINCVTCFG modify column FDOMAINFIELD bigint not null  comment 'FDOMAINFIELD';

alter table T_PLM_CFG_DOMAINCVTCFG modify column FDEFAULTVALUE nvarchar(50) not null  comment 'FDEFAULTVALUE';

--建表脚本--

create table T_PLM_CFG_DOMAINFIELD(

FID bigint not null  comment 'FID'

,FMasterID bigint not null  comment 'FMasterID'

,FCODE nvarchar(50) not null  comment 'FCODE'

,FENTITYCODE nvarchar(50) not null  comment 'FENTITYCODE'

,FFIELDTYPE nvarchar(50) not null  comment 'FFIELDTYPE'

,FKEY nvarchar(50) not null  comment 'FKEY'

,FELEMENTTYPEID nvarchar(50) not null  comment 'FELEMENTTYPEID'

,FDEFVALUE nvarchar(50) not null  comment 'FDEFVALUE'

,FMUSTINPUT char(1) not null  comment 'FMUSTINPUT'

,FISSHOW char(1) not null  comment 'FISSHOW'

,FFUNCTIONDEFAULT nvarchar(200) not null  comment 'FFUNCTIONDEFAULT'

,FBASETYPE nvarchar(50) not null  comment 'FBASETYPE'

,FISREADONLY char(1) not null  comment 'FISREADONLY'

,FISSHOWLIST char(1) not null  comment 'FISSHOWLIST'

,FENUMNAME nvarchar(50) not null  comment 'FENUMNAME'

,FOBJECTTYPE nvarchar(50) not null  comment 'FOBJECTTYPE'

,FOBJECTNAME nvarchar(50) not null  comment 'FOBJECTNAME'

,FFORMID nvarchar(100) not null  comment 'FFORMID'

,primary key (FID)

) comment = '领域对象字段表'

--查询--

select FID as "fid",FMasterID as "fmasterid",FCODE as "fcode",FENTITYCODE as "fentitycode",FFIELDTYPE as "ffieldtype",FKEY as "fkey",FELEMENTTYPEID as "felementtypeid",FDEFVALUE as "fdefvalue",FMUSTINPUT as "fmustinput",FISSHOW as "fisshow",FFUNCTIONDEFAULT as "ffunctiondefault",FBASETYPE as "fbasetype",FISREADONLY as "fisreadonly",FISSHOWLIST as "fisshowlist",FENUMNAME as "fenumname",FOBJECTTYPE as "fobjecttype",FOBJECTNAME as "fobjectname",FFORMID as "fformid" from T_PLM_CFG_DOMAINFIELD

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

select FID as "FID",FMasterID as "FMasterID",FCODE as "FCODE",FENTITYCODE as "FENTITYCODE",FFIELDTYPE as "FFIELDTYPE",FKEY as "FKEY",FELEMENTTYPEID as "FELEMENTTYPEID",FDEFVALUE as "FDEFVALUE",FMUSTINPUT as "FMUSTINPUT",FISSHOW as "FISSHOW",FFUNCTIONDEFAULT as "FFUNCTIONDEFAULT",FBASETYPE as "FBASETYPE",FISREADONLY as "FISREADONLY",FISSHOWLIST as "FISSHOWLIST",FENUMNAME as "FENUMNAME",FOBJECTTYPE as "FOBJECTTYPE",FOBJECTNAME as "FOBJECTNAME",FFORMID as "FFORMID" from T_PLM_CFG_DOMAINFIELD

--INSERT脚本--

insert into T_PLM_CFG_DOMAINFIELD(FID,FMasterID,FCODE,FENTITYCODE,FFIELDTYPE,FKEY,FELEMENTTYPEID,FDEFVALUE,FMUSTINPUT,FISSHOW,FFUNCTIONDEFAULT,FBASETYPE,FISREADONLY,FISSHOWLIST,FENUMNAME,FOBJECTTYPE,FOBJECTNAME,FFORMID) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)

--UPDATE脚本--

update T_PLM_CFG_DOMAINFIELD set FID=?,FMasterID=?,FCODE=?,FENTITYCODE=?,FFIELDTYPE=?,FKEY=?,FELEMENTTYPEID=?,FDEFVALUE=?,FMUSTINPUT=?,FISSHOW=?,FFUNCTIONDEFAULT=?,FBASETYPE=?,FISREADONLY=?,FISSHOWLIST=?,FENUMNAME=?,FOBJECTTYPE=?,FOBJECTNAME=?,FFORMID=? where FID=?

--delete脚本--

delete from T_PLM_CFG_DOMAINFIELD where FID=?

--给字段加备注--

alter table T_PLM_CFG_DOMAINFIELD comment '领域对象字段表';

alter table T_PLM_CFG_DOMAINFIELD modify column FID bigint not null  comment 'FID';

alter table T_PLM_CFG_DOMAINFIELD modify column FMasterID bigint not null  comment 'FMasterID';

alter table T_PLM_CFG_DOMAINFIELD modify column FCODE nvarchar(50) not null  comment 'FCODE';

alter table T_PLM_CFG_DOMAINFIELD modify column FENTITYCODE nvarchar(50) not null  comment 'FENTITYCODE';

alter table T_PLM_CFG_DOMAINFIELD modify column FFIELDTYPE nvarchar(50) not null  comment 'FFIELDTYPE';

alter table T_PLM_CFG_DOMAINFIELD modify column FKEY nvarchar(50) not null  comment 'FKEY';

alter table T_PLM_CFG_DOMAINFIELD modify column FELEMENTTYPEID nvarchar(50) not null  comment 'FELEMENTTYPEID';

alter table T_PLM_CFG_DOMAINFIELD modify column FDEFVALUE nvarchar(50) not null  comment 'FDEFVALUE';

alter table T_PLM_CFG_DOMAINFIELD modify column FMUSTINPUT char(1) not null  comment 'FMUSTINPUT';

alter table T_PLM_CFG_DOMAINFIELD modify column FISSHOW char(1) not null  comment 'FISSHOW';

alter table T_PLM_CFG_DOMAINFIELD modify column FFUNCTIONDEFAULT nvarchar(200) not null  comment 'FFUNCTIONDEFAULT';

alter table T_PLM_CFG_DOMAINFIELD modify column FBASETYPE nvarchar(50) not null  comment 'FBASETYPE';

alter table T_PLM_CFG_DOMAINFIELD modify column FISREADONLY char(1) not null  comment 'FISREADONLY';

alter table T_PLM_CFG_DOMAINFIELD modify column FISSHOWLIST char(1) not null  comment 'FISSHOWLIST';

alter table T_PLM_CFG_DOMAINFIELD modify column FENUMNAME nvarchar(50) not null  comment 'FENUMNAME';

alter table T_PLM_CFG_DOMAINFIELD modify column FOBJECTTYPE nvarchar(50) not null  comment 'FOBJECTTYPE';

alter table T_PLM_CFG_DOMAINFIELD modify column FOBJECTNAME nvarchar(50) not null  comment 'FOBJECTNAME';

alter table T_PLM_CFG_DOMAINFIELD modify column FFORMID nvarchar(100) not null  comment 'FFORMID';

--建表脚本--

create table T_PLM_CFG_DOMAINFIELD_L(

FPKID bigint not null  comment 'FPKID'

,FID bigint not null  comment 'FID'

,FLOCALEID int not null  comment 'FLOCALEID'

,FNAME nvarchar(500) not null  comment 'FNAME'

,FELEMENTTYPE nvarchar(50) not null  comment 'FELEMENTTYPE'

,primary key (FPKID)

) comment = '领域对象字段多语言表'

--查询--

select FPKID as "fpkid",FID as "fid",FLOCALEID as "flocaleid",FNAME as "fname",FELEMENTTYPE as "felementtype" from T_PLM_CFG_DOMAINFIELD_L

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

select FPKID as "FPKID",FID as "FID",FLOCALEID as "FLOCALEID",FNAME as "FNAME",FELEMENTTYPE as "FELEMENTTYPE" from T_PLM_CFG_DOMAINFIELD_L

--INSERT脚本--

insert into T_PLM_CFG_DOMAINFIELD_L(FPKID,FID,FLOCALEID,FNAME,FELEMENTTYPE) values (?,?,?,?,?)

--UPDATE脚本--

update T_PLM_CFG_DOMAINFIELD_L set FPKID=?,FID=?,FLOCALEID=?,FNAME=?,FELEMENTTYPE=? where FPKID=?

--delete脚本--

delete from T_PLM_CFG_DOMAINFIELD_L where FPKID=?

--给字段