hoopla_settings

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 √ null
apiUrl VARCHAR 255 √ NULL
libraryId INT 10 √ 0
library.libraryId Implied Constraint R
apiUsername VARCHAR 50 √ NULL
apiPassword VARCHAR 50 √ NULL
runFullUpdateInstant TINYINT 3 √ 0
lastUpdateOfChangedRecordsInstant INT 10 √ 0
lastUpdateOfAllRecordsInstant INT 10 √ 0
regroupAllRecords TINYINT 3 √ 0
hooplaInstantEnabled TINYINT 3 √ 1
hooplaFlexEnabled TINYINT 3 √ 0
runFullUpdateFlex TINYINT 3 √ 0
lastUpdateOfChangedRecordsFlex INT 10 √ 0
lastUpdateOfAllRecordsFlex INT 10 √ 0
accessToken VARCHAR 255 √ NULL
tokenExpirationTime INT 10 √ NULL

Indexes

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

Relationships

Close relationships within degrees of separation