--建表脚本--
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 comment '创建时间';
alter table T_PLM_CFG_CATEGORY modify column FPARENTID bigint not null comment '父业务类型';
alter table T_PLM_CFG_CATEGORY modify column FCODERULEID varchar(36) default null comment '编码规则';
alter table T_PLM_CFG_CATEGORY modify column FTYPEID int not null comment 'pdm类型';
alter table T_PLM_CFG_CATEGORY modify column FLIFECYCLETEMPLATE int not null comment '生命周期模板';
alter table T_PLM_CFG_CATEGORY modify column FMAJORSTRUCT bigint not null comment '大版本序列';
alter table T_PLM_CFG_CATEGORY modify column FSEPARATE nvarchar(50) default null comment '分隔符';
alter table T_PLM_CFG_CATEGORY modify column FMINORSTRUCT bigint not null comment '小版本序列';
alter table T_PLM_CFG_CATEGORY modify column FMODIFIERID int not null comment '修改人';
alter table T_PLM_CFG_CATEGORY modify column FMODIFYDATE datetime default null comment '修改日期';
alter table T_PLM_CFG_CATEGORY modify column FIMAGEICON image default null comment '图标';
alter table T_PLM_CFG_CATEGORY modify column FCBINSTANCE char(1) default ''1'' comment '实例化';
alter table T_PLM_CFG_CATEGORY modify column FCBMULINSTANCE char(1) default ''0'' comment '允许生成多个实例';
alter table T_PLM_CFG_CATEGORY modify column FISENABLEFORM char(1) default ''0'' comment '启用表单';
alter table T_PLM_CFG_CATEGORY modify column FISRELATIONTYPE char(1) default ''0'' comment '关系类型';
alter table T_PLM_CFG_CATEGORY modify column FISENABLECHECKIN char(1) default ''0'' comment '启用检入/检出继承';
alter table T_PLM_CFG_CATEGORY modify column FPERMISSIONOBJECTID nvarchar(50) default null comment '权限项id';
alter table T_PLM_CFG_CATEGORY modify column FPERMISSIONOBJECTNAME nvarchar(50) default null comment '权限项名称';
alter table T_PLM_CFG_CATEGORY modify column FNAME nvarchar(50) default null comment '名称';
alter table T_PLM_CFG_CATEGORY modify column FDEFAULTATTFOLDER bigint not null comment '默认附件文件夹';
alter table T_PLM_CFG_CATEGORY modify column FISJOINTHINKTANK char(1) not null comment '是否纳入研发智库';
alter table T_PLM_CFG_CATEGORY modify column FSPLITPOSITION int not null comment '是否用分隔容器呈现';
alter table T_PLM_CFG_CATEGORY modify column FCUSTOMSETTINGS nvarchar(2000) not null comment '自定义设置参数';
alter table T_PLM_CFG_CATEGORY modify column FENABLELINK char(1) not null comment '字段是否启用连接分隔符';
--建表脚本--
create table T_PLM_CFG_CATEGORYEXTEND(
FID bigint not null comment '主键'
,FCATEGORYID bigint not null comment '业务类型id'
,FSN int not null comment '序号'
,FISSHOW char(1) not null comment '是否显示'
,FISREADONLY char(1) not null comment '是否只读'
,FISMUST char(1) not null comment '是否必填'
,FISSHOWLIST char(1) not null comment '是否列表显示'
,FENUMNAME nvarchar(50) default null comment '枚举类型'
,FDEFAULT nvarchar(50) default null comment '默认值'
,FGROUP nvarchar(50) default null comment '分组'
,FBASETYPE nvarchar(50) default null comment '基础资料'
,FEXTENDID bigint not null comment '字段'
,FFIELDTYPE int not null comment '字段类型'
,FFUNCTIONDEFAULT nvarchar(200) default null comment '默认方法'
,FEXTENDNAME nvarchar(50) default null comment '别名'
,FISFORMSHOW char(1) default ''0'' comment '申请单显示'
,FISTABSHOW char(1) default ''1'' comment '页签显示'
,FFORMATSETTING nvarchar(500) not null comment '数据格式定义'
,FMATEXTENDID bigint not null comment '关联物料属性'
,FFLOWMAINTAIN varchar(20) not null comment '流程维护'
,FEXTENDCATEGORYID bigint default 0 comment '物料业务类型'
,primary key (FID)
) comment = '扩展字段关系'
--查询--
select FID as "fid",FCATEGORYID as "fcategoryid",FSN as "fsn",FISSHOW as "fisshow",FISREADONLY as "fisreadonly",FISMUST as "fismust",FISSHOWLIST as "fisshowlist",FENUMNAME as "fenumname",FDEFAULT as "fdefault",FGROUP as "fgroup",FBASETYPE as "fbasetype",FEXTENDID as "fextendid",FFIELDTYPE as "ffieldtype",FFUNCTIONDEFAULT as "ffunctiondefault",FEXTENDNAME as "fextendname",FISFORMSHOW as "fisformshow",FISTABSHOW as "fistabshow",FFORMATSETTING as "fformatsetting",FMATEXTENDID as "fmatextendid",FFLOWMAINTAIN as "fflowmaintain",FEXTENDCATEGORYID as "fextendcategoryid" from T_PLM_CFG_CATEGORYEXTEND
--查询(中文字段)--
select FID as "主键",FCATEGORYID as "业务类型id",FSN as "序号",FISSHOW as "是否显示",FISREADONLY as "是否只读",FISMUST as "是否必填",FISSHOWLIST as "是否列表显示",FENUMNAME as "枚举类型",FDEFAULT as "默认值",FGROUP as "分组",FBASETYPE as "基础资料",FEXTENDID as "字段",FFIELDTYPE as "字段类型",FFUNCTIONDEFAULT as "默认方法",FEXTENDNAME as "别名",FISFORMSHOW as "申请单显示",FISTABSHOW as "页签显示",FFORMATSETTING as "数据格式定义",FMATEXTENDID as "关联物料属性",FFLOWMAINTAIN as "流程维护",FEXTENDCATEGORYID as "物料业务类型" from T_PLM_CFG_CATEGORYEXTEND
--INSERT脚本--
insert into T_PLM_CFG_CATEGORYEXTEND(FID,FCATEGORYID,FSN,FISSHOW,FISREADONLY,FISMUST,FISSHOWLIST,FENUMNAME,FDEFAULT,FGROUP,FBASETYPE,FEXTENDID,FFIELDTYPE,FFUNCTIONDEFAULT,FEXTENDNAME,FISFORMSHOW,FISTABSHOW,FFORMATSETTING,FMATEXTENDID,FFLOWMAINTAIN,FEXTENDCATEGORYID) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
--UPDATE脚本--
update T_PLM_CFG_CATEGORYEXTEND set FID=?,FCATEGORYID=?,FSN=?,FISSHOW=?,FISREADONLY=?,FISMUST=?,FISSHOWLIST=?,FENUMNAME=?,FDEFAULT=?,FGROUP=?,FBASETYPE=?,FEXTENDID=?,FFIELDTYPE=?,FFUNCTIONDEFAULT=?,FEXTENDNAME=?,FISFORMSHOW=?,FISTABSHOW=?,FFORMATSETTING=?,FMATEXTENDID=?,FFLOWMAINTAIN=?,FEXTENDCATEGORYID=? where FID=?
--delete脚本--
delete from T_PLM_CFG_CATEGORYEXTEND where FID=?
--给字段加备注--
alter table T_PLM_CFG_CATEGORYEXTEND comment '扩展字段关系';
alter table T_PLM_CFG_CATEGORYEXTEND modify column FID bigint not null comment '主键';
alter table T_PLM_CFG_CATEGORYEXTEND modify column FCATEGORYID bigint not null comment '业务类型id';
alter table T_PLM_CFG_CATEGORYEXTEND modify column FSN int not null comment '序号';
alter table T_PLM_CFG_CATEGORYEXTEND modify column FISSHOW char(1) not null comment '是否显示';
alter table T_PLM_CFG_CATEGORYEXTEND modify column FISREADONLY char(1) not null comment '是否只读';
alter table T_PLM_CFG_CATEGORYEXTEND modify column FISMUST char(1) not null comment '是否必填';
alter table T_PLM_CFG_CATEGORYEXTEND modify column FISSHOWLIST char(1) not null comment '是否列表显示';
alter table T_PLM_CFG_CATEGORYEXTEND modify column FENUMNAME nvarchar(50) default null comment '枚举类型';
alter table T_PLM_CFG_CATEGORYEXTEND modify column FDEFAULT nvarchar(50) default null comment '默认值';
alter table T_PLM_CFG_CATEGORYEXTEND modify column FGROUP nvarchar(50) default null comment '分组';
alter table T_PLM_CFG_CATEGORYEXTEND modify column FBASETYPE nvarchar(50) default null comment '基础资料';
alter table T_PLM_CFG_CATEGORYEXTEND modify column FEXTENDID bigint not null comment '字段';
alter table T_PLM_CFG_CATEGORYEXTEND modify column FFIELDTYPE int not null comment '字段类型';
alter table T_PLM_CFG_CATEGORYEXTEND modify column FFUNCTIONDEFAULT nvarchar(200) default null comment '默认方法';
alter table T_PLM_CFG_CATEGORYEXTEND modify column FEXTENDNAME nvarchar(50) default null comment '别名';
alter table T_PLM_CFG_CATEGORYEXTEND modify column FISFORMSHOW char(1) default ''0'' comment '申请单显示';
alter table T_PLM_CFG_CATEGORYEXTEND modify column FISTABSHOW char(1) default ''1'' comment '页签显示';
alter table T_PLM_CFG_CATEGORYEXTEND modify column FFORMATSETTING nvarchar(500) not null comment '数据格式定义';
alter table T_PLM_CFG_CATEGORYEXTEND modify column FMATEXTENDID bigint not null comment '关联物料属性';
alter table T_PLM_CFG_CATEGORYEXTEND modify column FFLOWMAINTAIN varchar(20) not null comment '流程维护';
alter table T_PLM_CFG_CATEGORYEXTEND modify column FEXTENDCATEGORYID bigint default 0 comment '物料业务类型';
推荐阅读