# Sub Dictionary: `tbl_UserSubHistory`

## Table Info

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

## Columns

| # | Column | Type | Nullable | Default | Key | Extra | Description |
|---|--------|------|----------|---------|-----|-------|-------------|
| 1 | `ID` | `int unsigned` | NO | - | PRI | auto_increment |  |
| 2 | `iUserProgramID` | `int unsigned` | NO | - | MUL | - | Integer: User Program ID (likely FK) |
| 3 | `dStartDate` | `datetime` | NO | - | MUL | - | Datetime: Start Date |
| 4 | `dExpiryDate` | `datetime` | YES | NULL | MUL | - | Datetime: Expiry Date |
| 5 | `vSubType` | `varchar(100)` | NO | - | MUL | - | Varchar: Sub Type |
| 6 | `bExpired` | `tinyint(1)` | YES | `0` | MUL | - | Boolean/Flag: Expired |
| 7 | `vExpiredReason` | `varchar(500)` | YES | NULL | - | - | Varchar: Expired Reason |
| 8 | `vSubscriptionId` | `varchar(1000)` | YES | NULL | - | - | Varchar: Subscription Id |
| 9 | `vProductId` | `varchar(100)` | YES | NULL | - | - | Varchar: Product Id |
| 10 | `vLabel` | `varchar(100)` | YES | NULL | - | - | Varchar: Label |
| 11 | `iCouponId` | `int unsigned` | YES | NULL | - | - | Integer: Coupon Id (likely FK) |
| 12 | `iDiscount` | `int unsigned` | YES | NULL | - | - | Integer: Discount |
| 13 | `bRestore` | `tinyint` | YES | NULL | - | - | Boolean/Flag: Restore |
| 14 | `vCurrency` | `varchar(10)` | YES | NULL | - | - | Varchar: Currency |
| 15 | `decPrice` | `decimal(10,2)` | YES | NULL | - | - | Decimal: Price |
| 16 | `vSubScreen` | `varchar(100)` | YES | NULL | - | - | Varchar: Sub Screen |

## Indexes

| Name | Columns | Unique | Type |
|------|---------|--------|------|
| `idx_tbl_UserSubHistory_bExpired` | `bExpired` | NO | BTREE |
| `idx_tbl_UserSubHistory_dExpiryDate` | `dExpiryDate` | NO | BTREE |
| `idx_tbl_UserSubHistory_dStartDate` | `dStartDate` | NO | BTREE |
| `idx_tbl_UserSubHistory_iUserProgramID` | `iUserProgramID` | NO | BTREE |
| `idx_tbl_UserSubHistory_vSubType` | `vSubType` | NO | BTREE |
| `PRIMARY` | `ID` | YES | BTREE |

## Foreign Keys

### Formal Foreign Keys

None defined.

### Implicit Relationships (from column naming)

| Column | Likely References |
|--------|------------------|
| `iUserProgramID` | `tbl_UserPrograms.iUserProgramID` |
| `iCouponId` | `tbl_Coupons.iCouponId` |