logo
ExamplesEditorPricingDocs
37.1kSign in

A/B testing & experimentation platform schema

An experimentation platform end to end: experiments and weighted variants, deterministic hash bucketing, exposure events, metric definitions, per-variant aggregates with sufficient statistics, significance results and staged rollout.

A/B Testing ER diagram

A/B testing & experimentation platform schema n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 exclusion_groups idBIGINT keyVARCHAR nameVARCHAR total_slotsINTEGER hash_seedVARCHAR created_atTIMESTAMP experiments idBIGINT keyVARCHAR nameVARCHAR hypothesisTEXT subject_typeVARCHAR statusVARCHAR hash_seedVARCHAR traffic_percentSMALLINT exclusion_group_idBIGINT bucket_lowINTEGER bucket_highINTEGER primary_metric_idBIGINT winner_variant_idBIGINT started_atTIMESTAMP ended_atTIMESTAMP created_atTIMESTAMP variants idBIGINT experiment_idBIGINT keyVARCHAR nameVARCHAR is_controlBOOLEAN traffic_weightSMALLINT configJSONB assignments idBIGINT experiment_idBIGINT variant_idBIGINT subject_keyVARCHAR bucketINTEGER assigned_atTIMESTAMP exposures idBIGINT experiment_idBIGINT variant_idBIGINT subject_keyVARCHAR occurred_atTIMESTAMP contextJSONB metric_definitions idBIGINT keyVARCHAR nameVARCHAR metric_typeVARCHAR aggregationVARCHAR directionVARCHAR is_guardrailBOOLEAN window_hoursINTEGER experiment_metrics experiment_idBIGINT metric_idBIGINT roleVARCHAR minimum_detectabl…DECIMAL metric_events idBIGINT metric_idBIGINT subject_keyVARCHAR value_numericDECIMAL occurred_atTIMESTAMP dedupe_keyVARCHAR variant_daily_stats idBIGINT experiment_idBIGINT variant_idBIGINT metric_idBIGINT stat_dateDATE subject_countBIGINT converted_countBIGINT value_sumDECIMAL value_sum_squaresDECIMAL experiment_results idBIGINT experiment_idBIGINT variant_idBIGINT metric_idBIGINT computed_atTIMESTAMP methodVARCHAR subject_countBIGINT mean_valueDECIMAL relative_liftDECIMAL confidence_lowerDECIMAL confidence_upperDECIMAL p_valueDECIMAL is_significantBOOLEAN rollouts idBIGINT experiment_idBIGINT variant_idBIGINT percentSMALLINT statusVARCHAR started_atTIMESTAMP completed_atTIMESTAMP rolled_back_atTIMESTAMP notesTEXT

Related database schemas

PostgreSQL
SaaS

Product analytics platform database schema

How a product analytics service stores its data: projects and a discovered event registry, raw events with JSONB properties, anonymous and identified users with identity merges, sessions, funnels, cohorts, retention reports and precomputed metric snapshots.

PostgreSQL
SaaS

Email marketing & campaign database schema

How a campaign sender stores its data: lists and contacts with custom fields, rule-based segments, campaigns with A/B variants, one send row per recipient, opens and clicks, bounces and suppressions, and drip automations.

PostgreSQL
SaaS

Help desk & customer support ticketing schema

A support desk modelled properly: tickets in queues, one thread that mixes public replies with internal notes, SLA clocks measured in business hours with breach tracking, macros, tags, merges and CSAT.

PostgreSQL
SaaS

Multi-tenant SaaS database schema

Shared-database multi-tenancy done properly: organizations as tenants, global users joined through memberships, invitations, scoped API keys, plans, subscriptions, metered usage and an append-only audit log.