CMS_MFA

Tables (3)

mfa

  • id — int — Primary key — NOT NULL
  • mfa_question_id — int — Foreign key → mfa_questions.id — NOT NULL
  • user_id — int — Foreign key → users.id — NOT NULL
  • answer — varchar(255) — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp

mfa_questions

  • id — int — Primary key — NOT NULL
  • question — varchar(255) — NOT NULL
  • status — int — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp

users

  • id — int — Primary key — NOT NULL
  • is_mfa_completed — int — 1 - completed, null - not completed