PLM-业务类型

--建表脚本--

create table T_PLM_CFG_CATEGORYEXTEND_L(

FPKID bigint not null  comment 'FPKID'

,FID bigint not null  comment 'FID'

,FLocaleID int not null  comment 'FLocaleID'

,FMULALIAS nvarchar(50) not null  comment '别名字段'

,primary key (FPKID)

) comment = '扩展业务类型多语言表'

--查询--

select FPKID as "fpkid",FID as "fid",FLocaleID as "flocaleid",FMULALIAS as "fmulalias" from T_PLM_CFG_CATEGORYEXTEND_L

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

select FPKID as "FPKID",FID as "FID",FLocaleID as "FLocaleID",FMULALIAS as "别名字段" from T_PLM_CFG_CATEGORYEXTEND_L

--INSERT脚本--

insert into T_PLM_CFG_CATEGORYEXTEND_L(FPKID,FID,FLocaleID,FMULALIAS) values (?,?,?,?)

--UPDATE脚本--

update T_PLM_CFG_CATEGORYEXTEND_L set FPKID=?,FID=?,FLocaleID=?,FMULALIAS=? where FPKID=?

--delete脚本--

delete from T_PLM_CFG_CATEGORYEXTEND_L where FPKID=?

--给字段加备注--

alter table T_PLM_CFG_CATEGORYEXTEND_L comment '扩展业务类型多语言表';

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

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

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

alter table T_PLM_CFG_CATEGORYEXTEND_L modify column FMULALIAS nvarchar(50) not null  comment '别名字段';

--建表脚本--

create table T_PLM_CFG_CATEGORYPAGES(

FID bigint not null  comment 'FID'

,FPAGEID bigint not null  comment '平台页签标识'

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

,FISSYSPRESET char(1) not null  comment '是否预置'

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

,FISSHOW char(1) not null  comment '是否显示页签'

,primary key (FID)

) comment = '业务类型配置平台签项'

--查询--

select FID as "fid",FPAGEID as "fpageid",FCATEGORYID as "fcategoryid",FISSYSPRESET as "fissyspreset",FISINHERIT as "fisinherit",FISSHOW as "fisshow" from T_PLM_CFG_CATEGORYPAGES

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

select FID as "FID",FPAGEID as "平台页签标识",FCATEGORYID as "业务类型标识",FISSYSPRESET as "是否预置",FISINHERIT as "是否继承",FISSHOW as "是否显示页签" from T_PLM_CFG_CATEGORYPAGES

--INSERT脚本--

insert into T_PLM_CFG_CATEGORYPAGES(FID,FPAGEID,FCATEGORYID,FISSYSPRESET,FISINHERIT,FISSHOW) values (?,?,?,?,?,?)

--UPDATE脚本--

update T_PLM_CFG_CATEGORYPAGES set FID=?,FPAGEID=?,FCATEGORYID=?,FISSYSPRESET=?,FISINHERIT=?,FISSHOW=? where FID=?

--delete脚本--

delete from T_PLM_CFG_CATEGORYPAGES where FID=?

--给字段加备注--

alter table T_PLM_CFG_CATEGORYPAGES comment '业务类型配置平台签项';

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

alter table T_PLM_CFG_CATEGORYPAGES modify column FPAGEID bigint not null  comment '平台页签标识';

alter table T_PLM_CFG_CATEGORYPAGES modify column FCATEGORYID bigint not null  comment '业务类型标识';

alter table T_PLM_CFG_CATEGORYPAGES modify column FISSYSPRESET char(1) not null  comment '是否预置';

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

alter table T_PLM_CFG_CATEGORYPAGES modify column FISSHOW char(1) not null  comment '是否显示页签';

--建表脚本--

create table T_PLM_CFG_CATEGORYRULECFG(

FEntryID bigint not null  comment '配置分录id'

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

,FCONTROLRULE bigint not null  comment '控制规则'

,FISON char(1) not null  comment '是否勾选'

,FNOINHERIT char(1) not null  comment '不继承父'

,FSTAGE bigint not null  comment '生命周期阶段id'

,primary key (FEntryID)

) comment = '业务类型规则配置'

--查询--

select FEntryID as "fentryid",FID as "fid",FCONTROLRULE as "fcontrolrule",FISON as "fison",FNOINHERIT as "fnoinherit",FSTAGE as "fstage" from T_PLM_CFG_CATEGORYRULECFG

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

select FEntryID as "配置分录id",FID as "业务类型id",FCONTROLRULE as "控制规则",FISON as "是否勾选",FNOINHERIT as "不继承父",FSTAGE as "生命周期阶段id" from T_PLM_CFG_CATEGORYRULECFG

--INSERT脚本--

insert into T_PLM_CFG_CATEGORYRULECFG(FEntryID,FID,FCONTROLRULE,FISON,FNOINHERIT,FSTAGE) values (?,?,?,?,?,?)

--UPDATE脚本--

