test
테이블 (3)
대출 (LOAN)
- id (member_id) — BIGINT — 외래 키 → 멤버.id — NOT NULL
- Key (book_id) — BIGINT — 외래 키 → 책.Key — NOT NULL
- Field2 (status) — VARCHAR — NOT NULL
- Field2 (loan_date) — VARCHAR — NOT NULL
- Field (return_date) — NOT NULL
멤버 (MEMBER)
- id (member_id) — BIGINT — 기본 키 — NOT NULL
- 이름 (name) — VARCHAR — NOT NULL
- Field (id) — VARCHAR — NOT NULL
- Field2 (password) — VARCHAR — NOT NULL
- Field2 (phone) — VARCHAR — NOT NULL
- Field (jumin_no) — VARCHAR — NOT NULL
- Field (address) — VARCHAR — NOT NULL
책 (BOOK)
- Key (book_id) — BIGINT — 기본 키 — NOT NULL
- Field (ISBN) — VARCHAR(13) — NOT NULL
- Field (name) — VARCHAR(20) — NOT NULL
- Field4 (author) — VARCHAR(20) — NOT NULL
- Field (publisher) — VARCHAR(20) — NOT NULL
- Field2 (pub_date) — VARCHAR(20)