format_map_values

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 null
indexingProfileId INT 10 null
value VARCHAR 50 null
format VARCHAR 255 null
formatCategory VARCHAR 255 null
formatBoost TINYINT 3 null
suppress TINYINT 3 0
holdType enum('bib', 'item', 'either', 'none') 6 'bib'
inLibraryUseOnly TINYINT 3 0
pickupAt TINYINT 3 0
appliesToBibLevel TINYINT 3 1
appliesToItemShelvingLocation TINYINT 3 1
appliesToItemSublocation TINYINT 3 1
appliesToItemCollection TINYINT 3 1
appliesToItemType TINYINT 3 1
appliesToItemFormat TINYINT 3 1
appliesToMatType TINYINT 3 1
appliesToFallbackFormat TINYINT 3 1

Indexes

Constraint Name Type Sort Column(s)
format_map_values_s_pk Primary key Asc id
indexingProfileId Must be unique Asc/Asc indexingProfileId + value
PRIMARY Must be unique Asc id

Relationships