Badge Criteria Met Table Schema (badge_criteria_met)


Description

Defines criteria that were met for an issued badge

badge_criteria_met table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
issuedid BIGINT 19 √ null
badge_issued.id badgcritmet_iss2_fk R
critid BIGINT 19 null
badge_criteria.id badgcritmet_cri2_fk R
userid BIGINT 19 null
user.id badgcritmet_use2_fk R
datemet BIGINT 19 null

Table contained -1 rows

badge_criteria_met table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
badgcritmet_cri_ix Performance Asc critid
badgcritmet_iss_ix Performance Asc issuedid
badgcritmet_use_ix Performance Asc userid

badge_criteria_met table relationships

Close relationships within degrees of separation