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

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
redacted_at INT ✓ 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_event_type event_type SQL 
CREATE INDEX idx_ui_events_event_type
ON ui_events(event_type)
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_redacted_at redacted_at SQL 
CREATE INDEX idx_ui_events_redacted_at
ON ui_events(redacted_at)
read-only
idx_ui_events_session_id session_id SQL 
CREATE INDEX idx_ui_events_session_id
ON ui_events(session_id)
read-only
idx_ui_events_sync_id sync_id SQL 
CREATE INDEX idx_ui_events_sync_id
ON ui_events(sync_id)
read-only
idx_ui_events_synced_at synced_at SQL 
CREATE INDEX idx_ui_events_synced_at
ON ui_events(synced_at)
read-only
idx_ui_events_timestamp timestamp SQL 
CREATE INDEX idx_ui_events_timestamp
ON ui_events(timestamp)
read-only
idx_ui_events_unsynced synced_at SQL 
CREATE INDEX idx_ui_events_unsynced
ON ui_events(synced_at) WHERE synced_at IS NULL
read-only

Triggers

Name SQL Drop?
ui_events_ad SQL 
CREATE TRIGGER ui_events_ad AFTER DELETE ON ui_events BEGIN
    INSERT INTO ui_events_fts(ui_events_fts, rowid, text_content, app_name, window_title, element_name)
    VALUES('delete', OLD.id, OLD.text_content, OLD.app_name, OLD.window_title, OLD.element_name);
END
read-only
ui_events_ai SQL 
CREATE TRIGGER ui_events_ai AFTER INSERT ON ui_events BEGIN
    INSERT OR IGNORE INTO ui_events_fts(rowid, text_content, app_name, window_title, element_name)
    VALUES (NEW.id, NEW.text_content, NEW.app_name, NEW.window_title, NEW.element_name);
END
read-only
ui_events_au SQL 
CREATE TRIGGER ui_events_au AFTER UPDATE ON ui_events BEGIN
    INSERT INTO ui_events_fts(ui_events_fts, rowid, text_content, app_name, window_title, element_name)
    VALUES('delete', OLD.id, OLD.text_content, OLD.app_name, OLD.window_title, OLD.element_name);
    INSERT INTO ui_events_fts(rowid, text_content, app_name, window_title, element_name)
    VALUES (NEW.id, NEW.text_content, NEW.app_name, NEW.window_title, NEW.element_name);
END
read-only