도서 대출
테이블 (3)
Book (books)
- Book (idx) — INT — 기본 키 — NOT NULL
- Title (title) — VARCHAR(30)
- Category (category) — VARCHAR(30)
- Rent_chk (state) — BOOLEAN
Member (members)
- Member (idx) — INT — 기본 키 — NOT NULL
- Email (email) — VARCHAR(30)
- Name (name) — VARCHAR(30)
Rent (rents)
- Rent (idx) — INT — 기본 키 — NOT NULL
- Member (member_id) — INT — 외래 키 → Member.Member — NOT NULL
- Book (book_id) — INT — 외래 키 → Book.Book — NOT NULL
- Rent_date (rent_date) — DATE
- Description (description) — VARCHAR(30)