current_state_events

1 row where event_stream_ordering = 16834

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ event_id room_id type state_key membership event_stream_ordering
5324 5324 $D9OjZ8UqPklGY8qHlo-isRVsJ3NKIuq6AzzKOhtV5ck !DOKvXoFHlHLFlRknXs:matrix.jamesst.one m.room.member @signal_pni__5a42e6b6-b879-4f38-997a-460e662faef5:matrix.jamesst.one invite 16834 16834

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE current_state_events( event_id TEXT NOT NULL, room_id TEXT NOT NULL, type TEXT NOT NULL, state_key TEXT NOT NULL, membership TEXT, event_stream_ordering BIGINT REFERENCES events(stream_ordering), UNIQUE (event_id), UNIQUE (room_id, type, state_key) );
CREATE INDEX current_state_events_member_index ON current_state_events (state_key) WHERE type='m.room.member';
CREATE INDEX current_state_events_stream_ordering_idx ON current_state_events (event_stream_ordering) ;
CREATE INDEX current_state_events_members_room_index ON current_state_events (room_id, membership) WHERE type='m.room.member';