Badge External Backpack Table Schema (badge_external_backpack)


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
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.

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

badge_external_backpack table relationships