Badge Criteria Table Schema (badge_criteria)


Defines criteria for issuing badges

badge_criteria table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
badge_criteria_met.critid badgcritmet_cri2_fk R
badge_criteria_param.critid badgcritpara_cri2_fk R
badgeid BIGINT 19 0 badgcrit_bad2_fk R
criteriatype BIGINT 19 null

The criteria type we are aggregating

method BIT 1 1

1 = all, 2 = any

description LONGTEXT 2147483647 null
descriptionformat TINYINT 3 0

Table contained -1 rows

badge_criteria table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
badgcrit_bad_ix Performance Asc badgeid
badgcrit_badcri_uix Must be unique Asc/Asc badgeid + criteriatype
badgcrit_cri_ix Performance Asc criteriatype

badge_criteria table relationships