🔌 System Architecture

Data flow and infrastructure diagram

Data Flow

Users Players, Parents, Coaches Frontend Astro + React TailwindCSS Backend PocketBase SQLite DB APIs Collections teams players games signups Payments Stripe PayPal Print Printful API Custom Ink

📦 Database Collections

teams

Team info, stats, coach contact

namecolorwinslossesdrawsrunsForrunsAgainstcoachNamecoachPhonecoachEmail
players

Player roster, positions, stats

namenumberpositionteamIdbattingAvghomeRunsrbi
games

Schedule, scores, status

datehomeTeamawayTeamhomeScoreawayScorestatus

🛒 Commerce

signups

Registration forms, volunteer signups

nameemailphonetypemessagestatus
orders

Shop orders, tracking, Printful sync

customerNamecustomerEmailitemstotalstatusprintfulIdtrackingNumber

🔗 API Endpoints (PocketBase)

GET/api/collections/teams/records
POST/api/collections/teams/records
GET/api/collections/games/records
PATCH/api/collections/games/records/[id]
POST/api/collections/signups/records
POST/api/collections/orders/records