-- 员工管理
|
CREATE TABLE IF NOT EXISTS `t_employee` (
|
`employee_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '员工主键',
|
`dept_id` bigint(20) NOT NULL COMMENT '所属部门ID',
|
`employee_name` varchar(64) NOT NULL COMMENT '员工名称',
|
`employee_no` varchar(64) NOT NULL COMMENT '员工编号',
|
`contact_phone_cipher` varchar(255) NOT NULL COMMENT '联系电话密文',
|
`contact_phone_hash` char(64) NOT NULL COMMENT '联系电话哈希，用于全匹配查询',
|
`position` varchar(64) NOT NULL DEFAULT '' COMMENT '岗位文本',
|
`card_no` varchar(64) DEFAULT NULL COMMENT '绑定卡号',
|
`face_image` longtext COMMENT '人脸图片',
|
`enabled` tinyint(1) NOT NULL DEFAULT 1 COMMENT '是否启用',
|
`del_flag` char(1) NOT NULL DEFAULT '0' COMMENT '删除标识：0正常 1删除',
|
`create_by` varchar(64) DEFAULT '' COMMENT '创建者',
|
`create_time` datetime DEFAULT NULL COMMENT '创建时间',
|
`update_by` varchar(64) DEFAULT '' COMMENT '更新者',
|
`update_time` datetime DEFAULT NULL COMMENT '更新时间',
|
PRIMARY KEY (`employee_id`),
|
UNIQUE KEY `uk_employee_no` (`employee_no`, `del_flag`),
|
UNIQUE KEY `uk_employee_phone_hash` (`contact_phone_hash`, `del_flag`),
|
KEY `idx_employee_dept` (`dept_id`, `del_flag`),
|
KEY `idx_employee_status` (`enabled`, `del_flag`),
|
KEY `idx_employee_card_no` (`card_no`, `del_flag`)
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='员工管理表';
|
