Specification

Latest Release: 09/18/2008 (Draft 20)

• 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 | PostgreSQL 8
• What's New (in Draft 20):
  • Renamed soccer_action_penalties.penalty_value to soccer_action_penalties.penalty_level
  • Fixed typo in ice_hockey_action_participants.ice_hockey_action_play_id field
  • Added indexes to useful fields (such as the event_states context and sequence_number fields)
  • Added new generic event state and event action tables:
    • event_states
    • event_action_fouls
    • event_action_plays
    • event_action_participants
    • event_action_penalties
  • Added new tennis tables and fields:
    • tennis_service_stats
    • tennis_return_stats
    • tennis_set_stats
    • tennis_team_stats
    • tennis_player_stats
  • Added events.event_number and events.round_number fields
  • Added new fields to ice_hockey_defensive_stats table: goaltender_wins, goaltender_losses, goaltender_ties
  • Added person_phases.duration field
  • Increased length of documents.revision_id and latest_revisions.revision_id fields
  • Other maintenance adjustments concerning Foreign Keys
• Patches for moving from SportsDB 19 to 20: MySQL 3 | SQL Server 2000 | PostgreSQL 8
• Transition SQL from SportsDB 19 to 20: 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"