Badge Table Schema (badge)


Description

Defines badge

badge table columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigint 10 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 10 0
timemodified bigint 10 0
usercreated bigint 10 null
user.id badg_use4_fk R
usermodified bigint 10 null
user.id badg_use3_fk R
issuername varchar 255
issuerurl varchar 255
issuercontact varchar 255 null
expiredate bigint 10 null
expireperiod bigint 10 null
type BIT 1 1

1 = site, 2 = course

courseid bigint 10 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 10 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