Working prototype of milestone 1 for project #1660172. Tap through the phone: sign in with your department, open the map, filter services, search near a port, save providers, add a provider to the database. Providers, names and ratings are illustrative.
Find trusted services anywhere your yacht goes. Pick your department: the map opens with the filters you use most.
New here? Create account (same form, role is saved to the profile)
Every crew member can add a provider; an admin approves it before it goes public. That is how the database grows beyond the seed list.
This is the first milestone from the bid: a working map prototype with a provider database and filters. It runs in the browser so you can click it today; the real app is built in Flutter for iOS and Android from the same screens.
Map tiles: OpenStreetMap. In the published app the map is Google Maps or Mapbox SDK with offline caching for the saved list.
| Table | Key fields | Used for |
|---|---|---|
| users | id, email, name, role (captain / interior / exterior / engineering), yacht, home_port | sign-in, default filters, who added or reviewed what |
| providers | id, name, category_id, lat, lng, city, country, rating, hours, languages[], phone, messenger, website, status (pending / approved), added_by | pins on the map, near-port search (PostGIS geography index) |
| categories | id, name, department (one or many), icon, colour | filter chips, colours, role defaults |
| services | provider_id, title, price_note | what exactly a provider does (engine brands, flower delivery to the berth, 24h laundry) |
| reviews | provider_id, user_id, stars, text, yacht_size | rating; crew trusts crew |
| requests | user_id, provider_id, message, status, created_at | "Request" button, history in the profile, push on reply |
| saved | user_id, provider_id | Saved tab, offline cache |
Map prototype with the database and filters, exactly this scope in Flutter on a test build (TestFlight / internal track) for your review. Seed providers for the regions you name first.
review pointAccounts and roles, provider profiles, Save and Request, "Add a provider" with admin approval, web admin, push notifications.
review pointPolish, store assets, publishing to App Store and Google Play. From your side: Apple Developer and Google Play Console accounts. 2 revision rounds included, 14 days of fixes after release.
release