-- 员工管理
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='员工管理表';