Problems with 'schedules' table:
'-' dumped instead of blank for home and away scores (I have to store as a char and convert each time...)
schedule has no primary key (gameId is reused for each league...)
preseason and regular season games (and, playoff games) aren't flagged anywhere in the table, forcing me to manually input league/playoff start dates...
Last edited by Breich; 11-06-2015 at 03:33 PM.
|