PurpleFox · Action Log Exporter

Data sources

SUPABASE PurpleFox backend — fetched on each sync, requires JWT

CARDE carde.io tournament engine — fetched via admin API token, no login needed

DERIVED Computed locally — never stored as-is in the source system

round_timers one row per round per tournament — primary timing record

Column	Type	Source	Description
tournament_id	TEXT PK	SUPABASE	UUID identifying the tournament
round	INTEGER PK	CARDE	Round number (1-based)
carde_round_id	INTEGER	CARDE	Internal carde.io round identifier — used for pairings API calls
started_at	TEXT	CARDE	ISO datetime when the round timer was started by the TO
timer_end_datetime	TEXT	DERIVED	Scheduled end time — started_at + timer_duration_minutes + any round-level extensions
completed_at	TEXT	CARDE	ISO datetime when the round was marked COMPLETE (all results in — later than time-called)
timer_duration_minutes	INTEGER	CARDE	Base round duration in minutes as configured by the TO
extra_time_seconds	INTEGER	CARDE	Round-level extra time added beyond the base duration (if carde provides it)
carde_status	TEXT	CARDE	UPCOMING / IN_PROGRESS / COMPLETE
incomplete_at_end	INTEGER	CARDE	Number of matches with no result at the moment the round clock hit zero. Written once, never updated.
missing_tables_json	TEXT	CARDE	JSON int array of table numbers missing results at time-called. Populated from a fresh pairing fetch queued the moment the clock expires. Written once.

round_pairings one row per (round, table) — match-level pairings and results

Column	Type	Source	Description
tournament_id	TEXT PK	SUPABASE	Tournament UUID
round	INTEGER PK	CARDE	Round number
table_number	INTEGER PK	CARDE	Physical table number
match_id	INTEGER	CARDE	carde.io match identifier
p1_name / p2_name	TEXT	CARDE	Player display names from carde user_identifier
p1_user_id / p2_user_id	TEXT	CARDE	carde.io internal user IDs
status	TEXT	CARDE	Match status (e.g. COMPLETE)
time_extension_sec	INTEGER	CARDE	Per-table time extension in seconds granted by a judge
winner_user_id	TEXT	CARDE	carde user ID of the winner. Empty = result not yet submitted.

drops player drop events — from PurpleFox tournament_drops table

Column	Type	Source	Description
tournament_id	TEXT PK	SUPABASE	Tournament UUID (mapped from tournamentId)
player_game_id	TEXT PK	SUPABASE	PurpleFox player game ID (playerGameId)
round	INTEGER PK	SUPABASE	Round the drop was recorded in
table_number	INTEGER	SUPABASE	Table where the player was seated when they dropped
player_name	TEXT	SUPABASE	Player display name
is_checked	INTEGER	SUPABASE	1 = drop verified by a second judge
is_cancelled	INTEGER	SUPABASE	1 = drop was recorded in error and cancelled
added_by_name	TEXT	DERIVED	Judge who first recorded the drop — inferred from updated_by_name while is_checked=0. Write-once.
verified_by_name	TEXT	DERIVED	Judge who verified the drop — inferred from updated_by_name when is_checked flips to 1. Write-once.

time_logs judge action log entries — from PurpleFox tournament_logs table

Column	Type	Source	Description
id	INTEGER PK	SUPABASE	Monotonically increasing log entry ID
tournament_id	TEXT	SUPABASE	Tournament UUID
round	INTEGER	SUPABASE	Round number when the action occurred
table_number	INTEGER	SUPABASE	Table the judge acted on
action	TEXT	SUPABASE	Free-text action description, e.g. "Change time from 5min to 10min"
user_id	TEXT	SUPABASE	UUID of the judge who performed the action — resolved to display name via the users cache
created_at	TEXT	SUPABASE	ISO timestamp of the action

penalties infraction records — from PurpleFox tournament_penalities table

Column	Type	Source	Description
id	TEXT PK	SUPABASE	UUID of the penalty record
tournament_id	TEXT	SUPABASE	Tournament UUID
round	INTEGER	SUPABASE	Round the infraction occurred in
player_name	TEXT	SUPABASE	Name of the penalized player
description	TEXT	SUPABASE	Free-text infraction description
type	TEXT	SUPABASE	Infraction category, e.g. "Slow Play", "Late to Match"
sanction	TEXT	SUPABASE	Penalty level (Warning, Game Loss, etc.)
creator_id / creator_name	TEXT	SUPABASE	Judge who issued the penalty. creator_name is also used to seed the users name cache.

table_coverage judge seating — from PurpleFox tables.coveredBy field

