api_token

Columns

Column	Type	Size	Nulls	Auto	Default	Children	Parents	Comments
id	BIGINT	19		√	null

|

| | | user_id | VARCHAR | 40 | √ | | NULL |

|

| | | token | VARCHAR | 128 | √ | | NULL |

|

| | | expiry | DATETIME | 19 | √ | | NULL |

|

| | | client_id | VARCHAR | 80 | √ | | NULL |

|

| | | scope | TEXT | 65535 | √ | | NULL |

|

|

json encoded

| | revoked | BOOLEAN | 3 | | | 0 |

|

|

1=revoked,0=not revoked

| | context | TEXT | 65535 | √ | | NULL |

|

|

context values that change/govern how access token are used

|

Indexes

Constraint Name	Type	Sort	Column(s)
PRIMARY	Primary key	Asc	id
token	Must be unique	Asc	token

Relationships

Close relationships within degrees of separation