기말고사

테이블 (3)

BOOK_LOAN_RETURN (Untitled4)

  • BookTitle (Field2) — char(50)
  • BookLoanDate (Field) — date
  • BookReturnDate (Field3) — date
  • BookStartID (Key3) — int(20) — 외래 키 → BOOK_START.BookStartID — NOT NULL
  • UserID (Key32) — int(10) — 외래 키 → READING_1000BOOKS.UserID — NOT NULL
  • TotalNumberOfLoan (Field4)

BOOK_START (Untitled3)

  • BookStartID (Key) — int(20) — 기본 키 — NOT NULL
  • UserName (Field) — char(30)
  • Description (Field3) — text
  • ParentName (Field4) — char(30)
  • BirthDate (Field5) — date
  • Address (Field2) — char(30)
  • BookStartLevel (Field6) — int(5)
  • PhoneNumber (Field7) — int(10)

READING_1000BOOKS (Untitled2)

  • UserID (Key3) — int(20) — 기본 키 — NOT NULL
  • UserName (Field) — char(30)
  • UserGender (Field2) — char(2))
  • UserBirthDate (Field3) — date
  • UserAddress (Field4) — char(30)
  • UserPhoneNumber (Field5) — int(10)
  • Description (Field6) — text
  • UserParentName (Field7) — char(30)
  • UserParentID (Field8) — int(10)
  • 1000BooksLevel (Field9) — int(5)