Help me build a comprehensive analytics foundation in Lovable using Supabase that tracks the complete customer journey from traffic source to lifetime value:

BUSINESS CONTEXT: [Describe your business model, pricing, typical customer journey]

FOUNDATION REQUIREMENTS:

**DATABASE STRUCTURE:**
- traffic_sources table: source, medium, campaign, content, referral_code, utm_data, landing_page, timestamp, session_id
- users table: user_id, source_id (links to traffic_sources), signup_date, conversion_path
- conversions table: user_id, source_id, conversion_type (lead/trial/paid/upgrade), amount, timestamp
- revenue table: user_id, source_id, transaction_amount, transaction_date, cumulative_ltv

**TRACKING FEATURES:**
- Automatic UTM parameter capture for all traffic sources
- Unique tracking codes for partners and campaigns
- Full attribution chain from first touch to final purchase
- Conversion rate calculation by source
- Lifetime value tracking per customer and source
- Dashboard showing performance across all metrics

**MODULAR STRUCTURE:**
- Foundation that supports referral tracking module (Day 38)
- Structure for affiliate commission calculation (Day 40)
- Integration points for content feature tracking (Day 39)
- Easy extension without rebuilding core system

**DASHBOARD VIEWS:**
- Traffic source performance: volume, conversion rates, revenue
- Customer acquisition cost by source
- Lifetime value comparison across sources
- ROI calculation for each growth method
- Funnel analysis showing drop-off points

Build this as a solid foundation I can build upon. 
Build step by step, allow me to check and then we'll move to the next piece.