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