HSA Final Project - BACKEND Description
-
users: contains user ID and some basic user information
-
artists: contains artist ID and name (we can add more information after API implementation)
-
songs: contains song ID, title, genre, and artist ID (limitation: currently a song can only have one artist; there is no two-way table)
-
usersongs: contains a user ID and the song ID that the user likes (currently, there are some redundancies due to the random generator)
-
userartists: contains a user ID and the song ID that the user likes (currently, there are some redundancies due to the random generator)
-
usergenres: contains a user ID and a genre the user likes (the genre is just a string)
-
matches: contains user IDs matched to one another (currently, there is only 1 match per user, and most matches are not injective yet)
GraphQL mutations and queries have also been written, with examples in the text file