movie-project

Tables (11)

Comment (Untitled5)

  • Key — Primary key — NOT NULL
  • Key (Key2) — Foreign key → Post.Key — NOT NULL
  • Key (Key22) — Foreign key → Post.Key — NOT NULL
  • Key (Key3) — Foreign key → Post.Key — NOT NULL
  • comment_id (pk)
  • post_id (fk)
  • user_id (Field3) — User
  • content (Field4)
  • created_at (Field5)

Follow (Untitled7)

  • Key — Primary key — NOT NULL
  • Key (Key2) — Foreign key → User.Key — NOT NULL
  • follow_id (pk)
  • follower_id (fk)
  • followed_id (Field3) — Movie

Like (Untitled6)

  • Key — Primary key — NOT NULL
  • Key (Key2) — Foreign key → User.Key — NOT NULL
  • like_id (pk)
  • user_id (fk)
  • post_id (Field3) — Post

Movie-detail (Untitled2)

  • Key — Primary key — NOT NULL
  • movie_id (pk)
  • title (Field2)
  • release_date (Field3)
  • director (Field4)
  • genre (Field5)
  • poster_image (Field)

Movies (Untitled9)

  • Key — Primary key — NOT NULL
  • Key (Key2) — Foreign key → Movie-detail.Key — NOT NULL
  • movie_id (pk)
  • title (Field3)
  • image (Field4)

Post (Untitled4)

  • Key — Primary key — NOT NULL
  • Key (Key2) — Foreign key → User.Key — NOT NULL
  • Key (Key3) — Foreign key → Movie-detail.Key — NOT NULL
  • post_id (pk)
  • user_id (fk)
  • movie_id (Field3) — Movie
  • content (Field4)
  • image (Field5)
  • updated_at (Field)
  • created_at (Field2)

Profile (Untitled8)

  • Key — Primary key — NOT NULL
  • Key (Key2) — Foreign key → User.Key — NOT NULL
  • profile_id (pk)
  • user_id (fk)
  • profile_content (Field3)
  • profile_picture (Field4)
  • updated_at (Field)
  • created_at (Field2)

User (Untitled)

  • Key — Primary key — NOT NULL
  • user_id (pk)
  • email (Field2)
  • password (Field3)
  • name (Field4)
  • profile_picture (Field5)
  • created_at (Field)

location (Untitled3)

  • Key — Primary key — NOT NULL
  • Key (Key2) — Foreign key → Movie-detail.Key — NOT NULL
  • location_id (pk)
  • movie_id (FK)
  • name (Field3)
  • description (Field4)
  • location (Field5)
  • image (Field6)

post-tag (Untitled11)

  • Key — Primary key — NOT NULL
  • Key (Key2) — Foreign key → Post.Key — NOT NULL
  • Key (Key22) — Foreign key → Post.Key — NOT NULL
  • Key (Key3) — Foreign key → Post.Key — NOT NULL
  • post_id (fk)
  • tag_id (f) — Tag

tag (Untitled10)

  • Key — Primary key — NOT NULL
  • Key (Key2) — Foreign key → post-tag.Key — NOT NULL
  • Key (Key22) — Foreign key → post-tag.Key — NOT NULL
  • Key (Key222) — Foreign key → post-tag.Key — NOT NULL
  • Key (Key3) — Foreign key → post-tag.Key — NOT NULL
  • tag_id (pk)
  • location_id (fk)
  • created_at (Field3)