PLM-业务类型原创
金蝶云·星空
金蝶云·星空实施
金蝶云·星空-学习笔记
金蝶云·星空-PLM
金蝶云社区-枯藤老树昏鸦
枯藤老树昏鸦
70人赞赏了该文章 369次浏览 未经作者许可，禁止转载编辑于2024年05月24日 08:05:10

image.png

--建表脚本--

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 '单据路径'

,FLISTPATH bigint default null  comment '列表路径'

,FISCUSTOMER char(1) default ''0''  comment '是否是自定义'

,FANCESTOR bigint default null  comment '父项id'

,FISINHERIT char(1) default ''0''  comment '是否继承'

,primary key (FID)

) comment = '业务类型操作'


--查询--

select FID as "fid",FMasterID as "fmasterid",FCATEGORY as "fcategory",FOPERATION as "foperation",FBILLPATH as "fbillpath",FLISTPATH as "flistpath",FISCUSTOMER as "fiscustomer",FANCESTOR as "fancestor",FISINHERIT as "fisinherit" from T_PLM_CFG_CATEGORY_OP


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

select FID as "标识",FMasterID as "多组织标识",FCATEGORY as "业务类型id",FOPERATION as "操作类型id",FBILLPATH as "单据路径",FLISTPATH as "列表路径",FISCUSTOMER as "是否是自定义",FANCESTOR as "父项id",FISINHERIT as "是否继承" from T_PLM_CFG_CATEGORY_OP


--INSERT脚本--

insert into T_PLM_CFG_CATEGORY_OP(FID,FMasterID,FCATEGORY,FOPERATION,FBILLPATH,FLISTPATH,FISCUSTOMER,FANCESTOR,FISINHERIT) values (?,?,?,?,?,?,?,?,?)


--UPDATE脚本--

update T_PLM_CFG_CATEGORY_OP set FID=?,FMasterID=?,FCATEGORY=?,FOPERATION=?,FBILLPATH=?,FLISTPATH=?,FISCUSTOMER=?,FANCESTOR=?,FISINHERIT=? where FID=?


--delete脚本--

delete from T_PLM_CFG_CATEGORY_OP where FID=?


--给字段加备注--

alter table T_PLM_CFG_CATEGORY_OP comment '业务类型操作';

alter table T_PLM_CFG_CATEGORY_OP modify column FID bigint not null  comment '标识';

alter table T_PLM_CFG_CATEGORY_OP modify column FMasterID bigint not null  comment '多组织标识';

alter table T_PLM_CFG_CATEGORY_OP modify column FCATEGORY bigint default null  comment '业务类型id';

alter table T_PLM_CFG_CATEGORY_OP modify column FOPERATION bigint default null  comment '操作类型id';

alter table T_PLM_CFG_CATEGORY_OP modify column FBILLPATH bigint default null  comment '单据路径';

alter table T_PLM_CFG_CATEGORY_OP modify column FLISTPATH bigint default null  comment '列表路径';

alter table T_PLM_CFG_CATEGORY_OP modify column FISCUSTOMER char(1) default ''0''  comment '是否是自定义';

alter table T_PLM_CFG_CATEGORY_OP modify column FANCESTOR bigint default null  comment '父项id';

alter table T_PLM_CFG_CATEGORY_OP modify column FISINHERIT char(1) default ''0''  comment '是否继承';

--建表脚本--

