--建表脚本--

create table T_PLM_CFG_AUTHITEM(

FEntryID varchar(36) not null  comment 'FEntryID'

,FAuthObjectId varchar(36) not null  comment '授权对象id'

,FOBJECTID int not null  comment '对象id'

,FOBJECTTYPE int not null  comment '对象类别'

,primary key (FEntryID)

) comment = '授权对象分录'

--查询--

select FEntryID as "fentryid",FAuthObjectId as "fauthobjectid",FOBJECTID as "fobjectid",FOBJECTTYPE as "fobjecttype" from T_PLM_CFG_AUTHITEM

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

select FEntryID as "FEntryID",FAuthObjectId as "授权对象id",FOBJECTID as "对象id",FOBJECTTYPE as "对象类别" from T_PLM_CFG_AUTHITEM

--INSERT脚本--

insert into T_PLM_CFG_AUTHITEM(FEntryID,FAuthObjectId,FOBJECTID,FOBJECTTYPE) values (?,?,?,?)

--UPDATE脚本--

update T_PLM_CFG_AUTHITEM set FEntryID=?,FAuthObjectId=?,FOBJECTID=?,FOBJECTTYPE=? where FEntryID=?

--delete脚本--

delete from T_PLM_CFG_AUTHITEM where FEntryID=?

--给字段加备注--

alter table T_PLM_CFG_AUTHITEM comment '授权对象分录';

alter table T_PLM_CFG_AUTHITEM modify column FEntryID varchar(36) not null  comment 'FEntryID';

alter table T_PLM_CFG_AUTHITEM modify column FAuthObjectId varchar(36) not null  comment '授权对象id';

alter table T_PLM_CFG_AUTHITEM modify column FOBJECTID int not null  comment '对象id';

alter table T_PLM_CFG_AUTHITEM modify column FOBJECTTYPE int not null  comment '对象类别';

--建表脚本--

create table T_PLM_CFG_AUTH_INFOR(

FENTRYID varchar(36) not null  comment 'FENTRYID'

,FOBJECTENTRYID nvarchar(100) not null  comment '权限对象分录id'

,FAUTHORIZERID nvarchar(100) not null  comment '授权对象id'

,FAUTHSTATUS varchar(20) not null  comment '权限状态'

,FPARENT varchar(36) default null  comment '父项'

,FANCESTOR varchar(36) default null  comment '继承项'

,FISINHERIT char(1) not null  comment '是否继承'

,FRESOURCEID varchar(100) not null  comment '资源'

,FOPERATIONID varchar(100) not null  comment '操作'

,primary key (FENTRYID)

) comment = '授权信息'

--查询--

select FENTRYID as "fentryid",FOBJECTENTRYID as "fobjectentryid",FAUTHORIZERID as "fauthorizerid",FAUTHSTATUS as "fauthstatus",FPARENT as "fparent",FANCESTOR as "fancestor",FISINHERIT as "fisinherit",FRESOURCEID as "fresourceid",FOPERATIONID as "foperationid" from T_PLM_CFG_AUTH_INFOR

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

select FENTRYID as "FENTRYID",FOBJECTENTRYID as "权限对象分录id",FAUTHORIZERID as "授权对象id",FAUTHSTATUS as "权限状态",FPARENT as "父项",FANCESTOR as "继承项",FISINHERIT as "是否继承",FRESOURCEID as "资源",FOPERATIONID as "操作" from T_PLM_CFG_AUTH_INFOR

--INSERT脚本--

insert into T_PLM_CFG_AUTH_INFOR(FENTRYID,FOBJECTENTRYID,FAUTHORIZERID,FAUTHSTATUS,FPARENT,FANCESTOR,FISINHERIT,FRESOURCEID,FOPERATIONID) values (?,?,?,?,?,?,?,?,?)

--UPDATE脚本--

update T_PLM_CFG_AUTH_INFOR set FENTRYID=?,FOBJECTENTRYID=?,FAUTHORIZERID=?,FAUTHSTATUS=?,FPARENT=?,FANCESTOR=?,FISINHERIT=?,FRESOURCEID=?,FOPERATIONID=? where FENTRYID=?

--delete脚本--

delete from T_PLM_CFG_AUTH_INFOR where FENTRYID=?

--给字段加备注--

alter table T_PLM_CFG_AUTH_INFOR comment '授权信息';

