`12

Tables (3)

MOVIE

  • Movie_ID — INT — Primary key
  • Title — VARCHAR(255) — NOT NULL
  • Rating — DECIMAL(2, 1)
  • Description — TEXT

REVIEW

  • UID (UID2) — VARCHAR(50) — Foreign key → USER.UID
  • Movie_ID (Movie_ID2) — INT — Foreign key → MOVIE.Movie_ID
  • Review_ID — INT
  • Comment — TEXT — EX
  • Rating — DECIMAL(2, 1)
  • Created_At — TIMESTAMP

USER

  • UID — VARCHAR(50) — Primary key
  • Email — VARCHAR(100) — NOT NULL
  • Mbti — VARCHAR(10)
  • Nickname — VARCHAR(50)