2022913002ERD4
Tables (6)
ACTOR (Untitled5)
- Key — char(30) — Primary key — NOT NULL
- Field — char(30)
- Field2 — text
CUSTOMER (Untitled2)
- Key — char(10) — Primary key — NOT NULL
- Field — char(30)
- Field2 — char(30)
- Field3 — char(12)
- Field4 — char(20)
DIRECTOR (Untitled6)
- Key — char(30) — Primary key — NOT NULL
- Field — char(30)
- Field2 — text
DVD (Untitled3)
- Key — char(10) — Primary key — NOT NULL
- Field — int(8)
- Field2 — int(20)
- Key (Key2) — char(30) — Foreign key → MOVIE.Key — NOT NULL
DVD_STORE (Untitled)
- Key — char(10) — Primary key — NOT NULL
- Field — date
- Field2 — int(6)
- Key (Key2) — char(10) — Foreign key → CUSTOMER.Key — NOT NULL
- Key (Key3) — char(10) — Foreign key → DVD.Key — NOT NULL
MOVIE (Untitled4)
- Key — char(30) — Primary key — NOT NULL
- Field3 — int(8)
- Field4 — char(30)
- Field — text
- Key (Key2) — char(30) — Foreign key → ACTOR.Key — NOT NULL
- Key (Key3) — char(30) — Foreign key → DIRECTOR.Key — NOT NULL