Screvercommerce
Data model

PostgreSQL-backed, type-safe, tenant-aware.

Every collection has a tenant column, a versioned schema, and an additive-only migration policy. Schema changes use ADD COLUMN IF NOT EXISTS; never DROP.

Migration policy
Additive only
Database
PostgreSQL 17
Map

Schema browser.

Inspect any table — columns, types, relations — directly in the workspace.

app.screver.ch/integrations/schema
IntegrationsSchemaslug: schema
MK

Schema browser

PostgreSQL · 14 tables

Tables

bookings

142 columns · 8.4M rows
ColumnTypeNullable
iduuidno
tenant_iduuidno
customer_iduuidno
referencetextno
statusbooking_statusno
total_centsbigintno
currencychar(3)no
created_attimestamptzno
metadatajsonbyes

Relations

customer_id → customers.id
tenant_id → tenants.id
payment_id → payments.id
entitlements ← entitlements.booking_id
events ← audit_log.booking_id
Schema browser · PostgreSQL 17
Collections

Collections.

Collections

  • Tenants

    Destinations, operators, regions. Root multi-tenant boundary.

  • Users

    Admin accounts (owner / admin / editor / provider roles).

  • Customers

    Guest accounts with locale, Stripe customer ID, SwissID / SwissPass binding.

  • Pages

    CMS pages with block layout, drafts, versioning, SEO.

  • Media

    Images and video with 7 size presets, alt text, EXIF stripped.

  • Products

    Tickets, ancillaries, packages, memberships, vouchers, gift cards, merchandise.

  • Orders

    Shop orders with payment status.

  • Bookings

    Booking records with passenger arrays, route snapshots, fare breakdown, ancillaries snapshot, integration audit trail, PDF URL.

  • Stations

    Stations with UIC codes, coordinates, region.

  • Lines

    Branded train and cable car products.

  • Routes

    Directional segments between stations on a line.

  • Fares

    Price table: route × class × reduction.

  • Schedules

    Weekly timetables with bookable toggle, day-of-week pattern.

  • Providers

    Hotels, schools, shops, restaurants in the region.

  • ProviderServices

    Specific services a provider offers.

  • Memberships

    Membership records bound to customers.

  • Entitlements

    Granular entitlements granted by memberships and passes.

  • Promotions

    Promotion definitions with eligibility.

  • Bundles

    Bundle definitions with constraints and pricing.

  • IntegrationEvents

    Audit log of every external call.

  • ConnectorConfigs

    Per-tenant connector configuration (credentials encrypted).

  • Workflows

    Workflow definitions (triggers + conditions + actions).

  • PricingRules

    Pricing rules with evaluation order.

  • AISessions

    AI Concierge and Ops Copilot conversations.

  • AIDocuments

    Documents ingested for RAG, with chunks and pgvector embeddings.

  • MCPServers

    Per-tenant external MCP server registrations.

Globals

Globals.

Globals

  • Header

    Navigation items (up to 6 with dropdowns), CTA button.

  • Footer

    Navigation, tagline, social links.

  • Home

    Hero, route cards, themed experiences, scenic, timetable.

  • SiteSettings

    Site name, logo, favicon, contact info, address.

  • Theme

    Color tokens, fonts, hero imagery for both seasons.

  • TenantConfig

    Locales, currencies, payment methods, identity providers, data residency.

Keep reading

API reference

Endpoints that read and write these collections.

Open

Multi-tenancy

How tenant_id flows through every row.

Open

Deployment

Additive-only migrations as Cloud Run Jobs.

Open