Can I ask another question please.
Each online course (we will be selling a number of different courses) will require a table of its own to store Information such as Images taken by the student, Check boxes for modules completed and final exam taken etc along with the User ID.
So when a student purchases say the Spray Tanning course and they register during check out, how would I insert into the stcourse table the userID so when it comes to updating the stcourse table with images etc the student will be just updating the table with file uploads. I don't want the student to have access to the insert table.
I am thinking that as the Order and or Order detail table is updated so can the relevant course table with its own CourseID and UserID.
So for example if customer A purchased ProductID 1 (Spray Tanning) this would populate a Spraytanning ID and User ID in the Spray Tanning Table
If customer B purchased ProductID 2 Nail art this would populate the nails table with NailsID and UserID
And like wife if customer A then purchased ProductID 2 Nail Art this with then also populate the nails table with a different NailID but the same User ID.
My reasoning behind this is that all i want is for the customer to update these tables with file uploads.
I know it would be easier to add all the different upload fields to the User table but if we have 10 different courses the user table will be very large.
Any help on direction would be very much appreciated as I also hope that the above make's some kind of sense