📈 Open source, privacy-first web analytics — a cookie-less Google Analytics alternative with built-in error tracking and performance monitoring. Self-host it or use our cloud. Get started for free!
TypeScript chartsclickhousedockergdprgoogle-analyticsmetricsmonitoringmysqlnestjsprivacyredisself-hostedselfhostedstatisticstailwindcssweb-analyticswebanalyticswebsite
CREATE TABLE `projects_views` (
`id` varchar(36) NOT NULL,
`projectId` varchar(255) NOT NULL,
`name` varchar(255) NOT NULL,
`type` enum('traffic','performance') NOT NULL,
`pg` varchar(255) NOT NULL,
`ev` varchar(255) NOT NULL,
`dv` varchar(255) DEFAULT NULL,
`br` varchar(255) DEFAULT NULL,
`os` varchar(255) DEFAULT NULL,
`lc` varchar(255) DEFAULT NULL,
`ref` varchar(255) DEFAULT NULL,
`so` varchar(255) DEFAULT NULL,
`me` varchar(255) DEFAULT NULL,
`ca` varchar(255) DEFAULT NULL,
`cc` varchar(2) DEFAULT NULL,
`rg` varchar(255) DEFAULT NULL,
`ct` varchar(255) DEFAULT NULL,
`createdAt` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
`updatedAt` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6),
PRIMARY KEY (`id`),
FOREIGN KEY (`projectId`) REFERENCES `project` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
CREATE TABLE `projects_views_custom_events` (
`id` varchar(36) NOT NULL,
`viewId` varchar(255) NOT NULL,
`customEventName` varchar(255) NOT NULL,
`metaKey` varchar(255) NOT NULL,
`metaValue` varchar(255) NOT NULL,
`metaValueType` enum('string','integer','float') NOT NULL DEFAULT 'string',
`createdAt` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
`updatedAt` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6),
PRIMARY KEY (`id`),
FOREIGN KEY (`viewId`) REFERENCES `projects_views` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;