Final PJT - BoGuVie

Tables (9)

User

  • id — Primary key — NOT NULL
  • username
  • password
  • etc ...

community_Post (Post)

  • id — Primary key — NOT NULL
  • user_id — Foreign key → User.id — NOT NULL
  • title
  • content
  • created_at
  • updated_at

community_Post Comment (Post Comment)

  • id — Primary key — NOT NULL
  • post_id — Foreign key → community_Post.id — NOT NULL
  • user_id — Foreign key → User.id — NOT NULL
  • content
  • created_at
  • updated_at

community_Post Like Users (Post Like Users)

  • id — Primary key — NOT NULL
  • post_id — Foreign key → community_Post.id — NOT NULL
  • user_id — Foreign key → User.id — NOT NULL

movies_Genre (Genre)

  • id — Primary key — NOT NULL
  • name

movies_Movie (Movie)

  • id — Primary key — NOT NULL
  • title
  • adult
  • original_language
  • original_title
  • overview
  • popularity
  • poster_path
  • release_date
  • vote_average

movies_Movie Comment (Movie Comment)

  • id — Primary key — NOT NULL
  • movie_id — Foreign key → movies_Movie.id — NOT NULL
  • user_id — Foreign key → User.id — NOT NULL
  • comment
  • score
  • created_at
  • updated_at

movies_Movie Genre Ids (Movie Genre Ids)

  • id — Primary key — NOT NULL
  • movie_id — Foreign key → movies_Movie.id — NOT NULL
  • genre_id — Foreign key → movies_Genre.id — NOT NULL

movies_Movie Like Users (Movie Like users)

  • id — Primary key — NOT NULL
  • movie_id — Foreign key → movies_Movie.id — NOT NULL
  • user_id — Foreign key → User.id — NOT NULL