PLM相关基础开发-集合

--建表脚本--

create table T_PLM_CFG_PDMTYPE(

FID int not null  comment '主键'

,FMasterID int not null  comment '组织id'

,FNAME nvarchar(50) default null  comment '名称'

,FICON image default null  comment '图标'

,FFORMID nvarchar(50) default null  comment '单据id'

,primary key (FID)

) comment = '标准类型'

--查询--

select FID as "fid",FMasterID as "fmasterid",FNAME as "fname",FICON as "ficon",FFORMID as "fformid" from T_PLM_CFG_PDMTYPE

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

select FID as "主键",FMasterID as "组织id",FNAME as "名称",FICON as "图标",FFORMID as "单据id" from T_PLM_CFG_PDMTYPE

--INSERT脚本--

insert into T_PLM_CFG_PDMTYPE(FID,FMasterID,FNAME,FICON,FFORMID) values (?,?,?,?,?)

--UPDATE脚本--

update T_PLM_CFG_PDMTYPE set FID=?,FMasterID=?,FNAME=?,FICON=?,FFORMID=? where FID=?

--delete脚本--

delete from T_PLM_CFG_PDMTYPE where FID=?

--给字段加备注--

alter table T_PLM_CFG_PDMTYPE comment '标准类型';

alter table T_PLM_CFG_PDMTYPE modify column FID int not null  comment '主键';

alter table T_PLM_CFG_PDMTYPE modify column FMasterID int not null  comment '组织id';

alter table T_PLM_CFG_PDMTYPE modify column FNAME nvarchar(50) default null  comment '名称';

alter table T_PLM_CFG_PDMTYPE modify column FICON image default null  comment '图标';

alter table T_PLM_CFG_PDMTYPE modify column FFORMID nvarchar(50) default null  comment '单据id';

--建表脚本--

create table T_PLM_CFG_PDMVER_HISTORY(

FID bigint not null  comment '主键'

,FMasterID bigint not null  comment '组织中标识'

,FBASEVEROBJECT bigint not null  comment '版本历史对象'

,FCREATORID int not null  comment '创建者'

,FCREATEDATE datetime default null  comment '创建时间'

,FVERNO nvarchar(50) default null  comment '版本号'

,FOPERATIONTYPE nvarchar(50) default null  comment '操作类型'

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

,FOBJECTID int not null  comment '对象id'

,primary key (FID)

) comment = '版本历史列表'

--查询--

select FID as "fid",FMasterID as "fmasterid",FBASEVEROBJECT as "fbaseverobject",FCREATORID as "fcreatorid",FCREATEDATE as "fcreatedate",FVERNO as "fverno",FOPERATIONTYPE as "foperationtype",FREMARK as "fremark",FOBJECTID as "fobjectid" from T_PLM_CFG_PDMVER_HISTORY

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

select FID as "主键",FMasterID as "组织中标识",FBASEVEROBJECT as "版本历史对象",FCREATORID as "创建者",FCREATEDATE as "创建时间",FVERNO as "版本号",FOPERATIONTYPE as "操作类型",FREMARK as "备注",FOBJECTID as "对象id" from T_PLM_CFG_PDMVER_HISTORY

--INSERT脚本--

insert into T_PLM_CFG_PDMVER_HISTORY(FID,FMasterID,FBASEVEROBJECT,FCREATORID,FCREATEDATE,FVERNO,FOPERATIONTYPE,FREMARK,FOBJECTID) values (?,?,?,?,?,?,?,?,?)

--UPDATE脚本--

update T_PLM_CFG_PDMVER_HISTORY set FID=?,FMasterID=?,FBASEVEROBJECT=?,FCREATORID=?,FCREATEDATE=?,FVERNO=?,FOPERATIONTYPE=?,FREMARK=?,FOBJECTID=? where FID=?

--delete脚本--

delete from T_PLM_CFG_PDMVER_HISTORY where FID=?

--给字段加备注--

alter table T_PLM_CFG_PDMVER_HISTORY comment '版本历史列表';

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

alter table T_PLM_CFG_PDMVER_HISTORY modify column FMasterID bigint not null  comment '组织中标识';

alter table T_PLM_CFG_PDMVER_HISTORY modify column FBASEVEROBJECT bigint not null  comment '版本历史对象';

alter table T_PLM_CFG_PDMVER_HISTORY modify column FCREATORID int not null  comment '创建者';

