FACETCATGRP

Stores the facet IDs related to a given catalog group.

Column Descriptions:

Name	Type	Description
FACETCATGRP_ID	BIGINT NOT NULL	The unique identifier for the table.
FACET_ID	BIGINT NOT NULL	Foreign key to Facet table.
SEQUENCE	DOUBLE	The sequence of the facet showing in the storefront.
STOREENT_ID	INTEGER NOT NULL	Foreign key to the Storeent table.
CATGROUP_ID	BIGINT NOT NULL	Foreign key to the Catgroup table.
DISPLAYABLE	SMALLINT NOT NULL DEFAULT 0	Describes whether the facet is displayable. Valid values are: 0 = Do not display in the storefront 1 = Display in the storefront
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_0013	FACETCATGRP_ID	Primary Key
I0001479	FACET_ID+CATGROUP_ID+STOREENT_ID	Unique Index
I0001480	STOREENT_ID	Non-Unique Index
I0001481	CATGROUP_ID	Non-Unique Index

Constrained By Parent Tables:

Constraint	Columns	Parent Table	Parent Columns	Type
F_3734	STOREENT_ID	STOREENT	STOREENT_ID	Cascade
F_3735	CATGROUP_ID	CATGROUP	CATGROUP_ID	Cascade
F_3736	FACET_ID	FACET	FACET_ID	Cascade