# Sub Dictionary: `tbl_DeepLinkClicks`

## Table Info

| Property | Value |
|----------|-------|
| Table | `tbl_DeepLinkClicks` |
| Database | quitsure |
| Connection | `mysql` |
| Engine | InnoDB |
| Type | TABLE |
| Category | Deep Linking |
| Laravel Model | `DeepLinkClick` (app/Models/DeepLinkClick.php) |

Per-click log for self-hosted deep links, written by the redirect agent when a link is tapped on a not-installed device. Powers click/install analytics and the Android deferred-install bridge (token in the Play Install Referrer). Pruned after 120 days by the `clean_deep_link_clicks` cron.

## Columns

| # | Column | Type | Nullable | Default | Key | Extra | Description |
|---|--------|------|----------|---------|-----|-------|-------------|
| 1 | `id` | `bigint unsigned` | NO | - | PRI | auto_increment | Auto-increment primary key |
| 2 | `vToken` | `varchar(10)` (utf8mb4_bin) | NO | - | UNI | - | Per-click token (carried in the Play Install Referrer as `qs_token`) |
| 3 | `vLinkCode` | `varchar(10)` (utf8mb4_bin) | YES | - | MUL | - | Campaign code for `/l/{code}` clicks; null for SSO/catch-all (indexed) |
| 4 | `vTargetPath` | `varchar(512)` | YES | - | - | - | Resolved in-app screen path |
| 5 | `vWebFallbackUrl` | `varchar(2048)` | YES | - | - | - | Web fallback URL used for this click |
| 6 | `vPlatformGuess` | `varchar(20)` | NO | - | - | - | Detected platform from the User-Agent (`ios`, `android`, `desktop`, `inapp`, `unknown`) |
| 7 | `vUserAgent` | `varchar(1024)` | YES | - | - | - | Truncated request User-Agent |
| 8 | `vIpHash` | `char(64)` | YES | - | - | - | Salted SHA-256 of client IP (no raw IP stored) |
| 9 | `setRawQuery` | `json` | YES | - | - | - | Captured query params (capped 50 × 512, UTF-8 sanitized) |
| 10 | `vUtmSource` | `varchar(255)` | YES | - | - | - | Campaign UTM source |
| 11 | `vUtmMedium` | `varchar(255)` | YES | - | - | - | Campaign UTM medium |
| 12 | `vUtmCampaign` | `varchar(255)` | YES | - | MUL | - | Campaign UTM campaign (indexed) |
| 13 | `setCustomParams` | `json` | YES | - | - | - | Extra params; holds `{u,s}` for deferred SSO links |
| 14 | `vRoutedTo` | `varchar(20)` | YES | - | - | - | Where the agent routed this click (`app_store`, `play_store`, `web`, `interstitial`) |
| 15 | `dDateCreated` | `datetime` | NO | `CURRENT_TIMESTAMP` | MUL | DEFAULT_GENERATED | Datetime: click time (indexed) |
| 16 | `dResolvedAt` | `datetime` | YES | - | - | - | Set when the app resolves the token post-install |
| 17 | `vResolvedPlatform` | `varchar(16)` | YES | - | - | - | Platform that resolved the token |