book_rent
Tables (4)
books (Untitled2)
- Key (book_id) — Primary key — NOT NULL
- Field (title)
- Field (writer)
- Field (buy_dt)
- Field (print_dt)
- Field (isbn)
- Field (price)
- Field (rent_yn)
- Field (shelves_id)
- Field (category)
disposal (Untitled4)
- Key (book_id) — Primary key — NOT NULL
- Field (title)
- Field (writer)
- Field (buy_dt)
- Field2 (print_dt)
- Field (isbn)
- Field (price)
- Field (category)
- Field (disposal_dt)
- Field (disposal_mgr_id)
rent_history (Untitled3)
- Key (seq) — Primary key — NOT NULL
- (user_id2) — Foreign key → users.user_id — NOT NULL
- Key (book_id2) — Foreign key → books.Key — NOT NULL
- Field (book_id)
- Field (user_id)
- Field (rent_dt)
- Field (return_dt)
- Field (penalty_days)
- Field (lost_yn)
users (Untitled)
- (user_id) — Primary key — NOT NULL
- Field (name)
- Field (phone)
- Field (address)
- Field (join_dt)
- Field (leave_yn)