pjt

Tables (5)

accounts_user (Untitled)

  • user_id — int — Primary key — NOT NULL
  • username (사용자 이름) — varchar(50) — NOT NULL
  • password (비밀번호) — varchar(50) — NOT NULL

community_review (Untitled3)

  • review_id (PK) — int — Primary key — NOT NULL
  • movie_id (FK2) — int — Foreign key → movies_movie.movie_id — NOT NULL
  • user_id (FK) — int — Foreign key → movies_movie.user_id — NOT NULL
  • title (제목) — varcher(50)
  • content (내용) — text
  • created_date (작성일) — date
  • updated_date (수정일) — date
  • like_review_users (좋아요) — manyTomany

communuty_comment (Untitled4)

  • comment_id (PK) — int — Primary key — NOT NULL
  • user_id (FK22) — int — Foreign key → accounts_user.user_id — NOT NULL
  • review_id (FK2) — int — Foreign key → community_review.review_id — NOT NULL
  • movie_id (FK) — int — Foreign key → community_review.movie_id — NOT NULL
  • content (내용) — varchar(50)
  • created_date (작성일) — date
  • updated_date (수정일) — date
  • like_comment_users (좋아요) — manyTomany

movies_movie (Untitled2)

  • user_id (FK) — int — Primary key — NOT NULL
  • movie_id (PK) — int — Primary key — NOT NULL
  • title (제목) — varchar(50)
  • overview (줄거리) — varchar(50)
  • poster_path (포스터) — varchar(50)
  • released_date (개봉일) — date
  • genre (장르) — varchar(50)

rate (Untitled5)

  • movie_id (FK) — int — Foreign key → movies_movie.movie_id — NOT NULL
  • user_id (FK2) — int — Foreign key → movies_movie.user_id — NOT NULL
  • score (평점) — float