facet_response
- Sylvain Paillard
Each Facet Response represents ONE individual facet-type element suggested by CPO engine in response to a received request.
Field name | Type | Mode | Description |
|---|---|---|---|
request_id | STRING | REQUIRED | PK, Is a concatenation of a BUNDLE_ID and REQUEST_ORDER_NUM (a generated sequential number), source does not deliver IDs for individual requests. |
variant_id | STRING | REQUIRED | PK, variants represent different strategies available for handling the same request. They are available as ad hoc choices for client system. |
field_name | STRING | REQUIRED | PK |
request_ts | TIMESTAMP | REQUIRED | Is the timestamp of the original request bundle. It is repeated across tables to partition data by date for fast access. |
value_list | RECORD | REPEATED | Unflattened contents of facet.values from source. |
value_list. hitCount | INTEGER | NULLABLE |
|
value_list. rangeFromInclusive | STRING | NULLABLE |
|
value_list. rangeToExclusive | STRING | NULLABLE |
|
value_list. selected | BOOLEAN | NULLABLE |
|
value_list. stringValue | STRING | NULLABLE |
|
value_list. display | STRING | NULLABLE |
|
creation_tm | DATETIME | REQUIRED | technical field |
client_id | INTEGER | REQUIRED | technical field |
src_sys_id | INTEGER | REQUIRED | technical field |