--建表脚本--

create table T_PLM_CFG_DOMAINCVTCFG(

FID bigint not null  comment 'FID'

,FMASTERID bigint not null  comment 'FMASTERID'

,FISUPDATE char(1) not null  comment 'FISUPDATE'

,FCONNECTOR nvarchar(50) not null  comment 'FCONNECTOR'

,FSTARTUP char(1) not null  comment 'FSTARTUP'

,FISMUST char(1) not null  comment 'FISMUST'

,FCATEGORYID bigint not null  comment 'FCATEGORYID'

,FDOMAINFIELD bigint not null  comment 'FDOMAINFIELD'

,FDEFAULTVALUE nvarchar(50) not null  comment 'FDEFAULTVALUE'

,primary key (FID)

) comment = '领域对象同步配置'

--查询--

select FID as "fid",FMASTERID as "fmasterid",FISUPDATE as "fisupdate",FCONNECTOR as "fconnector",FSTARTUP as "fstartup",FISMUST as "fismust",FCATEGORYID as "fcategoryid",FDOMAINFIELD as "fdomainfield",FDEFAULTVALUE as "fdefaultvalue" from T_PLM_CFG_DOMAINCVTCFG

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

select FID as "FID",FMASTERID as "FMASTERID",FISUPDATE as "FISUPDATE",FCONNECTOR as "FCONNECTOR",FSTARTUP as "FSTARTUP",FISMUST as "FISMUST",FCATEGORYID as "FCATEGORYID",FDOMAINFIELD as "FDOMAINFIELD",FDEFAULTVALUE as "FDEFAULTVALUE" from T_PLM_CFG_DOMAINCVTCFG

--INSERT脚本--

insert into T_PLM_CFG_DOMAINCVTCFG(FID,FMASTERID,FISUPDATE,FCONNECTOR,FSTARTUP,FISMUST,FCATEGORYID,FDOMAINFIELD,FDEFAULTVALUE) values (?,?,?,?,?,?,?,?,?)

--UPDATE脚本--

update T_PLM_CFG_DOMAINCVTCFG set FID=?,FMASTERID=?,FISUPDATE=?,FCONNECTOR=?,FSTARTUP=?,FISMUST=?,FCATEGORYID=?,FDOMAINFIELD=?,FDEFAULTVALUE=? where FID=?

--delete脚本--

delete from T_PLM_CFG_DOMAINCVTCFG where FID=?

--给字段加备注--

alter table T_PLM_CFG_DOMAINCVTCFG comment '领域对象同步配置';

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

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

alter table T_PLM_CFG_DOMAINCVTCFG modify column FISUPDATE char(1) not null  comment 'FISUPDATE';

alter table T_PLM_CFG_DOMAINCVTCFG modify column FCONNECTOR nvarchar(50) not null  comment 'FCONNECTOR';

alter table T_PLM_CFG_DOMAINCVTCFG modify column FSTARTUP char(1) not null  comment 'FSTARTUP';

alter table T_PLM_CFG_DOMAINCVTCFG modify column FISMUST char(1) not null  comment 'FISMUST';

alter table T_PLM_CFG_DOMAINCVTCFG modify column FCATEGORYID bigint not null  comment 'FCATEGORYID';

alter table T_PLM_CFG_DOMAINCVTCFG modify column FDOMAINFIELD bigint not null  comment 'FDOMAINFIELD';

alter table T_PLM_CFG_DOMAINCVTCFG modify column FDEFAULTVALUE nvarchar(50) not null  comment 'FDEFAULTVALUE';

--建表脚本--

create table T_PLM_CFG_DOMAINFIELD(

FID bigint not null  comment 'FID'

,FMasterID bigint not null  comment 'FMasterID'

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

,FENTITYCODE nvarchar(50) not null  comment 'FENTITYCODE'

,FFIELDTYPE nvarchar(50) not null  comment 'FFIELDTYPE'

,FKEY nvarchar(50) not null  comment 'FKEY'

,FELEMENTTYPEID nvarchar(50) not null  comment 'FELEMENTTYPEID'

,FDEFVALUE nvarchar(50) not null  comment 'FDEFVALUE'

,FMUSTINPUT char(1) not null  comment 'FMUSTINPUT'

,FISSHOW char(1) not null  comment 'FISSHOW'

,FFUNCTIONDEFAULT nvarchar(200) not null  comment 'FFUNCTIONDEFAULT'

,FBASETYPE nvarchar(50) not null  comment 'FBASETYPE'

,FISREADONLY char(1) not null  comment 'FISREADONLY'

,FISSHOWLIST char(1) not null  comment 'FISSHOWLIST'

,FENUMNAME nvarchar(50) not null  comment 'FENUMNAME'

,FOBJECTTYPE nvarchar(50) not null  comment 'FOBJECTTYPE'

,FOBJECTNAME nvarchar(50) not null  comment 'FOBJECTNAME'

,FFORMID nvarchar(100) not null  comment 'FFORMID'

,primary key (FID)

) comment = '领域对象字段表'

