completeness · column grain
6-table backbone, every schema
but not perfectly uniform
Schema Explorer
Drill a sport's schema down to individual columns. Every backbone table carries the same guaranteedcolumns in all four verticals — that's the product floor. A short list of conditional columns live in only some sports; those are exactly the columns a cross-sport query trips over.
LegendGuaranteed — in COMMON_COLUMNS for every sportConditional — present in some sports onlyidentity / key column
Schema
Tables in asd_smx
Backbone · 6
Sport-specific · 3
asd_smx.resultsbackbone
Guaranteed columns
7
present in all four schemasresult_idevent_idcompetition_idcompetitor_iddivisionfinish_positionstatus
Conditional columns
2
present in some sports onlyresults.points / results.score
in SMX · WSL · MASL
present in SMX
results.region / competitions.region
in SMX · WSL
present in SMX
Pulled with AWS_PROFILE=asd against Redshift Serverless (us-west-1 / default-workgroup / dev).