PLM-授权、立项及BOM相关属性

--建表脚本--

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 "ftempl