badge_backpack

0 rows


Description

Defines settings for connecting external backpack

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
badge_external.backpackid badgexte_bac2_fkR
badge_external_identifier.sitebackpackid badgexteiden_sit2_fkR
userid BIGINT 19 0
user.id badgback_use2_fkR
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_fkR

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
badgback_ext_ix Performance Asc externalbackpackid
badgback_use_ix Performance Asc userid
badgback_useext_uix Must be unique Asc/Asc userid + externalbackpackid

Relationships

Close relationships within degrees of separation