Kaizen Job Portal - August Fest 2025

A smart matchmaking platform for students and companies at August Fest 2025.

Features

• QR Code-based job applications
• AI-powered matching based on personality and skills
• Instant fitment score calculation
• Company job posting portal
• Student assessment system

Tech Stack

• Next.js 15
• React 19
• Tailwind CSS
• MySQL Database
• Prisma ORM

Database Setup

This project uses MySQL as the database backend. Follow these steps to set up the database:

1. Install MySQL

   Make sure you have MySQL installed and running on your system. You can download it from MySQL official website.

2. Configure Database Connection

   Update the .env file with your MySQL connection details:

   DATABASE_URL="mysql://username:password@localhost:3306/kaizen_job_portal"
   

   Replace username and password with your MySQL credentials.

3. Initialize the Database

   Run the database initialization script:

   npm run init-db

   This will create the database and run the Prisma migrations to set up the tables.

Database Schema

The database consists of the following tables:

• Company: Stores company information
• Job: Stores job listings created by companies
• Student: Stores student profiles and assessment data
• Application: Tracks job applications and fitment scores

Development

1. Install dependencies:

   npm install

2. Run the development server:

   npm run dev

3. Open http://localhost:3000 in your browser.

API Routes

• POST /api/jobs - Create a new job listing
• GET /api/jobs - Get all job listings
• GET /api/jobs/:id - Get a specific job by ID
• POST /api/applications - Create a student profile and/or job application
• GET /api/applications - Get all applications (can filter by student or job)

Deployment

Build the application for production:

npm run build

Start the production server:

npm start