website_facets

4 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 null
facetGroupId INT 10 null
displayName VARCHAR 50 null
displayNamePlural VARCHAR 50 NULL
facetName VARCHAR 50 null
weight INT 10 0
numEntriesToShowByDefault INT 10 5
sortMode enum('alphabetically', 'num_results') 14 'num_results'
collapseByDefault TINYINT 3 1
useMoreFacetPopup TINYINT 3 1
translate TINYINT 3 1
multiSelect TINYINT 3 1
canLock TINYINT 3 1

Indexes

Constraint Name Type Sort Column(s)
website_facets_s_pk Primary key Asc id
groupFacet Must be unique Asc/Asc facetGroupId + facetName
PRIMARY Must be unique Asc id

Relationships