Query

billing.db — trouble_reports

+/- table definition

Query 

CREATE TABLE trouble_reports  (
  id INTEGER PRIMARY KEY AUTOINCREMENT,
  phone TEXT,
  name TEXT,
  location TEXT,
  category TEXT,
  description TEXT,
  status TEXT DEFAULT 'pending',
  assigned_to INTEGER,
  resolution TEXT,
  created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
  updated_at DATETIME DEFAULT CURRENT_TIMESTAMP
)
Use Shift + Up/Down to navigate recently-executed queries
delete expression index : create index : drop insert select : advanced select table : alter table : create table : drop trigger : create trigger : drop update upsert view : create view : drop