HireTrack — Interview Pipeline CRM

A full-stack recruiting CRM to track job applications, OA deadlines, interviews, recruiter calls, and follow-ups in one slick dashboard.

Tech Stack: Next.js 16 · PostgreSQL · Prisma · Tailwind CSS v4 · TypeScript

---

Features

• Pipeline View — Visual circuit-board stage tracker per application (Wishlist → Applied → OA → Phone Screen → Technical → Onsite → Offer)
• Application Board — Grid/list view with search, priority filter, and urgency indicators
• Event Timeline — Per-application event log with OA, interviews, recruiter calls, follow-ups, deadlines
• Contacts — Store recruiters, hiring managers, and interviewers per application
• Calendar View — Monthly calendar showing all scheduled events
• Dashboard — Stats cards (response rate, active pipeline, offers) + upcoming events strip
• Status Management — One-click status updates with full audit trail
• Overdue Detection — Auto-highlights overdue tasks and upcoming deadlines

---

Getting Started

1. Prerequisites

• Node.js 18+
• PostgreSQL running locally (or a connection string from Supabase / Neon / Railway)

2. Clone & Install

git clone <your-repo>
cd interview-tracker
npm install

3. Configure Environment

cp .env.example .env

Edit .env and set your database URL:

DATABASE_URL="postgresql://postgres:password@localhost:5432/interview_tracker"

4. Initialize Database

# Generate Prisma client
npx prisma generate

# Push schema to your database
npx prisma db push

# (Optional) Seed with sample data
npx prisma db seed

5. Run

npm run dev

Open http://localhost:3000

---

Database Schema

Application
  ├── id, company, role, location, jobUrl, salary
  ├── status (WISHLIST → APPLIED → OA → PHONE_SCREEN → TECHNICAL → ONSITE → OFFER | REJECTED | WITHDRAWN)
  ├── priority (LOW | MEDIUM | HIGH | DREAM)
  ├── appliedAt, updatedAt, notes
  ├── events[]  →  Event (type, title, scheduledAt, deadline, completed, notes)
  └── contacts[]  →  Contact (name, role, email, linkedin, notes)

---

Scripts

Command	Description
npm run dev	Start dev server
npm run build	Production build
npx prisma studio	Visual DB browser
npx prisma db push	Sync schema to DB
npx prisma db seed	Load sample data

---

Deployment

Deploy to Vercel with a managed Postgres (Supabase / Neon / Railway):

1. Push to GitHub
2. Import project on Vercel
3. Add DATABASE_URL environment variable
4. Run npx prisma db push against production DB
5. Deploy ✓