FACETDESC

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

Column Descriptions:

Name	Type	Description
FACET_ID	BIGINT NOT NULL	Foreign key to Facet table.
LANGUAGE_ID	INTEGER NOT NULL	Foreign key to Language table.
NAME	VARCHAR (256) NOT NULL	The language sensitive name for a non-attribute based facet.
DESCRIPTION	VARCHAR (256)	The language sensitive administrative description for a non-attribute based facet.
FIELD1	INTEGER	Customizable field.
FIELD2	VARCHAR (256)	Customizable field.
FIELD3	VARCHAR (256)	Customizable field.
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
P_0014	FACET_ID+LANGUAGE_ID	Primary Key
I0001482	LANGUAGE_ID	Non-Unique Index

Constrained By Parent Tables:

Constraint	Columns	Parent Table	Parent Columns	Type
F_3737	FACET_ID	FACET	FACET_ID	Cascade
F_3738	LANGUAGE_ID	LANGUAGE	LANGUAGE_ID	Cascade