ex 4

Tables (11)

CLIENT

  • Key (clientId) — int(10) — Primary key — NOT NULL
  • Field (name) — char(20)
  • Field (address) — char(20)
  • Field

Untitled (ITEM)

  • Key (itemId) — int(10) — Primary key — NOT NULL
  • Key (movieId) — int(10) — Foreign key → Untitled.Key — NOT NULL
  • Field

Untitled (MOVIE)

  • Key (movieId) — int(10) — Primary key — NOT NULL
  • Field (title) — char(20)
  • Field (year) — int(10)
  • Field (copy) — int(10)
  • Field (time) — char(20)
  • Key (actorId) — int(10) — NOT NULL
  • Field2 (directorId) — nt(10)
  • Field (descriptioj) — LONGTEXT
  • Field

Untitled (DIRECTOR)

  • Key (directorId) — int(10) — Primary key — NOT NULL
  • Field (name) — char(20)
  • Field2 (age) — int(10)
  • Field
  • Field2

Untitled (ACTOR)

  • Key (actorId) — int(10) — Primary key — NOT NULL
  • Field (name) — char(20)
  • Field (age) — int(10)
  • Field

Untitled (DATARECORD)

  • Key (itemData) — Primary key — NOT NULL
  • Key (clientId) — int(10) — Foreign key → CLIENT.Key — NOT NULL
  • Key (itemId) — int(10) — Foreign key → Untitled.Key — NOT NULL
  • Field (startData) — char(20)
  • Field

Untitled (MOVIECREW)

  • Key (movieId) — int(10) — Foreign key → Untitled.Key — NOT NULL
  • Key (actorId) — int(10) — Foreign key → Untitled.Key — NOT NULL
  • Key (directorId) — int(10) — Foreign key → Untitled.Key — NOT NULL

Untitled (REVIEW)

  • Key (reviewId) — int(10) — Primary key — NOT NULL
  • Field

Untitled (MOVIE_GENRE)

    Untitled (GENRE)

    • Key — Primary key — NOT NULL
    • Field (name) — char(20)
    • Field2

    Untitled (RENT)