PLM-开发字段集合

--建表脚本--

create table T_PLM_CFG_BOMCONVERT(

FID bigint not null  comment '主键'

,FMasterID bigint not null  comment '组织id'

,FISUPDATE char(1) default ''0''  comment '是否更新'

,FISMUST char(1) default ''0''  comment '是否必填'

,FDEFAULTVALUE nvarchar(50) default null  comment '默认值'

,FPLMBOMFIELD bigint not null  comment 'plmbom字段主键'

,FERPBOMFIELD bigint not null  comment 'erpbom字段主键'

,FSTARTUP char(1) default ''1''  comment '是否启用'

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

,FCONNECTOR nvarchar(100) not null  comment '连接符'

,primary key (FID)

) comment = 'bom发布'

--查询--

select FID as "fid",FMasterID as "fmasterid",FISUPDATE as "fisupdate",FISMUST as "fismust",FDEFAULTVALUE as "fdefaultvalue",FPLMBOMFIELD as "fplmbomfield",FERPBOMFIELD as "ferpbomfield",FSTARTUP as "fstartup",FCATEGORYID as "fcategoryid",FCONNECTOR as "fconnector" from T_PLM_CFG_BOMCONVERT

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

select FID as "主键",FMasterID as "组织id",FISUPDATE as "是否更新",FISMUST as "是否必填",FDEFAULTVALUE as "默认值",FPLMBOMFIELD as "plmbom字段主键",FERPBOMFIELD as "erpbom字段主键",FSTARTUP as "是否启用",FCATEGORYID as "业务类型",FCONNECTOR as "连接符" from T_PLM_CFG_BOMCONVERT

--INSERT脚本--

insert into T_PLM_CFG_BOMCONVERT(FID,FMasterID,FISUPDATE,FISMUST,FDEFAULTVALUE,FPLMBOMFIELD,FERPBOMFIELD,FSTARTUP,FCATEGORYID,FCONNECTOR) values (?,?,?,?,?,?,?,?,?,?)

--UPDATE脚本--

update T_PLM_CFG_BOMCONVERT set FID=?,FMasterID=?,FISUPDATE=?,FISMUST=?,FDEFAULTVALUE=?,FPLMBOMFIELD=?,FERPBOMFIELD=?,FSTARTUP=?,FCATEGORYID=?,FCONNECTOR=? where FID=?

--delete脚本--

delete from T_PLM_CFG_BOMCONVERT where FID=?

--给字段加备注--

alter table T_PLM_CFG_BOMCONVERT comment 'bom发布';

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

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

alter table T_PLM_CFG_BOMCONVERT modify column FISUPDATE char(1) default ''0''  comment '是否更新';

alter table T_PLM_CFG_BOMCONVERT modify column FISMUST char(1) default ''0''  comment '是否必填';

alter table T_PLM_CFG_BOMCONVERT modify column FDEFAULTVALUE nvarchar(50) default null  comment '默认值';

alter table T_PLM_CFG_BOMCONVERT modify column FPLMBOMFIELD bigint not null  comment 'plmbom字段主键';

alter table T_PLM_CFG_BOMCONVERT modify column FERPBOMFIELD bigint not null  comment 'erpbom字段主键';

alter table T_PLM_CFG_BOMCONVERT modify column FSTARTUP char(1) default ''1''  comment '是否启用';

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

alter table T_PLM_CFG_BOMCONVERT modify column FCONNECTOR nvarchar(100) not null  comment '连接符';

--建表脚本--

create table T_PLM_CFG_BTNOP_REF(

FEntryID bigint not null  comment 'FEntryID'

,FID bigint not null  comment 'FID'

,FOPERATION bigint not null  comment 'FOPERATION'

,FORDER int not null  comment 'FORDER'

,FENABLED char(1) default ''1''  comment 'FENABLED'

,primary key (FEntryID)

) comment = 'T_PLM_CFG_BTNOP_RE...'

--查询--

select FEntryID as "fentryid",FID as "fid",FOPERATION as "foperation",FORDER as "forder",FENABLED as "fenabled" from T_PLM_CFG_BTNOP_REF

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

select FEntryID as "FEntryID",FID as "FID",FOPERATION as "FOPERATION",FORDER as "FORDER",FENABLED as "FENABLED" from T_PLM_CFG_BTNOP_REF

--INSERT脚本--

insert into T_PLM_CFG_BTNOP_REF(FEntryID,FID,FOPERATION,FORDER,FENABLED) values (?,?,?,?,?)

--UPDATE脚本--

update T_PLM_CFG_BTNOP_REF set FEntryID=?,FID=?,FOPERATION=?,FORDER=?,FENABLED=? where FEntryID=?

--delete脚本--

delete from T_PLM_CFG_BTNOP_REF where FEntryID=?

--给字段加备注--

alter table T_PLM_CFG_BTNOP_REF comment 'T_PLM_CFG_BTNOP_RE...';

