Orders
60%
Included in 3 of 5 comparable schemas
E-commerce
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
2contracted tables
0docs notes
Opens as an unsaved working copy. Sign in later when you want to save it to your workspace.
Schema DNA
Compare this schema to public patterns
This benchmark compares the public schema against the matching gallery corpus plus built-in reference templates. It uses only structural metadata like table roles, density, naming shape, and relationship layout.
Similarity44%
to the closest reference pattern
Coverage0/1
common structural patterns present for e-commerce schemas
DomainE-commerce
inferred from table roles and naming patterns
This e-commerce schema is 44% structurally similar to E-commerce.
It is currently missing 1 common table pattern seen across comparable schemas.
Live preview
Inspect the schema layout
Open the shared review or fork this starter into the editor when you want to keep modeling.
100%