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