api_keys

Columns

Related columns Constraint Comments

Search:

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

Showing 1 to 5 of 5 entries

Indexes

Search:

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

Showing 1 to 3 of 3 entries

Columns

Indexes

Relationships

Close relationships within degrees of separation