SchemaStruct
DocsBlogGalleryPricingAboutContact
Sign inGet started
DocsBlogGalleryPricingAboutContactSign inGet started
Public gallery

Browse warehouse schema starting points

Review public schemas shared from SchemaStruct workspaces, inspect table structure, compare patterns, and fork a warehouse-ready design straight into your own editor session.

Review shared warehouse starting points Compare public schema patterns Fork a design into the editor
4
public schemas
46
tables documented
11
contracted tables
Built for warehouse review and handoff

Public gallery entries are reusable starting points for dbt, Snowflake, and Databricks-style modeling work — not generic ER diagrams.

Explore the corpus

Filter by domain and sort by depth

Start with public examples that match your warehouse domain, then compare structure before forking a schema into your workspace.

Domain
All domainsE-commerceSaaSFintechHealthcareMLWarehouse
Sort
Most recentMost tablesMost contracts
4 schemas in E-commerceSorted by Most recent
patients
encounters
providers
E-commerce3 contracted

Clinical EHR Data Platform

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.

12tables
17relationships
113columns
0notes
encounterspatientsproviderslab_orders
View schema Public starter model
dim_customer
fact_orders_daily
dim_date
E-commerce2 contracted

Enterprise Data Warehouse Star Schema

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.

10tables
17relationships
100columns
0notes
fact_orders_dailydim_customerdim_datefact_web_sessions
View schema Public starter model
organizations
orders
customers
E-commerce3 contracted

Shopify-Scale Commerce Platform

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.

12tables
17relationships
117columns
0notes
ordersorganizationscustomersaddresses
View schema Public starter model
payment_intents
merchants
charges
E-commerce3 contracted

Stripe-Scale Payments Platform

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.

12tables
14relationships
114columns
0notes
merchantspayment_intentschargescustomers
View schema Public starter model
Share your work

Have a schema worth sharing? Publish it to the gallery

Open a public starter, fork it into the editor, and push your own reviewed warehouse model back to the community.

Open the editorRead the CLI docs
SchemaStruct

Visual warehouse schema design for data engineers. Model, review, sync, and hand off — one workspace.

Product

EditorDocsPricingGalleryData Lab

Company

AboutBlogContact

Resources

Getting startedSchema templatesdbt integrationAPI reference
© 2026 SchemaStruct. All rights reserved.PrivacyTerms