Skip to content

Analytics Schema

Schema: ext_analytics | Auto-generated on 2026-03-30


Individual click events with geo, device, UTM data.

ColumnTypeNullableDefault
iduuidNOgen_random_uuid()
user_iduuidNO—
source_apptextNO—
source_iduuidNO—
source_typetextYES—
ip_hashtextYES—
countrytextYES—
citytextYES—
device_typetextYES—
browsertextYES—
ostextYES—
referrertextYES—
referrer_domaintextYES—
utm_sourcetextYES—
utm_mediumtextYES—
utm_campaigntextYES—
utm_termtextYES—
utm_contenttextYES—
metadatajsonbYES'{}'
clicked_attimestamptzNOnow()

Pre-aggregated daily click/visitor stats per source.

ColumnTypeNullableDefault
iduuidNOgen_random_uuid()
user_iduuidNO—
source_apptextNO—
source_iduuidNO—
datedateNO—
total_clicksintegerNO0
unique_visitorsintegerNO0