app_badge_manual_award

0 rows


Description

Track manual award criteria for badges

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('app_badge_manual_award_id_seq'::regclass)
badgeid int8 19 null
app_badge.id Defined in XMLR
recipientid int8 19 null
app_user.id Defined in XMLR
issuerid int8 19 null
app_user.id Defined in XMLR
issuerrole int8 19 null
app_role.id Defined in XMLR
datemet int8 19 null

Indexes

Constraint Name Type Sort Column(s)
app_badgmanuawar_id_pk Primary key Asc id
app_badgmanuawar_bad_ix Performance Asc badgeid
app_badgmanuawar_iss2_ix Performance Asc issuerrole
app_badgmanuawar_iss_ix Performance Asc issuerid
app_badgmanuawar_rec_ix Performance Asc recipientid

Relationships

Close relationships within degrees of separation