--建表脚本--

create table T_PLM_CFG_FIELD(

FID bigint not null  comment '主键'

,FMasterID bigint not null  comment '组织id'

,FCODE nvarchar(50) default null  comment '编码'

,FENTITYCODE nvarchar(50) default null  comment '实体属性'

,FFIELDTYPE nvarchar(50) default null  comment '字段类型'

,FKEY nvarchar(50) default null  comment '标识'

,FELEMENTTYPEID nvarchar(50) default null  comment '元素类型id'

,FOBJECTTYPE int not null  comment '对象类型'

,FDEFVALUE nvarchar(1000) default ''  comment '默认值'

,FMUSTINPUT char(1) default ''0''  comment '必填'

,FFUNCTIONDEFAULT nvarchar(200) default null  comment '默认方法'

,FBASETYPE nvarchar(50) default null  comment '基础资料'

,FENUMNAME nvarchar(50) default null  comment '枚举类型'

,FISREADONLY char(1) default ''0''  comment '是否只读'

,FISSHOWLIST char(1) default ''0''  comment '列表显示'

,FISSHOW char(1) default ''0''  comment '显示'

,FISCLIENTDEFAULT char(1) default ''0''  comment 'FISCLIENTDEFAULT'

,FISCLIENTSEARCHDEFAULT char(1) default ''0''  comment '客户端搜索默认'

,FISCLIENTGRIDDEFAULT char(1) default ''0''  comment '客户端grid默认'

,FISTREEEDITORDEFAULT char(1) default ''0''  comment '客户端bom编辑默认'

,FISTREEVIEWDEFAULT char(1) default ''0''  comment '客户端bom查看默认'

,FELEMENTTYPE nvarchar(50) default null  comment '元素类型'

,FCREATEDATE datetime default null  comment '创建时间'

,FMODIFYDATE datetime default null  comment '修改时间'

,FEXTENDKEY nvarchar(100) not null  comment '扩展标识'

,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",FOBJECTTYPE as "fobjecttype",FDEFVALUE as "fdefvalue",FMUSTINPUT as "fmustinput",FFUNCTIONDEFAULT as "ffunctiondefault",FBASETYPE as "fbasetype",FENUMNAME as "fenumname",FISREADONLY as "fisreadonly",FISSHOWLIST as "fisshowlist",FISSHOW as "fisshow",FISCLIENTDEFAULT as "fisclientdefault",FISCLIENTSEARCHDEFAULT as "fisclientsearchdefault",FISCLIENTGRIDDEFAULT as "fisclientgriddefault",FISTREEEDITORDEFAULT as "fistreeeditordefault",FISTREEVIEWDEFAULT as "fistreeviewdefault",FELEMENTTYPE as "felementtype",FCREATEDATE as "fcreatedate",FMODIFYDATE as "fmodifydate",FEXTENDKEY as "fextendkey" from T_PLM_CFG_FIELD

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

select FID as "主键",FMasterID as "组织id",FCODE as "编码",FENTITYCODE as "实体属性",FFIELDTYPE as "字段类型",FKEY as "标识",FELEMENTTYPEID as "元素类型id",FOBJECTTYPE as "对象类型",FDEFVALUE as "默认值",FMUSTINPUT as "必填",FFUNCTIONDEFAULT as "默认方法",FBASETYPE as "基础资料",FENUMNAME as "枚举类型",FISREADONLY as "是否只读",FISSHOWLIST as "列表显示",FISSHOW as "显示",FISCLIENTDEFAULT as "FISCLIENTDEFAULT",FISCLIENTSEARCHDEFAULT as "客户端搜索默认",FISCLIENTGRIDDEFAULT as "客户端grid默认",FISTREEEDITORDEFAULT as "客户端bom编辑默认",FISTREEVIEWDEFAULT as "客户端bom查看默认",FELEMENTTYPE as "元素类型",FCREATEDATE as "创建时间",FMODIFYDATE as "修改时间",FEXTENDKEY as "扩展标识" from T_PLM_CFG_FIELD

--INSERT脚本--

insert into T_PLM_CFG_FIELD(FID,FMasterID,FCODE,FENTITYCODE,FFIELDTYPE,FKEY,FELEMENTTYPEID,FOBJECTTYPE,FDEFVALUE,FMUSTINPUT,FFUNCTIONDEFAULT,FBASETYPE,FENUMNAME,FISREADONLY,FISSHOWLIST,FISSHOW,FISCLIENTDEFAULT,FISCLIENTSEARCHDEFAULT,FISCLIENTGRIDDEFAULT,FISTREEEDITORDEFAULT,FISTREEVIEWDEFAULT,FELEMENTTYPE,FCREATEDATE,FMODIFYDATE,FEXTENDKEY) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)

