Query

event_store.db — reminders

SQL

CREATE TABLE reminders  (
  entity_id TEXT PRIMARY KEY,
  text TEXT NOT NULL,
  due_at_iso TEXT NOT NULL,
  recurrence_cron TEXT,
  status TEXT NOT NULL CHECK (status IN ('active','snoozed','done','cancelled')),
  last_fired_at TEXT,
  done_at TEXT,
  snoozed_until_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
entity_id TEXT ✓ ✓ Rename | Drop
text TEXT Rename | Drop
due_at_iso TEXT Rename | Drop
recurrence_cron TEXT ✓ Rename | Drop
status TEXT Rename | Drop
last_fired_at TEXT ✓ Rename | Drop
done_at TEXT ✓ Rename | Drop
snoozed_until_iso TEXT ✓ Rename | Drop
created_at TEXT Rename | Drop
updated_at TEXT Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
idx_reminders_status_due
  • status
  • due_at_iso
 SQL 
CREATE INDEX idx_reminders_status_due
ON reminders (status, due_at_iso)
Drop
sqlite_autoindex_reminders_1 entity_id ✓ SQL
-- no sql found --
 Drop