mrs

Tables (3)

movie (Untitled2)

  • title (Field) — Primary key
  • director (Field3) — Primary key
  • category (Field2)
  • actor (Field4)
  • country (Field5)
  • runtime (Field6)
  • synopsis (Field7)
  • review_count (Field9)
  • release_date (Field11)
  • poster_url (Field12)
  • trailer_url (Field13)
  • id (Key) — NOT NULL
  • avrage_rating (Key2) — Foreign key → review.id — NOT NULL

review (Untitled3)

  • id (Key) — Primary key — NOT NULL
  • review_title (Field2)
  • description (Field3)
  • rating (Field4)
  • date (Field5)
  • user_id (Field) — Foreign key → user.user_id
  • movie_title (Field6) — Foreign key → movie.title
  • director (Field32) — Foreign key → movie.director

user (Untitled)

  • user_id (Field) — Primary key
  • id (Key) — NOT NULL
  • user_email (Field2)
  • user_name (Field3)
  • user_password (Field4)