Schema
PayOSCommerce

MenuItem

Catalogue item linking ordered items to live menu. Allergen, dietary, Square POS integration.

12 fields4 relationships

Fields

NameTypeReqDescription
iduuidyesInternal item ID.
namestringyesDisplay name.
descriptionstringMenu description.
pricepenniesBase price in pennies.
caloriesnumberCalorie count.
is_alcoholbooleanContains alcohol.
square_catalog_item_idstringSquare catalogue item ID.
square_variation_idstringSquare variation ID — use for ordering.
skustringSKU.
allergensstringComma list: gluten,milk,nuts.
dietariesstringComma list: vegan,vegetarian.
activebooleanCurrently available.

Relationships

Outbound (3)
  • MenuItem[:AVAILABLE_AT]Venue
  • MenuItem[:FREQUENTLY_ORDERED_WITH]MenuItemco_occurrence_count, computed_at — AI computed, co_occurrence >= 3
  • MenuItem[:TRENDING]Venuetrend_direction (rising | falling | stable), growth_rate, current_period_orders, previous_period_orders, computed_at — AI computed 28-day comparison
Inbound (1)