Query

billing.db — technician_activities

SQL

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
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ ✓ Rename | Drop
technician_id INTEGER Rename | Drop
activity_type TEXT Rename | Drop
description TEXT Rename | Drop
metadata TEXT ✓ Rename | Drop
created_at DATETIME ✓ Rename | Drop

Foreign Keys

Column Destination
technician_id technicians.id

+ Add index

Indexes

Name Columns Unique SQL Drop?
idx_technician_activities_technician technician_id SQL 
CREATE INDEX idx_technician_activities_technician
ON technician_activities(technician_id)
Drop
idx_technician_activities_type activity_type SQL 
CREATE INDEX idx_technician_activities_type
ON technician_activities(activity_type)
Drop