home / japari_dc_bot

user_interactive_roles

4 rows where interactive_role_id = 9

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: assigned_at (date)

Link user_discord_id interactive_role_id assigned_at
191573055531646976,9 191573055531646976 9 9 2025-06-23 10:54:50
293284178785599488,9 293284178785599488 9 9 2025-06-20 18:19:36
324804215547625475,9 324804215547625475 9 9 2025-06-21 17:31:42
407540601157058570,9 407540601157058570 9 9 2025-07-11 12:34:09

Advanced export

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

CSV options:

CREATE TABLE user_interactive_roles (
            user_discord_id BIGINT NOT NULL,
            interactive_role_id INTEGER NOT NULL,
            assigned_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
            PRIMARY KEY (user_discord_id, interactive_role_id),
            FOREIGN KEY (interactive_role_id) REFERENCES interactive_roles(id) ON DELETE CASCADE
        );
Powered by Datasette · Queries took 12.91ms