Query
CREATE TABLE technician_activities (
id INTEGER PRIMARY KEY AUTOINCREMENT,
technician_id INTEGER NOT NULL,
activity_type TEXT NOT NULL,
description TEXT NOT NULL,
metadata TEXT,
created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
FOREIGN KEY (technician_id) REFERENCES technicians(id) ON DELETE CASCADE
)