26d4de1e
 “wangming”
feat: 添加健康师工资额外计算...
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
|
-- 创建健康师工资额外计算表
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='健康师工资额外计算表';
|
