영화추천

테이블 (7)

Community_Comments (Untitled4)

  • id (PrimaryKey) — INT — 기본 키 — NOT NULL
  • user_id (ForeignKey) — INT — 외래 키 → User.user_id — NOT NULL
  • review_id (ForeignKey2) — INT — 외래 키 → Review.review_id — NOT NULL
  • content (Field) — TEXT

Genre (Untitled8)

  • genre_id (Primarykey) — INT — 기본 키 — NOT NULL
  • genre_name (Field) — VARCHAR

Movie (Untitled7)

  • movie_id (PrimaryKey) — INT — 기본 키 — NOT NULL
  • poster_path (Field) — TEXT
  • release_date (Field2) — DATE
  • language (Field3) — VARCHAR
  • vote_average (Field5) — FLOAT
  • over_view (Field6) — TEXT
  • popularity (Field7) — INT

Movie_Genre (Untitled9)

  • id (Primarykey) — INT — 기본 키 — NOT NULL
  • movie_id (ForeginKey) — INT — 외래 키 → Movie.movie_id — NOT NULL
  • genre_id (ForeginKey2) — INT — 외래 키 → Genre.genre_id — NOT NULL

Review (Untitled3)

  • review_id (PrimaryKey) — INT — 기본 키 — NOT NULL
  • user_id (ForeignKey) — INT — 외래 키 → User.user_id — NOT NULL
  • movie_id (ForeignKey2) — INT — 외래 키 → Movie.movie_id — NOT NULL
  • title (Field) — VARCHAR
  • rank (Field3) — FLOAT
  • content (Field4) — Text
  • created_at (Field5) — Date
  • updated_at (Field6) — Date

User (Untitled)

  • user_id (PrimaryKey) — INT — 기본 키 — NOT NULL
  • user_name (Field) — CHAR
  • password (Field2) — VARCHAR

User_Interest (Untitled2)

  • user_id (PrimaryKey) — INT — 외래 키 → User.user_id — NOT NULL
  • genre_id (ForeignKey) — INT — 외래 키 → Genre.genre_id — NOT NULL
  • count (Field) — INT
  • total (Field2) — FLOAT