From d37c463e8dcdc72edf992f8c010b5c9037a3dceb Mon Sep 17 00:00:00 2001 From: gaoluyang <2820782392@qq.com> Date: 星期三, 14 十月 2026 15:52:50 +0800 Subject: [PATCH] feat(hrm): 社保公积金方案支持按部门绑定，修比例输入精度 --- docs/sql/config_export_all_20260904.sql | 22 ++++++++++++++++++++-- 1 files changed, 20 insertions(+), 2 deletions(-) diff --git a/docs/sql/config_export_all_20260904.sql b/docs/sql/config_export_all_20260904.sql index d9bc193..38f3d3d 100644 --- a/docs/sql/config_export_all_20260904.sql +++ b/docs/sql/config_export_all_20260904.sql @@ -4060,8 +4060,8 @@ `contact_last_time` datetime DEFAULT NULL COMMENT '鏈�鍚庤窡杩涙椂闂�', `contact_next_time` datetime DEFAULT NULL COMMENT '涓嬫鑱旂郴鏃堕棿', `owner_user_id` bigint DEFAULT NULL COMMENT '璐熻矗浜虹殑鐢ㄦ埛缂栧彿', - `status_type_id` bigint NOT NULL COMMENT '鍟嗘満鐘舵�佺粍缂栧彿', - `status_id` bigint NOT NULL COMMENT '鍟嗘満鐘舵�佺紪鍙�', + `status_type_id` bigint DEFAULT NULL COMMENT '鍟嗘満鐘舵�佺粍缂栧彿', + `status_id` bigint DEFAULT NULL COMMENT '鍟嗘満鐘舵�佺紪鍙�', `end_status` int DEFAULT NULL COMMENT '缁撴潫鐘舵��', `end_remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '缁撴潫鏃剁殑澶囨敞', `deal_time` datetime DEFAULT NULL COMMENT '棰勮鎴愪氦鏃ユ湡', @@ -5525,6 +5525,8 @@ `maternity_ratio` decimal(5,4) NOT NULL DEFAULT '0.0050' COMMENT '鐢熻偛淇濋櫓浼佷笟缂寸撼姣斾緥', `housing_fund_company_ratio` decimal(5,4) NOT NULL DEFAULT '0.1200' COMMENT '鍏Н閲戜紒涓氱即绾虫瘮渚�', `housing_fund_personal_ratio` decimal(5,4) NOT NULL DEFAULT '0.1200' COMMENT '鍏Н閲戜釜浜虹即绾虫瘮渚�', + `default_social_security_base` decimal(12,2) DEFAULT NULL COMMENT '榛樿绀句繚缂磋垂鍩烘暟锛堢┖鍒欑敤鍛樺伐鍩烘湰宸ヨ祫锛�', + `default_housing_fund_base` decimal(12,2) DEFAULT NULL COMMENT '榛樿鍏Н閲戠即璐瑰熀鏁帮紙绌烘垨 0 鍒欑敤绀句繚缂磋垂鍩烘暟锛�', `status` tinyint NOT NULL DEFAULT '0' COMMENT '鐘舵�侊細0-鍚敤锛�1-绂佺敤', `remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '澶囨敞', `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '鍒涘缓鑰�', @@ -5536,6 +5538,22 @@ KEY `idx_effective_date` (`effective_date`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='HRM绀句繚鍏Н閲戞柟妗堣〃'; +-- ============ 琛細hrm_social_security_scheme_dept锛堜粎 DDL锛屾棤鏁版嵁锛� ============ +DROP TABLE IF EXISTS `hrm_social_security_scheme_dept`; +CREATE TABLE `hrm_social_security_scheme_dept` ( + `id` bigint NOT NULL AUTO_INCREMENT COMMENT '涓婚敭', + `scheme_id` bigint NOT NULL COMMENT '绀句繚鍏Н閲戞柟妗圛D', + `dept_id` bigint NOT NULL COMMENT '閫傜敤閮ㄩ棬ID', + `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '鍒涘缓鑰�', + `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', + `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '鏇存柊鑰�', + `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏇存柊鏃堕棿', + `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '鏄惁鍒犻櫎', + PRIMARY KEY (`id`) USING BTREE, + KEY `idx_scheme_id` (`scheme_id`) USING BTREE, + KEY `idx_dept_id` (`dept_id`) USING BTREE +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='HRM绀句繚鍏Н閲戞柟妗堥�傜敤閮ㄩ棬琛�'; + -- ============ 琛細hrm_tax_rate_config锛堜粎 DDL锛屾棤鏁版嵁锛� ============ DROP TABLE IF EXISTS `hrm_tax_rate_config`; CREATE TABLE `hrm_tax_rate_config` ( -- Gitblit v1.9.3