Mine

TABLE map_event_level (
  event_id varchar(100) NOT NULL default '',		DONE
  hi_level char(20) NOT NULL default '',			INDEX ME!
  hi_level_key char(255) NOT NULL default ''		DONE


TABLE map_event_result (
  event_id varchar(100) NOT NULL default '',		INDEX ME!
  hi_level char(20) NOT NULL default '',		INDEX ME!
  hi_level_key char(75) NOT NULL default '',		INDEX ME!
  alignment char(20) default NULL,
  event_outcome char(20) default NULL,
  score char(20) default NULL,
  rank char(20) default NULL

map_event_result_subscore (
  event_id varchar(100) NOT NULL default '',		INDEX ME!
  hi_level char(20) NOT NULL default '',		INDEX ME!
  hi_level_key char(75) NOT NULL default '',		INDEX ME!
  period_value smallint NOT NULL default '0',
  score char(20) NOT NULL default ''


TABLE map_revision_document (
  revision_id char(150) NOT NULL default '',		INDEX ME!
  doc_id char(75) NOT NULL default ''			DONE








--------


TABLE events (
  event_id varchar(100) NOT NULL default '',		INDEX ME! SHOULD BE PRIMARY KEY
  event_key varchar(100) NOT NULL default '',	DONE
  event_name varchar(75) NOT NULL default '',
  publisher_key varchar(30) NOT NULL default '',	DONE
  site_key varchar(50) default NULL,
  last_update datetime NOT NULL default '',			INDEX ME!
  start_date_time datetime default NULL,	DONE
  start_date_time_local datetime default NULL,
  site_alignment char(50) default NULL,
  event_status char(20) NOT NULL default 'unknown',
  season_type char(20) default NULL,	DONE
  season_key char(20) default NULL		DONE


TABLE map_stats_player (
  player_key varchar(255) NOT NULL default '',			INDEX ME!
  date_coverage_type varchar(255) NOT NULL default '',			INDEX ME!
  date_coverage_value varchar(255) NOT NULL default '',			INDEX ME!
  publisher_key varchar(50) NOT NULL default '',			DONE
  team_key varchar(100) default NULL,					INDEX ME!
  position varchar(255) default NULL,
  status varchar(255) default NULL,
  weight varchar(50) default NULL,
  stat_key varchar(255) NOT NULL default ''				INDEX ME!




TABLE map_stats_team (
  team_key varchar(100) NOT NULL default '',			INDEX ME!
  date_coverage_type varchar(255) NOT NULL default '',			INDEX ME!
  date_coverage_value varchar(255) NOT NULL default '',			INDEX ME!
  publisher_key varchar(50) NOT NULL default '',			DONE
  stat_key varchar(255) NOT NULL default ''				INDEX ME!


TABLE stats_baseball_defensive (
  stat_key varchar(255) NOT NULL default '',				INDEX ME!

TABLE stats_baseball_offensive (
  stat_key varchar(255) NOT NULL default '',				INDEX ME!

TABLE stats_baseball_pitching (
  stat_key varchar(255) NOT NULL default '',			INDEX ME!

TABLE refdyn_player (
  player_key varchar(75) NOT NULL default '',			INDEX ME!
  publisher_key varchar(50) NOT NULL default '',		DONE
  team_key varchar(255) default NULL,					INDEX ME!
  position varchar(255) default NULL,
  first_name varchar(255) default NULL,
  middle_name varchar(255) default NULL,