Badge Criteria Table Schema (badge_criteria)


Description

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
badge.id 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

Close relationships within degrees of separation