Customers can search for items using facets. These facets are defined based upon dimension values. Some of the facets allow the selection of multiple values of an individual facet, with the selections combined using Boolean or the OR statement.

Column Name

Type

Length

Null Allowed

Description

ID

integer

No

Identifier; primary key.

NAME

varchar

2000

No

The name of the item searched for by the customer.

FACET_NAMES

varchar

2000

No

The names of the facets used during the search.

HASH_VALUE

varchar

254

No

Used during data loading.

LENGTH

smallint

No

Size of the group segment.


Copyright © 1997, 2017 Oracle and/or its affiliates. All rights reserved. Legal Notices