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