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