Thread: Poor db design?
View Single Post
  #5 (permalink)  
Old July 31st, 2009, 12:08 AM
myerman myerman is offline
Wrox Author
Join Date: May 2008
Location: Austin, TX, USA.
Posts: 53
Thanks: 0
Thanked 5 Times in 5 Posts
Default database design

I can see where a main category table and subcategories might be useful, if you consider that you might want to have multiple paths to a subcategory. For example:

Top > Mens Clothing > Blazers
Top > Monthly Specials > Blazers

Although, something like that might be better handled with non-hierarchical tags or keywords....also, I don't think something like this with separate tables would scale very well.....your thoughts?
Thomas Myer
Author, Professional CodeIgniter