Ball:link 초안

테이블 (17)

files

  • file_id — CHAR(36) — 기본 키 — NOT NULL
  • original_name — VARCHAR(255) — NOT NULL
  • content_type — VARCHAR(100) — NOT NULL
  • size_bytes — BIGINT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

game_events

  • id — BIGINT — 기본 키 — NOT NULL
  • game_id — BIGINT — NOT NULL
  • ts — DATETIME — NOT NULL
  • period — INT — NOT NULL
  • clock_time — VARCHAR(8)
  • team_id — BIGINT
  • team_side — ENUM('HOME','AWAY')
  • player_id — BIGINT
  • type — ENUM( 'SCORE','FOUL','TIMEOUT','SUBSTITUTION', 'ASSIST','STEAL','BLOCK','TURNOVER', 'REBOUND_O','REBOUND_D', 'PERIOD_START','PERIOD_END', 'CLOCK_UPDATE','SHOTCLOCK_RESET', 'NOTE' ) — NOT NULL
  • meta — JSON

game_lineup_players

  • id — BIGINT — 기본 키 — NOT NULL
  • game_id — BIGINT — NOT NULL
  • team_id — BIGINT — NOT NULL
  • team_side — ENUM('HOME','AWAY') — NOT NULL
  • player_id — BIGINT
  • guest_name — VARCHAR(100)
  • guest_number — SMALLINT
  • is_starter — TINYINT(1) — NOT NULL
  • number — SMALLINT
  • position — ENUM('PG','SG','SF','PF','C')

game_player_stats

  • id — BIGINT — 기본 키 — NOT NULL
  • game_id — BIGINT — NOT NULL
  • team_id — BIGINT — NOT NULL
  • player_id — BIGINT — NOT NULL
  • pts — INT — NOT NULL
  • reb — INT — NOT NULL
  • ast — INT — NOT NULL
  • stl — INT — NOT NULL
  • blk — INT — NOT NULL
  • fg2_made — INT — NOT NULL
  • fg2_att — INT — NOT NULL
  • fg3_made — INT — NOT NULL
  • fg3_att — INT — NOT NULL
  • ft_made — INT — NOT NULL
  • ft_att — INT — NOT NULL
  • tov — INT — NOT NULL
  • pf — INT — NOT NULL
  • minutes — DECIMAL(5,2) — NOT NULL

game_team_stats

  • id — BIGINT — 기본 키 — NOT NULL
  • game_id — BIGINT — NOT NULL
  • team_id — BIGINT — NOT NULL
  • pts — INT — NOT NULL
  • reb — INT — NOT NULL
  • ast — INT — NOT NULL
  • stl — INT — NOT NULL
  • blk — INT — NOT NULL
  • tov — INT — NOT NULL
  • pf — INT — NOT NULL

games

  • id — BIGINT — 기본 키 — NOT NULL
  • tournament_id — BIGINT
  • home_team_id — BIGINT — NOT NULL
  • away_team_id — BIGINT
  • opponent_name — VARCHAR(120)
  • round_code — ENUM('GROUP','ROUND_OF_16','QF','SF','FINAL')
  • bracket_order — INT
  • state — ENUM('SCHEDULED','ONGOING','FINISHED','CANCELED') — NOT NULL
  • scheduled_at — DATETIME
  • started_at — DATETIME
  • finished_at — DATETIME
  • canceled_reason — VARCHAR(255)
  • venue_id — BIGINT
  • created_at — TIMESTAMP — NOT NULL

invites

  • code — VARCHAR(32) — 기본 키 — NOT NULL
  • team_id — BIGINT — NOT NULL
  • status — ENUM('ACTIVE','REVOKED','EXPIRED') — NOT NULL
  • expires_at — DATETIME
  • max_uses — INT
  • used_count — INT — NOT NULL
  • created_by — BIGINT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • revoked_at — DATETIME

join_requests

  • id — BIGINT — 기본 키 — NOT NULL
  • team_id — BIGINT — NOT NULL
  • applicant_user_id — BIGINT — NOT NULL
  • position — ENUM('PG','SG','SF','PF','C')
  • location — VARCHAR(100)
  • bio — TEXT
  • invite_code — VARCHAR(32)
  • status — ENUM('PENDING','ACCEPTED','REJECTED') — NOT NULL
  • applied_at — TIMESTAMP — NOT NULL
  • processed_at — DATETIME
  • processed_by — BIGINT
  • reject_reason — VARCHAR(255)

players

  • id — BIGINT — 기본 키 — NOT NULL
  • team_id — BIGINT — NOT NULL
  • user_id — BIGINT
  • name — VARCHAR(100) — NOT NULL
  • number — SMALLINT
  • position — ENUM('PG','SG','SF','PF','C')
  • note — VARCHAR(255)
  • active — TINYINT(1) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • deleted_at — TIMESTAMP
  • is_active — TINYINT(1) — NOT NULL

score_sessions

  • id — BIGINT — 기본 키 — NOT NULL
  • game_id — BIGINT — NOT NULL
  • session_token — VARCHAR(64) — NOT NULL
  • created_by — BIGINT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • expires_at — DATETIME
  • status — ENUM('ACTIVE','EXPIRED','CLOSED') — NOT NULL

team_members

  • id — BIGINT — 기본 키 — NOT NULL
  • team_id — BIGINT — NOT NULL
  • user_id — BIGINT — NOT NULL
  • role — ENUM('LEADER','MANAGER','PLAYER') — NOT NULL
  • joined_at — TIMESTAMP — NOT NULL
  • left_at — TIMESTAMP

teams

  • id — BIGINT — 기본 키 — NOT NULL
  • owner_user_id — BIGINT — NOT NULL
  • name — VARCHAR(120) — NOT NULL
  • short_name — VARCHAR(50)
  • founded_year — SMALLINT
  • region — VARCHAR(50)
  • description — TEXT
  • emblem_file_id — CHAR(36)
  • color_primary — VARCHAR(9)
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • deleted_at — TIMESTAMP

tournament_entries

  • id — BIGINT — 기본 키 — NOT NULL
  • tournament_id — BIGINT — NOT NULL
  • team_id — BIGINT — NOT NULL
  • player_id — BIGINT — NOT NULL
  • number — SMALLINT
  • position — ENUM('PG','SG','SF','PF','C')
  • note — VARCHAR(255)
  • locked — TINYINT(1) — NOT NULL

tournament_teams

  • id — BIGINT — 기본 키 — NOT NULL
  • tournament_id — BIGINT — NOT NULL
  • team_id — BIGINT — NOT NULL
  • seed — INT
  • created_at — TIMESTAMP — NOT NULL

tournaments

  • id — BIGINT — 기본 키 — NOT NULL
  • name — VARCHAR(150) — NOT NULL
  • season — VARCHAR(20)
  • location — VARCHAR(100)
  • status — ENUM('SCHEDULED','ONGOING','FINISHED','CANCELED') — NOT NULL
  • start_date — DATE
  • end_date — DATE
  • venue_id — BIGINT
  • created_at — TIMESTAMP — NOT NULL

users

  • id — BIGINT — 기본 키 — NOT NULL
  • email — VARCHAR(255)
  • password_hash — VARCHAR(255)
  • name — VARCHAR(100) — NOT NULL
  • gender — ENUM('M','F')
  • birth_year — SMALLINT
  • phone — VARCHAR(30)
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

venues

  • id — BIGINT — 기본 키 — NOT NULL
  • name — VARCHAR(150) — NOT NULL
  • address — VARCHAR(255)
  • phone — VARCHAR(30)
  • created_at — TIMESTAMP — NOT NULL