ERD_DailyQuiz

테이블 (7)

대여 (Loan)

  • Loan ID (loan_id) — INT — 기본 키 — NOT NULL
  • Book ID (book_id) — INT — 외래 키 → 도서.Book ID — NOT NULL
  • Member ID (member_id) — INT — 외래 키 → 회원.Member ID — NOT NULL
  • Loan Date (loan_date) — DATE
  • Return Date (return_date) — DATE
  • Overdue Flag (overdue_flag) — BOOLEAN
  • Extension (extension) — BOOLEAN

도서 (Book)

  • Book ID (book_id) — INT — 기본 키 — NOT NULL
  • ISBN (isbn) — VARCHAR(100) — 외래 키 → 도서정보.ISBN — NOT NULL
  • Reservation Status (reservation_status) — BOOLEAN

도서분류 (BookCategory)

  • Category Code (category_Code) — VARCHAR — 기본 키 — NOT NULL
  • Category Name (category_name) — VARCHAR

도서정보 (BookInfo)

  • ISBN (isbn) — VARCHAR(100) — 기본 키 — NOT NULL
  • Category Code (category_code) — VARCHAR — 외래 키 → 도서분류.Category Code — NOT NULL
  • Author (author) — VARCHAR
  • Publisher (publisher) — VARCHAR
  • Publish Date (publish_date) — DATE
  • Title (titleV) — VARCHAR

부록 (Supplement)

  • Supplement Code (supplement_code) — INT — 기본 키 — NOT NULL
  • Book ID (book_id) — INT — 외래 키 → 도서.Book ID — NOT NULL
  • Supplement Name (supplement_name) — VARCHAR

예약 (Reservation)

  • Member ID (member_id) — INT — 외래 키 → 회원.Member ID — NOT NULL
  • Book ID (book_id) — INT — 외래 키 → 도서.Book ID — NOT NULL
  • Reservation Date (reservation_date) — DATE

회원 (Member)

  • Member ID (member_id) — INT — 기본 키 — NOT NULL
  • Name (name) — VARCHAR(100)
  • Grade (grade) — VARCHAR(100)
  • Address (address) — VARCHAR(3000)
  • Phone (phone_number) — VARCHAR(1000)
  • Email (email) — VARCHAR(1000)