account_user_snapshots

52 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Next page

CREATE TABLE account_user_snapshots (
    snapshot_at      TEXT NOT NULL,
    store_hash       TEXT NOT NULL,
    user_id          TEXT NOT NULL,
    email            TEXT NOT NULL,
    first_name       TEXT,
    last_name        TEXT,
    status           TEXT,
    last_login_at    TEXT,
    permissions_json TEXT NOT NULL,
    permissions_hash TEXT NOT NULL,
    PRIMARY KEY (snapshot_at, store_hash, user_id)
);
CREATE INDEX idx_user_snapshots_lookup
    ON account_user_snapshots(store_hash, user_id, snapshot_at DESC);