Week_4

Tables (8)

ACTOR (CopyOfUntitled5)

  • actor_code (Key) — CHAR(6) — Primary key — NOT NULL
  • gname (Field) — CHAR(16)
  • fname (Field2) — CHAR(16)
  • biography (Field3) — longtext

CUSTOMER (Untitled)

  • customer_code (Key) — CHAR(6) — Primary key — NOT NULL
  • gname (Field) — CHAR(16)
  • fname (Field2) — CHAR(16)
  • address (Field3) — longtext

DIRECTOR (Untitled5)

  • director_code (Key) — CHAR(6) — Primary key — NOT NULL
  • gname (Field) — CHAR(16)
  • fname (Field2) — CHAR(16)
  • biography (Field3) — longtext

DVD (Untitled2)

  • dvd_code (Key) — CHAR(8) — Primary key — NOT NULL
  • buyat (Field) — date
  • lendcount (Field2) — int
  • movie_code (Key2) — CHAR(6) — Foreign key → MOVIE.movie_code — NOT NULL

DVD_LEND (Untitled3)

  • lenddate (Field) — date — Primary key
  • lendtime (Field2) — time — Primary key
  • customer_code (Key) — CHAR(6) — Foreign key → CUSTOMER.customer_code — NOT NULL
  • dvd_code (Key2) — CHAR(8) — Foreign key → DVD.dvd_code — NOT NULL

MOVIE (Untitled4)

  • movie_code (Key) — CHAR(6) — Primary key — NOT NULL
  • title (Field) — CHAR(32)
  • coming (Field2) — date

MOVIE_ACTOR (Untitled6)

  • actor_code (Key) — CHAR(6) — Foreign key → ACTOR.actor_code — NOT NULL
  • movie_code (Key2) — CHAR(6) — Foreign key → MOVIE.movie_code — NOT NULL

MOVIE_DIRECTOR (Untitled7)

  • director_code (Key) — CHAR(6) — Foreign key → DIRECTOR.director_code — NOT NULL
  • movie_code (Key2) — CHAR(6) — Foreign key → MOVIE.movie_code — NOT NULL