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