create table T_PLM_CFG_CATEGORY_OP_L(

FPKID bigint not null  comment 'FPKID'

,FID bigint not null  comment '对象标识'

,FLocaleID int not null  comment '语言标识'

,FBILLNAME nvarchar(50) default null  comment '单据上的名称'

,FLISTNAME nvarchar(50) default null  comment '列表上的名称'

,primary key (FPKID)

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


--查询--

select FPKID as "fpkid",FID as "fid",FLocaleID as "flocaleid",FBILLNAME as "fbillname",FLISTNAME as "flistname" from T_PLM_CFG_CATEGORY_OP_L


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

select FPKID as "FPKID",FID as "对象标识",FLocaleID as "语言标识",FBILLNAME as "单据上的名称",FLISTNAME as "列表上的名称" from T_PLM_CFG_CATEGORY_OP_L


--INSERT脚本--

insert into T_PLM_CFG_CATEGORY_OP_L(FPKID,FID,FLocaleID,FBILLNAME,FLISTNAME) values (?,?,?,?,?)


--UPDATE脚本--

update T_PLM_CFG_CATEGORY_OP_L set FPKID=?,FID=?,FLocaleID=?,FBILLNAME=?,FLISTNAME=? where FPKID=?


--delete脚本--

delete from T_PLM_CFG_CATEGORY_OP_L where FPKID=?


--给字段加备注--

alter table T_PLM_CFG_CATEGORY_OP_L comment '业务类型操作多语言';

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

alter table T_PLM_CFG_CATEGORY_OP_L modify column FID bigint not null  comment '对象标识';

alter table T_PLM_CFG_CATEGORY_OP_L modify column FLocaleID int not null  comment '语言标识';

alter table T_PLM_CFG_CATEGORY_OP_L modify column FBILLNAME nvarchar(50) default null  comment '单据上的名称';

alter table T_PLM_CFG_CATEGORY_OP_L modify column FLISTNAME nvarchar(50) default null  comment '列表上的名称';

--建表脚本--

create table T_PLM_CFG_CATEGORY_PERM(

FID bigint not null  comment 'FID'

,FMasterID bigint not null  comment 'FMasterID'

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

,FPERMISSIONOBJECTID varchar(36) not null  comment '权限对象id'

,FSTAGE bigint not null  comment '阶段'

,primary key (FID)

) comment = '业务类型分录'


--查询--

select FID as "fid",FMasterID as "fmasterid",FCATEGORYID as "fcategoryid",FPERMISSIONOBJECTID as "fpermissionobjectid",FSTAGE as "fstage" from T_PLM_CFG_CATEGORY_PERM


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

select FID as "FID",FMasterID as "FMasterID",FCATEGORYID as "业务类型id",FPERMISSIONOBJECTID as "权限对象id",FSTAGE as "阶段" from T_PLM_CFG_CATEGORY_PERM


--INSERT脚本--

insert into T_PLM_CFG_CATEGORY_PERM(FID,FMasterID,FCATEGORYID,FPERMISSIONOBJECTID,FSTAGE) values (?,?,?,?,?)


--UPDATE脚本--

update T_PLM_CFG_CATEGORY_PERM set FID=?,FMasterID=?,FCATEGORYID=?,FPERMISSIONOBJECTID=?,FSTAGE=? where FID=?


--delete脚本--

delete from T_PLM_CFG_CATEGORY_PERM where FID=?


--给字段加备注--

alter table T_PLM_CFG_CATEGORY_PERM comment '业务类型分录';

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

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

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

alter table T_PLM_CFG_CATEGORY_PERM modify column FPERMISSIONOBJECTID varchar(36) not null  comment '权限对象id';

alter table T_PLM_CFG_CATEGORY_PERM modify column FSTAGE bigint not null  comment '阶段';

--建表脚本--

create table T_PLM_CFG_CATEGORY_RULE(

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

,FRULEID varchar(36) not null  comment '编码规则id'

,FBASEID bigint not null  comment '对象id'

,primary key (FCATEGORYID,FRULEID)

) comment = '业务类型对应编码规则流水更新记录表'


--查询--

select FCATEGORYID as "fcategoryid",FRULEID as "fruleid",FBASEID as "fbaseid" from T_PLM_CFG_CATEGORY_RULE


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

select FCATEGORYID as "业务类型id",FRULEID as "编码规则id",FBASEID as "对象id" from T_PLM_CFG_CATEGORY_RULE


--INSERT脚本--

insert into T_PLM_CFG_CATEGORY_RULE(FCATEGORYID,FRULEID,FBASEID) values (?,?,?)


--UPDATE脚本--

update T_PLM_CFG_CATEGORY_RULE set FCATEGORYID=?,FRULEID=?,FBASEID=? where FCATEGORYID=? AND FRULEID=?


--delete脚本--

delete from T_PLM_CFG_CATEGORY_RULE where FCATEGORYID=? AND FRULEID=?


--给字段加备注--

alter table T_PLM_CFG_CATEGORY_RULE comment '业务类型对应编码规则流水更新记录表';

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

alter table T_PLM_CFG_CATEGORY_RULE modify column FRULEID varchar(36) not null  comment '编码规则id';

alter table T_PLM_CFG_CATEGORY_RULE modify column FBASEID bigint not null  comment '对象id';

--建表脚本--

create table T_PLM_CFG_CATEGORY_TEMP(

FID nvarchar(50) not null  comment 'FID'

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

,FSTAGEVALUE nvarchar(5) not null  comment '生命周期状态'

,FAUTHORIZERID nvarchar(50) not null  comment '分配对象'

,primary key (FID)

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


--查询--

select FID as "fid",FCATEGORYID as "fcategoryid",FSTAGEVALUE as "fstagevalue",FAUTHORIZERID as "fauthorizerid" from T_PLM_CFG_CATEGORY_TEMP


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

select FID as "FID",FCATEGORYID as "业务类型id",FSTAGEVALUE as "生命周期状态",FAUTHORIZERID as "分配对象" from T_PLM_CFG_CATEGORY_TEMP


--INSERT脚本--

insert into T_PLM_CFG_CATEGORY_TEMP(FID,FCATEGORYID,FSTAGEVALUE,FAUTHORIZERID) values (?,?,?,?)


--UPDATE脚本--

update T_PLM_CFG_CATEGORY_TEMP set FID=?,FCATEGORYID=?,FSTAGEVALUE=?,FAUTHORIZERID=? where FID=?


--delete脚本--

delete from T_PLM_CFG_CATEGORY_TEMP where FID=?


--给字段加备注--

alter table T_PLM_CFG_CATEGORY_TEMP comment '业务类型权限缓存表';

alter table T_PLM_CFG_CATEGORY_TEMP modify column FID nvarchar(50) not null  comment 'FID';

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

alter table T_PLM_CFG_CATEGORY_TEMP modify column FSTAGEVALUE nvarchar(5) not null  comment '生命周期状态';

alter table T_PLM_CFG_CATEGORY_TEMP modify column FAUTHORIZERID nvarchar(50) not null  comment '分配对象';

上传图片


赞 70

推荐阅读

星空|PLM|业务类型|新增业务类型注意项

新增PLM业务类型 以物料为例，新增PLM业务类型应该注意哪些内容。 属性配置 在业务类型配置中进行属性配置，增减字段以及调整字段顺序。 可以利用配置复用，co …

    文章

    180

PLM业务类型模板扩展汇总帖

说明： 由于PLM的业务类型与平台单据映射的业务数据与业务处理可能不全或不完全兼容；如果扩展了业务类型单据，会导致界面混乱与升级一系列不可控的问题。为了规范扩展 …

    知识

    2,191

PLM业务类型配置属性配置格式定义中使用辅助 …

【应用场景】 业务类型配置属性配置格式定义中使用辅助属性类型 【具体解析】 1、打开业务类型配置 [图片] 2、双击需要的属性所在行的格式定义 [图片] 3、双 …

    知识

    1,618