Add Column

Cancel

Current Schema

CREATE TABLE sessions  (
  id TEXT PRIMARY KEY,
  -- 32 Bytes hex
  kind TEXT NOT NULL,
  -- 'trainer' | 'student'
  trainer_id INTEGER REFERENCES trainers(id) ON DELETE CASCADE,
  student_id INTEGER REFERENCES students(id) ON DELETE CASCADE,
  created_at TEXT NOT NULL DEFAULT (datetime('now')),
  expires_at TEXT NOT NULL,
  last_seen_at TEXT NOT NULL DEFAULT (datetime('now')),
  ip TEXT,
  user_agent TEXT
)