movie_rater

Tables (3)

movies

  • id — INTEGER — Primary key — NOT NULL
  • name — VARCHAR(20)
  • director — VARCHAR(20)
  • release_global — DATE
  • release_kr — DATE
  • createdAt — DATETIME
  • updatedAt — DATETIME
  • poster — VARCHAR(100)

ratings

  • id — INTEGER — Primary key — NOT NULL
  • user_id — INTEGER — Foreign key → users.id — NOT NULL
  • movie_id — INTEGER — Foreign key → movies.id — NOT NULL
  • rating — INTEGER
  • comment — MEDIUMTEXT
  • createdAt — DATETIME
  • updatedAt — DATETIME

users

  • id — INTEGER — Primary key — NOT NULL
  • name — VARCHAR(20)
  • email — VARCHAR(40)
  • password — VARCHAR(100)
  • salt — VARCHAR(100)
  • createdAt — DATETIME
  • updatedAt — DATETIME
  • role — INTEGER