Badge Backpack Table Schema (badge_backpack)


Description

Defines settings for connecting external backpack

badge_backpack table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
badge_external.backpackid badgexte_bac2_fk R
badge_external_identifier.sitebackpackid badgexteiden_sit2_fk R
userid BIGINT 19 0
user.id badgback_use2_fk R
email VARCHAR 100
backpackuid BIGINT 19 null
autosync BIT 1 0
password VARCHAR 50 √ null
externalbackpackid BIGINT 19 √ null
badge_external_backpack.id badgback_ext2_fk R

Table contained -1 rows

badge_backpack table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
badgback_ext_ix Performance Asc externalbackpackid
badgback_use_ix Performance Asc userid

badge_backpack table relationships

Close relationships within degrees of separation