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)