--UPDATE脚本--

update T_PLM_CFG_FIELD set FID=?,FMasterID=?,FCODE=?,FENTITYCODE=?,FFIELDTYPE=?,FKEY=?,FELEMENTTYPEID=?,FOBJECTTYPE=?,FDEFVALUE=?,FMUSTINPUT=?,FFUNCTIONDEFAULT=?,FBASETYPE=?,FENUMNAME=?,FISREADONLY=?,FISSHOWLIST=?,FISSHOW=?,FISCLIENTDEFAULT=?,FISCLIENTSEARCHDEFAULT=?,FISCLIENTGRIDDEFAULT=?,FISTREEEDITORDEFAULT=?,FISTREEVIEWDEFAULT=?,FELEMENTTYPE=?,FCREATEDATE=?,FMODIFYDATE=?,FEXTENDKEY=? where FID=?

--delete脚本--

delete from T_PLM_CFG_FIELD where FID=?

--给字段加备注--

alter table T_PLM_CFG_FIELD comment '字段对象';

alter table T_PLM_CFG_FIELD modify column FID bigint not null  comment '主键';

alter table T_PLM_CFG_FIELD modify column FMasterID bigint not null  comment '组织id';

alter table T_PLM_CFG_FIELD modify column FCODE nvarchar(50) default null  comment '编码';

alter table T_PLM_CFG_FIELD modify column FENTITYCODE nvarchar(50) default null  comment '实体属性';

alter table T_PLM_CFG_FIELD modify column FFIELDTYPE nvarchar(50) default null  comment '字段类型';

alter table T_PLM_CFG_FIELD modify column FKEY nvarchar(50) default null  comment '标识';

alter table T_PLM_CFG_FIELD modify column FELEMENTTYPEID nvarchar(50) default null  comment '元素类型id';

alter table T_PLM_CFG_FIELD modify column FOBJECTTYPE int not null  comment '对象类型';

alter table T_PLM_CFG_FIELD modify column FDEFVALUE nvarchar(1000) default ''  comment '默认值';

alter table T_PLM_CFG_FIELD modify column FMUSTINPUT char(1) default ''0''  comment '必填';

alter table T_PLM_CFG_FIELD modify column FFUNCTIONDEFAULT nvarchar(200) default null  comment '默认方法';

alter table T_PLM_CFG_FIELD modify column FBASETYPE nvarchar(50) default null  comment '基础资料';

alter table T_PLM_CFG_FIELD modify column FENUMNAME nvarchar(50) default null  comment '枚举类型';

alter table T_PLM_CFG_FIELD modify column FISREADONLY char(1) default ''0''  comment '是否只读';

alter table T_PLM_CFG_FIELD modify column FISSHOWLIST char(1) default ''0''  comment '列表显示';

alter table T_PLM_CFG_FIELD modify column FISSHOW char(1) default ''0''  comment '显示';

alter table T_PLM_CFG_FIELD modify column FISCLIENTDEFAULT char(1) default ''0''  comment 'FISCLIENTDEFAULT';

alter table T_PLM_CFG_FIELD modify column FISCLIENTSEARCHDEFAULT char(1) default ''0''  comment '客户端搜索默认';

alter table T_PLM_CFG_FIELD modify column FISCLIENTGRIDDEFAULT char(1) default ''0''  comment '客户端grid默认';

alter table T_PLM_CFG_FIELD modify column FISTREEEDITORDEFAULT char(1) default ''0''  comment '客户端bom编辑默认';

alter table T_PLM_CFG_FIELD modify column FISTREEVIEWDEFAULT char(1) default ''0''  comment '客户端bom查看默认';

alter table T_PLM_CFG_FIELD modify column FELEMENTTYPE nvarchar(50) default null  comment '元素类型';

alter table T_PLM_CFG_FIELD modify column FCREATEDATE datetime default null  comment '创建时间';

alter table T_PLM_CFG_FIELD modify column FMODIFYDATE datetime default null  comment '修改时间';

