account_apps_snapshots

18 rows

✎ View and edit SQL

This data as json, CSV (advanced)

CREATE TABLE account_apps_snapshots (
    snapshot_at TEXT NOT NULL,
    store_hash  TEXT NOT NULL,
    app_id      TEXT NOT NULL,
    app_name    TEXT,
    PRIMARY KEY (snapshot_at, store_hash, app_id)
);
CREATE INDEX idx_apps_snapshots_lookup
    ON account_apps_snapshots(store_hash, snapshot_at DESC);