> How do I allow for more workout types to be added and relate them to the > existing tables? > > I can imagine having tables for users, daily_stats, workouts, and routes, > but how would I integrate new workout types? I don't think adding fields to > a general workout table would be the most elegant solution. Maybe I'm wrong. > (It's happened before.) Create a workout_types table? table workout_types name varchar(64) ... Then just reference the workout_types.name in whatever other tables you reference a workout type? 3rd normal form. yum. _______________________________________________ TCLUG Mailing List - Minneapolis/St. Paul, Minnesota Help beta test TCLUG's potential new home: http://plone.mn-linux.org Got pictures for TCLUG? Beta test http://plone.mn-linux.org/gallery tclug-list at mn-linux.org https://mailman.real-time.com/mailman/listinfo/tclug-list