erdtest

Tables (5)

Comment (review_comment)

  • Primary Key (id) — auto_increment — Primary key — NOT NULL
  • 작성자 (user_id) — int — Foreign key → User.Primary Key — NOT NULL
  • 리뷰 (review_id) — int — Foreign key → Review.Primary Key — NOT NULL
  • 내용 (content) — text
  • 작성시간 (created_at) — datetime
  • 수정시간 (updated_at) — datetime

Like (movies_movie_like_users)

  • 영화 (movie_id) — int — Foreign key → Movie.Primary Key — NOT NULL
  • 유저 (user_id) — int — Foreign key → User.Primary Key — NOT NULL

Movie (movies_movie)

  • Primary Key (id) — auto_increment — Primary key — NOT NULL
  • 장르ID (genre_ids) — char(50)
  • 영화ID (movie_id) — int
  • 줄거리 (overview) — text
  • 포스터 (poster_path) — char(500)
  • 개봉일 (release_date) — date
  • 영화제목 (title) — char(100)
  • 평점 (vote_average) — float

Review (review_review)

  • Primary Key (id) — auto_increment — Primary key — NOT NULL
  • 영화 (movie_id) — int — Foreign key → Movie.Primary Key — NOT NULL
  • 작성자 (user_id) — int — Foreign key → User.Primary Key — NOT NULL
  • 제목 (title) — char(100)
  • 내용 (content) — text
  • 평점 (score) — int
  • 작성시간 (created_at) — datetime
  • 수정시간 (updated_at) — datetime

User (accounts_user)

  • Primary Key (id) — auto_increment — Primary key — NOT NULL
  • 유저 (username) — char
  • 비밀번호 (password) — char