alter table T_PLM_CFG_FIELD modify column FEXTENDKEY nvarchar(100) not null  comment '扩展标识';

--建表脚本--

create table T_PLM_CFG_FIELDENTRY(

FEntryID int not null  comment '从表id'

,FID int not null  comment '主键'

,FFIELDCODE bigint not null  comment '字段编码'

,primary key (FEntryID)

) comment = '字段对象从表'

--查询--

select FEntryID as "fentryid",FID as "fid",FFIELDCODE as "ffieldcode" from T_PLM_CFG_FIELDENTRY

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

select FEntryID as "从表id",FID as "主键",FFIELDCODE as "字段编码" from T_PLM_CFG_FIELDENTRY

--INSERT脚本--

insert into T_PLM_CFG_FIELDENTRY(FEntryID,FID,FFIELDCODE) values (?,?,?)

--UPDATE脚本--

update T_PLM_CFG_FIELDENTRY set FEntryID=?,FID=?,FFIELDCODE=? where FEntryID=?

--delete脚本--

delete from T_PLM_CFG_FIELDENTRY where FEntryID=?

--给字段加备注--

alter table T_PLM_CFG_FIELDENTRY comment '字段对象从表';

alter table T_PLM_CFG_FIELDENTRY modify column FEntryID int not null  comment '从表id';

alter table T_PLM_CFG_FIELDENTRY modify column FID int not null  comment '主键';

alter table T_PLM_CFG_FIELDENTRY modify column FFIELDCODE bigint not null  comment '字段编码';

--建表脚本--

create table T_PLM_CFG_FOLDER(

FID bigint not null  comment '主键'

,FMasterID bigint not null  comment '组织id'

,FCODE nvarchar(50) default null  comment '编码'

,FCREATORID int not null  comment '创建人'

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

,FMODIFIERID int not null  comment '修改人'

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

,FPARENTID bigint not null  comment '父文件夹'

,FTYPE varchar(20) default null  comment 'FTYPE'

,FPATHID int not null  comment 'FPATHID'

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

,FOWNERID int default null  comment '拥有者用户id'

,FPERMISSIONOBJECTID varchar(36) not null  comment 'FPERMISSIONOBJECTID'

,FKEYID decimal(38,1) not null  comment '文件夹线索id'

,FLEVEL int not null  comment '文件夹层级'

,FISJOINTHINKTANK char(1) not null  comment '是否纳入研发智库'

,FPROJECTRESOURCE char(1) not null  comment '项目资源目录'

,FCREATEORGID int not null  comment '创建组织'

,FSN int not null  comment '序号'

,primary key (FID)

) comment = 'pdm文件夹'

--查询--

select FID as "fid",FMasterID as "fmasterid",FCODE as "fcode",FCREATORID as "fcreatorid",FCREATEDATE as "fcreatedate",FMODIFIERID as "fmodifierid",FMODIFYDATE as "fmodifydate",FPARENTID as "fparentid",FTYPE as "ftype",FPATHID as "fpathid",FISPRODUCTFOLDER as "fisproductfolder",FOWNERID as "fownerid",FPERMISSIONOBJECTID as "fpermissionobjectid",FKEYID as "fkeyid",FLEVEL as "flevel",FISJOINTHINKTANK as "fisjointhinktank",FPROJECTRESOURCE as "fprojectresource",FCREATEORGID as "fcreateorgid",FSN as "fsn" from T_PLM_CFG_FOLDER

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

select FID as "主键",FMasterID as "组织id",FCODE as "编码",FCREATORID as "创建人",FCREATEDATE as "创建日期",FMODIFIERID as "修改人",FMODIFYDATE as "修改日期",FPARENTID as "父文件夹",FTYPE as "FTYPE",FPATHID as "FPATHID",FISPRODUCTFOLDER as "FISPRODUCTFOLDER",FOWNERID as "拥有者用户id",FPERMISSIONOBJECTID as "FPERMISSIONOBJECTID",FKEYID as "文件夹线索id",FLEVEL as "文件夹层级",FISJOINTHINKTANK as "是否纳入研发智库",FPROJECTRESOURCE as "项目资源目录",FCREATEORGID as "创建组织",FSN as "序号" from T_PLM_CFG_FOLDER

--INSERT脚本--

