SQL

CREATE TABLE ui_events (
  id INT,
  timestamp NUM,
  session_id TEXT,
  relative_ms INT,
  event_type TEXT,
  x INT,
  y INT,
  delta_x INT,
  delta_y INT,
  button INT,
  click_count INT,
  key_code INT,
  modifiers INT,
  text_content TEXT,
  text_length INT,
  app_name TEXT,
  app_pid INT,
  window_title TEXT,
  browser_url TEXT,
  element_role TEXT,
  element_name TEXT,
  element_value TEXT,
  element_description TEXT,
  element_automation_id TEXT,
  element_bounds TEXT,
  frame_id INT,
  sync_id TEXT,
  machine_id TEXT,
  synced_at NUM
)

Columns

Column Data type Allow null Primary key Actions
id INT ✓ read-only
timestamp NUM ✓ read-only
session_id TEXT ✓ read-only
relative_ms INT ✓ read-only
event_type TEXT ✓ read-only
x INT ✓ read-only
y INT ✓ read-only
delta_x INT ✓ read-only
delta_y INT ✓ read-only
button INT ✓ read-only
click_count INT ✓ read-only
key_code INT ✓ read-only
modifiers INT ✓ read-only
text_content TEXT ✓ read-only
text_length INT ✓ read-only
app_name TEXT ✓ read-only
app_pid INT ✓ read-only
window_title TEXT ✓ read-only
browser_url TEXT ✓ read-only
element_role TEXT ✓ read-only
element_name TEXT ✓ read-only
element_value TEXT ✓ read-only
element_description TEXT ✓ read-only
element_automation_id TEXT ✓ read-only
element_bounds TEXT ✓ read-only
frame_id INT ✓ read-only
sync_id TEXT ✓ read-only
machine_id TEXT ✓ read-only
synced_at NUM ✓ read-only

Indexes

Name Columns Unique SQL Drop?
idx_ui_events_app_name app_name SQL 
CREATE INDEX idx_ui_events_app_name
ON ui_events(app_name)
read-only
idx_ui_events_frame_id frame_id SQL 
CREATE INDEX idx_ui_events_frame_id
ON ui_events(frame_id)
read-only
idx_ui_events_timestamp timestamp SQL 
CREATE INDEX idx_ui_events_timestamp
ON ui_events(timestamp)
read-only