CDP协同开发平台 / 用户管理 / 物理模型图

--建表脚本--

create table T_CDP_MyProject(

FId int not null  comment '内码'

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

,FCompany nvarchar(255) default null  comment '企业名称'

,FProjectName nvarchar(255) default null  comment '项目名称'

,FRemark nvarchar(2000) default null  comment '项目描述'

,FRole nvarchar(50) default null  comment '担当角色'

,FStartTime datetime default null  comment '开始日期'

,FEndTime datetime default null  comment '结束日期'

,primary key (FId)

) comment = '个人项目'

--查询--

select FId as "fid",FUserId as "fuserid",FCompany as "fcompany",FProjectName as "fprojectname",FRemark as "fremark",FRole as "frole",FStartTime as "fstarttime",FEndTime as "fendtime" from T_CDP_MyProject

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

select FId as "内码",FUserId as "用户内码",FCompany as "企业名称",FProjectName as "项目名称",FRemark as "项目描述",FRole as "担当角色",FStartTime as "开始日期",FEndTime as "结束日期" from T_CDP_MyProject

--INSERT脚本--

insert into T_CDP_MyProject(FId,FUserId,FCompany,FProjectName,FRemark,FRole,FStartTime,FEndTime) values (?,?,?,?,?,?,?,?)

--UPDATE脚本--

update T_CDP_MyProject set FId=?,FUserId=?,FCompany=?,FProjectName=?,FRemark=?,FRole=?,FStartTime=?,FEndTime=? where FId=?

--delete脚本--

delete from T_CDP_MyProject where FId=?

--给字段加备注--

alter table T_CDP_MyProject comment '个人项目';

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

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

alter table T_CDP_MyProject modify column FCompany nvarchar(255) default null  comment '企业名称';

alter table T_CDP_MyProject modify column FProjectName nvarchar(255) default null  comment '项目名称';

alter table T_CDP_MyProject modify column FRemark nvarchar(2000) default null  comment '项目描述';

alter table T_CDP_MyProject modify column FRole nvarchar(50) default null  comment '担当角色';

alter table T_CDP_MyProject modify column FStartTime datetime default null  comment '开始日期';

alter table T_CDP_MyProject modify column FEndTime datetime default null  comment '结束日期';

--建表脚本--

create table T_CDP_Qualification(

FId int not null  comment '内码'

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

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

,FProductTYPE nvarchar(50) default null  comment '产品类型'

,FMODULE nvarchar(50) default null  comment '领域'

,FCAPABILITY nvarchar(50) default null  comment '实施能力'

,FType nvarchar(50) default null  comment '资质类型'

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

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

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

,FScore decimal(10,2) default null  comment '认证分数'

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

,FEffectiveTime datetime default null  comment '生效日期'

,FExpirationTime datetime default null  comment '失效日期'

,FApproverId int default null  comment '审批人内码'

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

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

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

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

,primary key (FId)

) comment = '个人资质'

--查询--

select FId as "fid",FApplicantId as "fapplicantid",FQUALIFICATIONTYPE as "fqualificationtype",FProductTYPE as "fproducttype",FMODULE as "fmodule",FCAPABILITY as "fcapability",FType as "ftype",FApplyTime as "fapplytime",FApplyRemark as "fapplyremark",FStatus as "fstatus",FScore as "fscore",FQualificationNo as "fqualificationno",FEffectiveTime as "feffectivetime",FExpirationTime as "fexpirationtime",FApproverId as "fapproverid",FApproveTime as "fapprovetime",FApproveRemark as "fapproveremark",FAPPLYORGID as "fapplyorgid",FInfoStatus as "finfostatus" from T_CDP_Qualification

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

select FId as "内码",FApplicantId as "申请人内码",FQUALIFICATIONTYPE as "认证类型",FProductTYPE as "产品类型",FMODULE as "领域",FCAPABILITY as "实施能力",FType as "资质类型",FApplyTime as "申请日期",FApplyRemark as "申请说明",FStatus as "状态",FScore as "认证分数",FQualificationNo as "资质证书编号",FEffectiveTime as "生效日期",FExpirationTime as "失效日期",FApproverId as "审批人内码",FApproveTime as "审批日期",FApproveRemark as "审批说明",FAPPLYORGID as "申请企业",FInfoStatus as "信息状态" from T_CDP_Qualification

--INSERT脚本--

insert into T_CDP_Qualification(FId,FApplicantId,FQUALIFICATIONTYPE,FProductTYPE,FMODULE,FCAPABILITY,FType,FApplyTime,FApplyRemark,FStatus,FScore,FQualificationNo,FEffectiveTime,FExpirationTime,FApproverId,FApproveTime,FApproveRemark,FAPPLYORGID,FInfoStatus) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)

--UPDATE脚本--

update T_CDP_Qualification set FId=?,FApplicantId=?,FQUALIFICATIONTYPE=?,FProductTYPE=?,FMODULE=?,FCAPABILITY=?,FType=?,FApplyTime=?,FApplyRemark=?,FStatus=?,FScore=?,FQualificationNo=?,FEffectiveTime=?,FExpirationTime=?,FApproverId=?,FApproveTime=?,FApproveRemark=?,FAPPLYORGID=?,FInfoStatus=? where FId=?

--delete脚本--

delete from T_CDP_Qualification where FId=?

--给字段加备注--

alter table T_CDP_Qualification comment '个人资质';

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

alter table T_CDP_Qualification modify column FApplicantId int default null  comment '申请人内码';

alter table T_CDP_Qualification modify column FQUALIFICATIONTYPE nvarchar(50) default null  comment '认证类型';

alter table T_CDP_Qualification modify column FProductTYPE nvarchar(50) default null  comment '产品类型';

alter table T_CDP_Qualification modify column FMODULE nvarchar(50) default null  comment '领域';

alter table T_CDP_Qualification modify column FCAPABILITY nvarchar(50) default null  comment '实施能力';

alter table T_CDP_Qualification modify column FType nvarchar(50) default null  comment '资质类型';

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

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

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

alter table T_CDP_Qualification modify column FScore decimal(10,2) default null  comment '认证分数';

alter table T_CDP_Qualification modify column FQualificationNo nvarchar(50) default null  comment '资质证书编号';

alter table T_CDP_Qualification modify column FEffectiveTime datetime default null  comment '生效日期';

alter table T_CDP_Qualification modify column FExpirationTime datetime defau