format_map_values

155 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 BOOLEAN 3 √ 0
holdType enum('bib', 'item', 'either', 'none') 6 √ 'bib'
inLibraryUseOnly BOOLEAN 3 √ 0
pickupAt BOOLEAN 3 √ 0

Indexes

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

Relationships