Moodle LMS 3.9
Database
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
Badge Backpack Oauth2 Table Schema (badge_backpack_oauth2)
Description
Default comment for the table, please edit me
badge_backpack_oauth2 table columns
Related columns
Constraint
Comments
Search:
Column
Type
Size
Nulls
Auto
Default
Children
Parents
Comments
id
BIGINT
19
√
null
usermodified
BIGINT
19
0
user
.id
badgbackoaut_use3_fk
R
timecreated
BIGINT
19
0
timemodified
BIGINT
19
0
userid
BIGINT
19
null
user
.id
badgbackoaut_use4_fk
R
issuerid
BIGINT
19
null
oauth2_issuer
.id
badgbackoaut_iss2_fk
R
externalbackpackid
BIGINT
19
null
badge_external_backpack
.id
badgbackoaut_ext2_fk
R
token
LONGTEXT
2147483647
null
refreshtoken
LONGTEXT
2147483647
null
expires
BIGINT
19
√
null
scope
LONGTEXT
2147483647
√
null
Showing 1 to 11 of 11 entries
Table contained
-1
rows
badge_backpack_oauth2 table indexes
Search:
Constraint Name
Type
Sort
Column(s)
PRIMARY
Primary key
Asc
id
badgbackoaut_ext_ix
Performance
Asc
externalbackpackid
badgbackoaut_iss_ix
Performance
Asc
issuerid
badgbackoaut_use2_ix
Performance
Asc
userid
badgbackoaut_use_ix
Performance
Asc
usermodified
Showing 1 to 5 of 5 entries
badge_backpack_oauth2 table relationships
Close relationships within degrees of separation
One
Two degrees
One implied
Two implied