exercise4
Tables (7)
ACTOR & ACTRESS (Untitled5)
- code (Key2) — char(7) — Primary key — NOT NULL
- movieIdentifier (Key) — char(6) — Foreign key → MOVIE.identifier — NOT NULL
- biography (Field) — long text
CUSTOMER (Untitled)
- ID (Key) — char(10) — Primary key — NOT NULL
- name (Field) — char(10)
- address (Field2) — char(30)
DIRECTOR (Untitled6)
- code (Key) — char(7) — Primary key — NOT NULL
- biography (Field) — long text
DVD (Untitled2)
- ID (Key) — char(8) — Primary key — NOT NULL
- copyId (Field) — char(8)
- dateOfPurchase (Field2) — date
- timeOfRental (Field3) — int(3)
- identifier (Key2) — char(6) — Foreign key → MOVIE.identifier — NOT NULL
MOVIE (Untitled3)
- identifier (Key) — char(6) — Primary key — NOT NULL
- title (Field) — char(30)
- yearOfProduction (Field2) — int(4)
borrows (Untitled4)
- customerID (Key) — char(10) — Foreign key → CUSTOMER.ID — NOT NULL
- dvdID (Key2) — char(8) — Foreign key → DVD.ID — NOT NULL
- dateOfRental (Field) — date
- timeOfRental (Field2) — time
hasCodes (Untitled7)
- identifier (Key) — char(6) — Foreign key → MOVIE.identifier — NOT NULL
- Key (Key2) — Foreign key → DIRECTOR.code — NOT NULL