# Sub Dictionary: `tbl_UserAppActivity`

## Table Info

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

## Columns

| # | Column | Type | Nullable | Default | Key | Extra | Description |
|---|--------|------|----------|---------|-----|-------|-------------|
| 1 | `iUserId` | `int unsigned` | NO | - | PRI | - | Integer: User Id (likely FK) |
| 2 | `iStatsView` | `int unsigned` | NO | `0` | - | - | Integer: Stats View |
| 3 | `iTrackerView` | `int unsigned` | NO | `0` | - | - | Integer: Tracker View |
| 4 | `dDeletedDate` | `datetime` | YES | NULL | - | - | Datetime: Deleted Date |
| 5 | `iProgramChange` | `int unsigned` | NO | `0` | - | - | Integer: Program Change |
| 6 | `iInstructionsView` | `int unsigned` | NO | `0` | - | - | Integer: Instructions View |
| 7 | `iShareTheApp` | `int unsigned` | NO | `0` | - | - | Integer: Share The App |
| 8 | `iHowToDoProgram` | `int unsigned` | NO | `0` | - | - | Integer: How To Do Program |
| 9 | `iInitiateRelapse` | `int unsigned` | NO | `0` | - | - | Integer: Initiate Relapse |
| 10 | `bWhatsappJoin` | `tinyint(1)` | YES | NULL | - | - | Boolean/Flag: Whatsapp Join |
| 11 | `iSeeAllAchievements` | `int unsigned` | YES | `0` | - | - | Integer: See All Achievements |
| 12 | `iHelpLinkInProfile` | `int unsigned` | NO | `0` | - | - | Integer: Help Link In Profile |
| 13 | `iHelpLinkInExercise` | `int unsigned` | NO | `0` | - | - | Integer: Help Link In Exercise |
| 14 | `iRateProfile` | `int unsigned` | NO | `0` | - | - | Integer: Rate Profile |
| 15 | `iArticleId` | `int unsigned` | NO | `27` | - | - | Integer: Article Id (likely FK) |
| 16 | `bArticleViewed` | `int` | NO | `0` | - | - | Boolean/Flag: Article Viewed |
| 17 | `i555Breathing` | `int unsigned` | NO | `0` | - | - |  |
| 18 | `iPostQuitBanner` | `int unsigned` | NO | `0` | - | - | Integer: Post Quit Banner |
| 19 | `iPostQuitShare` | `int unsigned` | NO | `0` | - | - | Integer: Post Quit Share |
| 20 | `iRateExercise` | `int unsigned` | NO | `0` | - | - | Integer: Rate Exercise |
| 21 | `iCommunity` | `int unsigned` | NO | `0` | - | - | Integer: Community |
| 22 | `iCancelSubscribe` | `int unsigned` | NO | `0` | - | - | Integer: Cancel Subscribe |
| 23 | `iRatingNo` | `int unsigned` | NO | `0` | - | - | Integer: Rating No |
| 24 | `bAlreadyRated` | `int unsigned` | NO | `0` | - | - | Boolean/Flag: Already Rated |
| 25 | `bRateLater` | `int unsigned` | NO | `0` | - | - | Boolean/Flag: Rate Later |
| 26 | `bSetHesitationOpen` | `int unsigned` | NO | `0` | - | - | Boolean/Flag: Set Hesitation Open |
| 27 | `iPreQuitImageShare` | `int unsigned` | NO | `0` | - | - | Integer: Pre-quit motivational image share count |
| 28 | `iPostQuitImageShare` | `int unsigned` | NO | `0` | - | - | Integer: Post-quit motivational image share count |

## Indexes

| Name | Columns | Unique | Type |
|------|---------|--------|------|
| `iUserId_UNIQUE` | `iUserId` | YES | BTREE |
| `PRIMARY` | `iUserId` | YES | BTREE |

## Foreign Keys

### Formal Foreign Keys

None defined.

### Implicit Relationships (from column naming)

| Column | Likely References |
|--------|------------------|
| `iUserId` | `tbl_Users.iUserID` |
| `iArticleId` | `tbl_Articles.iArticleId` |