Query
CREATE TABLE technician_sessions (
id INTEGER PRIMARY KEY AUTOINCREMENT,
session_id TEXT UNIQUE NOT NULL,
technician_id INTEGER NOT NULL,
expires_at DATETIME NOT NULL,
ip_address TEXT,
user_agent TEXT,
is_active INTEGER DEFAULT 1 CHECK (is_active IN (0, 1)),
created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
last_activity DATETIME DEFAULT CURRENT_TIMESTAMP,
FOREIGN KEY (technician_id) REFERENCES technicians(id) ON DELETE CASCADE
)