badge_issued

0 rows


Description

Defines issued badges

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
badge_criteria_met.issuedid badgcritmet_iss2_fkR
badgeid BIGINT 19 0
badge.id badgissu_bad2_fkR
userid BIGINT 19 0
user.id badgissu_use2_fkR
uniquehash LONGTEXT 2147483647 null
dateissued BIGINT 19 0
dateexpire BIGINT 19 null
visible BIT 1 0
issuernotified BIGINT 19 null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
badgissu_bad2_ix Performance Asc badgeid
badgissu_baduse2_uix Must be unique Asc/Asc badgeid + userid
badgissu_use2_ix Performance Asc userid

Relationships