badge_issued

0 rows

Description

Defines issued badges

Columns

Related columns Constraint Comments

Search:

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

id

BIGINT

19

√

null

badge_criteria_met.issuedid

badgcritmet_iss2_fkR

badgeid

BIGINT

19

0

badgissu_bad2_fkR

userid

BIGINT

19

0

badgissu_use2_fkR

uniquehash

LONGTEXT

2147483647

null

dateissued

BIGINT

19

0

dateexpire

BIGINT

19

√

null

visible

BIT

1

0

issuernotified

BIGINT

19

√

null

Showing 1 to 8 of 8 entries

Indexes

Search:

Constraint Name	Type	Sort	Column(s)
PRIMARY	Primary key	Asc	id
badgissu_bad4_ix	Performance	Asc	badgeid
badgissu_baduse2_uix	Must be unique	Asc/Asc	badgeid + userid
badgissu_use4_ix	Performance	Asc	userid

Showing 1 to 4 of 4 entries

Relationships

Close relationships within degrees of separation

One
Two degrees