Badge Table Schema (badge)


Description

Defines badge

badge table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
badge_criteria.badgeid badgcrit_bad2_fk R
badge_issued.badgeid badgissu_bad2_fk R
badge_manual_award.badgeid badgmanuawar_bad2_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

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

Close relationships within degrees of separation