CDP协同开发平台 / 企业管理 / 物理模型图（2）

--建表脚本--

create table T_CDP_HISTORYAUTHORIZE_M(

FDetailID int not null  comment '领域表内码'

,FEntryID int default null  comment '产品表内码'

,FMODULESELECTED char(1) default null  comment '是否选择该领域'

,FMODULE nvarchar(50) default null  comment '领域辅助资料内码'

,primary key (FDetailID)

) comment = '企业认证-领域'

--查询--

select FDetailID as "fdetailid",FEntryID as "fentryid",FMODULESELECTED as "fmoduleselected",FMODULE as "fmodule" from T_CDP_HISTORYAUTHORIZE_M

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

select FDetailID as "领域表内码",FEntryID as "产品表内码",FMODULESELECTED as "是否选择该领域",FMODULE as "领域辅助资料内码" from T_CDP_HISTORYAUTHORIZE_M

--INSERT脚本--

insert into T_CDP_HISTORYAUTHORIZE_M(FDetailID,FEntryID,FMODULESELECTED,FMODULE) values (?,?,?,?)

--UPDATE脚本--

update T_CDP_HISTORYAUTHORIZE_M set FDetailID=?,FEntryID=?,FMODULESELECTED=?,FMODULE=? where FDetailID=?

--delete脚本--

delete from T_CDP_HISTORYAUTHORIZE_M where FDetailID=?

--给字段加备注--

alter table T_CDP_HISTORYAUTHORIZE_M comment '企业认证-领域';

alter table T_CDP_HISTORYAUTHORIZE_M modify column FDetailID int not null  comment '领域表内码';

alter table T_CDP_HISTORYAUTHORIZE_M modify column FEntryID int default null  comment '产品表内码';

alter table T_CDP_HISTORYAUTHORIZE_M modify column FMODULESELECTED char(1) default null  comment '是否选择该领域';

alter table T_CDP_HISTORYAUTHORIZE_M modify column FMODULE nvarchar(50) default null  comment '领域辅助资料内码';

--建表脚本--

create table T_CDP_HISTORYAUTHORIZE_P(

FEntryID int not null  comment '产品表内码'

,FID int default null  comment '企业认证内码'

,FPRODUCTTYPE nvarchar(50) default null  comment '产品辅助资料内码'

,FPROJECTNUMBER int default null  comment '从事产品人数'

,FISSELECTED char(1) default null  comment '是否申请该产品认证'

,primary key (FEntryID)

) comment = '企业认证-产品类型'

--查询--

select FEntryID as "fentryid",FID as "fid",FPRODUCTTYPE as "fproducttype",FPROJECTNUMBER as "fprojectnumber",FISSELECTED as "fisselected" from T_CDP_HISTORYAUTHORIZE_P

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

select FEntryID as "产品表内码",FID as "企业认证内码",FPRODUCTTYPE as "产品辅助资料内码",FPROJECTNUMBER as "从事产品人数",FISSELECTED as "是否申请该产品认证" from T_CDP_HISTORYAUTHORIZE_P

--INSERT脚本--

insert into T_CDP_HISTORYAUTHORIZE_P(FEntryID,FID,FPRODUCTTYPE,FPROJECTNUMBER,FISSELECTED) values (?,?,?,?,?)

--UPDATE脚本--

update T_CDP_HISTORYAUTHORIZE_P set FEntryID=?,FID=?,FPRODUCTTYPE=?,FPROJECTNUMBER=?,FISSELECTED=? where FEntryID=?

--delete脚本--

delete from T_CDP_HISTORYAUTHORIZE_P where FEntryID=?

--给字段加备注--

alter table T_CDP_HISTORYAUTHORIZE_P comment '企业认证-产品类型';

alter table T_CDP_HISTORYAUTHORIZE_P modify column FEntryID int not null  comment '产品表内码';

alter table T_CDP_HISTORYAUTHORIZE_P modify column FID int default null  comment '企业认证内码';

alter table T_CDP_HISTORYAUTHORIZE_P modify column FPRODUCTTYPE nvarchar(50) default null  comment '产品辅助资料内码';

alter table T_CDP_HISTORYAUTHORIZE_P modify column FPROJECTNUMBER int default null  comment '从事产品人数';

alter table T_CDP_HISTORYAUTHORIZE_P modify column FISSELECTED char(1) default null  comment '是否申请该产品认证';

--建表脚本--

create table T_CDP_HISTORYAUTHORIZE_R(

FEntryID int not null  comment '内码'

,FID int default null  comment '认证表内码'

,FRegionID int default null  comment '区域代码'

,primary key (FEntryID)

) comment = '企业授权范围-区域'

