SQL

CREATE TABLE frames (
  id INT,
  video_chunk_id INT,
  offset_index INT,
  timestamp NUM,
  name TEXT,
  app_name TEXT,
  window_name TEXT,
  focused NUM,
  browser_url TEXT,
  device_name TEXT,
  sync_id TEXT,
  machine_id TEXT,
  synced_at NUM,
  snapshot_path TEXT,
  accessibility_text TEXT,
  accessibility_tree_json TEXT,
  content_hash INT,
  simhash INT,
  capture_trigger TEXT,
  text_source TEXT,
  cloud_blob_id TEXT,
  full_text TEXT,
  elements_ref_frame_id INT
)

Columns

Column Data type Allow null Primary key Actions
id INT ✓ read-only
video_chunk_id INT ✓ read-only
offset_index INT ✓ read-only
timestamp NUM ✓ read-only
name TEXT ✓ read-only
app_name TEXT ✓ read-only
window_name TEXT ✓ read-only
focused NUM ✓ read-only
browser_url TEXT ✓ read-only
device_name TEXT ✓ read-only
sync_id TEXT ✓ read-only
machine_id TEXT ✓ read-only
synced_at NUM ✓ read-only
snapshot_path TEXT ✓ read-only
accessibility_text TEXT ✓ read-only
accessibility_tree_json TEXT ✓ read-only
content_hash INT ✓ read-only
simhash INT ✓ read-only
capture_trigger TEXT ✓ read-only
text_source TEXT ✓ read-only
cloud_blob_id TEXT ✓ read-only
full_text TEXT ✓ read-only
elements_ref_frame_id INT ✓ read-only

Indexes

Name Columns Unique SQL Drop?
idx_frames_app_name app_name SQL 
CREATE INDEX idx_frames_app_name
ON frames(app_name)
read-only
idx_frames_timestamp timestamp SQL 
CREATE INDEX idx_frames_timestamp
ON frames(timestamp)
read-only
idx_frames_video_chunk_id video_chunk_id SQL 
CREATE INDEX idx_frames_video_chunk_id
ON frames(video_chunk_id)
read-only
idx_frames_window_name window_name SQL 
CREATE INDEX idx_frames_window_name
ON frames(window_name)
read-only