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