도서관이용자 이용현황

테이블 (4)

Untitled (LIBRARY MEMBERS)

  • Field (ID) — 기본 키
  • Field (Name) — char(10)
  • Field (Age) — int(3)
  • Field (Gender) — char(5)
  • Field (Address) — char(30)

Untitled (WISH BOOK)

  • Field (ISBN) — int(15) — 기본 키
  • Field (Name) — char(10)
  • Field (Title) — int(3)
  • Field (Author) — char(30)
  • Field (Publisher) — char(30)
  • Field (Price) — int(10)
  • Field (ReleaseDate)
  • Field (ID) — 외래 키 → Untitled.Field

Untitled2 (INTER LIBRARY LOAN)

  • Field (ISBN) — INT(30) — 기본 키
  • Field (Title) — char(10)
  • Field (Author) — char(30)
  • Field (Publisher) — char(30)
  • Field (Price) — int(10)
  • Field (ReleaseDate)
  • Field (InterLibrary) — char(30)
  • Field (ID2) — 외래 키 → Untitled.Field

Untitled4 (PROGRAM)

  • Field (programTitle) — char(30) — 기본 키
  • Field (target) — char(10)
  • Field (time) — int(30)
  • Field (daysofWeek) — char(10)
  • Field (Address) — char(30)
  • Field (ID2) — 외래 키 → Untitled.Field