과제 예제4_임미숙

테이블 (6)

ACTOR (Untitled6)

  • actorCode (Key) — char(5) — 기본 키 — NOT NULL
  • titleCode (Key2) — char(10) — 외래 키 → MOVIE.titleCode — NOT NULL
  • directorCode (Key22) — char(5) — 외래 키 → MOVIE.directorCode — NOT NULL
  • biography (Field) — text
  • name (Field2) — char(20)
  • phone (Field3) — int
  • email (Field4) — char(25)

CUSTOMER (Untitled)

  • customerNo (Key) — char(5) — 기본 키 — NOT NULL
  • name (Field) — char(20)
  • address (Field2) — char(30)
  • phone (Field3) — char(15)

DIRECTOR (Untitled5)

  • directorCode (Key) — char(5) — 기본 키 — NOT NULL
  • bioraphy (Field) — text
  • name (Field2) — char(20)
  • phone (Field3) — int
  • email (Field4) — char(25)

MOVIE (Untitled4)

  • titleCode (Key) — char(10) — 기본 키 — NOT NULL
  • directorCode (Key2) — char(5) — 외래 키 → DIRECTOR.directorCode — NOT NULL
  • title (Field) — char(20)
  • yearMade (Field2) — year
  • director (Field3) — char(20)
  • actor (Field4) — char(20)

TRANSACTION (Untitled3)

  • customerNo (Key) — 기본 키 — NOT NULL
  • customerNo (Key2) — char(5) — 외래 키 → CUSTOMER.customerNo — NOT NULL
  • movietitleId (Field) — char(10)
  • transactionDate (Field2) — date
  • transactionTime (Field3) — char(10)

VIDEO (Untitled2)

  • videoCode (Key) — char(5) — 기본 키 — NOT NULL
  • titleCode (Key2) — char(10) — 외래 키 → MOVIE.titleCode — NOT NULL
  • directorCode (Key22) — char(5) — 외래 키 → MOVIE.directorCode — NOT NULL
  • customerNo (Key3) — 외래 키 → TRANSACTION.customerNo — NOT NULL
  • customerNo (Key23) — char(5) — 외래 키 → TRANSACTION.customerNo — NOT NULL
  • copyCode (Field) — char(5)
  • purchaseDate (Field2) — date
  • NoOfRented (Field3) — int