library_records_to_include

3 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 √ null
libraryId INT 10 null
library.libraryId Implied Constraint R
indexingProfileId INT 10 null
location VARCHAR 100 null
subLocation VARCHAR 150 ''
includeHoldableOnly TINYINT 3 1
includeItemsOnOrder BOOLEAN 3 0
includeEContent BOOLEAN 3 0
weight INT 10 0
iType VARCHAR 100 √ NULL
audience VARCHAR 100 √ NULL
format VARCHAR 100 √ NULL
marcTagToMatch VARCHAR 100 √ NULL
marcValueToMatch VARCHAR 100 √ NULL
includeExcludeMatches TINYINT 3 √ 1
urlToMatch VARCHAR 100 √ NULL
urlReplacement VARCHAR 255 √ NULL
locationsToExclude TEXT 65535 √ NULL
subLocationsToExclude VARCHAR 400 ''
markRecordsAsOwned TINYINT 3 √ 0
iTypesToExclude VARCHAR 100 ''
audiencesToExclude VARCHAR 100 ''
formatsToExclude VARCHAR 100 ''
shelfLocation VARCHAR 100 ''
shelfLocationsToExclude TEXT 65535 √ NULL
collectionCode VARCHAR 100 ''
collectionCodesToExclude VARCHAR 100 ''

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
indexingProfileId Performance Asc indexingProfileId
libraryId Performance Asc/Asc libraryId + indexingProfileId

Relationships