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