--建表脚本--

create table T_PLM_CFG_COMPLETE_CHECK_L(

FPKID bigint not null  comment 'FPKID'

,FID bigint not null  comment 'FID'

,FLocaleID int not null  comment 'FLocaleID'

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

,FOPERATIONNAME nvarchar(200) not null  comment '操作名称'

,primary key (FPKID)

) comment = '完整性检查规则多语言'

--查询--

select FPKID as "fpkid",FID as "fid",FLocaleID as "flocaleid",FNAME as "fname",FOPERATIONNAME as "foperationname" from T_PLM_CFG_COMPLETE_CHECK_L

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

select FPKID as "FPKID",FID as "FID",FLocaleID as "FLocaleID",FNAME as "名称",FOPERATIONNAME as "操作名称" from T_PLM_CFG_COMPLETE_CHECK_L

--INSERT脚本--

insert into T_PLM_CFG_COMPLETE_CHECK_L(FPKID,FID,FLocaleID,FNAME,FOPERATIONNAME) values (?,?,?,?,?)

--UPDATE脚本--

update T_PLM_CFG_COMPLETE_CHECK_L set FPKID=?,FID=?,FLocaleID=?,FNAME=?,FOPERATIONNAME=? where FPKID=?

--delete脚本--

delete from T_PLM_CFG_COMPLETE_CHECK_L where FPKID=?

--给字段加备注--

alter table T_PLM_CFG_COMPLETE_CHECK_L comment '完整性检查规则多语言';

alter table T_PLM_CFG_COMPLETE_CHECK_L modify column FPKID bigint not null  comment 'FPKID';

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

alter table T_PLM_CFG_COMPLETE_CHECK_L modify column FLocaleID int not null  comment 'FLocaleID';

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

alter table T_PLM_CFG_COMPLETE_CHECK_L modify column FOPERATIONNAME nvarchar(200) not null  comment '操作名称';

--建表脚本--

create table T_PLM_CFG_CONTROLRULE(

FID int not null  comment '规则标识'

,FRULETYPE varchar(20) not null  comment '规则类型'

,FOPTIONGROUP int not null  comment '规则分组标识'

,FSEQ int not null  comment '规则序号'

,FNUMBER nvarchar(100) not null  comment '规则编码'

,FCATEGORY bigint not null  comment '所属业务类型'

,FCONTROLKEY nvarchar(600) not null  comment '控件标识'

,primary key (FID)

) comment = '控制规则项'

--查询--

select FID as "fid",FRULETYPE as "fruletype",FOPTIONGROUP as "foptiongroup",FSEQ as "fseq",FNUMBER as "fnumber",FCATEGORY as "fcategory",FCONTROLKEY as "fcontrolkey" from T_PLM_CFG_CONTROLRULE

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

select FID as "规则标识",FRULETYPE as "规则类型",FOPTIONGROUP as "规则分组标识",FSEQ as "规则序号",FNUMBER as "规则编码",FCATEGORY as "所属业务类型",FCONTROLKEY as "控件标识" from T_PLM_CFG_CONTROLRULE

--INSERT脚本--

insert into T_PLM_CFG_CONTROLRULE(FID,FRULETYPE,FOPTIONGROUP,FSEQ,FNUMBER,FCATEGORY,FCONTROLKEY) values (?,?,?,?,?,?,?)

--UPDATE脚本--

update T_PLM_CFG_CONTROLRULE set FID=?,FRULETYPE=?,FOPTIONGROUP=?,FSEQ=?,FNUMBER=?,FCATEGORY=?,FCONTROLKEY=? where FID=?

--delete脚本--

delete from T_PLM_CFG_CONTROLRULE where FID=?

--给字段加备注--

alter table T_PLM_CFG_CONTROLRULE comment '控制规则项';

alter table T_PLM_CFG_CONTROLRULE modify column FID int not null  comment '规则标识';

alter table T_PLM_CFG_CONTROLRULE modify column FRULETYPE varchar(20) not null  comment '规则类型';

alter table T_PLM_CFG_CONTROLRULE modify column FOPTIONGROUP int not null  comment '规则分组标识';

alter table T_PLM_CFG_CONTROLRULE modify column FSEQ int not null  comment '规则序号';

alter table T_PLM_CFG_CONTROLRULE modify column FNUMBER nvarchar(100) not null  comment '规则编码';

alter table T_PLM_CFG_CONTROLRULE modify column FCATEGORY bigint not null  comment '所属业务类型';

alter table T_PLM_CFG_CONTROLRULE modify column FCONTROLKEY nvarchar(600) not null  comment '控件标识';

--建表脚本--

create table T_PLM_CFG_CONTROLRULE_L(

FPKID bigint not null  comment '主键标识'

,FID bigint not null  comment '规则标识'

,FLocaleID int not null  comment '语言标识'

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

,FDESCRIPTION nvarchar(800) not null  comment '描述'

,primary key (FPKID)

) comment = '控制规则项多语言'