insert into T_PLM_CFG_FOLDER(FID,FMasterID,FCODE,FCREATORID,FCREATEDATE,FMODIFIERID,FMODIFYDATE,FPARENTID,FTYPE,FPATHID,FISPRODUCTFOLDER,FOWNERID,FPERMISSIONOBJECTID,FKEYID,FLEVEL,FISJOINTHINKTANK,FPROJECTRESOURCE,FCREATEORGID,FSN) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)

--UPDATE脚本--

update T_PLM_CFG_FOLDER set FID=?,FMasterID=?,FCODE=?,FCREATORID=?,FCREATEDATE=?,FMODIFIERID=?,FMODIFYDATE=?,FPARENTID=?,FTYPE=?,FPATHID=?,FISPRODUCTFOLDER=?,FOWNERID=?,FPERMISSIONOBJECTID=?,FKEYID=?,FLEVEL=?,FISJOINTHINKTANK=?,FPROJECTRESOURCE=?,FCREATEORGID=?,FSN=? where FID=?

--delete脚本--

delete from T_PLM_CFG_FOLDER where FID=?

--给字段加备注--

alter table T_PLM_CFG_FOLDER comment 'pdm文件夹';

alter table T_PLM_CFG_FOLDER modify column FID bigint not null  comment '主键';

alter table T_PLM_CFG_FOLDER modify column FMasterID bigint not null  comment '组织id';

alter table T_PLM_CFG_FOLDER modify column FCODE nvarchar(50) default null  comment '编码';

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

alter table T_PLM_CFG_FOLDER modify column FCREATEDATE datetime default null  comment '创建日期';

alter table T_PLM_CFG_FOLDER modify column FMODIFIERID int not null  comment '修改人';

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

alter table T_PLM_CFG_FOLDER modify column FPARENTID bigint not null  comment '父文件夹';

alter table T_PLM_CFG_FOLDER modify column FTYPE varchar(20) default null  comment 'FTYPE';

alter table T_PLM_CFG_FOLDER modify column FPATHID int not null  comment 'FPATHID';

alter table T_PLM_CFG_FOLDER modify column FISPRODUCTFOLDER char(1) not null  comment 'FISPRODUCTFOLDER';

alter table T_PLM_CFG_FOLDER modify column FOWNERID int default null  comment '拥有者用户id';

alter table T_PLM_CFG_FOLDER modify column FPERMISSIONOBJECTID varchar(36) not null  comment 'FPERMISSIONOBJECTID';

alter table T_PLM_CFG_FOLDER modify column FKEYID decimal(38,1) not null  comment '文件夹线索id';

alter table T_PLM_CFG_FOLDER modify column FLEVEL int not null  comment '文件夹层级';

alter table T_PLM_CFG_FOLDER modify column FISJOINTHINKTANK char(1) not null  comment '是否纳入研发智库';

alter table T_PLM_CFG_FOLDER modify column FPROJECTRESOURCE char(1) not null  comment '项目资源目录';

alter table T_PLM_CFG_FOLDER modify column FCREATEORGID int not null  comment '创建组织';

alter table T_PLM_CFG_FOLDER modify column FSN int not null  comment '序号';

--建表脚本--

create table T_PLM_CFG_GRIDCONFIGFIELD(

FEntryID int not null  comment '从表id'

,FUSERID int not null  comment '用户'

,FGRIDFIELD bigint not null  comment '字段'

,FSN int default null  comment '序号'

,primary key (FEntryID)

) comment = '客户端列表字段配置'

--查询--

select FEntryID as "fentryid",FUSERID as "fuserid",FGRIDFIELD as "fgridfield",FSN as "fsn" from T_PLM_CFG_GRIDCONFIGFIELD

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

select FEntryID as "从表id",FUSERID as "用户",FGRIDFIELD as "字段",FSN as "序号" from T_PLM_CFG_GRIDCONFIGFIELD

--INSERT脚本--

insert into T_PLM_CFG_GRIDCONFIGFIELD(FEntryID,FUSERID,FGRIDFIELD,FSN) values (?,?,?,?)

--UPDATE脚本--

update T_PLM_CFG_GRIDCONFIGFIELD set FEntryID=?,FUSERID=?,FGRIDFIELD=?,FSN=? where FEntryID=?

--delete脚本--

delete from T_PLM_CFG_GRIDCONFIGFIELD where FEntryID=?

--给字段加备注--

alter table T_PLM_CFG_GRIDCONFIGFIELD comment '客户端列表字段配置';

