PJT

Tables (3)

Comment (Untitled3)

  • PK (comment_pk) — INT — Primary key — NOT NULL
  • PK (user_pk) — INT — Foreign key → User.PK — NOT NULL
  • PK (movie_pk) — INT — Foreign key → Movie.PK — NOT NULL
  • Vote (comment_vote) — INT
  • Content (comment_content) — CHAR

Movie (Untitled2)

  • PK (movie_pk) — INT — Primary key — NOT NULL
  • Title (movie_title) — CHAR
  • Overview (movie_overview) — CHAR
  • ReleaseDate (movie_release_date) — DATE
  • VoteAverage (movie_vote_average) — FLOAT
  • PosterPath (movie_poster_path) — CHAR
  • PK (user_pk) — INT — Foreign key → User.PK — NOT NULL

User (Untitled)

  • PK (user_pk) — INT — Primary key — NOT NULL
  • UserName (user_name) — CHAR
  • UserEmail (user_email) — CHAR
  • Following (user_following) — LIST
  • Follower (user_follower) — LIST
  • UserId (user_id) — CHAR
  • UserPassword (user_password) — CHAR
  • Liked (user_liked) — LIST
  • Recent (user_recent) — LIST