도서관리시스템

테이블 (7)

Appendix

  • Appendix code (Appendix_code) — varchar2(8) — 기본 키 — NOT NULL
  • Book NO (Book_No) — varchar2(10) — 외래 키 → book.Book No — NOT NULL
  • Appendix name (Appendix_name) — varchar2(50) — NOT NULL

Book Info (Book_Info)

  • ISBN (ISBM) — number(15) — 기본 키 — NOT NULL
  • Classification symbol (Classification_symbol) — varchar2(50) — 외래 키 → Book classification.Classification symbol — NOT NULL
  • Author — varchar2(50) — NOT NULL
  • Publisher — varcahr2(50) — NOT NULL
  • Published date (Published_date) — date — NOT NULL
  • Book name (Book_name) — varchar2(50) — NOT NULL

Book Loan (Book_Loan)

  • Book Loan No (Book_Loan_No) — number(10) — 기본 키 — NOT NULL
  • Member No (Member_No) — varchar2(8) — 외래 키 → Member.Member No — NOT NULL — 회원번호 최대 10개까지 제약
  • Book No (Book_No) — number — 외래 키 → book.Book No — NOT NULL
  • Book Loan date (Book_Loan_date) — date — NOT NULL
  • Book Return date (Book_Return_date) — date
  • Appendix loan status (Appendix_Loan_Status) — number(1) — NOT NULL — 부록 대출 여부 1: Yes, 0: No
  • Extension — number(7)

Book classification (Book_classification)

  • Classification symbol (Classification_symbol) — varchar2(50) — 기본 키 — NOT NULL
  • Classification name (Classification_name) — varchar2(50) — NOT NULL

Member

  • Member No (Member_No) — varchar2(8) — 기본 키 — NOT NULL
  • Name — varchar2(20) — NOT NULL
  • Registration No (Registration_No) — varchar2(14) — NOT NULL — UNIQUE
  • Member type (Member_type) — number — NOT NULL — 회원 등급 0: professor, 1: student, 2: graduate
  • Address — varchar2(60) — NOT NULL
  • Phone No (Phone_No) — varchar2(13)) — NOT NULL — UNIQUE
  • email (e-mail) — varchar2(30) — NOT NULL — UNIQUE
  • Late fee (Late_fee) — number(5)

Reservation

  • Member No (Member_No) — varchar2(8) — 외래 키 → Member.Member No — NOT NULL
  • Book NO (Book_No) — varchar2(10) — 외래 키 → book.Book No — NOT NULL
  • Reservation date (Reservation_date) — date — NOT NULL

book (Book)

  • Book No (Book_No) — varchar2(8) — 기본 키 — NOT NULL
  • ISBN — number(15) — 외래 키 → Book Info.ISBN — NOT NULL
  • Subscription — number(1) — NOT NULL — 예약여부 1: Yes, 0: No