api_keys

0 rows


Columns

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

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_id C

Foreign key to the borrowers table
active BIT 0 1

0 means this API key is revoked

Indexes

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

Relationships

Close relationships within degrees of separation