# Database Design

Tables:
- users
- projects
- reports
- report_photos
- report_files
- report_comments
- report_status_logs
- project_user assignments for project technicians and supervisors
- audit_logs
- app_settings
- report_shares

Reports include archive metadata, including archived_at and archived_by, so completed records can be retained without cluttering active work.

Report shares store revocable public tokens, optional client email addresses, expiry timestamps, and last-viewed timestamps.