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