cards.db — email_verification_tokens

• audit_log
• cards
• email_verification_tokens
• invitations
• migrations
• organisation_settings
• organisations
• password_reset_tokens
• sqlite_sequence
• user_settings
• users

Toggle helper tables

• Structure
• Content
• Query
• Insert
• Drop
• Import
• Export

CREATE TABLE email_verification_tokens  (
  id TEXT PRIMARY KEY,
  user_id TEXT NOT NULL,
  token TEXT UNIQUE NOT NULL,
  expires_at DATETIME NOT NULL,
  verified_at DATETIME,
  created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
  FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE CASCADE
)