moodln / new_wave

New Wave is a single page clone of BandCamp - a website that hosts artists' music and allows fans to follow and purchase songs or albums from artists.

https://newwwave.herokuapp.com/#/

5 stars 1 forks source link

Database Schema #3

Closed okj203 closed 2 years ago

okj203 commented 2 years ago

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 tables' names 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

okj203 commented 2 years ago

[x] You probably don't want to create an artist table, because artists ARE users as well. Therefore, the artist page would essentially be a user show page.
[x] Songs and genres have many-to-many relationships, artist or not. A song belongs to a user, but a genre belongs to a song, not a specific user/artist. ex. Rihanna can sing a punk rock song, but that doesn't mean the entire genre of punk rock belongs to Rihanna. So you'll need to remove the artist_id from your genres tables, and instead create a joins table for songs and genres, through which they can have many-to-many relationships. ex. A song can have many genres, such as pop AND rock, but pop genre can ALSO have many songs.

moodln commented 2 years ago

I decided to include an artist_id in the users table, so that I can have a self-join association to display all artists that a user is following. Does that make sense? I'm also considering adding an albums table, to keep all of the songs more organized, but I'm not sure if that is necessary. After all, I could just gather the songs together based off of the 'album' key in their table. Thank you for your insight about the artists table and the genre_joins table !!

okj203 commented 2 years ago

[x] Anytime! Self-join makes sense here, but remember that you're trying to create many-to-many self-join, where a user can follow many artists while having many followers herself/himself, NOT a one-to-many self-join.

moodln commented 2 years ago

ooof - many-to-many self-join, sounds like fun 😆 i'm doing research for that now.. i know we covered it before but i'm going to have to brush up on it- thank you !!