Schema for the following attributes: column_name json_level data_type description
- id root uuid product variation identifier
- name root text product variation name
- description root text product description
- slug root text product url slug
- keywords root ARRAY product keywords
- product_id root uuid product aggregation identifier - one product_id will link multiple id (product variation identifiers)
- status root bigint product variation status
- package_dimension root jsonb product varitation product + package dimensions (height, width, length)
- package_dimensions.width.unit leaf bigint package_dimensions width unit standardizes measurement in type 1, 2 or 3
- package_dimensions.width.value leaf bigint package_dimensions width value states amount of units
- package_dimensions.height.unit leaf bigint package_dimensions height unit standardizes measurement in type 1, 2 or 3
- package_dimensions.height.value leaf bigint package_dimensions height value states amount of units
- package_dimensions.length.unit leaf bigint package_dimensions length unit standardizes measurement in type 1, 2 or 3
- package_dimensions.length.value leaf bigint package_dimensions length value states amount of units
- package_weight root jsonb product variation product + package weight
- package_weight.unit leaf bigint package_weight unit standardizes measurement in type 1, 2 or 3
- package_weight.value leaf bigint package_weight value states amount of units
- gtin root text global trade identifier number should uniquely identify a trade item
- category_id root uuid category identifier
internal_attributes root array internal_attributes provides internal settings for products that are not customer facing.
- internal_attributes.attribute_id leaf uuid internal attribute identifier
- internal_attributes.value leaf array internal attribute value is an array that can contain multiple keys found in characteristics
- internal_attributes.name leaf text internal attribute name provides a descriptive name to the attribute or characteristic
- characteristics root array characteristics will contain all characteristics that complement a product definition, such as flavour, size, colour, screen_size, etc.
- characteristics.attribute_id leaf uuid characteristics identifier
- characteristics.value leaf text characteristics value - can relate with internal_attributes value
- characteristics.name leaf text characteristics name provides a descriptive name to the attribute or characteristic