user_signature_stream

2 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: user_ids (array)

Link rowid ▼ stream_id from_user_id user_ids instance_name
1 1 7 @james:matrix.jamesst.one ["@james:matrix.jamesst.one"] master
2 2 26 @james:matrix.jamesst.one ["@james:matrix.jamesst.one"] master

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE user_signature_stream (
    -- uses the same stream ID as device list stream
    stream_id BIGINT NOT NULL,
    -- user who did the signing
    from_user_id TEXT NOT NULL,
    -- list of users who were signed, as a JSON array
    user_ids TEXT NOT NULL
, instance_name TEXT);
CREATE UNIQUE INDEX user_signature_stream_idx ON user_signature_stream(stream_id);