--建表脚本--
create table T_PLM_CFG_LIFECYCLE(
FID int not null comment '主键'
,FMasterID int not null comment '组织id'
,FCODE nvarchar(50) default null comment '编码'
,FDESCRIPTION nvarchar(2000) default null comment '描述'
,FCREATORID int not null comment '创建人'
,FCREATEDATE datetime default null comment '创建日期'
,FNAME nvarchar(50) default null comment '名称'
,FISSYSPRESET char(1) not null comment '系统预制'
,primary key (FID)
) comment = '生命周期模版'
--查询--
select FID as "fid",FMasterID as "fmasterid",FCODE as "fcode",FDESCRIPTION as "fdescription",FCREATORID as "fcreatorid",FCREATEDATE as "fcreatedate",FNAME as "fname",FISSYSPRESET as "fissyspreset" from T_PLM_CFG_LIFECYCLE
--查询(中文字段)--
select FID as "主键",FMasterID as "组织id",FCODE as "编码",FDESCRIPTION as "描述",FCREATORID as "创建人",FCREATEDATE as "创建日期",FNAME as "名称",FISSYSPRESET as "系统预制" from T_PLM_CFG_LIFECYCLE
--INSERT脚本--
insert into T_PLM_CFG_LIFECYCLE(FID,FMasterID,FCODE,FDESCRIPTION,FCREATORID,FCREATEDATE,FNAME,FISSYSPRESET) values (?,?,?,?,?,?,?,?)
--UPDATE脚本--
update T_PLM_CFG_LIFECYCLE set FID=?,FMasterID=?,FCODE=?,FDESCRIPTION=?,FCREATORID=?,FCREATEDATE=?,FNAME=?,FISSYSPRESET=? where FID=?
--delete脚本--
delete from T_PLM_CFG_LIFECYCLE where FID=?
--给字段加备注--
alter table T_PLM_CFG_LIFECYCLE comment '生命周期模版';
alter table T_PLM_CFG_LIFECYCLE modify column FID int not null comment '主键';
alter table T_PLM_CFG_LIFECYCLE modify column FMasterID int not null comment '组织id';
alter table T_PLM_CFG_LIFECYCLE modify column FCODE nvarchar(50) default null comment '编码';
alter table T_PLM_CFG_LIFECYCLE modify column FDESCRIPTION nvarchar(2000) default null comment '描述';
alter table T_PLM_CFG_LIFECYCLE modify column FCREATORID int not null comment '创建人';
alter table T_PLM_CFG_LIFECYCLE modify column FCREATEDATE datetime default null comment '创建日期';
alter table T_PLM_CFG_LIFECYCLE modify column FNAME nvarchar(50) default null comment '名称';
alter table T_PLM_CFG_LIFECYCLE modify column FISSYSPRESET char(1) not null comment '系统预制';
--建表脚本--
create table T_PLM_CFG_LIFECYCLEFIELDS(
FID bigint not null comment '主键'
,FFormId varchar(36) default null comment '表单id'
,FFIELDS nvarchar(2000) default null comment '字段集合'
,FCATEGORY bigint not null comment '业务类型'
,FLIFECYCLESTAGE bigint not null comment '生命周期阶段'
,primary key (FID)
) comment = '生命周期字段'
--查询--
select FID as "fid",FFormId as "fformid",FFIELDS as "ffields",FCATEGORY as "fcategory",FLIFECYCLESTAGE as "flifecyclestage" from T_PLM_CFG_LIFECYCLEFIELDS
--查询(中文字段)--
select FID as "主键",FFormId as "表单id",FFIELDS as "字段集合",FCATEGORY as "业务类型",FLIFECYCLESTAGE as "生命周期阶段" from T_PLM_CFG_LIFECYCLEFIELDS
--INSERT脚本--
insert into T_PLM_CFG_LIFECYCLEFIELDS(FID,FFormId,FFIELDS,FCATEGORY,FLIFECYCLESTAGE) values (?,?,?,?,?)
--UPDATE脚本--
update T_PLM_CFG_LIFECYCLEFIELDS set FID=?,FFormId=?,FFIELDS=?,FCATEGORY=?,FLIFECYCLESTAGE=? where FID=?
--delete脚本--
delete from T_PLM_CFG_LIFECYCLEFIELDS where FID=?
--给字段加备注--
alter table T_PLM_CFG_LIFECYCLEFIELDS comment '生命周期字段';
alter table T_PLM_CFG_LIFECYCLEFIELDS modify column FID bigint not null comment '主键';
alter table T_PLM_CFG_LIFECYCLEFIELDS modify column FFormId varchar(36) default null comment '表单id';
alter table T_PLM_CFG_LIFECYCLEFIELDS modify column FFIELDS nvarchar(2000) default null comment '字段集合';
alter table T_PLM_CFG_LIFECYCLEFIELDS modify column FCATEGORY bigint not null comment '业务类型';
alter table T_PLM_CFG_LIFECYCLEFIELDS modify column FLIFECYCLESTAGE bigint not null comment '生命周期阶段';
--建表脚本--
create table T_PLM_CFG_LIFECYCLERULES(
FID bigint not null comment '主键'
,FMasterID bigint not null comment '组织中标识'
,FSOURCESTATE nvarchar(50) default null comment '源状态'
,FTARGETSTATE nvarchar(50) default null comment '目标状态'
,FSTATETRANS char(1) default ''0'' comment '状态转换'
,FUPGRADELV char(1) default ''0'' comment '升大版'
,FUPGRADESV char(1) default ''0'' comment '升小版'
,FLIFECYCLEID nvarchar(50) default null comment '生命周期id'
,primary key (FID)
) comment = '生命周期规则'
--查询--
select FID as "fid",FMasterID as "fmasterid",FSOURCESTATE as "fsourcestate",FTARGETSTATE as "ftargetstate",FSTATETRANS as "fstatetrans",FUPGRADELV as "fupgradelv",FUPGRADESV as "fupgradesv",FLIFECYCLEID as "flifecycleid" from T_PLM_CFG_LIFECYCLERULES
--查询(中文字段)--
select FID as "主键",FMasterID as "组织中标识",FSOURCESTATE as "源状态",FTARGETSTATE as "目标状态",FSTATETRANS as "状态转换",FUPGRADELV as "升大版",FUPGRADESV as "升小版",FLIFECYCLEID as "生命周期id" from T_PLM_CFG_LIFECYCLERULES
--INSERT脚本--
insert into T_PLM_CFG_LIFECYCLERULES(FID,FMasterID,FSOURCESTATE,FTARGETSTATE,FSTATETRANS,FUPGRADELV,FUPGRADESV,FLIFECYCLEID) values (?,?,?,?,?,?,?,?)
--UPDATE脚本--
update T_PLM_CFG_LIFECYCLERULES set FID=?,FMasterID=?,FSOURCESTATE=?,FTARGETSTATE=?,FSTATETRANS=?,FUPGRADELV=?,FUPGRADESV=?,FLIFECYCLEID=? where FID=?
--delete脚本--
delete from T_PLM_CFG_LIFECYCLERULES where FID=?
--给字段加备注--
alter table T_PLM_CFG_LIFECYCLERULES comment '生命周期规则';
alter table T_PLM_CFG_LIFECYCLERULES modify column FID bigint not null comment '主键';
alter table T_PLM_CFG_LIFECYCLERULES modify column FMasterID bigint not null comment '组织中标识';
alter table T_PLM_CFG_LIFECYCLERULES modify column FSOURCESTATE nvarchar(50) default null comment '源状态';
alter table T_PLM_CFG_LIFECYCLERULES modify column FTARGETSTATE nvarchar(50) default null comment '目标状态';
alter table T_PLM_CFG_LIFECYCLERULES modify column FSTATETRANS char(1) default ''0'' comment '状态转换';
alter table T_PLM_CFG_LIFECYCLERULES modify column FUPGRADELV char(1) default ''0'' comment '升大版';
alter table T_PLM_CFG_LIFECYCLERULES modify column FUPGRADESV char(1) default ''0'' comment '升小版';
alter table T_PLM_CFG_LIFECYCLERULES modify column FLIFECYCLEID nvarchar(50) default null comment '生命周期id';
--建表脚本--
create table T_PLM_CFG_LIFECYCLESTAGE(
FID bigint not null comment '主键'
,FMasterID bigint not null comment '组织主键'
,FSTAGE bigint default null comment '生命周期阶段标识'
,FORDER int not null comment '顺序'
,FLIFECYCLEID int not null comment '生命周期模版id'
,FCOLOR char(20) default null comment '颜色'
,FOPERTIONLIST nvarchar(1000) default null comment '操作列表'
,FFIELDLIST nvarchar(1000) default null comment '字段列表'
,FISSYSPRESET char(1) not null comment '系统预制'
,primary key (FID)
) comment = '生命周期阶段'
--查询--
select FID as "fid",FMasterID as "fmasterid",FSTAGE as "fstage",FORDER as "forder",FLIFECYCLEID as "flifecycleid",FCOLOR as "fcolor",FOPERTIONLIST as "fopertionlist",FFIELDLIST as "ffieldlist",FISSYSPRESET as "fissyspreset" from T_PLM_CFG_LIFECYCLESTAGE
--查询(中文字段)--
select FID as "主键",FMasterID as "组织主键",FSTAGE as "生命周期阶段标识",FORDER as "顺序",FLIFECYCLEID as "生命周期模版id",FCOLOR as "颜色",FOPERTIONLIST as "操作列表",FFIELDLIST as "字段列表",FISSYSPRESET as "系统预制" from T_PLM_CFG_LIFECYCLESTAGE
--INSERT脚本--
insert into T_PLM_CFG_LIFECYCLESTAGE(FID,FMasterID,FSTAGE,FORDER,FLIFECYCLEID,FCOLOR,FOPERTIONLIST,FFIELDLIST,FISSYSPRESET) values (?,?,?,?,?,?,?,?,?)
--UPDATE脚本--
update T_PLM_CFG_LIFECYCLESTAGE set FID=?,FMasterID=?,FSTAGE=?,FORDER=?,FLIFECYCLEID=?,FCOLOR=?,FOPERTIONLIST=?,FFIELDLIST=?,FISSYSPRESET=? where FID=?
--delete脚本--
delete from T_PLM_CFG_LIFECYCLESTAGE where FID=?
--给字段加备注--
alter table T_PLM_CFG_LIFECYCLESTAGE comment '生命周期阶段';
alter table T_PLM_CFG_LIFECYCLESTAGE modify column FID bigint not null comment '主键';
alter table T_PLM_CFG_LIFECYCLESTAGE modify column FMasterID bigint not null comment '组织主键';
alter table T_PLM_CFG_LIFECYCLESTAGE modify column FSTAGE bigint default null comment '生命周期阶段标识';
alter table T_PLM_CFG_LIFECYCLESTAGE modify column FORDER int not null comment '顺序';
alter table T_PLM_CFG_LIFECYCLESTAGE modify column FLIFECYCLEID int not null comment '生命周期模版id';
alter table T_PLM_CFG_LIFECYCLESTAGE modify column FCOLOR char(20) default null comment '颜色';
alter table T_PLM_CFG_LIFECYCLESTAGE modify column FOPERTIONLIST nvarchar(1000) default null comment '操作列表';
alter table T_PLM_CFG_LIFECYCLESTAGE modify column FFIELDLIST nvarchar(1000) default null comment '字段列表';
alter table T_PLM_CFG_LIFECYCLESTAGE modify column FISSYSPRESET char(1) not null comment '系统预制';
--建表脚本--
create table T_PLM_CFG_LIFESTAGE_OP(
FID bigint not null comment '主键'
,FMasterID bigint not null comment '组织主键'
,FOPERATION bigint not null comment '操作'
,FBILLNAME nvarchar(200) default null comment '单据按钮名称'
,FLISTNAME nvarchar(200) default null comment '列表按钮名称'
,FISBILL char(1) default ''0'' comment '是否单据按钮'
,FISLIST char(1) default ''0'' comment '是否列表按钮'
,FISCUSTOMER char(1) default ''0'' comment '是否用户自定义'
,FLIFECYCLESTAGE nvarchar(50) default null comment '生命周期阶段值'
,FLIFECYCLEID int not null comment '生命周期模版'
,FPARAMS nvarchar(2000) default null comment '参数'
,FISSELECTED char(1) default ''0'' comment '是否启用'
,FBILLPATH nvarchar(200) default null comment '单据按钮路径'
,FLISTPATH nvarchar(200) default null comment '列表按钮路径'
,primary key (FID)
) comment = '生命周期阶段操作'
--查询--
select FID as "fid",FMasterID as "fmasterid",FOPERATION as "foperation",FBILLNAME as "fbillname",FLISTNAME as "flistname",FISBILL as "fisbill",FISLIST as "fislist",FISCUSTOMER as "fiscustomer",FLIFECYCLESTAGE as "flifecyclestage",FLIFECYCLEID as "flifecycleid",FPARAMS as "fparams",FISSELECTED as "fisselected",FBILLPATH as "fbillpath",FLISTPATH as "flistpath" from T_PLM_CFG_LIFESTAGE_OP
--查询(中文字段)--
select FID as "主键",FMasterID as "组织主键",FOPERATION as "操作",FBILLNAME as "单据按钮名称",FLISTNAME as "列表按钮名称",FISBILL as "是否单据按钮",FISLIST as "是否列表按钮",FISCUSTOMER as "是否用户自定义",FLIFECYCLESTAGE as "生命周期阶段值",FLIFECYCLEID as "生命周期模版",FPARAMS as "参数",FISSELECTED as "是否启用",FBILLPATH as "单据按钮路径",FLISTPATH as "列表按钮路径" from T_PLM_CFG_LIFESTAGE_OP
--INSERT脚本--
insert into T_PLM_CFG_LIFESTAGE_OP(FID,FMasterID,FOPERATION,FBILLNAME,FLISTNAME,FISBILL,FISLIST,FISCUSTOMER,FLIFECYCLESTAGE,FLIFECYCLEID,FPARAMS,FISSELECTED,FBILLPATH,FLISTPATH) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?)
--UPDATE脚本--
update T_PLM_CFG_LIFESTAGE_OP set FID=?,FMasterID=?,FOPERATION=?,FBILLNAME=?,FLISTNAME=?,FISBILL=?,FISLIST=?,FISCUSTOMER=?,FLIFECYCLESTAGE=?,FLIFECYCLEID=?,FPARAMS=?,FISSELECTED=?,FBILLPATH=?,FLISTPATH=? where FID=?
--delete脚本--
delete from T_PLM_CFG_LIFESTAGE_OP where FID=?
--给字段加备注--
alter table T_PLM_CFG_LIFESTAGE_OP comment '生命周期阶段操作';
alter table T_PLM_CFG_LIFESTAGE_OP modify column FID bigint not null comment '主键';
alter table T_PLM_CFG_LIFESTAGE_OP modify column FMasterID bigint not null comment '组织主键';
alter table T_PLM_CFG_LIFESTAGE_OP modify column FOPERATION bigint not null comment '操作';
alter table T_PLM_CFG_LIFESTAGE_OP modify column FBILLNAME nvarchar(200) default null comment '单据按钮名称';
alter table T_PLM_CFG_LIFESTAGE_OP modify column FLISTNAME nvarchar(200) default null comment '列表按钮名称';
alter table T_PLM_CFG_LIFESTAGE_OP modify column FISBILL char(1) default ''0'' comment '是否单据按钮';
alter table T_PLM_CFG_LIFESTAGE_OP modify column FISLIST char(1) default ''0'' comment '是否列表按钮';
alter table T_PLM_CFG_LIFESTAGE_OP modify column FISCUSTOMER char(1) default ''0'' comment '是否用户自定义';
alter table T_PLM_CFG_LIFESTAGE_OP modify column FLIFECYCLESTAGE nvarchar(50) default null comment '生命周期阶段值';
alter table T_PLM_CFG_LIFESTAGE_OP modify column FLIFECYCLEID int not null comment '生命周期模版';
alter table T_PLM_CFG_LIFESTAGE_OP modify column FPARAMS nvarchar(2000) default null comment '参数';
alter table T_PLM_CFG_LIFESTAGE_OP modify column FISSELECTED char(1) default ''0'' comment '是否启用';
alter table T_PLM_CFG_LIFESTAGE_OP modify column FBILLPATH nvarchar(200) default null comment '单据按钮路径';
alter table T_PLM_CFG_LIFESTAGE_OP modify column FLISTPATH nvarchar(200) default null comment '列表按钮路径';
推荐阅读