alter table T_PLM_CFG_GRIDCONFIGFIELD modify column FEntryID int not null  comment '从表id';

alter table T_PLM_CFG_GRIDCONFIGFIELD modify column FUSERID int not null  comment '用户';

alter table T_PLM_CFG_GRIDCONFIGFIELD modify column FGRIDFIELD bigint not null  comment '字段';

alter table T_PLM_CFG_GRIDCONFIGFIELD modify column FSN int default null  comment '序号';

--建表脚本--

create table T_PLM_CFG_INHERITCATEGORYEX(

FID bigint not null  comment '主键'

,FCATEGORYID bigint not null  comment '业务类型'

,FITEM nvarchar(50) default ''  comment '项'

,FVALUE nvarchar(500) default ''  comment '值'

,FEXTENDID bigint not null  comment '字段'

,FFIELDTYPE int not null  comment '字段类型'

,primary key (FID)

) comment = '子层扩展字段'

--查询--

select FID as "fid",FCATEGORYID as "fcategoryid",FITEM as "fitem",FVALUE as "fvalue",FEXTENDID as "fextendid",FFIELDTYPE as "ffieldtype" from T_PLM_CFG_INHERITCATEGORYEX

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

select FID as "主键",FCATEGORYID as "业务类型",FITEM as "项",FVALUE as "值",FEXTENDID as "字段",FFIELDTYPE as "字段类型" from T_PLM_CFG_INHERITCATEGORYEX

--INSERT脚本--

insert into T_PLM_CFG_INHERITCATEGORYEX(FID,FCATEGORYID,FITEM,FVALUE,FEXTENDID,FFIELDTYPE) values (?,?,?,?,?,?)

--UPDATE脚本--

update T_PLM_CFG_INHERITCATEGORYEX set FID=?,FCATEGORYID=?,FITEM=?,FVALUE=?,FEXTENDID=?,FFIELDTYPE=? where FID=?

--delete脚本--

delete from T_PLM_CFG_INHERITCATEGORYEX where FID=?

--给字段加备注--

alter table T_PLM_CFG_INHERITCATEGORYEX comment '子层扩展字段';

alter table T_PLM_CFG_INHERITCATEGORYEX modify column FID bigint not null  comment '主键';

alter table T_PLM_CFG_INHERITCATEGORYEX modify column FCATEGORYID bigint not null  comment '业务类型';

alter table T_PLM_CFG_INHERITCATEGORYEX modify column FITEM nvarchar(50) default ''  comment '项';

alter table T_PLM_CFG_INHERITCATEGORYEX modify column FVALUE nvarchar(500) default ''  comment '值';

alter table T_PLM_CFG_INHERITCATEGORYEX modify column FEXTENDID bigint not null  comment '字段';

alter table T_PLM_CFG_INHERITCATEGORYEX modify column FFIELDTYPE int not null  comment '字段类型';

--建表脚本--

create table T_PLM_CFG_INTEGRITYATTRIBUTE(

FID bigint not null  comment '主键'

,FMasterID bigint not null  comment '组织id'

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

,FSQL nvarchar(2000) not null  comment '对应sql查询条件'

,primary key (FID)

) comment = '完整性属性项配置'

--查询--

select FID as "fid",FMasterID as "fmasterid",FNAME as "fname",FSQL as "fsql" from T_PLM_CFG_INTEGRITYATTRIBUTE

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

select FID as "主键",FMasterID as "组织id",FNAME as "名称",FSQL as "对应sql查询条件" from T_PLM_CFG_INTEGRITYATTRIBUTE

--INSERT脚本--

insert into T_PLM_CFG_INTEGRITYATTRIBUTE(FID,FMasterID,FNAME,FSQL) values (?,?,?,?)

--UPDATE脚本--

update T_PLM_CFG_INTEGRITYATTRIBUTE set FID=?,FMasterID=?,FNAME=?,FSQL=? where FID=?

--delete脚本--

delete from T_PLM_CFG_INTEGRITYATTRIBUTE where FID=?

--给字段加备注--

alter table T_PLM_CFG_INTEGRITYATTRIBUTE comment '完整性属性项配置';

alter table T_PLM_CFG_INTEGRITYATTRIBUTE modify column FID bigint not null  comment '主键';

