Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| id | BIGINT | 19 | √ | null |
|
|
||
| userid | BIGINT | 19 | null |
|
|
User ID |
||
| factor | VARCHAR | 100 |
|
|
Factor type |
|||
| secret | VARCHAR | 1333 | √ | null |
|
|
Any secret data for factor |
|
| label | VARCHAR | 1333 | √ | null |
|
|
label for factor instance, eg device or email. |
|
| timecreated | BIGINT | 19 | √ | null |
|
|
Time the factor instance was setup |
|
| createdfromip | VARCHAR | 100 | √ | null |
|
|
IP that the factor was setup from |
|
| timemodified | BIGINT | 19 | √ | null |
|
|
Time factor was last modified. |
|
| lastverified | BIGINT | 19 | √ | null |
|
|
Time user was last verified with this factor. |
|
| revoked | BIT | 1 | 0 |
|
|
|||
| lockcounter | MEDIUMINT | 7 | 0 |
|
|
Counter of failed attempts |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | id |
| toolmfa_fac2_ix | Performance | Asc | factor |
| toolmfa_use2_ix | Performance | Asc | userid |
| toolmfa_usefacloc2_ix | Performance | Asc/Asc/Asc | userid + factor + lockcounter |