Make a "week of table" and add that fkey to your schedule table. Now you preserve the date and time??? for the event as well as maintain the proper placement for this sport.
On Tue, May 7, 2013 at 2:33 PM, Gary Jeurink <[email protected]> wrote: > 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 > --- > [excessive quoting removed by server] _______________________________________________ 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/cajidmylfkjboshfq5j0c8q3rgw34_s_1xqms4uezrl1_oie...@mail.gmail.com ** 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.
