PLM模块关联内容（二）

--建表脚本--

create table T_PLM_CFG_AD_SYNCDATA(

FID bigint not null  comment 'FID'

,FRESULT char(1) not null  comment '同步结果'

,FSYNCDATE datetime default null  comment '同步时间'

,FMESSAGE nvarchar(50) not null  comment '信息异常失败信息'

,primary key (FID)

) comment = 'ad数据同步记录表'

--查询--

select FID as "fid",FRESULT as "fresult",FSYNCDATE as "fsyncdate",FMESSAGE as "fmessage" from T_PLM_CFG_AD_SYNCDATA

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

select FID as "FID",FRESULT as "同步结果",FSYNCDATE as "同步时间",FMESSAGE as "信息异常失败信息" from T_PLM_CFG_AD_SYNCDATA

--INSERT脚本--

insert into T_PLM_CFG_AD_SYNCDATA(FID,FRESULT,FSYNCDATE,FMESSAGE) values (?,?,?,?)

--UPDATE脚本--

update T_PLM_CFG_AD_SYNCDATA set FID=?,FRESULT=?,FSYNCDATE=?,FMESSAGE=? where FID=?

--delete脚本--

delete from T_PLM_CFG_AD_SYNCDATA where FID=?

--给字段加备注--

alter table T_PLM_CFG_AD_SYNCDATA comment 'ad数据同步记录表';

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

alter table T_PLM_CFG_AD_SYNCDATA modify column FRESULT char(1) not null  comment '同步结果';

alter table T_PLM_CFG_AD_SYNCDATA modify column FSYNCDATE datetime default null  comment '同步时间';

alter table T_PLM_CFG_AD_SYNCDATA modify column FMESSAGE nvarchar(50) not null  comment '信息异常失败信息';

--建表脚本--

create table T_PLM_CFG_AFMATFGCFG(

FID bigint not null  comment 'FID'

,FMasterID bigint not null  comment 'FMasterID'

,FAPPLYFORMCATEGORYID bigint not null  comment '申请单业务类型id'

,FMATFIELDID bigint not null  comment '物料字段id'

,FMATFIELDGROUPID bigint not null  comment '物料字段分组id'

,primary key (FID)

) comment = '申请单物料字段分组配置表'

--查询--

select FID as "fid",FMasterID as "fmasterid",FAPPLYFORMCATEGORYID as "fapplyformcategoryid",FMATFIELDID as "fmatfieldid",FMATFIELDGROUPID as "fmatfieldgroupid" from T_PLM_CFG_AFMATFGCFG

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

select FID as "FID",FMasterID as "FMasterID",FAPPLYFORMCATEGORYID as "申请单业务类型id",FMATFIELDID as "物料字段id",FMATFIELDGROUPID as "物料字段分组id" from T_PLM_CFG_AFMATFGCFG

--INSERT脚本--

insert into T_PLM_CFG_AFMATFGCFG(FID,FMasterID,FAPPLYFORMCATEGORYID,FMATFIELDID,FMATFIELDGROUPID) values (?,?,?,?,?)

--UPDATE脚本--

update T_PLM_CFG_AFMATFGCFG set FID=?,FMasterID=?,FAPPLYFORMCATEGORYID=?,FMATFIELDID=?,FMATFIELDGROUPID=? where FID=?

--delete脚本--

delete from T_PLM_CFG_AFMATFGCFG where FID=?

--给字段加备注--

alter table T_PLM_CFG_AFMATFGCFG comment '申请单物料字段分组配置表';

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

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

alter table T_PLM_CFG_AFMATFGCFG modify column FAPPLYFORMCATEGORYID bigint not null  comment '申请单业务类型id';

alter table T_PLM_CFG_AFMATFGCFG modify column FMATFIELDID bigint not null  comment '物料字段id';

alter table T_PLM_CFG_AFMATFGCFG modify column FMATFIELDGROUPID bigint not null  comment '物料字段分组id';

--建表脚本--

