v11.17.01

Tables (6)

Article (articles_article)

  • Key (article_id) — integer — Primary key — NOT NULL
  • movie_id — integer — Foreign key → Movie.Key — NOT NULL
  • user_id — integer — Foreign key → User.Key — NOT NULL
  • 리뷰제목 (title) — varchar(100)
  • 리뷰상세 (content) — text
  • 작성일 (created_at) — datetime
  • 수정일 (updated_at) — datetime

Genre (movies_genre)

  • Key (genre_id) — integer — Primary key — NOT NULL
  • 장르 (name) — varchar(50)

Movie (movies_movie)

  • Key (movie_id) — integer — Primary key — NOT NULL
  • 영화제목 (title) — varchar(100)
  • 개봉일 (released_date) — datetime
  • 인기도 (popularity) — float
  • 평점 (vote_avg) — float
  • 줄거리 (overview) — text
  • 포스터 (poster_path) — text
  • 장르 (genres) — json
  • 감독 (director) — varchar(50)
  • 주/조연 (actors) — json

Movie_genre (Untitled)

  • Key (id) — integer — Primary key — NOT NULL
  • Key (movie_id) — integer — Foreign key → Movie.Key — NOT NULL
  • Key (genre_id) — integer — Foreign key → Genre.Key — NOT NULL

Movie_info (Untitled2)

  • Key (user_id) — integer — Foreign key → User.Key — NOT NULL
  • Key (movie_id) — integer — Foreign key → Movie.Key — NOT NULL
  • 정보 (info) — integer

User (accounts_user)

  • Key (user_id) — integer — Primary key — NOT NULL
  • 비밀번호 (password)
  • ID (username) — varchar(150)
  • 별명 (nickname) — varchar(20)
  • 관리자계정 (is_superuser) — boolean