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
courseid BIGINT 19 null
course.id badg_cou2_fkR
message LONGTEXT 2147483647 null
messagesubject LONGTEXT 2147483647 null
attachment BIT 1 1
notification BIT 1 1
status BIT 1 0
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_cou4_ix Performance Asc courseid
badg_typ2_ix Performance Asc type
badg_use6_ix Performance Asc usermodified
badg_use8_ix Performance Asc usercreated

Relationships