Badge Backpack Oauth2 Table Schema (badge_backpack_oauth2)


Description

Default comment for the table, please edit me

badge_backpack_oauth2 table columns

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

Table contained -1 rows

badge_backpack_oauth2 table indexes

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

badge_backpack_oauth2 table relationships

Close relationships within degrees of separation