A comprehensive application for digital marketing agencies to manage customer projects with real-time communication and project updates.

• Customer Portal: Customers can view and update their project details
• Project Management: Track project status, milestones, and deliverables
• Messaging System: Real-time communication between customers and agency
• File Sharing: Upload and share project assets
• Progress Tracking: Visual project timeline and status updates

├── backend/
│   ├── database/
│   │   ├── migrations.ts    # Database schema setup
│   │   └── queries.ts       # Database query functions
│   ├── routes/
│   │   ├── auth.ts         # Authentication routes
│   │   ├── projects.ts     # Project management routes
│   │   ├── messages.ts     # Messaging system routes
│   │   └── static.ts       # Static file serving
│   └── index.ts            # Main API entry point
├── frontend/
│   ├── components/
│   │   ├── App.tsx         # Main application component
│   │   ├── ProjectDashboard.tsx
│   │   ├── MessageCenter.tsx
│   │   └── ProjectForm.tsx
│   ├── index.html          # Main HTML template
│   ├── index.tsx           # Frontend entry point
│   └── style.css           # Custom styles
└── shared/
    ├── types.ts            # Shared TypeScript types
    └── utils.ts            # Shared utility functions

1. The application runs on the backend HTTP endpoint
2. Customers can access their projects via unique project IDs
3. Agency staff can manage all projects and communicate with customers
4. All data is stored in SQLite with automatic migrations

• GET / - Customer portal interface
• GET /api/projects - List all projects
• POST /api/projects - Create new project
• PUT /api/projects/:id - Update project
• GET /api/messages/:projectId - Get project messages
• POST /api/messages - Send new message