app_user_state

1 row

✎ View and edit SQL

This data as json, CSV (advanced)

Link actor_id app_id last_accessed_at pinned_at access_count
root,01kwjk7289pmy4h2xrkpct13y5 root 01kwjk7289pmy4h2xrkpct13y5 2026-07-03T00:13:52.378042+00:00   3

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE app_user_state (
    actor_id TEXT NOT NULL,
    app_id TEXT NOT NULL REFERENCES apps(id),
    last_accessed_at TEXT,
    pinned_at TEXT,
    access_count INTEGER NOT NULL DEFAULT 0,
    PRIMARY KEY (actor_id, app_id)
);
CREATE INDEX idx_app_user_state_actor_pinned
    ON app_user_state(actor_id, pinned_at DESC, last_accessed_at DESC, app_id);
CREATE INDEX idx_app_user_state_actor_recent
    ON app_user_state(actor_id, last_accessed_at DESC, app_id);