2023_SLI_EX4
Tables (9)
Customers (CLIENT)
- Key (custromeID) — char(10) — Primary key — NOT NULL
- Field (name) — char(20)
- Field (address) — char(50)
- Field (phone) — int(11)
- Field (ssn) — char(13)
Untitled (DVD)
- Key (code) — char(100) — Primary key — NOT NULL
- Field (buyingDate) — date
- Field (price) — int(10)
- Key (moviedID) — int(10) — Foreign key → Untitled.Key — NOT NULL
Untitled (RENT)
- Key (rentID) — int(100) — Primary key — NOT NULL
- Field (rentDate) — date
- Field (returnDate) — date
- Key (code) — char(100) — Foreign key → Untitled.Key — NOT NULL
- Key (custromeID) — char(10) — Foreign key → Customers.Key — NOT NULL
Untitled (MOVIE)
- Key (moviedID) — int(10) — Primary key — NOT NULL
- Field (title) — char(30)
- Field (pubYear) — int(4)
- Field (pubMonth) — int(2)
- Field (description) — text
Untitled (CASTING)
- Key (roleID) — int(3) — Foreign key → Untitled.Key — NOT NULL
- Key (personID) — int(10) — Foreign key → Untitled.Key — NOT NULL
- Key (moviedID) — int(10) — Foreign key → Untitled.Key — NOT NULL
Untitled (ROLE)
- Key (roleID) — int(3) — Primary key — NOT NULL
- Field (roletitle) — char(30)
- Field (description) — text
Untitled (PERSON)
- Key (personID) — int(10) — Primary key — NOT NULL
- Field (name) — char(30)
- Field (minit) — char(1)
- Field (description) — text
- Field (award) — text
Untitled (MOVIE GELRE)
- Key (moviedID) — int(10) — Foreign key → Untitled.Key — NOT NULL
- Key (genreID) — int(5) — Foreign key → Untitled.Key — NOT NULL
Untitled (GELRE)
- Key (genreID) — int(5) — Primary key — NOT NULL
- Field (name) — char(30)
- Field (description) — text