# Sub Dictionary: `tbl_IOSPrice`

## Table Info

| Property | Value |
|----------|-------|
| Table | `tbl_IOSPrice` |
| Database | quitsure |
| Connection | `mysql` |
| Engine | InnoDB |
| Type | TABLE |
| Category | Core/Master |
| Comment | iOS program pricing by country and currency |

## Columns

| # | Column | Type | Nullable | Default | Key | Extra | Description |
|---|--------|------|----------|---------|-----|-------|-------------|
| 1 | `id` | `int` | NO | - | PRI | auto_increment | Auto-increment primary key |
| 2 | `vCountry` | `varchar(100)` | NO | - | UNI | - | Varchar: Country |
| 3 | `vCurrency` | `varchar(10)` | NO | - | MUL | - | Varchar: Currency |
| 4 | `decProgram1` | `decimal(10,2)` | YES | NULL | - | - | Decimal: Program1 |
| 5 | `decProgram3` | `decimal(10,2)` | YES | NULL | - | - | Decimal: Program3 |
| 6 | `decProgram4` | `decimal(10,2)` | YES | NULL | - | - | Decimal: Program4 |
| 7 | `decProgram7` | `decimal(10,2)` | YES | NULL | - | - | Decimal: Program7 |
| 8 | `decProgram5` | `decimal(10,2)` | YES | NULL | - | - | Decimal: Program5 |
| 9 | `decProgram2` | `decimal(10,2)` | YES | NULL | - | - | Decimal: Program2 |
| 10 | `created_at` | `timestamp` | YES | `CURRENT_TIMESTAMP` | - | DEFAULT_GENERATED | Laravel timestamp (created) |
| 11 | `updated_at` | `timestamp` | YES | `CURRENT_TIMESTAMP` | - | DEFAULT_GENERATED on update CURRENT_TIMESTAMP | Laravel timestamp (updated) |

## Indexes

| Name | Columns | Unique | Type |
|------|---------|--------|------|
| `idx_currency` | `vCurrency` | NO | BTREE |
| `PRIMARY` | `id` | YES | BTREE |
| `uk_country` | `vCountry` | YES | BTREE |

## Foreign Keys

### Formal Foreign Keys

None defined.