improvement(db): added missing indexes for common access patterns (#2… #7295

Job	Run time
Test and Build / Test and Build	4m 34s
Detect Version	3s
Check Docs Changes	0s
Build AMD64 (./docker/db.Dockerfile, ghcr.io/simstudioai/migrations, ECR_MIGRATIONS)	2m 5s
Build AMD64 (./docker/realtime.Dockerfile, ghcr.io/simstudioai/realtime, ECR_REALTIME)	2m 33s
Build AMD64 (./docker/app.Dockerfile, ghcr.io/simstudioai/simstudio, ECR_APP)	4m 44s
Build ARM64 (GHCR Only)	-1s
Process Docs	0s
Create GHCR Manifests	-1s
	13m 57s

Provide feedback