Exercise 4 _ DB
Tables (9)
Untitled (CLIENT)
- Key (ClientId) — char — Primary key — NOT NULL
- Field (name)
- Field (address)
Untitled (RENTAL)
- Key (rentalId) — int — Primary key — NOT NULL
- Field (dateAndTimeRented) — char
- Key (ClientId) — char — Foreign key → Untitled.Key — NOT NULL
- Key (dvdCodeId) — char — Foreign key → Untitled2.Key — NOT NULL
Untitled (PERSON)
- Key (personId) — Primary key — NOT NULL
- Field (biography)
- Field (name)
- Field (birthDate)
Untitled (MOVIE_DIRECTOR)
- Key (personId) — Foreign key → Untitled2.Key — NOT NULL
- Key (movieId) — char — Foreign key → Untitled3.Key — NOT NULL
Untitled (MOVIE_ACTOR)
- Key (personId) — Foreign key → Untitled3.Key — NOT NULL
- Key (movieId) — char — Foreign key → Untitled3.Key — NOT NULL
Untitled2 (DVD)
- Key (dvdCodeId) — char — Primary key — NOT NULL
- Field (dateOdPurchase) — date
- Field (rentalCount) — int
- Key (movieId) — char — Foreign key → Untitled3.Key — NOT NULL
Untitled2 (DIRECTOR)
- Key (personId) — Foreign key → Untitled.Key — NOT NULL
- Field (role)
Untitled3 (MOVIE)
- Key (movieId) — char — Primary key — NOT NULL
- Field (title) — char
- Field (yearMade) — date
- Field (description) — texta
- Field (award)
Untitled3 (ACTOR)
- Key (personId) — Foreign key → Untitled.Key — NOT NULL
- Field (role)