movieapi

Tables (7)

accounts.User (Untitled4)

  • id (Key) — INTEGER — Primary key — NOT NULL
  • imageBase64 (Field) — IMAGE
  • male (Field2) — FLOAT
  • age (Field3) — FLOAT

community.CommunityComment (Untitled6)

  • community (Key2) — INTEGER — Primary key — NOT NULL
  • user (Key) — INTEGER — Foreign key → movies.Community.user — NOT NULL
  • content (Field) — CHAR
  • created_at (Field2) — DATETIME
  • updated_at (Field3) — DATETIME

movies.Comment (Untitled3)

  • id — INTEGER — Foreign key → movies.Review.id — NOT NULL — comment
  • review (id2) — INTEGER — Foreign key → movies.Review.movie — NOT NULL — comment
  • content (Field) — CHAR
  • created_at (Field2) — DATETIME
  • updated_at (Field3) — DATETIME

movies.Community (Untitled5)

  • user (Key) — INTEGER — Primary key — NOT NULL
  • id (Key2) — INTEGER — Foreign key → accounts.User.id — NOT NULL
  • title (Field2) — CHAR
  • content (Field3) — TEXT
  • created_at (Field4) — DATETIME
  • updated_at (Field5) — DATETIME

movies.Genre (Untitled)

  • id — INTEGER — Foreign key → movies.Movie.id — NOT NULL — comment
  • movie (id2) — CharField — Foreign key → movies.Movie.genres — NOT NULL — comment
  • name (Field) — CHAR

movies.Movie (comment)

  • id — INTEGER — Primary key — NOT NULL — comment
  • genres (id2) — CharField — Foreign key → movies.Genre.id — NOT NULL — comment
  • title (Field) — CharField — comment
  • release_date (Field2) — DATE — NOT NULL
  • popularity (Field3) — FLOAT
  • vote_count (Field4) — INTEGER
  • vote_average (Field5) — FLOAT
  • overview (Field6) — TEXT
  • poster_path (Field7) — CHAR

movies.Review (Untitled2)

  • id — INTEGER — Foreign key → movies.Movie.id — NOT NULL — comment
  • movie (id2) — INTEGER — Foreign key → movies.Movie.genres — NOT NULL — comment
  • content (Field) — TEXT
  • rank (Field2) — INTEGER