library_records_to_include

0 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 TINYINT 3 0
includeEContent TINYINT 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 VARCHAR 100 ''
collectionCode VARCHAR 100 ''
collectionCodesToExclude VARCHAR 100 ''

Indexes

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

Relationships