SRCH_COMPCONFIG

Reserved for HCL internal use. This stores the component configuration for a particular commerce instance

Column Descriptions:

NameTypeDescription
SRCH_COMPCONFIG_IDBIGINT NOT NULLPrimary key
TENANT_IDBIGINT NOT NULL DEFAULT 0The ID of the tenant in the multi-tenant environment
COMP_IDVARCHAR (128) NOT NULLThe component ID of the configuration
NAMEVARCHAR (128) NOT NULLThe name of the configuration
CONTENTCLOB (1048576)The configuration detail in XML format
LASTUPDATETIMESTAMPThe last update time stamp
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_0043SRCH_COMPCONFIG_IDPrimary Key
I0001539TENANT_ID+COMP_ID+NAMEUnique Index