exercise 4

Tables (6)

Untitled (CUSTOMER)

  • Key (cusID) — char(10) — Primary key — NOT NULL
  • Field (name) — char(10)
  • Field (address) — char(30)
  • Field (phone) — char(11)
  • Field (birthDate) — date
  • Field (email) — char(30)

Untitled (DVD)

  • Key (dvdCode) — char(20) — Primary key — NOT NULL
  • Field (구입일) — date
  • Field (대여횟수) — int(4)
  • Field (movieName) — char(30)
  • Field (price) — int(10)
  • Key (movieId) — int(10) — Foreign key → Untitled.Key — NOT NULL

Untitled (RENT)

  • Key (cusID) — char(10) — Foreign key → Untitled.Key — NOT NULL
  • Field (대여날짜) — date
  • Field (대여시간) — char(5)
  • Key (dvdCode) — char(20) — Foreign key → Untitled.Key — NOT NULL

Untitled (ACTOR_CASTING)

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

Untitled (MOVIE)

  • Key (movieId) — int(10) — Primary key — NOT NULL
  • Field (title) — chat(30)
  • Field (pubYear) — int(4)
  • Field (pubMonth) — int(2)
  • Field (description) — LONGTEXT
  • Field (award) — LONGTEXT

Untitled (PERSON)

  • Key (personId) — int(10) — Primary key — NOT NULL
  • Field (fname) — char(30)
  • Field (minit) — char(1)
  • Field (lname) — char(30)
  • Field (description) — LONGTEXT
  • Field (award) — text