PLM内容专辑（三）

--建表脚本--

create table T_PLM_CFG_ERPBOMFIELD_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 = 'erpbom字段多语言'

--查询--

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

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

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

--INSERT脚本--

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

--UPDATE脚本--

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

--delete脚本--

delete from T_PLM_CFG_ERPBOMFIELD_L where FPKID=?

--给字段加备注--

alter table T_PLM_CFG_ERPBOMFIELD_L comment 'erpbom字段多语言';

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

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

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

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

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

--建表脚本--

create table T_PLM_CFG_ERPMATFIELD_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 = 'erp物料字段多语言'

--查询--

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

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

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

--INSERT脚本--

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

--UPDATE脚本--

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

--delete脚本--

delete from T_PLM_CFG_ERPMATFIELD_L where FPKID=?

--给字段加备注--

alter table T_PLM_CFG_ERPMATFIELD_L comment 'erp物料字段多语言';

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

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

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

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

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

--建表脚本--

create table T_PLM_CFG_ERPTEMPLATE(

FCATEGORYID bigint not null  comment '业务类型id'

,FOBJECTID bigint not null  comment 'erp对象fid'

,FTEMPLATETYPE char(1) default ''''  comment '操作类型'

,primary key (FCATEGORYID)

) comment = 'erp模板对象配置'

--查询--

select FCATEGORYID as "fcategoryid",FOBJECTID as "fobjectid",FTEMPLATETYPE as "ftemplatetype" from T_PLM_CFG_ERPTEMPLATE

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

select FCATEGORYID as "业务类型id",FOBJECTID as "erp对象fid",FTEMPLATETYPE as "操作类型" from T_PLM_CFG_ERPTEMPLATE

--INSERT脚本--

insert into T_PLM_CFG_ERPTEMPLATE(FCATEGORYID,FOBJECTID,FTEMPLATETYPE) values (?,?,?)

--UPDATE脚本--

update T_PLM_CFG_ERPTEMPLATE set FCATEGORYID=?,FOBJECTID=?,FTEMPLATETYPE=? where FCATEGORYID=?

--delete脚本--

delete from T_PLM_CFG_ERPTEMPLATE where FCATEGORYID=?

--给字段加备注--

alter table T_PLM_CFG_ERPTEMPLATE comment 'erp模板对象配置';

alter table T_PLM_CFG_ERPTEMPLATE modify column FCATEGORYID bigint not null  comment '业务类型id';

alter table T_PLM_CFG_ERPTEMPLATE modify column FOBJECTID bigint not null  comment 'erp对象fid';

alter table T_PLM_CFG_ERPTEMPLATE modify column FTEMPLATETYPE char(1) default ''''  comment '操作类型';

--建表脚本--

create table T_PLM_CFG_FIELDGROUP(

FID bigint not null  comment 'FID'

,FMasterID bigint not null  comment 'FMasterID'

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

,FSN int not null  comment '字段排序'

,primary key (FID)

) comment = '字段分组'

--查询--

select FID as "fid",FMasterID as "fmasterid",FCODE as "fcode",FSN as "fsn" from T_PLM_CFG_FIELDGROUP

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

select FID as "FID",FMasterID as "FMasterID",FCODE as "编码",FSN as "字段排序" from T_PLM_CFG_FIELDGROUP

--INSERT脚本--

insert into T_PLM_CFG_FIELDGROUP(FID,FMasterID,FCODE,FSN) values (?,?,?,?)

--UPDATE脚本--

update T_PLM_CFG_FIELDGROUP set FID=?,FMasterID=?,FCODE=?,FSN=? where FID=?

--delete脚本--

delete from T_PLM_CFG_FIELDGROUP where FID=?

--给字段加备注--

alter table T_PLM_CFG_FIELDGROUP comment '字段分组';

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

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

alter table T_PLM_CFG_FIELDGROUP modify column FCODE nvarchar(50) not null  comment '编码';

alter table T_PLM_CFG_FIELDGROUP modify column FSN int not null  comment '字段排序';

--建表脚本--

create table T_PLM_CFG_FIELDGROUPCFG(

FID bigint not null  comment 'FID'

,FMasterID bigint not null  comment 'FMasterID'

,FFIELDGROUP bigint not null  comment '字段分组'

,FGROUPREADONLY char(1) not null  comment '只读'

,FGROUPHIDE char(1) not null  comment '隐藏'

,FGROUPREQUIRE char(1) not null  comment '必填'

,FPROCESSID nvarchar(250) not null  comment '流程实例'

,FNODEID nvarchar(250) not null  comment '流程节点'

,primary key (FID)

) comment = '字段分组流程节点配置'

--查询--

select FID as "fid",FMasterID as "fmasterid",FFIELDGROUP as "ffieldgroup",FGROUPREADONLY as "fgroupreadonly",FGROUPHIDE as "fgrouphide",FGROUPREQUIRE as "fgrouprequire",FPROCESSID as "fprocessid",FNODEID as "fnodeid" from T_PLM_CFG_FIELDGROUPCFG

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

select FID as "FID",FMasterID as "FMasterID",FFIELDGROUP as "字段分组",FGROUPREADONLY as "只读",FGROUPHIDE as "隐藏",FGROUPREQUIRE as "必填",FPROCESSID as "流程实例",FNODEID as "流程节点" from T_PLM_CFG_FIELDGROUPCFG

--INSERT脚本--

insert into T_PLM_CFG_FIELDGROUPCFG(FID,FMasterID,FFIELDGROUP,FGROUPREADONLY,FGROUPHIDE,FGROUPREQUIRE,FPROCESSID,FNODEID) values (?,?,?,?,?,?,?,?)

--UPDATE脚本--

update T_PLM_CFG_FIELDGROUPCFG set FID=?,FMasterID=?,FFIELDGROUP=?,FGROUPREADONLY=?,FG