--建表脚本--
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_PROPERTYEFIELD(FID,FMasterID,FPROPERTYID,FPROPERTYNAME,FMETAFIELDNAME,FMETAFIELDID,FCONNECT,FCATEGORYID,FSN,FVALUEFIELD,FUSESPACE) values (?,?,?,?,?,?,?,?,?,?,?)
--UPDATE脚本--
update T_PLM_CFG_PROPERTYEFIELD set FID=?,FMasterID=?,FPROPERTYID=?,FPROPERTYNAME=?,FMETAFIELDNAME=?,FMETAFIELDID=?,FCONNECT=?,FCATEGORYID=?,FSN=?,FVALUEFIELD=?,FUSESPACE=? where FID=?
--delete脚本--
delete from T_PLM_CFG_PROPERTYEFIELD where FID=?
--给字段加备注--
alter table T_PLM_CFG_PROPERTYEFIELD comment '属性项设置';
alter table T_PLM_CFG_PROPERTYEFIELD modify column FID bigint not null comment '主键';
alter table T_PLM_CFG_PROPERTYEFIELD modify column FMasterID bigint not null comment '组织id';
alter table T_PLM_CFG_PROPERTYEFIELD modify column FPROPERTYID nvarchar(50) default null comment '属性项id';
alter table T_PLM_CFG_PROPERTYEFIELD modify column FPROPERTYNAME nvarchar(50) default null comment '属性项名称';
alter table T_PLM_CFG_PROPERTYEFIELD modify column FMETAFIELDNAME nvarchar(50) default null comment '参数项名称';
alter table T_PLM_CFG_PROPERTYEFIELD modify column FMETAFIELDID nvarchar(50) default null comment '参数项id';
alter table T_PLM_CFG_PROPERTYEFIELD modify column FCONNECT nvarchar(50) default null comment '连接符';
alter table T_PLM_CFG_PROPERTYEFIELD modify column FCATEGORYID nvarchar(50) default null comment '业务类型';
alter table T_PLM_CFG_PROPERTYEFIELD modify column FSN int not null comment '顺序号';
alter table T_PLM_CFG_PROPERTYEFIELD modify column FVALUEFIELD nvarchar(50) not null comment '来源属性';
alter table T_PLM_CFG_PROPERTYEFIELD modify column FUSESPACE char(1) not null comment '记录是否启用空格';
--建表脚本--
create table T_PLM_CFG_RELATEDOBJECT(
FEntryID bigint not null comment '从表主键'
,FID bigint not null comment '主键'
,FRELATEDOBJECT bigint not null comment '相关对象id'
,FDATATYPE int not null comment '数据标识'
,FCheckBox char(1) not null comment 'FCheckBox'
,FRELATIONTYPE int not null comment '关联类型'
,FOPERTYPE char(1) not null comment '操作类型'
,FISSRCPDM char(1) not null comment '源对象是否pdm类型'
,FISTARGETPDM char(1) not null comment '目标对象是否pdm类型'
,primary key (FEntryID)
) comment = '相关对象'
--查询--
select FEntryID as "fentryid",FID as "fid",FRELATEDOBJECT as "frelatedobject",FDATATYPE as "fdatatype",FCheckBox as "fcheckbox",FRELATIONTYPE as "frelationtype",FOPERTYPE as "fopertype",FISSRCPDM as "fissrcpdm",FISTARGETPDM as "fistargetpdm" from T_PLM_CFG_RELATEDOBJECT
--查询(中文字段)--
select FEntryID as "从表主键",FID as "主键",FRELATEDOBJECT as "相关对象id",FDATATYPE as "数据标识",FCheckBox as "FCheckBox",FRELATIONTYPE as "关联类型",FOPERTYPE as "操作类型",FISSRCPDM as "源对象是否pdm类型",FISTARGETPDM as "目标对象是否pdm类型" from T_PLM_CFG_RELATEDOBJECT
--INSERT脚本--
insert into T_PLM_CFG_RELATEDOBJECT(FEntryID,FID,FRELATEDOBJECT,FDATATYPE,FCheckBox,FRELATIONTYPE,FOPERTYPE,FISSRCPDM,FISTARGETPDM) values (?,?,?,?,?,?,?,?,?)
--UPDATE脚本--
update T_PLM_CFG_RELATEDOBJECT set FEntryID=?,FID=?,FRELATEDOBJECT=?,FDATATYPE=?,FCheckBox=?,FRELATIONTYPE=?,FOPERTYPE=?,FISSRCPDM=?,FISTARGETPDM=? where FEntryID=?
--delete脚本--
delete from T_PLM_CFG_RELATEDOBJECT where FEntryID=?
--给字段加备注--
alter table T_PLM_CFG_RELATEDOBJECT comment '相关对象';
alter table T_PLM_CFG_RELATEDOBJECT modify column FEntryID bigint not null comment '从表主键';
alter table T_PLM_CFG_RELATEDOBJECT modify column FID bigint not null comment '主键';
alter table T_PLM_CFG_RELATEDOBJECT modify column FRELATEDOBJECT bigint not null comment '相关对象id';
alter table T_PLM_CFG_RELATEDOBJECT modify column FDATATYPE int not null comment '数据标识';
alter table T_PLM_CFG_RELATEDOBJECT modify column FCheckBox char(1) not null comment 'FCheckBox';
alter table T_PLM_CFG_RELATEDOBJECT modify column FRELATIONTYPE int not null comment '关联类型';
alter table T_PLM_CFG_RELATEDOBJECT modify column FOPERTYPE char(1) not null comment '操作类型';
alter table T_PLM_CFG_RELATEDOBJECT modify column FISSRCPDM char(1) not null comment '源对象是否pdm类型';
alter table T_PLM_CFG_RELATEDOBJECT modify column FISTARGETPDM char(1) not null comment '目标对象是否pdm类型';
--建表脚本--
create table T_PLM_CFG_RELATEDOBJECT_VER(
FEntryID bigint not null comment '分录主键'
,FID bigint not null comment '主键'
,FTARGETOBJECTID bigint not null comment '关联对象标识'
,FSUMMARY nvarchar(50) default null comment '关联说明'
,FSOURCEID bigint not null comment '主引用对象标识'
,FOBJECTRELATIONTYPE int not null comment 'FOBJECTRELATIONTYPE'
,FISSRCPDM char(1) not null comment '源对象是否pdm类型'
,FISTARGETPDM char(1) not null comment '目标对象是否pdm类型'
,primary key (FEntryID)
) comment = '相关对象操作列表分录记录'
--查询--
select FEntryID as "fentryid",FID as "fid",FTARGETOBJECTID as "ftargetobjectid",FSUMMARY as "fsummary",FSOURCEID as "fsourceid",FOBJECTRELATIONTYPE as "fobjectrelationtype",FISSRCPDM as "fissrcpdm",FISTARGETPDM as "fistargetpdm" from T_PLM_CFG_RELATEDOBJECT_VER
--查询(中文字段)--
select FEntryID as "分录主键",FID as "主键",FTARGETOBJECTID as "关联对象标识",FSUMMARY as "关联说明",FSOURCEID as "主引用对象标识",FOBJECTRELATIONTYPE as "FOBJECTRELATIONTYPE",FISSRCPDM as "源对象是否pdm类型",FISTARGETPDM as "目标对象是否pdm类型" from T_PLM_CFG_RELATEDOBJECT_VER
--INSERT脚本--
insert into T_PLM_CFG_RELATEDOBJECT_VER(FEntryID,FID,FTARGETOBJECTID,FSUMMARY,FSOURCEID,FOBJECTRELATIONTYPE,FISSRCPDM,FISTARGETPDM) values (?,?,?,?,?,?,?,?)
--UPDATE脚本--
update T_PLM_CFG_RELATEDOBJECT_VER set FEntryID=?,FID=?,FTARGETOBJECTID=?,FSUMMARY=?,FSOURCEID=?,FOBJECTRELATIONTYPE=?,FISSRCPDM=?,FISTARGETPDM=? where FEntryID=?
--delete脚本--
delete from T_PLM_CFG_RELATEDOBJECT_VER where FEntryID=?
--给字段加备注--
alter table T_PLM_CFG_RELATEDOBJECT_VER comment '相关对象操作列表分录记录';
alter table T_PLM_CFG_RELATEDOBJECT_VER modify column FEntryID bigint not null comment '分录主键';
alter table T_PLM_CFG_RELATEDOBJECT_VER modify column FID bigint not null comment '主键';
alter table T_PLM_CFG_RELATEDOBJECT_VER modify column FTARGETOBJECTID bigint not null comment '关联对象标识';
alter table T_PLM_CFG_RELATEDOBJECT_VER modify column FSUMMARY nvarchar(50) default null comment '关联说明';
alter table T_PLM_CFG_RELATEDOBJECT_VER modify column FSOURCEID bigint not null comment '主引用对象标识';
alter table T_PLM_CFG_RELATEDOBJECT_VER modify column FOBJECTRELATIONTYPE int not null comment 'FOBJECTRELATIONTYPE';
alter table T_PLM_CFG_RELATEDOBJECT_VER modify column FISSRCPDM char(1) not null comment '源对象是否pdm类型';
alter table T_PLM_CFG_RELATEDOBJECT_VER modify column FISTARGETPDM char(1) not null comment '目标对象是否pdm类型';
推荐阅读