FACETDESC

Stores language sensitive name and description information for non-attribute based facets.

Column Descriptions:

NameTypeDescription
FACET_IDBIGINT NOT NULLForeign key to Facet table.
LANGUAGE_IDINTEGER NOT NULLForeign key to Language table.
NAMEVARCHAR (256) NOT NULLThe language sensitive name for a non-attribute based facet.
DESCRIPTIONVARCHAR (256)The language sensitive administrative description for a non-attribute based facet.
FIELD1INTEGERCustomizable field.
FIELD2VARCHAR (256)Customizable field.
FIELD3VARCHAR (256)Customizable field.
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_0014FACET_ID+LANGUAGE_IDPrimary Key
I0001482LANGUAGE_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_3737FACET_IDFACETFACET_IDCascade
F_3738LANGUAGE_IDLANGUAGELANGUAGE_IDCascade