Skip to content
pking-hecsPublic

About

Resources

Stars

0 stars

Watchers

0 watching

Forks

Latest commit

Β 

History

69 Commits

Folders and files

NameName
Last commit message
Last commit date
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 

Repository files navigation

πŸš€ TeamFlow β€” Collaborative Project & Task Management

A lightweight, high-performance web application for efficient team collaboration and streamlined project management.

Live Demo React Node.js MySQL Vercel


πŸ“‹ Table of Contents


πŸ’‘ About

TeamFlow bridges the gap between overly simplistic tools like Trello and complex enterprise solutions like Jira. It focuses on core functionalities β€” authentication, team hierarchies, and visual task tracking β€” to ensure productivity without unnecessary overhead.

Built as a Database Systems Mini Project, this application demonstrates practical implementation of relational database concepts including normalization (3NF), referential integrity through foreign key constraints, and cascading operations.


✨ Features

Feature Description
πŸ” Secure Authentication JWT-based token auth with bcrypt password hashing
πŸ‘₯ Role-Based Teams Create teams with admin and member roles
πŸ“ Project Management Organize tasks into projects within teams
βœ… Task Tracking Tasks with descriptions, priorities, deadlines, and assignees
πŸ“Š Kanban Board Visual three-column board (To Do β†’ In Progress β†’ Done)
πŸ” Advanced Filtering Search and filter tasks by status, assignee, or priority
🎨 Modern UI Clean, responsive interface with smooth animations

πŸ›  Tech Stack

Frontend

Technology Purpose
React 18 Component-based UI
Redux Toolkit Global state management
React Router v7 Client-side routing
Axios HTTP client
Lucide React Icon library
Vite Build tool & dev server

Backend

Technology Purpose
Node.js Runtime environment
Express.js REST API framework
MySQL 8.0 Relational database
mysql2 Database driver
JWT Authentication tokens
bcrypt Password hashing

πŸ—„ Database Schema

The schema is normalized to Third Normal Form (3NF) with foreign key constraints and cascading operations for referential integrity.

β”Œβ”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”       β”Œβ”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”       β”Œβ”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”
β”‚    Users     β”‚       β”‚    Teams     β”‚       β”‚   Projects   β”‚
β”œβ”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€       β”œβ”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€       β”œβ”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€
β”‚ User_ID (PK) │──┐    β”‚ Team_ID (PK) │──┐    β”‚Project_ID(PK)β”‚
β”‚ User_Name    β”‚  β”‚    β”‚ Team_Name    β”‚  β”‚    β”‚ Title        β”‚
β”‚ Email_ID(UQ) β”‚  β”‚    β”‚ Creator_ID   β”‚β”€β”€β”˜    β”‚ Team_ID (FK) β”‚
β”‚ Password     β”‚  β”‚    β””β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”˜  β”‚    β”‚ Handled_By   β”‚
β””β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”˜  β”‚                      β”‚    β”‚ Deadline     β”‚
                  β”‚    β”Œβ”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”  β”‚    β””β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”˜
                  β”‚    β”‚  Membership  β”‚  β”‚           β”‚
                  β”‚    β”œβ”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€  β”‚    β”Œβ”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”
                  β”œβ”€β”€β”€β–Άβ”‚ User_ID (FK) β”‚  β”‚    β”‚    Tasks     β”‚
                  β”‚    β”‚ Team_ID (FK) │◀──    β”œβ”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€
                  β”‚    β”‚ Is_Admin     β”‚  β”‚    β”‚ Task_ID (PK) β”‚
                  β”‚    β””β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”˜  β”‚    β”‚ Task_Desc    β”‚
                  β”‚                      β”‚    β”‚ Deadline     β”‚
                  β”‚    β”Œβ”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”  β”‚    β”‚ Part_Of (FK) β”‚
                  β”‚    β”‚   Status     β”‚  β”‚    β”‚Assigned_To   β”‚
                  β”‚    β”œβ”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€  β”‚    β”‚Status_ID(FK) β”‚
                  β”‚    β”‚Status_ID(PK) β”‚β”€β”€β”˜    β””β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”˜
                  β”‚    β”‚ Status_Name  β”‚
                  β”‚    β””β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”˜
                  β”‚
                  └─── (Referenced by Teams.Creator_ID,
                        Tasks.Assigned_To, Membership.User_ID)

πŸ“ Project Structure

