Public trips, admin diagnostics, and a lightweight user portal.
Admin Console
Configuration, diagnostics, and operational visibility
This first slice is aimed at practical support work: runtime config, metadata field control, trip diagnostics, and a quick operational pulse.
Context
Offline demo mode
No auth
Users
248
Registered user rows.
Trips
731
68 public, 141 shared
Shares
187
24 pending invitations
Public stops
219
14 metadata definitions
Active today
0
Users with trip activity in the last 24 h
Active this week
0
Users with trip activity in the last 7 days
Active this month
0
Users with trip activity in the last 30 days
Moderation
Public trip visibility
All trips currently visible on the public discovery page. Unpublishing sets visibility to private immediately — the owner can re-publish at any time from their dashboard.
No public trips at the moment.
Reporting
Storage and export usage
Live counts from the export_request table and per-bucket storage usage (requires v_admin_storage_usage view — see DOCS/BACKLOG.md for SQL).
Export requests by status
Storage usage by bucket
Storage view unavailable — run v_admin_storage_usage migration.
Runtime Config
Editable config values
This table is intended for web flags, shared app settings, and later AI provider switches. Values are stored as JSON for forward compatibility.
shared
trip.location_options
Selectable visit metadata options for trip locations across mobile and web.
Public config
Save updates directly to Supabase runtime config
shared
trip.map_providers
Enabled trip map providers and outbound directions templates for mobile and web.
Public config
Save updates directly to Supabase runtime config
web
public.discovery
Public trip discovery page defaults and feature toggles.
Public config
Save updates directly to Supabase runtime config
TripLocation Metadata
Field definition controls
Enable or disable dynamic metadata fields without shipping a new mobile build.
| Field | Section | Type | Order | State | Action |
|---|---|---|---|---|---|
Recommended time recommended_minutes | visit | integer | 10 | Enable | |
Best time of day best_time_of_day | visit | select | 20 | Enable | |
Pet policy pet_policy | visit | select | 30 | Enable | |
Activities activity_types | visit | multiselect | 40 | Enable | |
Booking required booking_required | visit | boolean | 50 | Enable | |
Weather sensitive weather_sensitive | visit | boolean | 60 | Enable | |
Family friendly family_friendly | visit | boolean | 70 | Enable | |
Accessibility notes accessibility_notes | visit | multiline | 80 | Enable | |
Cost band cost_band | visit | select | 90 | Enable |
POI Catalog
Points of interest and filter definitions
Manage reusable POI catalog rows and the attribute definitions/options that drive mobile planning filters.
POI catalog rows
Edit existing POIs or insert new ones directly into the shared catalog.
Add POI row
Insert JSON with name, visibility, geo_location, optional place IDs, and attributes.
Attribute definitions
These definitions describe which POI attributes exist and how users can filter them.
Add attribute definition
Attribute options
Controlled choices for enum and multi-enum POI filters.
| Field | Name | Order |
|---|
Add attribute option
Insert JSON with definition_id, option_key, label, and sort_order.
PDF Studio
PDF template catalog
Manage database-backed PDF template rows. Changes take effect immediately without a redeploy, as long as they target a supported renderer family.
Add PDF template
Create a new catalog row by inserting JSON with `template_key`, `name`, `renderer_variant`, `orientation`, `page_size`, `design_tokens`, `is_active`, and `sort_order`.
Diagnostics
Recent trip diagnostics
| Trip | Owner | State | Shares | Public stops | Last sync | Updated |
|---|
Audit Trail
Recent admin changes
Templates
Curated trip starters
SA Outback Birding Loop
Outback centers, practical overnight rhythm, strong birding focus.
Eyre Peninsula Coastal Loop
Family-friendly South Australia coast loop with easy stopovers.
Next phase
PDF design studio
The website is the right place to define layout presets for itinerary exports, checklist printouts, and curated public trip summaries. The data contract is now ready to support that later stage.
Open preview studio