Filmwave
Tables (12)
Comment (.)
- id — integer — Primary key — NOT NULL
- post_id — integer — Foreign key → Post.post_id — NOT NULL
- user_id — integer — Foreign key → Post.user_id — NOT NULL
- content — text — NOT NULL
- created_at (Field) — datetime
- updated_at (Field2) — datetime
Genre (Untitled6)
- genre_id — integer — Primary key — NOT NULL
- name — text — NOT NULL
Group (Untitled3)
- group_id — integer — Primary key — NOT NULL
- title — varchar(200) — NOT NULL
- overview — text — NOT NULL
- image — text
- created_at — datetime — NOT NULL
- updated_at — datetime — NOT NULL
Membership (Untitled2)
- membership_id — integer — Primary key — NOT NULL
- group_id — integer — Foreign key → Group.group_id — NOT NULL
- user_id — integer — Foreign key → User.user_id — NOT NULL
- role — varchar(20) — NOT NULL
- date_joined — datetime — NOT NULL
MembershipRequest (Untitled8)
- membership_request_id — integer — Primary key — NOT NULL
- user_id — integer — Foreign key → User.user_id — NOT NULL
- group_id — integer — Foreign key → Group.group_id — NOT NULL
- status — varchar(20) — NOT NULL
- date_requested — datetime — NOT NULL
- date_updated — datetime — NOT NULL
Movie (gd)
- movie_id — integer — Primary key — NOT NULL
- title — text — NOT NULL
- overview — text
- popularity — real
- vote_average — real
- backdrop_path — text
- poster_path — text
- release_data — date
- adult — bool
- title_embedding (Field) — text
- genre_embedding (Field2) — text
Movie_Genres (Untitled7)
- movie_id — integer — Foreign key → Movie.movie_id — NOT NULL
- genre_id — integer — Foreign key → Genre.genre_id — NOT NULL
Movie_like_users (Untitled12)
- user_id — integer — Foreign key → User.user_id — NOT NULL
- movie_id — integer — Foreign key → Movie.movie_id — NOT NULL
Post (Untitled9)
- post_id — integer — Primary key — NOT NULL
- user_id — integer — Foreign key → User.user_id — NOT NULL
- group_id — integer — Foreign key → Group.group_id — NOT NULL
- content — text — NOT NULL
- title — varchar(100) — NOT NULL
- created_at — datetime — NOT NULL
- updated_at — datetime — NOT NULL
Review (Untitled5)
- review_id — integer — Primary key — NOT NULL
- movie_id — integer — Foreign key → Movie.movie_id — NOT NULL
- user_id — integer — Foreign key → User.user_id — NOT NULL
- content — text — NOT NULL
- score (rate) — real — NOT NULL
- created_at — datetime — NOT NULL
- updated_at — datetime — NOT NULL
User (Untitled)
- user_id — integer — Primary key — NOT NULL
- username — text — NOT NULL
- password — text — NOT NULL
- email — text
- first_name — text
- last_name — text
UserPreference (Untitled10)
- user_preference_id — integer — Primary key — NOT NULL
- user_id — integer — Foreign key → User.user_id — NOT NULL
- embedding — text