ARCHITECTURE OVERVIEW
Bible Quizzing — System & Data Flow
A live walkthrough of how the platform routes scoring, brackets, committee assignments, and TV rendering across its three tiers. Click a scenario to animate the request path.
TV render (multi-room)
Live scoring
Bracket setup
Committee edit (Path B)
Auth & session
CLIENTS
📺 Public TV
/public/multiroom.html
🏆 Rankings
/public/rankings.html
📋 Committee Ref.
/public/committee.html
⌨️ Scorekeeper
/scorekeeper/
🪜 Brackets
/admin/brackets.html
👥 Committee
/admin/committee.html
API · PHP
🎯 quizzes
answer · start · complete
🔁 rooms · rounds
brackets backbone
🧑🤝🧑 teams · users
rosters · profiles
DATABASE · MariaDB
👤 users
scorekeeper_profiles
🚪 rooms · rounds
date-scoped
📝 quizzes · quiz_teams
3-team matches
⚡ quiz_answers
per-question events
📊 team_standings
quizzer_quiz_stats
🧑⚖️ quiz_room_staff★ new (Path B)
🏫 teams · schools
churches · participants
📺 TV render — Multi-room live view
generated for bq.bsoj.org · MariaDB 11.4 · PHP 8 · Vue 3 · Bootstrap 5 RTL