Stampede
Schema

Schema

The canonical data model. 44 entities across eight layers — seven product modules sitting on the Graph AI Engine spine. 374 fields, 176 relationships. Click any entity to inspect its full surface.

44Entities374Fields176Relationships8Layers

Graph AI Engine

3 entities · 25 fields

The identity spine. Customer, Organization and Venue anchor every other node; every event flows through this layer.

Customer15 f · 28 r
The root guest identity node. Every interaction across bookings, Wi-Fi, orders, reviews, and loyalty is unified under a single Customer node per organisation.
Organization5 f · 4 r
Top-level organisation node. Supports franchise and group hierarchies via :PARENT_OF. Every piece of data in the platform is scoped to an organisation.
Venue5 f · 15 r
A physical location operated by an organisation. Every activity node — bookings, Wi-Fi sessions, orders, reviews — links back to a venue via the :AT_VENUE relationship.

Bookings

7 entities · 54 fields

Reservations, walk-ins, enquiries, events and the inbox threads they generate.

Booking16 f · 12 r
A table reservation or walk-in visit. Central hub connecting customers to venues, orders, threads, upgrades, and events.
Enquiry10 f · 5 r
Pre-booking enquiry from a guest (large parties, private events, corporate). Sales pipeline, can become a booking.
Thread8 f · 5 r
CRM inbox conversation thread. Multi-channel comms linked to bookings, reviews, or enquiries.
Form2 f · 2 r
Form definition for capturing guest data — feedback, registration, custom collection.
FormSubmission2 f · 3 r
Guest's completed form submission. Links guest to form and venue.
Event11 f · 3 r
Ticketed/bookable event at a venue (themed dinner, wine tasting, performance).
BookingIntegration5 f · 2 r
Booking via external third-party API (non-native bookings).

Wi-Fi

2 entities · 27 fields

MikroTik routers and Wi-Fi sessions that turn physical presence into linkable events.

HardwareDevice11 f · 3 r
Physical networking device (MikroTik router or AP) at a venue capturing Wi-Fi sessions.
WifiSession16 f · 4 r
Created when a guest authenticates through a Stampede Wi-Fi splash. Links physical presence to customer profile, with or without a booking.

PayOS

13 entities · 116 fields

Orders, POS tickets, line items, menu items, billing and add-ons. Every penny tracked.

Order7 f · 5 r
Pre-order placed via Stampede ordering (Zion). Linked to a booking before guest arrives.
SquareOrder5 f · 5 r
Live POS order via Square integration. Real-time table spend during service. All amounts in pennies.
OrderItem10 f · 3 r
Line item on any order. Links to MenuItem catalogue. Pennies.
MenuItem12 f · 4 r
Catalogue item linking ordered items to live menu. Allergen, dietary, Square POS integration.
BookingUpgrade7 f · 2 r
Upsell/add-on purchasable alongside a booking (champagne package, private room fee).
CancellationCharge4 f · 3 r
Late-cancel or no-show fee. Tracks amount owed vs collected.
Subscription15 f · 5 r
Billing subscription for an organisation. Supports Stripe and Chargebee. MRR stored in pennies.
Invoice19 f · 3 r
Billing invoice issued to an organisation. Amounts in pennies. Includes hosted invoice and PDF URLs for customer access.
InvoiceLineItem10 f · 2 r
A single line on an invoice (product or proration). Pennies.
Product4 f · 2 r
A billable product in the Stampede catalogue (feature tier or add-on).
CreditNote11 f · 1 r
Credit issued against an invoice (downgrade, refund).
Discount10 f · 1 r
Coupon or promotional discount on a subscription. Percentage or fixed.
Feature2 f · 2 r
Platform feature/add-on enabled at venue or org level. Global node — one per code.

Loyalty

2 entities · 12 fields

Loyalty enrolment and gift-card lifecycle. Reward the routine.

LoyaltyEnrollment2 f · 1 r
Membership in the loyalty programme. Points balance and enrollment date stored on the relationship to Customer.
GiftCard10 f · 3 r
Digital gift card. Tracks created → activated → redeemed → refunded lifecycle.

Reviews

2 entities · 21 fields

Guest reviews from Google and Stampede, with NLP sentiment and topic keywords.

Review19 f · 4 r
Guest review from Google or Stampede. Includes NLP sentiment scores, reply-state machine, and vector embedding for semantic clustering.
Keyword2 f · 2 r
NLP topic keyword extracted from reviews. Surfaces themes, cross-correlates topics across reviews.

Marketing CRM

8 entities · 56 fields

Email, SMS, segments, workflows, tags, custom questions and the social graph.

EmailCampaign15 f · 8 r
Email campaign — manual or workflow-triggered. Tracks send/open/click/bounce funnel per customer.
SmsCampaign12 f · 3 r
SMS campaign to a segment. Delivery, failure, opt-out tracking.
Segment8 f · 4 r
Audience segment for targeting campaigns. Dynamic (graph-driven) or static (fixed list).
Workflow5 f · 4 r
Automated marketing journey triggered by behaviour events. Sends email or SMS at intervals/conditions.
WorkflowRun4 f · 1 r
Single execution of a workflow for one customer. Audit trail per automated journey.
Tag4 f · 2 r
Customer label. Sourced from CRM (Morpheus) or booking (Zion) — IDs prefixed accordingly.
CustomQuestion4 f · 2 r
Custom data-collection question shown during booking/registration. Answers stored on the ANSWERED edge.
SocialGraphEdges4 f · 4 r
Customer-to-customer relationship edges powering social analytics. Not nodes — direct edges between Customers (dining companions, referrals, gifts).

AI Analytics

7 entities · 63 fields

Computed intelligence — loyalty scores, churn risk, LTV, customer influence, campaign response, Wi-Fi profile, venue intelligence.

AI_LoyaltyScore6 f · 1 r
Computed RFM+ loyalty score per customer per venue. Tiers from champion to lost. Recomputed on every data sync.
AI_ChurnRisk7 f · 1 r
Computed churn risk per customer per organisation. Identifies at-risk guests with contributing factors for targeted intervention.
AI_LifetimeValue9 f · 1 r
Computed LTV per customer per organisation. Historical spend, predicted future value, tier.
AI_CustomerInfluence7 f · 1 r
Computed social influence between two customers. Asymmetric — booker influences companions. Strength reflects co-dining count and venue spread.
AI_CampaignResponder11 f · 1 r
Computed email engagement profile per customer per organisation. Tier classification plus a 'reads but never clicks' flag.
AI_WifiProfile15 f · 3 r
Computed Wi-Fi portal funnel metrics per customer per venue. Tracks how far each guest progresses through the splash journey across all sessions.
AI_VenueIntelligence8 f · 6 r
Aggregated AI insights at venue level — review health, customer overlap between venues, ordering and cancellation patterns per customer.