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=?,FPERMI