--查询--

select FID as "fid",FMasterID as "fmasterid",FCODE as "fcode",FENTITYCODE as "fentitycode",FFIELDTYPE as "ffieldtype",FKEY as "fkey",FELEMENTTYPEID as "felementtypeid",FDEFVALUE as "fdefvalue",FMUSTINPUT as "fmustinput",FISSHOW as "fisshow",FFUNCTIONDEFAULT as "ffunctiondefault",FBASETYPE as "fbasetype",FISREADONLY as "fisreadonly",FISSHOWLIST as "fisshowlist",FENUMNAME as "fenumname",FOBJECTTYPE as "fobjecttype",FOBJECTNAME as "fobjectname",FFORMID as "fformid" from T_PLM_CFG_DOMAINFIELD

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

select FID as "FID",FMasterID as "FMasterID",FCODE as "FCODE",FENTITYCODE as "FENTITYCODE",FFIELDTYPE as "FFIELDTYPE",FKEY as "FKEY",FELEMENTTYPEID as "FELEMENTTYPEID",FDEFVALUE as "FDEFVALUE",FMUSTINPUT as "FMUSTINPUT",FISSHOW as "FISSHOW",FFUNCTIONDEFAULT as "FFUNCTIONDEFAULT",FBASETYPE as "FBASETYPE",FISREADONLY as "FISREADONLY",FISSHOWLIST as "FISSHOWLIST",FENUMNAME as "FENUMNAME",FOBJECTTYPE as "FOBJECTTYPE",FOBJECTNAME as "FOBJECTNAME",FFORMID as "FFORMID" from T_PLM_CFG_DOMAINFIELD

--INSERT脚本--

insert into T_PLM_CFG_DOMAINFIELD(FID,FMasterID,FCODE,FENTITYCODE,FFIELDTYPE,FKEY,FELEMENTTYPEID,FDEFVALUE,FMUSTINPUT,FISSHOW,FFUNCTIONDEFAULT,FBASETYPE,FISREADONLY,FISSHOWLIST,FENUMNAME,FOBJECTTYPE,FOBJECTNAME,FFORMID) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)

--UPDATE脚本--

update T_PLM_CFG_DOMAINFIELD set FID=?,FMasterID=?,FCODE=?,FENTITYCODE=?,FFIELDTYPE=?,FKEY=?,FELEMENTTYPEID=?,FDEFVALUE=?,FMUSTINPUT=?,FISSHOW=?,FFUNCTIONDEFAULT=?,FBASETYPE=?,FISREADONLY=?,FISSHOWLIST=?,FENUMNAME=?,FOBJECTTYPE=?,FOBJECTNAME=?,FFORMID=? where FID=?

--delete脚本--

delete from T_PLM_CFG_DOMAINFIELD where FID=?

--给字段加备注--

alter table T_PLM_CFG_DOMAINFIELD comment '领域对象字段表';

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

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

alter table T_PLM_CFG_DOMAINFIELD modify column FCODE nvarchar(50) not null  comment 'FCODE';

alter table T_PLM_CFG_DOMAINFIELD modify column FENTITYCODE nvarchar(50) not null  comment 'FENTITYCODE';

alter table T_PLM_CFG_DOMAINFIELD modify column FFIELDTYPE nvarchar(50) not null  comment 'FFIELDTYPE';

alter table T_PLM_CFG_DOMAINFIELD modify column FKEY nvarchar(50) not null  comment 'FKEY';

alter table T_PLM_CFG_DOMAINFIELD modify column FELEMENTTYPEID nvarchar(50) not null  comment 'FELEMENTTYPEID';

alter table T_PLM_CFG_DOMAINFIELD modify column FDEFVALUE nvarchar(50) not null  comment 'FDEFVALUE';

alter table T_PLM_CFG_DOMAINFIELD modify column FMUSTINPUT char(1) not null  comment 'FMUSTINPUT';

alter table T_PLM_CFG_DOMAINFIELD modify column FISSHOW char(1) not null  comment 'FISSHOW';

alter table T_PLM_CFG_DOMAINFIELD modify column FFUNCTIONDEFAULT nvarchar(200) not null  comment 'FFUNCTIONDEFAULT';

alter table T_PLM_CFG_DOMAINFIELD modify column FBASETYPE nvarchar(50) not null  comment 'FBASETYPE';

