antissoft / lvqianmeiye_ERP

-- 创建健康师工资额外计算表
CREATE TABLE IF NOT EXISTS `lq_salary_extra_calculation` (
  `F_Id` VARCHAR(50) NOT NULL COMMENT '主键ID',
  `F_EmployeeId` VARCHAR(50) NULL COMMENT '健康师ID',
  `F_Year` INT NULL COMMENT '年份',
  `F_Month` INT NULL COMMENT '月份',
  `F_BaseRewardPerformance` DECIMAL(18,2) DEFAULT 0.00 COMMENT '基础奖励业绩',
  `F_CooperationRewardPerformance` DECIMAL(18,2) DEFAULT 0.00 COMMENT '合作奖励业绩',
  `F_NewCustomerPerformance` DECIMAL(18,2) DEFAULT 0.00 COMMENT '新客业绩',
  `F_NewCustomerConversionRate` DECIMAL(18,4) DEFAULT 0.0000 COMMENT '新客成交率',
  `F_UpgradePerformance` DECIMAL(18,2) DEFAULT 0.00 COMMENT '升单业绩',
  `F_UpgradeConversionRate` DECIMAL(18,4) DEFAULT 0.0000 COMMENT '升单成交率',
  PRIMARY KEY (`F_Id`),
  KEY `idx_employee_year_month` (`F_EmployeeId`, `F_Year`, `F_Month`),
  KEY `idx_year_month` (`F_Year`, `F_Month`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='健康师工资额外计算表';