|
here's anothing thing i am noticing.
in the heirarchy table, there will be 1 parent id for each category id, .. so why does this need to be in a different table?
the only reason i can think of is if the category would have more than 1 parent, in which case the category id field could not be a primary field because there could be duplicates.
i'm just trying to figure this out so i don't waste time developing something i will later find a better way to design.
|