Admin_BadgesByBadges: Discourse Admin Badges by Badges
read only REST
- Catalog:
Discourse - Schema:
Badges - Label: Admin Badges by Badges
get a list of badges
Can only retrieve data.
Summary
get a list of badges
API Source
- Endpoint:
/admin/badges.json - Operation:
get /admin/badges.json
Performance Characteristics
| Characteristic | Value |
|---|---|
| Average access latency (ms) | 243 |
| Write rows per minute | 219 |
The result can be cached on the client.
Table Columns
The columns of the table Admin_BadgesByBadges are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.
| Name | Data Type | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
allow_ |
char |
Allow Title | writable, allow_ |
||
auto_ |
char |
Auto Revoke | writable, auto_ |
||
badge_ |
decimal |
Badge Grouping ID | writable, badge_ |
||
badge_ |
decimal |
Badge Type ID | writable, badge_ |
||
description |
varchar2 |
Description | writable, description |
||
enabled |
char |
Enabled | writable, enabled |
||
grant_ |
decimal |
Grant Count | writable, grant_ |
||
i18n_ |
varchar2 |
I18N Name | filters on the platform, writable, i18n_ |
||
icon |
varchar2 |
Icon | writable, icon |
||
id |
decimal |
ID | writable, id |
||
image |
varchar2 |
Image | writable, image |
||
listable |
char |
Listable | writable, listable |
||
long_ |
varchar2 |
Long Description | writable, long_ |
||
manually_ |
char |
Manually Grantable | filters on the platform, writable, manually_ |
||
multiple_ |
char |
Multiple Grant | writable, multiple_ |
||
name |
varchar2 |
Name | writable, name |
||
query |
varchar2 |
Query | writable, query |
||
show_ |
char |
Show Posts | writable, show_ |
||
slug |
varchar2 |
Slug | writable, slug |
||
system |
char |
System | writable, system |
||
target_ |
char |
Target Posts | writable, target_ |
||
trigger |
decimal |
Trigger | writable, trigger |
||
triggers_ |
decimal |
Triggers None | filters on the platform, writable, ::ancestor. |
||
triggers_ |
decimal |
Triggers Post Action | filters on the platform, writable, ::ancestor. |
||
triggers_ |
decimal |
Triggers Post Processed | filters on the platform, writable, ::ancestor. |
||
triggers_ |
decimal |
Triggers Post Revision | filters on the platform, writable, ::ancestor. |
||
triggers_ |
decimal |
Triggers Trust Level Change | filters on the platform, writable, ::ancestor. |
||
triggers_ |
decimal |
Triggers User Change | filters on the platform, writable, ::ancestor. |
Keys
| Key | Column | Refers to | Kind | Description |
|---|---|---|---|---|
Admin_ |
badge_ |
Admin_Badge_groupingsByBadges.id |
Key | |
Admin_ |
badge_ |
Admin_Badge_typesByBadges.id |
Key |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver:
Changes of This Table, 26.0 to 27.0
~badge_grouping_id(database_data_type:decimal→int64)~badge_grouping_id(dotnet_data_type:decimal→int64)~badge_type_id(database_data_type:decimal→int64)~badge_type_id(dotnet_data_type:decimal→int64)~grant_count(database_data_type:decimal→int64)~grant_count(dotnet_data_type:decimal→int64)~id(database_data_type:decimal→int64)~id(dotnet_data_type:decimal→int64)-image~trigger(database_data_type:decimal→int64)~trigger(dotnet_data_type:decimal→int64)-triggers_none-triggers_post_action-triggers_post_processed-triggers_post_revision
10 more changes
-triggers_trust_level_change-triggers_user_change+admin_badges_triggers_none(int64)+admin_badges_triggers_post_action(int64)+admin_badges_triggers_post_revision(int64)+admin_badges_triggers_trust_level_change(int64)+admin_badges_triggers_user_change(int64)+image_upload_id(int64)+image_url(varchar2)+show_in_post_header(char)