Member
Tables (5)
Author (Untitled2)
- 저자 (author_name) — varchar — Primary key
- 나이 (age) — int
- 책이름 (book_name) — varchar
Book
- 책번호 (book_id) — int — Primary key
- 책이름 (book_name) — varchar
- 재고 (book_count) — varchar
- 저자 (author) — varchar
- 줄거리 (summary) — varchar
- 순위 (ranking) — int
- 출판사 (publisher) — varchar
- 저자 (author_name) — varchar — Foreign key → Author.저자
- 장르 (genre) — varchar
- 장르 (genre2) — varchar — Foreign key → genre.장르 — NOT NULL
Member
- pk — Integer — Primary key — NOT NULL
- 회원번호 (member_id) — varchar — Primary key
- 회원이름 (member_name) — varchar
- 휴대폰번호 (phone_number) — varchar
- 연채 (overdue) — int
- 주소 (address) — varchar
- 등급 (grade) — varchar
Rental
- pk — Integer — Primary key — NOT NULL
- 책번호 (book_id) — int — Foreign key → Book.책번호
- 회원번호 (member_id) — varchar — Foreign key → Member.회원번호
- 저자 (author_name2) — int — Foreign key → Book.저자
genre (Untitled)
- 장르 (genre) — varchar — Primary key — NOT NULL
- 공포 (horor) — varchar
- 판타지 (fantasy) — varchar
- 시 (poetry) — varchar