moviePJT

Tables (4)

forum_post (Comment)

  • Key (uid) — int — Primary key — NOT NULL — 덧글 번호
  • user_no (user) — int — Foreign key → user.user_no — NOT NULL
  • Key (movie_id) — int — Foreign key → user.Key — NOT NULL
  • user_no (user2) — int — Foreign key → user.user_no — NOT NULL
  • Key (movie_id2) — int — Foreign key → user.Key — NOT NULL
  • Field (content) — text
  • Field (created_at) — Datetime

forum_thread (Review)

  • Key (movie_id) — int — Foreign key → movie.Key — NOT NULL
  • user_no (user2) — int — Foreign key → movie.user_no — NOT NULL
  • Key (movie_id22) — int — Foreign key → movie.Key — NOT NULL
  • Field (title) — char
  • Field (content) — text
  • Field (rank) — float
  • Field (created_at) — Datetime
  • Field (updated_at) — Datetime
  • user_no (user) — int — Foreign key → user.user_no — NOT NULL
  • Key (movie_id2) — int — Foreign key → user.Key — NOT NULL

movie (Movie)

  • Key (movie_id) — int — Primary key — NOT NULL
  • user_no (user2) — int — Foreign key → user.user_no — NOT NULL
  • Key (movie_id2) — int — Foreign key → user.Key — NOT NULL
  • Field (title) — char
  • Field (release_date) — Date
  • Field (popularity) — float
  • Field (overview) — text
  • Field (poster_path) — char
  • Field (like_users) — int

user (accounts.User)

  • user_no (user) — int — Primary key — NOT NULL
  • Key (movie_id) — int — Foreign key → movie.Key — NOT NULL
  • user_no (user2) — int — Foreign key → movie.user_no — NOT NULL
  • Key (movie_id2) — int — Foreign key → movie.Key — NOT NULL
  • Field