alter table T_PLM_CFG_PDMVER_HISTORY modify column FCREATEDATE datetime default null  comment '创建时间';

alter table T_PLM_CFG_PDMVER_HISTORY modify column FVERNO nvarchar(50) default null  comment '版本号';

alter table T_PLM_CFG_PDMVER_HISTORY modify column FOPERATIONTYPE nvarchar(50) default null  comment '操作类型';

alter table T_PLM_CFG_PDMVER_HISTORY modify column FREMARK nvarchar(255) default null  comment '备注';

alter table T_PLM_CFG_PDMVER_HISTORY modify column FOBJECTID int not null  comment '对象id';

--建表脚本--

create table T_PLM_CFG_PERSONSETTING(

FID bigint not null  comment '主键'

,FMasterID bigint not null  comment '组织id'

,FUSERID int not null  comment '用户id'

,FWORKPATH nvarchar(255) default null  comment '个人工作路径'

,FACCESSTYPE varchar(1) default null  comment '电子仓访问方式'

,FSIGNIMAGE image default null  comment '签字图片'

,FKCSPORT int default 0  comment '客户端服务端口'

,FKCSLOGUSER nvarchar(50) default ' '  comment '客户端登录用户'

,primary key (FID)

) comment = '个人设置'

--查询--

select FID as "fid",FMasterID as "fmasterid",FUSERID as "fuserid",FWORKPATH as "fworkpath",FACCESSTYPE as "faccesstype",FSIGNIMAGE as "fsignimage",FKCSPORT as "fkcsport",FKCSLOGUSER as "fkcsloguser" from T_PLM_CFG_PERSONSETTING

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

select FID as "主键",FMasterID as "组织id",FUSERID as "用户id",FWORKPATH as "个人工作路径",FACCESSTYPE as "电子仓访问方式",FSIGNIMAGE as "签字图片",FKCSPORT as "客户端服务端口",FKCSLOGUSER as "客户端登录用户" from T_PLM_CFG_PERSONSETTING

--INSERT脚本--

insert into T_PLM_CFG_PERSONSETTING(FID,FMasterID,FUSERID,FWORKPATH,FACCESSTYPE,FSIGNIMAGE,FKCSPORT,FKCSLOGUSER) values (?,?,?,?,?,?,?,?)

--UPDATE脚本--

update T_PLM_CFG_PERSONSETTING set FID=?,FMasterID=?,FUSERID=?,FWORKPATH=?,FACCESSTYPE=?,FSIGNIMAGE=?,FKCSPORT=?,FKCSLOGUSER=? where FID=?

--delete脚本--

delete from T_PLM_CFG_PERSONSETTING where FID=?

--给字段加备注--

alter table T_PLM_CFG_PERSONSETTING comment '个人设置';

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

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

alter table T_PLM_CFG_PERSONSETTING modify column FUSERID int not null  comment '用户id';

alter table T_PLM_CFG_PERSONSETTING modify column FWORKPATH nvarchar(255) default null  comment '个人工作路径';

alter table T_PLM_CFG_PERSONSETTING modify column FACCESSTYPE varchar(1) default null  comment '电子仓访问方式';

alter table T_PLM_CFG_PERSONSETTING modify column FSIGNIMAGE image default null  comment '签字图片';

alter table T_PLM_CFG_PERSONSETTING modify column FKCSPORT int default 0  comment '客户端服务端口';

alter table T_PLM_CFG_PERSONSETTING modify column FKCSLOGUSER nvarchar(50) default ' '  comment '客户端登录用户';

--建表脚本--

create table T_PLM_CFG_PRESONALCACHE(

FID bigint not null  comment 'FID'

,FMasterID bigint not null  comment 'FMasterID'

,FCATEGORYID bigint not null  comment 'FCATEGORYID'

,FOBJECTID bigint not null  comment 'FOBJECTID'

,FCREATORID int not null  comment 'FCREATORID'

,FSTATUS int not null  comment 'FSTATUS'

,FVALUE xml default null  comment 'FVALUE'

,FCREATEDATE datetime default null  comment 'FCREATEDATE'

,FMODIFYDATE datetime default null  comment 'FMODIFYDATE'

,primary key (FID)

) comment = 'T_PLM_CFG_PRESONAL...'

--查询--