create table T_PLM_CFG_AMR_BASE(

FID bigint not null  comment 'FID'

,FMasterID bigint not null  comment 'FMasterID'

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

,FISINPLAN char(1) not null  comment '是否应用执行计划'

,FDATETIME datetime default null  comment '上次执行时间'

,FCHECKOUTPATH nvarchar(200) not null  comment '检出路径'

,primary key (FID)

) comment = '自动匹配规则单据头'

--查询--

select FID as "fid",FMasterID as "fmasterid",FAMRNAME as "famrname",FISINPLAN as "fisinplan",FDATETIME as "fdatetime",FCHECKOUTPATH as "fcheckoutpath" from T_PLM_CFG_AMR_BASE

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

select FID as "FID",FMasterID as "FMasterID",FAMRNAME as "名称",FISINPLAN as "是否应用执行计划",FDATETIME as "上次执行时间",FCHECKOUTPATH as "检出路径" from T_PLM_CFG_AMR_BASE

--INSERT脚本--

insert into T_PLM_CFG_AMR_BASE(FID,FMasterID,FAMRNAME,FISINPLAN,FDATETIME,FCHECKOUTPATH) values (?,?,?,?,?,?)

--UPDATE脚本--

update T_PLM_CFG_AMR_BASE set FID=?,FMasterID=?,FAMRNAME=?,FISINPLAN=?,FDATETIME=?,FCHECKOUTPATH=? where FID=?

--delete脚本--

delete from T_PLM_CFG_AMR_BASE where FID=?

--给字段加备注--

alter table T_PLM_CFG_AMR_BASE comment '自动匹配规则单据头';

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

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

alter table T_PLM_CFG_AMR_BASE modify column FAMRNAME nvarchar(100) not null  comment '名称';

alter table T_PLM_CFG_AMR_BASE modify column FISINPLAN char(1) not null  comment '是否应用执行计划';

alter table T_PLM_CFG_AMR_BASE modify column FDATETIME datetime default null  comment '上次执行时间';

alter table T_PLM_CFG_AMR_BASE modify column FCHECKOUTPATH nvarchar(200) not null  comment '检出路径';

--建表脚本--

create table T_PLM_CFG_AMR_BASE_L(

FPKID bigint not null  comment 'FPKID'

,FID bigint not null  comment 'FID'

,FLocaleID int not null  comment 'FLocaleID'

,FDOCMULLANG nvarchar(200) not null  comment '文档'

,FMATMULLANG nvarchar(200) not null  comment '物料'

,primary key (FPKID)

) comment = '自动匹配规则单据头多语言'

--查询--

select FPKID as "fpkid",FID as "fid",FLocaleID as "flocaleid",FDOCMULLANG as "fdocmullang",FMATMULLANG as "fmatmullang" from T_PLM_CFG_AMR_BASE_L

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

select FPKID as "FPKID",FID as "FID",FLocaleID as "FLocaleID",FDOCMULLANG as "文档",FMATMULLANG as "物料" from T_PLM_CFG_AMR_BASE_L

--INSERT脚本--

insert into T_PLM_CFG_AMR_BASE_L(FPKID,FID,FLocaleID,FDOCMULLANG,FMATMULLANG) values (?,?,?,?,?)

--UPDATE脚本--

update T_PLM_CFG_AMR_BASE_L set FPKID=?,FID=?,FLocaleID=?,FDOCMULLANG=?,FMATMULLANG=? where FPKID=?

--delete脚本--

delete from T_PLM_CFG_AMR_BASE_L where FPKID=?

--给字段加备注--

alter table T_PLM_CFG_AMR_BASE_L comment '自动匹配规则单据头多语言';

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

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

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

alter table T_PLM_CFG_AMR_BASE_L modify column FDOCMULLANG nvarchar(200) not null  comment '文档';

alter table T_PLM_CFG_AMR_BASE_L modify column FMATMULLANG nvarchar(200) not null  comment '物料';

--建表脚本--

