user_checkout

2 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 √ null
type VARCHAR 20 null
source VARCHAR 50 null
userId INT 10 null
user.id Implied Constraint R
sourceId VARCHAR 50 null
recordId VARCHAR 50 null
shortId VARCHAR 50 √ NULL
itemId VARCHAR 50 √ NULL
itemIndex VARCHAR 50 √ NULL
renewalId VARCHAR 50 √ NULL
barcode VARCHAR 50 √ NULL
title VARCHAR 500 √ NULL
title2 VARCHAR 500 √ NULL
author VARCHAR 500 √ NULL
callNumber VARCHAR 100 √ NULL
volume VARCHAR 255 √ NULL
checkoutDate INT 10 √ NULL
dueDate BIGINT 19 √ NULL
renewCount INT 10 √ NULL
canRenew BOOLEAN 3 √ NULL
autoRenew BOOLEAN 3 √ NULL
autoRenewError VARCHAR 500 √ NULL
maxRenewals INT 10 √ NULL
fine FLOAT 12 √ NULL
returnClaim VARCHAR 500 √ NULL
holdQueueLength INT 10 √ NULL
renewalDate BIGINT 19 √ NULL
allowDownload BOOLEAN 3 √ NULL
overdriveRead BOOLEAN 3 √ NULL
overdriveReadUrl VARCHAR 255 √ NULL
overdriveListen BOOLEAN 3 √ NULL
overdriveListenUrl VARCHAR 255 √ NULL
overdriveVideo BOOLEAN 3 √ NULL
overdriveVideoUrl VARCHAR 255 √ NULL
formatSelected BOOLEAN 3 √ NULL
selectedFormatName VARCHAR 50 √ NULL
selectedFormatValue VARCHAR 25 √ NULL
canReturnEarly BOOLEAN 3 √ NULL
supplementalMaterials MEDIUMTEXT 16777215 √ NULL
formats MEDIUMTEXT 16777215 √ NULL
downloadUrl VARCHAR 255 √ NULL
accessOnlineUrl VARCHAR 255 √ NULL
transactionId VARCHAR 40 √ NULL
coverUrl VARCHAR 255 √ NULL
format VARCHAR 75 √ NULL
renewIndicator VARCHAR 20 √ NULL
groupedWorkId CHAR 40 √ NULL
overdriveMagazine BOOLEAN 3 √ NULL
isSupplemental BOOLEAN 3 √ 0
linkUrl VARCHAR 255 √ NULL
renewError VARCHAR 500 √ NULL

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
userId Performance Asc/Asc/Asc userId + source + recordId
userId_2 Performance Asc/Asc userId + groupedWorkId
userId_3 Performance Asc/Asc/Asc userId + source + recordId
userId_4 Performance Asc/Asc userId + groupedWorkId

Relationships