A comprehensive support system that allows users to submit assistance requests and engage in real-time chat with support staff.

• User Portal: Submit assistance requests with priority levels
• Admin Dashboard: Manage requests and respond to users
• Real-time Chat: Live messaging between users and support staff
• Status Tracking: Monitor request progress (Open → In Progress → Resolved)
• Priority Management: Handle urgent, normal, and low priority requests
• Message History: Complete chat history for each request

├── backend/
│   ├── database/
│   │   ├── migrations.ts    # Database schema setup
│   │   └── queries.ts       # Database query functions
│   ├── routes/
│   │   ├── api.ts          # API endpoints for requests and messages
│   │   └── static.ts       # Static file serving
│   └── index.ts            # Main Hono server
├── frontend/
│   ├── components/
│   │   ├── App.tsx         # Main application component
│   │   ├── UserPortal.tsx  # User request submission
│   │   ├── AdminDashboard.tsx # Admin interface
│   │   └── ChatWindow.tsx  # Real-time chat component
│   ├── index.html          # Main HTML template
│   ├── index.tsx           # Frontend entry point
│   └── style.css           # Custom styles
└── shared/
    └── types.ts            # Shared TypeScript types

1. Users: Access the main page to submit assistance requests
2. Admins: Use /admin to view and manage all requests
3. Chat: Click on any request to open the chat window

• GET /api/requests - Get all requests (admin) or user's requests
• POST /api/requests - Create new assistance request
• PUT /api/requests/:id - Update request status
• GET /api/messages/:requestId - Get chat messages for a request
• POST /api/messages - Send new chat message
• GET /api/events/:requestId - Server-sent events for real-time updates

• id, title, description, priority, status, user_email, created_at, updated_at

• id, request_id, sender_email, sender_type, message, created_at