Product Catalogue

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

Data and Resources

Additional Info

Field Value
Last Updated November 5, 2020, 13:10 (UTC)
Created November 3, 2020, 11:34 (UTC)