🔒 Closed Database design for Watchlist, Favorites, Watched

Status
Not open for further replies.

Red-Eyed XaXa

Honorary Poster
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.
 
Status
Not open for further replies.

About this Thread

  • 2
    Replies
  • 404
    Views
  • 2
    Participants
Last reply from:
Red-Eyed XaXa

Online now

Members online
1,024
Guests online
722
Total visitors
1,746

Forum statistics

Threads
2,276,959
Posts
28,973,344
Members
1,229,665
Latest member
hellowwolrd
Back
Top