alter table T_PLM_CFG_AUTH_INFOR modify column FENTRYID varchar(36) not null  comment 'FENTRYID';

alter table T_PLM_CFG_AUTH_INFOR modify column FOBJECTENTRYID nvarchar(100) not null  comment '权限对象分录id';

alter table T_PLM_CFG_AUTH_INFOR modify column FAUTHORIZERID nvarchar(100) not null  comment '授权对象id';

alter table T_PLM_CFG_AUTH_INFOR modify column FAUTHSTATUS varchar(20) not null  comment '权限状态';

alter table T_PLM_CFG_AUTH_INFOR modify column FPARENT varchar(36) default null  comment '父项';

alter table T_PLM_CFG_AUTH_INFOR modify column FANCESTOR varchar(36) default null  comment '继承项';

alter table T_PLM_CFG_AUTH_INFOR modify column FISINHERIT char(1) not null  comment '是否继承';

alter table T_PLM_CFG_AUTH_INFOR modify column FRESOURCEID varchar(100) not null  comment '资源';

alter table T_PLM_CFG_AUTH_INFOR modify column FOPERATIONID varchar(100) not null  comment '操作';

--建表脚本--

create table T_PLM_CFG_AUTH_OBJECT(

FAUTHOBJECTID varchar(36) not null  comment 'FAUTHOBJECTID'

,FMasterID varchar(36) not null  comment 'FMasterID'

,FAUTHORTYPE int not null  comment '对象类别'

,primary key (FAUTHOBJECTID)

) comment = '授权对象'

--查询--

select FAUTHOBJECTID as "fauthobjectid",FMasterID as "fmasterid",FAUTHORTYPE as "fauthortype" from T_PLM_CFG_AUTH_OBJECT

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

select FAUTHOBJECTID as "FAUTHOBJECTID",FMasterID as "FMasterID",FAUTHORTYPE as "对象类别" from T_PLM_CFG_AUTH_OBJECT

--INSERT脚本--

insert into T_PLM_CFG_AUTH_OBJECT(FAUTHOBJECTID,FMasterID,FAUTHORTYPE) values (?,?,?)

--UPDATE脚本--

update T_PLM_CFG_AUTH_OBJECT set FAUTHOBJECTID=?,FMasterID=?,FAUTHORTYPE=? where FAUTHOBJECTID=?

--delete脚本--

delete from T_PLM_CFG_AUTH_OBJECT where FAUTHOBJECTID=?

--给字段加备注--

alter table T_PLM_CFG_AUTH_OBJECT comment '授权对象';

alter table T_PLM_CFG_AUTH_OBJECT modify column FAUTHOBJECTID varchar(36) not null  comment 'FAUTHOBJECTID';

alter table T_PLM_CFG_AUTH_OBJECT modify column FMasterID varchar(36) not null  comment 'FMasterID';

alter table T_PLM_CFG_AUTH_OBJECT modify column FAUTHORTYPE int not null  comment '对象类别';

--建表脚本--

create table T_PLM_CFG_AUTH_OBJECT(

FAUTHOBJECTID varchar(36) not null  comment 'FAUTHOBJECTID'

,FMasterID varchar(36) not null  comment 'FMasterID'

,FAUTHORTYPE int not null  comment '对象类别'

,primary key (FAUTHOBJECTID)

) comment = '授权对象'

--查询--

select FAUTHOBJECTID as "fauthobjectid",FMasterID as "fmasterid",FAUTHORTYPE as "fauthortype" from T_PLM_CFG_AUTH_OBJECT

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

select FAUTHOBJECTID as "FAUTHOBJECTID",FMasterID as "FMasterID",FAUTHORTYPE as "对象类别" from T_PLM_CFG_AUTH_OBJECT

--INSERT脚本--

insert into T_PLM_CFG_AUTH_OBJECT(FAUTHOBJECTID,FMasterID,FAUTHORTYPE) values (?,?,?)

--UPDATE脚本--

update T_PLM_CFG_AUTH_OBJECT set FAUTHOBJECTID=?,FMasterID=?,FAUTHORTYPE=? where FAUTHOBJECTID=?

--delete脚本--

delete from T_PLM_CFG_AUTH_OBJECT where FAUTHOBJECTID=?

--给字段加备注--

alter table T_PLM_CFG_AUTH_OBJECT comment '授权对象';

