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

--建表脚本--

create table T_CDP_DEVPROJECT(

FOrgId int not null  comment '项目内码'

,FPackageName nvarchar(50) default null  comment '构建包名称'

,FVersionMajor int default null  comment '构建包主版本'

,FVersionMinor int default null  comment '构建包子版本'

,FVMId nvarchar(50) default null  comment '开发虚拟机id'

,primary key (FOrgId)

) comment = '项目开发'

--查询--

select FOrgId as "forgid",FPackageName as "fpackagename",FVersionMajor as "fversionmajor",FVersionMinor as "fversionminor",FVMId as "fvmid" from T_CDP_DEVPROJECT

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

select FOrgId as "项目内码",FPackageName as "构建包名称",FVersionMajor as "构建包主版本",FVersionMinor as "构建包子版本",FVMId as "开发虚拟机id" from T_CDP_DEVPROJECT

--INSERT脚本--

insert into T_CDP_DEVPROJECT(FOrgId,FPackageName,FVersionMajor,FVersionMinor,FVMId) values (?,?,?,?,?)

--UPDATE脚本--

update T_CDP_DEVPROJECT set FOrgId=?,FPackageName=?,FVersionMajor=?,FVersionMinor=?,FVMId=? where FOrgId=?

--delete脚本--

delete from T_CDP_DEVPROJECT where FOrgId=?

--给字段加备注--

alter table T_CDP_DEVPROJECT comment '项目开发';

alter table T_CDP_DEVPROJECT modify column FOrgId int not null  comment '项目内码';

alter table T_CDP_DEVPROJECT modify column FPackageName nvarchar(50) default null  comment '构建包名称';

alter table T_CDP_DEVPROJECT modify column FVersionMajor int default null  comment '构建包主版本';

alter table T_CDP_DEVPROJECT modify column FVersionMinor int default null  comment '构建包子版本';

alter table T_CDP_DEVPROJECT modify column FVMId nvarchar(50) default null  comment '开发虚拟机id';

--建表脚本--

