人力资源培训发展信息表数据表全文案例分析电子版

返回总览人力资源培训发展信息表数据表序号表名1HR_TR_TrainNotice2HR_TR_TrainPlan3HR_TR_TrainPlanClass4HR_TR_TrainRequirement5HR_TR_TrainTeacher6HR_TR_ActivityExam7HR_TR_ActivityExamStyle8HR_TR_ActivityMsg9HR_TR_ActivityQuestionnaire10HR_TR_ActivitySummary11HR_TR_ActivityTrainStyle12HR_TR_AttachmentFile13HR_TR_Book14HR_TR_BookBorrow15HR_TR_BookCategory16HR_TR_ClassChannel17HR_TR_ClassMaterial18HR_TR_ClassParticipator19HR_TR_ClassSummary20HR_TR_ClassTeacher21HR_TR_EmpTrainNote22HR_TR_ExamClass23HR_TR_ExamPaper24HR_TR_ExamPaperInstance25HR_TR_NoticeProcess26HR_TR_OnLineExam27HR_TR_PaperExamGrade28HR_TR_PaperExamReply29HR_TR_PaperItem30HR_TR_Questionnaire31HR_TR_QuestionnaireInstance32HR_TR_QuestionnaireItem33HR_TR_QuestionnaireItemReply34HR_TR_QuestionnaireLog35HR_TR_RequirementClass36HR_TR_Suggestion37HR_TR_TrainActivity38HR_TR_TrainActivityClass39HR_TR_TrainApplication40HR_TR_TrainApprival41HR_TR_TrainChannel42HR_TR_TrainClass43HR_TR_TrainClassType44HR_TR_TrainMaterial45HR_TR_TrainNoteEx表描述培训征集通知表培训规划表培训规划课程表部门培训申请培训讲师表培训考试表培训活动考核方式表培训活动信息发布表培训问卷表培训活动总结表培训活动培训方式表培训资料附件表图书表借书表图书类别表培训课程渠道关系表培训课程资料关系表培训课程参与者表培训课程总结培训课程讲师关系表培训记录表培训考试记录表考试试卷表试卷实例表培训征集过程表考试记录表考试成绩等级表考试回复结果表试卷题目表问卷表调查问卷实例表问卷题目表问卷调查项目回复记录表问卷调查记录表部门培训申请课程表培训建议表培训活动表培训活动课程表个人培训申请综合评价表培训渠道表培训课程表培训课程类别表培训资料表员工培训记录附表返回人力资源培训发展信息表目录表结构字段名类型描述ContentSTRING通知内容DeadLineDATETIME期限EndDateDATETIME结束日期FromOrgUnitUnKnown发送部门IDUnKnown唯一标识SenderUnKnown发送者IDStartdateDATETIME开始日期StatusINTEGER状态键表键名类型PK_HR_TR_TrainNotice主键索引表索引名字段PK_HR_TR_TrainNoticeID触发器表触发器名描述返回人力资源培训发展信息表目录表结构字段名类型描述ApproveDateDATETIME规划批准日期ApproveStatusINTEGER规划状态BudgetFLOAT预算费用CreateDateDATETIME创建时间EndDateDATETIME结束日期IDUnKnown唯一标识NameSTRING规划名称StartDateDATETIME开始日期UnitIDUnKnown所属组织单元IDWeightFLOAT课程成本权重键表键名类型PK_HR_TR_TrainPlan主键索引表索引名字段PK_HR_TR_TrainPlanID触发器表触发器名描述返回人力资源培训发展信息表目录表结构字段名类型描述AverageCostFLOAT每次课程费用ClassIDUnKnown培训课程IDCreateDateDATETIME创建时间ExecuteStatusINTEGER实施状态ExecuteTimesINTEGER举办次数IDUnKnown唯一标识IsObjSavedINTEGER是否引用过PlanEndDateDATETIME计划结束日期PlanHoursFLOAT计划课时PlanStartDateDATETIME计划开始日期RemarkSTRING备注TrainPlanIDUnKnown培训规划ID键表键名类型FK_HR_TR_TrainPlanClass_HR_TR_TrainClass外键FK_HR_TR_TrainPlanClass_HR_TR_TrainPlan外键PK_HR_TR_TrainPlanClass主键索引表索引名字段PK_HR_TR_TrainPlanClassID触发器表触发器名描述返回人力资源培训发展信息表目录表结构字段名类型描述AdviceTeacherSTRING建议讲师ClassNameSTRING课程名称ClassTypeIDUnKnown课程类型IDNoticeIDUnKnown征集通知IDTrainPlanTimeSTRING计划培训时间ActualizeManagerIDUnKnown培训实施部门负责人IDActualizeUnitIDUnKnown培训实施部门IDAdviceChannelSTRING建议渠道AimSTRING目的ApplyDateDATETIME申请日期ApplyOrgUnitUnKnown申请部门ApplyUnitManagerIDUnKnown申请部门负责人IDBeginDateDATETIME开始日期ConditionSTRING参与条件ContactWaySTRING联系方式ContentSTRING内容EndDateDATETIME结束日期IDUnKnown唯一标识IsClassBuildedINTEGER建议课程是否创建NameSTRING申请名称OperaterIDUnKnown申请记录者IDPartNumINTEGER参与人数RemarkSTRING备注StatusINTEGER状态TrainNoSTRING申请编号键表键名类型PK_HR_TR_TrainRequirement主键索引表索引名字段PK_HR_TR_TrainRequirementID触发器表触发器名描述返回人力资源培训发展信息表目录表结构字段名类型描述BriefSTRING讲师简介ChannelIDUnKnown所属渠道IDCostFLOAT费用IDUnKnown唯一标识NameSTRING讲师姓名TypeINTEGER讲师类型键表键名类型PK_HR_TR_TrainTeacher主键索引表索引名字段PK_HR_TR_TrainTeacherID触发器表触发器名描述返回人力资源培训发展信息表目录表结构字段名类型描述ActivityIDUnKnown培训活动IDClassIDUnKnown培训课程IDCreateDateDATETIME建立日期EndDateDATETIME结束日期ExamPaperIDUnKnown试卷IDIDUnKnown唯一标识键表键名类型FK_HR_TR_ActivityExam_HR_TR_ExamPaper外键FK_HR_TR_ActivityExam_HR_TR_TrainActivity外键PK_HR_TR_ActivityExam主键索引表索引名字段PK_HR_TR_ActivityExamID触发器表触发器名描述返回人力资源培训发展信息表目录表结构字段名类型描述FActivityIDUnKnown活动唯一标识FExamStyleUnKnown考核方式唯一标识键表键名类型FK_HR_TR_AC_REFERENCE_HR_TR_CO外键FK_HR_TR_AC_REFERENCE_HR_TR_TR外键PK_HR_TR_ACTIVITYEXAMSTYLE主键索引表索引名字段PK_HR_TR_ACTIVITYEXAMSTYLEFActivityID触发器表触发器名描述返回人力资源培训发展信息表目录表结构字段名类型描述ContentSTRING活动信息内容IDUnKnown唯一标识SendFlagINTEGER是否已发送SubjectSTRING活动信息主题键表键名类型PK_HR_TR_ActivityMsg主键索引表索引名字段PK_HR_TR_ActivityMsgID触发器表触发器名描述返回人力资源培训发展信息表目录表结构字段名类型描述ActivityIDUnKnown培训活动IDClassIDUnKnown培训课程IDCreateDateDATETIME建立日期EndDateDATETIME结束日期IDUnKnown唯一标识QuestionnaireIDUnKnown问卷IDSourceIDUnKnown问卷对象IDSurveyResultFLOAT问卷结果SurveyTypeINTEGER问卷类型键表键名类型FK_HR_TR_AC_REFERENCE_HR_TR_QU外键FK_HR_TR_ActivityQuestionnaire_HR_TR_Questionnaire外键FK_HR_TR_ActivityQuestionnaire_HR_TR_TrainActivity外键PK_HR_TR_ActivityQuestionnaire主键索引表索引名字段PK_HR_TR_ActivityQuestionnaireID触发器表触发器名描述返回人力资源培训发展信息表目录表结构字段名类型描述ActivityIDUnKnown培训活动IDCreateDateDATETIME活动总结时间IDUnKnown唯一标识RealCostFLOAT实际费用RealEndDateDATETIME实际结束日期RealStartDateDATETIME实际开始日期RemarkSTRING总结内容StatusINTEGER状态键表键名类型FK_HR_TR_ActivitySummary_HR_TR_TrainActivity外键PK_HR_TR_ActivitySummary主键索引表索引名字段PK_HR_TR_ActivitySummaryID触发器表触发器名描述返回人力资源培训发展信息表目录表结构字段名类型描述FActivityIDUnKnown活动唯一标识FTrainStyleUnKnown培训方式唯一标识键表键名类型PK_HR_TR_ACTIVITYTRAINSTYLE主键索引表索引名字段PK_HR_TR_ACTIVITYTRAINSTYLEFActivityID触发器表触发器名描述返回人力资源培训发展信息表目录表结构字段名类型描述ContentUnKnown附件内容ContentTypeSTRING文件类型FileNameSTRING文件名FileSizeINTEGER文件大小IDUnKnown唯一标识MaterialIDUnKnown资料IDNameSTRING附件名称UploadDateDATETIME上传日期键表键名类型FK_HR_TR_AttachmentFile_HR_TR_TrainMaterial外键PK_HR_TR_AttachmentFile主键索引表索引名字段PK_HR_TR_AttachmentFileID触发器表触发器名描述返回人力资源培训发展信息表目录表结构字段名类型描述AuthorSTRING作者CategoryIDUnKnown图书类型ContentUnKnown图书说明Curr