...
Field name | Type | Mode | Description |
|---|---|---|---|
attribute_name | STRING | REQUIRED | the name of the attribute (should match the name of the attribute provided in the doc_product table in either string_attributes, numeric_attributes or localized_numeric_attributes |
numerical | BOOLEAN | NULLABLE | are the provided attribute value identifiers numerical? fyi - in this tables, the values are always provided as strings, but not in the doc_products and other tables |
value_id | STRING | REQUIRED | the value id to map to it's related value labels (always a string, but must be castable to numeric if numerical = true) |
value_label | REPEATED | the labels of the value id | |
parent_value_ids | STRING | REPEATED | the value ids of the parent (only for hierarchical attributes), (always a string, but must be castable to numeric if numerical = true) |
products | REPEATED | connections to products (normally not needed, as should be provided in the doc_product table | |
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')])] | |
pricing | NULLABLE | pricing information about the product line, e.g.: STRUCT('discount',[STRUCT('de','Bis:')],[STRUCT('de','-50:')],[STRUCT('de','%')]) | |
visibility | REPEATED | the product visibility :VISIBILITY_NOT_VISIBLE = 1; VISIBILITY_IN_CATALOG = 2; VISIBILITY_IN_SEARCH = 3; VISIBILITY_BOTH = 4; | |
status | REPEATED | the product status | |
periods | REPEATED | information about the activity periods of the attribute value | |
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 name of the attribute (should match the name of the attribute provided in the doc_product table in either string_attributes, numeric_attributes or localized_numeric_attributes",
"type": "STRING",
"name": "attribute_name",
"mode": "REQUIRED"
},
{
"type": "BOOLEAN",
"name": "numerical",
"description": "are the provided attribute value identifiers numerical? fyi - in this tables, the values are always provided as strings, but not in the doc_products and other tables"
},
{
"description": "the value id to map to it's related value labels (always a string, but must be castable to numeric if numerical = true)",
"type": "STRING",
"name": "value_id",
"mode": "REQUIRED"
},
{
"fields": [
{
"type": "STRING",
"name": "language",
"mode": "REQUIRED"
},
{
"type": "STRING",
"name": "value",
"mode": "REQUIRED"
}
],
"description": "the labels of the value id",
"type": "RECORD",
"name": "value_label",
"mode": "REPEATED"
},
{
"description": "the value ids of the parent (only for hierarchical attributes), (always a string, but must be castable to numeric if numerical = true)",
"type": "STRING",
"name": "parent_value_ids",
"mode": "REPEATED"
},
{
"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"
}
],
"description": "connections to products (normally not needed, as should be provided in the doc_product table",
"type": "RECORD",
"name": "products",
"mode": "REPEATED"
},
{
"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 attribute value",
"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 attribute value",
"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 attribute value",
"type": "RECORD",
"name": "description",
"mode": "REPEATED"
},
{
"fields": [
{
"type": "STRING",
"name": "name"
},
{
"fields": [
{
"type": "STRING",
"name": "value_id"
},
{
"fields": [
{
"type": "STRING",
"name": "language",
"mode": "REQUIRED"
},
{
"type": "STRING",
"name": "value",
"mode": "REQUIRED"
}
],
"type": "RECORD",
"name": "value",
"mode": "REPEATED"
}
],
"type": "RECORD",
"name": "values",
"mode": "REPEATED"
}
],
"description": "the images of the attribute value",
"type": "RECORD",
"name": "images",
"mode": "REPEATED"
},
{
"fields": [
{
"type": "STRING",
"name": "language"
},
{
"type": "STRING",
"name": "value",
"mode": "REQUIRED"
}
],
"description": "the link of the attribute value",
"type": "RECORD",
"name": "link",
"mode": "REPEATED"
},
{
"fields": [
{
"type": "STRING",
"name": "type"
},
{
"type": "STRING",
"name": "value"
},
{
"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 attribute value, e.g.: [STRUCT('tag', 'hello world', [STRUCT('de', 'hello world')])]",
"type": "RECORD",
"name": "tags",
"mode": "REPEATED"
},
{
"fields": [
{
"type": "STRING",
"name": "type"
},
{
"type": "STRING",
"name": "name",
"mode": "REQUIRED"
},
{
"type": "STRING",
"name": "value"
},
{
"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 attribute value, e.g.: [STRUCT('symbol', 'delivery', '24h', [STRUCT('de', '24-H Versand')])]",
"type": "RECORD",
"name": "labels",
"mode": "REPEATED"
},
{
"fields": [
{
"type": "STRING",
"name": "type"
},
{
"fields": [
{
"type": "STRING",
"name": "language",
"mode": "REQUIRED"
},
{
"type": "STRING",
"name": "label"
},
{
"type": "STRING",
"name": "value",
"mode": "REQUIRED"
},
{
"type": "STRING",
"name": "sign"
}
],
"type": "RECORD",
"name": "values",
"mode": "REPEATED"
}
],
"description": "pricing information about the attribute value, e.g.: STRUCT('de','discount','Bis:', '-50.-', 'CHF'",
"type": "RECORD",
"name": "pricing",
"mode": "REPEATED"
},
{
"fields": [
{
"type": "STRING",
"name": "customer_groups",
"mode": "REPEATED"
},
{
"fields": [
{
"type": "STRING",
"name": "language",
"mode": "REQUIRED"
},
{
"type": "INTEGER",
"name": "value",
"mode": "REQUIRED"
}
],
"type": "RECORD",
"name": "values",
"mode": "REPEATED"
}
],
"description": "the attribute value visibility :VISIBILITY_NOT_VISIBLE = 1; VISIBILITY_IN_CATALOG = 2; VISIBILITY_IN_SEARCH = 3; VISIBILITY_BOTH = 4;",
"type": "RECORD",
"name": "visibility",
"mode": "REPEATED"
},
{
"fields": [
{
"type": "STRING",
"name": "language",
"mode": "REQUIRED"
},
{
"type": "INTEGER",
"name": "value",
"mode": "REQUIRED"
}
],
"description": "the attribute value status",
"type": "RECORD",
"name": "status",
"mode": "REPEATED"
},
{
"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 attribute value",
"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 attribute value",
"type": "RECORD",
"name": "string_attributes",
"mode": "REPEATED"
},
{
"fields": [
{
"type": "STRING",
"name": "type"
},
{
"type": "STRING",
"name": "name",
"mode": "REQUIRED"
},
{
"fields": [
{
"type": "STRING",
"name": "value_id"
},
{
"fields": [
{
"type": "STRING",
"name": "language",
"mode": "REQUIRED"
},
{
"type": "STRING",
"name": "value",
"mode": "REQUIRED"
}
],
"type": "RECORD",
"name": "value",
"mode": "REPEATED"
}
],
"type": "RECORD",
"name": "values",
"mode": "REPEATED"
}
],
"description": "additional localized string attributes of the attribute value",
"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 attribute value",
"type": "RECORD",
"name": "numeric_attributes",
"mode": "REPEATED"
},
{
"fields": [
{
"type": "STRING",
"name": "type"
},
{
"type": "STRING",
"name": "name",
"mode": "REQUIRED"
},
{
"fields": [
{
"type": "STRING",
"name": "value_id"
},
{
"fields": [
{
"type": "STRING",
"name": "language",
"mode": "REQUIRED"
},
{
"type": "NUMERIC",
"name": "value",
"mode": "REQUIRED"
}
],
"type": "RECORD",
"name": "value",
"mode": "REPEATED"
}
],
"type": "RECORD",
"name": "values",
"mode": "REPEATED"
}
],
"description": "additional localized numeric attributes of the attribute value",
"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 attribute value",
"type": "RECORD",
"name": "datetime_attributes",
"mode": "REPEATED"
},
{
"fields": [
{
"type": "STRING",
"name": "type"
},
{
"type": "STRING",
"name": "name",
"mode": "REQUIRED"
},
{
"fields": [
{
"type": "STRING",
"name": "value_id"
},
{
"fields": [
{
"type": "STRING",
"name": "language",
"mode": "REQUIRED"
},
{
"type": "DATETIME",
"name": "value",
"mode": "REQUIRED"
}
],
"type": "RECORD",
"name": "value",
"mode": "REPEATED"
}
],
"type": "RECORD",
"name": "values",
"mode": "REPEATED"
}
],
"description": "additional localized datetime attributes of the attribute value",
"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_attribute_value.json
BigQuery DDL
https://github.com/boxalino/data-integration-doc-schema/blob/master/ddl/doc_attribute_value.sql