Movie_pjt

Tables (11)

Comment (movies_comment)

  • id — PK — Primary key — NOT NULL
  • user_id — FK — Foreign key → User.id — NOT NULL
  • review_id — FK — Foreign key → Review.id — NOT NULL
  • movie_id — FK — Foreign key → Review.movie_id — NOT NULL
  • content (내용)
  • created_at (생성시간)
  • updated_at (수정시간)

Genre (movies_genre)

  • id — PK — Primary key — NOT NULL
  • name (장르 이름)

Movie (movies_movie)

  • id — PK — Primary key — NOT NULL
  • title (제목)
  • original_title (개봉 제목)
  • overview (요약)
  • release_date (개봉일)
  • popularity (관람객 수)
  • vote_count (득표 수)
  • vote_average (평점)
  • adult (19금)
  • poster_path (포스터)
  • backdrop_path (배경이미지)

Movielist (movies_movielist)

  • id — PK — Primary key — NOT NULL
  • genre (장르)
  • vote_average (평점)

Review (movies_review)

  • id — PK — Primary key — NOT NULL
  • movie_id — FK — Foreign key → Movie.id — NOT NULL
  • user_id — FK — Foreign key → User.id — NOT NULL
  • title (제목)
  • content (내용)
  • rank (요약)
  • created_at (생성시간)
  • updated_at (수정시간)

User (accounts)

  • id — PK — Primary key — NOT NULL
  • username (이름)
  • password (비밀번호)

User (user_accounts)

  • id — PK — Primary key — NOT NULL
  • username (이름)
  • password (비밀번호)

follow (accounts_user)

  • id — PK — Primary key — NOT NULL
  • from_user_id (보낸이) — FK — Foreign key → User.id — NOT NULL
  • to_user_id (보내는이) — FK — Foreign key → User.id — NOT NULL

movie_genres (movie<->genre)

  • id — PK — Primary key — NOT NULL
  • genre_id — FK — Foreign key → Genre.id — NOT NULL
  • movie_id — FK — Foreign key → Movie.id — NOT NULL

users_like (movie_users_like)

  • id — PK — Primary key — NOT NULL
  • movie_id — FK — Foreign key → Movie.id — NOT NULL
  • user_id — FK — Foreign key → User.id — NOT NULL

users_like (review_user_like)

  • id — PK — Primary key — NOT NULL
  • review_id — FK — Foreign key → User.id — NOT NULL
  • user_id — FK — Foreign key → Review.id — NOT NULL