Ecosystem surface inventory

This file is generated from the repository and is a completeness guard, not a release claim. It answers what exists in source; the enterprise feature traceability ledger records whether each capability is unverified, partial, locally verified, or production released.

• Inventory digest: 1121c30247b0060e84d9
• Regenerate: pnpm docs:inventory
• Verify no drift: pnpm docs:inventory:check
• Runtime truth: production routes, permissions, schema, workers, and integrations still require deployed verification.

Inventory summary

Surface	Count	Completeness meaning
Web page boundaries	96	Every page boundary under the three Next.js App Routers
Web API boundaries	265	Every route handler under the three Next.js App Routers
Web UI modules	261	Every non-page TSX module under web app source roots
Mobile GoRouter routes	59	Every resolved GoRoute in both Flutter routers
Mobile screen/page files	50	Every Flutter *_screen.dart and *_page.dart file
Shared package source modules	162	Every TypeScript/TSX implementation module under packages/*/src
Migration-declared tables	168	Unique table names declared anywhere in migration history
Migration-declared views	16	Unique view names declared anywhere in migration history
Migration-declared functions	554	Unique function names declared anywhere in migration history
Migration-declared types	24	Unique PostgreSQL type names declared anywhere in migration history
Compose services	38	Top-level services in docker-compose.yml
Supabase Edge Functions	2	Function entrypoints present in source
Automated test files	1070	Tests in the explicitly enumerated ownership roots below

Audit findings generated from source

Check	Result	Evidence
API method extraction	Complete	Every API boundary exposes at least one statically discoverable HTTP method
Web route-flow coverage	Complete	Every Next.js page boundary is represented in the cross-application route-flow manifest
Mobile route-flow coverage	Complete	Every Flutter GoRoute is represented in the cross-application route-flow manifest

customer web application

40 page routes

Route	Source
/auth/complete-phone	apps/customer/src/app/auth/complete-phone/page.tsx
/auth/complete-profile	apps/customer/src/app/auth/complete-profile/page.tsx
/auth/login	apps/customer/src/app/auth/login/page.tsx
/auth/recover-account	apps/customer/src/app/auth/recover-account/page.tsx
/auth/register	apps/customer/src/app/auth/register/page.tsx
/auth/verify-email	apps/customer/src/app/auth/verify-email/page.tsx
/auth/verify	apps/customer/src/app/auth/verify/page.tsx
/book/[tripId]	apps/customer/src/app/book/[tripId]/page.tsx
/bookings/[id]/cancel	apps/customer/src/app/bookings/[id]/cancel/page.tsx
/bookings/[id]/modify	apps/customer/src/app/bookings/[id]/modify/page.tsx
/bookings/[id]	apps/customer/src/app/bookings/[id]/page.tsx
/bookings/[id]/ticket	apps/customer/src/app/bookings/[id]/ticket/page.tsx
/bookings	apps/customer/src/app/bookings/page.tsx
/companies/[slug]	apps/customer/src/app/companies/[slug]/page.tsx
/customer-auth/login	apps/customer/src/app/customer-auth/login/page.tsx
/demo	apps/customer/src/app/demo/page.tsx
/download	apps/customer/src/app/download/page.tsx
/en	apps/customer/src/app/en/page.tsx
/favorites	apps/customer/src/app/favorites/page.tsx
/find-booking	apps/customer/src/app/find-booking/page.tsx
/journey-orders/[orderId]/checkout	apps/customer/src/app/journey-orders/[orderId]/checkout/page.tsx
/journey-orders/[orderId]/confirmation	apps/customer/src/app/journey-orders/[orderId]/confirmation/page.tsx
/journeys/[bookingId]/checkout	apps/customer/src/app/journeys/[bookingId]/checkout/page.tsx
/journeys/[bookingId]/confirmation	apps/customer/src/app/journeys/[bookingId]/confirmation/page.tsx
/journeys/[bookingId]/tracking	apps/customer/src/app/journeys/[bookingId]/tracking/page.tsx
/loyalty	apps/customer/src/app/loyalty/page.tsx
/offline	apps/customer/src/app/offline/page.tsx
/	apps/customer/src/app/page.tsx
/privacy	apps/customer/src/app/privacy/page.tsx
/profile/edit	apps/customer/src/app/profile/edit/page.tsx
/profile	apps/customer/src/app/profile/page.tsx
/search	apps/customer/src/app/search/page.tsx
/settings	apps/customer/src/app/settings/page.tsx
/share/[grantId]	apps/customer/src/app/share/[grantId]/page.tsx
/support/[id]	apps/customer/src/app/support/[id]/page.tsx
/support/new	apps/customer/src/app/support/new/page.tsx
/support	apps/customer/src/app/support/page.tsx
/terms	apps/customer/src/app/terms/page.tsx
/trips/[id]	apps/customer/src/app/trips/[id]/page.tsx
/trips	apps/customer/src/app/trips/page.tsx

96 API routes

Route	Methods	Source
/api/auth/customer/complete-phone	POST OPTIONS	apps/customer/src/app/api/auth/customer/complete-phone/route.ts
/api/auth/customer/google/mobile	POST	apps/customer/src/app/api/auth/customer/google/mobile/route.ts
/api/auth/customer/google/nonce	GET	apps/customer/src/app/api/auth/customer/google/nonce/route.ts
/api/auth/customer/google/pwa	POST OPTIONS	apps/customer/src/app/api/auth/customer/google/pwa/route.ts
/api/auth/customer/google/web	POST	apps/customer/src/app/api/auth/customer/google/web/route.ts
/api/auth/customer/logout	POST OPTIONS	apps/customer/src/app/api/auth/customer/logout/route.ts
/api/auth/customer/me	GET OPTIONS	apps/customer/src/app/api/auth/customer/me/route.ts
/api/auth/customer/recover/init	POST OPTIONS	apps/customer/src/app/api/auth/customer/recover/init/route.ts
/api/auth/customer/recover/send-otp	POST OPTIONS	apps/customer/src/app/api/auth/customer/recover/send-otp/route.ts
/api/auth/customer/recover/verify	POST OPTIONS	apps/customer/src/app/api/auth/customer/recover/verify/route.ts
/api/auth/customer/refresh	POST OPTIONS	apps/customer/src/app/api/auth/customer/refresh/route.ts
/api/auth/customer/resend-verification	POST OPTIONS	apps/customer/src/app/api/auth/customer/resend-verification/route.ts
/api/auth/customer/send-email-code	POST OPTIONS	apps/customer/src/app/api/auth/customer/send-email-code/route.ts
/api/auth/customer/send-otp	POST OPTIONS	apps/customer/src/app/api/auth/customer/send-otp/route.ts
/api/auth/customer/verify-email-code	POST OPTIONS	apps/customer/src/app/api/auth/customer/verify-email-code/route.ts
/api/auth/customer/verify-email	GET POST OPTIONS	apps/customer/src/app/api/auth/customer/verify-email/route.ts
/api/auth/customer/verify-otp	POST OPTIONS	apps/customer/src/app/api/auth/customer/verify-otp/route.ts
/api/auth/driver/2fa/enable	POST OPTIONS	apps/customer/src/app/api/auth/driver/2fa/enable/route.ts
/api/auth/driver/2fa/setup	POST OPTIONS	apps/customer/src/app/api/auth/driver/2fa/setup/route.ts
/api/auth/driver/2fa/verify	POST OPTIONS	apps/customer/src/app/api/auth/driver/2fa/verify/route.ts
/api/auth/driver/login	POST OPTIONS	apps/customer/src/app/api/auth/driver/login/route.ts
/api/auth/driver/send-otp	POST OPTIONS	apps/customer/src/app/api/auth/driver/send-otp/route.ts
/api/auth/driver/verify-otp	POST OPTIONS	apps/customer/src/app/api/auth/driver/verify-otp/route.ts
/api/booking-flow	GET POST DELETE OPTIONS	apps/customer/src/app/api/booking-flow/route.ts
/api/bookings/[id]/billing-address	GET PUT OPTIONS	apps/customer/src/app/api/bookings/[id]/billing-address/route.ts
/api/bookings/[id]/cancel	POST OPTIONS	apps/customer/src/app/api/bookings/[id]/cancel/route.ts
/api/bookings/[id]/document	GET OPTIONS	apps/customer/src/app/api/bookings/[id]/document/route.ts
/api/bookings/[id]/payments	GET OPTIONS	apps/customer/src/app/api/bookings/[id]/payments/route.ts
/api/bookings/[id]/receipt	GET OPTIONS	apps/customer/src/app/api/bookings/[id]/receipt/route.ts
/api/bookings/[id]	GET PATCH OPTIONS	apps/customer/src/app/api/bookings/[id]/route.ts
/api/bookings/batch	POST OPTIONS	apps/customer/src/app/api/bookings/batch/route.ts
/api/bookings/lookup	POST OPTIONS	apps/customer/src/app/api/bookings/lookup/route.ts
/api/bookings/qr/[id]	GET OPTIONS	apps/customer/src/app/api/bookings/qr/[id]/route.ts
/api/bookings/round-trip	POST OPTIONS	apps/customer/src/app/api/bookings/round-trip/route.ts
/api/bookings	GET POST OPTIONS	apps/customer/src/app/api/bookings/route.ts
/api/cities	GET OPTIONS	apps/customer/src/app/api/cities/route.ts
/api/companies/[id]/payment-settings	GET OPTIONS	apps/customer/src/app/api/companies/[id]/payment-settings/route.ts
/api/companies/[id]	GET OPTIONS	apps/customer/src/app/api/companies/[id]/route.ts
/api/customer	GET OPTIONS	apps/customer/src/app/api/customer/route.ts
/api/demo/access	POST OPTIONS	apps/customer/src/app/api/demo/access/route.ts
/api/document-shares/[grantId]/accept	POST OPTIONS	apps/customer/src/app/api/document-shares/[grantId]/accept/route.ts
/api/document-shares/[grantId]/document	GET OPTIONS	apps/customer/src/app/api/document-shares/[grantId]/document/route.ts
/api/document-shares/[grantId]/preview	POST OPTIONS	apps/customer/src/app/api/document-shares/[grantId]/preview/route.ts
/api/document-shares/[grantId]/revoke	POST OPTIONS	apps/customer/src/app/api/document-shares/[grantId]/revoke/route.ts
/api/document-shares/[grantId]/session	GET OPTIONS	apps/customer/src/app/api/document-shares/[grantId]/session/route.ts
/api/document-shares	POST OPTIONS	apps/customer/src/app/api/document-shares/route.ts
/api/favorites	GET POST DELETE OPTIONS	apps/customer/src/app/api/favorites/route.ts
/api/health	GET OPTIONS	apps/customer/src/app/api/health/route.ts
/api/journey-locations	GET OPTIONS	apps/customer/src/app/api/journey-locations/route.ts
/api/journey-orders/[orderId]/confirm	POST OPTIONS	apps/customer/src/app/api/journey-orders/[orderId]/confirm/route.ts
/api/journey-orders/[orderId]/hold	POST OPTIONS	apps/customer/src/app/api/journey-orders/[orderId]/hold/route.ts
/api/journey-orders/[orderId]/holds/[holdBatchId]	DELETE OPTIONS	apps/customer/src/app/api/journey-orders/[orderId]/holds/[holdBatchId]/route.ts
/api/journey-orders/[orderId]	GET OPTIONS	apps/customer/src/app/api/journey-orders/[orderId]/route.ts
/api/journey-orders/quote	POST OPTIONS	apps/customer/src/app/api/journey-orders/quote/route.ts
/api/journeys/[bookingId]/cancellation	GET POST OPTIONS	apps/customer/src/app/api/journeys/[bookingId]/cancellation/route.ts
/api/journeys/[bookingId]/confirm	POST OPTIONS	apps/customer/src/app/api/journeys/[bookingId]/confirm/route.ts
/api/journeys/[bookingId]/hold	POST OPTIONS	apps/customer/src/app/api/journeys/[bookingId]/hold/route.ts
/api/journeys/[bookingId]/holds/[holdBatchId]	DELETE OPTIONS	apps/customer/src/app/api/journeys/[bookingId]/holds/[holdBatchId]/route.ts
/api/journeys/[bookingId]	GET OPTIONS	apps/customer/src/app/api/journeys/[bookingId]/route.ts
/api/journeys/[bookingId]/tracking	GET OPTIONS	apps/customer/src/app/api/journeys/[bookingId]/tracking/route.ts
/api/journeys/history	GET OPTIONS	apps/customer/src/app/api/journeys/history/route.ts
/api/journeys/quote	POST OPTIONS	apps/customer/src/app/api/journeys/quote/route.ts
/api/journeys/search	POST OPTIONS	apps/customer/src/app/api/journeys/search/route.ts
/api/landing/routes	GET OPTIONS	apps/customer/src/app/api/landing/routes/route.ts
/api/landing/stats	GET OPTIONS	apps/customer/src/app/api/landing/stats/route.ts
/api/landing/testimonials	GET OPTIONS	apps/customer/src/app/api/landing/testimonials/route.ts
/api/loyalty/account	GET OPTIONS	apps/customer/src/app/api/loyalty/account/route.ts
/api/loyalty/preview	POST OPTIONS	apps/customer/src/app/api/loyalty/preview/route.ts
/api/loyalty/redeem	POST OPTIONS	apps/customer/src/app/api/loyalty/redeem/route.ts
/api/loyalty/referral	GET POST	apps/customer/src/app/api/loyalty/referral/route.ts
/api/loyalty/rewards	GET OPTIONS	apps/customer/src/app/api/loyalty/rewards/route.ts
/api/loyalty/transactions	GET OPTIONS	apps/customer/src/app/api/loyalty/transactions/route.ts
/api/payments/[id]/cancel	POST OPTIONS	apps/customer/src/app/api/payments/[id]/cancel/route.ts
/api/payments/[id]	GET OPTIONS	apps/customer/src/app/api/payments/[id]/route.ts
/api/payments/[id]/verify	POST OPTIONS	apps/customer/src/app/api/payments/[id]/verify/route.ts
/api/payments/create	POST OPTIONS	apps/customer/src/app/api/payments/create/route.ts
/api/payments	POST OPTIONS	apps/customer/src/app/api/payments/route.ts
/api/profile	GET PUT PATCH OPTIONS	apps/customer/src/app/api/profile/route.ts
/api/profile/security/identities/google	POST OPTIONS	apps/customer/src/app/api/profile/security/identities/google/route.ts
/api/profile/security/identities	GET DELETE OPTIONS	apps/customer/src/app/api/profile/security/identities/route.ts
/api/profile/security/sign-ins	GET OPTIONS	apps/customer/src/app/api/profile/security/sign-ins/route.ts
/api/profile/stats	GET OPTIONS	apps/customer/src/app/api/profile/stats/route.ts
/api/push/subscribe	POST OPTIONS	apps/customer/src/app/api/push/subscribe/route.ts
/api/push/unsubscribe	POST OPTIONS	apps/customer/src/app/api/push/unsubscribe/route.ts
/api/reviews/company/[companyId]	GET OPTIONS	apps/customer/src/app/api/reviews/company/[companyId]/route.ts
/api/reviews	GET POST OPTIONS	apps/customer/src/app/api/reviews/route.ts
/api/routes/popular	GET OPTIONS	apps/customer/src/app/api/routes/popular/route.ts
/api/settings/reminders	GET PUT OPTIONS	apps/customer/src/app/api/settings/reminders/route.ts
/api/tickets/[id]/messages	GET POST OPTIONS	apps/customer/src/app/api/tickets/[id]/messages/route.ts
/api/tickets/[id]	GET POST OPTIONS	apps/customer/src/app/api/tickets/[id]/route.ts
/api/tickets	GET POST OPTIONS	apps/customer/src/app/api/tickets/route.ts
/api/trips/[id]/messages	GET POST OPTIONS	apps/customer/src/app/api/trips/[id]/messages/route.ts
/api/trips/[id]	GET OPTIONS	apps/customer/src/app/api/trips/[id]/route.ts
/api/trips/[id]/seats/lock	GET POST DELETE	apps/customer/src/app/api/trips/[id]/seats/lock/route.ts
/api/trips/[id]/seats	GET OPTIONS	apps/customer/src/app/api/trips/[id]/seats/route.ts
/api/trips	GET OPTIONS	apps/customer/src/app/api/trips/route.ts

113 UI modules

• apps/customer/src/app/book/[tripId]/loading.tsx
• apps/customer/src/app/book/error.tsx
• apps/customer/src/app/bookings/[id]/loading.tsx
• apps/customer/src/app/bookings/[id]/ticket/layout.tsx
• apps/customer/src/app/bookings/error.tsx
• apps/customer/src/app/bookings/loading.tsx
• apps/customer/src/app/companies/[slug]/company-profile-client.tsx
• apps/customer/src/app/companies/[slug]/loading.tsx
• apps/customer/src/app/error.tsx
• apps/customer/src/app/favorites/loading.tsx
• apps/customer/src/app/layout.tsx
• apps/customer/src/app/loading.tsx
• apps/customer/src/app/loyalty/layout.tsx
• apps/customer/src/app/loyalty/loading.tsx
• apps/customer/src/app/not-found.tsx
• apps/customer/src/app/profile/loading.tsx
• apps/customer/src/app/support/loading.tsx
• apps/customer/src/app/trips/[id]/loading.tsx
• apps/customer/src/app/trips/error.tsx
• apps/customer/src/app/trips/loading.tsx
• apps/customer/src/components/admin/permission-guard.tsx
• apps/customer/src/components/auth/google-icon.tsx
• apps/customer/src/components/auth/traveler-authentication-shell.tsx
• apps/customer/src/components/auth/traveler-google-sign-in.tsx
• apps/customer/src/components/booking-details-card.tsx
• apps/customer/src/components/booking/billing-address-card.tsx
• apps/customer/src/components/booking/booking-skeleton.tsx
• apps/customer/src/components/booking/booking-step-indicator.tsx
• apps/customer/src/components/booking/company-trust-card.tsx
• apps/customer/src/components/booking/confetti-burst.tsx
• apps/customer/src/components/booking/dynamic-seat-map.tsx
• apps/customer/src/components/booking/price-breakdown-card.tsx
• apps/customer/src/components/booking/qr-code.tsx
• apps/customer/src/components/booking/seat-legend.tsx
• apps/customer/src/components/booking/seat-lock-banner.tsx
• apps/customer/src/components/booking/seat-map.tsx
• apps/customer/src/components/booking/seat-picker.tsx
• apps/customer/src/components/booking/seat.tsx
• apps/customer/src/components/booking/ticket-print.tsx
• apps/customer/src/components/booking/ticket.tsx
• apps/customer/src/components/booking/what-happens-next.tsx
• apps/customer/src/components/bookings/booking-card-countdown.tsx
• apps/customer/src/components/bookings/booking-card.tsx
• apps/customer/src/components/bookings/bookings-filter.tsx
• apps/customer/src/components/bookings/bookings-skeleton.tsx
• apps/customer/src/components/charts/area-chart.tsx
• apps/customer/src/components/charts/bar-chart.tsx
• apps/customer/src/components/charts/heatmap-chart.tsx
• apps/customer/src/components/charts/line-chart.tsx
• apps/customer/src/components/charts/pie-chart.tsx
• apps/customer/src/components/city-selector.tsx
• apps/customer/src/components/customer-layout.tsx
• apps/customer/src/components/dashboard/suspension-banner.tsx
• apps/customer/src/components/dashboard/warning-banner.tsx
• apps/customer/src/components/date-picker.tsx
• apps/customer/src/components/documents/secure-document-share.tsx
• apps/customer/src/components/documents/shared-document-recipient.tsx
• apps/customer/src/components/error-tracking-init.tsx
• apps/customer/src/components/journeys/checkout-primitives.tsx
• apps/customer/src/components/journeys/journey-cancellation-panel.tsx
• apps/customer/src/components/journeys/journey-ticket-qr.tsx
• apps/customer/src/components/landing/HeroSearchForm.tsx
• apps/customer/src/components/landing/LandingHeader.tsx
• apps/customer/src/components/landing/LandingPage.tsx
• apps/customer/src/components/landing/Reveal.tsx
• apps/customer/src/components/landing/SyriaCoverageMap.tsx
• apps/customer/src/components/landing/TravelerHomeJourney.tsx
• apps/customer/src/components/language-switcher.tsx
• apps/customer/src/components/layout/header.tsx
• apps/customer/src/components/layout/page-header.tsx
• apps/customer/src/components/layout/sidebar.tsx
• apps/customer/src/components/legal-document.tsx
• apps/customer/src/components/loyalty/loyalty-card.tsx
• apps/customer/src/components/loyalty/points-history.tsx
• apps/customer/src/components/loyalty/reward-card.tsx
• apps/customer/src/components/loyalty/tier-progress.tsx
• apps/customer/src/components/profile/connected-sign-in-methods.tsx
• apps/customer/src/components/profile/notifications-card.tsx
• apps/customer/src/components/profile/profile-stats-card.tsx
• apps/customer/src/components/profile/security-panel.tsx
• apps/customer/src/components/PWAProvider.tsx
• apps/customer/src/components/trips/pickup-location-card.tsx
• apps/customer/src/components/ui/avatar.tsx
• apps/customer/src/components/ui/badge.tsx
• apps/customer/src/components/ui/button.tsx
• apps/customer/src/components/ui/card.tsx
• apps/customer/src/components/ui/confirm-dialog.tsx
• apps/customer/src/components/ui/date-picker.tsx
• apps/customer/src/components/ui/date-range-picker.tsx
• apps/customer/src/components/ui/dropdown-menu.tsx
• apps/customer/src/components/ui/empty-state.tsx
• apps/customer/src/components/ui/error-boundary.tsx
• apps/customer/src/components/ui/input.tsx
• apps/customer/src/components/ui/modal.tsx
• apps/customer/src/components/ui/pagination.tsx
• apps/customer/src/components/ui/progress.tsx
• apps/customer/src/components/ui/route-error.tsx
• apps/customer/src/components/ui/search-input.tsx
• apps/customer/src/components/ui/select.tsx
• apps/customer/src/components/ui/skeleton-blocks.tsx
• apps/customer/src/components/ui/skeleton.tsx
• apps/customer/src/components/ui/stat.tsx
• apps/customer/src/components/ui/switch.tsx
• apps/customer/src/components/ui/table.tsx
• apps/customer/src/components/ui/tabs.tsx
• apps/customer/src/components/ui/textarea.tsx
• apps/customer/src/components/ui/time-picker.tsx
• apps/customer/src/components/ui/toast.tsx
• apps/customer/src/components/ui/toaster.tsx
• apps/customer/src/components/ui/tooltip.tsx
• apps/customer/src/lib/auth/auth-guard.tsx
• apps/customer/src/lib/auth/customer-auth-context.tsx
• apps/customer/src/providers/query-provider.tsx

dashboard web application

38 page routes

Route	Source
/account	apps/dashboard/src/app/account/page.tsx
/account/security	apps/dashboard/src/app/account/security/page.tsx
/analytics	apps/dashboard/src/app/analytics/page.tsx
/bookings/[id]	apps/dashboard/src/app/bookings/[id]/page.tsx
/bookings	apps/dashboard/src/app/bookings/page.tsx
/buses/[id]/layout	apps/dashboard/src/app/buses/[id]/layout/page.tsx
/buses/new	apps/dashboard/src/app/buses/new/page.tsx
/buses	apps/dashboard/src/app/buses/page.tsx
/demo/access	apps/dashboard/src/app/demo/access/page.tsx
/drivers/[id]/edit	apps/dashboard/src/app/drivers/[id]/edit/page.tsx
/drivers/[id]	apps/dashboard/src/app/drivers/[id]/page.tsx
/drivers/new	apps/dashboard/src/app/drivers/new/page.tsx
/drivers	apps/dashboard/src/app/drivers/page.tsx
/feedback	apps/dashboard/src/app/feedback/page.tsx
/login	apps/dashboard/src/app/login/page.tsx
/loyalty	apps/dashboard/src/app/loyalty/page.tsx
/office-booking/new	apps/dashboard/src/app/office-booking/new/page.tsx
/office-booking	apps/dashboard/src/app/office-booking/page.tsx
/	apps/dashboard/src/app/page.tsx
/payments	apps/dashboard/src/app/payments/page.tsx
/pending	apps/dashboard/src/app/pending/page.tsx
/reports	apps/dashboard/src/app/reports/page.tsx
/routes/[id]/edit	apps/dashboard/src/app/routes/[id]/edit/page.tsx
/routes/new	apps/dashboard/src/app/routes/new/page.tsx
/routes	apps/dashboard/src/app/routes/page.tsx
/settings	apps/dashboard/src/app/settings/page.tsx
/settings/public-profile	apps/dashboard/src/app/settings/public-profile/page.tsx
/settings/seat-types	apps/dashboard/src/app/settings/seat-types/page.tsx
/suspended	apps/dashboard/src/app/suspended/page.tsx
/tickets/[id]	apps/dashboard/src/app/tickets/[id]/page.tsx
/tickets/new	apps/dashboard/src/app/tickets/new/page.tsx
/tickets	apps/dashboard/src/app/tickets/page.tsx
/tracking	apps/dashboard/src/app/tracking/page.tsx
/trips/[id]/edit	apps/dashboard/src/app/trips/[id]/edit/page.tsx
/trips/[id]	apps/dashboard/src/app/trips/[id]/page.tsx
/trips/[id]/seats	apps/dashboard/src/app/trips/[id]/seats/page.tsx
/trips/new	apps/dashboard/src/app/trips/new/page.tsx
/trips	apps/dashboard/src/app/trips/page.tsx

101 API routes

Route	Methods	Source
/api/account/password	POST	apps/dashboard/src/app/api/account/password/route.ts
/api/analytics/advanced	GET	apps/dashboard/src/app/api/analytics/advanced/route.ts
/api/analytics/bookings	GET	apps/dashboard/src/app/api/analytics/bookings/route.ts
/api/analytics/cancellations	GET	apps/dashboard/src/app/api/analytics/cancellations/route.ts
/api/analytics/forecast	GET	apps/dashboard/src/app/api/analytics/forecast/route.ts
/api/analytics/lead-time	GET	apps/dashboard/src/app/api/analytics/lead-time/route.ts
/api/analytics/overview	GET	apps/dashboard/src/app/api/analytics/overview/route.ts
/api/analytics/retention	GET	apps/dashboard/src/app/api/analytics/retention/route.ts
/api/analytics/revenue	GET	apps/dashboard/src/app/api/analytics/revenue/route.ts
/api/analytics/route-rankings	GET	apps/dashboard/src/app/api/analytics/route-rankings/route.ts
/api/analytics	GET	apps/dashboard/src/app/api/analytics/route.ts
/api/auth/login	POST	apps/dashboard/src/app/api/auth/login/route.ts
/api/auth/logout	POST	apps/dashboard/src/app/api/auth/logout/route.ts
/api/auth/me	GET	apps/dashboard/src/app/api/auth/me/route.ts
/api/bookings/[id]/checkin	POST	apps/dashboard/src/app/api/bookings/[id]/checkin/route.ts
/api/bookings/[id]/documents/[kind]	GET	apps/dashboard/src/app/api/bookings/[id]/documents/[kind]/route.ts
/api/bookings/[id]/payments	GET	apps/dashboard/src/app/api/bookings/[id]/payments/route.ts
/api/bookings/[id]/refund	POST	apps/dashboard/src/app/api/bookings/[id]/refund/route.ts
/api/bookings/[id]/reminder	GET POST	apps/dashboard/src/app/api/bookings/[id]/reminder/route.ts
/api/bookings/[id]	GET	apps/dashboard/src/app/api/bookings/[id]/route.ts
/api/bookings/[id]/status	PATCH	apps/dashboard/src/app/api/bookings/[id]/status/route.ts
/api/bookings/bulk	POST	apps/dashboard/src/app/api/bookings/bulk/route.ts
/api/bookings/export	GET	apps/dashboard/src/app/api/bookings/export/route.ts
/api/bookings	GET POST	apps/dashboard/src/app/api/bookings/route.ts
/api/bus-templates	GET	apps/dashboard/src/app/api/bus-templates/route.ts
/api/buses/[id]/layout	GET PUT DELETE	apps/dashboard/src/app/api/buses/[id]/layout/route.ts
/api/buses/[id]/maintenance	POST	apps/dashboard/src/app/api/buses/[id]/maintenance/route.ts
/api/buses/[id]	GET PUT DELETE	apps/dashboard/src/app/api/buses/[id]/route.ts
/api/buses/drafts/[id]	DELETE	apps/dashboard/src/app/api/buses/drafts/[id]/route.ts
/api/buses/drafts	GET POST	apps/dashboard/src/app/api/buses/drafts/route.ts
/api/buses	GET POST	apps/dashboard/src/app/api/buses/route.ts
/api/cities	GET POST	apps/dashboard/src/app/api/cities/route.ts
/api/companies/[id]/expire-warning	POST	apps/dashboard/src/app/api/companies/[id]/expire-warning/route.ts
/api/companies/[id]/payment-settings	GET PUT	apps/dashboard/src/app/api/companies/[id]/payment-settings/route.ts
/api/demo/session	POST	apps/dashboard/src/app/api/demo/session/route.ts
/api/driver/checkin/manual	POST	apps/dashboard/src/app/api/driver/checkin/manual/route.ts
/api/driver/checkin/no-show	POST	apps/dashboard/src/app/api/driver/checkin/no-show/route.ts
/api/driver/checkin/scan	POST	apps/dashboard/src/app/api/driver/checkin/scan/route.ts
/api/driver/location	GET POST	apps/dashboard/src/app/api/driver/location/route.ts
/api/driver/sync	GET POST	apps/dashboard/src/app/api/driver/sync/route.ts
/api/driver/trips/[id]	GET PATCH	apps/dashboard/src/app/api/driver/trips/[id]/route.ts
/api/driver/trips	GET	apps/dashboard/src/app/api/driver/trips/route.ts
/api/drivers/[id]/credentials	POST	apps/dashboard/src/app/api/drivers/[id]/credentials/route.ts
/api/drivers/[id]	GET PUT DELETE	apps/dashboard/src/app/api/drivers/[id]/route.ts
/api/drivers/[id]/trips	GET	apps/dashboard/src/app/api/drivers/[id]/trips/route.ts
/api/drivers	GET POST	apps/dashboard/src/app/api/drivers/route.ts
/api/health	GET	apps/dashboard/src/app/api/health/route.ts
/api/loyalty/accounts/[id]/adjust	POST	apps/dashboard/src/app/api/loyalty/accounts/[id]/adjust/route.ts
/api/loyalty/rewards/[id]	PUT DELETE	apps/dashboard/src/app/api/loyalty/rewards/[id]/route.ts
/api/loyalty/rewards	POST	apps/dashboard/src/app/api/loyalty/rewards/route.ts
/api/loyalty	GET PUT	apps/dashboard/src/app/api/loyalty/route.ts
/api/loyalty/tiers/[id]	PUT	apps/dashboard/src/app/api/loyalty/tiers/[id]/route.ts
/api/loyalty/tiers	POST	apps/dashboard/src/app/api/loyalty/tiers/route.ts
/api/office-booking	GET POST	apps/dashboard/src/app/api/office-booking/route.ts
/api/office-booking/trips/[id]/seats	GET	apps/dashboard/src/app/api/office-booking/trips/[id]/seats/route.ts
/api/office-booking/trips	GET	apps/dashboard/src/app/api/office-booking/trips/route.ts
/api/payment-settings	GET PUT	apps/dashboard/src/app/api/payment-settings/route.ts
/api/payments/[id]/cancel	POST	apps/dashboard/src/app/api/payments/[id]/cancel/route.ts
/api/payments/[id]/refund	POST	apps/dashboard/src/app/api/payments/[id]/refund/route.ts
/api/payments/[id]	GET PATCH	apps/dashboard/src/app/api/payments/[id]/route.ts
/api/payments/[id]/verify	POST	apps/dashboard/src/app/api/payments/[id]/verify/route.ts
/api/payments/cash-shifts	GET POST	apps/dashboard/src/app/api/payments/cash-shifts/route.ts
/api/payments/receipts/[source]/[id]	GET	apps/dashboard/src/app/api/payments/receipts/[source]/[id]/route.ts
/api/payments	GET	apps/dashboard/src/app/api/payments/route.ts
/api/payments/webhook	GET POST	apps/dashboard/src/app/api/payments/webhook/route.ts
/api/pickup-locations	GET POST	apps/dashboard/src/app/api/pickup-locations/route.ts
/api/push/subscribe	POST	apps/dashboard/src/app/api/push/subscribe/route.ts
/api/push/unsubscribe	POST	apps/dashboard/src/app/api/push/unsubscribe/route.ts
/api/reports	GET POST	apps/dashboard/src/app/api/reports/route.ts
/api/routes/[id]	GET PUT PATCH DELETE	apps/dashboard/src/app/api/routes/[id]/route.ts
/api/routes	GET POST	apps/dashboard/src/app/api/routes/route.ts
/api/saved-views/[id]	PATCH DELETE	apps/dashboard/src/app/api/saved-views/[id]/route.ts
/api/saved-views	GET POST	apps/dashboard/src/app/api/saved-views/route.ts
/api/seat-types/[id]	GET PATCH DELETE	apps/dashboard/src/app/api/seat-types/[id]/route.ts
/api/seat-types/reorder	PUT	apps/dashboard/src/app/api/seat-types/reorder/route.ts
/api/seat-types	GET POST	apps/dashboard/src/app/api/seat-types/route.ts
/api/settings/booking-confirmation	PUT	apps/dashboard/src/app/api/settings/booking-confirmation/route.ts
/api/settings/logo	POST DELETE	apps/dashboard/src/app/api/settings/logo/route.ts
/api/settings/public-profile/cover	POST DELETE	apps/dashboard/src/app/api/settings/public-profile/cover/route.ts
/api/settings/public-profile/gallery/[galleryId]	PATCH DELETE	apps/dashboard/src/app/api/settings/public-profile/gallery/[galleryId]/route.ts
/api/settings/public-profile/gallery	GET POST	apps/dashboard/src/app/api/settings/public-profile/gallery/route.ts
/api/settings/public-profile	GET PUT	apps/dashboard/src/app/api/settings/public-profile/route.ts
/api/settings	GET PUT	apps/dashboard/src/app/api/settings/route.ts
/api/stats	GET	apps/dashboard/src/app/api/stats/route.ts
/api/team/[id]	GET PUT DELETE	apps/dashboard/src/app/api/team/[id]/route.ts
/api/team	GET POST	apps/dashboard/src/app/api/team/route.ts
/api/tickets/[id]/messages	POST	apps/dashboard/src/app/api/tickets/[id]/messages/route.ts
/api/tickets/[id]	GET PATCH	apps/dashboard/src/app/api/tickets/[id]/route.ts
/api/tickets	GET POST	apps/dashboard/src/app/api/tickets/route.ts
/api/tracking/active-trips	GET	apps/dashboard/src/app/api/tracking/active-trips/route.ts
/api/tracking/trip/[id]/history	GET	apps/dashboard/src/app/api/tracking/trip/[id]/history/route.ts
/api/trip-schedules	GET POST	apps/dashboard/src/app/api/trip-schedules/route.ts
/api/trips/[id]/dispatch	GET POST	apps/dashboard/src/app/api/trips/[id]/dispatch/route.ts
/api/trips/[id]/media/[mediaId]	PATCH DELETE	apps/dashboard/src/app/api/trips/[id]/media/[mediaId]/route.ts
/api/trips/[id]/media	GET POST	apps/dashboard/src/app/api/trips/[id]/media/route.ts
/api/trips/[id]	GET PUT PATCH DELETE	apps/dashboard/src/app/api/trips/[id]/route.ts
/api/trips/[id]/seats/lock	GET POST DELETE	apps/dashboard/src/app/api/trips/[id]/seats/lock/route.ts
/api/trips/[id]/seats	GET PUT PATCH DELETE	apps/dashboard/src/app/api/trips/[id]/seats/route.ts
/api/trips/bulk	POST	apps/dashboard/src/app/api/trips/bulk/route.ts
/api/trips	GET POST	apps/dashboard/src/app/api/trips/route.ts
/api/waitlist	POST	apps/dashboard/src/app/api/waitlist/route.ts

110 UI modules

• apps/dashboard/src/app/analytics/loading.tsx
• apps/dashboard/src/app/bookings/[id]/booking-workspace.tsx
• apps/dashboard/src/app/bookings/[id]/loading.tsx
• apps/dashboard/src/app/bookings/error.tsx
• apps/dashboard/src/app/bookings/loading.tsx
• apps/dashboard/src/app/buses/loading.tsx
• apps/dashboard/src/app/dashboard-layout-client.tsx
• apps/dashboard/src/app/drivers/[id]/loading.tsx
• apps/dashboard/src/app/drivers/loading.tsx
• apps/dashboard/src/app/error.tsx
• apps/dashboard/src/app/layout.tsx
• apps/dashboard/src/app/loading.tsx
• apps/dashboard/src/app/login/layout.tsx
• apps/dashboard/src/app/loyalty/loyalty-workspace.tsx
• apps/dashboard/src/app/loyalty/program-settings.tsx
• apps/dashboard/src/app/loyalty/reward-editor.tsx
• apps/dashboard/src/app/loyalty/tier-editor.tsx
• apps/dashboard/src/app/not-found.tsx
• apps/dashboard/src/app/payments/cash-reconciliation-panel.tsx
• apps/dashboard/src/app/payments/loading.tsx
• apps/dashboard/src/app/payments/payment-ledger-panel.tsx
• apps/dashboard/src/app/reports/loading.tsx
• apps/dashboard/src/app/routes/loading.tsx
• apps/dashboard/src/app/settings/loading.tsx
• apps/dashboard/src/app/settings/public-profile/company-gallery-manager.tsx
• apps/dashboard/src/app/tickets/[id]/loading.tsx
• apps/dashboard/src/app/tickets/loading.tsx
• apps/dashboard/src/app/tracking/loading.tsx
• apps/dashboard/src/app/trips/[id]/dispatch-room.tsx
• apps/dashboard/src/app/trips/[id]/edit/trip-media-manager.tsx
• apps/dashboard/src/app/trips/[id]/loading.tsx
• apps/dashboard/src/app/trips/error.tsx
• apps/dashboard/src/app/trips/loading.tsx
• apps/dashboard/src/app/trips/new/trip-planner.tsx
• apps/dashboard/src/app/trips/trips-client.tsx
• apps/dashboard/src/components/admin/permission-guard.tsx
• apps/dashboard/src/components/analytics/forecast-chart.tsx
• apps/dashboard/src/components/analytics/metric-trend.tsx
• apps/dashboard/src/components/booking-details-card.tsx
• apps/dashboard/src/components/booking/qr-code.tsx
• apps/dashboard/src/components/booking/seat-legend.tsx
• apps/dashboard/src/components/booking/seat-map.tsx
• apps/dashboard/src/components/booking/seat-picker.tsx
• apps/dashboard/src/components/booking/seat.tsx
• apps/dashboard/src/components/booking/ticket-print.tsx
• apps/dashboard/src/components/booking/ticket.tsx
• apps/dashboard/src/components/bus-layout/BusLayoutBuilder.tsx
• apps/dashboard/src/components/bus-layout/BusLayoutCanvas.tsx
• apps/dashboard/src/components/bus-layout/BusLayoutTemplateSelector.tsx
• apps/dashboard/src/components/bus-layout/BusLayoutToolbar.tsx
• apps/dashboard/src/components/bus-layout/CommandPalette.tsx
• apps/dashboard/src/components/bus-layout/CommitStyleAdvancedLayoutEditor.tsx
• apps/dashboard/src/components/bus-layout/CustomerSeatLayoutPreview.tsx
• apps/dashboard/src/components/bus-layout/FloatingToolbar.tsx
• apps/dashboard/src/components/bus-layout/KeyboardShortcutsDialog.tsx
• apps/dashboard/src/components/bus-layout/LayoutPreview.tsx
• apps/dashboard/src/components/bus-layout/NumberingConfig.tsx
• apps/dashboard/src/components/bus-layout/snap/SnapGuides.tsx
• apps/dashboard/src/components/bus-layout/TemplateSelector.tsx
• apps/dashboard/src/components/charts/area-chart.tsx
• apps/dashboard/src/components/charts/bar-chart.tsx
• apps/dashboard/src/components/charts/heatmap-chart.tsx
• apps/dashboard/src/components/charts/line-chart.tsx
• apps/dashboard/src/components/charts/pie-chart.tsx
• apps/dashboard/src/components/dashboard/suspension-banner.tsx
• apps/dashboard/src/components/dashboard/warning-banner.tsx
• apps/dashboard/src/components/error-tracking-init.tsx
• apps/dashboard/src/components/header.tsx
• apps/dashboard/src/components/layout/header.tsx
• apps/dashboard/src/components/layout/page-header.tsx
• apps/dashboard/src/components/layout/sidebar.tsx
• apps/dashboard/src/components/page-header.tsx
• apps/dashboard/src/components/PWAProvider.tsx
• apps/dashboard/src/components/sidebar.tsx
• apps/dashboard/src/components/tracking/active-trips-list.tsx
• apps/dashboard/src/components/tracking/driver-map.tsx
• apps/dashboard/src/components/tracking/driver-marker.tsx
• apps/dashboard/src/components/trips/pickup-location-map.tsx
• apps/dashboard/src/components/trips/trip-pickup-location-field.tsx
• apps/dashboard/src/components/ui/avatar.tsx
• apps/dashboard/src/components/ui/badge.tsx
• apps/dashboard/src/components/ui/button.tsx
• apps/dashboard/src/components/ui/card.tsx
• apps/dashboard/src/components/ui/confirm-dialog.tsx
• apps/dashboard/src/components/ui/date-picker.tsx
• apps/dashboard/src/components/ui/date-range-picker.tsx
• apps/dashboard/src/components/ui/dropdown-menu.tsx
• apps/dashboard/src/components/ui/empty-state.tsx
• apps/dashboard/src/components/ui/error-boundary.tsx
• apps/dashboard/src/components/ui/input.tsx
• apps/dashboard/src/components/ui/modal.tsx
• apps/dashboard/src/components/ui/pagination.tsx
• apps/dashboard/src/components/ui/progress.tsx
• apps/dashboard/src/components/ui/route-error.tsx
• apps/dashboard/src/components/ui/search-input.tsx
• apps/dashboard/src/components/ui/select.tsx
• apps/dashboard/src/components/ui/skeleton-blocks.tsx
• apps/dashboard/src/components/ui/skeleton.tsx
• apps/dashboard/src/components/ui/stat.tsx
• apps/dashboard/src/components/ui/switch.tsx
• apps/dashboard/src/components/ui/table.tsx
• apps/dashboard/src/components/ui/tabs.tsx
• apps/dashboard/src/components/ui/textarea.tsx
• apps/dashboard/src/components/ui/time-picker.tsx
• apps/dashboard/src/components/ui/toast.tsx
• apps/dashboard/src/components/ui/toaster.tsx
• apps/dashboard/src/components/ui/tooltip.tsx
• apps/dashboard/src/contexts/suspension-context.tsx
• apps/dashboard/src/contexts/user-context.tsx
• apps/dashboard/src/providers/query-provider.tsx

admin web application

18 page routes

Route	Source
/accept-invitation	apps/admin/src/app/accept-invitation/page.tsx
/admins	apps/admin/src/app/admins/page.tsx
/analytics	apps/admin/src/app/analytics/page.tsx
/approvals	apps/admin/src/app/approvals/page.tsx
/audit-log	apps/admin/src/app/audit-log/page.tsx
/companies/[id]	apps/admin/src/app/companies/[id]/page.tsx
/companies	apps/admin/src/app/companies/page.tsx
/demos	apps/admin/src/app/demos/page.tsx
/feature-flags	apps/admin/src/app/feature-flags/page.tsx
/hub	apps/admin/src/app/hub/page.tsx
/incidents	apps/admin/src/app/incidents/page.tsx
/login	apps/admin/src/app/login/page.tsx
/loyalty	apps/admin/src/app/loyalty/page.tsx
/	apps/admin/src/app/page.tsx
/settings	apps/admin/src/app/settings/page.tsx
/tickets/[id]	apps/admin/src/app/tickets/[id]/page.tsx
/tickets	apps/admin/src/app/tickets/page.tsx
/waitlist	apps/admin/src/app/waitlist/page.tsx

68 API routes

Route	Methods	Source
/api/admins/[id]/activity	GET	apps/admin/src/app/api/admins/[id]/activity/route.ts
/api/admins/[id]	GET PATCH DELETE	apps/admin/src/app/api/admins/[id]/route.ts
/api/admins	GET POST	apps/admin/src/app/api/admins/route.ts
/api/analytics	GET	apps/admin/src/app/api/analytics/route.ts
/api/audit-log/actions	GET	apps/admin/src/app/api/audit-log/actions/route.ts
/api/audit-log	GET	apps/admin/src/app/api/audit-log/route.ts
/api/auth/2fa/enable-login	POST	apps/admin/src/app/api/auth/2fa/enable-login/route.ts
/api/auth/2fa/setup-login	POST	apps/admin/src/app/api/auth/2fa/setup-login/route.ts
/api/auth/2fa/verify	POST	apps/admin/src/app/api/auth/2fa/verify/route.ts
/api/auth/login	POST	apps/admin/src/app/api/auth/login/route.ts
/api/auth/logout	POST	apps/admin/src/app/api/auth/logout/route.ts
/api/auth/me	GET	apps/admin/src/app/api/auth/me/route.ts
/api/bookings/[id]/payments	GET	apps/admin/src/app/api/bookings/[id]/payments/route.ts
/api/companies/[id]/approve	POST	apps/admin/src/app/api/companies/[id]/approve/route.ts
/api/companies/[id]/clear-warning	POST	apps/admin/src/app/api/companies/[id]/clear-warning/route.ts
/api/companies/[id]/expire-warning	POST	apps/admin/src/app/api/companies/[id]/expire-warning/route.ts
/api/companies/[id]/payment-settings	GET PUT	apps/admin/src/app/api/companies/[id]/payment-settings/route.ts
/api/companies/[id]/reject	POST	apps/admin/src/app/api/companies/[id]/reject/route.ts
/api/companies/[id]	GET	apps/admin/src/app/api/companies/[id]/route.ts
/api/companies/[id]/suspend	POST	apps/admin/src/app/api/companies/[id]/suspend/route.ts
/api/companies/[id]/suspension-history	GET	apps/admin/src/app/api/companies/[id]/suspension-history/route.ts
/api/companies/[id]/unsuspend	POST	apps/admin/src/app/api/companies/[id]/unsuspend/route.ts
/api/companies/[id]/warn	POST	apps/admin/src/app/api/companies/[id]/warn/route.ts
/api/companies/[id]/warnings	GET	apps/admin/src/app/api/companies/[id]/warnings/route.ts
/api/companies/list	GET	apps/admin/src/app/api/companies/list/route.ts
/api/companies	GET	apps/admin/src/app/api/companies/route.ts
/api/demos/[id]	PATCH	apps/admin/src/app/api/demos/[id]/route.ts
/api/demos	GET POST	apps/admin/src/app/api/demos/route.ts
/api/feature-flags/[id]/overrides/[overrideId]	DELETE	apps/admin/src/app/api/feature-flags/[id]/overrides/[overrideId]/route.ts
/api/feature-flags/[id]/overrides	POST	apps/admin/src/app/api/feature-flags/[id]/overrides/route.ts
/api/feature-flags/[id]	GET PUT DELETE	apps/admin/src/app/api/feature-flags/[id]/route.ts
/api/feature-flags/[id]/toggle	POST	apps/admin/src/app/api/feature-flags/[id]/toggle/route.ts
/api/feature-flags	GET POST	apps/admin/src/app/api/feature-flags/route.ts
/api/health	GET	apps/admin/src/app/api/health/route.ts
/api/incidents/[id]	GET PATCH	apps/admin/src/app/api/incidents/[id]/route.ts
/api/incidents	GET	apps/admin/src/app/api/incidents/route.ts
/api/internal/notifications/process	POST	apps/admin/src/app/api/internal/notifications/process/route.ts
/api/invitations/accept	POST	apps/admin/src/app/api/invitations/accept/route.ts
/api/invitations/verify	GET	apps/admin/src/app/api/invitations/verify/route.ts
/api/loyalty/accounts/[id]/adjust	POST	apps/admin/src/app/api/loyalty/accounts/[id]/adjust/route.ts
/api/loyalty/rewards/[id]	GET PUT DELETE	apps/admin/src/app/api/loyalty/rewards/[id]/route.ts
/api/loyalty/rewards	GET POST	apps/admin/src/app/api/loyalty/rewards/route.ts
/api/loyalty/stats	GET	apps/admin/src/app/api/loyalty/stats/route.ts
/api/maintenance	GET POST PATCH	apps/admin/src/app/api/maintenance/route.ts
/api/maps/geocode	GET	apps/admin/src/app/api/maps/geocode/route.ts
/api/passengers/search	GET	apps/admin/src/app/api/passengers/search/route.ts
/api/payments/[id]/cancel	POST	apps/admin/src/app/api/payments/[id]/cancel/route.ts
/api/payments/[id]	GET PATCH	apps/admin/src/app/api/payments/[id]/route.ts
/api/payments/[id]/verify	POST	apps/admin/src/app/api/payments/[id]/verify/route.ts
/api/payments	GET POST	apps/admin/src/app/api/payments/route.ts
/api/permissions	GET	apps/admin/src/app/api/permissions/route.ts
/api/push/subscribe	POST	apps/admin/src/app/api/push/subscribe/route.ts
/api/push/unsubscribe	POST	apps/admin/src/app/api/push/unsubscribe/route.ts
/api/security/2fa	GET POST PATCH DELETE	apps/admin/src/app/api/security/2fa/route.ts
/api/stats	GET	apps/admin/src/app/api/stats/route.ts
/api/tickets/[id]/assign	POST	apps/admin/src/app/api/tickets/[id]/assign/route.ts
/api/tickets/[id]/escalate	POST	apps/admin/src/app/api/tickets/[id]/escalate/route.ts
/api/tickets/[id]/messages	POST	apps/admin/src/app/api/tickets/[id]/messages/route.ts
/api/tickets/[id]/resolve	POST	apps/admin/src/app/api/tickets/[id]/resolve/route.ts
/api/tickets/[id]	GET PATCH	apps/admin/src/app/api/tickets/[id]/route.ts
/api/tickets	GET	apps/admin/src/app/api/tickets/route.ts
/api/tickets/stats	GET	apps/admin/src/app/api/tickets/stats/route.ts
/api/trips/[id]/seats/lock	GET POST DELETE	apps/admin/src/app/api/trips/[id]/seats/lock/route.ts
/api/waitlist	GET POST PATCH	apps/admin/src/app/api/waitlist/route.ts
/api/webhooks/notifications/external-sms	POST	apps/admin/src/app/api/webhooks/notifications/external-sms/route.ts
/api/webhooks/notifications/resend	POST	apps/admin/src/app/api/webhooks/notifications/resend/route.ts
/api/webhooks/notifications/twilio	POST	apps/admin/src/app/api/webhooks/notifications/twilio/route.ts
/api/webhooks/notifications/whatsapp	GET POST	apps/admin/src/app/api/webhooks/notifications/whatsapp/route.ts

38 UI modules

• apps/admin/src/app/analytics/loading.tsx
• apps/admin/src/app/approvals/error.tsx
• apps/admin/src/app/approvals/loading.tsx
• apps/admin/src/app/audit-log/loading.tsx
• apps/admin/src/app/companies/error.tsx
• apps/admin/src/app/companies/loading.tsx
• apps/admin/src/app/error.tsx
• apps/admin/src/app/incidents/loading.tsx
• apps/admin/src/app/layout.tsx
• apps/admin/src/app/loading.tsx
• apps/admin/src/app/login/layout.tsx
• apps/admin/src/app/not-found.tsx
• apps/admin/src/app/tickets/error.tsx
• apps/admin/src/app/tickets/loading.tsx
• apps/admin/src/components/admin/permission-guard.tsx
• apps/admin/src/components/booking-details-card.tsx
• apps/admin/src/components/booking/qr-code.tsx
• apps/admin/src/components/booking/seat-legend.tsx
• apps/admin/src/components/booking/seat-map.tsx
• apps/admin/src/components/booking/seat-picker.tsx
• apps/admin/src/components/booking/seat.tsx
• apps/admin/src/components/booking/ticket-print.tsx
• apps/admin/src/components/booking/ticket.tsx
• apps/admin/src/components/charts/area-chart.tsx
• apps/admin/src/components/charts/bar-chart.tsx
• apps/admin/src/components/charts/heatmap-chart.tsx
• apps/admin/src/components/charts/line-chart.tsx
• apps/admin/src/components/charts/pie-chart.tsx
• apps/admin/src/components/dashboard/suspension-banner.tsx
• apps/admin/src/components/dashboard/warning-banner.tsx
• apps/admin/src/components/error-tracking-init.tsx
• apps/admin/src/components/feature-flags/EntityCombobox.tsx
• apps/admin/src/components/layout/header.tsx
• apps/admin/src/components/layout/page-header.tsx
• apps/admin/src/components/PWAProvider.tsx
• apps/admin/src/components/ui/route-error.tsx
• apps/admin/src/components/ui/skeleton-blocks.tsx
• apps/admin/src/providers/query-provider.tsx

Mobile applications

The route list is resolved from actual GoRoute declarations, including AppRoutes constants and nested relative paths. The coverage column checks the shared production route-flow manifest.

59 resolved GoRouter routes

Application	Resolved route	Manifest	Source
mobile-customer	/auth/complete-phone	covered	apps/mobile/customer/lib/core/router/app_router.dart:600
mobile-customer	/auth/complete-profile	covered	apps/mobile/customer/lib/core/router/app_router.dart:593
mobile-customer	/booking/:tripId	covered	apps/mobile/customer/lib/core/router/app_router.dart:491
mobile-customer	/booking/confirmation/:bookingCode	covered	apps/mobile/customer/lib/core/router/app_router.dart:512
mobile-customer	/bookings/:code	covered	apps/mobile/customer/lib/core/router/app_router.dart:763
mobile-customer	/chat/:tripId	covered	apps/mobile/customer/lib/core/router/app_router.dart:822
mobile-customer	/dl/booking/:code	covered	apps/mobile/customer/lib/core/router/app_router.dart:752
mobile-customer	/dl/search	covered	apps/mobile/customer/lib/core/router/app_router.dart:790
mobile-customer	/dl/trip/:tripId	covered	apps/mobile/customer/lib/core/router/app_router.dart:778
mobile-customer	/feedback/:bookingId	covered	apps/mobile/customer/lib/core/router/app_router.dart:614
mobile-customer	/home	covered	apps/mobile/customer/lib/core/router/app_router.dart:303
mobile-customer	/journey-orders/:orderId/checkout	covered	apps/mobile/customer/lib/core/router/app_router.dart:388
mobile-customer	/journey-orders/:orderId/confirmation	covered	apps/mobile/customer/lib/core/router/app_router.dart:400
mobile-customer	/journeys	covered	apps/mobile/customer/lib/core/router/app_router.dart:347
mobile-customer	/journeys/:bookingId/checkout	covered	apps/mobile/customer/lib/core/router/app_router.dart:382
mobile-customer	/journeys/:bookingId/confirmation	covered	apps/mobile/customer/lib/core/router/app_router.dart:394
mobile-customer	/legal/privacy	covered	apps/mobile/customer/lib/core/router/app_router.dart:706
mobile-customer	/legal/terms	covered	apps/mobile/customer/lib/core/router/app_router.dart:697
mobile-customer	/login	covered	apps/mobile/customer/lib/core/router/app_router.dart:529
mobile-customer	/loyalty	covered	apps/mobile/customer/lib/core/router/app_router.dart:716
mobile-customer	/loyalty/referral	covered	apps/mobile/customer/lib/core/router/app_router.dart:730
mobile-customer	/loyalty/rewards	covered	apps/mobile/customer/lib/core/router/app_router.dart:723
mobile-customer	/loyalty/transactions	covered	apps/mobile/customer/lib/core/router/app_router.dart:737
mobile-customer	/my-bookings	covered	apps/mobile/customer/lib/core/router/app_router.dart:312
mobile-customer	/my-bookings/journey-orders/:orderId	covered	apps/mobile/customer/lib/core/router/app_router.dart:412
mobile-customer	/my-bookings/journeys/:bookingId	covered	apps/mobile/customer/lib/core/router/app_router.dart:406
mobile-customer	/my-bookings/journeys/:bookingId/tracking/:tripId	covered	apps/mobile/customer/lib/core/router/app_router.dart:418
mobile-customer	/nearby-stations	covered	apps/mobile/customer/lib/core/router/app_router.dart:663
mobile-customer	/otp	covered	apps/mobile/customer/lib/core/router/app_router.dart:542
mobile-customer	/profile	covered	apps/mobile/customer/lib/core/router/app_router.dart:335
mobile-customer	/profile/edit	covered	apps/mobile/customer/lib/core/router/app_router.dart:650
mobile-customer	/refer/:code	covered	apps/mobile/customer/lib/core/router/app_router.dart:860
mobile-customer	/register	covered	apps/mobile/customer/lib/core/router/app_router.dart:563
mobile-customer	/seat-selection/:tripId	covered	apps/mobile/customer/lib/core/router/app_router.dart:474
mobile-customer	/settings	covered	apps/mobile/customer/lib/core/router/app_router.dart:690
mobile-customer	/station/:stationId	covered	apps/mobile/customer/lib/core/router/app_router.dart:671
mobile-customer	/support	covered	apps/mobile/customer/lib/core/router/app_router.dart:326
mobile-customer	/support/:ticketId	covered	apps/mobile/customer/lib/core/router/app_router.dart:640
mobile-customer	/support/new	covered	apps/mobile/customer/lib/core/router/app_router.dart:624
mobile-customer	/track/:bookingCode	covered	apps/mobile/customer/lib/core/router/app_router.dart:842
mobile-customer	/trip/:tripId	covered	apps/mobile/customer/lib/core/router/app_router.dart:464
mobile-customer	/trips	covered	apps/mobile/customer/lib/core/router/app_router.dart:426
mobile-customer	/verify-email	covered	apps/mobile/customer/lib/core/router/app_router.dart:578
mobile-driver	/	covered	apps/mobile/driver/lib/core/router/app_router.dart:152
mobile-driver	/demo	covered	apps/mobile/driver/lib/core/router/app_router.dart:116
mobile-driver	/login	covered	apps/mobile/driver/lib/core/router/app_router.dart:111
mobile-driver	/settings	covered	apps/mobile/driver/lib/core/router/app_router.dart:280
mobile-driver	/splash	covered	apps/mobile/driver/lib/core/router/app_router.dart:103
mobile-driver	/trip/:assignmentId	covered	apps/mobile/driver/lib/core/router/app_router.dart:159
mobile-driver	/trip/:assignmentId/chat	covered	apps/mobile/driver/lib/core/router/app_router.dart:246
mobile-driver	/trip/:assignmentId/emergency	covered	apps/mobile/driver/lib/core/router/app_router.dart:235
mobile-driver	/trip/:assignmentId/manifest	covered	apps/mobile/driver/lib/core/router/app_router.dart:170
mobile-driver	/trip/:assignmentId/map	covered	apps/mobile/driver/lib/core/router/app_router.dart:192
mobile-driver	/trip/:assignmentId/payment/:bookingId	covered	apps/mobile/driver/lib/core/router/app_router.dart:203
mobile-driver	/trip/:assignmentId/payment/:bookingId/receipt/:receiptId	covered	apps/mobile/driver/lib/core/router/app_router.dart:222
mobile-driver	/trip/:assignmentId/photos	covered	apps/mobile/driver/lib/core/router/app_router.dart:260
mobile-driver	/trip/:assignmentId/scan	covered	apps/mobile/driver/lib/core/router/app_router.dart:181
mobile-driver	/two-factor	covered	apps/mobile/driver/lib/core/router/app_router.dart:126
mobile-driver	/two-factor-setup	covered	apps/mobile/driver/lib/core/router/app_router.dart:138

50 mobile screen/page files

Application	Source
mobile-customer	apps/mobile/customer/lib/core/widgets/progress_screen.dart
mobile-customer	apps/mobile/customer/lib/features/auth/presentation/screens/complete_phone_screen.dart
mobile-customer	apps/mobile/customer/lib/features/auth/presentation/screens/complete_profile_screen.dart
mobile-customer	apps/mobile/customer/lib/features/auth/presentation/screens/email_verification_screen.dart
mobile-customer	apps/mobile/customer/lib/features/auth/presentation/screens/login_screen.dart
mobile-customer	apps/mobile/customer/lib/features/auth/presentation/screens/otp_screen.dart
mobile-customer	apps/mobile/customer/lib/features/auth/presentation/screens/register_screen.dart
mobile-customer	apps/mobile/customer/lib/features/booking/presentation/screens/booking_confirmation_screen.dart
mobile-customer	apps/mobile/customer/lib/features/booking/presentation/screens/booking_screen.dart
mobile-customer	apps/mobile/customer/lib/features/booking/presentation/screens/my_bookings_screen.dart
mobile-customer	apps/mobile/customer/lib/features/booking/presentation/screens/seat_selection_screen.dart
mobile-customer	apps/mobile/customer/lib/features/chat/presentation/screens/chat_screen.dart
mobile-customer	apps/mobile/customer/lib/features/feedback/presentation/screens/feedback_screen.dart
mobile-customer	apps/mobile/customer/lib/features/journeys/presentation/screens/journey_checkout_screen.dart
mobile-customer	apps/mobile/customer/lib/features/journeys/presentation/screens/journey_confirmation_screen.dart
mobile-customer	apps/mobile/customer/lib/features/journeys/presentation/screens/journey_results_screen.dart
mobile-customer	apps/mobile/customer/lib/features/journeys/presentation/screens/traveler_journeys_screen.dart
mobile-customer	apps/mobile/customer/lib/features/loyalty/presentation/screens/loyalty_dashboard_screen.dart
mobile-customer	apps/mobile/customer/lib/features/loyalty/presentation/screens/referral_screen.dart
mobile-customer	apps/mobile/customer/lib/features/loyalty/presentation/screens/rewards_screen.dart
mobile-customer	apps/mobile/customer/lib/features/loyalty/presentation/screens/transactions_screen.dart
mobile-customer	apps/mobile/customer/lib/features/profile/presentation/screens/edit_profile_screen.dart
mobile-customer	apps/mobile/customer/lib/features/profile/presentation/screens/profile_screen.dart
mobile-customer	apps/mobile/customer/lib/features/search/presentation/screens/search_screen.dart
mobile-customer	apps/mobile/customer/lib/features/settings/presentation/screens/legal_document_screen.dart
mobile-customer	apps/mobile/customer/lib/features/settings/presentation/screens/settings_screen.dart
mobile-customer	apps/mobile/customer/lib/features/stations/presentation/screens/nearby_stations_screen.dart
mobile-customer	apps/mobile/customer/lib/features/stations/presentation/screens/station_details_screen.dart
mobile-customer	apps/mobile/customer/lib/features/support/presentation/screens/create_ticket_screen.dart
mobile-customer	apps/mobile/customer/lib/features/support/presentation/screens/support_screen.dart
mobile-customer	apps/mobile/customer/lib/features/support/presentation/screens/ticket_detail_screen.dart
mobile-customer	apps/mobile/customer/lib/features/tracking/presentation/screens/bus_tracking_screen.dart
mobile-customer	apps/mobile/customer/lib/features/trips/presentation/screens/trip_details_screen.dart
mobile-customer	apps/mobile/customer/lib/features/trips/presentation/screens/trip_results_screen.dart
mobile-driver	apps/mobile/driver/lib/features/auth/presentation/screens/demo_access_screen.dart
mobile-driver	apps/mobile/driver/lib/features/auth/presentation/screens/login_screen.dart
mobile-driver	apps/mobile/driver/lib/features/auth/presentation/screens/splash_screen.dart
mobile-driver	apps/mobile/driver/lib/features/auth/presentation/screens/two_factor_screen.dart
mobile-driver	apps/mobile/driver/lib/features/auth/presentation/screens/two_factor_setup_screen.dart
mobile-driver	apps/mobile/driver/lib/features/chat/presentation/screens/chat_screen.dart
mobile-driver	apps/mobile/driver/lib/features/emergency/presentation/screens/emergency_screen.dart
mobile-driver	apps/mobile/driver/lib/features/home/presentation/screens/home_screen.dart
mobile-driver	apps/mobile/driver/lib/features/payments/presentation/screens/collect_payment_screen.dart
mobile-driver	apps/mobile/driver/lib/features/payments/presentation/screens/payment_receipt_screen.dart
mobile-driver	apps/mobile/driver/lib/features/photos/presentation/screens/photo_capture_screen.dart
mobile-driver	apps/mobile/driver/lib/features/scanner/presentation/screens/qr_scanner_screen.dart
mobile-driver	apps/mobile/driver/lib/features/settings/presentation/screens/settings_screen.dart
mobile-driver	apps/mobile/driver/lib/features/tracking/presentation/screens/map_screen.dart
mobile-driver	apps/mobile/driver/lib/features/trip/presentation/screens/manifest_screen.dart
mobile-driver	apps/mobile/driver/lib/features/trip/presentation/screens/trip_detail_screen.dart

Shared package implementation modules

162 shared source modules

Package	Source
auth	packages/auth/src/auth-guard.tsx
auth	packages/auth/src/check-permission.ts
auth	packages/auth/src/csrf.ts
auth	packages/auth/src/customer-auth-context.tsx
auth	packages/auth/src/demo-access.ts
auth	packages/auth/src/demo-grant.ts
auth	packages/auth/src/index.ts
auth	packages/auth/src/password-validation.ts
auth	packages/auth/src/second-factor-session.ts
auth	packages/auth/src/security-headers.ts
auth	packages/auth/src/token-blocklist.ts
auth	packages/auth/src/totp-secret-crypto.d.mts
auth	packages/auth/src/totp-secret-crypto.mjs
auth	packages/auth/src/totp.ts
auth	packages/auth/src/use-admin-permissions.ts
auth	packages/auth/src/use-customer-auth.ts
auth	packages/auth/src/with-token-validation.ts
config	packages/config/src/agent-prompts/audits.ts
config	packages/config/src/agent-prompts/docs-ops.ts
config	packages/config/src/agent-prompts/helpers.ts
config	packages/config/src/agent-prompts/implementation.ts
config	packages/config/src/agent-prompts/index.ts
config	packages/config/src/agent-prompts/partner.ts
config	packages/config/src/agent-prompts/reliability.ts
config	packages/config/src/agent-prompts/types.ts
config	packages/config/src/constants.ts
config	packages/config/src/dev-credentials.ts
config	packages/config/src/index.ts
database	packages/database/src/adapters/memory.adapter.ts
database	packages/database/src/adapters/supabase.adapter.ts
database	packages/database/src/client.ts
database	packages/database/src/index.ts
database	packages/database/src/server.ts
encryption	packages/encryption/src/index.ts
encryption	packages/encryption/src/migration.ts
encryption	packages/encryption/src/passenger-pii.ts
encryption	packages/encryption/src/passenger.encryption.ts
logger	packages/logger/src/index.ts
services	packages/services/src/analytics.service.ts
services	packages/services/src/audit.service.ts
services	packages/services/src/booking-document-generation.service.ts
services	packages/services/src/booking-document-snapshot.service.ts
services	packages/services/src/bookings.service.ts
services	packages/services/src/captcha.ts
services	packages/services/src/dashboard.service.ts
services	packages/services/src/demo-safety.ts
services	packages/services/src/document-template.service.ts
services	packages/services/src/drivers.service.ts
services	packages/services/src/email.service.ts
services	packages/services/src/error-tracking.ts
services	packages/services/src/feature-flags.service.ts
services	packages/services/src/financial-document-generation.service.ts
services	packages/services/src/financial-document-snapshot.service.ts
services	packages/services/src/fraud-detection.service.ts
services	packages/services/src/index.ts
services	packages/services/src/journey-ticket-credential.service.ts
services	packages/services/src/journey-ticket-credential.ts
services	packages/services/src/login-audit.service.ts
services	packages/services/src/notification-delivery-worker.service.ts
services	packages/services/src/notification-template.service.ts
services	packages/services/src/notification-webhook.service.ts
services	packages/services/src/notification.service.ts
services	packages/services/src/ntfy.service.ts
services	packages/services/src/online-payment-adapter.service.ts
services	packages/services/src/otp-provider.service.ts
services	packages/services/src/otp.service.ts
services	packages/services/src/passengers.service.ts
services	packages/services/src/payment.service.ts
services	packages/services/src/pdf-document.service.ts
services	packages/services/src/push-sender.service.ts
services	packages/services/src/push-subscription-contract.ts
services	packages/services/src/push.service.ts
services	packages/services/src/rate-limit.service.ts
services	packages/services/src/routes.service.ts
services	packages/services/src/service-client.ts
services	packages/services/src/sms.service.ts
services	packages/services/src/supabase-dashboard.service.ts
services	packages/services/src/telegram-bot.service.ts
services	packages/services/src/telegram-gateway.service.ts
services	packages/services/src/trips.service.ts
services	packages/services/src/utils/validate.ts
services	packages/services/src/whatsapp.service.ts
shared	packages/shared/src/design-system.ts
shared	packages/shared/src/index.ts
shared	packages/shared/src/types.ts
types	packages/types/src/admin.ts
types	packages/types/src/booking-workspace.ts
types	packages/types/src/bus-layout.ts
types	packages/types/src/connected-transport.ts
types	packages/types/src/database.ts
types	packages/types/src/driver.ts
types	packages/types/src/ecosystem.ts
types	packages/types/src/global-product.ts
types	packages/types/src/index.ts
types	packages/types/src/partner-operations.ts
types	packages/types/src/schemas/booking-workspace.schema.ts
types	packages/types/src/schemas/booking.schema.ts
types	packages/types/src/schemas/common.schema.ts
types	packages/types/src/schemas/connected-transport.schema.ts
types	packages/types/src/schemas/global-product.schema.ts
types	packages/types/src/schemas/index.ts
types	packages/types/src/schemas/partner-operations.schema.ts
types	packages/types/src/schemas/passenger.schema.ts
types	packages/types/src/schemas/payment.schema.ts
types	packages/types/src/schemas/support.schema.ts
types	packages/types/src/schemas/team.schema.ts
types	packages/types/src/schemas/trip.schema.ts
types	packages/types/src/seats.ts
types	packages/types/src/tickets.ts
ui	packages/ui/src/authentication-shell.tsx
ui	packages/ui/src/avatar.tsx
ui	packages/ui/src/badge.tsx
ui	packages/ui/src/brand-logo.tsx
ui	packages/ui/src/bus-layout-renderer.tsx
ui	packages/ui/src/button.tsx
ui	packages/ui/src/card.tsx
ui	packages/ui/src/combobox.tsx
ui	packages/ui/src/confirm-dialog.tsx
ui	packages/ui/src/country-selector.tsx
ui	packages/ui/src/date-picker.tsx
ui	packages/ui/src/date-range-picker.tsx
ui	packages/ui/src/date-time-picker.tsx
ui	packages/ui/src/dropdown-menu.tsx
ui	packages/ui/src/empty-state.tsx
ui	packages/ui/src/error-boundary.tsx
ui	packages/ui/src/filter-bar.tsx
ui	packages/ui/src/image-uploader.tsx
ui	packages/ui/src/index.ts
ui	packages/ui/src/input.tsx
ui	packages/ui/src/lib/utils/cn.ts
ui	packages/ui/src/metric-strip.tsx
ui	packages/ui/src/modal.tsx
ui	packages/ui/src/motion.tsx
ui	packages/ui/src/otp-input.tsx
ui	packages/ui/src/otp-method-selector.tsx
ui	packages/ui/src/page-header.tsx
ui	packages/ui/src/pagination.tsx
ui	packages/ui/src/phone-input.tsx
ui	packages/ui/src/progress.tsx
ui	packages/ui/src/saved-view-control.tsx
ui	packages/ui/src/search-input.tsx
ui	packages/ui/src/select.tsx
ui	packages/ui/src/skeleton.tsx
ui	packages/ui/src/stat.tsx
ui	packages/ui/src/switch.tsx
ui	packages/ui/src/table.tsx
ui	packages/ui/src/tabs.tsx
ui	packages/ui/src/textarea.tsx
ui	packages/ui/src/time-picker.tsx
ui	packages/ui/src/toast.tsx
ui	packages/ui/src/toaster.tsx
ui	packages/ui/src/tooltip.tsx
utils	packages/utils/src/cn.ts
utils	packages/utils/src/date-utils.ts
utils	packages/utils/src/error-handler.ts
utils	packages/utils/src/format-route.ts
utils	packages/utils/src/index.ts
utils	packages/utils/src/latin-digits.ts
utils	packages/utils/src/return-path.ts
utils	packages/utils/src/sanitize.ts
utils	packages/utils/src/test-dates.ts
utils	packages/utils/src/validation.ts

Database migration lineage

These are historical declarations parsed from migrations, not a claim that every object remains live. A later migration can rename or drop an object. PostgreSQL catalog checks and RLS contract tests are authoritative for the deployed schema. “Latest declaration” means the latest migration containing a matching CREATE declaration.

168 migration-declared tables

table	Latest declaration
account_recovery_attempts	infrastructure/supabase/migrations/00164_account_recovery.sql
active_sessions	infrastructure/supabase/migrations/00079_session_configuration.sql
admin_audit_log	infrastructure/supabase/migrations/00001_complete_schema.sql
admin_invitations	infrastructure/supabase/migrations/00001_complete_schema.sql
admin_login_challenges	infrastructure/supabase/migrations/00167_admin_login_challenges.sql
admin_permissions	infrastructure/supabase/migrations/00001_complete_schema.sql
admin_user_permissions	infrastructure/supabase/migrations/00001_complete_schema.sql
admin_users	infrastructure/supabase/migrations/00001_complete_schema.sql
app_settings	infrastructure/supabase/migrations/00105_offline_qr_tokens.sql
auth_rate_limits	infrastructure/supabase/migrations/00071_fix_critical_bugs.sql
auth.identities	infrastructure/supabase/migrations/00060_seed_admin_auth_users.sql
booking_qr_tokens	infrastructure/supabase/migrations/00001_complete_schema.sql
booking_reminders	infrastructure/supabase/migrations/00098_booking_reminders.sql
bookings	infrastructure/supabase/migrations/00001_complete_schema.sql
bus_layout_positions	infrastructure/supabase/migrations/00122_ensure_dashboard_seat_types_and_feedback.sql
bus_layouts	infrastructure/supabase/migrations/00056_seat_configuration.sql
bus_locations	infrastructure/supabase/migrations/00001_complete_schema.sql
bus_maintenance_schedules	infrastructure/supabase/migrations/00061_remaining_fixes.sql
bus_templates	infrastructure/supabase/migrations/00054_bus_templates.sql
buses	infrastructure/supabase/migrations/00001_complete_schema.sql
cities	infrastructure/supabase/migrations/00001_complete_schema.sql
companies	infrastructure/supabase/migrations/00001_complete_schema.sql
company_monthly_stats	infrastructure/supabase/migrations/00001_complete_schema.sql
company_payment_settings	infrastructure/supabase/migrations/00011_payment_system.sql
company_suspension_history	infrastructure/supabase/migrations/00001_complete_schema.sql
company_users	infrastructure/supabase/migrations/00001_complete_schema.sql
company_warnings	infrastructure/supabase/migrations/00001_complete_schema.sql
customer_sessions	infrastructure/supabase/migrations/00041_auth_otp_storage.sql
device_tokens	infrastructure/supabase/migrations/00087_add_push_notification_support.sql
driver_backup_codes	infrastructure/supabase/migrations/00165_driver_email_auth.sql
driver_incidents	infrastructure/supabase/migrations/00125_ensure_admin_operational_tables.sql
driver_login_challenges	infrastructure/supabase/migrations/00165_driver_email_auth.sql
driver_notifications	infrastructure/supabase/migrations/00001_complete_schema.sql
driver_sync_queue	infrastructure/supabase/migrations/00001_complete_schema.sql
drivers	infrastructure/supabase/migrations/00001_complete_schema.sql
email_verifications	infrastructure/supabase/migrations/00043_email_verification.sql
favorite_routes	infrastructure/supabase/migrations/00018_favorite_routes.sql
feature_flag_overrides	infrastructure/supabase/migrations/00125_ensure_admin_operational_tables.sql
feature_flags	infrastructure/supabase/migrations/00125_ensure_admin_operational_tables.sql
group_booking_messages	infrastructure/supabase/migrations/00093_group_booking_system.sql
group_booking_passengers	infrastructure/supabase/migrations/00093_group_booking_system.sql
group_booking_payments	infrastructure/supabase/migrations/00093_group_booking_system.sql
group_booking_requests	infrastructure/supabase/migrations/00093_group_booking_system.sql
group_booking_templates	infrastructure/supabase/migrations/00093_group_booking_system.sql
loyalty_accounts	infrastructure/supabase/migrations/00125_ensure_admin_operational_tables.sql
loyalty_redemptions	infrastructure/supabase/migrations/00125_ensure_admin_operational_tables.sql
loyalty_referrals	infrastructure/supabase/migrations/00092_loyalty_points_system.sql
loyalty_rewards	infrastructure/supabase/migrations/00125_ensure_admin_operational_tables.sql
loyalty_tiers	infrastructure/supabase/migrations/00125_ensure_admin_operational_tables.sql
loyalty_transactions	infrastructure/supabase/migrations/00125_ensure_admin_operational_tables.sql
maintenance_logs	infrastructure/supabase/migrations/00038_maintenance_logs.sql
notification_logs	infrastructure/supabase/migrations/00061_remaining_fixes.sql
notification_preferences	infrastructure/supabase/migrations/00091_notification_system.sql
notification_templates	infrastructure/supabase/migrations/00091_notification_system.sql
notifications	infrastructure/supabase/migrations/00091_notification_system.sql
otp_codes	infrastructure/supabase/migrations/00041_auth_otp_storage.sql
passenger_checkins	infrastructure/supabase/migrations/00001_complete_schema.sql
passenger_payment_methods	infrastructure/supabase/migrations/00011_payment_system.sql
passengers	infrastructure/supabase/migrations/00001_complete_schema.sql
password_reset_tokens	infrastructure/supabase/migrations/00041_auth_otp_storage.sql
payment_transactions	infrastructure/supabase/migrations/00011_payment_system.sql
platform_maintenance_runs	infrastructure/supabase/migrations/00109_admin_platform_operations.sql
platform_maintenance_settings	infrastructure/supabase/migrations/00109_admin_platform_operations.sql
public.audit_log	infrastructure/supabase/migrations/00177_general_audit_log.sql
public.booking_documents	infrastructure/supabase/migrations/00253_enterprise_booking_workspace_and_documents.sql
public.booking_extras	infrastructure/supabase/migrations/00224_connected_transport_core.sql
public.booking_guest_access_sessions	infrastructure/supabase/migrations/00271_booking_guest_access_sessions.sql
public.booking_passengers	infrastructure/supabase/migrations/00227_atomic_journey_booking_inventory.sql
public.bus_creation_drafts	infrastructure/supabase/migrations/00219_global_product_foundation.sql
public.bus_layout_positions	infrastructure/supabase/migrations/00139_canonical_bus_layout_documents.sql
public.bus_layout_templates	infrastructure/supabase/migrations/00137_restore_resource_contract_compatibility.sql
public.bus_layouts	infrastructure/supabase/migrations/00139_canonical_bus_layout_documents.sql
public.bus_resource_capacities	infrastructure/supabase/migrations/00224_connected_transport_core.sql
public.bus_templates	infrastructure/supabase/migrations/00133_restore_bus_templates_contract.sql
public.company_booking_confirmation_policies	infrastructure/supabase/migrations/00305_company_booking_confirmation_lifecycle.sql
public.company_cash_adjustments	infrastructure/supabase/migrations/00211_company_cash_reconciliation.sql
public.company_cash_shifts	infrastructure/supabase/migrations/00211_company_cash_reconciliation.sql
public.company_gallery	infrastructure/supabase/migrations/00220_public_company_profiles_and_trip_media.sql
public.company_loyalty_programs	infrastructure/supabase/migrations/00255_company_owned_loyalty.sql
public.company_operating_cities	infrastructure/supabase/migrations/00220_public_company_profiles_and_trip_media.sql
public.company_quality_metric_values	infrastructure/supabase/migrations/00226_partner_quality_settlements.sql
public.company_quality_snapshots	infrastructure/supabase/migrations/00226_partner_quality_settlements.sql
public.company_traveler_policies	infrastructure/supabase/migrations/00246_traveler_journey_self_service.sql
public.demo_access_grants	infrastructure/supabase/migrations/00178_custom_demo_experience.sql
public.demo_outbox	infrastructure/supabase/migrations/00178_custom_demo_experience.sql
public.demo_personas	infrastructure/supabase/migrations/00178_custom_demo_experience.sql
public.document_render_events	infrastructure/supabase/migrations/00218_enterprise_document_registry.sql
public.document_share_events	infrastructure/supabase/migrations/00298_secure_document_share_grants.sql
public.document_share_grants	infrastructure/supabase/migrations/00298_secure_document_share_grants.sql
public.document_share_sessions	infrastructure/supabase/migrations/00298_secure_document_share_grants.sql
public.email_verifications	infrastructure/supabase/migrations/00127_ensure_passenger_email_verification_contract.sql
public.financial_documents	infrastructure/supabase/migrations/00218_enterprise_document_registry.sql
public.journey_booking_confirmation_requests	infrastructure/supabase/migrations/00305_company_booking_confirmation_lifecycle.sql
public.journey_booking_sessions	infrastructure/supabase/migrations/00227_atomic_journey_booking_inventory.sql
public.journey_bookings	infrastructure/supabase/migrations/00227_atomic_journey_booking_inventory.sql
public.journey_legs	infrastructure/supabase/migrations/00224_connected_transport_core.sql
public.journey_order_hold_batches	infrastructure/supabase/migrations/00230_atomic_journey_orders.sql
public.journey_order_items	infrastructure/supabase/migrations/00230_atomic_journey_orders.sql
public.journey_order_sessions	infrastructure/supabase/migrations/00230_atomic_journey_orders.sql
public.journey_orders	infrastructure/supabase/migrations/00230_atomic_journey_orders.sql
public.journey_quotes	infrastructure/supabase/migrations/00224_connected_transport_core.sql
public.journey_resource_hold_batches	infrastructure/supabase/migrations/00227_atomic_journey_booking_inventory.sql
public.journey_seat_assignments	infrastructure/supabase/migrations/00227_atomic_journey_booking_inventory.sql
public.journey_ticket_checkins	infrastructure/supabase/migrations/00247_canonical_journey_ticket_boarding.sql
public.journey_ticket_no_shows	infrastructure/supabase/migrations/00252_driver_trip_execution_read_model.sql
public.journey_tickets	infrastructure/supabase/migrations/00227_atomic_journey_booking_inventory.sql
public.journeys	infrastructure/supabase/migrations/00224_connected_transport_core.sql
public.login_audit	infrastructure/supabase/migrations/00161_login_audit.sql
public.notification_deliveries	infrastructure/supabase/migrations/00217_enterprise_notification_delivery.sql
public.notification_delivery_attempts	infrastructure/supabase/migrations/00217_enterprise_notification_delivery.sql
public.notification_delivery_events	infrastructure/supabase/migrations/00217_enterprise_notification_delivery.sql
public.notification_fanout_jobs	infrastructure/supabase/migrations/00217_enterprise_notification_delivery.sql
public.notification_fanout_targets	infrastructure/supabase/migrations/00217_enterprise_notification_delivery.sql
public.notification_template_versions	infrastructure/supabase/migrations/00217_enterprise_notification_delivery.sql
public.operational_alerts	infrastructure/supabase/migrations/00225_connected_operations_control.sql
public.partner_commercial_terms	infrastructure/supabase/migrations/00226_partner_quality_settlements.sql
public.partner_settlement_adjustments	infrastructure/supabase/migrations/00226_partner_quality_settlements.sql
public.partner_settlement_documents	infrastructure/supabase/migrations/00226_partner_quality_settlements.sql
public.partner_settlement_events	infrastructure/supabase/migrations/00226_partner_quality_settlements.sql
public.partner_settlement_generation_runs	infrastructure/supabase/migrations/00226_partner_quality_settlements.sql
public.partner_settlement_payments	infrastructure/supabase/migrations/00226_partner_quality_settlements.sql
public.partner_settlement_trip_lines	infrastructure/supabase/migrations/00226_partner_quality_settlements.sql
public.partner_settlements	infrastructure/supabase/migrations/00226_partner_quality_settlements.sql
public.pii_backfill_checkpoint	infrastructure/supabase/migrations/00158_pii_backfill_checkpoint.sql
public.quality_metric_definitions	infrastructure/supabase/migrations/00226_partner_quality_settlements.sql
public.quality_sla_breaches	infrastructure/supabase/migrations/00226_partner_quality_settlements.sql
public.quality_sla_rules	infrastructure/supabase/migrations/00226_partner_quality_settlements.sql
public.resource_types	infrastructure/supabase/migrations/00224_connected_transport_core.sql
public.route_stops	infrastructure/supabase/migrations/00224_connected_transport_core.sql
public.saved_filter_views	infrastructure/supabase/migrations/00219_global_product_foundation.sql
public.seat_locks	infrastructure/supabase/migrations/00131_repair_booking_seat_lock_schema.sql
public.seat_types	infrastructure/supabase/migrations/00137_restore_resource_contract_compatibility.sql
public.stops	infrastructure/supabase/migrations/00224_connected_transport_core.sql
public.telegram_chat_links	infrastructure/supabase/migrations/00113_telegram_chat_links.sql
public.token_blocklist	infrastructure/supabase/migrations/00137_restore_resource_contract_compatibility.sql
public.traveler_auth_identities	infrastructure/supabase/migrations/00221_traveler_identity_and_booking_continuity.sql
public.traveler_booking_flows	infrastructure/supabase/migrations/00221_traveler_identity_and_booking_continuity.sql
public.traveler_identity_events	infrastructure/supabase/migrations/00221_traveler_identity_and_booking_continuity.sql
public.traveler_journey_change_requests	infrastructure/supabase/migrations/00246_traveler_journey_self_service.sql
public.trip_announcements	infrastructure/supabase/migrations/00225_connected_operations_control.sql
public.trip_disruptions	infrastructure/supabase/migrations/00225_connected_operations_control.sql
public.trip_marketing_media	infrastructure/supabase/migrations/00220_public_company_profiles_and_trip_media.sql
public.trip_operation_events	infrastructure/supabase/migrations/00213_company_trip_dispatch.sql
public.trip_resource_holds	infrastructure/supabase/migrations/00224_connected_transport_core.sql
public.trip_resource_inventory	infrastructure/supabase/migrations/00224_connected_transport_core.sql
public.trip_schedules	infrastructure/supabase/migrations/00137_restore_resource_contract_compatibility.sql
public.trip_stop_calls	infrastructure/supabase/migrations/00224_connected_transport_core.sql
public.verified_second_factor_sessions	infrastructure/supabase/migrations/00185_verified_second_factor_sessions.sql
push_subscriptions	infrastructure/supabase/migrations/00091_notification_system.sql
routes	infrastructure/supabase/migrations/00001_complete_schema.sql
seat_locks	infrastructure/supabase/migrations/00020_seat_locks.sql
seat_type_definitions	infrastructure/supabase/migrations/00122_ensure_dashboard_seat_types_and_feedback.sql
seats	infrastructure/supabase/migrations/00023_create_seats_table.sql
session_config	infrastructure/supabase/migrations/00079_session_configuration.sql
support_tickets	infrastructure/supabase/migrations/00001_complete_schema.sql
ticket_escalations	infrastructure/supabase/migrations/00001_complete_schema.sql
ticket_messages	infrastructure/supabase/migrations/00001_complete_schema.sql
token_blocklist	infrastructure/supabase/migrations/00077_token_blocklist.sql
trip_assignments	infrastructure/supabase/migrations/00001_complete_schema.sql
trip_feedback	infrastructure/supabase/migrations/00001_complete_schema.sql
trip_messages	infrastructure/supabase/migrations/00108_trip_messages.sql
trip_payments	infrastructure/supabase/migrations/00001_complete_schema.sql
trip_photos	infrastructure/supabase/migrations/00107_trip_photos.sql
trip_reviews	infrastructure/supabase/migrations/00019_trip_reviews.sql
trip_seat_overrides	infrastructure/supabase/migrations/00056_seat_configuration.sql
trips	infrastructure/supabase/migrations/00001_complete_schema.sql
waitlist	infrastructure/supabase/migrations/00116_ensure_waitlist_table.sql
whatsapp_message_queue	infrastructure/supabase/migrations/00001_complete_schema.sql

16 migration-declared views

view	Latest declaration
admin_dashboard_stats	infrastructure/supabase/migrations/00002_indexes_views_functions.sql
bookings_with_linked	infrastructure/supabase/migrations/00099_round_trip_bookings.sql
company_stats	infrastructure/supabase/migrations/00002_indexes_views_functions.sql
mv_company_stats	infrastructure/supabase/migrations/00002_indexes_views_functions.sql
pending_company_approvals	infrastructure/supabase/migrations/00002_indexes_views_functions.sql
public_companies	infrastructure/supabase/migrations/00171_demo_tenant_isolation.sql
public_testimonials	infrastructure/supabase/migrations/00176_public_testimonials.sql
public_trip_reviews	infrastructure/supabase/migrations/00174_public_trip_reviews.sql
public_trips	infrastructure/supabase/migrations/00171_demo_tenant_isolation.sql
public.public_companies	infrastructure/supabase/migrations/00288_trip_account_scope_isolation.sql
public.public_testimonials	infrastructure/supabase/migrations/00288_trip_account_scope_isolation.sql
public.public_trip_reviews	infrastructure/supabase/migrations/00288_trip_account_scope_isolation.sql
public.public_trips	infrastructure/supabase/migrations/00288_trip_account_scope_isolation.sql
public.seat_types	infrastructure/supabase/migrations/00219_global_product_foundation.sql
rejected_companies	infrastructure/supabase/migrations/00002_indexes_views_functions.sql
trip_seat_consistency	infrastructure/supabase/migrations/00094_fix_trip_seat_calculation.sql

554 migration-declared functions

function	Latest declaration
accept_group_booking_quote	infrastructure/supabase/migrations/00093_group_booking_system.sql
account_recovery_in_cooldown	infrastructure/supabase/migrations/00164_account_recovery.sql
add_loyalty_points	infrastructure/supabase/migrations/00100_fix_function_error_handling.sql
add_service_role_policy_if_missing	infrastructure/supabase/migrations/00090_add_missing_service_role_policies.sql
admin_has_permission	infrastructure/supabase/migrations/00003_functions.sql
approve_company	infrastructure/supabase/migrations/00003_functions.sql
audit_feature_flag_change	infrastructure/supabase/migrations/00088_add_feature_flags.sql
auth_passenger_ids	infrastructure/supabase/migrations/00175_fix_passenger_booking_rls_recursion.sql
auth_passenger_phones	infrastructure/supabase/migrations/00175_fix_passenger_booking_rls_recursion.sql
auth.email	infrastructure/supabase/migrations/00179_persist_auth_helpers_and_admin_acl.sql
auth.get_company_user_role	infrastructure/supabase/migrations/00169_fix_company_user_self_promotion.sql
auth.get_user_company_ids	infrastructure/supabase/migrations/00178_custom_demo_experience.sql
auth.is_company_admin	infrastructure/supabase/migrations/00178_custom_demo_experience.sql
auth.role	infrastructure/supabase/migrations/00179_persist_auth_helpers_and_admin_acl.sql
auth.uid	infrastructure/supabase/migrations/00179_persist_auth_helpers_and_admin_acl.sql
auto_complete_arrived_trips	infrastructure/supabase/migrations/00061_remaining_fixes.sql
auto_create_qr_token	infrastructure/supabase/migrations/00004_triggers_rls.sql
award_points_on_booking_completion	infrastructure/supabase/migrations/00100_fix_function_error_handling.sql
blocklist_all_user_tokens	infrastructure/supabase/migrations/00077_token_blocklist.sql
blocklist_token	infrastructure/supabase/migrations/00077_token_blocklist.sql
can_leave_feedback	infrastructure/supabase/migrations/00003_functions.sql
cancel_booking_atomic	infrastructure/supabase/migrations/00166_fix_duplicate_seat_decrement.sql
cancel_booking_reminders	infrastructure/supabase/migrations/00104_fix_booking_reminders_trigger.sql
cancel_expired_pending_bookings	infrastructure/supabase/migrations/00014_add_booking_expires_at.sql
cancel_round_trip	infrastructure/supabase/migrations/00100_fix_function_error_handling.sql
cancel_trip_with_bookings	infrastructure/supabase/migrations/00048_cascade_trip_cancellation.sql
cascade_trip_cancellation	infrastructure/supabase/migrations/00048_cascade_trip_cancellation.sql
check_bus_maintenance_conflict	infrastructure/supabase/migrations/00061_remaining_fixes.sql
check_company_can_be_suspended	infrastructure/supabase/migrations/00059_fix_additional_bugs.sql
check_feature_flag	infrastructure/supabase/migrations/00088_add_feature_flags.sql
check_seat_lock_limit	infrastructure/supabase/migrations/00057_fix_critical_security_issues.sql
cleanup_auth_data	infrastructure/supabase/migrations/00041_auth_otp_storage.sql
cleanup_expired_email_verifications	infrastructure/supabase/migrations/00043_email_verification.sql
cleanup_expired_invitations	infrastructure/supabase/migrations/00003_functions.sql
cleanup_expired_otps	infrastructure/supabase/migrations/00041_auth_otp_storage.sql
cleanup_expired_qr_tokens	infrastructure/supabase/migrations/00003_functions.sql
cleanup_expired_recovery_attempts	infrastructure/supabase/migrations/00164_account_recovery.sql
cleanup_expired_reset_tokens	infrastructure/supabase/migrations/00041_auth_otp_storage.sql
cleanup_expired_seat_locks	infrastructure/supabase/migrations/00020_seat_locks.sql
cleanup_expired_sessions	infrastructure/supabase/migrations/00079_session_configuration.sql
cleanup_old_sync_queue	infrastructure/supabase/migrations/00003_functions.sql
cleanup_token_blocklist	infrastructure/supabase/migrations/00086_fix_token_blocklist_audit.sql
clear_driver_current_trip	infrastructure/supabase/migrations/00004_triggers_rls.sql
confirm_seats_for_booking	infrastructure/supabase/migrations/00052_seat_lock_departure_validation.sql
create_booking_atomic	infrastructure/supabase/migrations/00110_fix_booking_seat_numbers_persistence.sql
create_booking_qr_token	infrastructure/supabase/migrations/00003_functions.sql
create_group_booking_request	infrastructure/supabase/migrations/00093_group_booking_system.sql
create_round_trip_booking	infrastructure/supabase/migrations/00100_fix_function_error_handling.sql
deactivate_push_subscription	infrastructure/supabase/migrations/00095_enhance_push_subscriptions.sql
decrease_seats_atomic	infrastructure/supabase/migrations/00051_atomic_seat_helpers.sql
demo_tenant_cap	infrastructure/supabase/migrations/00173_demo_provisioning.sql
disable_admin_2fa	infrastructure/supabase/migrations/00075_add_admin_2fa.sql
enable_admin_2fa	infrastructure/supabase/migrations/00075_add_admin_2fa.sql
enforce_trip_status_transitions	infrastructure/supabase/migrations/00070_fix_remaining_schema_issues.sql
extend_seat_lock	infrastructure/supabase/migrations/00049_fix_seat_lock_race_condition.sql
fix_all_seat_mismatches	infrastructure/supabase/migrations/00044_seat_reconciliation.sql
generate_booking_code	infrastructure/supabase/migrations/00057_fix_critical_security_issues.sql
generate_booking_hmac_token	infrastructure/supabase/migrations/00105_offline_qr_tokens.sql
generate_group_request_code	infrastructure/supabase/migrations/00093_group_booking_system.sql
generate_payment_code	infrastructure/supabase/migrations/00011_payment_system.sql
generate_qr_token	infrastructure/supabase/migrations/00003_functions.sql
generate_referral_code	infrastructure/supabase/migrations/00100_fix_function_error_handling.sql
generate_seat_numbers	infrastructure/supabase/migrations/00142_bus_layout_numbering_and_seat_helpers.sql
generate_ticket_number	infrastructure/supabase/migrations/00003_functions.sql
generate_unique_booking_code	infrastructure/supabase/migrations/00085_fix_booking_code_uniqueness.sql
get_admin_permissions	infrastructure/supabase/migrations/00003_functions.sql
get_admin_role	infrastructure/supabase/migrations/00089_fix_admin_users_rls_recursion.sql
get_booking_by_code	infrastructure/supabase/migrations/00057_fix_critical_security_issues.sql
get_company_feedback	infrastructure/supabase/migrations/00122_ensure_dashboard_seat_types_and_feedback.sql
get_company_open_incidents	infrastructure/supabase/migrations/00080_driver_incidents.sql
get_company_payment_stats	infrastructure/supabase/migrations/00011_payment_system.sql
get_company_rating	infrastructure/supabase/migrations/00003_functions.sql
get_company_stats	infrastructure/supabase/migrations/00124_fix_live_database_contract_drift.sql
get_expiring_driver_licenses	infrastructure/supabase/migrations/00061_remaining_fixes.sql
get_feature_flags	infrastructure/supabase/migrations/00088_add_feature_flags.sql
get_linked_booking	infrastructure/supabase/migrations/00100_fix_function_error_handling.sql
get_locked_seats	infrastructure/supabase/migrations/00049_fix_seat_lock_race_condition.sql
get_my_company_id	infrastructure/supabase/migrations/00003_functions.sql
get_notification_retries	infrastructure/supabase/migrations/00061_remaining_fixes.sql
get_or_create_loyalty_account	infrastructure/supabase/migrations/00100_fix_function_error_handling.sql
get_or_create_passenger	infrastructure/supabase/migrations/00059_fix_additional_bugs.sql
get_passenger_device_tokens	infrastructure/supabase/migrations/00087_add_push_notification_support.sql
get_pending_reminders	infrastructure/supabase/migrations/00104_fix_booking_reminders_trigger.sql
get_seat_price	infrastructure/supabase/migrations/00056_seat_configuration.sql
get_session_config	infrastructure/supabase/migrations/00079_session_configuration.sql
get_trip_qr_tokens	infrastructure/supabase/migrations/00105_offline_qr_tokens.sql
get_unread_notification_count	infrastructure/supabase/migrations/00091_notification_system.sql
get_upcoming_maintenance	infrastructure/supabase/migrations/00070_fix_remaining_schema_issues.sql
get_user_company_id	infrastructure/supabase/migrations/00076_improve_tenant_isolation.sql
grant_basic_admin_permission	infrastructure/supabase/migrations/00074_add_admin_view_permission.sql
initialize_trip_seats	infrastructure/supabase/migrations/00023_create_seats_table.sql
is_active_admin	infrastructure/supabase/migrations/00089_fix_admin_users_rls_recursion.sql
is_company_admin	infrastructure/supabase/migrations/00136_fix_company_admin_role_rls_case.sql
is_company_member	infrastructure/supabase/migrations/00003_functions.sql
is_company_owner	infrastructure/supabase/migrations/00003_functions.sql
is_seat_available	infrastructure/supabase/migrations/00056_seat_configuration.sql
is_super_admin	infrastructure/supabase/migrations/00089_fix_admin_users_rls_recursion.sql
is_token_blocked	infrastructure/supabase/migrations/00077_token_blocklist.sql
is_user_force_logged_out	infrastructure/supabase/migrations/00077_token_blocklist.sql
issue_company_warning	infrastructure/supabase/migrations/00003_functions.sql
lift_company_suspension	infrastructure/supabase/migrations/00003_functions.sql
lock_seats	infrastructure/supabase/migrations/00052_seat_lock_departure_validation.sql
lock_seats_atomic	infrastructure/supabase/migrations/00084_fix_seat_lock_ownership.sql
log_2fa_attempt	infrastructure/supabase/migrations/00075_add_admin_2fa.sql
log_admin_action	infrastructure/supabase/migrations/00010_fix_audit_log_function.sql
log_notification_attempt	infrastructure/supabase/migrations/00061_remaining_fixes.sql
manual_checkin	infrastructure/supabase/migrations/00150_fix_validate_checkin_assignment_status.sql
mark_all_notifications_read	infrastructure/supabase/migrations/00091_notification_system.sql
mark_no_show	infrastructure/supabase/migrations/00003_functions.sql
mark_noshow_bookings_for_completed_trips	infrastructure/supabase/migrations/00061_remaining_fixes.sql
mark_notification_retry	infrastructure/supabase/migrations/00061_remaining_fixes.sql
mark_reminder_sent	infrastructure/supabase/migrations/00098_booking_reminders.sql
normalize_phone	infrastructure/supabase/migrations/00003_functions.sql
normalize_syrian_phone	infrastructure/supabase/migrations/00057_fix_critical_security_issues.sql
notify_incident_created	infrastructure/supabase/migrations/00150_fix_validate_checkin_assignment_status.sql
prevent_trip_deletion_with_active_data	infrastructure/supabase/migrations/00059_fix_additional_bugs.sql
provision_demo_tenant	infrastructure/supabase/migrations/00173_demo_provisioning.sql
public._build_layout_document_from_grid	infrastructure/supabase/migrations/00143_backfill_bus_layout_document.sql
public.accept_document_share_grant	infrastructure/supabase/migrations/00302_database_authoritative_document_share_expiry.sql
public.activate_partner_commercial_terms	infrastructure/supabase/migrations/00226_partner_quality_settlements.sql
public.add_company_cash_adjustment	infrastructure/supabase/migrations/00211_company_cash_reconciliation.sql
public.add_company_loyalty_points	infrastructure/supabase/migrations/00255_company_owned_loyalty.sql
public.apply_company_loyalty_referral	infrastructure/supabase/migrations/00255_company_owned_loyalty.sql
public.apply_provider_payment_webhook	infrastructure/supabase/migrations/00211_company_cash_reconciliation.sql
public.approve_pending_confirmation_scope	infrastructure/supabase/migrations/00305_company_booking_confirmation_lifecycle.sql
public.assign_booking_cash_shift	infrastructure/supabase/migrations/00234_cash_shift_null_payment_guard.sql
public.assign_booking_document_number	infrastructure/supabase/migrations/00253_enterprise_booking_workspace_and_documents.sql
public.assign_connected_transport_reference	infrastructure/supabase/migrations/00224_connected_transport_core.sql
public.assign_financial_document_number	infrastructure/supabase/migrations/00218_enterprise_document_registry.sql
public.audit_feature_flag_change	infrastructure/supabase/migrations/00149_fix_feature_flag_audit_trigger.sql
public.auth_passenger_ids	infrastructure/supabase/migrations/00221_traveler_identity_and_booking_continuity.sql
public.auth_passenger_phones	infrastructure/supabase/migrations/00221_traveler_identity_and_booking_continuity.sql
public.authorize_document_share_session	infrastructure/supabase/migrations/00300_two_phase_document_share_delivery.sql
public.award_points_on_booking_completion	infrastructure/supabase/migrations/00255_company_owned_loyalty.sql
public.blocklist_token	infrastructure/supabase/migrations/00137_restore_resource_contract_compatibility.sql
public.bookings_set_company_id	infrastructure/supabase/migrations/00148_bookings_company_id.sql
public.build_company_booking_document_snapshot	infrastructure/supabase/migrations/00270_booking_confirmation_boarding_qr.sql
public.build_company_booking_snapshot	infrastructure/supabase/migrations/00280_booking_pickup_location_documents.sql
public.build_trip_stop_calls	infrastructure/supabase/migrations/00279_trip_pickup_locations.sql
public.calculate_company_quality_snapshot	infrastructure/supabase/migrations/00226_partner_quality_settlements.sql
public.can_access_company_network_resource	infrastructure/supabase/migrations/00256_connected_transport_directory_rls.sql
public.can_access_tenant	infrastructure/supabase/migrations/00288_trip_account_scope_isolation.sql
public.can_discover_company	infrastructure/supabase/migrations/00288_trip_account_scope_isolation.sql
public.can_manage_company_bus_resource	infrastructure/supabase/migrations/00256_connected_transport_directory_rls.sql
public.can_manage_driver_directory	infrastructure/supabase/migrations/00258_driver_directory_rls_boundary.sql
public.can_manage_route_pattern	infrastructure/supabase/migrations/00256_connected_transport_directory_rls.sql
public.can_read_booking_extra	infrastructure/supabase/migrations/00256_connected_transport_directory_rls.sql
public.can_read_company_bus_resource	infrastructure/supabase/migrations/00256_connected_transport_directory_rls.sql
public.can_read_company_cash_ledger	infrastructure/supabase/migrations/00241_cash_reconciliation_rls_predicate.sql
public.can_read_company_operational_alerts	infrastructure/supabase/migrations/00237_connected_operations_rls_predicates.sql
public.can_read_connected_journey	infrastructure/supabase/migrations/00249_connected_journey_rls_predicates.sql
public.can_read_connected_journey_booking	infrastructure/supabase/migrations/00249_connected_journey_rls_predicates.sql
public.can_read_driver_directory_entry	infrastructure/supabase/migrations/00258_driver_directory_rls_boundary.sql
public.can_read_public_trip_inventory	infrastructure/supabase/migrations/00256_connected_transport_directory_rls.sql
public.can_read_route_pattern	infrastructure/supabase/migrations/00256_connected_transport_directory_rls.sql
public.can_read_trip_announcements	infrastructure/supabase/migrations/00237_connected_operations_rls_predicates.sql
public.can_read_trip_disruptions	infrastructure/supabase/migrations/00237_connected_operations_rls_predicates.sql
public.can_read_trip_live_location	infrastructure/supabase/migrations/00238_live_operations_rls_consolidation.sql
public.can_read_trip_operation_events	infrastructure/supabase/migrations/00238_live_operations_rls_consolidation.sql
public.can_read_trip_resource_hold	infrastructure/supabase/migrations/00256_connected_transport_directory_rls.sql
public.can_read_trip_stop_calls	infrastructure/supabase/migrations/00238_live_operations_rls_consolidation.sql
public.can_view_partner_finance	infrastructure/supabase/migrations/00226_partner_quality_settlements.sql
public.cancel_booking_atomic	infrastructure/supabase/migrations/00197_enable_dispatcher_booking_cancellation.sql
public.cancel_booking_reminders	infrastructure/supabase/migrations/00217_enterprise_notification_delivery.sql
public.cancel_company_payment	infrastructure/supabase/migrations/00211_company_cash_reconciliation.sql
public.cancel_pending_confirmation_scope	infrastructure/supabase/migrations/00305_company_booking_confirmation_lifecycle.sql
public.cancel_traveler_journey	infrastructure/supabase/migrations/00246_traveler_journey_self_service.sql
public.canonical_trip_seat_numbers	infrastructure/supabase/migrations/00196_atomic_company_booking_contract.sql
public.cascade_trip_cancellation	infrastructure/supabase/migrations/00217_enterprise_notification_delivery.sql
public.check_rate_limit	infrastructure/supabase/migrations/00071_fix_critical_bugs.sql
public.claim_notification_deliveries	infrastructure/supabase/migrations/00217_enterprise_notification_delivery.sql
public.claim_notification_fanout_jobs	infrastructure/supabase/migrations/00217_enterprise_notification_delivery.sql
public.cleanup_expired_email_verifications	infrastructure/supabase/migrations/00127_ensure_passenger_email_verification_contract.sql
public.cleanup_expired_seat_locks	infrastructure/supabase/migrations/00131_repair_booking_seat_lock_schema.sql
public.cleanup_login_audit	infrastructure/supabase/migrations/00161_login_audit.sql
public.cleanup_rate_limits	infrastructure/supabase/migrations/00071_fix_critical_bugs.sql
public.cleanup_token_blocklist	infrastructure/supabase/migrations/00137_restore_resource_contract_compatibility.sql
public.close_company_cash_shift	infrastructure/supabase/migrations/00211_company_cash_reconciliation.sql
public.close_journey_order_hold_batch	infrastructure/supabase/migrations/00231_journey_order_hold_lifecycle.sql
public.close_journey_resource_hold_batch	infrastructure/supabase/migrations/00227_atomic_journey_booking_inventory.sql
public.collect_trip_payment	infrastructure/supabase/migrations/00183_atomic_driver_payment_collection.sql
public.company_public_slug	infrastructure/supabase/migrations/00220_public_company_profiles_and_trip_media.sql
public.complete_notification_delivery	infrastructure/supabase/migrations/00217_enterprise_notification_delivery.sql
public.complete_traveler_phone_identity	infrastructure/supabase/migrations/00223_traveler_phone_completion.sql
public.confirm_company_booking	infrastructure/supabase/migrations/00213_company_trip_dispatch.sql
public.confirm_journey_booking_atomic	infrastructure/supabase/migrations/00227_atomic_journey_booking_inventory.sql
public.confirm_journey_booking_for_actor_atomic	infrastructure/supabase/migrations/00305_company_booking_confirmation_lifecycle.sql
public.confirm_journey_booking_with_identity_atomic	infrastructure/supabase/migrations/00271_booking_guest_access_sessions.sql
public.confirm_journey_order_atomic	infrastructure/supabase/migrations/00230_atomic_journey_orders.sql
public.confirm_journey_order_for_actor_atomic	infrastructure/supabase/migrations/00305_company_booking_confirmation_lifecycle.sql
public.confirm_journey_order_with_identity_atomic	infrastructure/supabase/migrations/00271_booking_guest_access_sessions.sql
public.create_booking_atomic	infrastructure/supabase/migrations/00194_repair_seat_lock_booking_contract.sql
public.create_booking_core_atomic	infrastructure/supabase/migrations/00194_repair_seat_lock_booking_contract.sql
public.create_booking_qr_token	infrastructure/supabase/migrations/00305_company_booking_confirmation_lifecycle.sql
public.create_booking_with_lock_atomic	infrastructure/supabase/migrations/00194_repair_seat_lock_booking_contract.sql
public.create_company_booking_atomic	infrastructure/supabase/migrations/00196_atomic_company_booking_contract.sql
public.create_company_trip	infrastructure/supabase/migrations/00279_trip_pickup_locations.sql
public.create_customer_booking_atomic	infrastructure/supabase/migrations/00205_apply_loyalty_rewards_to_customer_bookings.sql
public.create_customer_round_trip_booking_atomic	infrastructure/supabase/migrations/00205_apply_loyalty_rewards_to_customer_bookings.sql
public.create_demo_bus_layout_after_insert	infrastructure/supabase/migrations/00180_demo_bus_layouts.sql
public.create_demo_tenant	infrastructure/supabase/migrations/00178_custom_demo_experience.sql
public.create_document_share_grant	infrastructure/supabase/migrations/00302_database_authoritative_document_share_expiry.sql
public.create_journey_order_quote_atomic	infrastructure/supabase/migrations/00230_atomic_journey_orders.sql
public.create_journey_quote_atomic	infrastructure/supabase/migrations/00227_atomic_journey_booking_inventory.sql
public.create_partner_commercial_terms	infrastructure/supabase/migrations/00226_partner_quality_settlements.sql
public.create_round_trip_booking_with_locks_atomic	infrastructure/supabase/migrations/00194_repair_seat_lock_booking_contract.sql
public.create_trip_notification_fanout_job	infrastructure/supabase/migrations/00225_connected_operations_control.sql
public.current_active_admin_user_id	infrastructure/supabase/migrations/00226_partner_quality_settlements.sql
public.current_demo_company_id	infrastructure/supabase/migrations/00288_trip_account_scope_isolation.sql
public.current_finance_admin_user_id	infrastructure/supabase/migrations/00226_partner_quality_settlements.sql
public.current_traveler_discovery_scope	infrastructure/supabase/migrations/00288_trip_account_scope_isolation.sql
public.decide_company_booking_confirmation	infrastructure/supabase/migrations/00305_company_booking_confirmation_lifecycle.sql
public.delete_company_trip_draft	infrastructure/supabase/migrations/00213_company_trip_dispatch.sql
public.disable_admin_2fa	infrastructure/supabase/migrations/00156_security_audit_remediation.sql
public.disconnect_traveler_identity	infrastructure/supabase/migrations/00221_traveler_identity_and_booking_continuity.sql
public.enable_admin_2fa	infrastructure/supabase/migrations/00156_security_audit_remediation.sql
public.enforce_cash_only_customer_payment_provider	infrastructure/supabase/migrations/00278_online_payments_development_only.sql
public.enforce_cash_only_driver_payment_method	infrastructure/supabase/migrations/00278_online_payments_development_only.sql
public.enforce_trip_status_transitions	infrastructure/supabase/migrations/00213_company_trip_dispatch.sql
public.enqueue_booking_reminder_notification	infrastructure/supabase/migrations/00217_enterprise_notification_delivery.sql
public.enqueue_due_booking_reminders	infrastructure/supabase/migrations/00217_enterprise_notification_delivery.sql
public.enqueue_journey_confirmation_lifecycle_event	infrastructure/supabase/migrations/00305_company_booking_confirmation_lifecycle.sql
public.enqueue_templated_notification	infrastructure/supabase/migrations/00282_notification_pickup_context.sql
public.ensure_booking_journey	infrastructure/supabase/migrations/00224_connected_transport_core.sql
public.ensure_booking_journey_aggregate	infrastructure/supabase/migrations/00227_atomic_journey_booking_inventory.sql
public.ensure_company_default_seat_types	infrastructure/supabase/migrations/00219_global_product_foundation.sql
public.ensure_default_city_stop	infrastructure/supabase/migrations/00224_connected_transport_core.sql
public.ensure_demo_bus_layout	infrastructure/supabase/migrations/00180_demo_bus_layouts.sql
public.ensure_legacy_booking_journey_session	infrastructure/supabase/migrations/00295_runtime_schema_client_grant_hardening.sql
public.ensure_legacy_booking_journey_session_trigger	infrastructure/supabase/migrations/00295_runtime_schema_client_grant_hardening.sql
public.ensure_seed_bus_layout	infrastructure/supabase/migrations/00236_seed_bus_layout_provisioning.sql
public.expand_notification_fanout_job	infrastructure/supabase/migrations/00225_connected_operations_control.sql
public.expire_due_company_booking_confirmations	infrastructure/supabase/migrations/00305_company_booking_confirmation_lifecycle.sql
public.expire_journey_order_holds	infrastructure/supabase/migrations/00231_journey_order_hold_lifecycle.sql
public.expire_journey_resource_holds	infrastructure/supabase/migrations/00227_atomic_journey_booking_inventory.sql
public.extend_demo_tenant	infrastructure/supabase/migrations/00178_custom_demo_experience.sql
public.fail_notification_fanout_job	infrastructure/supabase/migrations/00217_enterprise_notification_delivery.sql
public.finalize_booking_trip_reassignment	infrastructure/supabase/migrations/00263_canonical_booking_trip_reassignment.sql
public.finalize_booking_trip_reassignment_trigger	infrastructure/supabase/migrations/00263_canonical_booking_trip_reassignment.sql
public.generate_booking_hmac_token	infrastructure/supabase/migrations/00305_company_booking_confirmation_lifecycle.sql
public.generate_company_referral_code	infrastructure/supabase/migrations/00255_company_owned_loyalty.sql
public.generate_partner_settlement	infrastructure/supabase/migrations/00226_partner_quality_settlements.sql
public.generate_referral_code	infrastructure/supabase/migrations/00129_ensure_customer_settings_and_loyalty_contracts.sql
public.generate_unique_booking_code	infrastructure/supabase/migrations/00130_harden_booking_transition_contracts.sql
public.get_auth_user_id_by_phone	infrastructure/supabase/migrations/00162_get_auth_user_id_by_phone.sql
public.get_booking_by_code	infrastructure/supabase/migrations/00138_fix_remaining_resource_contract_data.sql
public.get_company_booking_workspace	infrastructure/supabase/migrations/00305_company_booking_confirmation_lifecycle.sql
public.get_company_cash_collected	infrastructure/supabase/migrations/00211_company_cash_reconciliation.sql
public.get_company_cash_shift_summary	infrastructure/supabase/migrations/00211_company_cash_reconciliation.sql
public.get_company_loyalty_workspace	infrastructure/supabase/migrations/00255_company_owned_loyalty.sql
public.get_company_operations_control	infrastructure/supabase/migrations/00239_operations_exception_priority.sql
public.get_company_partner_settlements	infrastructure/supabase/migrations/00226_partner_quality_settlements.sql
public.get_company_trip_dispatch	infrastructure/supabase/migrations/00213_company_trip_dispatch.sql
public.get_company_trip_dispatch_v2	infrastructure/supabase/migrations/00283_trip_dispatch_pickup_projection.sql
public.get_company_trip_schedules	infrastructure/supabase/migrations/00212_recurring_trip_series.sql
public.get_company_trip_seat_inventory	infrastructure/supabase/migrations/00196_atomic_company_booking_contract.sql
public.get_dashboard_advanced_analytics	infrastructure/supabase/migrations/00201_dashboard_advanced_analytics.sql
public.get_dashboard_analytics_snapshot	infrastructure/supabase/migrations/00215_reassert_checked_in_reporting.sql
public.get_dashboard_bookings_page	infrastructure/supabase/migrations/00215_reassert_checked_in_reporting.sql
public.get_dashboard_fleet_operations	infrastructure/supabase/migrations/00213_company_trip_dispatch.sql
public.get_dashboard_payment_ledger	infrastructure/supabase/migrations/00210_unified_company_payment_ledger.sql
public.get_dashboard_routes_overview	infrastructure/supabase/migrations/00190_dashboard_routes_overview.sql
public.get_dashboard_trips_page	infrastructure/supabase/migrations/00251_indexed_dashboard_trip_page.sql
public.get_demo_passenger_launch_option	infrastructure/supabase/migrations/00295_runtime_schema_client_grant_hardening.sql
public.get_driver_trip_execution	infrastructure/supabase/migrations/00305_company_booking_confirmation_lifecycle.sql
public.get_journey_checkout	infrastructure/supabase/migrations/00305_company_booking_confirmation_lifecycle.sql
public.get_journey_confirmation_projection	infrastructure/supabase/migrations/00305_company_booking_confirmation_lifecycle.sql
public.get_journey_order_checkout	infrastructure/supabase/migrations/00305_company_booking_confirmation_lifecycle.sql
public.get_locked_seats	infrastructure/supabase/migrations/00194_repair_seat_lock_booking_contract.sql
public.get_or_create_company_loyalty_account	infrastructure/supabase/migrations/00255_company_owned_loyalty.sql
public.get_or_create_loyalty_account	infrastructure/supabase/migrations/00129_ensure_customer_settings_and_loyalty_contracts.sql
public.get_partner_settlement_details	infrastructure/supabase/migrations/00226_partner_quality_settlements.sql
public.get_partner_settlement_trip_lines	infrastructure/supabase/migrations/00226_partner_quality_settlements.sql
public.get_platform_partner_quality_comparison	infrastructure/supabase/migrations/00226_partner_quality_settlements.sql
public.get_public_company_profile	infrastructure/supabase/migrations/00222_global_product_api_contracts.sql
public.get_public_trip_tracking	infrastructure/supabase/migrations/00225_connected_operations_control.sql
public.get_traveler_booking_billing_address	infrastructure/supabase/migrations/00277_card_payment_billing_details.sql
public.get_traveler_journey_tracking	infrastructure/supabase/migrations/00244_traveler_journey_tracking.sql
public.get_trip_boarding_credentials	infrastructure/supabase/migrations/00247_canonical_journey_ticket_boarding.sql
public.get_trip_dispatch_blockers	infrastructure/supabase/migrations/00213_company_trip_dispatch.sql
public.get_trip_qr_tokens	infrastructure/supabase/migrations/00208_reassert_offline_qr_token_contract.sql
public.get_trip_resource_conflicts	infrastructure/supabase/migrations/00212_recurring_trip_series.sql
public.get_trip_series_conflicts	infrastructure/supabase/migrations/00212_recurring_trip_series.sql
public.get_user_company_id	infrastructure/supabase/migrations/00178_custom_demo_experience.sql
public.guard_pending_booking_confirmation_document	infrastructure/supabase/migrations/00305_company_booking_confirmation_lifecycle.sql
public.has_company_loyalty_management_access	infrastructure/supabase/migrations/00255_company_owned_loyalty.sql
public.hold_journey_order_resources_atomic	infrastructure/supabase/migrations/00230_atomic_journey_orders.sql
public.hold_journey_resources_atomic	infrastructure/supabase/migrations/00227_atomic_journey_booking_inventory.sql
public.increment_assignment_checkin	infrastructure/supabase/migrations/00071_fix_critical_bugs.sql
public.increment_assignment_collected	infrastructure/supabase/migrations/00071_fix_critical_bugs.sql
public.initialize_journey_booking_confirmation	infrastructure/supabase/migrations/00305_company_booking_confirmation_lifecycle.sql
public.initialize_journey_order_confirmation	infrastructure/supabase/migrations/00305_company_booking_confirmation_lifecycle.sql
public.initialize_legacy_booking_confirmation_trigger	infrastructure/supabase/migrations/00306_legacy_booking_confirmation_projection.sql
public.initialize_trip_seats	infrastructure/supabase/migrations/00188_optimize_trip_seat_initialization.sql
public.inspect_customer_loyalty_redemption	infrastructure/supabase/migrations/00255_company_owned_loyalty.sql
public.invalid_trip_seat_numbers	infrastructure/supabase/migrations/00194_repair_seat_lock_booking_contract.sql
public.is_admin	infrastructure/supabase/migrations/00003_functions.sql
public.is_assignment_operational	infrastructure/supabase/migrations/00178_custom_demo_experience.sql
public.is_booking_operational	infrastructure/supabase/migrations/00178_custom_demo_experience.sql
public.is_bus_operational	infrastructure/supabase/migrations/00178_custom_demo_experience.sql
public.is_company_operational	infrastructure/supabase/migrations/00178_custom_demo_experience.sql
public.is_company_user_operational	infrastructure/supabase/migrations/00178_custom_demo_experience.sql
public.is_driver_operational	infrastructure/supabase/migrations/00178_custom_demo_experience.sql
public.is_group_request_operational	infrastructure/supabase/migrations/00178_custom_demo_experience.sql
public.is_internal_account	infrastructure/supabase/migrations/00288_trip_account_scope_isolation.sql
public.is_loyalty_account_operational	infrastructure/supabase/migrations/00178_custom_demo_experience.sql
public.is_own_driver	infrastructure/supabase/migrations/00119_fix_driver_auth_rls.sql
public.is_passenger_operational	infrastructure/supabase/migrations/00178_custom_demo_experience.sql
public.is_route_operational	infrastructure/supabase/migrations/00178_custom_demo_experience.sql
public.is_token_blocked	infrastructure/supabase/migrations/00137_restore_resource_contract_compatibility.sql
public.is_trip_operational	infrastructure/supabase/migrations/00178_custom_demo_experience.sql
public.is_valid_company_trip_pickup	infrastructure/supabase/migrations/00279_trip_pickup_locations.sql
public.issue_booking_document	infrastructure/supabase/migrations/00270_booking_confirmation_boarding_qr.sql
public.issue_financial_document	infrastructure/supabase/migrations/00218_enterprise_document_registry.sql
public.journey_booking_boarding_authorized	infrastructure/supabase/migrations/00305_company_booking_confirmation_lifecycle.sql
public.journey_order_boarding_authorized	infrastructure/supabase/migrations/00305_company_booking_confirmation_lifecycle.sql
public.link_admin_user	infrastructure/supabase/migrations/00003_functions.sql
public.link_google_traveler_identity_to_account	infrastructure/supabase/migrations/00269_safe_google_traveler_identity_linking.sql
public.link_traveler_identity	infrastructure/supabase/migrations/00221_traveler_identity_and_booking_continuity.sql
public.list_traveler_journey_history	infrastructure/supabase/migrations/00305_company_booking_confirmation_lifecycle.sql
public.lock_company_cash_ledger	infrastructure/supabase/migrations/00211_company_cash_reconciliation.sql
public.lock_seats	infrastructure/supabase/migrations/00194_repair_seat_lock_booking_contract.sql
public.lock_seats_atomic	infrastructure/supabase/migrations/00194_repair_seat_lock_booking_contract.sql
public.log_2fa_attempt	infrastructure/supabase/migrations/00184_fix_admin_2fa_audit_logging.sql
public.log_admin_action	infrastructure/supabase/migrations/00177_general_audit_log.sql
public.log_notification_attempt	infrastructure/supabase/migrations/00217_enterprise_notification_delivery.sql
public.manual_checkin	infrastructure/supabase/migrations/00259_driver_attendance_and_incident_corrections.sql
public.manual_checkin_journey_ticket	infrastructure/supabase/migrations/00252_driver_trip_execution_read_model.sql
public.mark_driver_assignment_en_route	infrastructure/supabase/migrations/00213_company_trip_dispatch.sql
public.mask_notification_recipient	infrastructure/supabase/migrations/00217_enterprise_notification_delivery.sql
public.modify_booking_atomic	infrastructure/supabase/migrations/00202_atomic_customer_booking_modification.sql
public.next_journey_booking_reference	infrastructure/supabase/migrations/00227_atomic_journey_booking_inventory.sql
public.next_journey_order_reference	infrastructure/supabase/migrations/00230_atomic_journey_orders.sql
public.next_journey_ticket_reference	infrastructure/supabase/migrations/00227_atomic_journey_booking_inventory.sql
public.normalize_booking_payment_truth	infrastructure/supabase/migrations/00210_unified_company_payment_ledger.sql
public.occupied_trip_seat_numbers	infrastructure/supabase/migrations/00268_preserve_checked_in_seat_occupancy.sql
public.open_company_cash_shift	infrastructure/supabase/migrations/00211_company_cash_reconciliation.sql
public.perform_driver_checkin	infrastructure/supabase/migrations/00225_connected_operations_control.sql
public.plan_company_trip_series	infrastructure/supabase/migrations/00279_trip_pickup_locations.sql
public.popular_routes_aggregate	infrastructure/supabase/migrations/00288_trip_account_scope_isolation.sql
public.populate_booking_family_name_snapshot	infrastructure/supabase/migrations/00271_booking_guest_access_sessions.sql
public.prepare_booking_trip_reassignment	infrastructure/supabase/migrations/00263_canonical_booking_trip_reassignment.sql
public.prepare_booking_trip_reassignment_trigger	infrastructure/supabase/migrations/00263_canonical_booking_trip_reassignment.sql
public.prepare_company_public_profile	infrastructure/supabase/migrations/00220_public_company_profiles_and_trip_media.sql
public.prevent_trip_deletion_with_active_data	infrastructure/supabase/migrations/00250_connected_demo_tenant_lifecycle.sql
public.prevent_untrusted_internal_company_scope	infrastructure/supabase/migrations/00288_trip_account_scope_isolation.sql
public.preview_customer_loyalty_redemption	infrastructure/supabase/migrations/00205_apply_loyalty_rewards_to_customer_bookings.sql
public.preview_document_share_grant	infrastructure/supabase/migrations/00298_secure_document_share_grants.sql
public.project_traveler_history_confirmation	infrastructure/supabase/migrations/00305_company_booking_confirmation_lifecycle.sql
public.promote_trip_marketing_media	infrastructure/supabase/migrations/00222_global_product_api_contracts.sql
public.protect_document_share_session_identity	infrastructure/supabase/migrations/00298_secure_document_share_grants.sql
public.protect_partner_settlement_document	infrastructure/supabase/migrations/00250_connected_demo_tenant_lifecycle.sql
public.protect_trip_history_deletion	infrastructure/supabase/migrations/00250_connected_demo_tenant_lifecycle.sql
public.protect_trip_review_identity	infrastructure/supabase/migrations/00216_reassert_secure_customer_trip_reviews.sql
public.provision_bus_resource_capacities	infrastructure/supabase/migrations/00224_connected_transport_core.sql
public.provision_company_cash_payment_settings	infrastructure/supabase/migrations/00297_company_cash_payment_settings_provisioning.sql
public.provision_company_loyalty_program	infrastructure/supabase/migrations/00255_company_owned_loyalty.sql
public.provision_company_loyalty_program_for	infrastructure/supabase/migrations/00255_company_owned_loyalty.sql
public.provision_company_partner_terms	infrastructure/supabase/migrations/00226_partner_quality_settlements.sql
public.provision_company_traveler_policy	infrastructure/supabase/migrations/00246_traveler_journey_self_service.sql
public.provision_default_city_stop_on_insert	infrastructure/supabase/migrations/00233_default_city_stop_lifecycle.sql
public.provision_route_terminal_stops	infrastructure/supabase/migrations/00224_connected_transport_core.sql
public.publish_new_isolated_demo_profile	infrastructure/supabase/migrations/00295_runtime_schema_client_grant_hardening.sql
public.publish_trip_announcement	infrastructure/supabase/migrations/00225_connected_operations_control.sql
public.purge_demo_document_share_children	infrastructure/supabase/migrations/00303_document_share_demo_lifecycle.sql
public.purge_demo_tenant_operational_world	infrastructure/supabase/migrations/00250_connected_demo_tenant_lifecycle.sql
public.purge_expired_booking_guest_access_sessions	infrastructure/supabase/migrations/00271_booking_guest_access_sessions.sql
public.purge_notification_delivery_pii	infrastructure/supabase/migrations/00217_enterprise_notification_delivery.sql
public.queue_booking_notification_event	infrastructure/supabase/migrations/00306_legacy_booking_confirmation_projection.sql
public.queue_manual_booking_reminder	infrastructure/supabase/migrations/00217_enterprise_notification_delivery.sql
public.queue_trip_cancellation_notifications	infrastructure/supabase/migrations/00217_enterprise_notification_delivery.sql
public.queue_trip_notification_fanout	infrastructure/supabase/migrations/00217_enterprise_notification_delivery.sql
public.quote_traveler_journey_cancellation	infrastructure/supabase/migrations/00246_traveler_journey_self_service.sql
public.reap_expired_demos	infrastructure/supabase/migrations/00250_connected_demo_tenant_lifecycle.sql
public.recalculate_all_trip_seats	infrastructure/supabase/migrations/00206_reassert_seat_capacity_ownership.sql
public.recompute_driver_assignment_attendance	infrastructure/supabase/migrations/00252_driver_trip_execution_read_model.sql
public.reconcile_partner_settlement_trip_line	infrastructure/supabase/migrations/00226_partner_quality_settlements.sql
public.reconcile_trip_resource_inventory	infrastructure/supabase/migrations/00266_reconcile_converted_seat_locks_once.sql
public.record_demo_access	infrastructure/supabase/migrations/00178_custom_demo_experience.sql
public.record_document_share_delivery	infrastructure/supabase/migrations/00300_two_phase_document_share_delivery.sql
public.record_driver_telemetry	infrastructure/supabase/migrations/00225_connected_operations_control.sql
public.record_notification_delivery_event	infrastructure/supabase/migrations/00217_enterprise_notification_delivery.sql
public.record_partner_settlement_adjustment	infrastructure/supabase/migrations/00226_partner_quality_settlements.sql
public.record_partner_settlement_payment	infrastructure/supabase/migrations/00226_partner_quality_settlements.sql
public.record_trip_stop_event	infrastructure/supabase/migrations/00225_connected_operations_control.sql
public.redeem_company_loyalty_reward	infrastructure/supabase/migrations/00255_company_owned_loyalty.sql
public.redeem_loyalty_reward	infrastructure/supabase/migrations/00204_atomic_loyalty_reward_redemption.sql
public.refresh_active_trip_gps_health	infrastructure/supabase/migrations/00225_connected_operations_control.sql
public.refresh_notification_delivery_state	infrastructure/supabase/migrations/00217_enterprise_notification_delivery.sql
public.refresh_partner_settlement_rollup	infrastructure/supabase/migrations/00226_partner_quality_settlements.sql
public.refresh_partner_settlement_totals	infrastructure/supabase/migrations/00226_partner_quality_settlements.sql
public.refund_company_payment	infrastructure/supabase/migrations/00211_company_cash_reconciliation.sql
public.register_partner_settlement_document	infrastructure/supabase/migrations/00226_partner_quality_settlements.sql
public.reject_booking_document_mutation	infrastructure/supabase/migrations/00253_enterprise_booking_workspace_and_documents.sql
public.reject_document_share_event_mutation	infrastructure/supabase/migrations/00303_document_share_demo_lifecycle.sql
public.reject_financial_document_mutation	infrastructure/supabase/migrations/00250_connected_demo_tenant_lifecycle.sql
public.release_journey_order_hold_atomic	infrastructure/supabase/migrations/00231_journey_order_hold_lifecycle.sql
public.release_journey_resource_hold_atomic	infrastructure/supabase/migrations/00231_journey_order_hold_lifecycle.sql
public.release_seat_locks	infrastructure/supabase/migrations/00194_repair_seat_lock_booking_contract.sql
public.report_trip_disruption	infrastructure/supabase/migrations/00225_connected_operations_control.sql
public.reschedule_trip_booking_reminders	infrastructure/supabase/migrations/00217_enterprise_notification_delivery.sql
public.reset_demo_tenant	infrastructure/supabase/migrations/00250_connected_demo_tenant_lifecycle.sql
public.resolve_booking_reference_for_guest	infrastructure/supabase/migrations/00271_booking_guest_access_sessions.sql
public.resolve_document_share_issuer	infrastructure/supabase/migrations/00304_document_share_finance_role_scope.sql
public.resolve_document_share_session	infrastructure/supabase/migrations/00298_secure_document_share_grants.sql
public.resolve_google_traveler_auth_candidate	infrastructure/supabase/migrations/00267_native_google_traveler_auth_candidate.sql
public.retry_notification_delivery	infrastructure/supabase/migrations/00217_enterprise_notification_delivery.sql
public.retry_partner_settlement_generation_run	infrastructure/supabase/migrations/00226_partner_quality_settlements.sql
public.reverse_journey_ticket_no_show_on_checkin	infrastructure/supabase/migrations/00259_driver_attendance_and_incident_corrections.sql
public.revoke_demo_tenant	infrastructure/supabase/migrations/00178_custom_demo_experience.sql
public.revoke_document_share_grant	infrastructure/supabase/migrations/00298_secure_document_share_grants.sql
public.revoke_document_share_grant_by_auth_user	infrastructure/supabase/migrations/00301_complete_document_share_issuer_roles.sql
public.rotate_demo_access	infrastructure/supabase/migrations/00178_custom_demo_experience.sql
public.run_due_partner_settlements	infrastructure/supabase/migrations/00226_partner_quality_settlements.sql
public.save_bus_creation_draft	infrastructure/supabase/migrations/00222_global_product_api_contracts.sql
public.save_bus_layout_document	infrastructure/supabase/migrations/00147_save_bus_layout_document_post_drop.sql
public.save_filter_view	infrastructure/supabase/migrations/00222_global_product_api_contracts.sql
public.schedule_booking_reminders	infrastructure/supabase/migrations/00217_enterprise_notification_delivery.sql
public.search_journey_options	infrastructure/supabase/migrations/00228_journey_discovery.sql
public.seed_company_booking_confirmation_policy	infrastructure/supabase/migrations/00305_company_booking_confirmation_lifecycle.sql
public.seed_company_default_seat_types	infrastructure/supabase/migrations/00219_global_product_foundation.sql
public.seed_demo_company_world	infrastructure/supabase/migrations/00178_custom_demo_experience.sql
public.set_booking_price_breakdown_defaults	infrastructure/supabase/migrations/00205_apply_loyalty_rewards_to_customer_bookings.sql
public.set_company_trip_manifest_attendance	infrastructure/supabase/migrations/00254_company_ticket_attendance.sql
public.set_company_trip_passenger_attendance	infrastructure/supabase/migrations/00213_company_trip_dispatch.sql
public.set_driver_journey_ticket_no_show	infrastructure/supabase/migrations/00252_driver_trip_execution_read_model.sql
public.set_super_admin_require_2fa	infrastructure/supabase/migrations/00155_require_2fa_for_super_admins.sql
public.sign_journey_ticket_credential	infrastructure/supabase/migrations/00307_never_issued_ticket_credential_guard.sql
public.sync_admin_audit_log_compat_fields	infrastructure/supabase/migrations/00137_restore_resource_contract_compatibility.sql
public.sync_booking_checkin_from_passenger_checkins	infrastructure/supabase/migrations/00138_fix_remaining_resource_contract_data.sql
public.sync_city_compat_fields	infrastructure/supabase/migrations/00137_restore_resource_contract_compatibility.sql
public.sync_company_compat_fields	infrastructure/supabase/migrations/00137_restore_resource_contract_compatibility.sql
public.sync_company_user_compat_fields	infrastructure/supabase/migrations/00137_restore_resource_contract_compatibility.sql
public.sync_driver_compat_fields	infrastructure/supabase/migrations/00137_restore_resource_contract_compatibility.sql
public.sync_general_audit_log_fields	infrastructure/supabase/migrations/00177_general_audit_log.sql
public.sync_journey_from_booking_aggregate	infrastructure/supabase/migrations/00227_atomic_journey_booking_inventory.sql
public.sync_journey_from_bookings	infrastructure/supabase/migrations/00227_atomic_journey_booking_inventory.sql
public.sync_journey_order_from_booking	infrastructure/supabase/migrations/00243_traveler_journey_history.sql
public.sync_legacy_booking_canonical_artifacts	infrastructure/supabase/migrations/00272_legacy_booking_canonical_ticket_sync.sql
public.sync_legacy_booking_canonical_artifacts_trigger	infrastructure/supabase/migrations/00274_isolate_native_journey_from_legacy_ticket_sync.sql
public.sync_qr_token_compat_fields	infrastructure/supabase/migrations/00137_restore_resource_contract_compatibility.sql
public.sync_route_compat_fields	infrastructure/supabase/migrations/00137_restore_resource_contract_compatibility.sql
public.sync_trip_compat_fields	infrastructure/supabase/migrations/00137_restore_resource_contract_compatibility.sql
public.sync_trip_driver_assignment	infrastructure/supabase/migrations/00213_company_trip_dispatch.sql
public.sync_trip_resource_inventory	infrastructure/supabase/migrations/00260_canonical_seat_inventory_compatibility.sql
public.sync_trip_status_from_assignment	infrastructure/supabase/migrations/00071_fix_critical_bugs.sql
public.sync_trip_stop_calls	infrastructure/supabase/migrations/00279_trip_pickup_locations.sql
public.touch_connected_transport_updated_at	infrastructure/supabase/migrations/00224_connected_transport_core.sql
public.touch_global_product_record	infrastructure/supabase/migrations/00219_global_product_foundation.sql
public.transition_company_trip	infrastructure/supabase/migrations/00213_company_trip_dispatch.sql
public.transition_operational_alert	infrastructure/supabase/migrations/00225_connected_operations_control.sql
public.transition_partner_settlement	infrastructure/supabase/migrations/00226_partner_quality_settlements.sql
public.transition_trip_disruption	infrastructure/supabase/migrations/00225_connected_operations_control.sql
public.trg_generate_qr_hmac_token	infrastructure/supabase/migrations/00305_company_booking_confirmation_lifecycle.sql
public.trip_seat_ordinals	infrastructure/supabase/migrations/00196_atomic_company_booking_contract.sql
public.trip_seat_price	infrastructure/supabase/migrations/00196_atomic_company_booking_contract.sql
public.trip_segment_base_fare	infrastructure/supabase/migrations/00227_atomic_journey_booking_inventory.sql
public.update_booking_updated_at	infrastructure/supabase/migrations/00131_repair_booking_seat_lock_schema.sql
public.update_company_booking_confirmation_policy	infrastructure/supabase/migrations/00305_company_booking_confirmation_lifecycle.sql
public.update_company_payment_notes	infrastructure/supabase/migrations/00211_company_cash_reconciliation.sql
public.update_company_public_profile	infrastructure/supabase/migrations/00222_global_product_api_contracts.sql
public.update_company_trip_setup	infrastructure/supabase/migrations/00279_trip_pickup_locations.sql
public.update_traveler_booking_billing_address	infrastructure/supabase/migrations/00277_card_payment_billing_details.sql
public.use_backup_code	infrastructure/supabase/migrations/00118_ensure_admin_2fa_schema.sql
public.validate_and_checkin	infrastructure/supabase/migrations/00247_canonical_journey_ticket_boarding.sql
public.validate_and_checkin_journey_ticket	infrastructure/supabase/migrations/00247_canonical_journey_ticket_boarding.sql
public.validate_booking_extra_relationships	infrastructure/supabase/migrations/00224_connected_transport_core.sql
public.validate_booking_passenger_aggregate	infrastructure/supabase/migrations/00227_atomic_journey_booking_inventory.sql
public.validate_booking_status_change	infrastructure/supabase/migrations/00305_company_booking_confirmation_lifecycle.sql
public.validate_document_share_grant_relation	infrastructure/supabase/migrations/00298_secure_document_share_grants.sql
public.validate_journey_leg	infrastructure/supabase/migrations/00224_connected_transport_core.sql
public.validate_journey_seat_assignment	infrastructure/supabase/migrations/00227_atomic_journey_booking_inventory.sql
public.validate_journey_ticket_relationships	infrastructure/supabase/migrations/00227_atomic_journey_booking_inventory.sql
public.validate_offline_checkin	infrastructure/supabase/migrations/00247_canonical_journey_ticket_boarding.sql
public.validate_operational_alert_relationships	infrastructure/supabase/migrations/00225_connected_operations_control.sql
public.validate_route_stop_ownership	infrastructure/supabase/migrations/00224_connected_transport_core.sql
public.validate_trip_announcement_relationships	infrastructure/supabase/migrations/00225_connected_operations_control.sql
public.validate_trip_disruption_relationships	infrastructure/supabase/migrations/00225_connected_operations_control.sql
public.validate_trip_pickup_location	infrastructure/supabase/migrations/00279_trip_pickup_locations.sql
public.verify_company_payment	infrastructure/supabase/migrations/00211_company_cash_reconciliation.sql
public.verify_driver_phone	infrastructure/supabase/migrations/00144_verify_driver_phone_returns_auth_user_id.sql
public.verify_journey_ticket_credential	infrastructure/supabase/migrations/00227_atomic_journey_booking_inventory.sql
public.verify_rls_security_posture	infrastructure/supabase/migrations/00257_runtime_security_posture_reassertion.sql
public.verify_seat_lock_ownership	infrastructure/supabase/migrations/00132_fix_booking_transition_ownership.sql
queue_trip_cancellation_notifications	infrastructure/supabase/migrations/00048_cascade_trip_cancellation.sql
reap_expired_demos	infrastructure/supabase/migrations/00173_demo_provisioning.sql
recalculate_all_trip_seats	infrastructure/supabase/migrations/00166_fix_duplicate_seat_decrement.sql
recalculate_trip_available_seats	infrastructure/supabase/migrations/00094_fix_trip_seat_calculation.sql
reconcile_all_seats	infrastructure/supabase/migrations/00044_seat_reconciliation.sql
reconcile_trip_seats	infrastructure/supabase/migrations/00044_seat_reconciliation.sql
redeem_loyalty_reward	infrastructure/supabase/migrations/00092_loyalty_points_system.sql
refresh_company_stats	infrastructure/supabase/migrations/00003_functions.sql
register_device_token	infrastructure/supabase/migrations/00087_add_push_notification_support.sql
register_session	infrastructure/supabase/migrations/00079_session_configuration.sql
reject_company	infrastructure/supabase/migrations/00003_functions.sql
release_seat_locks	infrastructure/supabase/migrations/00084_fix_seat_lock_ownership.sql
release_seats_atomic	infrastructure/supabase/migrations/00094_fix_trip_seat_calculation.sql
reserve_seats	infrastructure/supabase/migrations/00100_fix_function_error_handling.sql
reserve_seats_atomic	infrastructure/supabase/migrations/00094_fix_trip_seat_calculation.sql
reserve_seats_safe	infrastructure/supabase/migrations/00100_fix_function_error_handling.sql
restore_seats_atomic	infrastructure/supabase/migrations/00051_atomic_seat_helpers.sql
revoke_all_user_sessions	infrastructure/supabase/migrations/00079_session_configuration.sql
revoke_session	infrastructure/supabase/migrations/00079_session_configuration.sql
run_periodic_cleanup	infrastructure/supabase/migrations/00003_functions.sql
safe_paginate	infrastructure/supabase/migrations/00059_fix_additional_bugs.sql
schedule_booking_reminders	infrastructure/supabase/migrations/00104_fix_booking_reminders_trigger.sql
seed_company_world	infrastructure/supabase/migrations/00172_seed_company_world.sql
send_templated_notification	infrastructure/supabase/migrations/00091_notification_system.sql
set_booking_code	infrastructure/supabase/migrations/00004_triggers_rls.sql
set_booking_expires_at	infrastructure/supabase/migrations/00028_fix_schema_issues.sql
set_booking_lookup_context	infrastructure/supabase/migrations/00072_fix_anonymous_rls_security.sql
set_ticket_number	infrastructure/supabase/migrations/00004_triggers_rls.sql
store_otp	infrastructure/supabase/migrations/00151_fix_store_otp_attempts_ambiguity.sql
submit_group_booking_quote	infrastructure/supabase/migrations/00093_group_booking_system.sql
suspend_company	infrastructure/supabase/migrations/00003_functions.sql
sync_city_name	infrastructure/supabase/migrations/00015_add_missing_columns.sql
sync_company_name	infrastructure/supabase/migrations/00015_add_missing_columns.sql
sync_trip_company_id	infrastructure/supabase/migrations/00124_fix_live_database_contract_drift.sql
trg_generate_qr_hmac_token	infrastructure/supabase/migrations/00105_offline_qr_tokens.sql
trg_update_trip_seats_on_booking_change	infrastructure/supabase/migrations/00094_fix_trip_seat_calculation.sql
update_available_seats	infrastructure/supabase/migrations/00047_fix_critical_issues.sql
update_booking_payment_status	infrastructure/supabase/migrations/00011_payment_system.sql
update_booking_updated_at	infrastructure/supabase/migrations/00024_fix_schema_mismatches.sql
update_bus_maintenance_dates	infrastructure/supabase/migrations/00038_maintenance_logs.sql
update_company_rating	infrastructure/supabase/migrations/00019_trip_reviews.sql
update_driver_incident_timestamp	infrastructure/supabase/migrations/00080_driver_incidents.sql
update_driver_stats	infrastructure/supabase/migrations/00004_triggers_rls.sql
update_feature_flag_timestamp	infrastructure/supabase/migrations/00088_add_feature_flags.sql
update_group_booking_total_paid	infrastructure/supabase/migrations/00093_group_booking_system.sql
update_maintenance_logs_updated_at	infrastructure/supabase/migrations/00038_maintenance_logs.sql
update_notification_prefs_timestamp	infrastructure/supabase/migrations/00091_notification_system.sql
update_passenger_profile	infrastructure/supabase/migrations/00037_add_hash_to_profile_function.sql
update_push_subscription_used	infrastructure/supabase/migrations/00095_enhance_push_subscriptions.sql
update_seat_config_updated_at	infrastructure/supabase/migrations/00056_seat_configuration.sql
update_session_activity	infrastructure/supabase/migrations/00079_session_configuration.sql
update_ticket_last_message	infrastructure/supabase/migrations/00004_triggers_rls.sql
update_ticket_timestamps	infrastructure/supabase/migrations/00004_triggers_rls.sql
update_trip_review_updated_at	infrastructure/supabase/migrations/00019_trip_reviews.sql
update_trip_seat_overrides	infrastructure/supabase/migrations/00046_atomic_seat_overrides.sql
update_updated_at	infrastructure/supabase/migrations/00004_triggers_rls.sql
update_updated_at_column	infrastructure/supabase/migrations/00015_add_missing_columns.sql
use_backup_code	infrastructure/supabase/migrations/00075_add_admin_2fa.sql
validate_and_checkin	infrastructure/supabase/migrations/00150_fix_validate_checkin_assignment_status.sql
validate_booking_status_change	infrastructure/supabase/migrations/00059_fix_additional_bugs.sql
validate_company_registration	infrastructure/supabase/migrations/00082_final_rls_hardening.sql
validate_offline_checkin	infrastructure/supabase/migrations/00105_offline_qr_tokens.sql
validate_trip_status_change	infrastructure/supabase/migrations/00059_fix_additional_bugs.sql
validate_trip_status_transition	infrastructure/supabase/migrations/00057_fix_critical_security_issues.sql
verify_admin_with_permission	infrastructure/supabase/migrations/00073_atomic_permission_check.sql
verify_admin_with_permission_by_email	infrastructure/supabase/migrations/00073_atomic_permission_check.sql
verify_booking_hmac_token	infrastructure/supabase/migrations/00105_offline_qr_tokens.sql
verify_driver_phone	infrastructure/supabase/migrations/00003_functions.sql
verify_otp	infrastructure/supabase/migrations/00041_auth_otp_storage.sql
verify_seat_lock_ownership	infrastructure/supabase/migrations/00084_fix_seat_lock_ownership.sql

24 migration-declared types

type	Latest declaration
admin_role	infrastructure/supabase/migrations/00001_complete_schema.sql
booking_status	infrastructure/supabase/migrations/00001_complete_schema.sql
bus_type	infrastructure/supabase/migrations/00001_complete_schema.sql
checkin_method	infrastructure/supabase/migrations/00001_complete_schema.sql
company_role	infrastructure/supabase/migrations/00001_complete_schema.sql
driver_notification_type	infrastructure/supabase/migrations/00001_complete_schema.sql
group_booking_status	infrastructure/supabase/migrations/00093_group_booking_system.sql
invitation_status	infrastructure/supabase/migrations/00001_complete_schema.sql
loyalty_transaction_type	infrastructure/supabase/migrations/00125_ensure_admin_operational_tables.sql
maintenance_type	infrastructure/supabase/migrations/00038_maintenance_logs.sql
message_sender_type	infrastructure/supabase/migrations/00001_complete_schema.sql
notification_channel	infrastructure/supabase/migrations/00058_fix_schema_mismatches.sql
notification_status	infrastructure/supabase/migrations/00001_complete_schema.sql
notification_type	infrastructure/supabase/migrations/00001_complete_schema.sql
numbering_scheme_type	infrastructure/supabase/migrations/00142_bus_layout_numbering_and_seat_helpers.sql
payment_method_driver	infrastructure/supabase/migrations/00001_complete_schema.sql
payment_provider	infrastructure/supabase/migrations/00011_payment_system.sql
payment_status	infrastructure/supabase/migrations/00011_payment_system.sql
seat_type	infrastructure/supabase/migrations/00001_complete_schema.sql
ticket_priority	infrastructure/supabase/migrations/00001_complete_schema.sql
ticket_status	infrastructure/supabase/migrations/00001_complete_schema.sql
ticket_type	infrastructure/supabase/migrations/00001_complete_schema.sql
trip_assignment_status	infrastructure/supabase/migrations/00001_complete_schema.sql
trip_status	infrastructure/supabase/migrations/00001_complete_schema.sql

Operational infrastructure and cross-cutting domains

38 Docker Compose services

• admin
• alertmanager
• alloy
• auth
• backup
• backup-sync
• customer
• dashboard
• db
• db-bootstrap
• docs
• glitchtip
• glitchtip-db
• glitchtip-redis
• glitchtip-worker
• gotenberg
• grafana
• imgproxy
• kong
• loki
• mailpit
• meta
• minio
• minio-init
• mobile-customer
• mobile-driver
• notification-worker
• ntfy
• pgadmin
• pgbouncer
• prometheus
• realtime
• redis
• rest
• storage
• studio
• telegram-bot
• tempo

2 Supabase Edge Function entrypoints

• infrastructure/supabase/functions/send-reminders/index.ts
• infrastructure/supabase/functions/whatsapp-notify/index.ts

12 worker, scheduler, reminder, or cleanup sources

• apps/admin/src/app/api/internal/notifications/process/route.ts
• apps/admin/src/hooks/useServiceWorker.ts
• apps/customer/src/app/api/settings/reminders/route.ts
• apps/customer/src/hooks/useServiceWorker.ts
• apps/dashboard/src/app/api/bookings/[id]/reminder/route.ts
• apps/dashboard/src/hooks/useServiceWorker.ts
• infrastructure/supabase/functions/send-reminders/index.ts
• infrastructure/supabase/migrations/00098_booking_reminders.sql
• infrastructure/supabase/migrations/00104_fix_booking_reminders_trigger.sql
• infrastructure/supabase/migrations/00140_fix_booking_reminders_rls.sql
• infrastructure/supabase/migrations/00264_notification_worker_acl_reassertion.sql
• packages/services/src/notification-delivery-worker.service.ts

36 notification-related sources

• apps/admin/src/app/api/internal/notifications/process/route.ts
• apps/admin/src/app/api/webhooks/notifications/_shared.ts
• apps/admin/src/app/api/webhooks/notifications/external-sms/route.ts
• apps/admin/src/app/api/webhooks/notifications/resend/route.ts
• apps/admin/src/app/api/webhooks/notifications/twilio/route.ts
• apps/admin/src/app/api/webhooks/notifications/whatsapp/route.ts
• apps/admin/src/hooks/use-push-notifications.ts
• apps/admin/src/lib/services/notification.service.ts
• apps/customer/src/app/api/settings/reminders/route.ts
• apps/customer/src/components/profile/notifications-card.tsx
• apps/customer/src/hooks/use-push-notifications.ts
• apps/customer/src/lib/services/notification.service.ts
• apps/dashboard/src/app/api/bookings/[id]/reminder/route.ts
• apps/dashboard/src/hooks/use-push-notifications.ts
• apps/dashboard/src/lib/services/notification.service.ts
• apps/mobile/customer/lib/core/services/push_notification_service.dart
• apps/mobile/driver/lib/core/services/push_notification_service.dart
• infrastructure/scripts/notify-slack.sh
• infrastructure/supabase/functions/send-reminders/index.ts
• infrastructure/supabase/functions/whatsapp-notify/index.ts
• infrastructure/supabase/migrations/00087_add_push_notification_support.sql
• infrastructure/supabase/migrations/00091_notification_system.sql
• infrastructure/supabase/migrations/00095_enhance_push_subscriptions.sql
• infrastructure/supabase/migrations/00098_booking_reminders.sql
• infrastructure/supabase/migrations/00104_fix_booking_reminders_trigger.sql
• infrastructure/supabase/migrations/00140_fix_booking_reminders_rls.sql
• infrastructure/supabase/migrations/00192_push_subscription_contract.sql
• infrastructure/supabase/migrations/00217_enterprise_notification_delivery.sql
• infrastructure/supabase/migrations/00248_reconcile_enterprise_notification_migration_history.sql
• infrastructure/supabase/migrations/00264_notification_worker_acl_reassertion.sql
• infrastructure/supabase/migrations/00282_notification_pickup_context.sql
• infrastructure/supabase/migrations/00284_notification_pgcrypto_search_path.sql
• packages/services/src/notification-delivery-worker.service.ts
• packages/services/src/notification-template.service.ts
• packages/services/src/notification-webhook.service.ts
• packages/services/src/notification.service.ts

44 document, PDF, invoice, receipt, or ticket sources

• apps/admin/src/components/booking/ticket-print.tsx
• apps/customer/scripts/render-document-samples.tsx
• apps/customer/src/app/api/bookings/[id]/document/route.ts
• apps/customer/src/app/api/bookings/[id]/receipt/route.ts
• apps/customer/src/app/api/document-shares/[grantId]/accept/route.ts
• apps/customer/src/app/api/document-shares/[grantId]/document/route.ts
• apps/customer/src/app/api/document-shares/[grantId]/preview/route.ts
• apps/customer/src/app/api/document-shares/[grantId]/revoke/route.ts
• apps/customer/src/app/api/document-shares/[grantId]/session/route.ts
• apps/customer/src/app/api/document-shares/route.ts
• apps/customer/src/components/booking/ticket-print.tsx
• apps/customer/src/components/documents/secure-document-share.tsx
• apps/customer/src/components/documents/shared-document-recipient.tsx
• apps/customer/src/components/legal-document.tsx
• apps/customer/src/lib/documents/document-share-http.ts
• apps/customer/src/lib/documents/document-share-issuer.ts
• apps/customer/src/lib/documents/document-share.ts
• apps/dashboard/src/app/api/bookings/[id]/documents/[kind]/route.ts
• apps/dashboard/src/app/api/payments/receipts/[source]/[id]/route.ts
• apps/dashboard/src/components/booking/ticket-print.tsx
• apps/mobile/customer/lib/features/settings/presentation/screens/legal_document_screen.dart
• apps/mobile/driver/lib/core/services/driver_document_service.dart
• apps/mobile/driver/lib/core/services/payment_receipt_service.dart
• apps/mobile/driver/lib/features/payments/presentation/screens/payment_receipt_screen.dart
• infrastructure/supabase/migrations/00139_canonical_bus_layout_documents.sql
• infrastructure/supabase/migrations/00143_backfill_bus_layout_document.sql
• infrastructure/supabase/migrations/00147_save_bus_layout_document_post_drop.sql
• infrastructure/supabase/migrations/00218_enterprise_document_registry.sql
• infrastructure/supabase/migrations/00253_enterprise_booking_workspace_and_documents.sql
• infrastructure/supabase/migrations/00280_booking_pickup_location_documents.sql
• infrastructure/supabase/migrations/00298_secure_document_share_grants.sql
• infrastructure/supabase/migrations/00299_document_share_issuer_authorization.sql
• infrastructure/supabase/migrations/00300_two_phase_document_share_delivery.sql
• infrastructure/supabase/migrations/00301_complete_document_share_issuer_roles.sql
• infrastructure/supabase/migrations/00302_database_authoritative_document_share_expiry.sql
• infrastructure/supabase/migrations/00303_document_share_demo_lifecycle.sql
• infrastructure/supabase/migrations/00304_document_share_finance_role_scope.sql
• infrastructure/supabase/migrations/00307_never_issued_ticket_credential_guard.sql
• packages/services/src/booking-document-generation.service.ts
• packages/services/src/booking-document-snapshot.service.ts
• packages/services/src/document-template.service.ts
• packages/services/src/financial-document-generation.service.ts
• packages/services/src/financial-document-snapshot.service.ts
• packages/services/src/pdf-document.service.ts

178 identity, role, permission, and RLS sources

• apps/admin/src/app/api/auth/2fa/enable-login/route.ts
• apps/admin/src/app/api/auth/2fa/setup-login/route.ts
• apps/admin/src/app/api/auth/2fa/verify/route.ts
• apps/admin/src/app/api/auth/login/route.ts
• apps/admin/src/app/api/auth/logout/route.ts
• apps/admin/src/app/api/auth/me/route.ts
• apps/admin/src/app/api/permissions/route.ts
• apps/admin/src/app/api/security/2fa/route.ts
• apps/admin/src/components/admin/permission-guard.tsx
• apps/admin/src/hooks/use-admin-permissions.ts
• apps/admin/src/lib/admin/check-permission.ts
• apps/customer/src/app/api/auth/customer/complete-phone/route.ts
• apps/customer/src/app/api/auth/customer/google/mobile/route.ts
• apps/customer/src/app/api/auth/customer/google/nonce/route.ts
• apps/customer/src/app/api/auth/customer/google/pwa/route.ts
• apps/customer/src/app/api/auth/customer/google/web/route.ts
• apps/customer/src/app/api/auth/customer/logout/route.ts
• apps/customer/src/app/api/auth/customer/me/route.ts
• apps/customer/src/app/api/auth/customer/recover/init/route.ts
• apps/customer/src/app/api/auth/customer/recover/send-otp/route.ts
• apps/customer/src/app/api/auth/customer/recover/verify/route.ts
• apps/customer/src/app/api/auth/customer/refresh/route.ts
• apps/customer/src/app/api/auth/customer/resend-verification/route.ts
• apps/customer/src/app/api/auth/customer/send-email-code/route.ts
• apps/customer/src/app/api/auth/customer/send-otp/route.ts
• apps/customer/src/app/api/auth/customer/verify-email-code/route.ts
• apps/customer/src/app/api/auth/customer/verify-email/route.ts
• apps/customer/src/app/api/auth/customer/verify-otp/route.ts
• apps/customer/src/app/api/auth/driver/2fa/enable/route.ts
• apps/customer/src/app/api/auth/driver/2fa/setup/route.ts
• apps/customer/src/app/api/auth/driver/2fa/verify/route.ts
• apps/customer/src/app/api/auth/driver/login/route.ts
• apps/customer/src/app/api/auth/driver/send-otp/route.ts
• apps/customer/src/app/api/auth/driver/verify-otp/route.ts
• apps/customer/src/app/auth/complete-phone/page.tsx
• apps/customer/src/app/auth/complete-profile/page.tsx
• apps/customer/src/app/auth/login/page.tsx
• apps/customer/src/app/auth/recover-account/page.tsx
• apps/customer/src/app/auth/register/page.tsx
• apps/customer/src/app/auth/verify-email/page.tsx
• apps/customer/src/app/auth/verify/page.tsx
• apps/customer/src/app/customer-auth/login/page.tsx
• apps/customer/src/components/admin/permission-guard.tsx
• apps/customer/src/components/auth/google-icon.tsx
• apps/customer/src/components/auth/traveler-authentication-shell.tsx
• apps/customer/src/components/auth/traveler-google-sign-in.tsx
• apps/customer/src/hooks/use-admin-permissions.ts
• apps/customer/src/lib/admin/check-permission.ts
• apps/customer/src/lib/auth/auth-guard.tsx
• apps/customer/src/lib/auth/booking-guest-access.ts
• apps/customer/src/lib/auth/create-google-traveler-session.ts
• apps/customer/src/lib/auth/customer-auth-context.tsx
• apps/customer/src/lib/auth/customer-session-cookies.ts
• apps/customer/src/lib/auth/google-return-path.ts
• apps/customer/src/lib/auth/google-web-nonce.ts
• apps/customer/src/lib/auth/index.ts
• apps/customer/src/lib/auth/traveler-context.ts
• apps/customer/src/lib/auth/traveler-journey-read.ts
• apps/customer/src/lib/auth/use-customer-auth.ts
• apps/customer/src/lib/auth/verify-google-id-token.ts
• apps/customer/src/lib/auth/verify-phone-challenge.ts
• apps/customer/src/lib/cors-policy.ts
• apps/customer/src/lib/services/driver-auth.ts
• apps/dashboard/src/app/api/auth/login/route.ts
• apps/dashboard/src/app/api/auth/logout/route.ts
• apps/dashboard/src/app/api/auth/me/route.ts
• apps/dashboard/src/components/admin/permission-guard.tsx
• apps/dashboard/src/hooks/use-admin-permissions.ts
• apps/dashboard/src/lib/admin/check-permission.ts
• apps/dashboard/src/lib/auth/company-access.ts
• apps/dashboard/src/lib/auth/company-roles.ts
• apps/dashboard/src/lib/auth/dashboard-bootstrap.ts
• apps/dashboard/src/lib/auth/dashboard-paths.ts
• apps/mobile/customer/lib/core/services/auth_service.dart
• apps/mobile/customer/lib/core/services/google_web_auth_transport.dart
• apps/mobile/customer/lib/core/services/google_web_auth_transport_stub.dart
• apps/mobile/customer/lib/core/services/google_web_auth_transport_web.dart
• apps/mobile/customer/lib/core/services/traveler_google_auth_coordinator.dart
• apps/mobile/customer/lib/features/auth/presentation/screens/complete_phone_screen.dart
• apps/mobile/customer/lib/features/auth/presentation/screens/complete_profile_screen.dart
• apps/mobile/customer/lib/features/auth/presentation/screens/email_verification_screen.dart
• apps/mobile/customer/lib/features/auth/presentation/screens/login_screen.dart
• apps/mobile/customer/lib/features/auth/presentation/screens/otp_screen.dart
• apps/mobile/customer/lib/features/auth/presentation/screens/register_screen.dart
• apps/mobile/driver/lib/core/router/driver_route_policy.dart
• apps/mobile/driver/lib/core/services/auth_service.dart
• apps/mobile/driver/lib/core/services/driver_authentication_gateway.dart
• apps/mobile/driver/lib/core/services/driver_identity_service.dart
• apps/mobile/driver/lib/features/auth/presentation/screens/demo_access_screen.dart
• apps/mobile/driver/lib/features/auth/presentation/screens/login_screen.dart
• apps/mobile/driver/lib/features/auth/presentation/screens/splash_screen.dart
• apps/mobile/driver/lib/features/auth/presentation/screens/two_factor_screen.dart
• apps/mobile/driver/lib/features/auth/presentation/screens/two_factor_setup_screen.dart
• infrastructure/scripts/configure-google-traveler-oauth.sh
• infrastructure/scripts/deploy-authentik.sh
• infrastructure/scripts/harden-production-auth.sh
• infrastructure/scripts/upgrade-authentik-production.sh
• infrastructure/supabase/migrations/00004_triggers_rls.sql
• infrastructure/supabase/migrations/00027_office_passenger_rls.sql
• infrastructure/supabase/migrations/00029_fix_passenger_rls.sql
• infrastructure/supabase/migrations/00030_fix_bookings_rls.sql
• infrastructure/supabase/migrations/00031_fix_rls_recursion.sql
• infrastructure/supabase/migrations/00036_fix_security_rls.sql
• infrastructure/supabase/migrations/00040_fix_critical_rls_security.sql
• infrastructure/supabase/migrations/00041_auth_otp_storage.sql
• infrastructure/supabase/migrations/00050_fix_critical_rls_security.sql
• infrastructure/supabase/migrations/00053_fix_company_users_rls.sql
• infrastructure/supabase/migrations/00060_seed_admin_auth_users.sql
• infrastructure/supabase/migrations/00063_service_role_policies.sql
• infrastructure/supabase/migrations/00069_seed_company_auth_users.sql
• infrastructure/supabase/migrations/00072_fix_anonymous_rls_security.sql
• infrastructure/supabase/migrations/00073_atomic_permission_check.sql
• infrastructure/supabase/migrations/00074_add_admin_view_permission.sql
• infrastructure/supabase/migrations/00075_add_admin_2fa.sql
• infrastructure/supabase/migrations/00082_final_rls_hardening.sql
• infrastructure/supabase/migrations/00089_fix_admin_users_rls_recursion.sql
• infrastructure/supabase/migrations/00090_add_missing_service_role_policies.sql
• infrastructure/supabase/migrations/00096_payment_service_role_policy.sql
• infrastructure/supabase/migrations/00097_fix_group_booking_rls_column_names.sql
• infrastructure/supabase/migrations/00101_add_loyalty_manage_permission.sql
• infrastructure/supabase/migrations/00102_seed_driver_auth_users.sql
• infrastructure/supabase/migrations/00112_rls_security_verification.sql
• infrastructure/supabase/migrations/00114_link_seed_auth_users.sql
• infrastructure/supabase/migrations/00115_fix_buses_authenticated_rls.sql
• infrastructure/supabase/migrations/00117_ensure_admin_auth_users.sql
• infrastructure/supabase/migrations/00118_ensure_admin_2fa_schema.sql
• infrastructure/supabase/migrations/00119_fix_driver_auth_rls.sql
• infrastructure/supabase/migrations/00120_fix_driver_bus_location_select_rls.sql
• infrastructure/supabase/migrations/00136_fix_company_admin_role_rls_case.sql
• infrastructure/supabase/migrations/00140_fix_booking_reminders_rls.sql
• infrastructure/supabase/migrations/00144_verify_driver_phone_returns_auth_user_id.sql
• infrastructure/supabase/migrations/00154_backfill_rls_for_resource_contract_tables.sql
• infrastructure/supabase/migrations/00155_require_2fa_for_super_admins.sql
• infrastructure/supabase/migrations/00157_require_2fa_for_all_admins.sql
• infrastructure/supabase/migrations/00162_get_auth_user_id_by_phone.sql
• infrastructure/supabase/migrations/00165_driver_email_auth.sql
• infrastructure/supabase/migrations/00168_admin_2fa_secret_column_privileges.sql
• infrastructure/supabase/migrations/00170_fix_auth_uid_json_claims.sql
• infrastructure/supabase/migrations/00175_fix_passenger_booking_rls_recursion.sql
• infrastructure/supabase/migrations/00179_persist_auth_helpers_and_admin_acl.sql
• infrastructure/supabase/migrations/00182_fix_trip_message_driver_identity.sql
• infrastructure/supabase/migrations/00184_fix_admin_2fa_audit_logging.sql
• infrastructure/supabase/migrations/00186_fix_support_admin_view_permission.sql
• infrastructure/supabase/migrations/00209_reassert_trip_message_driver_identity.sql
• infrastructure/supabase/migrations/00221_traveler_identity_and_booking_continuity.sql
• infrastructure/supabase/migrations/00237_connected_operations_rls_predicates.sql
• infrastructure/supabase/migrations/00238_live_operations_rls_consolidation.sql
• infrastructure/supabase/migrations/00241_cash_reconciliation_rls_predicate.sql
• infrastructure/supabase/migrations/00249_connected_journey_rls_predicates.sql
• infrastructure/supabase/migrations/00256_connected_transport_directory_rls.sql
• infrastructure/supabase/migrations/00258_driver_directory_rls_boundary.sql
• infrastructure/supabase/migrations/00267_native_google_traveler_auth_candidate.sql
• infrastructure/supabase/migrations/00269_safe_google_traveler_identity_linking.sql
• infrastructure/supabase/migrations/00275_service_only_identity_aware_journey_confirmation.sql
• infrastructure/supabase/migrations/00287_journey_search_stop_call_identity.sql
• infrastructure/supabase/migrations/00291_authenticated_journey_confirmation_actor.sql
• infrastructure/supabase/migrations/00299_document_share_issuer_authorization.sql
• infrastructure/supabase/migrations/00301_complete_document_share_issuer_roles.sql
• infrastructure/supabase/migrations/00302_database_authoritative_document_share_expiry.sql
• infrastructure/supabase/migrations/00304_document_share_finance_role_scope.sql
• packages/auth/src/auth-guard.tsx
• packages/auth/src/check-permission.ts
• packages/auth/src/csrf.ts
• packages/auth/src/customer-auth-context.tsx
• packages/auth/src/demo-access.ts
• packages/auth/src/demo-grant.ts
• packages/auth/src/index.ts
• packages/auth/src/password-validation.ts
• packages/auth/src/second-factor-session.ts
• packages/auth/src/security-headers.ts
• packages/auth/src/token-blocklist.ts
• packages/auth/src/totp-secret-crypto.mjs
• packages/auth/src/totp.ts
• packages/auth/src/use-admin-permissions.ts
• packages/auth/src/use-customer-auth.ts
• packages/auth/src/with-token-validation.ts
• packages/auth/vitest.config.ts
• packages/ui/src/authentication-shell.tsx

9 CI/CD workflows

• .github/workflows/ci.yml
• .github/workflows/deploy-mobile.yml
• .github/workflows/deploy-production.yml
• .github/workflows/deploy-staging.yml
• .github/workflows/e2e-tests.yml
• .github/workflows/lighthouse.yml
• .github/workflows/mobile-e2e.yml
• .github/workflows/security.yml
• .github/workflows/test.yml

Test ownership

Counts are deterministic and limited to the named roots. A file count is not proof of behavioral coverage; route coverage, contract assertions, mutation/race tests, browser/device tests, and production checks remain separate acceptance gates.

Ownership root	Test files
apps/customer/__tests__	216
apps/dashboard/__tests__	281
apps/admin/__tests__	223
apps/mobile/customer/test	102
apps/mobile/driver/test	46
packages/services/__tests__	39
packages/ui/__tests__	0
tests/e2e	85
tests/integration	27
infrastructure/supabase/tests	49
infrastructure/scripts/tests	2

How this inventory is used

1. A new route, screen, shared module, migration object, worker, notification source, or document source changes this file.
2. CI runs pnpm docs:inventory:check and rejects uncommitted inventory drift.
3. Reviewers map new or changed surfaces to the enterprise traceability ledger and acceptance evidence.
4. Release certification verifies the deployed runtime independently; generated source inventory never substitutes for production evidence.