create table T_PLM_CFG_AMR_CONDITION(

FEntryID bigint not null  comment 'FEntryID'

,FID bigint not null  comment 'FID'

,FDOCFIELD bigint not null  comment '文档字段'

,FMATFIELD bigint not null  comment '物料字段'

,FMATCHCONDITION varchar(200) not null  comment '匹配条件'

,FDOCSTART int not null  comment '文档开始位置'

,FDOCEND int not null  comment '文档结束位置'

,FMATSTART int not null  comment '物料开始位置'

,FMATEND int not null  comment '物料结束位置'

,FCASESENSITIVE char(1) not null  comment '是否大小写敏感'

,FREGEXPRESSION varchar(500) not null  comment '配置表达式'

,primary key (FEntryID)

) comment = '自动匹配规则单据体'

--查询--

select FEntryID as "fentryid",FID as "fid",FDOCFIELD as "fdocfield",FMATFIELD as "fmatfield",FMATCHCONDITION as "fmatchcondition",FDOCSTART as "fdocstart",FDOCEND as "fdocend",FMATSTART as "fmatstart",FMATEND as "fmatend",FCASESENSITIVE as "fcasesensitive",FREGEXPRESSION as "fregexpression" from T_PLM_CFG_AMR_CONDITION

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

select FEntryID as "FEntryID",FID as "FID",FDOCFIELD as "文档字段",FMATFIELD as "物料字段",FMATCHCONDITION as "匹配条件",FDOCSTART as "文档开始位置",FDOCEND as "文档结束位置",FMATSTART as "物料开始位置",FMATEND as "物料结束位置",FCASESENSITIVE as "是否大小写敏感",FREGEXPRESSION as "配置表达式" from T_PLM_CFG_AMR_CONDITION

--INSERT脚本--

insert into T_PLM_CFG_AMR_CONDITION(FEntryID,FID,FDOCFIELD,FMATFIELD,FMATCHCONDITION,FDOCSTART,FDOCEND,FMATSTART,FMATEND,FCASESENSITIVE,FREGEXPRESSION) values (?,?,?,?,?,?,?,?,?,?,?)

--UPDATE脚本--

update T_PLM_CFG_AMR_CONDITION set FEntryID=?,FID=?,FDOCFIELD=?,FMATFIELD=?,FMATCHCONDITION=?,FDOCSTART=?,FDOCEND=?,FMATSTART=?,FMATEND=?,FCASESENSITIVE=?,FREGEXPRESSION=? where FEntryID=?

--delete脚本--

delete from T_PLM_CFG_AMR_CONDITION where FEntryID=?

--给字段加备注--

alter table T_PLM_CFG_AMR_CONDITION comment '自动匹配规则单据体';

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

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

alter table T_PLM_CFG_AMR_CONDITION modify column FDOCFIELD bigint not null  comment '文档字段';

alter table T_PLM_CFG_AMR_CONDITION modify column FMATFIELD bigint not null  comment '物料字段';

alter table T_PLM_CFG_AMR_CONDITION modify column FMATCHCONDITION varchar(200) not null  comment '匹配条件';

alter table T_PLM_CFG_AMR_CONDITION modify column FDOCSTART int not null  comment '文档开始位置';

alter table T_PLM_CFG_AMR_CONDITION modify column FDOCEND int not null  comment '文档结束位置';

alter table T_PLM_CFG_AMR_CONDITION modify column FMATSTART int not null  comment '物料开始位置';

alter table T_PLM_CFG_AMR_CONDITION modify column FMATEND int not null  comment '物料结束位置';

alter table T_PLM_CFG_AMR_CONDITION modify column FCASESENSITIVE char(1) not null  comment '是否大小写敏感';

alter table T_PLM_CFG_AMR_CONDITION modify column FREGEXPRESSION varchar(500) not null  comment '配置表达式';

--建表脚本--

create table T_PLM_CFG_AMR_DOCTYPE(

FPKID bigint not null  comment 'FPKID'

,FID bigint not null  comment 'FID'

,FDOCTYPE bigint not null  comment '文档'

,primary key (FPKID)

) comment = '自动匹配规则单据头文档多选表'

