profile_updates

✎ View and edit SQL

This data as json

0 records

CREATE TABLE profile_updates (
  stream_id BIGINT NOT NULL PRIMARY KEY,
  instance_name TEXT NOT NULL,

  -- The full user ID
  user_id TEXT NOT NULL,

  -- Profile action that has happened, see ProfileUpdateAction enum.
  action TEXT NOT NULL,

  -- JSON array of the profile field names that have been
  -- added, updated or removed in this update.
  -- See https://spec.matrix.org/unstable/client-server-api/#profiles
  -- This is only present if `action` is `update`.
  --
  -- We support multiple field updates at once because it is easy to foresee features
  -- involving multiple fields (where getting the illusion of a torn write might be harmful),
  -- as well as synchronisation over federation being likely to lead to multiple field changes
  -- at once.
  affected_fields JSONB NULL,

  -- Unix timestamp (milliseconds) for debugging purposes
  inserted_ts BIGINT NOT NULL
);
CREATE INDEX profile_updates_by_user ON profile_updates (user_id, stream_id);