kknongchang_2506/app/Module/Promotionurs/Databases/GenerateSql/team_profit_rules.sql

-- ******************************************************************
-- 表 kku_promotion_profit_rules 的创建SQL
-- 对应的Model: App\Module\Promotion\Models\PromotionProfitRule
-- 警告: 此文件由系统自动生成，禁止修改！
-- ******************************************************************

CREATE TABLE `kku_promotion_profit_rules` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `source_type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '来源类型',
  `direct_profit_rate` decimal(5,4) NOT NULL COMMENT '直推分成比例',
  `max_indirect_level` int NOT NULL DEFAULT '20' COMMENT '最大间推层级',
  `status` tinyint unsigned NOT NULL DEFAULT '1' COMMENT '状态:1有效,0无效',
  `rules` json DEFAULT NULL COMMENT '特殊规则',
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `idx_source_type` (`source_type`) USING BTREE,
  KEY `idx_status` (`status`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='收益分成规则表';