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

• After each table, show what tables foreign keys reference (e.g. profiles table: user_id references users)
• For associations the foreign key should be in the table that belongs_to another table. (e.g. actor_id shouldn't be in the tv_shows table, there should instead be a tv_show_id in the actors table OR have a joins table for tv_show_actors that has both foreign keys)
• creators, actors, directors, and writers are all very simple and similar tables. Maybe combine them together and just have a type column or something
• for many to many relationships, use joins tables
• my_lists should have another joins table. Make sure you're saving a list in this table with its own id, and then have another table that has list_id, movie_id, and tv_show_id foreign keys

[hwkcode]

• [DONE] After each table, show what tables foreign keys reference (e.g. profiles table: user_id references users)
• [DONE - Created joins tables at bottom] For associations the foreign key should be in the table that belongs_to another table. (e.g. actor_id shouldn't be in the tv_shows table, there should instead be a tv_show_id in the actors table OR have a joins table for tv_show_actors that has both foreign keys)
• [_DONE - combined under "cast_andcrew"] creators, actors, directors, and writers are all very simple and similar tables. Maybe combine them together and just have a type column or something
• [DONE] for many to many relationships, use joins tables
• [ONGOING - Would like to discuss further] my_lists should have another joins table. Make sure you're saving a list in this table with its own id, and then have another table that has list_id, movie_id, and tv_show_id foreign keys

[hwkcode]

• Updated unique combinations in joins tables and for mylist
• Discussed my_lists setup