--查询--

select FPKID as "fpkid",FID as "fid",FDOCTYPE as "fdoctype" from T_PLM_CFG_AMR_DOCTYPE

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

select FPKID as "FPKID",FID as "FID",FDOCTYPE as "文档" from T_PLM_CFG_AMR_DOCTYPE

--INSERT脚本--

insert into T_PLM_CFG_AMR_DOCTYPE(FPKID,FID,FDOCTYPE) values (?,?,?)

--UPDATE脚本--

update T_PLM_CFG_AMR_DOCTYPE set FPKID=?,FID=?,FDOCTYPE=? where FPKID=?

--delete脚本--

delete from T_PLM_CFG_AMR_DOCTYPE where FPKID=?

--给字段加备注--

alter table T_PLM_CFG_AMR_DOCTYPE comment '自动匹配规则单据头文档多选表';

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

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

alter table T_PLM_CFG_AMR_DOCTYPE modify column FDOCTYPE bigint not null  comment '文档';

--建表脚本--

create table T_PLM_CFG_AMR_LOG(

FID varchar(36) not null  comment 'FID'

,FMATOBJECT bigint not null  comment '物料对象'

,FDOCOBJECT bigint not null  comment '文档对象'

,FDATETIME datetime default null  comment '记录创建时间'

,primary key (FID)

) comment = '自动匹配记录'

--查询--

select FID as "fid",FMATOBJECT as "fmatobject",FDOCOBJECT as "fdocobject",FDATETIME as "fdatetime" from T_PLM_CFG_AMR_LOG

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

select FID as "FID",FMATOBJECT as "物料对象",FDOCOBJECT as "文档对象",FDATETIME as "记录创建时间" from T_PLM_CFG_AMR_LOG

--INSERT脚本--

insert into T_PLM_CFG_AMR_LOG(FID,FMATOBJECT,FDOCOBJECT,FDATETIME) values (?,?,?,?)

--UPDATE脚本--

update T_PLM_CFG_AMR_LOG set FID=?,FMATOBJECT=?,FDOCOBJECT=?,FDATETIME=? where FID=?

--delete脚本--

delete from T_PLM_CFG_AMR_LOG where FID=?

--给字段加备注--

alter table T_PLM_CFG_AMR_LOG comment '自动匹配记录';

alter table T_PLM_CFG_AMR_LOG modify column FID varchar(36) not null  comment 'FID';

alter table T_PLM_CFG_AMR_LOG modify column FMATOBJECT bigint not null  comment '物料对象';

alter table T_PLM_CFG_AMR_LOG modify column FDOCOBJECT bigint not null  comment '文档对象';

alter table T_PLM_CFG_AMR_LOG modify column FDATETIME datetime default null  comment '记录创建时间';

--建表脚本--

create table T_PLM_CFG_AMR_MATTYPE(

FPKID bigint not null  comment 'FPKID'

,FID bigint not null  comment 'FID'

,FMATTYPE bigint not null  comment '物料'

,primary key (FPKID)

) comment = '自动匹配规则单据头物料多选表'

--查询--

select FPKID as "fpkid",FID as "fid",FMATTYPE as "fmattype" from T_PLM_CFG_AMR_MATTYPE

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

select FPKID as "FPKID",FID as "FID",FMATTYPE as "物料" from T_PLM_CFG_AMR_MATTYPE

--INSERT脚本--

insert into T_PLM_CFG_AMR_MATTYPE(FPKID,FID,FMATTYPE) values (?,?,?)

--UPDATE脚本--

update T_PLM_CFG_AMR_MATTYPE set FPKID=?,FID=?,FMATTYPE=? where FPKID=?

--delete脚本--

delete from T_PLM_CFG_AMR_MATTYPE where FPKID=?

--给字段加备注--

alter table T_PLM_CFG_AMR_MATTYPE comment '自动匹配规则单据头物料多选表';

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

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

alter table T_PLM_CFG_AMR_MATTYPE modify column FMATTYPE bigint not null  comment '物料';