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 10 null
badge_criteria_met.issuedid badgcritmet_iss2_fk R
badgeid bigint 10 0
badge.id badgissu_bad2_fk R
userid bigint 10 0
user.id badgissu_use2_fk R
uniquehash longtext 2147483647 null
dateissued bigint 10 0
dateexpire bigint 10 null
visible BIT 1 0
issuernotified bigint 10 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