CREATE TABLE `round_participants` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `round_id` int(11) NOT NULL,
  `round_id_str` varchar(12) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_id` int(11) NOT NULL,
  `nickname` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `avatar` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT '01',
  `up_original` decimal(15,2) DEFAULT '0.00',
  `up_approved` decimal(15,2) DEFAULT '0.00',
  `up_returned` decimal(15,2) DEFAULT '0.00',
  `down_original` decimal(15,2) DEFAULT '0.00',
  `down_approved` decimal(15,2) DEFAULT '0.00',
  `down_returned` decimal(15,2) DEFAULT '0.00',
  `total_payout` decimal(15,2) DEFAULT '0.00',
  `total_profit` decimal(15,2) DEFAULT '0.00',
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `unique_round_user` (`round_id`,`user_id`),
  KEY `idx_round_id` (`round_id`),
  KEY `idx_user_id` (`user_id`),
  CONSTRAINT `round_participants_ibfk_1` FOREIGN KEY (`round_id`) REFERENCES `game_rounds` (`id`) ON DELETE CASCADE,
  CONSTRAINT `round_participants_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=6699 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci