# Sub Dictionary: `UserSubHistory`

## Table Info

| Property | Value |
|----------|-------|
| Table | `UserSubHistory` |
| Database | quitsure |
| Connection | `mysql` |
| Engine | N/A |
| Type | VIEW |
| Category | Core/Master |
| Comment | VIEW |

## Columns

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

## Foreign Keys

### Formal Foreign Keys

None defined.

### Implicit Relationships (from column naming)

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