Daily Quiz_ERD

테이블 (7)

대여 (rental)

  • Rental Id (id) — INT — 기본 키 — NOT NULL
  • Book Number (book_number) — INT — 외래 키 → 도서.Book Number — NOT NULL
  • Member Id (member_id) — INT — 외래 키 → 회원.ID — NOT NULL — AUTO_INCREMENT
  • Loan Date (loan_date) — TIMESTAMP
  • Return Date (return_date) — TIMESTAMP
  • Loan Availability (loan_availability) — BOOLEAN — NOT NULL
  • Elongation (elongation) — TIMESTAMP

도서 (books)

  • Book Number (book_number) — INT — 기본 키 — NOT NULL
  • ISBM (isbm) — VARCHAR(25) — 외래 키 → 도서정보.ISBM — NOT NULL
  • Rental Status (rental_status) — BOOLEAN — NOT NULL

도서분류 (book_classification)

  • Classification Symbol (Classification_symbol) — INT — 기본 키 — NOT NULL
  • Classification Name (Classification_name) — VARCHAR(20) — NOT NULL

도서정보 (book_information)

  • ISBM (isbm) — VARCHAR(25) — 기본 키 — NOT NULL
  • Classification Symbol (Classification_symbol) — INT — 외래 키 → 도서분류.Classification Symbol — NOT NULL
  • Author (author) — VARCHAR(25) — NOT NULL
  • Publisher (publisher) — VARCHAR(50) — NOT NULL
  • Publication Date (publication_date) — TIMESTAMP
  • Book Name (book_name) — VARCHAR(25) — NOT NULL

부록 (supplement)

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

예약 (reservation)

  • Member Id (member_id) — INT — 외래 키 → 회원.ID — NOT NULL — AUTO_INCREMENT
  • Book Number (book_number) — INT — 외래 키 → 도서.Book Number — NOT NULL
  • Reservation Date (reservation_date) — TIMESTAMP

회원 (member)

  • ID (id) — INT — 기본 키 — NOT NULL — AUTO_INCREMENT
  • Name (name) — VARCHAR(100) — NOT NULL
  • Resident Number (resident_number) — VARCHAR(14) — NOT NULL
  • Membership Level (membership_level) — VARCHAR(10)
  • Address (address) — VARCHAR(3000)
  • Phone Number (phone_number) — VARCHAR(15)
  • Email (email) — VARCHAR(100)