football

Tables (5)

daily_puzzles

  • id — INT — Primary key — NOT NULL
  • date — DATE — NOT NULL
  • player_id — INT — Foreign key → players.id — NOT NULL

guesses

  • id — INT — Primary key — NOT NULL
  • user_id — INT — Foreign key → users.id — NOT NULL
  • puzzle_id — INT — Foreign key → daily_puzzles.id — NOT NULL
  • player_id — INT — Foreign key → players.id — NOT NULL
  • attempt_no — INT — NOT NULL
  • birth_year_hint — ENUM('UP', 'DOWN', 'EQUAL') — NOT NULL
  • nationality_match — BOOLEAN — NOT NULL
  • position_match — BOOLEAN — NOT NULL
  • rank_hint — ENUM('UP', 'DOWN', 'EQUAL') — NOT NULL
  • league_titles_hint — ENUM('UP', 'DOWN', 'EQUAL') — NOT NULL
  • ucl_titles_hint — ENUM('UP', 'DOWN', 'EQUAL') — NOT NULL
  • debut_team_match — BOOLEAN — NOT NULL
  • height_hint — ENUM('UP', 'DOWN', 'EQUAL') — NOT NULL
  • created_at — DATETIME — NOT NULL

players

  • id — INT — Primary key — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • birth_year — INT — NOT NULL
  • nationality — VARCHAR(30) — NOT NULL
  • position — ENUM('GK', 'DF', 'MF', 'FW') — NOT NULL
  • team_id — INT — Foreign key → teams.id — NOT NULL
  • debut_team_id — INT — Foreign key → teams.id — NOT NULL
  • league_titles — INT — NOT NULL
  • ucl_titles — INT — NOT NULL
  • height_cm — INT — NOT NULL

teams

  • id — INT — Primary key — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • league — ENUM('EPL', 'LALIGA', 'SERIE_A', 'BUNDESLIGA', 'LIGUE_1')
  • rank_2526 — INT

users

  • id — INT — Primary key — NOT NULL
  • username — VARCHAR(30) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • created_at — DATETIME — NOT NULL