--建表脚本--

create table T_PLM_CFG_APFWFGROUP(

FID bigint not null  comment 'FID'

,FMasterID bigint not null  comment 'FMasterID'

,FMATGROUP bigint not null  comment '物料字段分组'

,FREADONLY char(1) not null  comment '只读'

,FHIDE char(1) not null  comment '隐藏'

,FPROCESSID nvarchar(50) not null  comment '流程实例id'

,FNODEID nvarchar(50) not null  comment '流程节点id'

,primary key (FID)

) comment = '申请单流程节点分组配置表'

--查询--

select FID as "fid",FMasterID as "fmasterid",FMATGROUP as "fmatgroup",FREADONLY as "freadonly",FHIDE as "fhide",FPROCESSID as "fprocessid",FNODEID as "fnodeid" from T_PLM_CFG_APFWFGROUP

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

select FID as "FID",FMasterID as "FMasterID",FMATGROUP as "物料字段分组",FREADONLY as "只读",FHIDE as "隐藏",FPROCESSID as "流程实例id",FNODEID as "流程节点id" from T_PLM_CFG_APFWFGROUP

--INSERT脚本--

insert into T_PLM_CFG_APFWFGROUP(FID,FMasterID,FMATGROUP,FREADONLY,FHIDE,FPROCESSID,FNODEID) values (?,?,?,?,?,?,?)

--UPDATE脚本--

update T_PLM_CFG_APFWFGROUP set FID=?,FMasterID=?,FMATGROUP=?,FREADONLY=?,FHIDE=?,FPROCESSID=?,FNODEID=? where FID=?

--delete脚本--

delete from T_PLM_CFG_APFWFGROUP where FID=?

--给字段加备注--

alter table T_PLM_CFG_APFWFGROUP comment '申请单流程节点分组配置表';

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

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

alter table T_PLM_CFG_APFWFGROUP modify column FMATGROUP bigint not null  comment '物料字段分组';

alter table T_PLM_CFG_APFWFGROUP modify column FREADONLY char(1) not null  comment '只读';

alter table T_PLM_CFG_APFWFGROUP modify column FHIDE char(1) not null  comment '隐藏';

alter table T_PLM_CFG_APFWFGROUP modify column FPROCESSID nvarchar(50) not null  comment '流程实例id';

alter table T_PLM_CFG_APFWFGROUP modify column FNODEID nvarchar(50) not null  comment '流程节点id';

--建表脚本--

create table T_PLM_CFG_APPLYFORMCONFIG(

FID bigint not null  comment 'FID'

,FMasterID bigint not null  comment 'FMasterID'

,FAFFIELD bigint not null  comment '字段id'

,FISEXPORT char(1) not null  comment '是否导出'

,primary key (FID)

) comment = '申请单导出字段配置'

--查询--

select FID as "fid",FMasterID as "fmasterid",FAFFIELD as "faffield",FISEXPORT as "fisexport" from T_PLM_CFG_APPLYFORMCONFIG

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

select FID as "FID",FMasterID as "FMasterID",FAFFIELD as "字段id",FISEXPORT as "是否导出" from T_PLM_CFG_APPLYFORMCONFIG

--INSERT脚本--

insert into T_PLM_CFG_APPLYFORMCONFIG(FID,FMasterID,FAFFIELD,FISEXPORT) values (?,?,?,?)

--UPDATE脚本--

update T_PLM_CFG_APPLYFORMCONFIG set FID=?,FMasterID=?,FAFFIELD=?,FISEXPORT=? where FID=?

--delete脚本--

delete from T_PLM_CFG_APPLYFORMCONFIG where FID=?

--给字段加备注--

alter table T_PLM_CFG_APPLYFORMCONFIG comment '申请单导出字段配置';

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

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

alter table T_PLM_CFG_APPLYFORMCONFIG modify column FAFFIELD bigint not null  comment '字段id';

alter table T_PLM_CFG_APPLYFORMCONFIG modify column FISEXPORT char(1) not null  comment '是否导出';

--建表脚本--

create table T_PLM_CFG_APPLYFORMMATGROUP(

FID bigint not null  comment 'FID'

,FMasterID bigint not null  comment 'FMasterID'

,FGROUPSEQ int not null  comment '分组顺序'

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

,primary key (FID)

) comment = '申请单物料字段分组'

