Just started learning MySQL, more specifically using Python and MySQLdb and everything is up and running fine.
I have an interface where i generate buttons:
1) Firstly the main catagories are generated.
2) on clicking these buttons, sub-catagories of these catagories have thier buttons generated.
3) once again on clicking these "sub-catagory" buttons, a last set of "item" buttons are created.
as far as i can see, here is my rough structure:
main catagory > holds many > sub catagories > holds many > items > has many > properties.
Here is my question.
I know i need a table for my main catagories, but do i need a new table for everyone of my sub catagories aswell, or do i simply bung them all into one table and retrieve them based on their parent catagory?
I need to use a database because catagories and sub catagories can be added or removed. I already have a working version of this mechanism using "folders", "sub-folders" and text documents representing the "items" containing thier properties, although this isnt at all secure which is why i am moving to a database solution.
Thanks for the help.