Architecture
Database Schema Tree
Visual tree of all 102 SpacetimeDB tables grouped by domain, with primary relationships.
Database Schema Tree
LostChurn's SpacetimeDB module contains 102 tables organized across 14 domains. The mindmap below shows every table grouped by its functional area.
Table Hierarchy
Domain Relationship Map
The diagram below shows how the 14 domains connect through foreign-key relationships:
Table Counts by Domain
| Domain | Tables | Key Tables |
|---|---|---|
| Merchant & Config | 7 | merchant, integration, api_key |
| Customer | 6 | customer, customer_health_score |
| Payment & Decline | 4 | payment_event, decline_code_map |
| Recovery Pipeline | 10 | recovery_state, retry_attempt, failure_prediction |
| Campaign & Enrollment | 6 | campaign, campaign_enrollment, template |
| Cancel & Win-back | 10 | cancel_flow_session, exit_interview_session, winback_campaign |
| Email & Deliverability | 7 | email_provider_config, email_suppression, sender_domain |
| Webhook & Queues | 12 | webhook_delivery, email_queue, retry_execution_queue |
| Analytics & Reporting | 7 | analytics_rollup, cohort_snapshot, industry_benchmark |
| Routing & Optimization | 5 | routing_rule, routing_statistics, cascade_rule |
| A/B Testing & MAB | 4 | ab_test, mab_arm_state |
| CRM & Integrations | 7 | crm_sync_log, shopify_connection, slack_connection |
| AI & LLM | 3 | llm_prompt_template, llm_call_log |
| Admin & Compliance | 10 | audit_log, data_export_job, gdpr_domain_cleanup |
| Total | 102 |