A database to track the user's favourite, watched and unwatched movies

Table movie {
movie_id integer [pk]
title text
genre text
platform text
created_at timestamp
updated_at timestamp
}

enum status {
watched
not_watched
added_to_favorite
}

Table user {
id integer [pk]
email text unique
status status
created_at timestamp
updated_at timestamp
}

Table user_movie {
id integer [pk]
user_id integer [ref: > user.id]
movie_id integer [ref: > movie.movie_id]
created_at timestamp
updated_at timestamp
}

Table user_favorite {
id integer [pk]
user_id integer [ref: > user.id]
movie_id integer [ref: > movie.movie_id]
created_at timestamp
updated_at timestamp
}

Table user_watched {
id integer [pk]
user_id integer [ref: > user.id]
movie_id integer [ref: > movie.movie_id]
created_at timestamp
updated_at timestamp
}

Table user_not_watched {
id integer [pk]
user_id integer [ref: > user.id]
movie_id integer [ref: > movie.movie_id]
created_at timestamp
updated_at timestamp
}