FACET

Store facet configurations including attribute based and non-attribute based facets.

Column Descriptions:

NameTypeDescription
FACET_IDBIGINT NOT NULLThe unique identifier for this facet.
ATTR_IDBIGINTForeign key to the ATTR table. This will not be populated for facets that are not based on attribute dictionary attributes.
SRCHATTR_IDBIGINT NOT NULLForeign key to SrchAttr table.
SELECTIONSMALLINT NOT NULL DEFAULT 0Describes whether the facetable attribute will be allowed to have multiple selections. Valid values are: 0 = Not allowed to have multi-selection 1 = Allowed to have multi-selection
SORT_ORDERSMALLINT NOT NULL DEFAULT 0The display order to use when displaying the values for the facet. Valid values are: 0 = Sort by Count 1 = Sort alphabetically 2 = Sort by the attribute sequence as defined in the attribute dictionary (applies to attribute dictionary attributes only)
KEYWORD_SEARCHSMALLINT NOT NULL DEFAULT 1Describes whether the facet should be included in the keyword search. Valid values are: 0 = Not included in keyword search. 1 = Included in keyword search.
ZERO_DISPLAYSMALLINT NOT NULL DEFAULT 0Describes whether the facetable attribute should display zero count values. Valid values are: 0 = Do not return zero count values. 1 = Return zero count values.
STOREENT_IDINTEGER NOT NULLForeign key to the Storeent table.
MAX_DISPLAYINTEGER NOT NULL DEFAULT 20The maximum values to display in the storefront for the facet. This value is an integer, and -1 represents an infinite number of values are allowed to be returned.
SEQUENCEDOUBLE NOT NULL DEFAULT 0The sequence of the facet showing in the storefront.
FIELD1INTEGERCustomizable field.
FIELD2VARCHAR (256)Customizable field.
FIELD3VARCHAR (256)Customizable field.
GROUP_IDBIGINT DEFAULT 0The group id for the facet
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
P_0012FACET_IDPrimary Key
I0001476ATTR_IDNon-Unique Index
I0001477SRCHATTR_IDNon-Unique Index
I0001478STOREENT_ID+KEYWORD_SEARCHNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_3732ATTR_IDATTRATTR_IDCascade
F_3733SRCHATTR_IDSRCHATTRSRCHATTR_IDCascade

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_3736FACET_IDFACETCATGRPFACET_IDCascade
F_3737FACET_IDFACETDESCFACET_IDCascade