11 lines
372 B
SQL
11 lines
372 B
SQL
-- Daily Active User statistics
|
|
-- Aggregated from telemetry_events, recalculated nightly
|
|
CREATE TABLE IF NOT EXISTS daily_active_stats (
|
|
day DATE PRIMARY KEY,
|
|
dau_count INT NOT NULL DEFAULT 0,
|
|
dau_by_platform JSONB DEFAULT '{}',
|
|
dau_by_region JSONB DEFAULT '{}',
|
|
calculated_at TIMESTAMPTZ NOT NULL DEFAULT NOW(),
|
|
version INT NOT NULL DEFAULT 1
|
|
);
|