SRCHATTRPROP

This table stores the properties that are defined for each search index attribute. For example, the properties are rank, sort, catalogFilter, display, facet, filter and search.

Column Descriptions:

NameTypeDescription
SRCHATTR_IDBIGINT NOT NULLForeign key to the SrchAttr table.
PROPERTYNAMEVARCHAR (254) NOT NULLThe name of the property. For example rank or sort.
PROPERTYVALUEVARCHAR (254)The value for the particular search attribute and property. For example, the search index name.
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
<SYSTEM-GENERATED>SRCHATTR_ID+PROPERTYNAMEPrimary Key
I0001475PROPERTYNAME+PROPERTYVALUENon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_3689SRCHATTR_IDSRCHATTRSRCHATTR_IDCascade