2026-10-15
- Reference Data: Unified Country & Nationality Lookup —
migration
V86__seed_country_lookup_values.sqlseedslookup_valueswithcategory = 'COUNTRY'(Sri Lanka, UAE, Qatar, Saudi Arabia, Oman, Kuwait, Bahrain, Maldives, India, UK, USA, Australia, Canada, Singapore, Malaysia, Japan, China, Germany, France, Italy and 30+ more). Every nationality input now reads from it viaselectLookupOptionsByCategory(state, 'COUNTRY')—CustomerOnboardModal,EditCustomerModal(primary and dual nationality),PassportDetailsModal,TravelerFields(freeform<Input>replaced by a<Select>),OnboardingStepProfileandPersonalInfoTab— with a static fallback. Countries can be added, edited or retired from Admin Data → Reference Data (/admin/lookup-values) with no code change. - Architecture: Cloudflare R2 Soft-Delete Renaming (
deleted_Prefix) —FileStorageService.markFileDeleted(String fileKey)(implemented inR2FileStorageServiceImplwithCopyObjectRequest+DeleteObjectRequest) renames a deleted customer document, visa, ticket or photo to.../deleted_{filename}in R2 and persists the new key todocuments.file_keyalongsidedeleted_at = NOW(), so soft-deleted files are instantly recognisable in the bucket dashboard. The 04:00DocumentCleanupServiceretention job later purgesdeleted_objects after 30 days and removes the rows. Idempotent prefix handling is covered byR2FileStorageServiceImplTest. - Architecture: System Diagram, Document Lifecycle Flow & Scheduled Jobs Table — added a full-stack Mermaid architecture flowchart (client tier, Cloudflare + Nginx edge, Spring Boot 3.5 modular monolith, Supabase PostgreSQL, Cloudflare R2, SMTP, Grafana Loki), a four-phase sequence diagram for the document lifecycle (upload & annotation, presigned download, UI delete with R2 rename, 30-day cleanup), and a table of all 7 scheduled jobs with their cron schedules, purposes and manual trigger endpoints.
Last updated on