--建表脚本--

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 default null  comment '用户内码'

,ForgId int default null  comment '企业内码'

,Role nvarchar(255) default null  comment '角色'

,FStartTime datetime default null  comment '服务开始时间'

,FEndTime datetime default null  comment '服务结束时间'

,FID int default null  comment '其他表内码'

,primary key (FHistoryid)

) comment = '企业服务历史'

--查询--

select FHistoryid as "fhistoryid",FUserId as "fuserid",ForgId as "forgid",Role as "role",FStartTime as "fstarttime",FEndTime as "fendtime",FID as "fid" from T_CDP_HistoryCompany

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

select FHistoryid as "内码",FUserId as "用户内码",ForgId as "企业内码",Role as "角色",FStartTime as "服务开始时间",FEndTime as "服务结束时间",FID as "其他表内码" from T_CDP_HistoryCompany

--INSERT脚本--

insert into T_CDP_HistoryCompany(FHistoryid,FUserId,ForgId,Role,FStartTime,FEndTime,FID) values (?,?,?,?,?,?,?)

--UPDATE脚本--

update T_CDP_HistoryCompany set FHistoryid=?,FUserId=?,ForgId=?,Role=?,FStartTime=?,FEndTime=?,FID=? where FHistoryid=?

--delete脚本--

delete from T_CDP_HistoryCompany where FHistoryid=?

--给字段加备注--

alter table T_CDP_HistoryCompany comment '企业服务历史';

alter table T_CDP_HistoryCompany modify column FHistoryid int not null  comment '内码';

alter table T_CDP_HistoryCompany modify column FUserId int default null  comment '用户内码';

alter table T_CDP_HistoryCompany modify column ForgId int default null  comment '企业内码';

alter table T_CDP_HistoryCompany modify column Role nvarchar(255) default null  comment '角色';

alter table T_CDP_HistoryCompany modify column FStartTime datetime default null  comment '服务开始时间';

alter table T_CDP_HistoryCompany modify column FEndTime datetime default null  comment '服务结束时间';

alter table T_CDP_HistoryCompany modify column FID int default null  comment '其他表内码';

--建表脚本--

create table T_CDP_HistoryInptData(

FID int not null  comment '内码'

,FUSERFILE nvarchar(50) default null  comment '用户文件'

,FCOMPANYFILE nvarchar(50) default null  comment '公司文件'

,FQUALIFICATIONFILE nvarchar(50) default null  comment '个人认证文件'

,FCERTIFICATIONFILE nvarchar(50) default null  comment '企业认证文件'

,FOUTPUTPATH nvarchar(50) default null  comment '输出目录'

,FMINNO nvarchar(50) default null  comment '产生的最小编码'

,FINPUTUSERID int default null  comment '数据导入人'

,FINPUTDATE datetime default null  comment '导入日期'

,FRESULT nvarchar(50) default null  comment '导入结果'

,primary key (FID)

) comment = '导入数据'

--查询--

select FID as "fid",FUSERFILE as "fuserfile",FCOMPANYFILE as "fcompanyfile",FQUALIFICATIONFILE as "fqualificationfile",FCERTIFICATIONFILE as "fcertificationfile",FOUTPUTPATH as "foutputpath",FMINNO as "fminno",FINPUTUSERID as "finputuserid",FINPUTDATE as "finputdate",FRESULT as "fresult" from T_CDP_HistoryInptData

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

select FID as "内码",FUSERFILE as "用户文件",FCOMPANYFILE as "公司文件",FQUALIFICATIONFILE as "个人认证文件",FCERTIFICATIONFILE as "企业认证文件",FOUTPUTPATH as "输出目录",FMINNO as "产生的最小编码",FINPUTUSERID as "数据导入人",FINPUTDATE as "导入日期",FRESULT as "导入结果" from T_CDP_HistoryInptData

--INSERT脚本--

insert into T_CDP_HistoryInptData(FID,FUSERFILE,FCOMPANYFILE,FQUALIFICATIONFILE,FCERTIFICATIONFILE,FOUTPUTPATH,FMINNO,FINPUTUSERID,FINPUTDATE,FRESULT) values (?,?,?,?,?,?,?,?,?,?)

--UPDATE脚本--

update T_CDP_HistoryInptData set FID=?,FUSERFILE=?,FCOMPANYFILE=?,FQUALIFICATIONFILE=?,FCERTIFICATIONFILE=?,FOUTPUTPATH=?,FMINNO=?,FINPUTUSERID=?,FINPUTDATE=?,FRESULT=? where FID=?

--delete脚本--

delete from T_CDP_HistoryInptData where FID=?

--给字段加备注--

alter table T_CDP_HistoryInptData comment '导入数据';

alter table T_CDP_HistoryInptData modify column FID int not null  comment '内码';

alter table T_CDP_HistoryInptData modify column FUSERFILE nvarchar(50) default null  comment '用户文件';

alter table T_CDP_HistoryInptData modify column FCOMPANYFILE nvarchar(50) default null  comment '公司文件';

alter table T_CDP_HistoryInptData modify column FQUALIFICATIONFILE nvarchar(50) default null  comment '个人认证文件';

alter table T_CDP_HistoryInptData modify column FCERTIFICATIONFILE nvarchar(50) default null  comment '企业认证文件';

alter table T_CDP_HistoryInptData modify column FOUTPUTPATH nvarchar(50) default null  comment '输出目录';

alter table T_CDP_HistoryInptData modify column FMINNO nvarchar(50) default null  comment '产生的最小编码';

alter table T_CDP_HistoryInptData modify column FINPUTUSERID int default null  comment '数据导入人';

alter table T_CDP_HistoryInptData modify column FINPUTDATE datetime default null  comment '导入日期';

alter table T_CDP_HistoryInptData modify column FRESULT nvarchar(50) default null  comment '导入结果';