update T_PLM_CFG_CATEGORYRULECFG set FEntryID=?,FID=?,FCONTROLRULE=?,FISON=?,FNOINHERIT=?,FSTAGE=? where FEntryID=?

--delete脚本--

delete from T_PLM_CFG_CATEGORYRULECFG where FEntryID=?

--给字段加备注--

alter table T_PLM_CFG_CATEGORYRULECFG comment '业务类型规则配置';

alter table T_PLM_CFG_CATEGORYRULECFG modify column FEntryID bigint not null  comment '配置分录id';

alter table T_PLM_CFG_CATEGORYRULECFG modify column FID bigint not null  comment '业务类型id';

alter table T_PLM_CFG_CATEGORYRULECFG modify column FCONTROLRULE bigint not null  comment '控制规则';

alter table T_PLM_CFG_CATEGORYRULECFG modify column FISON char(1) not null  comment '是否勾选';

alter table T_PLM_CFG_CATEGORYRULECFG modify column FNOINHERIT char(1) not null  comment '不继承父';

alter table T_PLM_CFG_CATEGORYRULECFG modify column FSTAGE bigint not null  comment '生命周期阶段id';

--建表脚本--

create table T_PLM_CFG_CATEGORYVERSION(

FCATEGORYID bigint not null  comment '业务类型标识'

,FMODIFYDATE datetime not null  comment '业务类型配置修改更新的时间'

,FLASTUPDATEDATE datetime not null  comment '业务类型元数据最后更新的时间'

,primary key (FCATEGORYID)

) comment = '业务类型配置版本'

--查询--

select FCATEGORYID as "fcategoryid",FMODIFYDATE as "fmodifydate",FLASTUPDATEDATE as "flastupdatedate" from T_PLM_CFG_CATEGORYVERSION

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

select FCATEGORYID as "业务类型标识",FMODIFYDATE as "业务类型配置修改更新的时间",FLASTUPDATEDATE as "业务类型元数据最后更新的时间" from T_PLM_CFG_CATEGORYVERSION

--INSERT脚本--

insert into T_PLM_CFG_CATEGORYVERSION(FCATEGORYID,FMODIFYDATE,FLASTUPDATEDATE) values (?,?,?)

--UPDATE脚本--

update T_PLM_CFG_CATEGORYVERSION set FCATEGORYID=?,FMODIFYDATE=?,FLASTUPDATEDATE=? where FCATEGORYID=?

--delete脚本--

delete from T_PLM_CFG_CATEGORYVERSION where FCATEGORYID=?

--给字段加备注--

alter table T_PLM_CFG_CATEGORYVERSION comment '业务类型配置版本';

alter table T_PLM_CFG_CATEGORYVERSION modify column FCATEGORYID bigint not null  comment '业务类型标识';

alter table T_PLM_CFG_CATEGORYVERSION modify column FMODIFYDATE datetime not null  comment '业务类型配置修改更新的时间';

alter table T_PLM_CFG_CATEGORYVERSION modify column FLASTUPDATEDATE datetime not null  comment '业务类型元数据最后更新的时间';

--建表脚本--

create table T_PLM_CFG_CATEGORY_AUIN(

FENTRYID bigint not null  comment 'FENTRYID'

,FID bigint not null  comment 'FID'

,FVALUE bigint not null  comment '授权值'

,FAREA int not null  comment '授权域'

,FAUTHORIZERID nvarchar(100) not null  comment '授权角色id'

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

,FSTAGEID bigint not null  comment '授权阶段id'

,FANCESTOR bigint not null  comment '继承祖先id'

,primary key (FENTRYID)

) comment = '业务类型继承权限缓存表'

--查询--

select FENTRYID as "fentryid",FID as "fid",FVALUE as "fvalue",FAREA as "farea",FAUTHORIZERID as "fauthorizerid",FCATEGORYID as "fcategoryid",FSTAGEID as "fstageid",FANCESTOR as "fancestor" from T_PLM_CFG_CATEGORY_AUIN

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

select FENTRYID as "FENTRYID",FID as "FID",FVALUE as "授权值",FAREA as "授权域",FAUTHORIZERID as "授权角色id",FCATEGORYID as "授权业务类型id",FSTAGEID as "授权阶段id",FANCESTOR as "继承祖先id" from T_PLM_CFG_CATEGORY_AUIN

--INSERT脚本--

insert into T_PLM_CFG_CATEGORY_AUIN(FENTRYID,FID,FVALUE,FAREA,FAUTHORIZERID,FCATEGORYID,FSTAGEID,FANCESTOR) values (?,?,?,?,?,?,?,?)

--UPDATE脚本--

update T_PLM_CFG_CATEGORY_AUIN set FENTRYID=?,FID=?,FVALUE=?,FAREA=?,FAUTHORIZERID=?,FCATEGORYID=?,FSTAGEID=?,FANCESTOR=? where FENTRYID=?

--delete脚本--

delete from T_PLM_CFG_CATEGORY_AUIN where FENTRYID=?

--给字段加备注--

alter table T_PLM_CFG_CATEGORY_AUIN comment '业务类型继承权限缓存表';

