Ball:Link

Tables (19)

files

  • created_at — datetime(6)
  • size_bytes — bigint
  • file_id — varchar(36) — NOT NULL
  • content_type — varchar(255)
  • original_name — varchar(255)
  • category — enum
  • owner_id — bigint
  • owner_type — enum
  • relative_path — varchar(255)

game_events

  • period — int — NOT NULL
  • game_id — bigint
  • id — bigint
  • player_id — bigint
  • team_id — bigint
  • ts — datetime(6)
  • clock_time — varchar(255)
  • meta — longtext
  • team_side — enum
  • type — varchar(32) — NOT NULL

game_lineup_players

  • guest_number — smallint
  • is_starter — bit — NOT NULL
  • number — smallint
  • game_id — bigint
  • id — bigint
  • player_id — bigint
  • team_id — bigint
  • guest_name — varchar(255)
  • position — enum
  • team_side — enum

game_player_stats

  • ast — int — NOT NULL
  • blk — int — NOT NULL
  • fg2att — int — NOT NULL
  • fg2made — int — NOT NULL
  • fg3att — int — NOT NULL
  • fg3made — int — NOT NULL
  • ft_att — int — NOT NULL
  • ft_made — int — NOT NULL
  • minutes — decimal(38, 2)
  • pf — int — NOT NULL
  • pts — int — NOT NULL
  • reb — int — NOT NULL
  • stl — int — NOT NULL
  • tov — int — NOT NULL
  • game_id — bigint
  • id — bigint
  • player_id — bigint
  • team_id — bigint

game_team_stats

  • ast — int — NOT NULL
  • blk — int — NOT NULL
  • pf — int — NOT NULL
  • pts — int — NOT NULL
  • reb — int — NOT NULL
  • stl — int — NOT NULL
  • tov — int — NOT NULL
  • game_id — bigint
  • id — bigint
  • team_id — bigint
  • fg2 — int
  • fg3 — int
  • ft — int

games

  • bracket_order — int
  • away_team_id — bigint
  • created_at — datetime(6)
  • finished_at — datetime(6)
  • home_team_id — bigint
  • id — bigint
  • scheduled_at — datetime(6)
  • started_at — datetime(6)
  • tournament_id — bigint
  • venue_id — bigint
  • canceled_reason — varchar(255)
  • opponent_name — varchar(255)
  • round_code — enum
  • state — enum
  • deleted_at — datetime(6)
  • is_scrimmage — bit — NOT NULL
  • away_team_name — varchar(255)
  • home_team_name — varchar(255)

invites

  • max_uses — int
  • used_count — int
  • created_at — datetime(6)
  • created_by — bigint
  • expires_at — datetime(6)
  • revoked_at — datetime(6)
  • team_id — bigint
  • code — varchar(32) — NOT NULL
  • status — enum

join_requests

  • applicant_user_id — bigint
  • applied_at — datetime(6)
  • id — bigint
  • processed_at — datetime(6)
  • processed_by — bigint
  • team_id — bigint
  • invite_code — varchar(32)
  • bio — varchar(255)
  • location — varchar(255)
  • reject_reason — varchar(255)
  • position — enum
  • status — enum

password_reset_token

  • used — bit — NOT NULL
  • expires_at — datetime(6) — NOT NULL
  • id — bigint
  • email — varchar(255) — NOT NULL
  • token — varchar(255) — NOT NULL

players

  • is_active — bit — NOT NULL
  • number — smallint
  • created_at — datetime(6)
  • deleted_at — datetime(6)
  • id — bigint
  • team_id — bigint
  • updated_at — datetime(6)
  • user_id — bigint
  • name — varchar(100) — NOT NULL
  • note — varchar(255)
  • position — enum

score_sessions

  • created_at — datetime(6)
  • ended_at — datetime(6)
  • created_by — bigint
  • expires_at — datetime(6)
  • game_id — bigint
  • id — bigint
  • status — enum
  • tournament_id — bigint
  • session_token — varchar(128) — NOT NULL

team_members

  • id — bigint
  • joined_at — datetime(6)
  • left_at — datetime(6)
  • team_id — bigint
  • user_id — bigint
  • role — enum
  • back_number — int
  • location — varchar(100)
  • position — varchar(10)

teams

  • founded_at — date
  • is_public — bit — NOT NULL
  • created_at — datetime(6)
  • deleted_at — datetime(6)
  • id — bigint
  • owner_user_id — bigint
  • updated_at — datetime(6)
  • name — varchar(120) — NOT NULL
  • emblem_url — varchar(500)
  • description — longtext
  • region — varchar(255)
  • short_name — varchar(255)
  • team_tag — varchar(4) — NOT NULL

tournament_entries

  • locked — bit — NOT NULL
  • number — smallint
  • id — bigint
  • player_id — bigint
  • team_id — bigint
  • tournament_id — bigint
  • note — varchar(255)
  • position — enum

tournament_teams

  • seed — int
  • created_at — datetime(6)
  • id — bigint
  • team_id — bigint
  • tournament_id — bigint

tournaments

  • end_date — date
  • start_date — date
  • created_at — datetime(6)
  • id — bigint
  • venue_id — bigint
  • name — varchar(150) — NOT NULL
  • location — varchar(255)
  • season — varchar(255)
  • status — enum

user_providers

  • created_at — datetime(6)
  • id — bigint
  • user_id — bigint
  • provider_user_id — varchar(191) — NOT NULL
  • email — varchar(255)
  • provider — enum

users

  • birth_year — smallint
  • created_at — datetime(6)
  • id — bigint
  • updated_at — datetime(6)
  • name — varchar(100) — NOT NULL
  • email — varchar(255)
  • password_hash — varchar(255)
  • phone — varchar(255)
  • gender — enum
  • profile_image_path — varchar(255)
  • is_admin — bit — NOT NULL

venues

  • created_at — datetime(6)
  • id — bigint
  • name — varchar(150) — NOT NULL
  • address — varchar(255)
  • phone — varchar(255)