1 Matches Table Primary Table
| 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 | |
| P1_Subarch | Player 1 Deck Name | String | <Deck Name> |
| P2 | Player 2 Username | String | <Username> |
| P2_Arch | Player 2 Deck Archetype | String | |
| P2_Subarch | Player 2 Deck Name | String | <Deck Name> |
| P1_Roll | Player 1 Opening Die Roll | Integer | |
| P2_Roll | Player 2 Opening Die Roll | Integer | |
| Roll_Winner | Player who won the opening die roll | String | |
| P1_Wins | Player 1 games won during match | Integer | |
| P2_Wins | Player 2 games won during match | Integer | |
| Match_Winner | Player who won the match | String | |
| Format | Format being played | String | |
| 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 | |
| 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
| 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 | |
| PD_Selector | Player choosing whether to play/draw first | String | |
| PD_Choice | Play/Draw selection | String | |
| On_Play | Player who is on the play | String | |
| On_Draw | Player who is on the draw | String | |
| P1_Mulls | Player 1, number of mulligans | Integer | |
| P2_Mulls | Player 2, number of mulligans | Integer | |
| Game_Winner | Player who won the game | String | |
| Proc_Date | Date and time at which the game was processed | Datetime | YYYY-MM-DD HH:MM (24h) |
3 Plays Table Secondary Table
| Column Name | Description | Data Type | Format/Options |
|---|---|---|---|
| Match_ID | Match Identification Code | String | <Filename> |
| Game_Num | Sequential game number | Integer | |
| 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 | |
| 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 | |
| Self_Target | Binary indicator of spell/ability targeting Casting_Player | Binary | |
| 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
| 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 |
Set automatically after using Apply Associated Draft_IDs function
|
| Match_Losses | Player 2, games won during match | Integer |
Set automatically after using Apply Associated Draft_IDs function
|
| Draft_Format | Sets being drafted | String | |
| 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
| Column Name | Description | Data Type | Format/Options |
|---|---|---|---|
| Draft_ID | Draft Identification Code | String | YYYYMMDDHHMM-<Username>-<LimitedFormat>-<MTGODraftCode> |
| Pack_Num | Sequential pack number | Integer | |
| 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) |