CREATE TABLE `tournament_session`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `object_id` int(11) NULL DEFAULT NULL,
  `subject_id` int(11) NULL DEFAULT NULL,
  `is_evaluated` BIT(1) DEFAULT 0b00,
  `created_at` TIMESTAMP NOT NULL,
  `updated_at` TIMESTAMP NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `idx-tournament_session-id`(`id`) USING BTREE,
  INDEX `fk-tournament_session-subject_id`(`subject_id`) USING BTREE,
  CONSTRAINT `fk-tournament_session-subject_id` FOREIGN KEY (`subject_id`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  INDEX `fk-tournament_session-object_id`(`object_id`) USING BTREE,
  CONSTRAINT `fk-tournament_session-object_id` FOREIGN KEY (`object_id`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Compact;