# Database Schema

[andy-h-2016]

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

[andy-h-2016]

• Please look at Bluebird Schema for an example of how to format the Schema
• users
  • email_verified: verification of email sounds like another MVP. You would have to learn an email API, and figure out how to create verification links for new users. Recommend you drop this. Most people using your website would just skip the sign up and use the demo login feature.
  • profile_links: what is this? Can't comment unless I know what this is.
• posts
  • recommend renaming user_id to author_id for clearer meaning
  • link: If you intend for every post to have its own url, you do not need to store this url in the database. We will cover how to do this next week.
  • tags may have to be a separate table. Or alternatively an array/hash converted to a JSON string. In any case, I would save this as a bonus feature for searching by tags.
  • post_date should be handled by t.timestamps
  • source: don't know what this is
  • if this is image source, as Jordan mentioned in lecture, we will not be storing the image urls in the database but thru ActiveStorage/AWS
• follows
  • followed_type: Do we need this? What is it for?
• blogs_table
  • Don't need this. As we discussed last night, each user only has one blog. You don't need any of the columns listed in this table.
• tags
  • As mentioned above, this should be a bonus feature.

[andy-h-2016]

looks good