Acquisition Ready
Data Architecture Overview
Clean, scalable data model designed for enterprise integration. Built for POS, payment processors, and coffee tech acquirers.
Core Data Models
Users & Accounts
5 tables
User
~500K
+15% monthly
UserPreferences
~500K
Synced
UserSubscription
~125K
+20% monthly
HSStudentVerification
~50K
+30% monthly
University
~3K
Stable
Relationships:
- •One-to-one with preferences
- •One-to-many with subscriptions
- •Many-to-many with deals via redemptions
Deals & Redemptions
5 tables
MerchantDeal
~10K
+5% monthly
Campaign
~2K
+25% monthly
RedemptionHistory
~1M
+40% monthly
SavedDeal
~200K
+18% monthly
ClaimedDeal
~800K
+35% monthly
Relationships:
- •Deals linked to merchants
- •Redemptions track user activity
- •Campaigns span multiple states
Merchants & Partners
5 tables
Merchant
~5K
+8% monthly
MerchantApplication
~1.2K
+10% monthly
Supplier
~300
+5% monthly
MCOProfile
~12
Stable
Influencer
~800
+12% monthly
Relationships:
- •Merchants create deals
- •Suppliers submit warehouse inventory
- •MCOs operate country markets
Analytics & Intelligence
4 tables
DealPerformanceMetrics
~10K
Daily refresh
CampaignEvent
~500K
+50% monthly
MCOPerformanceMetrics
~150
Monthly refresh
ApprovedMetrics
~5K
Weekly refresh
Relationships:
- •Aggregated from redemptions
- •Real-time event tracking
- •Segment-level rollups
Operations
5 tables
Notification
~2M
+45% monthly
Order
~100K
+30% monthly
VaultOrder
~15K
+22% monthly
WarehouseInventory
~5K
Variable
AdminAccessLog
~50K
Continuous
Relationships:
- •Orders tied to users and deals
- •Notifications triggered by events
- •Admin logs for compliance
Data Flow Patterns
1
User Registration
→ User Entity → Preferences → Subscription✓ Onboarding funnel tracked end-to-end
2
Deal Creation
→ MerchantDeal/Campaign → Approval → Distribution → Notifications✓ Deal lifecycle fully auditable
3
Redemption
→ ClaimedDeal → RedemptionHistory → Merchant Analytics → User Points✓ Real-time transaction tracking
4
Analytics
→ Raw Events → Aggregation → Metrics Tables → Intelligence Index✓ Multi-layer analytics architecture
Acquisition Readiness
Clean Data Model
- ✓Normalized schema with clear relationships
- ✓Consistent naming conventions
- ✓Indexed for performance at scale
- ✓Foreign keys enforced
API-First Architecture
- ✓RESTful endpoints for all core entities
- ✓Webhook support for real-time integrations
- ✓Rate limiting and authentication built-in
- ✓Versioned API (v2.0)
Security & Compliance
- ✓COPPA-compliant student verification
- ✓PII handling with parental consent
- ✓Admin access logs for audits
- ✓Secure payment processing (Stripe)
Technology Stack
Backend
Database:PostgreSQL
API:RESTful + Webhooks
Auth:JWT + OAuth
Payments:Stripe Connect
Integrations
CRM:HubSpot
SMS:Twilio
Analytics:Custom Intelligence Index
AI/LLM:GPT-4 (via integrations)