Column	Type	Source	Description
tournament_id / table_number / covered_by	TEXT PK	SUPABASE	Composite PK — one row per (table, judge) pair ever seen
covered_by	TEXT	SUPABASE	Judge UUID — resolved to display name via users cache at read time
first_seen_at	TEXT	DERIVED	Timestamp of the sync run that first observed this (table, judge) assignment
round	INTEGER	DERIVED	Round inferred from the highest round seen in logs/drops at the time of the sync

table_judge_results judge-entered match results — from PurpleFox tables.judgeResult field

Column	Type	Source	Description
tournament_id / table_number / judge_result	TEXT PK	SUPABASE	Composite PK — one row per (table, result string) ever seen
judge	TEXT	DERIVED	Cross-referenced from table_status.updated_status_by at sync time, resolved via users cache
first_seen_at / round	TEXT / INTEGER	DERIVED	Sync timestamp and inferred round, same logic as table_coverage

table_time_updates per-table status change events — from PurpleFox table_status table

Column	Type	Source	Description
tournament_id / table_number / updated_at	PK	SUPABASE	Composite PK — unique status change event per table per timestamp
status	TEXT	SUPABASE	Table status label at this point in time
time_minutes	INTEGER	SUPABASE	Extension granted in minutes (PurpleFox time field)
updated_by	TEXT	SUPABASE	UUID of the judge who updated the table status

users judge name cache — resolves UUIDs to display names

Column	Type	Source	Description
user_id	TEXT PK	DERIVED	Supabase/PurpleFox user UUID
display_name	TEXT	DERIVED	Human-readable name. Seeded from: drops.updated_by_name, penalties.creator_name, JWT metadata (current user), and any global drops across all tournaments.

tournament_meta per-tournament settings and lifecycle state

Column	Type	Source	Description
tournament_id	TEXT PK	SUPABASE	Tournament UUID
last_table	INTEGER	SUPABASE	Highest table number — total active tables
default_time	INTEGER	SUPABASE	Default round duration in seconds as configured in PurpleFox
name	TEXT	SUPABASE	Tournament display name
is_ended	INTEGER	DERIVED	1 = event manually ended via the UI (stops auto-refresh, shows "ended" label)

API endpoints (serve.py)

Endpoint	Method	Auth	Description
/api/login	POST	none	Authenticate — returns Bearer token stored in localStorage
/api/logout	GET	Bearer	Invalidate current session token
/api/me	GET	Bearer	Return current username and is_admin flag
/api/sync?tournamentId=	GET	Bearer + JWT	Fetch all Supabase + carde data, upsert SQLite, return full dataset
/api/logs?tournamentId=	GET	Bearer	Read accumulated SQLite data without hitting any external API
/api/backfill[?tournamentId=]	GET	Bearer	Re-fetch carde round data for all (or one) tournament(s) and fill missing timing fields
/api/tournaments	GET	Bearer	List configured tournaments with their ended status
/api/end-tournament?tournamentId=	GET	Bearer	Mark tournament as ended — stops auto-refresh
/api/set-token	POST	Bearer	Store a PurpleFox Supabase JWT in server memory
/api/token-status	GET	Bearer	Check stored PF JWT validity and expiry
/proxy?url=	GET	Bearer + JWT	Authenticated proxy to PurpleFox Supabase (restricted to upbcarvmkmyzhbosheyo.supabase.co)

carde.io API reference admin only

Base URL: https://api.admin.carde.io
Auth header: Authorization: Token {CARDE_API_TOKEN} — token stored as constant in serve.py
All responses are JSON. No pagination except the matches-list endpoint.

Known tournament mappings

Tournament	Supabase UUID	carde event_id	First round_id
Atlanta RQ	4ac50cb1-f6ad-4507-94a1-6aee88b2cb7e	502327	721202 (base 721201)
Regional Rebound	17ed5ad8-0c94-41f9-bb22-2ec85453eeb2	513852	727669 (base 727668)

GET /api/magic-events/{event_id}/get_all_rounds/

Returns all rounds for a tournament, grouped by phase. Called on every sync and backfill.

Response: array of phase objects

Field path	Type	Description
[].rounds	array	Array of round objects for this phase (swiss phase, top-8 phase, etc.)
[].rounds[].id	integer	carde round ID — used as path param in matches-list calls
[].rounds[].round_number	integer	1-based round number within the tournament
[].rounds[].status	string	UPCOMING · SCHEDULED · ACTIVE · COMPLETE
[].rounds[].started_at	string\|null	ISO 8601 datetime when the TO started the round clock
[].rounds[].completed_at	string\|null	ISO 8601 datetime when all results were entered (later than time-called)
[].rounds[].timer_duration_minutes	integer\|null	Base round duration in minutes. Null for top-8 bracket rounds.
[].rounds[].extra_time_seconds	integer\|null	Round-level extra time in seconds added on top of base duration. Also seen as additional_time_seconds.
[].rounds[].timer_end_datetime	string\|null	Precomputed scheduled end time from carde. If absent, derived as started_at + duration + extra.

