PLM开发字段集合II

--建表脚本--

create table T_PLM_CFG_CATEGORYINTEGRITY(

FEntryID bigint not null  comment '分录标识'

,FID bigint not null  comment '主键'

,FSeq int not null  comment '序号'

,FBASEINTEGRITY bigint not null  comment '完整性规则编码'

,primary key (FEntryID)

) comment = '业务类型完整性校验'

--查询--

select FEntryID as "fentryid",FID as "fid",FSeq as "fseq",FBASEINTEGRITY as "fbaseintegrity" from T_PLM_CFG_CATEGORYINTEGRITY

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

select FEntryID as "分录标识",FID as "主键",FSeq as "序号",FBASEINTEGRITY as "完整性规则编码" from T_PLM_CFG_CATEGORYINTEGRITY

--INSERT脚本--

insert into T_PLM_CFG_CATEGORYINTEGRITY(FEntryID,FID,FSeq,FBASEINTEGRITY) values (?,?,?,?)

--UPDATE脚本--

update T_PLM_CFG_CATEGORYINTEGRITY set FEntryID=?,FID=?,FSeq=?,FBASEINTEGRITY=? where FEntryID=?

--delete脚本--

delete from T_PLM_CFG_CATEGORYINTEGRITY where FEntryID=?

--给字段加备注--

alter table T_PLM_CFG_CATEGORYINTEGRITY comment '业务类型完整性校验';

alter table T_PLM_CFG_CATEGORYINTEGRITY modify column FEntryID bigint not null  comment '分录标识';

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

alter table T_PLM_CFG_CATEGORYINTEGRITY modify column FSeq int not null  comment '序号';

alter table T_PLM_CFG_CATEGORYINTEGRITY modify column FBASEINTEGRITY bigint not null  comment '完整性规则编码';

--建表脚本--

create table T_PLM_CFG_CATEGORY_RELATION(

FID bigint not null  comment '主键'

,FMasterID bigint not null  comment '组织id'

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

,FPARENTCATEGORYID bigint not null  comment '主业务类型'

,FCHILDCATEGORYID bigint not null  comment '子业务类型'

,primary key (FID)

) comment = '业务类型关系'

--查询--

select FID as "fid",FMasterID as "fmasterid",FCATEGORYID as "fcategoryid",FPARENTCATEGORYID as "fparentcategoryid",FCHILDCATEGORYID as "fchildcategoryid" from T_PLM_CFG_CATEGORY_RELATION

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

select FID as "主键",FMasterID as "组织id",FCATEGORYID as "业务类型",FPARENTCATEGORYID as "主业务类型",FCHILDCATEGORYID as "子业务类型" from T_PLM_CFG_CATEGORY_RELATION

--INSERT脚本--

insert into T_PLM_CFG_CATEGORY_RELATION(FID,FMasterID,FCATEGORYID,FPARENTCATEGORYID,FCHILDCATEGORYID) values (?,?,?,?,?)

--UPDATE脚本--

update T_PLM_CFG_CATEGORY_RELATION set FID=?,FMasterID=?,FCATEGORYID=?,FPARENTCATEGORYID=?,FCHILDCATEGORYID=? where FID=?

--delete脚本--

delete from T_PLM_CFG_CATEGORY_RELATION where FID=?

--给字段加备注--

alter table T_PLM_CFG_CATEGORY_RELATION comment '业务类型关系';

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

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

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

alter table T_PLM_CFG_CATEGORY_RELATION modify column FPARENTCATEGORYID bigint not null  comment '主业务类型';

alter table T_PLM_CFG_CATEGORY_RELATION modify column FCHILDCATEGORYID bigint not null  comment '子业务类型';

--建表脚本--

create table T_PLM_CFG_CATEG_PREM_REF(

FID bigint not null  comment '主键'

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

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

,FPERMISSIONID nvarchar(50) default null  comment '权限对象id'

,FDESCRIPTION nvarchar(200) default null  comment '描述'

,FCHANGEFLAG int not null  comment '修改标识'

,primary key (FID)

) comment = '业务类型权限映射'

