Database Schema

[KevinHJo]

• [x] Contains correct datatypes
• [x] Contains appropriate constraints/details
  • [x] primary key
  • [x] not null
  • [x] unique
  • [x] indexed
  • [x] foreign key
• [x] Contains bullet points after the table that state which foreign keys will reference to which table, or references to the associations which will be made
  • [x] foreign key and table name are lowercased, snake_cased and back_ticked
• [x] Correctly formatted
  • [x] schema is written in a table format
  • [x] the table's name are lowercased, snake_cased and back_ticked
  • [x] the table header column names are bolded
  • [x] columns names are lowercased and snaked_cased and back_ticked

    Comments

• when displaying associations in the bullet points, include "references table_name"
• maintain formatting (friendships bullet point for unique constraint vs users table)
• how will replier_id be used? won't the reply itself already have a sender_id of its own
• specify which tables foreign keys reference (e.g. foreign key: sender_id references users)
• you may need two more tables. how are you planning to keep track of which servers and channels users are subscribed to? (separate from which servers users own)

[KevinHJo]

• make sure table names are backticked
• will all members of a server see all of the channels in that server? Discord has a feature of channel memberships as well as server memberships, but that could be out of scope for this clone. Depends on how you'd like to approach it. If you want channel memberships, make sure you add another table