新人派对申请.sql

CREATE TABLE `invite_apply` (
                             `id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT 'id',
                             `user_id` bigint NOT NULL COMMENT '发起申请者',
                             `new_user_id` bigint NOT NULL COMMENT '被邀请的人',
                             `platform` varchar(20) NOT NULL COMMENT '来自平台',
                             `platform_id` varchar(150) NOT NULL COMMENT '平台id',
                             `recharge_info` varchar(50) NOT NULL COMMENT '新用户在其它平台充值的标志',
                             `status` tinyint unsigned NOT NULL COMMENT '状态0.未审核1.已通过2.已拒绝',
                             `level` varchar(5) NOT NULL DEFAULT '' COMMENT '申请等级(S,A,B,C)',
                             `video_url` varchar(400) NOT NULL COMMENT '上传的视频url',
                             `reason` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '拒绝原因',
                             `created_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
                             `updated_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
                             PRIMARY KEY (`id`),
                             KEY `user_id` (`user_id`) USING BTREE,
                             KEY `new_user_id` (`new_user_id`) USING BTREE,
                             KEY `platform` (`platform`) USING BTREE,
                             KEY `status` (`status`) USING BTREE,
                             KEY `created_time` (`created_time`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='新人邀请申请';