Issue #03 - Schema

[keginzburg]

Database Schema

• [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

1. We can nix the has_many :jobposts association for our users.
2. Can comments have a parent_comment_id? Should they? Does LinkedIn allow for this kind of comment threads?
3. Can you clarify what your connections table stores? Is the conenction_id another user's id? If it is, then does that establish a connection and if it does, then do we want that connection to be unique?
4. I like that we're aiming for Polymorphic associations for our Likes. We can discuss these later and possibly scale down to just Likes for Posts, depending on our progress. Polymorphism could be a Bonus.

[seanieboi6687]

done