PLM内容专辑（四）

--建表脚本--

create table T_PLM_CFG_FIELD_CT(

FPKID nvarchar(36) not null  comment 'FPKID'

,FID bigint not null  comment 'FID'

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

,FINITDEFAULT nvarchar(50) not null  comment '默认值'

,FINITDEFAULTID nvarchar(50) not null  comment '默认id'

,FISBOMCONFIG char(1) not null  comment '是否bom配置'

,FCONFIGNAME nvarchar(255) not null  comment '配置方案名'

,FCONFIGID nvarchar(36) not null  comment '配置id'

,primary key (FPKID)

) comment = '下推配置表'

--查询--

select FPKID as "fpkid",FID as "fid",FCONNECTOR as "fconnector",FINITDEFAULT as "finitdefault",FINITDEFAULTID as "finitdefaultid",FISBOMCONFIG as "fisbomconfig",FCONFIGNAME as "fconfigname",FCONFIGID as "fconfigid" from T_PLM_CFG_FIELD_CT

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

select FPKID as "FPKID",FID as "FID",FCONNECTOR as "连接符",FINITDEFAULT as "默认值",FINITDEFAULTID as "默认id",FISBOMCONFIG as "是否bom配置",FCONFIGNAME as "配置方案名",FCONFIGID as "配置id" from T_PLM_CFG_FIELD_CT

--INSERT脚本--

insert into T_PLM_CFG_FIELD_CT(FPKID,FID,FCONNECTOR,FINITDEFAULT,FINITDEFAULTID,FISBOMCONFIG,FCONFIGNAME,FCONFIGID) values (?,?,?,?,?,?,?,?)

--UPDATE脚本--

update T_PLM_CFG_FIELD_CT set FPKID=?,FID=?,FCONNECTOR=?,FINITDEFAULT=?,FINITDEFAULTID=?,FISBOMCONFIG=?,FCONFIGNAME=?,FCONFIGID=? where FPKID=?

--delete脚本--

delete from T_PLM_CFG_FIELD_CT where FPKID=?

--给字段加备注--

alter table T_PLM_CFG_FIELD_CT comment '下推配置表';

alter table T_PLM_CFG_FIELD_CT modify column FPKID nvarchar(36) not null  comment 'FPKID';

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

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

alter table T_PLM_CFG_FIELD_CT modify column FINITDEFAULT nvarchar(50) not null  comment '默认值';

alter table T_PLM_CFG_FIELD_CT modify column FINITDEFAULTID nvarchar(50) not null  comment '默认id';

alter table T_PLM_CFG_FIELD_CT modify column FISBOMCONFIG char(1) not null  comment '是否bom配置';

alter table T_PLM_CFG_FIELD_CT modify column FCONFIGNAME nvarchar(255) not null  comment '配置方案名';

alter table T_PLM_CFG_FIELD_CT modify column FCONFIGID nvarchar(36) not null  comment '配置id';

--建表脚本--

create table T_PLM_CFG_FIELD_E(

FPKID bigint not null  comment 'FPKID'

,FID bigint not null  comment 'FID'

,FINITERPFIELD bigint not null  comment '物料erp字段'

,primary key (FPKID)

) comment = '物料字段配置'

--查询--

select FPKID as "fpkid",FID as "fid",FINITERPFIELD as "finiterpfield" from T_PLM_CFG_FIELD_E

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

select FPKID as "FPKID",FID as "FID",FINITERPFIELD as "物料erp字段" from T_PLM_CFG_FIELD_E

--INSERT脚本--

insert into T_PLM_CFG_FIELD_E(FPKID,FID,FINITERPFIELD) values (?,?,?)

--UPDATE脚本--

update T_PLM_CFG_FIELD_E set FPKID=?,FID=?,FINITERPFIELD=? where FPKID=?

--delete脚本--

delete from T_PLM_CFG_FIELD_E where FPKID=?

--给字段加备注--

alter table T_PLM_CFG_FIELD_E comment '物料字段配置';

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

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

alter table T_PLM_CFG_FIELD_E modify column FINITERPFIELD bigint not null  comment '物料erp字段';

--建表脚本--

create table T_PLM_CFG_FIELD_EB(

FPKID bigint not null  comment 'FPKID'

,FID bigint not null  comment 'FID'

,FINITERPBOMFIELD bigint not null  comment 'bom erp字段'

,primary key (FPKID)

) comment = 'ebom字段配置'

--查询--

select FPKID as "fpkid",FID as "fid",FINITERPBOMFIELD as "finiterpbomfield" from T_PLM_CFG_FIELD_EB

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

select FPKID as "FPKID",FID as "FID",FINITERPBOMFIELD as "bom erp字段" from T_PLM_CFG_FIELD_EB

--INSERT脚本--

insert into T_PLM_CFG_FIELD_EB(FPKID,FID,FINITERPBOMFIELD) values (?,?,?)

--UPDATE脚本--

update T_PLM_CFG_FIELD_EB set FPKID=?,FID=?,FINITERPBOMFIELD=? where FPKID=?

--delete脚本--

delete from T_PLM_CFG_FIELD_EB where FPKID=?

--给字段加备注--

alter table T_PLM_CFG_FIELD_EB comment 'ebom字段配置';

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

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

alter table T_PLM_CFG_FIELD_EB modify column FINITERPBOMFIELD bigint not null  comment 'bom erp字段';

--建表脚本--