--查询--

select FID as "fid",FMasterID as "fmasterid",FCATEGORYID as "fcategoryid",FPERMISSIONID as "fpermissionid",FDESCRIPTION as "fdescription",FCHANGEFLAG as "fchangeflag" from T_PLM_CFG_CATEG_PREM_REF

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

select FID as "主键",FMasterID as "组织中标识",FCATEGORYID as "业务类型标识",FPERMISSIONID as "权限对象id",FDESCRIPTION as "描述",FCHANGEFLAG as "修改标识" from T_PLM_CFG_CATEG_PREM_REF

--INSERT脚本--

insert into T_PLM_CFG_CATEG_PREM_REF(FID,FMasterID,FCATEGORYID,FPERMISSIONID,FDESCRIPTION,FCHANGEFLAG) values (?,?,?,?,?,?)

--UPDATE脚本--

update T_PLM_CFG_CATEG_PREM_REF set FID=?,FMasterID=?,FCATEGORYID=?,FPERMISSIONID=?,FDESCRIPTION=?,FCHANGEFLAG=? where FID=?

--delete脚本--

delete from T_PLM_CFG_CATEG_PREM_REF where FID=?

--给字段加备注--

alter table T_PLM_CFG_CATEG_PREM_REF comment '业务类型权限映射';

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

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

alter table T_PLM_CFG_CATEG_PREM_REF modify column FCATEGORYID nvarchar(50) default null  comment '业务类型标识';

alter table T_PLM_CFG_CATEG_PREM_REF modify column FPERMISSIONID nvarchar(50) default null  comment '权限对象id';

alter table T_PLM_CFG_CATEG_PREM_REF modify column FDESCRIPTION nvarchar(200) default null  comment '描述';

alter table T_PLM_CFG_CATEG_PREM_REF modify column FCHANGEFLAG int not null  comment '修改标识';

--建表脚本--

create table T_PLM_CFG_CHECK_REC(

FID bigint not null  comment '主键'

,FMasterID bigint not null  comment '组织主键'

,FOBJECTID nvarchar(50) default null  comment '资源库对象'

,FUSERID int not null  comment '用户'

,FSTATUS int not null  comment '状态'

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

,FENDTIME datetime default null  comment '结束时间'

,primary key (FID)

) comment = '检入检出操作记录'

--查询--

select FID as "fid",FMasterID as "fmasterid",FOBJECTID as "fobjectid",FUSERID as "fuserid",FSTATUS as "fstatus",FCREATETIME as "fcreatetime",FENDTIME as "fendtime" from T_PLM_CFG_CHECK_REC

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

select FID as "主键",FMasterID as "组织主键",FOBJECTID as "资源库对象",FUSERID as "用户",FSTATUS as "状态",FCREATETIME as "创建时间",FENDTIME as "结束时间" from T_PLM_CFG_CHECK_REC

--INSERT脚本--

insert into T_PLM_CFG_CHECK_REC(FID,FMasterID,FOBJECTID,FUSERID,FSTATUS,FCREATETIME,FENDTIME) values (?,?,?,?,?,?,?)

--UPDATE脚本--

update T_PLM_CFG_CHECK_REC set FID=?,FMasterID=?,FOBJECTID=?,FUSERID=?,FSTATUS=?,FCREATETIME=?,FENDTIME=? where FID=?

--delete脚本--

delete from T_PLM_CFG_CHECK_REC where FID=?

--给字段加备注--

alter table T_PLM_CFG_CHECK_REC comment '检入检出操作记录';

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

alter table T_PLM_CFG_CHECK_REC modify column FMasterID bigint not null  comment '组织主键';

alter table T_PLM_CFG_CHECK_REC modify column FOBJECTID nvarchar(50) default null  comment '资源库对象';

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

alter table T_PLM_CFG_CHECK_REC modify column FSTATUS int not null  comment '状态';

alter table T_PLM_CFG_CHECK_REC modify column FCREATETIME datetime default null  comment '创建时间';

alter table T_PLM_CFG_CHECK_REC modify column FENDTIME datetime default null  comment '结束时间';