Badge External Identifier Table Schema (badge_external_identifier)


Setting for external badges mappings

badge_external_identifier table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
sitebackpackid BIGINT 19 null badgexteiden_sit2_fk R

ID of a site backpack

internalid VARCHAR 128
externalid VARCHAR 128
type VARCHAR 16

Table contained -1 rows

badge_external_identifier table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
badgexteiden_sit_ix Performance Asc sitebackpackid
badgexteiden_sitintexttyp_uix Must be unique Asc/Asc/Asc/Asc sitebackpackid + internalid + externalid + type

badge_external_identifier table relationships