ex4

Tables (8)

actor (Untitled)

  • actorid (Key) — char(10) — Primary key — NOT NULL
  • name (Field) — char(10)
  • birth (Field2) — date
  • gender (Field3) — char(5)
  • biography (Field4) — text

actor-movie (Untitled3)

  • actor-movieid (Key) — char(13) — Primary key — NOT NULL
  • actorid (Key2) — char(10) — Foreign key → actor.actorid — NOT NULL
  • movieid (Key3) — char(13) — Foreign key → movie.movieid — NOT NULL

customer (Untitled5)

  • customerid (Key) — char(13) — Primary key — NOT NULL
  • name (Field) — char(10)
  • phone (Field2) — char(11)
  • address (Field3) — text
  • birth (Field4) — date

dirctor (Untitled2)

  • directorid (Key) — char(13) — Primary key — NOT NULL
  • name (Field) — char(10)
  • birth (Field2) — date
  • gender (Field3) — char(5)
  • biography (Field4) — text

dirctor_movie (Untitled8)

  • dirctor_movieid (Key) — char(13) — Primary key — NOT NULL
  • directorid (Key2) — char(13) — Foreign key → dirctor.directorid — NOT NULL
  • movieid (Key3) — char(13) — Foreign key → movie.movieid — NOT NULL

dvd (Untitled7)

  • dvdid (Key) — char(13) — Primary key — NOT NULL
  • copynumber (Key3) — integer — Primary key — NOT NULL
  • movieid (Key2) — char(13) — Foreign key → movie.movieid — NOT NULL
  • purchase (Field) — date

movie (Untitled4)

  • movieid (Key) — char(13) — Primary key — NOT NULL
  • title (Field2) — char(20)
  • release (Field3) — date
  • discription (Field) — text

rental (Untitled6)

  • rentalid (Key) — char(13) — Primary key — NOT NULL
  • customerid (Key2) — char(13) — Foreign key → customer.customerid — NOT NULL
  • dvdid (Key3) — char(13) — Foreign key → dvd.dvdid — NOT NULL
  • copynumber (Key32) — integer — Foreign key → dvd.copynumber — NOT NULL
  • date (Field) — date
  • time (Field2) — time