What's new

Help Database design for Watchlist, Favorites, Watched

Red-Eyed XaXa

Established
May tatlong feature akong gusto idagdag which is watchlist,favorites, and watched para sa movies and tv shows.
Ano po marerecommend niyong design?
-> Gagawa ako ng tatlong table pero same column lang sila (user_id, movie_id,media_type).
-> Or isang table nalang pero apat ang column (user_id, movie_id, media_type, status ).
Yung status column mag dedetermine kung Watchlist, Watched, or Favorite ng user yung movie or tv show.
 
Top