4

Tables (9)

DVD-COPY (DVD_COPY)

  • DVD-COPY_ID (DVD_COPY_ID) — INT — Primary key — NOT NULL
  • dvdID — INT — Foreign key → dvd.dvdID — NOT NULL

Movie-Director Link (Movie_Director Link)

  • movie_id — INT — Foreign key → movie.movie_id — NOT NULL
  • director_id — INT — Foreign key → director.director_id — NOT NULL

actor

  • actor_id — INT — Primary key — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • biography — TEXT

customer

  • customer_id — INT — Primary key — NOT NULL
  • name — char(50) — NOT NULL
  • address — char(50) — NOT NULL

director

  • director_id — INT — Primary key — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • biography — TEXT

dvd

  • dvdID — INT — Primary key — NOT NULL
  • purchase_date — DATE — NOT NULL
  • movie_id — INT — Foreign key → movie.movie_id — NOT NULL

movie

  • movie_id — INT — Primary key — NOT NULL
  • title — VARCHAR(50) — NOT NULL
  • year — INT — NOT NULL

movie-actor_Link (movie_actor_Link)

  • movie_id — INT — Foreign key → movie.movie_id — NOT NULL
  • actor_id — INT — Foreign key → actor.actor_id — NOT NULL

rental

  • rental_date — DATETIME — NOT NULL
  • rental_count — CHAR(50)
  • customer_id — INT — Foreign key → customer.customer_id — NOT NULL
  • DVD-COPY_ID (DVD_COPY_ID) — INT — Foreign key → DVD-COPY.DVD-COPY_ID — NOT NULL
  • dvdID — INT — Foreign key → DVD-COPY.dvdID — NOT NULL