alter table T_PLM_CFG_INTEGRITYATTRIBUTE modify column FMasterID bigint not null  comment '组织id';

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

alter table T_PLM_CFG_INTEGRITYATTRIBUTE modify column FSQL nvarchar(2000) not null  comment '对应sql查询条件';

--建表脚本--

create table T_PLM_CFG_INTEGRITYENTRY(

FEntryID bigint not null  comment '从表id'

,FID bigint not null  comment '主键'

,FSeq int not null  comment '序号'

,FCOMBOTYPE varchar(20) default null  comment '类型'

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

,FFIELD bigint not null  comment '来源属性'

,FCOMPARE varchar(20) not null  comment '比较'

,FLEFT nvarchar(100) not null  comment '左'

,FFIELDNAME nvarchar(100) not null  comment '字段名称'

,FRIGHT nvarchar(100) not null  comment '右'

,FLOGIC nvarchar(100) not null  comment '逻辑'

,FLOGICNAME nvarchar(100) not null  comment '逻辑名'

,primary key (FEntryID)

) comment = '完整性属性项配置子单据'

--查询--

select FEntryID as "fentryid",FID as "fid",FSeq as "fseq",FCOMBOTYPE as "fcombotype",FVALUE as "fvalue",FFIELD as "ffield",FCOMPARE as "fcompare",FLEFT as "fleft",FFIELDNAME as "ffieldname",FRIGHT as "fright",FLOGIC as "flogic",FLOGICNAME as "flogicname" from T_PLM_CFG_INTEGRITYENTRY

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

select FEntryID as "从表id",FID as "主键",FSeq as "序号",FCOMBOTYPE as "类型",FVALUE as "设置值",FFIELD as "来源属性",FCOMPARE as "比较",FLEFT as "左",FFIELDNAME as "字段名称",FRIGHT as "右",FLOGIC as "逻辑",FLOGICNAME as "逻辑名" from T_PLM_CFG_INTEGRITYENTRY

--INSERT脚本--

insert into T_PLM_CFG_INTEGRITYENTRY(FEntryID,FID,FSeq,FCOMBOTYPE,FVALUE,FFIELD,FCOMPARE,FLEFT,FFIELDNAME,FRIGHT,FLOGIC,FLOGICNAME) values (?,?,?,?,?,?,?,?,?,?,?,?)

--UPDATE脚本--

update T_PLM_CFG_INTEGRITYENTRY set FEntryID=?,FID=?,FSeq=?,FCOMBOTYPE=?,FVALUE=?,FFIELD=?,FCOMPARE=?,FLEFT=?,FFIELDNAME=?,FRIGHT=?,FLOGIC=?,FLOGICNAME=? where FEntryID=?

--delete脚本--

delete from T_PLM_CFG_INTEGRITYENTRY where FEntryID=?

--给字段加备注--

alter table T_PLM_CFG_INTEGRITYENTRY comment '完整性属性项配置子单据';

alter table T_PLM_CFG_INTEGRITYENTRY modify column FEntryID bigint not null  comment '从表id';

alter table T_PLM_CFG_INTEGRITYENTRY modify column FID bigint not null  comment '主键';

alter table T_PLM_CFG_INTEGRITYENTRY modify column FSeq int not null  comment '序号';

alter table T_PLM_CFG_INTEGRITYENTRY modify column FCOMBOTYPE varchar(20) default null  comment '类型';

alter table T_PLM_CFG_INTEGRITYENTRY modify column FVALUE nvarchar(50) default null  comment '设置值';

alter table T_PLM_CFG_INTEGRITYENTRY modify column FFIELD bigint not null  comment '来源属性';

alter table T_PLM_CFG_INTEGRITYENTRY modify column FCOMPARE varchar(20) not null  comment '比较';

alter table T_PLM_CFG_INTEGRITYENTRY modify column FLEFT nvarchar(100) not null  comment '左';

alter table T_PLM_CFG_INTEGRITYENTRY modify column FFIELDNAME nvarchar(100) not null  comment '字段名称';

alter table T_PLM_CFG_INTEGRITYENTRY modify column FRIGHT nvarchar(100) not null  comment '右';

alter table T_PLM_CFG_INTEGRITYENTRY modify column FLOGIC nvarchar(100) not null  comment '逻辑';

alter table T_PLM_CFG_INTEGRITYENTRY modify column FLOGICNAME nvarchar(100) not null  comment '逻辑名';