Exercise6
Tables (7)
CUSTOM (CUSTOMER)
- Key (customId) — Primary key — NOT NULL
- Field (customAddress)
- Field (customName)
Untitled (VIDEO)
- Key (videoCode) — Primary key — NOT NULL
- Field (purchaseDate)
- Key (movieCode) — Foreign key → Untitled.Key — NOT NULL
Untitled (RENT)
- Key (customId) — Foreign key → CUSTOM.Key — NOT NULL
- Key (videoCode) — Foreign key → Untitled.Key — NOT NULL
- Field (rentDate)
Untitled (MOVIE)
- Key (movieCode) — Primary key — NOT NULL
- Field (movieName)
- Field (movieDate)
- Key (producerId) — Foreign key → Untitled.Key — NOT NULL
Untitled (PRODUCER)
- Key (producerId) — Primary key — NOT NULL
- Field (producerName)
Untitled (ACTOR)
- Key (actorId) — Primary key — NOT NULL
- Field (actorName)
- Key (movieCode) — Foreign key → Untitled.Key — NOT NULL
Untitled (ACTOR_LIST)
- Key (movieCode) — Foreign key → Untitled.Key — NOT NULL
- Key (actorId) — Foreign key → Untitled.Key — NOT NULL