Test

Tables (6)

Comment (Untitled7)

  • id (Key) — Integer — Primary key — NOT NULL
  • content (Field2)
  • created_at (Field3)
  • updated_at (Field4)
  • user (Key2) — 1:N — Foreign key → User.id — NOT NULL
  • community (Key3) — 1:N — Foreign key → Community.id — NOT NULL

Community (Untitled)

  • id (Key) — Integer — Primary key — NOT NULL
  • title (Field)
  • content (Field3)
  • rank (Field2)
  • created_at (Field4)
  • updated_at (Field5)
  • user (Key2) — 1:N — Foreign key → User.id — NOT NULL
  • movie (Key3) — 1:N — Foreign key → Movie.id — NOT NULL
  • find_users (Key4) — M:N — Foreign key → User.id — NOT NULL

Genre (Untitled3)

  • id (Key) — Primary key — NOT NULL
  • genre_name (Field2)

Movie (Untitled4)

  • id (Key) — Primary key — NOT NULL
  • title (Field)
  • poster_path (Field2)
  • overview (Field3)
  • release_date (Field4)
  • vote_average (Field5)
  • popularity (Field6)
  • id (Field7)
  • original_title (Field12)
  • adult (Field11)
  • vote_count (Field10)
  • genres (Key3) — M:N — Foreign key → Genre.id — NOT NULL
  • like_users (Key2) — M:N — Foreign key → User.id — NOT NULL

Review (Untitled6)

  • id (Key) — Integer — Primary key — NOT NULL
  • content (Field)
  • rank (Field2)
  • created_at (Field3)
  • updated_at (Field5)
  • user (Key2) — 1:N — Foreign key → User.id — NOT NULL
  • community (Key3) — 1:N — Foreign key → Community.id — NOT NULL

User (Untitled2)

  • id (Key) — Primary key — NOT NULL
  • username (Field)
  • mbti_partner (Field2)
  • mbti_keywords (Field3)