DBS-Mini-Project/
β”œβ”€β”€ client/                     # Frontend (React + Vite)
β”‚   β”œβ”€β”€ src/
β”‚   β”‚   β”œβ”€β”€ components/         # Reusable UI components
β”‚   β”‚   β”‚   β”œβ”€β”€ Navbar.jsx
β”‚   β”‚   β”‚   β”œβ”€β”€ TaskCard.jsx
β”‚   β”‚   β”‚   └── TeamCard.jsx
β”‚   β”‚   β”œβ”€β”€ pages/              # Application pages
β”‚   β”‚   β”‚   β”œβ”€β”€ Dashboard.jsx
β”‚   β”‚   β”‚   β”œβ”€β”€ Login.jsx
β”‚   β”‚   β”‚   β”œβ”€β”€ Register.jsx
β”‚   β”‚   β”‚   β”œβ”€β”€ Teams.jsx
β”‚   β”‚   β”‚   β”œβ”€β”€ TeamDetail.jsx
β”‚   β”‚   β”‚   └── Project.jsx
β”‚   β”‚   β”œβ”€β”€ services/           # API client configuration
β”‚   β”‚   β”œβ”€β”€ store/              # Redux state management
β”‚   β”‚   β”œβ”€β”€ hooks/              # Custom React hooks
β”‚   β”‚   └── utils/              # Utility functions
β”‚   β”œβ”€β”€ vercel.json             # Vercel SPA routing config
β”‚   └── vite.config.js
β”‚
β”œβ”€β”€ server/                     # Backend (Node.js + Express)
β”‚   β”œβ”€β”€ src/
β”‚   β”‚   β”œβ”€β”€ config/             # Environment configuration
β”‚   β”‚   β”œβ”€β”€ controllers/        # Request handlers
β”‚   β”‚   β”œβ”€β”€ db/                 # Database connection pool
β”‚   β”‚   β”œβ”€β”€ middleware/         # Auth middleware (JWT)
β”‚   β”‚   β”œβ”€β”€ migrations/        # SQL schema (init.sql)
β”‚   β”‚   β”œβ”€β”€ models/            # Data access layer
β”‚   β”‚   β”œβ”€β”€ routes/            # API route definitions
β”‚   β”‚   └── server.js          # Entry point
β”‚   └── vercel.json            # Vercel serverless config
β”‚
└── README.md

πŸš€ Getting Started

Prerequisites

  • Node.js v14+
  • MySQL Server 8.0+
  • npm or yarn

1. Clone the Repository

git clone https://github.com/pking-hecs/DBS-Mini-Project.git
cd DBS-Mini-Project

2. Database Setup

# Log into MySQL and import the schema
sudo mysql -u root < server/src/migrations/init.sql

This creates the dbsMP database with all required tables and sample data.

3. Backend Setup

cd server
npm install

Create a .env file in the server/ directory:

DB_HOST=localhost
DB_USER=root
DB_PASSWORD=your_mysql_password
DB_NAME=dbsMP
DB_PORT=3306
JWT_SECRET=your_secret_key_here

Start the server:

npm run dev

4. Frontend Setup

cd client
npm install
npm run dev

Open http://localhost:5173 in your browser.


πŸ“‘ API Endpoints

Authentication

Method Endpoint Description
POST /api/auth/signup Register a new user
POST /api/auth/login Login & receive JWT token
GET /api/auth/me Get current user profile

Teams

Method Endpoint Description
GET /api/teams List all teams for user
POST /api/teams Create a new team
GET /api/teams/:id Get team details
PATCH /api/teams/:id Update team
DELETE /api/teams/:id Delete team
POST /api/teams/:id/members Add team member
PATCH /api/teams/:id/members/:userId Update member role
DELETE /api/teams/:id/members/:userId Remove member

Projects

Method Endpoint Description
GET /api/projects?teamId= List projects for a team
POST /api/projects Create a project
GET /api/projects/:id Get project details
PUT /api/projects/:id Update project
DELETE /api/projects/:id Delete project

Tasks

Method Endpoint Description
GET /api/tasks List tasks (with filters)
POST /api/tasks Create a task
GET /api/tasks/:id Get task details
PUT /api/tasks/:id Update task
DELETE /api/tasks/:id Delete task

☁️ Deployment

The application is live and deployed on Vercel with Aiven MySQL as the cloud database.

Service Link
🌐 Frontend dbs-mini-project-zr8l.vercel.app
βš™οΈ Backend API Health dbs-mini-project-xi.vercel.app/api/health

Environment Variables (Vercel)

Backend Project:

Variable Description
DB_HOST Aiven MySQL hostname
DB_PORT Aiven MySQL port
DB_USER Database username
DB_PASSWORD Database password
DB_NAME Database name
JWT_SECRET Secret key for JWT tokens
CLIENT_URL Frontend URL (or *)

Frontend Project:

Variable Description
VITE_API_URL Backend deployment URL

πŸ‘₯ Contributors

Aditya Gayan Ayush Ashutosh Jena Naseh Ameen Sayrawala Tarun P

Built with ❀️ as a Database Systems Mini Project

About

Resources

Stars

0 stars

Watchers

0 watching

Forks

Releases

Packages

Contributors

Languages