Knowledge Base ~ ERD - uchicago-cs/chigame GitHub Wiki

Knowledge Base ERD

Entities

• Guides

  • Name (str)
  • Game (foreign key)
  • User (foreign key)
  • Status (one of: "pending", "changes requested", "accepted")
  • Content (long str)
  • Number of likes (int)
  • Date created

• Review Feedback

  • Review (long string)
  • Reviewer (foreign key)
  • Guide (foreign key)
  • Approved (bool)
  • Date

Relationships

• One game can have exactly one guide published.
• One game could have multiple guides archived.
• One guide could have multiple pieces of feedback
• One user can publish multiple guides
• n users can like m guides
• n users can save m guides
• One moderator can review multiple guides