Support Domain¶

Team: Various (cross-cutting platform services)
Services: 9
Domain color: #64748b

Cross-cutting platform services including notifications, payments, loyalty rewards, analytics, weather, location services, media gallery, procurement, and reviews.

Topology¶

Services¶

Data Ownership¶

Every data entity has exactly one owning service. Other services access it read-only through APIs.

Data Stores¶

svc-notifications¶

• Engine: PostgreSQL 15 + Valkey 8
• Schema: notifications
• Tables: notifications, templates, delivery_log, channel_preferences
• Features:
  • Valkey queue for async delivery processing
  • Template versioning with rollback support
  • Multi-channel delivery: email, SMS, push, in-app
• Volume: ~15,000 notifications/day
• Backup: Daily pg_dump, 30-day retention

svc-payments¶

• Engine: PostgreSQL 15
• Schema: payments
• Tables: payments, refunds, payment_methods, daily_summaries, disputes, refund_policy_evaluations
• Features:
  • PCI-DSS compliant token storage (no raw card data)
  • Idempotent payment processing via request keys
  • Double-entry ledger for financial reconciliation
• Volume: ~2,500 transactions/day
• Backup: Continuous WAL archiving, daily base backup, 7-year retention (financial)

svc-loyalty-rewards¶

• Engine: Couchbase 7
• Schema: loyalty
• Tables: members, point_transactions, tiers, redemptions
• Features:
  • Document-oriented member profiles with flexible reward schemas
  • N1QL queries for tier recalculation and point aggregation
  • Sub-document operations for atomic point balance updates
• Volume: ~1,000 transactions/day
• Backup: XDCR to standby cluster, daily cbbackupmgr

svc-media-gallery¶

• Engine: PostgreSQL 15 + S3-Compatible Object Store
• Schema: media
• Tables: media_items, share_links, albums
• Features:
  • S3-compatible storage for photos and videos
  • Presigned URLs for secure direct upload and download
  • Automatic thumbnail generation on upload
• Volume: ~500 uploads/day peak season
• Backup: Daily pg_dump, S3 cross-region replication

svc-analytics¶

• Engine: Oracle Database 19c
• Schema: ANALYTICS
• Tables: BOOKING_METRICS, REVENUE_METRICS, UTILIZATION_METRICS, SATISFACTION_SCORES, SAFETY_METRICS, GUIDE_PERFORMANCE
• Features:
  • Oracle Partitioning for time-series data (range partitioning by month)
  • Materialized views with fast refresh for real-time dashboards
  • Oracle Advanced Analytics (DBMS_PREDICTIVE_ANALYTICS) for trend forecasting
• Volume: ~50K metric inserts/day (event-driven)
• Backup: Oracle RMAN incremental backup, 90-day retention

svc-weather¶

• Engine: Valkey 8 + PostgreSQL 15
• Schema: weather
• Tables: weather_stations, forecast_cache, alert_history
• Features:
  • Valkey TTL cache for current conditions (5-min TTL)
  • External weather API response caching and aggregation
  • Severe weather alert deduplication
• Volume: ~10K weather reads/day, ~100 external API fetches/day
• Backup: Daily pg_dump, 7-day retention (cache data is ephemeral)

svc-location-services¶

• Engine: PostGIS (PostgreSQL 15)
• Schema: locations
• Tables: locations, capacity_records, operating_hours
• Features:
  • PostGIS geometry for geofencing and proximity queries
  • Real-time capacity tracking with threshold alerts
  • Timezone-aware operating hours management
• Volume: ~100 updates/day, ~2K reads/day
• Backup: Daily pg_dump, 14-day retention

svc-inventory-procurement¶

• Engine: PostgreSQL 15
• Schema: procurement
• Tables: purchase_orders, po_line_items, suppliers, stock_levels, stock_adjustments, reorder_alerts
• Features:
  • Purchase order approval workflow with state machine
  • Automatic reorder point calculation based on consumption
  • Supplier lead time tracking for delivery estimates
• Volume: ~50 POs/day, ~200 stock adjustments/day
• Backup: Daily pg_dump, 30-day retention

svc-reviews¶

• Engine: PostgreSQL 15
• Schema: reviews
• Tables: reviews, review_helpful_votes, rating_aggregates
• Features:
  • Reservation-gated review submission (cross-ref svc-reservations)
  • Optimistic locking on review records (_rev field)
  • Pre-computed rating aggregates per trip and per guide
  • Full-text search on review body via tsvector index
• Volume: ~500 reviews/day, ~50,000 reads/day
• Backup: Daily pg_dump, 30-day retention

Bounded Context Rules¶

These rules are non-negotiable for this domain.

1. Notification delivery is multi-channel (email via SendGrid, SMS via Twilio, push via Firebase)
2. Payment processing integrates with external fraud detection before authorization
3. Analytics events flow via Kafka consumers — svc-analytics subscribes to all domain events
4. All support services are consumed by other domains but do not own core business data

Cross-Domain Integration¶

Outbound (this domain calls)¶

Inbound (called by other domains)¶

Domain Events¶

Events Produced¶

Consumers of these events:

• payment.processed → svc-reservations, svc-notifications

Events Consumed¶

Business Capabilities¶

Capabilities served by this domain's services.

Quick Links¶

• Domain Topology View
• svc-notifications Microservice Page
• svc-payments Microservice Page
• svc-loyalty-rewards Microservice Page
• svc-media-gallery Microservice Page
• svc-analytics Microservice Page
• svc-weather Microservice Page
• svc-location-services Microservice Page
• svc-inventory-procurement Microservice Page
• svc-reviews Microservice Page
• Event Catalog
• Business Capabilities

Generated from architecture/metadata/ YAML files by portal/scripts/generate-domain-pages.py.