movie

Tables (8)

articles (Untitled5)

  • id (article_pk) — Primary key — NOT NULL
  • username (account_id) — Foreign key → users.username
  • title (제목)
  • content (내용)
  • created_at (생성일자)
  • updated_at (수정일자)
  • image (사진)
  • Field

articles_like_users (Untitled7)

  • username (user_id) — Foreign key → users.username
  • id (article_pk) — Foreign key → articles.id — NOT NULL

comments (Untitled4)

  • id (comment_id) — Primary key
  • username (account_id) — Foreign key → users.username
  • id (article_pk) — Foreign key → articles.id — NOT NULL
  • content (내용)
  • created_at (생성일자)
  • updated_at (수정일자)
  • Field

movies (Untitled2)

  • id (movie_id) — Primary key
  • poster_path (영화포스터)
  • adult (나이제한)
  • overview (줄거리)
  • release_date (개봉일)
  • genre_ids (장르)
  • original_title (원제)
  • original_language (원어)
  • title (제목)
  • popularity (인기)
  • vote_count (투표수)
  • vote_average (평점)
  • video_path (유튜브 api)
  • director (감독)
  • actors (배우)
  • Field

movies_like_users (Untitled8)

  • username (user_id) — Foreign key → users.username
  • id (movie_id) — Foreign key → movies.id

reviews (Untitled3)

  • id (review_pk) — Primary key — NOT NULL
  • username (account_id) — Foreign key → users.username
  • id (movie_id) — Foreign key → movies.id
  • content (내용)
  • score (별점)
  • created_at (생성일자)
  • updated_at (수정일자)
  • Field

reviews_like_users (Untitled6)

  • username (user_id) — Foreign key → users.username
  • id (review_pk) — Foreign key → reviews.id — NOT NULL

users (Untitled)

  • username (user_id) — Primary key
  • password (비밀번호)
  • favorate_genre (선호장르)
  • is_staff (관리자)
  • age (나이)
  • gender (성별)
  • Field