wordle
Tables (5)
ATTEMPT (Untitled4)
- attempt_id (Key) — INT — Primary key — NOT NULL
- user_id (Field) — INT
- daily_id (Field2) — INT
- guess_game_id (Field3) — INT
- attempt_number (Field4) — INT
- result (Field5) — VARCHAR
- created_at (Field6) — DATE
- user_id — INT — Foreign key → USER.user_id — NOT NULL
- daily_id (Key2) — INT — Foreign key → DAILY_GAME.daily_id — NOT NULL
- guess_game_id (id2) — INT — Foreign key → GAME.game_id — NOT NULL
DAILY_GAME (Untitled3)
- daily_id (Key) — INT — Primary key — NOT NULL
- date (Field) — DATE
- game_id (id) — INT — Foreign key → GAME.game_id — NOT NULL
GAME (Untitled2)
- game_id (id) — INT — Primary key — NOT NULL
- title — VARCHAR
- release_year (yearreleased) — INT
- developer (dev) — VARCHAR
- genre (Field4) — VARCHAR
- platform (Field5) — VARCHAR
- rating (Field6) — FLOAT
RESULT_DETAIL (Untitled5)
- result_id (Key) — INT — Primary key — NOT NULL
- attribute_name (Field2) — VARCHAR
- is_correct (Field3) — BOOLEAN
- attempt_id (Key2) — INT — Foreign key → ATTEMPT.attempt_id — NOT NULL
USER (Untitled)
- user_id — INT — Primary key — NOT NULL
- username — VARCHAR
- email — VARCHAR
- password — VARCHAR
- created_at (datecreated) — DATE