profile_updates_per_user

✎ View and edit SQL

This data as json

0 records

CREATE TABLE profile_updates_per_user (
  -- Stream ID reference to `profile_updates`
  stream_id BIGINT NOT NULL REFERENCES profile_updates (stream_id),

  -- The full user ID of the local user that should receive the profile update.
  user_id TEXT NOT NULL,

  -- Unix timestamp (milliseconds). Used to determine when to prune rows (to prevent the table
  -- from growing indefinitely).
  inserted_ts BIGINT NOT NULL,

  PRIMARY KEY (user_id, stream_id)
);