Specification
Patch Release: 10/02/2011 (Draft 27) -- stats and event states table additions
Patch Release: 05/12/2010 (Draft 26) -- stats and event states table additions
Patch Release: 03/29/2010 (Draft 25) -- additions to american football event states, periods, participants_events tables plus addition of new sports_property table
Patch Release: 12/01/2009 (Draft 24) -- many additions to ice hockey and american football stats and events tables
Patch Release: 4/1/2009 (Draft 23) -- some minor touchups
Latest Release: 03/17/2009 (Drafts 21 + 22)
- Schematic Diagram of Tables (JPEG)
- Generated Documentation (rather sparse for now, but some fields filled in)
- HF (Happy Fish format)
- SQL: MySQL 3
| SQL Server 2000 (and SQL Server Index File)
| PostgreSQL 8
- What's New (in Draft 22, as well as the interim (not previously released) Draft 21):
- Added stat_membership_type and stat_membership_id fields to stats table
- Added indexes for stat_coverage_type and stat_coverage_id fields of stats table
- Added sportsml_blob field to document_contents table, for users who prefer to store entire SportsML source files, rather than just pathnames to the files
- Added fields to ice_hockey_action_plays table:
- penalty_type
- penalty_length
- penalty_code
- recipient_type
- team_id
- strength
- location_x
- location_y
- location_zone
- shootout_shot_order
- goal_order
- shot_type
- shot_distance
- goal_zone
- empty_net
- goal_awarded
- Added fields to ice_hockey_action_participants table:
- goals_to_date
- assists_to_date
- points_to_date
- New table called rankings, for NCAA polls, etc.
- New table called penalty_stats
- Added fields goals_allowed and shots_allowed to ice_hockey_defensive_stats
- Adjusted length of comment fields in wagering tables
- Added time_certainty field to events table
- Folded all fields from core_stats_player table into core_stats table
- Transition SQL from SportsDB 20 to 21:
MySQL 3
| SQL Server 2000
| PostgreSQL 8
- Transition SQL from SportsDB 21 to 22:
MySQL 3
| SQL Server 2000
| PostgreSQL 8
Previous Releases
Suggestions for Next Draft
- Remove baseball_action_substitutions.sequence_number field
Other Suggestions
- remove publishers.publisher_name and use display_names instead. Same with fixture display_name
- Sharpen all the field definitions and NULL/NOT NULL properties
- Improve baseball_action_contact_details table?
- Add a default_address_id field to locations table?
- Analyze the whole composite-games hierarchy (for Olympics-style competitions)
- Add to db_info table, to hold configuration values such as "Document Path Prefix"