Query

event_store.db — inbox_items

SQL

CREATE TABLE inbox_items  (
  id TEXT PRIMARY KEY,
  type TEXT NOT NULL,
  text TEXT NOT NULL,
  normalized_text TEXT,
  status TEXT NOT NULL CHECK (status IN ('new','open','triaged','snoozed','done','dismissed','archived')),
  tags TEXT,
  links TEXT,
  ts TEXT NOT NULL,
  route TEXT,
  urgency TEXT,
  next_touch_at_iso TEXT,
  created_at TEXT NOT NULL DEFAULT (strftime('%Y-%m-%dT%H:%M:%fZ','now')),
  updated_at TEXT NOT NULL DEFAULT (strftime('%Y-%m-%dT%H:%M:%fZ','now'))
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id TEXT ✓ ✓ Rename | Drop
type TEXT Rename | Drop
text TEXT Rename | Drop
normalized_text TEXT ✓ Rename | Drop
status TEXT Rename | Drop
tags TEXT ✓ Rename | Drop
links TEXT ✓ Rename | Drop
ts TEXT Rename | Drop
route TEXT ✓ Rename | Drop
urgency TEXT ✓ Rename | Drop
next_touch_at_iso TEXT ✓ Rename | Drop
created_at TEXT Rename | Drop
updated_at TEXT Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
idx_inbox_due
  • status
  • route
  • next_touch_at_iso
  • ts
 SQL 
CREATE INDEX idx_inbox_due
ON inbox_items(status, route, next_touch_at_iso, ts)
Drop
idx_inbox_items_status_ts
  • status
  • ts
 SQL 
CREATE INDEX idx_inbox_items_status_ts
ON inbox_items(status, ts DESC)
Drop
idx_inbox_status_ts
  • status
  • ts
 SQL 
CREATE INDEX idx_inbox_status_ts
ON inbox_items (status, ts)
Drop
idx_inbox_type_ts
  • type
  • ts
 SQL 
CREATE INDEX idx_inbox_type_ts
ON inbox_items (type, ts)
Drop
idx_inbox_updated updated_at SQL 
CREATE INDEX idx_inbox_updated
ON inbox_items (updated_at)
Drop
sqlite_autoindex_inbox_items_1 id ✓ SQL
-- no sql found --
 Drop