Validation: Seed practice_schedules table (#279)

validation-279-2026-04-03 Doc

validation pass

Validation: basketball-api#279

Verdict: PASS

Checks

  • Row count: SELECT count(*) FROM practice_schedules = 17 ✓
  • No NULLs: All start_time and end_time populated ✓
  • Monday (day 0): 2 rows — 16U Local Kings + 17U Local Kings @ BWill 19:00-21:00 ✓
  • Tuesday (day 1): 6 rows — all 7 teams across 3 courts @ West High 18:00-20:00 ✓
  • Thursday (day 3): 3 rows — Elite/Select Kings @ LCA 17:00-20:00 (optional) ✓
  • Friday (day 4): 3 rows — 16U Local Kings + both Queens @ BWill 19:00-21:00 ✓
  • Sunday (day 6): 3 rows — 16U Elite + 17U Elite + 17U Select Kings @ Kongo 14:00-16:00 ✓
  • Labels: All 17 rows have non-null labels (e.g. "16U Local Kings Mon Practice") ✓
  • Tenant: All rows tenant_id=1 ✓
  • Division: boys/girls correctly assigned per team ✓

Method

Direct SQL query via kubectl exec -n basketball-api postgres-9b5b87b5-5nccx -- psql. Full 17-row output verified against westside-practice-schedule pal-e-docs note.

Source

Board item #739, Forgejo issue forgejo_admin/basketball-api#279.