CampusLink

Overview

CampusLink is a sophisticated platform designed to bridge the gap between brands seeking marketing opportunities and college event organizers. The platform enables thousands of users across multiple schools to create, discover, and sponsor events, with secure payment processing, real-time messaging, and digital contract management. It serves as a complete ecosystem for campus event sponsorships, benefiting both brands looking to reach college audiences and student organizations seeking funding.

Key Features

• Brand-to-organizer matching system for event sponsorships
• Secure payment processing through Stripe integration
• Real-time chat with digital contract creation and signing
• Multi-school support with school-specific branding
• Comprehensive user profiles for brands, students, and organizations
• OAuth authentication and JWT-based authorization
• Admin dashboard with detailed analytics and approval workflows

Design & Structure

CampusLink employs a sophisticated architecture with SvelteKit powering the frontend and Cloudflare Workers providing serverless backend capabilities. The platform utilizes JWT-based authentication, role-based access control, and secure WebSocket connections for real-time features. The application leverages Cloudflare D1 (SQLite) for data persistence, with a carefully designed schema that supports complex relationships between users, events, sponsorships, and contracts.

Key Components

• Sponsorship Marketplace: Connects brands with event organizers
• Real-time Chat System: Facilitates negotiations between parties
• Digital Contract System: Enables creation, negotiation, and signing of sponsorship agreements
• Payment Processing: Secure handling of financial transactions via Stripe
• Multi-role User Profiles: Specialized interfaces for brands, students, and campus organizations
• Analytics Dashboard: Comprehensive metrics for both brands and event organizers
• Approval Workflow: Multi-stage process for event and sponsorship management

Project Structure

The application follows a modular architecture with clear separation of concerns. The frontend is organized into feature-based modules with shared components, while the backend implements a service-oriented approach with dedicated handlers for authentication, payments, messaging, and data operations. This structure ensures maintainability, scalability, and security across the platform.

// Example SvelteKit route handler for CampusLink
export const load = async ({ locals, params }) => {
  const { db } = locals;
  const { schoolId } = params;
  
  // Fetch school data
  const school = await db.prepare(
    'SELECT * FROM schools WHERE id = ?'
  ).bind(schoolId).first();
  
  // Fetch upcoming events for this school
  const events = await db.prepare(
    'SELECT * FROM events WHERE school_id = ? AND start_time > ? ORDER BY start_time'
  ).bind(schoolId, new Date().toISOString()).all();
  
  return {
    school,
    events: events.results
  };
};

Database Schema

CampusLink uses Cloudflare D1, which is a serverless SQL database built on SQLite. The database schema includes tables for schools, events, users, and more.

Technologies

API Endpoints

Here's a very non-comprehensive list of some of the endpoints from CampusLink:

Future Directions

Roadmap

• Enhanced analytics dashboard for event organizers
• Integration with social media platforms for event promotion
• Mobile application development
• Advanced search and filtering capabilities
• Event recommendation system based on user preferences