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,
  redacted_at INT
)

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
redacted_at INT ✓ 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_redacted_at redacted_at SQL 
CREATE INDEX idx_ocr_text_redacted_at
ON ocr_text(redacted_at)
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