create table T_CDP_HISTORYAPPLY(

FId int not null  comment '内码'

,FApplicantId int default null  comment '用户内码'

,FApplyTime datetime default null  comment '申请日期'

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

,FApplyRemark nvarchar(255) default null  comment '申请说明'

,FApproverId 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",FApplyTime as "fapplytime",FCompany as "fcompany",FApplyRemark as "fapplyremark",FApproverId as "fapproverid",FApproveTime as "fapprovetime",FApproveRemark as "fapproveremark",FStatus as "fstatus",FInfoStatus as "finfostatus" from T_CDP_HISTORYAPPLY

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

select FId as "内码",FApplicantId as "用户内码",FApplyTime as "申请日期",FCompany as "申请企业",FApplyRemark as "申请说明",FApproverId as "审批人",FApproveTime as "审批日期",FApproveRemark as "审批说明",FStatus as "状态",FInfoStatus as "信息状态" from T_CDP_HISTORYAPPLY

--INSERT脚本--

insert into T_CDP_HISTORYAPPLY(FId,FApplicantId,FApplyTime,FCompany,FApplyRemark,FApproverId,FApproveTime,FApproveRemark,FStatus,FInfoStatus) values (?,?,?,?,?,?,?,?,?,?)

--UPDATE脚本--

update T_CDP_HISTORYAPPLY set FId=?,FApplicantId=?,FApplyTime=?,FCompany=?,FApplyRemark=?,FApproverId=?,FApproveTime=?,FApproveRemark=?,FStatus=?,FInfoStatus=? where FId=?

--delete脚本--

delete from T_CDP_HISTORYAPPLY where FId=?

--给字段加备注--

alter table T_CDP_HISTORYAPPLY comment '企业申请历史';

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

alter table T_CDP_HISTORYAPPLY modify column FApplicantId int default null  comment '用户内码';

alter table T_CDP_HISTORYAPPLY modify column FApplyTime datetime default null  comment '申请日期';

alter table T_CDP_HISTORYAPPLY modify column FCompany int default null  comment '申请企业';

alter table T_CDP_HISTORYAPPLY modify column FApplyRemark nvarchar(255) default null  comment '申请说明';

alter table T_CDP_HISTORYAPPLY modify column FApproverId int default null  comment '审批人';

alter table T_CDP_HISTORYAPPLY modify column FApproveTime datetime default null  comment '审批日期';

alter table T_CDP_HISTORYAPPLY modify column FApproveRemark nvarchar(255) default null  comment '审批说明';

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

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

--建表脚本--

create table T_CDP_HISTORYAUTHORIZE(

FId int not null  comment '内码'

,FQUALIFICATIONTYPE nvarchar(50) default null  comment '认证类型'

,FAppliantId int default null  comment '申请人内码'

,FApplyTime datetime default null  comment '申请日期'

,FCOMPANY int default null  comment '申请企业'

,FApplyRemark nvarchar(255) default null  comment '申请说明'

,FApproverId int default null  comment '审批人'

,FApproveTime datetime default null  comment '审批日期'

,FApproveRemark nvarchar(255) default null  comment '审批说明'

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

,FRank nvarchar(50) default null  comment '企业等级'

,FNo nvarchar(50) default null  comment '资质证书编号'

,FStartTime datetime default null  comment '资质生效日期'

,FEndTime datetime default null  comment '资质失效日期'

,FAUTHORIZEID int default null  comment '企业认证信息内码'

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

,FDEVELOPERNUMBER int default null  comment '开发技术人数'

,FDEVELOPERNUMBER2 int default null  comment '开发交付人数'

,FImplementNumber int default null  comment '实施交付人数'

,FPREMIUM nvarchar(50) default null  comment '保证金'

,FCONTRACTENDDATE datetime default null  comment '合同到期日期'

,FRANGE int default null  comment '企业业务授权范围'

,FRegion int default null  comment '企业所属区域'

,FInstitution int default null  comment '企业所属机构'

,FNOTES nvarchar(255) default null  comment '认证备注'

,FBILLNO nvarchar(50) default null  comment '编码'

,FPRODUCT nvarchar(255) default null  comment '产品简介'

,primary key (FId)

) comment = '企业认证历史'

--查询--

select FId as "fid",FQUALIFICATIONTYPE as "fqualificationtype",FAppliantId as "fappliantid",FApplyTime as "fapplytime",FCOMPANY as "fcompany",FApplyRemark as "fapplyremark",FApproverId as "fapproverid",FApproveTime as "fapprovetime",FApproveRemark as "fapproveremark",FStatus as "fstatus",FRank as "frank",FNo as "fno",FStartTime as "fstarttime",FEndTime as "fendtime",FAUTHORIZEID as "fauthorizeid",FInfoStatus as "finfostatus",FDEVELOPERNUMBER as "fdevelopernumber",FDEVELOPERNUMBER2 as "fdevelopernumber2",FImplementNumber as "fimplementnumber",FPREMIUM as "fpremium",FCONTRACTENDDATE as "fcontractenddate",FRANGE as "frange",FRegion as "fregion",FInstitution as "finstitution",FNOTES as "fnotes",FBILLNO as "fbillno",FPRODUCT as "fproduct" from T_CDP_HISTORYAUTHORIZE

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

select FId as "内码",FQUALIFICATIONTYPE as "认证类型",FAppliantId as "申请人内码",FApplyTime as "申请日期",FCOMPANY as "申请企业",FApplyRemark as "申请说明",FApproverId as "审批人",FApproveTime as "审批日期",FApproveRemark as "审批说明",FStatus as "状态",FRank as "企业等级",FNo as "资质证书编号",FStartTime as "资质生效日期",FEndTime as "资质失效日期",FAUTHORIZEID as "企业认证信息内码",FInfoStatus as "信息状态",FDEVELOPERNUMBER as "开发技术人数",FDEVELOPERNUMBER2 as "开发交付人数",FImplementNumber as "实施交付人数",FPREMIUM as "保证金",FCONTRACTENDDATE as "合同到期日期",FRANGE as "企业业务授权范围",FRegion as "企业所属区域",FInstitution as "企业所属机构",FNOTES as "认证备注",FBILLNO as "编码",FPRODUCT as "产品简介" from T_CDP_HISTORYAUTHORIZE

--INSERT脚本--

insert into T_CDP_HISTORYAUTHORIZE(FId,FQUALIFICATIONTYPE,FAppliantId,FApplyTime,FCOMPANY,FApplyRemark,FApproverId,FApproveTime,FApproveRemark,FStatus,FRank,FNo,FStartTime,FEndTime,FAUTHORIZEID,FInfoStatus,FDEVELOPERNUMBER,FDEVELOPERNUMBER2,FImplementNumber,FPREMIUM,FCONTRACTENDDATE,FRANGE,FRegion,FInstitution,FNOTES,FBILLNO,FPRODUCT) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)

--UPDATE脚本--

update T_CDP_HISTORYAUTHORIZE set FId=?,FQUALIFICATIONTYPE=?,FAppliantId=?,FApplyTime=?,FCOMPANY=?,FApplyRemark=?,FApproverId=?,FApproveTime=?,FApproveRemark=?,FStatus=?,FRank=?,FNo=?,FStartTime=?,FEndTime=?,FAUTHORIZEID=?,FInfoStatus=?,FDEVELOPERNUMBER=?,FDEVELOPERNUMBER2=?,FImplementNumber=?,FPREMIUM=?,FCONTRACTEND