Schema

Review

Guest review from Google or Stampede. Includes NLP sentiment scores, reply-state machine, and vector embedding for semantic clustering.

19 fields4 relationships

Fields

Name	Type	Req	Description
id	uuid	yes	Review UUID.
platform	enum	yes	google \| stampede.
rating	number	yes	1–5 stars.
sentiment	enum	—	positive \| negative \| neutral \| mixed.
review_text	string	—	Full review text.
score_positive	number	—	NLP positive 0–1.
score_negative	number	—	NLP negative 0–1.
score_neutral	number	—	NLP neutral 0–1.
score_mixed	number	—	NLP mixed 0–1.
is_legible	boolean	—	False if gibberish/empty.
created_at	datetime	yes	Submitted at. Indexed.
replied_at	datetime	—	Venue replied at.
response_hours	number	—	Hours to respond. SLA tracking.
embedding	vector	—	Vector embedding for cosine similarity.
reply_status	enum	—	PENDING \| APPROVED \| SENT \| REJECTED \| EXPIRED.
reply_text	string	—	Reply (manual or AI).
reply_posted_at	datetime	—	Reply posted publicly.
reply_type	string	—	manual \| ai_generated.
auto_generated	boolean	—	True if AI-generated without human edit.

Outbound (3)

Inbound (1)