user_interactive_roles
3 rows where interactive_role_id = 3
This data as json, CSV (advanced)
Suggested facets: assigned_at (date)
| Link | user_discord_id | interactive_role_id | assigned_at |
|---|---|---|---|
| 458269651353337856,3 | 458269651353337856 | 3 3 | 2025-06-20 10:55:32 |
| 533656322563112992,3 | 533656322563112992 | 3 3 | 2025-06-22 13:08:00 |
| 646330608728932383,3 | 646330608728932383 | 3 3 | 2025-06-20 11:32:06 |
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
);