alter table T_PLM_CFG_CATEGORY_AUIN modify column FENTRYID bigint not null  comment 'FENTRYID';

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

alter table T_PLM_CFG_CATEGORY_AUIN modify column FVALUE bigint not null  comment '授权值';

alter table T_PLM_CFG_CATEGORY_AUIN modify column FAREA int not null  comment '授权域';

alter table T_PLM_CFG_CATEGORY_AUIN modify column FAUTHORIZERID nvarchar(100) not null  comment '授权角色id';

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

alter table T_PLM_CFG_CATEGORY_AUIN modify column FSTAGEID bigint not null  comment '授权阶段id';

alter table T_PLM_CFG_CATEGORY_AUIN modify column FANCESTOR bigint not null  comment '继承祖先id';

--建表脚本--

create table T_PLM_CFG_CATEGORY_AUTH(

FID bigint not null  comment 'FID'

,FVALUE bigint not null  comment '授权值'

,FAREA int not null  comment '授权域'

,FAUTHORIZERID nvarchar(100) not null  comment '授权角色id'

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

,FSTAGEID bigint not null  comment '授权阶段id'

,FAUTHSTATUS int not null  comment '授权状态'

,primary key (FID)

) comment = '业务类型授权状态表'

--查询--

select FID as "fid",FVALUE as "fvalue",FAREA as "farea",FAUTHORIZERID as "fauthorizerid",FCATEGORYID as "fcategoryid",FSTAGEID as "fstageid",FAUTHSTATUS as "fauthstatus" from T_PLM_CFG_CATEGORY_AUTH

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

select FID as "FID",FVALUE as "授权值",FAREA as "授权域",FAUTHORIZERID as "授权角色id",FCATEGORYID as "授权业务类型id",FSTAGEID as "授权阶段id",FAUTHSTATUS as "授权状态" from T_PLM_CFG_CATEGORY_AUTH

--INSERT脚本--

insert into T_PLM_CFG_CATEGORY_AUTH(FID,FVALUE,FAREA,FAUTHORIZERID,FCATEGORYID,FSTAGEID,FAUTHSTATUS) values (?,?,?,?,?,?,?)

--UPDATE脚本--

update T_PLM_CFG_CATEGORY_AUTH set FID=?,FVALUE=?,FAREA=?,FAUTHORIZERID=?,FCATEGORYID=?,FSTAGEID=?,FAUTHSTATUS=? where FID=?

--delete脚本--

delete from T_PLM_CFG_CATEGORY_AUTH where FID=?

--给字段加备注--

alter table T_PLM_CFG_CATEGORY_AUTH comment '业务类型授权状态表';

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

alter table T_PLM_CFG_CATEGORY_AUTH modify column FVALUE bigint not null  comment '授权值';

alter table T_PLM_CFG_CATEGORY_AUTH modify column FAREA int not null  comment '授权域';

alter table T_PLM_CFG_CATEGORY_AUTH modify column FAUTHORIZERID nvarchar(100) not null  comment '授权角色id';

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

alter table T_PLM_CFG_CATEGORY_AUTH modify column FSTAGEID bigint not null  comment '授权阶段id';

alter table T_PLM_CFG_CATEGORY_AUTH modify column FAUTHSTATUS int not null  comment '授权状态';

--建表脚本--

create table T_PLM_CFG_CATEGORY_L(

FPKID bigint not null  comment 'FPKID'

,FID bigint not null  comment 'FID'

,FLocaleID int not null  comment 'FLocaleID'

,FNAME nvarchar(50) not null  comment '名称'

,primary key (FPKID)

) comment = '业务类型多语言'

--查询--

select FPKID as "fpkid",FID as "fid",FLocaleID as "flocaleid",FNAME as "fname" from T_PLM_CFG_CATEGORY_L

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

select FPKID as "FPKID",FID as "FID",FLocaleID as "FLocaleID",FNAME as "名称" from T_PLM_CFG_CATEGORY_L

--INSERT脚本--

insert into T_PLM_CFG_CATEGORY_L(FPKID,FID,FLocaleID,FNAME) values (?,?,?,?)

--UPDATE脚本--

update T_PLM_CFG_CATEGORY_L set FPKID=?,FID=?,FLocaleID=?,FNAME=? where FPKID=?

--delete脚本--

delete from T_PLM_CFG_CATEGORY_L where FPKID=?

--给字段加备注--

alter table T_PLM_CFG_CATEGORY_L comment '业务类型多语言';

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

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

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

alter table T_PLM_CFG_CATEGORY_L modify column FNAME nvarchar(50) not null  comment '名称';

--建表脚本--

create table T_PLM_CFG_CATEGORY_OP(

FID bigint not null  comment '标识'

,FMasterID bigint not null  comment '多组织标识'

,FCATEGORY bigint default null  comment '业务类型id'

,FOPERATION bigint default null  comment '操作类型id'

,FBILLPATH bigint default null  comment '单据路径'

,FLI