RobinHeidenis / bucketlist

Movie, show, and bucket list app to keep track of all the things you still want to watch or do
https://bucketlist.fractum.nl
1 stars 0 forks source link

feat: 🎸 updated prisma schema to include watched movies and eps #91

Closed RobinHeidenis closed 1 year ago

RobinHeidenis commented 1 year ago

✅ Closes: BUC-82

linear[bot] commented 1 year ago
BUC-82 Update prisma schema to add watched movies and shows to profiles

There should be relationships added to the user model: ``` user -> user_movie_watchedMovies <- movie user -> user_epsiode_watchedEpisodes <- episode ``` The `user_movie_watchedMovies` table is a table that connects the user and movie tables, with an extra property `watchedAt` to keep track of when exactly a movie has been watched. This should only store the date, and not the actual time. This is the same for the `user_episode_watchedEpisodes` table. For future code: the same logic for seeing if a season and show is all watched or not as is currently used can be used to check this for the watched page. If enough duplication occurs, extract this to a function to deduplicate.

vercel[bot] commented 1 year ago

The latest updates on your projects. Learn more about Vercel for Git ↗︎

Name Status Preview Comments Updated (UTC)
bucketlist ✅ Ready (Inspect) Visit Preview 💬 Add feedback Sep 18, 2023 3:39am