Table testsql_comments.api_keys Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
client_id varchar 191
oauth_access_tokens.client_id Implied Constraint R
secret varchar 191
description varchar 255
patron_id int 10
borrowers.borrowernumber api_keys_fk_patron_id C
active bit 0 1

Table contained 0 rows at Mon Jul 16 08:37 NZST 2018

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

Close relationships  within of separation: