🔐 Authentication Flow (One-Time)
📤 Request
username + password
↓
POST /loginusername + password
📥 Response
User Info
↑
JWT TokenUser Info
Auth Service
🔑 Authentication
Validate Credentials
MD5 Hash Check
Generate JWT Token
Set Expiry
📤 Request
WHERE username
↓
SELECT * FROM adminWHERE username
📥 Response
password, role
↑
User Recordpassword, role
Admin Database
🗄️ MySQL
Admin Table
• username
• password (MD5)
• role
• permissions
⚙️ Business Logic Flow (Every Request)
📤 Request
Headers: Bearer JWT
↓
GET/POST/PUT/DELETEHeaders: Bearer JWT
📥 Response
Status Code
↑
JSON DataStatus Code
Services Layer
⚡ Node.js
Express
REST APIs
☕ Java
Spring Boot
Microservices
🐍 Python
Flask
Data APIs
📤 Request
INSERT / UPDATE / SELECT
↓
SQL / NoSQL QueryINSERT / UPDATE / SELECT
📥 Response
Affected Rows
↑
Query ResultsAffected Rows
Data Layer
🗄️ MySQL
Relational
Transactional
🍃 MongoDB
NoSQL
Documents
🔍 Elasticsearch
Search
Analytics
⚡ Redis
Cache
Session