es4(2)

Tables (8)

actors (Untitled4)

  • videoCode (Key) — Primary key — NOT NULL
  • moviesgoldfinger (Field)
  • actorsinteralCode (Field2)
  • moviesTitle (Key2) — Foreign key → movies.moviesTitle — NOT NULL

biographyinformation (Untitled5)

  • videoCode (Key) — Primary key — NOT NULL
  • directorsinteralCode (Field)
  • actorinteralCode (Field2)
  • videoCode (Key2) — Foreign key → actors.videoCode — NOT NULL

customer (Untitled8)

  • customerNumber (Key) — Primary key — NOT NULL
  • name (Field)
  • address (Field2)

directors (Untitled6)

  • videoCode (Key) — Primary key — NOT NULL
  • moviesgoldfinger (Field)
  • directorsinteralCode (Field2)
  • videoCode (Key2) — Foreign key → biographyinformation.videoCode — NOT NULL
  • moviesTitle (Key3) — Foreign key → movies.moviesTitle — NOT NULL

movies (Untitled3)

  • moviesTitle (Key) — Primary key — NOT NULL
  • moviesyearmade (Field)
  • videoCode (Field2)

rentinformation (Untitled7)

  • videoCode (Key) — Primary key — NOT NULL
  • customerNumber (Field)
  • purchaseDate (Field2)
  • rentnumberTime (Field3)
  • videoCode (Key2) — Foreign key → video.videoCode — NOT NULL
  • customerNumber (Key3) — Foreign key → customer.customerNumber — NOT NULL

video (Untitled2)

  • videoCode (Key) — Primary key — NOT NULL
  • videostoreCode (Field)
  • videocopyCode (Field2)
  • customerNumber (Field3)
  • name (Field4)
  • adress (Field5)
  • videostoreCode (Key2) — Foreign key → videostore.videostoreCode — NOT NULL
  • moviesTitle (Key3) — Foreign key → movies.moviesTitle — NOT NULL

videostore (Untitled)

  • videostoreCode (Key) — Primary key — NOT NULL
  • movieTile (Field)