--查询--

select FID as "fid",FMasterID as "fmasterid",FGROUPSEQ as "fgroupseq",FCATEGORYID as "fcategoryid" from T_PLM_CFG_APPLYFORMMATGROUP

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

select FID as "FID",FMasterID as "FMasterID",FGROUPSEQ as "分组顺序",FCATEGORYID as "业务类型id" from T_PLM_CFG_APPLYFORMMATGROUP

--INSERT脚本--

insert into T_PLM_CFG_APPLYFORMMATGROUP(FID,FMasterID,FGROUPSEQ,FCATEGORYID) values (?,?,?,?)

--UPDATE脚本--

update T_PLM_CFG_APPLYFORMMATGROUP set FID=?,FMasterID=?,FGROUPSEQ=?,FCATEGORYID=? where FID=?

--delete脚本--

delete from T_PLM_CFG_APPLYFORMMATGROUP where FID=?

--给字段加备注--

alter table T_PLM_CFG_APPLYFORMMATGROUP comment '申请单物料字段分组';

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

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

alter table T_PLM_CFG_APPLYFORMMATGROUP modify column FGROUPSEQ int not null  comment '分组顺序';

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

--建表脚本--

create table T_PLM_CFG_APPLYFORMMATGROUP_L(

FPKID bigint not null  comment 'FPKID'

,FID bigint default 0  comment 'FID'

,FLocaleID int default 0  comment 'FLocaleID'

,FGROUPNAME nvarchar(50) default ''  comment 'FGROUPNAME'

,primary key (FPKID)

) comment = '申请单物料字段分组多语言'

--查询--

select FPKID as "fpkid",FID as "fid",FLocaleID as "flocaleid",FGROUPNAME as "fgroupname" from T_PLM_CFG_APPLYFORMMATGROUP_L

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

select FPKID as "FPKID",FID as "FID",FLocaleID as "FLocaleID",FGROUPNAME as "FGROUPNAME" from T_PLM_CFG_APPLYFORMMATGROUP_L

--INSERT脚本--

insert into T_PLM_CFG_APPLYFORMMATGROUP_L(FPKID,FID,FLocaleID,FGROUPNAME) values (?,?,?,?)

--UPDATE脚本--

update T_PLM_CFG_APPLYFORMMATGROUP_L set FPKID=?,FID=?,FLocaleID=?,FGROUPNAME=? where FPKID=?

--delete脚本--

delete from T_PLM_CFG_APPLYFORMMATGROUP_L where FPKID=?

--给字段加备注--

alter table T_PLM_CFG_APPLYFORMMATGROUP_L comment '申请单物料字段分组多语言';

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

alter table T_PLM_CFG_APPLYFORMMATGROUP_L modify column FID bigint default 0  comment 'FID';

alter table T_PLM_CFG_APPLYFORMMATGROUP_L modify column FLocaleID int default 0  comment 'FLocaleID';

alter table T_PLM_CFG_APPLYFORMMATGROUP_L modify column FGROUPNAME nvarchar(50) default ''  comment 'FGROUPNAME';

--建表脚本--

create table T_PLM_CFG_APPLYMATRELATION(

FID bigint not null  comment '主键'

,FMasterID bigint not null  comment '组织id'

,FAPPLYFORMID nvarchar(50) default null  comment '申请单id'

,FMATERIALID nvarchar(50) default null  comment '物料id'

,primary key (FID)

) comment = '记录申请单生成的物料'

--查询--

select FID as "fid",FMasterID as "fmasterid",FAPPLYFORMID as "fapplyformid",FMATERIALID as "fmaterialid" from T_PLM_CFG_APPLYMATRELATION

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

select FID as "主键",FMasterID as "组织id",FAPPLYFORMID as "申请单id",FMATERIALID as "物料id" from T_PLM_CFG_APPLYMATRELATION

--INSERT脚本--

insert into T_PLM_CFG_APPLYMATRELATION(FID,FMasterID,FAPPLYFORMID,FMATERIALID) values (?,?,?,?)

--UPDATE脚本--

update T_PLM_CFG_APPLYMATRELATION set FID=?,FMasterID=?,FAPPLYFORMID=?,FMATERIALID=? where FID=?

--delete脚本--

