user_interactive_roles

20 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: user_discord_id, interactive_role_id, assigned_at (date)

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
        );