cards.db — users

• 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 users  (
  id TEXT PRIMARY KEY,
  email TEXT UNIQUE NOT NULL,
  password_hash TEXT NOT NULL,
  organisation_id TEXT,
  role TEXT DEFAULT 'member',
  email_verified INTEGER DEFAULT 0,
  created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
  updated_at DATETIME DEFAULT CURRENT_TIMESTAMP,
  FOREIGN KEY (organisation_id) REFERENCES organisations(id) ON DELETE SET NULL
)