pjt_final

Tables (13)

Comment (댓글)

  • PK (comment_id) — Primary key — NOT NULL
  • FK (review_id) — Foreign key → review.FK — NOT NULL
  • FK (user_Id) — Foreign key → User.Key — NOT NULL
  • 내용 (content)
  • 작성시간 (created_at)
  • 수정시간 (updated_at)

Like (좋아요 관계테이블)

  • PK (id) — Primary key — NOT NULL
  • FK (user_id) — Foreign key → User.Key — NOT NULL
  • FK (review_id) — Foreign key → review.PK — NOT NULL

Movie (영화)

  • PK (movie_id) — Primary key — NOT NULL
  • 제목 (title)
  • 원제 (original_title)
  • 줄거리 (overview)
  • 배경포스터경로 (backdrop_path)
  • 포스터경로 (poster_path)
  • 예고편 경로 (trailer_path)
  • 개봉일자 (release_date)
  • 상영시간 (runtime)
  • 국가 (production_countries)
  • 나이 (adult)
  • 장르 (genre)
  • 출연/제작 (crew)
  • 키워드 (keyword)
  • 비슷한 영화 (similar_movies)
  • 보고싶어하는 유저 (like_users)
  • PK (id2) — Foreign key → Similarity.PK — NOT NULL

Similarity (영화 유사도)

  • PK (id) — Primary key — NOT NULL
  • FK (source) — Foreign key → Movie.PK — NOT NULL
  • FK (target)
  • 유사도 (similarity)

User (Untitled)

  • Key (id) — Primary key — NOT NULL
  • 사용자 이름 (username)
  • 비밀번호 (password)

WantToWatch

  • PK (id) — Primary key — NOT NULL
  • FK (user_id) — Foreign key → User.Key — NOT NULL
  • FK (movie_id) — Foreign key → Movie.PK — NOT NULL
  • 상태 (status)

cast (출연/제작)

  • Key (cast_id) — Primary key — NOT NULL
  • 이름 (name)
  • 역할 (role)
  • 프로필사진 (profile_path)

genre (장르)

  • Key (genre_id) — Primary key — NOT NULL
  • 이름 (name)

keyword (키워드)

  • PK (keyword_id) — Primary key — NOT NULL
  • 이름 (name)

movie_cast (출연/제작 관계테이블)

  • Key (id) — Primary key — NOT NULL
  • FK (cast_id) — Foreign key → cast.Key — NOT NULL
  • Fk (movie_id) — Foreign key → Movie.PK — NOT NULL

movie_genre (장르 관계테이블)

  • Key (id) — Primary key — NOT NULL
  • FK (movie_id) — Foreign key → Movie.PK — NOT NULL
  • FK (genre_id) — Foreign key → genre.Key — NOT NULL

movie_keyword (키워드 관계테이블)

  • PK (id) — Primary key — NOT NULL
  • FK (movie_id) — Foreign key → Movie.PK — NOT NULL
  • FK (keyword_id) — Foreign key → keyword.PK — NOT NULL

review (한줄평)

  • PK (review_id) — Primary key — NOT NULL
  • FK (movie_id) — Foreign key → Movie.PK — NOT NULL
  • FK (user_id) — Foreign key → User.Key — NOT NULL
  • 내용 (content)
  • 평점 (rating)
  • 작성시간 (created_at)
  • 수정시간 (updated_at)
  • 좋아요 누른 유저 (like_users)