movie_wonit

Tables (7)

Company (배급사)

  • 배급사아이디 (company_id) — Primary key — NOT NULL
  • 배급사이름 (name)

Director (감독)

  • 감독아이디 (director_id) — Primary key — NOT NULL
  • 감독이름 (name)

Genre (영화장르)

  • 장르아이디 (genre_id) — Primary key — NOT NULL
  • 장르이름 (name)

Movie (영화)

  • 영화아이디 (movie_id) — Primary key — NOT NULL
  • 영화제목 (title)
  • 영화개봉일 (release_date)
  • 영화타입 (movie_type)
  • 영화제작국가 (country)
  • 누적관객수 (audience)
  • 상영된스크린수 (screens)
  • 관람가 (rating)
  • 수익 (revenue)

MovieCompany (영화배급사)

  • 영화배급사아이디 (movie_company_id) — Primary key — NOT NULL
  • 영화아이디 (movie_id) — Foreign key → Movie.영화아이디 — NOT NULL
  • 배급사아이디 (company_id) — Foreign key → Company.배급사아이디 — NOT NULL
  • 배급사역할 (role) — production,distributor,importer

MovieDirector (감독영화아이디)

  • 감독영화아이디 (movie_director_id) — Primary key — NOT NULL
  • 영화아이디 (movie_id) — Foreign key → Movie.영화아이디 — NOT NULL
  • 감독아이디 (director_id) — Foreign key → Director.감독아이디 — NOT NULL

movieGenre (Untitled6)

  • Key — Primary key — NOT NULL
  • 영화아이디 (movie_id) — Foreign key → Movie.영화아이디 — NOT NULL
  • 장르아이디 (genre_id) — Foreign key → Genre.장르아이디 — NOT NULL