Analytics Schema
ext_analytics - Analytics
Section titled “ext_analytics - Analytics”Schema: ext_analytics | Auto-generated on 2026-03-30
clicks
Section titled “clicks”Individual click events with geo, device, UTM data.
| Column | Type | Nullable | Default |
|---|---|---|---|
id | uuid | NO | gen_random_uuid() |
user_id | uuid | NO | — |
source_app | text | NO | — |
source_id | uuid | NO | — |
source_type | text | YES | — |
ip_hash | text | YES | — |
country | text | YES | — |
city | text | YES | — |
device_type | text | YES | — |
browser | text | YES | — |
os | text | YES | — |
referrer | text | YES | — |
referrer_domain | text | YES | — |
utm_source | text | YES | — |
utm_medium | text | YES | — |
utm_campaign | text | YES | — |
utm_term | text | YES | — |
utm_content | text | YES | — |
metadata | jsonb | YES | '{}' |
clicked_at | timestamptz | NO | now() |
daily_stats
Section titled “daily_stats”Pre-aggregated daily click/visitor stats per source.
| Column | Type | Nullable | Default |
|---|---|---|---|
id | uuid | NO | gen_random_uuid() |
user_id | uuid | NO | — |
source_app | text | NO | — |
source_id | uuid | NO | — |
date | date | NO | — |
total_clicks | integer | NO | 0 |
unique_visitors | integer | NO | 0 |