# Sub Dictionary: `tbl_AdminActivity`

## Table Info

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

## Columns

| # | Column | Type | Nullable | Default | Key | Extra | Description |
|---|--------|------|----------|---------|-----|-------|-------------|
| 1 | `iAdminActivityID` | `int unsigned` | NO | - | PRI | auto_increment | Integer: Admin Activity ID (likely FK) |
| 2 | `iAdminID` | `int unsigned` | NO | - | - | - | Integer: Admin ID (likely FK) |
| 3 | `vPageName` | `varchar(45)` | NO | - | MUL | - | Varchar: Page Name |
| 4 | `vButtonName` | `varchar(45)` | NO | - | - | - | Varchar: Button Name |
| 5 | `vOldData` | `text` | YES | NULL | MUL | - | Varchar: Old Data |
| 6 | `vNewData` | `text` | YES | NULL | MUL | - | Varchar: New Data |
| 7 | `dDateCreated` | `datetime` | NO | `CURRENT_TIMESTAMP` | - | DEFAULT_GENERATED | Datetime: Date Created |

## Indexes

| Name | Columns | Unique | Type |
|------|---------|--------|------|
| `idx_tbl_AdminActivity_vNewData` | `vNewData` | NO | BTREE |
| `idx_tbl_AdminActivity_vOldData` | `vOldData` | NO | BTREE |
| `PRIMARY` | `iAdminActivityID` | YES | BTREE |
| `vPageName` | `vPageName`, `vButtonName` | NO | BTREE |

## Foreign Keys

### Formal Foreign Keys

None defined.