Receipt Repository

Data access layer for all receipt records in the PostgreSQL database. Manages CRUD operations on the receipts table, maintains the foreign key relationship to the expenses table, and provides queries for retrieving receipts scoped to specific expenses or organizations. Enforces multi-tenant data isolation so receipt images are never accessible cross-tenant.

Feature: Receipt Photo Upload

receipt-repository

• Create receipt records with foreign key reference to parent expense
• Retrieve receipts by expense ID, user ID, or organization ID
• Delete receipt records and trigger storage object cleanup
• Enforce organization-scoped data isolation for all queries
• Support soft-delete and audit logging for compliance