# Sub Dictionary: `tbl_UserConfig`

## Table Info

| Property | Value |
|----------|-------|
| Table | `tbl_UserConfig` |
| Database | quitsure |
| Connection | `mysql` |
| Engine | InnoDB |
| Type | TABLE |
| Category | User |
| Laravel Model | `UserConfig` (app/Models/UserConfig.php) |

## Columns

| # | Column | Type | Nullable | Default | Key | Extra | Description |
|---|--------|------|----------|---------|-----|-------|-------------|
| 1 | `iUserID` | `int` | NO | - | PRI | - | Integer: User ID (likely FK) |
| 2 | `vDeviceID` | `varchar(500)` | YES | NULL | MUL | - | Varchar: Device ID |
| 3 | `vFreshChatToken` | `varchar(500)` | YES | NULL | - | - | Varchar: Fresh Chat Token |
| 4 | `vAppVersion` | `varchar(50)` | YES | NULL | - | - | Varchar: App Version |
| 5 | `vCountry` | `varchar(100)` | YES | NULL | MUL | - | Varchar: Country |
| 6 | `dUTCOffset` | `varchar(10)` | YES | NULL | - | - | Datetime: UTC Offset |
| 7 | `vOnBoardLocation` | `varchar(500)` | YES | NULL | - | - | Varchar: On Board Location |
| 8 | `bOnBoardComplete` | `tinyint` | NO | `0` | MUL | - | Boolean/Flag: On Board Complete |
| 9 | `dOnBoardCompleteTime` | `datetime` | YES | NULL | MUL | - | Datetime: On Board Complete Time |
| 10 | `dDownloadDate` | `datetime` | YES | NULL | - | - | Datetime: Download Date |
| 11 | `dDateUpdated` | `datetime` | YES | NULL | MUL | - | Datetime: Date Updated |
| 12 | `bVerified` | `tinyint` | YES | NULL | MUL | - | Boolean/Flag: Verified |
| 13 | `bHasUnusedVoucher` | `tinyint` | YES | `0` | MUL | - | Boolean/Flag: Has Unused Voucher |
| 14 | `bHasRated` | `tinyint` | YES | `0` | MUL | - | Boolean/Flag: Has Rated |
| 15 | `bEmailSubscribed` | `tinyint` | YES | `1` | MUL | - | Boolean/Flag: Email Subscribed |
| 16 | `bNotification` | `tinyint` | YES | NULL | MUL | - | Boolean/Flag: Notification |
| 17 | `bIosFbTrack` | `tinyint` | YES | NULL | - | - | Boolean/Flag: Ios Fb Track |
| 18 | `IsSocialLogin` | `tinyint` | NO | `0` | - | - |  |
| 19 | `SocialLoginType` | `int` | YES | NULL | - | - |  |
| 20 | `vRecordID` | `varchar(100)` | YES | NULL | - | - | Varchar: Record ID |
| 21 | `bTransactSubscribed` | `tinyint` | YES | `1` | - | - | Boolean/Flag: Transact Subscribed |
| 22 | `vExtendedUrl` | `varchar(500)` | YES | NULL | - | - | Varchar: Extended Url |
| 23 | `bExtendedComplete` | `tinyint` | YES | `0` | - | - | Boolean/Flag: Extended Complete |
| 24 | `dExtendedCompleteTime` | `datetime` | YES | NULL | - | - | Datetime: Extended Complete Time |
| 25 | `dProgramStartedOn` | `datetime` | YES | NULL | - | - | Datetime: Program Started On |
| 26 | `bDiscourseAccount` | `tinyint` | YES | `0` | - | - | Boolean/Flag: Discourse Account |
| 27 | `vDiscourseKey` | `varchar(500)` | YES | NULL | - | - | Varchar: Discourse Key |
| 28 | `vDeviceDetails` | `varchar(500)` | YES | NULL | - | - | Varchar: Device Details |
| 29 | `bSubBypass` | `tinyint(1)` | NO | `0` | - | - | Boolean/Flag: Sub Bypass |
| 30 | `bUninstalled` | `int` | NO | `0` | - | - | Boolean/Flag: Uninstalled |
| 31 | `dUninstallTime` | `datetime` | YES | NULL | - | - | Datetime: Uninstall Time |
| 32 | `vDeviceModel` | `varchar(255)` | YES | NULL | - | - | Varchar: Device Model |
| 33 | `vDeviceOS` | `varchar(255)` | YES | NULL | - | - | Varchar: Device OS |
| 34 | `iDeviceCategory` | `int unsigned` | YES | NULL | MUL | - | Integer: Device Category |
| 35 | `vSubIntent` | `varchar(255)` | YES | NULL | - | - | Varchar: Sub Intent |

## Indexes

| Name | Columns | Unique | Type |
|------|---------|--------|------|
| `idx_device_category_model` | `iDeviceCategory`, `vDeviceModel` | NO | BTREE |
| `idx_tbl_userconfig_bEmailSubscribed` | `bEmailSubscribed` | NO | BTREE |
| `idx_tbl_userconfig_bHasRated` | `bHasRated` | NO | BTREE |
| `idx_tbl_userconfig_bHasUnusedVoucher` | `bHasUnusedVoucher` | NO | BTREE |
| `idx_tbl_userconfig_bNotification` | `bNotification` | NO | BTREE |
| `idx_tbl_userconfig_bOnBoardComplete` | `bOnBoardComplete` | NO | BTREE |
| `idx_tbl_userconfig_bVerified` | `bVerified` | NO | BTREE |
| `idx_tbl_userconfig_dDateUpdated` | `dDateUpdated` | NO | BTREE |
| `idx_tbl_userconfig_dOnBoardCompleteTime` | `dOnBoardCompleteTime` | NO | BTREE |
| `idx_tbl_UserConfig_iUserID_bVerified` | `iUserID`, `bVerified` | NO | BTREE |
| `idx_tbl_userconfig_vCountry` | `vCountry` | NO | BTREE |
| `idx_tbl_userconfig_vDeviceID` | `vDeviceID` | NO | BTREE |
| `PRIMARY` | `iUserID` | YES | BTREE |

## Foreign Keys

### Formal Foreign Keys

| Constraint | Column | References |
|-----------|--------|------------|
| `tbl_UserConfig_ibfk_1` | `iUserID` | `tbl_Users`.`iUserID` |