doc_user_selections

id

STRING

REQUIRED

the unique id of the user selection

type

STRING

REQUIRED

the type of user selection: 'basket', 'wishlist', 'compare', 'favorite', ...

creation

DATETIME

NULLABLE

the creation date time of the user selection

last_update

DATETIME

NULLABLE

the last update date time of the user selection

persona_type

STRING

NULLABLE

the persona type who created this user selection

persona_id

STRING

NULLABLE

the persona who created this user selection

products

RECORD

REPEATED

connections to products

products. type

STRING

NULLABLE

products. name

STRING

NULLABLE

products. product_line

STRING

NULLABLE

products. product_group

STRING

NULLABLE

products. sku

STRING

NULLABLE

products. value

NUMERIC

NULLABLE

products. creation

DATETIME

NULLABLE

products. last_update

DATETIME

NULLABLE

contents

RECORD

REPEATED

relations to other contents

contents. type

STRING

NULLABLE

contents. name

STRING

NULLABLE

contents. content_type

STRING

NULLABLE

contents. content_id

STRING

NULLABLE

contents. value

NUMERIC

NULLABLE

contents. creation

DATETIME

NULLABLE

contents. last_update

DATETIME

NULLABLE

customers

RECORD

REPEATED

relations to other customers

customers. type

STRING

NULLABLE

customers. name

STRING

NULLABLE

customers. persona_id

STRING

NULLABLE

customers. customer_id

STRING

NULLABLE

customers. value

NUMERIC

NULLABLE

customers. creation

DATETIME

NULLABLE

customers. last_update

DATETIME

NULLABLE

value

NUMERIC

REQUIRED

the ucg value (weighting) (e.g.: 0.0 - 5.0 for stars)

stores

STRING

REPEATED

the stores

title

RECORD

REPEATED

the title of the user selection

title. language_code

STRING

REQUIRED

title. value

STRING

REQUIRED

short_description

RECORD

REPEATED

the short description of the product group

short_description. language_code

STRING

REQUIRED

short_description. value

STRING

REQUIRED

description

RECORD

REPEATED

the description of the user selection

description. language_code

STRING

REQUIRED

description. value

STRING

REQUIRED

images

RECORD

REPEATED

the images of the user selection

images. name

STRING

REQUIRED

images. path

RECORD

REPEATED

images.path. language_code

STRING

REQUIRED

images.path. value

STRING

REQUIRED

link

RECORD

REPEATED

the link of the user selection

link. language_code

STRING

REQUIRED

link. value

STRING

REQUIRED

tags

RECORD

REPEATED

the tags of the product line, e.g.: [STRUCT('tag', 'hello world', [STRUCT('de', 'hello world')])]

tags. type

STRING

REQUIRED

tags. value

STRING

REQUIRED

tags. loc_values

RECORD

REPEATED

tags.loc_values. language_code

STRING

REQUIRED

tags.loc_values. value

STRING

REQUIRED

labels

RECORD

REPEATED

the labels of the user selection, e.g.: [STRUCT('symbol', 'helpful', 'very', [STRUCT('de', 'sehr hilfreich')])]

labels. type

STRING

REQUIRED

labels. name

STRING

REQUIRED

labels. value

STRING

REQUIRED

labels. loc_values

RECORD

REPEATED

labels.loc_values. language_code

STRING

REQUIRED

labels.loc_values. value

STRING

REQUIRED

status

BOOLEAN

NULLABLE

the ucg status

periods

RECORD

REPEATED

information about the activity periods of the user selection

periods. start_datetime

RECORD

REPEATED

periods.start_datetime. language_code

STRING

REQUIRED

periods.start_datetime. value

DATETIME

REQUIRED

periods. end_datetime

RECORD

REPEATED

periods.end_datetime. language_code

STRING

REQUIRED

periods.end_datetime. value

DATETIME

REQUIRED

string_attributes

RECORD

REPEATED

additional string (not localized) attributes of the user selection

string_attributes. type

STRING

NULLABLE

string_attributes. name

STRING

REQUIRED

string_attributes. values

STRING

REPEATED

localized_string_attributes

RECORD

REPEATED

additional localized string attributes of the user selection

localized_string_attributes. type

STRING

NULLABLE

localized_string_attributes. name

STRING

REQUIRED

localized_string_attributes. values

RECORD

REPEATED

localized_string_attributes.values. language_code

STRING

REQUIRED

localized_string_attributes.values. value

STRING

REQUIRED

numeric_attributes

RECORD

REPEATED

additional numeric (not localized) attributes of the user selection

numeric_attributes. type

STRING

NULLABLE

numeric_attributes. name

STRING

REQUIRED

numeric_attributes. values

NUMERIC

REPEATED

localized_numeric_attributes

RECORD

REPEATED

additional localized numeric attributes of the user selection

localized_numeric_attributes. type

STRING

NULLABLE

localized_numeric_attributes. name

STRING

REQUIRED

localized_numeric_attributes. values

RECORD

REPEATED

localized_numeric_attributes.values. language_code

STRING

REQUIRED

localized_numeric_attributes.values. value

NUMERIC

REQUIRED

datetime_attributes

RECORD

REPEATED

additional datetime (not localized) attributes of the user selection

datetime_attributes. type

STRING

NULLABLE

datetime_attributes. name

STRING

REQUIRED

datetime_attributes. values

DATETIME

REPEATED

localized_datetime_attributes

RECORD

REPEATED

additional localized datetime attributes of the user selection

localized_datetime_attributes. type

STRING

NULLABLE

localized_datetime_attributes. name

STRING

REQUIRED

localized_datetime_attributes. values

RECORD

REPEATED

localized_datetime_attributes.values. language_code

STRING

REQUIRED

localized_datetime_attributes.values. value

DATETIME

REQUIRED

creation_tm

DATETIME

REQUIRED

technical field

client_id

INTEGER

REQUIRED

technical field

src_sys_id

INTEGER

REQUIRED

technical field