badge_criteria

0 rows


Description

Defines criteria for issuing badges

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
badge_criteria_met.critid badgcritmet_cri2_fkR
badge_criteria_param.critid badgcritpara_cri2_fkR
badgeid BIGINT 19 0
badge.id badgcrit_bad2_fkR
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

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

Relationships