Specification

Patch Release: 4/1/2009 (Draft 23) -- some minor touchups

• 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 23):
  • Added root_id field to affiliation_phases table
  • Added abstract_blob field to document_contents table
  • Adjusted sequence_number field in baseball_event_states, baseball_action_pitches, and baseball_action_substitutions to be DECIMAL(3,1) rather than INTEGER
• Transition SQL from SportsDB 22 to 23: MySQL 3 | SQL Server 2000 | PostgreSQL 8

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

• Specs and Documentation for 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"