LikeLion_3

Tables (6)

User (Untitled)

  • 사용자명 (user_id) — Primary key — NOT NULL

book_category (Untitled4)

  • 카테고리명 (category_id) — Primary key — NOT NULL
  • name (category_name)

book_has_category (Untitled5)

  • id (map_id) — Primary key — NOT NULL
  • ISBN (book_ISBN) — Foreign key → book_list.ISBN — NOT NULL
  • 카테고리명 (category_id) — Foreign key → book_category.카테고리명 — NOT NULL

book_list (Untitled2)

  • ISBN (book_ISBN) — Primary key — NOT NULL
  • 제목 (book_name)
  • 저자 (book_writer)
  • 출판년도 (book_published_year)

lend_info (Untitled3)

  • 대여자명 (lend_id) — Primary key — NOT NULL
  • 사용자명 (user_id) — Foreign key → User.사용자명 — NOT NULL
  • ISBN (book_ISBN) — Foreign key → book_list.ISBN — NOT NULL
  • 대여날짜 (lend_date)
  • 반납기한 (lend_deadline)

overdue_info (Untitled6)

  • 연체자명 (overdue_id) — Primary key — NOT NULL
  • 대여자명 (lend_id) — Foreign key → lend_info.대여자명 — NOT NULL
  • 연체일수 (overdue_days)
  • 연체료 (overdue_fee)