Help me build a referral system in Lovable that extends yesterday's analytics foundation:

BUSINESS CONTEXT: [Your business and the reward structure you designed above]

EXTEND EXISTING SYSTEM:
- Add referral tables that integrate with existing users/traffic_sources/revenue tables
- Generate unique referral codes linked to customer accounts  
- Track referral relationships through existing attribution system
- Calculate rewards automatically based on [your specific reward structure]
- Display referral performance in main dashboard alongside other traffic sources

REFERRAL SYSTEM FEATURES:
- Personal referral link generator for each customer
- Tracking when referral links are clicked and conversions happen
- Automatic reward delivery when qualification criteria are met
- Customer dashboard showing their referral activity and earned rewards

CUSTOMER EXPERIENCE:
- Easy way for customers to find and share their referral link
- Clear explanation of how rewards work and when they're delivered
- Simple sharing tools (email templates, social copy suggestions)
- Reward redemption or automatic delivery system

INTEGRATION REQUIREMENTS:
- Referral signups flow through existing traffic_sources tracking
- Referral conversions connect to existing sales attribution  
- Referral LTV tracking integrates with existing revenue analysis
- ROI comparison with other growth methods in unified dashboard

Build this as an extension of yesterday's foundation, not a separate system. Make access from my admin panel easy.
Work through this step by step with me, checking functionality along the way.