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