badge

0 rows


Description

Defines badge

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
badge_alignment.badgeid badgalig_bad2_fkR
badge_criteria.badgeid badgcrit_bad2_fkR
badge_endorsement.badgeid badgendo_bad2_fkR
badge_issued.badgeid badgissu_bad2_fkR
badge_manual_award.badgeid badgmanuawar_bad2_fkR
badge_related.badgeid badgrela_bad2_fkR
badge_related.relatedbadgeid badgrela_rel2_fkR
name VARCHAR 255
description LONGTEXT 2147483647 null
timecreated BIGINT 19 0
timemodified BIGINT 19 0
usercreated BIGINT 19 null
user.id badg_use4_fkR
usermodified BIGINT 19 null
user.id badg_use3_fkR
issuername VARCHAR 255
issuerurl VARCHAR 255
issuercontact VARCHAR 255 null
expiredate BIGINT 19 null
expireperiod BIGINT 19 null
type BIT 1 1

1 = site, 2 = course

courseid BIGINT 19 null
course.id badg_cou2_fkR
message LONGTEXT 2147483647 null
messagesubject LONGTEXT 2147483647 null
attachment BIT 1 1

Attach baked badge for download

notification BIT 1 1

Message when badge is awarded

status BIT 1 0

Badge status: 0 = inactive, 1 = active, 2 = active+locked, 3 = inactive+locked, 4 = archived

nextcron BIGINT 19 null
version VARCHAR 255 null
language VARCHAR 255 null
imageauthorname VARCHAR 255 null
imageauthoremail VARCHAR 255 null
imageauthorurl VARCHAR 255 null
imagecaption LONGTEXT 2147483647 null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
badg_cou2_ix Performance Asc courseid
badg_typ2_ix Performance Asc type
badg_use3_ix Performance Asc usermodified
badg_use4_ix Performance Asc usercreated

Relationships