GET /api/magic-events/{event_id}/tournament_overview/

Live tournament state snapshot. Called on every sync (alongside get_all_rounds).

Field	Type	Description
lifecycle_status	string	Overall tournament lifecycle (e.g. ACTIVE, COMPLETED)
timer_is_running	boolean	Whether the round clock is currently counting down
timer_end_datetime	string\|null	ISO 8601 scheduled end of the current running timer
timer_paused_at_datetime	string\|null	Set when the timer is paused mid-round
number_of_incomplete_matches	integer	Matches still pending a result at the moment of this call. Used as the "missing at time called" snapshot.
current_round.round_number	integer	Active round number
current_round.status	string	Status of the active round

GET /api/v2/organize/tournament-rounds/{round_id}/matches-list/

Query params: round_id={id}&page_size=25[&page={n}]

Paginated list of all matches in a round. Called in a background thread when a round is new or transitions to COMPLETE. Pagination: loop while response.next is truthy, passing it as the next page= value.

Response: { results: [], next: number|null }

Field path	Type	Description
results[].id	integer	carde match ID
results[].table_number	integer	Physical table number. Rows with table_number ≤ 0 are skipped.
results[].match_is_bye	boolean	Bye matches are skipped entirely.
results[].status	string	Match result status
results[].time_extension_seconds	integer	Per-table time extension in seconds (from judge actions)
results[].winning_player_id	integer\|null	carde user ID of the winner. Null if result not yet entered.
results[].player_match_relationships[]	array	Exactly two entries per match (player_order 1 and 2)
.player_order	integer	1 = seat 1, 2 = seat 2
.user_event_status.user_identifier	string	Player display name / gamertag
.user_event_status.user.id	integer	carde user ID — used to resolve winning_player_id
next	integer\|null	Next page number for pagination. Null on last page.

Backfill round timing

Re-fetches carde.io round data for both tournaments and fills in any missing timer_end_datetime, started_at, and extra_time_seconds values. No token required.

Ready

Quick reference

This tool gives tournament staff a live, searchable view of all PurpleFox event data — drops, time extensions, penalties, judge activity, and round timing — pulled from PurpleFox and carde.io and stored locally so nothing is lost between sessions.

Signing in

Enter your username and password at the sign-in prompt. Sessions last 7 days — you stay logged in across page reloads. Click Logout in the top-right to end your session manually.

Users

admin full access — all tabs including Data and admin sections

hj standard access — all tabs except Data

Tabs — available to all users

Logs

Main feed of all recorded events grouped by round — drops, time extensions, judge seats, table results, penalties. Most recent round first.

Fetch logs — pull fresh data from PurpleFox (requires a token in Session tab). Cached data loads automatically on page open without a token.
Auto-refresh — keep fetching on a timer. 30 sec is good during a live event; turn off for ended events.
Round filter — narrow feed to one round.
Search — filter by player name, table number, judge, or any text.
Type filters — show/hide drops, extensions, penalties independently.
Export CSV / JSON — export the current filtered view.

Insights

Round-by-round breakdown: timer (start → time-called → completed), how many tables had extensions, outstanding tables at time-called, drops, and penalty types. Click any round header to expand.

Infractions

Penalty-focused view across the entire event. Flags players with multiple penalties, shows a breakdown by type (Slow Play, Late to Match, etc.), and lists every penalty with player, round, type, sanction, and issuing judge.

Session

Paste your PurpleFox JWT token here to enable live syncing. Without a token the app shows cached data only.

How to get your token: open PurpleFox in a browser → F12 → Application → Local Storage → find the value starting with eyJ → copy and paste it here. Tokens expire after about an hour.

Debug

Query the PurpleFox Supabase database directly. Requires a token. Useful for exploring what data is available or diagnosing sync issues. Not needed during normal event operation.

Schema

Documents every local database table, its columns, and where the data comes from. Also lists all server API endpoints and a backfill button to re-pull round timing from carde.io.

Tips

During a live event Set auto-refresh to 30 sec. Switch to the Session tab first and paste your PF token to get live data rather than just the cache.

After the event Click End event in the header to stop auto-refresh and mark it done. All data stays in the database.

New entries look highlighted Each fetch marks entries that weren't there last time. Click Clear seen hashes to reset this — useful at the start of a new day.

Round timing gaps If Insights shows "—" for round start/end times, go to Schema → Backfill and run it. Timing comes from carde.io separately from PurpleFox.