request_context

Context of the request in terms of parameters (products, facets, selections...). As these are mostly the same for all requests we store all occurred combinations of parameters, their types and their values.

Field name

Type

Mode

Policy tags 

Description

Field name

Type

Mode

Policy tags 

Description

context_id

BYTES

REQUIRED

 

PK, SHA256 hash of the concatenated natural composite PK of (context_type, context_subtype, context_name, context_value).

context_type

STRING

REQUIRED

 

used to determine the meaning of the value in CONTEXT_VALUE field

context_subtype

STRING

REQUIRED

 

used to co-determine the meaning of the value in CONTEXT_VALUE field, dash-symbol means empty field

context_name

STRING

REQUIRED

 

 

context_value

STRING

REQUIRED

 

 

creation_tm

DATETIME

NULLABLE

 

technical field

client_id

INTEGER

NULLABLE

 

technical field

src_sys_id

INTEGER

REQUIRED

 

technical field