🤝
Borrowed Books
Read-Only ViewBooks lent to your account by other users. You have read-only visibility into book pages and notes while ownership remains with the lender.
🔒 Concurrency & Integrity: Books cannot be double-lent under concurrent requests. The PostgreSQL partial index
UNIQUE(book_id) WHERE returned_at IS NULL guarantees single active borrower state.