Ex4
Tables (9)
Untitled (Movie)
- Key (movieId) — unt(10) — Primary key — NOT NULL
- Field (title) — char(30)
- Field (pubYear) — int(4)
- Field (pubMonth) — int(2)
- Field (description) — text
- Field (award) — text
Untitled (Dvditem)
- Key (itemId) — int(100) — Primary key — NOT NULL
- Field (buyingDate) — date
- Field (price) — int(10)
- Field (Level) — char(1)
- Key (movieId) — unt(10) — Foreign key → Untitled.Key — NOT NULL
Untitled (Rent)
- Key (rentID) — int(1000) — Primary key — NOT NULL
- Field (rentDate) — date
- Field (retunDate) — date
- Field — date
- Key (itemId) — int(100) — Foreign key → Untitled.Key — NOT NULL
- Key (clientId) — int(100) — Foreign key → Untitled.Key — NOT NULL
Untitled (Movie_Genre)
- Key (movieId) — unt(10) — Foreign key → Untitled.Key — NOT NULL
- Key (genreIdKey) — unt(5) — Foreign key → Untitled.Key — NOT NULL
Untitled (Casting)
- Key (movieId) — unt(10) — Foreign key → Untitled.Key — NOT NULL
- Key (personId) — int(10) — Foreign key → Untitled.Key — NOT NULL
- Key (roleId) — int(3) — Foreign key → Untitled.Key — NOT NULL
Untitled (Genre)
- Key (genreIdKey) — unt(5) — Primary key — NOT NULL
- Field (name) — char(30)
- Field (description) — text
Untitled (Person)
- Key (personId) — int(10) — Primary key — NOT NULL
- Field (name) — char(30)
- Field (description) — text
- Field (award) — text
Untitled (Role)
- Key (roleId) — int(3) — Primary key — NOT NULL
- Field (roleTitle) — char(30)
Untitled (Client)
- Key (clientId) — int(100) — Primary key — NOT NULL
- Field (name) — char(30)
- Field (phone) — char(11)