DBFLIX
테이블 (7)
리뷰 (Review)
- ReviewId (reviewId) — NotNull — 기본 키 — NOT NULL
- ReviewNum (reviewNum) — NotNull
- ReviewText (reviewText) — NotNull
- ReviewScore (reviewScore) — NotNull
- ReviewWriter (writer) — NotNull
- enterDate — NotNull
- MovieId (movieId) — NotNull — 외래 키 → 영화.MovieId — NOT NULL
사진 (Photo)
- FileId (file_id) — NotNull — 기본 키 — NOT NULL
- origFileName — NotNull
- FilePath (filePath) — NotNull
- FileSize (fileSize) — NotNull
- ReviewId (reviewId) — NotNull — 외래 키 → 리뷰.ReviewId — NOT NULL
수상 (award)
- AwardId (awardId) — NotNull — 기본 키 — NOT NULL
- AwardNum (awardNum) — NotNull
- AwardName (awardName) — NotNull
- AwardType (awardType) — NotNull
- Artist (artistId) — NotNull — 외래 키 → 영화인.MoviePersonId — NOT NULL
- MovieId (movieId) — NotNull — 외래 키 → 영화.MovieId — NOT NULL
- MovieNum (movieNum) — NotNull
영화 (movie)
- MovieId (movieId) — NotNull — 기본 키 — NOT NULL
- MovieNum (movieNum) — NotNull
- MovieTitle (title) — NotNull
- MovieView (view) — NotNull
- MovieProductionCost (productionCost) — NotNull
- MovieProductionCountry (productionCountry) — NotNull
- MovieGenre (genre) — NotNull
- DirectorId (directorId) — NotNull — 외래 키 → 제작사.DirectorId — NOT NULL
영화인 (artist)
- MoviePersonId (moviePersonId) — NotNull — 기본 키 — NOT NULL
- ArtistType (artistType) — NotNull
- ArtistName (artistName) — NotNull
- ArtistCountry (artistCountry) — NotNull
- ArtistSex (artistSex) — NotNull
- ActorRole (actorRole)
제작사 (director)
- DirectorId (id) — NotNull — 기본 키 — NOT NULL
- CompanyNum (companyNum) — NotNull
- CompanyName (companyName) — NotNull
- CompanyLocation (companyLocation) — NotNull