Badge External Backpack Table Schema (badge_external_backpack)


Description

Defines settings for site level backpacks that a user can connect to.

badge_external_backpack table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
badge_backpack.externalbackpackid badgback_ext2_fk R
badge_backpack_oauth2.externalbackpackid badgbackoaut_ext2_fk R
backpackapiurl VARCHAR 255
backpackweburl VARCHAR 255
apiversion VARCHAR 12 1.0
sortorder BIGINT 19 0
password VARCHAR 255 √ null

Password to login into external backpack and issue badges.
oauth2_issuerid BIGINT 19 √ null
oauth2_issuer.id badgexteback_oau2_fk R

OAuth 2 Issuer

Table contained -1 rows

badge_external_backpack table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
badgexteback_bac2_uix Must be unique Asc backpackweburl
badgexteback_bac_uix Must be unique Asc backpackapiurl
badgexteback_oau_ix Performance Asc oauth2_issuerid

badge_external_backpack table relationships

Close relationships within degrees of separation