CREATE TABLE totp_authenticators
(
    id           VARCHAR   NOT NULL PRIMARY KEY,
    user_id      VARCHAR   NOT NULL REFERENCES users (id) ON DELETE CASCADE,
    secret       VARCHAR   NOT NULL,
    verified     BOOLEAN   NOT NULL,
    name         VARCHAR   NOT NULL,
    created_at   TIMESTAMP NOT NULL,
    last_seen_at TIMESTAMP NOT NULL
);