ERD_DailyQuiz
테이블 (7)
대여 (Loan)
- Loan ID (loan_id) — INT — 기본 키 — NOT NULL
- Book ID (book_id) — INT — 외래 키 → 도서.Book ID — NOT NULL
- Member ID (member_id) — INT — 외래 키 → 회원.Member ID — NOT NULL
- Loan Date (loan_date) — DATE
- Return Date (return_date) — DATE
- Overdue Flag (overdue_flag) — BOOLEAN
- Extension (extension) — BOOLEAN
도서 (Book)
- Book ID (book_id) — INT — 기본 키 — NOT NULL
- ISBN (isbn) — VARCHAR(100) — 외래 키 → 도서정보.ISBN — NOT NULL
- Reservation Status (reservation_status) — BOOLEAN
도서분류 (BookCategory)
- Category Code (category_Code) — VARCHAR — 기본 키 — NOT NULL
- Category Name (category_name) — VARCHAR
도서정보 (BookInfo)
- ISBN (isbn) — VARCHAR(100) — 기본 키 — NOT NULL
- Category Code (category_code) — VARCHAR — 외래 키 → 도서분류.Category Code — NOT NULL
- Author (author) — VARCHAR
- Publisher (publisher) — VARCHAR
- Publish Date (publish_date) — DATE
- Title (titleV) — VARCHAR
부록 (Supplement)
- Supplement Code (supplement_code) — INT — 기본 키 — NOT NULL
- Book ID (book_id) — INT — 외래 키 → 도서.Book ID — NOT NULL
- Supplement Name (supplement_name) — VARCHAR
예약 (Reservation)
- Member ID (member_id) — INT — 외래 키 → 회원.Member ID — NOT NULL
- Book ID (book_id) — INT — 외래 키 → 도서.Book ID — NOT NULL
- Reservation Date (reservation_date) — DATE
회원 (Member)
- Member ID (member_id) — INT — 기본 키 — NOT NULL
- Name (name) — VARCHAR(100)
- Grade (grade) — VARCHAR(100)
- Address (address) — VARCHAR(3000)
- Phone (phone_number) — VARCHAR(1000)
- Email (email) — VARCHAR(1000)