2022913002ERD4

Tables (6)

ACTOR (Untitled5)

  • Key — char(30) — Primary key — NOT NULL
  • Field — char(30)
  • Field2 — text

CUSTOMER (Untitled2)

  • Key — char(10) — Primary key — NOT NULL
  • Field — char(30)
  • Field2 — char(30)
  • Field3 — char(12)
  • Field4 — char(20)

DIRECTOR (Untitled6)

  • Key — char(30) — Primary key — NOT NULL
  • Field — char(30)
  • Field2 — text

DVD (Untitled3)

  • Key — char(10) — Primary key — NOT NULL
  • Field — int(8)
  • Field2 — int(20)
  • Key (Key2) — char(30) — Foreign key → MOVIE.Key — NOT NULL

DVD_STORE (Untitled)

  • Key — char(10) — Primary key — NOT NULL
  • Field — date
  • Field2 — int(6)
  • Key (Key2) — char(10) — Foreign key → CUSTOMER.Key — NOT NULL
  • Key (Key3) — char(10) — Foreign key → DVD.Key — NOT NULL

MOVIE (Untitled4)

  • Key — char(30) — Primary key — NOT NULL
  • Field3 — int(8)
  • Field4 — char(30)
  • Field — text
  • Key (Key2) — char(30) — Foreign key → ACTOR.Key — NOT NULL
  • Key (Key3) — char(30) — Foreign key → DIRECTOR.Key — NOT NULL