DBproject
Tables (13)
Untitled (director)
- Key (directorID) — int — Primary key — NOT NULL
- Field (directorName) — varchar — NOT NULL
- Field2 (dateOfBirth) — varchar — NOT NULL
- Field3 (dateOfDeath) — varchar
Untitled (actor)
- Key (actorID) — int — Primary key — NOT NULL
- Field (actorName) — varchar — NOT NULL
- Field (dateOfBirth) — varchar — NOT NULL
- Field (dateOfDeath) — varchar
- Field (gender) — varchar — NOT NULL
Untitled (movie)
- Key (movieID) — int — Primary key — NOT NULL
- Field (movieName) — varchar — NOT NULL
- Field (releaseYear) — varchar — NOT NULL
- Field (releaseMonth) — varchar — NOT NULL
- Field (releaseDate) — varchar — NOT NULL
- Field (publisherName) — varchar — NOT NULL
- Field (aveRate) — int — NOT NULL
Untitled (award)
- Key (awardID) — int — Primary key — NOT NULL
- Field (awardName) — varchar — NOT NULL
Untitled (genre)
- Key (genreName) — varchar — Primary key — NOT NULL
Untitled (movieGenre)
- Key (movieID) — int — Foreign key → Untitled.Key — NOT NULL
- Key (genreName) — varchar — Foreign key → Untitled.Key — NOT NULL
Untitled (movieObtain)
- Key (movieID) — int — Foreign key → Untitled.Key — NOT NULL
- Key (awardID) — int — Foreign key → Untitled.Key — NOT NULL
- Field (year) — varchar — NOT NULL
Untitled (actorObtain)
- Key (actorID) — int — Foreign key → Untitled.Key — NOT NULL
- Key (awardID) — int — Foreign key → Untitled.Key — NOT NULL
- Field (year) — varchar — NOT NULL
Untitled (directorObtain)
- Key (directorID) — int — Foreign key → Untitled.Key — NOT NULL
- Key (awardID) — int — Foreign key → Untitled.Key — NOT NULL
- Field (year) — varchar — NOT NULL
Untitled (casting)
- Key (movieID) — int — Foreign key → Untitled.Key — NOT NULL
- Key (actorID) — int — Foreign key → Untitled.Key — NOT NULL
- Field (role) — varchar — NOT NULL
Untitled (make)
- Key (movieID) — int — Foreign key → Untitled.Key — NOT NULL
- Key (directorID) — int — Foreign key → Untitled.Key — NOT NULL
Untitled (customerRate)
- Key (customerID) — int — Foreign key → Untitled.Key — NOT NULL
- Key (movieID) — int — Foreign key → Untitled.Key — NOT NULL
Untitled (customer)
- Key (customerID) — int — Primary key — NOT NULL
- Field (customerName) — varchar — NOT NULL
- Field (dateOfBirth) — varchar — NOT NULL
- Field (gender) — varchar — NOT NULL