user_hold

0 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
title VARCHAR 500 √ NULL
title2 VARCHAR 500 √ NULL
author VARCHAR 500 √ NULL
volume VARCHAR 255 √ NULL
callNumber VARCHAR 100 √ NULL
available TINYINT 3 √ NULL
cancelable TINYINT 3 √ NULL
cancelId VARCHAR 50 √ NULL
locationUpdateable TINYINT 3 √ NULL
pickupLocationId VARCHAR 50 √ NULL
pickupLocationName VARCHAR 100 √ NULL
status VARCHAR 50 √ NULL
position INT 10 √ NULL
holdQueueLength INT 10 √ NULL
createDate INT 10 √ NULL
availableDate INT 10 √ NULL
expirationDate INT 10 √ NULL
automaticCancellationDate INT 10 √ NULL
frozen TINYINT 3 √ NULL
canFreeze TINYINT 3 √ NULL
reactivateDate INT 10 √ NULL
groupedWorkId CHAR 40 √ NULL
format VARCHAR 150 √ NULL
coverUrl VARCHAR 255 √ NULL
linkUrl VARCHAR 255 √ NULL
isIll TINYINT 3 √ 0
pendingCancellation TINYINT 3 √ 0
cancellationUrl VARCHAR 255 √ NULL

Indexes

Constraint Name Type Sort Column(s)
user_hold_s_pk Primary key Asc id
PRIMARY Must be unique Asc id
userId Performance Asc/Asc/Asc userId + source + recordId
userId_2 Performance Asc/Asc userId + groupedWorkId

Relationships

Close relationships within degrees of separation