1 Matches Table Primary Table

Match-level table: Contains match details including players, decks, results, and metadata for each MTGO match.
Column Name Description Data Type Format/Options
Match_ID Match Identification Code String <Filename>
Draft_ID Draft Identification Code String YYYYMMDDHHMM-<Username>-<LimitedFormat>-<MTGODraftCode>
P1 Player 1 Username String <Username>
P1_Arch Player 1 Deck Archetype String
Aggro Midrange Control Combo Prison Tempo Ramp Rogue
P1_Subarch Player 1 Deck Name String <Deck Name>
P2 Player 2 Username String <Username>
P2_Arch Player 2 Deck Archetype String
Aggro Midrange Control Combo Prison Tempo Ramp Rogue
P2_Subarch Player 2 Deck Name String <Deck Name>
P1_Roll Player 1 Opening Die Roll Integer
1 2 3 4 5 6
P2_Roll Player 2 Opening Die Roll Integer
1 2 3 4 5 6
Roll_Winner Player who won the opening die roll String
P1 P2
P1_Wins Player 1 games won during match Integer
0 1 2
P2_Wins Player 2 games won during match Integer
0 1 2
Match_Winner Player who won the match String
NA P1 P2
Format Format being played String
NA Vintage Legacy Modern Standard Pioneer Pauper Other Constructed Booster Draft Sealed Deck Cube
Limited_Format Limited set/pool descriptor for limited formats String <Set or Limited Descriptor> (or NA)
Match_Type Event type in which match was played String
NA League Preliminary Challenge Premier Constructed 2-Man Practice Open Play BO1 Draft League Swiss Draft Elimination Draft Friendly Sealed League Competitive Sealed League Premier Sealed
Date Date and time at start of the match String YYYY-MM-DD HH:MM (24h)
Proc_Date Date and time at which the match was processed Datetime YYYY-MM-DD HH:MM (24h)

2 Games Table Secondary Table

Game-level data: Individual game details within each match, including play/draw decisions and game outcomes.
Column Name Description Data Type Format/Options
Match_ID Match Identification Code String <Filename>
P1 Player 1 Username String <Username>
P2 Player 2 Username String <Username>
Game_Num Sequential game number Integer
1 2 3
PD_Selector Player choosing whether to play/draw first String
P1 P2
PD_Choice Play/Draw selection String
Play Draw
On_Play Player who is on the play String
P1 P2
On_Draw Player who is on the draw String
P1 P2
P1_Mulls Player 1, number of mulligans Integer
0 1 2 3 4 5 6 7
P2_Mulls Player 2, number of mulligans Integer
0 1 2 3 4 5 6 7
Game_Winner Player who won the game String
NA P1 P2
Proc_Date Date and time at which the game was processed Datetime YYYY-MM-DD HH:MM (24h)

3 Plays Table Secondary Table

Play-by-play data: Individual card plays and actions within each game, providing detailed gameplay analysis.
Column Name Description Data Type Format/Options
Match_ID Match Identification Code String <Filename>
Game_Num Sequential game number Integer
1 2 3
Play_Num Sequential play number (of current game) Integer <1, 2, 3, 4, 5, ...>
Turn_Num Sequential turn number (of current game) Integer <1, 2, 3, 4, 5, ...>
Casting Player Username of player who took an action String <Username>
Action Game Action being taken String
Land Drop Casts Activated Ability Triggers Attacks Draws
Primary_Card Name of card being cast/played/etc. String <Card>, if applicable
Target_List List of cards being targeted by spell/ability JSON JSON array of <Card> objects
Opp_Target Binary indicator of spell/ability targeting opponent Binary
0 1
Self_Target Binary indicator of spell/ability targeting Casting_Player Binary
0 1
Cards_Drawn Total number of cards drawn (current action) Integer If applicable
Attacker_List List of cards being declared as attackers JSON JSON array of <Card> objects
Attackers Total number of attacking creatures (current action) Integer If applicable
Active_Player Player whose turn it is currently String <Username>
Non-Active Player Player whose turn it is not currently String <Username>
Proc_Date Date and time at which the play was processed Datetime YYYY-MM-DD HH:MM (24h)

4 Drafts Table Primary Table

Draft data: Information about draft sessions, including players, format, and results.
Column Name Description Data Type Format/Options
Draft_ID Draft Identification Code String YYYYMMDDHHMM-<Username>-<LimitedFormat>-<MTGODraftCode>
Hero Player whose draft perspective is being shown String <Username>
Player2 .. 8 Other drafters (7 other total players) String <Username>
Match_Wins Player 1, games won during match Integer
0 1 2
Set automatically after using Apply Associated Draft_IDs function
Match_Losses Player 2, games won during match Integer
0 1 2
Set automatically after using Apply Associated Draft_IDs function
Draft_Format Sets being drafted String
SETSETSET SET x6
Date Date and time at start of the draft DateTime YYYY-MM-DD HH:MM (24h)
Proc_Date Date and time at which the draft was processed Datetime YYYY-MM-DD HH:MM (24h)

5 Draft Picks Table Secondary Table

Draft pick data: Individual card picks during draft sessions, including pack and pick numbers and available cards.
Column Name Description Data Type Format/Options
Draft_ID Draft Identification Code String YYYYMMDDHHMM-<Username>-<LimitedFormat>-<MTGODraftCode>
Pack_Num Sequential pack number Integer
1 2 3
Pick_Num Sequential pick number Integer [1, 2, 3, .. 15]
Pick_Ovr Sequential pick number, overall Integer [1, 2, 3, .. 45]
Avail1 .. 14 Cards remaining in the pack String <Card>
Proc_Date Date and time at which the pick was processed Datetime YYYY-MM-DD HH:MM (24h)