jwt_grant_history


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 jwt_grant_history.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 JWT authorization grant ids to prevent replay attacks

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 √ null
jti VARCHAR 100 null

Unique JWT id
client_id VARCHAR 80 null

FK oauth2_clients.client_id
jti_exp TIMESTAMP 19 √ NULL

jwt exp claim when the jwt expires
creation_date DATETIME 19 current_timestamp()

datetime the grant authorization was requested

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
jti Performance Asc jti

Relationships

Close relationships within degrees of separation