Badge Issued Table Schema (badge_issued)


Description

Defines issued badges

badge_issued table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
badge_criteria_met.issuedid badgcritmet_iss2_fk R
badgeid BIGINT 19 0
badge.id badgissu_bad2_fk R
userid BIGINT 19 0
user.id badgissu_use2_fk R
uniquehash LONGTEXT 2147483647 null
dateissued BIGINT 19 0
dateexpire BIGINT 19 √ null
visible BIT 1 0
issuernotified BIGINT 19 √ null

Table contained -1 rows

badge_issued table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
badgissu_bad_ix Performance Asc badgeid
badgissu_baduse_uix Must be unique Asc/Asc badgeid + userid
badgissu_use_ix Performance Asc userid

badge_issued table relationships

Close relationships within degrees of separation