user_filters

1 row

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ user_id filter_id filter_json full_user_id
1 1 james 0 <Binary: 93 bytes> @james:matrix.jamesst.one

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "user_filters" ( user_id TEXT NOT NULL, filter_id BIGINT NOT NULL, filter_json BYTEA NOT NULL , full_user_id TEXT);
CREATE UNIQUE INDEX user_filters_unique ON "user_filters" (user_id, filter_id);
CREATE UNIQUE INDEX user_filters_full_user_id_unique ON
        user_filters (full_user_id, filter_id)
        ;
CREATE UNIQUE INDEX full_users_unique_idx ON user_filters (full_user_id, filter_id) ;