PJT-07

Tables (4)

movies_actor

  • PK (id) — Primary key — NOT NULL
  • name (Varchar(100))

movies_movie

  • PK (id) — Primary key — NOT NULL
  • title (Varchar(100))

movies_movie_actor

  • PK (id) — Primary key — NOT NULL
  • actor_id (integer(FK)) — Foreign key → movies_actor.PK — NOT NULL
  • movie_id (integer (FK)) — Foreign key → movies_movie.PK — NOT NULL

movies_review

  • PK (id) — Primary key — NOT NULL
  • movie_id (integer(FK)) — Foreign key → movies_movie.PK — NOT NULL
  • title (Varchar(100))
  • content (Text)