Please enable JavaScript to view this site.

Discourse Data Model

Navigation: Schema: Badges > Tables

Admin_BadgesByBadges

Contents Previous Home Next More

get a list of badges

Catalog: Discourse

Schema: Badges

This is a read-only table. The Discourse API may not support changing the data or the Invantive SQL driver for Discourse does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Discourse API.

Select Discourse API URL: /admin/badges.json

Insert Discourse API URL: /admin/badges.json

Update Discourse API URL: /admin/badges.json

Delete Discourse API URL: /admin/badges.json

Field Selection Method: NotRequired

Base Path: badges[*]

Select Discourse API Operation: get /admin/badges.json

Table Columns

The columns of the table Admin_BadgesByBadges are shown below. Each column has an SQL data type.

Name

Data Type

Label

Required

Documentation

allow_title

boolean

Allow Title

 

auto_revoke

boolean

Auto Revoke

 

badge_grouping_id

decimal

Badge Grouping ID

 

badge_type_id

decimal

Badge Type ID

 

description

string

Description

 

enabled

boolean

Enabled

 

grant_count

decimal

Grant Count

 

icon

string

Icon

 

id

decimal

ID

 

image

string

Image

 

listable

boolean

Listable

 

long_description

string

Long Description

 

multiple_grant

boolean

Multiple Grant

 

name

string

Name

 

query

string

Query

 

show_posts

boolean

Show Posts

 

slug

string

Slug

 

system

boolean

System

 

target_posts

boolean

Target Posts

 

trigger

decimal

Trigger

 

triggers_none

decimal

Triggers None

 

triggers_post_action

decimal

Triggers Post Action

 

triggers_post_processed

decimal

Triggers Post Processed

 

triggers_post_revision

decimal

Triggers Post Revision

 

triggers_trust_level_change

decimal

Triggers Trust Level Change

 

triggers_user_change

decimal

Triggers User Change

 

 

12-12-2020 18:47 Version 20.1.301-BETA+3023