CREATE TABLE `t_employee_basic`
(
    `id`                           bigint    NOT NULL AUTO_INCREMENT,
    `employee_key`                 varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci  DEFAULT NULL COMMENT '人员的唯一标识',
    `name`                         varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci  DEFAULT NULL COMMENT '姓名',
    `age`                          varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci  DEFAULT NULL COMMENT '年龄',
    `gender`                       varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci  DEFAULT NULL COMMENT '性别',
    `ethnic`                       varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci  DEFAULT NULL COMMENT '民族',
    `birth`                        varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci  DEFAULT NULL COMMENT '生日',
    `highest_education`            varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci  DEFAULT NULL COMMENT '最高学历',
    `full_time_edu_qualifications` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '全日制教育学历学位',
    `full_time_edu_institutions`   varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '全日制教育毕业院校系及专业',
    `on_job_edu_qualifications`    varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '在职教育学历学位',
    `on_job_edu_institutions`      varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '在职教育毕业院校系及专业',
    `join_party_time`              timestamp NOT NULL                                            DEFAULT CURRENT_TIMESTAMP COMMENT '入党时间',
    `join_work_time`               timestamp NOT NULL                                            DEFAULT CURRENT_TIMESTAMP COMMENT '参加工作时间',
    `is_concurrently`              varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci  DEFAULT NULL COMMENT '是否兼职',
    `deleted`                      bit(1)    NOT NULL                                            DEFAULT b'0' COMMENT '删除状态:0: 未删除 1: 已删除 (公共字段)',
    `create_time`                  timestamp NOT NULL                                            DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间 (公共字段)',
    `update_time`                  timestamp NOT NULL                                            DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '最后更新时间 (公共字段)',
    PRIMARY KEY (`id`) USING BTREE
)ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='员工基础信息表';



CREATE TABLE `t_employee_Post`
(
    `id`                    bigint    NOT NULL AUTO_INCREMENT,
    `employee_key`          varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci  DEFAULT NULL COMMENT '人员的唯一标识',
    `project`               varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '项目',
    `department`            varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '部门',
    `branch`                varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci  DEFAULT NULL COMMENT '单位',
    `current_position`      varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci  DEFAULT NULL COMMENT '现任职位',
    `current_position_time` timestamp NOT NULL                                            DEFAULT CURRENT_TIMESTAMP COMMENT '当前职位时间',
    `current_rank_time`     timestamp NOT NULL                                            DEFAULT CURRENT_TIMESTAMP COMMENT '当前职级时间',
    `managers_type`         varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci  DEFAULT NULL COMMENT '经理人类型',
    `appointment_documents` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci  DEFAULT NULL COMMENT '任命文件',
    `post_type`             varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci  DEFAULT NULL COMMENT '岗位类型',
    `remark`                varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci  DEFAULT NULL COMMENT '备注',
    `deleted`               bit(1)    NOT NULL                                            DEFAULT b'0' COMMENT '删除状态:0: 未删除 1: 已删除 (公共字段)',
    `create_time`           timestamp NOT NULL                                            DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间 (公共字段)',
    `update_time`           timestamp NOT NULL                                            DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '最后更新时间 (公共字段)',
    PRIMARY KEY (`id`) USING BTREE
)ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='员工岗位表';