chongqing-server/sql/employee_additional_score.sql

-- ----------------------------
-- 员工附加分表
-- ----------------------------
DROP TABLE IF EXISTS `score_employee_additional`;
CREATE TABLE `score_employee_additional` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `dept_id` bigint(20) DEFAULT NULL COMMENT '部门ID',
  `dept_name` varchar(100) DEFAULT NULL COMMENT '部门名称',
  `team_id` bigint(20) DEFAULT NULL COMMENT '队室/班组ID',
  `team_name` varchar(100) DEFAULT NULL COMMENT '队室/班组',
  `group_id` bigint(20) DEFAULT NULL COMMENT '通道/小组ID',
  `group_name` varchar(100) DEFAULT NULL COMMENT '通道/小组',
  `user_id` bigint(20) DEFAULT NULL COMMENT '员工ID',
  `user_name` varchar(100) DEFAULT NULL COMMENT '员工姓名',
  `month_of_record` varchar(20) DEFAULT NULL COMMENT '附加分所属月份',
  `type` tinyint(4) DEFAULT NULL COMMENT '类型：1-加分，2-减分',
  `score` decimal(10,2) DEFAULT NULL COMMENT '分值（员工画像附加分）',
  `remark` varchar(500) DEFAULT NULL COMMENT '备注',
  `create_by` varchar(64) DEFAULT '' COMMENT '创建者',
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_by` varchar(64) DEFAULT '' COMMENT '更新者',
  `update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `del_flag` char(1) DEFAULT '0' COMMENT '删除标志(0正常 2删除)',
  PRIMARY KEY (`id`),
  KEY `idx_dept_id` (`dept_id`),
  KEY `idx_team_id` (`team_id`),
  KEY `idx_group_id` (`group_id`),
  KEY `idx_user_id` (`user_id`),
  KEY `idx_month_of_record` (`month_of_record`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='员工附加分表';