--建表脚本--

create table T_PLM_WF_BASEOBJECTBILL(

FID bigint not null  comment '主键'

,FBILLNO nvarchar(30) default null  comment '单据编号'

,FDOCUMENTSTATUS char(1) default ''0''  comment '数据状态'

,FBILLNONAME nvarchar(255) default null  comment '单据名称'

,FCREATORID int not null  comment '创建人'

,FMODIFYDATE datetime default null  comment '修改日期'

,FCREATEDATE datetime default null  comment '创建日期'

,FMODIFIERID int not null  comment '修改人'

,FFLOWTYPE int not null  comment '流程类型'

,FMARK nvarchar(1000) not null  comment '备注'

,primary key (FID)

) comment = 'plm基础对象单据'

--查询--

select FID as "fid",FBILLNO as "fbillno",FDOCUMENTSTATUS as "fdocumentstatus",FBILLNONAME as "fbillnoname",FCREATORID as "fcreatorid",FMODIFYDATE as "fmodifydate",FCREATEDATE as "fcreatedate",FMODIFIERID as "fmodifierid",FFLOWTYPE as "fflowtype",FMARK as "fmark" from T_PLM_WF_BASEOBJECTBILL

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

select FID as "主键",FBILLNO as "单据编号",FDOCUMENTSTATUS as "数据状态",FBILLNONAME as "单据名称",FCREATORID as "创建人",FMODIFYDATE as "修改日期",FCREATEDATE as "创建日期",FMODIFIERID as "修改人",FFLOWTYPE as "流程类型",FMARK as "备注" from T_PLM_WF_BASEOBJECTBILL

--INSERT脚本--

insert into T_PLM_WF_BASEOBJECTBILL(FID,FBILLNO,FDOCUMENTSTATUS,FBILLNONAME,FCREATORID,FMODIFYDATE,FCREATEDATE,FMODIFIERID,FFLOWTYPE,FMARK) values (?,?,?,?,?,?,?,?,?,?)

--UPDATE脚本--

update T_PLM_WF_BASEOBJECTBILL set FID=?,FBILLNO=?,FDOCUMENTSTATUS=?,FBILLNONAME=?,FCREATORID=?,FMODIFYDATE=?,FCREATEDATE=?,FMODIFIERID=?,FFLOWTYPE=?,FMARK=? where FID=?

--delete脚本--

delete from T_PLM_WF_BASEOBJECTBILL where FID=?

--给字段加备注--

alter table T_PLM_WF_BASEOBJECTBILL comment 'plm基础对象单据';

alter table T_PLM_WF_BASEOBJECTBILL modify column FID bigint not null  comment '主键';

alter table T_PLM_WF_BASEOBJECTBILL modify column FBILLNO nvarchar(30) default null  comment '单据编号';

alter table T_PLM_WF_BASEOBJECTBILL modify column FDOCUMENTSTATUS char(1) default ''0''  comment '数据状态';

alter table T_PLM_WF_BASEOBJECTBILL modify column FBILLNONAME nvarchar(255) default null  comment '单据名称';

alter table T_PLM_WF_BASEOBJECTBILL modify column FCREATORID int not null  comment '创建人';

alter table T_PLM_WF_BASEOBJECTBILL modify column FMODIFYDATE datetime default null  comment '修改日期';

alter table T_PLM_WF_BASEOBJECTBILL modify column FCREATEDATE datetime default null  comment '创建日期';

alter table T_PLM_WF_BASEOBJECTBILL modify column FMODIFIERID int not null  comment '修改人';

alter table T_PLM_WF_BASEOBJECTBILL modify column FFLOWTYPE int not null  comment '流程类型';

alter table T_PLM_WF_BASEOBJECTBILL modify column FMARK nvarchar(1000) not null  comment '备注';

--建表脚本--

create table T_PLM_WF_BASEOBJECTBILLENTRY(

FEntryID bigint not null  comment '从表主键'

,FID bigint not null  comment '主键'

,FBASECODE bigint not null  comment '基础对象'

,FICON nvarchar(2000) not null  comment '图标'

,FISCHECK char(1) not null  comment '是否选中对象'

,FROWID nvarchar(50) not null  comment '体行id'

,FPARENTROWID nvarchar(50) not null  comment '父级行id'

,FROWEXPANDTYPE nvarchar(50) not null  comment '展开类型'

,primary key (FEntryID)

) comment = '流程单据子单据体'

--查询--

select FEntryID as "fentryid",FID as "fid",FBASECODE as "fbasecode",FICON as "ficon",FISCHECK as "fischeck",FROWID as "frowid",FPARENTROWID as "fparentrowid",FROWEXPANDTYPE as "frowexpandtype" from T_PLM_WF_BASEOBJECTBILLENTRY

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

select FEntryID as "从表主键",FID as "主键",FBASECODE as "基础对象",FICON as "图标",FISCHECK as "是否选中对象",FROWID as "体行id",FPARENTROWID as "父级行id",FROWEXPANDTYPE as "展开类型" from T_PLM_WF_BASEOBJECTBILLENTRY

