45

Tables (9)

casting (Untitled5)

  • movieid (Key) — int — Foreign key → movie.movieid — NOT NULL

customer (Untitled)

  • customerid (Key) — int — Primary key — NOT NULL
  • name (Field) — str(10)
  • address (Field2) — str(30)

customer (Untitled9)

  • customerid (Key) — int — Primary key — NOT NULL
  • name (Field) — str(10)
  • address (Field2) — text
  • phonenumber (Field3) — str(20)

dvd (Untitled2)

  • dvdid (Key) — int — Primary key — NOT NULL
  • purchasedate (Field) — date
  • rentalnumber (Field2) — int
  • movieid (Key2) — int — Foreign key → movie.movieid — NOT NULL

movie (Untitled4)

  • movieid (Key) — int — Primary key — NOT NULL
  • title (Field) — str(10)
  • productionyear (Field2) — str(10)
  • description (Field3) — longtext

purchase (Untitled10)

  • shoeid (Key) — int — Foreign key → shoes.shoeid — NOT NULL
  • customerid (Key2) — int — Foreign key → customer.customerid — NOT NULL
  • date (Field) — date
  • purchasenumber (Field2) — int

rental (Untitled3)

  • customerid (Key) — int — Foreign key → customer.customerid — NOT NULL
  • dvdid (Key2) — int — Foreign key → dvd.dvdid — NOT NULL
  • date (Field) — date
  • hour (Field2) — int

shoes (Untitled7)

  • shoeid (Key) — int — Primary key — NOT NULL
  • style (Field) — text
  • size (Field2) — int
  • color (Field3) — str(10)
  • suppliercode (Key2) — int — Foreign key → supplier.suppliercode — NOT NULL

supplier (Untitled8)

  • suppliercode (Key) — int — Primary key — NOT NULL