영화추천사이트

테이블 (5)

Comment (Untitled3)

  • id (Key) — 기본 키 — NOT NULL
  • review (Key2) — 외래 키 → Review.id — NOT NULL
  • user (Key3) — 외래 키 → User.id — NOT NULL
  • content (Field)

Movie (Untitled4)

  • id (Key) — 기본 키 — NOT NULL
  • user (Key2) — 외래 키 → User.id — NOT NULL
  • title (Field)
  • genres (Field2)
  • original_title (Field3)
  • overview (Field4)
  • popularity (Field5)
  • production_companies (Field6)
  • poster_path (Field7)
  • release_date (Field8)
  • vote_average (Field9)
  • homepage (Field10)

Review (community)

  • id (Key) — 기본 키 — NOT NULL
  • user (Key2) — 외래 키 → User.id — NOT NULL
  • title (Field2)
  • movie_title (Field3)
  • rank (Field4)
  • created_at (Field5)
  • updated_at (Field6)
  • like_users (Field7)

User (Untitled)

  • id (Key) — 기본 키 — NOT NULL
  • username (Field)
  • password (Field2)
  • followers (Field3)

User_vote (Untitled5)

  • id (Key4) — 기본 키 — NOT NULL
  • movie (Key2) — 외래 키 → Movie.user — NOT NULL
  • user (Key3) — 외래 키 → User.id — NOT NULL
  • cnt (Field)
  • content (Field2)
  • created_at (Field3)
  • updated_at (Field4)