...
Field name | Type | Mode | Description |
|---|---|---|---|
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 | REPEATED | connections to products | |
contents | REPEATED | relations to other contents | |
customers | REPEATED | relations to other customers | |
value | NUMERIC | NULLABLE | the ucg value (weighting) (e.g.: 0.0 - 5.0 for stars) |
stores | STRING | REPEATED | the stores |
title | REPEATED | the title of the attribute value | |
short_description | REPEATED | the short description of the product group | |
description | REPEATED | the description of the attribute value | |
images | REPEATED | the images of the attribute value | |
link | REPEATED | the link of the attribute value | |
tags | REPEATED | the tags , e.g.: [STRUCT('tag', 'hello world', [STRUCT('de', 'hello world')])] | |
labels | REPEATED | the labels of the product line, e.g.: [STRUCT('symbol', 'delivery', '24h', [STRUCT('de', '24-H Versand')])] | |
status | BOOLEAN | NULLABLE | the ucg status |
periods | REPEATED | information about the activity periods of the ugc | |
string_attributes | REPEATED | additional string (not localized) attributes of the product line | |
localized_string_attributes | REPEATED | additional localized string attributes | |
numeric_attributes | REPEATED | additional numeric (not localized) attributes | |
localized_numeric_attributes | REPEATED | additional localized numeric attributes | |
datetime_attributes | REPEATED | additional datetime (not localized) attributes | |
localized_datetime_attributes | REPEATED | additional localized datetime attributes | |
creation_tm | DATETIME | REQUIRED | technical field |
client_id | INTEGER | REQUIRED | technical field |
src_sys_id | INTEGER | REQUIRED | technical field |
Table structure
...
Resources
BigQuery JSON Schema
...
| Code Block | ||
|---|---|---|
| ||
[
{
"description": "the unique id of the user selection",
"type": "STRING",
"name": "id",
"mode": "REQUIRED"
},
{
"description": "the type of user selection: 'basket', 'wishlist', 'compare', 'favorite', ...",
"type": "STRING",
"name": "type",
"mode": "REQUIRED"
},
{
"type": "DATETIME",
"name": "creation",
"description": "the creation date time of the user selection"
},
{
"type": "DATETIME",
"name": "last_update",
"description": "the last update date time of the user selection"
},
{
"type": "STRING",
"name": "persona_type",
"description": "the persona type who created this user selection"
},
{
"type": "STRING",
"name": "persona_id",
"description": "the persona who created this user selection"
},
{
"fields": [
{
"type": "STRING",
"name": "type"
},
{
"type": "STRING",
"name": "name"
},
{
"type": "STRING",
"name": "product_line"
},
{
"type": "STRING",
"name": "product_group"
},
{
"type": "STRING",
"name": "sku"
},
{
"type": "NUMERIC",
"name": "value"
},
{
"type": "DATETIME",
"name": "creation"
},
{
"type": "DATETIME",
"name": "last_update"
}
],
"description": "connections to products",
"type": "RECORD",
"name": "products",
"mode": "REPEATED"
},
{
"fields": [
{
"type": "STRING",
"name": "type"
},
{
"type": "STRING",
"name": "name"
},
{
"type": "STRING",
"name": "content_type"
},
{
"type": "STRING",
"name": "content_id"
},
{
"type": "NUMERIC",
"name": "value"
},
{
"type": "DATETIME",
"name": "creation"
},
{
"type": "DATETIME",
"name": "last_update"
}
],
"description": "relations to other contents",
"type": "RECORD",
"name": "contents",
"mode": "REPEATED"
},
{
"fields": [
{
"type": "STRING",
"name": "type"
},
{
"type": "STRING",
"name": "name"
},
{
"type": "STRING",
"name": "persona_id"
},
{
"type": "STRING",
"name": "customer_id"
},
{
"type": "NUMERIC",
"name": "value"
},
{
"type": "DATETIME",
"name": "creation"
},
{
"type": "DATETIME",
"name": "last_update"
}
],
"description": "relations to other customers",
"type": "RECORD",
"name": "customers",
"mode": "REPEATED"
},
{
"description": "the ucg value (weighting) (e.g.: 0.0 - 5.0 for stars)",
"type": "NUMERIC",
"name": "value"
},
{
"description": "the stores",
"type": "STRING",
"name": "stores",
"mode": "REPEATED"
},
{
"fields": [
{
"type": "STRING",
"name": "language",
"mode": "REQUIRED"
},
{
"type": "STRING",
"name": "value",
"mode": "REQUIRED"
}
],
"description": "the title of the user selection",
"type": "RECORD",
"name": "title",
"mode": "REPEATED"
},
{
"fields": [
{
"type": "STRING",
"name": "language",
"mode": "REQUIRED"
},
{
"type": "STRING",
"name": "value",
"mode": "REQUIRED"
}
],
"description": "the short description of the product group",
"type": "RECORD",
"name": "short_description",
"mode": "REPEATED"
},
{
"fields": [
{
"type": "STRING",
"name": "language",
"mode": "REQUIRED"
},
{
"type": "STRING",
"name": "value",
"mode": "REQUIRED"
}
],
"description": "the description of the user selection",
"type": "RECORD",
"name": "description",
"mode": "REPEATED"
},
{
"fields": [
{
"type": "STRING",
"name": "name",
"mode": "REQUIRED"
},
{
"fields": [
{
"type": "STRING",
"name": "language",
"mode": "REQUIRED"
},
{
"type": "STRING",
"name": "value",
"mode": "REQUIRED"
}
],
"type": "RECORD",
"name": "value",
"mode": "REPEATED"
}
],
"description": "the images of the user selection",
"type": "RECORD",
"name": "images",
"mode": "REPEATED"
},
{
"fields": [
{
"type": "STRING",
"name": "language",
"mode": "REQUIRED"
},
{
"type": "STRING",
"name": "value",
"mode": "REQUIRED"
}
],
"description": "the link of the user selection",
"type": "RECORD",
"name": "link",
"mode": "REPEATED"
},
{
"fields": [
{
"type": "STRING",
"name": "type",
"mode": "REQUIRED"
},
{
"type": "STRING",
"name": "value",
"mode": "REQUIRED"
},
{
"fields": [
{
"type": "STRING",
"name": "language",
"mode": "REQUIRED"
},
{
"type": "STRING",
"name": "value",
"mode": "REQUIRED"
}
],
"type": "RECORD",
"name": "loc_values",
"mode": "REPEATED"
}
],
"description": "the tags of the product line, e.g.: [STRUCT('tag', 'hello world', [STRUCT('de', 'hello world')])]",
"type": "RECORD",
"name": "tags",
"mode": "REPEATED"
},
{
"fields": [
{
"type": "STRING",
"name": "type",
"mode": "REQUIRED"
},
{
"type": "STRING",
"name": "name",
"mode": "REQUIRED"
},
{
"type": "STRING",
"name": "value",
"mode": "REQUIRED"
},
{
"fields": [
{
"type": "STRING",
"name": "language",
"mode": "REQUIRED"
},
{
"type": "STRING",
"name": "value",
"mode": "REQUIRED"
}
],
"type": "RECORD",
"name": "loc_values",
"mode": "REPEATED"
}
],
"description": "the labels of the user selection, e.g.: [STRUCT('symbol', 'helpful', 'very', [STRUCT('de', 'sehr hilfreich')])]",
"type": "RECORD",
"name": "labels",
"mode": "REPEATED"
},
{
"type": "BOOLEAN",
"name": "status",
"description": "the ucg status"
},
{
"fields": [
{
"fields": [
{
"type": "STRING",
"name": "language",
"mode": "REQUIRED"
},
{
"type": "DATETIME",
"name": "value",
"mode": "REQUIRED"
}
],
"type": "RECORD",
"name": "start_datetime",
"mode": "REPEATED"
},
{
"fields": [
{
"type": "STRING",
"name": "language",
"mode": "REQUIRED"
},
{
"type": "DATETIME",
"name": "value",
"mode": "REQUIRED"
}
],
"type": "RECORD",
"name": "end_datetime",
"mode": "REPEATED"
}
],
"description": "information about the activity periods of the user selection",
"type": "RECORD",
"name": "periods",
"mode": "REPEATED"
},
{
"fields": [
{
"type": "STRING",
"name": "type"
},
{
"type": "STRING",
"name": "name",
"mode": "REQUIRED"
},
{
"type": "STRING",
"name": "values",
"mode": "REPEATED"
}
],
"description": "additional string (not localized) attributes of the user selection",
"type": "RECORD",
"name": "string_attributes",
"mode": "REPEATED"
},
{
"fields": [
{
"type": "STRING",
"name": "type"
},
{
"type": "STRING",
"name": "name",
"mode": "REQUIRED"
},
{
"fields": [
{
"type": "STRING",
"name": "language",
"mode": "REQUIRED"
},
{
"type": "STRING",
"name": "value",
"mode": "REQUIRED"
}
],
"type": "RECORD",
"name": "values",
"mode": "REPEATED"
}
],
"description": "additional localized string attributes of the user selection",
"type": "RECORD",
"name": "localized_string_attributes",
"mode": "REPEATED"
},
{
"fields": [
{
"type": "STRING",
"name": "type"
},
{
"type": "STRING",
"name": "name",
"mode": "REQUIRED"
},
{
"type": "NUMERIC",
"name": "values",
"mode": "REPEATED"
}
],
"description": "additional numeric (not localized) attributes of the user selection",
"type": "RECORD",
"name": "numeric_attributes",
"mode": "REPEATED"
},
{
"fields": [
{
"type": "STRING",
"name": "type"
},
{
"type": "STRING",
"name": "name",
"mode": "REQUIRED"
},
{
"fields": [
{
"type": "STRING",
"name": "language",
"mode": "REQUIRED"
},
{
"type": "NUMERIC",
"name": "value",
"mode": "REQUIRED"
}
],
"type": "RECORD",
"name": "values",
"mode": "REPEATED"
}
],
"description": "additional localized numeric attributes of the user selection",
"type": "RECORD",
"name": "localized_numeric_attributes",
"mode": "REPEATED"
},
{
"fields": [
{
"type": "STRING",
"name": "type"
},
{
"type": "STRING",
"name": "name",
"mode": "REQUIRED"
},
{
"type": "DATETIME",
"name": "values",
"mode": "REPEATED"
}
],
"description": "additional datetime (not localized) attributes of the user selection",
"type": "RECORD",
"name": "datetime_attributes",
"mode": "REPEATED"
},
{
"fields": [
{
"type": "STRING",
"name": "type"
},
{
"type": "STRING",
"name": "name",
"mode": "REQUIRED"
},
{
"fields": [
{
"type": "STRING",
"name": "language",
"mode": "REQUIRED"
},
{
"type": "DATETIME",
"name": "value",
"mode": "REQUIRED"
}
],
"type": "RECORD",
"name": "values",
"mode": "REPEATED"
}
],
"description": "additional localized datetime attributes of the user selection",
"type": "RECORD",
"name": "localized_datetime_attributes",
"mode": "REPEATED"
},
{
"description": "technical field",
"type": "DATETIME",
"name": "creation_tm",
"mode": "REQUIRED"
},
{
"description": "technical field",
"type": "INTEGER",
"name": "client_id",
"mode": "REQUIRED"
},
{
"description": "technical field",
"type": "INTEGER",
"name": "src_sys_id",
"mode": "REQUIRED"
}
] |
...
| title | BigQuery DDL |
|---|
...
| language | sql |
|---|
...
https://github.com/boxalino/data-integration-doc-schema/blob/master/doc/doc_user_selection.json
BigQuery DDL
https://github.com/boxalino/data-integration-doc-schema/blob/master/ddl/doc_user_selection.sql