Badge Table Schema (badge)


Description

Defines badge

badge table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
badge_alignment.badgeid badgalig_bad2_fk R
badge_criteria.badgeid badgcrit_bad2_fk R
badge_endorsement.badgeid badgendo_bad2_fk R
badge_issued.badgeid badgissu_bad2_fk R
badge_manual_award.badgeid badgmanuawar_bad2_fk R
badge_related.badgeid badgrela_bad2_fk R
badge_related.relatedbadgeid badgrela_rel2_fk R
name VARCHAR 255
description LONGTEXT 2147483647 null
timecreated BIGINT 19 0
timemodified BIGINT 19 0
usercreated BIGINT 19 null
user.id badg_use4_fk R
usermodified BIGINT 19 null
user.id badg_use3_fk R
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_fk R
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

Table contained -1 rows

badge table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
badg_cou_ix Performance Asc courseid
badg_typ_ix Performance Asc type
badg_use2_ix Performance Asc usercreated
badg_use_ix Performance Asc usermodified

badge table relationships