movie pjt

Tables (16)

accounts_user (Untitled6)

  • id (Key) — integer — Primary key — NOT NULL
  • movie_id (Key2) — integer — Foreign key → movies_movie.id — NOT NULL
  • password (Field) — varchar(128)
  • username (Field2) — varchar(150)
  • email (Field3) — varchar(254)
  • last_name (Field4) — varchar(150)
  • first_name (Field5) — varchar(150)
  • date_joined (Field6) — datetime
  • last_login (Field7) — datetime

accounts_user (Untitled10)

  • Key (id) — integer — Primary key — NOT NULL
  • Field (password) — varchar
  • Field (username) — varchar
  • Field (first_name) — varchar
  • Field (last_name) — varchar
  • Field (email) — varchar

community_comment (게시글 댓글)

  • id (Key4) — integer — Primary key — NOT NULL
  • review_id (Key) — integer — Foreign key → community_post.user_id — NOT NULL
  • user_id (Key3) — integer — Foreign key → accounts_user.id — NOT NULL
  • content (Field4) — text
  • created_at (Field5) — datetime
  • updated_at (Field6) — datetime

community_comment (Untitled12)

  • Key (id) — integer — Primary key — NOT NULL
  • Key (post_id) — integer — Foreign key → community_post.Key — NOT NULL
  • Key (user_id) — integer — Foreign key → accounts_user.Key — NOT NULL
  • Field (content) — text
  • Field (created_at) — datetime
  • Field (updated_at) — datetime

community_post (게시글)

  • id (Key2) — integer — Primary key — NOT NULL
  • user_id (Key) — integer — Foreign key → accounts_user.id — NOT NULL
  • title (Field)
  • content (Field2)
  • created_ate (Field3)
  • updated_at (Field4)

community_post (Untitled13)

  • Key (id) — integer — Primary key — NOT NULL
  • Key (user_id) — integer — Foreign key → accounts_user.Key — NOT NULL
  • Field (title) — varchar
  • Field (content) — text
  • Field (created_at) — datetime
  • Field (updated_at) — datetime

movie_comment (영화 댓글)

  • id (Key) — Primary key — NOT NULL
  • movie_id (영화id) — integer — Foreign key → movies_movie.id — NOT NULL
  • user_id (유저id) — integer — Foreign key → accounts_user.id — NOT NULL
  • rank (평점) — integer
  • content (내용) — char
  • created_at (생성시간) — datetime
  • updated_at (수정시간) — datetime

movies.movie (Untitled4)

  • Key (id) — integer — Primary key — NOT NULL
  • Field (title) — text
  • Field (original_title) — text
  • Field (overview) — text
  • Field (poster_path) — text
  • Field (vote_average) — real
  • Field (vote_count) — integer
  • Field (release_date) — text
  • Field (runtime) — integer
  • Field (popularity) — real
  • Field (adult) — bool

movies_genre (Untitled2)

  • id (Key) — integer — Primary key — NOT NULL
  • name (Field) — varchar(50)

movies_genre (Untitled5)

  • Key (id) — integer — Primary key — NOT NULL
  • Field (name) — text

movies_movie (Untitled)

  • id (Key) — integer — Primary key — NOT NULL
  • poster_path (Field) — varchar(200)
  • audlt (Field2) — bool
  • overview (Field3) — text
  • release_date (Field4) — date
  • original_title (Field5) — varchar(100)
  • original_language (Field6) — varchar(100)
  • title (Field7) — varchar(100)
  • popularity (Field8) — real
  • vote_count (Field9) — integer
  • vote_average (Field10) — real

movies_movie_genre_ids (Untitled3)

  • id (Key) — integer — Primary key — NOT NULL
  • id (Key2) — integer — Foreign key → movies_movie.id — NOT NULL
  • id (Key3) — integer — Foreign key → movies_genre.id — NOT NULL

movies_movie_genres (Untitled7)

  • Key (id) — integer — Primary key — NOT NULL
  • Key (movie_id) — integer — Foreign key → movies.movie.Key — NOT NULL
  • Key (genre_id) — integer — Foreign key → movies_genre.Key — NOT NULL

movies_movie_like_users (Untitled11)

  • Key (id) — integer — Primary key — NOT NULL
  • Key (movie_id) — bigint — Foreign key → movies.movie.Key — NOT NULL
  • Key (user_id) — bigint — Foreign key → accounts_user.Key — NOT NULL

movies_review (Untitled8)

  • Key (id) — integer — Primary key — NOT NULL
  • Key (movie_id) — integer — Foreign key → movies.movie.Key — NOT NULL
  • Key (id2) — integer — Foreign key → accounts_user.Key — NOT NULL
  • Field (title) — varchar
  • Field (content) — text
  • Field (rank) — integer
  • Field (created_at) — datetime
  • Field (updated_at) — datetime

movies_reviewcomment (Untitled9)

  • Key (id) — integer — Primary key — NOT NULL
  • Key (review_id) — bigint — Foreign key → movies_review.Key — NOT NULL
  • Key (user_id) — integer — Foreign key → accounts_user.Key — NOT NULL
  • Key (id2) — integer — Foreign key → movies_review.Key — NOT NULL
  • Field (content) — text
  • Field (rank) — integer
  • Field (created_at) — datetime
  • Field (updated_at) — datetime