-
Notifications
You must be signed in to change notification settings - Fork 12
Data Dictionary
Chris Erickson edited this page Aug 15, 2024
·
1 revision
Column Descriptions
| Table | Column_Name | Description |
|---|---|---|
| Matches | Match_ID | Unique Match_ID |
| P1 | Player 1 Username | |
| P1_Arch | Player 1 Deck Archetype (eg. Aggro/Control/etc.) | |
| P1_Subarch | Player 1 Deckname | |
| P2 | Player 2 Username | |
| P2_Arch | Player 2 Deck Archetype (eg. Aggro/Control/etc.) | |
| P2_Subarch | Player 2 Deckname | |
| P1_Roll | Integer: Player 1 Die Roll | |
| P2_Roll | Integer: Player 2 Die Roll | |
| Roll_Winner | Die Roll Winner | |
| P1_Wins | Integer: Player 1 Game Wins | |
| P2_Wins | Integer: Player 2 Game Wins | |
| Match_Winner | Match Winner | |
| Format | Match Format Played | |
| Limited_Format | Limited Format Played ('NA' if Constructed Match) | |
| Match_Type | MTGO Match Type (eg. League/Challenge) | |
| Date | Date/Time at Start of Match: YYYY-MM-DD-HH-MM |
Column Descriptions
| Table | Column_Name | Description |
|---|---|---|
| Games | Match_ID | Unique Match_ID |
| P1 | Player 1 Username | |
| P2 | Player 2 Username | |
| Game_Num | Integer: 1, 2, 3 | |
| PD_Selector | Player with Choice of Play/Draw | |
| PD_Choice | Play/Draw Selection | |
| On_Play | On-The-Play Player | |
| On_Draw | On-The-Draw Player | |
| P1_Mulls | Integer: Mulligans by Player 1 | |
| P2_Mulls | Integer: Mulligans by Player 2 | |
| Turns | Integer: Total Turns in Game | |
| Game_Winner | Game Winner |
Column Descriptions
| Table | Column_Name | Description |
|---|---|---|
| Plays | Match_ID | Unique Match_ID |
| Game_Num | Integer: 1, 2, 3 | |
| Play_Num | Integer: Play Number | |
| Turn_Num | Integer: Turn Number | |
| Casting_Player | Player Committing Game Action | |
| Action | Game Action: 'Land Drop', 'Casts', 'Triggers', 'Activated Ability', 'Draws', 'Attacks' | |
| Primary_Card | Card Being Cast/Played/Triggered/etc. | |
| Target1 | Target Card #1 of Primary Card ('NA' if No Targeted Cards) | |
| Target2 | Target Card #2 of Primary Card ('NA' if <2 Targeted Cards) | |
| Target3 | Target Card #3 of Primary Card ('NA' if <3 Targeted Cards) | |
| Opp_Target | Bool (1 or 0): '1' if Current Play is Targetting Opponent | |
| Self_Target | Bool (1 or 0): '1' if Current Play is Self-Targetting | |
| Cards_Drawn | Integer: Total Cards Drawn (Current Action) | |
| Attackers | Integer: Total Attackers (Current Action) | |
| Active_Player | Active Player | |
| Nonactive_Player | Nonactive Player |
Column Descriptions
| Table | Column_Name | Description |
|---|---|---|
| Drafts | Draft_ID | Unique Draft_ID |
| Hero | Drafting Player Username | |
| Player_1-8 | Username | |
| Match_Wins | Integer: Hero Match Wins | |
| Match_Losses | Integer: Hero Match Losses | |
| Format | Draft Format Played | |
| Date | Date/Time at Start of Match: YYYY-MM-DD-HH-MM |
Column Descriptions
| Table | Column_Name | Description |
|---|---|---|
| Draft Picks | Draft_ID | Unique Draft_ID |
| Card | Selected/Drafted Card | |
| Pack_Num | Integer: Pack of the Current Draft | |
| Pick_Num | Integer: Pick of the Current Pack | |
| Pick_Ovr | Integer: Overall Pick of the Draft | |
| Avail_1-14 | Other Available Cards During Pick |