Results 1 to 2 of 2
Thread: Database Design Help
Mar 24, 2010, 23:13 #1
- Join Date
- Jan 2010
- 0 Post(s)
- 0 Thread(s)
Database Design Help
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.....
Mar 25, 2010, 01:55 #2
You can add a parent_id column to your categories table.
Look here for more info: http://www.sitepoint.com/forums/show...94&postcount=3