Im having trouble finding the most efficient way put this database together which is designed to output a weight lifting workout from a database the desired output is a page with the users name, and lines that include(lift name, set,reps,weight(by percentage); sets, reps, weight) example
snatch (2x3[200lbs]) || (3x2[210lbs]) || (1x1[220lbs])
benchpress (3x5[300lbs]) || (2x2[320lbs])
ignore formating its just: lift (set x rep[calculated weight]) ||......
and each set has an id and multiplier which is how many sets per (set)
heres a rough and incomplete design I have drawn up but it seems like too much space would be taken by the sets/reps/percentage
would it be ok to just put set/rep/percentage in one field??