SRCHATTRPROP

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

Column Descriptions:

Name	Type	Description
SRCHATTR_ID	BIGINT NOT NULL	Foreign key to the SrchAttr table.
PROPERTYNAME	VARCHAR (254) NOT NULL	The name of the property. For example rank or sort.
PROPERTYVALUE	VARCHAR (254)	The value for the particular search attribute and property. For example, the search index name.
OPTCOUNTER	SMALLINT NOT NULL DEFAULT 0	The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

Name	Column Names	Type
<SYSTEM-GENERATED>	SRCHATTR_ID+PROPERTYNAME	Primary Key
I0001475	PROPERTYNAME+PROPERTYVALUE	Non-Unique Index

Constrained By Parent Tables:

Constraint	Columns	Parent Table	Parent Columns	Type
F_3689	SRCHATTR_ID	SRCHATTR	SRCHATTR_ID	Cascade