owl-admin/doc/系统设计/数据库设计/物理模型/分析后台设计增加/01用户列表-分销团队表.sql

-- Active: xiaoding_test@@192.168.110.85@3306@xiaoding_test
-- 分销团队表
DROP TABLE IF EXISTS `market_dist_teams`;
CREATE TABLE IF NOT EXISTS `market_dist_teams` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT '分销团队编号',
 `object_id` bigint unsigned NOT NULL COMMENT '对象编号',
 `object_type` varchar(255) NOT NULL COMMENT '对象类型',
 `user_id` bigint unsigned NOT NULL COMMENT '被邀用户编号',
 `level` varchar(255) NOT NULL DEFAULT '1' COMMENT '层级',
 `state` varchar(255) NOT NULL DEFAULT 'ENABLE' COMMENT '状态',
 `created_at` timestamp NULL DEFAULT NULL COMMENT '创建时间',
 `updated_at` timestamp NULL DEFAULT NULL COMMENT '更新时间',
 `deleted_at` timestamp NULL DEFAULT NULL COMMENT '删除时间',
 PRIMARY KEY (`id`),
 UNIQUE KEY `uk_object_user` (
 `object_id`,
 `object_type`,
 `user_id`
 ),
 KEY `idx_user_id` (`user_id`),
CONSTRAINT `fk_dist_teams_user_id` FOREIGN KEY (`user_id`) REFERENCES `member_users` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '分销团队表';