PLM开发字段（生命周期系列）

--建表脚本--

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