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 10 null
issuedid bigint 10 null
badge_issued.id badgcritmet_iss2_fk R
critid bigint 10 null
badge_criteria.id badgcritmet_cri2_fk R
userid bigint 10 null
user.id badgcritmet_use2_fk R
datemet bigint 10 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