DATA PIPELINE
How Visits Are Tracked
A transparent overview of how visitor actions flow from the browser directly into our secure database metrics.
DATABASE SCHEMA
The Visits Table
Visitor
Our relational schema is optimized for fast writes and real-time aggregation of unique, privacy-focused visits.
↓
Website
CREATE TABLE visits (
↓
id SERIAL PRIMARY KEY,
/api/visitor
visitor_id VARCHAR(255),
↓
ip_hash VARCHAR(255),
user_agent TEXT,
Database
visited_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
↓
);
Visitor Statistics
├── Today
├── This Week
├── This Month
└── Total


