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

{
  "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"
}

Raw Schema

{
  "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"
  }
}