movie

Tables (7)

Follow (Untitled6)

  • Field (follower_id) — INT (FK)
  • Field2 (followee_id) — INT (FK)
  • Field3 (created_at) — TIMESTAMP

Movie (Untitled)

  • Field (movie_id) — INT(PK)
  • Field2 (title) — VARCHAR(255)
  • Field3 (poster_url) — VARCHAR(255)
  • Field4 (release_date) — DATE
  • Field5 (director) — VARCHAR(255)
  • Field6 (synopsis) — TEXT

Post (Untitled3)

  • Field (post_id) — INT (PK)
  • Field2 (user_id) — INT (FK)
  • Field3 (movie_id) — INT (FK)
  • Field4 (region_id) — INT (FK)
  • Field5 (content) — TEXT
  • Field6 (created_at) — TIMESTAMP

Region (Untitled2)

  • Field (region_id) — INT (PK)
  • Field2 (name) — VARCHAR(255)
  • Field3 (country) — VARCHAR(255)
  • Field4 (latitude) — DECIMAL(9,6)
  • Field5 (longitude) — DECIMAL(9,6)

Untitled7

  • Field (movie_id) — INT (FK)
  • Field2 (region_id) — INT (FK)
  • Field

User (Untitled4)

  • Field (user_id) — INT (PK)
  • Field2 (username) — VARCHAR(255)
  • Field3 (email) — VARCHAR(255)
  • Field4 (password) — VARCHAR(255)

UserProfile (Untitled5)

  • Field (user_id) — INT (FK)
  • Field2 (profile_picture_url) — VARCHAR(255)
  • Field3 (bio) — TEXT
  • Field4 (website) — VARCHAR(255)
  • Field5 (location) — VARCHAR(255)