delete from T_PLM_CFG_APPLYMATRELATION where FID=?

--给字段加备注--

alter table T_PLM_CFG_APPLYMATRELATION comment '记录申请单生成的物料';

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

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

alter table T_PLM_CFG_APPLYMATRELATION modify column FAPPLYFORMID nvarchar(50) default null  comment '申请单id';

alter table T_PLM_CFG_APPLYMATRELATION modify column FMATERIALID nvarchar(50) default null  comment '物料id';

--建表脚本--

create table T_PLM_CFG_ASYNC_TASK(

FID bigint not null  comment '标识'

,FMasterID bigint default null  comment '组织内标识'

,FCREATORID int default null  comment '创始人标识'

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

,FSTATE int default 0  comment '任务状态标识'

,FREMARK nvarchar(50) default null  comment '备注'

,FACCESSDATE datetime default null  comment '最后访问日期'

,TIMES int default 0  comment '尝试次数'

,FMODIFIERID int default null  comment '最后访问修改人标识'

,FREFIDS nvarchar(255) default null  comment '相关标识集'

,FDESCRIPTION nvarchar(100) not null  comment '说明'

,FDATA image default null  comment '操作数据'

,primary key (FID)

) comment = 'plm异步任务'

--查询--

select FID as "fid",FMasterID as "fmasterid",FCREATORID as "fcreatorid",FCREATEDATE as "fcreatedate",FSTATE as "fstate",FREMARK as "fremark",FACCESSDATE as "faccessdate",TIMES as "times",FMODIFIERID as "fmodifierid",FREFIDS as "frefids",FDESCRIPTION as "fdescription",FDATA as "fdata" from T_PLM_CFG_ASYNC_TASK

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

select FID as "标识",FMasterID as "组织内标识",FCREATORID as "创始人标识",FCREATEDATE as "创建日期",FSTATE as "任务状态标识",FREMARK as "备注",FACCESSDATE as "最后访问日期",TIMES as "尝试次数",FMODIFIERID as "最后访问修改人标识",FREFIDS as "相关标识集",FDESCRIPTION as "说明",FDATA as "操作数据" from T_PLM_CFG_ASYNC_TASK

--INSERT脚本--

insert into T_PLM_CFG_ASYNC_TASK(FID,FMasterID,FCREATORID,FCREATEDATE,FSTATE,FREMARK,FACCESSDATE,TIMES,FMODIFIERID,FREFIDS,FDESCRIPTION,FDATA) values (?,?,?,?,?,?,?,?,?,?,?,?)

--UPDATE脚本--

update T_PLM_CFG_ASYNC_TASK set FID=?,FMasterID=?,FCREATORID=?,FCREATEDATE=?,FSTATE=?,FREMARK=?,FACCESSDATE=?,TIMES=?,FMODIFIERID=?,FREFIDS=?,FDESCRIPTION=?,FDATA=? where FID=?

--delete脚本--

delete from T_PLM_CFG_ASYNC_TASK where FID=?

--给字段加备注--

alter table T_PLM_CFG_ASYNC_TASK comment 'plm异步任务';

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

alter table T_PLM_CFG_ASYNC_TASK modify column FMasterID bigint default null  comment '组织内标识';

alter table T_PLM_CFG_ASYNC_TASK modify column FCREATORID int default null  comment '创始人标识';

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

alter table T_PLM_CFG_ASYNC_TASK modify column FSTATE int default 0  comment '任务状态标识';

alter table T_PLM_CFG_ASYNC_TASK modify column FREMARK nvarchar(50) default null  comment '备注';

alter table T_PLM_CFG_ASYNC_TASK modify column FACCESSDATE datetime default null  comment '最后访问日期';

alter table T_PLM_CFG_ASYNC_TASK modify column TIMES int default 0  comment '尝试次数';

alter table T_PLM_CFG_ASYNC_TASK modify column FMODIFIERID int default null  comment '最后访问修改人标识';

alter table T_PLM_CFG_ASYNC_TASK modify column FREFIDS nvarchar(255) default null  comment '相关标识集';

alter table T_PLM_CFG_ASYNC_TASK modify column FDESCRIPTION nvarchar(100) not null  comment '说明';

alter table T_PLM_CFG_ASYNC_TASK modify column FDATA image default null  comment '操作数据';