library_search_source

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 null
libraryId INT 10 -1
library.libraryId Implied Constraint R
label VARCHAR 50 null
weight INT 10 0
searchWhat enum('catalog', 'genealogy', 'overdrive', 'worldcat', 'prospector', 'goldrush', 'title_browse', 'author_browse', 'subject_browse', 'tags') 14 NULL
defaultFilter MEDIUMTEXT 16777215 NULL
defaultSort enum('relevance', 'popularity', 'newest_to_oldest', 'oldest_to_newest', 'author', 'title', 'user_rating') 16 NULL
catalogScoping enum('unscoped', 'library', 'location') 8 'unscoped'

Indexes

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

Relationships