1Events Primary Table

Event-level table: Contains event metadata and event type mappings.
Column NameDescriptionData Type
EVENT_IDUnique event identifier.BIGINT
EVENT_DATEDate event took place.DATE
EVENT_TYPE_IDIdentifier referencing event information from VALID_EVENT_TYPES.BIGINT
PROC_DTTime at which record was processed.TIMESTAMP

2Matches Primary Table

Match-level table: Contains match data, including players, results, and deck references for each match.
Column NameDescriptionData Type
MATCH_IDUnique match identifierBIGINT
P1Player 1 Username.VARCHAR(30)
P2Player 2 Username.VARCHAR(30)
P1_WINSNumber of game wins by Player 1.INT
P2_WINSNumber of game wins by Player 2.INT
MATCH_WINNERWinner of the match (P1 or P2).VARCHAR(2)
P1_DECK_IDIdentifier referencing Player 1's deck information from VALID_DECKS.BIGINT
P2_DECK_IDIdentifier referencing Player 2's deck information from VALID_DECKS.BIGINT
P1_NOTEAdditional Notes for Player 1.VARCHAR(100)
P2_NOTEAdditional Notes for Player 2.VARCHAR(100)
EVENT_IDIdentifier referencing event information from EVENTS.BIGINT
PROC_DTTime at which record was processed.TIMESTAMP

3Event Standings Primary Table

Standing table: Contains event standings and final ranks per player.
Column NameDescriptionData Type
EVENT_IDUnique event identifierBIGINT
P1Player 1 Username.VARCHAR(30)
BYESTotal byes received during event.INT
EVENT_RANKFinal standing/rank in the event.INT
PROC_DTTime at which record was processed.TIMESTAMP

4Valid Decks Secondary Table

Reference table: Contains valid deck metadata and deck identifiers.
Column NameDescriptionData Type
FORMATFormat of deck.VARCHAR(30)
ARCHETYPEArchetype of deck.VARCHAR(30)
SUBARCHETYPESub-archetype of the deck.VARCHAR(30)
DECK_IDUnique deck identifier.BIGINT
PROC_DTTime at which record was processed.TIMESTAMP

5Valid Event Types Secondary Table

Reference table: Contains valid event type metadata and identifiers.
Column NameDescriptionData Type
FORMATFormat played during event.VARCHAR(30)
EVENT_TYPEType of event (e.g., CHALLENGE).VARCHAR(30)
EVENT_TYPE_IDUnique event type identifier.BIGINT
PROC_DTTime at which record was processed.TIMESTAMP