Data Structures

12111

Table Overview

General Tables

Business Tables

_ui

UI Construction Plan

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 action type, e.g.: fetchData, postData, changeUi',
  `uiActionId` varchar(255)  DEFAULT NULL COMMENT 'action id; E.g: selectXXXByXXX',
  `desc` varchar(255)  DEFAULT NULL COMMENT 'description',
  `uiActionConfig` text  COMMENT 'UI action data',
  `appDataSchema` text  COMMENT 'UI validation data',
  `operation` varchar(255)  DEFAULT 'insert' COMMENT 'operation; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  `operationByUserId` varchar(255)  DEFAULT NULL COMMENT 'operator userId',
  `operationByUser` varchar(255)  DEFAULT NULL COMMENT 'operator username',
  `operationAt` varchar(255)  DEFAULT NULL COMMENT 'operation time; E.g: 2021-05-28T10:24:54+08:00 ',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = 'UI construction plan'

achievement_appraisal

Performance Appraisal

CREATE TABLE `achievement_appraisal` (
  `id` int(11) DEFAULT NULL COMMENT 'auto-increment primary key',
  `appraisalId` int(11) NOT NULL AUTO_INCREMENT,
  `appraisalName` varchar(50)  DEFAULT NULL COMMENT 'appraisal name',
  `cycleType` int(11) DEFAULT NULL COMMENT '1 month 2 quarter 3 year 4 half year',
  `startTime` date DEFAULT NULL COMMENT 'appraisal start time',
  `endTime` date DEFAULT NULL COMMENT 'appraisal end time',
  `tableId` int(11) DEFAULT NULL COMMENT 'appraisal table template id',
  `writtenBy` int(11) DEFAULT '1' COMMENT 'appraisal target writer 1 self',
  `resultConfirmors` varchar(1024)  DEFAULT NULL COMMENT 'appraisal result confirmers\n',
  `fullScore` decimal(7, 2) DEFAULT NULL COMMENT 'total score for appraisal',
  `isForce` int(11) DEFAULT NULL COMMENT 'whether to enable forced distribution 1 yes 0 no',
  `employeeIds` varchar(1024)  DEFAULT NULL COMMENT 'appraisal employees',
  `deptIds` varchar(1024)  DEFAULT NULL COMMENT 'appraisal departments',
  `appraisalSteps` int(11) DEFAULT '-1' COMMENT 'appraisal step progress',
  `activateSteps` int(11) DEFAULT '-1' COMMENT 'ongoing step progress',
  `status` int(11) DEFAULT '0' COMMENT 'performance status 0 not started 1 performance filling 2 performance evaluation 3 result confirmation 4 archived',
  `isStop` int(11) DEFAULT '0' COMMENT 'whether to terminate 0 no 1 yes',
  `stopTime` datetime DEFAULT NULL COMMENT 'termination time',
  `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 = 'performance appraisal'

achievement_appraisal_evaluators

Appraisal Result Evaluators

CREATE TABLE `achievement_appraisal_evaluators` (
  `id` int(11) DEFAULT NULL COMMENT 'auto-increment primary key',
  `evaluatorsId` int(11) NOT NULL AUTO_INCREMENT,
  `appraisalId` int(11) NOT NULL COMMENT 'appraisal id',
  `type` int(11) NOT NULL COMMENT '1 employee self 2 direct supervisor 3 department head 4 upper department head 5 designated target confirmer',
  `employeeId` int(11) DEFAULT NULL COMMENT 'designated confirmer id',
  `weight` decimal(5, 2) NOT NULL COMMENT 'weight',
  `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 = 'appraisal result evaluators'

achievement_appraisal_score_level

Appraisal Rule Levels

CREATE TABLE `achievement_appraisal_score_level` (
  `id` int(11) DEFAULT NULL COMMENT 'auto-increment primary key',
  `levelId` int(11) NOT NULL AUTO_INCREMENT,
  `appraisalId` int(11) NOT NULL COMMENT 'appraisal id',
  `levelName` varchar(50)  NOT NULL COMMENT 'level name',
  `minScore` decimal(7, 2) DEFAULT NULL COMMENT 'minimum score',
  `maxScore` decimal(7, 2) NOT NULL COMMENT 'maximum score',
  `minNum` int(11) NOT NULL COMMENT 'minimum number ratio',
  `maxNum` int(11) NOT NULL COMMENT 'maximum number ratio',
  `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 = 'appraisal rule levels'

achievement_appraisal_target_confirmors

Appraisal Target Confirmers

CREATE TABLE `achievement_appraisal_target_confirmors` (
  `id` int(11) DEFAULT NULL COMMENT 'auto-increment primary key',
  `targetConfirmorsId` int(11) NOT NULL AUTO_INCREMENT,
  `appraisalId` int(11) DEFAULT NULL COMMENT 'appraisal id',
  `type` int(11) DEFAULT NULL COMMENT '1 employee self 2 direct supervisor 3 department head 4 upper department head 5 designated target confirmer',
  `employeeId` int(11) DEFAULT NULL COMMENT 'designated confirmer id',
  `sort` int(11) DEFAULT NULL COMMENT 'step number from small to large',
  `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 = 'appraisal target confirmers'

achievement_employee_appraisal

Employee Performance Appraisal

CREATE TABLE `achievement_employee_appraisal` (
  `id` int(11) DEFAULT NULL COMMENT 'auto-increment primary key',
  `employeeAppraisalId` int(11) NOT NULL AUTO_INCREMENT,
  `employeeId` int(11) NOT NULL COMMENT 'employee id',
  `appraisalId` int(11) DEFAULT NULL COMMENT 'performance id',
  `status` int(11) DEFAULT NULL COMMENT 'appraisal status 1 pending filling 2 pending target confirmation 3 pending evaluation 4 pending result confirmation 5 terminated performance 6 appraisal completed',
  `score` double(10, 2) DEFAULT NULL COMMENT 'score',
  `levelId` int(11) DEFAULT NULL COMMENT 'appraisal result',
  `readStatus` int(11) DEFAULT '0' COMMENT 'result reading status 0 unread 1 read',
  `followUpEmployeeId` int(11) DEFAULT NULL COMMENT 'follow-up employee id',
  `followSort` int(11) DEFAULT NULL COMMENT 'follow-up employee sorting',
  `createTime` datetime DEFAULT NULL,
  `isDraft` int(11) DEFAULT '0' COMMENT 'is draft 0 no 1 yes',
  `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 = 'employee performance appraisal'

achievement_employee_evaluato

Employee Performance Result Evaluation Table

CREATE TABLE `achievement_employee_evaluato` (
  `id` int(11) DEFAULT NULL COMMENT 'auto-increment primary key',
  `employeeEvaluatoId` int(11) NOT NULL AUTO_INCREMENT,
  `employeeAppraisalId` int(11) DEFAULT NULL COMMENT 'employee side appraisal id',
  `appraisalId` int(11) DEFAULT NULL COMMENT 'performance id',
  `employeeId` int(11) NOT NULL COMMENT 'confirmer',
  `weight` decimal(5, 2) DEFAULT NULL COMMENT 'weight',
  `score` decimal(7, 2) DEFAULT NULL COMMENT 'score',
  `levelId` int(11) DEFAULT NULL COMMENT 'appraisal level',
  `evaluate` varchar(1024)  DEFAULT NULL COMMENT 'comments',
  `rejectReason` varchar(1024)  DEFAULT NULL COMMENT 'rejection reason',
  `createTime` datetime DEFAULT NULL,
  `updateTime` datetime DEFAULT NULL,
  `sort` int(11) DEFAULT NULL,
  `status` int(11) DEFAULT '0' COMMENT '0 pending evaluation 1 evaluated',
  `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 = 'employee performance result evaluation table'

achievement_employee_evaluato_seg

Employee Performance Appraisal Item Evaluation Table

CREATE TABLE `achievement_employee_evaluato_seg` (
  `id` int(11) DEFAULT NULL COMMENT 'auto-increment primary key',
  `employeeEvaluatoSegId` int(11) NOT NULL AUTO_INCREMENT,
  `employeeAppraisalId` int(11) DEFAULT NULL COMMENT 'employee side appraisal id',
  `employeeEvaluatoId` int(11) DEFAULT NULL COMMENT 'result evaluation id',
  `segId` int(11) DEFAULT NULL COMMENT 'appraisal item id',
  `employeeId` int(11) NOT NULL COMMENT 'evaluator',
  `score` decimal(7, 2) DEFAULT NULL COMMENT 'score',
  `evaluate` varchar(1024)  DEFAULT NULL COMMENT 'comments',
  `status` int(11) DEFAULT '1' COMMENT '0 pending evaluation 1 evaluated',
  `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 = 'employee performance appraisal item evaluation table'

achievement_employee_result_confirmors

Performance Result Confirmation Table

CREATE TABLE `achievement_employee_result_confirmors` (
  `id` int(11) DEFAULT NULL COMMENT 'auto-increment primary key',
  `confirmorsId` int(11) NOT NULL AUTO_INCREMENT,
  `employeeId` int(11) DEFAULT NULL,
  `appraisalId` int(11) DEFAULT NULL COMMENT 'performance id',
  `status` int(11) DEFAULT '0' COMMENT '0 not confirmed 1 confirmed',
  `sort` int(11) DEFAULT NULL,
  `createTime` datetime DEFAULT NULL COMMENT 'creation time',
  `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 = 'performance result confirmation table'

achievement_employee_seg

Employee Performance Appraisal Item

CREATE TABLE `achievement_employee_seg` (
  `id` int(11) DEFAULT NULL COMMENT 'auto-increment primary key',
  `segId` int(11) NOT NULL AUTO_INCREMENT,
  `employeeAppraisalId` int(11) DEFAULT NULL,
  `tempSegId` int(11) DEFAULT '0' COMMENT 'template appraisal item id',
  `employeeId` int(11) DEFAULT NULL,
  `segName` varchar(50)  DEFAULT NULL COMMENT 'appraisal item name',
  `value` varchar(255)  DEFAULT NULL COMMENT 'value',
  `isFixed` int(11) DEFAULT NULL COMMENT 'is fixed 1 yes 0 no',
  `weight` decimal(5, 2) DEFAULT NULL COMMENT 'weight -1 employee writes weight ratio 0~100',
  `schedule` int(11) DEFAULT '0' COMMENT 'target progress',
  `explainDesc` varchar(1024)  DEFAULT NULL COMMENT 'completion status description',
  `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 = 'employee performance appraisal item'

achievement_employee_seg_item

Employee Appraisal Item Options

CREATE TABLE `achievement_employee_seg_item` (
  `id` int(11) DEFAULT NULL COMMENT 'auto-increment primary key',
  `itemId` int(11) NOT NULL AUTO_INCREMENT,
  `segId` int(11) DEFAULT NULL,
  `tempItemId` int(11) DEFAULT '0' COMMENT 'template appraisal item id',
  `itemName` varchar(50)  DEFAULT NULL COMMENT 'option name',
  `value` varchar(255)  DEFAULT NULL COMMENT 'value',
  `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 = 'employee appraisal item options'

achievement_employee_target_confirm

Employee Appraisal Target Confirmation Table

CREATE TABLE `achievement_employee_target_confirm` (
  `id` int(11) DEFAULT NULL COMMENT 'auto-increment primary key',
  `employeeConfirmId` int(11) NOT NULL AUTO_INCREMENT,
  `employeeAppraisalId` int(11) DEFAULT NULL COMMENT 'employee side appraisal id',
  `appraisalId` int(11) DEFAULT NULL COMMENT 'performance id',
  `employeeId` int(11) NOT NULL COMMENT 'confirmer',
  `rejectReason` varchar(1024)  DEFAULT NULL COMMENT 'rejection reason',
  `createTime` datetime DEFAULT NULL,
  `updateTime` datetime DEFAULT NULL,
  `sort` int(11) DEFAULT NULL,
  `status` int(11) DEFAULT '0' COMMENT '0 pending confirmation 1 confirmed 2 rejected ',
  `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 = 'employee appraisal target confirmation table'

achievement_seg

Performance Appraisal Item Template

CREATE TABLE `achievement_seg` (
  `id` int(11) DEFAULT NULL COMMENT 'auto-increment primary key',
  `segId` int(11) NOT NULL AUTO_INCREMENT,
  `tableId` int(11) DEFAULT NULL,
  `segName` varchar(50)  DEFAULT NULL COMMENT 'appraisal item name',
  `isFixed` int(11) DEFAULT NULL COMMENT 'is fixed 1 yes 0 no',
  `weight` decimal(5, 2) DEFAULT NULL COMMENT 'weight -1 employee writes weight ratio 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 = 'performance appraisal item template'

achievement_seg_item

Appraisal Item Options

CREATE TABLE `achievement_seg_item` (
  `id` int(11) DEFAULT NULL COMMENT 'auto-increment primary key',
  `itemId` int(11) NOT NULL AUTO_INCREMENT,
  `segId` int(11) DEFAULT NULL,
  `itemName` varchar(50)  DEFAULT NULL COMMENT 'option name',
  `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 = 'appraisal item options'

achievement_table

Performance Appraisal Table Template

CREATE TABLE `achievement_table` (
  `id` int(11) DEFAULT NULL COMMENT 'auto-increment primary key',
  `tableId` int(11) NOT NULL AUTO_INCREMENT,
  `tableName` varchar(50)  DEFAULT NULL COMMENT 'appraisal name',
  `type` int(11) DEFAULT NULL COMMENT '1 OKR template 2 KPI template',
  `description` longtext  COMMENT 'appraisal table description',
  `isEmpWeight` int(11) DEFAULT '0' COMMENT 'whether employees fill weight 0 no 1 yes',
  `status` int(11) DEFAULT '1' COMMENT ' 1 active 0 deleted',
  `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 = 'performance appraisal table template'

attendance_clock

Clock-in Record Table

CREATE TABLE `attendance_clock` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'auto-increment primary key',
  `clockId` varchar(255)  NOT NULL COMMENT 'clock-in record id',
  `clockEmployeeId` varchar(255)  DEFAULT NULL,
  `clockTime` varchar(255)  NOT NULL COMMENT 'clock-in time',
  `clockType` int(11) NOT NULL COMMENT 'clock-in type 1 clock-in 2 clock-out',
  `attendanceTime` varchar(255)  NOT NULL COMMENT 'work date',
  `type` int(11) NOT NULL DEFAULT '1' COMMENT 'clock-in type 1 mobile clock-in 2 manual entry',
  `address` varchar(255)  NOT NULL COMMENT 'attendance address',
  `lng` varchar(50)  DEFAULT NULL COMMENT 'longitude',
  `lat` varchar(50)  DEFAULT NULL COMMENT 'latitude',
  `remark` varchar(255)  DEFAULT NULL COMMENT 'remark',
  `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 = 'clock-in record table'

employee

CREATE TABLE `employee` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `employeeId` varchar(255)  DEFAULT NULL COMMENT 'employee id',
  `employeeName` varchar(255)  DEFAULT NULL COMMENT 'employee name',
  `idSequence` int(11) DEFAULT NULL COMMENT 'employee sequence number',
  `sex` varchar(255)  DEFAULT NULL COMMENT 'employee gender',
  `age` int(11) DEFAULT NULL COMMENT 'employee age',
  `contactNumber` varchar(255)  DEFAULT NULL COMMENT 'contact number',
  `emergencyContactNumber` varchar(255)  DEFAULT NULL COMMENT 'emergency contact number',
  `post` varchar(255)  DEFAULT NULL COMMENT 'position 1',
  `post2` varchar(255)  DEFAULT NULL COMMENT 'position 2',
  `post3` varchar(255)  DEFAULT NULL COMMENT 'position 3',
  `politicalBackground` varchar(255)  DEFAULT NULL COMMENT 'political background',
  `icNumber` varchar(255)  DEFAULT NULL COMMENT 'ID number',
  `dateOfBirth` varchar(255)  DEFAULT NULL COMMENT 'date of birth',
  `institution` varchar(255)  DEFAULT NULL COMMENT 'graduated school',
  `major` varchar(255)  DEFAULT NULL COMMENT 'major',
  `highestEducation` varchar(255)  DEFAULT NULL COMMENT 'highest education level',
  `teacherQualification` varchar(255)  DEFAULT NULL COMMENT 'teacher qualification category',
  `teacherQualificationLeaver` varchar(255)  DEFAULT NULL COMMENT 'teacher qualification grade',
  `teacherQualificationSubject` varchar(255)  DEFAULT NULL COMMENT 'teacher qualification subject',
  `teacherCertificationNumber` varchar(255)  DEFAULT NULL COMMENT 'teacher qualification number',
  `teachingLevel` varchar(255)  DEFAULT NULL COMMENT 'teaching grade',
  `teachingSubject` varchar(255)  DEFAULT NULL COMMENT 'teaching subject',
  `residentialAddress` varchar(255)  DEFAULT NULL COMMENT 'home address',
  `province` varchar(255)  DEFAULT NULL COMMENT 'province',
  `city` varchar(255)  DEFAULT NULL COMMENT 'city',
  `county` varchar(255)  DEFAULT NULL COMMENT 'county',
  `operationAt` varchar(255)  DEFAULT NULL,
  `dateOfEntry` varchar(255)  DEFAULT NULL COMMENT 'date of entry',
  `dateOfContractExpiration` varchar(255)  DEFAULT NULL COMMENT 'expiration date',
  `leaveRequestStatus` varchar(255)  DEFAULT NULL COMMENT 'leave request status',
  `cardNumber` varchar(255)  DEFAULT NULL COMMENT 'bank card number',
  `licensePlateNumber` varchar(255)  DEFAULT NULL COMMENT 'license plate number',
  `employmentForms` varchar(255)  DEFAULT NULL COMMENT 'employment form',
  `probationPeriod` varchar(255)  DEFAULT NULL COMMENT 'probation period',
  `entryStatus` varchar(255)  DEFAULT NULL COMMENT 'employment status',
  `status` varchar(255)  DEFAULT NULL COMMENT 'employee status',
  `remarks` varchar(255)  DEFAULT NULL COMMENT 'remarks',
  `contactPerson` varchar(255)  DEFAULT NULL COMMENT 'contact person',
  `educationExperience` varchar(255)  DEFAULT NULL COMMENT 'education experience',
  `certificate` varchar(255)  DEFAULT NULL COMMENT 'certificate',
  `salaryCard` varchar(255)  DEFAULT NULL COMMENT 'salary card information',
  `socialSecurity` varchar(255)  DEFAULT NULL COMMENT 'social security card information',
  `trainingExperience` varchar(255)  DEFAULT NULL COMMENT 'training experience',
  `workExperience` varchar(255)  DEFAULT NULL COMMENT 'work experience',
  `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

Employee Contract

CREATE TABLE `employee_contract` (
  `id` int(11) DEFAULT NULL COMMENT 'auto-increment primary key',
  `contractId` int(11) NOT NULL AUTO_INCREMENT,
  `employeeId` int(11) NOT NULL,
  `contractNum` varchar(40)  DEFAULT NULL COMMENT 'contract number',
  `contractType` int(11) DEFAULT NULL COMMENT '1 fixed-term labor contract 2 indefinite-term labor contract 3 labor contract for completing certain work tasks 4 internship agreement 5 labor contract 6 re-employment agreement 7 labor dispatch contract 8 secondment contract 9 other',
  `startTime` datetime DEFAULT NULL,
  `endTime` datetime DEFAULT NULL,
  `term` int(11) DEFAULT NULL COMMENT 'term',
  `status` int(11) DEFAULT NULL COMMENT 'contract status 0 not executed 1 in execution 2 expired',
  `signCompany` varchar(255)  DEFAULT NULL COMMENT 'signing company',
  `signTime` datetime DEFAULT NULL COMMENT 'contract signing date',
  `remarks` varchar(255)  DEFAULT NULL COMMENT 'remarks',
  `isExpireRemind` int(11) DEFAULT NULL COMMENT 'is expiration reminder 0 no 1 yes',
  `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 contract'

employee_file

Employee Attachment Table

CREATE TABLE `employee_file` (
  `id` int(11) DEFAULT NULL COMMENT 'auto-increment primary key',
  `employeeFileId` int(11) NOT NULL AUTO_INCREMENT,
  `employeeId` int(11) NOT NULL COMMENT 'employee id',
  `fileId` bigint(20) NOT NULL COMMENT 'admin module attachment id',
  `type` int(11) DEFAULT NULL COMMENT '1 employee basic information 2 employee file information 3 employee resignation information',
  `subType` int(11) NOT NULL COMMENT '11 ID card original 12 education certificate 13 personal ID photo 14 ID card copy 15 salary bank card 16 social security card 17 provident fund card 18 award certificate 19 other 21 labor contract 22 entry resume 23 entry registration form 24 entry physical examination form 25 resignation certificate 26 regularization application form 27 other\n31 resignation approval 32 resignation certificate 33 other\n',
  `createUserId` bigint(20) DEFAULT NULL,
  `createTime` datetime DEFAULT NULL COMMENT 'creation time',
  `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 attachment table'

employee_quit_info

Resignation Information

CREATE TABLE `employee_quit_info` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'auto-increment primary key',
  `quitInfoId` varchar(100)  NOT NULL,
  `employeeId` varchar(100)  DEFAULT NULL,
  `planQuitTime` datetime DEFAULT NULL COMMENT 'planned resignation date',
  `applyQuitTime` datetime DEFAULT NULL COMMENT 'resignation application date',
  `salarySettlementTime` datetime DEFAULT NULL COMMENT 'salary settlement date',
  `quitType` int(11) DEFAULT NULL COMMENT 'resignation type 1 voluntary resignation 2 involuntary resignation 3 retirement',
  `quitReason` int(11) DEFAULT NULL COMMENT 'resignation reason 1 family reasons 2 health reasons 3 salary reasons 4 inconvenient transportation 5 work pressure 6 management issues 7 no promotion opportunities 8 career planning 9 contract expiration and refusal to renew 10 other personal reasons 11 dismissal during probation 12 violation of company regulations 13 organizational adjustment/redundancy 14 dismissal for performance not meeting standards 15 non-renewal of contract upon expiration 16 other reasons for involuntary resignation',
  `remarks` varchar(255)  DEFAULT NULL COMMENT 'remarks',
  `oldStatus` int(11) DEFAULT NULL COMMENT 'status before resignation',
  `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 = 'resignation information'

employee_request

CREATE TABLE `employee_request` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `employeeId` varchar(255)  DEFAULT NULL COMMENT 'employee number',
  `employeeName` varchar(255)  DEFAULT NULL COMMENT 'employee name',
  `sex` varchar(255)  DEFAULT NULL COMMENT 'employee gender',
  `age` varchar(255)  DEFAULT NULL COMMENT 'employee age',
  `contactNumber` varchar(255)  DEFAULT NULL COMMENT 'contact number',
  `icNumber` varchar(255)  DEFAULT NULL COMMENT 'ID number',
  `post` varchar(255)  DEFAULT NULL COMMENT 'employee position',
  `teachingLevel` varchar(255)  DEFAULT NULL COMMENT 'teaching grade',
  `teachingSubject` varchar(255)  DEFAULT NULL COMMENT 'teaching subject',
  `status` varchar(255)  DEFAULT NULL COMMENT 'employee status',
  `employmentForms` varchar(255)  DEFAULT NULL COMMENT 'employment form',
  `entryStatus` varchar(255)  DEFAULT NULL COMMENT 'entry status',
  `dateOfEntry` varchar(255)  DEFAULT NULL COMMENT 'entry date',
  `dateOfContractExpiration` varchar(255)  DEFAULT NULL COMMENT 'expiration date',
  `leaveRequestStatus` varchar(255)  DEFAULT NULL COMMENT 'leave request status',
  `remarks` varchar(255)  DEFAULT NULL COMMENT 'remarks',
  `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

Employee Monthly Social Security Record

CREATE TABLE `insurance_month_emp_record` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'auto-increment primary key',
  `iEmpRecordId` varchar(100) NOT NULL,
  `iRecordId` varchar(100) DEFAULT NULL COMMENT 'monthly generated social security id',
  `employeeId` varchar(100) DEFAULT NULL COMMENT 'employee id',
  `schemeId` varchar(100) DEFAULT NULL COMMENT 'social security scheme id',
  `year` int(11) DEFAULT NULL COMMENT 'year',
  `month` int(11) DEFAULT NULL COMMENT 'month',
  `personalInsuranceAmount` decimal(10, 2) DEFAULT NULL COMMENT 'personal social security amount',
  `personalProvidentFundAmount` decimal(10, 2) DEFAULT NULL COMMENT 'personal provident fund amount',
  `corporateInsuranceAmount` decimal(10, 2) DEFAULT NULL COMMENT 'company social security amount',
  `corporateProvidentFundAmount` decimal(10, 2) DEFAULT NULL COMMENT 'company provident fund amount',
  `optionList` text COMMENT 'detail list',
  `createTime` datetime DEFAULT NULL,
  `status` int(11) DEFAULT '1' COMMENT 'monthly social security status 0 stopped 1 normal',
  `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 = 'employee monthly social security record'

insurance_month_record

Monthly Social Security Record

CREATE TABLE `insurance_month_record` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'auto-increment primary key',
  `iRecordId` varchar(100) NOT NULL,
  `title` varchar(40) DEFAULT NULL COMMENT 'report name',
  `year` int(11) DEFAULT NULL COMMENT 'year',
  `month` int(11) DEFAULT NULL COMMENT 'month',
  `status` int(11) DEFAULT '0' COMMENT 'monthly social security status 0 not archived 1 archived',
  `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 = 'monthly social security record'

insurance_scheme

Social Security Scheme Table

CREATE TABLE `insurance_scheme` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'auto-increment primary key',
  `schemeId` varchar(100)  DEFAULT NULL COMMENT 'social security scheme id',
  `schemeName` varchar(40)  DEFAULT NULL COMMENT 'scheme name',
  `city` varchar(40)  DEFAULT NULL COMMENT 'insured city',
  `houseType` varchar(50)  DEFAULT NULL COMMENT 'household type',
  `schemeType` int(11) DEFAULT NULL COMMENT 'insurance type 1 ratio 2 amount',
  `projectList` text  COMMENT 'social security detail items',
  `isDel` int(11) DEFAULT '0' COMMENT '1 deleted 0 in use',
  `createUserId` varchar(255)  DEFAULT NULL COMMENT 'creator id',
  `createTime` varchar(255)  DEFAULT NULL COMMENT 'creation time',
  `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 = 'social security scheme table'

job_postings

Job Posting Table

CREATE TABLE `job_postings` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `jobId` varchar(255)  DEFAULT NULL COMMENT 'job ID',
  `recruitmentType` varchar(255)  DEFAULT NULL COMMENT 'recruitment channel: campus-campus recruitment | social-social recruitment | internship-internship',
  `jobTitle` varchar(255)  DEFAULT NULL COMMENT 'job title',
  `employmentType` varchar(20)  DEFAULT NULL COMMENT 'job type: full-full time | part-part time',
  `address` varchar(255)  DEFAULT NULL COMMENT 'address',
  `headcount` varchar(255)  DEFAULT NULL COMMENT 'number of recruits',
  `company` varchar(255)  DEFAULT NULL COMMENT 'recruiting company',
  `publishStatus` varchar(255)  DEFAULT NULL COMMENT 'recruitment status',
  `publishTime` varchar(255)  DEFAULT NULL COMMENT 'publish time',
  `responsibilities` text  COMMENT 'job responsibilities',
  `requirements` text  COMMENT 'job requirements list',
  `operation` varchar(255)  DEFAULT 'insert' COMMENT 'operation; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  `operationByUserId` varchar(255)  DEFAULT NULL COMMENT 'operator userId',
  `operationByUser` varchar(255)  DEFAULT NULL COMMENT 'operator username',
  `operationAt` varchar(255)  DEFAULT NULL COMMENT 'operation time; 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 posting table'

job_resume

Resume Submission Information Table

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 'resume ID',
  `employeeId` varchar(255) DEFAULT NULL,
  `user` varchar(255) DEFAULT NULL COMMENT 'name',
  `gender` varchar(50) DEFAULT NULL COMMENT 'gender',
  `age` varchar(50) DEFAULT NULL COMMENT 'age',
  `ethnicity` varchar(50) DEFAULT NULL COMMENT 'ethnicity',
  `height` varchar(50) DEFAULT NULL COMMENT 'height',
  `weight` varchar(50) DEFAULT NULL COMMENT 'weight',
  `bloodType` varchar(50) DEFAULT NULL COMMENT 'blood type',
  `maritalStatus` varchar(50) DEFAULT NULL COMMENT 'marital status',
  `politicalAffiliation` varchar(50) DEFAULT NULL COMMENT 'political affiliation',
  `physicalCondition` varchar(255) DEFAULT NULL COMMENT 'physical condition',
  `religiousBeliefs` varchar(255) DEFAULT NULL COMMENT 'religious beliefs',
  `phoneNumber` varchar(255) DEFAULT NULL COMMENT 'phone number',
  `IDNumber` varchar(255) DEFAULT NULL COMMENT 'ID number',
  `email` varchar(255) DEFAULT NULL COMMENT 'email',
  `highestEducation` varchar(255) DEFAULT NULL COMMENT 'highest education',
  `wechatID` varchar(255) DEFAULT NULL COMMENT 'WeChat ID',
  `nativePlace` varchar(255) DEFAULT NULL COMMENT 'native place',
  `homeAddress` varchar(255) DEFAULT NULL COMMENT 'home address',
  `currentAddress` varchar(255) DEFAULT NULL COMMENT 'current address',
  `academicRanking` varchar(255) DEFAULT NULL COMMENT 'academic ranking',
  `workplace` varchar(255) DEFAULT NULL COMMENT 'desired workplace',
  `salaryExpectation` varchar(255) DEFAULT NULL COMMENT 'salary expectation',
  `domicilePlace` varchar(255) DEFAULT NULL COMMENT 'domicile place',
  `earliestAvailability` varchar(255) DEFAULT NULL COMMENT 'earliest availability date',
  `education` text COMMENT 'education experience json',
  `educationCertificate` varchar(255) DEFAULT NULL COMMENT 'education title/qualification certificate',
  `experience` text COMMENT 'work experience json',
  `familyMember` text COMMENT 'family members json',
  `teacherContact` text COMMENT 'teacher reference',
  `studentSocialization` varchar(255) DEFAULT NULL COMMENT 'school socialization',
  `socialActivities` text COMMENT 'social activities',
  `achievement` varchar(500) DEFAULT NULL COMMENT 'work achievements',
  `socialHobbies` varchar(255) DEFAULT NULL COMMENT 'social hobbies',
  `personality` varchar(255) DEFAULT NULL COMMENT 'personal characteristics',
  `careerPlanning` varchar(255) DEFAULT NULL COMMENT 'career planning',
  `offence` varchar(255) DEFAULT NULL COMMENT 'any violations of law or dismissal',
  `resumeStatus` varchar(255) DEFAULT NULL COMMENT 'status: new-new candidate | passedInitialScreening\nscheduledInterview\npassedInterview\noffer\npending rejected\nhired',
  `fileAttachmentList` varchar(255) DEFAULT NULL,
  `operation` varchar(255) DEFAULT 'insert' COMMENT 'operation; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  `operationByUserId` varchar(255) DEFAULT NULL COMMENT 'operator userId',
  `operationByUser` varchar(255) DEFAULT NULL COMMENT 'operator username',
  `operationAt` varchar(255) DEFAULT NULL COMMENT 'operation time; E.g: 2021-05-28T10:24:54+08:00 ',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 23 DEFAULT CHARSET = utf8mb4 COMMENT = 'resume submission information table'

member_org_role

Organization Employee Table

CREATE TABLE `member_org_role` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `orgId` varchar(255)  DEFAULT NULL COMMENT 'organization Id;',
  `memberId` varchar(255)  DEFAULT NULL COMMENT 'employee Id;',
  `roleId` varchar(255)  DEFAULT NULL COMMENT 'role Id; leader, member',
  `remark` varchar(255)  DEFAULT NULL COMMENT 'remark',
  `operation` varchar(255)  DEFAULT 'insert' COMMENT 'operation; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  `operationByUserId` varchar(255)  DEFAULT NULL COMMENT 'operator userId',
  `operationByUser` varchar(255)  DEFAULT NULL COMMENT 'operator username',
  `operationAt` varchar(255)  DEFAULT NULL COMMENT 'operation time; 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 = 'organization employee table'

notes

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)

# Table Overview

## General Tables

- [_user](/__appId__/page/article/12324#_user)
- [_user_session](/__appId__/page/article/12324#_user_session)
- [_role](/__appId__/page/article/12324#_role)
- [_page](/__appId__/page/article/12324#_page)
- [_resource](/__appId__/page/article/12324#_resource)
- [_group](/__appId__/page/article/12324#_group)
- [_user_group_role](/__appId__/page/article/12324#_user_group_role)
- [_user_group_role_page](/__appId__/page/article/12324#_user_group_role_page)
- [_user_group_role_resource](/__appId__/page/article/12324#_user_group_role_resource)
- [_constant](/__appId__/page/article/12324#_constant)
- [_constant_ui](/__appId__/page/article/12324#_constant_ui)
- [_record](/__appId__/page/article/12324#_record)
- [_record_history](/__appId__/page/article/12324#_record_history)
- [_cache](/__appId__/page/article/12324#_cache)
- [_file](/__appId__/page/article/12324#_file)
- [_view01_user](/__appId__/page/article/12324#_view01_user)

## Business Tables

### _ui

- UI Construction Plan

```sql
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 action type, e.g.: fetchData, postData, changeUi',
  `uiActionId` varchar(255)  DEFAULT NULL COMMENT 'action id; E.g: selectXXXByXXX',
  `desc` varchar(255)  DEFAULT NULL COMMENT 'description',
  `uiActionConfig` text  COMMENT 'UI action data',
  `appDataSchema` text  COMMENT 'UI validation data',
  `operation` varchar(255)  DEFAULT 'insert' COMMENT 'operation; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  `operationByUserId` varchar(255)  DEFAULT NULL COMMENT 'operator userId',
  `operationByUser` varchar(255)  DEFAULT NULL COMMENT 'operator username',
  `operationAt` varchar(255)  DEFAULT NULL COMMENT 'operation time; E.g: 2021-05-28T10:24:54+08:00 ',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = 'UI construction plan'
```

### achievement_appraisal

- Performance Appraisal

```sql
CREATE TABLE `achievement_appraisal` (
  `id` int(11) DEFAULT NULL COMMENT 'auto-increment primary key',
  `appraisalId` int(11) NOT NULL AUTO_INCREMENT,
  `appraisalName` varchar(50)  DEFAULT NULL COMMENT 'appraisal name',
  `cycleType` int(11) DEFAULT NULL COMMENT '1 month 2 quarter 3 year 4 half year',
  `startTime` date DEFAULT NULL COMMENT 'appraisal start time',
  `endTime` date DEFAULT NULL COMMENT 'appraisal end time',
  `tableId` int(11) DEFAULT NULL COMMENT 'appraisal table template id',
  `writtenBy` int(11) DEFAULT '1' COMMENT 'appraisal target writer 1 self',
  `resultConfirmors` varchar(1024)  DEFAULT NULL COMMENT 'appraisal result confirmers\n',
  `fullScore` decimal(7, 2) DEFAULT NULL COMMENT 'total score for appraisal',
  `isForce` int(11) DEFAULT NULL COMMENT 'whether to enable forced distribution 1 yes 0 no',
  `employeeIds` varchar(1024)  DEFAULT NULL COMMENT 'appraisal employees',
  `deptIds` varchar(1024)  DEFAULT NULL COMMENT 'appraisal departments',
  `appraisalSteps` int(11) DEFAULT '-1' COMMENT 'appraisal step progress',
  `activateSteps` int(11) DEFAULT '-1' COMMENT 'ongoing step progress',
  `status` int(11) DEFAULT '0' COMMENT 'performance status 0 not started 1 performance filling 2 performance evaluation 3 result confirmation 4 archived',
  `isStop` int(11) DEFAULT '0' COMMENT 'whether to terminate 0 no 1 yes',
  `stopTime` datetime DEFAULT NULL COMMENT 'termination time',
  `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 = 'performance appraisal'
```

### achievement_appraisal_evaluators

- Appraisal Result Evaluators

```sql
CREATE TABLE `achievement_appraisal_evaluators` (
  `id` int(11) DEFAULT NULL COMMENT 'auto-increment primary key',
  `evaluatorsId` int(11) NOT NULL AUTO_INCREMENT,
  `appraisalId` int(11) NOT NULL COMMENT 'appraisal id',
  `type` int(11) NOT NULL COMMENT '1 employee self 2 direct supervisor 3 department head 4 upper department head 5 designated target confirmer',
  `employeeId` int(11) DEFAULT NULL COMMENT 'designated confirmer id',
  `weight` decimal(5, 2) NOT NULL COMMENT 'weight',
  `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 = 'appraisal result evaluators'
```

### achievement_appraisal_score_level

- Appraisal Rule Levels

```sql
CREATE TABLE `achievement_appraisal_score_level` (
  `id` int(11) DEFAULT NULL COMMENT 'auto-increment primary key',
  `levelId` int(11) NOT NULL AUTO_INCREMENT,
  `appraisalId` int(11) NOT NULL COMMENT 'appraisal id',
  `levelName` varchar(50)  NOT NULL COMMENT 'level name',
  `minScore` decimal(7, 2) DEFAULT NULL COMMENT 'minimum score',
  `maxScore` decimal(7, 2) NOT NULL COMMENT 'maximum score',
  `minNum` int(11) NOT NULL COMMENT 'minimum number ratio',
  `maxNum` int(11) NOT NULL COMMENT 'maximum number ratio',
  `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 = 'appraisal rule levels'
```

### achievement_appraisal_target_confirmors

- Appraisal Target Confirmers

```sql
CREATE TABLE `achievement_appraisal_target_confirmors` (
  `id` int(11) DEFAULT NULL COMMENT 'auto-increment primary key',
  `targetConfirmorsId` int(11) NOT NULL AUTO_INCREMENT,
  `appraisalId` int(11) DEFAULT NULL COMMENT 'appraisal id',
  `type` int(11) DEFAULT NULL COMMENT '1 employee self 2 direct supervisor 3 department head 4 upper department head 5 designated target confirmer',
  `employeeId` int(11) DEFAULT NULL COMMENT 'designated confirmer id',
  `sort` int(11) DEFAULT NULL COMMENT 'step number from small to large',
  `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 = 'appraisal target confirmers'
```

### achievement_employee_appraisal

- Employee Performance Appraisal

```sql
CREATE TABLE `achievement_employee_appraisal` (
  `id` int(11) DEFAULT NULL COMMENT 'auto-increment primary key',
  `employeeAppraisalId` int(11) NOT NULL AUTO_INCREMENT,
  `employeeId` int(11) NOT NULL COMMENT 'employee id',
  `appraisalId` int(11) DEFAULT NULL COMMENT 'performance id',
  `status` int(11) DEFAULT NULL COMMENT 'appraisal status 1 pending filling 2 pending target confirmation 3 pending evaluation 4 pending result confirmation 5 terminated performance 6 appraisal completed',
  `score` double(10, 2) DEFAULT NULL COMMENT 'score',
  `levelId` int(11) DEFAULT NULL COMMENT 'appraisal result',
  `readStatus` int(11) DEFAULT '0' COMMENT 'result reading status 0 unread 1 read',
  `followUpEmployeeId` int(11) DEFAULT NULL COMMENT 'follow-up employee id',
  `followSort` int(11) DEFAULT NULL COMMENT 'follow-up employee sorting',
  `createTime` datetime DEFAULT NULL,
  `isDraft` int(11) DEFAULT '0' COMMENT 'is draft 0 no 1 yes',
  `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 = 'employee performance appraisal'
```

### achievement_employee_evaluato

- Employee Performance Result Evaluation Table

```sql
CREATE TABLE `achievement_employee_evaluato` (
  `id` int(11) DEFAULT NULL COMMENT 'auto-increment primary key',
  `employeeEvaluatoId` int(11) NOT NULL AUTO_INCREMENT,
  `employeeAppraisalId` int(11) DEFAULT NULL COMMENT 'employee side appraisal id',
  `appraisalId` int(11) DEFAULT NULL COMMENT 'performance id',
  `employeeId` int(11) NOT NULL COMMENT 'confirmer',
  `weight` decimal(5, 2) DEFAULT NULL COMMENT 'weight',
  `score` decimal(7, 2) DEFAULT NULL COMMENT 'score',
  `levelId` int(11) DEFAULT NULL COMMENT 'appraisal level',
  `evaluate` varchar(1024)  DEFAULT NULL COMMENT 'comments',
  `rejectReason` varchar(1024)  DEFAULT NULL COMMENT 'rejection reason',
  `createTime` datetime DEFAULT NULL,
  `updateTime` datetime DEFAULT NULL,
  `sort` int(11) DEFAULT NULL,
  `status` int(11) DEFAULT '0' COMMENT '0 pending evaluation 1 evaluated',
  `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 = 'employee performance result evaluation table'
```

### achievement_employee_evaluato_seg

- Employee Performance Appraisal Item Evaluation Table

```sql
CREATE TABLE `achievement_employee_evaluato_seg` (
  `id` int(11) DEFAULT NULL COMMENT 'auto-increment primary key',
  `employeeEvaluatoSegId` int(11) NOT NULL AUTO_INCREMENT,
  `employeeAppraisalId` int(11) DEFAULT NULL COMMENT 'employee side appraisal id',
  `employeeEvaluatoId` int(11) DEFAULT NULL COMMENT 'result evaluation id',
  `segId` int(11) DEFAULT NULL COMMENT 'appraisal item id',
  `employeeId` int(11) NOT NULL COMMENT 'evaluator',
  `score` decimal(7, 2) DEFAULT NULL COMMENT 'score',
  `evaluate` varchar(1024)  DEFAULT NULL COMMENT 'comments',
  `status` int(11) DEFAULT '1' COMMENT '0 pending evaluation 1 evaluated',
  `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 = 'employee performance appraisal item evaluation table'
```

### achievement_employee_result_confirmors

- Performance Result Confirmation Table

```sql
CREATE TABLE `achievement_employee_result_confirmors` (
  `id` int(11) DEFAULT NULL COMMENT 'auto-increment primary key',
  `confirmorsId` int(11) NOT NULL AUTO_INCREMENT,
  `employeeId` int(11) DEFAULT NULL,
  `appraisalId` int(11) DEFAULT NULL COMMENT 'performance id',
  `status` int(11) DEFAULT '0' COMMENT '0 not confirmed 1 confirmed',
  `sort` int(11) DEFAULT NULL,
  `createTime` datetime DEFAULT NULL COMMENT 'creation time',
  `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 = 'performance result confirmation table'
```

### achievement_employee_seg

- Employee Performance Appraisal Item

```sql
CREATE TABLE `achievement_employee_seg` (
  `id` int(11) DEFAULT NULL COMMENT 'auto-increment primary key',
  `segId` int(11) NOT NULL AUTO_INCREMENT,
  `employeeAppraisalId` int(11) DEFAULT NULL,
  `tempSegId` int(11) DEFAULT '0' COMMENT 'template appraisal item id',
  `employeeId` int(11) DEFAULT NULL,
  `segName` varchar(50)  DEFAULT NULL COMMENT 'appraisal item name',
  `value` varchar(255)  DEFAULT NULL COMMENT 'value',
  `isFixed` int(11) DEFAULT NULL COMMENT 'is fixed 1 yes 0 no',
  `weight` decimal(5, 2) DEFAULT NULL COMMENT 'weight -1 employee writes weight ratio 0~100',
  `schedule` int(11) DEFAULT '0' COMMENT 'target progress',
  `explainDesc` varchar(1024)  DEFAULT NULL COMMENT 'completion status description',
  `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 = 'employee performance appraisal item'
```

### achievement_employee_seg_item

- Employee Appraisal Item Options

```sql
CREATE TABLE `achievement_employee_seg_item` (
  `id` int(11) DEFAULT NULL COMMENT 'auto-increment primary key',
  `itemId` int(11) NOT NULL AUTO_INCREMENT,
  `segId` int(11) DEFAULT NULL,
  `tempItemId` int(11) DEFAULT '0' COMMENT 'template appraisal item id',
  `itemName` varchar(50)  DEFAULT NULL COMMENT 'option name',
  `value` varchar(255)  DEFAULT NULL COMMENT 'value',
  `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 = 'employee appraisal item options'
```

### achievement_employee_target_confirm

- Employee Appraisal Target Confirmation Table

```sql
CREATE TABLE `achievement_employee_target_confirm` (
  `id` int(11) DEFAULT NULL COMMENT 'auto-increment primary key',
  `employeeConfirmId` int(11) NOT NULL AUTO_INCREMENT,
  `employeeAppraisalId` int(11) DEFAULT NULL COMMENT 'employee side appraisal id',
  `appraisalId` int(11) DEFAULT NULL COMMENT 'performance id',
  `employeeId` int(11) NOT NULL COMMENT 'confirmer',
  `rejectReason` varchar(1024)  DEFAULT NULL COMMENT 'rejection reason',
  `createTime` datetime DEFAULT NULL,
  `updateTime` datetime DEFAULT NULL,
  `sort` int(11) DEFAULT NULL,
  `status` int(11) DEFAULT '0' COMMENT '0 pending confirmation 1 confirmed 2 rejected ',
  `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 = 'employee appraisal target confirmation table'
```

### achievement_seg

- Performance Appraisal Item Template

```sql
CREATE TABLE `achievement_seg` (
  `id` int(11) DEFAULT NULL COMMENT 'auto-increment primary key',
  `segId` int(11) NOT NULL AUTO_INCREMENT,
  `tableId` int(11) DEFAULT NULL,
  `segName` varchar(50)  DEFAULT NULL COMMENT 'appraisal item name',
  `isFixed` int(11) DEFAULT NULL COMMENT 'is fixed 1 yes 0 no',
  `weight` decimal(5, 2) DEFAULT NULL COMMENT 'weight -1 employee writes weight ratio 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 = 'performance appraisal item template'
```

### achievement_seg_item

- Appraisal Item Options

```sql
CREATE TABLE `achievement_seg_item` (
  `id` int(11) DEFAULT NULL COMMENT 'auto-increment primary key',
  `itemId` int(11) NOT NULL AUTO_INCREMENT,
  `segId` int(11) DEFAULT NULL,
  `itemName` varchar(50)  DEFAULT NULL COMMENT 'option name',
  `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 = 'appraisal item options'
```

### achievement_table

- Performance Appraisal Table Template

```sql
CREATE TABLE `achievement_table` (
  `id` int(11) DEFAULT NULL COMMENT 'auto-increment primary key',
  `tableId` int(11) NOT NULL AUTO_INCREMENT,
  `tableName` varchar(50)  DEFAULT NULL COMMENT 'appraisal name',
  `type` int(11) DEFAULT NULL COMMENT '1 OKR template 2 KPI template',
  `description` longtext  COMMENT 'appraisal table description',
  `isEmpWeight` int(11) DEFAULT '0' COMMENT 'whether employees fill weight 0 no 1 yes',
  `status` int(11) DEFAULT '1' COMMENT ' 1 active 0 deleted',
  `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 = 'performance appraisal table template'
```

### attendance_clock

- Clock-in Record Table

```sql
CREATE TABLE `attendance_clock` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'auto-increment primary key',
  `clockId` varchar(255)  NOT NULL COMMENT 'clock-in record id',
  `clockEmployeeId` varchar(255)  DEFAULT NULL,
  `clockTime` varchar(255)  NOT NULL COMMENT 'clock-in time',
  `clockType` int(11) NOT NULL COMMENT 'clock-in type 1 clock-in 2 clock-out',
  `attendanceTime` varchar(255)  NOT NULL COMMENT 'work date',
  `type` int(11) NOT NULL DEFAULT '1' COMMENT 'clock-in type 1 mobile clock-in 2 manual entry',
  `address` varchar(255)  NOT NULL COMMENT 'attendance address',
  `lng` varchar(50)  DEFAULT NULL COMMENT 'longitude',
  `lat` varchar(50)  DEFAULT NULL COMMENT 'latitude',
  `remark` varchar(255)  DEFAULT NULL COMMENT 'remark',
  `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 = 'clock-in record table'
```

### employee

```sql
CREATE TABLE `employee` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `employeeId` varchar(255)  DEFAULT NULL COMMENT 'employee id',
  `employeeName` varchar(255)  DEFAULT NULL COMMENT 'employee name',
  `idSequence` int(11) DEFAULT NULL COMMENT 'employee sequence number',
  `sex` varchar(255)  DEFAULT NULL COMMENT 'employee gender',
  `age` int(11) DEFAULT NULL COMMENT 'employee age',
  `contactNumber` varchar(255)  DEFAULT NULL COMMENT 'contact number',
  `emergencyContactNumber` varchar(255)  DEFAULT NULL COMMENT 'emergency contact number',
  `post` varchar(255)  DEFAULT NULL COMMENT 'position 1',
  `post2` varchar(255)  DEFAULT NULL COMMENT 'position 2',
  `post3` varchar(255)  DEFAULT NULL COMMENT 'position 3',
  `politicalBackground` varchar(255)  DEFAULT NULL COMMENT 'political background',
  `icNumber` varchar(255)  DEFAULT NULL COMMENT 'ID number',
  `dateOfBirth` varchar(255)  DEFAULT NULL COMMENT 'date of birth',
  `institution` varchar(255)  DEFAULT NULL COMMENT 'graduated school',
  `major` varchar(255)  DEFAULT NULL COMMENT 'major',
  `highestEducation` varchar(255)  DEFAULT NULL COMMENT 'highest education level',
  `teacherQualification` varchar(255)  DEFAULT NULL COMMENT 'teacher qualification category',
  `teacherQualificationLeaver` varchar(255)  DEFAULT NULL COMMENT 'teacher qualification grade',
  `teacherQualificationSubject` varchar(255)  DEFAULT NULL COMMENT 'teacher qualification subject',
  `teacherCertificationNumber` varchar(255)  DEFAULT NULL COMMENT 'teacher qualification number',
  `teachingLevel` varchar(255)  DEFAULT NULL COMMENT 'teaching grade',
  `teachingSubject` varchar(255)  DEFAULT NULL COMMENT 'teaching subject',
  `residentialAddress` varchar(255)  DEFAULT NULL COMMENT 'home address',
  `province` varchar(255)  DEFAULT NULL COMMENT 'province',
  `city` varchar(255)  DEFAULT NULL COMMENT 'city',
  `county` varchar(255)  DEFAULT NULL COMMENT 'county',
  `operationAt` varchar(255)  DEFAULT NULL,
  `dateOfEntry` varchar(255)  DEFAULT NULL COMMENT 'date of entry',
  `dateOfContractExpiration` varchar(255)  DEFAULT NULL COMMENT 'expiration date',
  `leaveRequestStatus` varchar(255)  DEFAULT NULL COMMENT 'leave request status',
  `cardNumber` varchar(255)  DEFAULT NULL COMMENT 'bank card number',
  `licensePlateNumber` varchar(255)  DEFAULT NULL COMMENT 'license plate number',
  `employmentForms` varchar(255)  DEFAULT NULL COMMENT 'employment form',
  `probationPeriod` varchar(255)  DEFAULT NULL COMMENT 'probation period',
  `entryStatus` varchar(255)  DEFAULT NULL COMMENT 'employment status',
  `status` varchar(255)  DEFAULT NULL COMMENT 'employee status',
  `remarks` varchar(255)  DEFAULT NULL COMMENT 'remarks',
  `contactPerson` varchar(255)  DEFAULT NULL COMMENT 'contact person',
  `educationExperience` varchar(255)  DEFAULT NULL COMMENT 'education experience',
  `certificate` varchar(255)  DEFAULT NULL COMMENT 'certificate',
  `salaryCard` varchar(255)  DEFAULT NULL COMMENT 'salary card information',
  `socialSecurity` varchar(255)  DEFAULT NULL COMMENT 'social security card information',
  `trainingExperience` varchar(255)  DEFAULT NULL COMMENT 'training experience',
  `workExperience` varchar(255)  DEFAULT NULL COMMENT 'work experience',
  `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

- Employee Contract

```sql
CREATE TABLE `employee_contract` (
  `id` int(11) DEFAULT NULL COMMENT 'auto-increment primary key',
  `contractId` int(11) NOT NULL AUTO_INCREMENT,
  `employeeId` int(11) NOT NULL,
  `contractNum` varchar(40)  DEFAULT NULL COMMENT 'contract number',
  `contractType` int(11) DEFAULT NULL COMMENT '1 fixed-term labor contract 2 indefinite-term labor contract 3 labor contract for completing certain work tasks 4 internship agreement 5 labor contract 6 re-employment agreement 7 labor dispatch contract 8 secondment contract 9 other',
  `startTime` datetime DEFAULT NULL,
  `endTime` datetime DEFAULT NULL,
  `term` int(11) DEFAULT NULL COMMENT 'term',
  `status` int(11) DEFAULT NULL COMMENT 'contract status 0 not executed 1 in execution 2 expired',
  `signCompany` varchar(255)  DEFAULT NULL COMMENT 'signing company',
  `signTime` datetime DEFAULT NULL COMMENT 'contract signing date',
  `remarks` varchar(255)  DEFAULT NULL COMMENT 'remarks',
  `isExpireRemind` int(11) DEFAULT NULL COMMENT 'is expiration reminder 0 no 1 yes',
  `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 contract'
```

### employee_file

- Employee Attachment Table

```sql
CREATE TABLE `employee_file` (
  `id` int(11) DEFAULT NULL COMMENT 'auto-increment primary key',
  `employeeFileId` int(11) NOT NULL AUTO_INCREMENT,
  `employeeId` int(11) NOT NULL COMMENT 'employee id',
  `fileId` bigint(20) NOT NULL COMMENT 'admin module attachment id',
  `type` int(11) DEFAULT NULL COMMENT '1 employee basic information 2 employee file information 3 employee resignation information',
  `subType` int(11) NOT NULL COMMENT '11 ID card original 12 education certificate 13 personal ID photo 14 ID card copy 15 salary bank card 16 social security card 17 provident fund card 18 award certificate 19 other 21 labor contract 22 entry resume 23 entry registration form 24 entry physical examination form 25 resignation certificate 26 regularization application form 27 other\n31 resignation approval 32 resignation certificate 33 other\n',
  `createUserId` bigint(20) DEFAULT NULL,
  `createTime` datetime DEFAULT NULL COMMENT 'creation time',
  `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 attachment table'
```

### employee_quit_info

- Resignation Information

```sql
CREATE TABLE `employee_quit_info` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'auto-increment primary key',
  `quitInfoId` varchar(100)  NOT NULL,
  `employeeId` varchar(100)  DEFAULT NULL,
  `planQuitTime` datetime DEFAULT NULL COMMENT 'planned resignation date',
  `applyQuitTime` datetime DEFAULT NULL COMMENT 'resignation application date',
  `salarySettlementTime` datetime DEFAULT NULL COMMENT 'salary settlement date',
  `quitType` int(11) DEFAULT NULL COMMENT 'resignation type 1 voluntary resignation 2 involuntary resignation 3 retirement',
  `quitReason` int(11) DEFAULT NULL COMMENT 'resignation reason 1 family reasons 2 health reasons 3 salary reasons 4 inconvenient transportation 5 work pressure 6 management issues 7 no promotion opportunities 8 career planning 9 contract expiration and refusal to renew 10 other personal reasons 11 dismissal during probation 12 violation of company regulations 13 organizational adjustment/redundancy 14 dismissal for performance not meeting standards 15 non-renewal of contract upon expiration 16 other reasons for involuntary resignation',
  `remarks` varchar(255)  DEFAULT NULL COMMENT 'remarks',
  `oldStatus` int(11) DEFAULT NULL COMMENT 'status before resignation',
  `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 = 'resignation information'
```

### employee_request

```sql
CREATE TABLE `employee_request` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `employeeId` varchar(255)  DEFAULT NULL COMMENT 'employee number',
  `employeeName` varchar(255)  DEFAULT NULL COMMENT 'employee name',
  `sex` varchar(255)  DEFAULT NULL COMMENT 'employee gender',
  `age` varchar(255)  DEFAULT NULL COMMENT 'employee age',
  `contactNumber` varchar(255)  DEFAULT NULL COMMENT 'contact number',
  `icNumber` varchar(255)  DEFAULT NULL COMMENT 'ID number',
  `post` varchar(255)  DEFAULT NULL COMMENT 'employee position',
  `teachingLevel` varchar(255)  DEFAULT NULL COMMENT 'teaching grade',
  `teachingSubject` varchar(255)  DEFAULT NULL COMMENT 'teaching subject',
  `status` varchar(255)  DEFAULT NULL COMMENT 'employee status',
  `employmentForms` varchar(255)  DEFAULT NULL COMMENT 'employment form',
  `entryStatus` varchar(255)  DEFAULT NULL COMMENT 'entry status',
  `dateOfEntry` varchar(255)  DEFAULT NULL COMMENT 'entry date',
  `dateOfContractExpiration` varchar(255)  DEFAULT NULL COMMENT 'expiration date',
  `leaveRequestStatus` varchar(255)  DEFAULT NULL COMMENT 'leave request status',
  `remarks` varchar(255)  DEFAULT NULL COMMENT 'remarks',
  `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

- Employee Monthly Social Security Record

```sql
CREATE TABLE `insurance_month_emp_record` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'auto-increment primary key',
  `iEmpRecordId` varchar(100) NOT NULL,
  `iRecordId` varchar(100) DEFAULT NULL COMMENT 'monthly generated social security id',
  `employeeId` varchar(100) DEFAULT NULL COMMENT 'employee id',
  `schemeId` varchar(100) DEFAULT NULL COMMENT 'social security scheme id',
  `year` int(11) DEFAULT NULL COMMENT 'year',
  `month` int(11) DEFAULT NULL COMMENT 'month',
  `personalInsuranceAmount` decimal(10, 2) DEFAULT NULL COMMENT 'personal social security amount',
  `personalProvidentFundAmount` decimal(10, 2) DEFAULT NULL COMMENT 'personal provident fund amount',
  `corporateInsuranceAmount` decimal(10, 2) DEFAULT NULL COMMENT 'company social security amount',
  `corporateProvidentFundAmount` decimal(10, 2) DEFAULT NULL COMMENT 'company provident fund amount',
  `optionList` text COMMENT 'detail list',
  `createTime` datetime DEFAULT NULL,
  `status` int(11) DEFAULT '1' COMMENT 'monthly social security status 0 stopped 1 normal',
  `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 = 'employee monthly social security record'
```

### insurance_month_record

- Monthly Social Security Record

```sql
CREATE TABLE `insurance_month_record` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'auto-increment primary key',
  `iRecordId` varchar(100) NOT NULL,
  `title` varchar(40) DEFAULT NULL COMMENT 'report name',
  `year` int(11) DEFAULT NULL COMMENT 'year',
  `month` int(11) DEFAULT NULL COMMENT 'month',
  `status` int(11) DEFAULT '0' COMMENT 'monthly social security status 0 not archived 1 archived',
  `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 = 'monthly social security record'
```

### insurance_scheme

- Social Security Scheme Table

```sql
CREATE TABLE `insurance_scheme` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'auto-increment primary key',
  `schemeId` varchar(100)  DEFAULT NULL COMMENT 'social security scheme id',
  `schemeName` varchar(40)  DEFAULT NULL COMMENT 'scheme name',
  `city` varchar(40)  DEFAULT NULL COMMENT 'insured city',
  `houseType` varchar(50)  DEFAULT NULL COMMENT 'household type',
  `schemeType` int(11) DEFAULT NULL COMMENT 'insurance type 1 ratio 2 amount',
  `projectList` text  COMMENT 'social security detail items',
  `isDel` int(11) DEFAULT '0' COMMENT '1 deleted 0 in use',
  `createUserId` varchar(255)  DEFAULT NULL COMMENT 'creator id',
  `createTime` varchar(255)  DEFAULT NULL COMMENT 'creation time',
  `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 = 'social security scheme table'
```

### job_postings

- Job Posting Table

```sql
CREATE TABLE `job_postings` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `jobId` varchar(255)  DEFAULT NULL COMMENT 'job ID',
  `recruitmentType` varchar(255)  DEFAULT NULL COMMENT 'recruitment channel: campus-campus recruitment | social-social recruitment | internship-internship',
  `jobTitle` varchar(255)  DEFAULT NULL COMMENT 'job title',
  `employmentType` varchar(20)  DEFAULT NULL COMMENT 'job type: full-full time | part-part time',
  `address` varchar(255)  DEFAULT NULL COMMENT 'address',
  `headcount` varchar(255)  DEFAULT NULL COMMENT 'number of recruits',
  `company` varchar(255)  DEFAULT NULL COMMENT 'recruiting company',
  `publishStatus` varchar(255)  DEFAULT NULL COMMENT 'recruitment status',
  `publishTime` varchar(255)  DEFAULT NULL COMMENT 'publish time',
  `responsibilities` text  COMMENT 'job responsibilities',
  `requirements` text  COMMENT 'job requirements list',
  `operation` varchar(255)  DEFAULT 'insert' COMMENT 'operation; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  `operationByUserId` varchar(255)  DEFAULT NULL COMMENT 'operator userId',
  `operationByUser` varchar(255)  DEFAULT NULL COMMENT 'operator username',
  `operationAt` varchar(255)  DEFAULT NULL COMMENT 'operation time; 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 posting table'
```

### job_resume

- Resume Submission Information Table

```sql
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 'resume ID',
  `employeeId` varchar(255) DEFAULT NULL,
  `user` varchar(255) DEFAULT NULL COMMENT 'name',
  `gender` varchar(50) DEFAULT NULL COMMENT 'gender',
  `age` varchar(50) DEFAULT NULL COMMENT 'age',
  `ethnicity` varchar(50) DEFAULT NULL COMMENT 'ethnicity',
  `height` varchar(50) DEFAULT NULL COMMENT 'height',
  `weight` varchar(50) DEFAULT NULL COMMENT 'weight',
  `bloodType` varchar(50) DEFAULT NULL COMMENT 'blood type',
  `maritalStatus` varchar(50) DEFAULT NULL COMMENT 'marital status',
  `politicalAffiliation` varchar(50) DEFAULT NULL COMMENT 'political affiliation',
  `physicalCondition` varchar(255) DEFAULT NULL COMMENT 'physical condition',
  `religiousBeliefs` varchar(255) DEFAULT NULL COMMENT 'religious beliefs',
  `phoneNumber` varchar(255) DEFAULT NULL COMMENT 'phone number',
  `IDNumber` varchar(255) DEFAULT NULL COMMENT 'ID number',
  `email` varchar(255) DEFAULT NULL COMMENT 'email',
  `highestEducation` varchar(255) DEFAULT NULL COMMENT 'highest education',
  `wechatID` varchar(255) DEFAULT NULL COMMENT 'WeChat ID',
  `nativePlace` varchar(255) DEFAULT NULL COMMENT 'native place',
  `homeAddress` varchar(255) DEFAULT NULL COMMENT 'home address',
  `currentAddress` varchar(255) DEFAULT NULL COMMENT 'current address',
  `academicRanking` varchar(255) DEFAULT NULL COMMENT 'academic ranking',
  `workplace` varchar(255) DEFAULT NULL COMMENT 'desired workplace',
  `salaryExpectation` varchar(255) DEFAULT NULL COMMENT 'salary expectation',
  `domicilePlace` varchar(255) DEFAULT NULL COMMENT 'domicile place',
  `earliestAvailability` varchar(255) DEFAULT NULL COMMENT 'earliest availability date',
  `education` text COMMENT 'education experience json',
  `educationCertificate` varchar(255) DEFAULT NULL COMMENT 'education title/qualification certificate',
  `experience` text COMMENT 'work experience json',
  `familyMember` text COMMENT 'family members json',
  `teacherContact` text COMMENT 'teacher reference',
  `studentSocialization` varchar(255) DEFAULT NULL COMMENT 'school socialization',
  `socialActivities` text COMMENT 'social activities',
  `achievement` varchar(500) DEFAULT NULL COMMENT 'work achievements',
  `socialHobbies` varchar(255) DEFAULT NULL COMMENT 'social hobbies',
  `personality` varchar(255) DEFAULT NULL COMMENT 'personal characteristics',
  `careerPlanning` varchar(255) DEFAULT NULL COMMENT 'career planning',
  `offence` varchar(255) DEFAULT NULL COMMENT 'any violations of law or dismissal',
  `resumeStatus` varchar(255) DEFAULT NULL COMMENT 'status: new-new candidate | passedInitialScreening\nscheduledInterview\npassedInterview\noffer\npending rejected\nhired',
  `fileAttachmentList` varchar(255) DEFAULT NULL,
  `operation` varchar(255) DEFAULT 'insert' COMMENT 'operation; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  `operationByUserId` varchar(255) DEFAULT NULL COMMENT 'operator userId',
  `operationByUser` varchar(255) DEFAULT NULL COMMENT 'operator username',
  `operationAt` varchar(255) DEFAULT NULL COMMENT 'operation time; E.g: 2021-05-28T10:24:54+08:00 ',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 23 DEFAULT CHARSET = utf8mb4 COMMENT = 'resume submission information table'
```

### member_org_role

- Organization Employee Table

```sql
CREATE TABLE `member_org_role` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `orgId` varchar(255)  DEFAULT NULL COMMENT 'organization Id;',
  `memberId` varchar(255)  DEFAULT NULL COMMENT 'employee Id;',
  `roleId` varchar(255)  DEFAULT NULL COMMENT 'role Id; leader, member',
  `remark` varchar(255)  DEFAULT NULL COMMENT 'remark',
  `operation` varchar(255)  DEFAULT 'insert' COMMENT 'operation; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  `operationByUserId` varchar(255)  DEFAULT NULL COMMENT 'operator userId',
  `operationByUser` varchar(255)  DEFAULT NULL COMMENT 'operator username',
  `operationAt` varchar(255)  DEFAULT NULL COMMENT 'operation time; 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 = 'organization employee table'
```

### notes

- Notes

```sql
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)