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