daily_quiz

테이블 (7)

대여 (rental)

  • Rental Number (rental_num) — INT — 기본 키 — NOT NULL
  • Book Number (book_num) — INT — 외래 키 → 도서.Book Number — NOT NULL — 도서번호(FK)
  • Member Number (member_num) — INT — 외래 키 → 회원.Member Number — NOT NULL — 회원번호(FK)
  • Rental Date (rental_date) — DATE
  • Return Date (return_date) — DATE
  • Is Appendix Rental (is_appendix_rental) — TINYINT(1)
  • Is Extended (is_extended) — TINYINT(1)

도서 (book)

  • Book Number (book_num) — INT — 기본 키 — NOT NULL
  • ISBN — 외래 키 → 도서정보.ISBN — NOT NULL — ISBK(FK)
  • Is Reserved (is_reserved) — TINYINT(1)

도서분류 (book_category)

  • Book Symbol (book_symbol) — 기본 키 — NOT NULL
  • Category Name (category_name)

도서정보 (book_info)

  • ISBN — INT — 기본 키 — NOT NULL
  • Book Symbol (book_symbol) — VARCHAR(30) — 외래 키 → 도서분류.Book Symbol — NOT NULL — 분류기호(FK)
  • Author (author) — VARCHAR(30)
  • Publisher (publisher) — VARCHAR(50)
  • Publication Date (publication_date) — DATE
  • Book Title (book_title) — VARCHAR(100)

부록 (Appendix)

  • Appendix Code (appendix_code) — VARCHAR(30) — 기본 키 — NOT NULL
  • Book Number (book_num) — INT — 외래 키 → 도서.Book Number — NOT NULL — 도서번호(FK)
  • Appendix Name (appendix_name) — VARCHAR(50)

예약 (reservation)

  • Reservation Date (reservation_date) — DATE — 기본 키 — NOT NULL
  • Member Number (member_num2) — INT — 외래 키 → 회원.Member Number — NOT NULL — 회원번호(FK)
  • Book Number (book_num2) — INT — 외래 키 → 도서.Book Number — NOT NULL — 도서정보(FK)

회원 (member)

  • Member Number (member_num) — INT — 기본 키 — NOT NULL
  • Name (name) — VARCHAR(30)
  • Resident Registration Number (resident_registration_number) — VARCHAR(20)
  • Grade (grade) — VARCHAR(10)
  • Address (address) — VARCHAR(200)
  • Phone Number (phone_number) — VARCHAR(20)
  • E-mail (e_mail) — VARCHAR(200)