0811ex04
Tables (7)
ACTOR (Untitled4)
- acode (Key) — CHAR(30) — Primary key — NOT NULL
- aname (Field) — CHAR(30)
- ayearborn (Field2) — INT(8)
BIOGRAPHY (Untitled6)
- dcode (Key) — CHAR(30) — Foreign key → DIRECTOR.dcode — NOT NULL
- acode (Key2) — CHAR(30) — Foreign key → ACTOR.acode — NOT NULL
- mtitle (Key3) — CHAR(30) — Foreign key → MOVIE.mtitle — NOT NULL
CUSTOMER (Untitled)
- ccode (Key) — CHAR(30) — Primary key — NOT NULL
- cname (Field) — CHAR(30)
- caddress (Field2) — CHAR(50)
DIRECTOR (Untitled5)
- dcode (Key) — CHAR(30) — Primary key — NOT NULL
- dname (Field) — CHAR(30)
- dyearborn (Field2) — INT(8)
MOVIE (Untitled7)
- mtitle (Key) — CHAR(30) — Primary key — NOT NULL
- myearmade (Field) — INT(4)
- acode (Key2) — CHAR(30) — Foreign key → ACTOR.acode — NOT NULL
- dcode (Key3) — CHAR(30) — Foreign key → DIRECTOR.dcode — NOT NULL
RENTALRECORD (Untitled3)
- ccode (Key) — CHAR(30) — Foreign key → CUSTOMER.ccode — NOT NULL
- vcode (Key2) — CHAR(30) — Foreign key → VIDEO.vcode — NOT NULL
- rdate (Field) — INT(8)
- rtime (Field2) — INT(4)
VIDEO (Untitled2)
- vcode (Key) — CHAR(30) — Primary key — NOT NULL
- vdateofpurchase (Field3) — INT(8)
- mtitle (Key4) — CHAR(30) — Foreign key → MOVIE.mtitle — NOT NULL