--INSERT脚本--

insert into T_PLM_WF_BASEOBJECTBILLENTRY(FEntryID,FID,FBASECODE,FICON,FISCHECK,FROWID,FPARENTROWID,FROWEXPANDTYPE) values (?,?,?,?,?,?,?,?)

--UPDATE脚本--

update T_PLM_WF_BASEOBJECTBILLENTRY set FEntryID=?,FID=?,FBASECODE=?,FICON=?,FISCHECK=?,FROWID=?,FPARENTROWID=?,FROWEXPANDTYPE=? where FEntryID=?

--delete脚本--

delete from T_PLM_WF_BASEOBJECTBILLENTRY where FEntryID=?

--给字段加备注--

alter table T_PLM_WF_BASEOBJECTBILLENTRY comment '流程单据子单据体';

alter table T_PLM_WF_BASEOBJECTBILLENTRY modify column FEntryID bigint not null  comment '从表主键';

alter table T_PLM_WF_BASEOBJECTBILLENTRY modify column FID bigint not null  comment '主键';

alter table T_PLM_WF_BASEOBJECTBILLENTRY modify column FBASECODE bigint not null  comment '基础对象';

alter table T_PLM_WF_BASEOBJECTBILLENTRY modify column FICON nvarchar(2000) not null  comment '图标';

alter table T_PLM_WF_BASEOBJECTBILLENTRY modify column FISCHECK char(1) not null  comment '是否选中对象';

alter table T_PLM_WF_BASEOBJECTBILLENTRY modify column FROWID nvarchar(50) not null  comment '体行id';

alter table T_PLM_WF_BASEOBJECTBILLENTRY modify column FPARENTROWID nvarchar(50) not null  comment '父级行id';

alter table T_PLM_WF_BASEOBJECTBILLENTRY modify column FROWEXPANDTYPE nvarchar(50) not null  comment '展开类型';

--建表脚本--

create table T_PLM_WF_BILLMODEL(

FID bigint not null  comment '主键'

,FBILLNO nvarchar(30) default null  comment '单据编码'

,FDOCUMENTSTATUS char(1) default ''0''  comment '流程状态'

,primary key (FID)

) comment = '流程单据状态'

--查询--

select FID as "fid",FBILLNO as "fbillno",FDOCUMENTSTATUS as "fdocumentstatus" from T_PLM_WF_BILLMODEL

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

select FID as "主键",FBILLNO as "单据编码",FDOCUMENTSTATUS as "流程状态" from T_PLM_WF_BILLMODEL

--INSERT脚本--

insert into T_PLM_WF_BILLMODEL(FID,FBILLNO,FDOCUMENTSTATUS) values (?,?,?)

--UPDATE脚本--

update T_PLM_WF_BILLMODEL set FID=?,FBILLNO=?,FDOCUMENTSTATUS=? where FID=?

--delete脚本--

delete from T_PLM_WF_BILLMODEL where FID=?

--给字段加备注--

alter table T_PLM_WF_BILLMODEL comment '流程单据状态';

alter table T_PLM_WF_BILLMODEL modify column FID bigint not null  comment '主键';

alter table T_PLM_WF_BILLMODEL modify column FBILLNO nvarchar(30) default null  comment '单据编码';

alter table T_PLM_WF_BILLMODEL modify column FDOCUMENTSTATUS char(1) default ''0''  comment '流程状态';

--建表脚本--

create table T_PLM_WF_FLOWTEMPLATE(

FID bigint not null  comment '主键'

,FMasterID bigint not null  comment '组织id'

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

,FTMPDETAILID int not null  comment '模版id'

,primary key (FID)

) comment = 'plm流程模版'

--查询--

select FID as "fid",FMasterID as "fmasterid",FCATEGORYID as "fcategoryid",FTMPDETAILID as "ftmpdetailid" from T_PLM_WF_FLOWTEMPLATE

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

select FID as "主键",FMasterID as "组织id",FCATEGORYID as "业务类型",FTMPDETAILID as "模版id" from T_PLM_WF_FLOWTEMPLATE

--INSERT脚本--

insert into T_PLM_WF_FLOWTEMPLATE(FID,FMasterID,FCATEGORYID,FTMPDETAILID) values (?,?,?,?)

--UPDATE脚本--

update T_PLM_WF_FLOWTEMPLATE set FID=?,FMasterID=?,FCATEGORYID=?,FTMPDETAILID=? where FID=?

--delete脚本--

delete from T_PLM_WF_FLOWTEMPLATE where FID=?

--给字段加备注--

alter table T_PLM_WF_FLOWTEMPLATE comment 'plm流程模版';

alter table T_PLM_WF_FLOWTEMPLATE modify column FID bigint not null  comment '主键';

alter table T_PLM_WF_FLOWTEMPLATE modify column FMasterID bigint not null  comment '组织id';

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

alter table T_PLM_WF_FLOWTEMPLATE modify column FTMPDETAILID int not null  comment '模版id';