api_refresh_token


If there is patient data for this table the file for this export will be found in the extracted zip folder location under the filename of api_refresh_token.csv

If there are non-patient data column elements that are not part of the designated record set they will be marked in the Comment's column for that data element

Description

Holds information about api refresh tokens.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
user_id VARCHAR 40 √ NULL
client_id VARCHAR 80 √ NULL
token VARCHAR 128 null
expiry DATETIME 19 √ NULL
revoked BOOLEAN 3 0

1=revoked,0=not revoked

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
api_refresh_token_usr_client_idx Performance Asc/Asc client_id + user_id
token Must be unique Asc token

Relationships

Close relationships within degrees of separation