DBFLIX

테이블 (7)

Untitled

    리뷰 (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