SQL

CREATE TABLE "ocr_text"  (
  frame_id INTEGER NOT NULL,
  text TEXT NOT NULL,
  text_json TEXT,
  app_name TEXT NOT NULL DEFAULT '',
  ocr_engine TEXT NOT NULL DEFAULT 'unknown',
  window_name TEXT,
  focused BOOLEAN DEFAULT FALSE,
  text_length INTEGER,
  sync_id TEXT,
  synced_at DATETIME
)

Columns

Column Data type Allow null Primary key Actions
frame_id INTEGER read-only
text TEXT read-only
text_json TEXT ✓ read-only
app_name TEXT read-only
ocr_engine TEXT read-only
window_name TEXT ✓ read-only
focused BOOLEAN ✓ read-only
text_length INTEGER ✓ read-only
sync_id TEXT ✓ read-only
synced_at DATETIME ✓ read-only

Indexes

Name Columns Unique SQL Drop?
idx_ocr_text_frame_app_window
  • frame_id
  • app_name
  • window_name
 SQL 
CREATE INDEX idx_ocr_text_frame_app_window
ON ocr_text(frame_id, app_name, window_name)
read-only
idx_ocr_text_frame_id frame_id SQL 
CREATE INDEX idx_ocr_text_frame_id
ON ocr_text(frame_id)
read-only
idx_ocr_text_length text_length SQL 
CREATE INDEX idx_ocr_text_length
ON ocr_text (text_length)
read-only
idx_ocr_text_sync_id sync_id SQL 
CREATE INDEX idx_ocr_text_sync_id
ON ocr_text(sync_id) WHERE sync_id IS NOT NULL
read-only