alter table T_PLM_CFG_DOMAINFIELD modify column FISREADONLY char(1) not null  comment 'FISREADONLY';

alter table T_PLM_CFG_DOMAINFIELD modify column FISSHOWLIST char(1) not null  comment 'FISSHOWLIST';

alter table T_PLM_CFG_DOMAINFIELD modify column FENUMNAME nvarchar(50) not null  comment 'FENUMNAME';

alter table T_PLM_CFG_DOMAINFIELD modify column FOBJECTTYPE nvarchar(50) not null  comment 'FOBJECTTYPE';

alter table T_PLM_CFG_DOMAINFIELD modify column FOBJECTNAME nvarchar(50) not null  comment 'FOBJECTNAME';

alter table T_PLM_CFG_DOMAINFIELD modify column FFORMID nvarchar(100) not null  comment 'FFORMID';

--建表脚本--

create table T_PLM_CFG_DOMAINFIELD_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 'FNAME'

,FELEMENTTYPE nvarchar(50) not null  comment 'FELEMENTTYPE'

,primary key (FPKID)

) comment = '领域对象字段多语言表'

--查询--

select FPKID as "fpkid",FID as "fid",FLOCALEID as "flocaleid",FNAME as "fname",FELEMENTTYPE as "felementtype" from T_PLM_CFG_DOMAINFIELD_L

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

select FPKID as "FPKID",FID as "FID",FLOCALEID as "FLOCALEID",FNAME as "FNAME",FELEMENTTYPE as "FELEMENTTYPE" from T_PLM_CFG_DOMAINFIELD_L

--INSERT脚本--

insert into T_PLM_CFG_DOMAINFIELD_L(FPKID,FID,FLOCALEID,FNAME,FELEMENTTYPE) values (?,?,?,?,?)

--UPDATE脚本--

update T_PLM_CFG_DOMAINFIELD_L set FPKID=?,FID=?,FLOCALEID=?,FNAME=?,FELEMENTTYPE=? where FPKID=?

--delete脚本--

delete from T_PLM_CFG_DOMAINFIELD_L where FPKID=?

--给字段加备注--

alter table T_PLM_CFG_DOMAINFIELD_L comment '领域对象字段多语言表';

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

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

alter table T_PLM_CFG_DOMAINFIELD_L modify column FLOCALEID int not null  comment 'FLOCALEID';

alter table T_PLM_CFG_DOMAINFIELD_L modify column FNAME nvarchar(500) not null  comment 'FNAME';

alter table T_PLM_CFG_DOMAINFIELD_L modify column FELEMENTTYPE nvarchar(50) not null  comment 'FELEMENTTYPE';

--建表脚本--

create table T_PLM_CFG_DTOEDYNFIELDS(

FID int not null  comment 'FID'

,FMASTERID int not null  comment 'FMASTERID'

,FUSERID int not null  comment '用户id'

,primary key (FID)

) comment = 'dbom生成ebom界面动态字段配置...'

--查询--

select FID as "fid",FMASTERID as "fmasterid",FUSERID as "fuserid" from T_PLM_CFG_DTOEDYNFIELDS

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

select FID as "FID",FMASTERID as "FMASTERID",FUSERID as "用户id" from T_PLM_CFG_DTOEDYNFIELDS

--INSERT脚本--

insert into T_PLM_CFG_DTOEDYNFIELDS(FID,FMASTERID,FUSERID) values (?,?,?)

--UPDATE脚本--

update T_PLM_CFG_DTOEDYNFIELDS set FID=?,FMASTERID=?,FUSERID=? where FID=?

--delete脚本--

delete from T_PLM_CFG_DTOEDYNFIELDS where FID=?

--给字段加备注--

alter table T_PLM_CFG_DTOEDYNFIELDS comment 'dbom生成ebom界面动态字段配置...';

alter table T_PLM_CFG_DTOEDYNFIELDS modify column FID int not null  comment 'FID';

alter table T_PLM_CFG_DTOEDYNFIELDS modify column FMASTERID int not null  comment 'FMASTERID';

alter table T_PLM_CFG_DTOEDYNFIELDS modify column FUSERID int not null  comment '用户id';

--建表脚本--

create table T_PLM_CFG_DTOEFIELDSENTRY(

FENTRYID int not null  comment 'FENTRYID'

,FID int not null  comment 'FID'

,FFIELD bigint not null  comment '字段'

,FISDBOMFIELD char(1) not null  comment '是否dbom字段'

,FISEBOMFIELD char(1) not null  comment '是否ebom字段'

,primary key (FENTRYID)

) comment = 'dbom生成ebom界面动态字段配置...'

--查询--

select FENTRYID as "fentryid",FID as "fid",FFIELD as "ffield",FISDBOMFIELD as "fisdbomfield",FISEBOMFIELD as "fisebomfield" from T_PLM_CFG_DTOEFIELDSENTRY

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

