Final PJT

Tables (8)

Comment (댓글)

  • user (Key3) — Foreign key → User.id — NOT NULL
  • review (Key22) — Foreign key → Review.user — NOT NULL
  • content (Field2) — Text
  • created_at (Field3) — Date
  • updated_at (Field4) — Date

Genre (장르)

  • id (Key) — Primary key — NOT NULL
  • name (Field) — Char

Movie (영화)

  • id (Key) — Primary key — NOT NULL
  • popularity (Field) — Float
  • vote_count (Field2) — Int
  • video (Field3) — Bool
  • adult (Field4) — Bool
  • poster_path (Field5) — Char
  • backdrop_path (Field6) — Char
  • original_language (Field7) — Char
  • title (Field8) — Char
  • vote_average (Field9) — Float
  • overview (Field10) — Text
  • release_date (Field11) — Date

Review (영화 리뷰)

  • user (Key2) — Foreign key → User.id — NOT NULL
  • title (Field) — Char
  • movie_title (Field2) — Char
  • rank (Field3) — Int
  • content (Field4) — Text
  • created_at (Field5) — Date
  • updated_at (Field6) — Date

User (사용자)

  • id (Key) — Primary key — NOT NULL
  • age (Field) — Int
  • gender (Field2) — Char

followers (팔로우)

  • user (Key) — Foreign key → User.id — NOT NULL

genre_ids (장르-영화)

  • movie (key) — Foreign key → Movie.id — NOT NULL
  • genre (key2) — Foreign key → Genre.id — NOT NULL

like_users (좋아요)

  • movie (Key) — Foreign key → Movie.id — NOT NULL
  • user (Key2) — Foreign key → User.id — NOT NULL