badge_external_identifier

0 rows


Description

Setting for external badges mappings

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
sitebackpackid BIGINT 19 null
badge_backpack.id badgexteiden_sit2_fkR

ID of a site backpack

internalid VARCHAR 128
externalid VARCHAR 128
type VARCHAR 16

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

Relationships