Schema

[bamorgan13]

• [x] If a user can only have one list (My List), then having a lists table is unnecessary. You can connect the movies directly to the user_id in your list_item table instead of connecting them to a list then a user. A lists table would be necessary if you were planning on allowing users to create multiple lists, keeping track of the list's name and user_id, then have your list_item keep track of which list it connects to (like you currently do).
• [x] Your MVP list indicates you're planning on including both movies and tv shows. If this is the case you would need to include tables for tv series and episodes. If you are just going to do movies, remove the mention of tv show from your MVP list. (I would stick with just movies for now, you can always add in the tv show functionality later if you have more time).
• [x] By keeping genres on the movies table, you are potentially going to be searching this table on many occasions for matches (find all horror movies, find all action movies, etc.). Put an index on this column in order to speed up this process.