Skip to main content

Item Database (Core System)

Status: ✅ Complete (Core Features)
Last Updated: 2026-01-14

Overview​

Complete item database system with global item library, pricing, ownership tracking, lifecycle management, and usage tracking.

Implementation Details​

Global Item Library​

  • ✅ Items with categories, tags, photos, storage location, notes
  • ✅ Database schema, backend service, API routes, backend tests
  • ✅ Frontend ItemLibraryPage component with CRUD, search, filters, comprehensive tests

Item Pricing & Ownership​

  • ✅ Price and purchaseDate fields in Item model
  • ✅ Backend service supports pricing
  • ✅ Frontend form includes price and purchase date fields
  • ✅ Assign a price/value directly to an item (for already-owned items)
  • ✅ Link items to finance transactions (purchase, repair, resale) - Transaction.itemId field in schema, TransactionService supports itemId in create/update, API routes support itemId, backend tests cover item linking)

Item Lifecycle & Condition​

  • ✅ Condition field
  • ✅ ItemLoan model for lending
  • ✅ Backend service methods
  • ✅ API routes
  • ✅ Track condition states (new, used, damaged, repaired)
  • ✅ Lending flow (loan out, return, due date) linked to a Person (ItemLoan model, ItemService.createLoan/returnLoan methods, API routes)
  • ✅ Notes for repairs, damage history, and loans (notes field on Item and ItemLoan models)

Item Usage Tracking​

  • ✅ ItemUsageLog model
  • ✅ Backend service methods
  • ✅ API routes
  • ✅ Manual usage logs
  • ✅ Usage history per item (timeline view) - getUsageLogs method returns history

API Endpoints​

  • /api/items - Item CRUD
  • /api/items/:itemId/loans - Item loan management
  • /api/items/:itemId/usage - Item usage log management

Frontend Pages​

  • Item Library (/items)