SQL

CREATE TABLE ocr_text (
  frame_id INT,
  text TEXT,
  text_json TEXT,
  app_name TEXT,
  ocr_engine TEXT,
  window_name TEXT,
  focused NUM,
  text_length INT,
  sync_id TEXT,
  synced_at NUM
)

Columns

Column Data type Allow null Primary key Actions
frame_id INT ✓ 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 NUM ✓ read-only
text_length INT ✓ read-only
sync_id TEXT ✓ read-only
synced_at NUM ✓ read-only

Indexes

Name Columns Unique SQL Drop?
idx_ocr_text_frame_id frame_id SQL 
CREATE INDEX idx_ocr_text_frame_id
ON ocr_text(frame_id)
read-only