If TeeTime were just a NUMBER, you could just have a daily log. It wouldn't mean anything by itself, except linked fields to the other tables.

You're pretty close, it sounds like. Think about it. It's almost impossible to change something once it's in production...