ReviewsActivity
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 | no | positive | negative | neutral | mixed. |
| review_text | string | no | Full review text. |
| score_positive | number | no | NLP positive 0–1. |
| score_negative | number | no | NLP negative 0–1. |
| score_neutral | number | no | NLP neutral 0–1. |
| score_mixed | number | no | NLP mixed 0–1. |
| is_legible | boolean | no | False if gibberish/empty. |
| created_at | datetime | yes | Submitted at. Indexed. |
| replied_at | datetime | no | Venue replied at. |
| response_hours | number | no | Hours to respond. SLA tracking. |
| embedding | vector | no | Vector embedding for cosine similarity. |
| reply_status | enum | no | PENDING | APPROVED | SENT | REJECTED | EXPIRED. |
| reply_text | string | no | Reply (manual or AI). |
| reply_posted_at | datetime | no | Reply posted publicly. |
| reply_type | string | no | manual | ai_generated. |
| auto_generated | boolean | no | True if AI-generated without human edit. |
Relationships
Outbound (3)
Inbound (1)
- Customer[:REVIEWED]→Reviewcreated_at
Related entities
CustomerGraph AI Engine
The root guest identity node. Every interaction across bookings, Wi-Fi, orders, reviews, and loyalty is unified under a single Customer node per organisation.VenueGraph AI Engine
A physical location operated by an organisation. Every activity node — bookings, Wi-Fi sessions, orders, reviews — links back to a venue via the :AT_VENUE relationship.KeywordReviews
NLP topic keyword extracted from reviews. Surfaces themes, cross-correlates topics across reviews.ThreadBookings
CRM inbox conversation thread. Multi-channel comms linked to bookings, reviews, or enquiries.