long time @ SP ....a warm hello then...lol
All I'm tryin to design a yellow page directory...
but got some problem with database design. I have two type of audiences....
1) Online Traffic (User Searching our yellow pages LIVE)
2) Business to be registered
What i feel there must be these tables
1) Business (Will contain all the information about business, and other identifiers)
2) City (Which contain list of cities + states + countries)
4) User Reviews
5) User Registration Table
6) Business Rating Table
All looks great to me, but just one.....3).
Categories, how to deal with this, when sub-categories come to existence....
thanks for your help in advance.....
You can add a parent_id column to your categories table.
Look here for more info: http://www.sitepoint.com/forums/showpost.php?p=4174394&postcount=3