library

Tables (3)

Book

  • book_id (Key) — Long — Primary key — NOT NULL
  • title (Field) — String
  • author (Field2) — String
  • publisher (Field3) — String
  • language (Field4) — String
  • status (Field5) — String
  • created_at (Field6) — LocalDateTime
  • last_modified_at (Field7) — LocalDateTime

Borrow

  • borrow_id (Key) — Long — Primary key — NOT NULL
  • member_id (Key2) — Long — Foreign key → Member.member_id — NOT NULL
  • book_id (Key3) — Long — Foreign key → Book.book_id — NOT NULL
  • returned (Field2) — Boolean
  • penalty_applied (Field3) — Boolean
  • borrow_days (Field4) — Long
  • return_date (Field5) — LocalDateTime
  • created_at (Field6) — LocalDateTime
  • last_modified_at (Field7) — LocalDateTime

Member

  • member_id (Key) — Long — Primary key — NOT NULL
  • name (Field) — String
  • gender (Field2) — String
  • phone_number (Field3) — String
  • resident_registration_number (Field4) — String
  • address (Field5) — String
  • penalty (Field6) — Boolean
  • created_at (Field7) — LocalDateTime
  • last_modified_at (Field8) — LocalDateTime