minglei/mjava-minglei/src/main/resources/db/employee_roster.sql

CREATE TABLE employee_roster (
  id INT NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  dingtalk_id VARCHAR(64) DEFAULT NULL COMMENT '钉钉ID',
  employee_no VARCHAR(64) DEFAULT NULL COMMENT '工号ID',
  username VARCHAR(64) NOT NULL COMMENT '用户名',
  job_title VARCHAR(128) DEFAULT NULL COMMENT '职称',
  job_title_id VARCHAR(64) DEFAULT NULL COMMENT '职称ID',
  job_grade VARCHAR(32) DEFAULT NULL COMMENT '职等',
  job_grade_id VARCHAR(64) DEFAULT NULL COMMENT '职等ID',
  department VARCHAR(128) DEFAULT NULL COMMENT '部门',
  first_department VARCHAR(128) DEFAULT NULL COMMENT '一级部门',
  PRIMARY KEY (id),
  UNIQUE KEY uk_dingtalk_id (dingtalk_id),
  UNIQUE KEY uk_employee_no (employee_no),
  KEY idx_department (department),
  KEY idx_first_department (first_department)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='员工花名册表';