One record, one connected table.
The trainer is a write-capable seat, permissioned by design: the same athlete record powers their app, their coaches, their parents, and recruiters — each reading only what they’re permitted to see. Your trainer seat writes status, injuries, and plan assignments; every write leaves a receipt.