select FID as "fid",FMasterID as "fmasterid",FCATEGORYID as "fcategoryid",FOBJECTID as "fobjectid",FCREATORID as "fcreatorid",FSTATUS as "fstatus",FVALUE as "fvalue",FCREATEDATE as "fcreatedate",FMODIFYDATE as "fmodifydate" from T_PLM_CFG_PRESONALCACHE

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

select FID as "FID",FMasterID as "FMasterID",FCATEGORYID as "FCATEGORYID",FOBJECTID as "FOBJECTID",FCREATORID as "FCREATORID",FSTATUS as "FSTATUS",FVALUE as "FVALUE",FCREATEDATE as "FCREATEDATE",FMODIFYDATE as "FMODIFYDATE" from T_PLM_CFG_PRESONALCACHE

--INSERT脚本--

insert into T_PLM_CFG_PRESONALCACHE(FID,FMasterID,FCATEGORYID,FOBJECTID,FCREATORID,FSTATUS,FVALUE,FCREATEDATE,FMODIFYDATE) values (?,?,?,?,?,?,?,?,?)

--UPDATE脚本--

update T_PLM_CFG_PRESONALCACHE set FID=?,FMasterID=?,FCATEGORYID=?,FOBJECTID=?,FCREATORID=?,FSTATUS=?,FVALUE=?,FCREATEDATE=?,FMODIFYDATE=? where FID=?

--delete脚本--

delete from T_PLM_CFG_PRESONALCACHE where FID=?

--给字段加备注--

alter table T_PLM_CFG_PRESONALCACHE comment 'T_PLM_CFG_PRESONAL...';

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

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

alter table T_PLM_CFG_PRESONALCACHE modify column FCATEGORYID bigint not null  comment 'FCATEGORYID';

alter table T_PLM_CFG_PRESONALCACHE modify column FOBJECTID bigint not null  comment 'FOBJECTID';

alter table T_PLM_CFG_PRESONALCACHE modify column FCREATORID int not null  comment 'FCREATORID';

alter table T_PLM_CFG_PRESONALCACHE modify column FSTATUS int not null  comment 'FSTATUS';

alter table T_PLM_CFG_PRESONALCACHE modify column FVALUE xml default null  comment 'FVALUE';

alter table T_PLM_CFG_PRESONALCACHE modify column FCREATEDATE datetime default null  comment 'FCREATEDATE';

alter table T_PLM_CFG_PRESONALCACHE modify column FMODIFYDATE datetime default null  comment 'FMODIFYDATE';

--建表脚本--

create table T_PLM_CFG_PROPERTYEFIELD(

FID bigint not null  comment '主键'

,FMasterID bigint not null  comment '组织id'

,FPROPERTYID nvarchar(50) default null  comment '属性项id'

,FPROPERTYNAME nvarchar(50) default null  comment '属性项名称'

,FMETAFIELDNAME nvarchar(50) default null  comment '参数项名称'

,FMETAFIELDID nvarchar(50) default null  comment '参数项id'

,FCONNECT nvarchar(50) default null  comment '连接符'

,FCATEGORYID nvarchar(50) default null  comment '业务类型'

,FSN int not null  comment '顺序号'

,FVALUEFIELD nvarchar(50) not null  comment '来源属性'

,FUSESPACE char(1) not null  comment '记录是否启用空格'

,primary key (FID)

) comment = '属性项设置'

--查询--

select FID as "fid",FMasterID as "fmasterid",FPROPERTYID as "fpropertyid",FPROPERTYNAME as "fpropertyname",FMETAFIELDNAME as "fmetafieldname",FMETAFIELDID as "fmetafieldid",FCONNECT as "fconnect",FCATEGORYID as "fcategoryid",FSN as "fsn",FVALUEFIELD as "fvaluefield",FUSESPACE as "fusespace" from T_PLM_CFG_PROPERTYEFIELD

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

select FID as "主键",FMasterID as "组织id",FPROPERTYID as "属性项id",FPROPERTYNAME as "属性项名称",FMETAFIELDNAME as "参数项名称",FMETAFIELDID as "参数项id",FCONNECT as "连接符",FCATEGORYID as "业务类型",FSN as "顺序号",FVALUEFIELD as "来源属性",FUSESPACE as "记录是否启用空格" from T_PLM_CFG_PROPERTYEFIELD

--INSERT脚本--

insert into T_PLM_CFG_PROPERTYEF