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