access_tokens

3 rows

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ user_id device_id token valid_until_ms puppets_user_id last_validated refresh_token_id used
6 @james:matrix.jamesst.one BLSFYMBGKR syt_amFtZXM_DpodwXPCqAgRHOBwiqax_22Rq0E     1784901113775   1
9 @james:matrix.jamesst.one SZXXSYDHEN syt_amFtZXM_MQecbXiKfUBSadDJIQPO_0F1JbA     1787917557548   1
11 @james:matrix.jamesst.one HMCRCRAOHC syt_amFtZXM_IrwRNhheEscYdrLEEzmB_2Taehe     1787918592879   1

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE "access_tokens" (
    id BIGINT PRIMARY KEY, 
    user_id TEXT NOT NULL, 
    device_id TEXT, 
    token TEXT NOT NULL,
    valid_until_ms BIGINT,
    puppets_user_id TEXT,
    last_validated BIGINT, refresh_token_id BIGINT REFERENCES refresh_tokens (id) ON DELETE CASCADE, used BOOLEAN,
    UNIQUE(token) 
);
CREATE INDEX access_tokens_device_id ON access_tokens (user_id, device_id);
CREATE INDEX access_tokens_refresh_token_id_idx ON access_tokens (refresh_token_id) ;