badge_manual_award

0 rows


Description

Track manual award criteria for badges

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
badgeid BIGINT 19 null
badge.id badgmanuawar_bad2_fkR
recipientid BIGINT 19 null
user.id badgmanuawar_rec2_fkR
issuerid BIGINT 19 null
user.id badgmanuawar_iss3_fkR
issuerrole BIGINT 19 null
role.id badgmanuawar_iss4_fkR
datemet BIGINT 19 null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
badgmanuawar_bad_ix Performance Asc badgeid
badgmanuawar_iss2_ix Performance Asc issuerrole
badgmanuawar_iss_ix Performance Asc issuerid
badgmanuawar_rec_ix Performance Asc recipientid

Relationships