Book
Tables (5)
Book (book)
- 책번호 (book_id) — NOT NULL — Primary key — NOT NULL
- 책이름 (book_name) — NOT NULL
- 저자 (book_writer) — NOT NULL
- 출판사 (book_publisher) — NOT NULL
Member (mem)
- 회원번호 (mem_id) — NOT NULL — Primary key — NOT NULL
- 회원명 (mem_name) — NOT NULL — NOT NULL
- 생년월일 (mem_brithday) — NULL — NOT NULL
- 전화번호 (mem_phone) — NULL
- 등급 (mem_grade) — NOT NULL
Untitled (Rental)
- 책대여번호 (book_rent_no) — NOT NULL — Primary key — NOT NULL
- 대여일자 (rent_dt) — NOT NULL
- 예정반납일자 (ex_rent_dt) — NOT NULL
- 실제반납일자 (actually_rent_dt) — NOT NULL
- 회원번호 (mem_id) — NOT NULL — Foreign key → Member.회원번호 — NOT NULL
- 책번호 (book_id) — NOT NULL — Foreign key → Book.책번호 — NOT NULL
Untitled (Review)
- 작성일자 (writet_dt) — NOT NULL — Primary key — NOT NULL
- 책대여번호 (book_rent_no) — NOT NULL — Foreign key → Untitled.책대여번호 — NOT NULL
- 책후기내용 (book_rivew) — NOT NULL