movie

Tables (14)

Actor (Untitled7)

  • actor_id (Key) — Primary key — NOT NULL
  • actor_name (Field)
  • actor_profile_path (Field2)
  • polularity (Field3)

Comment (Untitled5)

  • user_id (Key) — Foreign key → User.user_id — NOT NULL
  • user_id (Key2) — Foreign key → Review.user_id — NOT NULL
  • movie_id (Key22) — Foreign key → Review.movie_id — NOT NULL
  • content (Field)

Director (Untitled6)

  • director_id (Key) — Primary key — NOT NULL
  • director_name (Field)
  • popularity (Field2)
  • profile_path (Field3)

Genre (Untitled4)

  • genre_id (Key) — Primary key — NOT NULL
  • genre_name (Field)

Movie (Untitled)

  • movie_id (Key) — Primary key — NOT NULL
  • title (Field)
  • original_title (Field2)
  • overview (Field3)
  • release_date (Field4)
  • poster_path (Field5)
  • runtime (Field6)
  • popularity (Field7)
  • backdrop_path (Field8)
  • tagline (Field9)

Movie_Actor (M:M 중계 테이블 2)

  • id (Key) — Primary key — NOT NULL
  • movie_id (Key2) — Foreign key → Movie.movie_id — NOT NULL
  • actor_id (Key3) — Foreign key → Actor.actor_id — NOT NULL

Movie_Director (M:M 중계 테이블 3)

  • id (Key) — Primary key — NOT NULL
  • movie_id (Key2) — Foreign key → Movie.movie_id — NOT NULL
  • director_id (Key3) — Foreign key → Director.director_id — NOT NULL

Movie_Genre (M:M 중계 테이블)

  • id (Key) — Primary key — NOT NULL
  • movie_id (Key2) — Foreign key → Movie.movie_id — NOT NULL
  • genre_id (Key3) — Foreign key → Genre.genre_id — NOT NULL

Movie_Provider (M:M 중계 테이블 4)

  • id (Key) — Primary key — NOT NULL
  • movie_id (Key2) — Foreign key → Movie.movie_id — NOT NULL
  • provider_id (Key3) — Foreign key → Provider.provider_id — NOT NULL

Provider (Untitled10)

  • provider_id (Key) — Primary key — NOT NULL
  • provider_name (Field)
  • logo_path (Field2)

Rating (Untitled9)

  • rating_id (Key) — Primary key — NOT NULL
  • movie_id (Key2) — Foreign key → Movie.movie_id — NOT NULL
  • user_id (Key3) — Foreign key → User.user_id — NOT NULL
  • score (Field)

Review (Untitled3)

  • user_id (Key) — Foreign key → User.user_id — NOT NULL
  • movie_id (Key2) — Foreign key → Movie.movie_id — NOT NULL
  • content (Field)

User (Untitled2)

  • user_id (Key) — Primary key — NOT NULL
  • nickname (Field)

Video (Untitled8)

  • video_id (Key) — Primary key — NOT NULL
  • movie_id (Key2) — Foreign key → Movie.movie_id — NOT NULL
  • key (Field)