select FENTRYID as "FENTRYID",FID as "FID",FFIELD as "字段",FISDBOMFIELD as "是否dbom字段",FISEBOMFIELD as "是否ebom字段" from T_PLM_CFG_DTOEFIELDSENTRY

--INSERT脚本--

insert into T_PLM_CFG_DTOEFIELDSENTRY(FENTRYID,FID,FFIELD,FISDBOMFIELD,FISEBOMFIELD) values (?,?,?,?,?)

--UPDATE脚本--

update T_PLM_CFG_DTOEFIELDSENTRY set FENTRYID=?,FID=?,FFIELD=?,FISDBOMFIELD=?,FISEBOMFIELD=? where FENTRYID=?

--delete脚本--

delete from T_PLM_CFG_DTOEFIELDSENTRY where FENTRYID=?

--给字段加备注--

alter table T_PLM_CFG_DTOEFIELDSENTRY comment 'dbom生成ebom界面动态字段配置...';

alter table T_PLM_CFG_DTOEFIELDSENTRY modify column FENTRYID int not null  comment 'FENTRYID';

alter table T_PLM_CFG_DTOEFIELDSENTRY modify column FID int not null  comment 'FID';

alter table T_PLM_CFG_DTOEFIELDSENTRY modify column FFIELD bigint not null  comment '字段';

alter table T_PLM_CFG_DTOEFIELDSENTRY modify column FISDBOMFIELD char(1) not null  comment '是否dbom字段';

alter table T_PLM_CFG_DTOEFIELDSENTRY modify column FISEBOMFIELD char(1) not null  comment '是否ebom字段';

--建表脚本--

create table T_PLM_CFG_DULLSTOCKCODE(

FPKID bigint not null  comment 'FPKID'

,FID bigint not null  comment 'FID'

,FDULLSTOCKCODE int not null  comment '仓库编码'

,primary key (FPKID)

) comment = '呆滞方案'

--查询--

select FPKID as "fpkid",FID as "fid",FDULLSTOCKCODE as "fdullstockcode" from T_PLM_CFG_DULLSTOCKCODE

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

select FPKID as "FPKID",FID as "FID",FDULLSTOCKCODE as "仓库编码" from T_PLM_CFG_DULLSTOCKCODE

--INSERT脚本--

insert into T_PLM_CFG_DULLSTOCKCODE(FPKID,FID,FDULLSTOCKCODE) values (?,?,?)

--UPDATE脚本--

update T_PLM_CFG_DULLSTOCKCODE set FPKID=?,FID=?,FDULLSTOCKCODE=? where FPKID=?

--delete脚本--

delete from T_PLM_CFG_DULLSTOCKCODE where FPKID=?

--给字段加备注--

alter table T_PLM_CFG_DULLSTOCKCODE comment '呆滞方案';

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

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

alter table T_PLM_CFG_DULLSTOCKCODE modify column FDULLSTOCKCODE int not null  comment '仓库编码';

--建表脚本--

create table T_PLM_CFG_ERPBOMCONFIG(

FID bigint not null  comment 'FID'

,FMasterID bigint not null  comment 'FMasterID'

,FSYNCPART char(1) not null  comment '是否启用部分上传'

,FISNEWBOM char(1) not null  comment '是否创建新版'

,primary key (FID)

) comment = 'bom推送规则配置表'

--查询--

select FID as "fid",FMasterID as "fmasterid",FSYNCPART as "fsyncpart",FISNEWBOM as "fisnewbom" from T_PLM_CFG_ERPBOMCONFIG

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

select FID as "FID",FMasterID as "FMasterID",FSYNCPART as "是否启用部分上传",FISNEWBOM as "是否创建新版" from T_PLM_CFG_ERPBOMCONFIG

--INSERT脚本--

insert into T_PLM_CFG_ERPBOMCONFIG(FID,FMasterID,FSYNCPART,FISNEWBOM) values (?,?,?,?)

--UPDATE脚本--

update T_PLM_CFG_ERPBOMCONFIG set FID=?,FMasterID=?,FSYNCPART=?,FISNEWBOM=? where FID=?

--delete脚本--

delete from T_PLM_CFG_ERPBOMCONFIG where FID=?

--给字段加备注--

alter table T_PLM_CFG_ERPBOMCONFIG comment 'bom推送规则配置表';

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

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

alter table T_PLM_CFG_ERPBOMCONFIG modify column FSYNCPART char(1) not null  comment '是否启用部分上传';

alter table T_PLM_CFG_ERPBOMCONFIG modify column FISNEWBOM char(1) not null  comment '是否创建新版';