alter table T_PLM_CFG_AUTH_OBJECT modify column FAUTHOBJECTID varchar(36) not null  comment 'FAUTHOBJECTID';

alter table T_PLM_CFG_AUTH_OBJECT modify column FMasterID varchar(36) not null  comment 'FMasterID';

alter table T_PLM_CFG_AUTH_OBJECT modify column FAUTHORTYPE int not null  comment '对象类别';

--建表脚本--

create table T_PLM_CFG_BILLCONVERTPROJ(

FID bigint not null  comment 'FID'

,FBILLID nvarchar(50) not null  comment '立项申请单id'

,FCATEGORYID nvarchar(50) not null  comment '业务类型id'

,primary key (FID)

) comment = '立项申请单配置项目'

--查询--

select FID as "fid",FBILLID as "fbillid",FCATEGORYID as "fcategoryid" from T_PLM_CFG_BILLCONVERTPROJ

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

select FID as "FID",FBILLID as "立项申请单id",FCATEGORYID as "业务类型id" from T_PLM_CFG_BILLCONVERTPROJ

--INSERT脚本--

insert into T_PLM_CFG_BILLCONVERTPROJ(FID,FBILLID,FCATEGORYID) values (?,?,?)

--UPDATE脚本--

update T_PLM_CFG_BILLCONVERTPROJ set FID=?,FBILLID=?,FCATEGORYID=? where FID=?

--delete脚本--

delete from T_PLM_CFG_BILLCONVERTPROJ where FID=?

--给字段加备注--

alter table T_PLM_CFG_BILLCONVERTPROJ comment '立项申请单配置项目';

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

alter table T_PLM_CFG_BILLCONVERTPROJ modify column FBILLID nvarchar(50) not null  comment '立项申请单id';

alter table T_PLM_CFG_BILLCONVERTPROJ modify column FCATEGORYID nvarchar(50) not null  comment '业务类型id';

--建表脚本--

create table T_PLM_CFG_BOMCATEGORY(

FCATEGORYID bigint not null  comment '物料业务类型'

,FBOMCATEGORYID bigint not null  comment 'bom业务类型'

,FTEMPLATETYPE char(1) not null  comment '类型'

,primary key (FCATEGORYID)

) comment = 'bom记忆'

--查询--

select FCATEGORYID as "fcategoryid",FBOMCATEGORYID as "fbomcategoryid",FTEMPLATETYPE as "ftemplatetype" from T_PLM_CFG_BOMCATEGORY

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

select FCATEGORYID as "物料业务类型",FBOMCATEGORYID as "bom业务类型",FTEMPLATETYPE as "类型" from T_PLM_CFG_BOMCATEGORY

--INSERT脚本--

insert into T_PLM_CFG_BOMCATEGORY(FCATEGORYID,FBOMCATEGORYID,FTEMPLATETYPE) values (?,?,?)

--UPDATE脚本--

update T_PLM_CFG_BOMCATEGORY set FCATEGORYID=?,FBOMCATEGORYID=?,FTEMPLATETYPE=? where FCATEGORYID=?

--delete脚本--

delete from T_PLM_CFG_BOMCATEGORY where FCATEGORYID=?

--给字段加备注--

alter table T_PLM_CFG_BOMCATEGORY comment 'bom记忆';

alter table T_PLM_CFG_BOMCATEGORY modify column FCATEGORYID bigint not null  comment '物料业务类型';

alter table T_PLM_CFG_BOMCATEGORY modify column FBOMCATEGORYID bigint not null  comment 'bom业务类型';

alter table T_PLM_CFG_BOMCATEGORY modify column FTEMPLATETYPE char(1) not null  comment '类型';

--建表脚本--

create table T_PLM_CFG_BOMCOMPAREPRO(

FID bigint not null  comment 'FID'

,FMasterID bigint not null  comment 'FMasterID'

,FUSERID int not null  comment '用户id'

,FWAY varchar(20) not null  comment '比较方式'

,FLEVEL int not null  comment '比较层数'

,FPROPERTY nvarchar(50) not null  comment '比较属性'

,FISENABLE int not null  comment '是否启用'

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

,primary key (FID)

) comment = 'bom比较属性配置表'

--查询--

select FID as "fid",FMasterID as "fmasterid",FUSERID as "fuserid",FWAY as "fway",FLEVEL as "flevel",FPROPERTY as "fproperty",FISENABLE as "fisenable",FCATEGORYID as "fcategoryid" from T_PLM_CFG_BOMCOMPAREPRO

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

