mission_TMDB

Tables (6)

Untitled3

    movie (Untitled)

    • movie_id (id) — Primary key — NOT NULL
    • title — 영화제목
    • poster_path — 포스터링크
    • status — 개봉여부
    • genre — 장르
    • overview — 영화설명
    • budget — 영화예산
    • production_country (Field) — 배급국가
    • production_company (Field2) — 배급사
    • vote_average — 투표평균값
    • vote_count — 투표횟수

    movie_trailer (Untitled4)

    • id (movie_id) — Foreign key → movie.movie_id — NOT NULL
    • trailer_title — String
    • trailer_url — String(url)
    • trailer_overview — String

    platform (movie_category)

    • id (movie_id) — Foreign key → movie.movie_id — NOT NULL
    • paltform (platform) — 플랫폼타입

    trend (movie_trends(view))

    • trend_id (id) — Primary key — NOT NULL
    • movie_id — Foreign key → movie.movie_id — NOT NULL
    • created_date — 생성날짜

    vote (Untitled2)

    • Key — Primary key — NOT NULL
    • movie_id (id) — Foreign key → movie.movie_id — NOT NULL
    • created_date (createDate)
    • vote_score (voteScore)