DATA SCHEMA
A market model that stays connected to the evidence.
SpoonIndex links the brand, branch, menu, item, source identity, and dated snapshot so analysis can stay simple without losing what was actually observed.
Branch context preservedSource-awareTime is part of the record
CORE BUILDING BLOCKS
Six layers, each with a clear job.
This is the business-facing conceptual model — not private database tables or collection implementation.
Brand
The restaurant identity used to group branch presence across a market.
namesource identitystatus
Branch
A location-specific restaurant record tied to its source and geographic context.
citydistrictcoordinates
Menu
The branch-level menu structure that preserves where an item was observed.
categorybranchsnapshot
Menu item
An observed item with title, description, price, image, and source context.
priceimagetext
Source identity
The factual identifiers that keep a record traceable to where it was observed.
platformbrand idbranch id
Snapshot / observation
The dated evidence layer that distinguishes capture-time facts from later change.
captured atpublished athistory
WHY IT MATTERS
Simplify the analysis without erasing the evidence.
Similar items can be grouped for analysis while every branch-level observation stays behind the result.
Branch AChicken Burger24 SAR
Branch BChicken Burger26 SAR
Branch CChicken Burger25 SAR
↓
Analytical viewChicken Burger3 branch observations preserved