| | |
| | | `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 '创建者', |
| | |
| | | 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 '社保公积金方案ID', |
| | | `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` ( |