alter table T_PLM_CFG_BTNOP_REF modify column FEntryID bigint not null  comment 'FEntryID';

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

alter table T_PLM_CFG_BTNOP_REF modify column FOPERATION bigint not null  comment 'FOPERATION';

alter table T_PLM_CFG_BTNOP_REF modify column FORDER int not null  comment 'FORDER';

alter table T_PLM_CFG_BTNOP_REF modify column FENABLED char(1) default ''1''  comment 'FENABLED';

--建表脚本--

create table T_PLM_CFG_BUTTON(

FID bigint not null  comment '主键'

,FMasterID bigint not null  comment '组织中标识'

,FNAME nvarchar(200) default null  comment '按钮名称'

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

,FBTNTYPE varchar(100) default null  comment '按钮类型'

,FBTNENABLED char(1) default ''1''  comment '启用'

,FSOURCE varchar(20) default null  comment '按钮来源'

,FBTNORDER int not null  comment '排序'

,FBUTTONPATH nvarchar(50) default null  comment '按钮路径'

,FLIFECYCLE bigint default null  comment '生命周期模版'

,primary key (FID)

) comment = 'plm单单据按钮'

--查询--

select FID as "fid",FMasterID as "fmasterid",FNAME as "fname",FCODE as "fcode",FBTNTYPE as "fbtntype",FBTNENABLED as "fbtnenabled",FSOURCE as "fsource",FBTNORDER as "fbtnorder",FBUTTONPATH as "fbuttonpath",FLIFECYCLE as "flifecycle" from T_PLM_CFG_BUTTON

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

select FID as "主键",FMasterID as "组织中标识",FNAME as "按钮名称",FCODE as "按钮编码",FBTNTYPE as "按钮类型",FBTNENABLED as "启用",FSOURCE as "按钮来源",FBTNORDER as "排序",FBUTTONPATH as "按钮路径",FLIFECYCLE as "生命周期模版" from T_PLM_CFG_BUTTON

--INSERT脚本--

insert into T_PLM_CFG_BUTTON(FID,FMasterID,FNAME,FCODE,FBTNTYPE,FBTNENABLED,FSOURCE,FBTNORDER,FBUTTONPATH,FLIFECYCLE) values (?,?,?,?,?,?,?,?,?,?)

--UPDATE脚本--

update T_PLM_CFG_BUTTON set FID=?,FMasterID=?,FNAME=?,FCODE=?,FBTNTYPE=?,FBTNENABLED=?,FSOURCE=?,FBTNORDER=?,FBUTTONPATH=?,FLIFECYCLE=? where FID=?

--delete脚本--

delete from T_PLM_CFG_BUTTON where FID=?

--给字段加备注--

alter table T_PLM_CFG_BUTTON comment 'plm单单据按钮';

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

alter table T_PLM_CFG_BUTTON modify column FMasterID bigint not null  comment '组织中标识';

alter table T_PLM_CFG_BUTTON modify column FNAME nvarchar(200) default null  comment '按钮名称';

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

alter table T_PLM_CFG_BUTTON modify column FBTNTYPE varchar(100) default null  comment '按钮类型';

alter table T_PLM_CFG_BUTTON modify column FBTNENABLED char(1) default ''1''  comment '启用';

alter table T_PLM_CFG_BUTTON modify column FSOURCE varchar(20) default null  comment '按钮来源';

alter table T_PLM_CFG_BUTTON modify column FBTNORDER int not null  comment '排序';

alter table T_PLM_CFG_BUTTON modify column FBUTTONPATH nvarchar(50) default null  comment '按钮路径';

alter table T_PLM_CFG_BUTTON modify column FLIFECYCLE bigint default null  comment '生命周期模版';

--建表脚本--

create table T_PLM_CFG_CATEGORY(

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 '创建时间'

,FPARENTID bigint not null  comment '父业务类型'

,FCODERULEID varchar(36) default null  comment '编码规则'

,FTYPEID int not null  comment 'pdm类型'

,FLIFECYCLETEMPLATE int not null  comment '生命周期模板'

,FMAJORSTRUCT bigint not null  comment '大版本序列'

,FSEPARATE nvarchar(50) default null  comment '分隔符'

,FMINORSTRUCT bigint not null  comment '小版本序列'

,FMODIFIERID int not null  comment '修改人'

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

,FIMAGEICON image default null  comment '图标'

,FCBINSTANCE char(1) default ''1''  comment '实例化'

,FCBMULINSTANCE char(1) default ''0''  comment '允许生成多个实例'

,FISENABLEFORM char(1) default ''0''  comment '启用表单'

,FISRELATIONTYPE char(1) default ''0''  comment '关系类型'

,FISENABLECHECKIN char(1) default ''0''  comment '启用检入/检出继承'

,FPERMISSIONOBJECTID nvarchar(50) default null  comment '权限项id'

,FPERMISSIONOBJECTNAME nvarchar(50) default null  comment '权限项名称'

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

,FDEFAULTATTFOLDER bigint not null  comment '默认附件文件夹'

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

,FSPLITPOSITION int not null  comment '是否用分隔容器呈现'

,FCUSTOMSETTINGS nvarchar(2000) not null  comment '自定义设置参数'

,FENABLELINK char(1) not null  comment '字段是否启用连接分隔符'

,primary key (FID)

) comment = '业务类型'

