--建表脚本--
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 default null comment '失效日期';
alter table T_CDP_Qualification modify column FApproverId int default null comment '审批人内码';
alter table T_CDP_Qualification modify column FApproveTime datetime default null comment '审批日期';
alter table T_CDP_Qualification modify column FApproveRemark nvarchar(255) default null comment '审批说明';
alter table T_CDP_Qualification modify column FAPPLYORGID int default null comment '申请企业';
alter table T_CDP_Qualification modify column FInfoStatus nvarchar(50) default null comment '信息状态';
--建表脚本--
create table T_CDP_Qualification_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_Qualification_L
--查询(中文字段)--
select FPKID as "内码",FId as "资质内码",FLocaleID as "地区内码",FName as "名称" from T_CDP_Qualification_L
--INSERT脚本--
insert into T_CDP_Qualification_L(FPKID,FId,FLocaleID,FName) values (?,?,?,?)
--UPDATE脚本--
update T_CDP_Qualification_L set FPKID=?,FId=?,FLocaleID=?,FName=? where FPKID=?
--delete脚本--
delete from T_CDP_Qualification_L where FPKID=?
--给字段加备注--
alter table T_CDP_Qualification_L comment '个人资质多语言';
alter table T_CDP_Qualification_L modify column FPKID int not null comment '内码';
alter table T_CDP_Qualification_L modify column FId int default null comment '资质内码';
alter table T_CDP_Qualification_L modify column FLocaleID int default null comment '地区内码';
alter table T_CDP_Qualification_L modify column FName nvarchar(50) default null comment '名称';
--建表脚本--
create table T_CDP_USERS(
FEntityID int not null comment '内码'
,FUserId int default null comment '用户内码'
,FSex smallint default null comment '性别'
,FSFZ nvarchar(50) default null comment '身份证'
,FMobile nvarchar(50) default null comment '手机'
,FMail nvarchar(255) default null comment '邮箱'
,FPhone nvarchar(50) default null comment '办公电话'
,FStartWorkTime datetime default null comment '参加工作时间'
,FEducation nvarchar(50) default null comment '最高学历'
,FQQ nvarchar(50) default null comment 'qq'
,FExperience nvarchar(2000) default null comment '工作经验'
,primary key (FEntityID)
) comment = '用户附表'
--查询--
select FEntityID as "fentityid",FUserId as "fuserid",FSex as "fsex",FSFZ as "fsfz",FMobile as "fmobile",FMail as "fmail",FPhone as "fphone",FStartWorkTime as "fstartworktime",FEducation as "feducation",FQQ as "fqq",FExperience as "fexperience" from T_CDP_USERS
--查询(中文字段)--
select FEntityID as "内码",FUserId as "用户内码",FSex as "性别",FSFZ as "身份证",FMobile as "手机",FMail as "邮箱",FPhone as "办公电话",FStartWorkTime as "参加工作时间",FEducation as "最高学历",FQQ as "qq",FExperience as "工作经验" from T_CDP_USERS
--INSERT脚本--
insert into T_CDP_USERS(FEntityID,FUserId,FSex,FSFZ,FMobile,FMail,FPhone,FStartWorkTime,FEducation,FQQ,FExperience) values (?,?,?,?,?,?,?,?,?,?,?)
--UPDATE脚本--
update T_CDP_USERS set FEntityID=?,FUserId=?,FSex=?,FSFZ=?,FMobile=?,FMail=?,FPhone=?,FStartWorkTime=?,FEducation=?,FQQ=?,FExperience=? where FEntityID=?
--delete脚本--
delete from T_CDP_USERS where FEntityID=?
--给字段加备注--
alter table T_CDP_USERS comment '用户附表';
alter table T_CDP_USERS modify column FEntityID int not null comment '内码';
alter table T_CDP_USERS modify column FUserId int default null comment '用户内码';
alter table T_CDP_USERS modify column FSex smallint default null comment '性别';
alter table T_CDP_USERS modify column FSFZ nvarchar(50) default null comment '身份证';
alter table T_CDP_USERS modify column FMobile nvarchar(50) default null comment '手机';
alter table T_CDP_USERS modify column FMail nvarchar(255) default null comment '邮箱';
alter table T_CDP_USERS modify column FPhone nvarchar(50) default null comment '办公电话';
alter table T_CDP_USERS modify column FStartWorkTime datetime default null comment '参加工作时间';
alter table T_CDP_USERS modify column FEducation nvarchar(50) default null comment '最高学历';
alter table T_CDP_USERS modify column FQQ nvarchar(50) default null comment 'qq';
alter table T_CDP_USERS modify column FExperience nvarchar(2000) default null comment '工作经验';
推荐阅读