Building the Database . . .
Today I finally began building the database for my TC.com activities. Several hours later, I am exhausted with plenty left to do.
I have improved my design over the database I have created for GC.com. Right now I am only concentrating on the scavenger hunts. I have not quite figured out the IDs assigned to the caches. IDs #1-100 glean just 24 caches. What are all those other ID numbers for? AK's X Marks the Spot was the first one. It is ID #7. Yet, Tread Grave is ID #2 and it was listed the day after X Marks the Spot. Why is that?
I have yet to determine whether or not ID #s are issued sequentially. I suspect they are, but why not with the numbered IDs? Probably a change at some point, but something I need to confirm.
Having a cache on the Watch List does not indicate when the cache is retired, I suspect. I will need to determine to handle that.
There is no number associated with the finds or caches yet in the database. I kind of like that! No running counts to work with. With the scavenger hunt, it shouldn't matter which order they were completed. As I haven't been recording the time (as I do with regualr caches), I think I am going to continue this way. It'll just be a collect them all approach, not how many?. That works well.
Once I get this thing in shape, I have to organize the photographs. I have them everywhere, named differently, etc. This needs to get done before things get unwieldy.
Also blogged on this date . . .
- Hobbit or Troll? - 2008
- The Ground Hog Was Right - 2007
- Batona Trial #3 - 2007
- Feminine - 2006
- One Hundred Years and Still Serving - 2005
- Where have you seen live baseball? - 2005
- Grateful Dead @ The Omni - 1992