ssafy project
Tables (13)
Followings (accounts_user_followings)
- id (User_id) — NOT NULL — Foreign key → User.id — NOT NULL
- from_user_id (Followings_from_user_id) — NOT NULL — NOT NULL
- to_user_id (Followings_to_user_id) — NOT NULL — NOT NULL
Movie (movies_movie)
- id (Movie_id) — NOT NULL — Primary key — NOT NULL
- title (Movie_title) — NOT NULL
- released_date (Movie_released_date) — NOT NULL
- poster_url (Movie_poster_url) — NOT NULL — NOT NULL
- overview (Movie_overview) — NOT NULL
- vote_average (Movie_vote_average) — NOT NULL
Movie_Like (movies_like)
- id (Movie_id) — NOT NULL — Foreign key → Movie.id — NOT NULL
- id (User_id) — NOT NULL — Foreign key → User.id — NOT NULL
Movie_dislike (movies_dislike)
- id (Movie_id) — NOT NULL — Foreign key → Movie.id — NOT NULL
- id (User_id) — NOT NULL — Foreign key → User.id — NOT NULL
Movie_genre (movies_movie_genres)
- id (Movie_id) — NOT NULL — Foreign key → Movie.id — NOT NULL
- name (genre_name) — NOT NULL — Foreign key → genre.name — NOT NULL
ReReview (rereview_rereview)
- id (Rereview_id) — NOT NULL — Primary key — NOT NULL
- id (review_id) — NOT NULL — Foreign key → Review.id — NOT NULL
- id (User_id) — NOT NULL — Foreign key → Review.id — NOT NULL
- id (Movie_id) — NOT NULL — Foreign key → Review.id — NOT NULL
- content (Rereview_content) — NOT NULL
ReReview_dislike (rereview_dislike)
- id (Rereview_id) — NOT NULL — Foreign key → ReReview.id — NOT NULL
- id (review_id2) — NOT NULL — Foreign key → ReReview.id — NOT NULL
- id (User_id) — NOT NULL — Foreign key → ReReview.id — NOT NULL
- id (Movie_id) — NOT NULL — Foreign key → ReReview.id — NOT NULL
- id (User_id2) — NOT NULL — Foreign key → User.id — NOT NULL
ReReview_like (rereview_like)
- id (Rereview_id) — NOT NULL — Foreign key → ReReview.id — NOT NULL
- id (review_id2) — NOT NULL — Foreign key → ReReview.id — NOT NULL
- id (User_id) — NOT NULL — Foreign key → ReReview.id — NOT NULL
- id (Movie_id) — NOT NULL — Foreign key → ReReview.id — NOT NULL
- id (User_id2) — NOT NULL — Foreign key → User.id — NOT NULL
Review (review_review)
- id (review_id) — NOT NULL — Primary key — NOT NULL
- id (User_id) — NOT NULL — Foreign key → User.id — NOT NULL
- id (Movie_id) — NOT NULL — Foreign key → Movie.id — NOT NULL
- content (review_title) — NOT NULL
- created_At (review_created_at) — NOT NULL — NOT NULL
- updated_at (review_updated_at) — NOT NULL
Review_dislike (review_dislike)
- id (User_id) — NOT NULL — Foreign key → User.id — NOT NULL
- id (review_id) — NOT NULL — Foreign key → Review.id — NOT NULL
Review_like (review_like)
- id (User_id) — NOT NULL — Foreign key → User.id — NOT NULL
- id (review_id) — NOT NULL — Foreign key → Review.id — NOT NULL
User (accounts_user)
- id (User_id) — NOT NULL — Primary key — NOT NULL
- password (User_password) — NOT NULL — NOT NULL
- last_login (User_last_login) — NOT NULL — NOT NULL
- is_superuser (User_is_superuser) — NOT NULL — NOT NULL
- username (User_username) — NOT NULL — NOT NULL
- first_name (User.first_name) — NOT NULL — NOT NULL
- last_name (User_last_name) — NOT NULL — NOT NULL
- email (User_email) — NOT NULL
- is_staff (User_is_staff) — NOT NULL — NOT NULL
- is_active (User_is_active) — NOT NULL — NOT NULL
genre (movies_genre)
- name (genre_name) — NOT NULL — Primary key — NOT NULL
- id (genre_id) — NOT NULL — NOT NULL