Vet Tiaret — Modern Clinical Intake & Appointment Platform
Core Mission: Replace phone-tag bottlenecks with real-time symptom triage, guaranteed data integrity, and seamless bilingual clinic workflows.
1. Executive Summary
65%Reduction in staff phone call load
40%Cut in appointment no-show rates
< 3 minAverage intake completion speed
0Critical medical emergencies missed
2. The Core Problem: Why Off-The-Shelf Tools Failed
- No Medical Triage Layer: Generic booking apps treat a routine nail trim identically to a fatal gastric torsion. Staff had no way to intercept life-threatening emergencies.
- The Confirmation & "No-Show" Paradox: Automated self-service without clinic verification led to 30%+ ghost bookings and uncontactable clients.
- Local Linguistic Reality: Pet owners in Algeria alternate between French and Algerian Arabic. Existing tools offered broken translation and zero Right-to-Left (RTL) support.
- Data Fragmentation: When a pet returned, vets had no unified timeline linking past symptoms, prescriptions, and media attachments by phone number.
3. Product Strategy & UX Engineering
A. The 4-Step Cognitive-Load-Reduced Triage Wizard
- Step 1: Owner Identification: Name, verified phone number, and residential area.
- Step 2: Pet Profile: Instant visual selector for species (Dog, Cat, Bird, Exotic), breed, age, sex, and vaccination status (Rabies / Viral).
- Step 3: Biological System & Symptom Picker: Grouped by physiological systems (Digestive, Respiratory, Reproductive, Skin, General State, Urinary).
- Step 4: Summary & Instant Feedback: Clean summary card displaying estimated urgency and clinic instructions.
Typescript
B. Real-Time Emergency Detection Matrix
- The UI renders an immediate high-visibility emergency banner directing users to call the emergency line.
- The intake payload is tagged VisitCategory.EMERGENCY, automatically escalating the ticket to the top of the receptionist queue.
Symptom Selected: "Difficulté respiratoire" ──► Rule Match: [RESPIRATORY_EMERGENCY] ├── UI Action: Render High-Visibility Emergency Caution Banner ├── Tagging: Set category = VisitCategory.EMERGENCY (🔴) └── Backend Action: Bump Priority in Receptionist Call List
C. Bilingual RTL/LTR Theme Architecture
- Dynamic dir="rtl" and dir="ltr" attribute switching on root nodes.
- Logical CSS property mappings (ms-*, me-*, start-*, end-*) preventing layout breakages across languages.
- Culturally accurate colloquial terms rather than machine-translated medical terminology.
4. Deep Technical Architecture
A. Tech Stack & Rationale
B. Finite State Machine & Audit History Engine
Typescript
C. Smart Ephemeral Storage & Clinical Case Study CMS
- Ephemeral Triage Files: Uploaded media for ordinary consultations are kept only while active. When an appointment transitions to COMPLETED or CANCELLED, the system automatically purges the files from disk and removes relational attachment entries.
- Persistent Clinical Case Studies: When an interesting medical case is flagged by the veterinarian (AppointmentStatus.CASE_STUDY), the data and media are permanently transferred into the clinic's internal knowledge base and research catalog.
D. High-Performance Relational Indexing & Data Trimming
- Added composite indexes on ownerPhone and petName.
- Optimized calendar queries to UTC bounded ranges (gte: startOfDay, lte: endOfDay), avoiding unbounded database scans.
- Applied Prisma lean select clauses in RTK Query endpoints, shipping only the fields consumed by each individual UI view.
Prisma
5. Clinic Dashboard: Operational Workflows
1. The Receptionist "Call Queue"
- Color-coded badges for immediate triage (🔴 Emergency, 🟡 Consultation, 🟢 Vaccination, 🔵 Follow-Up).
- Direct call triggers with instant status toggles (Called - No Answer, Confirmed).
- Prevents double-booking and eliminates forgotten inquiries.
2. The Visual Daily Schedule & Staff Planning
- Time-slot grid displaying confirmed appointments grouped by veterinarian and treatment room.
- Dynamic duration allocation (15 min for vaccines vs. 45 min for complex pathology consultations).
- Drag-and-drop rescheduling with automated conflict detection.
3. Unified Patient History Search
- Receptionists or veterinarians enter a phone number to view all historical visits across all pets owned by that client.
- Instant access to historical diagnoses, vaccination logs, and past medical notes in under 200ms.
6. Key Takeaways & Engineering Insights
- UX is Healthcare Infrastructure: In veterinary medicine, an ambiguous dropdown or a slow form isn't just bad design—it delays patient care. Simplifying the intake flow directly improved emergency response times.
- State Machines Prevent Chaos: Managing clinic operations with loose status flags causes race conditions. Encoding the clinic's real-life protocol into a strict state machine with an audit log created total accountability for staff actions.
- Automate Storage Hygiene Early: Allowing media uploads without a retention and pruning policy is an operational debt. Pairing ephemeral file pruning with permanent case study archiving kept infrastructure costs near zero while building a valuable clinical library.
- Local UX Drives Organic Adoption: Providing true bilingual support with native RTL layout eliminated digital hesitancy, leading to immediate self-service adoption across diverse demographic groups.