I have a football game database that I manage by date. This required me to make a table of dates to pull up the matching football games. ESPN seems to group their games into a season_by_week and I like it.
Is it practical to just add a field to the game table like seasonWK (char-7) resulting in. '2013_05' and even 2013_PS' to lump the post season games together, and then the season and week of the game can be handled by 1 field or should season and week be separate fields and use a compound index to organize. In the same sense, I could eliminate the already existing field season. Gary Jeurink --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/FDC689F259374362AAED85232FBB3B11@OwnerPC ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
