user_interactive_roles
4 rows where interactive_role_id = 9
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
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
);