--查询--

select FID as "fid",FMasterID as "fmasterid",FCODE as "fcode",FCREATORID as "fcreatorid",FCREATEDATE as "fcreatedate",FPARENTID as "fparentid",FCODERULEID as "fcoderuleid",FTYPEID as "ftypeid",FLIFECYCLETEMPLATE as "flifecycletemplate",FMAJORSTRUCT as "fmajorstruct",FSEPARATE as "fseparate",FMINORSTRUCT as "fminorstruct",FMODIFIERID as "fmodifierid",FMODIFYDATE as "fmodifydate",FIMAGEICON as "fimageicon",FCBINSTANCE as "fcbinstance",FCBMULINSTANCE as "fcbmulinstance",FISENABLEFORM as "fisenableform",FISRELATIONTYPE as "fisrelationtype",FISENABLECHECKIN as "fisenablecheckin",FPERMISSIONOBJECTID as "fpermissionobjectid",FPERMISSIONOBJECTNAME as "fpermissionobjectname",FNAME as "fname",FDEFAULTATTFOLDER as "fdefaultattfolder",FISJOINTHINKTANK as "fisjointhinktank",FSPLITPOSITION as "fsplitposition",FCUSTOMSETTINGS as "fcustomsettings",FENABLELINK as "fenablelink" from T_PLM_CFG_CATEGORY

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

select FID as "主键",FMasterID as "组织id",FCODE as "编码",FCREATORID as "创建人",FCREATEDATE as "创建时间",FPARENTID as "父业务类型",FCODERULEID as "编码规则",FTYPEID as "pdm类型",FLIFECYCLETEMPLATE as "生命周期模板",FMAJORSTRUCT as "大版本序列",FSEPARATE as "分隔符",FMINORSTRUCT as "小版本序列",FMODIFIERID as "修改人",FMODIFYDATE as "修改日期",FIMAGEICON as "图标",FCBINSTANCE as "实例化",FCBMULINSTANCE as "允许生成多个实例",FISENABLEFORM as "启用表单",FISRELATIONTYPE as "关系类型",FISENABLECHECKIN as "启用检入/检出继承",FPERMISSIONOBJECTID as "权限项id",FPERMISSIONOBJECTNAME as "权限项名称",FNAME as "名称",FDEFAULTATTFOLDER as "默认附件文件夹",FISJOINTHINKTANK as "是否纳入研发智库",FSPLITPOSITION as "是否用分隔容器呈现",FCUSTOMSETTINGS as "自定义设置参数",FENABLELINK as "字段是否启用连接分隔符" from T_PLM_CFG_CATEGORY

--INSERT脚本--

insert into T_PLM_CFG_CATEGORY(FID,FMasterID,FCODE,FCREATORID,FCREATEDATE,FPARENTID,FCODERULEID,FTYPEID,FLIFECYCLETEMPLATE,FMAJORSTRUCT,FSEPARATE,FMINORSTRUCT,FMODIFIERID,FMODIFYDATE,FIMAGEICON,FCBINSTANCE,FCBMULINSTANCE,FISENABLEFORM,FISRELATIONTYPE,FISENABLECHECKIN,FPERMISSIONOBJECTID,FPERMISSIONOBJECTNAME,FNAME,FDEFAULTATTFOLDER,FISJOINTHINKTANK,FSPLITPOSITION,FCUSTOMSETTINGS,FENABLELINK) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)

--UPDATE脚本--

update T_PLM_CFG_CATEGORY set FID=?,FMasterID=?,FCODE=?,FCREATORID=?,FCREATEDATE=?,FPARENTID=?,FCODERULEID=?,FTYPEID=?,FLIFECYCLETEMPLATE=?,FMAJORSTRUCT=?,FSEPARATE=?,FMINORSTRUCT=?,FMODIFIERID=?,FMODIFYDATE=?,FIMAGEICON=?,FCBINSTANCE=?,FCBMULINSTANCE=?,FISENABLEFORM=?,FISRELATIONTYPE=?,FISENABLECHECKIN=?,FPERMISSIONOBJECTID=?,FPERMISSIONOBJECTNAME=?,FNAME=?,FDEFAULTATTFOLDER=?,FISJOINTHINKTANK=?,FSPLITPOSITION=?,FCUSTOMSETTINGS=?,FENABLELINK=? where FID=?

--delete脚本--

delete from T_PLM_CFG_CATEGORY where FID=?

--给字段加备注--

alter table T_PLM_CFG_CATEGORY comment '业务类型';

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

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

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

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

alter table T_PLM_CFG_CATEGORY modify column FCREATEDATE datetime default null  comme