erd 22
Tables (5)
Untitled (VISITOR)
- Key (visitorID) — int(20) — Primary key — NOT NULL
- Field (name) — char(50)
- Field2 (address) — char(50)
- Field3 (phoneNumber) — int(11)
- Field (email) — char(30)
Untitled (MOVIE)
- Key (movieID) — int(30) — Primary key — NOT NULL
- Field (title) — char(50)
- Field2 (volume) — int(2)
- Field3 (subTitle) — char(50)
- Field4 (pubYear) — int(4)
- Field (runTime) — int(3)
- Key (artistID) — int(20) — Foreign key → Untitled.Key — NOT NULL
Untitled (ARTIST)
- Key (artistID) — int(20) — Primary key — NOT NULL
- Field2 (artistName) — char(50)
- Field3 (nationality) — char(20)
- Field (dateOfBirth) — int(8)
- Field (dateOfDeath) — int(8)
Untitled (VISITOR_ARTIST_INT)
- Key (visitorID) — int(20) — Foreign key → Untitled.Key — NOT NULL
- Key (artistID) — int(20) — Foreign key → Untitled.Key — NOT NULL
Untitled2 (TRANSACTION)
- Key (transactionID) — int(20) — Primary key — NOT NULL
- Field (returnDate) — int(8)
- Field2 (loanDate) — int(8)
- Key (movieID) — int(30) — Foreign key → Untitled.Key — NOT NULL
- Key (visitorID) — int(20) — Foreign key → Untitled.Key — NOT NULL