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)