app_badge_criteria

0 rows


Description

Defines criteria for issuing badges

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 nextval('app_badge_criteria_id_seq'::regclass)
app_badge_criteria_met.critid Defined in XMLR
app_badge_criteria_param.critid Defined in XMLR
badgeid int8 19 0
app_badge.id Defined in XMLR
criteriatype int8 19 null
method int2 5 1
description text 2147483647 null
descriptionformat int2 5 0

Indexes

Constraint Name Type Sort Column(s)
app_badgcrit_id_pk Primary key Asc id
app_badgcrit_bad_ix Performance Asc badgeid
app_badgcrit_badcri_uix Must be unique Asc/Asc badgeid + criteriatype
app_badgcrit_cri_ix Performance Asc criteriatype

Relationships