create table T_PLM_CFG_FIELD_ET(

FPKID nvarchar(36) not null  comment 'FPKID'

,FID bigint not null  comment 'FID'

,FINITERPFIELD bigint not null  comment 'erp字段id'

,FISBOMCONFIG char(1) not null  comment '是否bom配置'

,FCONFIGNAME nvarchar(255) not null  comment '配置方案名'

,FCONFIGID nvarchar(36) not null  comment '配置id'

,primary key (FPKID)

) comment = '下推配置erp字段表'

--查询--

select FPKID as "fpkid",FID as "fid",FINITERPFIELD as "finiterpfield",FISBOMCONFIG as "fisbomconfig",FCONFIGNAME as "fconfigname",FCONFIGID as "fconfigid" from T_PLM_CFG_FIELD_ET

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

select FPKID as "FPKID",FID as "FID",FINITERPFIELD as "erp字段id",FISBOMCONFIG as "是否bom配置",FCONFIGNAME as "配置方案名",FCONFIGID as "配置id" from T_PLM_CFG_FIELD_ET

--INSERT脚本--

insert into T_PLM_CFG_FIELD_ET(FPKID,FID,FINITERPFIELD,FISBOMCONFIG,FCONFIGNAME,FCONFIGID) values (?,?,?,?,?,?)

--UPDATE脚本--

update T_PLM_CFG_FIELD_ET set FPKID=?,FID=?,FINITERPFIELD=?,FISBOMCONFIG=?,FCONFIGNAME=?,FCONFIGID=? where FPKID=?

--delete脚本--

delete from T_PLM_CFG_FIELD_ET where FPKID=?

--给字段加备注--

alter table T_PLM_CFG_FIELD_ET comment '下推配置erp字段表';

alter table T_PLM_CFG_FIELD_ET modify column FPKID nvarchar(36) not null  comment 'FPKID';

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

alter table T_PLM_CFG_FIELD_ET modify column FINITERPFIELD bigint not null  comment 'erp字段id';

alter table T_PLM_CFG_FIELD_ET modify column FISBOMCONFIG char(1) not null  comment '是否bom配置';

alter table T_PLM_CFG_FIELD_ET modify column FCONFIGNAME nvarchar(255) not null  comment '配置方案名';

alter table T_PLM_CFG_FIELD_ET modify column FCONFIGID nvarchar(36) not null  comment '配置id';

--建表脚本--

create table T_PLM_CFG_FIELD_L(

FPKID bigint not null  comment 'FPKID'

,FID bigint not null  comment 'FID'

,FLocaleID int not null  comment 'FLocaleID'

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

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

,primary key (FPKID)

) comment = '字段对象多语言'

--查询--

select FPKID as "fpkid",FID as "fid",FLocaleID as "flocaleid",FNAME as "fname",FELEMENTTYPE as "felementtype" from T_PLM_CFG_FIELD_L

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

select FPKID as "FPKID",FID as "FID",FLocaleID as "FLocaleID",FNAME as "名称",FELEMENTTYPE as "元素类型" from T_PLM_CFG_FIELD_L

--INSERT脚本--

insert into T_PLM_CFG_FIELD_L(FPKID,FID,FLocaleID,FNAME,FELEMENTTYPE) values (?,?,?,?,?)

--UPDATE脚本--

update T_PLM_CFG_FIELD_L set FPKID=?,FID=?,FLocaleID=?,FNAME=?,FELEMENTTYPE=? where FPKID=?

--delete脚本--

delete from T_PLM_CFG_FIELD_L where FPKID=?

--给字段加备注--

alter table T_PLM_CFG_FIELD_L comment '字段对象多语言';

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

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

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

alter table T_PLM_CFG_FIELD_L modify column FNAME nvarchar(500) not null  comment '名称';

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

--建表脚本--

create table T_PLM_CFG_FILETYPE(

FID bigint not null  comment 'FID'

,FMasterID bigint not null  comment 'FMasterID'

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

,FISGENERATEPDF char(1) not null  comment '是否生成pdf'

,FFILETYPE varchar (20) not null  comment '文件类别'

,FISUPDATEDOC char(1) not null  comment '是否更新明细栏'

,FISLEAPLAYER char(1) not null  comment '是否跳层'

,FMATCHFIELD varchar(20) not null  comment '匹配的字段'

,FMATCHFIELDFORMAT nvarchar(50) not null  comment '匹配的字段格式'

,FMATCHCATEGORYFORMAT nvarchar(50) not null  comment '匹配的业务类型格式'

,FMATCHCATEGORYINFO varchar (20) not null  comment '匹配的业务类型信息'

,FZWCADTYPE nvarchar(50) not null  comment '中望cad类型'

,FFILEVERSIONTEXT nvarchar(300) not null  comment '图纸版本属性'

,FDRWSPLIT nvarchar(150) not null  comment '多工程图分隔符'

,FISMAINPCB char(1) not null  comment '拼版pcb文件主文件标记'

,primary key (FID)

) comment = '文件类型'

--查询--

select FID as "fid",FMasterID as "fmasterid",FCODE as "fcode",FISGENERATEPDF as "fisgeneratepdf",FFILETYPE as "ffiletype",FISUPDATEDOC as "fisupdatedoc",FISLEAPLAYER as "fisleaplayer",FMATCHFIELD as "fmatchfield",FMATCHFIELDFORMAT as "fmatchfieldformat",FMATCHCATEGORYFORMAT as "fmatchcategoryformat",FMATCHCATEGORYINFO as "fmatchcategoryinfo",FZWCADTYPE as "fzwcadtype",FFILEVERSIONTE