# Sub Dictionary: `tbl_DeepLinks`

## Table Info

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

Registry of self-hosted marketing campaign deep links (`link.quitsure.app/l/{code}`). Created via the admin Deep Links builder. Replaces Branch.io campaign links.

## Columns

| # | Column | Type | Nullable | Default | Key | Extra | Description |
|---|--------|------|----------|---------|-----|-------|-------------|
| 1 | `id` | `bigint unsigned` | NO | - | PRI | auto_increment | Auto-increment primary key |
| 2 | `vCode` | `varchar(10)` (utf8mb4_bin) | NO | - | UNI | - | Short, case-sensitive code used in the `/l/{code}` URL |
| 3 | `vTargetPath` | `varchar(512)` | NO | - | - | - | In-app screen path to open (e.g. `/article/benefits`) |
| 4 | `vWebFallbackUrl` | `varchar(2048)` | NO | - | - | - | Desktop/no-app fallback URL (host must be allowlisted, on quitsure.app) |
| 5 | `vUtmSource` | `varchar(255)` | YES | - | - | - | Campaign UTM source |
| 6 | `vUtmMedium` | `varchar(255)` | YES | - | - | - | Campaign UTM medium |
| 7 | `vUtmCampaign` | `varchar(255)` | YES | - | MUL | - | Campaign UTM campaign (indexed) |
| 8 | `setCustomParams` | `json` | YES | - | - | - | Arbitrary extra campaign key/values |
| 9 | `bActive` | `tinyint(1)` | NO | `1` | - | - | Boolean/Flag: link active (inactive → falls back to web) |
| 10 | `dDateCreated` | `datetime` | NO | `CURRENT_TIMESTAMP` | - | DEFAULT_GENERATED | Datetime: Date Created |