Schema Visualizer
Interactive database schema visualization for Openfront
Database Schema
Explore the Openfront database schema in this interactive view. Drag to move around and zoom to focus on an area.
The visualizer is built from a copy of the schema kept in this docs site. The authoritative sources are features/keystone/models and the generated schema.prisma and schema.graphql in the source repository. The current source defines 85 Keystone lists.
Model groups
Users and access
- User, Role, Team, UserField – accounts, role permissions and teams
- ApiKey, OAuthApp, OAuthToken – programmatic access
- WebhookEndpoint, WebhookEvent – outgoing webhooks
- IdempotencyKey – recorded progress for checkout, invoice payment, refunds and webhooks
Store and markets
- Store – the single store's name, logo and homepage text
- Region, Country, Currency, TaxRate, TaxProvider – where and how you sell
- SalesChannel – sales channel records
Catalog
- Product, ProductVariant, ProductOption, ProductOptionValue, ProductImage
- ProductCategory, ProductCollection, ProductTag, ProductType
- MoneyAmount, PriceSet, PriceRule, PriceList, RuleType – pricing
- Location, StockMovement, Measurement – stock and dimensions
Carts and orders
- Cart, LineItem, LineItemAdjustment, LineItemTaxLine, Address
- Order, OrderLineItem, OrderMoneyAmount, OrderEvent, Note, DraftOrder
- Discount, DiscountRule, DiscountCondition, CustomerGroup
- GiftCard, GiftCardTransaction
Payments
- PaymentProvider, PaymentCollection, PaymentSession, Payment, Capture, Refund
Fulfillment and shipping
- ShippingOption, ShippingOptionRequirement, ShippingProfile, ShippingMethod, ShippingMethodTaxLine, CustomShippingOption
- ShippingProvider, ShippingLabel, FulfillmentProvider, Fulfillment, FulfillmentItem
After the sale
- Return, ReturnItem, ReturnReason
- ClaimOrder, ClaimItem, ClaimImage, ClaimTag
- Swap (model only; no workflow uses it)
Business accounts
- BusinessAccountRequest, Account, AccountLineItem, Invoice, InvoiceLineItem
Other
- Notification, NotificationProvider, Invite, BatchJob
Key relationships
- Catalog: Product → ProductVariant → MoneyAmount, with StockMovement records for stock changes.
- Checkout: Cart → PaymentCollection → PaymentSession → Order → Payment.
- Fulfillment: Order → Fulfillment → FulfillmentItem and ShippingLabel.
- After the sale: Order → Return → Refund, and Order → ClaimOrder.
- Business accounts: BusinessAccountRequest → Account → AccountLineItem → Invoice.