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.
TypeScript analyticsaudience-segmentationchartscohort-analysisgoogle-analyticsproduct-analyticsstatisticsuser-journeyweb-analytics
-- CreateTable
CREATE TABLE "session_link" (
"website_id" UUID NOT NULL,
"session_id" UUID NOT NULL,
"distinct_id" VARCHAR(50) NOT NULL,
"created_at" TIMESTAMPTZ(6) DEFAULT CURRENT_TIMESTAMP,
CONSTRAINT "session_link_pkey" PRIMARY KEY ("website_id","distinct_id","session_id")
);
CREATE INDEX "session_link_website_id_session_id_idx" ON "session_link"("website_id", "session_id");