数据结构

12111

表总览

通用表

业务表

_ui

  • ui 施工方案
  1. CREATE TABLE `_ui` (
  2. `id` int(11) NOT NULL AUTO_INCREMENT,
  3. `pageId` varchar(255) DEFAULT NULL COMMENT 'page id; E.g: index',
  4. `uiActionType` varchar(255) DEFAULT NULL COMMENT 'ui 动作类型,如:fetchData, postData, changeUi',
  5. `uiActionId` varchar(255) DEFAULT NULL COMMENT 'action id; E.g: selectXXXByXXX',
  6. `desc` varchar(255) DEFAULT NULL COMMENT '描述',
  7. `uiActionConfig` text COMMENT 'ui 动作数据',
  8. `appDataSchema` text COMMENT 'ui 校验数据',
  9. `operation` varchar(255) DEFAULT 'insert' COMMENT '操作; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  10. `operationByUserId` varchar(255) DEFAULT NULL COMMENT '操作者userId',
  11. `operationByUser` varchar(255) DEFAULT NULL COMMENT '操作者用户名',
  12. `operationAt` varchar(255) DEFAULT NULL COMMENT '操作时间; E.g: 2021-05-28T10:24:54+08:00 ',
  13. PRIMARY KEY (`id`) USING BTREE
  14. ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = 'ui 施工方案'

achievement_appraisal

  • 绩效考核
  1. CREATE TABLE `achievement_appraisal` (
  2. `id` int(11) DEFAULT NULL COMMENT '自增主键',
  3. `appraisalId` int(11) NOT NULL AUTO_INCREMENT,
  4. `appraisalName` varchar(50) DEFAULT NULL COMMENT '考核名称',
  5. `cycleType` int(11) DEFAULT NULL COMMENT '1 月 2 季 3 年 4 半年',
  6. `startTime` date DEFAULT NULL COMMENT '考核开始时间',
  7. `endTime` date DEFAULT NULL COMMENT '考核结束时间',
  8. `tableId` int(11) DEFAULT NULL COMMENT '考核表模板id',
  9. `writtenBy` int(11) DEFAULT '1' COMMENT '考核目标填写人 1 本人',
  10. `resultConfirmors` varchar(1024) DEFAULT NULL COMMENT '考核结果确认人\n',
  11. `fullScore` decimal(7, 2) DEFAULT NULL COMMENT '考评总分数',
  12. `isForce` int(11) DEFAULT NULL COMMENT '是否开启强制分布 1 是 0 否',
  13. `employeeIds` varchar(1024) DEFAULT NULL COMMENT '考核员工',
  14. `deptIds` varchar(1024) DEFAULT NULL COMMENT '考核部门',
  15. `appraisalSteps` int(11) DEFAULT '-1' COMMENT '考核步骤进度',
  16. `activateSteps` int(11) DEFAULT '-1' COMMENT '进行中步骤进度',
  17. `status` int(11) DEFAULT '0' COMMENT '绩效状态 0 未开启考核 1 绩效填写中 2 绩效评定中 3 结果确认中 4 归档',
  18. `isStop` int(11) DEFAULT '0' COMMENT '是否终止 0 否 1 是',
  19. `stopTime` datetime DEFAULT NULL COMMENT '终止时间',
  20. `createUserId` bigint(20) DEFAULT NULL,
  21. `createTime` datetime DEFAULT NULL,
  22. `updateTime` datetime DEFAULT NULL,
  23. `operation` varchar(255) DEFAULT NULL,
  24. `operationByUserId` varchar(255) DEFAULT NULL,
  25. `operationByUser` varchar(255) DEFAULT NULL,
  26. `operationAt` varchar(255) DEFAULT NULL,
  27. PRIMARY KEY (`appraisalId`) USING BTREE
  28. ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '绩效考核'

achievement_appraisal_evaluators

  • 考核结果评定人
  1. CREATE TABLE `achievement_appraisal_evaluators` (
  2. `id` int(11) DEFAULT NULL COMMENT '自增主键',
  3. `evaluatorsId` int(11) NOT NULL AUTO_INCREMENT,
  4. `appraisalId` int(11) NOT NULL COMMENT '考核id',
  5. `type` int(11) NOT NULL COMMENT '1 员工本人 2 直属上级 3 所在部门负责人 4 上级部门负责人 5 指定目标确认人',
  6. `employeeId` int(11) DEFAULT NULL COMMENT '指定确认人id',
  7. `weight` decimal(5, 2) NOT NULL COMMENT '权重',
  8. `sort` int(11) DEFAULT NULL,
  9. `operation` varchar(255) DEFAULT NULL,
  10. `operationByUserId` varchar(255) DEFAULT NULL,
  11. `operationAt` varchar(255) DEFAULT NULL,
  12. `operationByUser` varchar(255) DEFAULT NULL,
  13. PRIMARY KEY (`evaluatorsId`) USING BTREE
  14. ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '考核结果评定人'

achievement_appraisal_score_level

  • 考评规则等级
  1. CREATE TABLE `achievement_appraisal_score_level` (
  2. `id` int(11) DEFAULT NULL COMMENT '自增主键',
  3. `levelId` int(11) NOT NULL AUTO_INCREMENT,
  4. `appraisalId` int(11) NOT NULL COMMENT '考核id',
  5. `levelName` varchar(50) NOT NULL COMMENT '等级名称',
  6. `minScore` decimal(7, 2) DEFAULT NULL COMMENT '最小分数',
  7. `maxScore` decimal(7, 2) NOT NULL COMMENT '最大分数',
  8. `minNum` int(11) NOT NULL COMMENT '最小人数比例',
  9. `maxNum` int(11) NOT NULL COMMENT '最大人数比例',
  10. `sort` int(11) DEFAULT NULL,
  11. `operationByUserId` varchar(255) DEFAULT NULL,
  12. `operation` varchar(255) DEFAULT NULL,
  13. `operationAt` varchar(255) DEFAULT NULL,
  14. `operationByUser` varchar(255) DEFAULT NULL,
  15. PRIMARY KEY (`levelId`) USING BTREE
  16. ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '考评规则等级'

achievement_appraisal_target_confirmors

  • 考核目标确认人
  1. CREATE TABLE `achievement_appraisal_target_confirmors` (
  2. `id` int(11) DEFAULT NULL COMMENT '自增主键',
  3. `targetConfirmorsId` int(11) NOT NULL AUTO_INCREMENT,
  4. `appraisalId` int(11) DEFAULT NULL COMMENT '考核id',
  5. `type` int(11) DEFAULT NULL COMMENT '1 员工本人 2 直属上级 3 所在部门负责人 4 上级部门负责人 5 指定目标确认人',
  6. `employeeId` int(11) DEFAULT NULL COMMENT '指定确认人id',
  7. `sort` int(11) DEFAULT NULL COMMENT '步骤号 从小到大',
  8. `operation` varchar(255) DEFAULT NULL,
  9. `operationByUserId` varchar(255) DEFAULT NULL,
  10. `operationAt` varchar(255) DEFAULT NULL,
  11. `operationByUser` varchar(255) DEFAULT NULL,
  12. PRIMARY KEY (`targetConfirmorsId`) USING BTREE
  13. ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '考核目标确认人'

achievement_employee_appraisal

  • 员工绩效考核
  1. CREATE TABLE `achievement_employee_appraisal` (
  2. `id` int(11) DEFAULT NULL COMMENT '自增主键',
  3. `employeeAppraisalId` int(11) NOT NULL AUTO_INCREMENT,
  4. `employeeId` int(11) NOT NULL COMMENT '员工id',
  5. `appraisalId` int(11) DEFAULT NULL COMMENT '绩效id',
  6. `status` int(11) DEFAULT NULL COMMENT '考核状态 1 待填写 2 待目标确认 3 待评定 4 待结果确认 5 终止绩效 6 考核完成',
  7. `score` double(10, 2) DEFAULT NULL COMMENT '评分',
  8. `levelId` int(11) DEFAULT NULL COMMENT '考核结果',
  9. `readStatus` int(11) DEFAULT '0' COMMENT '结果阅读状态 0 未读 1 已读',
  10. `followUpEmployeeId` int(11) DEFAULT NULL COMMENT '跟进员工id',
  11. `followSort` int(11) DEFAULT NULL COMMENT '跟进员工排序',
  12. `createTime` datetime DEFAULT NULL,
  13. `isDraft` int(11) DEFAULT '0' COMMENT '是否为草稿 0否 1是',
  14. `operationByUserId` varchar(255) DEFAULT NULL,
  15. `operation` varchar(255) DEFAULT NULL,
  16. `operationAt` varchar(255) DEFAULT NULL,
  17. `operationByUser` varchar(255) DEFAULT NULL,
  18. PRIMARY KEY (`employeeAppraisalId`) USING BTREE
  19. ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '员工绩效考核'

achievement_employee_evaluato

  • 员工绩效结果评定表
  1. CREATE TABLE `achievement_employee_evaluato` (
  2. `id` int(11) DEFAULT NULL COMMENT '自增主键',
  3. `employeeEvaluatoId` int(11) NOT NULL AUTO_INCREMENT,
  4. `employeeAppraisalId` int(11) DEFAULT NULL COMMENT '员工端考核id',
  5. `appraisalId` int(11) DEFAULT NULL COMMENT '绩效id',
  6. `employeeId` int(11) NOT NULL COMMENT '确认人',
  7. `weight` decimal(5, 2) DEFAULT NULL COMMENT '权重',
  8. `score` decimal(7, 2) DEFAULT NULL COMMENT '评分',
  9. `levelId` int(11) DEFAULT NULL COMMENT '考核等级',
  10. `evaluate` varchar(1024) DEFAULT NULL COMMENT '评语',
  11. `rejectReason` varchar(1024) DEFAULT NULL COMMENT '驳回原因',
  12. `createTime` datetime DEFAULT NULL,
  13. `updateTime` datetime DEFAULT NULL,
  14. `sort` int(11) DEFAULT NULL,
  15. `status` int(11) DEFAULT '0' COMMENT '0 待评定 1 已评定',
  16. `operation` varchar(255) DEFAULT NULL,
  17. `operationByUserId` varchar(255) DEFAULT NULL,
  18. `operationByUser` varchar(255) DEFAULT NULL,
  19. `operationAt` varchar(255) DEFAULT NULL,
  20. PRIMARY KEY (`employeeEvaluatoId`) USING BTREE
  21. ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '员工绩效结果评定表'

achievement_employee_evaluato_seg

  • 员工绩效考核项评定表
  1. CREATE TABLE `achievement_employee_evaluato_seg` (
  2. `id` int(11) DEFAULT NULL COMMENT '自增主键',
  3. `employeeEvaluatoSegId` int(11) NOT NULL AUTO_INCREMENT,
  4. `employeeAppraisalId` int(11) DEFAULT NULL COMMENT '员工端考核id',
  5. `employeeEvaluatoId` int(11) DEFAULT NULL COMMENT '结果评定id',
  6. `segId` int(11) DEFAULT NULL COMMENT '考核项id',
  7. `employeeId` int(11) NOT NULL COMMENT '评定人',
  8. `score` decimal(7, 2) DEFAULT NULL COMMENT '评分',
  9. `evaluate` varchar(1024) DEFAULT NULL COMMENT '评语',
  10. `status` int(11) DEFAULT '1' COMMENT '0 待评定 1 已评定',
  11. `createTime` datetime DEFAULT NULL,
  12. `updateTime` datetime DEFAULT NULL,
  13. `operation` varchar(255) DEFAULT NULL,
  14. `operationByUserId` varchar(255) DEFAULT NULL,
  15. `operationAt` varchar(255) DEFAULT NULL,
  16. `operationByUser` varchar(255) DEFAULT NULL,
  17. PRIMARY KEY (`employeeEvaluatoSegId`) USING BTREE
  18. ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '员工绩效考核项评定表'

achievement_employee_result_confirmors

  • 绩效结果确认表
  1. CREATE TABLE `achievement_employee_result_confirmors` (
  2. `id` int(11) DEFAULT NULL COMMENT '自增主键',
  3. `confirmorsId` int(11) NOT NULL AUTO_INCREMENT,
  4. `employeeId` int(11) DEFAULT NULL,
  5. `appraisalId` int(11) DEFAULT NULL COMMENT '绩效id',
  6. `status` int(11) DEFAULT '0' COMMENT '0 未确认 1 已确认',
  7. `sort` int(11) DEFAULT NULL,
  8. `createTime` datetime DEFAULT NULL COMMENT '创建时间',
  9. `operation` varchar(255) DEFAULT NULL,
  10. `operationByUserId` varchar(255) DEFAULT NULL,
  11. `operationAt` varchar(255) DEFAULT NULL,
  12. `operationByUser` varchar(255) DEFAULT NULL,
  13. PRIMARY KEY (`confirmorsId`) USING BTREE
  14. ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '绩效结果确认表'

achievement_employee_seg

  • 员工绩效考核项
  1. CREATE TABLE `achievement_employee_seg` (
  2. `id` int(11) DEFAULT NULL COMMENT '自增主键',
  3. `segId` int(11) NOT NULL AUTO_INCREMENT,
  4. `employeeAppraisalId` int(11) DEFAULT NULL,
  5. `tempSegId` int(11) DEFAULT '0' COMMENT '模板考核项id',
  6. `employeeId` int(11) DEFAULT NULL,
  7. `segName` varchar(50) DEFAULT NULL COMMENT '考核项名称',
  8. `value` varchar(255) DEFAULT NULL COMMENT '值',
  9. `isFixed` int(11) DEFAULT NULL COMMENT '是否固定 1 是 0 否',
  10. `weight` decimal(5, 2) DEFAULT NULL COMMENT '权重 -1 员工写权重比 0~100',
  11. `schedule` int(11) DEFAULT '0' COMMENT '目标进度',
  12. `explainDesc` varchar(1024) DEFAULT NULL COMMENT '完成情况说明',
  13. `sort` int(11) DEFAULT NULL,
  14. `operationByUserId` varchar(255) DEFAULT NULL,
  15. `operation` varchar(255) DEFAULT NULL,
  16. `operationByUser` varchar(255) DEFAULT NULL,
  17. `operationAt` varchar(255) DEFAULT NULL,
  18. PRIMARY KEY (`segId`) USING BTREE
  19. ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '员工绩效考核项'

achievement_employee_seg_item

  • 员工考核项选项
  1. CREATE TABLE `achievement_employee_seg_item` (
  2. `id` int(11) DEFAULT NULL COMMENT '自增主键',
  3. `itemId` int(11) NOT NULL AUTO_INCREMENT,
  4. `segId` int(11) DEFAULT NULL,
  5. `tempItemId` int(11) DEFAULT '0' COMMENT '模板考核项id',
  6. `itemName` varchar(50) DEFAULT NULL COMMENT '选项名称',
  7. `value` varchar(255) DEFAULT NULL COMMENT '值',
  8. `sort` int(11) DEFAULT NULL,
  9. `operation` varchar(255) DEFAULT NULL,
  10. `operationByUserId` varchar(255) DEFAULT NULL,
  11. `operationByUser` varchar(255) DEFAULT NULL,
  12. `operationAt` varchar(255) DEFAULT NULL,
  13. PRIMARY KEY (`itemId`) USING BTREE
  14. ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '员工考核项选项'

achievement_employee_target_confirm

  • 员工考核目标确认表
  1. CREATE TABLE `achievement_employee_target_confirm` (
  2. `id` int(11) DEFAULT NULL COMMENT '自增主键',
  3. `employeeConfirmId` int(11) NOT NULL AUTO_INCREMENT,
  4. `employeeAppraisalId` int(11) DEFAULT NULL COMMENT '员工端考核id',
  5. `appraisalId` int(11) DEFAULT NULL COMMENT '绩效id',
  6. `employeeId` int(11) NOT NULL COMMENT '确认人',
  7. `rejectReason` varchar(1024) DEFAULT NULL COMMENT '驳回原因',
  8. `createTime` datetime DEFAULT NULL,
  9. `updateTime` datetime DEFAULT NULL,
  10. `sort` int(11) DEFAULT NULL,
  11. `status` int(11) DEFAULT '0' COMMENT '0 待确认 1 已确认 2 驳回 ',
  12. `operation` varchar(255) DEFAULT NULL,
  13. `operationByUserId` varchar(255) DEFAULT NULL,
  14. `operationByUser` varchar(255) DEFAULT NULL,
  15. `operationAt` varchar(255) DEFAULT NULL,
  16. PRIMARY KEY (`employeeConfirmId`) USING BTREE
  17. ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '员工考核目标确认表'

achievement_seg

  • 绩效考核项模板
  1. CREATE TABLE `achievement_seg` (
  2. `id` int(11) DEFAULT NULL COMMENT '自增主键',
  3. `segId` int(11) NOT NULL AUTO_INCREMENT,
  4. `tableId` int(11) DEFAULT NULL,
  5. `segName` varchar(50) DEFAULT NULL COMMENT '考核项名称',
  6. `isFixed` int(11) DEFAULT NULL COMMENT '是否固定 1 是 0 否',
  7. `weight` decimal(5, 2) DEFAULT NULL COMMENT '权重 -1 员工写权重比 0~100',
  8. `sort` int(11) DEFAULT NULL,
  9. `operationByUserId` varchar(255) DEFAULT NULL,
  10. `operation` varchar(255) DEFAULT NULL,
  11. `operationByUser` varchar(255) DEFAULT NULL,
  12. `operationAt` varchar(255) DEFAULT NULL,
  13. PRIMARY KEY (`segId`) USING BTREE
  14. ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '绩效考核项模板'

achievement_seg_item

  • 考核项选项
  1. CREATE TABLE `achievement_seg_item` (
  2. `id` int(11) DEFAULT NULL COMMENT '自增主键',
  3. `itemId` int(11) NOT NULL AUTO_INCREMENT,
  4. `segId` int(11) DEFAULT NULL,
  5. `itemName` varchar(50) DEFAULT NULL COMMENT '选项名称',
  6. `sort` int(11) DEFAULT NULL,
  7. `operation` varchar(255) DEFAULT NULL,
  8. `operationByUser` varchar(255) DEFAULT NULL,
  9. `operationByUserId` varchar(255) DEFAULT NULL,
  10. `operationAt` varchar(255) DEFAULT NULL,
  11. PRIMARY KEY (`itemId`) USING BTREE
  12. ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '考核项选项'

achievement_table

  • 绩效考核表模板
  1. CREATE TABLE `achievement_table` (
  2. `id` int(11) DEFAULT NULL COMMENT '自增主键',
  3. `tableId` int(11) NOT NULL AUTO_INCREMENT,
  4. `tableName` varchar(50) DEFAULT NULL COMMENT '考核名称',
  5. `type` int(11) DEFAULT NULL COMMENT '1 OKR模板 2 KPI模板',
  6. `description` longtext COMMENT '考核表描述',
  7. `isEmpWeight` int(11) DEFAULT '0' COMMENT '是否员工填写权重 0 否 1 是',
  8. `status` int(11) DEFAULT '1' COMMENT ' 1 使用 0 删除',
  9. `createTime` datetime DEFAULT NULL,
  10. `createUserId` bigint(20) DEFAULT NULL,
  11. `operation` varchar(255) DEFAULT NULL,
  12. `operationByUserId` varchar(255) DEFAULT NULL,
  13. `operationByUser` varchar(255) DEFAULT NULL,
  14. `operationAt` varchar(255) DEFAULT NULL,
  15. PRIMARY KEY (`tableId`) USING BTREE
  16. ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '绩效考核表模板'

attendance_clock

  • 打卡记录表
  1. CREATE TABLE `attendance_clock` (
  2. `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增主键',
  3. `clockId` varchar(255) NOT NULL COMMENT '打卡记录id',
  4. `clockEmployeeId` varchar(255) DEFAULT NULL,
  5. `clockTime` varchar(255) NOT NULL COMMENT '打卡时间',
  6. `clockType` int(11) NOT NULL COMMENT '打卡类型 1 上班打卡 2 下班打卡',
  7. `attendanceTime` varchar(255) NOT NULL COMMENT '上班日期',
  8. `type` int(11) NOT NULL DEFAULT '1' COMMENT '打卡类型 1手机端打卡 2手工录入',
  9. `address` varchar(255) NOT NULL COMMENT '考勤地址',
  10. `lng` varchar(50) DEFAULT NULL COMMENT '精度',
  11. `lat` varchar(50) DEFAULT NULL COMMENT '维度',
  12. `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  13. `operationByUserId` varchar(255) DEFAULT NULL,
  14. `operation` varchar(255) DEFAULT NULL,
  15. `operationByUser` varchar(255) DEFAULT NULL,
  16. `operationAt` varchar(255) DEFAULT NULL,
  17. PRIMARY KEY (`id`) USING BTREE
  18. ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '打卡记录表'

employee

  1. CREATE TABLE `employee` (
  2. `id` int(11) NOT NULL AUTO_INCREMENT,
  3. `employeeId` varchar(255) DEFAULT NULL COMMENT '员工id',
  4. `employeeName` varchar(255) DEFAULT NULL COMMENT '员工姓名',
  5. `idSequence` int(11) DEFAULT NULL COMMENT '员工序号',
  6. `sex` varchar(255) DEFAULT NULL COMMENT '员工性别',
  7. `age` int(11) DEFAULT NULL COMMENT '员工年龄',
  8. `contactNumber` varchar(255) DEFAULT NULL COMMENT '联系电话',
  9. `emergencyContactNumber` varchar(255) DEFAULT NULL COMMENT '紧急联系电话',
  10. `post` varchar(255) DEFAULT NULL COMMENT '岗位1',
  11. `post2` varchar(255) DEFAULT NULL COMMENT '岗位2',
  12. `post3` varchar(255) DEFAULT NULL COMMENT '岗位3',
  13. `politicalBackground` varchar(255) DEFAULT NULL COMMENT '政治面貌',
  14. `icNumber` varchar(255) DEFAULT NULL COMMENT '身份证号码',
  15. `dateOfBirth` varchar(255) DEFAULT NULL COMMENT '出生日期',
  16. `institution` varchar(255) DEFAULT NULL COMMENT '毕业学校',
  17. `major` varchar(255) DEFAULT NULL COMMENT '专业',
  18. `highestEducation` varchar(255) DEFAULT NULL COMMENT '学历层次',
  19. `teacherQualification` varchar(255) DEFAULT NULL COMMENT '教师资格证类别',
  20. `teacherQualificationLeaver` varchar(255) DEFAULT NULL COMMENT '教师资格证学段',
  21. `teacherQualificationSubject` varchar(255) DEFAULT NULL COMMENT '教师资格证学科',
  22. `teacherCertificationNumber` varchar(255) DEFAULT NULL COMMENT '教师资格证编号',
  23. `teachingLevel` varchar(255) DEFAULT NULL COMMENT '任教学段',
  24. `teachingSubject` varchar(255) DEFAULT NULL COMMENT '任教学科',
  25. `residentialAddress` varchar(255) DEFAULT NULL COMMENT '家庭地址',
  26. `province` varchar(255) DEFAULT NULL COMMENT '省',
  27. `city` varchar(255) DEFAULT NULL COMMENT '市',
  28. `county` varchar(255) DEFAULT NULL COMMENT '县',
  29. `operationAt` varchar(255) DEFAULT NULL,
  30. `dateOfEntry` varchar(255) DEFAULT NULL COMMENT '入职',
  31. `dateOfContractExpiration` varchar(255) DEFAULT NULL COMMENT '到期',
  32. `leaveRequestStatus` varchar(255) DEFAULT NULL COMMENT '申请离职状态',
  33. `cardNumber` varchar(255) DEFAULT NULL COMMENT '建设银行卡卡号',
  34. `licensePlateNumber` varchar(255) DEFAULT NULL COMMENT '车牌号',
  35. `employmentForms` varchar(255) DEFAULT NULL COMMENT '聘用形式',
  36. `probationPeriod` varchar(255) DEFAULT NULL COMMENT '试用期',
  37. `entryStatus` varchar(255) DEFAULT NULL COMMENT '在职状态',
  38. `status` varchar(255) DEFAULT NULL COMMENT '员工状态',
  39. `remarks` varchar(255) DEFAULT NULL COMMENT '备注',
  40. `contactPerson` varchar(255) DEFAULT NULL COMMENT '联系人',
  41. `educationExperience` varchar(255) DEFAULT NULL COMMENT '教育经历',
  42. `certificate` varchar(255) DEFAULT NULL COMMENT '证书',
  43. `salaryCard` varchar(255) DEFAULT NULL COMMENT '薪资卡信息',
  44. `socialSecurity` varchar(255) DEFAULT NULL COMMENT '社保卡信息',
  45. `trainingExperience` varchar(255) DEFAULT NULL COMMENT '培训经历',
  46. `workExperience` varchar(255) DEFAULT NULL COMMENT '工作经历',
  47. `operation` varchar(255) DEFAULT NULL,
  48. `operationByUserId` varchar(255) DEFAULT NULL,
  49. `operationByUser` varchar(255) DEFAULT NULL,
  50. PRIMARY KEY (`id`) USING BTREE
  51. ) ENGINE = InnoDB AUTO_INCREMENT = 646 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin

employee_contract

  • 员工合同
  1. CREATE TABLE `employee_contract` (
  2. `id` int(11) DEFAULT NULL COMMENT '自增主键',
  3. `contractId` int(11) NOT NULL AUTO_INCREMENT,
  4. `employeeId` int(11) NOT NULL,
  5. `contractNum` varchar(40) DEFAULT NULL COMMENT '合同编号',
  6. `contractType` int(11) DEFAULT NULL COMMENT '1、固定期限劳动合同 2、无固定期限劳动合同 3、已完成一定工作任务为期限的劳动合同 4、实习协议 5、劳务合同 6、返聘协议 7、劳务派遣合同 8、借调合同 9、其他',
  7. `startTime` datetime DEFAULT NULL,
  8. `endTime` datetime DEFAULT NULL,
  9. `term` int(11) DEFAULT NULL COMMENT '期限',
  10. `status` int(11) DEFAULT NULL COMMENT '合同状态 0未执行 1 执行中、 2已到期、 ',
  11. `signCompany` varchar(255) DEFAULT NULL COMMENT '签约公司',
  12. `signTime` datetime DEFAULT NULL COMMENT '合同签订日期',
  13. `remarks` varchar(255) DEFAULT NULL COMMENT '备注',
  14. `isExpireRemind` int(11) DEFAULT NULL COMMENT '是否到期提醒 0 否 1 是',
  15. `sort` int(11) DEFAULT NULL,
  16. `createTime` datetime DEFAULT NULL,
  17. `createUserId` bigint(20) DEFAULT NULL,
  18. `batchId` varchar(32) DEFAULT NULL,
  19. `operationByUserId` varchar(255) DEFAULT NULL,
  20. `operation` varchar(255) DEFAULT NULL,
  21. `operationByUser` varchar(255) DEFAULT NULL,
  22. `operationAt` varchar(255) DEFAULT NULL,
  23. PRIMARY KEY (`contractId`) USING BTREE
  24. ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '员工合同'

employee_file

  • 员工附件表
  1. CREATE TABLE `employee_file` (
  2. `id` int(11) DEFAULT NULL COMMENT '自增主键',
  3. `employeeFileId` int(11) NOT NULL AUTO_INCREMENT,
  4. `employeeId` int(11) NOT NULL COMMENT '员工id',
  5. `fileId` bigint(20) NOT NULL COMMENT 'admin模块附件id',
  6. `type` int(11) DEFAULT NULL COMMENT '1 员工基本资料 2 员工档案资料 3 员工离职资料',
  7. `subType` int(11) NOT NULL COMMENT '11、身份证原件 12、学历证明 13、个人证件照 14、身份证复印件 15、工资银行卡 16、社保卡 17、公积金卡 18、获奖证书 19、其他 21、劳动合同 22、入职简历 23、入职登记表 24、入职体检单 25、离职证明 26、转正申请表 27、其他\n31、离职审批 32、离职证明 33 、其他\n',
  8. `createUserId` bigint(20) DEFAULT NULL,
  9. `createTime` datetime DEFAULT NULL COMMENT '创建时间',
  10. `operationByUserId` varchar(255) DEFAULT NULL,
  11. `operation` varchar(255) DEFAULT NULL,
  12. `operationByUser` varchar(255) DEFAULT NULL,
  13. `operationAt` varchar(255) DEFAULT NULL,
  14. PRIMARY KEY (`employeeFileId`) USING BTREE
  15. ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '员工附件表'

employee_quit_info

  • 离职信息
  1. CREATE TABLE `employee_quit_info` (
  2. `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增主键',
  3. `quitInfoId` varchar(100) NOT NULL,
  4. `employeeId` varchar(100) DEFAULT NULL,
  5. `planQuitTime` datetime DEFAULT NULL COMMENT '计划离职日期',
  6. `applyQuitTime` datetime DEFAULT NULL COMMENT '申请离职日期',
  7. `salarySettlementTime` datetime DEFAULT NULL COMMENT '薪资结算日期',
  8. `quitType` int(11) DEFAULT NULL COMMENT '离职类型 1 主动离职 2 被动离职 3 退休',
  9. `quitReason` int(11) DEFAULT NULL COMMENT '离职原因 1家庭原因 2身体原因 3薪资原因 4交通不便 5工作压力 6管理问题 7无晋升机会 8职业规划 9合同到期放弃续签 10其他个人原因 11试用期内辞退 12违反公司条例 13组织调整/裁员 14绩效不达标辞退 15合同到期不续签 16 其他原因被动离职',
  10. `remarks` varchar(255) DEFAULT NULL COMMENT '备注',
  11. `oldStatus` int(11) DEFAULT NULL COMMENT '离职前状态',
  12. `createTime` datetime DEFAULT NULL,
  13. `operation` varchar(255) DEFAULT NULL,
  14. `operationByUserId` varchar(255) DEFAULT NULL,
  15. `operationAt` varchar(255) DEFAULT NULL,
  16. `operationByUser` varchar(255) DEFAULT NULL,
  17. PRIMARY KEY (`id`) USING BTREE
  18. ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '离职信息'

employee_request

  1. CREATE TABLE `employee_request` (
  2. `id` int(11) NOT NULL AUTO_INCREMENT,
  3. `employeeId` varchar(255) DEFAULT NULL COMMENT '员工编号',
  4. `employeeName` varchar(255) DEFAULT NULL COMMENT '员工姓名',
  5. `sex` varchar(255) DEFAULT NULL COMMENT '员工性别',
  6. `age` varchar(255) DEFAULT NULL COMMENT '员工年龄',
  7. `contactNumber` varchar(255) DEFAULT NULL COMMENT '联系电话',
  8. `icNumber` varchar(255) DEFAULT NULL COMMENT '身份证号',
  9. `post` varchar(255) DEFAULT NULL COMMENT '员工岗位',
  10. `teachingLevel` varchar(255) DEFAULT NULL COMMENT '任教学段',
  11. `teachingSubject` varchar(255) DEFAULT NULL COMMENT '任教学科',
  12. `status` varchar(255) DEFAULT NULL COMMENT '员工状态',
  13. `employmentForms` varchar(255) DEFAULT NULL COMMENT '聘用形式',
  14. `entryStatus` varchar(255) DEFAULT NULL COMMENT '入职状态',
  15. `dateOfEntry` varchar(255) DEFAULT NULL COMMENT '入职日期',
  16. `dateOfContractExpiration` varchar(255) DEFAULT NULL COMMENT '到期日期',
  17. `leaveRequestStatus` varchar(255) DEFAULT NULL COMMENT '申请离职状态',
  18. `remarks` varchar(255) DEFAULT NULL COMMENT '备注',
  19. `operation` varchar(255) DEFAULT NULL,
  20. `operationByUserId` varchar(255) DEFAULT NULL,
  21. `operationByUser` varchar(255) DEFAULT NULL,
  22. `operationAt` varchar(255) DEFAULT NULL,
  23. PRIMARY KEY (`id`) USING BTREE
  24. ) ENGINE = InnoDB AUTO_INCREMENT = 24 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin

insurance_month_emp_record

  • 员工每月社保记录
  1. CREATE TABLE `insurance_month_emp_record` (
  2. `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增主键',
  3. `iEmpRecordId` varchar(100) NOT NULL,
  4. `iRecordId` varchar(100) DEFAULT NULL COMMENT '每月生成社保id',
  5. `employeeId` varchar(100) DEFAULT NULL COMMENT '员工id',
  6. `schemeId` varchar(100) DEFAULT NULL COMMENT '社保方案id',
  7. `year` int(11) DEFAULT NULL COMMENT '年',
  8. `month` int(11) DEFAULT NULL COMMENT '月',
  9. `personalInsuranceAmount` decimal(10, 2) DEFAULT NULL COMMENT '个人社保金额',
  10. `personalProvidentFundAmount` decimal(10, 2) DEFAULT NULL COMMENT '个人公积金金额',
  11. `corporateInsuranceAmount` decimal(10, 2) DEFAULT NULL COMMENT '公司社保金额',
  12. `corporateProvidentFundAmount` decimal(10, 2) DEFAULT NULL COMMENT '公司社保金额',
  13. `optionList` text COMMENT '明细列表',
  14. `createTime` datetime DEFAULT NULL,
  15. `status` int(11) DEFAULT '1' COMMENT '每月社保状态 0 停保 1 正常',
  16. `operation` varchar(255) DEFAULT NULL,
  17. `operationByUserId` varchar(255) DEFAULT NULL,
  18. `operationByUser` varchar(255) DEFAULT NULL,
  19. `operationAt` varchar(255) DEFAULT NULL,
  20. PRIMARY KEY (`id`) USING BTREE
  21. ) ENGINE = InnoDB AUTO_INCREMENT = 74 DEFAULT CHARSET = utf8mb4 COMMENT = '员工每月社保记录'

insurance_month_record

  • 每月社保记录
  1. CREATE TABLE `insurance_month_record` (
  2. `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增主键',
  3. `iRecordId` varchar(100) NOT NULL,
  4. `title` varchar(40) DEFAULT NULL COMMENT '报表名称',
  5. `year` int(11) DEFAULT NULL COMMENT '年份',
  6. `month` int(11) DEFAULT NULL COMMENT '月份',
  7. `status` int(11) DEFAULT '0' COMMENT '每月社保状态 0 未归档 1 已归档',
  8. `createTime` datetime DEFAULT NULL,
  9. `operation` varchar(255) DEFAULT NULL,
  10. `operationAt` varchar(255) DEFAULT NULL,
  11. `operationByUser` varchar(255) DEFAULT NULL,
  12. `operationByUserId` varchar(255) DEFAULT NULL,
  13. PRIMARY KEY (`id`) USING BTREE
  14. ) ENGINE = InnoDB AUTO_INCREMENT = 68 DEFAULT CHARSET = utf8mb4 COMMENT = '每月社保记录'

insurance_scheme

  • 社保方案表
  1. CREATE TABLE `insurance_scheme` (
  2. `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增主键',
  3. `schemeId` varchar(100) DEFAULT NULL COMMENT '社保方案id',
  4. `schemeName` varchar(40) DEFAULT NULL COMMENT '方案名称',
  5. `city` varchar(40) DEFAULT NULL COMMENT '参保城市',
  6. `houseType` varchar(50) DEFAULT NULL COMMENT '户籍类型',
  7. `schemeType` int(11) DEFAULT NULL COMMENT '参保类型 1 比例 2 金额',
  8. `projectList` text COMMENT '社保明细项',
  9. `isDel` int(11) DEFAULT '0' COMMENT '1 删除 0 使用',
  10. `createUserId` varchar(255) DEFAULT NULL COMMENT '创建人id',
  11. `createTime` varchar(255) DEFAULT NULL COMMENT '创建时间',
  12. `operation` varchar(255) DEFAULT NULL,
  13. `operationByUserId` varchar(255) DEFAULT NULL,
  14. `operationAt` varchar(255) DEFAULT NULL,
  15. `operationByUser` varchar(255) DEFAULT NULL,
  16. PRIMARY KEY (`id`) USING BTREE
  17. ) ENGINE = InnoDB AUTO_INCREMENT = 5 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '社保方案表'

job_postings

  • 招聘职位表
  1. CREATE TABLE `job_postings` (
  2. `id` int(11) NOT NULL AUTO_INCREMENT,
  3. `jobId` varchar(255) DEFAULT NULL COMMENT '职位ID',
  4. `recruitmentType` varchar(255) DEFAULT NULL COMMENT '招聘渠道:campus-校园招聘 | social-社会招聘 | internship-实习生',
  5. `jobTitle` varchar(255) DEFAULT NULL COMMENT '职位名称',
  6. `employmentType` varchar(20) DEFAULT NULL COMMENT '职位类型:full-全职 | part-兼职',
  7. `address` varchar(255) DEFAULT NULL COMMENT '地址',
  8. `headcount` varchar(255) DEFAULT NULL COMMENT '招聘人数',
  9. `company` varchar(255) DEFAULT NULL COMMENT '招聘公司',
  10. `publishStatus` varchar(255) DEFAULT NULL COMMENT '招聘状态',
  11. `publishTime` varchar(255) DEFAULT NULL COMMENT '发布时间',
  12. `responsibilities` text COMMENT '工作职责',
  13. `requirements` text COMMENT '工作要求顺序 list',
  14. `operation` varchar(255) DEFAULT 'insert' COMMENT '操作; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  15. `operationByUserId` varchar(255) DEFAULT NULL COMMENT '操作者userId',
  16. `operationByUser` varchar(255) DEFAULT NULL COMMENT '操作者用户名',
  17. `operationAt` varchar(255) DEFAULT NULL COMMENT '操作时间; E.g: 2021-05-28T10:24:54+08:00 ',
  18. PRIMARY KEY (`id`) USING BTREE
  19. ) ENGINE = InnoDB AUTO_INCREMENT = 7 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '招聘职位表'

job_resume

  • 简历投递信息表
  1. CREATE TABLE `job_resume` (
  2. `id` int(11) NOT NULL AUTO_INCREMENT,
  3. `jobId` varchar(255) DEFAULT NULL,
  4. `jobTitle` varchar(255) DEFAULT NULL,
  5. `jobResumeId` varchar(255) DEFAULT NULL COMMENT '简历ID',
  6. `employeeId` varchar(255) DEFAULT NULL,
  7. `user` varchar(255) DEFAULT NULL COMMENT '姓名',
  8. `gender` varchar(50) DEFAULT NULL COMMENT '性别',
  9. `age` varchar(50) DEFAULT NULL COMMENT '年龄',
  10. `ethnicity` varchar(50) DEFAULT NULL COMMENT '民族',
  11. `height` varchar(50) DEFAULT NULL COMMENT '身高',
  12. `weight` varchar(50) DEFAULT NULL COMMENT '体重',
  13. `bloodType` varchar(50) DEFAULT NULL COMMENT '血型',
  14. `maritalStatus` varchar(50) DEFAULT NULL COMMENT '婚姻状况',
  15. `politicalAffiliation` varchar(50) DEFAULT NULL COMMENT '政治面貌',
  16. `physicalCondition` varchar(255) DEFAULT NULL COMMENT '身体状况',
  17. `religiousBeliefs` varchar(255) DEFAULT NULL COMMENT '宗教信仰',
  18. `phoneNumber` varchar(255) DEFAULT NULL COMMENT '手机号码',
  19. `IDNumber` varchar(255) DEFAULT NULL COMMENT '身份证号',
  20. `email` varchar(255) DEFAULT NULL COMMENT '邮箱',
  21. `highestEducation` varchar(255) DEFAULT NULL COMMENT '最高学历',
  22. `wechatID` varchar(255) DEFAULT NULL COMMENT '微信',
  23. `nativePlace` varchar(255) DEFAULT NULL COMMENT '籍贯',
  24. `homeAddress` varchar(255) DEFAULT NULL COMMENT '家庭住址',
  25. `currentAddress` varchar(255) DEFAULT NULL COMMENT '现住址',
  26. `academicRanking` varchar(255) DEFAULT NULL COMMENT '专业成绩排名',
  27. `workplace` varchar(255) DEFAULT NULL COMMENT '意向工作地',
  28. `salaryExpectation` varchar(255) DEFAULT NULL COMMENT '薪资期望',
  29. `domicilePlace` varchar(255) DEFAULT NULL COMMENT '户口所在地',
  30. `earliestAvailability` varchar(255) DEFAULT NULL COMMENT '最快可到岗日期',
  31. `education` text COMMENT '教育经历 json',
  32. `educationCertificate` varchar(255) DEFAULT NULL COMMENT '教育职称/资格证书',
  33. `experience` text COMMENT '工作经历 json',
  34. `familyMember` text COMMENT '家庭成员 json',
  35. `teacherContact` text COMMENT '教师证明',
  36. `studentSocialization` varchar(255) DEFAULT NULL COMMENT '在校社交',
  37. `socialActivities` text COMMENT '社交活动',
  38. `achievement` varchar(500) DEFAULT NULL COMMENT '工作成就',
  39. `socialHobbies` varchar(255) DEFAULT NULL COMMENT '社交爱好',
  40. `personality` varchar(255) DEFAULT NULL COMMENT '个人特点',
  41. `careerPlanning` varchar(255) DEFAULT NULL COMMENT '职业规划',
  42. `offence` varchar(255) DEFAULT NULL COMMENT '是否有违反法纪、解雇等',
  43. `resumeStatus` varchar(255) DEFAULT NULL COMMENT '状态:new-新候选 | passedInitialScreening\nscheduledInterview\npassedInterview\noffer\npending rejected\nhired',
  44. `fileAttachmentList` varchar(255) DEFAULT NULL,
  45. `operation` varchar(255) DEFAULT 'insert' COMMENT '操作; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  46. `operationByUserId` varchar(255) DEFAULT NULL COMMENT '操作者userId',
  47. `operationByUser` varchar(255) DEFAULT NULL COMMENT '操作者用户名',
  48. `operationAt` varchar(255) DEFAULT NULL COMMENT '操作时间; E.g: 2021-05-28T10:24:54+08:00 ',
  49. PRIMARY KEY (`id`) USING BTREE
  50. ) ENGINE = InnoDB AUTO_INCREMENT = 23 DEFAULT CHARSET = utf8mb4 COMMENT = '简历投递信息表'

member_org_role

  • 组织员工表
  1. CREATE TABLE `member_org_role` (
  2. `id` int(11) NOT NULL AUTO_INCREMENT,
  3. `orgId` varchar(255) DEFAULT NULL COMMENT '组织Id;',
  4. `memberId` varchar(255) DEFAULT NULL COMMENT '职员Id;',
  5. `roleId` varchar(255) DEFAULT NULL COMMENT '角色Id; 负责人、成员',
  6. `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  7. `operation` varchar(255) DEFAULT 'insert' COMMENT '操作; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  8. `operationByUserId` varchar(255) DEFAULT NULL COMMENT '操作者userId',
  9. `operationByUser` varchar(255) DEFAULT NULL COMMENT '操作者用户名',
  10. `operationAt` varchar(255) DEFAULT NULL COMMENT '操作时间; E.g: 2021-05-28T10:24:54+08:00 ',
  11. PRIMARY KEY (`id`) USING BTREE,
  12. UNIQUE KEY `orgId_memberId_roleId_index` (`orgId`, `memberId`, `roleId`) USING BTREE
  13. ) ENGINE = InnoDB AUTO_INCREMENT = 101 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '组织员工表'

notes

  • 备忘
  1. CREATE TABLE `notes` (
  2. `notesId` int(11) NOT NULL AUTO_INCREMENT,
  3. `content` varchar(1024) NOT NULL,
  4. `employeeId` int(11) DEFAULT NULL,
  5. `reminderTime` datetime NOT NULL,
  6. `createTime` datetime DEFAULT NULL,
  7. `createUserId` bigint(20) NOT NULL,
  8. `operation` varchar(255) DEFAULT NULL,
  9. `id` int(11) DEFAULT NULL,
  10. `operationByUserId` varchar(255) DEFAULT NULL,
  11. `operationAt` varchar(255) DEFAULT NULL,
  12. `operationByUser` varchar(255) DEFAULT NULL,
  13. PRIMARY KEY (`notesId`) USING BTREE,
  14. KEY `wk_hrm_notes_employee_id_index` (`employeeId`) USING BTREE
  15. ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '备忘'

org

  • 组织表
  1. CREATE TABLE `org` (
  2. `id` int(11) NOT NULL AUTO_INCREMENT,
  3. `orgId` varchar(255) DEFAULT NULL COMMENT '组织Id; 路径法生成 01-03-01-11',
  4. `orgParentId` varchar(255) DEFAULT NULL COMMENT '组织父结点id',
  5. `orgName` varchar(255) DEFAULT NULL COMMENT '组织名',
  6. `orgNumber` varchar(255) DEFAULT NULL COMMENT 'org编号',
  7. `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  8. `operation` varchar(255) DEFAULT 'insert' COMMENT '操作; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  9. `operationByUserId` varchar(255) DEFAULT NULL COMMENT '操作者userId',
  10. `operationByUser` varchar(255) DEFAULT NULL COMMENT '操作者用户名',
  11. `operationAt` varchar(255) DEFAULT NULL COMMENT '操作时间; E.g: 2021-05-28T10:24:54+08:00 ',
  12. PRIMARY KEY (`id`) USING BTREE
  13. ) ENGINE = InnoDB AUTO_INCREMENT = 31 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '组织表'

performance

  1. CREATE TABLE `performance` (
  2. `id` int(11) NOT NULL AUTO_INCREMENT,
  3. `performanceId` varchar(255) NOT NULL,
  4. `performanceName` varchar(255) DEFAULT NULL COMMENT '考核名称',
  5. `performanceCycle` varchar(255) DEFAULT NULL COMMENT '考核周期',
  6. `templateId` varchar(255) DEFAULT NULL COMMENT '考核模板',
  7. `templateType` varchar(255) DEFAULT NULL COMMENT '模板类型',
  8. `performanceContent` text COMMENT '考核内容',
  9. `actualTargetData` varchar(255) DEFAULT NULL COMMENT '实际指标',
  10. `startTime` varchar(255) DEFAULT NULL COMMENT '考核开始时间',
  11. `endTime` varchar(255) DEFAULT NULL COMMENT '考核结束时间',
  12. `target` varchar(255) DEFAULT NULL COMMENT '考核目标',
  13. `employeeId` varchar(255) DEFAULT NULL COMMENT '考核员工Id',
  14. `employeeName` varchar(255) DEFAULT NULL COMMENT '考核员工名称',
  15. `raterId` varchar(255) DEFAULT NULL COMMENT '考核评分人Id',
  16. `raterName` varchar(255) DEFAULT NULL COMMENT '考核评分人名称',
  17. `status` varchar(255) DEFAULT NULL COMMENT '考核状态',
  18. `remarks` varchar(255) DEFAULT NULL COMMENT '备注',
  19. `operation` varchar(255) DEFAULT NULL,
  20. `operationByUserId` varchar(255) DEFAULT NULL,
  21. `operationByUser` varchar(255) DEFAULT NULL,
  22. `operationAt` varchar(255) DEFAULT NULL,
  23. PRIMARY KEY (`id`, `performanceId`) USING BTREE
  24. ) ENGINE = InnoDB AUTO_INCREMENT = 23 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin

performance_employee_rate

  1. CREATE TABLE `performance_employee_rate` (
  2. `id` int(11) NOT NULL AUTO_INCREMENT,
  3. `performanceId` varchar(255) DEFAULT NULL,
  4. `performanceName` varchar(255) DEFAULT NULL COMMENT '考核名称',
  5. `performanceContent` text COMMENT '考核内容',
  6. `performanceCycle` varchar(255) DEFAULT NULL COMMENT '考核周期',
  7. `templateType` varchar(255) DEFAULT NULL COMMENT '考核模板类型',
  8. `startTime` varchar(255) DEFAULT NULL COMMENT '考核开始时间',
  9. `endTime` varchar(255) DEFAULT NULL COMMENT '考核结束时间',
  10. `actualTargetData` varchar(255) DEFAULT NULL COMMENT '实际指标',
  11. `target` varchar(255) DEFAULT NULL COMMENT '主体目标组织',
  12. `employeeId` varchar(255) DEFAULT NULL COMMENT '考核员工Id',
  13. `employeeName` varchar(255) DEFAULT NULL COMMENT '考核员工名称',
  14. `raterId` varchar(255) DEFAULT NULL COMMENT '考核评分人Id',
  15. `raterName` varchar(255) DEFAULT NULL COMMENT '考核评分人名称',
  16. `gradePerformance` varchar(255) DEFAULT NULL COMMENT '指标评分',
  17. `status` varchar(255) DEFAULT NULL COMMENT '考核状态',
  18. `remarks` varchar(255) DEFAULT NULL COMMENT '备注',
  19. `operation` varchar(255) DEFAULT NULL,
  20. `operationByUserId` varchar(255) DEFAULT NULL,
  21. `operationByUser` varchar(255) DEFAULT NULL,
  22. `operationAt` varchar(255) DEFAULT NULL,
  23. PRIMARY KEY (`id`) USING BTREE
  24. ) ENGINE = InnoDB AUTO_INCREMENT = 24 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin

performance_result

  1. CREATE TABLE `performance_result` (
  2. `id` int(11) NOT NULL AUTO_INCREMENT,
  3. `performanceId` varchar(255) DEFAULT NULL COMMENT '考核内容',
  4. `performanceName` varchar(255) DEFAULT NULL,
  5. `startTime` datetime DEFAULT NULL,
  6. `endTime` datetime DEFAULT NULL,
  7. `employeeId` varchar(255) DEFAULT NULL,
  8. `target` varchar(255) DEFAULT NULL,
  9. `templateType` varchar(255) DEFAULT NULL,
  10. `employeeName` varchar(255) DEFAULT NULL,
  11. `actualTargetData` varchar(255) DEFAULT NULL,
  12. `raterId` varchar(255) DEFAULT NULL,
  13. `raterName` varchar(255) DEFAULT NULL,
  14. `gradePerformance` varchar(255) DEFAULT NULL,
  15. `status` varchar(255) DEFAULT NULL,
  16. `operation` varchar(255) DEFAULT NULL,
  17. `operationByUserId` varchar(255) DEFAULT NULL,
  18. `operationByUser` varchar(255) DEFAULT NULL,
  19. `operationAt` varchar(255) DEFAULT NULL,
  20. PRIMARY KEY (`id`) USING BTREE
  21. ) ENGINE = InnoDB AUTO_INCREMENT = 14 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin

performance_tmp

  1. CREATE TABLE `performance_tmp` (
  2. `id` int(11) NOT NULL AUTO_INCREMENT,
  3. `templateId` varchar(255) NOT NULL,
  4. `templateName` varchar(255) DEFAULT NULL COMMENT '模板名称',
  5. `templateContent` text COMMENT '考核内容',
  6. `templateType` varchar(255) DEFAULT NULL COMMENT '类型:person | ohter',
  7. `status` varchar(255) DEFAULT NULL COMMENT '考核状态',
  8. `remarks` varchar(255) DEFAULT NULL COMMENT '备注',
  9. `operation` varchar(255) DEFAULT NULL,
  10. `operationByUserId` varchar(255) DEFAULT NULL,
  11. `operationByUser` varchar(255) DEFAULT NULL,
  12. `operationAt` varchar(255) DEFAULT NULL,
  13. PRIMARY KEY (`id`, `templateId`) USING BTREE
  14. ) ENGINE = InnoDB AUTO_INCREMENT = 23 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin

salary_archives

  • 薪资档案表
  1. CREATE TABLE `salary_archives` (
  2. `id` int(11) NOT NULL AUTO_INCREMENT,
  3. `changeReason` int(11) NOT NULL COMMENT '调薪原因 1 入职核定 2 转正 3 晋升 4 调动 5 年中调薪 6 年度调薪 7 特别调薪 8 其他',
  4. `changeDate` date NOT NULL COMMENT '最近调整日期',
  5. `employeeId` varchar(255) NOT NULL COMMENT '员工id',
  6. `changeType` varchar(255) DEFAULT '0' COMMENT '0 未定薪 1 已定薪 2 已调薪',
  7. `remarks` varchar(255) NOT NULL DEFAULT '' COMMENT '备注',
  8. `operation` varchar(255) DEFAULT NULL,
  9. `operationByUserId` varchar(255) DEFAULT NULL,
  10. `operationByUser` varchar(255) DEFAULT NULL,
  11. `operationAt` varchar(255) DEFAULT NULL,
  12. PRIMARY KEY (`id`) USING BTREE,
  13. KEY `salary_archives_change_reason_index` (`changeReason`) USING BTREE,
  14. KEY `salary_archives_employee_id_index` (`employeeId`) USING BTREE
  15. ) ENGINE = InnoDB AUTO_INCREMENT = 67 DEFAULT CHARSET = utf8mb4 COMMENT = '薪资档案表'

salary_archives_option

  1. CREATE TABLE `salary_archives_option` (
  2. `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增主键',
  3. `employeeId` varchar(255) NOT NULL COMMENT '员工id',
  4. `isPro` int(11) NOT NULL COMMENT '是否是试用期 0 正式 1 试用期',
  5. `code` int(11) NOT NULL COMMENT '薪资项code',
  6. `name` varchar(20) NOT NULL COMMENT '薪资项名称',
  7. `value` varchar(20) NOT NULL COMMENT '薪资',
  8. `operation` varchar(255) DEFAULT NULL,
  9. `operationByUserId` varchar(255) DEFAULT NULL,
  10. `operationByUser` varchar(255) DEFAULT NULL,
  11. `operationAt` varchar(255) DEFAULT NULL,
  12. PRIMARY KEY (`id`) USING BTREE,
  13. KEY `salary_archives_option_employee_id_index` (`employeeId`) USING BTREE,
  14. KEY `salary_archives_option_is_pro_index` (`isPro`) USING BTREE
  15. ) ENGINE = InnoDB AUTO_INCREMENT = 151 DEFAULT CHARSET = utf8mb4

salary_change_record

  • 定薪调薪记录表
  1. CREATE TABLE `salary_change_record` (
  2. `id` int(11) NOT NULL AUTO_INCREMENT,
  3. `employeeId` varchar(255) NOT NULL COMMENT '员工id',
  4. `recordType` int(11) NOT NULL DEFAULT '1' COMMENT '记录类型 1 定薪 2 调薪',
  5. `changeReason` int(11) NOT NULL COMMENT '调薪原因 1 入职核定 2 转正 3 晋升 4 调动 5 年中调薪 6 年度调薪 7 特别调薪 8 其他',
  6. `enableDate` date NOT NULL COMMENT '生效时间',
  7. `proBeforeSum` varchar(20) NOT NULL DEFAULT '0' COMMENT '试用期调整前工资',
  8. `proAfterSum` varchar(20) NOT NULL DEFAULT '0' COMMENT '试用期调整后工资',
  9. `proSalary` varchar(4096) NOT NULL DEFAULT '' COMMENT '试用期工资明细',
  10. `beforeSum` varchar(20) NOT NULL DEFAULT '0' COMMENT '正式调整前工资 json',
  11. `afterSum` varchar(20) NOT NULL DEFAULT '0' COMMENT '正式调整后工资',
  12. `salary` varchar(4096) NOT NULL DEFAULT '' COMMENT '正式工资明细 json',
  13. `status` varchar(255) NOT NULL DEFAULT '0' COMMENT '状态 0 未生效 1 已生效 2 已取消',
  14. `employeeStatus` varchar(255) DEFAULT NULL,
  15. `beforeTotal` varchar(20) NOT NULL DEFAULT '0' COMMENT '调整前总薪资',
  16. `afterTotal` varchar(20) NOT NULL DEFAULT '0' COMMENT '调整后总薪资',
  17. `remarks` varchar(255) NOT NULL DEFAULT '' COMMENT '备注',
  18. `createTime` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  19. `createUserId` varchar(255) NOT NULL,
  20. `operation` varchar(255) DEFAULT NULL,
  21. `operationByUserId` varchar(255) DEFAULT NULL,
  22. `operationByUser` varchar(255) DEFAULT NULL,
  23. `operationAt` varchar(255) DEFAULT NULL,
  24. PRIMARY KEY (`id`) USING BTREE,
  25. KEY `salary_change_record_employee_id_index` (`employeeId`) USING BTREE,
  26. KEY `salary_change_record_status_index` (`status`) USING BTREE
  27. ) ENGINE = InnoDB AUTO_INCREMENT = 17 DEFAULT CHARSET = utf8mb4 COMMENT = '定薪调薪记录表'

salary_config

  • 薪资初始配置
  1. CREATE TABLE `salary_config` (
  2. `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增主键',
  3. `configId` varchar(255) NOT NULL,
  4. `salaryCycleStartDay` int(11) DEFAULT NULL COMMENT '计薪周期开始日',
  5. `salaryCycleEndDay` int(11) DEFAULT NULL COMMENT '计薪周期结束日',
  6. `payType` int(11) DEFAULT NULL COMMENT '发薪日期类型 1 当月 2 次月',
  7. `payDay` int(11) DEFAULT NULL COMMENT '发薪日期',
  8. `socialSecurityMonthType` int(11) DEFAULT NULL COMMENT '对应社保自然月 0上月 1当月 2次月',
  9. `salaryStartMonth` varchar(20) DEFAULT NULL COMMENT '薪酬起始月份(例2020.05)',
  10. `socialSecurityStartMonth` varchar(20) DEFAULT NULL COMMENT '社保开始月(例2020.05)',
  11. `operation` varchar(255) DEFAULT NULL,
  12. `operationByUserId` varchar(255) DEFAULT NULL,
  13. `operationByUser` varchar(255) DEFAULT NULL,
  14. `operationAt` varchar(255) DEFAULT NULL,
  15. PRIMARY KEY (`id`) USING BTREE
  16. ) ENGINE = InnoDB AUTO_INCREMENT = 4 DEFAULT CHARSET = utf8mb4 COMMENT = '薪资初始配置'

salary_group

  • 薪资组
  1. CREATE TABLE `salary_group` (
  2. `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增主键',
  3. `groupId` varchar(255) NOT NULL COMMENT '薪资组id',
  4. `groupName` varchar(50) DEFAULT NULL COMMENT '薪资组名称',
  5. `deptIds` varchar(1024) DEFAULT NULL COMMENT '部门范围',
  6. `employeeIds` varchar(1024) DEFAULT NULL COMMENT '员工范围',
  7. `salaryStandard` varchar(20) DEFAULT '21.75' COMMENT '月计薪标准',
  8. `changeRule` varchar(20) DEFAULT '按转正/调薪前后的工资混合计算' COMMENT '转正、调薪月规则',
  9. `ruleId` varchar(255) DEFAULT NULL COMMENT '计税规则id',
  10. `createTime` datetime NOT NULL,
  11. `createUserId` varchar(255) NOT NULL,
  12. `operationByUser` varchar(255) DEFAULT NULL,
  13. `operation` varchar(255) DEFAULT NULL,
  14. `operationByUserId` varchar(255) DEFAULT NULL,
  15. `operationAt` varchar(255) DEFAULT NULL,
  16. PRIMARY KEY (`id`) USING BTREE
  17. ) ENGINE = InnoDB AUTO_INCREMENT = 3 DEFAULT CHARSET = utf8mb4 COMMENT = '薪资组'

salary_month_emp_record

  • 每月薪资记录
  1. CREATE TABLE `salary_month_emp_record` (
  2. `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增主键',
  3. `employeeId` varchar(255) NOT NULL COMMENT '员工ID',
  4. `year` int(11) DEFAULT NULL COMMENT '年',
  5. `month` int(11) DEFAULT NULL COMMENT '月',
  6. `startTime` varchar(255) DEFAULT NULL COMMENT '计薪开始日期',
  7. `endTime` varchar(255) DEFAULT NULL COMMENT '计薪结束日期',
  8. `holidaySalary` decimal(10, 2) DEFAULT NULL COMMENT '假期工资',
  9. `sessionHourSalary` decimal(10, 2) DEFAULT NULL COMMENT '课时工资',
  10. `workloadAllowance` decimal(10, 2) DEFAULT NULL COMMENT '工作量津贴',
  11. `overtimeAllowance` decimal(10, 2) DEFAULT NULL COMMENT '超课时津贴',
  12. `nightAllowance` decimal(10, 2) DEFAULT NULL COMMENT '晚4津贴+培优',
  13. `dutyAllowance` decimal(10, 2) DEFAULT NULL COMMENT '教师值日津贴+励志培训 ',
  14. `specialClassSubstitutionAllowance` decimal(10, 2) DEFAULT NULL COMMENT '特殊班代课津贴',
  15. `weekendSubsidy` decimal(10, 2) DEFAULT NULL COMMENT '双休补贴',
  16. `examinationTeachingPerformance` decimal(10, 2) DEFAULT NULL COMMENT '考试教学绩效',
  17. `regularTeachingPerformance` decimal(10, 2) DEFAULT NULL COMMENT '常规教学绩效',
  18. `communityTeachingPerformance` decimal(10, 2) DEFAULT NULL COMMENT '社团教学绩效',
  19. `professionalTitleAllowance` decimal(10, 2) DEFAULT NULL COMMENT '职称津贴',
  20. `gradeTeamLeaderAllowance` decimal(10, 2) DEFAULT NULL COMMENT '年级组长津贴',
  21. `researchLeaderAllowance` decimal(10, 2) DEFAULT NULL COMMENT '教研组长津贴',
  22. `classTeacherAllowance` decimal(10, 2) DEFAULT NULL COMMENT '班主任津贴',
  23. `monthPropositionalSubsidy` decimal(10, 2) DEFAULT NULL COMMENT '月考命题补贴',
  24. `teachingAgeAllowance` decimal(10, 2) DEFAULT NULL COMMENT '教龄津贴',
  25. `preparationTeamLeaderAllowance` decimal(10, 2) DEFAULT NULL COMMENT '备课组长津贴',
  26. `managementPositionSalary` decimal(10, 2) DEFAULT NULL COMMENT '管理岗位工资',
  27. `teachingAssistantsSalary` decimal(10, 2) DEFAULT NULL COMMENT '教辅岗位工资',
  28. `enrollmentSubsidy` decimal(10, 2) DEFAULT NULL COMMENT '招生补贴',
  29. `supplementarySocialBenefit` decimal(10, 2) DEFAULT NULL COMMENT '补五险一金',
  30. `specialTalentAllowance` decimal(10, 2) DEFAULT NULL COMMENT '特殊人才津贴',
  31. `retainWage` decimal(10, 2) DEFAULT NULL COMMENT '提留工资',
  32. `partyBranchActivitySubsidy` decimal(10, 2) DEFAULT NULL COMMENT '党支部活动补贴',
  33. `carSubsidy` decimal(10, 2) DEFAULT NULL COMMENT '用车补贴',
  34. `substitutSalary` decimal(10, 2) DEFAULT NULL COMMENT '代课工资',
  35. `schoolAgeAllowanceAndOther` decimal(10, 2) DEFAULT NULL COMMENT '校龄津贴及其他',
  36. `schoolAgeAllowance` decimal(10, 2) DEFAULT NULL COMMENT '校龄津贴',
  37. `otherAllowances` decimal(10, 2) DEFAULT NULL COMMENT '其他津贴',
  38. `expectedPaySalary` decimal(10, 2) DEFAULT NULL COMMENT '应发工资',
  39. `deductionForLeave` decimal(10, 2) DEFAULT NULL COMMENT '缺勤请假+(扣除课时费)',
  40. `penaltyForViolation` decimal(10, 2) DEFAULT NULL COMMENT '违规罚款',
  41. `utilityCost` decimal(10, 2) DEFAULT NULL COMMENT '水电费',
  42. `personalTax` decimal(10, 2) DEFAULT NULL COMMENT '个人所得税',
  43. `socialSecurityPaymentAgency` decimal(10, 2) DEFAULT NULL COMMENT '社保代缴',
  44. `singleRoomFee` decimal(10, 2) DEFAULT NULL COMMENT '申请单间费用',
  45. `mealExpenses` decimal(10, 2) DEFAULT NULL COMMENT '伙食费',
  46. `workUniformExpenses` decimal(10, 2) DEFAULT NULL COMMENT '工作服费用',
  47. `deductionAmount` decimal(10, 2) DEFAULT NULL COMMENT '应扣款',
  48. `realPaySalary` decimal(10, 2) DEFAULT NULL COMMENT '实发工资',
  49. `checkStatus` varchar(255) DEFAULT '待审核' COMMENT '状态 0待审核、1通过、2拒绝、3审核中 4:撤回 5 未提交 10 历史薪资 11核算完成',
  50. `createUserId` varchar(255) DEFAULT NULL,
  51. `createTime` varchar(255) DEFAULT NULL,
  52. `operation` varchar(255) DEFAULT NULL,
  53. `operationByUserId` varchar(255) DEFAULT NULL,
  54. `operationByUser` varchar(255) DEFAULT NULL,
  55. `operationAt` varchar(255) DEFAULT NULL,
  56. PRIMARY KEY (`id`) USING BTREE
  57. ) ENGINE = InnoDB AUTO_INCREMENT = 108 DEFAULT CHARSET = utf8mb4 COMMENT = '每月薪资记录'

salary_month_record

  • 每月薪资记录
  1. CREATE TABLE `salary_month_record` (
  2. `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增主键',
  3. `sRecordId` varchar(255) NOT NULL,
  4. `title` varchar(40) DEFAULT NULL COMMENT '报表标题',
  5. `year` int(11) DEFAULT NULL COMMENT '年',
  6. `month` int(11) DEFAULT NULL COMMENT '月',
  7. `startTime` date DEFAULT NULL COMMENT '计薪开始日期',
  8. `endTime` date DEFAULT NULL COMMENT '计薪结束日期',
  9. `personalInsuranceAmount` decimal(10, 2) DEFAULT NULL COMMENT '个人社保金额',
  10. `personalProvidentFundAmount` decimal(10, 2) DEFAULT NULL COMMENT '个人公积金金额',
  11. `corporateInsuranceAmount` decimal(10, 2) DEFAULT NULL COMMENT '公司社保金额',
  12. `corporateProvidentFundAmount` decimal(10, 2) DEFAULT NULL COMMENT '公司社保金额',
  13. `expectedPaySalary` decimal(10, 2) DEFAULT NULL COMMENT '预应发工资',
  14. `personalTax` decimal(10, 2) DEFAULT NULL COMMENT '个人所得税',
  15. `realPaySalary` decimal(10, 2) DEFAULT NULL COMMENT '预计实发工资',
  16. `optionHead` longtext COMMENT '薪资项表头',
  17. `examineRecordId` varchar(255) DEFAULT NULL COMMENT '审核记录id',
  18. `checkStatus` varchar(255) DEFAULT '5' COMMENT '状态 0待审核、1通过、2拒绝、3审核中 4:撤回 5 未提交 10 历史薪资 11核算完成',
  19. `createUserId` varchar(255) DEFAULT NULL,
  20. `createTime` varchar(255) DEFAULT NULL,
  21. `operation` varchar(255) DEFAULT NULL,
  22. `operationByUserId` varchar(255) DEFAULT NULL,
  23. `operationByUser` varchar(255) DEFAULT NULL,
  24. `operationAt` varchar(255) DEFAULT NULL,
  25. PRIMARY KEY (`id`) USING BTREE
  26. ) ENGINE = InnoDB AUTO_INCREMENT = 2 DEFAULT CHARSET = utf8mb4 COMMENT = '每月薪资记录'

salary_tax_rule

  • 计税规则
  1. CREATE TABLE `salary_tax_rule` (
  2. `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增主键',
  3. `ruleId` varchar(255) NOT NULL,
  4. `ruleName` varchar(50) NOT NULL COMMENT '规则名称',
  5. `taxType` int(255) DEFAULT NULL COMMENT '个税类型 1 工资薪金所得税 2 劳务报酬所得税 3 不计税',
  6. `isTax` int(11) DEFAULT NULL COMMENT '是否计税 0 否 1 是',
  7. `markingPoint` int(11) DEFAULT NULL COMMENT '起征点',
  8. `decimalPoint` int(11) DEFAULT NULL COMMENT '个税结果(保留小数点)',
  9. `cycleType` int(11) DEFAULT NULL COMMENT '计税周期类型 1 上年12月到今年11月(对应的工资发放方式为次月发上月工资) 2 今年1月到12月(对应的工资发放方式为当月发当月工资)',
  10. `operation` varchar(255) DEFAULT NULL,
  11. `operationByUserId` varchar(255) DEFAULT NULL,
  12. `operationByUser` varchar(255) DEFAULT NULL,
  13. `operationAt` varchar(255) DEFAULT NULL,
  14. PRIMARY KEY (`id`) USING BTREE
  15. ) ENGINE = InnoDB AUTO_INCREMENT = 55 DEFAULT CHARSET = utf8mb4 COMMENT = '计税规则'

业务视图

_view02_user_app

  1. CREATE ALGORITHM = UNDEFINED DEFINER = `root` @`localhost` SQL SECURITY DEFINER VIEW `_view02_user_app` AS
  2. select
  3. `jh_enterprise_v2_data_repository`.`enterprise_view02_user_app`.`id` AS `id`,
  4. `jh_enterprise_v2_data_repository`.`enterprise_view02_user_app`.`userId` AS `userId`,
  5. `jh_enterprise_v2_data_repository`.`enterprise_view02_user_app`.`appId` AS `appId`
  6. from
  7. `jh_enterprise_v2_data_repository`.`enterprise_view02_user_app`
  8. where
  9. (
  10. `jh_enterprise_v2_data_repository`.`enterprise_view02_user_app`.`appId` = 'jianghu-hr'
  11. )

repo_hr_user_org

  1. CREATE ALGORITHM = UNDEFINED DEFINER = `root` @`%` SQL SECURITY DEFINER VIEW `repo_hr_user_org` AS
  2. select
  3. `mor`.`id` AS `id`,
  4. `mor`.`memberId` AS `userId`,
  5. `mor`.`orgId` AS `hrOrgId`,
  6. `org`.`orgName` AS `hrOrgName`,
  7. `mor`.`roleId` AS `hrRoleId`
  8. from
  9. (
  10. `member_org_role` `mor`
  11. left join `org` on ((`mor`.`orgId` = `org`.`orgId`))
  12. )

view01_archives_option_by_emp

  1. CREATE ALGORITHM = UNDEFINED DEFINER = `root` @`%` SQL SECURITY DEFINER VIEW `view01_archives_option_by_emp` AS
  2. select
  3. `salary_archives_option`.`employeeId` AS `employeeId`,
  4. sum(`salary_archives_option`.`value`) AS `totalSalary`
  5. from
  6. `salary_archives_option`
  7. group by
  8. `salary_archives_option`.`employeeId`

view01_attendance_clock

  1. CREATE ALGORITHM = UNDEFINED DEFINER = `root` @`%` SQL SECURITY DEFINER VIEW `view01_attendance_clock` AS
  2. select
  3. `employee`.`employeeName` AS `employeeName`,
  4. `attendance_clock`.`id` AS `id`,
  5. `attendance_clock`.`clockId` AS `clockId`,
  6. `attendance_clock`.`clockEmployeeId` AS `clockEmployeeId`,
  7. `attendance_clock`.`clockTime` AS `clockTime`,
  8. `attendance_clock`.`clockType` AS `clockType`,
  9. `attendance_clock`.`attendanceTime` AS `attendanceTime`,
  10. `attendance_clock`.`type` AS `type`,
  11. `attendance_clock`.`address` AS `address`,
  12. `attendance_clock`.`lng` AS `lng`,
  13. `attendance_clock`.`lat` AS `lat`,
  14. `attendance_clock`.`remark` AS `remark`,
  15. `attendance_clock`.`operationByUserId` AS `operationByUserId`,
  16. `attendance_clock`.`operation` AS `operation`,
  17. `attendance_clock`.`operationByUser` AS `operationByUser`,
  18. `attendance_clock`.`operationAt` AS `operationAt`
  19. from
  20. (
  21. `attendance_clock`
  22. left join `employee` on (
  23. (
  24. `attendance_clock`.`clockEmployeeId` = `employee`.`employeeId`
  25. )
  26. )
  27. )

view01_employee

  1. CREATE ALGORITHM = UNDEFINED DEFINER = `root` @`%` SQL SECURITY DEFINER VIEW `view01_employee` AS
  2. select distinct
  3. `employee`.`id` AS `id`,
  4. `employee`.`employeeId` AS `employeeId`,
  5. `employee`.`employeeName` AS `employeeName`,
  6. `employee`.`idSequence` AS `idSequence`,
  7. `employee`.`sex` AS `sex`,
  8. `employee`.`age` AS `age`,
  9. `employee`.`contactNumber` AS `contactNumber`,
  10. `employee`.`emergencyContactNumber` AS `emergencyContactNumber`,
  11. `employee`.`post` AS `post`,
  12. `employee`.`politicalBackground` AS `politicalBackground`,
  13. `employee`.`icNumber` AS `icNumber`,
  14. `employee`.`dateOfBirth` AS `dateOfBirth`,
  15. `employee`.`institution` AS `institution`,
  16. `employee`.`major` AS `major`,
  17. `employee`.`highestEducation` AS `highestEducation`,
  18. `employee`.`teacherQualification` AS `teacherQualification`,
  19. `employee`.`teacherQualificationLeaver` AS `teacherQualificationLeaver`,
  20. `employee`.`teacherQualificationSubject` AS `teacherQualificationSubject`,
  21. `employee`.`teacherCertificationNumber` AS `teacherCertificationNumber`,
  22. `employee`.`teachingLevel` AS `teachingLevel`,
  23. `employee`.`teachingSubject` AS `teachingSubject`,
  24. `employee`.`residentialAddress` AS `residentialAddress`,
  25. `employee`.`province` AS `province`,
  26. `employee`.`city` AS `city`,
  27. `employee`.`county` AS `county`,
  28. `employee`.`dateOfEntry` AS `dateOfEntry`,
  29. `employee`.`dateOfContractExpiration` AS `dateOfContractExpiration`,
  30. `employee`.`cardNumber` AS `cardNumber`,
  31. `employee`.`licensePlateNumber` AS `licensePlateNumber`,
  32. `employee`.`employmentForms` AS `employmentForms`,
  33. `employee`.`entryStatus` AS `entryStatus`,
  34. `employee`.`status` AS `status`,
  35. `employee`.`remarks` AS `remarks`,
  36. `employee`.`leaveRequestStatus` AS `leaveRequestStatus`,
  37. `employee`.`contactPerson` AS `contactPerson`,
  38. `employee`.`educationExperience` AS `educationExperience`,
  39. `employee`.`certificate` AS `certificate`,
  40. `employee`.`salaryCard` AS `salaryCard`,
  41. `employee`.`socialSecurity` AS `socialSecurity`,
  42. `employee`.`trainingExperience` AS `trainingExperience`,
  43. `employee`.`workExperience` AS `workExperience`,
  44. `employee`.`operation` AS `operation`,
  45. `employee`.`operationByUserId` AS `operationByUserId`,
  46. `employee`.`operationByUser` AS `operationByUser`,
  47. `employee`.`operationAt` AS `operationAt`,
  48. `view01_member_org_role`.`orgId` AS `orgId`,
  49. `view01_member_org_role`.`orgName` AS `orgName`
  50. from
  51. (
  52. `employee`
  53. left join `view01_member_org_role` on (
  54. (
  55. `employee`.`employeeId` = `view01_member_org_role`.`memberId`
  56. )
  57. )
  58. )

view01_employee_archives

  1. CREATE ALGORITHM = UNDEFINED DEFINER = `root` @`%` SQL SECURITY DEFINER VIEW `view01_employee_archives` AS
  2. select distinct
  3. `employee`.`employeeId` AS `employeeId`,
  4. `employee`.`id` AS `id`,
  5. `employee`.`employeeName` AS `employeeName`,
  6. `employee`.`county` AS `country`,
  7. `employee`.`status` AS `status`,
  8. `salary_archives`.`changeDate` AS `changeDate`,
  9. `salary_archives`.`changeReason` AS `changeReason`,
  10. `employee`.`dateOfEntry` AS `dateOfEntry`,
  11. `view01_archives_option_by_emp`.`totalSalary` AS `totalSalary`,
  12. `salary_archives`.`changeType` AS `changeType`,
  13. `employee`.`entryStatus` AS `entryStatus`,
  14. `employee`.`employmentForms` AS `employmentForms`,
  15. `employee`.`dateOfContractExpiration` AS `dateOfContractExpiration`
  16. from
  17. (
  18. (
  19. `employee`
  20. left join `salary_archives` on (
  21. (
  22. `employee`.`employeeId` = `salary_archives`.`employeeId`
  23. )
  24. )
  25. )
  26. left join `view01_archives_option_by_emp` on (
  27. (
  28. `employee`.`employeeId` = `view01_archives_option_by_emp`.`employeeId`
  29. )
  30. )
  31. )

view01_employee_quit_list

  1. CREATE ALGORITHM = UNDEFINED DEFINER = `root` @`%` SQL SECURITY DEFINER VIEW `view01_employee_quit_list` AS
  2. select
  3. `employee`.`id` AS `id`,
  4. `employee`.`employeeId` AS `employeeId`,
  5. `employee`.`employeeName` AS `employeeName`,
  6. `employee`.`idSequence` AS `idSequence`,
  7. `employee`.`sex` AS `sex`,
  8. `employee`.`age` AS `age`,
  9. `employee`.`contactNumber` AS `contactNumber`,
  10. `employee`.`emergencyContactNumber` AS `emergencyContactNumber`,
  11. `employee`.`post` AS `post`,
  12. `employee`.`politicalBackground` AS `politicalBackground`,
  13. `employee`.`icNumber` AS `icNumber`,
  14. `employee`.`dateOfBirth` AS `dateOfBirth`,
  15. `employee`.`institution` AS `institution`,
  16. `employee`.`major` AS `major`,
  17. `employee`.`highestEducation` AS `highestEducation`,
  18. `employee`.`teacherQualification` AS `teacherQualification`,
  19. `employee`.`teacherQualificationLeaver` AS `teacherQualificationLeaver`,
  20. `employee`.`teacherQualificationSubject` AS `teacherQualificationSubject`,
  21. `employee`.`teacherCertificationNumber` AS `teacherCertificationNumber`,
  22. `employee`.`teachingLevel` AS `teachingLevel`,
  23. `employee`.`teachingSubject` AS `teachingSubject`,
  24. `employee`.`residentialAddress` AS `residentialAddress`,
  25. `employee`.`province` AS `province`,
  26. `employee`.`city` AS `city`,
  27. `employee`.`county` AS `county`,
  28. `employee`.`dateOfEntry` AS `dateOfEntry`,
  29. `employee`.`dateOfContractExpiration` AS `dateOfContractExpiration`,
  30. `employee`.`cardNumber` AS `cardNumber`,
  31. `employee`.`licensePlateNumber` AS `licensePlateNumber`,
  32. `employee`.`employmentForms` AS `employmentForms`,
  33. `employee`.`entryStatus` AS `entryStatus`,
  34. `employee`.`status` AS `status`,
  35. `employee`.`remarks` AS `remarks`,
  36. `employee`.`operation` AS `operation`,
  37. `employee`.`operationByUserId` AS `operationByUserId`,
  38. `employee`.`operationByUser` AS `operationByUser`,
  39. `employee`.`operationAt` AS `operationAt`,
  40. `employee_quit_info`.`planQuitTime` AS `planQuitTime`
  41. from
  42. (
  43. `employee`
  44. left join `employee_quit_info` on (
  45. (
  46. `employee`.`employeeId` = `employee_quit_info`.`employeeId`
  47. )
  48. )
  49. )

view01_insurance_month

  1. CREATE ALGORITHM = UNDEFINED DEFINER = `root` @`%` SQL SECURITY DEFINER VIEW `view01_insurance_month` AS
  2. select
  3. `insurance_month_record`.`iRecordId` AS `iRecordId`,
  4. `insurance_month_record`.`title` AS `title`,
  5. `insurance_month_record`.`year` AS `year`,
  6. `insurance_month_record`.`month` AS `month`,
  7. count(distinct `insurance_month_emp_record`.`id`) AS `num`,
  8. sum(
  9. if(
  10. (`insurance_month_emp_record`.`status` = 1),
  11. `insurance_month_emp_record`.`personalInsuranceAmount`,
  12. 0
  13. )
  14. ) AS `personalInsuranceAmount`,
  15. sum(
  16. if(
  17. (`insurance_month_emp_record`.`status` = 1),
  18. `insurance_month_emp_record`.`personalProvidentFundAmount`,
  19. 0
  20. )
  21. ) AS `personalProvidentFundAmount`,
  22. sum(
  23. if(
  24. (`insurance_month_emp_record`.`status` = 1),
  25. `insurance_month_emp_record`.`corporateInsuranceAmount`,
  26. 0
  27. )
  28. ) AS `corporateInsuranceAmount`,
  29. sum(
  30. if(
  31. (`insurance_month_emp_record`.`status` = 1),
  32. `insurance_month_emp_record`.`corporateProvidentFundAmount`,
  33. 0
  34. )
  35. ) AS `corporateProvidentFundAmount`,
  36. count(
  37. if(
  38. (`insurance_month_emp_record`.`status` = 0),
  39. `insurance_month_emp_record`.`iEmpRecordId`,
  40. NULL
  41. )
  42. ) AS `stopCount`,
  43. `insurance_month_record`.`status` AS `monthStatus`
  44. from
  45. (
  46. `insurance_month_record`
  47. left join `insurance_month_emp_record` on (
  48. (
  49. (
  50. `insurance_month_record`.`year` = `insurance_month_emp_record`.`year`
  51. )
  52. and (
  53. `insurance_month_record`.`month` = `insurance_month_emp_record`.`month`
  54. )
  55. and (
  56. `insurance_month_record`.`iRecordId` = `insurance_month_emp_record`.`iRecordId`
  57. )
  58. )
  59. )
  60. )
  61. group by
  62. `insurance_month_record`.`year`,
  63. `insurance_month_record`.`month`

view01_insurance_scheme

  1. CREATE ALGORITHM = UNDEFINED DEFINER = `root` @`%` SQL SECURITY DEFINER VIEW `view01_insurance_scheme` AS
  2. select
  3. `insurance_month_record`.`iRecordId` AS `iRecordId`,
  4. `insurance_month_record`.`title` AS `title`,
  5. `insurance_month_record`.`year` AS `year`,
  6. `insurance_month_record`.`month` AS `month`,
  7. count(`insurance_month_emp_record`.`id`) AS `num`,
  8. sum(
  9. if(
  10. (`insurance_month_emp_record`.`status` = 1),
  11. `insurance_month_emp_record`.`personalInsuranceAmount`,
  12. 0
  13. )
  14. ) AS `personalInsuranceAmount`,
  15. sum(
  16. if(
  17. (`insurance_month_emp_record`.`status` = 1),
  18. `insurance_month_emp_record`.`personalProvidentFundAmount`,
  19. 0
  20. )
  21. ) AS `personalProvidentFundAmount`,
  22. sum(
  23. if(
  24. (`insurance_month_emp_record`.`status` = 1),
  25. `insurance_month_emp_record`.`corporateInsuranceAmount`,
  26. 0
  27. )
  28. ) AS `corporateInsuranceAmount`,
  29. sum(
  30. if(
  31. (`insurance_month_emp_record`.`status` = 1),
  32. `insurance_month_emp_record`.`corporateProvidentFundAmount`,
  33. 0
  34. )
  35. ) AS `corporateProvidentFundAmount`,
  36. count(
  37. if(
  38. (`insurance_month_emp_record`.`status` = 0),
  39. `insurance_month_emp_record`.`iEmpRecordId`,
  40. NULL
  41. )
  42. ) AS `stopCount`,
  43. `insurance_month_record`.`status` AS `monthStatus`
  44. from
  45. (
  46. `insurance_month_record`
  47. left join `insurance_month_emp_record` on (
  48. (
  49. (
  50. `insurance_month_record`.`year` = `insurance_month_emp_record`.`year`
  51. )
  52. and (
  53. `insurance_month_record`.`month` = `insurance_month_emp_record`.`month`
  54. )
  55. and (
  56. `insurance_month_record`.`iRecordId` = `insurance_month_emp_record`.`iRecordId`
  57. )
  58. )
  59. )
  60. )
  61. group by
  62. `insurance_month_record`.`year`,
  63. `insurance_month_record`.`month`

view01_job_resume

  1. CREATE ALGORITHM = UNDEFINED DEFINER = `root` @`%` SQL SECURITY DEFINER VIEW `view01_job_resume` AS
  2. select
  3. `job_resume`.`id` AS `id`,
  4. `job_resume`.`jobId` AS `jobId`,
  5. `job_resume`.`jobTitle` AS `jobTitle`,
  6. `job_resume`.`jobResumeId` AS `jobResumeId`,
  7. `job_resume`.`user` AS `user`,
  8. `job_resume`.`gender` AS `gender`,
  9. `job_resume`.`age` AS `age`,
  10. `job_resume`.`ethnicity` AS `ethnicity`,
  11. `job_resume`.`height` AS `height`,
  12. `job_resume`.`weight` AS `weight`,
  13. `job_resume`.`bloodType` AS `bloodType`,
  14. `job_resume`.`maritalStatus` AS `maritalStatus`,
  15. `job_resume`.`politicalAffiliation` AS `politicalAffiliation`,
  16. `job_resume`.`physicalCondition` AS `physicalCondition`,
  17. `job_resume`.`religiousBeliefs` AS `religiousBeliefs`,
  18. `job_resume`.`phoneNumber` AS `phoneNumber`,
  19. `job_resume`.`IDNumber` AS `IDNumber`,
  20. `job_resume`.`email` AS `email`,
  21. `job_resume`.`highestEducation` AS `highestEducation`,
  22. `job_resume`.`wechatID` AS `wechatID`,
  23. `job_resume`.`nativePlace` AS `nativePlace`,
  24. `job_resume`.`homeAddress` AS `homeAddress`,
  25. `job_resume`.`currentAddress` AS `currentAddress`,
  26. `job_resume`.`academicRanking` AS `academicRanking`,
  27. `job_resume`.`workplace` AS `workplace`,
  28. `job_resume`.`salaryExpectation` AS `salaryExpectation`,
  29. `job_resume`.`domicilePlace` AS `domicilePlace`,
  30. `job_resume`.`earliestAvailability` AS `earliestAvailability`,
  31. `job_resume`.`education` AS `education`,
  32. `job_resume`.`educationCertificate` AS `educationCertificate`,
  33. `job_resume`.`experience` AS `experience`,
  34. `job_resume`.`familyMember` AS `familyMember`,
  35. `job_resume`.`teacherContact` AS `teacherContact`,
  36. `job_resume`.`studentSocialization` AS `studentSocialization`,
  37. `job_resume`.`socialActivities` AS `socialActivities`,
  38. `job_resume`.`achievement` AS `achievement`,
  39. `job_resume`.`socialHobbies` AS `socialHobbies`,
  40. `job_resume`.`personality` AS `personality`,
  41. `job_resume`.`careerPlanning` AS `careerPlanning`,
  42. `job_resume`.`offence` AS `offence`,
  43. `job_resume`.`resumeStatus` AS `resumeStatus`,
  44. `job_resume`.`operation` AS `operation`,
  45. `job_resume`.`operationByUserId` AS `operationByUserId`,
  46. `job_resume`.`operationByUser` AS `operationByUser`,
  47. `job_resume`.`operationAt` AS `operationAt`
  48. from
  49. `job_resume`

view01_member_org_role

  1. CREATE ALGORITHM = UNDEFINED DEFINER = `root` @`%` SQL SECURITY DEFINER VIEW `view01_member_org_role` AS
  2. select
  3. `member_org_role`.`id` AS `id`,
  4. `member_org_role`.`orgId` AS `orgId`,
  5. `member_org_role`.`memberId` AS `memberId`,
  6. `member_org_role`.`roleId` AS `roleId`,
  7. `member_org_role`.`remark` AS `remark`,
  8. `org`.`orgParentId` AS `orgParentId`,
  9. `org`.`orgName` AS `orgName`,
  10. `employee`.`employeeId` AS `employeeId`,
  11. `employee`.`employeeName` AS `employeeName`,
  12. `employee`.`idSequence` AS `idSequence`,
  13. `employee`.`sex` AS `sex`,
  14. `employee`.`age` AS `age`,
  15. `employee`.`contactNumber` AS `contactNumber`,
  16. `employee`.`emergencyContactNumber` AS `emergencyContactNumber`,
  17. `employee`.`post` AS `post`,
  18. `employee`.`politicalBackground` AS `politicalBackground`,
  19. `employee`.`icNumber` AS `icNumber`,
  20. `employee`.`dateOfBirth` AS `dateOfBirth`,
  21. `employee`.`institution` AS `institution`,
  22. `employee`.`major` AS `major`,
  23. `employee`.`highestEducation` AS `highestEducation`,
  24. `employee`.`teacherQualification` AS `teacherQualification`,
  25. `employee`.`teacherQualificationLeaver` AS `teacherQualificationLeaver`,
  26. `employee`.`teacherQualificationSubject` AS `teacherQualificationSubject`,
  27. `employee`.`teacherCertificationNumber` AS `teacherCertificationNumber`,
  28. `employee`.`teachingLevel` AS `teachingLevel`,
  29. `employee`.`teachingSubject` AS `teachingSubject`,
  30. `employee`.`residentialAddress` AS `residentialAddress`,
  31. `employee`.`province` AS `province`,
  32. `employee`.`city` AS `city`,
  33. `employee`.`county` AS `county`,
  34. `employee`.`dateOfEntry` AS `dateOfEntry`,
  35. `employee`.`dateOfContractExpiration` AS `dateOfContractExpiration`,
  36. `employee`.`cardNumber` AS `cardNumber`,
  37. `employee`.`licensePlateNumber` AS `licensePlateNumber`,
  38. `employee`.`employmentForms` AS `employmentForms`,
  39. `employee`.`entryStatus` AS `entryStatus`,
  40. `employee`.`status` AS `status`,
  41. `employee`.`remarks` AS `remarks`
  42. from
  43. (
  44. (
  45. `member_org_role`
  46. left join `org` on ((`member_org_role`.`orgId` = `org`.`orgId`))
  47. )
  48. left join `employee` on (
  49. (
  50. `member_org_role`.`memberId` = `employee`.`employeeId`
  51. )
  52. )
  53. )

view01_salary_group_rule

  1. CREATE ALGORITHM = UNDEFINED DEFINER = `root` @`%` SQL SECURITY DEFINER VIEW `view01_salary_group_rule` AS
  2. select
  3. `salary_group`.`id` AS `id`,
  4. `salary_group`.`groupId` AS `groupId`,
  5. `salary_group`.`groupName` AS `groupName`,
  6. `salary_group`.`deptIds` AS `deptIds`,
  7. `salary_group`.`employeeIds` AS `employeeIds`,
  8. `salary_group`.`salaryStandard` AS `salaryStandard`,
  9. `salary_group`.`changeRule` AS `changeRule`,
  10. `salary_group`.`ruleId` AS `ruleId`,
  11. `salary_group`.`createTime` AS `createTime`,
  12. `salary_group`.`createUserId` AS `createUserId`,
  13. `salary_group`.`operationByUser` AS `operationByUser`,
  14. `salary_group`.`operation` AS `operation`,
  15. `salary_group`.`operationByUserId` AS `operationByUserId`,
  16. `salary_group`.`operationAt` AS `operationAt`,
  17. `salary_tax_rule`.`taxType` AS `taxType`,
  18. `salary_tax_rule`.`isTax` AS `isTax`,
  19. `salary_tax_rule`.`ruleName` AS `ruleName`,
  20. `salary_tax_rule`.`markingPoint` AS `markingPoint`,
  21. `salary_tax_rule`.`decimalPoint` AS `decimalPoint`,
  22. `salary_tax_rule`.`cycleType` AS `cycleType`
  23. from
  24. (
  25. `salary_group`
  26. left join `salary_tax_rule` on (
  27. (
  28. `salary_group`.`ruleId` = `salary_tax_rule`.`ruleId`
  29. )
  30. )
  31. )

view01_salary_month_record

  1. CREATE ALGORITHM = UNDEFINED DEFINER = `root` @`%` SQL SECURITY DEFINER VIEW `view01_salary_month_record` AS
  2. select
  3. `salary_month_record`.`id` AS `id`,
  4. `salary_month_record`.`sRecordId` AS `sRecordId`,
  5. `salary_month_record`.`title` AS `title`,
  6. `salary_month_record`.`year` AS `year`,
  7. `salary_month_record`.`month` AS `month`,
  8. `salary_month_record`.`startTime` AS `startTime`,
  9. `salary_month_record`.`endTime` AS `endTime`,
  10. `salary_month_record`.`personalInsuranceAmount` AS `personalInsuranceAmount`,
  11. `salary_month_record`.`personalProvidentFundAmount` AS `personalProvidentFundAmount`,
  12. `salary_month_record`.`corporateInsuranceAmount` AS `corporateInsuranceAmount`,
  13. `salary_month_record`.`corporateProvidentFundAmount` AS `corporateProvidentFundAmount`,
  14. `salary_month_record`.`expectedPaySalary` AS `expectedPaySalary`,
  15. `salary_month_record`.`personalTax` AS `personalTax`,
  16. `salary_month_record`.`realPaySalary` AS `realPaySalary`,
  17. `salary_month_record`.`optionHead` AS `optionHead`,
  18. `salary_month_record`.`examineRecordId` AS `examineRecordId`,
  19. `salary_month_record`.`checkStatus` AS `checkStatus`,
  20. `salary_month_record`.`createUserId` AS `createUserId`,
  21. `salary_month_record`.`createTime` AS `createTime`,
  22. `salary_month_record`.`operation` AS `operation`,
  23. `salary_month_record`.`operationByUserId` AS `operationByUserId`,
  24. `salary_month_record`.`operationByUser` AS `operationByUser`,
  25. `salary_month_record`.`operationAt` AS `operationAt`,
  26. count(`salary_month_emp_record`.`id`) AS `num`
  27. from
  28. (
  29. `salary_month_record`
  30. left join `salary_month_emp_record` on (
  31. (
  32. (
  33. `salary_month_record`.`year` = `salary_month_emp_record`.`year`
  34. )
  35. and (
  36. `salary_month_record`.`month` = `salary_month_emp_record`.`month`
  37. )
  38. )
  39. )
  40. )
  41. group by
  42. `salary_month_record`.`id`

view02_performance_employee_rate

  1. CREATE ALGORITHM = UNDEFINED DEFINER = `root` @`%` SQL SECURITY DEFINER VIEW `view02_performance_employee_rate` AS
  2. select
  3. `performance_employee_rate`.`id` AS `id`,
  4. `performance_employee_rate`.`performanceId` AS `performanceId`,
  5. `performance_employee_rate`.`performanceName` AS `performanceName`,
  6. `performance_employee_rate`.`performanceContent` AS `performanceContent`,
  7. `performance_employee_rate`.`performanceCycle` AS `performanceCycle`,
  8. `performance_employee_rate`.`startTime` AS `startTime`,
  9. `performance_employee_rate`.`endTime` AS `endTime`,
  10. `performance_employee_rate`.`actualTargetData` AS `actualTargetData`,
  11. `performance_employee_rate`.`employeeId` AS `employeeId`,
  12. `performance_employee_rate`.`employeeName` AS `employeeName`,
  13. `performance_employee_rate`.`raterId` AS `raterId`,
  14. `performance_employee_rate`.`raterName` AS `raterName`,
  15. `performance_employee_rate`.`gradePerformance` AS `gradePerformance`,
  16. `performance_employee_rate`.`status` AS `status`,
  17. `performance_employee_rate`.`remarks` AS `remarks`,
  18. `performance_employee_rate`.`operation` AS `operation`,
  19. `performance_employee_rate`.`operationByUserId` AS `operationByUserId`,
  20. `performance_employee_rate`.`operationByUser` AS `operationByUser`,
  21. `performance_employee_rate`.`operationAt` AS `operationAt`
  22. from
  23. `performance_employee_rate`