Query

billing.db — technician_sessions

SQL

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
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ ✓ Rename | Drop
session_id TEXT Rename | Drop
technician_id INTEGER Rename | Drop
expires_at DATETIME Rename | Drop
ip_address TEXT ✓ Rename | Drop
user_agent TEXT ✓ Rename | Drop
is_active INTEGER ✓ Rename | Drop
created_at DATETIME ✓ Rename | Drop
last_activity DATETIME ✓ Rename | Drop

Foreign Keys

Column Destination
technician_id technicians.id

+ Add index

Indexes

Name Columns Unique SQL Drop?
idx_technician_sessions_expires expires_at SQL 
CREATE INDEX idx_technician_sessions_expires
ON technician_sessions(expires_at)
Drop
idx_technician_sessions_id session_id SQL 
CREATE INDEX idx_technician_sessions_id
ON technician_sessions(session_id)
Drop
sqlite_autoindex_technician_sessions_1 session_id ✓ SQL
-- no sql found --
 Drop