I want to make an app that show list of quotes to the user, and each user can favorites the quotes they like, so that the user can see all of the favorites quotes that the user favorited.
I want to make the app on Android Studio and using MySQL, not SQLite.
So if I want each user to have their own favorites list, then I must make a user table right? for login?
Is this table right?
Email, password and genre can be varchar. Since you want the members to choose their favorite quotes, you need to create a relationship between User and QuoteList table.
You can create another table
UserFavorite user_id quote_id
user_id and quote_id comes from the other two tables. This way you know which user favorites which quote. user_id comes from the logged in user and quote_id comes from any quote from the list of quotes.