HomeBlogInfinite Depth

Infinite Depth

Published February 18, 2004
A client wanted to have his products broken down into sub categories. Instead of creating Tables for each layer (i.e. a sub category table) I created a single table with a parent id field which points to the id of the parent category (which is the primary key on this same table). With this architecture they can have as many sub categories as they would like (sub sub categories).
blog comments powered by Disqus


Joseph Cohn has been helping companies across many industries find high tech web and mobile solutions to the wide variety of challenges facing them. He has a Bachelors of Science degree in Computer Science from Touro College in NYC and currently resides in the remote hills of Rockland County with his precious family.

This article is under Web Programming

There is 1 comment for this post

Connect With Us

Send Us a Message

Do you wish to give us feedback on one of our apps, send us a message or explore a proposal? Fill out the form below and we'll get back to you pronto!

Visit Us

250 West Nyack Road, Suite #200 West Nyack, NY 10994
Get Directions

Call Us Toll Free