E3-F4: Seat Search and Lookup¶
Epic: E3: Seat Inventory Management
Size: M (Medium)
Problem / Outcome¶
Admin finds seats by various criteria for support operations.
Scope¶
In-Scope:
- Search by seat number
- Search by reservation/quota
- Search by email
- Advanced multi-criteria search
Out-of-Scope:
- Full-text search
Acceptance Criteria¶
- AC1: Given seat number, when searched, then seat details returned with linked document
- AC2: Given quota number, when searched, then all seats in quota displayed
- AC3: Given email, when searched, then all tickets for that email returned
Data Model Impact¶
No new tables required.
Query optimization required:
- Index on Seat(sector_id, row_number, seat_number)
- Index on Ticket(holder_email)
- Index on QuotaSeat(quota_id)
Permissions/Roles¶
- Admin (Inventory Manager)
- Admin (Support Agent)
How to Verify¶
npm test -- --grep "seat search"
Expected: All search methods return correct results.
Dependencies¶
Implementation Tasks¶
Doc References¶
Last Updated: January 2026