Skip to content

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

See E3: Seat Inventory Tasks

Doc References

Last Updated: January 2026