44 lines
4.8 KiB
SQL
44 lines
4.8 KiB
SQL
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='员工岗位表'; |