videoshop

Tables (7)

CASTING (Untitled8)

  • movieId (Key) — char(30) — Foreign key → MOVIE.movieId — NOT NULL
  • personId (Key3) — char(30) — Foreign key → PERSON.personId — NOT NULL
  • roleId (Key2) — char(30) — Foreign key → ROLE.roleId — NOT NULL

CUSTOMER (Untitled)

  • customerId (Key) — char(30) — Primary key — NOT NULL
  • name (Field) — char(30)
  • address (Field2) — char(30)

MOVIE (Untitled4)

  • movieId (Key) — char(30) — Primary key — NOT NULL
  • title (Field) — char(60)
  • year (Field2) — int(4)

PERSON (Untitled7)

  • personId (Key) — char(30) — Primary key — NOT NULL
  • birthdate (Field4) — int(8)
  • sex (Field) — char(6)
  • nationality (Field2) — char(30)
  • debutyear (Field3) — int(4)

ROLE (Untitled9)

  • roleId (Key) — char(30) — Primary key — NOT NULL

Transaction (Untitled3)

  • transactionId (Key) — char(30) — Primary key — NOT NULL
  • datetime (Field2) — int(12)
  • customerId (Key2) — char(30) — Foreign key → CUSTOMER.customerId — NOT NULL
  • videoCode (Key3) — char(30) — Foreign key → videocassette.videoCode — NOT NULL

videocassette (Untitled2)

  • videoCode (Key) — char(30) — Primary key — NOT NULL
  • purchaseDate (Field) — int(8)
  • rentTimes (Field2) — int(4)
  • movieId (Key2) — char(60) — Foreign key → MOVIE.movieId — NOT NULL