FPJT1

Tables (4)

accounts_user (Untitled)

  • PK (id) — Integer — Primary key — NOT NULL
  • 이름 (username) — Char
  • 닉네임 (nickname) — Char
  • 이메일 (email) — Text
  • Field
  • 관리자유무 (is_superuser)
  • 가입일 (data_joined)
  • 비밀번호 (password)
  • 마지막접속일 (last_login)

movies_comment (Untitled2)

  • PK (id) — Primary key — NOT NULL
  • FK (movie_id) — Primary key — NOT NULL
  • FK (user_id) — Primary key — NOT NULL
  • 코멘트 (comment)

movies_movie (Untitled3)

  • PK (id) — Primary key — NOT NULL
  • FK (user_id) — Primary key — NOT NULL
  • 제목 (title)
  • 줄거리요약 (overview)
  • 개봉날짜 (release_date)
  • 장르 (genre)
  • 관객수 (popularity)
  • 평균평점 (vote_average)
  • 포스터url (poster_path)

movies_movie_like_users (Untitled4)

  • PK (id) — Primary key — NOT NULL
  • FK (movie_id) — Primary key — NOT NULL
  • FK (user_id) — Primary key — NOT NULL
  • PK (id2) — Integer — Foreign key → accounts_user.PK — NOT NULL
  • PK (id3) — Foreign key → movies_movie.PK — NOT NULL
  • FK (user_id2) — Foreign key → movies_movie.FK — NOT NULL