Final_PJT

Tables (9)

Comment (리뷰 댓글)

  • id (Key) — integer — Primary key — NOT NULL
  • content (Field) — varchar(100)
  • created (Field2) — datetime
  • updated (Field3) — datetime
  • user_id (Key3) — integer — Foreign key → User.id — NOT NULL
  • review_id (Key2) — integer — Foreign key → Review.id — NOT NULL

Genre (장르)

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

Movie (영화)

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

Movie_Genre (영화/장르(M:N))

  • id (Key) — integer — Foreign key → Genre.id — NOT NULL
  • id (Key2) — integer — Foreign key → Movie.id — NOT NULL

OneLine (한줄평)

  • id (Key) — integer — Primary key — NOT NULL
  • title (Field1) — varchar(100)
  • movie_title (Field2) — varchar(50)
  • rank (Field3) — integer
  • content (Field4) — text
  • created_at (Field5) — datetime
  • updated_at (Field6) — datetime
  • user_id (Key2) — integer — Foreign key → User.id — NOT NULL
  • id (Key3) — integer — Foreign key → Movie.id — NOT NULL

Oneline_Like (한줄평 좋아요(M:N))

  • id (Key) — integer — Primary key — NOT NULL
  • user_id (Key2) — integer — Foreign key → User.id — NOT NULL
  • id (Key3) — integer — Foreign key → OneLine.id — NOT NULL

Review (영화 리뷰)

  • id (Key) — integer — Primary key — NOT NULL
  • title (Field1) — varchar(100)
  • movie_title (Field2) — varchar(50)
  • rank (Field3) — integer
  • content (Field4) — text
  • created_at (Field5) — datetime
  • updated_at (Field6) — datetime
  • user_id (Key2) — integer — Foreign key → User.id — NOT NULL
  • id (Key3) — integer — Foreign key → Movie.id — NOT NULL

Review_Like (리뷰 좋아요(M:N))

  • id (Key) — integer — Primary key — NOT NULL
  • review_id (Key3) — integer — Foreign key → Review.id — NOT NULL
  • user_id (Key2) — integer — Foreign key → User.id — NOT NULL

User (사용자)

  • id (Key) — integer — Primary key — NOT NULL
  • password (Field) — varchar(128)
  • username (Field2) — varchar(150)
  • email (Field3) — varchar(254)
  • is_staff (Field5) — bool
  • is_superuser (Field4) — bool
  • is_active (Field6) — bool
  • last_name (Field7) — varchar(150)
  • first_name (Field8) — varchar(150)
  • date_joined (Field9) — datetime
  • last_login (Field10) — datetime