Skip to content

armgit / umami

Public Imported from GitHub
0

Umami is a privacy-first web and product analytics platform. Traffic, campaigns, behavior, conversions, and revenue in one place. No cookies, no surveillance, self-hosted or in the cloud.

632 B
Raw Blame
-- Create heatmap_event
CREATE TABLE umami.heatmap_event
(
    heatmap_event_id UUID,
    website_id UUID,
    session_id UUID,
    visit_id UUID,
    url_path String,
    event_type UInt8,
    x Nullable(Int32),
    y Nullable(Int32),
    page_x Nullable(Int32),
    page_y Nullable(Int32),
    page_w Nullable(Int32),
    viewport_w Nullable(Int32),
    viewport_h Nullable(Int32),
    page_h Nullable(Int32),
    scroll_pct Nullable(UInt8),
    created_at DateTime('UTC')
)
ENGINE = MergeTree
    PARTITION BY toYYYYMM(created_at)
    ORDER BY (website_id, url_path, event_type, created_at)
    SETTINGS index_granularity = 8192;