room_memberships

1 row where event_stream_ordering = 16836

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ event_id user_id sender room_id membership forgotten display_name avatar_url event_stream_ordering participant
2420 2420 $XPCk6klnkAUIUkVaYb2Yudg29t_j8cTMATrZBEqd3Zk @signal_ee9352df-a332-42ea-aa2f-9d0c65579263:matrix.jamesst.one @signal_ee9352df-a332-42ea-aa2f-9d0c65579263:matrix.jamesst.one !DOKvXoFHlHLFlRknXs:matrix.jamesst.one join 0 Andrea Mongelli mxc://matrix.jamesst.one/kXkkFdADzBpACaCubIEDnOaY 16836 16836 1

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE room_memberships( event_id TEXT NOT NULL, user_id TEXT NOT NULL, sender TEXT NOT NULL, room_id TEXT NOT NULL, membership TEXT NOT NULL, forgotten INTEGER DEFAULT 0, display_name TEXT, avatar_url TEXT, event_stream_ordering BIGINT REFERENCES events(stream_ordering), participant BOOLEAN DEFAULT FALSE, UNIQUE (event_id) );
CREATE INDEX room_memberships_room_id ON room_memberships (room_id);
CREATE INDEX room_memberships_user_id ON room_memberships (user_id);
CREATE INDEX room_memberships_user_room_forgotten ON room_memberships (user_id, room_id) WHERE forgotten = 1;
CREATE INDEX room_membership_user_room_idx ON room_memberships (user_id, room_id) ;
CREATE INDEX room_memberships_stream_ordering_idx ON room_memberships (event_stream_ordering) ;