2023_SLI_EX4
Tables (10)
Untitled (MOVIE)
- Key (movieID) — int(10) — Primary key — NOT NULL
- Field (title) — char(30)
- Field (year) — int(4)
- Field (month) — int(2)
- Field (award) — text
- Field (description) — text
Untitled (COPYS)
- Key (copysCode) — Primary key — NOT NULL
- Field (purchaseDate)
- Field (rentedTime)
- Field
- Key (videoCode) — char(10) — Foreign key → Untitled.Key — NOT NULL
Untitled (RENT)
- Key (rentID) — int(100) — Primary key — NOT NULL
- Key (customerID) — char(10) — Foreign key → Untitled2.Key — NOT NULL
- Field (rentDate) — date
- Field (returnDate) — date
- Key (videoCode) — char(10) — Foreign key → Untitled.Key — NOT NULL
Untitled (VIDEOCASSETTE)
- Key (videoCode) — char(10) — Primary key — NOT NULL
- Field (description) — text
- Field (price) — int(10)
- Field (stateusLevel) — char(1)
- Field (buyingDate) — date
- Key (movieID) — int(10) — Foreign key → Untitled.Key — NOT NULL
Untitled (MOVIE_GENRE)
- Key (movieID2) — int(10) — Foreign key → Untitled.Key — NOT NULL
- Key (genreCode2) — int(5) — Foreign key → Untitled.Key — NOT NULL
- Field (movieID) — int(10)
- Field (genreCode) — int(5)
Untitled (GENRE)
- Key (genreCode) — int(5) — Primary key — NOT NULL
- Field (name) — char(30)
- Field (description) — text
Untitled (CASTING)
- Key (movieID2) — int(10) — Foreign key → Untitled.Key — NOT NULL
- Field (movieID) — INT(10)
- Field (personID) — INT(10)
- Field (roleID) — int(3)
- Field (description) — text
- Key (personID2) — int(10) — Foreign key → Untitled2.Key — NOT NULL
- Key (roleID2) — int(10) — Foreign key → Untitled.Key — NOT NULL
Untitled (ROLE)
- Key (roleID) — int(10) — Primary key — NOT NULL
- Field (roleTitle) — char(30)
- Field (description) — text
Untitled2 (CUSTOMER)
- Key (customerID) — int(100) — Primary key — NOT NULL
- Field (name) — char(20)
- Field (adress) — char(30)
- Field2 (phone) — int(11)
- Field (email) — char(3)
Untitled2 (PERSON)
- Key (personID) — int(10) — Primary key — NOT NULL
- Field (fname) — char(3)
- Field (award) — text
- Field (description) — text