2024_db_기말과제
테이블 (3)
book
- Key (book_ID) — int(10) — 기본 키 — NOT NULL
- Field (title) — char(250)
- Field (author) — char(100)
- Field (category) — char(50)
loan
- Key (loan_ID) — int(10) — 기본 키 — NOT NULL
- Field (loan_Date) — date
- Field (return_Date) — date
- Key (user_ID) — int(10) — 외래 키 → user.Key — NOT NULL
- Key (book_ID) — int(10) — 외래 키 → book.Key — NOT NULL
user
- Key (user_ID) — int(10) — 기본 키 — NOT NULL
- Field (name) — char(50)
- Field (phone) — int(11)