pjt

Tables (4)

Comment

  • Comment_id — Primary key — NOT NULL
  • Review_id — Foreign key → Review.Review_id — NOT NULL
  • User_id — Foreign key → User.User_id — NOT NULL
  • content
  • created_at
  • updated_at

Movie

  • Movie_id — Primary key — NOT NULL
  • title
  • poster
  • director

Review

  • Review_id — Primary key — NOT NULL
  • User_id — Foreign key → User.User_id — NOT NULL
  • Movie_id — Foreign key → Movie.Movie_id — NOT NULL
  • title
  • content
  • created_at
  • updated_at

User

  • User_id — Primary key — NOT NULL
  • User_pw
  • follower — Foreign key → User.User_id — NOT NULL
  • Username