DVD_rental

Tables (9)

Actor (Untitled8)

  • actorCode (Key) — char(15) — Primary key — NOT NULL
  • biography (Field) — char(30)

CopyDVD (Untitled4)

  • copyCode (Key) — char(15) — Primary key — NOT NULL
  • amount (Field) — int(3)
  • condition (Field2) — char(10)
  • location (Field3) — char(10)

Customer (Untitled)

  • cusCode (Key) — char(15) — Primary key — NOT NULL
  • cusName (Field) — char(15)
  • cusAdr (Field2) — char(30)
  • numRental (Field3) — int(5)
  • overdueRecord (Field4) — char(30)
  • accumMoney (Field5) — int(10)
  • Phone (Field6) — char(12)

DVD (Untitled3)

  • dvdCode (Key) — char(15) — Primary key — NOT NULL
  • buyDate (Field) — date
  • numRent (Field2) — int(5)
  • location (Field3) — char(10)
  • Field4
  • copyCode (Key2) — char(15) — Foreign key → CopyDVD.copyCode — NOT NULL
  • movieCode (Key3) — char(15) — Foreign key → Movie.movieCode — NOT NULL
  • actorCode (Key22) — char(15) — Foreign key → Movie.actorCode — NOT NULL
  • directorCode (Key32) — char(15) — Foreign key → Movie.directorCode — NOT NULL

Director (Untitled9)

  • directorCode (Key) — char(15) — Primary key — NOT NULL
  • biography (Field) — char(30)

Movie (Untitled5)

  • movieCode (Key) — char(15) — Primary key — NOT NULL
  • actorCode (Key2) — char(15) — Foreign key → Movie_Actor.actorCode — NOT NULL
  • directorCode (Key3) — char(15) — Foreign key → Movie_Director.directorCode — NOT NULL
  • name (Field) — char(20)
  • year (Field2) — int(4)
  • genre (Field3) — char(10)

Movie_Actor (Untitled6)

  • actorCode (Key) — char(15) — Foreign key → Actor.actorCode — NOT NULL

Movie_Director (Untitled7)

  • directorCode (Key) — char(15) — Foreign key → Director.directorCode — NOT NULL

Rental (Untitled2)

  • rentCode (Key) — char(15) — Primary key — NOT NULL
  • date (Field) — date
  • time (Field2) — char(10)
  • returnDate (Field3) — date
  • fee (Field4) — int(5)
  • dvdCode (Key3) — char(15) — Foreign key → DVD.dvdCode — NOT NULL
  • cusCode (Key2) — char(15) — Foreign key → Customer.cusCode — NOT NULL
  • actorCode (Key22) — char(15) — Foreign key → DVD.actorCode — NOT NULL
  • directorCode (Key32) — char(15) — Foreign key → DVD.directorCode — NOT NULL