Achievements ~ ERD - uchicago-cs/chigame GitHub Wiki

Entities

• Achievement
  • ID (primary, autoincrementing integer)
  • Name (String)
  • Rarity (String, one of “Precious”, “Rare”, “Uncommon”, or “Common”)
  • Spoiler (Boolean)
  • Date and time unlocked (Date/Time)
• User (taken from Forums ERD)
  • user name (string)
  • first name (string)
  • last name (string)
  • email (string)
• Game (adapted from Tournaments ERD)
  • ID (primary, autoincrementing integer)
  • Name (String)

Relationships

• A user has N achievements (1-to-many)
• A game has N achievements (1-to-many)
• A user has played N games (1-to-many)