home / chat

users_in_public_rooms

✎ View and edit SQL

This data as json

0 records

CREATE TABLE users_in_public_rooms ( user_id TEXT NOT NULL, room_id TEXT NOT NULL );
CREATE UNIQUE INDEX users_in_public_rooms_u_idx ON users_in_public_rooms(user_id, room_id);
CREATE INDEX users_in_public_rooms_r_idx ON users_in_public_rooms(room_id);
Powered by Datasette · Queries took 15.249ms