도서관리시스템
테이블 (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