과제

테이블 (3)

BOOK

  • Key (ISBN) — char(50) — 기본 키 — NOT NULL
  • Field (title) — char(50)
  • Field2 (pubyear) — int(4)
  • Field3 (type) — char(10)
  • Field4 (expression) — char(3)

Untitled (AUTHOR)

  • Key (authorID) — int(10) — 기본 키 — NOT NULL
  • Field (name) — char(30)
  • Field2 (alternativeName) — char(50)
  • Field3 (description) — text

Untitled (RENT)

  • Key (rentID) — int(1000) — 기본 키 — NOT NULL
  • Field (rentDate) — date
  • Field2 (returnDate) — date