By: Cleo Reyes, Ella Kim, Arushi Agarwal, Devanshi Desai

Our target audience consists of college students seeking unique, student-provided services, as well as student entrepreneurs looking to offer their skills and grow their businesses. Our platform aims to streamline this process by allowing service providers to easily showcase their offerings, whether it’s tutoring, nail services, keyboard building, or other specialized skills, while enabling service seekers to efficiently find and book what they need.

Beyond just connecting students, our goal is to create a safe, reliable, and community-driven marketplace where student entrepreneurs can establish their reputation, expand their reach, and gain real-world experience. To enhance engagement, our platform will integrate social features such as reviews, comments, posts, and messaging, making it more than just a marketplace, it’s a thriving ecosystem for student entrepreneurship.

College students often struggle to find affordable, high-quality services within their campus communities. Many specialized services are either unavailable nearby or come with high costs, forcing students to travel long distances or settle for expensive alternatives. Our platform provides a convenient and cost-effective solution by connecting them directly with fellow students who offer these services at competitive prices.

For student entrepreneurs, this application serves as a launchpad to showcase their skills, gain experience, and build a loyal customer base. By offering a structured yet flexible marketplace, we enable students to turn their passions into viable businesses while fostering a sense of community and mutual support.

We, as developers, want to build this application because we see a gap in the market for a student-driven service marketplace that fosters entrepreneurship, affordability, and community support. Many college students have skills and talents they can monetize, but they lack an accessible platform to showcase their services and connect with potential customers.

By developing this application, we aim to empower students by providing them with opportunities to gain real-world experience, build their businesses, and expand their networks. We are passionate about creating a seamless, user-friendly platform that encourages collaboration and trust within college communities. Additionally, we see this as an opportunity to apply our technical skills in designing an intuitive, scalable, and secure platform that can make a meaningful impact on students' lives.

CREATE TABLE users (
    id SERIAL PRIMARY KEY,
    name VARCHAR(255),
    profile_picture TEXT,
    email TEXT,
    phone_number TEXT,
    bio TEXT
);

CREATE TABLE services (
    id SERIAL PRIMARY KEY,
    user_id INT REFERENCES users(id),
    title VARCHAR(255),
    description TEXT,
    price DECIMAL,
    category VARCHAR(100),
    location TEXT,
    created_at TIMESTAMP DEFAULT NOW()
);

CREATE TABLE reviews (
    id SERIAL PRIMARY KEY,
    service_id INT REFERENCES services(id),
    user_id INT REFERENCES users(id),
    rating INT CHECK (rating BETWEEN 1 AND 5),
    comment TEXT,
    created_at TIMESTAMP DEFAULT NOW()
);

CREATE TABLE bookmarks (
    id SERIAL PRIMARY KEY
);

To run server:

cd server
npm run dev

To run client:

cd client
npm start