数据结构

12111

表总览

通用表

• _user
• _user_session
• _role
• _page
• _resource
• _group
• _user_group_role
• _user_group_role_page
• _user_group_role_resource
• _constant
• _constant_ui
• _record
• _record_history
• _cache
• _file
• _view01_user

业务表

_ui

• ui 施工方案

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

achievement_appraisal

• 绩效考核

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

achievement_appraisal_evaluators

• 考核结果评定人

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

achievement_appraisal_score_level

• 考评规则等级

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

achievement_appraisal_target_confirmors

• 考核目标确认人

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

achievement_employee_appraisal

• 员工绩效考核

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

achievement_employee_evaluato

• 员工绩效结果评定表

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

achievement_employee_evaluato_seg

• 员工绩效考核项评定表

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

achievement_employee_result_confirmors

• 绩效结果确认表

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

achievement_employee_seg

• 员工绩效考核项

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

achievement_employee_seg_item

• 员工考核项选项

CREATE TABLE `achievement_employee_seg_item` (
  `id` int(11) DEFAULT NULL COMMENT '自增主键',
  `itemId` int(11) NOT NULL AUTO_INCREMENT,
  `segId` int(11) DEFAULT NULL,
  `tempItemId` int(11) DEFAULT '0' COMMENT '模板考核项id',
  `itemName` varchar(50)  DEFAULT NULL COMMENT '选项名称',
  `value` varchar(255)  DEFAULT NULL COMMENT '值',
  `sort` int(11) DEFAULT NULL,
  `operation` varchar(255)  DEFAULT NULL,
  `operationByUserId` varchar(255)  DEFAULT NULL,
  `operationByUser` varchar(255)  DEFAULT NULL,
  `operationAt` varchar(255)  DEFAULT NULL,
  PRIMARY KEY (`itemId`) USING BTREE
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '员工考核项选项'

achievement_employee_target_confirm

• 员工考核目标确认表

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

achievement_seg

• 绩效考核项模板

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

achievement_seg_item

• 考核项选项

CREATE TABLE `achievement_seg_item` (
  `id` int(11) DEFAULT NULL COMMENT '自增主键',
  `itemId` int(11) NOT NULL AUTO_INCREMENT,
  `segId` int(11) DEFAULT NULL,
  `itemName` varchar(50)  DEFAULT NULL COMMENT '选项名称',
  `sort` int(11) DEFAULT NULL,
  `operation` varchar(255)  DEFAULT NULL,
  `operationByUser` varchar(255)  DEFAULT NULL,
  `operationByUserId` varchar(255)  DEFAULT NULL,
  `operationAt` varchar(255)  DEFAULT NULL,
  PRIMARY KEY (`itemId`) USING BTREE
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '考核项选项'

achievement_table

• 绩效考核表模板

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

attendance_clock

• 打卡记录表

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

employee

CREATE TABLE `employee` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `employeeId` varchar(255)  DEFAULT NULL COMMENT '员工id',
  `employeeName` varchar(255)  DEFAULT NULL COMMENT '员工姓名',
  `idSequence` int(11) DEFAULT NULL COMMENT '员工序号',
  `sex` varchar(255)  DEFAULT NULL COMMENT '员工性别',
  `age` int(11) DEFAULT NULL COMMENT '员工年龄',
  `contactNumber` varchar(255)  DEFAULT NULL COMMENT '联系电话',
  `emergencyContactNumber` varchar(255)  DEFAULT NULL COMMENT '紧急联系电话',
  `post` varchar(255)  DEFAULT NULL COMMENT '岗位1',
  `post2` varchar(255)  DEFAULT NULL COMMENT '岗位2',
  `post3` varchar(255)  DEFAULT NULL COMMENT '岗位3',
  `politicalBackground` varchar(255)  DEFAULT NULL COMMENT '政治面貌',
  `icNumber` varchar(255)  DEFAULT NULL COMMENT '身份证号码',
  `dateOfBirth` varchar(255)  DEFAULT NULL COMMENT '出生日期',
  `institution` varchar(255)  DEFAULT NULL COMMENT '毕业学校',
  `major` varchar(255)  DEFAULT NULL COMMENT '专业',
  `highestEducation` varchar(255)  DEFAULT NULL COMMENT '学历层次',
  `teacherQualification` varchar(255)  DEFAULT NULL COMMENT '教师资格证类别',
  `teacherQualificationLeaver` varchar(255)  DEFAULT NULL COMMENT '教师资格证学段',
  `teacherQualificationSubject` varchar(255)  DEFAULT NULL COMMENT '教师资格证学科',
  `teacherCertificationNumber` varchar(255)  DEFAULT NULL COMMENT '教师资格证编号',
  `teachingLevel` varchar(255)  DEFAULT NULL COMMENT '任教学段',
  `teachingSubject` varchar(255)  DEFAULT NULL COMMENT '任教学科',
  `residentialAddress` varchar(255)  DEFAULT NULL COMMENT '家庭地址',
  `province` varchar(255)  DEFAULT NULL COMMENT '省',
  `city` varchar(255)  DEFAULT NULL COMMENT '市',
  `county` varchar(255)  DEFAULT NULL COMMENT '县',
  `operationAt` varchar(255)  DEFAULT NULL,
  `dateOfEntry` varchar(255)  DEFAULT NULL COMMENT '入职',
  `dateOfContractExpiration` varchar(255)  DEFAULT NULL COMMENT '到期',
  `leaveRequestStatus` varchar(255)  DEFAULT NULL COMMENT '申请离职状态',
  `cardNumber` varchar(255)  DEFAULT NULL COMMENT '建设银行卡卡号',
  `licensePlateNumber` varchar(255)  DEFAULT NULL COMMENT '车牌号',
  `employmentForms` varchar(255)  DEFAULT NULL COMMENT '聘用形式',
  `probationPeriod` varchar(255)  DEFAULT NULL COMMENT '试用期',
  `entryStatus` varchar(255)  DEFAULT NULL COMMENT '在职状态',
  `status` varchar(255)  DEFAULT NULL COMMENT '员工状态',
  `remarks` varchar(255)  DEFAULT NULL COMMENT '备注',
  `contactPerson` varchar(255)  DEFAULT NULL COMMENT '联系人',
  `educationExperience` varchar(255)  DEFAULT NULL COMMENT '教育经历',
  `certificate` varchar(255)  DEFAULT NULL COMMENT '证书',
  `salaryCard` varchar(255)  DEFAULT NULL COMMENT '薪资卡信息',
  `socialSecurity` varchar(255)  DEFAULT NULL COMMENT '社保卡信息',
  `trainingExperience` varchar(255)  DEFAULT NULL COMMENT '培训经历',
  `workExperience` varchar(255)  DEFAULT NULL COMMENT '工作经历',
  `operation` varchar(255)  DEFAULT NULL,
  `operationByUserId` varchar(255)  DEFAULT NULL,
  `operationByUser` varchar(255)  DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 646 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin

employee_contract

• 员工合同

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

employee_file

• 员工附件表

CREATE TABLE `employee_file` (
  `id` int(11) DEFAULT NULL COMMENT '自增主键',
  `employeeFileId` int(11) NOT NULL AUTO_INCREMENT,
  `employeeId` int(11) NOT NULL COMMENT '员工id',
  `fileId` bigint(20) NOT NULL COMMENT 'admin模块附件id',
  `type` int(11) DEFAULT NULL COMMENT '1 员工基本资料 2 员工档案资料 3 员工离职资料',
  `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',
  `createUserId` bigint(20) DEFAULT NULL,
  `createTime` datetime DEFAULT NULL COMMENT '创建时间',
  `operationByUserId` varchar(255)  DEFAULT NULL,
  `operation` varchar(255)  DEFAULT NULL,
  `operationByUser` varchar(255)  DEFAULT NULL,
  `operationAt` varchar(255)  DEFAULT NULL,
  PRIMARY KEY (`employeeFileId`) USING BTREE
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '员工附件表'

employee_quit_info

• 离职信息

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

employee_request

CREATE TABLE `employee_request` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `employeeId` varchar(255)  DEFAULT NULL COMMENT '员工编号',
  `employeeName` varchar(255)  DEFAULT NULL COMMENT '员工姓名',
  `sex` varchar(255)  DEFAULT NULL COMMENT '员工性别',
  `age` varchar(255)  DEFAULT NULL COMMENT '员工年龄',
  `contactNumber` varchar(255)  DEFAULT NULL COMMENT '联系电话',
  `icNumber` varchar(255)  DEFAULT NULL COMMENT '身份证号',
  `post` varchar(255)  DEFAULT NULL COMMENT '员工岗位',
  `teachingLevel` varchar(255)  DEFAULT NULL COMMENT '任教学段',
  `teachingSubject` varchar(255)  DEFAULT NULL COMMENT '任教学科',
  `status` varchar(255)  DEFAULT NULL COMMENT '员工状态',
  `employmentForms` varchar(255)  DEFAULT NULL COMMENT '聘用形式',
  `entryStatus` varchar(255)  DEFAULT NULL COMMENT '入职状态',
  `dateOfEntry` varchar(255)  DEFAULT NULL COMMENT '入职日期',
  `dateOfContractExpiration` varchar(255)  DEFAULT NULL COMMENT '到期日期',
  `leaveRequestStatus` varchar(255)  DEFAULT NULL COMMENT '申请离职状态',
  `remarks` varchar(255)  DEFAULT NULL COMMENT '备注',
  `operation` varchar(255)  DEFAULT NULL,
  `operationByUserId` varchar(255)  DEFAULT NULL,
  `operationByUser` varchar(255)  DEFAULT NULL,
  `operationAt` varchar(255)  DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 24 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin

insurance_month_emp_record

• 员工每月社保记录

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

insurance_month_record

• 每月社保记录

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

insurance_scheme

• 社保方案表

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

job_postings

• 招聘职位表

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

job_resume

• 简历投递信息表

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

member_org_role

• 组织员工表

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

notes

• 备忘

CREATE TABLE `notes` (
  `notesId` int(11) NOT NULL AUTO_INCREMENT,
  `content` varchar(1024)  NOT NULL,
  `employeeId` int(11) DEFAULT NULL,
  `reminderTime` datetime NOT NULL,
  `createTime` datetime DEFAULT NULL,
  `createUserId` bigint(20) NOT NULL,
  `operation` varchar(255)  DEFAULT NULL,
  `id` int(11) DEFAULT NULL,
  `operationByUserId` varchar(255)  DEFAULT NULL,
  `operationAt` varchar(255)  DEFAULT NULL,
  `operationByUser` varchar(255)  DEFAULT NULL,
  PRIMARY KEY (`notesId`) USING BTREE,
  KEY `wk_hrm_notes_employee_id_index` (`employeeId`) USING BTREE
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '备忘'

org

• 组织表

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

performance

CREATE TABLE `performance` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `performanceId` varchar(255)  NOT NULL,
  `performanceName` varchar(255)  DEFAULT NULL COMMENT '考核名称',
  `performanceCycle` varchar(255)  DEFAULT NULL COMMENT '考核周期',
  `templateId` varchar(255)  DEFAULT NULL COMMENT '考核模板',
  `templateType` varchar(255)  DEFAULT NULL COMMENT '模板类型',
  `performanceContent` text  COMMENT '考核内容',
  `actualTargetData` varchar(255)  DEFAULT NULL COMMENT '实际指标',
  `startTime` varchar(255)  DEFAULT NULL COMMENT '考核开始时间',
  `endTime` varchar(255)  DEFAULT NULL COMMENT '考核结束时间',
  `target` varchar(255)  DEFAULT NULL COMMENT '考核目标',
  `employeeId` varchar(255)  DEFAULT NULL COMMENT '考核员工Id',
  `employeeName` varchar(255)  DEFAULT NULL COMMENT '考核员工名称',
  `raterId` varchar(255)  DEFAULT NULL COMMENT '考核评分人Id',
  `raterName` varchar(255)  DEFAULT NULL COMMENT '考核评分人名称',
  `status` varchar(255)  DEFAULT NULL COMMENT '考核状态',
  `remarks` varchar(255)  DEFAULT NULL COMMENT '备注',
  `operation` varchar(255)  DEFAULT NULL,
  `operationByUserId` varchar(255)  DEFAULT NULL,
  `operationByUser` varchar(255)  DEFAULT NULL,
  `operationAt` varchar(255)  DEFAULT NULL,
  PRIMARY KEY (`id`, `performanceId`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 23 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin

performance_employee_rate

CREATE TABLE `performance_employee_rate` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `performanceId` varchar(255)  DEFAULT NULL,
  `performanceName` varchar(255)  DEFAULT NULL COMMENT '考核名称',
  `performanceContent` text  COMMENT '考核内容',
  `performanceCycle` varchar(255)  DEFAULT NULL COMMENT '考核周期',
  `templateType` varchar(255)  DEFAULT NULL COMMENT '考核模板类型',
  `startTime` varchar(255)  DEFAULT NULL COMMENT '考核开始时间',
  `endTime` varchar(255)  DEFAULT NULL COMMENT '考核结束时间',
  `actualTargetData` varchar(255)  DEFAULT NULL COMMENT '实际指标',
  `target` varchar(255)  DEFAULT NULL COMMENT '主体目标组织',
  `employeeId` varchar(255)  DEFAULT NULL COMMENT '考核员工Id',
  `employeeName` varchar(255)  DEFAULT NULL COMMENT '考核员工名称',
  `raterId` varchar(255)  DEFAULT NULL COMMENT '考核评分人Id',
  `raterName` varchar(255)  DEFAULT NULL COMMENT '考核评分人名称',
  `gradePerformance` varchar(255)  DEFAULT NULL COMMENT '指标评分',
  `status` varchar(255)  DEFAULT NULL COMMENT '考核状态',
  `remarks` varchar(255)  DEFAULT NULL COMMENT '备注',
  `operation` varchar(255)  DEFAULT NULL,
  `operationByUserId` varchar(255)  DEFAULT NULL,
  `operationByUser` varchar(255)  DEFAULT NULL,
  `operationAt` varchar(255)  DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 24 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin

performance_result

CREATE TABLE `performance_result` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `performanceId` varchar(255)  DEFAULT NULL COMMENT '考核内容',
  `performanceName` varchar(255)  DEFAULT NULL,
  `startTime` datetime DEFAULT NULL,
  `endTime` datetime DEFAULT NULL,
  `employeeId` varchar(255)  DEFAULT NULL,
  `target` varchar(255)  DEFAULT NULL,
  `templateType` varchar(255)  DEFAULT NULL,
  `employeeName` varchar(255)  DEFAULT NULL,
  `actualTargetData` varchar(255)  DEFAULT NULL,
  `raterId` varchar(255)  DEFAULT NULL,
  `raterName` varchar(255)  DEFAULT NULL,
  `gradePerformance` varchar(255)  DEFAULT NULL,
  `status` varchar(255)  DEFAULT NULL,
  `operation` varchar(255)  DEFAULT NULL,
  `operationByUserId` varchar(255)  DEFAULT NULL,
  `operationByUser` varchar(255)  DEFAULT NULL,
  `operationAt` varchar(255)  DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 14 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin

performance_tmp

CREATE TABLE `performance_tmp` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `templateId` varchar(255)  NOT NULL,
  `templateName` varchar(255)  DEFAULT NULL COMMENT '模板名称',
  `templateContent` text  COMMENT '考核内容',
  `templateType` varchar(255)  DEFAULT NULL COMMENT '类型：person | ohter',
  `status` varchar(255)  DEFAULT NULL COMMENT '考核状态',
  `remarks` varchar(255)  DEFAULT NULL COMMENT '备注',
  `operation` varchar(255)  DEFAULT NULL,
  `operationByUserId` varchar(255)  DEFAULT NULL,
  `operationByUser` varchar(255)  DEFAULT NULL,
  `operationAt` varchar(255)  DEFAULT NULL,
  PRIMARY KEY (`id`, `templateId`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 23 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin

salary_archives

• 薪资档案表

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

salary_archives_option

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

salary_change_record

• 定薪调薪记录表

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

salary_config

• 薪资初始配置

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

salary_group

• 薪资组

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

salary_month_emp_record

• 每月薪资记录

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

salary_month_record

• 每月薪资记录

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

salary_tax_rule

• 计税规则

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

业务视图

_view02_user_app

CREATE ALGORITHM = UNDEFINED DEFINER = `root` @`localhost` SQL SECURITY DEFINER VIEW `_view02_user_app` AS
select
  `jh_enterprise_v2_data_repository`.`enterprise_view02_user_app`.`id` AS `id`,
  `jh_enterprise_v2_data_repository`.`enterprise_view02_user_app`.`userId` AS `userId`,
  `jh_enterprise_v2_data_repository`.`enterprise_view02_user_app`.`appId` AS `appId`
from
  `jh_enterprise_v2_data_repository`.`enterprise_view02_user_app`
where
  (
    `jh_enterprise_v2_data_repository`.`enterprise_view02_user_app`.`appId` = 'jianghu-hr'
  )

repo_hr_user_org

CREATE ALGORITHM = UNDEFINED DEFINER = `root` @`%` SQL SECURITY DEFINER VIEW `repo_hr_user_org` AS
select
  `mor`.`id` AS `id`,
  `mor`.`memberId` AS `userId`,
  `mor`.`orgId` AS `hrOrgId`,
  `org`.`orgName` AS `hrOrgName`,
  `mor`.`roleId` AS `hrRoleId`
from
  (
    `member_org_role` `mor`
    left join `org` on ((`mor`.`orgId` = `org`.`orgId`))
  )

view01_archives_option_by_emp

CREATE ALGORITHM = UNDEFINED DEFINER = `root` @`%` SQL SECURITY DEFINER VIEW `view01_archives_option_by_emp` AS
select
  `salary_archives_option`.`employeeId` AS `employeeId`,
  sum(`salary_archives_option`.`value`) AS `totalSalary`
from
  `salary_archives_option`
group by
  `salary_archives_option`.`employeeId`

view01_attendance_clock

CREATE ALGORITHM = UNDEFINED DEFINER = `root` @`%` SQL SECURITY DEFINER VIEW `view01_attendance_clock` AS
select
  `employee`.`employeeName` AS `employeeName`,
  `attendance_clock`.`id` AS `id`,
  `attendance_clock`.`clockId` AS `clockId`,
  `attendance_clock`.`clockEmployeeId` AS `clockEmployeeId`,
  `attendance_clock`.`clockTime` AS `clockTime`,
  `attendance_clock`.`clockType` AS `clockType`,
  `attendance_clock`.`attendanceTime` AS `attendanceTime`,
  `attendance_clock`.`type` AS `type`,
  `attendance_clock`.`address` AS `address`,
  `attendance_clock`.`lng` AS `lng`,
  `attendance_clock`.`lat` AS `lat`,
  `attendance_clock`.`remark` AS `remark`,
  `attendance_clock`.`operationByUserId` AS `operationByUserId`,
  `attendance_clock`.`operation` AS `operation`,
  `attendance_clock`.`operationByUser` AS `operationByUser`,
  `attendance_clock`.`operationAt` AS `operationAt`
from
  (
    `attendance_clock`
    left join `employee` on (
      (
        `attendance_clock`.`clockEmployeeId` = `employee`.`employeeId`
      )
    )
  )

view01_employee

CREATE ALGORITHM = UNDEFINED DEFINER = `root` @`%` SQL SECURITY DEFINER VIEW `view01_employee` AS
select distinct
  `employee`.`id` AS `id`,
  `employee`.`employeeId` AS `employeeId`,
  `employee`.`employeeName` AS `employeeName`,
  `employee`.`idSequence` AS `idSequence`,
  `employee`.`sex` AS `sex`,
  `employee`.`age` AS `age`,
  `employee`.`contactNumber` AS `contactNumber`,
  `employee`.`emergencyContactNumber` AS `emergencyContactNumber`,
  `employee`.`post` AS `post`,
  `employee`.`politicalBackground` AS `politicalBackground`,
  `employee`.`icNumber` AS `icNumber`,
  `employee`.`dateOfBirth` AS `dateOfBirth`,
  `employee`.`institution` AS `institution`,
  `employee`.`major` AS `major`,
  `employee`.`highestEducation` AS `highestEducation`,
  `employee`.`teacherQualification` AS `teacherQualification`,
  `employee`.`teacherQualificationLeaver` AS `teacherQualificationLeaver`,
  `employee`.`teacherQualificationSubject` AS `teacherQualificationSubject`,
  `employee`.`teacherCertificationNumber` AS `teacherCertificationNumber`,
  `employee`.`teachingLevel` AS `teachingLevel`,
  `employee`.`teachingSubject` AS `teachingSubject`,
  `employee`.`residentialAddress` AS `residentialAddress`,
  `employee`.`province` AS `province`,
  `employee`.`city` AS `city`,
  `employee`.`county` AS `county`,
  `employee`.`dateOfEntry` AS `dateOfEntry`,
  `employee`.`dateOfContractExpiration` AS `dateOfContractExpiration`,
  `employee`.`cardNumber` AS `cardNumber`,
  `employee`.`licensePlateNumber` AS `licensePlateNumber`,
  `employee`.`employmentForms` AS `employmentForms`,
  `employee`.`entryStatus` AS `entryStatus`,
  `employee`.`status` AS `status`,
  `employee`.`remarks` AS `remarks`,
  `employee`.`leaveRequestStatus` AS `leaveRequestStatus`,
  `employee`.`contactPerson` AS `contactPerson`,
  `employee`.`educationExperience` AS `educationExperience`,
  `employee`.`certificate` AS `certificate`,
  `employee`.`salaryCard` AS `salaryCard`,
  `employee`.`socialSecurity` AS `socialSecurity`,
  `employee`.`trainingExperience` AS `trainingExperience`,
  `employee`.`workExperience` AS `workExperience`,
  `employee`.`operation` AS `operation`,
  `employee`.`operationByUserId` AS `operationByUserId`,
  `employee`.`operationByUser` AS `operationByUser`,
  `employee`.`operationAt` AS `operationAt`,
  `view01_member_org_role`.`orgId` AS `orgId`,
  `view01_member_org_role`.`orgName` AS `orgName`
from
  (
    `employee`
    left join `view01_member_org_role` on (
      (
        `employee`.`employeeId` = `view01_member_org_role`.`memberId`
      )
    )
  )

view01_employee_archives

CREATE ALGORITHM = UNDEFINED DEFINER = `root` @`%` SQL SECURITY DEFINER VIEW `view01_employee_archives` AS
select distinct
  `employee`.`employeeId` AS `employeeId`,
  `employee`.`id` AS `id`,
  `employee`.`employeeName` AS `employeeName`,
  `employee`.`county` AS `country`,
  `employee`.`status` AS `status`,
  `salary_archives`.`changeDate` AS `changeDate`,
  `salary_archives`.`changeReason` AS `changeReason`,
  `employee`.`dateOfEntry` AS `dateOfEntry`,
  `view01_archives_option_by_emp`.`totalSalary` AS `totalSalary`,
  `salary_archives`.`changeType` AS `changeType`,
  `employee`.`entryStatus` AS `entryStatus`,
  `employee`.`employmentForms` AS `employmentForms`,
  `employee`.`dateOfContractExpiration` AS `dateOfContractExpiration`
from
  (
    (
      `employee`
      left join `salary_archives` on (
        (
          `employee`.`employeeId` = `salary_archives`.`employeeId`
        )
      )
    )
    left join `view01_archives_option_by_emp` on (
      (
        `employee`.`employeeId` = `view01_archives_option_by_emp`.`employeeId`
      )
    )
  )

view01_employee_quit_list

CREATE ALGORITHM = UNDEFINED DEFINER = `root` @`%` SQL SECURITY DEFINER VIEW `view01_employee_quit_list` AS
select
  `employee`.`id` AS `id`,
  `employee`.`employeeId` AS `employeeId`,
  `employee`.`employeeName` AS `employeeName`,
  `employee`.`idSequence` AS `idSequence`,
  `employee`.`sex` AS `sex`,
  `employee`.`age` AS `age`,
  `employee`.`contactNumber` AS `contactNumber`,
  `employee`.`emergencyContactNumber` AS `emergencyContactNumber`,
  `employee`.`post` AS `post`,
  `employee`.`politicalBackground` AS `politicalBackground`,
  `employee`.`icNumber` AS `icNumber`,
  `employee`.`dateOfBirth` AS `dateOfBirth`,
  `employee`.`institution` AS `institution`,
  `employee`.`major` AS `major`,
  `employee`.`highestEducation` AS `highestEducation`,
  `employee`.`teacherQualification` AS `teacherQualification`,
  `employee`.`teacherQualificationLeaver` AS `teacherQualificationLeaver`,
  `employee`.`teacherQualificationSubject` AS `teacherQualificationSubject`,
  `employee`.`teacherCertificationNumber` AS `teacherCertificationNumber`,
  `employee`.`teachingLevel` AS `teachingLevel`,
  `employee`.`teachingSubject` AS `teachingSubject`,
  `employee`.`residentialAddress` AS `residentialAddress`,
  `employee`.`province` AS `province`,
  `employee`.`city` AS `city`,
  `employee`.`county` AS `county`,
  `employee`.`dateOfEntry` AS `dateOfEntry`,
  `employee`.`dateOfContractExpiration` AS `dateOfContractExpiration`,
  `employee`.`cardNumber` AS `cardNumber`,
  `employee`.`licensePlateNumber` AS `licensePlateNumber`,
  `employee`.`employmentForms` AS `employmentForms`,
  `employee`.`entryStatus` AS `entryStatus`,
  `employee`.`status` AS `status`,
  `employee`.`remarks` AS `remarks`,
  `employee`.`operation` AS `operation`,
  `employee`.`operationByUserId` AS `operationByUserId`,
  `employee`.`operationByUser` AS `operationByUser`,
  `employee`.`operationAt` AS `operationAt`,
  `employee_quit_info`.`planQuitTime` AS `planQuitTime`
from
  (
    `employee`
    left join `employee_quit_info` on (
      (
        `employee`.`employeeId` = `employee_quit_info`.`employeeId`
      )
    )
  )

view01_insurance_month

CREATE ALGORITHM = UNDEFINED DEFINER = `root` @`%` SQL SECURITY DEFINER VIEW `view01_insurance_month` AS
select
  `insurance_month_record`.`iRecordId` AS `iRecordId`,
  `insurance_month_record`.`title` AS `title`,
  `insurance_month_record`.`year` AS `year`,
  `insurance_month_record`.`month` AS `month`,
  count(distinct `insurance_month_emp_record`.`id`) AS `num`,
  sum(
    if(
      (`insurance_month_emp_record`.`status` = 1),
      `insurance_month_emp_record`.`personalInsuranceAmount`,
      0
    )
  ) AS `personalInsuranceAmount`,
  sum(
    if(
      (`insurance_month_emp_record`.`status` = 1),
      `insurance_month_emp_record`.`personalProvidentFundAmount`,
      0
    )
  ) AS `personalProvidentFundAmount`,
  sum(
    if(
      (`insurance_month_emp_record`.`status` = 1),
      `insurance_month_emp_record`.`corporateInsuranceAmount`,
      0
    )
  ) AS `corporateInsuranceAmount`,
  sum(
    if(
      (`insurance_month_emp_record`.`status` = 1),
      `insurance_month_emp_record`.`corporateProvidentFundAmount`,
      0
    )
  ) AS `corporateProvidentFundAmount`,
  count(
    if(
      (`insurance_month_emp_record`.`status` = 0),
      `insurance_month_emp_record`.`iEmpRecordId`,
      NULL
    )
  ) AS `stopCount`,
  `insurance_month_record`.`status` AS `monthStatus`
from
  (
    `insurance_month_record`
    left join `insurance_month_emp_record` on (
      (
        (
          `insurance_month_record`.`year` = `insurance_month_emp_record`.`year`
        )
        and (
          `insurance_month_record`.`month` = `insurance_month_emp_record`.`month`
        )
        and (
          `insurance_month_record`.`iRecordId` = `insurance_month_emp_record`.`iRecordId`
        )
      )
    )
  )
group by
  `insurance_month_record`.`year`,
  `insurance_month_record`.`month`

view01_insurance_scheme

CREATE ALGORITHM = UNDEFINED DEFINER = `root` @`%` SQL SECURITY DEFINER VIEW `view01_insurance_scheme` AS
select
  `insurance_month_record`.`iRecordId` AS `iRecordId`,
  `insurance_month_record`.`title` AS `title`,
  `insurance_month_record`.`year` AS `year`,
  `insurance_month_record`.`month` AS `month`,
  count(`insurance_month_emp_record`.`id`) AS `num`,
  sum(
    if(
      (`insurance_month_emp_record`.`status` = 1),
      `insurance_month_emp_record`.`personalInsuranceAmount`,
      0
    )
  ) AS `personalInsuranceAmount`,
  sum(
    if(
      (`insurance_month_emp_record`.`status` = 1),
      `insurance_month_emp_record`.`personalProvidentFundAmount`,
      0
    )
  ) AS `personalProvidentFundAmount`,
  sum(
    if(
      (`insurance_month_emp_record`.`status` = 1),
      `insurance_month_emp_record`.`corporateInsuranceAmount`,
      0
    )
  ) AS `corporateInsuranceAmount`,
  sum(
    if(
      (`insurance_month_emp_record`.`status` = 1),
      `insurance_month_emp_record`.`corporateProvidentFundAmount`,
      0
    )
  ) AS `corporateProvidentFundAmount`,
  count(
    if(
      (`insurance_month_emp_record`.`status` = 0),
      `insurance_month_emp_record`.`iEmpRecordId`,
      NULL
    )
  ) AS `stopCount`,
  `insurance_month_record`.`status` AS `monthStatus`
from
  (
    `insurance_month_record`
    left join `insurance_month_emp_record` on (
      (
        (
          `insurance_month_record`.`year` = `insurance_month_emp_record`.`year`
        )
        and (
          `insurance_month_record`.`month` = `insurance_month_emp_record`.`month`
        )
        and (
          `insurance_month_record`.`iRecordId` = `insurance_month_emp_record`.`iRecordId`
        )
      )
    )
  )
group by
  `insurance_month_record`.`year`,
  `insurance_month_record`.`month`

view01_job_resume

CREATE ALGORITHM = UNDEFINED DEFINER = `root` @`%` SQL SECURITY DEFINER VIEW `view01_job_resume` AS
select
  `job_resume`.`id` AS `id`,
  `job_resume`.`jobId` AS `jobId`,
  `job_resume`.`jobTitle` AS `jobTitle`,
  `job_resume`.`jobResumeId` AS `jobResumeId`,
  `job_resume`.`user` AS `user`,
  `job_resume`.`gender` AS `gender`,
  `job_resume`.`age` AS `age`,
  `job_resume`.`ethnicity` AS `ethnicity`,
  `job_resume`.`height` AS `height`,
  `job_resume`.`weight` AS `weight`,
  `job_resume`.`bloodType` AS `bloodType`,
  `job_resume`.`maritalStatus` AS `maritalStatus`,
  `job_resume`.`politicalAffiliation` AS `politicalAffiliation`,
  `job_resume`.`physicalCondition` AS `physicalCondition`,
  `job_resume`.`religiousBeliefs` AS `religiousBeliefs`,
  `job_resume`.`phoneNumber` AS `phoneNumber`,
  `job_resume`.`IDNumber` AS `IDNumber`,
  `job_resume`.`email` AS `email`,
  `job_resume`.`highestEducation` AS `highestEducation`,
  `job_resume`.`wechatID` AS `wechatID`,
  `job_resume`.`nativePlace` AS `nativePlace`,
  `job_resume`.`homeAddress` AS `homeAddress`,
  `job_resume`.`currentAddress` AS `currentAddress`,
  `job_resume`.`academicRanking` AS `academicRanking`,
  `job_resume`.`workplace` AS `workplace`,
  `job_resume`.`salaryExpectation` AS `salaryExpectation`,
  `job_resume`.`domicilePlace` AS `domicilePlace`,
  `job_resume`.`earliestAvailability` AS `earliestAvailability`,
  `job_resume`.`education` AS `education`,
  `job_resume`.`educationCertificate` AS `educationCertificate`,
  `job_resume`.`experience` AS `experience`,
  `job_resume`.`familyMember` AS `familyMember`,
  `job_resume`.`teacherContact` AS `teacherContact`,
  `job_resume`.`studentSocialization` AS `studentSocialization`,
  `job_resume`.`socialActivities` AS `socialActivities`,
  `job_resume`.`achievement` AS `achievement`,
  `job_resume`.`socialHobbies` AS `socialHobbies`,
  `job_resume`.`personality` AS `personality`,
  `job_resume`.`careerPlanning` AS `careerPlanning`,
  `job_resume`.`offence` AS `offence`,
  `job_resume`.`resumeStatus` AS `resumeStatus`,
  `job_resume`.`operation` AS `operation`,
  `job_resume`.`operationByUserId` AS `operationByUserId`,
  `job_resume`.`operationByUser` AS `operationByUser`,
  `job_resume`.`operationAt` AS `operationAt`
from
  `job_resume`

view01_member_org_role

CREATE ALGORITHM = UNDEFINED DEFINER = `root` @`%` SQL SECURITY DEFINER VIEW `view01_member_org_role` AS
select
  `member_org_role`.`id` AS `id`,
  `member_org_role`.`orgId` AS `orgId`,
  `member_org_role`.`memberId` AS `memberId`,
  `member_org_role`.`roleId` AS `roleId`,
  `member_org_role`.`remark` AS `remark`,
  `org`.`orgParentId` AS `orgParentId`,
  `org`.`orgName` AS `orgName`,
  `employee`.`employeeId` AS `employeeId`,
  `employee`.`employeeName` AS `employeeName`,
  `employee`.`idSequence` AS `idSequence`,
  `employee`.`sex` AS `sex`,
  `employee`.`age` AS `age`,
  `employee`.`contactNumber` AS `contactNumber`,
  `employee`.`emergencyContactNumber` AS `emergencyContactNumber`,
  `employee`.`post` AS `post`,
  `employee`.`politicalBackground` AS `politicalBackground`,
  `employee`.`icNumber` AS `icNumber`,
  `employee`.`dateOfBirth` AS `dateOfBirth`,
  `employee`.`institution` AS `institution`,
  `employee`.`major` AS `major`,
  `employee`.`highestEducation` AS `highestEducation`,
  `employee`.`teacherQualification` AS `teacherQualification`,
  `employee`.`teacherQualificationLeaver` AS `teacherQualificationLeaver`,
  `employee`.`teacherQualificationSubject` AS `teacherQualificationSubject`,
  `employee`.`teacherCertificationNumber` AS `teacherCertificationNumber`,
  `employee`.`teachingLevel` AS `teachingLevel`,
  `employee`.`teachingSubject` AS `teachingSubject`,
  `employee`.`residentialAddress` AS `residentialAddress`,
  `employee`.`province` AS `province`,
  `employee`.`city` AS `city`,
  `employee`.`county` AS `county`,
  `employee`.`dateOfEntry` AS `dateOfEntry`,
  `employee`.`dateOfContractExpiration` AS `dateOfContractExpiration`,
  `employee`.`cardNumber` AS `cardNumber`,
  `employee`.`licensePlateNumber` AS `licensePlateNumber`,
  `employee`.`employmentForms` AS `employmentForms`,
  `employee`.`entryStatus` AS `entryStatus`,
  `employee`.`status` AS `status`,
  `employee`.`remarks` AS `remarks`
from
  (
    (
      `member_org_role`
      left join `org` on ((`member_org_role`.`orgId` = `org`.`orgId`))
    )
    left join `employee` on (
      (
        `member_org_role`.`memberId` = `employee`.`employeeId`
      )
    )
  )

view01_salary_group_rule

CREATE ALGORITHM = UNDEFINED DEFINER = `root` @`%` SQL SECURITY DEFINER VIEW `view01_salary_group_rule` AS
select
  `salary_group`.`id` AS `id`,
  `salary_group`.`groupId` AS `groupId`,
  `salary_group`.`groupName` AS `groupName`,
  `salary_group`.`deptIds` AS `deptIds`,
  `salary_group`.`employeeIds` AS `employeeIds`,
  `salary_group`.`salaryStandard` AS `salaryStandard`,
  `salary_group`.`changeRule` AS `changeRule`,
  `salary_group`.`ruleId` AS `ruleId`,
  `salary_group`.`createTime` AS `createTime`,
  `salary_group`.`createUserId` AS `createUserId`,
  `salary_group`.`operationByUser` AS `operationByUser`,
  `salary_group`.`operation` AS `operation`,
  `salary_group`.`operationByUserId` AS `operationByUserId`,
  `salary_group`.`operationAt` AS `operationAt`,
  `salary_tax_rule`.`taxType` AS `taxType`,
  `salary_tax_rule`.`isTax` AS `isTax`,
  `salary_tax_rule`.`ruleName` AS `ruleName`,
  `salary_tax_rule`.`markingPoint` AS `markingPoint`,
  `salary_tax_rule`.`decimalPoint` AS `decimalPoint`,
  `salary_tax_rule`.`cycleType` AS `cycleType`
from
  (
    `salary_group`
    left join `salary_tax_rule` on (
      (
        `salary_group`.`ruleId` = `salary_tax_rule`.`ruleId`
      )
    )
  )

view01_salary_month_record

CREATE ALGORITHM = UNDEFINED DEFINER = `root` @`%` SQL SECURITY DEFINER VIEW `view01_salary_month_record` AS
select
  `salary_month_record`.`id` AS `id`,
  `salary_month_record`.`sRecordId` AS `sRecordId`,
  `salary_month_record`.`title` AS `title`,
  `salary_month_record`.`year` AS `year`,
  `salary_month_record`.`month` AS `month`,
  `salary_month_record`.`startTime` AS `startTime`,
  `salary_month_record`.`endTime` AS `endTime`,
  `salary_month_record`.`personalInsuranceAmount` AS `personalInsuranceAmount`,
  `salary_month_record`.`personalProvidentFundAmount` AS `personalProvidentFundAmount`,
  `salary_month_record`.`corporateInsuranceAmount` AS `corporateInsuranceAmount`,
  `salary_month_record`.`corporateProvidentFundAmount` AS `corporateProvidentFundAmount`,
  `salary_month_record`.`expectedPaySalary` AS `expectedPaySalary`,
  `salary_month_record`.`personalTax` AS `personalTax`,
  `salary_month_record`.`realPaySalary` AS `realPaySalary`,
  `salary_month_record`.`optionHead` AS `optionHead`,
  `salary_month_record`.`examineRecordId` AS `examineRecordId`,
  `salary_month_record`.`checkStatus` AS `checkStatus`,
  `salary_month_record`.`createUserId` AS `createUserId`,
  `salary_month_record`.`createTime` AS `createTime`,
  `salary_month_record`.`operation` AS `operation`,
  `salary_month_record`.`operationByUserId` AS `operationByUserId`,
  `salary_month_record`.`operationByUser` AS `operationByUser`,
  `salary_month_record`.`operationAt` AS `operationAt`,
  count(`salary_month_emp_record`.`id`) AS `num`
from
  (
    `salary_month_record`
    left join `salary_month_emp_record` on (
      (
        (
          `salary_month_record`.`year` = `salary_month_emp_record`.`year`
        )
        and (
          `salary_month_record`.`month` = `salary_month_emp_record`.`month`
        )
      )
    )
  )
group by
  `salary_month_record`.`id`

view02_performance_employee_rate

CREATE ALGORITHM = UNDEFINED DEFINER = `root` @`%` SQL SECURITY DEFINER VIEW `view02_performance_employee_rate` AS
select
  `performance_employee_rate`.`id` AS `id`,
  `performance_employee_rate`.`performanceId` AS `performanceId`,
  `performance_employee_rate`.`performanceName` AS `performanceName`,
  `performance_employee_rate`.`performanceContent` AS `performanceContent`,
  `performance_employee_rate`.`performanceCycle` AS `performanceCycle`,
  `performance_employee_rate`.`startTime` AS `startTime`,
  `performance_employee_rate`.`endTime` AS `endTime`,
  `performance_employee_rate`.`actualTargetData` AS `actualTargetData`,
  `performance_employee_rate`.`employeeId` AS `employeeId`,
  `performance_employee_rate`.`employeeName` AS `employeeName`,
  `performance_employee_rate`.`raterId` AS `raterId`,
  `performance_employee_rate`.`raterName` AS `raterName`,
  `performance_employee_rate`.`gradePerformance` AS `gradePerformance`,
  `performance_employee_rate`.`status` AS `status`,
  `performance_employee_rate`.`remarks` AS `remarks`,
  `performance_employee_rate`.`operation` AS `operation`,
  `performance_employee_rate`.`operationByUserId` AS `operationByUserId`,
  `performance_employee_rate`.`operationByUser` AS `operationByUser`,
  `performance_employee_rate`.`operationAt` AS `operationAt`
from
  `performance_employee_rate`