ERD exercise 5(20200928)
Tables (8)
ACTOR (Untitled4)
- actId (Key) — CHAR(10) — Primary key — NOT NULL
- actName (Field) — CHAR(20)
- actSsn (Field2) — CHAR(20)
- biography (Field3) — longtext
APPEAR (Untitled5)
- actId (Key) — CHAR(10) — Foreign key → ACTOR.actId — NOT NULL
- movId (Key2) — CHAR(10) — Foreign key → MOVIE.movId — NOT NULL
- role (Field) — CHAR(10)
CLIENT (Untitled)
- clId (Key) — CHAR(10) — Primary key — NOT NULL
- clName (Field) — CHAR(20)
- clSsn (Field2) — CHAR(20)
- clAddress (Field3) — CHAR(50)
- phone (Field4) — CHAR(20)
- email (Field5) — CHAR(30)
CONTRACT (Untitled2)
- conId (Key) — CHAR(10) — Primary key — NOT NULL
- conDate (Field) — date
- conTime (Field2) — time
- price (Field3) — int(10)
- dueDate (Field4) — date
- dvdId (Key2) — CHAR(10) — Foreign key → DVD.dvdId — NOT NULL
- clId (Key3) — CHAR(10) — Foreign key → CLIENT.clId — NOT NULL
DIRECTOR (Untitled7)
- dirId (Key) — CHAR(10) — Primary key — NOT NULL
- dirName (Field) — CHAR(20)
- dirSsn (Field2) — CHAR(20)
- biography (Field3) — longlext
DVD (Untitled3)
- dvdId (Key) — CHAR(10) — Primary key — NOT NULL
- dvdName (Field) — CHAR(20)
- purchaseDate (Field2) — date
- numOfContract (Field3) — int(10)
- length (Field4) — int(10)
- price (Field5) — int(10)
- description (Field6) — CHAR(50)
- movId (Key2) — CHAR(10) — Foreign key → MOVIE.movId — NOT NULL
MOVIE (Untitled6)
- movId (Key) — CHAR(10) — Primary key — NOT NULL
- title (Field) — CHAR(20)
- subtitle (Field2) — CHAR(20)
- productionYear (Field3) — date
PARTICIPATE (Untitled8)
- dirId (Key) — CHAR(10) — Foreign key → DIRECTOR.dirId — NOT NULL
- movId (Key2) — CHAR(10) — Foreign key → MOVIE.movId — NOT NULL
- role (Field) — CHAR(10)