select FID as "FID",FMasterID as "FMasterID",FUSERID as "用户id",FWAY as "比较方式",FLEVEL as "比较层数",FPROPERTY as "比较属性",FISENABLE as "是否启用",FCATEGORYID as "业务类型" from T_PLM_CFG_BOMCOMPAREPRO

--INSERT脚本--

insert into T_PLM_CFG_BOMCOMPAREPRO(FID,FMasterID,FUSERID,FWAY,FLEVEL,FPROPERTY,FISENABLE,FCATEGORYID) values (?,?,?,?,?,?,?,?)

--UPDATE脚本--

update T_PLM_CFG_BOMCOMPAREPRO set FID=?,FMasterID=?,FUSERID=?,FWAY=?,FLEVEL=?,FPROPERTY=?,FISENABLE=?,FCATEGORYID=? where FID=?

--delete脚本--

delete from T_PLM_CFG_BOMCOMPAREPRO where FID=?

--给字段加备注--

alter table T_PLM_CFG_BOMCOMPAREPRO comment 'bom比较属性配置表';

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

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

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

alter table T_PLM_CFG_BOMCOMPAREPRO modify column FWAY varchar(20) not null  comment '比较方式';

alter table T_PLM_CFG_BOMCOMPAREPRO modify column FLEVEL int not null  comment '比较层数';

alter table T_PLM_CFG_BOMCOMPAREPRO modify column FPROPERTY nvarchar(50) not null  comment '比较属性';

alter table T_PLM_CFG_BOMCOMPAREPRO modify column FISENABLE int not null  comment '是否启用';

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

--建表脚本--

create table T_PLM_CFG_BOMSTATE(

FID bigint not null  comment 'FID'

,FMasterID bigint not null  comment 'FMasterID'

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

,FPUSHBOMSTATE nvarchar(50) not null  comment '下推状态'

,primary key (FID)

) comment = 'bom下推状态'

--查询--

select FID as "fid",FMasterID as "fmasterid",FCATEGORYID as "fcategoryid",FPUSHBOMSTATE as "fpushbomstate" from T_PLM_CFG_BOMSTATE

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

select FID as "FID",FMasterID as "FMasterID",FCATEGORYID as "业务类型id",FPUSHBOMSTATE as "下推状态" from T_PLM_CFG_BOMSTATE

--INSERT脚本--

insert into T_PLM_CFG_BOMSTATE(FID,FMasterID,FCATEGORYID,FPUSHBOMSTATE) values (?,?,?,?)

--UPDATE脚本--

update T_PLM_CFG_BOMSTATE set FID=?,FMasterID=?,FCATEGORYID=?,FPUSHBOMSTATE=? where FID=?

--delete脚本--

delete from T_PLM_CFG_BOMSTATE where FID=?

--给字段加备注--

alter table T_PLM_CFG_BOMSTATE comment 'bom下推状态';

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

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

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

alter table T_PLM_CFG_BOMSTATE modify column FPUSHBOMSTATE nvarchar(50) not null  comment '下推状态';

--建表脚本--

create table T_PLM_CFG_BOM_E(

FPKID bigint not null  comment 'FPKID'

,FID bigint not null  comment 'FID'

,FPLMBOMFIELD bigint not null  comment 'bom字段id'

,primary key (FPKID)

) comment = 'bom推送配置字段关联'

--查询--

select FPKID as "fpkid",FID as "fid",FPLMBOMFIELD as "fplmbomfield" from T_PLM_CFG_BOM_E

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

select FPKID as "FPKID",FID as "FID",FPLMBOMFIELD as "bom字段id" from T_PLM_CFG_BOM_E

--INSERT脚本--

insert into T_PLM_CFG_BOM_E(FPKID,FID,FPLMBOMFIELD) values (?,?,?)

--UPDATE脚本--

update T_PLM_CFG_BOM_E set FPKID=?,FID=?,FPLMBOMFIELD=? where FPKID=?

--delete脚本--

delete from T_PLM_CFG_BOM_E where FPKID=?

--给字段加备注--

alter table T_PLM_CFG_BOM_E comment 'bom推送配置字段关联';

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

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

alter table T_PLM_CFG_BOM_E modify column FPLMBOMFIELD bigint not null  comment 'bom字段id';