microl44 / Julet

Website visualizing data from my watched movies, brought forward by the jul.
3 stars 1 forks source link

Create database tables for user groups #125

Closed microl44 closed 1 month ago

microl44 commented 1 month ago

The users should be able to create movie watcher groups, sort of like a digital "movie club".

To start development of this feature the database structure must be able to support it.

I suggest:

Adding a movie_group table, with id, name, description

Adding a group_member table that connects users to groups. Should contain date of joining, rank and status.

Adding a group_movie_seen table with group id & group member as - key, date of viewing, rating, and review/comment.

See if it's possible for a group to set a deadline on when a movie should've been seen, preferably without adding it to the group table.

microl44 commented 1 month ago

Fixed as of pull request #127