Prototype Implementation

The Ecore prototype is a full-stack web application (React + TypeScript frontend, Node.js/Express + Prisma backend) connected to the faculty PostgreSQL database (project schema) through an SSH tunnel. It implements the three most important use-cases documented in Phase P3, each backed by real SQL executed against the live database.

Implemented use-cases

• UseCase0001PrototypeImplementation – Admin creates and assigns a task to workers
• UseCase0002PrototypeImplementation – Client views project and task status
• UseCase0003PrototypeImplementation – Admin issues an invoice with line items

Technology

• Frontend: React 19 + TypeScript, Vite, React Router
• Backend: Node.js + Express 5, Prisma ORM 6
• Database: PostgreSQL (faculty project schema), accessed over an SSH tunnel
• Auth: JWT + bcrypt

Build and run instructions are documented on the BuildInstructions page.