Child subjects: rate dishes, waiters, and other nested items #8

New issue

Open

opened 2026-06-06 01:24:56 +02:00 by myrmidex · 0 comments

myrmidex commented

2026-06-06 01:24:56 +02:00

Owner

Support rating things within a subject — e.g. a specific dish, a waiter, or a wine at a restaurant. Modeled via a self-referential parent_id on Subject (already discussed). Children inherit their parent's location (their own lat/lng is nullable, resolving up the tree). Includes a "root requires location" validation rule so only top-level subjects need coordinates.

Scope: Add nullable lat/lng migration with the root-requires-location validation, add parent_id FK to Subject, expose children in GET /api/subjects/{id}, and build the "+ review dish / + review waiter" flow in the pin panel. Does not include rating criteria.

Size: large

Support rating things within a subject — e.g. a specific dish, a waiter, or a wine at a restaurant. Modeled via a self-referential `parent_id` on Subject (already discussed). Children inherit their parent's location (their own lat/lng is nullable, resolving up the tree). Includes a "root requires location" validation rule so only top-level subjects need coordinates. **Scope:** Add nullable lat/lng migration with the root-requires-location validation, add `parent_id` FK to Subject, expose children in `GET /api/subjects/{id}`, and build the "+ review dish / + review waiter" flow in the pin panel. Does not include rating criteria. **Size: large**