# 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 | 1333 |  |  |  |  |  |
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 | 1333 |  |  |  |  |  |
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_fkR
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 |  |  |
imagecaption | LONGTEXT | 2147483647 | √ |  | null |  |  |

### 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

### Relationships