Neep some comments on my schema...

From: tconley79 <knuckles19_at_earthlink-dot-net.no-spam.invalid>
Date: Fri, 04 Nov 2005 02:10:00 -0600
Message-ID: <vuKdnToHTNnFivbeRVn_vQ@giganews.com>

Ok I have this form data that needs to be stored in a database structure. It's basically a form that logs several people's workout session on a regular basis...so every form is one workout log for one person.

It's got hairy once I learn that a workout session can be broken down into so many little parts. i.e....

-A session is comprised of phases (warm up, core, cool down)
-A phase is comprised of exercises(bar bell press, lunge,
whatever..and these exercises are innummerable)
-An exercise works one or more muscles and is comprised of sets(one or
more)
-And a set is comprised of two values, intensity and repetitions.

*whew*

Now here's my prelim structure:

SESSION

---

ID
client_ID
date

PHASE

---

ID
name

EXERCISE

---

ID
name
description

MUSCLE_GROUP

---

ID
name

EXERCISE_WORKS

---

exercise_ID
muscle_group_ID

WORKSET

---

ID
intensity
reps

SESSION_INFO

---

session_ID
phase_ID
exercise_ID
exercise_order_in_phase
worsket_ID
workset_order_in_exercise
notes

So with this structure each row of the session_info table would describe one set of one exercise of one phase of a session. Is there a better way?? Received on Fri Nov 04 2005 - 02:10:00 CST