Database/Table structure...HELP!

[PlaGuE]

Okay so for this script i have these ppl called trainers.

Now with each trainer they can make training routines.

These routines need to be able to be assigned to a trainee.

The values of the routines are trainee independant. Meaning that a trainee's progress should not affect other trainee's of the same routine.


If thats confusing...Well it is to me too.

Hopefully this example will help.


I am a trainer.
I have 1 routine which i use.

it consists of "Three" tasks.

Routine Name: StarCraft:: Terran Training

1. Can make 20 nukes in under 10 minutes.
2. Can expand to 3 bases in under 5 minutes.
3. Has 6 groups of dropships full of snipers and tank within 8 minutes.

Now i train three users.Trainee's.

Trainee#1
Routine Name: StarCraft:: Terran Training

1. Can make 20 nukes in under 10 minutes. :: Complete
2. Can expand to 3 bases in under 5 minutes. :: Complete
3. Has 6 groups of dropships full of snipers and tank within 8 minutes. :: Complete

Trainee#2
Routine Name: StarCraft:: Terran Training

1. Can make 20 nukes in under 10 minutes. :: Complete
2. Can expand to 3 bases in under 5 minutes. :: Incomplete
3. Has 6 groups of dropships full of snipers and tank within 8 minutes.:: Incomplete

Trainee#3
Routine Name: StarCraft:: Terran Training

1. Can make 20 nukes in under 10 minutes. :: InComplete
2. Can expand to 3 bases in under 5 minutes. :: InComplete
3. Has 6 groups of dropships full of snipers and tank within 8 minutes. :: InComplete

Now see my problem?...If its an easy solution then shoot me dead.Otherwise I think to hard.

What i need help on is the fact that i dont know how i am to go about the database's tables aswell as row insertion?

So far i have this as my table structure


Its just 1 row atm "Routines Main Header Column".Hence the parent_id (-1).
The value column is for the true or false. True = Complete. False = Incomplete.
Atm... Idk what i was thinking with the user_id (-1) which meant its the default structure.

I put it there right before i posted this topic.

ANymore info you need to help me figure out this... this.. thing. Dont hesitate ask.