schemastruct
DocumentationBlogAboutGalleryPricingContactSign inGet started

Public Gallery

Browse warehouse schema starting points

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

Review shared warehouse starting pointsCompare public schema patternsFork a design straight into the editor
4
public schemas
46
tables documented
11
contracted tables

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

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 own workspace.

Domain
All domainsE-commerceSaaSFintechHealthcareMLWarehouse
Sort
Most RecentMost TablesMost Contracts
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 schemaPublic starter model
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 schemaPublic starter model
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 schemaPublic starter model
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 schemaPublic starter model