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