futsal

Tables (11)

team_members

  • id — BIGINT
  • team_id — BIGINT — Foreign key → teams.id — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • role — VARCHAR(20) — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • position — VARCHAR(20) — NOT NULL
  • joined_at — DATETIME — NOT NULL

team_tactics

  • id — BIGINT
  • team_id — BIGINT — Foreign key → teams.id — NOT NULL
  • formation — VARCHAR(20) — NOT NULL
  • players_json — TEXT
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

teams

  • id — BIGINT
  • name — VARCHAR(100) — NOT NULL
  • region — VARCHAR(50) — NOT NULL
  • logo_url — VARCHAR(500)
  • captain_user_id — BIGINT — Foreign key → users.id — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

tournament_applications

  • id — BIGINT
  • tournament_id — BIGINT — Foreign key → tournaments.id — NOT NULL
  • team_id — BIGINT — Foreign key → teams.id — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • memo — TEXT
  • applied_at — DATETIME — NOT NULL

tournament_group_teams

  • group_id — BIGINT — Foreign key → tournament_groups.id — NOT NULL
  • team_id — BIGINT — Foreign key → teams.id — NOT NULL

tournament_groups

  • id — BIGINT
  • tournament_id — BIGINT — Foreign key → tournaments.id — NOT NULL
  • group_name — VARCHAR(10) — NOT NULL
  • group_order — INT — NOT NULL

tournament_matches

  • id — BIGINT
  • tournament_id — BIGINT — Foreign key → tournaments.id — NOT NULL
  • round — INT — NOT NULL
  • match_number — INT — NOT NULL
  • group_id — VARCHAR(10)
  • team1_id — BIGINT — Foreign key → teams.id
  • team2_id — BIGINT — Foreign key → teams.id
  • team1_score — INT
  • team2_score — INT
  • team1_penalty_score — INT
  • team2_penalty_score — INT
  • winner_id — BIGINT — Foreign key → teams.id
  • status — VARCHAR(20) — NOT NULL
  • scheduled_at — DATETIME
  • started_at — DATETIME
  • finished_at — DATETIME
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

tournament_participants

  • id — BIGINT
  • tournament_id — BIGINT — Foreign key → tournaments.id — NOT NULL
  • team_id — BIGINT — Foreign key → teams.id — NOT NULL
  • team_name — VARCHAR(100) — NOT NULL
  • team_logo_url — VARCHAR(500)
  • registered_by — BIGINT — Foreign key → users.id — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

tournament_posters

  • poster_url — VARCHAR(500) — Primary key — NOT NULL
  • tournament_id — BIGINT — Foreign key → tournaments.id — NOT NULL

tournaments

  • id — BIGINT
  • title — VARCHAR(100) — NOT NULL
  • tournament_date — DATE — NOT NULL
  • location — VARCHAR(100) — NOT NULL
  • player_type — VARCHAR(20) — NOT NULL
  • gender — VARCHAR(10) — NOT NULL
  • description — TEXT — NOT NULL
  • view_count — INT — NOT NULL
  • original_link — VARCHAR(500) — NOT NULL
  • tournament_type — VARCHAR(30) — NOT NULL
  • max_teams — INT — NOT NULL
  • share_code — VARCHAR(8)
  • allow_join — BOOLEAN — NOT NULL
  • group_count — INT
  • teams_per_group — INT
  • swiss_rounds — INT
  • bracket_generated — BOOLEAN — NOT NULL
  • recruitment_status — VARCHAR(20) — NOT NULL
  • user_id — BIGINT — Foreign key → users.id
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

users

  • id — BIGINT
  • kakao_id — BIGINT — NOT NULL
  • nickname — VARCHAR(50) — NOT NULL
  • profile_image_url — VARCHAR(500)
  • role — VARCHAR(20) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL