Data Structures
12129表总览
通用表
- _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_binemployee_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_bininsurance_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_binperformance_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_binperformance_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_binperformance_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_binsalary_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 = utf8mb4salary_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`