login_mfa_registrations

Columns

Column	Type	Size	Nulls	Auto	Default	Children	Parents	Comments
user_id	BIGINT	19			null

|

| | | name | VARCHAR | 30 | | | null |

|

| | | last_challenge | DATETIME | 19 | √ | | NULL |

|

| | | method | VARCHAR | 31 | | | null |

|

|

Q&A, U2F, TOTP etc.

| | var1 | VARCHAR | 4096 | | | '' |

|

|

Question, U2F registration etc.

| | var2 | VARCHAR | 256 | | | '' |

|

|

Answer etc.

|

Indexes

Constraint Name	Type	Sort	Column(s)
PRIMARY	Primary key	Asc/Asc	user_id + name

Relationships

Close relationships within degrees of separation