--查询--

select FEntryID as "fentryid",FID as "fid",FRegionID as "fregionid" from T_CDP_HISTORYAUTHORIZE_R

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

select FEntryID as "内码",FID as "认证表内码",FRegionID as "区域代码" from T_CDP_HISTORYAUTHORIZE_R

--INSERT脚本--

insert into T_CDP_HISTORYAUTHORIZE_R(FEntryID,FID,FRegionID) values (?,?,?)

--UPDATE脚本--

update T_CDP_HISTORYAUTHORIZE_R set FEntryID=?,FID=?,FRegionID=? where FEntryID=?

--delete脚本--

delete from T_CDP_HISTORYAUTHORIZE_R where FEntryID=?

--给字段加备注--

alter table T_CDP_HISTORYAUTHORIZE_R comment '企业授权范围-区域';

alter table T_CDP_HISTORYAUTHORIZE_R modify column FEntryID int not null  comment '内码';

alter table T_CDP_HISTORYAUTHORIZE_R modify column FID int default null  comment '认证表内码';

alter table T_CDP_HISTORYAUTHORIZE_R modify column FRegionID int default null  comment '区域代码';

--建表脚本--

create table T_CDP_HISTORYINVITE(

FId int not null  comment '内码'

,FApplicantId int default null  comment '被邀请人内码'

,FInviteTime datetime default null  comment '邀请日期'

,FCompany int default null  comment '邀请企业'

,FInviteRemark nvarchar(255) default null  comment '邀请说明'

,FInviterID int default null  comment '邀请人'

,FApproveTime datetime default null  comment '接受日期'

,FApproveRemark nvarchar(255) default null  comment '接受说明'

,FStatus nvarchar(50) default null  comment '状态'

,FInfoStatus nvarchar(50) default null  comment '信息状态'

,primary key (FId)

) comment = '企业邀请历史'

--查询--

select FId as "fid",FApplicantId as "fapplicantid",FInviteTime as "finvitetime",FCompany as "fcompany",FInviteRemark as "finviteremark",FInviterID as "finviterid",FApproveTime as "fapprovetime",FApproveRemark as "fapproveremark",FStatus as "fstatus",FInfoStatus as "finfostatus" from T_CDP_HISTORYINVITE

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

select FId as "内码",FApplicantId as "被邀请人内码",FInviteTime as "邀请日期",FCompany as "邀请企业",FInviteRemark as "邀请说明",FInviterID as "邀请人",FApproveTime as "接受日期",FApproveRemark as "接受说明",FStatus as "状态",FInfoStatus as "信息状态" from T_CDP_HISTORYINVITE

--INSERT脚本--

insert into T_CDP_HISTORYINVITE(FId,FApplicantId,FInviteTime,FCompany,FInviteRemark,FInviterID,FApproveTime,FApproveRemark,FStatus,FInfoStatus) values (?,?,?,?,?,?,?,?,?,?)

--UPDATE脚本--

update T_CDP_HISTORYINVITE set FId=?,FApplicantId=?,FInviteTime=?,FCompany=?,FInviteRemark=?,FInviterID=?,FApproveTime=?,FApproveRemark=?,FStatus=?,FInfoStatus=? where FId=?

--delete脚本--

delete from T_CDP_HISTORYINVITE where FId=?

--给字段加备注--

alter table T_CDP_HISTORYINVITE comment '企业邀请历史';

alter table T_CDP_HISTORYINVITE modify column FId int not null  comment '内码';

alter table T_CDP_HISTORYINVITE modify column FApplicantId int default null  comment '被邀请人内码';

alter table T_CDP_HISTORYINVITE modify column FInviteTime datetime default null  comment '邀请日期';

alter table T_CDP_HISTORYINVITE modify column FCompany int default null  comment '邀请企业';

alter table T_CDP_HISTORYINVITE modify column FInviteRemark nvarchar(255) default null  comment '邀请说明';

alter table T_CDP_HISTORYINVITE modify column FInviterID int default null  comment '邀请人';

alter table T_CDP_HISTORYINVITE modify column FApproveTime datetime default null  comment '接受日期';

alter table T_CDP_HISTORYINVITE modify column FApproveRemark nvarchar(255) default null  comment '接受说明';

alter table T_CDP_HISTORYINVITE modify column FStatus nvarchar(50) default null  comment '状态';

alter table T_CDP_HISTORYINVITE modify column FInfoStatus nvarchar(50) default null  comment '信息状态';

--建表脚本--

create table T_CDP_HistoryCompany(

FHistoryid int not null  comment '内码'

,FUserId int