Adding Games II ~ ERD - uchicago-cs/chigame GitHub Wiki
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