--查询--

select FPKID as "fpkid",FID as "fid",FLocaleID as "flocaleid",FNAME as "fname",FDESCRIPTION as "fdescription" from T_PLM_CFG_CONTROLRULE_L

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

select FPKID as "主键标识",FID as "规则标识",FLocaleID as "语言标识",FNAME as "名称",FDESCRIPTION as "描述" from T_PLM_CFG_CONTROLRULE_L

--INSERT脚本--

insert into T_PLM_CFG_CONTROLRULE_L(FPKID,FID,FLocaleID,FNAME,FDESCRIPTION) values (?,?,?,?,?)

--UPDATE脚本--

update T_PLM_CFG_CONTROLRULE_L set FPKID=?,FID=?,FLocaleID=?,FNAME=?,FDESCRIPTION=? where FPKID=?

--delete脚本--

delete from T_PLM_CFG_CONTROLRULE_L where FPKID=?

--给字段加备注--

alter table T_PLM_CFG_CONTROLRULE_L comment '控制规则项多语言';

alter table T_PLM_CFG_CONTROLRULE_L modify column FPKID bigint not null  comment '主键标识';

alter table T_PLM_CFG_CONTROLRULE_L modify column FID bigint not null  comment '规则标识';

alter table T_PLM_CFG_CONTROLRULE_L modify column FLocaleID int not null  comment '语言标识';

alter table T_PLM_CFG_CONTROLRULE_L modify column FNAME nvarchar(100) not null  comment '名称';

alter table T_PLM_CFG_CONTROLRULE_L modify column FDESCRIPTION nvarchar(800) not null  comment '描述';

--建表脚本--

create table T_PLM_CFG_CONVERT_CONFIG(

FPKID bigint not null  comment 'FPKID'

,FENTRYID bigint not null  comment 'FENTRYID'

,FCONVERTOTHERTYPE bigint not null  comment '转换为其它文件类型'

,primary key (FPKID)

) comment = '转换配置表'

--查询--

select FPKID as "fpkid",FENTRYID as "fentryid",FCONVERTOTHERTYPE as "fconvertothertype" from T_PLM_CFG_CONVERT_CONFIG

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

select FPKID as "FPKID",FENTRYID as "FENTRYID",FCONVERTOTHERTYPE as "转换为其它文件类型" from T_PLM_CFG_CONVERT_CONFIG

--INSERT脚本--

insert into T_PLM_CFG_CONVERT_CONFIG(FPKID,FENTRYID,FCONVERTOTHERTYPE) values (?,?,?)

--UPDATE脚本--

update T_PLM_CFG_CONVERT_CONFIG set FPKID=?,FENTRYID=?,FCONVERTOTHERTYPE=? where FPKID=?

--delete脚本--

delete from T_PLM_CFG_CONVERT_CONFIG where FPKID=?

--给字段加备注--

alter table T_PLM_CFG_CONVERT_CONFIG comment '转换配置表';

alter table T_PLM_CFG_CONVERT_CONFIG modify column FPKID bigint not null  comment 'FPKID';

alter table T_PLM_CFG_CONVERT_CONFIG modify column FENTRYID bigint not null  comment 'FENTRYID';

alter table T_PLM_CFG_CONVERT_CONFIG modify column FCONVERTOTHERTYPE bigint not null  comment '转换为其它文件类型';

--建表脚本--

create table T_PLM_CFG_CONVERT_FILE(

FID bigint not null  comment 'FID'

,FOBJECTID bigint not null  comment '文件基对象id'

,FFILEID nvarchar(100) not null  comment '文件id'

,FRELEVANTOBJECT nvarchar(100) not null  comment '关联对象id'

,FSUFFIX nvarchar(100) not null  comment '后缀'

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

,primary key (FID)

) comment = '文件转换对象'

--查询--

select FID as "fid",FOBJECTID as "fobjectid",FFILEID as "ffileid",FRELEVANTOBJECT as "frelevantobject",FSUFFIX as "fsuffix",FCREATEDATE as "fcreatedate" from T_PLM_CFG_CONVERT_FILE

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

select FID as "FID",FOBJECTID as "文件基对象id",FFILEID as "文件id",FRELEVANTOBJECT as "关联对象id",FSUFFIX as "后缀",FCREATEDATE as "创建日期" from T_PLM_CFG_CONVERT_FILE

--INSERT脚本--

insert into T_PLM_CFG_CONVERT_FILE(FID,FOBJECTID,FFILEID,FRELEVANTOBJECT,FSUFFIX,FCREATEDATE) values (?,?,?,?,?,?)

--UPDATE脚本--

update T_PLM_CFG_CONVERT_FILE set FID=?,FOBJECTID=?,FFILEID=?,FRELEVANTOBJECT=?,FSUFFIX=?,FCREATEDATE=? where FID=?

