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

Close relationships within degrees of separation