api_refresh_token

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