--delete脚本--

delete from T_PLM_CFG_CONVERT_FILE where FID=?

--给字段加备注--

alter table T_PLM_CFG_CONVERT_FILE comment '文件转换对象';

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

alter table T_PLM_CFG_CONVERT_FILE modify column FOBJECTID bigint not null  comment '文件基对象id';

alter table T_PLM_CFG_CONVERT_FILE modify column FFILEID nvarchar(100) not null  comment '文件id';

alter table T_PLM_CFG_CONVERT_FILE modify column FRELEVANTOBJECT nvarchar(100) not null  comment '关联对象id';

alter table T_PLM_CFG_CONVERT_FILE modify column FSUFFIX nvarchar(100) not null  comment '后缀';

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

--建表脚本--

create table T_PLM_CFG_CONVERT_FILETYPE(

FID bigint not null  comment 'FID'

,FMASTERID bigint not null  comment 'FMASTERID'

,FCODE nvarchar(100) not null  comment '编码'

,FCONVERTSUFFIX nvarchar(100) not null  comment '转换后缀'

,primary key (FID)

) comment = '转换文件类型表'

--查询--

select FID as "fid",FMASTERID as "fmasterid",FCODE as "fcode",FCONVERTSUFFIX as "fconvertsuffix" from T_PLM_CFG_CONVERT_FILETYPE

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

select FID as "FID",FMASTERID as "FMASTERID",FCODE as "编码",FCONVERTSUFFIX as "转换后缀" from T_PLM_CFG_CONVERT_FILETYPE

--INSERT脚本--

insert into T_PLM_CFG_CONVERT_FILETYPE(FID,FMASTERID,FCODE,FCONVERTSUFFIX) values (?,?,?,?)

--UPDATE脚本--

update T_PLM_CFG_CONVERT_FILETYPE set FID=?,FMASTERID=?,FCODE=?,FCONVERTSUFFIX=? where FID=?

--delete脚本--

delete from T_PLM_CFG_CONVERT_FILETYPE where FID=?

--给字段加备注--

alter table T_PLM_CFG_CONVERT_FILETYPE comment '转换文件类型表';

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

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

alter table T_PLM_CFG_CONVERT_FILETYPE modify column FCODE nvarchar(100) not null  comment '编码';

alter table T_PLM_CFG_CONVERT_FILETYPE modify column FCONVERTSUFFIX nvarchar(100) not null  comment '转换后缀';

--建表脚本--

create table T_PLM_CFG_DOCSHARERULE(

FID bigint not null  comment 'FID'

,FMasterID bigint not null  comment 'FMasterID'

,FMATCATAGORY bigint not null  comment '物料业务类型'

,FDOCCATAGORY bigint not null  comment '文档业务类型'

,FFILETYPE bigint not null  comment '文件类型'

,FLIFECYCLESTAGE bigint not null  comment '生命周期阶段'

,primary key (FID)

) comment = '文档共享集成配置规则表'

--查询--

select FID as "fid",FMasterID as "fmasterid",FMATCATAGORY as "fmatcatagory",FDOCCATAGORY as "fdoccatagory",FFILETYPE as "ffiletype",FLIFECYCLESTAGE as "flifecyclestage" from T_PLM_CFG_DOCSHARERULE

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

select FID as "FID",FMasterID as "FMasterID",FMATCATAGORY as "物料业务类型",FDOCCATAGORY as "文档业务类型",FFILETYPE as "文件类型",FLIFECYCLESTAGE as "生命周期阶段" from T_PLM_CFG_DOCSHARERULE

--INSERT脚本--

insert into T_PLM_CFG_DOCSHARERULE(FID,FMasterID,FMATCATAGORY,FDOCCATAGORY,FFILETYPE,FLIFECYCLESTAGE) values (?,?,?,?,?,?)

--UPDATE脚本--

update T_PLM_CFG_DOCSHARERULE set FID=?,FMasterID=?,FMATCATAGORY=?,FDOCCATAGORY=?,FFILETYPE=?,FLIFECYCLESTAGE=? where FID=?

--delete脚本--

delete from T_PLM_CFG_DOCSHARERULE where FID=?

--给字段加备注--

alter table T_PLM_CFG_DOCSHARERULE comment '文档共享集成配置规则表';

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

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

alter table T_PLM_CFG_DOCSHARERULE modify column FMATCATAGORY bigint not null  comment '物料业务类型';

alter table T_PLM_CFG_DOCSHARERULE modify column FDOCCATAGORY bigint not null  comment '文档业务类型';

alter table T_PLM_CFG_DOCSHARERULE modify column FFILETYPE bigint not null  comment '文件类型';

alter table T_PLM_CFG_DOCSHARERULE modify column FLIFECYCLESTAGE bigint not null  comment '生命周期阶段';