Query
CREATE TABLE technicians (
id INTEGER PRIMARY KEY AUTOINCREMENT,
name TEXT NOT NULL,
phone TEXT UNIQUE NOT NULL,
role TEXT NOT NULL CHECK (role IN ('technician', 'field_officer', 'collector')),
email TEXT,
notes TEXT,
is_active INTEGER DEFAULT 1 CHECK (is_active IN (0, 1)),
area_coverage TEXT,
created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
updated_at DATETIME DEFAULT CURRENT_TIMESTAMP,
last_login DATETIME,
whatsapp_group_id TEXT,
join_date DATETIME
)