app_badge_issued

0 rows


Description

Defines issued badges

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 nextval('app_badge_issued_id_seq'::regclass)
app_badge_criteria_met.issuedid Defined in XMLR
badgeid int8 19 0
app_badge.id Defined in XMLR
userid int8 19 0
app_user.id Defined in XMLR
uniquehash text 2147483647 null
dateissued int8 19 0
dateexpire int8 19 null
visible int2 5 0
issuernotified int8 19 null

Indexes

Constraint Name Type Sort Column(s)
app_badgissu_id_pk Primary key Asc id
app_badgissu_bad_ix Performance Asc badgeid
app_badgissu_baduse_uix Must be unique Asc/Asc badgeid + userid
app_badgissu_use_ix Performance Asc userid

Relationships