From d476e7d1595e131f2bb7bb1a62c00fa3e82fb0a7 Mon Sep 17 00:00:00 2001 From: yuan <123@> Date: 星期一, 19 十月 2026 17:23:30 +0800 Subject: [PATCH] feat: 添加员工工资明细中的请假、缺勤、迟到、早退次数及手动扣工资字段 --- sql/product-inventory-management-new-pro.sql | 6 +++--- 1 files changed, 3 insertions(+), 3 deletions(-) diff --git a/sql/product-inventory-management-new-pro.sql b/sql/product-inventory-management-new-pro.sql index 20746ca..5e24716 100644 --- a/sql/product-inventory-management-new-pro.sql +++ b/sql/product-inventory-management-new-pro.sql @@ -4672,14 +4672,14 @@ `other_deduct` decimal(10, 2) NULL DEFAULT 0.00 COMMENT '鍏朵粬鏀嚭', `salary_tax` decimal(10, 2) NULL DEFAULT 0.00 COMMENT '宸ヨ祫涓◣', `gross_salary` decimal(10, 2) NULL DEFAULT 0.00 COMMENT '搴斿彂宸ヨ祫', - `deduct_salary` decimal(10, 2) NULL DEFAULT 0.00 COMMENT '搴旀墸宸ヨ祫', + `deduct_salary` decimal(10, 2) NULL DEFAULT 0.00 COMMENT '搴旀墸绀句繚', `leave_count` int NULL DEFAULT 0 COMMENT '璇峰亣娆℃暟', `absence_count` int NULL DEFAULT 0 COMMENT '缂哄嫟娆℃暟', `late_count` int NULL DEFAULT 0 COMMENT '杩熷埌娆℃暟', `early_count` int NULL DEFAULT 0 COMMENT '鏃╅��娆℃暟', - `manual_deduct` decimal(10, 2) NULL DEFAULT 0.00 COMMENT '鎵ｅ伐璧勶紙鎵嬪姩濉啓锛�', + `manual_deduct` decimal(10, 2) NULL DEFAULT 0.00 COMMENT '搴旀墸宸ヨ祫锛堟墜鍔ㄥ～鍐欙級', `net_salary` decimal(10, 2) NULL DEFAULT 0.00 COMMENT '瀹炲彂宸ヨ祫', - `remark` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '澶囨敞', + `remark` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '澶囨敞', `create_time` datetime NULL DEFAULT NULL COMMENT '鍒涘缓鏃堕棿', `create_user` bigint NULL DEFAULT NULL COMMENT '鍒涘缓鐢ㄦ埛', `update_time` datetime NULL DEFAULT NULL COMMENT '淇敼鏃堕棿', -- Gitblit v1.9.3