--建表脚本--
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",FFILEVERSIONTEXT as "ffileversiontext",FDRWSPLIT as "fdrwsplit",FISMAINPCB as "fismainpcb" from T_PLM_CFG_FILETYPE
--查询(中文字段)--
select FID as "FID",FMasterID as "FMasterID",FCODE as "编码",FISGENERATEPDF as "是否生成pdf",FFILETYPE as "文件类别",FISUPDATEDOC as "是否更新明细栏",FISLEAPLAYER as "是否跳层",FMATCHFIELD as "匹配的字段",FMATCHFIELDFORMAT as "匹配的字段格式",FMATCHCATEGORYFORMAT as "匹配的业务类型格式",FMATCHCATEGORYINFO as "匹配的业务类型信息",FZWCADTYPE as "中望cad类型",FFILEVERSIONTEXT as "图纸版本属性",FDRWSPLIT as "多工程图分隔符",FISMAINPCB as "拼版pcb文件主文件标记" from T_PLM_CFG_FILETYPE
--INSERT脚本--
insert into T_PLM_CFG_FILETYPE(FID,FMasterID,FCODE,FISGENERATEPDF,FFILETYPE,FISUPDATEDOC,FISLEAPLAYER,FMATCHFIELD,FMATCHFIELDFORMAT,FMATCHCATEGORYFORMAT,FMATCHCATEGORYINFO,FZWCADTYPE,FFILEVERSIONTEXT,FDRWSPLIT,FISMAINPCB) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
--UPDATE脚本--
update T_PLM_CFG_FILETYPE set FID=?,FMasterID=?,FCODE=?,FISGENERATEPDF=?,FFILETYPE=?,FISUPDATEDOC=?,FISLEAPLAYER=?,FMATCHFIELD=?,FMATCHFIELDFORMAT=?,FMATCHCATEGORYFORMAT=?,FMATCHCATEGORYINFO=?,FZWCADTYPE=?,FFILEVERSIONTEXT=?,FDRWSPLIT=?,FISMAINPCB=? where FID=?
--delete脚本--
delete from T_PLM_CFG_FILETYPE where FID=?
--给字段加备注--
alter table T_PLM_CFG_FILETYPE comment '文件类型';
alter table T_PLM_CFG_FILETYPE modify column FID bigint not null comment 'FID';
alter table T_PLM_CFG_FILETYPE modify column FMasterID bigint not null comment 'FMasterID';
alter table T_PLM_CFG_FILETYPE modify column FCODE nvarchar(50) not null comment '编码';
alter table T_PLM_CFG_FILETYPE modify column FISGENERATEPDF char(1) not null comment '是否生成pdf';
alter table T_PLM_CFG_FILETYPE modify column FFILETYPE varchar (20) not null comment '文件类别';
alter table T_PLM_CFG_FILETYPE modify column FISUPDATEDOC char(1) not null comment '是否更新明细栏';
alter table T_PLM_CFG_FILETYPE modify column FISLEAPLAYER char(1) not null comment '是否跳层';
alter table T_PLM_CFG_FILETYPE modify column FMATCHFIELD varchar(20) not null comment '匹配的字段';
alter table T_PLM_CFG_FILETYPE modify column FMATCHFIELDFORMAT nvarchar(50) not null comment '匹配的字段格式';
alter table T_PLM_CFG_FILETYPE modify column FMATCHCATEGORYFORMAT nvarchar(50) not null comment '匹配的业务类型格式';
alter table T_PLM_CFG_FILETYPE modify column FMATCHCATEGORYINFO varchar (20) not null comment '匹配的业务类型信息';
alter table T_PLM_CFG_FILETYPE modify column FZWCADTYPE nvarchar(50) not null comment '中望cad类型';
alter table T_PLM_CFG_FILETYPE modify column FFILEVERSIONTEXT nvarchar(300) not null comment '图纸版本属性';
alter table T_PLM_CFG_FILETYPE modify column FDRWSPLIT nvarchar(150) not null comment '多工程图分隔符';
alter table T_PLM_CFG_FILETYPE modify column FISMAINPCB char(1) not null comment '拼版pcb文件主文件标记';
--建表脚本--
create table T_PLM_CFG_FILETYPEENTRY_0(
FEntryID bigint not null comment 'FEntryID'
,FID bigint not null comment 'FID'
,FFILEIDENTIFIER nvarchar(50) not null comment '字段标识'
,FCBFILEDTYPE varchar(10) not null comment '字段类型'
,FDESCRIBE nvarchar(500) not null comment '描述'
,FMATERIALFILED bigint not null comment '属性字段'
,FCBINDEX char(1) not null comment '索引'
,FCBISMUST char(1) not null comment '必填项'
,FCBFILEINDEX char(1) not null comment '文件索引'
,FCBFILENAME char(1) not null comment '虚文档名称'
,FBASETYPE nvarchar(500) not null comment '基础资料类型'
,primary key (FEntryID)
) comment = '数据对应关系'
--查询--
select FEntryID as "fentryid",FID as "fid",FFILEIDENTIFIER as "ffileidentifier",FCBFILEDTYPE as "fcbfiledtype",FDESCRIBE as "fdescribe",FMATERIALFILED as "fmaterialfiled",FCBINDEX as "fcbindex",FCBISMUST as "fcbismust",FCBFILEINDEX as "fcbfileindex",FCBFILENAME as "fcbfilename",FBASETYPE as "fbasetype" from T_PLM_CFG_FILETYPEENTRY_0
--查询(中文字段)--
select FEntryID as "FEntryID",FID as "FID",FFILEIDENTIFIER as "字段标识",FCBFILEDTYPE as "字段类型",FDESCRIBE as "描述",FMATERIALFILED as "属性字段",FCBINDEX as "索引",FCBISMUST as "必填项",FCBFILEINDEX as "文件索引",FCBFILENAME as "虚文档名称",FBASETYPE as "基础资料类型" from T_PLM_CFG_FILETYPEENTRY_0
--INSERT脚本--
insert into T_PLM_CFG_FILETYPEENTRY_0(FEntryID,FID,FFILEIDENTIFIER,FCBFILEDTYPE,FDESCRIBE,FMATERIALFILED,FCBINDEX,FCBISMUST,FCBFILEINDEX,FCBFILENAME,FBASETYPE) values (?,?,?,?,?,?,?,?,?,?,?)
--UPDATE脚本--
update T_PLM_CFG_FILETYPEENTRY_0 set FEntryID=?,FID=?,FFILEIDENTIFIER=?,FCBFILEDTYPE=?,FDESCRIBE=?,FMATERIALFILED=?,FCBINDEX=?,FCBISMUST=?,FCBFILEINDEX=?,FCBFILENAME=?,FBASETYPE=? where FEntryID=?
--delete脚本--
delete from T_PLM_CFG_FILETYPEENTRY_0 where FEntryID=?
--给字段加备注--
alter table T_PLM_CFG_FILETYPEENTRY_0 comment '数据对应关系';
alter table T_PLM_CFG_FILETYPEENTRY_0 modify column FEntryID bigint not null comment 'FEntryID';
alter table T_PLM_CFG_FILETYPEENTRY_0 modify column FID bigint not null comment 'FID';
alter table T_PLM_CFG_FILETYPEENTRY_0 modify column FFILEIDENTIFIER nvarchar(50) not null comment '字段标识';
alter table T_PLM_CFG_FILETYPEENTRY_0 modify column FCBFILEDTYPE varchar(10) not null comment '字段类型';
alter table T_PLM_CFG_FILETYPEENTRY_0 modify column FDESCRIBE nvarchar(500) not null comment '描述';
alter table T_PLM_CFG_FILETYPEENTRY_0 modify column FMATERIALFILED bigint not null comment '属性字段';
alter table T_PLM_CFG_FILETYPEENTRY_0 modify column FCBINDEX char(1) not null comment '索引';
alter table T_PLM_CFG_FILETYPEENTRY_0 modify column FCBISMUST char(1) not null comment '必填项';
alter table T_PLM_CFG_FILETYPEENTRY_0 modify column FCBFILEINDEX char(1) not null comment '文件索引';
alter table T_PLM_CFG_FILETYPEENTRY_0 modify column FCBFILENAME char(1) not null comment '虚文档名称';
alter table T_PLM_CFG_FILETYPEENTRY_0 modify column FBASETYPE nvarchar(500) not null comment '基础资料类型';
推荐阅读
