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)