Public Gallery
Review public schemas shared from SchemaStruct workspaces, inspect table structure, compare public patterns, and fork a warehouse-ready design into your own editor session.
Built for warehouse review and handoff
Public gallery entries are intended as reusable starting points for dbt, Snowflake, and Databricks-style modeling work, not generic ER diagrams.
Explore the corpus
Start with public examples that match your warehouse domain, then compare structure before forking a schema into your own workspace.
Production-grade multi-tenant SaaS schema with organizations, users, subscription plans, invoicing with line items, usage-based metering, feature flags with per-org overrides, API tokens, and full audit logging — modeled after Slack/HubSpot-scale architectures.
FHIR-informed clinical data platform spanning patient master, insurance coverages, provider credentialing, care teams, inpatient encounters, ICD-10 diagnoses, medication orders, lab orders with results, and revenue-cycle claims — modeled after Epic-scale EHR production schemas.
Enterprise-grade dimensional warehouse with Type-2 SCD customer dimension, conformed date and geography dimensions, product and channel dimensions, sales rep hierarchy, and four fact tables covering daily orders, revenue recognition, inventory snapshots, and web session attribution — modeled after Snowflake and dbt-driven production warehouses.
Production MLOps platform schema covering dataset versioning, feature groups with online/offline serving, experiment tracking with run metrics and artifacts, model registry with promotion stages, endpoint deployments, real-time inference logging, and automated drift detection — modeled after MLflow + Feast production architectures.
Enterprise commerce schema covering multi-org catalog, product variants, inventory across locations, full order lifecycle, fulfillments, refunds, and discount engine — modeled after Shopify-scale production systems.
Enterprise payments schema covering merchant onboarding, payment intents, charges, full double-entry ledger, disputes, refunds, payout batching, KYC verifications, and risk scoring — modeled after Stripe-scale production systems.