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)