# Sub Dictionary: `tbl_OnlyDownload`

## Table Info

| Property | Value |
|----------|-------|
| Table | `tbl_OnlyDownload` |
| Database | quitsure |
| Connection | `mysql` |
| Engine | InnoDB |
| Type | TABLE |
| Category | Core/Master |
| Laravel Model | `OnlyDownload` (app/Models/OnlyDownload.php) |

## Columns

| # | Column | Type | Nullable | Default | Key | Extra | Description |
|---|--------|------|----------|---------|-----|-------|-------------|
| 1 | `iOnlyDownload` | `int unsigned` | NO | - | PRI | auto_increment | Integer: Only Download |
| 2 | `vUDID` | `varchar(500)` | YES | NULL | UNI | - | Varchar: UDID |
| 3 | `vDeviceId` | `varchar(500)` | YES | NULL | MUL | - | Varchar: Device Id |
| 4 | `dDateCreated` | `datetime` | YES | `CURRENT_TIMESTAMP` | MUL | DEFAULT_GENERATED | Datetime: Date Created |
| 5 | `dLastLogin` | `datetime` | YES | NULL | MUL | - | Datetime: Last Login |
| 6 | `bActive` | `tinyint` | NO | `1` | MUL | - | Boolean/Flag: Active |
| 7 | `vSourceUrl` | `varchar(8000)` | YES | NULL | - | - | Varchar: Source Url |
| 8 | `vDeviceType` | `varchar(50)` | YES | NULL | MUL | - | Varchar: Device Type |
| 9 | `vSource` | `varchar(100)` | YES | NULL | MUL | - | Varchar: Source |
| 10 | `vMedium` | `varchar(100)` | YES | NULL | MUL | - | Varchar: Medium |
| 11 | `vCampaign` | `varchar(100)` | YES | NULL | MUL | - | Varchar: Campaign |
| 12 | `vCountry` | `varchar(100)` | YES | NULL | - | - | Varchar: Country |
| 13 | `bTestUser` | `tinyint` | YES | `0` | - | - | Boolean/Flag: Test User |
| 14 | `dUTCOffset` | `varchar(10)` | YES | NULL | - | - | Datetime: UTC Offset |
| 15 | `vDeviceDetails` | `varchar(500)` | YES | NULL | - | - | Varchar: Device Details |
| 16 | `bNotification` | `tinyint` | YES | NULL | - | - | Boolean/Flag: Notification |

## Indexes

| Name | Columns | Unique | Type |
|------|---------|--------|------|
| `idx_source_exists` | `` | NO | BTREE |
| `idx_tbl_onlydownload_bActive` | `bActive` | NO | BTREE |
| `idx_tbl_onlydownload_dDateCreated` | `dDateCreated` | NO | BTREE |
| `idx_tbl_onlydownload_dLastLogin` | `dLastLogin` | NO | BTREE |
| `idx_tbl_OnlyDownload_vCampaign` | `vCampaign` | NO | FULLTEXT |
| `idx_tbl_OnlyDownload_vDeviceId` | `vDeviceId` | NO | BTREE |
| `idx_tbl_OnlyDownload_vDeviceType_vDeviceId` | `vDeviceType`, `vDeviceId` | NO | BTREE |
| `idx_tbl_OnlyDownload_vMedium` | `vMedium` | NO | FULLTEXT |
| `idx_tbl_OnlyDownload_vSource` | `vSource` | NO | FULLTEXT |
| `idx_tbl_OnlyDownload_vUDID_dDateCreated_vDeviceType` | `vUDID`, `dDateCreated`, `vDeviceType` | NO | BTREE |
| `PRIMARY` | `iOnlyDownload` | YES | BTREE |
| `vUDID` | `vUDID` | YES | BTREE |

## Foreign Keys

### Formal Foreign Keys

None defined.