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
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
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
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