daily_quiz
테이블 (7)
대여 (rental)
- Rental Number (rental_num) — INT — 기본 키 — NOT NULL
- Book Number (book_num) — INT — 외래 키 → 도서.Book Number — NOT NULL — 도서번호(FK)
- Member Number (member_num) — INT — 외래 키 → 회원.Member Number — NOT NULL — 회원번호(FK)
- Rental Date (rental_date) — DATE
- Return Date (return_date) — DATE
- Is Appendix Rental (is_appendix_rental) — TINYINT(1)
- Is Extended (is_extended) — TINYINT(1)
도서 (book)
- Book Number (book_num) — INT — 기본 키 — NOT NULL
- ISBN — 외래 키 → 도서정보.ISBN — NOT NULL — ISBK(FK)
- Is Reserved (is_reserved) — TINYINT(1)
도서분류 (book_category)
- Book Symbol (book_symbol) — 기본 키 — NOT NULL
- Category Name (category_name)
도서정보 (book_info)
- ISBN — INT — 기본 키 — NOT NULL
- Book Symbol (book_symbol) — VARCHAR(30) — 외래 키 → 도서분류.Book Symbol — NOT NULL — 분류기호(FK)
- Author (author) — VARCHAR(30)
- Publisher (publisher) — VARCHAR(50)
- Publication Date (publication_date) — DATE
- Book Title (book_title) — VARCHAR(100)
부록 (Appendix)
- Appendix Code (appendix_code) — VARCHAR(30) — 기본 키 — NOT NULL
- Book Number (book_num) — INT — 외래 키 → 도서.Book Number — NOT NULL — 도서번호(FK)
- Appendix Name (appendix_name) — VARCHAR(50)
예약 (reservation)
- Reservation Date (reservation_date) — DATE — 기본 키 — NOT NULL
- Member Number (member_num2) — INT — 외래 키 → 회원.Member Number — NOT NULL — 회원번호(FK)
- Book Number (book_num2) — INT — 외래 키 → 도서.Book Number — NOT NULL — 도서정보(FK)
회원 (member)
- Member Number (member_num) — INT — 기본 키 — NOT NULL
- Name (name) — VARCHAR(30)
- Resident Registration Number (resident_registration_number) — VARCHAR(20)
- Grade (grade) — VARCHAR(10)
- Address (address) — VARCHAR(200)
- Phone Number (phone_number) — VARCHAR(20)
- E-mail (e_mail) — VARCHAR(200)