Company Review App

A full-stack application that allows users to leave and view company reviews.

• Search for companies
• Leave detailed reviews with ratings
• View all reviews for a company
• Responsive design with TailwindCSS

├── backend/
│   ├── database/
│   │   ├── migrations.ts    # Database schema setup
│   │   └── queries.ts       # Database query functions
│   └── routes/
│       └── api.ts          # API endpoints
│   ├── index.ts            # Main Hono server
├── frontend/
│   ├── components/
│   │   ├── App.tsx         # Main React component
│   │   ├── CompanySearch.tsx
│   │   ├── ReviewForm.tsx
│   │   └── ReviewList.tsx
│   ├── index.html          # Main HTML template
│   ├── index.tsx           # Frontend entry point
│   └── style.css           # Custom styles
└── shared/
    └── types.ts            # Shared TypeScript types

• GET /api/companies/search?q={query} - Search companies
• GET /api/companies/{id}/reviews - Get reviews for a company
• POST /api/reviews - Submit a new review
• GET /api/companies/{id} - Get company details

• id (INTEGER PRIMARY KEY)
• name (TEXT)
• industry (TEXT)
• website (TEXT)
• created_at (DATETIME)

• id (INTEGER PRIMARY KEY)
• company_id (INTEGER)
• reviewer_name (TEXT)
• position (TEXT)
• rating (INTEGER 1-5)
• title (TEXT)
• review_text (TEXT)
• pros (TEXT)
• cons (TEXT)
• created_at (DATETIME)