exercise4
Tables (8)
ACTOR (Untitled4)
- actorCODE (Key) — char(10) — Primary key — NOT NULL
- biography (Field) — text
CUSTOMER (Untitled)
- customerID (Key) — char(10) — Primary key — NOT NULL
- name (Field) — char(20)
- address (Field2) — char(30)
CopyDvd (Untitled7)
- copyID (Key) — char(10) — Primary key — NOT NULL
DIRECTOR (Untitled5)
- CODE (Key) — Primary key — NOT NULL
- biography (Field)
DVD (Untitled3)
- dvdCODE (Key) — char(10) — Primary key — NOT NULL
- copyID (Key2) — char(10) — Foreign key → CopyDvd.copyID — NOT NULL
- purchaseDate (Field) — date
- time (Field2) — int(2)
MOVIE (Untitled8)
- MOVIEID (Key) — Primary key — NOT NULL
- CODE (Key2) — Foreign key → DIRECTOR.CODE — NOT NULL
- actorCODE (Key3) — char(10) — Foreign key → ACTOR.actorCODE — NOT NULL
STORE (Untitled2)
- MOVIEID (Key) — Foreign key → MOVIE.MOVIEID — NOT NULL
- CODE (Key23) — Foreign key → MOVIE.CODE — NOT NULL
- actorCODE (Key32) — char(10) — Foreign key → MOVIE.actorCODE — NOT NULL
- time (Field) — int(2)
- lentDate (Field2) — date
- Field3
- customerID (Key2) — char(10) — Foreign key → CUSTOMER.customerID — NOT NULL
- dvdCODE (Key3) — char(10) — Foreign key → DVD.dvdCODE — NOT NULL
- copyID (Key22) — char(10) — Foreign key → DVD.copyID — NOT NULL