Bookrent

Tables (6)

Book (도서 ID)

  • Key — Foreign key → Rental.Key — NOT NULL
  • id (int) — Foreign key → Rental.id — NOT NULL
  • Field

Book

  • Key (id) — Primary key — NOT NULL
  • Field (title)
  • Field2 (author)
  • Field3 (publisher)

Member (회원 ID)

  • id (int) — Primary key — NOT NULL
  • Field

Member

  • Key (id) — Primary key — NOT NULL
  • Field (name)
  • Field2 (age)
  • Field3 (joined_at)

Rental (대출ID)

  • Key — Primary key — NOT NULL
  • id (int) — Foreign key → Member.id — NOT NULL
  • Field

Untitled (Rental)

  • Key (id) — Primary key — NOT NULL
  • Key (id2) — Foreign key → Member.Key — NOT NULL
  • Key (id3) — Foreign key → Book.Key — NOT NULL
  • Field (member_id)
  • Field2 (book_id)
  • Field3 (due_date)