0 rows


Column Type Size Nulls Auto Default Children Parents Comments
client_id VARCHAR 191 null
oauth_access_tokens.client_id Implied ConstraintR

API client ID

secret VARCHAR 191 null

API client secret used for API authentication

description VARCHAR 255 null

API client description

patron_id INT 10 null
borrowers.borrowernumber api_keys_fk_patron_idC

Foreign key to the borrowers table

active BIT 0 1

0 means this API key is revoked


Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc client_id
patron_id Performance Asc patron_id
secret Must be unique Asc secret