# tool_mfa

0 rows

### Description

Table to store factor configurations for users

### 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_fac_ix | Performance | Asc | factor
toolmfa_use_ix | Performance | Asc | userid
toolmfa_usefacloc_ix | Performance | Asc/Asc/Asc | userid + factor + lockcounter