jef-caferimo-products
=====================

Source
------

- Repository: ``jef-systems/jef-caferimo-backend``
- Table: ``jef-caferimo-products``
- Schema path: ``dynamodb/jef-caferimo-products/schema.json``
- Commit: ``3dccda18d04172b054737f19e80b9cc4422d766a``
- Generated at: ``2026-04-24T19:57:33Z``

Attributes
----------

.. code-block:: json

   {
     "pk": "string-{entity_number}#{product_number}",
     "gsi_1_pk": "string-{entity_number}",
     "gsi_1_sk": "string-{product_name}",
     "gsi_2_pk": "string-{entity_number}#{recipe_number}",
     "gsi_2_sk": "string-{product_number}",
     "gsi_3_pk": "string-{entity_number}#{is_active}",
     "gsi_3_sk": "string-{category}#{display_order}#{product_name}",
     "entity_number": "string-4-digits-nonzerostart",
     "product_number": "string-4-digits",
     "product_name": "string",
     "recipe_number": "string-4-digits",
     "recipe_name": "string",
     "category": "string-enum-BEVERAGE|FOOD",
     "family": "string-enum-espresso|cold-brew|frappe|pastry",
     "base_price": "number-two-decimals",
     "size_mode": "string-enum-drink|std",
     "uses_milk": "boolean",
     "has_add_ons": "boolean",
     "default_size_label": "string-enum-Small|Medium|Large|STD",
     "default_milk_name": "string",
     "size_options": [
       {
         "label": "string-enum-Small|Medium|Large|STD",
         "upcharge": "number-two-decimals",
         "is_default": "boolean",
         "is_active": "boolean"
       }
     ],
     "milk_options": [
       {
         "name": "string",
         "price": "number-two-decimals",
         "is_default": "boolean",
         "is_active": "boolean"
       }
     ],
     "add_on_options": [
       {
         "id": "string",
         "name": "string",
         "price": "number-two-decimals",
         "is_active": "boolean"
       }
     ],
     "source_type": "string-enum-recipe_autogenerated|manual",
     "source_recipe_version": "number-whole-number",
     "last_generated_at": "string-iso8601",
     "display_order": "number-whole-number",
     "is_active": "boolean",
     "is_deleted": "boolean",
     "created_at": "string-iso8601",
     "updated_at": "string-iso8601",
     "version": "number-whole-number"
   }

Main Index
----------

.. code-block:: json

   {
     "pk": "pk"
   }

Raw Schema
----------

.. code-block:: json

   {
     "table": "jef-caferimo-products",
     "attributes": {
       "pk": "string-{entity_number}#{product_number}",
       "gsi_1_pk": "string-{entity_number}",
       "gsi_1_sk": "string-{product_name}",
       "gsi_2_pk": "string-{entity_number}#{recipe_number}",
       "gsi_2_sk": "string-{product_number}",
       "gsi_3_pk": "string-{entity_number}#{is_active}",
       "gsi_3_sk": "string-{category}#{display_order}#{product_name}",
       "entity_number": "string-4-digits-nonzerostart",
       "product_number": "string-4-digits",
       "product_name": "string",
       "recipe_number": "string-4-digits",
       "recipe_name": "string",
       "category": "string-enum-BEVERAGE|FOOD",
       "family": "string-enum-espresso|cold-brew|frappe|pastry",
       "base_price": "number-two-decimals",
       "size_mode": "string-enum-drink|std",
       "uses_milk": "boolean",
       "has_add_ons": "boolean",
       "default_size_label": "string-enum-Small|Medium|Large|STD",
       "default_milk_name": "string",
       "size_options": [
         {
           "label": "string-enum-Small|Medium|Large|STD",
           "upcharge": "number-two-decimals",
           "is_default": "boolean",
           "is_active": "boolean"
         }
       ],
       "milk_options": [
         {
           "name": "string",
           "price": "number-two-decimals",
           "is_default": "boolean",
           "is_active": "boolean"
         }
       ],
       "add_on_options": [
         {
           "id": "string",
           "name": "string",
           "price": "number-two-decimals",
           "is_active": "boolean"
         }
       ],
       "source_type": "string-enum-recipe_autogenerated|manual",
       "source_recipe_version": "number-whole-number",
       "last_generated_at": "string-iso8601",
       "display_order": "number-whole-number",
       "is_active": "boolean",
       "is_deleted": "boolean",
       "created_at": "string-iso8601",
       "updated_at": "string-iso8601",
       "version": "number-whole-number"
     },
     "main_index": {
       "pk": "pk"
     },
     "gsi_1": {
       "pk": "gsi_1_pk",
       "sk": "gsi_1_sk"
     },
     "gsi_2": {
       "pk": "gsi_2_pk",
       "sk": "gsi_2_sk"
     },
     "gsi_3": {
       "pk": "gsi_3_pk",
       "sk": "gsi_3_sk"
     }
   }