Week_4
Tables (8)
ACTOR (CopyOfUntitled5)
- actor_code (Key) — CHAR(6) — Primary key — NOT NULL
- gname (Field) — CHAR(16)
- fname (Field2) — CHAR(16)
- biography (Field3) — longtext
CUSTOMER (Untitled)
- customer_code (Key) — CHAR(6) — Primary key — NOT NULL
- gname (Field) — CHAR(16)
- fname (Field2) — CHAR(16)
- address (Field3) — longtext
DIRECTOR (Untitled5)
- director_code (Key) — CHAR(6) — Primary key — NOT NULL
- gname (Field) — CHAR(16)
- fname (Field2) — CHAR(16)
- biography (Field3) — longtext
DVD (Untitled2)
- dvd_code (Key) — CHAR(8) — Primary key — NOT NULL
- buyat (Field) — date
- lendcount (Field2) — int
- movie_code (Key2) — CHAR(6) — Foreign key → MOVIE.movie_code — NOT NULL
DVD_LEND (Untitled3)
- lenddate (Field) — date — Primary key
- lendtime (Field2) — time — Primary key
- customer_code (Key) — CHAR(6) — Foreign key → CUSTOMER.customer_code — NOT NULL
- dvd_code (Key2) — CHAR(8) — Foreign key → DVD.dvd_code — NOT NULL
MOVIE (Untitled4)
- movie_code (Key) — CHAR(6) — Primary key — NOT NULL
- title (Field) — CHAR(32)
- coming (Field2) — date
MOVIE_ACTOR (Untitled6)
- actor_code (Key) — CHAR(6) — Foreign key → ACTOR.actor_code — NOT NULL
- movie_code (Key2) — CHAR(6) — Foreign key → MOVIE.movie_code — NOT NULL
MOVIE_DIRECTOR (Untitled7)
- director_code (Key) — CHAR(6) — Foreign key → DIRECTOR.director_code — NOT NULL
- movie_code (Key2) — CHAR(6) — Foreign key → MOVIE.movie_code — NOT NULL