Issues

• [Epic] Specialty shows in the flowsheet: program identity, who is on now, posters, the request line and catalog admin — wave 1

  ship-dag-wave
  WXYC/Backend-Service#3488 · Filter by author jakebromberg opened on Oct 18, 2026

• Lint: enforce braced if-statements with ESLint's curly rule in Backend-Service

  WXYC/Backend-Service#3486 · Filter by author jakebromberg opened on Oct 18, 2026

• POST /intake/{id}/release: take an optional expected_state and answer 409 state_changed when the record moved

  concern:contract-changeeffort:senhancement
  WXYC/Backend-Service#3480 · Filter by author jakebromberg opened on Oct 18, 2026

• Turn on FLOWSHEET_SPOTLIGHT_ENABLED in production once the DJ site and the Android app tolerate spotlight rows

  WXYC/Backend-Service#3479 · Filter by author jakebromberg opened on Oct 17, 2026

• Validate the flowsheet spotlight CHECK constraint in production, out of band, after its migration deploys

  WXYC/Backend-Service#3478 · Filter by author jakebromberg opened on Oct 17, 2026

• Create the station art bucket, its CloudFront distribution at art.wxyc.org, and the instance-role policy for specialty-show posters and logos

  WXYC/Backend-Service#3477 · Filter by author jakebromberg opened on Oct 17, 2026

• L56: Specialty-show logo upload, complete and delete on the poster store and render module (square only, PNG kept)

  WXYC/Backend-Service#3475 · Filter by author jakebromberg opened on Oct 17, 2026

• L55: Create, edit and retire specialty shows behind the programming permission, with the slug rule, slot validation and audit columns

  migration
  WXYC/Backend-Service#3474 · Filter by author jakebromberg opened on Oct 17, 2026

• L53: The specialty_shows: ['manage'] grant key for station managers, and capability grant and revoke events in the account audit

  WXYC/Backend-Service#3473 · Filter by author jakebromberg opened on Oct 17, 2026

• L47: Close a requests-mode request line while a band or reader is the current spotlight

  WXYC/Backend-Service#3472 · Filter by author jakebromberg opened on Oct 17, 2026

• L46: Request-line modes: shows.request_mode, specialty_shows.default_request_mode with four programs seeded to feedback, effectiveRequestMode, on_air.request_line

  migration
  WXYC/Backend-Service#3471 · Filter by author jakebromberg opened on Oct 17, 2026

• L60: Restore and purge specialty posters for music directors and station managers, and the status filter on the poster list

  WXYC/Backend-Service#3470 · Filter by author jakebromberg opened on Oct 17, 2026

• L38: Replace, rebind and soft-remove specialty posters: unbind, move renditions to held/, invalidate, record who and when

  WXYC/Backend-Service#3469 · Filter by author jakebromberg opened on Oct 17, 2026

• L37: poster on on_air, range shows[] and GET /flowsheet/playlist

  WXYC/Backend-Service#3468 · Filter by author jakebromberg opened on Oct 17, 2026

• L68: Bind a published poster to its specialty airing on tagging and on publish, fill an empty title, broadcast refetch

  WXYC/Backend-Service#3467 · Filter by author jakebromberg opened on Oct 17, 2026

• L36: POST /specialty-posters/{id}/complete: size check, read-back, validation, rendering and publishing

  WXYC/Backend-Service#3466 · Filter by author jakebromberg opened on Oct 17, 2026

• L35: Poster render module on sharp: validation, normalization, and 600 and 1200 px renditions at the poster's own aspect

  WXYC/Backend-Service#3465 · Filter by author jakebromberg opened on Oct 17, 2026

• L34: specialty_posters table with a watermark trigger; POST /specialty-posters with a presigned PUT and the airing-state check; the poster list

  migration
  WXYC/Backend-Service#3464 · Filter by author jakebromberg opened on Oct 17, 2026

• L67: The poster store on the instance-role signing core: its allowlist, held/ copies and CloudFront invalidation, refusing every call until configured

  WXYC/Backend-Service#3463 · Filter by author jakebromberg opened on Oct 17, 2026

• L33: Extract the instance-role S3 signing core (pinned credential provider and the TR-X-15 lifetime guard) into a shared module

  WXYC/Backend-Service#3462 · Filter by author jakebromberg opened on Oct 17, 2026

• L24: shows[] with specialty programs on the default GET /flowsheet branch

  WXYC/Backend-Service#3461 · Filter by author jakebromberg opened on Oct 17, 2026

• L17: Accept and validate spotlight entries on any show, compose their message, emit them in V2, and publish on_air.spotlight

  WXYC/Backend-Service#3460 · Filter by author jakebromberg opened on Oct 17, 2026

• L70: FLOWSHEET_SPOTLIGHT_ENABLED flag (off by default) with the 403 spotlight_disabled answer, and PATCH /flowsheet accepting spotlight fields

  WXYC/Backend-Service#3459 · Filter by author jakebromberg opened on Oct 17, 2026

• L16: Migrations: add the spotlight flowsheet entry type, then spotlight_role and spotlight_name with a NOT VALID CHECK

  migration
  WXYC/Backend-Service#3458 · Filter by author jakebromberg opened on Oct 17, 2026

• L8: Populate on_air.show_id, show_name and specialty on GET /flowsheet, and specialty and show_name in the Go Live 409

  WXYC/Backend-Service#3457 · Filter by author jakebromberg opened on Oct 17, 2026