MovieProject

Tables (10)

Cast (Untitled6)

  • cast_id (PK) — int — Primary key — NOT NULL
  • name (배우이름) — char(100)
  • character (배역이름) — char(100)
  • movie_id (FK1) — int — Foreign key → Movie.movie_id — NOT NULL
  • person_id (FK2) — int — Foreign key → Person.person_id — NOT NULL

Coment (Untitled10)

  • comment_id (PK) — int — Primary key — NOT NULL
  • community_id (FK1) — Foreign key → Community.Key — NOT NULL
  • user_id (FK2) — int — Foreign key → User.user_id — NOT NULL
  • content (댓글) — Text

Community (Untitled9)

  • Key — Primary key — NOT NULL
  • title (Field)
  • content (Field2)
  • movie_id (FK1) — int — Foreign key → Movie.movie_id — NOT NULL
  • user_id (FK2) — int — Foreign key → User.user_id — NOT NULL

Crew (Untitled5)

  • crew_id (PK) — int — Primary key — NOT NULL
  • department (맡은 역할) — char(100)
  • movie_id (FK1) — int — Foreign key → Movie.movie_id — NOT NULL
  • person_id (FK2) — int — Foreign key → Person.person_id — NOT NULL

Emotion (Untitled3)

  • emotion_id (Key) — int — Primary key — NOT NULL
  • name (감정이름) — char(100)

Genre (Untitled2)

  • genre_id (PK) — int — Primary key — NOT NULL
  • name (장르이름) — char(100)
  • movie_id (FK1) — int — Foreign key → Movie.movie_id — NOT NULL
  • emotion_id (FK2) — int — Foreign key → Emotion.emotion_id — NOT NULL

Movie (Untitled)

  • movie_id (PK) — int — Primary key — NOT NULL
  • title (제목) — char(100)
  • original_title (원어 제목) — char(100)
  • release_date (개봉일) — Date
  • overview (줄거리요약) — Text
  • runtime (영화상영시간) — Time
  • popularity (인기지수) — float
  • vote_average (평균평점) — float
  • vote_count (평점 투표 수) — int
  • poster_path (포스터이미지경로) — char(200)
  • backdrop_path (배경이미지경로) — char(200)
  • budget (영화제작비용) — int
  • revenue (영화수익) — int
  • adult (성인영화여부) — bool
  • genre_id (FK1) — int — Foreign key → Genre.genre_id — NOT NULL
  • cast_id (FK2) — int — Foreign key → Cast.cast_id — NOT NULL
  • review_id (FK3) — int — Foreign key → Review.review_id — NOT NULL
  • crew_id (FK4) — int — Foreign key → Crew.crew_id — NOT NULL

Person (Untitled4)

  • person_id (PK) — int — Primary key — NOT NULL
  • name (이름) — char(100)
  • biography (인물전기) — Text
  • birthday (출생일) — Date
  • deathday (사망일(option)) — Date
  • profile_path (프로필이미지경로) — char(200)
  • crew_id (FK1) — int — Foreign key → Crew.crew_id — NOT NULL

Review (Untitled7)

  • review_id (PK) — int — Primary key — NOT NULL
  • content (리뷰내용) — Text
  • rating (평점) — float
  • create_review (리뷰작성일) — DateTime
  • user_id (FK1) — int — Foreign key → User.user_id — NOT NULL
  • movie_id (FK2) — int — Foreign key → Movie.movie_id — NOT NULL
  • emotion_id (FK3) — int — Foreign key → Emotion.emotion_id — NOT NULL

User (Untitled8)

  • user_id (PK) — int — Primary key — NOT NULL
  • user_email (이메일) — char(100)
  • user_password (패스워드) — char(100)
  • user_profile (유저이미지경로) — char(200)
  • user_intro (유저소개) — char(100)
  • review_id (FK1) — int — Foreign key → Review.review_id — NOT NULL
  • comment_id (FK2) — int — Foreign key → Coment.comment_id — NOT NULL
  • movie_id (ManyToMany) — int — Foreign key → Movie.movie_id — NOT NULL