Skip to content

Adding Games II ~ ERD

Yohan De Guzman edited this page Apr 22, 2025 · 2 revisions

User

  • UserID (int)
  • First_Name (str)
  • Last_Name (str)
  • Username (str)
  • Email (str)

Game

  • Date_Completed (time)
  • Past_Guesses (str)
  • Current_Guess (str)
  • Right_or_Wrong (bool)
  • Score (nullable int)

Date

  • DateID (int)
  • Month (int)
  • Day (int)
  • Year (int)
  • Word (str)

Guess

  • Guess_Number (int 1-6)
  • Guessed_Word (str)

Relationships

  • Game.UserID is a foreign key referencing User.UserID
  • Guess.GameID is a foreign key referencing Game.GameID
  • Game.DateID is a foreign key referencing Date.DateID
  • Date.Word holds the solution word for that day
Clone this wiki locally