Hey guys!


My client wants me to build him a classified site that functions more or less the same as this one (but for different products):

http://www.snapbay.com.au/

Now, its been a while since I have been back-end since I have been specializing in JavaScript in recent times. So I was wondering if you DB pros could tell me if the following database design is sound enough in order to replicate that sites features. Please note that I have left out most of the fields from each table since I am only concerned about relationships at this stage:

databasediagram.jpg

I realize that site actually has a very basic Db design, but I just wanted to double check I have the right approach!


many thanks