--建表脚本--
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=?,FCONTRACTENDDATE=?,FRANGE=?,FRegion=?,FInstitution=?,FNOTES=?,FBILLNO=?,FPRODUCT=? where FId=?
--delete脚本--
delete from T_CDP_HISTORYAUTHORIZE where FId=?
--给字段加备注--
alter table T_CDP_HISTORYAUTHORIZE comment '企业认证历史';
alter table T_CDP_HISTORYAUTHORIZE modify column FId int not null comment '内码';
alter table T_CDP_HISTORYAUTHORIZE modify column FQUALIFICATIONTYPE nvarchar(50) default null comment '认证类型';
alter table T_CDP_HISTORYAUTHORIZE modify column FAppliantId int default null comment '申请人内码';
alter table T_CDP_HISTORYAUTHORIZE modify column FApplyTime datetime default null comment '申请日期';
alter table T_CDP_HISTORYAUTHORIZE modify column FCOMPANY int default null comment '申请企业';
alter table T_CDP_HISTORYAUTHORIZE modify column FApplyRemark nvarchar(255) default null comment '申请说明';
alter table T_CDP_HISTORYAUTHORIZE modify column FApproverId int default null comment '审批人';
alter table T_CDP_HISTORYAUTHORIZE modify column FApproveTime datetime default null comment '审批日期';
alter table T_CDP_HISTORYAUTHORIZE modify column FApproveRemark nvarchar(255) default null comment '审批说明';
alter table T_CDP_HISTORYAUTHORIZE modify column FStatus nvarchar(50) default null comment '状态';
alter table T_CDP_HISTORYAUTHORIZE modify column FRank nvarchar(50) default null comment '企业等级';
alter table T_CDP_HISTORYAUTHORIZE modify column FNo nvarchar(50) default null comment '资质证书编号';
alter table T_CDP_HISTORYAUTHORIZE modify column FStartTime datetime default null comment '资质生效日期';
alter table T_CDP_HISTORYAUTHORIZE modify column FEndTime datetime default null comment '资质失效日期';
alter table T_CDP_HISTORYAUTHORIZE modify column FAUTHORIZEID int default null comment '企业认证信息内码';
alter table T_CDP_HISTORYAUTHORIZE modify column FInfoStatus nvarchar(50) default null comment '信息状态';
alter table T_CDP_HISTORYAUTHORIZE modify column FDEVELOPERNUMBER int default null comment '开发技术人数';
alter table T_CDP_HISTORYAUTHORIZE modify column FDEVELOPERNUMBER2 int default null comment '开发交付人数';
alter table T_CDP_HISTORYAUTHORIZE modify column FImplementNumber int default null comment '实施交付人数';
alter table T_CDP_HISTORYAUTHORIZE modify column FPREMIUM nvarchar(50) default null comment '保证金';
alter table T_CDP_HISTORYAUTHORIZE modify column FCONTRACTENDDATE datetime default null comment '合同到期日期';
alter table T_CDP_HISTORYAUTHORIZE modify column FRANGE int default null comment '企业业务授权范围';
alter table T_CDP_HISTORYAUTHORIZE modify column FRegion int default null comment '企业所属区域';
alter table T_CDP_HISTORYAUTHORIZE modify column FInstitution int default null comment '企业所属机构';
alter table T_CDP_HISTORYAUTHORIZE modify column FNOTES nvarchar(255) default null comment '认证备注';
alter table T_CDP_HISTORYAUTHORIZE modify column FBILLNO nvarchar(50) default null comment '编码';
alter table T_CDP_HISTORYAUTHORIZE modify column FPRODUCT nvarchar(255) default null comment '产品简介';
--建表脚本--
create table T_CDP_HISTORYAUTHORIZE_I(
FEntryID int not null comment '内码'
,FID int default null comment '认证表内码'
,FInstitutionID int default null comment '机构内码'
,primary key (FEntryID)
) comment = '企业授权范围-机构'
--查询--
select FEntryID as "fentryid",FID as "fid",FInstitutionID as "finstitutionid" from T_CDP_HISTORYAUTHORIZE_I
--查询(中文字段)--
select FEntryID as "内码",FID as "认证表内码",FInstitutionID as "机构内码" from T_CDP_HISTORYAUTHORIZE_I
--INSERT脚本--
insert into T_CDP_HISTORYAUTHORIZE_I(FEntryID,FID,FInstitutionID) values (?,?,?)
--UPDATE脚本--
update T_CDP_HISTORYAUTHORIZE_I set FEntryID=?,FID=?,FInstitutionID=? where FEntryID=?
--delete脚本--
delete from T_CDP_HISTORYAUTHORIZE_I where FEntryID=?
--给字段加备注--
alter table T_CDP_HISTORYAUTHORIZE_I comment '企业授权范围-机构';
alter table T_CDP_HISTORYAUTHORIZE_I modify column FEntryID int not null comment '内码';
alter table T_CDP_HISTORYAUTHORIZE_I modify column FID int default null comment '认证表内码';
alter table T_CDP_HISTORYAUTHORIZE_I modify column FInstitutionID int default null comment '机构内码';
--建表脚本--
create table T_CDP_HISTORYAUTHORIZE_L(
FPKID int not null comment '内码'
,FId int default null comment '资质内码'
,FLocaleID int default null comment '地区内码'
,FName nvarchar(50) default null comment '名称'
,primary key (FPKID)
) comment = '企业资质多语言'
--查询--
select FPKID as "fpkid",FId as "fid",FLocaleID as "flocaleid",FName as "fname" from T_CDP_HISTORYAUTHORIZE_L
--查询(中文字段)--
select FPKID as "内码",FId as "资质内码",FLocaleID as "地区内码",FName as "名称" from T_CDP_HISTORYAUTHORIZE_L
--INSERT脚本--
insert into T_CDP_HISTORYAUTHORIZE_L(FPKID,FId,FLocaleID,FName) values (?,?,?,?)
--UPDATE脚本--
update T_CDP_HISTORYAUTHORIZE_L set FPKID=?,FId=?,FLocaleID=?,FName=? where FPKID=?
--delete脚本--
delete from T_CDP_HISTORYAUTHORIZE_L where FPKID=?
--给字段加备注--
alter table T_CDP_HISTORYAUTHORIZE_L comment '企业资质多语言';
alter table T_CDP_HISTORYAUTHORIZE_L modify column FPKID int not null comment '内码';
alter table T_CDP_HISTORYAUTHORIZE_L modify column FId int default null comment '资质内码';
alter table T_CDP_HISTORYAUTHORIZE_L modify column FLocaleID int default null comment '地区内码';
alter table T_CDP_HISTORYAUTHORIZE_L modify column FName nvarchar(50) default null comment '名称';
赞 34
打赏推荐阅读
